How to Close the Day: Cash and UPI Reconciliation for Shops

If you only count the drawer at month end, a ₹200 shortage on a Tuesday becomes a ₹6,000 mystery by the 30th. Nobody remembers that Tuesday. A daily close catches the gap while people still remember what happened.

Reconciliation simply means checking that what you should have matches what you do have. For a shop that takes cash, UPI and card, that is three checks. Credit sales are a fourth, because they brought in no money at all.

The whole routine takes ten to fifteen minutes once it is a habit. It works the same whether you have one till or four.

Open every day with the same amount of change in the drawer. This is the float. Pick a figure and keep it fixed, say ₹2,000 in small notes and coins. Write it down with the time and the name of whoever counted it.

If you run two shifts, do the full close at each handover, with both cashiers present. A shortage found at 10 p.m. across two shifts cannot be traced to either of them.

At closing, get the day's sales split by how customers paid: cash, UPI, card and credit. If one bill was split, say ₹300 in cash and ₹500 by UPI, each part counts under its own mode.

Worked example. Sales for the day are ₹42,600. The split is cash ₹14,250, UPI ₹22,850, card ₹3,100 and credit ₹2,400. The ₹2,400 on credit is not money in hand. It belongs in customers' khata accounts and is checked there, not in the drawer.

Expected cash = opening float + cash sales + cash received against khata − cash paid out − cash refunds.

Continuing the example. Float ₹2,000. Cash sales ₹14,250. A customer paid ₹1,000 in cash against his khata. You paid ₹350 to the milk vendor and ₹120 for tea and loading, and refunded ₹180 in cash for a return.

Expected cash = 2,000 + 14,250 + 1,000 − 350 − 120 − 180 = ₹16,600.

Count the drawer note by note and write down each denomination. Suppose the count comes to ₹16,450. The drawer is ₹150 short. Set aside ₹2,000 as tomorrow's float, and lock away or bank the rest.

UPI money is not in the drawer, so check it against what actually reached your bank account. Do not rely on the payment screen a customer showed you. Open your bank or UPI business app and total the credits for the day.

In the example, sales say UPI ₹22,850. The bank shows ₹22,350. The ₹500 gap is worth chasing straight away, while the customer may still be reachable. The usual causes are below.

For card, compare the terminal's settlement report with the card total in your sales. Card money reaches the bank later, after charges are taken, so match the gross figure on the terminal report today and check the bank credit when it arrives.

Some shops keep a small register for payment disputes: date, amount, customer name and what was done. When a customer comes back a week later saying they paid, the register settles it in a minute.

• A customer showed a payment that had failed or was still pending.
• Money went to an old QR code or to someone else's UPI ID.
• A cash sale was marked as UPI by mistake, or the other way round.
• A payment made late in the evening appears in the next day's statement.

First check for a wrong payment mode. If cash is short and UPI is over by the same amount, or the reverse, one bill was tagged wrongly. Correct it and both gaps disappear. This is the most common cause, so always check it first.

Next, go through paid-out slips, refunds and cancelled bills. In our example, a missing slip for ₹150 of loading charges explains the cash shortage. Write it in. The UPI gap of ₹500 turns out to be a failed payment from a customer who has an account with you, so the ₹500 goes to his khata as credit.

If a gap remains, record it as it is, with the date and who was on the counter. Do not quietly top it up from your pocket. Small, regular shortages on the same shift are a pattern, and you only see the pattern if every day is written down.

A workable rule: a few rupees on a ₹40,000 day is rounding, but log it anyway. Anything over ₹200, or any shortage three days running, gets a calm conversation.

Reconciliation works because it is boring. The same steps, in the same order, by the same people. Write the routine on a card and keep it by the till.

After a month, read back through the log. Are the gaps on certain days, certain shifts or one payment mode? That is where to look first.

• The same float, every day.
• A slip for every cash payout, however small.
• Count before the cashier leaves, with them present.
• Separate counts for each shift if more than one person runs the till.
• Bank cash the next morning and keep the deposit slip.
• Check UPI against the bank, never against a phone at the counter.

Okount's billing takes split payments across cash, UPI, card and store credit, shows a UPI QR drawn from your own UPI ID, and supports shift open and close with a cash-drawer float and X/Z reports. Credit sales go straight to each customer's khata. Reports show a money view of cash, digital and credit, and bank reconciliation is matched by a person, not guessed.