Bank Statement

Field Descriptions

QuickBooks Field Label QuickBooks Field Description
Payment Date TxnDate Date of the transaction
Memo PrivateNote Organization-private note(memo) about the transaction
Currency Currency Currency associated with the transaction.
Exchange Rate ExchangeRate The number of home currency units it takes to equal one unit of currency specified within QBO.
Account DepositToAccount * Account to / from which the amount comes in or goes out. Include only the account name or account number in this field and not both. If using Account Names in QuickBooks Online specify the entire account name, including any sub-account names and separate with account and sub-account with a colon in between (eg. Account:SubAccount). If using an account number include only the lowest sub-account number and enable the Transaction Pro Importer option, Enable Account Numbers.
Customer/Vendor/Employee Entity Associated entities can be Customer or Vendor or Employee.
Line Description LineDesc Line description.
Line Amount LineAmount * Amount of the transaction, negative is for checks and positive is for deposits.
Line Account Account * Account associated with the transaction. Include only the account name or account number in this field and not both. If using Account Names in QuickBooks Online specify the entire account name, including any sub-account names and separate with account and sub-account with a colon in between (eg. Account:SubAccount). If using an account number include only the lowest sub-account number and enable the Transaction Pro Importer option, Enable Account Numbers.