Book a call

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.

Fiskal7 min readUpdated
On this page
  1. What are inventory valuation methods and why do they matter?
  2. How does FIFO work?
  3. How does average cost work?
  4. How does specific identification work?
  5. FIFO vs average cost vs specific identification: what changes?
  6. Which valuation method does Cin7, QuickBooks Online, and Xero use?
  7. Why does your inventory valuation drift between Cin7 and your books?
  8. How should you choose a valuation method?
  9. Can you change your inventory valuation method later?
  10. 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.

MethodCOGS usesEnding inventory reflectsBest forWhat to check
FIFOOldest purchase costMost recent costsMost inventory businesses, perishables, international sellersMargin can flatter you when costs are rising
Average costBlended cost of all purchasesThe blended costInterchangeable items bought at shifting pricesLate invoices and landed costs move the whole average
Specific identificationActual cost of the exact unit soldActual cost of units on handHigh-value, serialised, or batch-traceable goodsNeeds 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.

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.

SymptomRoot causeFix
Margins look better than the bank balance suggestsFreight, duties, or brokerage coded to expenses instead of attached to the purchase order, so unit cost is understatedAttach third-party costs to the purchase and allocate them on the right basis
Inventory value moves with no new stock movementA supplier invoice authorised after the stock was sold rewrites the estimated cost journalsAuthorise invoices on a rhythm and diagnose before posting any journal
Unit cost keeps reverting after you correct itThe fix was applied to a display field, not the cost layer COGS is calculated fromTrace the error to the purchase receipt, landed cost, or sync layer
Margin spikes before month endRevenue posted at invoice, cost relief waiting on shipment authorisationAlign 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.

  1. 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.
  2. Match the method to the physical flow. If you ship oldest first, FIFO describes reality. If you have expiry dates, FEFO describes it better.
  3. 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.
  4. Decide who owns costing. One system calculates cost, the other receives journals. Avoid two systems valuing the same stock.
  5. 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.
  6. 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.

The Fiskal Score //

Want this sorted in your business?

We start with the Fiskal Score, a 100 point read on your people, process and technology.

Keep reading

Cin7 Core vs Cin7 Omni: which one fits your business

Cin7 Core is the self-serve platform with published plans, and Cin7 Omni is the customisable platform quoted by demo. This post shows how to pick between them by tracing one order through to QBO or Xero.

Fiskal6 min read