You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
You are viewing the article in preview mode. It is not live at the moment.
Emails from our Customer Support team will be sent from [email protected].

To ensure you receive important updates without interruption, please add [email protected] to your safe sender list and mark it as “not spam.”

Showing articles from Import tag

Import Fees on PayPal Transactions with Rightworks Transaction Pro Importer for QuickBooks Online

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…

Error Validating Customer ID: Invalid Integer

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…

Creates a New Vendor or Customer When One Already Exists in QuickBooks Online

ISSUE When a Vendor or Customer name already exists, Rightworks Transaction Pro Importer creates a new name in QuickBooks Online. RESOLUTION Importer does a match based upon what is in the Display Name field in the Vendor or Customer setup in QuickBooks Online. Make sure the values in the import file matches…

Sales Receipt Import Fields for Rightworks Transaction Pro Online

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…

Common Issues Importing Classes into QuickBooks Online

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.

Creates a New Vendor or Customer When One Already Exists in QuickBooks Desktop

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…

Do Not Auto-Create List Items when Importing

QUESTION Is there an Option to control as to whether or not list items are auto-created when importing into QuickBooks Online using Rightworks Transaction Pro Importer? RESOLUTION Yes, Importer has the Options available to tell QuickBooks Online to not auto-create list items during an import. The list items …

Invalid Account Specified in the APAccount column

MESSAGE "Invalid Account specified in the APAccount column" when importing Bills. RESOLUTION If using Account Names for the Expense Accounts in the import file: - Enter the General Ledger Account Name of the Accounts Payable account on the Rightworks Transaction Pro Importer mapping screen in the Defaul…

Common Issues Importing Vendors into QuickBooks Online

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…

Vendor Import Fields for Rightworks Transaction Pro Online

TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Title Title N Alpha-numeric 4 Example: Mr, Mrs, Ms, Miss, Dr CompanyName Company N Alpha-numeric 100 FirstName First name N Alpha-numeric 25 MiddleName Middle name N Alpha-num…