• Contents

Importing COGS into QuickBooks Online

Last updated 08/01/2021

 

How to import Cost of Goods Sold (COGS) to QuickBooks Online.

Overview


Cin7 generates Cost of Goods Sold (COGS) for each Sale provided that:

  • you have entered a Fully Dispatched date,
  • you have entered an Invoice Date, and
  • you have imported the Sales Order into QuickBooks Online or set to 'Do Not Import'.

Importing COGS to QuickBooks Online credits your Inventory account and debits your COGS account by the same value. For further information on COGS please see our article Cost of Goods Sold in Cin7.

Cin7 creates a single COGS journal for each month to import into QuickBooks Online. This reduces transactions sent to QuickBooks Online and keeps your ledger tidy. Cin7 updates the same journal every time there is a change or an addition to the COGS. The monthly journal will always be available to import in the QuickBooks Online module.

By default, Cin7 updates both the previous month and the current month's COGS journals. If you wish, you can also change the system to update COGS journals up to 6 months prior to the current month. For more information see Importing COGS from Previous Months.

Importing COGS


There are two ways to import COGS into QuickBooks Online.

All COGS at once

This method will import or update multiple monthly COGS journals at the same time. This is the quickest method.

  1. From the left navigation, select Accounting, then QuickBooks Online.
  2. Select Upload Adjustments & COGS.
  3. Select Upload COGS.
  4. Select Update All.

A confirmation will notify you if Cin7 has imported the orders successfully.

FAQs

I use alternative COGS accounts that match my Alternative GL Accounts. How does COGS work in this situation?

This method still works if you have multiple COGS accounts. With alternative COGS accounts, your monthly COGS journal will include multiple lines for each Alternative Account.

I've imported the COGS for this month already, but the value has reappeared in my QuickBooks Online dashboard for import?

Correct. There will always be a transaction to import. It usually will change as your COGS change throughout the month. Not to worry, though; it overwrites the existing journal and won't import a new one.