Free Landed Cost Spreadsheet Template for Importers

A supplier quote is only the beginning of an import cost model. The quote tells you what the factory charges for the product, but it does not tell you what the product costs after freight, insurance, import duty, customs handling, domestic delivery, inspection, damaged units, marketplace fees, and a small operating buffer.

That gap is where many new ecommerce sellers lose money. A product that looks profitable at $5 from the supplier may become a $7 or $8 product after it reaches the warehouse. If the selling price is already competitive, those hidden dollars can remove the entire advertising budget or make the product impossible to discount.

A landed cost spreadsheet gives you a simple habit: every shipment gets one cost model before the purchase order is confirmed. You can test freight changes, duty assumptions, damaged-unit rates, and target prices without rebuilding the math every time.

The template is built around shipment-level costs first: product cost total, international freight, cargo insurance, duty rate, customs and broker fees, port or terminal fees, domestic delivery, inspection or prep, and a small other-cost buffer. These are the lines that often sit outside the supplier quote but still belong in the inventory cost basis.

It also separates ordered units from sellable units. This matters because a purchase order of 1,000 units may not produce 1,000 sellable units. Samples, defects, damaged packaging, missing items, inspection holds, and replacement stock all reduce the units that can generate revenue. If you divide total shipment cost by ordered units only, your unit cost may look too low.

Finally, the template includes a pricing check. After calculating landed cost per sellable unit, it asks for target selling price, marketplace and fulfillment cost, and ad, discount, or return allowance. That turns the import model into a quick profit model.

First, replace the example shipment costs with your own quotes. If you do not yet have exact numbers, use conservative estimates. A rough but cautious model is better than a clean spreadsheet that ignores unknown costs.

Second, enter your duty rate as a decimal. For example, 6% should be entered as 0.06. The spreadsheet uses a simple planning formula, but real customs valuation can vary by country, product classification, Incoterms, and import method. Use the template for business planning, then confirm important duty assumptions with official tariff resources or a customs broker.

Third, update ordered units and unsellable units. If your product is fragile, customized, apparel-based, regulated, or packaging-sensitive, use a higher unsellable allowance during early testing. This keeps your pricing model from depending on perfect execution.

Fourth, use the pricing check to compare landed cost against market price. If your expected profit only works when freight is cheap, duty is low, and every unit is sellable, the product may be too fragile. A better product can survive a few realistic mistakes.

Suppose you buy 1,000 units at $5 each. The supplier invoice is $5,000. If you stop there, the product may look attractive. Now add $900 international freight, $80 insurance, 6% planning duty, $160 customs and broker fees, $120 port or terminal fees, $220 domestic delivery, $140 inspection and prep, and $100 buffer.

Using the template, the customs value example is product cost plus freight plus insurance, or $5,980. Duty at 6% is $358.80. Total landed cost becomes $7,078.80. If all 1,000 units are sellable, the landed cost per ordered unit is about $7.08. If 30 units are damaged or held back, the landed cost per sellable unit is about $7.30.

That means the $5 supplier quote became a $7.30 sellable unit cost before marketplace fees, fulfillment, advertising, discounts, and returns. For a product selling at $19.99, this can still work. For a product selling at $12.99, it may become risky.

Use the spreadsheet when you are comparing suppliers, freight quotes, or purchase-order scenarios. It is better for planning a shipment because it keeps each cost line visible and lets you save a copy for later review.

Use the landed cost calculator when you want a faster answer or when you are checking a single scenario. The calculator is useful during product research, supplier negotiation, or quick conversations with a freight forwarder.

The best workflow is to use both. Start with the calculator to see whether the product is even worth deeper research. Then use the spreadsheet before committing money to inventory. After the shipment arrives, update the spreadsheet with real costs so your next order is based on actual data, not guesses.

The first version of your landed cost model will not be perfect. That is fine. The goal is not perfect prediction. The goal is to make hidden costs visible before they hurt your pricing decision.

Create one copy of the template for each supplier quote or shipment. Add a short note about freight terms, duty assumptions, exchange rate, inspection plan, and risk level. Over time, these copies become a small knowledge base for your product sourcing decisions.

Download the template, run your current product idea through it, then open the landed cost calculator to test faster price scenarios: /import-duty-landed-cost-calculator