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

Import Undeposited Funds Deposits into QuickBooks Online

QUESTION:

How are Deposit imports posted from Undeposited Funds when importing  with Transaction Pro Importer into QuickBooks Online (QBO)?

RESOLUTION:

When importing Deposits into QBO with TPro Importer, Deposits can be posted from Undeposited Funds. However, the Receive Payment or Sales Receipt transaction must have a Payment Reference Number in order to process this type of transactions with an import with TPro Importer.

When importing a Deposit transaction import type to post from Undeposited Funds, the required fields to map in TPro Importer are:

  • REFNUMBER:  To group imported detail lines together into a single Deposit
  • DEPOSITTOACCOUNT: To specify to which General Ledger Bank Account QBO is to post the Deposit
  • LINKEDTXNTYPE: To specify the transaction type of either PAYMENT or SALESRECEIPT associated with the amount
  • LINKEDTXNNUMBER: To specify the Payment Reference Number associated with the amount to Deposit
  • CURRENCY: To specify the currency of the Deposit, if using Multi-currency in QBO

TXNDATE is not required but should be used to specify a specific Deposit date. Otherwise, the Deposit will post to the date that the import is processed.

The Customer (ENTITY), Payment Amount (LINEAMOUNT), or General Ledger Account Undeposited Funds (ACCOUNT) are not needed when posting a Deposit from Undeposited Funds.

Example:

When manually processing a Bank Deposit in QBO, the following transactions show as available to be posted from Undeposited Funds:

The first two include a Payment Reference Number. Therefore, they can be part of a Deposit import with TPro Importer. However, the third cannot because there is not a Payment Reference Number. To be able to include the third transaction in a Deposit import, a Payment Reference Number will need to be added in QBO.

For the other two transactions, here is how the imported file would look when mapped in TPro Importer:

The below screenshot shows the entry screen for Deposits in QBO with the location indicated into which each Transaction Pro Importer field will import including when importing a Deposit posted to Undeposited Funds.

  • 424
  • 26-Aug-2020
  • 1994 Views