“Who owes me money?” — the one screen most clinic software gets wrong
A ₹60,000 root canal and crown paid across four visits is the normal case, not the complicated one. Most clinic software models it as an afterthought.
“The RCT patient paid ₹15,000 on the first visit. By the crown I genuinely couldn't remember what was left.”
This is the single most common money problem in an Indian dental or dermatology practice, and it is not a discipline problem. It is a modelling problem: the treatment is one thing, the payments are several, and they happen weeks apart.
Why the invoice-only model breaks
Most small-practice software treats each visit as an invoice. That works for a consultation. It falls apart the moment treatment spans visits, because now you have four invoices, three part-payments and no single place that answers "what does this patient still owe?"
The staff workaround is universal and terrible: a number written in the corner of the register, or a WhatsApp message to the owner. Both fail the day the person who wrote it is on leave.
What the data model has to do
Three things, and you can check any vendor against them in a five-minute demo:
- A treatment plan that exists above the invoice — staged, with a total the patient agreed to, so the balance is a property of the treatment and not of one bill.
- An instalment schedule attached to that plan, because "₹15,000 now and the rest across three visits" is a plan, not an accident.
- Every payment linked to both the appointment and the invoice, so the daily collection sheet balances and the patient's history is one list rather than a reconciliation exercise.
The dues screen is a collections tool, not a report
A list of balances is useless unless it is actionable. What makes it work is the context beside each number: how old the balance is, which treatment plan it belongs to, when the patient was last in, and a one-tap way to email a reminder from the same screen.
Age matters most. A ₹8,000 balance from last week is a scheduling matter. The same balance from March is a conversation, and it needs to happen before it becomes a write-off.
Cash, UPI and card still have to land in the same place
Most Indian practices collect a mix. If the software only records online payments cleanly and treats cash as an afterthought, your daily collection sheet will never tie out and you will stop trusting it inside a month.
Record the mode — cash, UPI QR, card, online link — on every payment, including pay-at-practice. The point is not bookkeeping elegance; it is that the owner can look at one number at 8pm and believe it.
A note on where the money goes
Online payments should settle into the practice's own account, not the software vendor's. This is worth checking explicitly — see why clinic software should never hold your payments.
Questions we get asked
- Can I write off a bad debt?
- You should be able to, with a reason recorded and an audit trail. Silently editing an invoice down is how disputes become unresolvable.
- What about discounts given at the chair?
- Model them on the plan or the invoice line, not by quietly reducing the total. The patient agreed to a number; you want to be able to show what changed and when.
- Does GST apply to these invoices?
- Most therapeutic healthcare is exempt, but there are real exceptions. See [our GST piece](/blog/gst-invoicing-dental-practice) — and talk to your CA.