The Margin Mystery: Profitable On Paper, Broke In The Bank

Every product business hits this one. The P&L looks fine, gross margin sits where it should, and yet cash never quite matches what the reports promise. The instinct is to blame pricing, or the market, or a slow season. It's almost never any of those things.

In a Cin7 environment, this pattern almost always traces back to landed cost. landed cost means the full cost of a unit of inventory by the time it's sellable, and Cin7 only calculates what it's told. Most setups are missing pieces of the real cost of getting inventory onto the shelf, and that's the problem.

Fixing it means going back to how costs enter Cin7 in the first place.

What Landed Cost Includes, And What Cin7 Assumes You've Entered

Landed cost is the full cost of a unit of inventory by the time it's sellable. That includes purchase price, freight, customs duties, insurance, handling fees, and currency conversion costs where applicable.

Cin7 calculates landed cost accurately from what's entered. Nothing more. If freight gets coded to a general expense account instead of attached to the PO, Cin7 never sees it. If duties get paid outside the purchasing workflow, through a separate broker invoice that nobody links back to the order, the system has no way to allocate that cost to the units it belongs to. The result is a landed cost figure that looks complete but is quietly understated, and a margin that looks better than it is.

How Cin7 Calculates Landed Cost, Step By Step

Cin7 builds landed cost in layers. Unit cost starts as the subtotal of the line item divided by the quantity received. From there, Cin7 adds the unit's share of additional costs paid to the supplier, freight and surcharges minus any discount, divided by the total quantity ordered across all line items on that purchase order. It then allocates any additional costs paid to third parties, brokers, freight forwarders, customs agents, based on the distribution method selected.

Take a simple example. A purchase order brings in 500 units at $10 each, with $750 in freight and a separate $250 customs invoice from a third party. Unit cost starts at $10. The freight share adds 1.50perunit(750 divided by 500). The third-party allocation adds another $0.50 per unit if distributed evenly. Landed cost lands at $12 per unit, not $10. If that freight or customs cost never gets attached to the order, Cin7 reports $10 and every downstream margin calculation is wrong by 20%.

Expense Distribution Methods, And Why Picking The Wrong One Skews Every Product's Margin

Cin7 offers several ways to distribute additional costs across a purchase order: by cost, by quantity, by weight, or by volume. Each one produces a different landed cost per SKU, and the right choice depends entirely on what's driving the cost in the first place.

If freight is priced by container space, weight or volume-based distribution reflects reality far better than an even split by quantity. If duties are calculated as a percentage of invoice value, cost-based distribution is the accurate choice. Businesses that default to quantity-based distribution because it's the simplest option often end up overcosting light, low-value SKUs and undercosting heavy, high-value ones. Every product's margin shifts, and nobody notices until pricing becomes indefensible.

The Domino Effect: How Landed Cost Errors Quietly Wreck COGS Snd Pricing

Landed cost isn't an isolated number. It feeds directly into cost of goods sold, and COGS feeds directly into gross margin, and gross margin feeds directly into pricing decisions. A landed cost that's understated by $1.50 per unit doesn't stay contained. It understates COGS, inflates reported margin, and eventually leads to pricing decisions built on a number that was never accurate, so the price on the shelf reflects a cost that was wrong from the start.

This is the domino effect behind the margin mystery. The P&L looks healthy because every number downstream of the landed cost error inherited the same mistake. By the time it shows up in cash flow, the root cause is months old and buried under dozens of transactions.

A Practical Audit: 5 Places to Check Your Cin7 Landed Cost Setup Right Now

Start with purchase orders from the last quarter and check whether freight costs are attached to the order or sitting in a general expense account, check whether third-party costs like customs and brokerage are linked back to the originating PO or floating as unrelated bills, review which expense distribution method is selected and whether it matches how that cost behaves, by weight, volume, cost, or quantity, compare landed cost per unit against the original supplier quote for a handful of SKUs and flag anything that looks too close to the base purchase price, and check whether currency conversion is being captured at the actual settled rate, not an estimated or default rate that never gets corrected. This audit needs to connect to how landed cost tracking is configured across your setup in how landed cost tracking is configured.

When to Bring In A Cin7 Specialist, And What That Fixes

Auditing landed cost once is useful. Building the governance that keeps it accurate every purchase order, every quarter, is where the real work lives. That means mapping rules for freight and duty allocation and setting a review rhythm that catches drift before it compounds into a pricing problem, the same discipline we cover in why Cin7 systems get worse over time without governance. On one implementation, freight costs were landing in a general expense account instead of the purchase order, understating landed cost on every affected SKU by more than a dollar a unit until the mapping was corrected. For example, Fiskal builds this governance as part of Cin7 implementation and controlling work, mapping the freight and duty allocation rules for a client and setting the quarterly review cadence, so landed cost stops being a quarterly surprise and starts being a number you can build pricing decisions on.

Frequently Asked Questions

What is landed cost in Cin7?

Landed cost in Cin7 is the total cost of a unit of inventory by the time it's ready to sell, including purchase price, freight, duties, insurance, and handling fees. Cin7 calculates it automatically from purchase order data, but only for the costs that are actually entered against that order.

Why does my Cin7 margin not match my actual profit?

This usually happens when costs like freight, customs, or brokerage fees are entered outside the purchase order workflow instead of attached to it. Cin7 then calculates landed cost using incomplete data, which understates COGS and overstates margin on every affected SKU.

What expense distribution methods does Cin7 support?

Cin7 supports four methods: by cost, by quantity, by weight, and by volume. The right method depends on how the underlying cost behaves, for example weight-based distribution suits freight priced by container space, while cost-based distribution suits duties calculated as a percentage of invoice value.

How often should I audit my landed cost setup in Cin7?

A quarterly audit catches most drift before it compounds into pricing errors. Businesses with high purchase order volume or frequent supplier changes benefit from a monthly check on freight and third-party cost allocation.

Can a wrong landed cost setup affect COGS and pricing?

Yes. Landed cost feeds directly into cost of goods sold, which feeds directly into gross margin and pricing decisions. An understated landed cost inflates reported margin and can lead to underpricing products for months before the error surfaces in cash flow.

Run a Cin7 Core Health Check

If your Cin7 setup has not been reviewed since a channel launch, a warehouse change, or a staff transition, a Diagnostic Call can identify where configuration may have drifted from how the business now operates, before it shows up in reconciliation or margin reporting.

Share on your socials.

Finance Ops:
Bookkeeping
Controlling
FP&A
Industries

Why Fiskal:
About us
Customer Stories
Careers
Contact Us

Contact Details:
+1 (954) 415-7895 or +1 (267) 717-7923
info@fiskalfinance.com
Offices:
Florida
New York
Pennsylvania
Stellenbosch

Resources
Blog
The Fiskal Score
Cin7 Academy
FAQs
Privacy Policy

Cin7 Solutions:
Problems We Solve
Integrations
Report Accuracy
Forecasting & MRP
Cin7 Implementation
Cin7 Support