QUESTION

What order do lists and transactions need to be imported into QuickBooks Online?

RESOLUTION

When importing lists and transactions into QuickBooks Online with Rightworks Transaction Pro Importer, the lists and transactions should be imported in the same order as they would be manually entered into QuickBooks Online. This is the same whether importing into a new QuickBooks Online company file or an existing QuickBooks Online company file.

SUGGESTED IMPORT ORDER

Import Lists:

• Accounts
• Classes
• Locations
• Customers
• Vendors
• Employees
• Products & Services

Import Transactions:

• Journal Entries
• Transfers (Bank Transfers)
• Purchase Orders (1)
• Bills 
• Vendor Credits (3)
• Bill Payments
• Checks
• Credit Card Charges
• Credit Card Credits
• Purchases - Cash
• Estimates (1)
• Invoices 
• Sales Receipts (2)
• Credit Memos (3)
• Receive Payments (2)
• Deposit (2)

(1) Estimates and Purchase Orders are for history purposes.

(2) Deposits from Undeposited Funds with Importer must contain a Payment Reference Number on the original payment transaction. See THIS ARTICLE for more information about importing this type of transaction. 

(3) Vendor Credits and Credit Memos are not automatically applied to open Bills or Invoices. This must be handled manually in QuickBooks Online.

PLEASE NOTE THAT IMPORTER CANNOT IMPORT THE FOLLOWING DATA FROM ONE QUICKBOOKS ONLINE COMPANY FILE TO ANOTHER:

• Bank Reconciliations (4)
• Payroll Data / History

(4) If migrating data from one QuickBooks Online company to another, it is suggested to do one bank reconciliation as of the last date reconciled in the previous company and clear all cleared items at once to be ready to do the next month's reconciliation.