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…
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 …
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. PrivateNote Memo N Alpha-numeric 4000 ToAccount Transfer Funds To Y Alpha-numer…
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…
COMMON ISSUE RESOLUTION Sub-Class Name Not Importing Sub-Class Name must include full name with a colon between each level with no space on either side of the colon. Example: CLASS:SUB-CLASS See this article for more info.
ISSUE When a Vendor or Customer name already exists, Rightworks Transaction Pro Importer creates a new name in QuickBooks Desktop (QBDT). RESOLUTION Importer does a match based upon what is in the Display Name field on the Vendor or Customer setup in QBDT. Make sure the values in the import file match QBDT e…
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…
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…
MESSAGE "Error validating Customer ID: Invalid Integer" RESOLUTION This message appears because QuickBooks Online is not allowing Rightworks Transaction Pro Importer to save the Customer name. This is typically the result of one of the two situations below: * The value mapped to the field Customer alread…
MESSAGE "This key is already associated with an element of this collection." RESOLUTION Check the import file to see if there are extra spaces in the list name (Customer, Vendor, Employee, or Product and Service) that is being added. The issue is most likely caused by the scenario below: Customer name …