Landed cost worksheet

Freight Cost Allocation Calculator by SKU

Allocate shared freight, insurance, handling, and other shipment costs across up to five SKU lines using goods value, quantity, weight, or an equal-per-line basis.

Last reviewed: 2026-07-07Estimate onlySource-check required
Tool Widget

Enter shipment or catalog details

Free browser worksheet: allocate a single shipment across up to five SKU lines. Your entries stay in this browser and can be downloaded as a CSV.

Use one consistent basis for the whole shipment. The result is a repeatable cost-allocation record, not a customs filing decision.

SKU lines

Record the products in this shipment

SKU line 1

For a goods-value basis, use quantity × unit goods value. For a weight basis, record each line's shipment weight in the same unit. The tool does not convert currencies or weights.

SKU cost allocation worksheet

Run the tool to see an itemized result. No signup is required and calculator inputs are processed in the browser unless you submit a correction form.

AI Answer Block

What this page answers

Question

How do I allocate freight cost across multiple SKUs?

Enter the shared shipment costs and SKU lines, select the basis your finance or customs workflow uses, then download the reconciled worksheet. Verify whether any cost belongs in customs value under the actual destination rules before filing.

Formula / Criteria

What to check

Allocated shared cost for a SKU = total shared shipment cost × (that SKU's selected allocation base ÷ all SKU allocation bases). The tool keeps the chosen basis visible and confirms that the line allocations reconcile to the shipment total.

Use This Tool

When to use it

Use this before setting SKU-level landed-cost assumptions, comparing product margins, or preparing a multi-line catalog and document review.

Official Source Note

Source-check required

Cost allocation can be useful for an internal landed-cost worksheet, but it is not a universal customs valuation rule. Check the destination authority's valuation guidance and the shipment documents before filing.

Last Reviewed

2026-07-07

Official source notes and calculator assumptions should be reviewed before shipment, label purchase, invoice filing, or customs entry.

Official References

Check source data before filing

Formula / Criteria

Calculation logic

Allocated shared cost for a SKU = total shared shipment cost × (that SKU's selected allocation base ÷ all SKU allocation bases). The tool keeps the chosen basis visible and confirms that the line allocations reconcile to the shipment total.

Example

Scenario

A shipment has USD 600 of shared freight, insurance, and handling across three SKU lines. A value-based allocation gives each SKU a share of that USD 600 based on its goods value, then shows the resulting allocated cost per unit.

Source Note

Official check

Cost allocation can be useful for an internal landed-cost worksheet, but it is not a universal customs valuation rule. Check the destination authority's valuation guidance and the shipment documents before filing.

Limitations

Filing check

This tool provides planning estimates and document preparation support only. Confirm final classifications, duty treatment, and filing requirements with official tariff databases or qualified trade professionals.

FAQ

Common questions

Which allocation basis should I choose?

Use the basis your internal cost policy, accounting workflow, broker, or destination guidance calls for. Goods value, quantity, weight, and equal-per-line allocation can produce different results.

Does this decide customs value?

No. The worksheet allocates shared shipment costs for preparation. Customs valuation inclusions and exclusions depend on the destination rules and transaction facts.

Can I allocate insurance and handling too?

Yes. The tool adds freight, insurance, handling, and another shared cost into one visible shared-cost total before allocating it.

Why does the tool flag a missing SKU weight or value?

A missing field can distort a weight- or value-based allocation. Add the missing fact or select another documented allocation basis.

Can I download the result?

Yes. After calculation, download a local CSV worksheet with the inputs, allocation percentage, allocated shared cost, and per-unit total.

What is the free limit?

The browser worksheet accepts up to five SKU lines and does not require an account. It does not upload, save, or send the data anywhere.

Prepare more SKUs with free tools

Use the AI HS Code Finder, CSV Catalog Checker, and Import Duty Calculator to prepare customs data before shipping.