AnalystBuilt home Etsy shop

Sewing & Apparel

Fabric & Trims Inventory

Rolls and dye lots, trims, stock reserved per order and a reorder list

Fabric & Trims Inventory: Every roll, every dye lot, every order
Every roll, every dye lot, every order
  • Fabric & Trims Inventory: Every roll, every dye lot, every order
  • Never mix dye lots in one order: Flags an order that will mix lots, or a lot too short to cover it
  • See what is really available: On hand − reserved for open orders = free to use, plus what's on order
  • Every roll and what's left on it: Remnants, aging lots and over-issued rolls, each at its own cost
  • Know exactly what to reorder: Order qty tops up to max stock, rounded to your roll or pack size
  • Reserve fabric by garment count: Type the garments — the style's consumption and waste give the kilos
  • Log every roll as it arrives: Lot ID, dye lot, rolls, cost and rack — late and open orders flagged
  • Issues, returns and write-offs: Link lines to their roll and order — checks catch the slips

from $11.99 on Etsy

Price on Etsy may vary (sales, your currency).

View on Etsy
  • Google Sheets + Excel versions included
  • Instant digital download, nothing is shipped
  • Sample data and a Start Here tab
  • One-time purchase, no subscription

Works in Google Sheets (free Google account) and Microsoft Excel 2016 or newer.

Know which rolls are on the shelf, what is already promised to an order and which dye lot to cut next. This fabric and trims inventory tracks every roll and dye lot in kg, meters or yards, every zip, label and polybag, and warns you before an order gets cut from two dye lots of the same color.

Made for small cut-and-sew and CMT factories that sew batches of tees, hoodies, sweatshirts and joggers for wholesale clients and clothing brands, and for brands that buy their own fabric. Up to 150 items, 300 deliveries and 800 issue lines.

What's inside

  • Start Here

    Settings (fabric unit, aging days, remnant size, lead time, count date) and your lists of units, suppliers and clients

  • Dashboard

    Stock value by type, fabric on hand and reserved, what to reorder, dye-lot warnings, aging lots, materials issued by month and by client

  • Items

    Fabrics with color, composition, GSM and width, plus zips, drawcord, eyelets, elastic, thread, labels and packaging, each with a reorder point and lead time

  • Styles

    Consumption per garment and cutting waste % for each style, so a reservation can work out the kilos for you

  • Receipts

    Each roll or lot as it arrives: lot ID, dye lot, rolls, quantity, unit cost, supplier and rack; open orders show On order or Late

  • Issues

    Fabric and trims issued to cutting or the line for an order, leftovers returned, damage written off, count adjustments

  • Reservations

    What each production order needs, how much is issued, how much is still to issue and whether one dye lot can cover it

  • Stock

    On hand, reserved, available, on order, value and a status for every item, with a suggested order quantity

  • Lots

    What is left on every roll and dye lot, its age and value: Full, In use, Remnant, Aging, Used up

  • Count

    Your stock take by lot or item against the book, with the difference in quantity and money

Why you'll like it

  • Dye-lot aware: flags an order that was cut from two dye lots, an order that no single lot can cover and a requested lot that is too short
  • Reserved vs available: stock promised to open orders is set aside, so the reorder list looks at what is really free
  • Reservations by garments: type the garment count and the style's consumption and waste % give the kilos to reserve
  • Fabric valued roll by roll at what you paid for that lot; trims at their average cost
  • Aging lots and remnants shown with the money tied up in them
  • Over-plan check: see when cutting used more fabric than the plan
  • A fixed "status date" option and sample data for a fictional knitwear factory, so you see every status first
  • Built by a data analyst together with a working cut-and-sew workshop: every number is a formula you can trace

How you get it

  1. Download on Etsy

    Buy the template on Etsy, then download START-HERE.pdf and the Excel .zip from your Purchases.

    How to download

  2. Make a copy

    Click MAKE A COPY in the PDF: your own Google Sheet is saved to your Google Drive. Prefer Excel? Open the .xlsx.

    How to make your copy

  3. Start

    Follow the Start Here tab. Type in the cream cells; the gray cells do the math for you.

    Clearing the sample data

You receive:

  • START-HERE.pdf — Google Sheets link + quick guide
  • fabric-trims-inventory-excel.zip — Excel version

Good to know

  • One fabric unit per file (kg, m or yd); trims can use any unit (pcs, m, cones, boxes).
  • Client-supplied fabric or labels can be tracked at zero cost.
  • It tracks materials, not finished garments or the sewing schedule.
  • Best used on a computer; you can view it in the Google Sheets app on your phone.
  • Using a Mac?
  • For use in one business. Please do not resell or share the files.
  • Listing images show real screenshots of this template with sample data.

Not tax or accounting advice.

Designed by me with the help of AI tools.

View Fabric & Trims Inventory on Etsy

More in Sewing & Apparel