TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Sales Receipt no Y Alpha-numeric 21 The Reference Number is the Invoice Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import mu…
QUESTION If importing a General Ledger Account on a transaction with Rightworks Transaction Pro Importer, should the Account Name or the Account Number or both be used? RESOLUTION If using Account Numbers, the import data should include either the Account Name or Account Number but not both. If posting to…
QUESTION Can exports be scheduled with Rightworks Transaction Pro Exporter for QuickBooks Online? RESOLUTION When exporting transactions and lists from QuickBooks Online with Exporter, there is the option to configure and schedule the exports. The schedule can be one time or recurring. This option allows the…
QUESTION What import types that should be used when importing sales into QuickBooks? RESOLUTION Below are brief descriptions how Sales Receipts, Invoices and Deposits work in QuickBooks. QuickBooks Sales Receipts Sales Receipt should be selected as an import type when the Customers pay at the same time…
QUESTION How does Rightworks Transaction Pro Importer know when there are multiple detail lines on a transaction when importing into QuickBooks Online? RESOLUTION Importer knows how to group multiple lines onto the same transaction when importing transactions such as Invoices, Bills, Journal Entries, et cete…
MESSAGE "Unfortunately an internal error occurred while processing your request" RESOLUTION If the above message is received when using Rightworks Transaction Pro Importer for QuickBooks Online, the Admin of the TPro subscription will need to disconnect and reconnect TPro by following the steps below: * …
QUESTION Can the Trial Balance Report be exported with Rightworks Transaction Pro Exporter for QuickBooks Online? RESOLUTION When exporting transactions and lists from QuickBooks Online with Exporter, there is now the option to export the Trial Balance report. Below are the steps to export the Trial Balan…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Y Alpha-numeric 100 Reference Number is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must be sorted by this column prior to import. TxnDa…
COMMON ISSUE RESOLUTION Sub-Customer Name Not Importing Sub-Customer Name must include full name with a colon between each level with no space on either side of the colon. Example: CUSTOMER:SUB-CUSTOMER See this article for more info. Wrong Currency Imports Multi-currency not turned on in QuickBoo…
QUESTION: How are Deposit imports posted from Undeposited Funds when importing with Rightworks Transaction Pro Importer into QuickBooks Online? RESOLUTION: When importing Deposits into QuickBooks Online with TPro Importer, Deposits can be posted from Undeposited Funds. However, the Receive Payment or Sales …