FREE · NO ACCOUNT NEEDED
Boutique Size & Color Stock Matrix
Build a clothing inventory size and color matrix. Compare counted variants with your own stock targets and export a printable boutique stock worksheet.
- 1Set up
- 2Add records
- 3Review & save
Set up your worksheet
Counted stock onlyUse one row per style, color and size. Enter 0 for a counted stockout; omit combinations you have not counted.
Your report
Enter your details and records, then calculate to review the results.
Save or download your work
Work stays in this page until you choose Save on this device. Device saves belong to this browser and can be removed by clearing browser data. JSON keeps an editable backup; CSV and PDF keep a report.
Boutique Size & Color Stock Matrix: complete guide
What you can do
- Actual size columns built from your entered variants.
- Missing entries distinguished from counted zero units.
- Separate replenishment gaps and surpluses by variant.
- Up to 100 editable rows, explicit device saving, JSON backup, CSV and browser PDF printing.
How to use this planner
- Choose a collection and count date.
- Enter one row for every style/color/size combination you want to review.
- Set realistic variant targets from your own records; calculate the matrix and variant gaps.
- Verify missing combinations and supplier pack constraints before preparing a purchase order.
Inputs and units
| Field | Input rule |
|---|---|
| Collection / shop label | Required. Up to 160 characters. |
| Stock count date | Required. Calendar date, 1900–2200. |
| Style / product | Required. Up to 160 characters. |
| Color | Required. Up to 160 characters. |
| Size | Required. Up to 160 characters. |
| On-hand units | Required. Whole numbers from 0 to 1000000. |
| Your target units | Required. Whole numbers from 0 to 1000000. |
How the result works
Each unique style, color and size is one variant. The report groups styles/colors and shows one column per entered size. A dash means no record was entered. Replenishment gaps and surpluses use the target you enter for that variant.
Worked example with fictional data
A navy shirt has 3 small units against a target of 5, so its gap is 2. Medium has 7 against 5, so its surplus is 2. Both remain separate variants; the medium surplus does not cancel the small gap.
Limits to keep in mind
Gap = max(0, target − on-hand units). Surplus = max(0, on-hand − target). Targets are entered by you, not predicted demand. Duplicate style/color/size combinations are rejected to prevent double counting. Missing combinations are not assumed to have zero stock.
Review the result before acting
- Inspect gaps in your best-selling sizes before reviewing the total unit count.
- Check the meaning of size labels so S and Small do not accidentally become separate variants.
- Share the matrix with a buyer alongside your own sales history, supplier packs and budget.
Save, restore and export
Add entry creates another record. Edit any field directly or use Remove entry to delete a row. Changing inputs clears the previous report so it cannot be mistaken for current results. Choose Calculate / review results again when your changes are ready.
Save on this device keeps an editable worksheet in this browser only. On a later visit in this browser, your saved worksheet loads automatically. Restore device save can also reload the last save after you confirm replacement. Saving drafts is allowed, but a report requires valid, complete inputs. Download backup creates a versioned JSON file for the same tool. Import backup shows the worksheet label and row count before replacing current work; it does not change the device save until you press Save.
Download CSV exports the settings, summary, row details and calculation notes. CSV is for spreadsheet review; it cannot restore this worksheet. Print / Save PDF recalculates the current entries and opens your browser’s print dialog. Choose Save as PDF where supported. The report excludes navigation, guides and product CTAs. Clear data removes the current worksheet and its device save after confirmation; keep a backup first if needed.
Use a personal browser for private records and keep important backups separately. Entered worksheet fields are not included in our planner-action analytics.
Frequently asked questions
Does a dash mean out of stock?
No. A dash means that combination has no entered record. Enter a zero-unit row to record a confirmed stockout.
Can I enter the same variant twice?
No. Style, color and size are checked ignoring surrounding spaces and letter case. Combine counts for the same variant before calculating.
Is it free, and can I move my work to another device?
All worksheet features are free without an account. Save on this device keeps data in this browser; use an editable JSON backup to transfer it. CSV and PDF are reports, not import files. There is no cloud sync or background monitoring.
Continue the planning workflow
WHEN YOU NEED A BROADER WORKFLOW
Boutique Business Planner
Review the full boutique workflow for collection and business planning. Read the guide and preview the product to check whether it fits your work. This free planner stays free; its JSON backup does not import into the paid application.