Restaurant Sales Reports: The 8 Reports Every Owner Should Check

This guide is for restaurant, cafe and fast food owners who have billing software full of reports and open perhaps one of them. By the end you will know which eight reports deserve your time, how often to read each, what question each one answers and what to change when the answer is not the one you wanted.

Which restaurant sales reports should an owner check

Most restaurant POS software can produce dozens of reports. The trouble is rarely a shortage of data. It is that nobody has decided which report belongs to which decision, so the owner looks at the total sale for the day and stops there. The table below is the whole system on one page.

Daily restaurant sales report and payment mode report

Daily sales

The daily sales report is the headline: number of bills, gross sales, discounts, net sales, tax and the average bill value. One figure alone tells you little. Two comparisons make it useful.

Compare with the same weekday last week, not with yesterday. A Tuesday will always look poor beside a Sunday. And split the change into its two parts: sales equal bills multiplied by average bill value. If Tuesday's sale fell from ₹42,000 to ₹36,000, check whether bills fell from 140 to 120 at the same ₹300 average, or stayed at 140 while the average dropped to ₹257. Fewer bills is a footfall problem: weather, a road closure, a new outlet nearby. A lower average is a menu or service problem: fewer starters and beverages per table, or a discount running too freely.

Payment mode

The payment mode report splits the day's collection into cash, UPI and card. Its first use is reconciliation: the cash line should match the drawer and the UPI line should match the credits in your bank account. The full routine is in the guide to the restaurant day end report and cash closing.

Its second use is trend. UPI now carries a large share of restaurant payments in Gujarat cities. If your outlet's cash share is far higher than you would expect for your area and your crowd, or suddenly rises under one cashier, ask why. If cash keeps falling, you can reduce the float and the bank trips.

Cancelled and void

This is the third daily report and it takes 30 seconds. It lists bills cancelled after printing and items removed from orders, with the user, time and reason. Most entries are innocent: a wrong table, a guest who changed the order. You are looking for patterns: voids clustered in the last hour, the same reason typed every time, a cancelled bill a few minutes after a cash settlement.

Hour-wise, item-wise and category-wise sales reports

Hour-wise sales

The hour-wise report shows bills and sales for each hour of the business day. A typical family restaurant in Rajkot might do 60% of its day between 7:30 PM and 10:30 PM, with a smaller lunch peak and a dead stretch from 3:30 PM to 6 PM.

It supports three decisions. Rostering: bring the second captain and the extra kitchen hand in at 7 PM, not at 5 PM. Opening hours: if 11 AM to 12 noon produces four bills a day, test opening at 12. Offers: a tea-time combo is meant to fill the dead stretch, and this report shows within two weeks whether it does.

Item-wise sales

The item-wise report lists every dish with quantity sold and value. Sort it by quantity and read both ends.

• The top 20 items usually carry well over half of the sale. Keep them available every day, keep their preparation fast and think hard before changing their price.
• The bottom 20 items are candidates for removal. An item that sells twice a week still needs its ingredients stocked and its recipe remembered.
• Sizes and add-ons deserve a look. If the half portion outsells the full by four to one, the full price may be set too high. If extra cheese is added to one pizza in three, it may deserve its own menu line.

One caution: this report shows what sold, not what earned. A dish can sell well and still earn little if its ingredients are costly. Billing software without recipe and stock management cannot show food cost, so combine the item report with your own costing for the top 20 dishes.

Category-wise sales

The category-wise report rolls the items up: dosa and uttapam, pav bhaji and fast food, Punjabi, Chinese, beverages, desserts. It answers bigger questions than the item report. If beverages are 4% of the sale in a restaurant where every table orders food, the staff are not offering drinks. If one category brings 8% of the sale but needs its own cook and counter, that is a cost decision. It also guides the menu card: the category that earns the most should not sit on the last page.

Discount and table turnover reports that protect margin

Discount report

A discount is the fastest way to lose margin without noticing. The discount report lists each discounted bill with the amount, the percentage, the reason and who gave it. Read three totals weekly: discount as a percentage of gross sales, discount by reason, and discount by user.

If discounts are 1.5% of sales and the reasons are mostly a known festival offer, fine. If they are 5% and the reason on most bills is blank or "regular customer", you have a control problem, not a marketing programme. The answer is a limit per role and a manager approval above it, covered in the post on restaurant discount control.

Table turnover

Table turnover is how many times a table is occupied and billed in a day. A 20-table restaurant that issues 90 dine-in bills has a turnover of 4.5. At peak, the constraint on sales is often not the kitchen but tables that stay blocked.

The report supports two decisions. Seating mix: if two-seat tables turn six times and eight-seat tables turn twice, consider tables that can be joined when a large group arrives. Speed at the end of the meal: if tables stay occupied long after the food is finished, the delay is in billing and payment, and a bill that carries a UPI QR for the exact amount shortens it.

A weekly 15-minute restaurant report review routine

Pick a fixed slot, such as Monday at 11 AM, and review the last seven days in this order. Keep a notebook with one line per week for each number, since the trend matters more than any single week.

1. Minutes 0 to 2, weekly sales. Total sales, bills and average bill value against the previous week. Note the strongest and weakest day.
2. Minutes 2 to 4, hour-wise. Confirm the peak hours have not shifted. Check the hours where you ran an offer.
3. Minutes 4 to 7, item-wise. Top 10 and bottom 10 by quantity. Mark any item in the bottom 10 for a third week running.
4. Minutes 7 to 9, category-wise. Each category's share of sales against last month's.
5. Minutes 9 to 11, discounts. Total as a percentage of sales, then by user.
6. Minutes 11 to 13, cancelled and void. Rate by captain and cashier. Pick the two oddest entries and ask about them.
7. Minutes 13 to 14, table turnover. Weekend against weekday.
8. Minute 15, one decision. Write down one change for the coming week and who will carry it out.

The last step is the point of the other seven. A review that ends without a decision is reading, not managing.

How Dhandhaan handles this

Dhandhaan is the restaurant POS and billing software from JK Tech Hub in Rajkot. All eight reports in this guide are in it: daily, weekly and monthly sales, hour-wise sales, payment mode split, item-wise and category-wise sales, the discount report, the cancelled and void report and table turnover. It also has captain-wise and cashier-wise reports, an invoice register, GST reports and a day end report printed at close.

The owner reads them in the web admin panel, which works in a phone browser, and a live dashboard shows the current day. Every report exports to Excel and PDF. Every discount, void, price change and settings change is written to an audit log, so the report shows what happened and the log shows who did it and when. For a multi-branch business, the cloud panel shows combined and branch-wise figures.

Two limits should be stated plainly. Dhandhaan does not include inventory, recipe or purchase management at present, so it reports sales and not food cost. It also has no customer accounts or loyalty module, so there are no customer-wise reports. The price is ₹12,999 a year for a single branch and ₹23,999 a year for multi-branch, with no charge per bill.

What we have seen with restaurant reports in Gujarat

We built Dhandhaan for a multi-branch South Indian and fast food restaurant business in Gujarat that was moving off a hosted POS. Reports were not the reason for the move, outages at peak hours were, but three things about reports became clear during the build and testing.

First, the business day decides whether reports can be trusted. With a midnight cut, a late Saturday spilled into Sunday and the hour-wise report showed a peak at the start of the day that belonged to the night before. Starting the business day at 4:00 AM fixed the daily and hourly reports together.

Second, reports are only as good as the habits behind them. If a table is freed when the bill is printed and not when it is settled, table turnover looks better than it is. If a discount can be given with no reason, the discount report is a list of numbers with nothing to act on. That is why a discount is entered with its reason at the moment it is given.

Third, the owner reads on a phone, away from the restaurant, in the gaps of the day. A report that needs the counter PC does not get read. That is why the admin panel was built to work in a phone browser.

What this means for your business

Start with the three daily reports this week. They take two minutes and they change how staff behave, because people act differently once they know the cancelled and void report is read every morning. Add the weekly review next week. Within a month you will have four rows in the notebook and the first trends.

If your current system cannot produce one of the eight reports, or produces it only at the counter, note that for your next software decision. The guide on how to choose restaurant billing software has a fuller checklist.

Related reading and next step

• Restaurant day end report and cash closing routine
• Restaurant discount control: how to stop billing leakage
• Restaurant table management: merge and split tables
• Multi-branch restaurant management software
• Restaurant POS software in Rajkot

To see these reports with sample data on your own phone, book a demo or ask for a quote through the contact page or on WhatsApp at +91 7265004040.