# Clothing Store Inventory Spreadsheet Excel (Free)

> Free Excel inventory sheet for a clothing store: one SKU per color and size, markup and margin, sell-through by style and season, weeks of cover and markdowns.

Source: https://softwiro.com/templates/clothing-store-inventory-tracker
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Clothing Store Inventory Spreadsheet (Size and Color) for Excel

A free Excel inventory spreadsheet built for a boutique or small clothing shop. A jacket is not one item: it is a style that comes in colors and sizes, and what hurts you is the size M that sold out while the XL sits on the rail. You list each style once with its cost and price, add one SKU for every color and size, and log receipts, sales, returns and counts in a single movement log. The sheet then shows what is on hand by size, how much of each style and season has sold, how many weeks of cover are left, what to reorder, what is overstocked, how far you have marked things down and what your stock is worth at cost and at retail. It opens in Excel, LibreOffice and Google Sheets and works in any currency.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-clothing-store-inventory-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-clothing-store-inventory-tracker-blank.xlsx)

Excel file (.xlsx) · 457 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| Stock as of | 46346 | Dates, currency and the rules behind the statuses are on the Settings sheet. |  |  |
| --- | --- | --- | --- | --- |
|  |  |  |  |  |
| Styles | 8 |  | Overall sell-through % | 41.2% |
| SKUs (colour and size) | 38 |  | Average weeks of cover | 8.7 |
| Units on hand | 206 |  | SKUs low or out of stock | 11 |
| Stock value at cost | 5,046.00 |  | SKUs overstocked or not selling | 15 |
| Stock value at retail | 12,815.00 |  | Styles on markdown | 3 |
| Margin still in stock (retail - cost) | 7,769.00 |  | Retail value given up on stock in markdowns | 1,471.00 |
| Net sales (sales less returns) | 14,844.00 |  |  |  |
| Month | Units sold | Net sales |  |  |
| Jan | 0 | 0.00 |  |  |
| Feb | 0 | 0.00 |  |  |
| Mar | 0 | 0.00 |  |  |
| Apr | 0 | 0.00 |  |  |
| May | 0 | 0.00 |  |  |
| Jun | 0 | 0.00 |  |  |
| Jul | 0 | 0.00 |  |  |
| Aug | 0 | 0.00 |  |  |
| Sep | 0 | 0.00 |  |  |
| Oct | 76 | 7,600.00 |  |  |
| Nov | 72 | 7,244.00 |  |  |
| Dec | 0 | 0.00 |  |  |

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

## What is inside

- Dashboard: Styles, SKUs, units on hand, stock value at cost and at retail, the margin still sitting in stock, net sales, overall sell-through, average weeks of cover, counts of low and overstocked SKUs, markdown cost, and four charts: sell-through by season, stock value by category (cost against retail), units on hand and sold by size, and net sales by month.
- Styles: One row per style (100 rows): code, name, category, season, vendor, unit cost, original price and an optional markdown price. It works out the selling price now, markup, margin, markdown percent, opening, received, sold, on hand, sell-through %, weeks of cover, stock at cost and retail, net sales, gross margin and a suggested action: Strong seller, Consider markdown, On markdown or Sold out.
- SKUs: One row per color and size (400 rows): SKU, style, color, size from your size scale, reorder point and opening on hand. It adds received, sold, returned, adjustments, on hand, unit cost, selling price, stock value, units sold in the sales window, weeks of cover, sell-through % and a status of OK, Low, Out of stock, Overstock or No sales, with a Check column for duplicate SKUs and unknown styles or sizes.
- Movements: The single log (3,000 rows): date, SKU, type (Receipt, Sale, Return or Adjustment), quantity, price charged, reference and note. It shows the style, the stock change and the sales amount, and flags unknown SKUs and missing types, quantities or prices.
- Sell-through: Sell-through, stock value, net sales and gross margin by season and by category, plus a size table showing units in, sold, on hand and each size's share of sales.
- Low stock: Every SKU at or below its reorder point or out of stock (first 60), with vendor, weeks of cover, an order quantity that brings it back up to your chosen multiple of the reorder point, and the order cost.
- Overstock: SKUs with more weeks of cover than your limit, and SKUs with stock but no sales in the sales window, with the cash tied up at cost and at retail. These are your markdown and stop-reordering candidates.
- Settings: Business name, currency symbol, as-of date, sales window in weeks, overstock limit, order-up-to multiple, markdown review and strong-seller thresholds, the year shown on the Dashboard, and your lists: size scale (XS to XL, editable), seasons, categories and vendors.

The file opens on a start tab (“Start here”) that explains how to use it.

## What makes it different

Generic inventory sheets track one quantity per item, so a style that has sold out in the middle sizes still looks healthy. This one keeps stock at the color and size level, rolls it up to style, season, category and size, and uses retail measures a buyer actually reads: markup, margin, sell-through, weeks of cover and markdown cost. The sample is a small boutique with 8 styles, 38 SKUs and 150 movements in October and November 2026.

## How do I track clothing inventory by size and color in Excel?

Give every color and size its own SKU, built from style, color and size, for example JK100-OLV-M for the olive jacket in medium. Keep the style code, color and size in separate columns so the sheet can add them up either way. On the SKUs sheet you type those three, the reorder point and the units you hold now; the movement log does the rest.

Log each receipt, sale, return and count on the Movements sheet. On hand is opening plus received minus sold plus returned plus adjustments. In the sample, the olive field jacket in medium started with 3, received 5 and sold 8, so it shows 0 and a status of Out of stock, while the large has 1 left and shows Low. Rolled up on the Sell-through sheet, the sample's sizes S, M and L carry most of the sales, while XS has sold 5 of 42 units and sits at 11.9%.

## How do I calculate sell-through rate and weeks of cover?

Sell-through % here is units sold, net of returns, divided by the units you started with plus the units you received. The sample as a whole has sold 145 of 352 units, 41.2%. By style it ranges from 82.1% for the waxed field jacket to 11.4% for the crew tee, and by season from 57.9% for Fall 2026 to 11.4% for Spring 2026. A season that is nearly over and still low is the signal to mark down or stop reordering.

Weeks of cover is the stock on hand divided by the average weekly sales over a window you set on Settings (4 weeks in the sample). The sample's stock covers 8.7 weeks on average, but the crew tee in extra small has 52 weeks of cover. The [reorder point calculator](https://softwiro.com/tools/reorder-point-calculator) helps you choose the reorder point for each SKU.

## How do I work out markup and margin, and track markdowns?

Markup is the profit as a percent of cost and margin is the profit as a percent of the retail price. The waxed field jacket costs 62.00 and sells for 148.00, a markup of 138.7% and a margin of 58.1%. Type a lower price under Markdown price and the sheet uses it as the selling price, shows the percent off, the margin you now earn, and the retail value you gave up on the stock still on hand. The linen wrap dress, marked down from 96.00 to 59.00, is 38.5% off and costs 851.00 in retail value on its 23 remaining units; across all marked-down styles the sample gives up 1,471.00.

Stock value is shown at cost, which is what you have paid, and at retail, which is what the shelves could bring in at today's prices: 5,046.00 and 12,815.00 in the sample. The sheet values stock at your current unit cost, not by FIFO or average cost, so ask your accountant what your reports need. To check the shelves against the sheet, count a few items and log the difference as an Adjustment, or use the [stock count reconciliation sheet](https://softwiro.com/templates/stock-count-reconciliation) for a full count.

## How to use it

1. On Settings type your business name, currency symbol, the as-of date and the rules (sales window in weeks, overstock weeks, order-up-to multiple). Edit the size scale, seasons, categories and vendors lists.
2. On Styles add one row per style: code, name, category, season, vendor, unit cost and original retail price. When you mark a style down, type the new price under Markdown price.
3. On SKUs add one row per colour and size of each style: a SKU code, the style code, colour, size, the reorder point and the units you hold now (Opening on hand).
4. On Movements log every change: date, SKU, type (Receipt, Sale, Return or Adjustment), quantity and, for sales and returns, the price charged. An adjustment is signed: -1 removes a unit.
5. SKUs works out on hand, weeks of cover, sell-through and a status for every colour and size. Styles shows markup, margin, sell-through and a suggested action for every style.
6. Open Low stock and Overstock for the two buying and markdown lists, Sell-through for season, category and size tables, and Dashboard for the totals and charts.

**Before you start:**

- Capacity: 100 styles, 400 SKUs, 3,000 movements, 8 sizes, 6 seasons, 10 categories and 20 vendors. Low stock and Overstock show the first 60 lines each.
- Opening on hand is what you hold when you start. Do not log that stock again as a Receipt.
- Sell-through % = units sold (net of returns) / (opening on hand + received). Weeks of cover = on hand / average weekly sales over the sales window.
- Stock value uses the unit cost on Styles; retail value uses the current selling price (the markdown price when there is one). Update the cost when your vendor price changes.
- A SKU with stock but no sales in the window is listed as No sales on the Overstock sheet; a brand new delivery will show there until it sells.
- Use one currency in one workbook. The currency symbol on Settings is only a label.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-clothing-store-inventory-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-clothing-store-inventory-tracker-blank.xlsx)

Excel file (.xlsx) · 457 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Still running this on Excel?

This sheet needs someone to type in every transaction. Accsys deducts the quantity at every sale and works across all the shop's devices at once, even without internet.

| In this sheet | In Accsys |
| --- | --- |
| You type in every sale and every purchase by hand. | Each color and size combination has its own barcode, which is deducted from stock at the sale and returned to stock on a return. |
| The e-invoice for the tax authority lives in a different system. | It issues e-invoices compatible with the Egyptian Tax Authority's ETA system, and sends the invoice on WhatsApp with a payment link. |
| The sheet sits on one device, and whoever edits it last wins. | It works offline, then syncs data across all the shop's devices when the connection returns. |
| Total sales doesn't tell you how much you earned. | A tiered income statement from revenue down to net profit, plus profit and margin for each item. |

[See Accsys](https://softwiro.com/product/accsys) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| You type every sale and receipt | Sales come straight from the till and receipts from the vendor delivery |
| One file on one computer | Live stock across every till and branch |
| Reorder list you read and act on | Purchase orders prepared from the low-stock list |
| Sell-through in a chart you refresh | Season and size reports updating as you sell |
| Markdowns changed by hand | Price changes and promotions applied at the register |

### Extra features in the app

- Scan the barcode of each color and size at the till so a sale takes that exact unit out of stock
- A return puts the unit back into stock automatically, in the right size
- Stock kept in step across several tills or shops, working even when the internet drops
- Profit and margin for each item shown without building any formulas
- Invoices sent to the customer by message, with a payment link
- Everyone on the team using the same live stock, with no file to email around

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### Is this clothing store inventory spreadsheet really free?

Yes. Download it, use it in your shop and change anything you like. There is nothing to sign up for to open the file.

### Can I change the sizes, for example to numeric sizes or plus sizes?

Yes. The size scale on Settings holds up to 8 sizes and the sample uses XS to XL. Replace them with 6, 8, 10, 12 or 1X, 2X and the SKUs dropdown, the size table and the size chart follow.

### Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets.

### How many styles, SKUs and movements can it hold?

100 styles, 400 SKUs (colors and sizes) and 3,000 movements, with 8 sizes, 6 seasons, 10 categories and 20 vendors. The Low stock and Overstock sheets list the first 60 lines each. When the log fills up, save a copy, type each SKU's current on hand as its opening on hand and clear the Movements sheet.

### How do I record a return or an exchange?

Log a Return with the quantity and the price you refunded; it puts the unit back on the shelf and takes the amount out of net sales. For an exchange, log the Return of the first size and a Sale of the new one. Use an Adjustment, typed with a minus sign, for loss, damage or a count that comes out short.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

More free templates for: Shops and stores

## More free templates

- Cash Book Template for Excel
- Invoice Template with Invoice Log (Excel)
- Multi-Location Inventory Spreadsheet for Excel
- Customer accounts, credit sales and customer statement sheet
- Cash book and customer accounts sheet
- Installments and collection tracker
- General shop inventory tracker (stock in/out, reorder, slow movers)
- Supplier purchase orders and payables tracker
- Periodic stock count and count-difference reconciliation sheet
- Barcode, batch and expiry inventory sheet
- Grocery store management sheet
- Stationery shop and photocopy management sheet
- Electronics shop sheet: serials, warranty and repairs
- Wholesale clothing trade sheet: traders, stock and collection
- Food wholesale and distribution sheet in Excel: routes, expiry and collection
- Quran Hifz Tracker Template for Excel (Sabaq, Sabqi, Manzil)
- Rotating Savings Club Tracker for Excel (Susu, Tanda, ROSCA)
- College Application Tracker Spreadsheet for Excel (Deadlines, Checklist, Aid)
- Weighted Grade Calculator for Excel (Gradebook with Categories)
- Breakeven ROAS Calculator for Excel
- Small Business Budget Template for Excel (Monthly)
- Annual Department Budget Template for Excel (Budget vs Actual)
- Construction Project Tracker for Excel

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
