Softwiro
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.

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

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
Stock as of46346Dates, currency and the rules behind the statuses are on the Settings sheet.
Styles8Overall sell-through %41.2%
SKUs (colour and size)38Average weeks of cover8.7
Units on hand206SKUs low or out of stock11
Stock value at cost5,046.00SKUs overstocked or not selling15
Stock value at retail12,815.00Styles on markdown3
Margin still in stock (retail - cost)7,769.00Retail value given up on stock in markdowns1,471.00
Net sales (sales less returns)14,844.00
MonthUnits soldNet sales
Jan00.00
Feb00.00
Mar00.00
Apr00.00
May00.00
Jun00.00
Jul00.00
Aug00.00
Sep00.00
Oct767,600.00
Nov727,244.00
Dec00.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 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 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.

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 sheetIn 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 · Ask for a demo

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, 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

More free templates for: Shops and stores

More free templates

All templates · Free tools