Skip to content
Stock and production for small businesses, in Arabic and EnglishRequest a demo
Back to the journal
Costing

Average cost and FIFO, in plain words

Two ways to put a value on the stock you sell and the stock you keep. One worked example, what each method tells you, and how to choose.

The question both methods answer

You bought the same item twice at different prices. Now you have sold some of it. What did the pieces you sold cost you, and what is the rest worth? The answer sets your gross profit and the value of your stock, so it matters even if you never open an accounting book.

Take an example. A shop buys 100 extension cables at EGP 50 each in September, then 100 more at EGP 60 in October after the price goes up. In November it sells 120.

Average cost: one price for everything on the shelf

Average cost mixes the purchases into one price. The shop paid EGP 5,000 plus EGP 6,000 for 200 cables, so each one costs EGP 55. The 120 sold cost EGP 6,600. The 80 left are worth EGP 4,400.

Every new receipt updates the average. If the next 100 arrive at EGP 64, the 80 cables at EGP 55 and the 100 at EGP 64 become 180 cables at EGP 60 each. It is simple, it smooths out price swings, and it is what most small shops and distributors need.

FIFO: the first in is the first out

FIFO keeps each purchase as its own layer and assumes the oldest stock leaves first. The 120 cables sold are the 100 from September at EGP 50 plus 20 from October at EGP 60: EGP 6,200. The 80 left are all from October, worth EGP 4,800.

The total is the same EGP 11,000 either way. What changes is how it is split between what you sold and what you kept. When prices are rising, FIFO shows a lower cost of sales and a higher stock value, because the stock on the shelf is valued at recent prices.

Which one to choose

Choose average cost if you buy the same items often and want one steady cost per item. Choose FIFO if your purchase prices change sharply, if you import in large shipments, or if your accountant asks for it. Both are accepted under IAS 2, the international standard for inventories; agree the choice with your accountant before you start.

In Ignitix Inventory the costing method is a workspace setting. Average cost is available on every plan; FIFO comes with Growth and above. The method can only be changed before any stock has moved, so the same history is never valued two ways.

Whichever you choose, the stock value report and every receipt, delivery and adjustment use it consistently, so the numbers on your screen are the same ones your accountant works with.

Further reading

Examples are illustrative and use fictional businesses. Costing and tax treatment depend on your circumstances; your accountant can help apply them to your business.

All articlesReorder points from your own sales