You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Home > How to Import Using Transaction Pro Importer > Online Importer > Order to Import Transactions into QuickBooks Online
Order to Import Transactions into QuickBooks Online
print icon

QUESTION

 

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

 

RESOLUTION

 

When importing lists and transactions into QuickBooks Online with 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.

Feedback
3 out of 7 found this helpful

scroll to top icon