Clothing Inventory Spreadsheet: Track Sizes and Colours Without the Mess
Clothing inventory spreadsheet: track each size and colour as a separate row, count what is on hand, and see which sizes move in your boutique.
By Ultimate Inventory Tracker by Cosmo Suite · Editorial policy
Published · 7 min read

A clothing inventory spreadsheet is easier to check when each size and colour you count has its own row. A total for “linen shirt” can look fine while the medium blue shirt is already gone.
For a small boutique, keep one item list for the variants, then record each purchase, sale, transfer, and count correction in a movement log. Review both the overall style and its sizes. That gives you a useful picture without pretending a spreadsheet can see a sale you have not entered.
If you want a ready-made starting point, the Ultimate Inventory Tracker file connects the item list and movement tabs.
In Short
- One row per separately counted size and colour combination.
- Keep a stable item code, even when the display name is descriptive.
- Separate current stock from sales history so you can trace changes.
- Compare size-level sell-through over a fixed period, with one consistent definition.
- If you sell in more than one place, enter or paste each sale yourself.
What belongs in a clothing inventory spreadsheet?
A clothing inventory spreadsheet needs a clear variant list and a record of stock movements. The variant list answers what you have now; the movement log explains why the count changed.
| Record | Fields to keep | What it answers |
|---|---|---|
| Item or variant | Style, size, colour, item code | Which exact version is this? |
| Current stock | Place, on hand, on order, reorder level | What can you sell or expect? |
| Sale entry | Date, item code, quantity, place | What left, and where? |
| Purchase entry | Supplier, date, item code, quantity received | What arrived? |
| Count correction | Date, item code, place, counted amount, reason | What did the shelf show? |
A clothing variant is one combination of a style, colour, and size. If you count small, medium, and large shirts separately, give each its own record. Do the same for navy and rust when you keep their piles apart. The style name can group those rows for a broader view.
Shopify describes a variant as a combination of product options such as size or colour, and supports inventory quantities at the variant level. That is a useful naming model even if you keep your own spreadsheet instead of using Shopify. Shopify’s variant guide explains the product-option structure.
Use a short, stable item code such as LSH-NVY-M. Keep the readable style, colour, and size in their own columns too. The code helps you find the same item in a sales row later. Do not reuse a code when you change the fit or material enough that the stock should be counted separately.
The boutique example: 60 size and colour rows
Imagine a small boutique with 10 styles, three sizes per style, and two colours for each size. That is 60 separately counted variants. The example is illustrative, not a sales benchmark.
| Style | Colour | Size | Opening | Received | Sold | On hand |
|---|---|---|---|---|---|---|
| Linen shirt | Navy | S | 4 | 3 | 2 | 5 |
| Linen shirt | Navy | M | 5 | 2 | 4 | 3 |
| Linen shirt | Navy | L | 3 | 0 | 1 | 2 |
| Linen shirt | Rust | S | 2 | 2 | 1 | 3 |
| Linen shirt | Rust | M | 4 | 0 | 3 | 1 |
| Linen shirt | Rust | L | 3 | 1 | 1 | 3 |
For each row, the simple check is opening stock plus received quantity minus sold quantity. The navy medium row is 5 + 2 - 4 = 3. If the shelf count says 2, check the sale entries, returns, transfers, and last physical count before you change the record.
In this example, rust medium has one left while rust small has three. A style total would show six rust shirts, but would hide which size needs attention.

An item list should not become a second sales log. Keep dated sale rows separately, with one line per item code and place. Then you can review a period without overwriting your opening quantity.
Clothing stock: what to use when
Use the smallest record that answers the decision you need to make. A single item list is fine for a narrow range; add movement rows when you need a history.
| Your situation | Record to use | Check before you rely on it |
|---|---|---|
| Few styles, one storage place | Variant list with counts | Can you spot each size and colour? |
| Frequent sales or restocks | Variant list plus movement log | Does every change have a date and item code? |
| Online orders and a market stall | Quantity by place | Are you entering each sale at the right place? |
| Need size comparisons | Period sales grouped by size | Are the date range and available-stock rule consistent? |
| Counts keep disagreeing | Physical count and correction entry | Did you record the reason instead of hiding the difference? |
For a pivot-table summary in Google Sheets, give every source column a header. Put item size in Rows and sold quantity in Values, then sort or filter the summary as needed. Google’s Docs Editors Help explains how to create a pivot table and customize its rows, values, and filters.
How to compare sell-through by size
Sell-through can help compare sizes over one period, as long as you define the calculation before comparing rows. One simple version is:
Sell-through percentage = units sold ÷ units available × 100
For this comparison, define units available as opening stock plus units received during the period. If a size starts with 5, receives 2, and sells 4, the calculation is 4 of 7, a little over half. Apply the same opening date and received-stock rule to the other sizes.
This percentage describes only the period you measured. It cannot tell you why a size sold, whether a customer wanted an unavailable size, or what to order next. Check the sales window, promotions, display location, and stockouts before acting on it. Sales for a size that was unavailable part of the period may understate interest.
How to set up the rows and keep them useful
Start with the variants you physically count. Add movement logs when you need to explain a change. A short sheet you keep current is easier to check than a long list you stop updating.
- Choose the item boundary. Make one row for each size and colour combination you count separately. Add a fit or fabric only when it changes the item you store and sell.
- Assign an item code. Use a consistent pattern, such as style-colour-size. Keep colour and size in separate columns so you can sort them without decoding the code.
- Count opening stock by place. Record the date and location with the count. If stock is split between a shop, back room, and market box, do not combine it into one unexplained total.
- Log purchases when received. Keep ordered quantity distinct from received quantity. A purchase order is not stock on the shelf yet.
- Log each sale against its variant. Use the same item code and note where the sale happened. When a sale includes two sizes, use two item lines.
- Count and correct with a reason. When the physical count differs from the sheet, record the amount you counted and why you made an adjustment. Leave the earlier movement rows intact.
- Review a fixed period. Compare size sales over a clear date range. Keep the same sell-through definition each time and note when a size was out of stock.

If you want a broader starting layout, this inventory spreadsheet template explains item fields and movement records. A simple list can help with a count, while a tracker needs dated movements when stock changes often. Microsoft’s inventory template gallery is another reference for common spreadsheet layouts.
When should you use software instead?
A spreadsheet is a reasonable fit when you can enter stock changes and check the result against the shelf. If you need sales to reach the stock record without manual entry, choose software with the exact store connection you use.
The Ultimate Inventory Tracker (by Cosmo Suite: one Google Sheets and Excel file, 12 tabs, $9 once) includes Products & Supplies, Sales, Purchases, Adjustments, Transfers, Stock by Place, and a Reorder List. You log or paste each sale yourself. It does not connect to an online shop or a till, and it does not scan barcodes. Cost and profit fields are for your own tracking, not tax figures. See the ready-made inventory file if that manual workflow fits your shop.
If counts are split across places, the overselling guide covers a simple closeout routine and the limits of a sheet when sales happen in more than one channel. A spreadsheet does not prevent an oversell by itself. Someone still needs to record the sale and keep the available quantity current.
How the Ultimate Inventory Tracker handles this
The Ultimate Inventory Tracker has a Products & Supplies list, movement logs, and a Stock by Place view. Give each size and colour its own item row when you count it separately.
The About page explains who publishes this guide. Product details here were checked against the published contents list during editorial review.
The file includes one Google Sheets version and one Excel version with the same 12 connected tabs. Its sample copy shows example data; a clean copy is available too. You can enter your own currency symbol and year start. The Reorder List flags items at or below their reorder level and suggests a quantity toward a target level.
Sales do not import from an online shop or till. You log or paste each one, and the file does not scan barcodes. If that fits your routine, the Ultimate Inventory Tracker file connects the item list and movement tabs.
Frequently asked questions
How do you track clothing inventory in a spreadsheet?
Give each size and colour combination its own item row when you count it separately. Record the starting quantity, then log purchases, sales, transfers, and count corrections. Review totals by style, size, colour, and place.
What columns should a clothing inventory spreadsheet have?
Start with item or style, size, colour, item code, place, quantity on hand, quantity on order, reorder level, and last count date. Keep sales and purchase details in separate movement logs if you need to trace how a quantity changed.
Should each clothing size have its own inventory row?
Yes, when each size has a separate count. Keep the style name the same and give each size and colour combination its own row or item code. That lets you see a missing size without hiding it inside the style total.
How do I calculate clothing sell-through by size?
For a chosen period, divide units sold by units available for that period, then multiply by 100. Define whether available means opening stock plus received stock, and use the same rule for every size. The result is a comparison aid, not a forecast.
Can an inventory spreadsheet update clothing stock from my online shop?
The Ultimate Inventory Tracker does not connect to an online shop or a till, and it does not scan barcodes. You log or paste each sale yourself. Choose software with the required connection if automatic order updates matter to your routine.
When is a spreadsheet not enough for a clothing boutique?
A spreadsheet can fit a shop when someone can keep its entries current and check counts. If you need automatic shop updates, barcode scans, or several people changing stock at once, look for a system that offers those functions.