Service Pricing Calculator for Beauty Trades | Excel & Sheets

What should I charge? This spreadsheet answers it. Put in what your business costs each month, the take-home pay you want and the hours you really spend with clients. It works out the hourly rate you need, prices every service you offer, and flags the ones that are losing you money.

Made for nail techs, lash and brow artists, hairdressers, barbers, dog groomers, tattoo artists and beauty therapists working for themselves in the UK.

What's inside, sheet by sheet

• Start here: numbered steps, including how to open it in Google Sheets.
• Settings: business name, your trade (7 to pick from), and whether suggested prices round up to the next £1 or 50p.
• My costs: rent or chair rent, insurance, booking app, phone, software, training, marketing and more; your target take-home pay, tax set-aside %, working weeks and client hours. Gives you the hourly rate you need.
• Products: pack cost and how many clients a pack does, turned into a cost per client.
• Services: each service's time, products and current price. You get product cost, time cost, full cost, a suggested price, profit per service, profit per hour and a green, amber or red flag.
• Price rise: current vs new price, % change and what it adds each month, plus a short, friendly message to copy and send to clients.
• Example services: common UK service names and typical times for your trade, to get you started. No prices: those are yours to set.

Formulas are locked so you can't break them by accident. It comes filled with a made-up nail tech so you can see it working; Start here tells you how to clear it.

How delivery works

After checkout you get a download link. Open the file in Excel, or upload it to Google Drive and open with Google Sheets. Nothing to install.

Honest limits

• It works from your numbers. It doesn't know local market prices and doesn't pretend to.
• Typical times are a starting point. Time yourself and use your own.
• Suggested prices assume you're not VAT registered. The tax set-aside % is a rough figure, not tax advice.

FAQ

I'm not a nail tech. Will it work for me?
Yes. Pick your trade in Settings to see example services for it, then put in your own services. The maths is the same for any service you do by the hour.

What do the colours mean?
Green: the price covers products, overheads and your full target pay. Amber: it covers your costs but not all your pay. Red: you lose money every time you do it.

Does it work on a phone?
It opens in the Google Sheets app, but it's much easier to set up on a laptop or tablet.