The Landed Cost Formula
Landed cost per unit = (goods + allocated freight, insurance and fees + duty) / quantity. The per-unit part is what most quick calculations skip. A $500 freight charge on a mixed invoice does not belong to the order as a whole; it belongs to each unit on it, in proportion. Until you push the freight down to the unit, you do not know what any single product cost you, and every margin built on the invoice cost is overstated.
Worked example: a three-line gift invoice
Goods: 24 x $6.50 = $156.00, 12 x $8.00 = $96.00, 50 x $1.25 = $62.50; total $314.50Freight $42.50 by value: 156 / 314.50 x 42.50 = $21.08 to the mugsLanded unit (mugs) = (156.00 + 21.08) / 24 = $7.38Selling price at 50% margin = 7.3783 / 0.5 = $14.76
The mugs cost $7.38 landed, not $6.50, and need a $14.76 price to keep a 50% margin.
Worked example: a UK import with duty and VAT
100 units at $10.00, exchange rate 0.79: goods = £790.00Freight £100, insurance £10: customs value (CIF) = £900.00Duty at 5% = £45.00Import VAT at 20% on (900 + 45) = £189.00, reclaimableLanded unit = (790 + 100 + 10 + 45) / 100 = £9.45
Each unit lands at £9.45. The £189 import VAT is cash out on arrival but comes back on your VAT return.
Import Duty Calculator for UK Imports
For goods coming into Great Britain, the calculator works as an import duty calculator once you have the duty rate. The rate comes from the UK Trade Tariff: look up the commodity code for each product and use the third-country rate, or the preferential rate if the goods qualify under a trade agreement and you hold proof of origin. Many EU-made goods enter at 0% under the UK-EU Trade and Cooperation Agreement for that reason.
Duty is worked out on the customs value, which in the UK is the goods plus freight and insurance to the border (CIF), so choose the CIF basis above. Import VAT is then charged on the customs value plus the duty. The importer on the declaration needs a GB EORI number; check yours or a supplier's with the EORI number checker.
Why Allocation Method Matters
By value spreads freight in proportion to each line's share of the goods total. It is the right default when a carton of expensive items and a carton of cheap ones weigh about the same, because the expensive goods usually drive the insurance and handling cost. By units spreads freight evenly per piece, which fits when every unit takes similar space, like case-packed drinks or uniform cartons.
By weight is the most physically accurate method for heavy, dense freight, but it needs a weight per line, and vendor invoices rarely carry it. If your invoice lists weights, use them. If not, by value is the standard fallback and the one most accounting teams expect.
| Method | Use it when |
|---|---|
| By value | Mixed goods of similar size; the accounting default |
| By units | Uniform cartons or case-packed goods |
| By weight | Heavy or dense freight, and the invoice lists weights |
Penny-Exact Allocation
Split $100 of freight three ways and a naive percentage gives each line $33.33: the invoice is a penny short. Across a 40-line invoice, rounding each share on its own can drift several cents either way. That matters the moment the numbers post to a product catalogue, a POS or a GL account that must tie back to the freight on the invoice. This calculator allocates in whole cents and hands the leftover pennies to the lines with the largest remainders, so the shares always add up to the charge you entered.
From Landed Cost to Shelf Price
Landed cost is the number to price from, because it is what the unit actually cost to get onto your shelf. Set a target margin and the calculator solves price = landed / (1 - margin), the correct direction of the formula. For shelf prices with VAT and .99 endings, use the retail price calculator; to check what a price earns, the margin calculator. Shipping by sea? The CBM calculator works out container fit.
From Vendor Invoice to Priced Catalogue
This is the calculation buyers do by hand when a vendor invoice arrives with wholesale costs and no retail prices: type the lines into a spreadsheet, spread the freight, divide by quantity, apply a margin. OrderSync extracts the lines from the invoice so the costs are ready the moment the document lands. Try the invoice extractor on a real document, or see how multi-format document processing handles every format a vendor can send.