Salon Invoice Template (Free) Excel
A free Excel Salon invoice with auto-calculating totals, tax and discount rows. Fill in the industry fields and the workbook does the math.
Get the free salon Excel invoice
Open the generator, fill in your job details, and export a Excel in seconds. Everything stays in your browser.
Why salons and stylists should bill in Excel
An Excel salon invoice is the working version: totals, tax and discounts calculate themselves, and you keep a running history of every job in one workbook. Formulas add up line items and track what is still unpaid; drop-downs for your usual services keep data entry consistent across months; one workbook per client or per season makes year-end bookkeeping a copy-paste job.
Fields a salon invoice must include
Every job is different, but these salon fields belong on the invoice. Keep them on the template so nothing gets missed:
| Field | What to enter |
|---|---|
| Service breakdown | Cut, color, blowout, treatment — each service listed with its price |
| Stylist level surcharge | Senior / master stylist premium on top of base service price |
| Retail products | Shampoo, styling products sold at retail with tax |
| Package / series discount | Multi-session treatment package discount |
| Extensions / bonding service | Extension application, maintenance or removal fees |
| Tip line | Gratuity — cash or card, not always on the invoice |
| Cancellation policy note | Late-cancel or no-show fee terms printed on the invoice |
Real scenario: a color-and-cut visit with retail product
Salon invoices itemize each service and stylist level, and retail product sales need their own tax handling on the same ticket. Here is a worked example using typical salons and stylists pricing:
| Line | Qty | Rate | Amount |
|---|---|---|---|
| Haircut — senior stylist | 1 | $75 | $75.00 |
| Full color — base + gloss | 1 | $185 | $185.00 |
| Deep conditioning treatment | 1 | $45 | $45.00 |
| Package series discount (4-visit plan) | 1 | -$40 | -$40.00 |
| Retail — styling oil | 1 | $28 | $28.00 |
Subtotal $293.00 plus tax on the retail product line only. The 4-visit treatment package discount is shown as its own line; tip is separate and not included. Net due at checkout.
How to make a salon Excel invoice in 3 steps
Download the workbook
Get the Excel salon invoice with formulas and drop-downs already set up.
Fill the line items
Enter the Service breakdown, Stylist level surcharge, Retail products and more lines — totals, tax and discounts update automatically.
Save or print
Print a PDF copy for the client or keep the workbook as your running history per client.
Salon Excel invoice questions
Should salon invoices show the stylist level?
Yes — senior and master stylists carry a surcharge over base service prices, and the client should see it on the line so there is no surprise at checkout.
How is tax handled on salon services?
It varies by state: some tax services, others tax only retail products. Keep the retail line separate so the right lines are taxable.
Can a package discount appear on a single visit?
Yes. The series discount line applies to the current visit and the remaining visits are tracked on the plan.
Why is the cancellation policy on the invoice?
Printing the late-cancel and no-show terms on the invoice makes them enforceable and reduces chargeback disputes.