Day end at a clinic: counting cash, checking UPI

By Abhishek Dogra, Founder, ElaiorLast verified

A clinic day that took only cash and UPI does not have one figure to check at closing. It has two, and they fail for unrelated reasons. Cash is the only money a person can physically verify, so that half is a count against an expected number. The UPI total cannot be counted at all: it is a claim your own records make, testable only against a second system, the bank account or the collection app. Run them as one total and you get a single unexplained number.

The countable half: expected cash, then a blind count

Expected cash is opening float plus cash collected, less refunds paid out in cash, less anything paid out of the drawer. Count what is physically there before you look at that number. Retail guidance calls this the blind count: the counter enters the drawer figure first and only then sees the expected balance, which is given as opening float plus cash sales less cash paid out.

  1. Count by denomination and subtotal, the way Northwestern's sample drawer count form does it, rather than eyeballing a bundle.
  2. Subtract the float. That form states plainly that the drawer total should always be static, so the float you open with tomorrow is the float you opened with today.
  3. Take the expected figure from somebody other than the counter. Northwestern's instructions say the register total is obtained from the approver of deposits.
  4. Put the difference on its own over and short line, with a shortage added to and an overage subtracted from the deposit so the result equals the register total.
  5. Close out the system and print the total, count the cash, deduct petty cash if you keep any, and the remainder should balance to the day's grand total. That is Utah's closing sequence, without the card machine step a cash and UPI clinic does not have.

The uncountable half: what a UPI total is claiming

When your own record says the UPI side of the day is done, you are asserting three separate things: that the sender's bank moved the money, that it reached the clinic's account, and that none of it will come back. All three can be false tonight and true next week. The RBI circular on harmonisation of turn around time, dated 20 September 2019, sets the windows: a UPI payment to a merchant that receives no confirmation is auto reversed within T plus 5 days, and a fund transfer where the beneficiary account is not credited is auto reversed latest on T plus 1 day, where T is the transaction date. Compensation of Rs 100 per day applies beyond that window, automatically, with no complaint needed. PhonePe's gateway guide restates the same timelines and notes that most refunds in practice land within hours.

The second trap is settlement. If the clinic collects through a payment aggregator rather than straight into its own bank account, today's money is not in the account today. Razorpay documents the standard domestic cycle as T plus 2 working days from capture, worked through as a payment captured on 02 February 2019 at 9:00 a.m. settling on 04 February 2019 at 9:00 a.m., shifted if that date is a bank holiday, and sells instant settlement as the paid way around it.

Timings you can cite, with the document each comes from
WhatTimingSource
UPI to a merchant, no confirmationAuto reversal within T plus 5 daysRBI circular, 20 September 2019
Fund transfer, beneficiary not creditedAuto reversal latest on T plus 1 dayRBI circular, 20 September 2019
Delay past that windowRs 100 per day, applied automaticallyRBI circular, 20 September 2019
Aggregator settlement into your bankT plus 2 working days from captureRazorpay settlements documentation
Authorized but never capturedAuto refunded if not captured within 3 days of creationRazorpay payments documentation

Causes, sorted by which half they break

Where to look, given which number is off
CauseBreaksFirst check
Change given wrong, or notes miscountedCashRecount by denomination
Money paid out of the drawer, not enteredCashToday's expense entries
A cash refund handed back with no recordCashThe day's refunds
A bill voided and reissued, one of the two countedEitherInvoices issued against invoices voided
Money taken by UPI but written down as cashBoth, opposite waysWhatever note the desk keeps of how each payment arrived
Payment still pending on the sender's sideUPIStatus in the app, then wait
Auto reversal inside the RBI windowUPITransaction ID, then the bank
Aggregator has not settled yetUPIThe settlement report, not the account balance
Paid to a staff member's personal handleUPIWho collected, and where it landed
A small shortage on the same shift each weekCashThe pattern, not tonight's number

PhonePe groups UPI failures the way a desk meets them. Human: wrong UPI PIN, insufficient balance, crossing the daily limit it states as Rs 1 lakh, and a mistyped virtual payment address. Technical: bank server downtime at month end peaks, weak connectivity mid transaction, scheduled NPCI maintenance, and gateway timeouts. Its escalation path is the one to hand the patient: check status through UDIR inside the UPI app, wait 60 minutes before retrying, then take the transaction ID to the bank.

What to do with the difference

  1. Recount by denomination before theorising. Most cash gaps are the count.
  2. Look for the unrecorded transaction: a payout, a refund, a void, a bill reissued.
  3. Have a second person verify. Utah wants a supervisor recount before any entry is made, and FSU wants the cashier and the supervisor both counting at close.
  4. Write it down the same day. Northwestern requires shortages documented in full and overages deposited rather than left in the fund, and money handed between staff recorded with name, date, time and amount.
  5. Bank on a schedule, not when it feels large. FSU expects deposits daily and nothing held beyond five business days, and Utah says within 3 business days. Both are American university rules, so treat them as a shape to copy rather than a number that transfers.
  6. Track the pattern. A variance once a quarter is a different problem from a small shortage every Friday, and a steady run of small shortages is the stronger signal.

What Elaior's day end sheet shows, and what it does not

Verified in the code, because the honest version is narrower than the pitch. Elaior does not record how money arrived. There is a payment mode column in the database, but every payment row and every expense row is written with the same fixed value, and no screen asks or displays a method, so the day end sheet carries no cash figure, no UPI figure and no drawer count. What it does report for one day: collections net of refunds, refunds shown as a positive number, a category split across consult, pharmacy, procedure and other, the expense rows, the net, and counts of invoices issued, invoices voided, patients registered and consults done. Splitting the two tenders and counting the drawer is still paper and a second pair of eyes. Two product rules do remove causes from the table above: billing is pay first, with no khata and no partial payments, and no field on an issued invoice can be edited, so a correction is a void and a fresh bill. Expenses can only be entered for today or yesterday, so a payout cannot be quietly backdated into a day that was already closed.

What we do not know

Sources

  1. Harmonisation of Turn Around Time (TAT) and customer compensation for failed transactions using authorised Payment SystemsReserve Bank of India. Checked 2026-09-10.
  2. UPI Failed Transaction: Reasons, Fixes and Refund TimelinePhonePe Payment Gateway. Checked 2026-09-10.
  3. SettlementsRazorpay. Checked 2026-09-10.
  4. PaymentsRazorpay. Checked 2026-09-10.
  5. Policy: Cash Collection and Deposit, with Sample Cash Drawer Count InstructionsNorthwestern University, Office of the Controller. Checked 2026-09-10.
  6. Cash Handling Procedures GuideFlorida State University, Office of the Controller. Checked 2026-09-10.
  7. Best Practices for Cash ControlUniversity of Utah, Financial and Business Services. Checked 2026-09-10.
  8. Basic Cash Control: Principles and PracticesUniversity of California, Santa Cruz, Financial Affairs. Checked 2026-09-10.
  9. Cash register management and cash trackingShopify. Checked 2026-09-10.
  10. Balancing a Cash DrawerRevenueRegister. Checked 2026-09-10.
  11. Retail Cash Handling Procedures: Policy Template plus Step by Step GuideXenia. Checked 2026-09-10.