Home » Growth Scaling » Use Your POS Sales Report to Improve Your Restaurant Menu

Use Your POS Sales Report to Improve Your Restaurant Menu

Across the 1,00,000+ restaurants on our POS, the owners who lift their margins share one habit. They read the sales report each month and act on it.

Your POS already tracks two things for every dish: how many you sold, and how much profit each one earned. Put those numbers side by side, and your menu sorts into four groups. Each group points to one call: keep, promote, reprice, or cut.

This guide shows how to read that report and make each call. It uses numbers your POS already holds, so you need no spreadsheet and no consultant.

Key Takeaways

  • Your POS report holds the two numbers behind every menu call: units sold and profit per dish
  • Sort dishes by those two numbers and each lands in one group: keep, promote, reprice or cut
  • A dish that sells well but earns little needs a smaller portion or cheaper recipe, not a bigger price
  • Read the report on a set day each month; acting on it beats a once-a-year menu overhaul
  • Your POS does the maths, so the real job is the decision, not the counting

What Two Numbers Does Your Sales Report Show?

Every menu call rests on two numbers, and your POS records both. The first is units sold: how many plates of each dish went out in the period you pick. The second is contribution margin, the price of a dish minus what its ingredients cost.

Say a paneer tikka (an example) sells at ₹240 and its ingredients cost ₹86. Its contribution margin is ₹154. That ₹154 is what the dish adds to your earnings each time it sells, not the ₹240 on the bill.

Your report shows both numbers for every dish. One tells you what customers love. The other tells you what pays your rent. If a dish’s ingredient cost is unclear, a food cost calculator works it out from the recipe.

What a Good Menu Report Includes

The two numbers are the start. A useful report holds a few more columns, and each one sharpens the call you make on a dish:

  • Units sold and contribution margin for every dish, over the period you pick
  • Menu mix percentage, so each dish’s share of orders is clear at a glance
  • Food cost percentage, to catch a dish whose recipe cost has crept up
  • This month against last, so a fading star shows up before it turns into a dog

A POS pulls all of these onto one screen. If you track them by hand, start with the first two and add the rest as you go.

How Do You Pull the Report?

You do not need a new tool for this. Most restaurant POS systems keep it under a reports or analytics tab. Four steps get you there:

  1. Open the item-wise sales report for the month you want to review.
  2. Add the cost or margin column if it is not shown, so profit sits next to sales.
  3. Sort by units sold, then scan the margin column for the odd ones out.
  4. Export to a sheet only if you want a record; the POS view is enough to decide.

On the Petpooja POS, this lives in the reports section and updates as bills go through, so the numbers are always current.

How Do You Sort the Report Into Four Groups?

Two lines turn the report into four groups, and you draw both from your own data. For profit, find the average contribution margin across all dishes. Anything above it is high-profit, anything below it is low.

For popularity, use each dish’s share of total orders, its menu mix percentage. A common benchmark is the 70% rule: divide 100% by your number of items, then take 70%. With 20 dishes (an example), any dish above a 3.5% share counts as popular.

With both lines drawn, every dish falls into one of these four groups.

Profit per dish How often it sells Puzzles promote or reposition Stars keep and feature Dogs rework or cut Plough-horses reprice or trim cost
Each dish maps onto two axes from your report: how often it sells, and how much it earns.
Menu groupSellsEarnsYour call
StarsHighHighKeep and feature
Plough-horsesHighLowReprice or trim cost
PuzzlesLowHighPromote or reposition
DogsLowLowRework or cut

What Should You Do With Each Group?

Stars sell well and earn well. Protect them. Keep the recipe steady and give them a prominent spot on the card. These few dishes carry most of your profit, so guard their quality and supply. Do not fix what already works.

Plough-horses sell well but earn little, so a big share of your bills carry thin profit. Look at portion size or supplier cost first. A small ₹10 to ₹15 rise often helps, or you can reduce food cost on the recipe.

Puzzles earn well but hide. A high-margin dish that barely sells usually needs a better position on the card or a clearer name, not a price change. A short, tempting line next to it often gives it the nudge it needs.

Dogs sell little and earn little. Rework the recipe once to see if a better version moves. If it still does not sell next month, cut it and free the space for something that does.

RECOMMENDED READ  FoSCoS Portal: How to Apply for an FSSAI Licence in 7 Steps

Should You Read Delivery and Dine-In Separately?

Yes, when your POS lets you. The same dish earns less on Swiggy or Zomato than at your table, because the apps take a commission. A delivery commission calculator shows what each app leaves you. A dish that looks like a star on your counter can slip to a plough-horse on delivery.

So pull the report by channel where you can. Reprice for delivery to hold your margin, and keep dine-in prices where regulars expect them. One blended number can hide a dish that only loses money on the apps.

How Often Should You Read the Report?

Read the report on the same day each month, say the 30th. A menu change shows up in the next month’s numbers, not the next day, so a monthly rhythm suits most restaurants.

Doing this by hand means counting bills and matching each sale to a recipe cost. That takes days you do not have during a weekend rush. This is where the software earns its place.

When each dish links to its recipe on the item master, the POS already knows what sold and what each plate cost. The Petpooja POS hands you the four-group sort as a report you read, not a spreadsheet you build.

A Worked Example You Can Copy

Take a family diner in Vastrapur, Ahmedabad (an example) with 120 dishes. Its owner opens the June 2026 report and finds the menu averages a ₹150 contribution margin. Each dish then gets read against that line and its share of covers.

Dish (example)Plates soldMargin per plateGroupThe call
Dal makhani640₹78 (below average)Plough-horseSmall ₹15 rise, tighter portion
Grilled fish48₹190 (above average)PuzzleMove to top of mains, add a line
Paneer platter22Below averageDogTake it off the card

None of this needed a new kitchen or a new chef. It needed the report, a clear read on each group, and a reprint.

Common Mistakes When Reading the Report

A report only helps if you read it right. A few slips trip up owners most often:

  • Judging on sales alone. The dish that sells the most can still lose you money. Read popularity next to margin, never on its own.
  • Cutting a dish too fast. Give a reworked dish one full month before you drop it. One slow week is not a trend.
  • Ignoring the direction. A star fading month on month needs attention before it becomes a dog. The trend matters as much as the number.
  • Repricing everything at once. Change a few dishes, watch the next report, then adjust. A blanket rise drives regulars away.

Where Do You Go From Here?

Reading the report tells you what to change. Two more skills turn that into sales. For the full method behind the four groups, see our menu engineering guide.

To shape how each dish reads on the card, our menu design post covers layout and wording. To set the right price without losing regulars, our menu pricing guide walks through it.

India’s food services market is on track to cross ₹10.7 lakh crore by 2030 (IBEF), so the margin on each dish is worth guarding.

Conclusion

A menu that earns more is not a bigger menu or a cheaper one. It is a menu where every dish has been read against your own report and given a clear call: keep, promote, reprice, or cut.

Your POS already holds the numbers. Set a day each month, read the four groups, and act. Let the Petpooja POS carry the maths, so you can focus on the decisions only you can make.

Frequently Asked Questions

1. What food cost percentage should my dishes aim for?

Most restaurants keep food cost between about 25% and 35% of a dish’s selling price. Pizzerias often run lower, and fine dining can sit above 40%. Your report flags the dishes that drift outside your own range, so you can rework them or cut food wastage on the recipe.

2. Should I cut every dish in the dogs group?

No. Some dogs earn their place for other reasons. A cheap dish that keeps families coming, or a signature item that defines your brand, can stay even with thin numbers. Cut only the dogs that add nothing, since a shorter menu is easier to run.

3. How is reading the report different from just raising prices?

Raising prices is one move. The report tells you which dishes can take a rise. Others need a smaller portion, a cheaper recipe, or a better spot instead. A price rise on the wrong dish loses regulars, so the sorting comes first.

4. Does this work for a delivery-only cloud kitchen?

Yes, and the data is often cleaner. A cloud kitchen reads its sales straight from Swiggy, Zomato and its own online ordering app. The one change is cost. Delivery commission eats into each dish’s margin, so work out contribution margin after the commission, not before.

5. How soon will I see results after acting on the report?

Give it one full sales cycle, usually a month. Repositioning a dish or a small price change shows up in the next report, not the next day. Check the same numbers again after four weeks, and if a puzzle still does not sell, try another fix.

Avani Joshi
Avani Joshi
Avani Joshi is a Content Writer at Petpooja, where she writes about payroll, billing, and the everyday software that keeps Indian SMEs running. She has a knack for taking complicated topics and explaining them in plain language for business owners who don't have time to decode jargon.

RELATED UPDATES

Leave a Reply

Take a free demo