FIFO COGS (Shopify)
Seed cost layers, run the COGS report, reconcile, and post journals to your books.
Get your SKUs lined up
The order to do things in so your costs land on the right products: tidy Shopify first, take the baseline, then line up any remaining codes, calculate and sync. Why the baseline only happens once.
Bulk-edit product fields in a spreadsheet
Set your supplier's codes, the supplier's name and Shopify's cost per item for a whole catalogue in one CSV. Shopify's own product export cannot carry variant fields, so this is the bulk path that does not exist anywhere else.
Seed your cost layers
The five ways to give Landara the cost of your stock so it can cost your Shopify orders with FIFO.
Run the COGS report
Read your period COGS per SKU, switch between cost-at-sale and cost-at-fulfilment, match a payout window, and export.
How Landara and your books fit together
The full double entry picture: what raises your Inventory account, what releases it, and why transfers between locations post nothing at all.
What your stock is worth
The Inventory Valuation page: how Landara values your on-hand stock at FIFO cost, how to read the breakdowns, and how it differs from the COGS report and from Shopify.
Stock on hand and availability
One row per SKU showing what Shopify holds beside what Landara has costed, why the two are different facts, and the two gaps worth acting on.
Opening balances and differences
Opening a brand new accounting file, why an existing one never agrees on day one, and how Landara hands the difference to your accountant instead of journalling it away.
The journal your accountant posts
After you accept your opening difference, Landara shows one entry to be made in Xero or QuickBooks: move your old stock value across, and decide what to do with what is left.
Post a COGS journal
Post your period COGS to Xero or QuickBooks, close a period, and post a reconciling revaluation journal.
Reconcile vs Shopify
Compare Shopify on-hand to Landara's position, turn drift into costed adjustments, and pair a transfer between locations.
Run a stocktake
Count your physical stock, review the variance against Landara's FIFO position, and post shrinkage to a dedicated account, with barcode scanning. Pause, keep selling, refresh, or cancel a draft. A replacement for Stocky stocktakes.
What Landara picks up automatically
Which Shopify actions flow into your cost ledger on their own, which ones need a step from you, and how to tell the difference.
Move stock between locations
The three ways a transfer reaches Landara, why moving stock never changes what it cost or how old it is, and how to correct one you recorded wrongly.