Softwiro
Free Excel template

Production tracking sheet for a home textiles factory: free Excel plus weekly report

Track mattresses, sofas, curtains and bedding through cutting, sewing, filling, upholstery and packing, with fabric and filling waste per order.

3 min read

A home textiles factory has two questions every week: where is each order, and how much fabric and filling did we lose? The answers are usually scattered across a supervisor's notebook and a WhatsApp group.

This free Excel sheet gives you one register for the quantity leaving each stage and a dashboard that turns it into a status per order. The sheet and its page are in Arabic: home textiles production sheet. It is built on the garment version, production tracking sheet.

What is inside

  • Stages: cutting, sewing, filling, upholstery, packing (change or extend to 12).
  • Production orders: order, product, customer, quantity, delivery date, fabric type, fabric waste in metres, filling waste in kg.
  • Stage log: each quantity leaving a stage, with its date.
  • Dashboard: per order, quantity at each stage, completion, remaining, days to delivery, status and waste.
  • Weekly report: enter the week start date; it totals each stage for the week, counts running, late and completed orders and the total waste. Printable on A4 landscape.

A worked example from the sheet's sample data

Sample numbers, not a real factory.

  • PO-101, double mattress, 100 pcs: 60 packed, so 60% complete, 40 remaining.
  • PO-102, curtain set, 60: all 60 packed, 100%, status done.
  • PO-103, 6-piece bedspread, 200: all cut and sewn, 120 filled, none packed: 0% by the last stage, but the stage columns show it is well advanced.
  • PO-104, 3-seat sofa, 25: only cut so far, 25 remaining.
  • Waste across the four orders: 115 m of fabric and 27 kg of filling.

Limits

Waste is typed by you per order; the sheet adds it up but does not measure it. For several users with permissions, worker-level scanning and WhatsApp alerts, see our production management system.

Questions this raises

Can I change the stages?

Yes. The five stages are an example; rename them or add up to 12 in the Stages sheet.

How is waste calculated?

You type it per order (fabric cut minus fabric used). The sheet totals it on the dashboard and the weekly report.

Is it free?

Yes, with no sign-up. It works in Excel 2016 and later, Google Sheets and LibreOffice.

Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project