.png)
.png)
Valid Values for Tax Exemption Reason for Customer Import into QuickBooks Online
Value For Exemption Reason 1 Federal government 2 State government 3 Local government 4 Tribal government 5 Charitable organization 6 Religious organization 7 Educational organization 8 Hospital 9 Resale 10 Direct pay permit 11 Multiple points of use 12 Direct mail 13 …
Import Journal Entries into QuickBooks Online
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…
Time Activities - Hours/Minutes Must Be Supplied
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.
This Account Period is Closed
MESSAGE "This account period is closed" RESOLUTION The date of the transaction being imported falls before the closing date restriction that has been set in QuickBooks Online. To import, either the date of the transaction to be imported will need to be changed to a later date or the closing date restriction will need…
Error Validating Invalid Double
MESSAGE "Error validating Invalid double:" when importing Time Activities into QuickBooks Online RESOLUTION Verify the following: * If importing billable time into QuickBooks Online, be sure to have an import column with a Y mapped to BillableStatus or enter a Y for the Default Value column. * If import…
Import Employee Expenses Charged to Company Credit Card into QuickBooks Online
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…
Employee Import Fields for 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 FirstName First name Y Alpha-numeric 50 MiddleName M.I. N Alpha-numeric 1 QuickBooks Online only stores the Middle Initia…
How to Tell if QuickBooks Online is Set Up as Automatic Sales Tax or Manual Sales Tax
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…
Error Validating Sales Term ID: Required Field Not Specified
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…
Alphanumeric Value Error - QuickBooks Online
ISSUE Error received or incorrect data imports when importing alphanumeric columns. RESOLUTION Make sure that mixed formatted columns (alphanumeric) are formatted as text in the import file.
