Available

Garment Master Order System

Know what an order really costs, decide whether to take it, and give every department the same instructions. One Excel workbook for small factories and clothing brands.

US$24 · One-time digital download · Excel (.xlsx), imports into Google Sheets

Buy on Gumroad · US$24Try the free MOQ calculator

Gumroad emails your receipt and download links for both Excel files after checkout.

In plain words: what is it for?

When an enquiry arrives you need three answers fast: what does it cost me, what should I charge, and can I afford to start? After that, everyone who works on the order needs the same instructions. This workbook does both in one place. "MO" means master order: the one sheet that holds the cost, the price and the decision for an order.

Problem: you quote a price and find out later you lost money.
Fix: the MO shows the estimated profit and margin before you reply. Check that the quote and all supplier costs are entered before using the verdict.

Problem: a supplier raised a price, so your old quote is wrong.
Fix: change it once in the Price Book. Stale prices are flagged and every MO updates.

Problem: you need to know how much of the materials and trims you must fund after the customer deposit.
Fix: the MO compares that buy list with the deposit.

Problem: every department gets a slightly different brief.
Fix: one Work Order per product, built from the same numbers, with size pack, specs, routing and QC.

Problem: orders slip, and unpaid balances get forgotten.
Fix: the Orders sheet flags what is late, due soon and still to collect.

One order, start to finish

1. An enquiry arrives. 2. Cost it in the MO from your Price Book. 3. Check your inputs, margin and materials cash gap before deciding whether to quote. 4. Accepted? Fill a Work Order and hand it to each department. 5. Buy materials against the Purchasing budget and enter what you really paid. 6. Track the order until delivered and paid, and compare the latest estimate with your plan.

Six sheets, one flow

1. Price Book. Every material, trim and service with pack price, unit price, previous price and a flag when a price has gone stale.

2. MO (master order). Build the cost of each product from the Price Book, set your price, and get COGS per piece, price at target margin, estimated profit, the materials cash gap after the deposit, and the verdict for a completed quote.

3. Work Order. One page per product: spec, size pack checked against the MO quantity, fabric to buy, measurement spec, department routing with late flags, and QC checkpoints.

4. Purchasing. Budget filled from the MO. Enter what you really paid and see projected profit against plan.

5. Orders. Every order in one log with late, due soon and balance still to collect.

6. Guide. What to tell each department, common mistakes, and a weekly price routine.

What you get

Two Excel files: a filled example workbook so you can see every sheet working, and a blank starter workbook for your own orders. Plain formulas, no macros.

Start in Excel or import both files into Google Sheets. Compare the first order with the filled example and read the margin values directly. Sheets import can omit the low-margin highlight in Orders.

Who it is for

Small factories, tailors and clothing brands that quote jobs, buy materials and brief several departments or vendors. If prices change often and quotes live in your head or in scattered files, this puts them in one place.

It is a planning and control sheet. Your results depend on the prices and specs you enter, and every estimate should be confirmed with your suppliers.

Questions

Where can I buy it? Buy the Garment Master Order System on Gumroad for a one-time US$24 payment.

Do I need to know Excel? Start with the filled example. In the starter, enter the quantities and quote price, then check each material, trim and service price before using the result.

Can I change the margins, waste and deposit? Yes, all in the Settings sheet. You can also test a scenario, for example plus 8 percent on materials.

Is it only for T-shirts? No. It works for any cut-and-sew product (bags, jackets, uniforms) because you build the cost lines yourself.

More questions? See Support.

Back to shop · All free tools