Blog/Guías de ecommerce

FIFO Method: What It Is, Examples and How to Apply It in Your Warehouse

FIFO method explained for online shops: what it is, stock and valuation example, differences with LIFO, FEFO and WAC, and how to apply it in your warehouse.

The FIFO method (First In, First Out) means the stock that arrived at your warehouse first is the stock that gets shipped first. It serves two different purposes: organising how physical product moves on the shelves, and calculating how much your inventory is worth for accounting purposes.

If you run an online shop, what matters most to you is the first one: making sure a box that's been sitting at the back of the shelf for eight months doesn't get left behind while you ship the one that arrived last week. Below you'll find a worked example, the differences with LIFO, FEFO and WAC, and how it's actually applied in a warehouse.

What is the FIFO method and what is it for

The FIFO method is a way of managing inventory in which the units that came in first are the first to go out. In the warehouse, this translates into locating and picking orders so that older stock rotates out first; in accounting, it means valuing what you sell at the cost of the oldest purchases and what's left at the cost of the most recent ones.

What it's used for, in practice:

  • Preventing product from ageing: packaging that yellows, outdated labels, packaging from a past collection or, in food and cosmetics, products that expire.
  • Spotting stock that isn't moving, because if the oldest items always go out first, whatever's left sitting still stands out.
  • Valuing inventory in a way that's consistent with how stock actually moves and what it genuinely cost you.

It's worth separating the two sides of FIFO from the start. You can value your inventory using FIFO in your accounts while your warehouse is complete chaos, or the other way round. Ideally, both should point in the same direction.

FIFO method: a simple stock and valuation example

Imagine a shop selling a cream. The figures are for illustration only, just to show how the calculation works.

  • 1 January: 100 units come in at €5 each (€500).
  • 1 March: 100 units come in at €6 each (€600).
  • During March and April: you sell 150 units.

How the physical stock moves

With FIFO, the 150 units you ship are the 100 from the January batch plus 50 from the March batch. You're left with 50 units on the shelf, all from the March batch. If the cream has an expiry date, you've just avoided letting the January batch go off.

How the inventory is valued

The cost of what's sold is calculated using the oldest prices first:

  • Cost of the 150 units sold: 100 × €5 + 50 × €6 = €800.
  • Value of the remaining stock: 50 × €6 = €300.

If you sold those 150 creams at €15 each (€2,250), your gross margin under FIFO would be €1,450. When purchase prices rise, as in this example, FIFO produces a lower cost of sales and a closing inventory valued at more current prices.

The same exercise worked out with WAC and LIFO

For comparison, here's the same case using the other two methods that crop up in every FIFO and WAC exercise:

  • WAC (weighted average cost): (500 + 600) / 200 = €5.50 per unit. Cost of goods sold: 150 × 5.50 = €825. Closing stock: 50 × 5.50 = €275.
  • LIFO (last in, first out): 100 × €6 + 50 × €5 = €850. Closing stock: 50 × €5 = €250.

Notice that the total always adds up: cost of goods sold plus closing stock comes to €1,100, which is what you paid. The only thing that changes is how it's split between what's sold and what's left. If you're looking for worked FIFO and WAC exercises to practise with, they all follow this same logic: a stock card with receipts, dispatches and balances, and the cost of each dispatch depending on the method used.

FIFO, LIFO, FEFO and WAC: differences and when to use each one

These acronyms get mixed up a lot, but they don't all answer the same question. FIFO, LIFO and FEFO are mainly about which physical unit goes out first. FIFO, LIFO and WAC are about how inventory is valued.

LIFO method

LIFO (Last In, First Out) dispatches whatever came in last, first. Physically, this makes sense for products that don't age and are stacked in storage, such as bulk materials or certain building materials: whatever's on top is the most accessible. For an online shop, it almost never fits.

As a valuation method, LIFO isn't permitted under current Spanish accounting standards (the Plan General de Contabilidad): the accepted methods are WAC and FIFO. Similar restrictions apply in most of the UK and EU, so if you're unsure which method to use for your accounts, check with your accountant.

FEFO method

FEFO (First Expired, First Out) dispatches whatever expires soonest, even if it arrived later. This is the key difference between FIFO and FEFO: FIFO looks at the arrival date, while FEFO looks at the expiry date.

They almost always line up, but not always. If your supplier sends you a batch in May that expires before the one you received in April (it happens more often than you'd think), FIFO would have you ship the April batch first, and the May one could expire sitting on the shelf. For food, supplements, cosmetics or pet products, FEFO rules.

WAC method (weighted average cost)

WAC doesn't decide which unit goes out first: it simply calculates an average cost every time new stock comes in. The difference between FIFO and WAC is that FIFO assigns each sale the actual cost of the oldest batch, while WAC assigns every unit the same average cost.

It's very common, and perfectly compatible, to value inventory using WAC in your accounts while moving physical stock using FIFO or FEFO in the warehouse.

What FIFO means for food products

In food settings, FIFO is applied in kitchens, bakeries and warehouses so that the oldest product is used first and waste is minimised. When a product has a use-by or best-before date, in practice it's managed as FEFO, which is the version of FIFO that tracks the date that actually matters.

Which one to use in your online shop

  • Non-perishable product (clothing, accessories, electronics, home decor): FIFO in the warehouse so packaging doesn't age and old collections don't get left behind.
  • Product with an expiry date or batch (cosmetics, food, supplements): FEFO, with batch and date tracking.
  • Accounting valuation: FIFO or WAC, whichever your accountant decides. Not LIFO.

The FIFO method in the warehouse: how it's applied in practice

Saying

Back to blog