Building a landed-cost sheet your whole team can use

Ask sales what a product costs and they'll usually quote the supplier's unit price. Ask finance and you'll get a fuller number, buried somewhere in a spreadsheet only finance opens, with freight and duty allocated in a way nobody else on the team could reproduce. Neither number is wrong, exactly — they're just answering different questions, and a pricing decision made on the sales number instead of the finance one is how margin quietly disappears between the quote and the bank statement.

A landed-cost sheet exists to close that gap: one per-unit number, built from product cost plus every cost of actually getting that unit into your warehouse ready to sell, that sales, purchasing, and operations can all read the same way without needing finance to translate it for them. The hard part isn't the arithmetic. It's designing the sheet so the number stays trustworthy once people other than the person who built it start using it.

Key Takeaways

• Landed cost is product cost plus freight, insurance, customs duty, clearance and handling fees, and inland transport to your warehouse — all expressed per unit, not per shipment.
• A sheet that only finance can read gets used by finance only, which means sales and purchasing keep pricing and buying off an incomplete number.
• Costs that apply to a whole shipment covering multiple SKUs have to be allocated down to each product using a consistent method — by weight, volume, or value — and switching methods between products is the most common source of numbers that don't reconcile.
• Freight rates and duty exposure change often enough that a landed-cost sheet needs a refresh cadence, not a one-time build.
• The most durable sheets separate a standard (estimated) cost used for day-to-day pricing from actual costs reconciled after each shipment lands, rather than pretending the estimate and the actual are the same thing.
• The landed cost calculator is the fastest way to sanity-check a per-unit figure before it goes into a shared sheet as the reference number.

What actually belongs in landed cost

Landed cost is everything it costs to get a unit of product from the supplier to a state where it's sitting in your warehouse ready to sell, expressed on a per-unit basis. That includes the supplier's unit price (whether quoted ex-works, FOB, or another Incoterm — which matters, because it changes what's already included, since under an ex-works term the buyer picks up freight and export clearance that a FOB seller would already have absorbed (International Chamber of Commerce — Incoterms 2020 rules, retrieved 2026-09-11)); international freight, whether by sea, air, or road; cargo insurance; customs duty, calculated against the correct HS code and customs value rather than a rough percentage guess — UAE customs duty is assessed on the CIF value under a 12-digit HS code within the GCC Integrated Customs Tariff (Federal Authority for Identity, Citizenship, Customs & Port Security — Central Customs Tariff System, retrieved 2026-09-11); customs clearance and agency fees; port or terminal handling charges; and inland trucking from the port or airport to your own warehouse. Less obviously, but just as real, is the carrying cost of capital tied up in transit — cash paid to a supplier and sitting in stock on the water for weeks before it can be sold isn't free, even if nobody's invoicing you for it directly.

Leaving any of these out doesn't make the cost disappear, it just moves the surprise later — usually to the point where someone in finance notices margin is thinner than the pricing model said it should be, several months and several shipments after the pricing decision was made.

Why one shared sheet matters more than a more sophisticated one

The instinct in most small trading businesses is for finance to own landed cost, refine it over time, and hand a summary number to whoever asks. That works until the business has more than one person setting prices or placing purchase orders, at which point the summary number becomes a bottleneck and the people who actually need the detail — why is this SKU's landed cost higher than that one, what happens to margin if freight rates move — don't have it.

Sales needs a landed cost they can quote against with confidence, not a rounded number handed down periodically. Purchasing needs to compare suppliers on total delivered cost, not just unit price, because a cheaper unit price from a supplier with a longer, costlier freight lane can easily land more expensive overall. Operations needs the cost breakdown to know which line item is actually driving cost up when a shipment comes in over budget — freight, duty, or handling — rather than a single blended number that hides which one moved. None of that requires a more sophisticated model than finance already has. It requires the same model built so someone outside finance can open it, understand it, and trust the number without a walkthrough.

Structuring the sheet so it holds together

The sheet works at two levels: shipment level, where costs like freight and insurance apply to the whole container or airway bill, and SKU level, where those shipment-level costs have to be allocated down to a per-unit figure for each product actually inside it. That allocation step is where sheets most often break. A container holding ten different SKUs of different sizes, weights, and values needs a consistent rule for splitting the freight bill across them — commonly by weight, by volume (cubic metres), or by value — and each method produces a different per-unit answer. Weight-based allocation is straightforward but can overstate freight cost on light, low-value items shipped alongside heavy, high-value ones. Value-based allocation does the opposite. There's no universally correct method, but there is a correct rule for your own sheet: pick one, document why, and apply it consistently, because a sheet where different SKUs were allocated using different logic will never reconcile back to the shipment's actual total cost, and nobody will be able to explain why two similar products show different margins.

Build the sheet with clear input cells for the numbers that change shipment to shipment — freight quote, duty rate, insurance premium — separated from the calculation cells that turn those inputs into a per-unit output. Locking the calculation logic and leaving only the inputs editable is what makes a sheet safe to hand to someone outside finance: they can update what changed without being able to accidentally break the formula underneath.

Keeping the numbers honest as freight and duty move

Freight rates, in particular, move enough that a landed-cost sheet built once and left alone drifts out of date within a quarter or two, quietly overstating margin on every quote based on it — container spot rates on some lanes moved by double-digit percentages within a single month during 2026 (S&P Global Commodity Insights — Containers Quarterly, retrieved 2026-09-11). The more durable approach is to run two versions side by side: a standard cost, used for day-to-day pricing decisions and quotes, updated on a set schedule rather than after every shipment; and an actual cost, reconciled against each shipment's real freight, duty, and handling invoices once it lands. The gap between standard and actual is itself useful information — a standard cost that's consistently running under actual means quotes are being priced too thin, and it's better to catch that pattern from the reconciliation than from a shrinking bank balance. Use the landed cost calculator to check a specific shipment's actual per-unit cost whenever a reconciliation looks off, or before setting a new standard cost for a product whose freight lane or duty treatment has changed. Building that refresh cadence into how the business actually runs, rather than leaving it as a one-off spreadsheet someone built once, is core operational groundwork, which is exactly what the operations setup guide is there to help put in place.

Frequently asked questions

Should landed cost include the cost of capital tied up in transit?

It's worth including, or at minimum tracking separately, for any product with a long freight lane or a slow-moving SKU, because cash sitting in stock on the water for weeks is a real cost even without a specific invoice attached to it. For fast-moving, short-lane products the effect is small enough that many businesses leave it out of the headline landed cost and note it separately instead.

How do we allocate freight cost across different SKUs in the same shipment?

Choose one consistent method — by weight, by volume, or by value — and apply it to every SKU in every shipment rather than switching between methods depending on what looks best for a given product. Weight and volume-based allocation tend to suit shipments where item density varies a lot; value-based allocation tends to suit shipments of broadly similar-sized goods at very different price points.

How often should the landed-cost sheet be updated?

Set a fixed schedule for updating the standard cost used in day-to-day pricing — monthly or quarterly is common — and reconcile against actual costs after every shipment lands, rather than waiting for someone to notice margin looks off. The reconciliation step is what tells you whether the standard cost still holds or needs updating sooner than scheduled.

Who should own the landed-cost sheet if more than one team uses it?

Ownership of the inputs and the calculation logic should stay with one person or team — usually finance or operations — so the formula doesn't drift, but the output should be visible and understandable to sales and purchasing without needing that owner to interpret it for them every time.

The bottom line

A landed-cost sheet only does its job if the people making pricing and purchasing decisions actually use it, and that depends more on how clearly it's built than on how sophisticated its formulas are. Get the components right, allocate consistently, and separate the standard estimate from the reconciled actual, and the same sheet works for sales, purchasing, and finance without three different versions of the truth.

Figures were verified on 11 September 2026 against the International Chamber of Commerce, the UAE Federal Authority for Identity, Citizenship, Customs & Port Security, and S&P Global Commodity Insights. Freight rates and duty treatment change often enough that inputs should be re-checked against your own broker before pricing a shipment.