Daily collection report India
Summarise all daily collections — cash sales, aggregator orders (Swiggy, Zomato with commission deduction), and card / UPI payments. Net revenue and closing cash compute automatically. Print a print-ready daily collection report for manager sign-off or export CSV for your accountant. No signup.
Cash collections
Aggregator sales
Card / UPI collections
| Cash collections | ₹ | |
|---|---|---|
| Opening cash | 0.00 | |
| Cash sales | 0.00 | |
| Cash in hand | 0.00 | |
| Closing cash | 0.00 | |
| Aggregator | Gross | Commission | Net |
|---|---|---|---|
| Swiggy | 0.00 | 0.00 | 0.00 |
| Total | 0.00 | 0.00 | 0.00 |
| Card / UPI | ₹ |
|---|---|
| UPI (QR / POS) | 0.00 |
| Total | 0.00 |
| Total gross sales | 0.00 |
| Total net revenue (after agg. commission) | 0.00 |
The daily collection report: what it covers
A daily collection report is a single-page document that summarises all revenue received by a restaurant outlet in one day, across all payment modes. It serves three purposes: daily revenue visibility for the owner, cash accountability for the manager, and the raw data for the accountant's cash book entry.
Modern Indian restaurants collect revenue through four channels:
- Cash: Over-the-counter orders paid in cash. Most susceptible to leakage — requires denomination tally and physical count.
- Card / UPI: POS card transactions, QR-code UPI payments, wallet payments (Paytm, PhonePe). These settle to the bank account within 1–2 days typically.
- Aggregators (Swiggy, Zomato, etc.): Online delivery orders. Revenue shown on the platform dashboard is gross; actual cash received is net of commission (23–32%) on a 7-day settlement cycle. This distinction matters — operators who don't deduct commission from daily revenue overstate their income.
- Dine-in corporate accounts / credit: For restaurants with corporate accounts, some dine-in bills may be settled monthly on credit. These should be tracked separately in the vendor ledger, not as daily cash collections.
Aggregator commission: the most common blind spot
Aggregator commission is the most consistently misunderstood cost in Indian restaurant operations. A restaurant that does ₹1,00,000 in Swiggy orders in a month at 28% commission actually receives ₹72,000 — but many operators report the ₹1,00,000 in their daily revenue and discover the discrepancy only when the bank settlement arrives.
The daily collection report addresses this by showing gross aggregator sales separately from net (after commission) — so the operator always sees both the revenue generated and the revenue that will actually be received. The commission amount is visible as a daily cost, not a monthly surprise.
Note: the aggregator settlement (net amount) arrives in your bank account 7 days after the order date. So today's aggregator orders show up in the bank statement next week. This is a timing difference in your bank reconciliation — track it by keeping a separate “aggregator pending settlement” log.
Where this fits
- Cash denomination tally — the cash sales figure in this report should match the denomination tally's total; reconcile both daily
- Daily sales report — the DSR captures individual menu-item sales; this report captures how those sales were collected (by payment mode)
- Cash book — each day's collection report feeds one entry into the cash book: cash deposit as a debit, aggregator net as a receivable, card collection as a pending bank credit
- Bank reconciliation statement — aggregator settlements (7-day delay) and card settlements (1–2 day delay) are common timing differences in the monthly BRS; the daily collection report is the source for identifying them
- Aggregator margin calculator — compute whether your aggregator channel is profitable after commissions, packaging, and delivery costs
- P1 — Cash close pillar — complete guide to daily cash close for Indian restaurants