Free template
Free landed cost template
Free landed cost spreadsheet.
Enter the shipment's freight, duties, insurance and other fees at the top, then each line on the invoice. The sheet spreads the extra costs across lines by value and gives you the landed cost per unit to use in margins and pricing.
Download the free template (.xlsx)
Works in Excel, Google Sheets (File, Import, Upload) and Apple Numbers. No email required.
What's in the template
Shipment costs (freight, duties, insurance, fees) and up to 30 lines: SKU, quantity, unit price, line value, share of invoice, allocated extra cost and landed cost per unit.
White cells are inputs. Green cells are formulas, so don't type over them. Sample rows are included so you can see how it works. Delete them and add your own.
How to use it
- Enter freight, duties, insurance and any broker or bank fees for the shipment.
- List each SKU with quantity and the supplier's unit price.
- Read landed cost per unit and update your cost per item in Shopify.
- Use landed cost, not supplier price, when you check margins.
- If one product is very bulky, allocate freight by weight or volume instead.
The math
Landed cost per unit = (line value + line share × extra costs) ÷ quantity
Want to check one product quickly? Use the free landed cost calculator.
Skip the spreadsheet
Spreadsheets work until you have more products than time. SteadyShelf connects to your Shopify store, works out daily sales for every product, shows what to reorder and when for each supplier, and drafts the purchase order for you. $29/month flat, unlimited products and suppliers, 30-day free trial.
SteadyShelf is launching on the Shopify App Store. Join early access to get the install link first.
More free templates
- Reorder point template
- Purchase order template
- Inventory count sheet
- Supplier list template
- Safety stock template
All free inventory templates · Free purchase order generator
FAQ
Should freight be split by value or by weight?
By value is simplest and fine when products are similar in size. If some products are much heavier or bulkier for their price, split freight by weight or volume.
Where do I put landed cost in Shopify?
In the product variant's Cost per item field, so Shopify's profit reports use the true cost.
Let SteadyShelf do this math for every SKU
Order-by dates per supplier, seasonal forecasts and draft POs for your Shopify store. $29/month after a 30-day free trial.
Get early access