Daily sales reconciliation sheet
A daily sales reconciliation sheet matches what you sold to what you were paid. It lists sales by channel and payments by mode, then checks cash, UPI and card. It is the fuller version of the daily cash-up sheet.
Nothing is sent anywhere. To make a PDF, choose "Save as PDF" in your browser's print window.
What it is for
A daily sales reconciliation sheet matches what you sold to what you were paid. It lists sales by channel and payments by mode, then checks cash, UPI and card. It is the fuller version of the daily cash-up sheet.
Read more: Daily cash-up sheet (the short version) · Why the till does not match: cash short or over
How to use it
- Write sales for each channel: dine-in, takeaway, delivery apps and your own online orders. Write refunds and voids.
- Write payments by mode: cash, UPI, card, wallet and credit. Delivery apps usually pay you later, so write that amount in its own line.
- The payments total should equal net sales. If not, write the difference and look for the missing bill.
- Count the cash in the drawer and compare it with the cash that should be there.
- Match UPI and card to your UPI statement and your card settlement report. Card money may arrive after a day or two.
- Two people sign. Keep it with the day's bills.
Example row (made up)
| Item | Amount (₹) | Notes |
|---|---|---|
| Cash that should be in the drawer | 14,500 | Float 3,000 plus cash received 12,000 minus paid out 500. Counted 14,450. Difference minus 50. Write it down. |
An example with made-up figures. It is not a real order, price or reading.
Daily sales reconciliation sheet
Zentaro Serve · serve.zentaro.cloud/templates/daily-sales-reconciliationSales by channel
| Channel | Amount (₹) | Notes |
|---|---|---|
| Dine-in | ||
| Takeaway | ||
| Delivery apps (all apps together) | ||
| Own online orders | ||
| Total sales | ||
| Refunds and voids | ||
| Net sales (total sales minus refunds and voids) |
Payments by mode
| Mode | Amount (₹) | Notes |
|---|---|---|
| Cash | ||
| UPI | ||
| Card | ||
| Wallet | ||
| Credit or khata (not paid yet) | ||
| Delivery app payout due later | ||
| Total payments | ||
| Difference (net sales minus total payments) |
Cash check
| Item | Amount (₹) | Notes |
|---|---|---|
| Opening float | ||
| Cash paid out (expenses, advances) | ||
| Cash that should be in the drawer (float plus cash received minus paid out) | ||
| Cash counted | ||
| Difference (counted minus should be) |
UPI and card settlement check
| Item | Amount (₹) | Notes |
|---|---|---|
| UPI total on your UPI statement | ||
| UPI difference (statement minus till) | ||
| Card total on the settlement report | ||
| Card difference (report minus till) |
Notes
Calculators that go with this
Questions about this sheet
How is this different from the daily cash-up sheet?
The cash-up sheet counts the drawer. This sheet also matches sales by channel to payments by mode and checks UPI and card settlement.
Why a separate line for delivery apps?
Delivery apps pay you later, not at the till. A separate line keeps your payments total honest.
What if card money has not arrived yet?
Write it in the notes and check again when the settlement report comes. Do not change the till figure.
What is credit or khata?
Sales a regular guest will pay for later. They count as sales today, and as money you are still owed.
Want this done for you, every day?
Zentaro Serve launches in 2027. It keeps your sales, cash, stock and recipes in one place. Tell us what you run today and we will get in touch.
Last updated: