From Paper OPD Cards to Digital Patient Records: A Family Practice's First Month

It's Monday, half past ten, and the queue is out the door. A patient who has been coming for years hands over his token. The receptionist goes to the almirah behind the desk and starts flipping through the S shelf. His card isn't there. It might be in the pile on the doctor's table from Saturday, or misfiled under his son's name, or in the stack waiting to be put back. After two minutes she gives up and writes a fresh card. He now has two. The one with the allergy written in red ink on page three is the one nobody can find.

This isn't a careless receptionist. It's how paper behaves at volume. Before you start converting the almirah, it helps to see exactly where paper fails, because that tells you what to digitise first and what can wait.

Why paper OPD cards break down

A paper card has four structural weaknesses, and none of them can be trained away.

• There is one copy. If the card is on the doctor's desk, in a bag or misfiled, the patient's history doesn't exist for that visit.
• It is found by memory. Filing by name, card number or date only works if everyone files the same way, every day, including the Saturday locum.
• Duplicates multiply silently. Every "can't find it, make a new one" splits a patient's history across two cards, and neither card knows about the other.
• The important lines get buried. An allergy noted on the first visit sits under years of consult notes. The current chronic medicines get rewritten, slightly differently, at each review visit.

There's a fifth weakness that matters to the business: you can't ask a stack of cards a question. Who hasn't been in for their monthly review? Which children are due for their next vaccination? Answering that from paper means a person reading cards one by one, so in practice it rarely gets asked.

The usual way a digitisation project fails is the opposite mistake: someone decides every card must be scanned or typed in before the new system goes live. The project stalls on shelf C, and the clinic keeps running on paper.

What to digitise first

Don't digitise the almirah. Digitise the patients who are actually walking in, and only the lines on their card that change what happens at the next visit.

1. Active patients only. Pick a cut-off, such as anyone seen in the last year. Patients older than that get a digital record the day they return.
2. Identity and contact. Full name, date of birth (or age if that's all you have), sex and a mobile number. For a child, the parent or guardian's name and number.
3. Allergies as recorded. Copy exactly what the card says, and have the doctor confirm it with the patient at the next visit. The point is to move the information, not to interpret it.
4. Current chronic medicines. The list the patient is taking now, as it appears in the latest note. Not the full history.
5. The old card number. Put it in the digital record so anyone can go straight to the paper card when the older notes are needed.

Everything else, meaning years of old consult notes, lab slips and referral letters, stays on paper for now. It isn't lost. It's one card number away.

Say a two-doctor family clinic has around 6,000 cards built up over fifteen years, but only about 1,500 patients have visited in the last twelve months. In this example, the job shrinks by three quarters before anyone types a word. Better still, those 1,500 come in on their own over the following weeks, so their records can be built and checked at the desk while they're there, rather than in a back-office marathon.

Importing the Excel list you already have

Plenty of family practices already have a patient spreadsheet: a list a receptionist started for phone numbers, or a register someone typed up during a slow month. It's worth using, but clean it before it goes anywhere.

• One row per patient. Sort by mobile number and look for repeats. A shared family number is normal, so check the names before merging anything.
• One column per field. Name, date of birth, sex, mobile, guardian name, old card number. Split "Ramesh Kumar 9xxxx M" into its pieces.
• Consistent formats. Dates written one way throughout, phone numbers without spaces or a leading zero, sex as one agreed set of values.
• Leave clinical lines out of the bulk import. Allergies and medicines typed into a spreadsheet years ago are the lines most likely to be out of date. Enter them at the patient's next visit, read off the current card and confirmed with the patient.

MyCliniCore can import a patient list from Excel or CSV during setup. If the clinic later switches on the optional WhatsApp welcome message, it goes only to patients staff add by hand and is never sent to patients who came in through the import. Whatever system you use, run a test import of twenty rows first and open each record to check the columns landed where you expected.

Running paper and digital side by side for a month

Don't switch overnight. Run both for about a month, with simple rules everyone can follow on a busy morning.

1. Every patient seen today gets a digital record today. If they were in the import, check and complete it. If not, create it at the desk.
2. The paper card still gets pulled and written on. It's the safety net while staff are learning, and it keeps the old history in reach.
3. The doctor writes the consult in the system. Notes, vitals and the prescription. Check that the prescription printout carries what you need on it, such as the patient's age and sex and the doctor's registration number and qualification, before the month starts, not halfway through.
4. Count at closing. The receptionist compares the day's token register with the number of digital consults. Any gap gets fixed before going home, not on Friday.
5. A ten-minute review each week. What slowed the queue? Which field does nobody fill in? Fix one thing a week.

Expect the first Monday to be slower. That's the real cost of the change, and it's why you don't start it in the middle of monsoon fever season. Pick a quieter stretch if your calendar allows it.

Deciding when to stop writing on paper

End the parallel run when three things are true: the closing count has matched every day for a couple of weeks, the doctors stopped looking at the paper card during routine consults some time ago, and the receptionist finds a patient faster in the system than in the almirah. If any one of those isn't true yet, run another week.

Stopping new entries on paper doesn't mean throwing the cards away. Keep the almirah. Medical record retention depends on the Clinical Establishments Act, 2010 where your state has adopted it, on state rules and on your own professional obligations, and requirements vary by state. Check with your state authority or a legal adviser before you archive or dispose of anything.

Once the active patients are digital, the questions paper couldn't answer become possible. A sensible next step is a review-date habit for chronic patients, covered in setting review dates for chronic patients.

If you'd like to see how this setup and import would look for your practice, MyCliniCore is now available for general practices and polyclinics, and the team sets it up with you. You can also browse the features first. When you're ready, tell us about your clinic.