poso vs spreadsheets and notebooks.
When a notebook or Excel sheet is enough, when it starts costing you money, and what changes with a proper system.
By the poso team · Updated
A notebook or Excel sheet is enough for a very small shop with a few dozen products, no expiry-dated stock and one person handling cash. Once you carry medicines, vet drugs or cosmetics with expiry dates, have staff selling, or stock more than a couple of hundred products, a system like poso pays for itself by cutting expired stock, stock-outs and cash differences, and by doing the record keeping as you sell.
Most shops start with a stock book, a receipt book and a cash box, and many move to Excel. That is sensible: these tools are free and familiar. The question is not whether spreadsheets work, but when they start costing more than they save.
Side by side
| Notebook or Excel | poso | |
|---|---|---|
| Recording a sale | Written or typed after the sale, if there is time | The sale is the record |
| Stock levels | Correct only after someone updates them | Updated with every sale and delivery |
| Expiry dates | Hard to track by batch; easy to miss | Per batch, sold earliest-expiry first, 90-day alerts |
| Reordering | Someone walks the shelves | Reorder list from minimum levels |
| Cash check | Count against a receipt book | Expected vs counted by payment method, per session |
| Who did what | Unknown | Every action linked to a user |
| Profit | Estimated at year end | Exact margin per sale, every day |
| Several people at once | One person per file, or conflicts | Many users and tills at once |
| Backup | Lost if the book or laptop is lost | Backed up by poso |
| Cost | Free, plus your time | From $29 a month |
The hidden costs of spreadsheets
The spreadsheet itself is free. The costs are elsewhere:
- Expired stock nobody spotted because expiry dates were in a column nobody sorted.
- Lost sales when a fast mover ran out because the sheet wasn't updated.
- Cash differences that can't be traced to a sale or a person.
- Owner time spent updating sheets at night instead of buying, selling or resting.
- Errors: a mistyped formula or a sorted column that breaks the whole file.
A single expired carton of a high-value medicine, or one week of a best seller out of stock, often costs more than a year of software. Our guide to reducing stock losses shows where money usually leaks.
When to switch
| Sign | Why it matters |
|---|---|
| You stock more than about 200 products | Manual stock records fall behind. |
| You sell anything with an expiry date | Batch-level expiry is very hard by hand. |
| Someone other than you handles cash | You need a per-person record. |
| You have found expired stock on the shelf | The current method isn't catching it. |
| You don't know last month's profit | Decisions are guesses. |
| You are opening a second shop | Spreadsheets don't scale across locations. |
Moving from Excel to poso
Your spreadsheet is a good start: it becomes your product import. Clean up the names, add barcodes, cost and selling prices, import it into poso, count opening stock with batch and expiry dates, and start selling. Most shops do it in a day. See how to get started.
Questions about spreadsheets vs software
Can I manage pharmacy stock in Excel?
You can for a small range, but tracking batches and expiry dates, keeping stock current as you sell and controlling cash by person become hard quickly. Most pharmacies outgrow Excel once they have staff or a few hundred products.
Is there a free alternative to pharmacy software?
Notebooks and spreadsheets are free but cost time and missed problems. A free trial of a paid system lets you compare without spending.
Can I import my Excel product list into poso?
Yes. poso imports products from Excel or CSV: names, barcodes, categories, units, costs and prices.
How long does it take to switch from a notebook to software?
Usually a day for a single shop: import products, count opening stock and train staff.
Last updated by the poso team.