How to Calculate Landed Cost of Imported Goods in Excel: Formula, Template, and Duty Breakdown
Import Export
If you want to calculate the landed cost of imported goods in Excel, the basic method is simple: add together the product cost, international freight, insurance, customs charges, duties or tariffs, and any other import fees you want included, then divide by the number of sellable units to get a per-unit landed cost. That gives you the true cost of bringing the goods to the destination point you are using for the calculation, not just the supplier invoice amount.
In practice, a good Excel sheet for landed cost should behave like a calculator: one section for inputs, one formula for the shipment total, and one output for unit cost, pack cost, and pricing. If you also need customs, invoice, or freight context while building your sheet, you may find our guides on commercial invoice basics and the freight volume and volumetric weight calculator useful as supporting references.
What landed cost means in shipping and importing
Landed cost is the total cost of getting a product from the supplier or factory to the destination point you are using in your calculation. In shipping and importing terms, it is broader than the supplier invoice price because it includes the product itself plus the costs required to move it across borders and into your hands.
A practical landed cost calculation usually includes:
- purchase price or supplier price
- international freight or shipping
- insurance
- customs charges and processing fees
- duties or tariffs
- other import-related charges you decide to include in the sheet
That is the point of the calculation: to show the real incoming cost of the goods so you can price them properly, protect margin, and avoid underestimating your cost base.
One important boundary to keep in mind is that landed cost is usually defined up to a destination point, not every cost you might incur after the goods arrive. For example, some shipping guidance distinguishes between charges up to the destination port and later inland carriage from the port to the final delivery point. If you include domestic delivery or warehousing in your sheet, do so deliberately and label those cells clearly so you do not mix them with the core landed cost figure.
How to calculate landed cost in Excel
The easiest way to build a landed cost calculator in Excel is to create a row for each cost component and then sum the total. The worksheet should be built around simple arithmetic rather than complicated functions. The goal is to make the formula easy to audit, update, and reuse for future shipments.
A simple Excel layout
| Cell / field | What to enter | Example |
|---|---|---|
| A2 | Quantity of sellable units | 500 |
| A3 | Supplier or purchase price per unit | 12.00 |
| A4 | International freight | 650.00 |
| A5 | Insurance | 75.00 |
| A6 | Customs charges / brokerage / processing | 120.00 |
| A7 | Duties / tariffs | 300.00 |
You can adapt the structure if your purchase price is entered as a shipment total rather than a unit price. The key is consistency: every cost should be entered in the same currency and tied to the same shipment.
The landed cost formula in plain English
The landed cost formula is:
Landed cost = product cost + shipping + insurance + customs charges + duties/tariffs + other included import fees
In Excel, that can be written in a very direct way. If your shipment total cost components are in cells B2:B7, the formula for total landed cost could simply be:
=SUM(B2:B7)
If the supplier price is entered as a unit price and you need the full purchase value first, multiply unit price by quantity before adding the other costs. For example:
=(A2*A3)+A4+A5+A6+A7
That is the same logic you would use in a landed cost calculator template: calculate the stock value, add the import costs, and arrive at the full shipment cost.
For a more detailed worked example of the formula pattern used in spreadsheet-based supply chain analysis, the cell-by-cell approach shown in this Excel landed cost example is useful to mirror in your own sheet.
Example landed cost formula in Excel
Let us use a simple example to show how the calculation works in practice.
| Input | Value |
|---|---|
| Quantity | 500 units |
| Supplier price per unit | $12.00 |
| International freight | $650.00 |
| Insurance | $75.00 |
| Customs charges | $120.00 |
| Duties/tariffs | $300.00 |
First calculate the purchase value:
500 × $12.00 = $6,000.00
Then add the other landed cost components:
$6,000.00 + $650.00 + $75.00 + $120.00 + $300.00 = $7,145.00
So the total landed cost for the shipment is $7,145.00.
If you want a unit landed cost, divide by the number of units:
$7,145.00 ÷ 500 = $14.29 per unit
That per-unit figure is the number you would typically use for pricing, margin planning, and inventory valuation decisions.
If you are unsure which charges should be included in your calculation, a broader landed cost overview from FedEx’s landed cost explanation is helpful because it groups the main cost buckets as product, shipping, customs, risk, and overhead. For another worked approach that includes duties and import-related fees in a practical formula, see this landed cost formula guide and worked examples.
How to calculate landed cost per unit and per pack
Once you have the total landed cost, the next step is converting it into a cost per item. This is where many Excel sheets go wrong: they stop at the shipment total and do not translate that number into a usable unit cost.
The rule is straightforward:
Per-unit landed cost = total landed cost ÷ total sellable units
If your goods are sold individually, the number of sellable units is simply the quantity received. If the product is sold in packs, calculate the cost based on the number of individual sellable items inside those packs, not the number of cartons or outer packs.
Cost per item in a pack
Suppose your shipment contains 200 packs, and each pack contains 6 sellable items. That means you have 1,200 sellable units in total.
If the total landed cost of the shipment is $9,600, then:
$9,600 ÷ 1,200 = $8.00 per item
If you also want the cost per pack, multiply the unit landed cost by the number of units in each pack:
$8.00 × 6 = $48.00 per pack
This distinction matters. Cost per pack is useful if you sell and invoice by pack. Cost per item is the figure you usually need for margin analysis, inventory costing, and pricing individual sellable units.
In Excel, you can keep both calculations on the same sheet so the business can see the shipment total, pack cost, and unit cost at a glance.
How landed cost relates to COGS and selling price
Landed cost is not automatically the whole accounting treatment for every business, but it is a key input into cost of goods sold and pricing analysis. That is why importers often calculate landed cost before setting their minimum selling price or gross margin target.
Once you know your landed cost per unit, you can compare it with your planned sale price. For example, if a unit costs you $14.29 landed and you plan to sell it for $25.00, your gross margin room is much clearer than if you only looked at the $12.00 supplier price.
You can use the landed cost number in several practical ways:
- to test whether the product is profitable before ordering more stock
- to set a minimum selling price
- to compare different suppliers or shipping methods
- to estimate inventory value more accurately
- to support COGS-style calculations in your internal reports
If you are building this for a finance or operations workbook, treat landed cost as the cost base for pricing, then layer your own margin logic on top. That keeps the spreadsheet useful without pretending that landed cost alone replaces full accounting treatment.
For readers who need customs-duty context as part of that pricing calculation, our guide on how to pay import customs duty explains where duty fits in the import process, and our article on customs bond amount calculation is a useful next step if bond costs affect your landed-cost model. If you are still deciding whether customs will apply at all, see whether you’ll have to pay customs.
What to include in your Excel landed cost sheet
A practical import costing sheet format in Excel should include only the costs you actually want to treat as part of landed cost. The most common inputs are below.
| Cost bucket | Include in landed cost? | Notes |
|---|---|---|
| Supplier or purchase price | Yes | The base product cost |
| International freight | Yes | Ocean, air, or courier transport to your chosen destination point |
| Insurance | Yes | Often included where applicable |
| Customs charges | Usually yes | Brokerage or clearance fees if you want a full import cost view |
| Duties / tariffs | Yes | Import duty and tariff charges where applicable |
| Processing fees | Often yes | Use the fee type you actually incur |
| Inland delivery after destination point | Sometimes | Include only if your internal definition of landed cost includes it |
If your company uses a different definition, make that clear in the workbook title or a note beside the formula. A good spreadsheet is not just about arithmetic; it is about showing exactly what is included so nobody mistakes the numbers later.
A simple Excel sheet structure you can copy
Here is a straightforward structure for a landed cost calculator template in Excel:
- Enter the quantity received.
- Enter the supplier price per unit or the total supplier invoice value.
- Enter freight or shipping charges.
- Enter insurance charges.
- Enter customs brokerage or processing fees.
- Enter duties and tariffs.
- Enter any other included import fees.
- Calculate total landed cost.
- Divide by sellable units to get landed cost per unit.
- Multiply by pack size if you also need cost per pack.
If your workflow also depends on freight measurement, especially for ocean or air charges based on volume or weight, the freight volume and volumetric weight calculator can help you estimate the shipping component that feeds into the landed cost sheet.
Common mistakes when calculating landed cost in Excel
Even a well-built spreadsheet can produce the wrong answer if the inputs are inconsistent. The most common mistakes are:
- including only the supplier price and forgetting shipping or duty
- mixing shipment totals with unit prices in the same formula
- dividing by carton count instead of sellable units
- counting both pack quantity and unit quantity twice
- including post-arrival domestic costs without clearly labelling them
- using different currencies without converting them first
If you avoid those errors, your Excel sheet will give you a much more reliable landed cost figure and a cleaner basis for pricing decisions.
When a template or calculator is most useful
A formula-driven landed cost calculator in Excel is most useful when you are comparing several suppliers, shipping methods, or product lines. It gives you a repeatable way to test profitability before placing an order, which is especially valuable if freight rates, customs charges, or duties can change from shipment to shipment.
That is also why many importers prefer a sheet format rather than a simple calculator online: Excel lets them change the assumptions, keep the assumptions visible, and build their own margin tests beside the landed cost formula.
If you are looking for a free downloadable template, make sure one is actually offered by the source you are using. This article is designed to show you how to build the sheet yourself, not to claim a file download that is not provided here.
Quick recap
To calculate landed cost of imported goods in Excel, enter the product cost, freight, insurance, customs charges, duties or tariffs, and any other import fees you want included, then sum them in a single formula. After that, divide by the number of sellable units to get the per-item landed cost, and multiply by pack size if you need a per-pack figure. That gives you a practical cost base for pricing, margin analysis, and COGS-style planning.
If you build the sheet clearly, you will not just know what the goods cost at the supplier level. You will know what they truly cost to import.
