Nail Tech Client Book & Income Tracker | Excel + Google Sheets + Printables

Still scrolling back through DMs to remember what shape she wanted?

Your client's allergies are in your Notes app, her last color is in a text thread, your income is "whatever's in Venmo", and booth rent is due Friday. When someone asks "how's business?" you honestly don't know. You're talented at nails and running the business side on vibes, and the vibes are expensive: a no-show you didn't charge for, a service that quietly loses money per hour, three regulars who drifted off because nobody texted them at week three.

The Nail Tech Client Book & Income Tracker is one Excel / Google Sheets file plus an 18-page printable kit, built for booth renters and home-based techs. Pick the client and service from a dropdown after each appointment; everything else fills itself in.

WHAT'S IN THE SPREADSHEET (13 tabs)✔ Dashboard: this month vs your income target, income by service, top 10 clients by spend, rebooking rate, no-shows, tips, profit after product cost + booth rent, busiest days✔ My Goals: "to take home $___ a month I need ___ sets a week" calculator, plus this month's pace✔ Service Menu: time, price, product cost, profit and profit per hour for every service✔ Client Book (200 clients): phone, IG, birthday, allergies, shape, length, go-to colors; last visit, visits, lifetime spend, days since and no-shows update automatically. "Days since" turns pink at 3 weeks so you know who to text✔ Client Cards: pick one client and get a printable card with her preferences and visit history✔ Appointments (1,000 rows): price fills from your menu; add-ons, tip, deposit, status (Booked / Done / No-show / Cancelled), payment method, rebooked?✔ Deposits & No-shows: no-show rate, revenue lost, deposits kept, a watch list and a deposit log✔ Tips: by month, payment method and weekday✔ Expenses: supplies, booth rent, licensing, education, marketing, tools, with category totals✔ Inventory: polish, gel, acrylic, tips, tools with a reorder flag✔ Content Planner: weekly IG / TikTok plan with status, plus 20 post ideas✔ Monthly Review: the month's numbers plus 8 prompts✔ Start Here: 5-step setup and FAQ. Sample data is loaded so you can see it work, then delete it.

WHAT'S IN THE PRINTABLE KIT (18 pages, US Letter, plus a print-friendly version)Client intake & consent form · client cards (2 per page) · weekly appointment book · daily sales sheet · weekly tip log · service menu & price list template · deposit & no-show policy sheet in plain English (you edit the blanks) · follow-up & rebooking list · monthly income & expense summary · bills & booth rent checklist · inventory checklist · year at a glance · goal page · IG content calendar · aftercare cards for clients (4 per page) · gift certificates (2 per page)

WORKS WITHMicrosoft Excel (desktop or free online) and Google Sheets. All formulas are standard (no add-ons, no macros). Log appointments from your phone with the free Sheets app.

GOOD TO KNOW• Lash, brow, hair or tattoo artist? Rename the services and shapes and it fits.• Digital download, nothing is shipped. Personal use only.• Planning tool, not tax advice.• Trouble opening it? Reply to your receipt email and I'll help personally.• Made with AI assistance and checked by a human.