Beauty Client Tracker Spreadsheet, Lash and Nail Tech Patch Test Log and Income Tracker

Run your lash, brow, nail or beauty business from one spreadsheet: client cards, appointments, patch tests, stock and your income for the tax year. Works in Google Sheets AND Excel.

Every appointment for a service that needs a patch test is checked against your patch test log. It shows OK, Patch test needed, Patch test expired, or Reaction on file in red, so you see it before the client sits down. You set how long a clear test stays current and how many days before a treatment it must be done, to match your insurer and product makers. Client cards keep allergies, sensitivities and preferences (lash map, shape, colour) in one place, remind you when a consultation form needs updating and show when each client is next due a rebook. Prices come from your own price list, no-shows and late cancellations are charged at your fee, and deposits, payments and tips are tracked, so you always know who owes you. There are two versions: UK (£, dd/mm/yyyy, 6 April tax year) and US ($, mm/dd/yyyy, January tax year).

WHAT'S INSIDE (10 tabs)
- Settings: business name, tax year start, no-show fee, patch test rules, consultation form reminder and mileage rate
- Services: up to 40 services with category, price, minutes, patch test yes or no and product cost. Shows how many you have done, what each made and your profit per hour
- Clients: up to 150 client cards with phone, email, birthday, rebook weeks, allergies and sensitivities, preferences and consultation form date. Shows visits, spend, balance, last visit, next due, rebook status, patch test status and form status
- Appointments: up to 1,000 appointments with date, time, client, service, status, discount, paid, tip and method, plus the patch test check
- Patch Tests: up to 200 tests with product, batch number, where on the skin, checked date, result and the date each clear test is current until
- Stock: up to 100 products with cost, stock level, reorder level, opened date and use-by date. Flags Reorder, Use soon and Out of date
- Expenses: up to 300 costs (stock, equipment, rent, insurance, training and more) plus business miles valued at your rate
- Monthly: appointments, takings, tips, expenses, mileage and profit for each month of the tax year, with a chart
- Summary: takings and profit for the tax year, a "needs your attention" list, your top services and this month's client birthdays
- Start Here: plain-English instructions

It comes with sample clients so you can see how it works, with instructions for clearing them. Great for lash techs, brow artists, nail techs, mobile and home salon therapists and small beauty rooms.

This is an organiser, not tax, legal or medical advice. Always follow your insurer's and product maker's patch test instructions, and keep client records private.

WHAT YOU GET
- 2 versions: UK (£) and US ($)
- Quick Start guide (PDF)

HOW IT WORKS
- Download the files from your Etsy Purchases page
- Google Sheets: upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets
- Excel: just open it (Excel 2010 or later, Windows or Mac, or Excel for the web)
- Type in the cream cells. Everything else updates on its own
- A Quick Start PDF walks you through setup in 5 minutes

GOOD TO KNOW
- Plain formulas only: no macros, no add-ins, no subscriptions
- Formula cells are locked so you can't break them by accident (no password, so you can unlock and customise)
- Apple Numbers and LibreOffice aren't officially supported

PLEASE NOTE
- This is a DIGITAL download. Nothing physical will be shipped.
- Personal use only. Please don't share or resell the files.

Designed by Thexton Labs. Artwork and layouts were created with our own code, with the help of AI tools.