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
25% off
Sale ends in 1 day
Here's what's eligible:
- Your order doesn't match the item description or photos
- Your item arrived damaged
- Your item arrived after the estimated arrival window
- Your item didn't arrive or was lost in the mail
You can only make an offer when buying a single item
Highlights
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
More from this shop
Visit shop-
Digital download
Motorcycle SVG Bundle, 12 Biker Cut Files for Cricut, Rider Dad Svg, Grandpa Gift, Garage Sign DXF, Helmet Decal Svg, Laser Cut, Rider Shirt
Sale Price $3.37
Original Price $4.50
-
Digital download
8-Bit Platformer Sound Effects, 23 Retro Jump, Landing, Door and Switch Sfx for Indie Games, WAV OGG MP3, Royalty-Free
$2.25
-
Digital download
Christmas SVG Bundle, 15 Winter Cut Files for Cricut, Checkered Truck Svg, Ornament Svg, Snowflake Svg, Gingerbread Svg, Laser DXF PNG
Sale Price $3.00
Original Price $4.00
-
Digital download
Undated ADHD Planner, Digital + Printable PDF, Brain Dump, Time Blocking, Focus Log, Dopamine Menu, Hyperlinked Tablet Planner, Letter + A4
Sale Price $4.50
Original Price $6.00
Be the first to leave a review
-
Digital download
3D Print Cost Calculator and Tracker Excel - Filament Profit and Loss Spreadsheet - 3D Printing Log Project Management - Digital Download
$5.99
-
Digital download
Vinyl Cost Calculator/ Inventory Tracker/ Price Calculator/ Small business spreadsheet
$7.00
-
Digital download
Product Pricing Calculator | Google Sheets Cost & Profit Tracker | Handmade and Small Business Pricing Spreadsheet | Material Labor Tax Tool
$13.77
-
Digital download
Product Pricing Calculator Excel Template | Cost & Profit Margin Spreadsheet for Small Business
Sale Price $7.47
Original Price $11.50
-
Digital download
U.S. Recipe Cost, Price & Profit Calculator Excel Template | Cost Calculator | Price Calculator | Profit Calculator
$8.21
-
Digital download
Excel Spreadsheet for Small Business: Pricing Calculator & Inventory Management - Blue
$8.75
-
Digital download
Business Pricing Calculator | Excel Template, Profit Margin (Digital Download
$5.00
-
Digital download
Craft Pricing Calculator & Inventory Spreadsheet, Sales Profit Tracker, Invoice and Price List Template for Etsy Sellers, Excel
Sale Price $9.97
Original Price $19.95
-
Digital download
Small Business Pricing Calculator & Inventory Tracker Excel Spreadsheet - Multicolor
$8.75
-
Digital download
Pricing Calculator for Small Business Product Cost & Profit Margin Template Excel Google Sheets Pricing Guide Handmade Products Profit Calc
Sale Price $3.97
Original Price $9.92
-
Digital download
Price Tracker | Cost Calculator | Excel Template
$17.50
-
Digital download
Etsy Fees Calculator Product Cost Pricing Template COGM Markup Profit Margin Sale Price Excel Google Sheets for Handmade Business Strategy
$5.50
Shoppers with similar taste loved these
-
Digital download
Kanban Board Project Management Tool: Google Sheets Template & Excel Spreadsheet
Sale Price $6.99
Original Price $9.32
-
Digital download
Small Business Bundle Bookkeeping Inventory Tracker Order Tracker Product Handmade Pricing Calculator Smart Bill Calendar Google Sheet Excel
Sale Price $14.57
Original Price $29.14
-
Digital download
Task Tracker Spreadsheet Template Google Sheets Digital To-Do List Excel Daily Task Priority List Work Organization Team Project Management
Sale Price $6.56
Original Price $13.11
-
Digital download
CEO Dashboard Excel Template | Executive KPI Dashboard with Finance and Team Tracker | Small Business Owner Report
Sale Price $7.99
Original Price $9.99
-
Digital download
Project Management Dashboard Excel Template | Task Tracker, Budget and Timeline | Simple Project Tracker
Sale Price $7.99
Original Price $9.99
-
Digital download
Excel Client Tracker, CRM Dashboard, Excel Small Business Template, Lead Tracker, Business Tracker, Business Planner Business Spreadsheet
Sale Price $13.73
Original Price $22.88
-
Digital download
Freelancer Notion Template: CRM, Project & Business Planner
Sale Price $31.98
Original Price $53.30
-
Digital download
Project Tracker with Project Timeline, Gantt Chart, and Task Tracker: Google Sheets & Excel Template (Digital Download)
Sale Price $6.99
Original Price $9.32
-
Mid Century Modern Colorful Bauhaus Art, Retro Geometric Canvas and Poster Print
Sale Price $71.50
Original Price $130.00
-
Digital download
Employee Monthly Check-In Form: Customizable Performance Review (Digital)
$13.61
-
Digital download
New Business Plan Template, Proposal Startup Business, Etsy Business Plan, Minimal Business Workbook, Side Hustle, Editable Canva, PDF
Sale Price $0.85
Original Price $3.42
-
Digital download
Reseller Spreadsheet Template, Resale Business Planner, Reseller Bookkeeping, Product Inventory Management, Reseller Tools Reseller Tracker
Sale Price $8.76
Original Price $17.52