A daily sales report for a small shop is a one-page summary of everything you sold in a single day — the number of bills, the total value, how much came in as cash versus credit, and the GST you collected. Reading it at closing time takes about two minutes and tells you whether the day went the way it felt. This guide explains what a daily sales report should show, how it helps at GST time, and walks through a worked example for a Maharashtra shop.
What a daily sales report should show
You don’t need a fancy dashboard. A useful daily sales report for a small shop answers a handful of plain questions:
| What to check | Why it matters |
|---|---|
| Number of bills | A quick sense of footfall — busy day or slow day. |
| Total sale value | The headline number: what you sold today. |
| Cash vs credit | How much actually hit the drawer versus how much went on udhaar. |
| GST collected | CGST + SGST (or IGST) for the day — needed at return time. |
| Top items | What’s moving, so you reorder before you run out. |
| Discounts given | Money left on the table across the day. |
If you can see those six things in one place, you’re reading your shop correctly. Anything more is a bonus.
Why the daily habit beats the monthly scramble
Most shopkeepers only add up their sales when the GST return is due — and then spend an evening sorting a shoebox of bills. Checking a daily sales report instead turns that into a two-minute habit:
- Nothing goes missing. You catch a mis-entered bill or a forgotten credit sale the same day, not four weeks later.
- GST time is calm. Your month is already added up, day by day, when GSTR-1 (around the 11th) and GSTR-3B (around the 20th) come around. Confirm the current due dates on gst.gov.in.
- You spot trends early. A slow week or a fast-selling item shows up while you can still do something about it.
Under GST, a registered person is expected to keep an account of outward supplies — your sales — as part of the books of account (see the accounts and records rules on cbic.gov.in). A day-wise sales record is the simplest way to keep that account tidy. Exactly what your shop must maintain can vary, so confirm the current rule on gst.gov.in or with your CA.
Day book vs sale register: which report do I read?
Two reports get called “daily,” and it helps to know the difference:
- Day book — every transaction of the day in the order it happened: sales, customer receipts, and payments out. The broad view of your counter.
- Sale register — only your sales bills, usually with the CGST/SGST or IGST split shown. This is the one you hand your accountant.
For the two-minute closing check, the day book is usually enough. For GST work, the sale register is what you’ll lean on.
A worked example: one day at a Nagpur shop
Sunita runs a general store in Nagpur, Maharashtra. All her customers are in Maharashtra, so every sale is intra-state — the GST splits into CGST + SGST. Here is her day book for 10/08/2026:
| Bill | Taxable value | Rate | CGST | SGST | Bill total |
|---|---|---|---|---|---|
| Bill 1 | ₹1,000 | 18% | ₹90.00 | ₹90.00 | ₹1,180.00 |
| Bill 2 | ₹500 | 5% | ₹12.50 | ₹12.50 | ₹525.00 |
| Bill 3 | ₹2,000 | 18% | ₹180.00 | ₹180.00 | ₹2,360.00 |
Now the day’s totals, added down each column:
- Bills: 3
- Taxable value: ₹1,000 + ₹500 + ₹2,000 = ₹3,500
- CGST: ₹90.00 + ₹12.50 + ₹180.00 = ₹282.50
- SGST: ₹90.00 + ₹12.50 + ₹180.00 = ₹282.50
- Total collected: ₹3,500 + ₹282.50 + ₹282.50 = ₹4,065
Cross-checking the bill totals: ₹1,180 + ₹525 + ₹2,360 = ₹4,065 — the two ways of adding up agree, which is exactly what a clean daily report should confirm.
One more split worth reading: of that ₹4,065, Sunita took ₹3,540 in cash and gave ₹525 on udhaar (Bill 2, to a regular customer). Cash in the drawer plus credit given back to ₹4,065. Knowing that split at closing is how you keep your dues from quietly piling up — see our guide to tracking udhaar khata digitally.
(The 5% and 18% figures follow the current GST slabs — always confirm the rate for your specific goods on cbic.gov.in, as rates do change.)
Turn the shoebox into a two-minute read
You can build all of this in a notebook or a spreadsheet. The catch is doing it accurately, every single day, while also running the counter — and having the tax split come out right without hand arithmetic.
Yojika is offline-first GST billing software for Indian small shops, and the reports come out of the bills you’re already making. A day book, sale register and bill-wise profit are ready the moment you need them, you can filter by date or party, and every report exports to CSV, PDF or Excel for your accountant. The CGST/SGST/IGST split is worked out automatically on each bill, so your daily totals are correct without you adding a single column. And because Yojika is offline-first, all of this stays on your own PC — your sales are your business, not someone’s cloud.
- See the reports and everything else on the features page.
- Or download Yojika and try it free for 14 days.
Want to go further than sales? Pair this with our guide to managing shop inventory for a small business, so what you sell and what you stock stay in step.
This article is general information, not tax advice. GST rules, rates and due dates change — confirm the current position on gst.gov.in or with your CA.