# Calculate salon commission pay with AI

> Researched. Small business · Beginner · Invoicing & money. Updated 2026-11-02.

Canonical page: https://www.aisetupsthatwork.com/setups/calculate-salon-commission-pay-with-ai/

## What it does
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 it's for
Salon and barbershop owners who work out hourly-plus-commission pay by hand every week.

## Tools
- ChatGPT or Claude
- Excel or Google Sheets
- Your booking system's weekly sales and hours report

## Steps
1. Write down each pay rule: hourly rate, service commission %, retail commission %, and any minimum or tier.
2. Use the prompt below to build the sheet. Anthropic says Claude can create Excel files with working formulas.
3. Each week, paste hours and sales from your booking system report.
4. Check two people's pay by hand before sending anything.
5. 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.
6. Send the totals to your payroll provider. Booth renters are not on payroll; handle their 1099s separately.

## Copy-paste prompt
Adapt bracketed fields to your situation.
```text
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.
```

## Guardrails
- What it touches: Chat input you provide (ChatGPT or Claude; Excel or Google Sheets).
- Needs your OK: Send, pay, publish, and account changes stay with you. Treat agent output as drafts first.
- Safety level: Adds sheet rows
- Including tips in commission sales by mistake.
- Forgetting retail returns.
- Treating booth renters like employees.

## Tips
- 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.

## Estimates (labeled, not measured)
- Time saved: About 30 to 60 minutes a week.
- Money saved: Not stated in sources.
- Tool cost: Prices: Not stated in sources.

## Sources
Summaries use the public sources below, not independent verification.
- Anthropic: https://support.claude.com/en/articles/12111783-create-and-edit-files-with-claude (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))
- U.S. Department of Labor, Wage and Hour Division: https://www.dol.gov/whd/regs/compliance/whdfs23.htm (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))

## Get the free starter pack
Five beginner copy-paste AI setups, free by email: https://www.aisetupsthatwork.com/starter-pack/?utm_source=ai-agent&utm_medium=markdown&utm_campaign=setup-calculate-salon-commission-pay-with-ai

Related:
- [Set Up Contractor W-9s and 1099s Without the Scramble](https://www.aisetupsthatwork.com/setups/contractor-w-9-and-1099-setup/index.md)
- [Connect ChatGPT to QuickBooks](https://www.aisetupsthatwork.com/setups/connect-chatgpt-to-quickbooks/index.md)