Report this item to Etsy

Landed Cost Calculator Excel Template | Import Duty, Section 301 Tariff & Freight Cost Spreadsheet | Profit, Inventory and Sales Tracker

NowPrice:$7.12

Original Price: $9.50

Loading

25% off

•

Sale ends in 1 day

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Digital download
  • Digital file type(s): 1 ZIP

Know what each imported product really costs you, and what you really make when it sells.

Your supplier's price is only the start. Freight, insurance, duty, extra tariffs, customs fees, broker fees and delivery can add 50% or more. This Excel workbook adds them up and spreads them across every product in a shipment, by value, volume or weight. You get a true landed cost per unit, then real profit per product, per sales channel and per month.

Made for small businesses that import products and sell them: Etsy, Amazon and Shopify sellers, boutiques and wholesale brands.

WHAT'S INSIDE

• Cost Estimator: test a product before you order it. Supplier price, quantity, exchange rate, shipping mode, freight, base duty, Section 301, Section 232 and other additional duty rates. You get MPF, HMF, landed cost per unit, break-even price and a suggested price for every sales channel.
• Shipments: one row per shipment with PO #, supplier, mode and status. Freight, broker and other costs are split by value, volume (CBM) or weight, your choice per shipment. MPF and HMF are estimated until you type the amounts from your entry summary.
• Shipment Items: PO #, SKU, HTS code, origin, quantity and cost, with a duty rate per line for base duty, Section 301, Section 232 (with an optional metal-content value) and other additional duties.
• Products: stock on hand, units incoming, reorder alerts, average landed cost, channel fees, profit per unit and inventory value. All automatic.
• Sales: log each order. Channel fees, product cost and net profit are calculated for you.
• Dashboard: pick a year to see revenue, profit and margin by month and by channel, with charts.
• Settings: your marketplace fee rates, default freight split and the customs fee inputs. You can edit all of them.

FEATURES

• 4 files: Light and Dark Mode, each with the sample business (Example) and cleared (Blank)
• You type every duty rate: the workbook holds no tariff rates, because they change. Tips point you to hts.usitc.gov and CBP's CSMS messages.
• Orange checks flag a shipping mode it doesn't recognize, a blank informal-entry fee or a line missing the CBM or weight its shipment is split by
• HMF is applied to every ocean mode (Ocean FCL, Ocean LCL), never to air or courier
• Pairs with the Import PO & Shipment Tracker: shipment and PO-line columns paste straight across with Paste Special > Values (tested)
• Formulas are protected so they can't be typed over (no password; you can unprotect any time)
• Dropdowns, built-in tips and color-coded cells you fill in. No macros and no add-ins.
• Room for 100 shipments, 300 shipment lines, 200 products and 1,000 orders

COMPATIBILITY

Made for Microsoft Excel; Google Sheets not yet tested. Built and checked in Microsoft Excel for Mac (Microsoft 365).

HOW IT WORKS

1. Buy the listing and download the zip file.
2. Open the Example file to see it working, then start your own copy from the Blank file. Read the Start Here tab first.
3. Enter your fee rates and products, add each shipment and its lines, then log your sales.

PLEASE NOTE

• This is a digital download. No physical item will be shipped.
• This is a calculation tool, not customs, tax or legal advice. Duty rates, tariffs and CBP fees change. Enter the current rates for your products and confirm them with a licensed customs broker.
• License: one business. You may share your filled-in copy with your employees, bookkeeper, freight forwarder or customs broker. Please don't resell or redistribute the file.
• Because this is a digital file, returns aren't accepted. If anything doesn't work, message me and I'll help.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Nov 16, 2026