Landed cost: the complete guide for inventory businesses
Your supplier invoice says $10 a unit, yet the margin report and the bank account keep disagreeing. This guide covers what landed cost includes, how to calculate and allocate it, and how to keep it clean in your inventory and accounting systems.

On this page
- What is landed cost and what does it include?
- Why does landed cost go wrong in the first place?
- How does Cin7 Core allocate landed cost?
- Which allocation method should you use?
- Where should landed cost sit in QuickBooks Online and Xero?
- Patch, reconfigure, or rebuild: what does your setup need?
- What can you do this week to fix landed cost?
- Frequently asked questions
TL;DR
- Landed cost is what a unit really costs once it is sellable: supplier price plus freight, duties, insurance, brokerage, and handling, so any cost that stays on a separate bill in expenses leaves margin overstated.
- Cin7 Core allocates additional costs proportionally to each line's cost by default, and the cost only reaches inventory value when the account on the additional cost matches the inventory account.
- QuickBooks Online and Xero have no native landed cost allocation, so the allocation happens in Cin7, a worksheet, or an app, and the accounting system receives the result.
- A freight or duty invoice that arrives after units have sold does not rewrite the old sale. It posts as a separate adjustment in the current period, which is why margin can move in a month when nothing moved in the warehouse.
- The setup only holds if one named person owns how freight and duty bills are coded, with one clearing rule and a month-end check that every shipment's extra costs have been allocated.
In the Cin7 setups we audit, the pattern repeats. The supplier invoice looks right, then freight and duty land on expense. The supplier invoice says $10 a unit, the margin report looks healthy, and then a freight bill, a customs broker invoice, and a trucking invoice turn up on different days from three different vendors. Each one gets coded to expense because that clears the inbox fastest. Gross margin looks strong, cash looks thin, and nobody can say why.
This guide covers what landed cost includes, how to calculate it, how the allocation choice changes your unit costs, and where the cost should sit in Cin7 Core and QuickBooks Online or Xero. It ends with a checklist you can run this week. Where a deeper Cin7 walk-through already exists, we link to it instead of repeating it.
What is landed cost and what does it include?
Landed cost is what a unit really costs once it is sellable. It starts with the supplier price and adds everything it took to get the goods to your shelf.
That usually means international freight, insurance, customs duties, brokerage fees, inland trucking, and handling. QuickBooks lists shipping, customs duties, insurance, and miscellaneous items as the costs that landed cost factors in, and the logic holds whatever system you run.
The formula is simple addition: product cost, plus freight and insurance, plus duties and fees. The difficulty sits in the inputs, because those charges arrive on different invoices, from different vendors, on different dates.
A worked example with round numbers
Take an illustrative order of 1,000 units at $20 each. Add $1,800 of freight, $200 of insurance, $600 of brokerage, and a $2,400 duty bill. The shipment moves from $20,000 to $25,000, or $25 per unit. If only the $20 reaches inventory, every unit sold carries $5 of cost that sits in overhead, and gross margin is overstated by exactly that amount.
Why does landed cost go wrong in the first place?
Landed cost goes wrong because the costs live on separate bills, and the system only counts what it is told. A freight invoice coded to a general expense account never touches inventory value, and no error message appears.
Three patterns repeat across the Cin7 setups we audit. Landed cost sits in expenses instead of inventory. Duty is paid through a broker outside the purchasing workflow, so nobody links it to the order. And a freight invoice lands after the goods have sold. The table below maps each symptom to its cause and fix.
| Symptom | Root cause | Fix |
|---|---|---|
| Gross margin looks strong, cash looks thin | Freight and duty coded to expense accounts | Route extra costs to the inventory account and allocate them to the purchase |
| Margin jumps in a month with no warehouse change | Freight invoice allocated after the units sold | Allocate on receipt, and review late invoices at month end |
| Inventory value is lower than the physical stock suggests | Additional cost account differs from the inventory account | Align the account on every additional cost line |
| Books and Cin7 disagree after a journal | Manual journal posted in accounting only | Correct the cost layer at source, then let the sync carry it |
That last row matters more than it looks. A manual journal in QuickBooks Online or Xero corrects the ledger, while the cost layers in Cin7 underneath stay as they were, so the same error returns next month. A reconciliation difference is rarely a reconciliation problem. It usually traces back to a cost that entered the system in the wrong place, which is the pattern our Cin7 Core and QuickBooks Online reconciliation guide walks through.
How does Cin7 Core allocate landed cost?
Cin7 Core, the inventory platform formerly called DEAR Systems, allocates landed cost proportionally to each line's cost by default, with options for quantity, weight, or volume. The account on each additional cost must match the product's inventory account, or stock value never rises.
Cin7's help centre states that the landed cost is not divided equally but allocated proportionally, based on each invoice line cost to the total invoice amount, and that the account on the additional cost must be the same as the inventory account for the products. Point it anywhere else and the cost never increases stock on hand value.
Timing is the second trap. When a freight or duty invoice is allocated after stock has sold, Cin7 Core does not correct the earlier sale. It posts a separate adjustment in the current period, so margin moves in a month where nothing moved in the warehouse.
For the full configuration, our guides to tracking landed costs in Cin7 and why margins do not add up go step by step. If a sale ships before the purchase invoice is authorised, the unit cost is wrong from day one, a pattern traced in why Cin7 unit costs stay wrong after fixes.
Which allocation method should you use?
Allocate on whatever drives the cost. Freight follows weight or volume, duty follows customs value, and insurance follows value. A single method applied to everything is the most common reason one SKU looks profitable when it is not.
Two products in one container make the point. A heavy, low-value item and a light, high-value item share one freight bill. Allocate by value and the light item absorbs most of the freight. Allocate by weight and the heavy item does. The same money produces two different answers about which product to push.
| Cost type | Usual driver | What to check |
|---|---|---|
| Ocean or air freight | Weight or volume | Are carton dimensions held on the product record? |
| Customs duty | Customs value by tariff code | Do mixed shipments carry different duty rates per line? |
| Insurance | Value | Is it allocated on the same basis as the goods? |
| Brokerage and port fees | Per shipment, spread by line cost or quantity | Does a single flat fee distort low-cost SKUs? |
| Inland trucking | Weight or pallets | Is it kept separate from outbound delivery to customers? |
Where should landed cost sit in QuickBooks Online and Xero?
Landed cost should end up in the inventory asset account in your accounting system, then move to cost of goods sold when the item sells. Neither QuickBooks Online nor Xero does the allocation for you.
QuickBooks has a landed cost feature, but its steps are written for QuickBooks Desktop Enterprise Platinum and Diamond with Advanced Inventory, and it is not designed to work with multiple currencies. Xero's guidance tells sellers to include landed costs, the product price plus inbound shipping, duties, and fees, in cost of goods sold, and its own product ideas board carries an open request to allocate freight and duty to inventory.
Allocate in Cin7 Core, where the purchase lives, then let the integration carry the result to QBO or Xero. Month-end reconciliation then confirms the two agree. Our guide to GRNI and GINR in Cin7 covers the clearing accounts where unresolved receipts and invoices collect.
Patch, reconfigure, or rebuild: what does your setup need?
Most fixes are one mapping. When purchasing, receiving, and accounting each follow different rules, the setup needs rebuilding. Diagnosing first is what separates a lasting fix from a deferral.
The Fiskal Score measures this across People, Systems, and Finance, including purchasing and receiving, inventory valuation, and the Cin7 to accounting integration. It shows whether a margin problem is a single mapping or a gap in how the team works. The setup only holds if one named person owns how freight and duty bills are coded.
What can you do this week to fix landed cost?
- List every cost that touches a shipment. Pull the last three shipments and mark each invoice: supplier, freight forwarder, customs broker, insurer, trucker. Note which ones were coded to expense.
- Check the account on every additional cost line. In Cin7 Core, confirm it matches the inventory account of the products it is allocated against.
- Choose an allocation basis per cost type. Write it down: freight by weight or volume, duty by customs value, insurance by value.
- Set a rule for late invoices. Decide who allocates a freight or duty bill that arrives after units have sold, and how that adjustment is reviewed.
- Add a month-end clearing check. Every shipment's extra costs should be allocated or explained, and clearing accounts should reach zero.
- Assign one owner. A named person approves how freight and duty bills are coded, so accounts payable no longer decides it invoice by invoice.
- Re-run the margin report. Compare gross margin by SKU before and after allocation. The gap is the cost that was hiding in expenses.
If the checklist surfaces costs you cannot trace, our Cin7 onboarding audit checks sync errors, variances and connections across QBO, Shopify and your 3PL, then retrains the team on the process so it stays fixed.
Frequently asked questions
What is landed cost in simple terms?
Landed cost is the full cost of a unit by the time it is ready to sell. It is the supplier price plus freight, duties, insurance, brokerage, and handling, so a $10 item that costs $14 to land has a landed cost of $14.
How do you calculate landed cost per unit?
Add every cost on the shipment, then divide by the units received, allocating shared costs by the driver that fits each one. Freight usually follows weight or volume and duty follows customs value, so a single even split rarely gives a true unit cost.
Is landed cost the same as cost of goods sold?
No. Landed cost sits in inventory value until the item sells, then flows into cost of goods sold. If it is booked to expense on arrival, it hits the profit and loss before the goods are sold, which distorts both margin and inventory value.
Does QuickBooks Online or Xero calculate landed cost automatically?
Neither allocates landed cost across SKUs on its own. QuickBooks' landed cost steps are written for Desktop Enterprise with Advanced Inventory, and Xero has an open product idea for it. Most inventory businesses allocate in Cin7 Core or a worksheet, then post the result to the accounting system.
Why did my margin change when no stock moved?
A freight or duty invoice was probably allocated after the units sold. Cin7 Core posts that as a separate adjustment in the current period, so the earlier sale keeps its old cost while the current month absorbs the difference.


