Free Landed Cost Calculator Excel Template: Download and Calculate True Import Cost

If you need a landed cost calculator Excel free download, use the free CSV template above. It opens in Excel, Google Sheets, Numbers, and most spreadsheet tools. The template helps you estimate true imported unit cost before you place a supplier order.

The template is built for ecommerce sellers who need to model product cost, international freight, insurance, import duty, customs or broker fees, domestic delivery, inspection, unsellable units, and a quick margin check in one file.

A landed cost calculator Excel template helps importers answer one question before they place a purchase order: what will one sellable unit really cost after the product leaves the factory and reaches the warehouse?

If you are searching for a landed cost calculator Excel free download, the real goal is usually not the file itself. The goal is to avoid buying inventory with a false unit cost. A spreadsheet helps because it keeps every hidden import cost visible before you send money to a supplier.

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.

This is especially useful for Amazon FBA, Shopify, Etsy, and TikTok Shop sellers who import products from China or other sourcing markets. The supplier invoice may be in CNY, freight may be quoted in USD, import charges may be local, and selling revenue may arrive through a marketplace. A template forces those costs into one model.

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.

A practical landed cost formula is: landed cost = product cost + international freight + insurance + import duty + customs or broker fees + port or terminal fees + domestic delivery + inspection or prep + other import costs.

Then calculate landed cost per sellable unit by dividing total landed cost by the number of units you can actually sell. This matters because damaged packaging, samples, missing units, quality-control failures, and replacement stock all reduce the denominator.

For example, if total landed cost is $7,078.80 and 970 units are sellable, landed cost per sellable unit is $7.30. If you divide by 1,000 ordered units instead, you would show $7.08 and make the product look slightly better than it really is.

The most common missing cost is domestic delivery after customs clearance. Sellers often include ocean or air freight but forget the cost of moving goods from port, airport, or forwarder warehouse to the final storage location.

The second missing cost is unsellable inventory. Even a small defect or packaging-damage rate can raise the true cost per sellable unit. For fragile, apparel, regulated, customized, or giftable products, use a larger allowance during early testing.

The third missing cost is currency movement and payment spread. If supplier cost is paid in CNY and the sales model is in USD, use a conservative exchange rate. A small exchange-rate change can remove margin when the product is already thin.

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

After you know the imported unit cost, compare platform economics with the cross-platform profit comparison page: /marketplace-fee-comparison. This is the quickest way to see whether the same product is stronger on Amazon, Etsy, Shopify, or TikTok Shop.

If the imported product is for Amazon FBA, use the free Amazon FBA profit calculator spreadsheet template next to model referral fee, FBA fulfillment, ads, returns, ROI, and break-even price: /guides/free-amazon-fba-profit-calculator-spreadsheet-template

If you plan to sell the imported product through your own Shopify store, use the free Shopify profit spreadsheet template next: /guides/free-shopify-profit-calculator-spreadsheet-template