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

Tax Code List

The mapping of the Tax Code lists is really down to your own preference and is something that requires careful consideration there are many differences to the codes used by MYOB to the codes used by QuickBooks.  Retaining the MYOB tax coding makes the transfer easier but can often lead to confusion later.  For that reason we recommend that you follow the default QuickBooks tax coding.  If in doubt please refer to professional advice.

 

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

 

MYOB	QuickBooks
GST	GST
FRE	FRE

 

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.

 

1. Overview
2. Transfer MYOB card file details to QuickBooks.
3. Transfer tax codes and customer lists to QuickBooks
4. Transfer supplier lists and employee lists to QuickBooks
5. Create opening balances in QuickBooks
6. Create opening inventory balances in QuickBooks
7. Export accounts payable and account receivable transactions from MYOB into text files
8. Import accounts payable transactions into QuickBooks
9. Import accounts receivable transactions into QuickBooks
10. Validate data transfer
11. Setup and configure QuickBooks

 

 

QuickBooks	MYOB
Job or Customer Name	Co./Last Name
Opening Balance
Opening Balance as Of
Company Name	Co./Last Name
Salutation	Salutation
First Name	First Name
Middle Initial
Last Name
Contact	Contact name
Phone	Phone #1
Fax	Fax
Alternate Phone	Phone #2
Alternate Contact
Email	Email
Billing Address 1	Addr 1 – Line 1
Billing Address 2	Addr 1 City
Billing Address 3	Addr 1 State
Billing Address 4	Addr 1 Post Code
Billing Address 5	Addr 1 Country
Shipping Address 1	Addr 2 Line 1
Shipping Address 2	Addr 2 City
Shipping Address 3	Addr 2 State
Shipping Address 4	Addr 2 Post Code
Shipping Address 5	Addr 2 Country
Customer Type
Terms
Sales Rep	Salesperson
Tax Code	Tax Code
Business Number	ABN
Price Level	Price Level
Account Number	Card ID
Credit Limit	Credit Limit
Preferred Payment Method	Payment Method
Credit Card No.	Card Number
Credit Card Expiration Month	Expiry Date
Credit Card Expiration Year	Expiry Date
Name on card
Credit card Address
Credit card post code
Job Status
Job Start Date
Job Projected Date

Article ID: 38, Created On: 10/21/2011, Modified: 10/21/2011