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.
A useful weekly clinic financial review reconciles charges, patient dues, collections and advances before investigating exceptions. Start and end with explicit balances, trace unusual adjustments to their authority and compare the records with bank or cash evidence. No dashboard can make finances leak-proof, and money received is not automatically revenue or profit.
Independent Indian doctors and clinic administrators who want a practical oversight routine to discuss with their accountant without personally rechecking every routine receipt.
Choose a clear weekly cutoff and identify which location, service and business entity the review covers. A report from one branch cannot be reconciled to a bank account containing several branches without an allocation bridge.
Keep at least two patient-balance questions separate: what patients owe for charges already made, and what the clinic holds as unused patient advances. A large bank balance can coexist with unpaid bills and obligations to patients.
Agree report meanings with the person responsible for the accounts. Gross tariff, actual charge, approved adjustment, collected money, applied advance and provider settlement are different measures. Similar-looking columns are not evidence that they use the same definition.
The US GAO Green Book provides general internal-control context around operations, reporting and compliance. It is not an Indian clinic accounting standard. The review pack in this guide is original and should be adapted with the clinic's accountant to the applicable treatment and records.
Fix the evidence period before investigating a difference. A bank statement downloaded at 5 pm and a clinic report ending at 8 pm are not the same cutoff. Keep late entries and subsequently resolved items linked rather than silently changing the earlier reviewed total.
In an original fictional week, opening patient dues are ₹12,000. The clinic records ₹84,000 of gross charges and ₹4,000 of authorised reductions, leaving ₹80,000 of net charges for the period.
During the week, ₹71,000 of newly received money is applied to patient charges, and ₹3,000 of previously held advances is also applied. Closing dues are ₹12,000 + ₹80,000 − ₹71,000 − ₹3,000 = ₹18,000.
That bridge is valid only if the categories are complete and do not overlap. The ₹71,000 includes the new money applied to any included charge, whether its bill arose this week or earlier. The ₹3,000 is an application of money already held, not another bank receipt this week.
If a charge correction or write-off affects a prior-period bill, include it in the appropriate adjustment column with a clear sign and reference. Do not hide it inside collections simply because both reduce an outstanding balance.
Investigate the composition of ₹18,000 rather than only its total. An agreed payment arrangement, an unconfirmed transfer, a disputed charge and an incorrectly allocated receipt need different actions. Do not automatically label every outstanding amount as default or bad debt.
The example is deliberately a patient-balance reconciliation, not a prescription for revenue recognition, GST treatment or accounting entries. Have the responsible accountant define those separately for the actual clinic and services.
On a narrow screen, scroll the table horizontally to read all columns.
| Bridge | Calculation in the fictional week | Meaning at the cutoff |
|---|---|---|
| Net charges | ₹84,000 gross − ₹4,000 authorised reductions = ₹80,000 | Charge value after the specified adjustments |
| Patient dues | ₹12,000 + ₹80,000 − ₹71,000 − ₹3,000 = ₹18,000 | Charges still outstanding |
| New receipts | ₹71,000 applied + ₹5,000 new unused advances = ₹76,000 | New money received, before the example's refund |
| Advance balance | ₹7,000 + ₹5,000 − ₹3,000 − ₹1,000 = ₹8,000 | Unused patient money still held |
| Net money movement | ₹76,000 received − ₹1,000 refunded = ₹75,000 | Net receipts in this simplified example, not profit |
The fictional week begins with ₹7,000 of unused advances. Another ₹5,000 is received for future charges, ₹3,000 is applied to bills and ₹1,000 is actually refunded. Closing unused advances are ₹7,000 + ₹5,000 − ₹3,000 − ₹1,000 = ₹8,000.
New receipts total ₹76,000: the ₹71,000 applied to charges plus the ₹5,000 retained as new advances. Applying ₹3,000 of old advances does not increase those new receipts, because that money was received before the review period.
After the confirmed ₹1,000 refund, net money received in this simplified example is ₹75,000. This amount does not establish profit. It excludes operating costs, relevant tax and accounting adjustments, and it includes money not yet applied to services.
The ₹8,000 advance balance is a separate patient-level obligation to explain. Check that the total can be traced to named balances and that one family's payment has not been copied as a full advance for several people.
Bank credits may still differ from provider-confirmed gross payments because of settlement timing and deductions. Build that bridge from the actual provider and bank evidence; do not make patients owe a provider fee solely to force the totals to match.
Use the same discipline for refunds. An internal approval, provider request and confirmed money movement can occur at different times. The weekly report should state which event it counts and identify approved but unfinished refunds.
Use an exception pack that retains the original bill, payment or adjustment reference, current amount, author, reason and supporting evidence. A red number without those links creates work but does not explain what happened.
Start with changes that can alter a balance without new care: charge reductions, voids, allocation corrections, advance applications and refunds. Confirm that the action had the required authority and that related records agree after the change.
Then trace selected ordinary items from beginning to end. For example, select an actual charge from the clinic record and locate its payment or due balance; select a bank credit and find its patient allocation. Looking in both directions can reveal omissions that a receipt-only review misses.
Do not call every unexplained difference theft. Timing, duplicate entry, a wrong patient allocation, an omitted cash movement or a genuine unauthorised action require different findings. Preserve evidence and use the clinic's proper investigation process before reaching a conclusion.
In a solo practice, the owner may approve and review their own decisions. Make that limitation explicit and use appropriate external accounting review where needed. A second login belonging to the same person does not create independent oversight.
Limit the review pack to the financial task. A reviewer needs enough information to identify the transaction, but a financial exception is not a reason to circulate a full clinical narrative to every staff member.
For each unresolved item, write the question, current evidence, responsible person and next action. 'Reconcile UPI' is too broad; 'locate the clinic credit for the reported transfer reference and confirm its bill allocation' can be acted on.
Separate an item corrected from an explanation merely received. A staff member may explain why a charge was changed, while the linked statement or advance balance still needs correction. Closure should name the evidence that settles the financial record.
Preserve the reviewed version of the pack and link later changes. A report regenerated after corrections may be right, but without a bridge it can make the original exception and the person who resolved it disappear.
Review trends only after the definitions are stable. A drop in outstanding dues may reflect improved collection, large concessions, a reporting change or more advance applications. The number alone does not establish the cause.
Choose a small set of controls the team can actually maintain, then expand when a recurring gap warrants it. The objective is a traceable explanation of money and obligations, not an impressive number of dashboard tiles or an unsupported promise that no leakage is possible.
Discuss unusual tax, employment-benefit, related-party or professional-fee questions with the appropriately qualified adviser. This workflow supplies reconciled facts for that advice rather than substituting a generic online answer for the clinic's circumstances.
In the fictional week, ₹76,000 of new money less a ₹1,000 refund yields ₹75,000 net receipts. Separately, the dues bridge closes at ₹18,000 and the unused-advance bridge at ₹8,000. Applying ₹3,000 of old advances reduces dues and advances together; it does not create another ₹3,000 bank receipt.
Use these prompts in your clinic’s own notes. Record the result, responsible person and next action for each item.
No. Receipts can include advances and settlement effects, while profit depends on appropriate recognition, costs and other accounting treatment.
Not as new money received. It reduces the held advance and the relevant charge balance; preserve the original receipt date.
No. Distinguish authorised concessions and corrections from unexplained or unauthorised changes, with the actual amount and authority recorded.
Yes, but describe the real role and its limits. Self-review is not independent review, and relevant accounting or investigation needs may require another qualified person.
Check the cutoff, payment state, settlement timing, deductions and allocations. Preserve the mismatch until the relevant evidence explains it; do not alter patient charges just to force agreement.
Updated on . Original financial-control worksheet and fictional arithmetic, using a US control-framework overview only for general context. This is not tax advice, a statutory audit, a fraud finding or a guarantee of loss prevention. No independent clinical or legal review is claimed.
US federal internal-control framework; not Indian tax law, an accounting opinion or a fraud-prevention guarantee.
Reconcile clinic cash and UPI with worked examples for shared and split payments, duplicate credits, statement differences and late confirmations.
Match clinic collections to the correct provider, bank reference and bill allocation without treating a screenshot, card slip or uncleared cheque as settled money.
Coordinate an Indian clinic day through opening readiness, mid-session changes and end-of-day handoffs, with distinct patient, clinical and money states.
Ask Bractis to trace a synthetic week with opening dues, new charges, an advance application, a refund and a pending payment. Reconcile the exported balances and ask which accounting work remains outside the product.
Request a clinic demo