Hair & Beauty Booth Renter Business Kit — Clients, Formulas, Booth Rent & Tax Set-Aside in Excel

🔥 Hair & Beauty Booth Renter Business Kit — Instant Download Template

Keep every client’s formula and rebook date in one place, track booth rent and see what you keep each month.

A ready-to-use Excel workbook for booth and suite renters: stylists, colorists, lash and brow artists and nail techs. It brings clients and color formulas, your service menu, appointments, retail products, booth rent and expenses, and a monthly income and tax set-aside sheet into one file, with a Dashboard that updates from every tab. Seven working tabs plus START HERE and Settings, in one file.

✨ What You Get Inside

- START HERE: step-by-step setup, a map of every tab and my contact email

- Settings: business name, booth rent amount, weekly or monthly rent, rent start date, tax set-aside % (an illustration, not tax advice), card processing fee %, default rebook interval, year and every dropdown list (services with room for 12, payment methods, rebooked, rent frequency, client sources, product categories, expense categories)

- Clients & Formulas: formula / color notes, patch test date, next appointment, visits, last visit, days since, next due date, rebook status (Booked / Due to rebook / Due soon / OK / New) and lifetime spend (entry rows 7 to 500, 494 rows), plus a client card that shows one client’s details and last 3 visits

- Services & Prices: 12 service rows with price, minutes, product cost, rebook weeks, margin after product, earnings per hour, bookings and revenue for the year and share of revenue; the service, price and minutes columns print as a service menu

- Appointments: menu price or the price you charged, tip, payment method, rebooked Yes / No, retail product and quantity, retail sales and profit, card fee and total collected (entry rows 7 to 500, 494 rows)

- Retail Products: units sold from Appointments, on hand, Out / Reorder / OK flag, margin % and retail profit (entry rows 7 to 500, 494 rows)

- Booth Rent & Expenses: a 60-date rent schedule (weekly or monthly from your start date) with amount paid, balance and Paid / Partial / OVERDUE / Due soon / Upcoming status, plus an expense log (entry rows 7 to 500, 494 rows)

- Income & Tax Set-Aside: 12 months plus a total row with services, retail sales, tips, gross income, booth rent paid, supplies and tools, other expenses, card fees, net income, set-aside (net × your %), set-aside moved and the difference, with a year-to-date summary

- Dashboard: 8 KPI cards and 3 charts (income mix of services, retail and tips; monthly net after booth rent; top 6 services by revenue)

💡 Who This Is For

- Stylists and colorists renting a booth or suite

- Lash, brow and nail artists working for themselves

- New booth renters setting up their first business records

- Anyone who wants client formulas and rebook dates in one place

🔄 Before & After Using This Template

- Before: Color formulas on scraps of paper / After: Formula notes, patch test date and the last 3 visits on a client card

- Before: Clients drifting past their rebook date / After: Due to rebook and Due soon flags based on each client’s own rebook interval

- Before: No idea how much to put aside each month / After: A monthly set-aside amount from net income at the % you choose, with what you have moved so far

🏆 What Makes This Template Better

- Appointments feed client history, service revenue, retail stock and the monthly income sheet, so you log each visit once

- Live formulas throughout, so totals, flags and charts update as you type

- Every dropdown list lives on Settings, so you can rename items to fit your business

- Formula cells are pre-locked and shaded gray; sheet protection is off, so you can switch it on to prevent accidental edits

- Rows marked EXAMPLE DATA show how each tab works before you add your own numbers

- One ready .xlsx file: no zip to unpack

⚡ Get Results in Minutes

- Download instantly

- Open in Excel 2019 or later, Microsoft 365, or Google Sheets

- Set your booth rent and services on Settings and Services & Prices, then replace the EXAMPLE DATA rows

- Start using it immediately

Compatibility: Needs Excel 2019 or later (or Microsoft 365, or Google Sheets) because it uses the MAXIFS function, so it will not work fully in Excel 2016 or earlier. No macros.

Sample data is fictional. Replace it with yours.

🔒 Instant Access

Once you purchase, you get immediate access to your files.

Need it tailored? Get a Custom Build of this kit built around your business: https://payhip.com/b/Vs6m3

We’re a new store, but our digital tools are built to save you time, simplify your workflow, and help your business grow. Your trust matters — and every product is designed to deliver real results.

Thank you for supporting a growing brand.

— Kyle P. Herrick, Founder

✔️ Satisfaction Guarantee

If this template doesn’t help you save time or improve your workflow, message me and I’ll make it right. Your success matters.

💬 Need Help?

Message me anytime — I’m here to help you get the most out of your templates. You can also email herrickkyle87@outlook.com (the address is on the START HERE tab too).

🚀 Ready to Use This Template?

Click “Buy Now” to get instant access and start using it today.

Organization tool only; not tax, legal, accounting or financial advice.