Shirt Inventory Spreadsheet: Track Sizes and Stock

How-to basics · Updated November 21, 2026

A shirt inventory spreadsheet is a workbook for recording each shirt style, color, size, and quantity, then calculating what remains in stock. In Excel for Microsoft 365 on Windows, a practical starting point is one row per sellable size-and-color variant, with columns for its SKU, opening quantity, receipts, sales, damage, current stock, and reorder level.

What a shirt inventory spreadsheet tracks

Shirt stock is not just a count of designs. A single graphic tee may come in three colors and five sizes, and each combination can sell at a different rate. To avoid treating all those pieces as interchangeable, give each distinct variant its own record. For instance, a black medium and a black large should have separate rows, even though they share the same style and color.

The spreadsheet can serve as a simple stock record for a small shop, a clothing brand, a school fundraiser, or a team ordering shirts. Its usefulness depends on recording changes consistently: incoming stock increases the quantity, while sales, samples, returns, and damaged garments need to be handled explicitly. A number entered once and never updated is a snapshot, not a dependable inventory system.

A basic workbook usually answers three questions: What do I have? Where is it or what does it cost? When should I replenish it? A more developed version can also show sales history, suppliers, purchase orders, and the date of the latest count.

Choose a row structure that matches the products

Use one row for one sellable variant, not one row for an entire design. A useful set of columns is:

  • SKU: A unique identifier, such as TEE-BLK-M, for the black medium tee.
  • Style: The design or product name, such as Classic Tee or Mountain Print.
  • Color and size: Separate fields make it easier to filter and summarize stock.
  • Location: A shelf, stockroom, or event location, if inventory is stored in more than one place.
  • Opening quantity, received, sold, and damaged: The quantities needed to calculate stock using a simple period-based method.
  • On hand and reorder level: The current count and the threshold that prompts a restock review.
  • Unit cost, supplier, and last counted: Optional fields that support purchasing and stock checks.

Keep units consistent. If quantities represent individual shirts, enter individual shirts everywhere, not cases in one column and pieces in another. For example, SKU TEE-BLK-M should never be reused for a different color, size, or garment. A unique SKU helps distinguish variants when product descriptions are similar.

Set up the workbook in Excel

Start with a clear header row and put inventory records below it. In Excel for Microsoft 365 on Windows, select the range and choose Home > Format as Table, or press Ctrl+T. Confirm that the table has headers. Tables provide filter buttons, consistent formatting, and automatic expansion when you add rows. On Mac, use Home > Format as Table or Command+T. Excel for the web also supports tables, though the exact ribbon layout can vary.

Keep reference information separate from changing quantities. For example, put the SKU, style, color, and size in identifying columns, then put stock movements and calculated results in their own columns. Use a consistent spelling for colors and styles; “Navy,” “navy,” and “Dark Blue” can otherwise become three categories in a summary. Where consistency matters, a drop-down list can help. Select the entry cells and choose Data > Data Validation on Windows, then set the validation type to List and provide the allowed options.

Before relying on the workbook, test it with a few known items. Check that filters work, formulas fill down as expected, and the total stock agrees with a physical count. Freeze the header row if the list is long; on Windows, choose View > Freeze Panes > Freeze Top Row. Mac and web versions may place freeze controls differently under the View tab.

Calculate stock on hand

A simple stock calculation uses an opening count plus receipts, minus sales and damaged or otherwise unsellable units. This works well when each row represents a defined tracking period and the opening quantity is reset to the verified count at the start of the next period. For row 2, assume opening quantity is in E2, received units in F2, sold units in G2, damaged units in H2, and on-hand stock in I2. Enter =E2+F2-G2-H2 in I2. If the row has 12 opening shirts, 8 received, 5 sold, and 1 damaged, the result is 14 shirts.

To flag a possible reorder, assume on-hand quantity is in I2, reorder level is in J2, and the status formula goes in K2. Enter =IF(I2<=J2,"REORDER","OK"). With 14 on hand and a reorder level of 10, it returns OK; if stock falls to 10 or below, it returns REORDER. A reorder flag is a prompt to review purchasing, not an instruction to order automatically: lead time, planned promotions, and available cash may also matter.

If unit cost is in L2 and the inventory value is in M2, enter =I2*L2 in M2. With 14 shirts on hand at an illustrative unit cost of $7.50, the result is $105.00. Be clear about what “unit cost” means in your records, and do not mix retail price with cost. These formulas are ordinary arithmetic and IF, so they work in current desktop Excel, Excel for Mac, and Excel for the web.

Record receipts, sales, and adjustments consistently

The opening-plus-movements layout is easy to understand, but it can become difficult to audit if every new delivery overwrites an old number. For better traceability, create a separate movement log with one row per event: date, SKU, movement type, quantity, reference or note, and person recording it. A delivery might be marked “Receipt” for 24 units; a sale might be marked “Sale” for 2. Keep the sign convention consistent, or store all quantities as positive numbers and use the movement type to explain their direction.

A movement log is especially useful when stock changes often or more than one person updates the workbook. It provides a history to investigate when the calculated count and physical count disagree. You can still keep a current-stock summary on another sheet, but take care that the summary is linked to the log correctly and that new SKUs are included.

Decide in advance how to treat returns. A saleable return can increase available stock after inspection; a damaged return should not. Samples, staff shirts, gifts, and event giveaways also reduce stock even if they are not ordinary sales. Recording these as distinct movement types gives a more honest picture than silently changing the count.

Summarize stock and identify replenishment needs

Filters let you inspect a single size, color, or style without changing the underlying records. A summary can also show total units for a style. For example, assume style names are in B2:B4 and on-hand quantities are in I2:I4; the three rows contain Classic Tee quantities of 14, 9, and 6. Enter =SUMIF(B2:B4,"Classic Tee",I2:I4) in a summary cell. It returns 29 shirts for that style. In a larger workbook, a PivotTable can summarize quantity by style, size, color, or location; on Windows, select the source table and choose Insert > PivotTable.

Conditional formatting can make low-stock rows easier to spot. Select the quantity or status cells and use Home > Conditional Formatting to apply a rule, such as highlighting values below a chosen threshold. Keep the visual cue secondary to the recorded numbers: color alone is not a reliable description, and a red cell does not explain whether the item is actually available to sell.

Reorder levels should reflect how quickly a particular variant sells and how long replenishment takes. A popular large size may need a different threshold from a slow-moving color. A fixed threshold is a helpful starting point, but it will not account for a one-off event or a supplier delay unless someone reviews those circumstances.

Common spreadsheet problems to prevent

The most common errors are duplicate SKUs, inconsistent labels, forgotten stock movements, and formulas that stop before newly added rows. An Excel Table helps formulas and formatting extend to new records, but it cannot ensure that entries are correct. Protect the meaning of each column with clear headers, and document unusual adjustments in a notes field or movement log.

  • Do not combine sizes in one quantity cell. “12 shirts, mixed sizes” cannot show which sizes are available.
  • Do not use blanks to mean zero. Enter 0 when the count is known to be zero; reserve blanks for unknown or unrecorded values.
  • Do not delete an item just because it is out of stock. Keeping the SKU preserves its history and makes restocking easier.
  • Reconcile with a physical count. A formula cannot detect an unrecorded sale, theft, or data-entry error.
  • Keep a backup. Save a dated copy before major changes and use a shared, controlled file if multiple people need to edit it.

A negative on-hand result is a signal to investigate, not a number to hide. It may mean a sale was entered before a receipt, an opening count was wrong, or a transaction was recorded against the wrong size. Correct the source record and preserve a note about the adjustment rather than typing over a calculated formula.

When a spreadsheet is enough—and when it is not

A spreadsheet can be a sensible choice for a small, stable range of shirts, a short-term event, or a business where one person updates stock and sales volume is manageable. It is flexible, easy to tailor, and can run without a dedicated inventory service. Its limitations become more significant when many staff members edit at once, stock moves across several locations, online and in-person sales need to stay synchronized, or order fulfillment depends on near-real-time counts.

Alternatives include inventory features built into an existing point-of-sale or ecommerce system, or dedicated inventory software. Those tools may connect sales and stock movements automatically, but suitability depends on product variants, integrations, reporting, and cost. A spreadsheet may still be useful for planning or analysis even when another system is the authoritative stock record. Avoid maintaining two uncoordinated “official” counts: decide which system is the source of truth and how often any secondary sheet is updated.

Frequently Asked Questions

How do I track shirt sizes in a spreadsheet?
Give every size-and-color combination its own row and unique SKU. Keep size and color in separate columns so you can filter, count, and summarize each variant accurately.

Should each shirt design have one row or several?
Use several rows when a design is sold in different sizes or colors. One row per sellable variant prevents a total count from hiding a stockout in a particular size.

How do I calculate shirt stock after sales?
For a period-based sheet, add the opening quantity and receipts, then subtract sales and damaged units. Record each movement consistently, and verify the result against a physical count.

Can Excel alert me when a size is low?
Yes. Add a reorder-level column and use an IF formula to display a status when on-hand quantity is at or below that level. Conditional formatting can also highlight the row for review.

How often should I update a shirt inventory spreadsheet?
Update it whenever stock changes if you use it to make sales or fulfillment decisions. At minimum, reconcile it regularly with a physical count; the right interval depends on how quickly stock moves and the consequences of an inaccurate count.

Can I use the same spreadsheet for shirts in multiple locations?
Yes, if each stock record identifies its location or the movement log records where a transfer starts and ends. Otherwise, a total may look sufficient while a particular store, event, or stockroom has none available.

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.