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

Phase One: MYOB card files into QuickBooks lists
To start you may need to make some changes in MYOB before you export the lists as there is there are differences in the rules surrounding MYOB and QuickBooks lists.  Correcting these before you export your data from MYOB will save you a lot of time later in the process.  These include:
 
Duplicate Names - QuickBooks will not allow duplicate names on any lists, but MYOB does, for example a supplier called Smith J and a customer called Smith J will not import into QuickBooks, the name must have some slight difference from the existing name, such as an initial or different capitalization, punctuation, or spacing.  Use the search and replace to identify

Unsupported characters – Any MYOB lists which contain the following characters will not or may create errors when importing into QuickBooks
 

  • Comma ( , )
  • Apostrophe ( ‘ )
  • Colons ( : )
  • Names which are too long

 
List size restrictions – QuickBooks has a limit to the number of items in its lists, at the time of writing this note it was 14,000 for version up to Premier and 28,000 for Enterprise.
 
Once you have tidy up these you can start exporting the MYOB card files.
 
Export your accounts list from MYOB

  1. Open MYOB select File > Export data > Accounts.  
  2. You will need to make the following modifications for the new equivalent in QuickBooks
  3. Open the exported file in Microsoft Excel and update the Account Types to the QuickBooks Account Type equivalents as shown in the table below, using the search and replace feature.
  4. Change currency format to number format

 

MYOB

 

QuickBooks

Asset

 

 

Asset

>

Fixed Asset

Bank

 

Bank

Other Asset

 

Other Asset

Account Receivable

>

Accounts Receivable

Liabilities

 

 

Liability

>

Long Term Liability

Other Liability

>

Other Current Liability

Accounts Payable

 

Accounts Payable

Equity

 

 

Equity

 

Equity

Income

 

 

Income

 

Income

Cost of Sales

 

 

Cost of Sales

>

Cost of Goods Sold

Expense

 

 

Expense

 

Expense

Other Income

 

 

Other Income

 

Other Income

Other Expense

 

 

Other Expense

 

Other Expense

 


Possible to recognise Credit Card accounts and classify those
 
Import the Account list into QuickBooks
  1. Create a new company file in QuickBooks with no chart of accounts.
  2. Open QuickBooks Select File > Import > Excel files and map the following fields
 
For a full interpretation of Import Errors when importing Excel lists into QuickBooks: Intuit have a good support note here:
http://www.quickbooks.com/support/faqs/qbw2004/premier/319404.html  

 

MYOB

QuickBooks

Account Number

Number

Account Name

Name

Balance

<<Unmatched>>

Account Type

Type

Tax Code

Tax Code

Inactive Account

Is Inactive

B/Account Number

Bank Acct. No

Description

Description

 

Complete the above process for the following lists from MYOB into QuickBooks
 

  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
 

 

Add Feedback