If you’ve been comparing FIFO and LIFO for your UK business, there’s a fact worth knowing before you go any further: LIFO isn’t actually a legal option for statutory accounts here. It’s used in the US, where GAAP permits it, but UK accounting standards, aligned with IAS 2 and FRS 102, don’t allow it. So the real decision most UK businesses are making isn’t FIFO versus LIFO. It’s FIFO versus weighted average.
TL;DR
- LIFO isn’t permitted under UK GAAP or IFRS, so it’s not a genuine option for statutory UK accounts, regardless of what US-focused guides suggest.
- FIFO assumes your oldest stock sells first and tends to reflect current replacement cost more accurately.
- Weighted average blends all your stock into a single running cost per unit, smoothing out price swings.
- The method you use changes your reported margin and stock value, not just how a spreadsheet is formatted.
- Blue Lotus 360 supports FIFO and weighted average as native costing methods, recalculating automatically as stock moves.
Why LIFO isn’t really on the table
Worth spelling this out properly, since a lot of generic ERP content treats FIFO and LIFO as two equally valid choices. Under IAS 2, the international standard, and FRS 102, the UK’s own standard for most companies, LIFO simply isn’t a permitted costing method for financial reporting. It’s not that it’s discouraged, it’s genuinely not an option for your statutory accounts.
This matters for anyone comparing ERP systems too. If a vendor’s promotional material heavily features LIFO capability, that’s usually a sign the software (or the content) was built with a US audience in mind rather than a UK one. Worth asking directly whether the costing methods on offer actually apply to how you’re required to report.
FIFO vs weighted average: the choice that actually matters
FIFO (first in, first out) assumes the stock you bought first is the stock you sell first. Physically, that’s often exactly what happens, particularly with anything perishable or subject to obsolescence. The cost of goods sold reflects older purchase prices, while what’s left on the shelf is valued closer to what you’d pay to replace it today.
Weighted average takes a different approach entirely. Rather than tracking which specific batch of stock left first, it blends the cost of everything you’re holding into a single average cost per unit, recalculated as new stock arrives. Every unit sold, regardless of which delivery it physically came from, is costed at that running average.
Here’s how the difference shows up with real numbers. Say you’re selling a component that you’ve bought in three batches:
- 100 units at £10 each
- 150 units at £12 each
- 100 units at £15 each
You then sell 200 units.
Under FIFO, those 200 units are costed using the earliest batches first: all 100 units at £10, plus 100 of the £12 units, giving a cost of goods sold of £2,200. Your remaining stock (50 units at £12, 100 at £15) is valued at £2,100, reflecting more recent, higher prices.
Under weighted average, you’d first calculate the blended cost across all 350 units bought (£10.86 per unit, roughly), then apply that single figure to the 200 units sold: £2,171. Your remaining 150 units are valued at the same average rate, £1,629.
The physical stock hasn’t changed between these two calculations. The reported cost of goods sold, and therefore your reported gross margin, has.
Why this matters beyond the number on a shelf
This isn’t just an accounting technicality that lives in a spreadsheet nobody looks at. Your chosen method feeds directly into cost of goods sold, gross margin, and the value of stock sitting on your balance sheet, three figures that genuinely shape how the business gets read by a lender, an investor, or your own management team deciding whether a product line is actually profitable.
In a period of rising supplier prices, FIFO tends to report a higher margin, since it’s costing sales against older, cheaper stock while your balance sheet shows inventory closer to current value. Weighted average smooths that out, which some finance teams prefer precisely because it doesn’t swing sharply when a single big purchase order comes in at a different price point.
Neither is objectively “better.” The right one depends on how your stock actually behaves, whether prices move a lot, whether you’re holding fast-moving or slow-moving inventory, and frankly, what your finance team is used to working with.
How this actually runs inside an ERP system
Manually, this calculation gets tedious fast, and error-prone the moment you’re tracking more than a handful of SKUs. Every purchase creates what’s effectively a “layer” of cost, and every sale needs to correctly consume from the right layer (for FIFO) or trigger a recalculation of the average (for weighted average).
A properly built ERP does this automatically, in the background, every time stock moves. FIFO systems track which batch a unit of stock actually belongs to and cost it out accordingly when it’s sold. Weighted average systems recalculate the running cost the moment new stock arrives, so every subsequent sale uses an up-to-date figure rather than a stale one from last month.
The practical benefit isn’t just saved time. It’s that your gross margin reporting stays accurate in real time, rather than being something finance reconstructs at month-end and hopes matches reality.
Where Blue Lotus 360 fits in
Blue Lotus 360 supports both FIFO and weighted average as native costing methods, applied automatically as stock moves rather than recalculated by hand. Cost layers update the moment goods are received, and margin reporting reflects the method you’ve actually chosen to use, not a rough approximation reconstructed after the fact.
If you’re unsure which method suits how your stock behaves, or you’re currently reconciling this manually every month-end, a demo is a straightforward way to see both approaches running against your own numbers.
FAQ Section
Can a UK business use LIFO at all?
Not for statutory financial reporting. UK accounting standards, aligned with IAS 2 and FRS 102, don’t permit LIFO. It may occasionally appear in internal management reports for specific analysis, but it isn’t a valid basis for your published accounts.
Which method gives a higher reported profit, FIFO or weighted average?
It depends on price direction. When supplier costs are rising, FIFO tends to report a higher margin because it costs sales against older, cheaper stock. Weighted average smooths that effect out, sitting somewhere between the extremes rather than tracking either the oldest or most recent prices closely.
Can I use different valuation methods for different product categories?
In many ERP systems, yes, applied at a product or category level rather than forced across the whole business. It’s worth confirming this with your accountant though, since consistency in application matters for audit purposes even if the specific method varies by product type.
How often does weighted average cost actually get recalculated?
In a properly built perpetual system, it recalculates every time new stock is received, not on a fixed schedule like monthly or quarterly. That’s what keeps the figure genuinely current rather than an averaged approximation from whenever it was last manually updated.
