Clothing Inventory Spreadsheet Template: Setup & Tips

How-to basics · Updated November 21, 2026

A clothing inventory spreadsheet template should track each sellable variation—such as a particular shirt in size M and black—not just the general product. In Excel for Microsoft 365 on Windows, set up columns for SKU, item, size, color, quantity, reorder point, cost, and location, then use simple formulas to flag low stock and calculate inventory value.

What a clothing inventory spreadsheet tracks

Clothing stock is more complicated than a list of product names because one style can have many variations. A store might sell a crew-neck T-shirt in five sizes and four colors, making 20 distinct options to count. If those options share one row, the spreadsheet cannot reliably show which size or color is running low.

The basic record should therefore represent one specific stock-keeping unit (SKU): one product in one size and one color. The same T-shirt can have separate rows for a black medium and a black large. Each row needs its own quantity and, ideally, a unique SKU. A spreadsheet can help you see stock, plan replenishment, and investigate discrepancies, but it does not physically count garments or automatically know about sales unless you connect it to another system.

Template columns to include

Start with one header row and add a row for every sellable variant. These columns cover the needs of a small shop without requiring specialized inventory software:

  • SKU: A unique, consistent identifier for the variant, such as TEE-CRW-BLK-M.
  • Item name: A readable product name, such as Classic Crew T-Shirt.
  • Category: A broad group such as tops, denim, dresses, or accessories.
  • Size and color: Record each in its own column; use consistent labels such as M rather than mixing M, Medium, and Med.
  • Supplier: The vendor or maker associated with the item.
  • Storage location: A useful shelf, rack, bin, or back-room location.
  • Quantity on hand: The number of sellable units physically available at the latest count.
  • Reorder point: The quantity at which you want to review or replenish the variant.
  • Unit cost and retail price: Keep purchase cost distinct from selling price.
  • Date received and last counted: These dates help with receiving checks and count follow-up.
  • Status and stock value: Optional calculated fields for a quick reorder signal and a simple cost-based total.

A sample row might read: TEE-CRW-BLK-M | Classic Crew T-Shirt | Tops | M | Black | Northside Apparel | Rack A3 | 3 | 4 | 16.00 | 29.00 | 2026-09-12 | 2026-10-30. The dates and amounts here are illustrative. Confirm the actual cost, price, and stock against your own records.

Build the sheet in Excel

Put the headers in row 1 and enter each variant on a separate row below. Avoid merged cells, blank rows within the data, and decorative title rows above the headers; those can make filtering and sorting less reliable. Select a cell in the range and choose Insert > Table, then confirm that the table has headers. In Excel for Microsoft 365 on Windows, Ctrl+T also opens the Create Table dialog. On a Mac, use Insert > Table if the shortcut differs in your setup.

Give the table a descriptive name from the Table Design tab, such as ClothingStock. Tables add filter buttons and generally extend formatting and formulas when you add rows. Use the drop-downs in the header row to filter by category, size, color, supplier, or low-stock status. To keep headers visible while scrolling, choose View > Freeze Panes > Freeze Top Row.

Keep quantities as numbers and dates as real Excel dates rather than text that only looks like a date. Use consistent currency formatting for cost and retail price, and avoid typing currency symbols into the numeric value itself. If a product has no cost information yet, leave the cost blank and follow up rather than entering zero; zero can be mistaken for a real cost in summaries.

Use formulas for stock status and value

Formulas can make the sheet easier to scan, but they depend on the columns being entered consistently. With SKU in A, item name in B, category in C, size in D, color in E, supplier in F, location in G, quantity on hand in H, reorder point in I, unit cost in J, retail price in K, received date in L, last-counted date in M, status in N, and stock value in O, enter this in N2:

With quantity on hand in H2 and reorder point in I2, and with H2 set to 3 and I2 set to 4, this formula returns Reorder:

=IF(H2<=I2,"Reorder","OK")

The comparison uses less than or equal to, so an item is flagged as soon as it reaches the threshold. Copy the formula down the column, or enter it in the first data row of an Excel table so the calculated column can fill down automatically. The flag is a prompt to review stock, not an instruction to place a purchase order; lead time, upcoming demand, and supplier minimums may also matter.

With quantity on hand in H2 and unit cost in J2, and with H2 set to 3 and J2 set to 16, this formula returns 48.00 as the row’s cost-based stock value:

=H2*J2

Enter that formula in O2 and fill it down. The result is a simple quantity-times-unit-cost calculation, not necessarily the accounting value required for financial statements. For a total of the example rows, if their calculated stock values are in O2:O3 and are 48 and 32, this formula returns 80:

=SUM(O2:O3)

On Windows, use Home > Conditional Formatting > Highlight Cells Rules to make low quantities or reorder flags stand out. Color is a visual aid, so keep the text status as well; a color-only signal is less accessible and can be missed in printouts.

Make SKUs and variants dependable

A SKU is useful only if it identifies one variant unambiguously and stays stable. One simple pattern combines a short style code, color code, and size code, as in TEE-CRW-BLK-M. Decide on abbreviations before entering hundreds of rows, and document them in a small reference sheet. Do not reuse a SKU for a different garment after discontinuing the original; old sales or count records could then refer to the wrong item.

Barcodes and supplier item numbers can also be recorded, but they serve different purposes. A supplier’s code may identify a style but not your exact size-and-color stock unit. If you sell multiple variants, verify what the supplier code represents before treating it as a unique identifier. A barcode scanner can enter a code into a selected cell, but a spreadsheet does not become a point-of-sale system merely because it contains barcodes.

Keep counts accurate as stock changes

Choose a clear rule for updating quantities. For a basic manual tracker, adjust the count after receiving goods, recording a sale, processing a return, or removing damaged items, and note the date. If you update only during periodic stocktakes, label the figure as the last counted quantity rather than implying that it is live. A log of stock movements is more informative than silently overwriting the number, especially when you need to understand why a count changed.

A movement log can use columns for date, SKU, movement type, quantity change, reference, and notes. For example, a receipt might add 12 units, a sale subtract one, and a damaged item subtract one. Use a consistent sign convention: positive numbers for additions and negative numbers for removals. If more than one person edits the workbook, agree on who records each movement and how corrections are documented. Shared access alone does not prevent duplicate entries or missed sales.

Count garments in a repeatable way: use the same location order, separate sellable stock from damaged or reserved items, and verify that the SKU label matches the size and color. For a discrepancy, recount the affected variant and check recent receipts, transfers, returns, and sales before changing the record. A written adjustment note preserves context that a changed quantity by itself cannot provide.

Common spreadsheet mistakes

  • Combining variants: A row for “black T-shirt, all sizes” hides which sizes need replenishment. Use one row per size-color combination.
  • Duplicate or inconsistent labels: “Navy,” “navy blue,” and “NVY” may be treated as different values in filters. Use a controlled spelling or a validated drop-down list.
  • Sorting only one column: This can detach quantities from their SKUs. Sort the Excel table, not an isolated column, so whole records stay together.
  • Confusing zero and blank: Zero means a count was made and none were found; blank may mean the variant has not been counted or entered.
  • Overwriting formulas: Protect formula columns through careful editing practices and keep a backup. Check a few calculated rows after adding or pasting data.
  • Treating the reorder point as an order quantity: A threshold signals when to review. It does not account by itself for delivery time, demand, or pack sizes.

When a spreadsheet is enough—and when it is not

A spreadsheet can be a practical starting point for a small catalog, occasional stock counts, or a business that wants a transparent record it can tailor. It is inexpensive to begin if you already have Excel, and it allows custom fields for racks, collections, or supplier references. However, accuracy relies on people entering movements correctly and consistently.

As sales volume grows, multiple locations are involved, or online and in-person orders need to update the same stock instantly, manual spreadsheets can fall behind. A point-of-sale or inventory application may automate sales deductions, purchase orders, barcode workflows, and multi-location balances, depending on the product and plan. Before switching, check that the system handles size-color variants, data exports, user permissions, and the sales channels you actually use. You can retain a spreadsheet for analysis or backup, but avoid maintaining two competing “official” counts.

Frequently Asked Questions

How do I track clothing sizes and colors in Excel?
Use separate size and color columns, and give every size-color combination its own row and unique SKU. This lets you filter and count each sellable variant without combining unlike items.

Should each clothing style have one SKU or several?
If a style is sold in multiple sizes or colors, give each sellable variant its own SKU or other unique stock identifier. The style name can be shared across rows, but the stock counts should not be.

How do I calculate clothing inventory value?
For a simple estimate, multiply the quantity on hand by the unit cost for each variant, then sum those row values. The spreadsheet example is a basic calculation; use the method required by your accounting process for formal reporting.

Can Excel automatically reduce inventory when I make a sale?
Not from a manually maintained stock list by itself. You would need to record each sale as a stock movement or connect the workbook to a suitable sales or inventory system, then verify that updates are not duplicated or missed.

What is a reorder point for clothing?
It is a chosen quantity that prompts someone to review replenishment. Set it with regard to sales pace and supplier lead time, and revisit it when demand or delivery conditions change; it is not automatically the amount to order.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.