Excel vs pharmacy software: the honest comparison
Where a spreadsheet genuinely beats pharmacy software, where it quietly breaks, the side-by-side, and the point at which it's time to move — plus how to move in an afternoon.
Most comparisons like this are written by software companies and arrive at the conclusion you'd expect. We are a software company too, so here is the deal: we'll start with where the spreadsheet wins, be specific about where it breaks, and tell you when to stay on it.
Where Excel is genuinely better
It's free, and you already have it. No subscription, no sign-up, no trial ending.
Everyone knows it. You can hand it to a new staff member and they can read it. Software has a learning curve, even a short one.
It works offline. A laptop with a spreadsheet works in a power cut with no network. Cloud software, by and large, does not.
It bends to you. Want a column for "supplier's cousin's phone number"? Add it. Software makes you do things its way.
It is fine for a very small shop. One person, under fifty products, no credit sales, no prescriptions. If that's you, stop reading and go back to work — you don't need software yet.
Where it quietly breaks
The spreadsheet rarely fails loudly. It fails by becoming slightly wrong in ways nobody notices until stock-take.
Two people, one file. The cashier is selling; you are updating stock. One of you overwrites the other's changes, or you keep two copies and merge them on Sunday. Every pharmacy that has ever run on a spreadsheet has a story about the Sunday merge.
The expiry column nobody sorts. The dates are in there. Somebody has to sort by that column every Monday and act on it. The week that doesn't happen is the week a box goes past its date on the shelf.
Batches don't fit in a row. One product, three deliveries, three expiry dates. A spreadsheet wants one row per product. So either you have three rows for paracetamol (and the stock total is now a formula someone will break) or one row with the nearest expiry date (and you've lost track of the other two batches).
Credit lives in a second file. Sales in one sheet, what customers owe in another, repayments typed in by hand. The two disagree within a month. Nobody knows who owes for more than 60 days without an afternoon's work.
There is no till. The spreadsheet doesn't print a receipt, take a split payment, or stop a cashier selling on credit to someone over their limit. So sales get written on paper and typed in later — or not.
There is no "who". A quantity changed from 40 to 4. Was it a sale, a typo, or something else? The spreadsheet doesn't know and can't tell you.
It doesn't scale to a second branch. Two shops means two files, or one file that two shops fight over. "What did the other shop do today" means a phone call.
Side by side
| Spreadsheet | Pharmacy software (Shopman) | |
|---|---|---|
| Cost | Free | Free for 1 user / 50 products; $19–$49 a month for a single shop |
| Stock by batch and expiry | Possible, fragile | Built in; sells oldest batch first |
| Expiry alerts | If someone remembers to sort | Automatic, 90 / 30 / 7 days |
| Till and receipts | No | Yes — cash, card, mobile money, split, credit |
| Credit limits and ageing | Manual, in a second file | Enforced at the till; ageing report |
| Prescriptions linked to sales | No | Yes (Starter and above) |
| Profit & Loss | If you build it | One click |
| Several people at once | Painful | Normal; five staff roles |
| Who changed what | No | Activity log with before/after |
| Second branch | Second file | Its own shop, seen from head office |
| Works offline | Yes | Needs internet |
| Your data is yours | Yes | Yes — export any report to Excel |
When to stay on Excel
Honestly:
- You are the only person who touches stock and sales.
- Under about fifty products.
- You don't sell on credit, or only to two people you'd trust with your keys.
- No prescriptions, no controlled substances.
- One location, and no plans for a second.
That describes a real shop, and for that shop the software is overhead.
When it's time to move
The moment any one of these is true:
- A second person needs the file while you're using it.
- You found expired stock on the shelf and it wasn't the first time.
- You can't say, right now, how much customers owe you in total.
- You're dispensing prescriptions.
- You're opening a second location.
Not because the spreadsheet is bad, but because each of those is a job it was never built for, and the workaround costs you more hours than the software costs money.
How to move in an afternoon
- Export your product list to CSV: name, SKU or barcode if you have one, cost price, selling price, current quantity, reorder level.
- Import it. Shopman's bulk upload takes that file; twenty minutes for a few hundred products. Categories can be set on the way in.
- Enter the batches you care about — the ones with expiry dates in the next six months. Everything else can be received properly on its next delivery.
- Enter outstanding credit as an opening balance per customer. You'll want the customer list anyway.
- Run both for a week. Ring up sales in the software; keep the spreadsheet as the fallback. By Friday you'll know.
- Export a backup from the software to Excel at any point — so the fear of being locked in is answered before it's asked.
Start free, with your own product list — fourteen days of the full plan, no card, and the free tier stays free after.
Frequently asked
Can I keep using Excel for some things? Yes, and many shops do — for supplier price comparisons, staff rotas, the things that are genuinely personal. Stock, sales and credit are the three that need one shared source of truth.
What happens to my spreadsheet history? Import the product list and opening credit balances; keep the old file for reference. Historical sales rarely need to come across — the reports start from the day you switch.
Is cloud software safe for a pharmacy's data? Each shop's data in Shopman is separated from every other shop's at the database level — it's the first thing the system was built around, and it's documented publicly. A spreadsheet on a shared laptop is, by comparison, one USB stick away from anywhere.