OPD register format, printable and Excel
A clean daily patient register for the front desk. Pick how many rows you want and print it in A4 landscape, or download the same columns as a CSV file that opens in Excel or Google Sheets.
Free, no sign-up. It runs in your browser and nothing you type is uploaded.
Clinic name
OPD Register
Date: ________________
| Token | Date | Patient name | Age/Sex | Phone | Complaint | Diagnosis | Fee (₹) | Paid (mode) |
|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||
| 2 | ||||||||
| 3 | ||||||||
| 4 | ||||||||
| 5 | ||||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 | ||||||||
| 11 | ||||||||
| 12 | ||||||||
| 13 | ||||||||
| 14 | ||||||||
| 15 | ||||||||
| 16 | ||||||||
| 17 | ||||||||
| 18 | ||||||||
| 19 | ||||||||
| 20 |
Why keep an OPD register
The OPD register is the clinic's day book. It tells you who came, in what order, what they came for and what they paid. At the end of the day it is how the front desk tallies cash against UPI, and months later it is how you find a patient whose name you half remember. Some state Clinical Establishments rules and inspection checklists also expect a clinic to keep some record of patients seen, so a neat register is worth having even if you use software for prescriptions.
How to make your register, step by step
- Clinic name and, if you want it, the doctor's name go at the top left of every sheet. If you have used the prescription pad maker on this device, they are already filled in.
- Title defaults to OPD Register. Change it to suit, for example Evening OPD or Dr. Rao, Room 2, if the clinic keeps one register per doctor or session.
- Date is optional. Leave it blank to write the date by hand, or set it when you print sheets for a particular day.
- Rows sets how many patient lines to print: 15, 20 (one page), 25, 40 (two pages), 60 (three pages) or 100.
- First token sets the number on the first row. Use it to carry on from the last token on the previous sheet.
- Press Print register, or Download CSV template for a spreadsheet with the same columns and token numbers.
The columns in this format
- Token: the order the patient arrived in. Start from 1 every morning, or set the first token if the day runs across two sheets.
- Date: useful when one sheet covers more than a day, or when pages are filed later.
- Patient name, age and sex: enough to tell two patients with the same name apart.
- Phone: the best way to find a returning patient and to call about reports.
- Complaint and diagnosis: a few words each. They make the register searchable and help you see seasonal patterns such as a dengue spike.
- Fee and paid (mode): the amount and how it was paid: cash, UPI or card. Leave the fee blank or write "free" for reviews you do not charge for.
The footer has space for the number of patients seen and the day's total, so the doctor and the receptionist can sign off on the same numbers.
Printed register or Excel?
Paper is quick at a busy front desk and never needs a charger. A spreadsheet is easier to search and total. You can use both: print the register for the day, then copy it into the CSV template in the evening, or have the receptionist type straight into the spreadsheet. The CSV file has exactly the same columns, opens in Excel, Google Sheets or LibreOffice, and carries the token numbers you chose.
Printing tips
- Print in A4 landscape at 100 percent scale. About 20 rows fit on one page with comfortable writing space.
- Choose more rows for a busy day; the column headings repeat on every page.
- Print a week of sheets at once and keep them in a clip file or get them bound as a register book.
- Store filled registers safely. They contain patient names and phone numbers, which deserve the same care as prescriptions.
Who this is for
A printed register suits a new clinic that has not chosen software yet, a solo doctor whose assistant prefers pen and paper at the front desk, and camps or outreach OPDs where there is no computer. The CSV suits a clinic that already keeps its accounts in Excel or Google Sheets and wants the day's patients in the same place.
When the register starts to take more time than the patients, the MedPrax OPD token queue does the same job as you work: tokens, visit notes and payments in one list, with the day's totals ready at closing time.
Questions
Do this from every visit in MedPrax OPD.
MedPrax OPD keeps this register for you: every token, visit and payment recorded as it happens, with the day's totals ready.
Free plan · No card needed · See opd queue and tokens