On this page
- What is a day book, and what is it not?
- The closing routine, step by step
- What should a printable closing checklist hold?
- Which mismatches come up again and again?
- How do you handle UPI references?
- What about petty cash and advances?
- How does handover work between shifts?
- What does weekly and monthly reconciliation look like?
- What should the software do?

A dental clinic day book records every payment received in a day and matches it to the invoices raised. Close it daily by payment mode: cash, UPI and card, each with its reference. List outstanding balances, account for petty cash, and hand over a signed summary. Reconcile against the bank weekly and review the full month before your accountant files.
At 9 pm the receptionist counts ₹42,300 in the drawer. The billing screen says ₹43,800. The difference is one receipt, written by hand during a power cut, that never reached the software. Nobody remembers which patient it was for.
Most clinics have a version of that evening. The day book exists to make the gap visible while someone can still remember the answer, instead of at month end when the trail is cold.
What is a day book, and what is it not?
A day book is the record of money that moved through the clinic today, by mode, against the invoices it belongs to. It is not the invoice register, and it is not the GST return. Those answer different questions.
The invoice register says what was billed and what tax applied. The day book says what was collected, what is still due, and whether the cash in the drawer matches the receipts. A clinic can have a perfect invoice register and a day book that never balances, because the two are updated by different people at different times.
The distinction matters more in dentistry than in most retail, because a single treatment is often paid in instalments across months. An implant plan quoted at ₹45,000 may arrive as ₹15,000 by UPI in October, ₹20,000 by card in November and the rest in cash. The day book has to carry the balance as well as the receipt.
The closing routine, step by step
Do the same things in the same order every day. The order is what makes it fast.
- Freeze new entries. Stop taking payments for the day and note the time. Anything after that belongs to tomorrow.
- Print or open the list of receipts for the day, by mode.
- Count the cash with the receipt list open, not from memory.
- Match each UPI and card receipt to its reference. Mark any receipt without a reference before you go further.
- Total the day by mode and write the three figures beside the invoice total.
- List the invoices raised today with no payment, and the older ones still open.
- Record petty cash spent, with the voucher number.
- Note any refund, discount or write-off and who approved it.
- Sign the summary and hand it to the second person to check.
- Move the cash to the safe or the deposit envelope. Do not leave it in the drawer.
The last step is the one that gets skipped on a busy Saturday, and it is the one that turns a small mismatch into an argument.
What should a printable closing checklist hold?
Print one page, keep it at the desk, and let the closing person tick it. A checklist that lives on a screen nobody opens is decoration.
- Cash counted and entered, with the denomination count if the amount is large
- UPI receipts matched to transaction references
- Card receipts matched to the settlement batch
- Cheques and bank transfers listed with the reference
- Invoice total for the day compared with the receipt total
- Outstanding invoices listed, with the patient name and amount
- Advances received today tagged to a patient and a future invoice
- Petty cash spent, with vouchers attached
- Refunds and discounts noted with the approver's name
- Day book signed by the closing person and checked by a second person
- Cash moved to the safe, with the deposit entry recorded
Two signatures on one page is not bureaucracy. It is the difference between "the cash was short" and "the cash was short when Ramesh closed and correct when Priya checked".
Which mismatches come up again and again?
Swipe the table to see every column| What you see | Usual cause | The fix |
|---|---|---|
| Cash short by a small amount | Change given without recording, or a receipt not entered | Recount with the receipt book open, then record the shortage instead of absorbing it |
| UPI total higher than receipts | A transfer for an older invoice, or a personal transfer to the clinic number | Match by reference, not by amount |
| Card total lower than the machine | Settlement happens after the cut-off time | Compare against the settlement date, not the payment date |
| Invoice raised, nothing received | Credit given verbally at the desk | Mark it outstanding with a due date and an owner |
| Two receipts for one payment | Duplicate entry after a printer jam | Cancel one with a reason, never delete the entry |
| Advance with no patient tag | Taken as a walk-in payment | Link the advance to the patient and the invoice it will settle |
| Discount with no approval | Applied at the desk | Require a reason and an approver above a set limit |
| Refund shown as a negative receipt | No refund voucher | Separate voucher, linked to the original invoice |
Print this table and keep it with the checklist. Half the argument at closing is a person not recognising the cause.
How do you handle UPI references?
Write the reference on the receipt at the moment of payment. Not later, not from the patient's screenshot.
UPI has a habit of producing identical amounts. Three patients paying ₹1,500 on the same evening will produce three credits that look the same in a statement. The reference, usually a 12-digit UPI transaction ID, is the only thing that separates them. A clinic that records it can answer a query in a minute. A clinic that does not will guess.
For card payments, keep the merchant copy or the settlement reference. For bank transfers, record the UTR. The principle is the same across modes: the receipt carries the proof, and the day book carries the total.
Our guide to GST for dental clinics explains why the day book should also split exempt treatment from taxable cosmetic work, since that split is rebuilt from the same receipts.
What about petty cash and advances?
Petty cash needs a fixed float and a rule. Keep ₹5,000 in the drawer for small expenses, and treat it as a separate box from patient payments. Every rupee out gets a voucher with a date and a purpose. At closing, count the float and the vouchers together, and replenish to the fixed amount rather than topping up whatever is left.
Advances are the other trap. A patient paying ₹10,000 towards a plan that starts next month has not paid for today's treatment. Record it as an advance against the patient, not as a receipt against a zero-value invoice. Otherwise the month's collection figure includes money for work that has not happened, and the plan balance is wrong from day one.
How does handover work between shifts?
A clinic that runs an evening shift needs a handover that is signed, not spoken.
Count the cash at the changeover, write the figure on the summary, and have both people sign. List any receipt still waiting for a reference. Note anything unusual: a part payment, a refund promised, a patient who will return tomorrow with the balance.
The written handover also protects the person leaving. A shortage that appears at 9 pm should not land on the receptionist who left at 2 pm.
What does weekly and monthly reconciliation look like?
Weekly, compare three lists: the day book totals, the bank and payment app credits, and the invoice list. Anything that appears in one and not the others gets a note and an owner. This is also the right time to chase the oldest outstanding balances, while the patient still remembers the treatment.
Monthly, before the accountant receives anything:
- Total collections by mode and compare with the bank statement.
- Total invoices raised, and the difference between billed and collected.
- Review outstanding balances older than 30, 60 and 90 days.
- Check the exempt and taxable split against the invoices that carried GST.
- Review discounts and write-offs, with approvals.
- Confirm the petty cash float is intact and vouchers are filed.
A monthly review that takes an hour is worth more than a quarterly audit that takes a day, because the questions are still answerable.
What should the software do?
The day book is one of the few reports where software earns its price in a single evening. Look for four things.
A closing screen that shows the day by payment mode, not one total. A field for the UPI or card reference on every receipt, and a way to list receipts missing one. An outstanding list that ages balances by patient. A lock on a closed day, so a receipt cannot be edited after the summary is signed.
IvoryCRM's billing module keeps the invoice, the receipt and the payment reference on the same patient record, and the day book closes by mode. Your accountant still owns the filing. The clinic just stops rebuilding the month from a drawer of slips.
If you are comparing systems, the dental clinic KPIs page shows which of these numbers are worth watching weekly rather than annually.
Frequently asked questions
What is a day book in a dental clinic?
It is the daily record of money received and money due, split by payment mode. It sits beside the invoice register rather than replacing it. The invoice says what was billed. The day book says what came in, by cash, UPI, card or bank transfer, and what is still owed at closing time.
How long should closing the day book take?
Ten to fifteen minutes in a clinic that records payments against invoices as they happen. If it takes an hour, the problem is upstream: receipts written on paper and entered later, UPI references not captured, or one person holding all the cash. Fix the entry step before you add more checks at closing.
Should the day book separate GST from exempt treatment?
Yes, if the clinic provides any taxable cosmetic work. Keep exempt and taxable collections in separate columns so the month's totals can be checked against the invoices. A single daily figure forces someone to rebuild the split from paper at the end of the month, which is where errors start.
How do I reconcile UPI payments in a dental clinic?
Match by reference, not by amount. Record the UPI reference or transaction ID on the receipt when the payment is taken, then compare the day's list against the bank or payment app statement. Amounts repeat often, so a ₹5,000 credit may belong to a different patient than the one you assume.
Who should close the day book?
The person who handled the cash during the shift, with a second person checking. In a single-chair clinic that may be the same receptionist and the dentist. A five-branch group should have one named owner per branch and a monthly review at head office.
See it with your own clinic day.
Book a walkthrough and follow a patient from booking through charting, treatment and billing. No patient data is needed.