Rightworks Transaction Pro Importer map files can be created to import transactions such as Invoices or Journal Entries and to import lists such as Price Levels, Customers, or Items into QuickBooks Desktop (QBDT). Below is a screenshot of the Importer mapping screen with more detailed information below it. …
Employee Expenses charged to the company credit card may be imported into QuickBooks Online using Transaction Pro (TPro) Importer as a Credit Card Charge import type. TPro Importer does not require a specific file layout to import into QuickBooks Online. However, if you wish to view or use the TPro sample file for…
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 FirstName First name Y Alpha-numeric 50 MiddleName M.I. N Alpha-numeric 1 QuickBooks Online only stores the Middle Initia…
MESSAGE " Hours/minutes must be supplied for a time tracking item" RESOLUTION Check to see if any transaction in the import file that have a zero for the duration. These rows should be deleted from the import file prior to importing.
QUESTION What is the easiest way to tell if the QuickBooks Online company is set to automatic or manual tax? RESOLUTION The quickest way to tell if on the automatic sales tax or manual sales tax option is to open a Customer in QuickBooks Online and go to the TAX INFO tab. If the tab displays a checkbox follo…
QUESTION When using Silent Mode, what setting will allow the import file exception to appear? RESOLUTION Add the command line: /LOG_FILE=drive and directory name. Read more about Import Command Lines HERE .
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…
MESSAGE "E rror validating sales term ID: required field not specified" RESOLUTION This error message appears because a Sales Term was not specified and mapped to the field Sales Terms. QuickBooks Online requires that a Sales Term be mapped to the field. To resolve this issue, either a Sales Terms must be…
QUESTION When importing Sales transactions, how can the transaction be marked either TO BE EMAILED or TO BE PRINTED? RESOLUTION When using Transaction Pro Importer for QuickBooks Desktop (Pro, Premier and Enterprise), on the mapping window for the Sales transaction, provide the value of Y for the QB Field TO…
QUESTION What are some common uses for a Journal Entry import into QuickBooks Online with Rightworks Transaction Pro Importer? RESOLUTION Some of the most common uses for a Deposit import are listed below: * Importing Payroll Data after each payroll * Importing Daily Sales from a Point of Sale (POS) Syste…