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 m…
Often times, a business will set up Group Items in QuickBooks Desktop (QBDT) to simplify the data entry for multiple Items that are frequently sold together. This enables the person creating the form to enter the name of the Group Item and allow QB to fill in the details for all the Items in that Group. This artic…
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 i…
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…
ISSUE Unable to activate Rightworks Transaction Pro Importer (TPI), Exporter (TPE), or Deleter (TPD) Desktop or Server Editions. RESOLUTION Please check the following items: * You have an Internet connection. * Your login and password are correct (the password should contain no spaces). * You have read/w…
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 If the multi-line transactions are in columns instead of rows when importing Bills or Checks into QuickBooks Desktop (QBDT), how can the transaction be imported with Rightworks Transaction Pro Importer? RESOLUTION Importer has the option to import Bills and Checks as columns. These options are found…
The following are instructions for importing the Concur AP Invoice (Vendor Bills) Report into QuickBooks Desktop (QBDT) using Rightworks Transaction Pro Importer. After downloading an AP Invoice Report from Concur , launch Transaction Pro and select to IMPORT. Open Transaction Pro Importer and select 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 can a sales transaction such as Estimate, Invoice, or Sales Receipt post to a General Ledger (GL) Account instead of an Item when importing into QuickBooks Online with Rightworks Transaction Pro Importer? RESOLUTION In QuickBooks Online , Intuit does not allow a GL Account to be used on sales…