If you still run landed cost in a spreadsheet, the question is whether to automate.
Usually yes, but not because a spreadsheet is a bad calculator.
It is a bad system.
The formula still works.
The file stops being the current file.
Stay here for the decision, not a trophy list: when the sheet is enough, where it breaks, and what software has to do besides redraw the grid in a browser.
The arithmetic is how to calculate landed cost.
If you are picking a calculator (web form vs sheet vs platform), use the ecommerce landed cost calculator roundup.
Stay here when the question is automate or keep the workbook.
If More Than One Person Edited The Cost File This Month
You import finished goods.
You already have a landed-cost tab.
More than one PO is open, or more than one person has edited the file this month.
You have approved a reorder on a number you later found was the first freight quote.
Skip a platform trial if you model a shipment twice a year and one person still has the current file.
A sheet plus the landed cost calculator is enough until the bills leave the file.
When The Spreadsheet Is Still The Right Tool
A sheet is honest at the start.
Cheap.
Visible.
You can see the formula.
It holds when:
- You are testing a first import, not running a cadence
- SKU count is small and shared charges are simple
- One person owns the numbers
- The job is an estimate, not a workflow
That is why templates still earn their keep.
The import duty calculator is the same idea: a model, not an operating system.
The Break Is The Workflow, Not The Formula
Tabs multiply.
Then two suppliers, a revised ocean quote, a split container, a credit, and finance asking why Shopify margin is not the P&L.
The SUM line is fine.
The process around it is not.
What actually fails:
- Two "final" copies
- Invoice amounts pasted by hand, weeks late
- Freight sitting in email while the sheet still has the quote
- A column insert that quietly breaks a range
- Documents in Drive with hopeful names
- Allocation that only one person remembers
- No trail for why last March's unit cost moved
$2,200 In The Sheet, $3,050 In The Inbox
Three open POs.
One person "owns" the workbook.
| PO | What the sheet has | What arrived |
|---|---|---|
| PO-1048 kitchenware | First freight quote | Unchanged |
| PO-1051 travel accessories | Ocean $2,200 | Revised bill $3,050, email to finance only |
| PO-1054 parts | Estimate | Still in transit |
For two weeks the travel SKU is costed on $2,200.
Same pattern as the calculator miss: the revised freight bill sits in email while the sheet still has the quote.
You do not need an inspection miss for the number to be wrong.
The $850 freight gap on PO-1051 is already in someone's inbox.
In that window the team approves a reorder, a promo uses the cheap cost, and the buyer thinks the factory quote still works.
Nobody broke a formula.
Nobody opened the other inbox.
Organizing supplier invoices is the filing version of the same break.
Spreadsheet Vs Software, By The Job
Not "which is better."
Which job you are asking the file to do.
| Job | Spreadsheet | Software |
|---|---|---|
| One-off estimate | Strong | Optional |
| Same logic on every inbound | Fragile | Strong if the rule is explicit |
| Purchasing, ops, and finance | One grid, many editors | Shared record, fewer overwrites |
| Documents | Links and hope | On the PO |
| Estimate → actual | Extra tabs, extra people | Replace the line when the bill lands |
| Mixed-SKU allocation | Doable, painful to reuse | Worth it when the mix repeats |
If the product only recreates the grid in a browser, you bought a prettier sheet.
Three Signs The Sheet Is Finished
Automate (meaning a system that holds the PO, the files, and the actuals) when most of these are true:
- More than one open shipment, and costs arrive after you have already received.
- More than one person must trust the same unit cost. Variants count.
- The next PO uses last inbound's number. If that number still lives in email, you are already late.
Also watch: invoices, freight bills, and duty receipts in three places; a margin review that cannot show the bill behind a SKU.
The hidden cost is not a software invoice.
It is the reorder you priced off $8.50, the hour spent proving the formula, the finance cleanup after ops moved on.
What The Software Has To Do
A useful landed-cost system stores the supplier and the order, captures the documents, ties charges to the shipment and SKU, allocates with a stated driver, and lets you compare estimate to actual.
Per-product margin should come from that record, not from a tab named v7_REAL.
SupplyAutomate is built for the point where the sheet stops.
Purchase orders, supplier files, freight bills, unit cost as the bills arrive.
The pricing page is what that costs against the hours.
I am not quoting a competitor.
Ask each vendor against your PO volume.
It will not classify an HTS heading or file an entry.
You still need honest quantities.
One SKU and a stable lane can stay in Excel.
Shopify-only checkout duty apps solve a different problem.
Shopify landed cost tools is that split.
QuickBooks posting is landed cost in QuickBooks.
FAQ
Should We Automate Landed Cost If We Already Have A Spreadsheet?
If the sheet is still the current file, and one person can reconstruct last inbound from it, keep it.
Automate when the freight revision lives in email, two people edit copies, or you cannot say what a SKU cost without Slack.
What Is The Difference Between A Landed Cost Spreadsheet And Software?
The sheet calculates.
Software is supposed to keep the calculation attached to the PO and the bills as they arrive.
Many "software" products fail that test.
Can I Keep Using Excel For Landed Cost?
Yes, for estimates and a small catalog.
Replace cells with invoices.
Several currencies, late duty, and mixed SKUs is when the file becomes a rumor.
What Should Landed Cost Software Cost?
Depends on PO volume and who must see the number.
Price it against the miss (the $850 freight gap, the promo on stale cost), not against a brochure.
Anyone quoting a single "landed cost software price" without asking how many inbounds you run is selling a seat.
The test is whether the last three POs have the freight bill, not the quote, in the sheet a second person can rebuild.
If a revision is missing, the workbook already answered the software question.
The landed cost calculator is a clean rebuild of that inbound.
SupplyAutomate is the next step when the file cannot keep up.