Product Costing GL Accounts Mapping

Product Costing GL Accounts

In order for products to be automatically created in QuickBooks Online when batching Item Receipts or Invoices that have products, you will need to also fill in the “Inventory” and/or “COGS (Cost of Goods Sold)” accounts, depending on the product “Type Xref” (see Product Item Type). For example, a product with the “Type Xref” of “Inventory” will require both the Inventory and COGS accounts to be populated in the GL Account Setup, as shown below. However, a product with the “Type Xref” of “Service” will only require the COGS account to be populated in the GL Account Setup. This is filled out on the “Revenue-Product” or “Revenue-Agreement-Product” account types.  Note:  All Inventory Products must have COGS account.

It is important to note that any time that you make changes to your GL Account Mapping you need to open and then close any closed invoices that use that mapping for it to change.  Once you have done that you can then successfully run the batch in QuickBooks to show the new account. More on this here.

Since the Account Number field is optional, QuickBooks Online uses the Account Name as the primary key. As a result, the Account Number should never be included in any mappings within Manage.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.