Check cost of goods sold (COGS) has generated

Overview

Find sales orders and credit notes that haven’t generated cost of goods sold (COGS) with the Sales Orders and Credit Notes report.

Cost of goods sold (COGS) is the net carrying cost of the goods sold and returned. Cin7 Omni will automatically generate COGS once a day for sales orders and credit notes that meet several conditions. You can manually generate COGS for those transactions too.

Conditions for COGS

COGS is only generated for sales orders and credit notes that have:

Qty Dispatch (sales orders) or Qty Moved (credit notes) for each line item
A Fully Dispatched (sales orders) or Completed Date (credit notes)
An Invoice Date (sales orders) or Credit Note Date (credit notes)
An Accounting Invoice Status of Imported or Do Not Import

Value of COGS

For an individual sales order or credit note, COGS is the sum of the landed costs of the units dispatched (Qty Dispatch) or received (Qty Moved) in the transaction. For a particular time period, COGS is the net amount of the individual COGS of sales orders and credit notes invoiced during that period.

Generate COGS

Omni will automatically generate COGS on sales order and credit notes once a day. You can manually generate COGS too:

From the Accounting menu in the navigation, open your Xero or QuickBooks Online integration.
Open the Accounting & COGS > COGS tab.
Select Refresh Data.

Check COGS has generated

You can check whether COGS has been generated for individual sales orders and credit notes in a time period with the Sales Orders and Credit Notes report:

From the navigation, open Insights.
From the navigation, open Standard Reports.
Under Finance, open Sales Orders and Credit Notes—if you can’t see the report, find out how to install new reports.
Set the time period (Start Date and End Date).
Select Search.

You’ll see each transaction’s COGS in the Cost column. If Cost is blank, COGS has not been generated for that transaction. To generate its COGS, check it meets the conditions for COGS and then generate them.

If Cost is $0.00, the transaction has no COGS. This is okay, so long as the units dispatched or received either (a) have no landed cost or (b) are non-stock items.

Find out more about the Sales Orders and Credit Notes report.