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

Receive Payment Import Fields for Transaction Pro Online

TPro Field Name QBO Field Name Required Character Type Character Limit Notes
RefNumber   Y Alpha-numeric 31 The Reference Number for this type of import should be unique for each row.
TxnDate Payment date N Date N/A If no date is imported, transaction will be dated the day of the import.
PaymentRefNumber Reference no N Alpha-numeric 31 The Payment Reference Number is the actual reference number of the payment received such as the Check Number or the ACH Confirmation Number. If the payment is paying multiple Invoices, this number can be repeated multiple times on the same import.
Customer Customer Y Alpha-numeric 100 If importing a sub-Customer or Project, must include the full name. See this article for more info.
PaymentMethod Payment method N Alpha-numeric 31  
DepositToAccount Deposit to N Alpha-numeric 100 Import either the full Account Name or the Account Number of the Bank Account into which payment was deposited. See this article for more info.
InvoiceApplyTo Invoice no N Alpha-numeric 21 Must be an Invoice Number that already exists in QBO prior to importing. If no Invoice Number is imported, payment will be auto-applied to the account.
LineAmount Payment Y Numeric 11 Maximum value 99,999,999,999.
PrivateNote Memo N Alpha-numeric 4000  
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.
  • 506
  • 24-Oct-2020
  • 875 Views