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

Import Bank Statements or Bank Transactions

QUESTION

Can Bank Transactions (Deposits and Checks) be imported together into QuickBooks Desktop (QBDT) with Transaction Pro Importer?

RESOLUTION

Both Deposits and Checks can be imported together in a single import as a Bank Statement import into QBDT with Importer.

Below are some formatting information for importing a Bank Statement with Importer.

  1. Deposits should be expressed as positive numbers and Checks as negative numbers.
  2. There is no requirement to have a value mapped to a Reference Number as with other Importer transaction imports because when the Bank Statement import type is selected, each line of the import file is treated as an individual transaction (ie. no split transactions).
  3. The Payee field refers to the Vendor, if importing a Check or to the Customer, if importing a Deposit.
  4. The name mapped to the QB field Billable Entity must exist in QBDT as either a Customer, Vendor, Other Name, or Employee. Importer does not create new names with this import type.
  5. If the Billable field is Y (for yes), then a Billable Entity must also be mapped and imported for that line.
  6. If the transaction is not billable, then do not map any value to the Billable field.
  7. If using Account Names, the import file should include the full Account Name (Parent:Child) with each level separated by a colon with no space before or after the colon (ie. Account:Sub-Account) If using Account Numbers, the import should only include the lowest Sub-Account Number.
  8. Deposits cannot be imported against Undeposited Funds.
  • 464
  • 04-Jun-2020
  • 166 Views