Last updated:
Quick answer
Have the AI build a weekly pay sheet: hours, hourly rate, service sales, service commission rate, retail sales and retail commission rate, with formulas. Paste in the week's numbers from your booking system, check two stylists by hand, and send the totals to your payroll provider. Ask your accountant how commissions affect overtime.
Free PDF
Get this setup as a PDF
Confirm your email and we'll open a print-ready copy of this setup you can save as a PDF. You also get the free starter pack and one setup a week. Unsubscribe anytime.
Already a subscriber? Unlock it on this device
At a glance
All outcome figures are estimates from cited sources, not independent verification by us.
- What it is allowed to do
- Adds sheet rows
Adds rows to your own Google Sheet.
- Time saved (estimate)
- About 30 to 60 minutes a week.
- Difficulty
- Beginner
- Tools needed
- ChatGPT, Claude, Excel or Google Sheets
- Typical cost
- Prices: Not stated in sources.
Reviewed Nov 2, 2026
Basis (estimate): Estimate only: based on the steps above, not timed.
What does this setup do?
Build a weekly salon pay sheet for hourly plus service and retail commission, with formulas, so the pay run is quick and the numbers are checkable.
Who is it for?
Salon and barbershop owners who work out hourly-plus-commission pay by hand every week.
How do you set it up?
Tools
- ChatGPT or Claude
- Excel or Google Sheets
- Your booking system's weekly sales and hours report
Steps
- Write down each pay rule: hourly rate, service commission %, retail commission %, and any minimum or tier.
- Use the prompt below to build the sheet. Anthropic says Claude can create Excel files with working formulas.
- Each week, paste hours and sales from your booking system report.
- Check two people's pay by hand before sending anything.
- Overtime: the Department of Labor says overtime is paid on the regular rate, and its releases say earned commissions can count toward it. Confirm your setup with your accountant or payroll provider.
- Send the totals to your payroll provider. Booth renters are not on payroll; handle their 1099s separately.
Example output
Illustrative. Your results will differ.
- J.M.: 32 hrs x $15 = $480 + 40% of $1,850 services = $740 + 10% of $220 retail = $22; total $1,242
- Flag: A.R. 42 hours, check overtime with your payroll provider
Where to paste this prompt
ChatGPT → Project instructions, or ChatGPT Tasks for scheduled reminders (once a day on Free)
Copy-paste prompt
Adapt bracketed fields to your situation.
Build a weekly pay sheet (Excel) for my salon. Use only my rules.
Pay rules per person: [NAME OR INITIALS: hourly rate, service commission %, retail commission %, any tiers]
Columns: Person | Hours | Hourly pay | Service sales | Service commission | Retail sales | Retail commission | Total before taxes
Add a row of totals and a note column. Show the formula for each column in one line. Leave rows empty for me to fill. Do not calculate taxes or overtime; flag anyone over 40 hours for me to check.Newsletter
Get the free starter pack
Free starter pack with five beginner copy-paste prompts after you confirm, plus one researched setup in your inbox each week. Unsubscribe anytime.
What usually goes wrong?
Where agents tend to stall on this job. More patterns in Where AI gets stuck.
- Including tips in commission sales by mistake.
- Forgetting retail returns.
- Treating booth renters like employees.
Which chat tools work with this prompt?
Paste the prompt into any of these assistants (free or paid tiers).
- ChatGPT
- Claude
Common questions
- How do I calculate hourly plus commission pay?
- Hours times rate, plus service sales times the service rate, plus retail sales times the retail rate. A sheet with formulas does it each week.
- Do commissions affect overtime?
- The Department of Labor says overtime is based on the regular rate, which can include earned commissions. Check with your accountant.
- Can AI run payroll?
- Use it to build and check the numbers. Your payroll provider handles taxes and payment.
What tips make it smoother?
- Pull sales from the same report every week.
- Write tier rules out in full; vague rules make wrong formulas.
- Keep the sheet; it explains every paycheck if someone asks.
Where do the claims come from?
Summaries use public sources linked below, not independent verification. How setups are picked.
- Read Anthropic’s write-up (support.claude.com)
Anthropic: Create and edit files with Claude: Excel spreadsheets with working formulas; upload CSV and other files for analysis (read 2026-11-02 from a search result excerpt of the page)
- Read U.S. Department of Labor, Wage and Hour Division’s write-up (www.dol.gov)
U.S. Department of Labor, Wage and Hour Division: Fact Sheet #23, Overtime Pay Requirements of the FLSA: overtime is paid at 1.5 times the regular rate; a DOL release says the regular rate can include earned bonuses or commissions (read 2026-11-02 from a search result summary of the page)
Related setups
- Set Up Contractor W-9s and 1099s Without the Scramble
Build a simple W-9 collection routine and a year-end 1099 filing checklist so January is calm.
- Connect ChatGPT to QuickBooks
Connect QuickBooks Online to ChatGPT with Intuit's app, ask questions about invoices and spending, and review suggested categories before changing anything.