For a shop with more than one counter, make a daily sheet with one column per counter or person, rows for each kind of sale, a total column, and a closing check that ties each column to its own cash and UPI. A shortfall then points to one column instead of the whole shop.
What rows does the sheet need?
- Opening cash float for each counter, counted in the morning.
- Cash sales.
- UPI sales, taken from that counter's own QR or soundbox where possible.
- Credit (udhaar) given, for sales to be paid later.
- Total sales, which is the three sale rows added together.
- Expected cash in the drawer: opening float plus cash sales, less any cash paid out from that drawer.
- Counted cash at closing.
- Difference: counted minus expected.
A made-up two-counter day
| Row | Counter 1 | Counter 2 | Shop total |
|---|---|---|---|
| Opening float | ₹2,000 | ₹2,000 | ₹4,000 |
| Cash sales | ₹9,200 | ₹4,800 | ₹14,000 |
| UPI sales | ₹6,400 | ₹7,100 | ₹13,500 |
| Udhaar given | ₹1,200 | ₹0 | ₹1,200 |
| Total sales | ₹16,800 | ₹11,900 | ₹28,700 |
| Expected cash | ₹11,200 | ₹6,800 | ₹18,000 |
| Counted cash | ₹11,150 | ₹6,800 | ₹17,950 |
| Difference | -₹50 | ₹0 | -₹50 |
Check the arithmetic. Counter 1 total sales: 9,200 plus 6,400 plus 1,200 is 16,800. Expected cash: 2,000 plus 9,200 is 11,200. Counted 11,150 gives a difference of minus 50. Counter 2: 4,800 plus 7,100 is 11,900, and cash expected is 2,000 plus 4,800, which is 6,800, exactly as counted. The shop-wide difference of minus ₹50 belongs entirely to Counter 1.
What are the formulas?
Put the rows in the order above, with the first counter in column B and rows starting at row 2 for the opening float. Then:
- Total sales in B6: =B3+B4+B5
- Expected cash in B7: =B2+B3-B8, where B8 is cash paid out from the drawer (add that row if you use it)
- Difference in B10: =B9-B7, where B9 is the counted cash
- Shop total column E: =B3+C3 and so on across the rows, or =SUM(B3:D3) if you have three counters
Whatever row numbers you choose, keep the logic the same: each column stands alone and the total column only adds them.
How do I handle a staff member who works at two counters?
Make the column belong to the till or QR, not the person, and add a line in the notes for who was on it in each shift. If the shift changes mid-day, close the column at handover: count the cash, note the UPI total shown, initial it, and open a new column for the next person. A column per shift is more work, but it tells you exactly where things went wrong.
What should I check at closing?
- Each UPI figure matches the app total for that QR.
- Each total sales figure matches the counter's own bill count or bill book.
- Each counter's expected cash equals its counted cash, or the gap has a reason written beside it.
- Udhaar given is entered in the credit book as well, with the customer's name and amount.
- Both counters' sheets are initialled by whoever closed them.
Who should fill it in, and who checks it?
Let the person at each counter write their own column during the day, and let a different person do the closing count where you can. Someone who sold and counted alone has no one to catch a slip. Even in a family shop, a second person counting the drawer and initialling the column takes two minutes and removes most arguments. Keep the sheets for the month in date order, since a gap in one counter's figures is easier to explain next week than next quarter.
Weekly view
Keep one line per day per counter in a summary tab, with the date, counter, total sales and difference. A SUMIFS on counter and week shows which counter is trending short or strong, and by how much. Look at it calmly, because a single ₹50 gap on a busy day is normal, while the same gap every day deserves a closer look.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

