Your spreadsheet is fine at arithmetic. It cannot see a sale.
Your COGS spreadsheet is not wrong. It is blind. It does the sums perfectly and has no idea your store sold forty units this morning. Landara costs every order against real FIFO layers and hands you a ready-to-post journal.
10 costed shipments free. No credit card required.
What your spreadsheet gets right
More than most software companies will admit. It is worth being precise about this, because the case against a spreadsheet is not that it is sloppy.
- The arithmetic is correct. A landed cost formula in a cell is the same formula any costing tool runs. Nobody is claiming your sums are wrong.
- It is yours. Any column you want, any structure, no workflow telling you how to think about your own costs.
- It taught you your cost structure. Building it is how most importers first learn that freight and duty belong in the unit cost at all, and that knowledge transfers.
- For one or two shipments a year it is genuinely the right tool, and a costing app would be overkill.
None of that is the problem. The problem is everything that happens between the moment you type a number and the moment the stock sells.
The three things it cannot do
Not things it does badly. Things a file sitting outside your store cannot do at all.
It cannot see a sale. Every number in it was true at the moment you typed it and has been drifting since. You find out at year end, from your accountant, about a quarter you can no longer change.
The forwarder bills weeks after the container lands. The customs broker bills after that. So the cost you sold at was never the cost you paid, and nobody goes back to restate the sales that already shipped.
A spreadsheet gives you one cost per SKU. FIFO needs a cost per receipt, drawn down oldest first, with an audit trail behind every sale. Averaging two shipments together is not a rounding difference. It is a different number, and it is the one your accountant has to sign.
A container of 1,000 units lands. Supplier invoice: $10,000, so $10 a unit. You receive the stock, Shopify Cost per item says $10, and you sell 400 units in the first three weeks. Then the forwarder bills $1,800 freight and the customs broker bills $700 duty plus $250 clearance.
True landed cost is $12.75 a unit. COGS on the 400 units you already sold is understated by $1,100, and the 600 still on hand are undervalued by $1,650.
Round numbers, so you can check the arithmetic. Your spreadsheet would have got every one of those sums right. It just never saw the 400 units go out, and the freight invoice arrived after they had.
Feature comparison
See how Landara stacks up against Excel and Google Sheets
| Feature | Spreadsheets | Landara |
|---|---|---|
| Sees a Shopify sale | No. You retype what sold, when you remember | Every order costed as it ships |
| Cost per receipt | One cost per SKU, whatever was typed last | A dated layer per receipt, drawn down oldest first |
| A freight invoice that arrives late | Restate the sold units by hand, or never | Lands into the cost layer before it forms |
| Data entry | Manual typing from invoices | AI extracts from the PDF, you review before it counts |
| Audit trail | None, or fragmented versions | Complete history with source documents attached |
| Accounting integration | Copy-paste or re-enter | Push to Xero/QBO with one click |
| Formula maintenance | Breaks when structure changes | No formulas to maintain |
| Multi-currency | Manual conversion | Automatic detection & conversion |
| Perpetual FIFO COGS per order | Manual, breaks past a few SKUs | Costed automatically on every Shopify order |
| Ready-to-post COGS journal | Build the entries yourself | Generated each period (Dr COGS / Cr Inventory) |
| Cost | Free (but time cost) | Free, then from $49/month |
| Flexibility | Unlimited customization | Structured workflow |
When spreadsheets make sense
- You import once or twice a year, so nothing has time to drift
- Your landed cost barely moves between shipments, so one cost per SKU is close enough to the truth
- You need a calculation unique enough to your business that no product models it
- You are quoting or modelling, not costing sales that have already shipped
When Landara makes sense
- You import regularly (monthly or more)
- You want to stop typing invoice data manually
- You sell on Shopify and need an accurate COGS per order
- You need a Stocky replacement now that Shopify has retired it
- Your time is worth more than $49/month
Why importers switch to Landara
The same accuracy, a fraction of the time
Upload instead of type
Drop your freight invoice PDF and watch AI extract every line item, amount, and category automatically.
Running COGS, not a formula
Landed cost feeds FIFO (or moving-average) cost layers, and every Shopify order is costed automatically, no formulas to build or break.
Push to accounting
Publish original invoices to Xero or QuickBooks with one click. No re-entering, no copy-paste errors.
Audit-ready history
Every calculation is saved with source documents attached. Show your accountant exactly how you got the numbers.
Common questions
Can I track COGS in a spreadsheet?
You can track landed cost in a spreadsheet perfectly well. Tracking COGS is a different job, because COGS is a cost attached to a sale, and the sale happens in Shopify where the file cannot see it. That is the line: a spreadsheet can tell you what a unit cost. It cannot tell you what the units you sold last month cost, unless you go back and match every order by hand.
Can I import my existing spreadsheet data?
You don't need to. Just start uploading your freight invoices going forward. Each calculation is independent, so there's no migration needed.
What if the AI gets something wrong?
Every extraction shows a confidence score, and you review and correct it before confirming. Nothing is costed from an extraction you have not approved, so a misread line becomes a correction on screen rather than a wrong number in your ledger.
Can I still export to a spreadsheet?
Yes. Every calculation can be exported to CSV or Google Sheets. Use Landara for extraction and calculation, then export if you need the data elsewhere.
Is my spreadsheet template still useful?
Your template helped you understand your cost structure. That knowledge transfers. Landara just removes the manual data entry and formula maintenance.
Can it replace my Shopify COGS spreadsheet?
Yes. Landara connects to your Shopify orders and costs each one with perpetual FIFO (or moving average), so you always know cost of goods sold. No running tally to maintain by hand. With Shopify having retired Stocky, it's a lightweight way to keep accurate COGS without a full inventory platform.
Does Landara post to Xero for me?
Yes, on your command. Landara produces the COGS journal (Dr COGS / Cr Inventory) and posts it to Xero or QuickBooks for you when you choose, or hands you a CSV. You stay in control of when it posts; Landara just does the FIFO maths a spreadsheet can't.
Ready to retire the COGS spreadsheet?
Connect your store and Landara costs every order against real FIFO layers, lands freight and duty into each one, then hands your bookkeeper a ready-to-post journal. Keep the spreadsheet for the jobs it is good at.