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

Import Cash Purchases into QuickBooks Online


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


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

  • Importing transactions from a debit card
  • Importing monthly or daily activity from another accounting system
  • Importing transactions paid by owner to not be reimbursed
  • Importing transactions paid with cash


What are some helpful tips to know when importing Cash Purchases 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 Cash Purcahses into QBO with Importer.

  • When importing a Cash Purchase, the following fields are required (at minimum).
    • RefNumber
    • BankAccount (General Ledger Bank Account Name or Number)
  • If a Cash Purchase transaction has multiple distribution lines on it, repeat the same value on every line for the Reference Number (e.g. a transaction ID or cash purchase number) to allow Importer to know to group the multiple lines onto one Cash Purchase.
  • 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 will become required if using Products or Services on the Item Tab: LineItem, LineQuantity, and either LineUnitPrice or LineAmount.
  • These fields become required if using Expense Accounts on the Accounts Tab:  ExpenseAccount and ExpenseAmount.

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

  • 249
  • 26-Aug-2020