Beauty Parlour Rate List & Bill Format in Excel (Free) – Salon Bill with Discount & Total in Words

Beauty parlour bill format in Excel with services, discount and total

Advertisement

Quick answer: A beauty parlour bill should show:

  • your parlour’s name, address and phone, a bill number and the date
  • the client’s name and phone
  • each service with its quantity, rate and amount, and who did it
  • any discount, GST if you are registered, and the total in figures and words
  • how the client paid

Download a free beauty parlour bill format in Excel below. Pick services from your own rate list and the prices fill in by themselves. The rate list prints on its own as a menu card for your counter.

Key takeaways

  • Rate list with up to 40 lines under headings like Face & Skin, Waxing, Hair, and Hands, Feet & Make-up.
  • Bill with up to 10 services. Use “Your rate” to give a regular client a special price without changing the list.
  • Discount, optional GST, total in words, payment mode and your UPI ID.
  • “Done by” column for each service, so you know who earned what.
  • Free, with no macros. Print it or save it as PDF for WhatsApp.

↓ Jump to the free download

FOR SALONS & PARLOURSBring back the clients you’re losing.XploreSalon handles bills, prepaid cards, staff commission and birthday & win-back WhatsApp.See XploreSalon — from ₹599 →⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceXploreSalon

Beauty parlour bill format in Excel with services, discount and total
A gold facial, threading, a pedicure at a regular client’s rate and a hair spa: ₹2,710 less ₹150 discount gives ₹2,560.

Beauty parlour rate list

Beauty parlour rate list format in Excel – facial, threading, waxing, hair, make-up
Your rate list with headings. Change any service or price, then print it for the counter.

The sample prices are examples from a mid-range parlour in a Punjab city. Rates vary a lot between towns, and between a home parlour and a branded salon, so type your own. Clients trust a printed rate list more than a price said out loud. It also stops staff charging different clients different prices.

How to use the template

  1. Setup: type your parlour name, tagline, address, phone, UPI ID, GST details if any, bill prefix and thank-you line.
  2. Rate List: type your services and prices. A line with no price becomes a heading.
  3. Bill: type the bill number, date and client. Pick each service from the drop-down list. Enter the discount and how she paid, then print the bill or save it as PDF.

Tips that bring clients back

  • Keep the client’s phone number on every bill. It is the start of your client list for birthday wishes and offers.
  • Sell prepaid cards. For example, pay ₹5,000 and get services worth ₹6,000. You get the money now, and the client keeps coming back to use it.
  • Message clients who haven’t visited for 45 days. A WhatsApp with a small offer usually works better than an ad.
Outgrown the free sheet? Here’s what XploreSalon adds

Free sheetXploreSalon
Appointment book with reminders—✓
Staff commission and monthly profit—✓
Retail product stock—✓
Monthly profit report—✓
Fill-in forms & one-click PDF (macro edition)—✓

⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceGet XploreSalon — from ₹599 →

Download the free Beauty Parlour Rate List & Bill Format

There are three sheets: Bill, Setup and Rate List. Fill in the yellow cells; everything else is worked out.

Get updates and new free templates

Your download below doesn’t need this. Leave your WhatsApp number or email and I’ll send you fixes for this file and new free templates. No spam, unsubscribe anytime.

Was this template useful?

FAQs

Do beauty parlours charge GST?

Beauty and salon services are taxable under GST. A parlour has to register and charge GST only once its turnover crosses the registration limit for services. Check with your CA. If you’re not registered, keep GST at 0% in Setup and leave the GSTIN blank.

Advertisement

Can I use it for a unisex salon or a men’s salon?

Yes. Rename the services and headings on the Rate List. For example, add haircut and beard styling for men.

Can I send the bill on WhatsApp?

Yes. Save the Bill sheet as PDF and send the PDF.

More free templates

Advertisement

Amanpreet Kaur Bharaj
I'm Amanpreet Kaur Bharaj from Hoshiarpur, Punjab. I've worked in Excel for about 12 years, and since 2022 I've run my own ethnic-wear boutique, Punjabi Libas, on Excel files I built myself. XplorExcel is where I share those files: free templates for everyday business work, and ready-made Excel software for shops, boutiques, clinics, dairies, mandis and offices. Every file comes with a filled-in sample so you can see how it works. Stuck with one? Message me and I'll help.