An import landed cost worksheet helps you see what overseas inventory really costs before it reaches your warehouse. This guide provides a repeatable method for combining supplier pricing, freight, insurance, duties, brokerage, currency conversion, payment fees, and other allocated expenses into a reliable per-unit cost.
Overview
The supplier’s quoted price is only one part of an import cost. A product that appears inexpensive at the factory may become less attractive after transportation, customs charges, financing, storage, and local handling are included. Landed cost is the total cost of acquiring goods and getting them to the agreed destination, ready for sale or internal use.
A practical landed cost formula is:
Total landed cost = product cost + origin charges + international freight + insurance + duties and tariffs + customs and brokerage fees + destination charges + payment and currency costs + allocated warehousing and handling costs
Unit landed cost = total landed cost divided by the number of saleable units received
The phrase “saleable units” matters. If a shipment contains damaged, missing, or nonconforming goods, dividing by the original order quantity can understate the cost of the units you can actually sell. Keep a separate record of expected quantity, received quantity, and saleable quantity.
Use the worksheet for each purchase order, supplier comparison, and meaningful change in shipping or trade conditions. It can also support pricing decisions, reorder planning, and an international expansion strategy by showing whether a market remains commercially viable after delivery costs.
How to estimate
Build the worksheet in the same order that costs arise. This makes missing assumptions easier to identify and prevents a low supplier quote from obscuring downstream expenses.
- Record the supplier quote. Enter the product price, quantity, packaging charges, tooling or inspection fees, and the currency. Note the delivery term or Incoterm shown on the quotation because it affects which party is responsible for transport, insurance, and import-related charges.
- Convert the quote into your reporting currency. Apply the exchange rate you expect to use for settlement, not just a convenient market rate. If the payment date is later, include a sensitivity case for an unfavorable currency movement. Record the date, rate, and any conversion spread separately.
- Add origin costs. Include export documentation, factory-to-port transport, loading, consolidation, inspection, and other charges billed before the international shipment begins. Ask the supplier or freight provider which costs are included in the quote.
- Add international transportation and insurance. Record ocean, air, rail, or courier freight as applicable. Include cargo insurance when purchased or when a reasonable risk allowance is needed for planning. Use the quoted charge for the shipment size and route rather than applying a generic rate.
- Estimate duties and tariffs. Start with the correct tariff classification and the customs value used by the destination country. Confirm the applicable rate and whether additional measures, exemptions, trade agreements, or product-specific requirements may apply. Do not assume that a supplier’s classification is correct without checking the relevant customs guidance or qualified trade professional.
- Add customs, brokerage, and destination charges. Include customs entry or brokerage fees, port or terminal handling, documentation, examination-related charges where relevant, delivery from the port, and other fees needed to move the goods to your facility.
- Add financial and operational costs. Enter wire or payment-processing fees, foreign-exchange charges, inspection costs, temporary storage, receiving labor, and allocated warehouse handling. These may be small individually but material across frequent or low-margin shipments.
- Divide by saleable units. Calculate the total and divide it by the quantity expected to be received in sellable condition. Keep both the total shipment cost and the per-unit result in the worksheet.
For a simple spreadsheet, use columns for cost category, amount, currency, exchange rate, converted amount, source or quote date, and assumption notes. A notes column is valuable because it records whether a figure is quoted, estimated, prepaid, refundable, or subject to change.
Inputs and assumptions
A good import landed cost calculator separates confirmed amounts from estimates. Use a status field such as “quoted,” “contracted,” “estimated,” or “pending.” This shows which parts of the result need the most attention before placing an order.
Core worksheet inputs
- Product cost: unit price multiplied by ordered quantity, plus product-specific packaging or customization.
- Quantity and dimensions: carton count, gross weight, volume, and expected saleable units. Freight quotes often depend on these details.
- Trade terms: identify which costs are included in the supplier’s price and which are yours to arrange.
- Route and mode: origin, destination, transport mode, service level, and expected transit period.
- Customs basis: tariff classification, customs value, duty rate, and any applicable taxes or import charges.
- Currency and payment: invoice currency, payment schedule, conversion rate, bank charges, and any payment-platform fee.
- Local fulfillment: delivery to the warehouse, receiving labor, inspection, storage, labeling, and preparation for sale.
Keep duties, tariffs, and recoverable taxes in separate rows. Whether an import tax is a true cost can depend on the business’s registration, accounting treatment, and ability to claim a credit or refund. Likewise, do not combine a temporary storage charge with product cost if your accounting system treats it separately. The worksheet is a decision tool, but it should be consistent with your bookkeeping and tax treatment.
Use three scenarios where inputs are uncertain: a base case, a higher-cost case, and a lower-cost case. For example, vary freight, exchange rates, delivery time, and the quantity of saleable units. This produces a range rather than a misleading single-point estimate. For a detailed explanation of tariff terminology and planning considerations, see Tariffs Explained for Small Business Importers.
Worked examples
Assume an importer is comparing three sourcing and shipping scenarios for the same product. The figures below are illustrative assumptions, not current market quotations.
| Scenario | Product cost | Freight and insurance | Duties and fees | Other allocated costs | Saleable units | Estimated landed cost per unit |
|---|---|---|---|---|---|---|
| A: lower unit price, slower freight | 12,000 | 2,400 | 1,800 | 800 | 1,000 | 17.00 |
| B: higher unit price, consolidated freight | 13,200 | 1,500 | 1,980 | 700 | 1,000 | 17.38 |
| C: smaller order, expedited freight | 6,600 | 2,200 | 990 | 500 | 500 | 20.58 |
Scenario A totals 17,000, or 17.00 per saleable unit. Scenario B totals 17,380, or 17.38 per unit. Scenario C totals 10,290, or 20.58 per unit. The comparison shows why supplier price alone is not enough: the smallest order has a materially higher unit cost because fixed freight and handling are spread across fewer units.
Before choosing Scenario A, the buyer should check delivery time, working-capital requirements, storage capacity, and the risk of tying up cash in a larger order. Before choosing Scenario B, the buyer should verify that consolidation assumptions are available for the planned shipment. The cheapest landed cost is not always the best commercial decision if it creates stockout risk or excessive inventory.
Once the landed cost is calculated, use it as the input for pricing rather than adding a simple percentage to the supplier price. The guide How to Price a Product for International Markets can be used alongside the worksheet when evaluating margin, taxes, channel fees, and market-specific pricing.
When to recalculate
Recalculate the worksheet whenever a cost assumption can change the buying decision or margin. At minimum, revisit it for every new supplier quote, purchase order, shipping mode, route, currency, or product classification.
- Before ordering: replace estimates with the latest supplier, freight, insurance, and brokerage quotes.
- When trade rules change: review tariff classifications, duty rates, documentation requirements, and any applicable de minimis or exemption rules with current official guidance.
- When freight conditions move: update transportation, fuel, congestion, handling, and delivery assumptions.
- When currencies move: refresh the settlement rate and run an adverse-rate scenario for foreign-currency purchases.
- After receipt: compare estimated costs with invoices and actual received quantities. Record the variance and improve the next estimate.
- During quarterly sourcing reviews: compare suppliers, routes, order sizes, and fulfillment options using the same cost categories.
For practical use, save a dated version of the worksheet with each purchase order. Mark every input that changed and calculate the effect on unit cost and gross margin. Link the result to your cash planning; a 13-Week Cash Flow Forecast can help show when deposits, freight payments, duties, and inventory receipts affect liquidity. If costs rise sharply, test the effect on reorder timing, pricing, and stock levels rather than reacting to the supplier price alone.
The most reliable worksheet is not the most complicated one. It is the version your team updates consistently, documents clearly, and checks against actual invoices. Keep the categories stable, refresh the changing inputs, and use the resulting landed cost to make sourcing and international expansion decisions on a comparable basis.
