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

Import Deposits to QuickBooks Online

QUESTION

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

RESOLUTION

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

  • Recording donations from an online web app
  • Recording daily activity from a Point of Sale (POS) system
  • Importing bank activities

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 Deposits into QuickBooks Online (QBO) with Transaction Pro Importer?

RESOLUTION

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

  • When importing a Deposit, the following fields are required (at minimum).
    • RefNumber
    • DepositToAccount (General Ledger Bank Account Name or Number)
  • If a Deposit has multiple lines on it, repeat the same value on every line for the Reference Number (ie Deposit number) to allow Importer to know to group the multiple lines together onto one Deposit.
  • 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 using Account Numbers, on the Preview screen of Importer, click OPTIONS and select the option ENABLE ACCOUNT NUMBERS ON TRANSACTIONS.
  • Consider using a Default Value for the QBO field DepositToAccount.
  • To import a Deposit from the Undeposited Funds account, see this ARTICLE.

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

  • 247
  • 26-Aug-2020
  • 1916 Views