Report this item to Etsy

UK Beauty Business Spreadsheet 2026/27, Hairdresser Nail Tech Lash Barber Bookkeeping, Client and Patch Test Tracker, Excel & Google Sheets

Price:$16.68

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by TaxReadySheets
  • Digital download
  • Digital file type(s): 1 PDF, 2 other files

Self-employed in hair or beauty? Keep your takings, clients, prices and tax in one place. Log each appointment and this kit works out your income, tips, fees and profit, tells you how much to set aside for tax, shows which clients are due back and checks every patch test for you. Works in Excel and Google Sheets.

Built for UK hairdressers, barbers, nail technicians, lash and brow techs, beauty therapists and makeup artists, whether you rent a chair, work from home, go mobile or run your own studio.

WHAT IT DOES FOR YOU
• Pick the client and service and the price fills in from your price list. Tips, retail sales, gift vouchers, deposits and no-shows are all handled
• Works out card reader and booking-app fees from your own %
• Client book: visits, total spend, last visit and the date each client is due back, with overdue clients highlighted
• Patch test checker: log patch tests like appointments and every colour, lash and brow service is checked. Tests done too close to the appointment, out-of-date tests and reactions on file are flagged
• Price checker: your real profit per hour after products and card fees, services below your target rate flagged, and the price you'd need to hit your target
• Shows how much to set aside each month and whether your tax pot covers your estimated bill
• Expenses matched to HMRC's boxes, including chair or room rent, products, tools, training and uniform. Mileage at 55p a mile for mobile work
• Flags Making Tax Digital if your 2026/27 income goes over £20,000

WHAT'S INSIDE (15 tabs + an example file)
• Appointments: 1,000 rows for appointments, tips, retail, vouchers, no-shows and patch tests, with a Check column that flags mistakes
• Clients: 300 clients with visits, spend, due-back dates and patch test status
• Services: 50 services with profit per hour, price check and times booked
• Dashboard: income, profit, tax set aside, tax bill, clients due back, patch tests due, money lost to no-shows, monthly chart and top 5 services
• Monthly Summary: takings, tips, retail, fees, expenses, profit and what to set aside, month by month
• Tax Estimate: Income Tax, Class 4 NI, the £1,000 trading allowance check, payments on account and Making Tax Digital
• Expenses: 1,000 rows with category drop-downs, business-use % and receipt tracking
• Mileage: business trips with 55p and 25p worked out for you
• Annual Summary: your figures for the self-employment pages of your tax return
• Plus Start Here guide, Settings, Key Dates, Checklist, What Goes Where and Rates (with GOV.UK sources)

YOU'LL RECEIVE
• Blank Excel spreadsheet (.xlsx)
• Example Excel spreadsheet filled with a sample home nail and lash studio
• PDF with your Google Sheets links (click "Make a copy")

WORKS WITH
Microsoft Excel 2016 or newer (Windows and Mac) and Google Sheets with a free Google account. Set up on a computer; after that you can check it on your phone.

PLEASE NOTE
• Digital download only. No physical item will be sent.
• This is not a booking system. It keeps your records and works out your figures. It doesn't send anything to HMRC or file your tax return.
• Patch test rules come from your product manufacturer and your insurer. The kit reminds you, using the rules you set.
• Client details are personal data. Keep your copy private and only record what you need.
• It's a record-keeping tool, not tax or financial advice.
• Built for self-employed sole traders. Limited companies, partnerships, VAT-registered businesses and salon payroll aren't covered.
• Uses 2026/27 rates for England, Wales and Northern Ireland. Scottish income tax bands are different, so the estimate won't be exact in Scotland. Student loans and the High Income Child Benefit Charge aren't included.
• Designed by me with the help of AI tools, then checked and tested by hand.
• For your own use only. Please don't share or resell.

Questions or stuck? Send me a message, I reply within 24 hours.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

Hair Salon Bookkeeping

Listed on Oct 23, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Bookkeeping Templates