FIFO inventory valuation explained, with a worked example in JOD
What FIFO (first in, first out) means for inventory valuation, a step-by-step example in Jordanian dinars compared with the weighted average method, what IAS 2 allows, and how FEFO handles expiry dates in pharmacies and food businesses.
Every business that holds stock has to answer one accounting question each time it sells: which cost leaves the warehouse with the goods? When you bought the same item at three different prices, the answer changes your cost of goods sold, your gross profit and the value of the stock left on the balance sheet. FIFO, short for first in, first out, is one of the two answers that international accounting standards accept. This guide explains it with a worked example in Jordanian dinars, compares it with the weighted average method, and separates it from FEFO, the expiry rule that pharmacies and food distributors use on the shelf. If you are choosing a system to do this for you, our inventory software for Jordanian businesses page shows how Aspirations handles both methods.
What FIFO means
Under FIFO, the cost of the oldest units in stock is charged to cost of goods sold first. The units left at the end of the period are therefore valued at the most recent purchase prices. FIFO is a costing assumption, not a description of physical movement: a hardware store can pick any box from the shelf, but its books still assume the earliest-bought units were sold first.
The other accepted method is weighted average cost: every time stock comes in (or at period end, in a periodic system), the cost of all units on hand is averaged, and each sale is charged at that average.
What IAS 2 allows, and why LIFO is out
IAS 2 Inventories, issued by the IFRS Foundation, requires inventories to be measured at the lower of cost and net realisable value. For items that are ordinarily interchangeable, it allows only two cost formulas: FIFO or weighted average. Items that are not interchangeable, or are produced for specific projects, use specific identification of their individual costs.
LIFO (last in, first out) was removed when IAS 2 was revised in 2003, so it is not available to companies reporting under IFRS, which includes most Jordanian companies that prepare IFRS financial statements. You may still see LIFO in older textbooks or in material written for US GAAP, which is a different framework.
IAS 2 also expects the same formula to be used for all inventories of a similar nature and use. Switching from weighted average to FIFO is a change in accounting policy, which has its own disclosure rules, so it is a decision to make with your auditor rather than mid-year in a spreadsheet.
Worked example: one item, three prices
A distributor in Amman stocks a cleaning product. In January it has the following movements (all figures in JOD, to three decimals):
| Date | Movement | Units | Unit cost | Total cost |
|---|---|---|---|---|
| 1 Jan | Opening stock | 100 | 2.000 | 200.000 |
| 5 Jan | Purchase | 200 | 2.300 | 460.000 |
| 12 Jan | Purchase | 150 | 2.600 | 390.000 |
| Available | 450 | 1,050.000 | ||
| 20 Jan | Sale at 3.500 per unit | 320 |
FIFO calculation
The 320 units sold are costed from the oldest layer up:
- 100 units from opening stock × 2.000 = 200.000
- 200 units from the 5 January purchase × 2.300 = 460.000
- 20 units from the 12 January purchase × 2.600 = 52.000
Cost of goods sold is 712.000 JOD. The 130 units left are all from the latest layer: 130 × 2.600 = 338.000 JOD. Check: 712.000 + 338.000 = 1,050.000.
Weighted average calculation
Because both purchases arrived before the sale, the average cost on 20 January is 1,050.000 ÷ 450 = 2.333 JOD per unit (2.3333 unrounded). Cost of goods sold is 320 × 2.3333 = 746.667 JOD, and closing stock is 130 × 2.3333 = 303.333 JOD.
Side by side
| FIFO | Weighted average | |
|---|---|---|
| Sales (320 × 3.500) | 1,120.000 | 1,120.000 |
| Cost of goods sold | 712.000 | 746.667 |
| Gross profit | 408.000 | 373.333 |
| Closing stock (130 units) | 338.000 | 303.333 |
With rising purchase prices, FIFO gives a lower cost of sales, a higher gross profit and a closing stock value closer to current replacement cost. When prices fall, the effect reverses. Over the full life of the stock the total cost is the same 1,050.000; the methods only change when that cost reaches the income statement.
A note on perpetual and periodic systems: in this example every purchase arrived before the sale, so the moving average equals the period-end average. If the sale had fallen between the two purchases, a moving average would be recalculated after each receipt and give a different figure from a month-end average. Modern systems work perpetually, costing each sale at the moment it is invoiced rather than waiting for month end to know the gross profit.
Choosing between FIFO and weighted average
- FIFO keeps the balance sheet close to recent prices and matches the way perishable stock actually moves. It needs the system to track cost layers per item and per warehouse, which is impractical by hand once you have hundreds of items.
- Weighted average is simpler to explain, smooths price swings and is common in trading and distribution. Its weakness is that a single expensive or cheap purchase blends into the average and can hide a margin problem.
Whichever you choose, the cost going into each layer must be the full cost of purchase, including freight, insurance, customs duty and clearance. Our guide to calculating landed cost shows how to allocate those charges, and it matters as much as the formula itself. At period end, inventory is still written down if its net realisable value falls below cost, whatever formula you use.
FEFO: expiry dates on the shelf
Pharmacies, food distributors and supermarkets usually care less about which cost leaves first and more about which batch leaves first. FEFO, first expired, first out, is a picking rule: always issue the batch with the nearest expiry date, even if a later-dated batch arrived earlier. It reduces write-offs from expired goods and is the practical rule wherever products carry an expiry date.
FEFO and FIFO answer different questions. FEFO decides which physical batch to pick; FIFO or weighted average decides how that issue is costed in the books. A pharmacy can pick by FEFO and value by weighted average without any contradiction. What it needs is batch numbers and expiry dates recorded at goods receipt, so the system can suggest the right batch at sale and flag stock that is close to expiry. Our pharmacy software page describes how this works in practice.
Common mistakes
- Changing method to improve one year's profit. The standard expects consistency; a change needs a proper justification and disclosure.
- Leaving freight and duty out of cost. Expensing them directly understates inventory and distorts margins by item.
- Ignoring returns. A customer return should come back at the cost it left with, not at today's average or newest layer.
- No write-down for damaged or expired stock. A stocktake that finds expired batches should lead to an adjustment, as our stocktake guide explains.
FIFO and weighted average in Aspirations
In Aspirations, inventory is valued at weighted average by default, or by FIFO for the whole company if you choose it at setup; the method applies company-wide rather than per item. The system supports multiple warehouses and transfers, batch numbers with expiry dates, landed costs allocated to receipts, stocktake adjustments and reorder alerts, and it posts the cost of each sale to the general ledger. It is part of the wider Aspirations ERP. A drug database and insurance claims for pharmacies are not available. Plans are being finalised; a free trial is available.
This guide is general information based on IAS 2 as published by the IFRS Foundation. For your financial statements, confirm the method and any change of policy with your auditor or accountant.
