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 Descriptio…
Import Accounts Instead of Items on Sales Transactions into QuickBooks Online
**QUESTION** How can a sales transaction such as Estimate, Invoice, or Sales Receipt post to a General Ledger (GL) Account instead of an Item when importing into QuickBooks Online with Transaction Pro Importer? **RESOLUTION** In QuickBooks Online, Intuit does not allow a GL Account to be used on sales transactions.…
Product and Service Import Fields for Transaction Pro Online
**TYPE: INVENTORY** ![][1] **TYPE: NONINVENTORY** ![][2] **TYPE: SERVICE** ![][3] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 100 To import Product & Service item into a Category, import Category:Name for the Name field. Type T…
Business Validation Error: There is No Account Associated with the Item "Item Name"
**MESSAGE** "Business Validation Error: There is no account associated with the Item 'Item Name'" **RESOLUTION** The message indicates that a Product is being imported, and the Product does not have an Expense Account assigned in QuickBooks Online. Update the Product setup in QuickBooks Online to include an Expense…
Import Products and Services with Categories into QuickBooks Online
**QUESTION** How are Product Categories imported into QuickBooks Online with Transaction Pro Importer? How are Products & Services imported into the Categories? **RESOLUTION** A separate import type does not exist for importing Categories into QuickBooks Online with Transaction Pro Importer. Categories are setup du…
This Key is Already Associated with an Element in QuickBooks Online
**MESSAGE** "This key is already associated with an element of this collection" **RESOLUTION** Check the import file to see if there are extra spaces in the list name (Customer, Vendor, Employee, or Product and Service) that is being added. The issue is most likely caused by the scenario below: Customer name in t…
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 mi…
Business Validation Error: There is no Account Associated with the Item
**MESSAGE** Business Validation Error: There is no account associated with the item. Is it marked for purchase and has an account associated with it? **RESOLUTION** If the above message is received when importing using Transaction Pro Importer for QuickBooks Online and the Item type is either Non-Inventory or Servi…
You Must Select a Product / Service or an Account for Each Split Line with Either an Amount or a Billable Customer
**MESSAGE** "You must select a product/service or an account for each split line with either an amount or a billable customer" **RESOLUTION** This is a known bug in the QuickBooks Online Application Program Interface (API) as it is a false error message. The actual issue is that an expense transaction (Bills, Chec…
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 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 include: …
