QUESTION When importing Credit Card Charges, how can the Vendor names on the Credit Card Statement be matched to the Vendor names that already exist in QuickBooks Desktop (QBDT)? ANSWER Rightworks Transaction Pro (TPro) Importer for QBDT has an ALIASES option that allows names to be matched between the impor…
QUESTION What are some helpful tips to know when importing Bills into QuickBooks Online with Rightworks Transaction Pro Importer? RESOLUTION Below are some helpful tips to keep in mind regarding the most common issues that occur when importing Bills into QuickBooks Online with Importer. * When importing …
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Bill no Y Alpha-numeric 21 The Reference Number is the Bill Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must be sorted…
Employee Expense Reimbursements may be imported into QuickBooks Desktop (QBDT) using Transaction Pro (TPro) Importer as either a Bill import type to be reimbursed at a later date or as an Check import type, if the reimbursement has already occurred. This article discusses importing as a Bill import type. For infor…
Employee Expense Reimbursements may be imported into QuickBooks Online using Transaction Pro (TPro) Importer as either a Bill import type to be reimbursed at a later date or as an Expense or Check import type, if the reimbursement has already occurred. This article discusses importing as a Bill import type. For in…
MESSAGE "Duplicate Document Number Error : You must specify a different number. This number has already been used." RESOLUTION The message appears because a transaction already exists in QuickBooks Online with this number. In order to allow QuickBooks Online to use duplicate numbers, the following changes…
MESSAGE "Required parameter line is missing in the request" when importing Checks or Bills into QuickBooks Online. RESOLUTION If importing Checks or Bills into QuickBooks Online, the data needs to be mapped to one of this two scenarios: * Products and Services: LineItem and LineAmount: Data must be map…
QUESTION Is there a way to import both the Item Receipt and the Vendor Bill at the same time? RESOLUTION Yes, both transactions can be imported at the same time into QuickBooks Desktop (QBDT) using Transaction Pro Importer by using the Import Type ITEM RECEIPT W/BILL. As an additional bonus, if the Purcha…
MESSAGE "Transactions must have at least one line item - Make sure an account or item is specified on at least one transaction line" RESOLUTION For the transaction types listed below, QuickBooks gives the option of using either Expense Accounts or Items on the transaction. * Bills * Checks * Credit Car…
QUESTION What is the best import type to use to import expenses into QuickBooks Online? RESOLUTION Often times, users will have an Excel listing of expenses to import into QuickBooks Online but are unsure as to which import type to select. Below are the different import types to consider selecting and how…