TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Estimate no Y Alpha-numeric 21 The Reference Number is the Estimate Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must b…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes TxnDate Date N Date N/A If no date is imported, transaction date will default to the date of the import. Name Name Y Alpha-numeric 100 Name can be an Employee Name or a Vendor Name (Contrac…
QUESTION How can lines be removed from the import file from within Rightworks Transaction Pro Importer for QuickBooks Desktop (QBDT)? RESOLUTION Sometimes, the import file may contain additional lines that are not to be imported or when testing, only a line or two is desired to test. The additional lines can…
MESSAGE "String length specified does not match the supported length." RESOLUTION This message appears because some data in the import file exceeds the maximum length allowed in QuickBooks Online. Edit the data in the import file so that it is shorter. For more information about maximum character lengths …
QUESTION Can Memorized Transactions be imported into QuickBooks Online using Rightworks Transaction Pro Importer? RESOLUTION At this time, it is not possible to import Memorized Transactions into QuickBooks Online using Importer. A workaround is to use Importer to create these recurring transactions instead …
QUESTION How can PayPal transaction fees be imported? RESOLUTION The download file from PayPal lists the gross amount and PayPal fees on a single line. However, in Rightworks Transaction Pro Importer, only one item can be mapped per line. The workaround is to import the Gross Amount as a Product/Service a…
QUESTION How can Rightworks Transaction Pro Importer create a new name (Customer, Vendor, or Employee) during a Journal Entry import into QuickBooks Desktop (QBDT)? RESOLUTION By default, Importer does not create new names when importing Journal Entries. However, by using the command line /JE_NAME, Importer …
COMMON ISSUE RESOLUTION Sub-Vendor Name Not Importing Sub-Vendor Name must include full name with a colon between each level with no space on either side of the colon. Example: VENDOR:SUB-VENDOR See this article for more info. Wrong Currency Imports Multi-currency not turned on in QuickBooks Onlin…
ISSUE After selecting the Option for QuickBooks Online to AUTO ASSIGN the transaction number and importing the transaction with Rightworks Transaction Pro Importer, the transaction number field is blank in QuickBooks Online. RESOLUTION If a transaction number is not auto assigned even when the Option to have…
ISSUE When importing Receive Payments, Rightworks Transaction Pro Importer failed to find a matching Invoice in QuickBooks Desktop (QBDT) file even though the record does exist. Error message "Could Not Find Matching Invoice to Apply Payment" displays on the Transaction Log. RESOLUTION First, make sure th…