Boutique Bill Format in Excel (Free) – Tailoring Bill with Advance, Balance & Rate List

Boutique bill format in Excel with advance and balance

Advertisement

Quick answer: A boutique or tailoring bill should show:

  • your boutique name, address and phone, a bill number and the date
  • the customer’s name and phone, and the trial and delivery dates
  • each item and add-on (lining, piping, latkan, padding, urgent charge) with quantity, rate and amount
  • discount, GST if you are registered, the total, the advance taken and the balance due at delivery

Download a free boutique bill format in Excel below. Pick items from your own rate list and the rates fill in by themselves. It prints a customer copy and a shop copy on one A4 page, with the total in words.

Key takeaways

  • Rate list of 20 garments and 20 add-ons. Change the rates once and every new bill uses them.
  • Up to 8 lines per bill. Type your own rate for a regular customer without changing the list.
  • Advance and balance are worked out, with the total in words and your UPI ID printed on the bill.
  • A shop copy below the cut line with space for the karigar’s name and the cut and ready dates.
  • A printable stitching rate list for your counter. Free, with no macros.

↓ Jump to the free download

FOR BOUTIQUES & TAILORSNever lose a measurement or miss a delivery.XploreStitch saves measurements, prints order slips, tracks deliveries and karigar dues.See XploreStitch — from ₹499 →⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceXploreStitch

Boutique bill format in Excel with items, advance, balance and customer and shop copy
A designer suit with lining, latkan, a blouse at a regular customer’s rate and an urgent charge: total ₹2,380, advance ₹1,000, balance ₹1,380.

What to write on a tailoring bill

PartWhy it matters
Bill number and dateThe customer brings the bill at trial and delivery, so you find the right order quickly.
Customer name and phoneTo call or WhatsApp when the clothes are ready.
Trial and delivery datesThe promise you made. Write them on every bill, especially before Diwali and the wedding season.
Items and add-ons, each with its own rateLining, piping or an urgent charge written separately avoids arguments at delivery.
Advance and balanceMost boutiques take part of the payment at booking. The bill shows exactly what is still due.
TermsFor example: orders not collected within 30 days are not your responsibility, and the advance is not refundable.

Stitching rate list

Tailor stitching rate list format in Excel for suits, blouses and add-ons
Your rate list: garments on the left, add-ons on the right. Print it for the counter.

The sample rates are only an example. Stitching rates vary a lot between cities and between a simple shop and a designer boutique, so type your own. Keep add-ons such as lining, piping, padding and hand work as separate lines. Customers accept extra charges more easily when they can see each one.

How to use the template

  1. Setup: type your boutique name, tagline, address, phone, UPI ID, GST details if any, the bill prefix and your terms.
  2. Rate List: type your garments and add-ons with your rates.
  3. Bill: type the bill number, date, customer and dates. Pick each item from the drop-down list and enter the quantity. Use Your rate only when you charge a different rate for this customer.
  4. Enter the discount and the advance received, then print the page and cut it in two. Or save it as PDF and send it on WhatsApp.
Outgrown the free sheet? Here’s what XploreStitch adds

Free sheetXploreStitch
Order slips with workshop copy—✓
Balance pending list—✓
Monthly profit report—✓
Item-wise margin—✓
Fill-in forms & one-click PDF (macro edition)—✓

⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceGet XploreStitch — from ₹499 →

Download the free Boutique Bill Format & Stitching Rate List

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 I need to charge GST on stitching?

Only if your boutique is registered under GST. Small tailoring shops below the registration limit are usually not registered. Check with your CA. If you’re not registered, keep GST at 0% in Setup and leave the GSTIN blank.

Advertisement

How much advance should I take?

Many boutiques take 30–50% at booking, and the full amount for fabric they buy for the customer. Write the advance on the bill so the balance is clear at delivery.

Can I keep measurements in this file?

This file is for bills and rates. For a free measurement card, see the Tailor Order Book & Measurement Chart.

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.