How to convert data from MYOB to QuickBooks - Step 3 - Lists

Zed Partner Suggestion: During my work with Axis Importer I figured if you coded the COA Expense accounts first, the bills and cheques will come across with a Tax Code and Tax Amount. You need to add in a Tax Code & Amount column in excel prior to importing Bills and Cheques. Final step is to search the transaction listing for those transactions which differ from the default tax Code assigned to the COA and edit the transaction to reflect the actual tax code and amount because if Telephone Expenses is coded NCG - all transactions would come across with NCG and 10% GST.

Sales & Income transactions

Expense transactions

Once you have set up the Expense and Cost of Goods Accounts with a default tax code then the Zed Axis Importer will default to that Tax Code and removes the need to import the tax code with the transaction line.  However transactions that do not follow the default need to be noted and manually adjusted once the transaction has been imported.

Customer List

MYOB and QuickBooks differ in the way they handle jobs.  MYOB jobs are kept in a separate list, whilst QuickBooks has a parent:child type structure.  For example;

Jones (Parent)

            Jones: Audit (Parent:child)

            Jones: Tax prep

You will need to do some modification in Excel if you want to retain the transaction to the particular Job and not pooled to the customer.