Goods cost
Quantity × supplier unit cost
Match the quantity to the unit your supplier priced. A price per carton needs a quantity in cartons.
Free shipment allocation worksheet
Landed Cost Calculator
One freight bill, several products. Allocate the shipment’s shared costs and see the landed cost for every SKU and unit.
One shipment
Start with your products
Use the supplier price for one unit. Add another SKU only if your shipment needs it.
Shared shipment charges
Amounts for the whole shipment. Count each charge once; blank optional charges mean 0.
Insurance, clearance & other costs Optional
Choose how costs are split
Split in proportion to quantity × supplier unit cost. A higher-value row receives a larger share. All five shared charges use this basis.
Currency is a display label. Values are not converted. Examples use made-up costs.
Private to this tab. Your costs and SKU names are not sent or saved automatically.
From a shipment invoice to a usable unit cost
The supplier’s unit price is only the goods cost. Shared freight and fees belong to the whole shipment; this worksheet assigns them to each SKU using your selected basis. Enter row duty and included tax amounts separately, once. Every allocated charge and SKU total reconciles to the shipment.
Shared charge quota
Charge × SKU basis ÷ total shipment basis
The selected basis assigns a share to every SKU. Each charge is then reconciled to whole cents.
SKU landed total
Goods + allocated shared charges + entered duty + included tax
Only the costs you enter are included. Duty and tax are row amounts you have already determined.
Two products, one freight bill
These synthetic figures show why the allocation basis changes a SKU’s cost while keeping the shipment total the same.
USD 300 goods + USD 30 freight
Ten small items cost USD 10 each; ten large items cost USD 20 each. Purchase value assigns one-third of the freight to the small items and two-thirds to the large items.
Small item / SKU A
100.00 goods + 10.00 freight = 110.00 landed total.
110.00 ÷ 10 units = USD 11.00 per unit.
Large item / SKU B
200.00 goods + 20.00 freight = 220.00 landed total.
220.00 ÷ 10 units = USD 22.00 per unit.
110.00 + 220.00 = USD 330.00 shipment total
Change the split to Units
Each ten-unit row receives USD 15 freight. The small item becomes USD 11.50 per unit and the large item USD 21.50. Their totals, USD 115 + USD 215, still reconcile to USD 330. The example also supplies made-up total row weights of 1 kg / 3 kg and volumes of 0.5 m³ / 1.5 m³ so you can compare all four bases.
Keep the next decision clear
These printable references connect a checked cost to the next question. They use synthetic examples and work without entering your shipment details.
Pricing decision sheet
Carry a reconciled unit cost into the appropriate markup, margin or wholesale calculation. Check which selling costs still need to be included.
Download pricing sheetInventory replenishment map
Separate your stock buffer, order trigger, order quantity and arrival-date checks before reviewing the chosen shipment.
Download inventory mapBefore you use the cost for pricing
Which allocation basis should I use?
Use a basis that reflects the charge and your consistent costing approach. Units treats every piece equally; purchase value follows supplier spend; weight and volume follow the total physical measure for each row. The default is a starting selection, not a universal rule. All shared charges use the same basis in this worksheet.
Should I include every tax I paid?
Enter only the amount you want included in this cost basis. A tax that you recover may belong in your cash-flow records rather than the included cost; confirm its treatment for your own records. This worksheet accepts your chosen amount and does not decide tax recoverability.
Can I mix currencies or pack sizes?
Convert costs to one chosen currency before entering them; no exchange rate is supplied. Match quantity to the supplier unit price. Under Units, a carton and a loose piece count equally unless you first express them in comparable units. Weight or volume may fit a mixed shipment better.
Why does a cent go to one SKU?
Each shared charge must add back to its entered amount. The worksheet floors the exact quotas, then assigns remaining cents to the largest remainders. Equal remainders use the row order. Each fee is handled separately, so several tied residual cents can go to the same row.
What should I do with the landed unit cost?
Use it as the included cost basis for the next pricing decision. Keep any additional selling costs separate and count each expense once. The Wholesale, Markup and Profit Margin tools answer different pricing questions from that cost.
Calculation rules, supported values & sources
- All costs use the same selected display currency. USD, EUR, GBP, CAD, AUD and PKR use two-decimal amounts here; the currency selector does not convert values.
- One allocation basis applies to all five shared charge buckets. Weight is total kilograms for the SKU row; volume is total cubic metres. Neither is multiplied by quantity again.
- Each shared charge is allocated independently to exact cents. Quotas are floored, then residual cents follow the largest exact fractional remainders. Ties follow the original row order.
- Purchase value can include a zero-value row with zero share. An all-zero value basis is unavailable; choose Units if it matches your shipment. Every row needs a positive selected weight or volume, even when shared charges are zero.
- Required quantities and supplier unit costs cannot be blank. Blank optional charges are excluded and use zero. Duty and included tax are amounts entered for the row, not rates calculated by this tool.
- Quantity accepts 1–1,000,000,000 whole units. Money inputs accept 0–999,999,999.99 with two decimals; physical measures accept positive values through 999,999,999.999999 with six decimals. Up to 50 SKU rows and a derived shipment total through 999,999,999,999.99 are supported.
- Displayed unit costs round half-up to two decimals. The exact SKU total is authoritative; multiplying a rounded unit cost by its quantity may not reproduce that total.
- Each active numeric entry accepts up to 64 characters, including whitespace and leading zeros; longer entries are rejected without truncation. Unselected physical entries are ignored and marked NOT_USED in exports.
- CSV includes UTF-8 text, exact cents and each unit divisor. A reversible safety prefix is identified in csv_prefix_added_columns. The printable PDF supports basic Latin SKU names; use CSV to preserve other scripts.
- This is a costing worksheet using your inputs. It has no HS lookup, automatic tariffs, country tax defaults, FX service, recoverability determination or supplier integration.
International Trade Administration — Determine Total Export Price — Goods, freight, insurance, duty, taxes and other fees can contribute to landed cost. Its route-specific examples are not used as defaults.
IFRS Foundation — IAS 2 Inventories overview — General inventory-cost context for bringing goods to their present location and condition. This worksheet’s allocation and cent rules are disclosed product conventions, not professional review.