.png)
.png)
Bank Statement Import Fields for Rightworks Transaction Pro Online
Oct 18, 2023
313
| 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. |
