Skip to main content

Cash and UPI Reconciliation for Indian Clinics

Reconcile cash and UPI as separate evidence trails linked to the clinic’s bills and receipts. Count physical cash using opening cash, collections, refunds and recorded movements. Match digital collections to confirmed transaction information and track pending, duplicate and refunded payments separately. An invoice, a patient screenshot and a bank credit describe different events; they should not automatically produce the same collection entry.

By Bractis · Updated · 13 min read

For Indian clinic owners and reception teams closing the day across cash, UPI, refunds and unresolved payment exceptions.

Separate the bill, payment attempt and confirmed collection

A bill records what is charged. A payment attempt records an effort to pay. A confirmed collection records evidence that the clinic received the payment through the relevant process. Confusing these events creates familiar errors: an unpaid invoice counted as collected, a pending UPI attempt treated as cash, or two attempts recorded against one fee without a duplicate exception.

Keep a reference linking the bill, receipt and transaction information. The desk should be able to answer which fee a payment settled and whether a later adjustment changed the amount. A total collections figure without this trail is difficult to investigate when a patient queries the payment.

NPCI’s merchant FAQ describes an acquiring-bank route for transaction-status enquiries and grievances. Confirm the current process with the clinic’s bank or provider. Do not infer a universal settlement deadline or treat a patient-side screenshot as the only evidence available.

Source: NPCI: UPI frequently asked questions for merchants

Use payment states that preserve uncertainty

The reception view should distinguish confirmed, pending or unconfirmed, failed, duplicate and refunded/partly refunded events as supported by the actual setup. A label must correspond to evidence, not just the button staff clicked. Keep the transaction reference and the time/status information needed for reconciliation.

When information is unclear, record the uncertainty and the agreed next action. Staff should not pressure a second payment simply to make the ledger look complete, nor mark an amount confirmed solely to clear the queue. The clinic’s payment exception policy should explain who can decide and how later confirmation is handled.

On a narrow screen, scroll the table horizontally to read all columns.

Payment evidence and what the desk should record
SituationRecord nowKeep separate
Cash receivedActual amount, receipt and the relevant bill.Opening float and non-patient cash movements.
UPI confirmed through the agreed processAmount, transaction reference and linked receipt/bill.Any provider settlement or reconciliation detail that is a later event.
Patient reports success; clinic confirmation unresolvedThe attempt and evidence available, with an owner for follow-up.Do not silently convert uncertainty into confirmed collection.
Two credits for one intended paymentBoth references and a duplicate-payment exception.The duplicate is not a second clinical service charge.
Refund or adjustmentApproved reason, amount and relationship to the original collection.Do not erase the original receipt to make the net total match.

Worked cash example: the drawer total is not the day’s revenue

The following figures are fictional. Suppose the drawer opens with ₹1,500. The clinic collects ₹8,400 in cash, refunds ₹600, pays a recorded ₹350 cash expense and transfers ₹5,000 out of the drawer for banking. Expected closing cash is ₹1,500 + ₹8,400 − ₹600 − ₹350 − ₹5,000 = ₹3,950.

If the physical count is ₹3,900, the difference is a ₹50 shortage to investigate. Do not alter a patient receipt or invent an expense simply to remove it. Record the discrepancy, review the source movements and assign the next action under the clinic’s process.

Notice that the ₹3,950 drawer balance is not the amount collected from patients and not the clinic’s profit. It includes opening cash and reflects expenses and transfers. Keeping those categories separate makes the close understandable to the owner and the person responsible for the accounts.

On a narrow screen, scroll the table horizontally to read all columns.

Illustrative cash-drawer reconciliation
MovementAmountEffect on expected drawer cash
Opening cash₹1,500Starting balance
Patient cash collections₹8,400Add
Cash refunds₹600Subtract
Recorded cash expense₹350Subtract
Cash transferred for banking₹5,000Subtract
Expected closing cash₹3,950Compare with the physical count
Actual cash counted₹3,900₹50 shortage remains an explicit exception

Worked UPI example: pending amounts do not belong in confirmed totals

Now suppose the same fictional day has ₹12,600 in confirmed UPI collections and ₹900 in confirmed linked refunds. Net confirmed UPI collections are ₹11,700. A further ₹1,200 payment attempt remains unconfirmed and is listed separately with its reference, evidence and follow-up owner.

If the ₹1,200 is confirmed later, update the linked payment history through the supported process. Preserve when the attempt occurred and when confirmation was obtained. Avoid creating a second unrelated receipt that makes the later day look as though another service was sold.

Combine categories only for the question you are answering. Net patient collections in this example are ₹7,800 cash after cash refunds plus ₹11,700 confirmed UPI after digital refunds, or ₹19,500. The cash expense and banking transfer affect drawer movement, not the same collection subtotal. Accounting treatment and reporting should follow the clinic’s actual books and responsible accounting process.

Allocate a family payment or split payment without duplicating the collection

A payment has a payer and a transaction reference; a bill has a patient and a service-charge context. Those relationships need not be one-to-one. A relative may pay once for two separate patients, or a patient may settle one bill partly in cash and partly through UPI. Keep the underlying patient records separate and record how the confirmed amount is allocated.

The following is a separate fictional example, not an addition to the earlier day-close totals or a recommendation of clinic fees. A ₹1,500 confirmed UPI transaction U-81 covers bills B-41 for ₹900 and B-42 for ₹600. Bill B-43 is ₹1,000, with ₹400 cash and ₹500 confirmed UPI received. A further ₹100 attempt is unconfirmed. The clinic can trace the three bills without treating the shared payer’s phone as a patient identifier.

  • U-81 is one collection with two allocations: ₹900 + ₹600 = ₹1,500.
  • B-43 has ₹900 confirmed against ₹1,000 charged. Recording the pending ₹100 as confirmed would conceal the remaining balance.
  • If an allocation is corrected, retain its history and the actual transaction reference; do not manufacture a second credit to repair the bill link.

On a narrow screen, scroll the table horizontally to read all columns.

Fictional bill allocations with shared and split payment methods
Bill and chargeConfirmed allocationBalance and evidence
B-41: ₹900₹900 allocated from UPI reference U-81₹0 balance; the allocation links to the single ₹1,500 collection.
B-42: ₹600₹600 allocated from the same UPI reference U-81₹0 balance; U-81 is not recorded again as another ₹1,500 collection.
B-43: ₹1,000₹400 cash plus ₹500 confirmed UPI₹100 remains uncollected in this example; the unresolved attempt stays separate.
Combined charges: ₹2,500₹2,400 confirmed allocations₹100 outstanding; allocation totals and collections reconcile.

Treat a duplicate credit as an exception even when both bank credits are real

In another fictional case, bill B-50 is ₹700. Two distinct ₹700 UPI credits arrive for the same intended payment. The bank evidence totals ₹1,400, but the charge remains ₹700. The additional ₹700 needs an explicit overpayment/duplicate resolution under the clinic’s process. It is not a second consultation, and deleting one bank reference would make the evidence trail incomplete.

Assign the refund decision to the authorised role and link any approved refund to the original credit and bill. A refund request is not a confirmed outgoing payment. Until the outcome is known, retain the excess amount and refund status as an open exception. In this simplified case, after a linked ₹700 refund is confirmed, the net retained amount is ₹700.

If only one ₹700 credit actually occurred but the application imported its status twice, the problem is a duplicated record of the same transaction, not a second payment to refund. Compare references and provider evidence before choosing the correction. Confusing these cases can turn a bookkeeping error into an unnecessary outgoing payment.

Explain a bank or provider total before comparing it with billed services

First establish what the statement represents. A direct bank credit, a payment-provider transaction report and a later settlement report may have different scopes and cutoffs. Ask which one is being reconciled and which accounts or provider arrangements it includes. Do not assume that every UPI setup uses the same settlement mechanism.

For a purely fictional provider statement, suppose gross receipts are ₹5,000, linked refunds are ₹300 and a separately documented contractual deduction is ₹100. Its net transfer would be ₹4,600. This is an illustrative statement bridge, not an assertion that UPI has a universal fee or that this deduction applies to Bractis. Verify any real deduction against the actual agreement and statement.

A clinic collection report showing ₹5,000 and a transfer showing ₹4,600 are not necessarily in conflict. The difference needs the ₹300 refund and ₹100 deduction evidence. Conversely, a matching total is not enough if transactions belong to the wrong period or account. Reconcile the components and references before declaring the reports consistent.

On a narrow screen, scroll the table horizontally to read all columns.

Illustrative bridge from provider receipts to a net transfer
Statement componentFictional amountEvidence required
Gross receipts in the stated scope₹5,000Underlying confirmed transactions and reporting cutoff.
Linked refunds in that statement−₹300Refund references and confirmed status.
Documented contractual deduction−₹100Applicable agreement and statement explanation; no default UPI fee is assumed.
Net transfer₹4,600Transfer reference and receiving-account evidence.

Investigate exceptions through their references

For a duplicate, retain both transaction references and identify the intended bill. For a refund, link the approved adjustment to the original collection and track its actual status. For a mismatch, preserve the competing evidence rather than overwriting it with the value that makes the summary reconcile.

If the clinic uses more than one bank account, QR or collection provider, identify the destination of each payment. A credit to a different authorized account can otherwise look like a missing transaction. Confirm which accounts belong in the day’s reconciliation scope.

Keep access appropriate to the role. The person receiving money may not be authorized to approve every refund or change a closed period. Demonstrate the permission and approval path in the software, including how the owner can review a correction later.

A repeatable close with an exception list

Choose the reporting cutoff and identify any transactions crossing it. Gather bills/receipts, physical cash information and the relevant digital confirmations. Reconcile each payment channel, then review the relationship to charges and outstanding amounts. Keep unresolved items visible rather than carrying forward a single unexplained difference.

The handover should tell the next person exactly what to investigate. “UPI short by ₹1,200” is less useful than a reference-linked unconfirmed attempt with the patient/bill context and the bank/provider route to check. Keep sensitive payment information within the authorized process.

Keep the close snapshot and later resolution distinguishable

Return to the earlier ₹1,200 unconfirmed attempt. If it occurred before the clinic’s close but was resolved the next morning, preserve the service date, payment-attempt time, available bank/provider transaction time, confirmation-discovery time and exception-resolution time as applicable. These may differ. Do not invent a value when the provider does not supply it.

The person responsible for the accounts should determine the treatment in the clinic’s books. Operationally, the software should let the team explain what was known at the original close and how later evidence changed the linked payment state. Silently editing yesterday’s printout or entering a new service charge today loses that explanation.

When comparing reports, specify whether they show the original close snapshot or a later view including corrections. A difference between those views may be explainable, but it needs a linked event and authorisation where required. A report date alone does not tell the reader which version of the evidence it contains.

Test reconciliation with a deliberately imperfect day

Ask the vendor to demonstrate a mixed cash/UPI sample with opening cash, a pending attempt, a duplicate and a refund. Inspect the totals, original references, permissions and later resolution. A clean day with only successful payments will not reveal how the clinic handles uncertainty.

Confirm the provider setup and which statuses are automatically confirmed versus manually recorded. Bractis’s billing page describes the intended workflow, but your acceptance evidence should identify the actual configured integrations and any manual reconciliation still required.

Measure the close by completeness and traceability before measuring speed. A five-minute close that hides unresolved transactions is not equivalent to an accurate close with an honest exception list.

Source: Bractis billing and reconciliation

A late confirmation should resolve an exception, not create another sale

A fictional clinic leaves a ₹1,200 UPI attempt unconfirmed at close. The next morning, the authorized confirmation process establishes the credit. Staff connect it to the original bill and attempt, retain the confirmation history and close the exception. They do not create a new consultation charge or erase the original close record. This preserves the difference between the date of service, the payment attempt and the later information that resolved uncertainty.

Cash and UPI Day-Close Worksheet

Use these prompts in your clinic’s own notes. Record the result, responsible person and next action for each item.

Scope and evidence
Fix the period, cash drawer and digital accounts; gather bill/receipt links and actual confirmation evidence.
Cash movement
Reconcile opening cash, patient collections, refunds, recorded expenses and transfers against the physical count.
Digital exceptions
Keep unconfirmed, duplicate and refunded amounts distinct, with references and approved resolution paths.
Handover
Assign each unresolved difference and retain the later confirmation or adjustment without rewriting the original history.

Questions doctors ask

How should one UPI payment for two family members be recorded?

Record the confirmed collection once and allocate the appropriate amounts to each separate patient bill. Keep both allocation links and verify that their total equals the collection; the shared payer does not merge the patients or create a second credit.

Does a repeated payment-status entry mean the clinic should refund a duplicate payment?

Only actual evidence of an additional credit supports treating it as another payment. Compare references and bank/provider records: two records of one transaction require a record correction, while two genuine credits for one intended charge need an authorised overpayment resolution.

Is a patient’s UPI screenshot enough to mark a payment confirmed?

Use the clinic’s agreed bank/provider confirmation and exception process. A screenshot can be evidence to investigate, but it should not automatically replace the confirmation the clinic relies on for its collection record.

Should pending UPI payments be included in confirmed collections?

Keep unresolved attempts separate until the relevant confirmation is established. Retain their references and next action so later resolution connects to the original bill.

Why does cash in the drawer differ from patient collections?

The drawer also reflects opening cash, refunds, expenses and transfers. Reconcile those movements explicitly rather than treating the physical balance as revenue or profit.

Should a refunded receipt be deleted?

Preserve the original and use a linked, authorized adjustment or refund process. The record should explain both the collection and what happened afterwards.

Can every clinic finish reconciliation in five minutes?

No universal duration is supported here. The time depends on volume, provider evidence and exceptions. Evaluate whether the close is complete and traceable, then observe the effort required in your setup.

Sources and scope

Updated on . All monetary examples are fictional arithmetic. The guide explains operational reconciliation and does not determine tax treatment, accounting policy or an individual bank’s resolution deadline. No independent clinical or legal review is claimed.

  • NPCI: UPI frequently asked questions for merchants

    Indexed primary FAQ answer checked 26 October 2026 for the acquiring-bank transaction-status/grievance route. Confirm the current route with the actual bank/provider. No universal fee, settlement or reversal deadline is asserted; all monetary cases are original fictional arithmetic.

  • Bractis billing and reconciliation

    First-party workflow scope; confirm provider setup, permissions and exception handling in the demonstration.

Try the workflow
with Bractis.

Bring a fictional mixed-payment day with opening cash, an uncertain UPI attempt and a refund. We can trace the totals back to individual events and inspect how later corrections are recorded.

Request a clinic demo