Order to Import Transactions into QuickBooks Online

QUESTION

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

RESOLUTION

When importing lists and transactions into QBO with Transaction Pro Importer, the lists and transactions should be imported in the same order as they would be manually entered into QBO. This is the same whether importing into a new QBO company file or an existing QBO 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 QBO.

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

  • Bank Reconciliations (4)
  • Payroll Data / History

(4) If migrating data from one QBO 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.

  • 421
  • 03-Sep-2019
  • 376 Views