What the Aesthetic Freelancing Worksheet Actually Does for You
The spreadsheet I use every week to track sessions, supplies, client history, and income isn't fancy. It's a set of tabs in Google Sheets that I built because my first year doing freelance aesthetics — lashes, lips, brow lamination — I was losing money on products I couldn't track and clients whose history I had to guess at. Most people who ask me about the Aesthetic Freelancing Worksheet want to know if it replaces booking software. It doesn't. It complements it. Here is how it works in practice. My booking platform handles appointments and payments. The worksheet handles everything else: which products went to which client, what their skin history shows, when they last had a treatment, what contraindications they have, and how much each service actually cost me in materials. That last part is the one most freelancers miss until they are looking at a bank account that says "I should be richer than this."
Building Your Aesthetic Freelancing Worksheet
I started with five sheets. That number has stayed the same for three years even though I added more services. Here is what each one does: Sheet 1: Client Intake & History — Every client gets a row. Columns include name, contact, date of birth, consultation date, medical history checkboxes (pregnancy, retinoid use, keloid scarring, diabetes, recent Botox/fillers, eye infections), product allergies, desired outcomes, and my notes section. I used to put all of this in a notebook. I lost a client's allergy history once because I wrote it down but never logged it digitally. She had an contact lens reaction during a lash lift because I didn't cross-reference her previous reaction notes. That was the moment I built this sheet. Sheet 2: Service Menu & Pricing — Service name, duration, base price, material cost per session, and profit margin calculated automatically. I keep separate rows for add-ons so I can see which ones are actually worth doing. When I started, I was doing lash fills and adding tint for free because "it feels nice to offer." The worksheet showed me I was losing $4.50 per session on that add-on after product costs. I stopped offering it free within a week.
Sheet 3: Supply Inventory — Product name, SKU, quantity purchased, cost per unit, current stock, reorder threshold, and date of last reorder. I set reorder thresholds based on how many sessions a bottle lasts me. For lash glue, that is roughly 40 sessions. For lip pigment, 25. The sheet alerts me when I hit the threshold so I am not mid-session realizing I am out of adhesive. Nothing ruins a booking faster than that. Sheet 4: Session Log — Date, client name, service performed, duration, materials used (linked back to the supply sheet with a dropdown so I don't have to type product names), tips received, and any complications or follow-up notes. This is the sheet I update after every single appointment. If I do not update it immediately after the session, I stop updating it for the whole month. Trust me on this one. Sheet 5: Monthly Financial Summary — Pulls data from the session log and supply inventory to calculate gross revenue, material costs, net profit per service, and profit per hour. I added a column for "no-show loss" which tracks how much revenue I lost to cancellations. This has been humbling.
Get the Full Details
The whole thing took me about six hours to set up. After that, daily updates take maybe twelve minutes. My monthly review takes about twenty minutes on the first Saturday of each month.
Where to Get the Aesthetic Freelancing Worksheet
I have a shareable Google Sheets template that mirrors the five-sheet structure above. You can copy it and customize the columns for your specific services. The link is in the resources section below. If you already use a booking platform like Fresha, Vagaro, or Square Appointments, you can export your client and session data to CSV and import it into the worksheet. That saves you about forty hours of manual entry if you have been operating for more than six months without a system. I did that transition last year and spent one Saturday connected to two monitors and a lot of coffee.
Common Mistakes People Make With This Worksheet
The biggest one is treating it like a tax document instead of an operational tool. People set it up, fill it out once, and then forget about it until tax season. The value is in the real-time data. Your supply reorder thresholds need to adjust when you switch to a new brand or a new supplier changes bottle sizes. Your service pricing needs to be revised when material costs go up — which they have this year across almost every aesthetic supply category. I adjusted my lash extension pricing by eight percent after reviewing the supply sheet and seeing adhesive costs climb thirty-two percent in nine months. Another mistake is over-complicating the dropdown menus. I spent two hours once creating nested dropdowns for product sub-types. I use the sheet daily. I deleted the nesting the next day. Simple is better than thorough when you are the one filling it out after a long day of appointments.
What This Worksheet Cannot Do
It will not replace a booking platform. It will not send reminder texts. It will not process payments. It will not handle insurance or liability documentation. It is purely a tracking and analysis tool. If you need something that does all of the above, look at platforms like MindBody or Acuity Scheduling with their built-in reporting. But those platforms charge monthly fees that scale with your client count, and their reporting is shallow compared to what you can build here. There is also a limit to what you can automate in Google Sheets without moving to a more advanced tool. If you are doing more than fifteen sessions per week across multiple service types, the manual entry becomes a bottleneck. At that point, I would recommend migrating to a dedicated small business ERP like Zoho Inventory or even a custom Airtable base that syncs with your booking platform via Zapier. I am still at under fifteen sessions per week so I have not made that move yet, and I have no immediate plan to. One more blunt note: if you struggle with consistency in daily data entry, this worksheet will not fix that habit. I have seen people build beautiful spreadsheets and then abandon them after three weeks because updating the session log felt like homework. The solution to that is not a better spreadsheet. It is either simplifying the process until it takes under five minutes per entry, or hiring a virtual assistant for fifteen dollars an hour to handle the data entry. I considered the VA route when I was first starting out but could not justify the cost relative to my revenue. Now the revenue justifies it, but the habit of updating the sheet myself is too established to hand off.
Download: Aesthetic Freelancing Worksheet Template
The template I reference throughout this article is available here: [Insert your download link to the Aesthetic Freelancing Worksheet Google Sheets template]. It comes pre-formatted with the five sheets described above, formulas for cost calculations and profit margins, and dropdown lists for common aesthetic services and products. You will need to fill in your own pricing and supply data. I also included a instructions tab with screenshots for anyone who is not comfortable with Google Sheets formulas.
