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

Bank Statement Import Fields for Transaction Pro Online

TPro Field Name QBO Field Name Required Character Type Character Limit Notes
TxnDate Date (Deposit)
Payment date (Check)

 
N Date N/A If no date is imported, transaction will be dated the day of the import.
PrivateNote Memo (Deposit)
Memo (Check)
N Alpha-numeric 4000  
Currency Currency N Alpha  3 Only available if multi-currency activated in QBO. Must match currencies pre-defined in QBO.
ExchangeRate   N Numeric   For all currencies except for BITCOIN, the saved Exchange Rate for that currency in QBO must be used.
DepositToAccount Account (Deposit)
Bank Account (Check)
Y Alpha-numeric 100 Import either the full Account Name or the Account Number of the Bank Account into which payment was deposited (Deposits) or from which the payment was made (Checks). See this article for more info.
Entity Received From (Deposit)
Payee (Check)
N Alpha-numeric 100 Customer, Vendor, or Employee Name from which the payment was received (Deposits) or to which the payment was made (Checks). If importing a sub-Customer or sub-Vendor, see this article for more info.
LineDesc Description (Deposit)
Description (Check)
N Alpha-numeric 4000  
LineAmount Amount (Deposit)
Amount (Check)
N Numeric 11 Maximum value 99,999,999,999. Positive numbers import as Deposits. Negative numbers import as Checks.
Account Account (Deposit)
Category (Check)
  Alpha-numeric 100 For Deposit, this is the General Ledger Account reflecting for what the deposit was paid (Income). For Check, this is the General Ledger Account reflecting for what the payment was made (Expense). Import either the full Account Name or the Account Number. See this article for more info.
  • 511
  • 24-Oct-2020
  • 878 Views