Tax and GST

A daily sales summary sheet for cash, UPI and card takings

A one-page daily sales summary for cash, UPI, card and credit takings, with a filled example and how to tie it to the next day's bank credits.

Editorial illustration for A daily sales summary sheet for cash, UPI and card takings

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?

LineWhat you writeWhere it comes from
Date and dayFor example 12 Nov, ThursdayCalendar
Cash salesNotes and coins counted, minus the opening floatTill count
UPI salesTotal of the day's UPI creditsUPI app or soundbox history
Card salesTotal of the swipe or machine slipsCard machine day total
Credit salesSales on account, not yet paidCredit register
Total salesAdd all four linesCalculated
Bill book totalTotal of the day's bills or counter slipsBill book
DifferenceTotal sales minus bill book totalCalculated

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

  1. Count the drawer and write cash sales.
  2. Read the UPI and card totals and write them.
  3. Add the credit sales from the register.
  4. Total the sheet and compare with the bill book.
  5. Note any difference, and file the sheet with the day's slips.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports