Fix cost of goods sold (COGS) discrepancies

Fix cost of goods sold (COGS) discrepancies

Overview

Cost of goods sold (COGS) can occasionally differ between Cin7 Omni and Xero or QuickBooks Online due to timing differences, configuration changes, or data updates.

Use the COGS breakdown report to identify discrepancies. Contact your accountant to resolve them.

Check for COGS discrepancies

Check for COGS discrepancies by comparing COGS in Omni with Xero or QuickBooks Online:

  1. From the navigation, open Insights > Standard reports.

  2. Under Finance, open COGS Breakdown.

  3. Set Start date to 12 months ago and End date to today.

  4. Add Year and Month column fields.

  5. Add COGS data field.

  6. Optionally, remove all row fields (this speeds up the report).

  7. Compare each month's COGS Grand Total with the matching journal in Xero or QuickBooks Online.

If you find discrepancies, contact your accountant to resolve them.

Was this article helpful?

Have more questions? Submit a request