العربية

FIFO inventory valuation explained, with a worked example in JOD

By CS-Aspirations · Updated

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):

DateMovementUnitsUnit costTotal cost
1 JanOpening stock1002.000200.000
5 JanPurchase2002.300460.000
12 JanPurchase1502.600390.000
Available4501,050.000
20 JanSale at 3.500 per unit320

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

FIFOWeighted average
Sales (320 × 3.500)1,120.0001,120.000
Cost of goods sold712.000746.667
Gross profit408.000373.333
Closing stock (130 units)338.000303.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.

Official sources

Frequently asked questions

What is FIFO in inventory?

First in, first out: the cost of the oldest units in stock is charged to cost of goods sold first, so the stock left at period end is valued at the most recent purchase prices.

Is LIFO allowed under IFRS?

No. IAS 2 allows only FIFO or weighted average for interchangeable items, plus specific identification for items that are not interchangeable. LIFO was removed in the 2003 revision of IAS 2.

Which gives a higher profit, FIFO or weighted average?

When purchase prices are rising, FIFO usually gives a lower cost of goods sold and a higher gross profit. When prices are falling, weighted average gives the higher profit. Total cost over the life of the stock is the same.

What is the difference between FIFO and FEFO?

FIFO is a costing method for the books. FEFO (first expired, first out) is a picking rule that issues the batch with the nearest expiry date first. A pharmacy can pick by FEFO and value stock by weighted average or FIFO.

Can I change from weighted average to FIFO?

It is a change in accounting policy under IFRS and needs a justification and disclosure. Agree it with your auditor and make the change from the start of a financial period.