Templates and checklists · Daily sales reconciliation sheet
Free sheet to print

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

Last reviewed 18 November 2026. A working tool for your own team, not legal advice.

How to use it

  1. Write sales for each channel: dine-in, takeaway, delivery apps and your own online orders. Write refunds and voids.
  2. Write payments by mode: cash, UPI, card, wallet and credit. Delivery apps usually pay you later, so write that amount in its own line.
  3. The payments total should equal net sales. If not, write the difference and look for the missing bill.
  4. Count the cash in the drawer and compare it with the cash that should be there.
  5. Match UPI and card to your UPI statement and your card settlement report. Card money may arrive after a day or two.
  6. Two people sign. Keep it with the day's bills.

Example row (made up)

ItemAmount (₹)Notes
Cash that should be in the drawer14,500Float 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-reconciliation
Date
Prepared by
Checked by

Sales by channel

ChannelAmount (₹)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

ModeAmount (₹)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

ItemAmount (₹)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

ItemAmount (₹)Notes
UPI total on your UPI statement
UPI difference (statement minus till)
Card total on the settlement report
Card difference (report minus till)

Notes

Why is there a difference? What will you do?
Signature of the person who prepared this
Signature of the person who checked it

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.

Talk to us Join the early access list

Last updated:

Pricing is coming soon

We are keeping pricing simple. We will share it when Zentaro Serve launches in 2027. Join early access and we will tell you first.