Import Landed Cost Calculator Excel Template
Landed cost is the total cost of getting imported goods to the point where they are ready to sell or use. It usually goes beyond the supplier invoice.
Typical import landed cost components
- Purchase value
- International freight
- Insurance
- Customs duties
- Import taxes
- Origin and destination charges
- Local transport and handling
Calculating these items in one workbook helps buyers and logistics teams understand the real cost per unit before setting prices or approving a purchase.
Basic landed cost formula
Landed cost = purchase value + freight + insurance + duties + import taxes + origin/destination charges + local transport and handling.
If you only need a quick starting point, use the free landed cost quick calculator.
What the ImportVista calculator includes
The professional workbook combines total landed cost, cost per unit, currency conversion, duties, taxes and a target selling price based on margin. It also keeps a historical log of multiple operations and a dashboard for quick review.
View the Landed Cost Calculator Excel Template
For shipment tracking and documentation too, see the Essentials Pack.
FAQ
Can I calculate landed cost in Excel?
Yes. Excel is suitable for combining purchase, freight, duty, tax and local-charge inputs into a total and cost-per-unit calculation.
Does the template calculate official customs duties automatically?
No. Duty and tax treatment depends on the product, country and transaction. Enter the applicable rates or amounts after verifying them for your operation.