OPD Register Format in Excel (Free) – Patient Register, Token No. & OPD Slip with Bill

opd register format

Advertisement

Quick answer: An OPD register needs one row per visit with these columns:

  • token no., date, patient name, age / sex and phone
  • complaint and doctor
  • fee (consultation + services), discount, paid, mode and balance
  • next visit date, so follow-ups aren’t missed

Download a free OPD register in Excel below. Token numbers restart every day, the day’s patients and collection are totalled, and follow-ups due soon or missed are coloured. It also has a printable OPD slip with an Rx area and the bill.

Key takeaways

  • OPD register for 200 visits, with the token no. and balance worked out automatically.
  • Daily totals: type a date to see patients, collection and balance for that day.
  • Follow-up alerts: next visits in the next 3 days in orange, missed ones in red.
  • Printable OPD slip with clinic header, vitals, Rx space and bill. Free, no macros.

↓ Jump to the free download

FOR CLINICSStop juggling registers. Run your whole OPD in one Excel file.XploreClinic does tokens, slips, free follow-ups, daily collection and doctor share — automatically.See XploreClinic — from ₹499 →⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceXploreClinic

OPD register format in Excel with token number, fee, balance and next visit
Token numbers restart each day. A missed follow-up shows in red, one due in the next 3 days in orange.

What an OPD register should record

ColumnWhy it matters
Token no. and datePatients are called in order; the count gives daily OPD numbers.
Patient name, age / sex, phoneIdentifies the patient and lets you call for follow-ups.
Complaint and doctorShows the reason for the visit and who saw the patient (useful with visiting doctors).
Fee, discount, paid, modeDaily cash and UPI collection must match the register.
Balance and next visitNothing pending is forgotten, and patients come back on time.

OPD slip format with bill

OPD slip format in Excel with clinic header, Rx area and bill
Clinic and doctor header, patient details and vitals, space for the prescription, and the bill at the bottom.

The slip has:

  • clinic name, address, phone and timings, and the doctor’s name and qualification
  • date, token, patient, age / sex, phone and visit type
  • BP, weight, temperature and pulse
  • a blank Rx area for the doctor to write in
  • bill lines, discount, total, paid, balance and next visit date

Change the header once with your clinic details, then fill the yellow cells for each patient and print on A4 or A5.

Tips for running the OPD desk

  • Enter each patient at the reception desk as they arrive. The token no. fills itself.
  • At closing time, type today’s date at the top and match the collection with the cash drawer and UPI app.
  • Check the red rows once a day and call those patients. Missed follow-ups are lost revenue and, often, worse outcomes.
  • Keep one file per year and save a backup copy every week.
Outgrown the free sheet? Here’s what XploreClinic adds

Free sheetXploreClinic
WhatsApp follow-up reminders—✓
Free follow-up fee rule—✓
Visiting doctor share—✓
Monthly report—✓
Up to 10,000 visits a year—✓
Fill-in forms & one-click PDF (macro edition)—✓

⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceGet XploreClinic — from ₹499 →

Download the free OPD Register & OPD Slip

There are two sheets: OPD Register and OPD Slip. Fill in the yellow cells; everything else is worked out.

Get updates and new free templates

Your download below doesn’t need this. Leave your WhatsApp number or email and I’ll send you fixes for this file and new free templates. No spam, unsubscribe anytime.

Was this template useful?

FAQs

Is this a medical records system?

No. It is an OPD register and billing sheet. Keep clinical notes as your state rules and medical council require.

Advertisement

Can I use it for a dental or physiotherapy clinic?

Yes. Change the complaint column to “treatment” and the fee to your procedure rates.

Does it work on mobile?

Yes. Open it in the Excel or Google Sheets app at the reception desk.

More free templates

Advertisement

Amanpreet Kaur Bharaj
I'm Amanpreet Kaur Bharaj from Hoshiarpur, Punjab. I've worked in Excel for about 12 years, and since 2022 I've run my own ethnic-wear boutique, Punjabi Libas, on Excel files I built myself. XplorExcel is where I share those files: free templates for everyday business work, and ready-made Excel software for shops, boutiques, clinics, dairies, mandis and offices. Every file comes with a filled-in sample so you can see how it works. Stuck with one? Message me and I'll help.