How is landed cost calculated in this template?

Landed cost is goods value plus international freight, insurance, duty, extra tariffs, brokerage and fees, and inland freight. For 1,000 units at 12.00 with 1,200 freight, a 5% duty on the 12,000 FOB value (600) and 600 of insurance, brokerage and handling, landed cost is 14,400, or 14.40 per unit. That matches the Landed Cost calculator for the same inputs.

Should duty be charged on FOB or CIF value?

It depends on the importing country. The United States values most imports at the transaction value without international freight and insurance, which this workbook calls FOB value. The European Union, the United Kingdom and India include freight and insurance to the border, which is CIF value. On 30,000 of goods with 1,800 freight and insurance, a 4% duty is 1,200 on FOB and 1,272 on CIF. Choose the basis on Setup, and check with your broker.

What goes in the extra tariff column?

Any additional duty charged on top of the normal duty rate for that HS code and origin, as a percentage of customs value: anti-dumping or countervailing duties, safeguard duties, retaliatory or other special tariffs. On a 27,900 customs value, a 2.8% duty is 781.20 and a 25% extra tariff is 6,975. The workbook reports extra tariffs separately so you can see what they add.

Does the template look up tariff rates for me?

No. Rates depend on the exact classification, the origin, trade-agreement preferences and the date of entry, so they are typed on each row from the customs entry or your broker. The HS codes and rates in the example are invented illustrations, not current tariffs. Typing the rate per row also means a later rate change does not rewrite the cost of past entries.

How does the tariff what-if work?

Type extra percentage points, for example 10%, and the Dashboard multiplies the customs value of the entries in view by it. With 80,000 of customs value from one origin in view, 10 more points of tariff adds 8,000 to landed cost; the tile also shows the new uplift over the goods value. Pick an origin in the filter to test one country.

Are VAT, GST and other import taxes included?

No, because most manufacturers reclaim import VAT or GST. If part of a tax is not recoverable for you, add it to Brokerage and fees on the row. Inventory carrying cost and quality losses are also outside landed cost here; the Reshoring Total Cost of Ownership template adds them.

Planning and Supply Chain

Landed Cost and Tariff Excel Template

Turn every import entry into landed cost per unit, see how much of it is duty and extra tariffs, compare two origins for the same part, and test a tariff increase before it lands.

Overview

This landed cost and tariff workbook is for buyers, importers and cost analysts who need the real cost of a purchased part at the plant door, not the price on the supplier's invoice. It ships with three months of example entries for a fictional pump assembler importing eight components from five origins, including one part bought from two countries, so the dashboard is populated the moment you open it. The duty and tariff rates in the example are invented illustrations; replace them with the rates on your own entries.

Each log row is one part line of a customs entry. The workbook calculates the goods value, the customs value (goods only on a FOB basis, or goods plus international freight and insurance on a CIF basis, as you choose on Setup), duty and any extra tariff as a percentage of the customs value, and landed cost: goods plus freight, insurance, duty, extra tariffs, brokerage and fees and inland freight. Landed cost per unit and the uplift over the goods value follow, with the same arithmetic as the Landed Cost calculator on this site. Totals and averages are formed from sums, so a large lot weighs more than a small one.

In practice, add each entry when the broker's paperwork arrives and review the Dashboard monthly. The part by origin matrix answers the sourcing question directly: what a part costs landed from each country. The uplift chart shows which origins cost most to land, and the what-if shows what an extra 10 or 25 points of tariff would add to the purchases in view, which is the number a tariff announcement needs.

What this template includes

Setup with your currency label, the duty base your customs authority uses (FOB value or CIF value), a landed-cost uplift limit, and supplier, origin and part lists with HS codes
Landed Cost Log table: one row per part line of an import entry with units, unit price, international freight, insurance, duty rate, extra tariff rate, brokerage and fees and inland freight
Per-row goods value, customs value, duty, extra tariff, landed cost, landed cost per unit and uplift over the goods value, with a status word against your limit
Check column that names problems in words: part or supplier not on the Setup list, missing units or price, freight above the goods value, duplicate entry line
Dashboard with origin and date filters, KPI tiles for landed cost, uplift, duty and tariffs and extra tariffs alone
Two native charts: landed cost by origin split into goods, freight, duty, extra tariffs and fees, and uplift by origin against your limit
Tariff what-if: type extra percentage points and see the added cost and the new uplift for the origin and dates in view
Part by origin matrix of landed cost per unit, and summary tables by origin and by part
Method and Verify sheets: every formula in words, and a self-check against an independent reference including the Landed Cost calculator's example
A CSV with live formulas of the Landed Cost Log for any spreadsheet app; the dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it to cost each import entry for inventory valuation, to compare landed cost per unit when a part comes from two countries, to show management how much tariffs add, and to size the effect of a proposed tariff change on your current purchases.

How to use it

On Setup, type your company and currency label, choose whether duty is charged on FOB value or CIF value in your country, and set your uplift limit.
Replace the example origins, suppliers and parts with your own, with each part's HS code.
On Landed Cost Log, add one row per part line of each customs entry: units, unit price in your currency, freight, insurance, the duty rate and any extra tariff rate from the entry, brokerage and fees, and inland freight.
Fix anything the Check column flags.
Open the Dashboard: filter by origin or dates, read landed cost per unit by part and origin, and type extra tariff points into the what-if to see the added cost.

Frequently Asked Questions

How is landed cost calculated in this template?: Landed cost is goods value plus international freight, insurance, duty, extra tariffs, brokerage and fees, and inland freight. For 1,000 units at 12.00 with 1,200 freight, a 5% duty on the 12,000 FOB value (600) and 600 of insurance, brokerage and handling, landed cost is 14,400, or 14.40 per unit. That matches the Landed Cost calculator for the same inputs.
Should duty be charged on FOB or CIF value?: It depends on the importing country. The United States values most imports at the transaction value without international freight and insurance, which this workbook calls FOB value. The European Union, the United Kingdom and India include freight and insurance to the border, which is CIF value. On 30,000 of goods with 1,800 freight and insurance, a 4% duty is 1,200 on FOB and 1,272 on CIF. Choose the basis on Setup, and check with your broker.
What goes in the extra tariff column?: Any additional duty charged on top of the normal duty rate for that HS code and origin, as a percentage of customs value: anti-dumping or countervailing duties, safeguard duties, retaliatory or other special tariffs. On a 27,900 customs value, a 2.8% duty is 781.20 and a 25% extra tariff is 6,975. The workbook reports extra tariffs separately so you can see what they add.
Does the template look up tariff rates for me?: No. Rates depend on the exact classification, the origin, trade-agreement preferences and the date of entry, so they are typed on each row from the customs entry or your broker. The HS codes and rates in the example are invented illustrations, not current tariffs. Typing the rate per row also means a later rate change does not rewrite the cost of past entries.
How does the tariff what-if work?: Type extra percentage points, for example 10%, and the Dashboard multiplies the customs value of the entries in view by it. With 80,000 of customs value from one origin in view, 10 more points of tariff adds 8,000 to landed cost; the tile also shows the new uplift over the goods value. Pick an origin in the filter to test one country.
Are VAT, GST and other import taxes included?: No, because most manufacturers reclaim import VAT or GST. If part of a tax is not recoverable for you, add it to Brokerage and fees on the row. Inventory carrying cost and quality losses are also outside landed cost here; the Reshoring Total Cost of Ownership template adds them.