Imagine a clinic issuing ₹20,000 in bills but collecting ₹18,000 that day. The difference might be an unpaid amount, an earlier deposit applied or a recording mistake. It cannot be explained by comparing two totals alone.
Clinic payment reconciliation matches each collection to its bill or approved purpose, then checks cash and digital payments against independent records. Separate billing dates, collection dates and bank settlement dates. Keep private clinical details out of the closing worksheet.
The idea, at a glance
Three records. One explained close.
- 01Bills
What was charged?
- 02Collections
What was actually received?
- 03Settlement
What reached the bank?
- 04Exceptions
What still needs investigation?
Start with the right question
“What did we bill?” and “What money did we receive?” are different questions. A patient may pay an earlier bill today, or a deposit may be applied later. Decide with your accountant how these movements should be recorded, and use the same method each day.
The official patient-rights charter includes detailed bills. A clear financial trail supports understandable documents, but does not replace the establishment's applicable accounting and legal requirements.
Reconcile cash independently
Here is an invented closing example. It assumes every listed movement is authorised and recorded.
| Cash movement | Amount |
|---|---|
| Opening change float | ₹1,000 |
| Cash collections | +₹4,800 |
| Cash refund | −₹300 |
| Expected cash | ₹5,500 |
| Counted cash | ₹5,500 |
| Difference | ₹0 |
Square's cash-session documentation illustrates the separation of opening cash and movements. The arithmetic is general; the product instructions are vendor-specific.
If cash differs, recount and check references before correcting anything. An adjustment needs a reason and appropriate approval, not a silent change to make the sheet balance.
Match digital collections by reference
Check the merchant provider's status, amount and transaction reference. A screenshot supplied by the payer is not the clinic's confirmation record. Keep uncertain payments in an exception list and use the provider's current support route.
NPCI's UPI FAQ points merchants to their acquiring bank for status enquiries. Do not promise a generic reversal time or ask for a duplicate payment without checking the original attempt through the approved process.
Keep the exception list small and useful
Record reference, amount, state, evidence, owner and next check time. Use internal identifiers rather than diagnoses or full medical details. Restrict the worksheet to staff who need it, following the privacy checklist.
A refund request, a pending payment and a bank settlement difference are different states. Do not combine them into “unpaid.” The action and responsible person may differ for each.
Review before closing the day
Have the appropriate reviewer check the totals and unresolved items. Preserve the audit trail for corrected receipts and refunds. If an issue remains open, transfer it using the administrative follow-up tracker.
For the patient's side of the process, use the billing-transparency guide. The close is complete when the money is explained and remaining exceptions are owned, not simply when a report has been printed.
A conversation worth having
Reader comments
What has worked in your business? Share a useful example or ask a question. Comments are reviewed before publication.
Loading comments…