You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Home > How to Import Using Transaction Pro Importer > Online Importer > Bank Statement Import Fields for Transaction Pro Online
Bank Statement Import Fields for Transaction Pro Online
print icon

 

 

 
TPro Field Name QuickBooks Online 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 QuickBooks Online. Must match currencies pre-defined in QuickBooks Online.
ExchangeRate   N Numeric   For all currencies except for BITCOIN, the saved Exchange Rate for that currency in QuickBooks Online 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.
Feedback
1 out of 2 found this helpful

scroll to top icon