How to Build a Consumption Report: 6 Columns and 4 Steps

A consumption report is a list of what you actually used in a period, item by item. Six columns carry it: the item, its unit, opening stock, what you received, closing stock, and the consumption those four produce.

Purchases and consumption are different numbers. You start a month with stock already on the floor, so what you bought and what you got through will rarely match. Purchase figures tell you what you spent; only consumption tells you what the business used.

The useful part comes next. Once you know what you used, you can set it against what you should have used. That gap is the whole point of running the report.

This post covers the six columns and how to build the report from records you already keep. It also covers whether to run it daily or monthly, and how to read the gap.

Key Takeaways

• Six columns and one calculation: opening stock, plus what you received, minus what is left.
• That figure means nothing on its own. Set against what you should have used, it shows you where the money went.
• Most wrong consumption figures are not maths errors. They are a goods received note still sitting in a drawer.

What Goes in a Consumption Report?

Six columns do the job, and four of them you already record. This section sets out each one and what fills it.

The last column is calculated, and that matters. If anyone types a consumption figure straight in, the report stops being a check on anything and becomes a record of what someone believed.

Two columns are worth adding once the basic report is running: theoretical consumption, and the variance between the two. Both rest on knowing your kitchen inventory cost per item. Those turn a record into a test, and the section on reading the report covers what they do.

A note on where this sits. Our glossary pages define what a consumption report is and give the formula on its own. This post is about building and running one, so the definition here is deliberately brief.

Building a Consumption Report, Step by Step

You need three numbers per item and a period to put them in. This section walks the build in four steps, whichever way you keep your records.

The four steps

1. Fix the period and the item list first. A report covering a different set of items each month cannot be compared with last month’s. That comparison is where most of its value lives.
2. Carry the opening stock forward. It is last period’s closing stock, not a fresh count. If you count again at the start, you will find a difference and you will not know which count was wrong.
3. Add everything received. Purchase invoices, transfers in from another outlet, returns from a department. A goods received note that never made it into the system is the most common reason a consumption figure comes out too low.
4. Count the closing stock on the same day the period ends. It is the same figure your trading account needs, so it is worth getting right once. Not the next morning, and not across two evenings. A count taken a day late includes a day of use that belongs to the next period.

Why the closing count decides the rest

Getting the closing count right is the hard part, and it is the reason many businesses run the whole report late. A cycle counting routine spreads the work across the month so period end is not a single long night.

The steps above give you the middle box. The rest of this post is about the two below it.

Should the Consumption Report Be Daily, Weekly or Monthly?

Pick the period from how fast the stock moves and how much a mistake costs, not from the calendar. This section gives the three usual choices and who each suits.

Those three bands cover most stock, but almost nobody runs everything on one of them.

Why one period is rarely enough

Most businesses need more than one. A sweet shop in Indore might count khoya and paneer daily because they spoil, run packaging weekly, and leave dry goods to the month. A supermarket in Baner would count the dairy cabinet daily and the aisles monthly.

Running everything on one period is what makes the report feel like a chore.

A liquor counter is the clearest case for a short period, and bar inventory reports are usually run weekly for that reason.

The trap is starting daily on every item. Teams do it for a fortnight, the counts get rushed, and the numbers stop being worth reading. Start monthly on everything, then move up only the items where the monthly figure surprised you.

How Do You Read a Consumption Report?

You read it by setting it beside what the same output should have taken. On its own the report gives a quantity, which is not yet information. This section works through one item end to end.

Work one item through

Take a snack manufacturer in Indore running refined flour through a month (an example).

Now the second number. The month’s output was 4,800 packs, and the recipe uses 0.26 kg of flour per pack. That is 1,248 kg of theoretical consumption.

The gap is 57 kg, or 4.6% more than the recipe allows. At ₹42 a kg that is ₹2,394 of flour nobody can account for.

It has a short list of possible causes. The recipe quantity may be out of date, or something was received and never entered. A batch was spoiled without a record, or the closing count is wrong.

How big a gap matters

Judge the gap against your own history, not a published benchmark. A 4.6% variance in a month when a new line was being trialled means something different from 4.6% in a settled month.

What you want is a number that moved. The only way to see that is to keep last month’s report beside this one.

Where a variance keeps appearing on the same item, the cause is usually a process rather than theft. Reviewing your inventory control methods is a better use of a week than another count.

What Makes a Consumption Report Wrong?

Most bad consumption figures come from the same handful of errors, and none of them is the formula. This section lists the ones worth checking before you go looking for a culprit.

• Goods received but not entered. Stock arrives, the invoice sits in a drawer, and the report shows less received than reality. Consumption comes out too low.
• Transfers between outlets counted once. A chain moving stock between branches records it out of one and into the other. It is the hardest part of central kitchen management. Above ₹50,000 the move needs an e-way bill even though it is not a sale, and that document is the easiest thing to reconcile against.
• The unit changes halfway. Oil bought in 15 kg tins and issued in litres will produce a number nobody can use.
• Wastage never recorded. A spoiled batch that goes in the bin without an entry looks identical to a batch that walked out of the door.
• The count and the cut-off disagree. Counting on 2 March 2026 for a period that ended on 28 February 2026 puts two days of use in the wrong month.

Why it is usually the paperwork

Restaurant and shop owners we work with tell us the same thing about the first item on that list. The report is rarely wrong because someone calculated badly. It is wrong because paperwork arrived late.

That is the one error a system can remove rather than catch. Petpooja keeps the purchase entry and the stock movement in one module, so a receipt that is booked is already counted.

Conclusion

A consumption report answers one question: what did the business actually use this period, as opposed to what it bought. Six columns get you there, and only the last one is calculated.

The report earns its keep at the comparison. You set consumption against what the recipes or the bills say should have been used, and the difference stands out on its own line.

So start monthly, on the items where a mistake costs the most, and keep last month’s report beside this one. A single report tells you a quantity. Two tell you a direction.

Keeping the received column honest is where most of this stands or falls. That is a job for the system that records the purchase. A restaurant billing and inventory system records the purchase and the stock it adds as one action, rather than two.

Frequently Asked Questions