Description
A complete inventory and financial system for an independent pharmacy, built to your specification. Runs in Google Sheets and Excel — no monthly fee, no hardware, no lock-in.
What’s inside — 16 linked tabs
- Owner dashboard — sales, gross profit, stock value and cash position at a glance
- Medicines master — generic and brand name, unit, reorder level, supplier
- Batch and expiry tracking with FEFO — the sheet tells you which batch to sell first, and flags expired stock as DO NOT SELL
- Expiry report — 30 / 60 / 90-day watchlists so nothing expires on the shelf
- Stock IN / Stock OUT — purchases and sales with running stock on hand
- Suppliers and payments — invoice-level payables with automatic Paid / Partial / Unpaid status
- Expenses, Monthly P&L, Quarterly P&L and Cash Flow
- Physical stock count — system quantity vs counted, variance flagged
- Reorder watchlist — what to buy before you run out
Exclusive licence
This system is built for you alone. BudgetSheets PH will not sell, license or publish it to any other buyer.
Includes setup with your opening stock, a one-hour walkthrough, and 30 days of support after handover.





Reviews
There are no reviews yet.