Daily Sales Report Format for a Small Shop (What to Include)
A daily sales report format for a small shop: fields to include, payment split, returns, cash counted vs expected, top items, and how to read a week of reports.
A daily sales report is a one-page summary of a shop's day. It should show the date, number of bills, gross sales, discounts, returns, net sales, tax collected, the split between cash, UPI and card, cash expected versus cash counted, the top-selling items, stock that ran out, and a short note. Fill it the same way every day.
The value is not in any single day's sheet. It is in being able to lay seven of them side by side and see what changed. That only works if every sheet has the same fields in the same order.
What does a filled-in daily sales report look like?
Take an illustrative kirana store in Nagpur run by Suresh. Here is his report for one Saturday:
- Date and day: Saturday, 10 October 2026. Prepared by: Suresh
- Bills: 186 (first bill A0412, last bill A0597)
- Gross sales: ₹48,620
- Discounts: ₹540
- Returns and cancelled bills: ₹380 (2 bills)
- Net sales: ₹47,700
- Average bill value: ₹47,700 ÷ 186 = about ₹256
- Payment split: cash ₹17,900, UPI ₹27,600, card ₹2,200 (total ₹47,700)
- Cash expected: ₹2,000 opening float + ₹17,900 cash sales − ₹600 paid out = ₹19,300
- Cash counted: ₹19,180. Difference: ₹120 short
- Top items by value: 5 kg atta, sunflower oil 1 litre, toor dal
- Ran out: 1 litre milk packets by 7 pm
- Note: ₹600 paid to the porter for unloading; short of ₹120 not yet explained
Every number on that sheet ties to another. Gross minus discounts minus returns gives net. Net equals the three payment modes added together. Cash expected comes from the float, cash sales and payouts. If any of these do not add up, the sheet itself tells you something is wrong.
What fields should a daily sales report include?
Here is the full format, in the order that makes it easiest to fill and check. Copy it into a register or a spreadsheet.
1. Header
- Date and day of the week
- Who prepared it, and who was on the counter
- Opening time and closing time, if they vary
2. Sales summary
- Number of bills, with first and last bill numbers
- Gross sales, discounts, returns and net sales
- Average bill value (net sales ÷ number of bills)
- GST collected, if you are registered: taxable value and tax, by rate
3. Payment split
- Cash, UPI, card, and any other mode, each as a total
- The UPI total from your payment app, written next to the UPI total from your bills
- Credit sales, if you give udhaar, listed by name
4. Cash reconciliation
- Opening float (the change you started with)
- Plus cash sales, minus cash paid out from the till, with what each payout was for
- Cash expected, cash counted, and the difference
- Cash taken to the bank or home, and the float left for tomorrow
5. Items and stock
- Top five items by value
- Items that ran out, and roughly when
- Items damaged, expired or written off today
- Items customers asked for that you did not have
6. Notes and sign-off
- Anything unusual: a bulk order, a power cut, a festival, rain
- Explanation for any cash difference
- Signature of the person who counted the cash
A sheet with a blank in the difference box looks the same as one nobody checked. Writing "₹0" tells you, a month later, that the count was actually done that day.
Why do discounts and returns need their own lines?
Because they are where money leaves quietly. A shop that writes only net sales cannot tell a slow day from a day with ₹2,000 of discounts. Discounts and cancelled bills are also the two places a dishonest counter would hide a missing amount, so seeing them every day, with a count, is a basic control.
How is a daily sales report different from a closing routine?
A closing routine is the set of checks you do before you lock up. The daily sales report is the record those checks produce. The routine asks the questions; the report is the page that keeps the answers.
The five questions worth asking at closing, and why daily beats weekly, are covered here: Daily Closing Routine for a Shop: Track Sales in 5 Minutes
How should you read a week of daily sales reports?
Once a week, put the seven sheets side by side and look across each line, not down each page.
- Compare each day with the same day last week, not with yesterday. Saturdays should be compared with Saturdays
- Watch the average bill value. If bills fall but the bill count holds, customers are buying less per visit
- Watch the UPI share. A sudden drop in UPI with a rise in cash deserves a question
- Add up the cash differences. Small ups and downs are normal; a run of shortages in one direction is not
- Check discounts as a share of gross sales. If it creeps up week after week, find out who is giving them
- List items that ran out more than once, and change the order quantity
In Suresh's case, a ₹120 shortage on one Saturday is not worth a fight. Four Saturdays in a row, always on the same counter, is a pattern worth looking into.
A cafe or restaurant needs extra lines for order types, covers and kitchen waste, set out here: Restaurant Daily Sales Report: What to Check Every Night
What makes a daily sales report useless?
- Filling it the next morning from memory instead of at closing
- Writing only net sales, so discounts and returns disappear
- Writing cash expected after counting the drawer, so the two always match
- Changing the format every few weeks, so no two sheets compare
- Counting the cash with the same person who sat at the counter all day, every day, with no second check
- Leaving out cash paid from the till, which turns every porter fee into an unexplained shortage
The third mistake is the most common and the most damaging. Work out the expected figure first, then count. Otherwise the report only ever confirms itself.
Should you keep the report on paper or in an app?
A paper register works if the owner fills it every single night. The weakness is that the numbers are written from the bills by hand, so a missed or wrong bill becomes a wrong report. A billing app builds most of the sheet itself from the bills, leaving you to count the cash and write the notes.
Mapis shows sales by payment method, by item and by cashier, and its day close puts cash counted next to cash expected. The format above still applies: it is a list of what to look at, whichever tool produces it.
If you would rather count the cash than add up the bills, here is how shop billing and day close work. See how Mapis handles daily sales reports for shops
One page, the same fields, every night. After a month, the stack of sheets will tell you more about your shop than any single busy day ever could.
Frequently asked questions
What should a daily sales report include?
Date, who prepared it, number of bills, gross sales, discounts, returns, net sales, average bill value, tax collected if registered, and the split between cash, UPI and card. Then cash expected versus cash counted, with the difference, the top-selling items, items that ran out, items written off, and a short note explaining anything unusual.
How do I make a daily sales report for my shop?
At closing, total the day's bills into gross sales, discounts, returns and net sales. Split net sales by payment mode and check that the modes add up to net. Work out cash expected from the opening float, cash sales and payouts, then count the drawer and write the difference. Add top items, stock-outs and a note.
What is the difference between gross sales and net sales?
Gross sales is the total value of everything billed before deductions. Net sales is gross sales minus discounts and minus returns or cancelled bills. Net sales is the figure that should match the cash, UPI and card you actually received. Showing both separately lets you see how much discounts and returns cost you each day.
How do I calculate cash expected in the till?
Start with the opening float, the change you put in the drawer in the morning. Add the day's cash sales. Subtract any cash paid out of the till, such as a porter's fee or a small purchase. The result is cash expected. Count the drawer and write the difference, even when it is zero.
How often should I review daily sales reports?
Glance at each one the same night, then review them together once a week. Compare each day with the same day of the previous week, watch the average bill value and UPI share, add up cash differences, and note items that ran out more than once. Patterns across a week matter more than any single day.