.png)
.png)
Bill Payment Import Fields for Rightworks Transaction Pro Online
Oct 18, 2023
703
| TPro Field Name | QuickBooks Online 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 QuickBooks Online 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 | QuickBooks Online 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 QuickBooks Online. Must match currencies pre-defined in QuickBooks Online. 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 QuickBooks Online 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 QuickBooks Online prior to import. |
| LineAmount | Payment | Y | Numeric | 11 | Maximum value 99,999,999,999. |
