How to convert transaction data from MYOB to QuickBooks

Convert transaction history from MYOB to QuickBooks.

Once you done your checks and you have a QuickBooks file setup with lists and opening balances it is a good point to make a backup before you start importing transaction history into QuickBooks.
Historical Transaction Data
The first stage in the transaction transfer process is to export all the relevant transactions from your MYOB company file into text files.  Depending on the opening balance date you have chosen you will need all open transactions prior to you opening balance date and then all transactoins since the opening balance date.
  1. Select File > Export data and then the transactions types to export.  It’s probably better to transfer manageable chunks of data with on a monthly or quarterly basis depending on the volumes of transactions you are trying to get across.
MYOB gives you the following transactions types that you can export:

Journal Transactions
  • Transaction journals
  • General journal entries
Accounts Receivable
  • Service Sales
  • Item Sales
  • Professional Sales
  • Time Billing Sales
  • Miscellaneous Sales
  • Money received
Accounts Payable
  • Purchases
  • Service purchases
  • Item purchases
  • Professional purchases
  • Miscellaneous purchases
  • Money spent

You will need to do some tidying up in Excel to remove blank lines or subtotals from the MYOB exported transaction files, if you are recoding the Tax Codes then you will need to do the in Excel prior to getting this data into QuickBooks alternatively you can rely on the default tax code associated with the item which the Transaction Importer will default to if not specified, but be careful as there may be exceptions

The next step will be to import these transactions into your QuickBooks company file using the Zed Axis Importer.   Remember to always backup your company file before attempting to import transactions so if something goes wrong you can rollback to the last good version.
  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