MarCat

FIFO method for supermarket stock: on the shelf and in the books

FIFO in a supermarket means two things: old stock out first on the shelf, and a way of valuing stock in the books. Both explained with a store example.

By Swarbhanu Gupta, who has run Banjara supermarket in Ahmedabad since January 2025 (billing on MarCat since April 2026) · 13 November 2026

Ask a shelf filler what FIFO means and you will hear "old stock in front". Ask your accountant and you will hear something about valuing closing stock. Both are right. In a supermarket, FIFO (first in, first out) works in two places: on the shelf, where it decides which pack the customer picks up, and in the books, where it decides what your stock is worth.

FIFO starts on the shelf, and stock and inventory management software that tracks batches helps you check it.

This guide covers both, with a made-up store example.

FIFO on the shelf

The rule is simple: the stock that came in first goes out first. New stock goes to the back of the shelf, older stock is pulled to the front.

Why it matters in a supermarket:

  • Dates. Older packs expire first. If new stock is pushed in front, the old packs sit at the back until they are past their date.
  • MRP changes. When the MRP goes up, old packs carry the old MRP. Selling them first means fewer days with two prices on the same shelf, and fewer mistakes at the counter. Our guide on one product with two MRPs explains the billing side.
  • Damaged packs. Packs that stay at the back for months get crushed, dusty and faded. Customers leave them.

How to stack by FIFO, step by step

  1. Mark cartons when they arrive. Write the arrival month on the carton in thick marker, or the expiry month for food.
  2. Store room: new behind old. In the store room, new cartons go behind or below the older ones, never in front.
  3. Shelf filling: pull forward first. Before adding stock to a shelf, pull the existing packs to the front edge.
  4. Then fill from the back. New packs go behind them.
  5. Check the date while you fill. If a new pack has an earlier expiry than what is already on the shelf, it goes in front. That is FEFO (below).

FIFO or FEFO

FEFO means first expiry, first out. For food, it is the safer rule.

Most of the time FIFO and FEFO give the same answer, because the older delivery expires first. But sometimes a newer delivery has an earlier expiry date, for example when a distributor sends older stock from their own godown. A filler following "new to the back" without looking at the date gets this wrong.

Situation FIFO says FEFO says
Old delivery expires first Old in front Old in front
New delivery expires first Old in front New in front
No expiry date (detergent, utensils) Old in front Not relevant, use FIFO

So for food, teach FEFO. For everything else, FIFO is enough.

FIFO in the books

The second meaning is about money. When you sell 30 packs of an item you bought at different rates, what did those 30 packs cost you? The answer changes your profit and your closing stock value.

Under the Indian accounting standard on inventories (AS 2), goods like a supermarket's are valued using either FIFO or weighted average cost. Your accountant picks one and keeps it the same every year.

A worked example

Made-up numbers for one item, Tea 250 g, in one month:

Date What happened Packs Cost per pack
1st Opening stock 20 ₹24
10th Purchase 40 ₹26
During the month Sold 30
30th Closing stock 30 ?

FIFO: the 30 packs sold are taken from the oldest cost first.

  • Cost of packs sold: 20 x ₹24 + 10 x ₹26 = ₹480 + ₹260 = ₹740
  • Closing stock: 30 x ₹26 = ₹780

Weighted average: all packs get the same average cost.

  • Average cost: (20 x ₹24 + 40 x ₹26) ÷ 60 = ₹1,520 ÷ 60 = ₹25.33
  • Cost of packs sold: 30 x ₹25.33 = ₹760 (rounded)
  • Closing stock: 30 x ₹25.33 = ₹760 (rounded)

Same packs, same month, a ₹20 difference in the cost of what you sold. When purchase rates are rising, FIFO shows a lower cost of goods sold and a higher closing stock than weighted average. When rates fall, it is the other way round. Over a full year, across thousands of items, the gap can matter. Neither is "more correct". What matters is that your accountant uses one method, every year.

What this means for you as the owner

  • Ask your accountant which method your books use. Then read your margin reports with that in mind.
  • Keep purchase rates right. Both methods depend on the rate on each supplier bill being entered correctly, including free units from schemes.
  • Count before you value. A wrong closing quantity gives a wrong closing value, whatever the method.

Counting a FIFO shelf

When you count stock, count the back of the shelf and the store room, not just the front row. FIFO stacking means the newest stock is behind or below. A quick front-row count will always be short.

From our counter

We have run Banjara, our own supermarket in Ahmedabad, since January 2025. A few opinions from running one:

  • FIFO fails during the evening refill, not in the store room. When the shelf is half empty and the queue is long, the quickest thing is to put new packs in front. Plan refills for quieter hours where you can.
  • A marker pen at receiving does more than any rule. If the date is on the carton in big letters, people follow FIFO without being told.
  • The person who fills the shelf decides your MRP mistakes. Train the fillers, not just the cashiers.
  • Pick one valuation method and stop thinking about it. The shelf side of FIFO needs daily attention. The books side needs a decision once.

Where software helps

The shelf side of FIFO is people and habits. The books side depends on clean data: every purchase entered with the right rate and quantity, and every sale moving stock. Software that keeps batch, MRP and cost with each purchase gives your accountant the numbers either method needs, and shows you how much of each MRP is left to sell first.

How MarCat handles it

We have run Banjara, our own supermarket in Ahmedabad, since January 2025, and it has billed on MarCat since April 2026. This is what MarCat does here:

  • Batch, MRP and cost with every purchase. Every sale and every purchase moves stock automatically, with batch, MRP and cost tracking.
  • Old MRP and new MRP kept apart. When an MRP changes, MarCat asks whether to keep both prices or replace. Keep both, and each MRP has its own stock, so you can see how many old packs are left.
  • Reports for the accountant. Purchase, margin and GST-ready reports can be downloaded and given to your accountant.

If you want to see how MRP-wise stock looks on your own items, message us on WhatsApp at +91 96787 65518.

Questions

What is the FIFO method in a supermarket?
FIFO means first in, first out. On the shelf, the stock that came in first is placed in front and sold first. In the books, it means the cost of what you sold is taken from your oldest purchases first.
What is the difference between FIFO and FEFO?
FIFO goes by the date the stock arrived. FEFO, first expiry first out, goes by the expiry date on the pack. They are usually the same, but when a newer delivery has an earlier expiry date, FEFO is the safer rule for food.
Should my books use FIFO or weighted average?
Under the Indian accounting standard on inventories, goods like these are valued using either FIFO or weighted average cost. Your accountant chooses one and keeps it the same every year. Both are normal for a supermarket.
Does FIFO matter when the MRP changes?
Yes. Selling the old MRP packs first shortens the time both prices sit on the shelf together, which means fewer billing mistakes at the counter.