Clinic Patient Management System in Excel: Patient Register, Visits, Fees, Follow-up Reminders and Receipts

By Ravindra Bagale · Last updated: 17 October 2026

Download the template: clinic-patient-management-system-template.xlsx: a 7-sheet system with example data and real formulas (Read me, Setup, Patients, Visits, Receipt, Report, Dashboard). Yellow cells are inputs you can type over; green cells hold formulas; blue rows are headers and totals. Replace the example data with your own and every report and the dashboard recalculate.

Made-up data: every name, amount, business and date on this page is made up for practice. Cities are used only to make the examples feel real.

1. The business story

Bagale Clinic, 1 to 17 October 2026 (made-up patients and fees).

A follow-up is Done when the same patient has any later visit, Missed? when its date has passed without one, Due when it falls within the next 7 days. For patients tracking their own readings at home, see the blood pressure log; the hospital view is in 27.7 healthcare: revenue and length of stay.

2. Build it sheet by sheet

Step 1. Setup and Patients

1. On Setup, type the as-of date in B3, the clinic in B4 and the follow-up window (7 days) in B5. From row 8: visit types and fees (New consultation ₹500, Follow-up ₹300, Dressing ₹200, Procedure ₹1,500).
2. On Patients, type ID, name, gender and age. Visits E5 =COUNTIF(Visits!$C$5:$C$300,A5), last visit F5 =MAXIFS(Visits!$B$5:$B$300,Visits!$C$5:$C$300,A5), billed, paid and due with SUMIFS (SUMIFS).

Step 2. Visits: fee, balance and follow-up date

1. On Visits, type visit no, date, patient ID, visit type, paid, payment mode and follow-up days. Patient D5: =XLOOKUP(C5,Patients!$A$5:$A$40,Patients!$B$5:$B$40,"Check ID") (XLOOKUP).
2. Fee F5: =XLOOKUP(E5,Setup!$A$8:$A$11,Setup!$B$8:$B$11,0) and balance H5 =F5-G5 (red when above 0).
3. Follow-up date K5: =IF(J5="","",B5+J5): blank when no follow-up was advised.

Step 3. Visits: follow-up status

1. Status L5: =IF(K5="","",IF(COUNTIFS($C$5:$C$300,C5,$B$5:$B$300,">"&B5)>0,"Done",IF(K5<Setup!$B$3,"Missed?",IF(K5<=Setup!$B$3+Setup!$B$5,"Due","Later")))).
2. Read it from the inside: has this patient visited after this date? Then Done. Otherwise, is the date past? Missed?. Within the window? Due. Else Later (nested IF, COUNTIFS).
3. Colour Due amber and Missed? red. Ravina (V-0005) was due on 11 October with no later visit: Missed?.

Step 4. Receipt

1. On Receipt, pick the visit in B4. Each line is =XLOOKUP($B$4,Visits!$A$5:$A$300,Visits!$B$5:$B$300) with the right column: date, patient, visit type, fee, paid, balance, payment mode.
2. Next visit B14: =IF(XLOOKUP(...K...)="","Not advised",XLOOKUP(...K...)). Set the print area A1:D16 (print area).

Step 5. Report and Dashboard

1. On Report, per visit type: visits =COUNTIF(Visits!$E$5:$E$300,A5), billed and collected with SUMIFS; per payment mode: collected.
2. On Dashboard, KPI cards: visits, billed =SUM(Visits!$F$5:$F$300), collected, dues =B5-C5, follow-ups due =COUNTIF(Visits!$L$5:$L$300,"Due") and possibly missed (KPI cards).

3. Formulas used

Every formula above is written in the template, so you can click a cell and see it in the formula bar. All values on this page were recalculated in LibreOffice with zero errors.

4. Common mistakes

1. Typing patient names instead of IDs. Two patients can share a name. Use the patient ID; the name is looked up.
2. Treating "Missed?" as certain. The patient may have visited another doctor or recovered. It is a list of people to call, not a verdict.
3. Changing the fee on old visits when fees go up. Fees are looked up from Setup. When fees change, add the new fee from that date, or paste old fees as values first.
4. Writing medical notes in this file. Keep clinical notes in your clinical record. This file has names and money, so protect it with a password.
5. Leaving follow-up days blank when advised. If the doctor said "come after 7 days", type 7. A blank means no follow-up was advised.

5. More real examples

Example 1: Physiotherapy centre. Visit type Session; follow-up days 2 or 3; a Patients column counts sessions against the number prescribed.

Example 2: Dental clinic with treatment plans. Add a Plan amount per patient and track paid against the plan with SUMIFS.

Example 3: Vaccination reminders. Use follow-up days for the next dose; the Due list becomes the week's call list.

Quick revision cards

Englishमराठीहिंदी

Quick revision

Each card shows formulas from this page, each with an example and its answer from the template. Scan the QR code on a card to open this lesson. All names and numbers are made up for practice.

More cards: Ravi Sir's Cards.

6. Frequently asked questions

How do I make a patient register in Excel?

One row per patient with an ID, and a Visits sheet with one row per visit. Totals per patient come from COUNTIF, MAXIFS and SUMIFS.

How can Excel remind me of follow-ups?

Compute follow-up date = visit date + days advised, and a status that checks for a later visit with COUNTIFS and compares with today.

How do I know if a patient came back?

COUNTIFS(patient column, this patient, date column, ">"&this date) > 0 means there is a later visit.

How do I print a receipt?

Pick the visit number in a cell, look up each detail with XLOOKUP and set the print area to the receipt.

Is it safe to keep patient data in Excel?

Keep only what you need, protect the file with a password, and do not share it. Medical notes belong in your clinical record.

7. Quick quiz

Ten questions on this page. Sign in to save your score.