You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.

Import Checks into QuickBooks Online


What are some common uses for a Check import into QuickBooks Online (QBO) with Transaction Pro Importer?


Some of the most common uses for a Check import are listed below:

  • Importing Payroll Data after each payroll
  • Importing Check activity that was processed through a third party billing system system
  • Importing Employee Reimbursements that were paid by ACH

NOTE: To record both Checks and Deposits at the same time, use Transaction Pro Importer's Bank Statement import. 


What are some helpful tips to know when importing Checks into QuickBooks Online (QBO) with Transaction Pro Importer?


Below are some helpful tips to keep in mind regarding the most common issues that occur when importing Checks into QBO with Importer.

  • When importing a Check, the following fields are required (at minimum).
    • RefNumber
    • Bank Account (GL Account Name or Number)
  • If a Check has multiple distribution lines on it, repeat the same Reference Number on every line (ie. a transaction ID or check number) to allow Importer to know to group the multiple lines onto one Check.
  • Importer supports both Account Numbers and Account Names. However, only include either the lowest Sub-Account number or the entire Account Name in the import file, not both.
  • If importing Account Numbers, on the Preview window of Importer, click OPTIONS and select the option to ENABLE ACCOUNT NUMBERS ON TRANSACTIONS.
  • These fields are required if importing Products or Services on the Item tab: LineItem, LineQuantity, and either LineUnitPrice or LineAmount.
  • These fields are required if using Expense Accounts on the Accounts tab: ExpenseAccount and ExpenseAmount.

The below screenshot shows the entry screen for Checks in QBO with the location indicated into which each Transaction Pro Importer field will import.

  • 253
  • 26-Aug-2020