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

Bill Payment Import Fields for Transaction Pro Online

TPro Field Name QBO Field Name Required Character Type Character Limit Notes
RefNumber Check no. Y Alpha-numeric 21 The Reference Number is the assigned Check Number, but it also is how TPro and QBO know which detail rows belong on the same transaction. Import must be sorted by this column prior to importing. If the option to print checks later is selected, the Reference Number will not be used as the Check Number.
APAccount   N Alpha-numeric 100 QBO only allows posting to the default AP Account. If multiple currencies, it will post to the default AP Account for the currency of the Vendor.
Vendor Payee Y Alpha-numeric 100  
TxnDate Payment date N Date N/A If no date is imported, transaction will be dated the day of the import.
Bank or CC Account Payment account Y Alpha-numeric 100 Import either the full Account Name or the Account Number of the General Ledger Bank Account or the Credit Card Account from which the Bill was paid. See this article for more info.
PrivateNote   N Alpha-numeric 4000  
Currency Currency N Alpha  3 Only available if multi-currency activated in QBO. Must match currencies pre-defined in QBO. It will default to Currency assigned the Vendor. If setting the Vendor up "on the fly," this field will be the assigned Currency.
ExchangeRate   N Numeric   For all currencies except for BITCOIN, the saved Exchange Rate for that currency in QBO must be used.
ToBePrinted Print later N Y or N N/A Default is False (unchecked). To check field, valid values are 1, t, true, y, or yes.
BillApplyTo Ref no. Y Alpha-numeric 21 Must be a Bill Reference Number that exists in QBO prior to import.
LineAmount Payment Y Numeric 11 Maximum value 99,999,999,999.
  • 500
  • 24-Oct-2020
  • 637 Views