Daily sales report (DSR) builder
The end-of-day DSR every Indian restaurant needs but most still write on a half-torn KOT pad. Punch the day's sales by channel — dine-in, takeaway, Swiggy, Zomato, party — net out the aggregator commissions, add GST and service charge, split the tender across cash, UPI, card, wallet and aggregator settlement, capture covers, and close the cash float with a variance line. Printable A4 portrait, CSV export, and a live tender-match indicator so you catch the missing rupees before the manager goes home. No signup, no email gate.
Inputs
| Dine-in | ₹38,400 |
| Takeaway | ₹6,200 |
| Swiggy gross | ₹14,800 |
| Zomato gross | ₹11,200 |
| Other aggregator | ₹0 |
| Party / catering | ₹0 |
| Gross sales | ₹70,600 |
| Swiggy | ₹3,404 |
| Zomato | ₹2,576 |
| Other | ₹0 |
| Net sales | ₹64,620 |
| Cash | ₹12,300 |
| UPI | ₹21,450 |
| Card | ₹10,800 |
| Wallet | ₹0 |
| Aggregator settlement | ₹20,020 |
| Credit / khata | ₹0 |
| Tender total | ₹64,570 |
| GST collected | ₹3,960 |
| Service charge | ₹0 |
| Packaging | ₹420 |
| Total | ₹4,380 |
| Discount given | ₹850 |
| Complimentary | ₹320 |
| Dine-in covers | ₹46 |
| Avg cover (₹) | ₹835 |
| Opening float | ₹2,000 |
| Closing float | ₹2,000 |
| Expected cash | ₹12,300 |
| Cash deposited | ₹12,100 |
| Variance | ₹200 |
What a DSR captures
A daily sales report is the one document that turns a noisy shift — three POS terminals, two aggregator tablets, a UPI sound box, a khata book, a cash drawer — into a single end-of-day number that your owner, your accountant, and (eventually) your auditor can all read the same way. The minimum a DSR must reconcile is the three-way match: gross sales by channel must equal the net sales you can deposit, the GST you owe, and the tender you actually collected. If those three don't tie, something is wrong — a missed cash entry, a skimmed aggregator commission, a card swipe in the wrong batch, a comp meal punched as a paid bill.
The format here mirrors what a working independent restaurant in India actually needs to close: dine-in vs takeaway split, Swiggy / Zomato gross with commission netted out (the 22-25% bite is the single biggest leak operators under-track), GST and service charge as separate lines (because the GSTR-1 filer needs them split), a tender breakup that includes wallet and aggregator-settlement-later (because the cash you have in hand at midnight is not the same as the revenue you booked), covers and average cover (so you can spot a discount-leak the next morning), and an opening / closing float + cash-deposited line that produces the cash variance for the shift.
Where this fits
- Restaurant cash close process in India — the seven-step shift-close routine the DSR slots into
- Daily sales report Excel template for restaurants — the field-by-field reference behind this builder, plus the legacy Excel format if you need to mail it to your CA
- Daily cash reconciliation for Indian restaurants — how the DSR's tender breakup feeds the next-morning bank-deposit match
- Cash variance calculator — the deeper version of the variance line at the bottom of the DSR, with tolerance bands by format
- P1 — Cash close pillar — every cash-close article we've published, sequenced from first-shift to month-end