Cash and UPI Reconciliation for Indian Clinics
Reconcile clinic cash and UPI with worked examples for shared and split payments, duplicate credits, statement differences and late confirmations.
Give your CA a reconciled set of source records with clear dates and definitions, not a screenshot labelled 'monthly revenue'. Connect bills and adjustments to payments, refunds, advances and bank settlements, and list unresolved differences openly. Agree the required statutory records and patient fields separately from the general finance summary. Clinical narratives should not be included simply because the software can export them.
Indian doctors, clinic managers and reception teams preparing a dependable monthly accounts handover.
Start with the legal entity and clinic locations covered, the period start and end, the reporting timezone and the extraction time. An owner operating several facilities needs to know whether an export contains one branch, a combined practice or more than one accounting entity. Separate transaction ownership from the name of the doctor who delivered care.
Define labels such as billed, collected, settled, refunded and outstanding. A report organised by visit date answers a different question from one organised by payment date. Keep both dates where needed rather than forcing a payment received in April onto the date of a March consultation. The accountant should determine the formal recognition and filing treatment from the actual records.
The Income Tax Department explains that the April 2026 transition introduces tax-year terminology while earlier periods continue under transitional provisions. Label the period and framework explicitly. Do not rename or rewrite historical transactions merely because a current form or portal uses a different year label.
Source: Income Tax Department: Objective and scope of the Income-tax Act, 2025
A practical handover connects the charge ledger, adjustments, payment ledger, refunds, patient advances, bank or merchant statements and expense evidence. Keep stable references so a reviewer can move from a summary amount to its source. Include opening and closing balances where the ledger carries obligations or amounts due across months.
Do not send several exports with the same vague title and let the CA guess which is authoritative. Give each file a purpose, period, version and brief field definition. A consolidated workbook can be useful, but preserve enough source detail to reconstruct totals and identify duplicates. A PDF collection report is an overview, not a substitute for transaction-level reconciliation.
ICAI's cash-flow framework distinguishes operating, investing and financing movements. For the handover, flag loans, equipment purchases, deposits and owner movements separately so they are not hidden among ordinary patient collections or supplier costs. Let the accountant apply the correct accounting treatment to the actual transaction.
On a narrow screen, scroll the table horizontally to read all columns.
| Record group | Core references and dates | Open issue to disclose |
|---|---|---|
| Charges and adjustments | Patient/visit link, document number, service and issue dates. | Corrections, voids or services completed but not billed. |
| Payments and refunds | Payment identifier, mode, receipt date and linked bill or advance. | Unknown outcome, duplicate credit or refund still pending. |
| Merchant and bank reconciliation | Provider reference, settlement batch, fee and bank credit. | Gross transactions that do not yet explain the net credit. |
| Advances and balances | Opening balance, movements, applications and closing balance. | Money received for care not yet delivered or allocated. |
| Expenses and commitments | Supplier, purpose, invoice, payment and supporting evidence. | Missing document, personal element or unpaid commitment. |
| Stock and assets | Movement and valuation basis, purchases and disposals. | Unusable stock, disputed returns or incomplete asset details. |
| Prescribed records | The actual required register and period. | Missing fields or uncertainty about applicability. |
In a fictional month, opening amounts receivable are ₹20,000 and new net bills are ₹2,40,000. Payments applied against those bills and the opening receivables total ₹2,30,000. With no other changes in this simplified example, closing receivables should be ₹20,000 + ₹2,40,000 − ₹2,30,000 = ₹30,000.
Suppose total receipts are ₹2,60,000 because the clinic also receives ₹30,000 in new patient advances that have not yet been applied. Reporting ₹2,60,000 as payments against billed work would incorrectly erase the ₹30,000 receivable balance. Show the unapplied advance separately and preserve its patient and payment references.
Use a bridge from the opening balance to the closing balance for each relevant ledger. Identify credits, write-offs, refunds, transfers and applications with their actual purpose rather than hiding them in a balancing entry. The CA needs the evidence and unresolved questions, not a forced total made to look reconciled.
In a separate fictional merchant example, a settlement batch contains ₹1,00,000 of gross payments, ₹2,000 of stated provider fees and ₹3,000 of refunds, producing a ₹95,000 bank credit. Keep the batch components and provider statement together. The ₹5,000 difference is explained by the stated movements; it is not automatically a collection shortfall or a discount to patients.
Other differences may concern timing rather than amount. A payment accepted on the last day of the month may settle later. Retain the payment event and the bank-credit event with their own dates. Do not move all activity to whichever month makes the bank statement match the clinic dashboard.
If a payer reports a tax deduction or other withholding, retain the gross charge, cash received, payer explanation and supporting evidence separately. A ₹10,000 bill followed by ₹9,000 received does not reveal by itself whether the remaining ₹1,000 is withholding, a disputed deduction or unpaid money. Ask the CA to verify its classification and any required supporting statement; do not invent a tax credit.
The department's Form 25 guidance describes a medical daily case register with patient, service, fee and receipt-date information. It is not the same as a generic daily collections total. Confirm applicability and the required record with the CA, including the relationship to the earlier Form 3C framework. A new software export name alone does not establish that the necessary register is complete.
Separate that prescribed-record discussion from a general management summary. The latter may not need patient names or clinical detail at all, while a required source record may need specified identifying fields. Avoid an absolute rule either to remove every name or to export the entire consultation note. Ask what each recipient needs for the actual purpose.
Use an agreed transfer channel, named recipients and access boundaries. Do not share a staff login that also opens clinical charts merely to let the accountant download a report. If a clarification requires a particular record, share the relevant evidence through the approved route and keep unrelated medical details out of the exchange.
Set a practical extraction cutoff and list transactions whose outcome is unresolved at that point. Include a named owner, the evidence needed and the next expected action. Examples include an uncertain refund, missing supplier invoice, unallocated payment or a merchant credit not yet seen at the bank. An exception list is more useful than silently excluding troublesome rows.
If a later correction changes a delivered pack, produce a clearly versioned replacement or an agreed adjustment file. State which totals and records changed and why. Do not overwrite an emailed workbook and assume the CA has the latest copy. Retain the original extraction and the reconciliation that supported it.
Ask the reviewer to select several summary lines and trace them back to source records, then trace a few source transactions forward into the summaries. This checks both unsupported totals and missing entries. The goal is a reproducible handover, not merely a folder with many attachments.
Reception sends the March handover on 2 April. A patient then pays an outstanding March bill on 4 April. The clinic records the actual April receipt and its link to the March bill, rather than altering the earlier export to make March look fully collected. The CA receives the later payment in the agreed next-period record and can reconcile the carried-forward balance.
Use these prompts in your clinic’s own notes. Record the result, responsible person and next action for each item.
It is a summary, not a complete evidence trail. Supply the agreed linked records and reconciliations so amounts, timing, corrections and carried balances can be checked.
No. Preserve what the payment is for and whether it has been applied. The CA determines the formal accounting and tax treatment; an unapplied advance should not erase an unrelated receivable.
Fees, refunds, timing and other identified adjustments can affect settlement. Reconcile the provider's batch detail to the bank credit rather than assuming the difference is missing money.
Decide by the actual purpose and required record. A management summary may not need names, while a prescribed register may require identifying fields. Share the necessary information without unrelated clinical narratives.
Provide an attributable correction through a versioned replacement or agreed adjustment file. Identify the changed records and totals, keep the earlier version and preserve actual event dates.
Updated on . Original handover and reconciliation method with limited official tax-form context. This is not a complete statutory books checklist, filing service, tax opinion or assurance that a particular export satisfies every obligation. No independent clinical or legal review is claimed.
Explains the April 2026 transition and tax-year terminology; no filing deadline or clinic-specific tax conclusion is inferred.
Accounting context; applicability varies. Original clinic examples.
Official educational guidance mapping the medical daily case register to the 2026 framework; confirm applicable records with the clinic’s CA.
Reconcile clinic cash and UPI with worked examples for shared and split payments, duplicate credits, statement differences and late confirmations.
Design clinic receipt references for split payments, reprints, refunds and retries, with document-specific tax context and a practical acceptance trial.
Prepare an April rollover with clear series rules, Indian-time boundaries, carried balances and cross-period payments, refunds and receipt reprints.
Use synthetic bills, an unapplied advance, a next-month payment and a net merchant settlement. Ask Bractis for exports that reconstruct the balances and references without granting the reviewer access to clinical notes.
Request a clinic demo