You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Import Checks into QuickBooks Online
print icon

QUESTION

 

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

 

RESOLUTION

 

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. 

 

QUESTION

 

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

 

RESOLUTION

 

Below are some helpful tips to keep in mind regarding the most common issues that occur when importing Checks into QuickBooks Online 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 QuickBooks Online with the location indicated into which each Transaction Pro Importer field will import.

 

Feedback
2 out of 11 found this helpful

scroll to top icon