How are Deposit imports posted from Undeposited Funds when importing with Transaction Pro Importer into QuickBooks Online (QBO)?
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:
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.
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.