Moving Your Lab from Excel or a PaperRegister to Software: Step by Step

Nobody is really worried about the new software. They are worried about the eleven years of records in the register on the top shelf, and what happens to all of it.

That worry is fair, and it is why a lot of labs stay on Excel long after Excel stopped coping. But this move is boring work, not risky work, as long as you do it in an order. Here is the order that works.

Step 1: clean the test catalogue and the rate list

Everything else is built on these two lists, so fix them before anybody imports anything.

Put your test list and your rate card side by side and settle:

• the exact name of every test you run or send out, with duplicates merged — “CBC”, “C.B.C.” and “Complete Blood Count” are one test, not three;
• units, reference ranges and the department each test sits in;
• your own rate, plus every other rate you honour: camp rate, doctor’s rate, corporate or TPA rate, staff rate.

Most labs find tests they have not run in two years, and three different prices for the same panel. Drop the dead ones. Settle the prices now, on paper, while it is a five-minute conversation instead of a billing argument in front of a patient.

This is the step owners skip, and it decides how the rest goes. A clean catalogue takes a day. A messy one costs you a little every day after.

Step 2: decide how much history to bring across

You do not need eleven years inside the software. Pick what you will actually use:

• Patients — name, mobile number, age and sex, referring doctor. Bring all of them. This is the list that lets the front desk pull up a repeat patient by phone number instead of asking for the old bill.
• Test catalogue, doctors, rate lists — all of it.
• Old results — the real decision. Most labs import the last year or two, leave the older registers in the cupboard, and never miss them. Import everything only if your patients genuinely come back asking you to compare a value from four years ago.
• Outstanding dues — bring them in as opening balances, or you will be chasing money in two places for a year.

Write the decision down before the import starts. Changing your mind halfway through is what creates duplicate patients.

Step 3: run paper and software together for a week

Do not switch on a Monday morning and hope. For one full week, register every patient twice — in the register or the Excel sheet as usual, and in the software as well.

It is double work for five or six days, and it buys you three things. The front desk learns the screens on real patients instead of a demo. You find the tests whose ranges or report templates are wrong before a doctor finds them. And if something is missing, your usual system is still running.

At the end of the week take one day’s billing from each and compare the totals. If they match, you are ready. If they do not, you have found a rate list problem, which is what the week was for.

Step 4: train the front desk, not just the owner

The person who registers patients decides whether the software works. Train them properly, not only yourself.

An hour on each of these is usually enough:

• registration and billing, including discounts and part payments;
• collecting the sample, printing labels, and moving a sample through the day’s worklist;
• result entry, and what to do with a value the software flags;
• who verifies a report, and how it goes out on WhatsApp, print or email.

Then let them run a normal morning while someone confident sits next to them. The questions people ask during a live rush are the ones worth answering.

Settle permissions before go-live too. A receptionist should not be able to delete a bill, and only the people you authorise should be able to verify a report.

Step 5: the go-live checklist

Before you stop writing in the register:

• the test catalogue is complete, with units, ranges and departments;
• every rate list is in, camp and doctor rates included;
• the patient list is imported, and you have spot-checked a few names against the register;
• your report layout is printed once on your own letterhead and shown to your busiest referring doctor;
• the report footer carries the right signature, name and registration details;
• two people know where the data lives and how a backup is taken;
• one person is the go-to for the first week’s questions.

Keep writing the register for a fortnight after go-live. Not as a second system — as a safety net you throw away once nobody has reached for it in ten days.

What it should cost you

A single-location lab with a tidy rate list is usually live in a day or two, and the catalogue clean-up is the slow part, because it is your decisions rather than the software’s work.

At Pathora, importing your patients, test catalogue and rate lists is part of onboarding rather than a line on the invoice, and training is included. Ask every vendor you talk to the same question and get the answer in writing: “you can enter it yourself” is not a data import.

If you are still comparing vendors, our 10-point checklist has the questions to ask before you pay anything.