Keep two ledgers separate: customs duty and valuation stay tied to the legal tariff lines and entry data; management allocation spreads shared commercial costs across SKUs for pricing and margin analysis.
Planning guidance only. It is not a customs ruling, tax opinion, legal advice or binding freight quotation. Verify current rules and shipment-specific rates before acting.
Key takeaways
- Allocate each shared cost using the driver that caused it; do not force freight, insurance, brokerage and prep through one denominator.
- Customs duty stays tied to the legal tariff line and customs entry; management allocation does not rewrite customs treatment.
- Every allocated column must reconcile back to the shipment-level invoice or charge.
- Keep estimated and actual allocations so SKU-level variance can be explained after arrival.
From supplier terms to cost per sellable unit
Why equal allocation can distort SKU economics
Imagine two SKUs in the same shipment: a small high-value electronic item and a large low-value home product. Splitting freight by customs value can overcharge the electronic SKU; splitting insurance by volume can do the opposite.
The goal is not to find one universal allocation key. The goal is to preserve the relationship between each shared cost and the factor that caused it, then document that method so the result can be repeated and audited internally.
Customs allocation and management allocation are not the same thing
A customs entry can contain multiple tariff lines with different classifications, values, duty rates and legal quantity bases. Do not take a blended shipment-level duty rate and spread it back across products as though the customs rules used that average.
For internal landed-cost analysis, shared commercial charges such as freight, insurance, brokerage or warehouse receiving can be allocated using a rational business driver. That internal allocation does not rewrite the customs value or duty legally declared for each line.
Choose the driver cost by cost
| Cost layer | Common allocation driver | Why |
|---|---|---|
| International freight | Weight, volume, chargeable weight or carrier rating basis | Transport cost is often capacity-driven |
| Cargo insurance | Declared / insured value | Premium commonly follows value |
| Ad-valorem duty | Actual customs value and duty result for each tariff line | Duty remains tied to the customs entry line |
| Specific duty | Units, weight or other legal quantity basis | Follows the tariff formula rather than a commercial allocation key |
| Broker / entry fee | Entry, line count or documented internal policy | Often not proportional to product value |
| Prep / labeling | Units actually requiring the service | Operationally unit-driven |
| Pallet / carton handling | Cartons, pallets or occupied space | Handling driver |
| General shipment minimum | Documented policy such as value, units or equal split | Use a stable rule and flag the arbitrary element |
Worked example: three SKUs, three allocation bases
Assume a mixed shipment contains SKU A, B and C. The forwarder invoice includes $2,400 freight, cargo insurance is $120 and the broker charges $300 for the entry. The shipment also has tariff-line-specific duty that has already been calculated from the customs entry.
Freight is allocated by chargeable weight, insurance by product value, and brokerage by the documented entry-line policy. Duty is not reallocated from a shipment average; each SKU keeps its actual tariff-line duty.
| SKU | Chargeable-weight share | Value share | Freight allocation | Insurance allocation |
|---|---|---|---|---|
| A | 50% | 20% | $1,200 | $24 |
| B | 30% | 50% | $720 | $60 |
| C | 20% | 30% | $480 | $36 |
| Check | 100% | 100% | $2,400 | $120 |
Brokerage and duty would be added using their own documented basis. Every allocated column must reconcile back to the original shipment-level invoice or customs record.
A hybrid method is usually more explainable than one blended key
If every shared cost is allocated by product value, bulky low-value products can look artificially profitable. If every cost is allocated by weight, high-value low-weight items can escape insurance or value-driven charges.
A hybrid method adds a little spreadsheet complexity but makes the unit economics easier to explain. Store the driver next to each cost line rather than burying the method in a formula.
Reconcile the allocation back to the shipment total
Calculate the shipment-level total for every shared cost from the final invoice or estimate.
Choose and document the driver for each shared cost.
Calculate each SKU share and confirm allocated amounts sum back to the original charge.
Add SKU-specific duty, tax or handling items from the legal or operational source.
Divide each SKU total by expected or actual sellable units, depending on whether the analysis is estimated or actual.
Retain the source invoice, allocation basis and reconciliation check with the scenario.
Estimated allocation and actual allocation should both survive
Before ordering, use estimated weight, volume, value and quantity to forecast SKU economics. After arrival, rebuild the allocation with the final freight invoice, actual packed dimensions or weights, customs entry and sellable quantity.
Do not overwrite the original estimate. Compare it with the actual allocation to find whether the variance came from freight, quantity, scope, customs or warehouse handling. See Estimated vs Actual Landed Cost.
Accounting cost assignment is a separate policy question
IAS 2 explains that inventory cost includes costs of purchase and other costs incurred in bringing inventories to their present location and condition, and it contains cost-assignment rules for accounting. That does not mean a landed-cost spreadsheet can automatically determine the accounting treatment for every brokerage, prep, storage or marketplace fee.
Use this guide for management allocation and supplier/SKU decisions. Reconcile financial-statement inventory and COGS treatment with the accounting framework and policy applicable to the business.
Use a one-SKU calculator without hiding the mixed-shipment logic
LandedScope’s flagship calculator is intentionally conservative: one SKU or tariff line at a time. For a mixed shipment, allocate the shared commercial costs first, then run each SKU with its allocated freight and shared-cost amounts. This keeps the legal duty line and the commercial allocation method separate.
Shared-cost allocation
SKU share = SKU driver ÷ total shipment driver Allocated shared cost = shipment shared cost × SKU share
Choose the driver separately for each cost: value, weight, volume, chargeable weight, units, cartons, lines or another documented policy.
Three-SKU allocation check
- Freight — shipment total
- $2,400
- SKU A — 50% chargeable-weight share
- $1,200
- SKU B — 30% chargeable-weight share
- $720
- SKU C — 20% chargeable-weight share
- $480
- Reconciliation
- $1,200 + $720 + $480 = $2,400
Insurance or brokerage can use different drivers. Duty should remain tied to each customs line rather than a blended shipment average.
Model one SKU after allocating shared costs
Allocate freight, insurance and shared charges first using documented drivers, then enter the SKU-specific allocated amounts into the calculator.
No values are prefilled — enter your own shipment facts and verified rates.What goes wrong — and how to correct it
| Risk | Common mistake | Why it matters | Correct action |
|---|---|---|---|
| HighDouble counted charges | Adding pickup, brokerage or final delivery again when an all-in quote already contains them. | The shipment total is overstated and supplier or forwarder comparisons become unreliable. | Record the quote scope line by line and assign each charge to one cost bucket only. |
| HighMissing customs inputs | Treating an unknown duty, customs value or import tax as zero. | The worksheet can show an artificially low per-unit cost while a critical input is still unresolved. | Keep the result incomplete until the classification, customs value and applicable rates are confirmed. |
| MediumWrong unit denominator | Dividing by ordered units when samples, defects or reserved stock are not sellable. | The unit cost is understated and the margin model inherits the same error. | Use the quantity reasonably expected to be sellable and keep the loss assumption visible. |
Topic-specific checks
- Allocating every shared cost by product value because it is easy.
- Averaging different tariff-line duty rates across all SKUs.
- Failing to reconcile allocated totals back to the original invoice.
- Overwriting the estimated allocation instead of comparing it with the actual shipment.
Pre-decision checklist
Use this immediately before you approve a quote, purchase order or shipment plan. High-risk items should not remain unresolved.
- HighSupplier price, quantity and Incoterm are confirmed on the same commercial basis.
- HighThe freight quote has a clear scope, destination and validity date.
- HighCustoms value is confirmed for the destination rather than copied from a generic worksheet.
- HighDuty, additional tariff measures and import tax are verified separately.
- MediumRecoverable VAT/GST is shown separately from permanent economic cost.
- HighBrokerage, destination delivery, prep and receiving are counted once only.
- MediumThe denominator is sellable units, not simply ordered units.
- MediumThe exchange-rate date and source are retained with the scenario.
Questions importers ask
Should I split freight by product value?
Only when value is a defensible proxy for the freight driver. Weight, volume or chargeable weight can be better for capacity-driven freight.
Can I use one allocation method for all costs?
You can, but it can distort SKU economics. A hybrid method is often more explainable because different costs follow different drivers.
Should I average the duty rate across all SKUs?
Not for customs treatment. Keep each tariff line tied to its own classification, customs value and duty result.
How do I check the spreadsheet is balanced?
The allocated SKU amounts for each shared invoice should sum back to the original shipment-level charge.
Should I update the allocation after arrival?
Yes. Keep the original estimate, then build an actual allocation from final invoices, customs records and sellable quantities so you can measure variance.
Official references
A reviewed link is not a shipment-specific customs ruling. Classification, origin, valuation and treatment still require verification for the actual goods.
Tariffs, tax treatment, valuation and freight rules can change by product, origin, destination and transaction. Verify the current official sources before acting.
Open official source registerStart from the worked assumptions, then replace them with your goods cost, actual freight quote and verified customs inputs. Missing critical inputs remain visible.