You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Need immediate help? Phone support is available between Monday and Friday from 9am to 9pm EST at 888-297-6172

Showing articles from Import tag

Customer Address Being Cleared on Import

ISSUE When importing Invoices or Sales Receipts, the Customer Address is being cleared. RESOLUTION Verify that the Option to CLEAR TRANSACTION BILL TO/SHIP TO ADDRESS WHEN IMPORTING is not selected in the OPTIONS on the BASIC tab (see image below).

Let QuickBooks Online Assign the Next Transaction Number during Import

QUESTION How can the next transaction number in QuickBooks Online be used when importing a transaction with Transaction Pro Importer? RESOLUTION If the transaction number is not in the import file or if it is preferred to let QuickBooks Online use the next transaction number in the current numbering sequence…

The Item History Could Not Be Locked

QUESTION "The item history could not be locked" RESOLUTION This message appears because one of the Items in the import file is being edited in the QuickBooks company file while the import is being processed. Once this Item is saved or closed in QB, the message will not appear.

Common Issues Importing Products & Services into QuickBooks Online

COMMON ISSUE RESOLUTION Required parameter ExpenseAccountRef or IncomeAccountRef is missing in the request Income Account is required on all Types. Expense Account is required for type Inventory. Expense Account is required for type NonInventory and Service if values are imported for Purchase Description…

Incorrect Date Issue for Mac Users

ISSUE When importing with Transaction Pro Importer on a Mac computer, the dates import incorrectly. RESOLUTION Check to make sure that the 1904 date format is not turned on in Excel. If it is, it will cause dates to shift by 1462 days. The Excel setting is in different places depending on the Office versi…

Import Employee Expense Reimbursement to be Paid into QuickBooks Online

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…

JOOR Sales Transaction Estimate Import into QuickBooks Online

Below are the instructions to import JOOR sales transactions into QuickBooks Online as an Estimate using Transaction Pro Importer. After downloading your sales file from JOOR , log into Transaction Pro Importer and select to START IMPORT. CHOOSE IMPORT TYPE: Select ESTIMATES as your import type by clicking …

Entering Discount When Receiving Payments

QUESTION How is a discount entered when importing Receive Payments? RESOLUTION The amount mapped to the Discount Amount field needs to be expressed as a positive amount. The Discount Account field needs to be the lowest sub-account number or sub-account name of the General Ledger account.

New Products and Services Setup in QuickBooks Online with Uncategorized Income or Uncategorized Expense

QUESTION Why do new Products and Services that set up during an import into QuickBooks Online set up with the Accounts of Uncategorized Income or Uncategorized Expense? RESOLUTION If a Products and Services in an import does not already exist in QuickBooks Online, Transaction Pro Importer will create the mis…

Import Refund Receipts into QuickBooks Online

QUESTION How can a Refund Receipt be imported into QuickBooks Online using Transaction Pro Importer? RESOLUTION Refund Receipts can be imported into QuickBooks Online using Importer. A Refund Receipt is a posting transaction that is used when reimbursing a customer's money. Some important formatting consi…

scroll to top icon