Boutique inventory with tailoring: fabric, jobs and finished stock

Track fabric received, fabric issued to the tailor, pieces stitched and pieces delivered to the party in one stock ledger. A practical flow for boutiques.

A boutique that stitches as well as sells needs one ledger that follows fabric through four stages: received from the supplier, issued to the tailor, stitched into garments, and delivered to the party. If each stage is entered against the same item and the same job, you can see at any moment how many metres are on the shelf, how many are with the tailor, and which orders are ready. Keep separate notebooks for fabric, tailor and orders and the numbers will not agree with each other.

Why does a boutique with tailoring need a different stock setup?

A plain retail shop buys a finished item and sells the same item. A boutique with tailoring buys one thing, fabric in metres, and sells something else, a garment in pieces. Partway through, the stock leaves your shop and sits with a tailor, sometimes in-house and often outside.

That middle stage is where boutiques lose track. Fabric goes out in a bag with a slip, the tailor sends back pieces over several days, and leftover material comes back weeks later or never. Without a record for each job, the only time you find the gap is at stock-take, when nobody remembers which order used which roll.

What does the fabric-to-delivery flow look like?

Think of every tailoring order as a job that moves stock from one location to the next. The table below shows one illustrative job. The numbers are made up to show the flow, not taken from a real shop.

Stage	Entry	Fabric in shop (m)	Fabric with tailor (m)	Finished pieces in shop	Delivered to party
Fabric in	Purchase of 40 m printed cotton	40	0	0	0
Issued	Job 1: 15 m issued for 6 kurtas	25	15	0	0
Stitched	Tailor returns 6 kurtas and 1.5 m leftover	26.5	0	6	0
Delivered	4 kurtas delivered to the party, 2 kept for the shelf	26.5	0	2	4

Read it row by row. Total fabric never disappears: it is in the shop, with the tailor, or converted into pieces. In this example, 13.5 m went into 6 kurtas, or 2.25 m a piece. That figure is your yield for this design, and it becomes the standard you check the next job against.

How do I set up items so the ledger works?

Three kinds of item, kept apart:

Fabric, counted in metres, one item per fabric and colour. If you buy the same print in two colourways, make two items.
Trims and accessories such as buttons, lace, lining and zips, counted in their natural unit (pieces, metres, packets). Issue these to jobs the same way as fabric.
Finished garments, counted in pieces. Ready-to-wear stock usually needs size and colour variants. Our guide to the apparel size and colour matrix shows how to set that up without hundreds of separate items.

Then add a location for the tailor. Each outside tailor gets their own location, so the ledger shows what is sitting with each one. An in-house tailoring room can be one more location in the shop.

How should a tailoring job be recorded?

Each job, whether it is a party's bridal order or a batch of ten kurtas for the rack, gets one record with:

Job number and party name, or "shop stock" if it is for the shelf.
What goes out: fabric and trims, with quantities, moved from the shop to the tailor's location.
What is expected back: the garment, size and number of pieces, and the promised date.
What actually comes back: pieces received, leftover fabric returned, and any offcuts written off.
Delivery: pieces handed to the party, linked to the sale or invoice.

The job stays open until every metre issued is accounted for, either as pieces, as returned fabric, or as recorded wastage. An open job past its promised date is your follow-up list for the tailor.

How do I check whether the tailor's fabric use is reasonable?

Compare actual use with your standard for that design. In the example above, 2.25 m a piece was the result. If the next batch of the same kurta comes in at 2.6 m a piece with no leftover returned, ask about it. Larger sizes, pattern matching on prints and directional fabrics legitimately use more, so record size and design on the job before you draw conclusions.

The point is not to accuse the tailor. It is to replace a vague feeling that "fabric keeps running short" with a figure per job that both sides can look at.

Checklist: a week of boutique stock that reconciles

Every fabric purchase entered in metres on the day it arrives.
Nothing leaves for the tailor without a job number and an issue entry.
Pieces and leftover fabric entered when they come back, not when someone has time.
Party-supplied fabric recorded on the order but kept out of your own stock.
Finished pieces for the shelf entered with size and colour.
Open jobs reviewed weekly against promised dates.
Monthly count of fabric in the shop and a check with each tailor on what they hold.

Common mistakes

Issuing fabric "on account". Handing over a roll without tying it to a job means you cannot later say which garments it became. Always issue against a job, even a rough one.

Forgetting leftovers. Returned pieces of fabric are stock. If you do not enter them, the system shows less fabric than you have, and you buy again too early.

Counting party fabric as your own. It inflates your stock value and confuses reconciliation. Keep it on the order only.

One item for every shade. A single "cotton print" item with mixed colours makes counts meaningless. Split by fabric and colour.

Closing a job on delivery date alone. A job is closed when the fabric adds up, not when the party collects.

When this does not apply

If you only alter garments that customers bring in and hold no fabric of your own, a simple order register with dates and charges is enough. You have no material stock to trace. Equally, if you buy only ready-made pieces and never stitch, standard retail stock tracking with a size and colour matrix covers you.

This guide covers stock movement only. Tax documents for sending goods to an outside tailor are a separate subject; check the current requirements with your CA.

What should I look for in software for this?

You need metre and piece units on different items, multiple locations including outside parties, issue and receipt against a job, and variants for finished garments. A spreadsheet can hold this for a handful of jobs a month, but it struggles once several tailors and dozens of open orders are involved. Our guide to choosing inventory software in India lists the questions to ask before you commit, and Excel vs inventory software helps you decide when to switch.

FAQ

Should fabric be tracked in metres or in pieces? Track fabric in metres, because that is how you buy it and how the tailor uses it. Track finished garments in pieces. The tailoring job connects the two: it records the metres issued and the pieces expected back. Then you can check yield on every job instead of guessing where the fabric went at stock-take.

How do I handle leftover fabric the tailor returns? Record it as a return against the same job, in metres, and put it back into fabric stock. Pieces too small to sell or reuse go to a separate offcuts or scrap entry. If you leave returns off the ledger, your fabric balance will always look lower than what is on the shelf.

Is a customer's own fabric part of my stock? No. Fabric a party brings in for stitching belongs to them. Record it on the order so you know it is in your shop and with your tailor, but keep it out of your own stock value. Mixing it in inflates your inventory and makes it hard to reconcile what you actually own.