Inventory valuation methods: FIFO, average cost and specific identification, and what they do to Cin7, QuickBooks and Xero
Your gross margin is partly a choice. The same purchases and the same sales produce different COGS depending on the valuation method, and when your ERP and accounting system use different methods, the two sets of books drift apart quietly.

On this page
- What are inventory valuation methods and why do they matter?
- How does FIFO work?
- How does average cost work?
- How does specific identification work?
- FIFO vs average cost vs specific identification: what changes?
- Which valuation method does Cin7, QuickBooks Online, and Xero use?
- Why does your inventory valuation drift between Cin7 and your books?
- How should you choose a valuation method?
- Can you change your inventory valuation method later?
- Frequently asked questions
TL;DR
- Inventory valuation methods decide which purchase costs move to COGS when you sell and which stay on the balance sheet, so the method directly changes reported margin, inventory value, and tax.
- FIFO expenses your oldest costs first, average cost blends every purchase into one unit cost, and specific identification tracks the actual cost of each individual unit.
- Cin7 and the ledger often run different methods, and nobody notices until month end.
- The valuation method matters less than whether costs enter the system completely and on time, because landed cost, invoice timing, and costing changes with open stock cause most of the margin surprises we trace.
- Pick the method before go-live, document it, and reconcile inventory on hand between systems every month. The Fiskal Score shows which layer of costing needs work first.
The symptom usually shows up at month end. Gross margin moves in a way nobody can explain, the inventory asset in the books is off from the stock value in the warehouse system, and someone books a manual journal to close the gap. The gap reopens next month. Very often the root cause is a valuation method that was never chosen on purpose, or two systems that apply different ones.
This post covers the three methods that matter for a business holding stock, runs the same purchases through each, and explains how Cin7 Core, QuickBooks Online (QBO), and Xero treat them, so you can choose deliberately and keep both systems in step.
What are inventory valuation methods and why do they matter?
An inventory valuation method is the rule that assigns a cost to each unit sold and to each unit left on the shelf. The cost of a unit you sell becomes cost of goods sold (COGS) on the income statement, while the cost of units you still hold stays on the balance sheet as an asset. Change the rule and the split between those two numbers changes, even though nothing physical moved.
The rule also reaches taxes and reporting. When prices rise, FIFO produces higher reported profit and higher taxes, while LIFO produces lower profit and lower taxes, and under GAAP, FIFO, LIFO, weighted average, and specific identification are all acceptable methods of cost determination. The same Cin7 guide notes that IFRS does not allow LIFO, and that electing LIFO in the US means filing IRS Form 970 and using LIFO in your financial reports too. For a business selling across borders or planning to raise capital, that restriction alone narrows the field to FIFO, average cost, and specific identification.
How does FIFO work?
FIFO, first in first out, assumes the oldest units sell first, so the oldest costs go to COGS and the newest costs stay in inventory. Under FIFO, the first 100 units sold carry the cost of the earliest purchase, and whatever is left on the balance sheet sits closer to current prices.
FIFO suits most businesses holding stock because it mirrors how stock physically moves. Warehouses ship older stock first to avoid spoilage and obsolescence, so the accounting assumption and the physical reality line up. The trade-off is that in a rising-cost year, older and cheaper costs hit COGS, so margin can look healthier than what restocking costs you today.
How does average cost work?
Average cost, also called weighted average or moving average cost, blends every purchase into one unit cost and applies that blended cost to each sale. It smooths price swings, which makes it a good fit for commodity-like items you buy repeatedly at changing prices and cannot tell apart on the shelf.
The catch is that the blend is recalculated as new purchases arrive, so a late supplier invoice or a landed cost added after receipt moves the average and, with it, the value of everything on hand. Xero values tracked stock using the average cost method and records COGS automatically with every tracked sale, so this smoothing is built into the ledger for any Xero user, whether they chose it or not.
How does specific identification work?
Specific identification assigns the actual cost of each individual unit to the sale of that unit. It is the most precise method and the most labour-intensive, because every unit needs its own traceable cost. It fits high-value, unique, or serialised goods, and anything where batch or serial numbers already exist for traceability.
In Cin7 Core, this is the special costing option. Cin7 Core's costing methods include FIFO, FIFO by batch or serial number, FEFO by batch or serial number, and special (specific) batch or serial costing. FEFO, first expired first out, picks the batch with the earliest expiry and suits food, supplements, and cosmetics, where shelf life drives the picking rule.
FIFO vs average cost vs specific identification: what changes?
The same purchases produce different numbers under each rule. Take 100 units bought at $10, then 100 units bought at $12, and a sale of 150 units at $20 each, $3,000 of revenue. Under FIFO, COGS is $1,600, ending inventory is $600, and gross profit is $1,400. Under average cost, the blended unit cost is $11, so COGS is $1,650, ending inventory is $550, and gross profit is $1,350. Under specific identification, the answer depends entirely on which units were physically picked, anywhere between the two.
| Method | COGS uses | Ending inventory reflects | Best for | What to check |
|---|---|---|---|---|
| FIFO | Oldest purchase cost | Most recent costs | Most inventory businesses, perishables, international sellers | Margin can flatter you when costs are rising |
| Average cost | Blended cost of all purchases | The blended cost | Interchangeable items bought at shifting prices | Late invoices and landed costs move the whole average |
| Specific identification | Actual cost of the exact unit sold | Actual cost of units on hand | High-value, serialised, or batch-traceable goods | Needs unit-level tracking discipline |
Which valuation method does Cin7, QuickBooks Online, and Xero use?
Each platform applies a different set of methods, which is where the trouble starts for a business running Cin7 with an accounting system behind it.
- Cin7 Core costs each sale using FIFO, FEFO, or special costing, depending on the method set on the product. Cin7 Core costs each sale from the purchase cost of the stock picked, so every upstream mistake reaches gross margin.
- QuickBooks Online offers two options. QBO supports FIFO and Moving Average Cost, you should choose carefully because the method cannot be changed later, and QBO defaults to FIFO if you create an inventory item before choosing.
- Xero uses average cost. Xero records COGS and updates the inventory asset account using the average cost method each time a tracked item sells.
The mismatch is sharpest for a Cin7 plus Xero business. Cin7 calculates each sale from FIFO cost layers, while Xero would value any stock it tracks itself at average cost. That is one reason Fiskal sets the integration up so Cin7 owns inventory quantities and costing, and the accounting system receives journals rather than running a parallel valuation.
Why does your inventory valuation drift between Cin7 and your books?
The method itself is rarely the culprit. Cost entering the system late, incompletely, or on the wrong layer is the usual cause, and each pattern leaves a recognisable fingerprint.
| Symptom | Root cause | Fix |
|---|---|---|
| Margins look better than the bank balance suggests | Freight, duties, or brokerage coded to expenses instead of attached to the purchase order, so unit cost is understated | Attach third-party costs to the purchase and allocate them on the right basis |
| Inventory value moves with no new stock movement | A supplier invoice authorised after the stock was sold rewrites the estimated cost journals | Authorise invoices on a rhythm and diagnose before posting any journal |
| Unit cost keeps reverting after you correct it | The fix was applied to a display field, not the cost layer COGS is calculated from | Trace the error to the purchase receipt, landed cost, or sync layer |
| Margin spikes before month end | Revenue posted at invoice, cost relief waiting on shipment authorisation | Align invoice and shipment timing to the same reporting window |
A margin that looks wrong is usually a landed cost that never reached the unit, and Cin7 only calculates what it is told. Inventory that revalues itself is a purchase ledger trigger, not a stock ledger event. A fix that will not stick often means the correction went to the wrong layer of the cost architecture, and a margin spike right before close is the signature of revenue recognised before the matching cost entry has been triggered.
The two-ledger problem
FIFO charges the oldest cost to each sale. Average cost charges one blended cost to every sale. Both answers are defensible, but the owner's system and the accountant's ledger can apply different rules, and nobody reconciles them.
How should you choose a valuation method?
Start from how your stock moves and what your accounting system can support, not from the tax angle alone. Work through these steps with your controller before go-live.
- Map one real order flow. Follow a purchase, landed cost, sale, and return through the system and write down where cost lands at each step.
- Match the method to the physical flow. If you ship oldest first, FIFO describes reality. If you have expiry dates, FEFO describes it better.
- Check the accounting system's constraints. QBO fixes its method after setup, and Xero is average cost only, so the ledger limits what you can assume.
- Decide who owns costing. One system calculates cost, the other receives journals. Avoid two systems valuing the same stock.
- Write the policy down. Record the method, the cutover date, the rule for late supplier invoices, and the rule for landed costs added after sale.
- Lock the governance step. Reconcile inventory on hand between Cin7 and the ledger monthly, set lock dates that match your invoice timing, and ban retroactive changes to closed periods without a documented reason.
If the inventory asset and the warehouse stock value keep drifting apart, the cause sits somewhere between purchasing, receiving, landing, and shipping. Our Cin7 Core and QuickBooks Online reconciliation guide covers the monthly sequence, and our inventory accounting service ties each of those steps to the ledger so the margin on your income statement matches what moved through your warehouse. The Fiskal Score shows which layer of costing needs work first.
Can you change your inventory valuation method later?
You can, but treat it as a project rather than a setting. In QBO the choice is permanent once made. In Cin7 Core, the costing method on a product is the trap: a change with open transactions or stock on hand shifts which cost layers sales draw from, and the visible symptom is a margin movement nobody can tie to a sale. Plan the change at a period boundary, confirm tax treatment with your accountant, and expect to restate the opening position.
Frequently asked questions
Which inventory valuation method is best for a business holding stock?
FIFO is the most common fit because it matches how stock physically moves and is accepted under both GAAP and IFRS. Choose FEFO if expiry drives picking, average cost for interchangeable items bought at shifting prices, and specific identification for serialised or high-value goods.
Does Cin7 use FIFO or average cost?
Cin7 Core costs sales using FIFO, FEFO, or special costing on the product. Average cost appears in Cin7 as an informational value, and COGS is calculated from the cost layers of the picked stock rather than from that average.
Can QuickBooks Online use specific identification?
No. QuickBooks Online offers FIFO and Moving Average Cost only, and the choice cannot be changed after you set it. If you need unit-level costing, the ERP has to carry it and pass journals to QBO.
Does Xero support FIFO?
Xero's tracked inventory uses the average cost method. If you need FIFO or batch costing, run costing in your inventory platform and let Xero receive the journals.
Why does my inventory value in the books differ from my inventory system?
The usual causes are timing differences between receipt and supplier invoice, landed costs added after sale, and a costing method changed while stock was open. Trace the difference to its source before booking any manual journal, because a journal hides the cause while the drift continues.


