What Is an Hourly Sales Report?
A day’s total tells you how much, never when.
An hourly sales report breaks a single day’s takings into one row per hour, so you can see how many bills, how much money and what share of the day landed in each slot. It is the same transaction record behind your daily sales report, cut along time instead of category.
That cut is the only one you can put a roster against. In an Indian outlet where dinner runs past ten, the total and the shape tell very different stories.
What Each Hour Shows You
A usable hourly report carries five columns, and the last one is the one owners skip:
- Bills, which give you volume rather than only value.
- Items or covers, which separates a busy hour from a big-ticket hour.
- Net sales for the slot, after discounts.
- Average bill, which moves independently of the total.
- Share of the day, because 22% in one hour changes how you staff it.
Volume and value do not always move together. A lunch hour can turn a respectable number of bills at a much smaller average, which is why bills and average bill are worth reading side by side rather than one at a time.
One caveat sits underneath all five. The report timestamps the bill, not the visit, so a table that sat down at 7.30 and settled at 9.10 lands entirely in the 9 pm row, with nothing showing against the hour those covers actually occupied. Where orders get punched late, the whole shape shifts right and the peak reads later than it really is.
Hourly vs Daily Sales Report
Both are built from the same bills. They answer different questions, and mixing them up is why some outlets keep rostering to a total.
| Aspect | Hourly report | Daily report |
|---|---|---|
| Answers | When money came in | How much came in |
| Row | One per hour | One per day |
| Used for | Rosters, prep, promos | Targets, trends, closing |
| Blind to | Day-on-day trend | Everything inside the day |
A sales report is still the right place to compare Tuesday against Tuesday. What it cannot tell you is that half of Tuesday happened after 8 pm. Most systems build both from the same underlying data, so the question is which one you open on a Monday morning, not which one you pay for.
Hourly Sales Report Example
Take a family restaurant in Kozhikode reading back a Saturday.
| Hour | Bills | Net sales | Share of day |
|---|---|---|---|
| 1 pm | 38 | Rs 21,660 | 14% |
| 4 pm | 9 | Rs 4,230 | 3% |
| 8 pm | 54 | Rs 34,180 | 22% |
| 9 pm | 61 | Rs 38,940 | 25% |
| Day | 288 | Rs 1,54,700 | 100% |
Note: this is an invented example for illustration only, and only four of the day’s hours are shown.
What to Do With a Peak You Can Finally See
Nearly half that Saturday arrived between 8 and 10 pm. Three decisions follow from knowing it, none of which follow from the daily total.
Roster to the shape rather than the shift. If the 4 pm hour turns nine bills, the second server on the floor at 4 pm is being paid to wait. Post the 6 pm slot as an open shift instead and let someone claim the hours that actually carry covers. Kitchen prep moves the same way: the batch that has to be ready at 7.45 pm is not the batch you start at 11 am.
Then there is the trough. A dead 4 to 6 pm is where an offer costs you least, because you are filling seats that would otherwise stay empty rather than discounting a queue. The table turnover calculator will show what those seats are worth before you price the offer, and a busy floor is a different problem from an empty one.
Know the Shape of Your Own Day
The reports we see owners open most are the ones that close the day, which is fair enough: that is the number the accountant wants.
Petpooja POSS records every bill as it is raised and turns the day into downloadable reports covering sales, cancelled orders, payments and CRM, alongside day-end sales and inventory consumption. The timestamps are already sitting in that record.
A total closes the day, but only the shape tells you how to run the next one. Pull a single Saturday apart before you write next month’s roster, and see whether it matches the one you assumed.
Frequently Asked Questions
The daily report gives one row for the whole day, while the hourly report gives one row per hour of trading. Same bills underneath, cut along time rather than category.
The quietest one, not the busiest. A peak mostly confirms what the floor already knew, whereas a trough you had not noticed is where the roster and the offers are wrong.
No. A lunch hour can average Rs 570 a bill while the 9 pm hour averages Rs 638, which is why average bill belongs beside net sales rather than on its own.
Three or four of the same weekday, rather than one date. A single Saturday can be skewed by weather, a match or a local festival.
Yes. Any counter with uneven footfall, a chemist, a bakery or a grocery, has a shape to its day, and the reasoning about staffing and quiet-hour offers is the same.
