FIFO cost of goods sold
for Shopify
Shopify counts every unit you sell. What each unit cost you sits in a spreadsheet your store has never seen. Landara connects the two, and costs every order first-in, first-out against the real cost of each delivery of stock.
Free tier available. No credit card required.
Landara is first-in, first-out (FIFO) cost of goods sold for Shopify. Shopify keeps counting your stock. Landara keeps a cost for every delivery of stock, lands freight and duty into it, draws the oldest delivery down first as orders ship, and hands your bookkeeper a ready-to-post COGS journal for Xero or QuickBooks.
A spreadsheet your store has never seen
Shopify knows what everything sold for. It has no idea what any of it cost. That lives in a spreadsheet, or in a "Cost per item" field typed once, and neither can keep up with a store that is selling.
Disconnected
It cannot see a sale. Your store sells forty units and the file has no idea, so every margin in it drifts from the day you typed it.
Late
The forwarder bills weeks after the stock lands, and the customs broker after that. By then you have sold units at a cost you did not have yet.
One cost per SKU
Shopify holds one Cost per item and overwrites it. FIFO needs a cost for every delivery of stock, drawn down oldest first.
Month-end by hand
Export, look up, allocate, hope. The COGS figure gets rebuilt every month, and it is still the number your accountant has to sign.
A worked example
What a late freight invoice does to COGS
A container of 1,000 units lands. Supplier invoice: $10,000, so $10 a unit. 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.
COGS understated on the 400 units already sold
$1,100
The 600 units on hand, undervalued by
$1,650
Landara lands those bills into that delivery's cost, so the units already sold are costed right. If the month is already posted, you get a correcting journal, not a rebuild.
How Landara costs every order
Connect Shopify once. Landara costs every order FIFO and hands you a ready-to-post journal.
Connect Shopify
Landara reads your orders, fulfilments, and stock movements (never customer data). Costing starts the moment you connect.
Cost every order, FIFO
Every delivery of stock keeps its own cost, which Landara calls a cost layer. Each sale draws down the oldest first. Moving average is there if your accountant prefers it.
Land freight & duty
Import your stock? Allocate freight and duty per SKU so real landed cost feeds each layer. Your COGS is only as good as your cost.
Post the journal
Get a clean period COGS figure and a Dr COGS / Cr Inventory journal. Landara posts it to Xero or QuickBooks for you when you choose, or hands you a CSV. You decide when it posts.
Finance-grade inventory truth
Not more inventory tracking. FIFO cost behind every sale, freight and duty landed into every unit, a ready-to-post journal every month, and books that match the warehouse.
Why accurate COGS matters
Real cost of goods sold means real margins, and books that tie out.
Trust your margins
Perpetual FIFO COGS means your profit reflects what each unit actually cost, not a stale number stapled to every sale.
Find money-losing products
Some products look profitable until freight and duty land on them. Spot the losers before they drain your cash flow.
Price promotions correctly
Running a 20% off sale? Make sure your discount doesn't push you below what the unit actually cost.
Books that tie out
Every period, Landara posts a clean Dr COGS / Cr Inventory journal to Xero or QuickBooks for you on your command, or hands it over as a CSV. Nothing touches your ledger until you say so.
What only Landara does
Plenty of tools will show you a cost. These are the differences that decide whether the number survives contact with your accountant.
Cost layers per receipt, not one cost field
Shopify holds a single cost per variant and overwrites it whenever it changes, so last month's cost is simply gone. Landara keeps a dated layer for every receipt, which is what FIFO requires and what makes the figure auditable months later.
A journal your accountant posts, not a number you retype
A Dr COGS / Cr Inventory journal ready for Xero or QuickBooks, alongside revaluation, write-down and shrinkage journals. You review it and you post it. Landara never writes to your ledger unasked.
Landed cost inside the layer, not on a spreadsheet beside it
Freight, duty, insurance and clearance are allocated across the units on the shipment, so the layer that depletes on a sale already carries what it truly cost to land those goods.
Recoverable import tax stays recoverable, never capitalised
Import GST and VAT are reclaimable, so they never inflate inventory value, while customs duty correctly does. Tools that treat every border charge alike overstate landed cost and leave the tax off your BAS.
Two costing bases, not one opinion
Cost at sale and cost at fulfilment, switchable whenever you need. They are two views of the same COGS and are never summed, so you can match whichever basis your accountant works from.
A ledger with no delete button, not an editable history
A correction is a reversing movement, never a deletion, so the audit trail behind a period you have already posted stays intact. That is the difference between a record and a working file.
Shopify keeps owning quantity, so there is no migration
Landara never maintains a competing stock-on-hand number and never asks you to move inventory into another system. Connect it, and it costs the movements Shopify already reports.
Built for the cost side only, and honest about it
Landara does not forecast demand or run your reorder workflow, and will tell you so. It does the one job with an accounting deadline behind it, which is why it sits beside whatever you pick for planning.
Direct Shopify integration
Connect your Shopify store once and apply your costs. Landara reads your orders and fulfilments, matches each sale against dated FIFO layers, and keeps a running COGS figure it can post to your accounting for you any period.
- Reads orders & fulfilments by SKU
- Perpetual FIFO or moving-average costing
- Ready-to-post journal each period
your-store.myshopify.com
Connected
Learn more about ecommerce costing
How Do I Track FIFO COGS for Shopify?
The 4 realistic ways to track cost of goods sold, compared honestly.
Read moreWhy Is My Shopify Inventory Always Wrong?
The 6 causes of drift, and how to cost the variance instead of deleting it.
Read moreGet Shopify COGS Into Xero or QuickBooks
How the monthly Dr COGS / Cr Inventory journal works, step by step.
Read moreCommon questions
What is FIFO cost of goods sold?
First-in, first-out (FIFO) costs each unit you sell at the price of the oldest stock still on hand. Buy 100 units at $10, then 100 more at $12, and the first 100 sales cost $10 each while the next 100 cost $12. Your COGS follows what the stock actually cost, delivery by delivery.
Does Shopify track cost of goods sold?
No. Shopify tracks quantity and has a single Cost per item field, which is a current snapshot rather than a history. Reports built on it reprice historical sales at today's cost. Real COGS needs a dated cost layer per receipt, which is what Landara maintains against your orders.
Is Landara a replacement for Stocky?
For the cost side, yes. Shopify has retired Stocky and directs former users to manage inventory in the Shopify admin and Shopify POS. Landara replaces the parts that matter for your numbers: perpetual FIFO COGS, stocktakes with barcode scanning, landed cost per unit, and a ready-to-post journal. Shopify keeps tracking quantity; Landara does not replace how your store manages stock.
Do I have to stop using Shopify inventory tracking?
No. Shopify stays the source of truth for quantity. Landara reads orders, fulfilments and stock movements (never customer data) and attaches cost to them. Nothing about how you run your store changes.
How does the COGS journal get into Xero or QuickBooks?
Each period Landara produces a Dr COGS / Cr Inventory journal from the FIFO ledger. You review it, then Landara posts it to Xero or QuickBooks on your command, or hands you a CSV. Nothing touches your ledger until you say so.
Shopify counts your stock. Landara costs it.
Connect Shopify and every order is costed first-in, first-out against the real cost of each delivery, with a ready-to-post COGS journal for Xero or QuickBooks. No inventory system to run.
Free tier available. No credit card required.