The Independent Optician Management System is an all-in-one independent optician business spreadsheet. Log every sale, chase unpaid invoices, run your stock take, keep on top of daily checks, certificates and risk assessments, and see your profit on a live dashboard. It costs £15 once, with no subscription and no app.
Why a spreadsheet instead of an app
- One-off £15, not a monthly fee
- Works in Excel you already own, Excel online or Google Sheets
- Your data stays in your file
- Fully editable: add your own checks, stock items, hazards and categories
Built for opticians
- Daily, weekly and monthly checks: sight test performed by a registered optometrist, nHS eligibility checked and form signed, equipment calibrated and cleaned, prescription issued to the patient, referrals sent where needed and more, each showing Up to date, Due soon or Overdue.
- Compliance register with renewal reminders: sight tests only by registered optometrists or doctors, gOC registration for individuals and, where required, the business, nHS General Ophthalmic Services contract (if offering NHS tests), restrictions on selling to children and people registered sight-impaired, professional indemnity and public liability insurance, plus infection control for contact lenses and equipment, patient records kept under UK GDPR, iCO data protection fee, data protection and VAT.
- Risk assessment template: 7 pre-filled hazards with likelihood × severity scoring and 12-month review dates.
- Stock take: pre-loaded with spectacle frames, sunglasses, contact lenses and solutions, cases and cleaning cloths and more, with usage, stock value and reorder alerts.
- Operations tracker: service or product, patient, patients or sales, revenue, costs and gross profit on every line, with "collection or recall due" reminders.
- Key figures for your trade: eye examinations, average spend per patient, cost of goods % of revenue and gross margin.
Money and admin, done for you
- Sales and VAT: net, tax and gross on every sale
- Invoice tracker and debtors report with aged debt and a "chase these first" list
- 12-week cash flow forecast with shortfall warnings
- Quarterly VAT summary, profit and loss by month, budget vs actual and a pricing calculator
- Expenses, staff hours, rota, customers, suppliers, assets and maintenance logs
Works wherever you are
- 5 languages: English, Spanish, French, German and Portuguese
- 25 countries and currencies
- Excel 2016+, Microsoft 365, Excel for Mac, Excel online and Google Sheets. No macros.
What you get
- Independent Optician Management System (.xlsx), 24 working sheets, with example data that's easy to delete and a Start Here guide
Read: How to start an independent optician in the UK · How much an optician earns · The KPIs to track · Free startup cost calculator
Often used alongside: Hearing Clinic Management System · Podiatry Clinic Business Management System · Physiotherapy Clinic Management System · Free HR Starter Pack
Need a business plan too? Independent Optician Business Plan Template: £10 · Or get everything: Full Business Pack: £20 (save £5)









