Landed Cost Spreadsheet: How to Calculate Import Costs in Excel

A landed cost calculation answers a simple but important question: what does an imported product really cost by the time it reaches your business?

What to include in landed cost

A practical landed cost spreadsheet normally brings together the purchase value, international freight, insurance, customs duties, taxes where applicable, destination charges, local transport and other operation-specific costs.

Why cost per unit matters

The total shipment cost is useful, but many purchasing decisions depend on cost per unit. Divide the total landed cost by the number of units received to estimate the real unit cost before setting margins or comparing suppliers.

A simple Excel workflow

  1. Enter the purchase value and currency.
  2. Add freight, insurance and origin/destination charges.
  3. Enter the applicable duty and tax assumptions.
  4. Add local delivery or other charges.
  5. Calculate total landed cost and unit cost.

Keeping each cost component visible makes the calculation easier to review and update when a quote changes.

Use a ready-made template

The ImportVista Landed Cost Calculator includes a quick calculator, dashboard, historical operations and unit-cost calculations in Excel.

If you also need shipment tracking and document control, the Essentials Pack combines all three tools.