Independent optician business spreadsheet: run your business from one Excel file

Run your independent optician in Excel: patients, eye exams, recalls, glasses orders, contact lens plans, stock and cash flow. £15.

£15 one-off · No subscription · Excel workbook.

Starting a independent optician business business? Use our free startup-cost guide and calculator →

Independent Optician Management System cover

Independent Optician Management System dashboard preview

Look inside

Real screenshots from the Independent Optician Management System workbook.

Independent Optician Management System operations worksheet screenshot
Operations — Real operating records and monthly performance in the workbook.
Independent Optician Management System checks worksheet screenshot
Checks — Daily and recurring checks, with completion status and follow-up.
Independent Optician Management System compliance worksheet screenshot
Compliance — Renewals, registrations and important compliance dates.
Independent Optician Management System risk assessments worksheet screenshot
Risk Assessments — Industry risks, controls and review tracking.
Independent Optician Management System stock take worksheet screenshot
Stock Take — Stock, supplies or equipment information relevant to the business.
Independent Optician Management System rota worksheet screenshot
Rota — People, bookings or capacity planning for the working week.
Independent Optician Management System cash flow worksheet screenshot
Cash Flow — Income, costs and cash position in one workbook.
Independent Optician Management System debtors worksheet screenshot
Debtors — Customer balances, due dates and payment follow-up.

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

Built for opticians

Money and admin, done for you

Works wherever you are

What you get

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)

How to start this business

How much can you earn?

The KPIs to track

FAQ

Is this a one-off payment? Yes. £15 once, with no subscription and no monthly fee.

Does it work on Mac, Excel online and Google Sheets? Yes: Excel 2016 or later on Windows and Mac, Excel for the web, and Google Sheets. To use it in Google Sheets, upload the file to Google Drive, open it with Google Sheets, then choose File, Save as Google Sheets.

Does it calculate VAT? Yes. Set your rate and it works out tax on every sale, plus a quarterly summary. Always check figures with your accountant before filing.

Is there example data? Yes. Example rows show how it works and are marked 'Example' so you can delete them.

Browse all Business Management Systems