Why Your Margins Are Wrong: How Receiving Errors in Cin7 Break COGS

Incorrect COGS in Cin7 occurs when inventory value is not fully established through the correct combination of receiving, supplier invoicing, and cost allocation.

SYSTEMS AND SOFTWAREECOMMERCE

Pierre Goldie

4/20/20265 min read

Why Your Margins Are Wrong: How Receiving Errors in Cin7 Break COGS

Pierre Goldie, Co-founder & CGO @ Fiskal

Incorrect COGS in Cin7 occurs when inventory value is not fully established through the correct combination of receiving, supplier invoicing, and cost allocation. Timing gaps, missing landed costs, and unresolved clearing accounts result in incomplete inventory valuation, which flows directly into margins and financial reporting.

Cin7 does not calculate margins in isolation. It reflects the outcome of how inventory value is created, updated, and synchronized across operational and financial systems.

If your margins don’t match expectations, the issue is unlikely to be reported. It is how value is being established in your system.

Most attempts to fix incorrect margins start in the wrong place.

Teams look at reports, reconcile differences, or adjust figures in accounting. These actions operate on outputs. They do not address how those outputs are produced.

Margins in Cin7 are not determined by reporting. They are the result of how inventory value is constructed through transactions and how those transactions interact across systems.


TL;DR

  • Margins become unreliable when inventory valuation is incomplete or misaligned

  • COGS reflects upstream transaction issues, not just sales activity

  • GINR, landed cost omission, and timing mismatches are primary drivers

  • Fixes fail when they target reporting instead of system logic

  • Financial accuracy depends on alignment across receiving, invoicing, and accounting

This is a valuation problem, not a quantity problem

Inventory value in Cin7 is recognized through aligned transaction events. These include receiving, invoicing, and cost allocation. It is not created by any single operational step.

COGS errors are not reporting issues. They are the result of incomplete or misaligned inventory valuation upstream.

A common assumption is that accurate stock counts lead to accurate financials. That assumption is incorrect.

A stock take updates quantity on hand, but it does not guarantee correct financial valuation. Inventory can match physically while remaining financially incorrect if cost data is incomplete or inaccurate.

Even when quantities are correct, margins can still be wrong if the underlying cost structure is incomplete or misaligned.

At its core, inventory follows a simple equation:

Inventory = Opening Balance + Purchases – Cost of Goods Sold

If any part of that equation is incomplete or incorrectly timed, the result, including margins, becomes unreliable.

If your stock counts are correct but margins are not, the issue lies in valuation, not quantity.


How Cin7 actually generates COGS

Cin7 calculates COGS based on inventory value at the moment of shipment. Revenue is recognized at invoicing. These are separate transactions that must align correctly.

If receiving, invoicing, and accounting synchronization are not aligned, Cin7 produces financially incorrect outputs even when operational workflows appear correct.

This separation is critical:

  • Invoicing affects revenue

  • Shipment affects inventory and COGS

  • Receiving enables inventory recognition, contingent on supplier invoicing and cost allocation

When transaction timing is inconsistent, inventory value becomes incomplete or delayed. This results in incorrect COGS.

These are not system errors. They are the natural outcome of how ERP systems process transactions independently.


Where is the source of truth?

Cin7 governs inventory value based on transaction processing. That value must align with accounting outputs to ensure consistency.

When discrepancies appear between Cin7 and accounting, the question is not which system is correct.

If Cin7 and your accounting system disagree, the issue is whether transactions are aligned.


The core break: value is not fully established

Margin distortion occurs when inventory value is incomplete or incorrectly timed across receiving, invoicing, and cost allocation.

Receiving is a critical step in value recognition, but only within the full transaction chain.

Receiving does not independently create value.

It enables inventory recognition within a sequence:

  • Supplier invoice establishes liability

  • Receiving enables asset recognition

  • Cost allocation completes valuation

If any part of this sequence is incomplete or misaligned, the resulting inventory value and therefore COGS will be incorrect.


Failure pattern 1: GINR is left unresolved

GINR represents a timing difference between invoicing and receiving. It is not an error by default.

In Cin7, this may appear as Stock in Transit (goods invoiced but not received) or Inventory Accrual (goods received but not invoiced), depending on the transaction state.

When purchase orders are partially received, value remains in these interim accounts and is not fully recognized as inventory.

Unresolved balances result in incomplete inventory valuation. This leads to understated COGS and distorted margins.

This is not a warehouse issue.

Persistent balances indicate incomplete purchasing workflows.


Failure pattern 2: partial receipts and timing gaps

Supplier invoices and stock receipts are separate events. They must align to establish full inventory value.

When invoices are processed before goods are fully received, liabilities are recognized without corresponding asset completion.

Timing mismatches between invoicing and receiving result in incomplete valuation. This impacts COGS accuracy.

These gaps are expected in isolated cases. They become problematic when they persist across multiple transactions.


Failure pattern 3: landed cost omission

Landed costs must be capitalized into inventory to complete product valuation.

When freight, duties, or additional costs are expensed instead, inventory value is understated.

Missing landed costs create artificially high margins. These margins later adjust when true costs are recognized.

If margins appear unusually high, cost allocation is likely incomplete.


Failure pattern 4: invoice vs receipt mismatch with lock constraints

When supplier invoice values differ from the value established at receipt, adjustment journals may be required to align inventory valuation.

While received quantities must align with what is invoiced, they can differ from the original purchase order quantities. The issue arises when valuation is not correctly aligned between receipt and invoicing.

If accounting lock dates prevent those adjustments from being posted, discrepancies can persist until the underlying transactions are corrected.


Failure pattern 5: manual accounting overrides

Manual journals should not be used to force alignment between Cin7 and accounting systems.

When manual adjustments are made outside Cin7 and the system later processes its own transactions, duplicate or conflicting entries can occur.

This may appear to resolve reporting discrepancies temporarily. It introduces long-term inconsistency.

If reconciliation depends on manual adjustments, the underlying system logic is not aligned.


Why many fixes don’t work

Fixes fail when they address reporting outputs or isolated transactions rather than correcting underlying valuation and timing logic.

Reconciliation, re-syncing, and adjustments operate on outputs. They do not change how inventory value is established.

Repeated reconciliation issues indicate structural misalignment.


Financial consequences

Incorrect inventory valuation leads to overstated margins, unstable COGS, and unreliable financial reporting.

This affects:

  • Profitability analysis

  • Decision-making

  • Audit readiness

If financial reports cannot be trusted, system alignment must be reviewed.


What a clean system looks like

A clean system reflects fully aligned transactions across receiving, invoicing, cost allocation, and accounting integration.

This includes:

  • Interim balances resolved through completed workflows

  • Landed costs allocated before closing purchase orders

  • No manual accounting overrides

  • Transaction timing aligned across systems


Diagnostic indicators

Recurring discrepancies are not isolated errors. They are signals of system misalignment.

Common indicators include:

  • Margin volatility without operational change

  • Inventory not matching the balance sheet

  • Persistent interim balances

  • Repeated reconciliation adjustments

If these patterns exist, a system-level diagnostic is required.


The system is doing exactly what you told it to do

Margins do not break because reports are wrong.

They break because the system producing those reports is misaligned.

If your margins do not reflect reality, the issue is not reporting. It is how inventory value is being established across receiving, invoicing, and accounting integration.

Start with a Purchasing and COGS Accuracy Audit to identify where valuation logic, transaction timing, and system mapping are misaligned and restore financial accuracy through correct transaction alignment.


Restoring Stability in a Cin7 Month-End Close

When close repeatedly becomes investigative rather than confirmatory, structural review is often required.

If your Cin7 month-end close consistently exposes late-stage volatility, governance review and integration alignment may be necessary.

Learn how Fiskal Finance supports post-go-live Cin7 integration alignment and accounting stability.

A Stable Month-End Close Is a System Outcome

Month-end close reflects how a business operates daily.

When upstream processes are disciplined and the Cin7 finance workflow is clearly understood, reconciliation confirms reality. When governance drifts, close becomes investigative.

Sustainable improvement comes from alignment, not from forcing numbers to match at the end of the month.

Need Support With Your Cin7 and Xero or QuickBooks Integration?

Learn how Fiskal supports post-go-live Cin7 and Xero or QuickBooks environments.

Where close stability, reconciliation clarity, and integration governance require structural alignment.

📞 Or call us directly: (954) 415-7895

Share on your socials.