A daily sales summary is a one-page sheet filled at closing time that lists the day's takings by mode: cash, UPI, card and credit, then totals them and compares with your bill book. If the totals differ, you find out the same evening, not at month end.
What goes on the sheet?
| Line | What you write | Where it comes from |
|---|---|---|
| Date and day | For example 12 Nov, Thursday | Calendar |
| Cash sales | Notes and coins counted, minus the opening float | Till count |
| UPI sales | Total of the day's UPI credits | UPI app or soundbox history |
| Card sales | Total of the swipe or machine slips | Card machine day total |
| Credit sales | Sales on account, not yet paid | Credit register |
| Total sales | Add all four lines | Calculated |
| Bill book total | Total of the day's bills or counter slips | Bill book |
| Difference | Total sales minus bill book total | Calculated |
A filled example
Say a general store has these takings on Thursday: cash ₹8,400, UPI ₹12,650, card ₹5,200 and credit ₹1,800. Total sales are ₹8,400 + ₹12,650 + ₹5,200 + ₹1,800 = ₹28,050. The bill book for the day adds up to ₹28,150. The difference is ₹100, meaning ₹100 of billing is not yet in any mode. Maybe a customer was given a discount that the bill book did not record, or a small cash sale was missed on the sheet. The shop owner checks that evening, finds two lines of ₹50 in the bill book without a matching payment, and writes a note next to the difference.
How should you count each mode?
- Cash: count the drawer, subtract the opening float, and add anything you removed during the day such as a deposit or a payment, so you are counting sales and not cash movement.
- UPI: read the total from the app or soundbox history for that day. Do not rely on messages from memory.
- Card: use the machine's end-of-day total, not each slip.
- Credit: add what is entered in the credit register today. It is not money yet.
How does the sheet tie to the bank?
UPI credits usually appear in the bank statement the same day or the next. Card settlements often take longer and may arrive as one lump or net of charges, so read your own statement and the card machine report for the exact timing and deductions rather than assuming. Cash arrives only when you deposit it.
So after a day or two, tick the UPI and card totals from the sheets against the credits in the bank statement. Whatever you cannot tick is either a timing gap or a mismatch worth asking about.
What do you do with a recurring difference?
One difference of ₹100 is noise. The same difference every Saturday is a pattern. Start by looking at who handles the counter at that time, whether discounts are given without a note, and whether a card or UPI sale is being entered as cash.
Is there a tidier way to keep this?
A printed pad of the table above works well, as does a spreadsheet with one row per day. For the month, add the daily totals by mode and compare the UPI and card totals with the bank credits. SpendixAI is built for spending rather than shop sales, so it will not replace the sheet, but its statement upload helps you review the bank side of what came in.
Closing-time checklist
- Count the drawer and write cash sales.
- Read the UPI and card totals and write them.
- Add the credit sales from the register.
- Total the sheet and compare with the bill book.
- Note any difference, and file the sheet with the day's slips.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


