Stock valuation methods: FIFO vs weighted average

The way you value stock changes your cost of sales and your profit. Here is how the two common methods differ.

By the AvrioBooks team · · 6 min read

Stock valuation methods: FIFO vs weighted average

This is general information, not tax or legal advice. Rules and rates change, so check GOV.UK or ask an accountant.

If you buy stock at different prices over time, you must decide which cost goes on each item you sell. That is your stock valuation method, and it affects cost of sales, profit and the value of what is left on the shelf.

An example

You buy 10 units at £5, then 10 more at £7. You sell 12 units.

FIFO (first in, first out)

The oldest stock is assumed to be sold first.

  • 12 units sold: 10 at £5 plus 2 at £7 = £64 cost of sales.
  • 8 units left: 8 at £7 = £56 stock value.

Weighted average

Every unit is given the average cost of what you hold. Here (10 × £5 + 10 × £7) ÷ 20 = £6 per unit.

  • 12 units sold: 12 × £6 = £72 cost of sales.
  • 8 units left: 8 × £6 = £48 stock value.

What this means

FIFOWeighted average
Cost of sales£64£72
Closing stock£56£48
Profit effect (rising prices)HigherLower

Total cost is the same, £120, but it is split differently between sales and stock. Over the full life of the stock, the difference evens out.

Which should you use?

  • FIFO matches the physical flow for perishable or dated goods.
  • Weighted average is simpler to run when items are interchangeable, because you do not track individual purchase batches.
  • Be consistent. Changing method needs a good reason and your accountant’s advice.
  • For UK tax and accounts, methods such as LIFO are generally not accepted. Check GOV.UK and ask your accountant.

Value at cost or lower

Stock is normally valued at cost or net realisable value, whichever is lower, so damaged or unsellable stock should be written down. See how to do a stock count.

Check your margins

See gross margin vs markup.

How AvrioBooks handles it

AvrioBooks uses weighted-average costing. Inventory, on the Premium plan, tracks movements, posts adjustments and reports on stock valuation. It does not offer FIFO. See inventory management software and products, services and inventory.

Frequently asked questions

What is the difference between FIFO and weighted average?

FIFO assumes the oldest stock is sold first. Weighted average gives every unit the average cost of what you hold.

Does the method change my profit?

It changes how total cost is split between cost of sales and closing stock, so profit in a period differs, but the total cost over the life of the stock is the same.

Which method does AvrioBooks use?

Weighted-average costing. It does not offer FIFO.

Is LIFO allowed in the UK?

It is generally not accepted for UK accounts and tax. Check GOV.UK and ask your accountant.

Written by the AvrioBooks team. We build cloud accounting software for small businesses, freelancers and their accountants, from Qodexify. This article is general information, not tax, legal or financial advice. Check GOV.UK or ask an accountant about your own situation.
Try AvrioBooks free Start a 30-day free trial with everything in Premium, no card needed. Start free trial
Newsletter

Accounting tips, tax dates and product news

Practical bookkeeping, VAT and Making Tax Digital guidance for freelancers and small businesses, plus AvrioBooks updates.

By subscribing you agree to receive emails from AvrioBooks. Unsubscribe at any time. See our privacy policy.

Sign up freeContact us