• Contents

Importing COGS into Xero

Last updated 23/12/2020

How to import Cost of Goods Sold (COGS) to Xero.

Overview


If you are using the Perpetual inventory accounting method, you will import COGS into Xero to decrease your inventory asset/SOH account and increase your COGS expense account.

Accounting Methods

If you are using the Periodic method, COGS are still calculated, but you do not need to import COGS into your Xero account. For the difference between the two methods, please see Perpetual Method and Periodic Method.

Cin7 generates Cost of Goods Sold (COGS) for each Sale provided the sale has:

  • a Fully Dispatched date entered,
  • an Invoice Date entered, and
  • been imported the Sales Order into Xero.

Importing COGS to Xero 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 Xero. This reduces transactions sent to Xero, and keeps your ledger tidy. Cin7 updates the same journal every time there is a change or an addition to the COGS value. The monthly journal will always be available to import in the Xero 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.

Importing COGS


Importing All COGS at the same time

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 Xero.
  2. Click Import COGS.
    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 do 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 Xero module for import?

That's correct, there will always be a transaction to import - usually, it will change as your COGS change throughout the month. Don't worry though, it overwrites the existing journal, it won't import a new one.

I've recently sold some products, why haven't my COGS changed?

Cin7 automatically generates COGS on a daily basis, so you may not see the COGS change until the next day, provided the Sales Order fulfills the conditions above. To see the most up to date COGS values click on 'Preview' next to Import COGS in the Xero module.