Nail Tech Business Profit and Client Tracker

Nail Tech Profit Tracker Excel for your nail business — service pricing, appointment profit, supplies inventory, and a monthly P and L dashboard. Know what every service actually costs — and whether the month actually made money.

Built for nail techs, booth renters, and small nail salon owners who need to know, service by service and appointment by appointment, whether the hourly price covers the supplies, the labor, and the booth rent — without accounting software. If a service is losing money, this workbook shows it before the next booking.

WHAT'S INCLUDED (6 sheets):

- Services and Pricing — average hours, supplies cost and labor cost per service, cost per hour, price per hour, and margin in dollars and percent for every service. Change a cost and every appointment profit updates by formula.

- Appointments Log — date, client, nail tech, service, hours, rate per hour, revenue, cost per hour pulled from the service sheet, profit per appointment, and margin. Log full sets, fills, pedicures, and free nail fixes in one place.

- Supplies and Inventory — supply, unit, quantity on hand, reorder point, cost per unit, and stock value. Anything at or below its reorder point is flagged LOW STOCK so you buy it before the next client.

- Monthly P and L — revenue, supplies and labor cost, booth rent, utilities, and other expenses by month, Jan-Dec, with net profit and margin. Revenue and appointment cost are formulas from the Appointments sheet.

- Dashboard — total revenue, appointments, hours, average appointment value, gross and net profit and margin, best service by margin per hour and by margin percent, best-selling service, best appointment and best nail tech, costs by category, and low stock count.

- Cover and How to Use — start here. Yellow cells are the only ones you edit.

EXAMPLE DATA (October 2026 — replace with your own numbers):

- Total revenue 1,710.25 from 20 appointments and 24.75 hours; average appointment value 85.51.

- Supplies plus labor cost 940.50; gross profit 769.75; gross margin 45.0 percent.

- Booth rent 450, utilities 80, other expenses 140 (booking software, marketing, insurance); total expenses 1,610.50; net profit 99.75; net margin 5.8 percent.

- Revenue by nail tech: Ava 665 (best), Zoe 543.75, Mia 501.50.

- Best service by margin per hour and by margin percent: Acrylic Full Set, margin 48.00 per hour, 56.5 percent (cost 37.00 per hour, price 85).

- Best-selling service: Acrylic Full Set, 4 hours. Next: Gel-X Extensions 3.5, Structured Gel Manicure and Acrylic Fill / Rebalance 3 each.

- Best appointment: Emma R., October 1, Acrylic Full Set x2 hours — revenue 170, profit 96.

- Inventory example: stock value 1,172, with 7 items at or below their reorder point — Gel Polish - Reds, Builder Gel, Acrylic Liquid (Monomer), Gel-X Tips, Buffers, Disposable Towels, and Top Coat (No-Wipe).

HOW IT WORKS:

1. Download the Excel file instantly after purchase.

2. On sheet 1, enter each service's average hours, supplies cost per service, labor cost per service, and price per hour. Cost per hour and margin fill in by formula.

3. On sheet 2, log every appointment: date, client, nail tech, service (spelled exactly as on sheet 1), hours, and rate per hour. Revenue, cost per hour, and profit fill in by formula.

4. On sheet 3, keep quantities on hand current and set a reorder point for each supply. Buy more of anything flagged LOW STOCK before the next client.

5. On sheet 4, enter booth rent, utilities, and other expenses each month, then check gross and net profit on the Dashboard.

HOW THE NUMBERS WORK:

Cost per hour is (supplies cost per service plus labor cost per service) divided by average hours. Margin per hour is price per hour minus cost per hour. Margin percent is margin per hour divided by price per hour. Gross profit is revenue minus supplies and labor cost; net profit is revenue minus supplies and labor cost, booth rent, utilities, and other expenses. One billable hour is one unit.

WHO IT'S FOR:

Nail techs, booth renters, and small nail salon owners who want service pricing, appointment profit, supplies inventory, and a monthly P and L in one workbook — without accounting software.

PLEASE NOTE:

- This is a digital download. No physical item will be shipped.

- Works in Microsoft Excel and Google Sheets (upload to Google Drive to open in Sheets).

- Example data for October 2026 is included (12 services, 20 appointments, 24.75 hours, 3 nail techs, 14 supplies). Replace it with your own numbers.

- The example is simplified: free nail-fix appointments lose 21.00 each in the example because they cost supplies and labor with no charge, and Nail Art Add-On earns the lowest margin per hour of any paid service at 12.00 per hour. Labor cost is entered as a flat amount per service in the example — change it on sheet 1 if your labor cost works differently.

- This is a bookkeeping and planning tool only, not tax, legal, or CPA advice.

- Due to the nature of digital downloads, refunds are not available. Message me before buying if you have a question.

Built by an accountant: B.S. Accountancy, ASU W. P. Carey, with revenue-reconciliation experience at Marriott and audit work at PwC.