Description
Stop being your own bookkeeper. This is the problem solver: one spreadsheet that runs the entire business side of your beauty studio or mobile round, so you save hours of time every month.
SOUND FAMILIAR?
– Double-booked a treatment because the diary wasn’t in one place
– Forgotten to chase a balance until weeks after it was due
– No idea what you actually earned last month until you dig through your bank app
– Patch-test dates and allergy notes scattered across sticky notes
– A phone full of client numbers you can never find fast enough
None of that is a “you” problem, it’s a missing system problem. This template fixes it.
THE FIX: ALL IN ONE SHEET
The Beautician Studio Command Centre puts treatments, clients, invoicing, expenses, mileage and tax all into one spreadsheet that does the maths for you. No formulas to write, no accounting background needed, just fill in the coloured cells.
BONUS: SEE IT IN ACTION
Your download includes a second file too – a fully filled-in example with sample treatments, clients and an invoice already entered, so you can see exactly how everything looks and works before you add your own data.
WHAT’S INSIDE
– Dashboard — this month’s revenue, expenses and profit at a glance, plus outstanding invoices, upcoming treatments, and mileage claimable to date.
– Bookings — log every treatment with client name, service, patch-test/allergy notes, price, deposit and automatic balance due and payment status (Paid / Outstanding / Overdue).
– Invoice — a proper letterhead invoice that fills itself in from a single Booking ID, ready to save as a PDF and send.
– Invoice Log — a running record of every invoice sent, so you always know what’s outstanding.
– Clients — a simple client CRM with phone, email, notes, total bookings and lifetime revenue per client.
– Expenses — log outgoings by category (beauty products, equipment, studio rent, insurance, training, marketing and more) with an automatic breakdown.
– Mileage — log mobile visits and claim mileage automatically at your own rate per mile.
– Workflow — a job-tracker board with stages from Booked through Patch Test Due, Confirmed, In Treatment and Completed.
– 12-month trend & 3-month forecast chart of revenue, expenses and profit.
– UK Tax Year Summary — revenue, expenses, net profit and an estimated tax reserve, calculated automatically.
– Start Here guide — a plain-English walkthrough of every tab, built into the workbook.
Every number flows automatically from your Bookings and Expenses tabs – enter a job once, and the Dashboard, invoice, tax summary and charts all update themselves. No macros, no add-ons, no subscription.
FORMAT
Instant digital download – works in Microsoft Excel, Google Sheets and LibreOffice, on Mac, PC, Chromebook or tablet. Nothing to install.
HOW IT WORKS
1. Purchase and download the file
2. Open it in Excel or upload it to Google Sheets
3. Follow the Start Here tab to add your business details
4. Start logging treatments – everything else updates itself
PLEASE NOTE
This is a digital product – no physical item will be shipped or posted. For personal/business use only, please don’t resell or share the file.
Questions before you buy? Message me any time, happy to help!
