Production tracker template: what a fashion brand should track

A production tracker answers one question early: which samples and orders are late before the factory tells you? This page lists what to put in the template, shows the date logic behind the flags, and walks through one worked example with invented dates.

What a production tracker template needs

Most small brands start with one long sheet where samples, orders and deadlines share the same rows. It works for a handful of styles and falls apart at the first revision. Four separate logs are easier to keep honest.

1. Sample log. One row per sample round, not per style, because a style can go through several rounds. Typical rounds are proto, fit, sales sample, pre-production and top of production. Columns: style, round, date sent, date due, date received, outcome (approved, comments, rejected), and days open.

2. Purchase order log. One row per order with milestone dates: materials in, production started, packed, shipped. Add the ex-factory date and the in-store date you promised your customer.

3. Time and action calendar. A list of milestones counted back from the in-store date. It tells you when each step must happen for the date to hold.

4. Vendor list. Factory, contact, and your own score on a few criteria such as communication and sample quality. It is a judgement tool, so keep it simple and date your scores.

The date logic behind the flags

A flag is a comparison of two dates, nothing more.

• Days open = today's date minus date sent, while the sample is still out.
• Late = the sample has not come back and today's date is past the due date.
• Waiting = not back yet, but still inside the due date.
• Done = received.

Use one "status date" cell that you set to today and let every formula read from it. That also lets you check how the plan looked on any past date.

Worked example (invented dates)

These dates and lead times are made up to show the arithmetic. They are not industry standards, and your factories will have their own.

Sample flag. A fit sample was sent on 2 Nov 2026 and is due back on 16 Nov 2026. The status date is 20 Nov 2026. Days open = 18. The due date passed 4 days ago and nothing has arrived, so the flag reads LATE.

Time and action calendar. The in-store date is 1 Mar 2027. Count back with these example lead times:

1. In-store 1 Mar 2027, minus 21 days for transit and receiving gives an ex-factory date of 8 Feb 2027.
2. Minus 35 days for production and packing gives a production start of 4 Jan 2027.
3. Minus 14 days for materials to arrive gives a materials-in date of 21 Dec 2026.
4. Minus 10 days for pre-production sample approval gives a deadline of 11 Dec 2026.

So the pre-production sample has to be approved by 11 Dec 2026. If it is still out on that date, every later date moves, and you now know it weeks before the shipment would have been missed.

Common mistakes

• Tracking styles instead of sample rounds. You lose the history of what was sent and when.
• Typing dates as text. Formulas cannot subtract them. Use real date cells.
• Copying lead times from the internet. Ask your factory and write down the date you asked.
• No one owns the status date. If it is not updated, every flag is stale.
• Mixing costs into the tracker. Keep timing here and prices in a separate costing sheet.

Build it yourself or use a ready template

Everything above works in a plain spreadsheet, and the free route is a perfectly good way to start. A ready template saves the setup time.

The Fashion Production & Sample Tracker is an Excel workbook with eight tabs: Start Here, Setup, Style Master, Sample Tracker, PO Tracker, T&A Calendar, Vendor Scorecard and a Dashboard. It holds up to 100 sample rounds, 60 orders, 40 styles and 10 vendors, flags samples as LATE, WAITING or DONE, and gives each order a risk flag. It opens with clearly marked example data that you clear before real use, and the default lead times are placeholders you replace with your own. It does not do costing, spec sheets or size-run buying, and Google Sheets is not officially supported. It is a paid product and a planning aid only.

See the Fashion Production & Sample Tracker Fashion Brand Bundle on Etsy

Frequently asked questions

What should a production tracker template contain?

At minimum a sample log, a purchase order log with milestone dates, a calendar that counts back from your in-store date, and a vendor list. Each one needs dates and a status that flags what is late.

How do I know a sample is late?

Compare the due date with today's date. If the sample has not been received and the due date has passed, flag it late and count the days open.

Can I build a production tracker in Google Sheets or Excel?

Yes. Every formula on this page works in a plain spreadsheet. The Fashion Production & Sample Tracker is made for Excel and LibreOffice, and Google Sheets is not officially supported.

Are the dates in the example real?

No. The dates and lead times are invented to show the arithmetic. Use your own factories' figures.