Uniform Inventory Spreadsheet: Build a Useful Tracker

How-to basics · Updated November 21, 2026

Create a uniform inventory spreadsheet in Excel with one row per item and size, columns for opening stock, receipts, issues, current stock, and reorder level, then update it whenever garments move in or out. For a small operation, a single inventory sheet is enough; for frequent transactions, use a separate movement log and calculate stock from it.

What a Uniform Inventory Spreadsheet Tracks

A uniform inventory spreadsheet is a structured record of garments and related items held for employees, students, teams, or other groups. It helps answer practical questions: How many medium shirts are available? Which sizes need replenishing? Has a particular employee received a coat? It can also support ordering and periodic stock counts, but it is only as reliable as the records entered and checked.

Uniform stock is not always just a count of identical objects. A shirt in one size is not interchangeable with the same shirt in another size, and items may also differ by style, department, gender cut, color, logo, or supplier. For that reason, the spreadsheet should identify each distinct stock-keeping item clearly. A polo shirt in size M and a polo shirt in size L generally belong on separate rows.

The sheet is useful for both reusable stock and garments issued to individuals, but these are related yet different records. The inventory sheet tracks quantities available. An issue history records which person received which item and when. Keeping those purposes distinct makes it easier to reconcile the remaining stock without losing the distribution history.

Choose a Layout Before Entering Data

Start with a simple design that matches the scale of the operation. For a small office or club, use one worksheet called Inventory. Put one item-size combination on each row and use clear column headings such as:

  • Item ID or SKU: a unique code for the exact garment and size.
  • Item description: for example, “Logo polo shirt.”
  • Size and other variants: record size, color, cut, or department separately when those distinctions affect stock.
  • Opening quantity: the quantity on hand when tracking begins.
  • Received and issued: additions and distributions since the opening count.
  • On hand: the calculated balance.
  • Reorder level: a locally chosen threshold that signals when to review or purchase stock.
  • Supplier, location, and notes: optional details that help with purchasing and storage.

Use one consistent description for each item. If one person enters “navy polo” and another enters “blue shirt,” filtering and summaries may treat them as different products. A stable item code is a stronger identifier than a description alone. For example, POLO-NVY-M can represent a navy polo in medium, provided the organization documents and consistently uses that code.

In Excel for Microsoft 365 on Windows, select the headings and data and choose Insert > Table. Confirm that the table has headers. An Excel table supplies filter controls, expands as rows are added, and makes it easier to format and manage a growing list. Use descriptive worksheet names and avoid merged cells in the data area, because merged layouts make sorting and filtering awkward.

Set Up Stock Quantities and Useful Fields

Decide what “on hand” means before building the calculation. A straightforward count includes garments physically available for issue. If items can be reserved, damaged, being altered, or held in another location, track those states explicitly rather than quietly treating them as available. One organization might add a Reserved column; another might separate storage locations into different records. The right choice depends on how staff make allocation decisions.

For example, a uniform room might carry black trousers in sizes 30, 32, and 34, plus shirts in XS through XXL. Each size is a separate row, even when the style and supplier are identical. If the same shirt is stocked at two sites and staff cannot readily transfer it, record the location as part of the item record or use separate rows by location. This avoids a total that looks sufficient overall while one site has none.

Only collect personal information that is needed for the tracking task. Employee names and issue details are often better kept in a restricted distribution log than in a sheet visible to everyone who needs to check stock. A stock count usually needs an item identifier and a quantity, not a person’s full employment record.

Calculate the On-Hand Balance

For a basic sheet, place the opening quantity in column D, receipts in E, issues in F, and the balance in G. With those headings on row 1 and the first item on row 2, enter the formula below in G2, then fill it down for the other item rows.

With opening stock in D2, receipts in E2, and issues in F2, =D2+E2-F2 returns 15 when D2 is 12, E2 is 8, and F2 is 5. The arithmetic is 12 + 8 − 5 = 15 garments on hand.

Put the reorder level in H and a stock status in I. With the calculated balance in G2 and the reorder level in H2, =IF(G2<=H2,"REORDER","OK") displays REORDER when the balance is at or below the threshold and OK otherwise. If G2 is 15 and H2 is 6, the result is OK. This is a prompt to review stock, not an automatic purchase decision: lead time, upcoming demand, budget, and supplier availability may also matter.

Enter quantities as numbers, not text such as “15 shirts.” Keep the unit consistent, usually individual garments. If one package contains several pieces, convert it to the number of garments before adding it, or clearly define a different unit. Do not enter a negative quantity in an “issued” field unless the sheet’s design explicitly expects it; normally, an issue is entered as a positive number and subtracted by the formula.

Use a Movement Log for Frequent Changes

When stock changes often, repeatedly editing total receipts and issues in the master list makes it hard to see what happened. A movement log provides a dated record. Create a worksheet named Movements with columns for Date, SKU, Type, Quantity, and Reference or Notes. Enter one row per transaction, using a consistent type such as Receive or Issue. Keep the inventory master list separate, with one row for each SKU and an opening quantity.

For this design, assume Inventory has the SKU in A2 and opening quantity in D2. In Movements, assume SKU is in column B, Type in C, and positive quantities in D. With the movement log in those columns, the following formula in the Inventory balance cell totals receipts and subtracts issues for that SKU:

With opening stock in Inventory!D2 and movement SKUs, types, and quantities in Movements!B:B, Movements!C:C, and Movements!D:D, =D2+SUMIFS(Movements!$D:$D,Movements!$B:$B,$A2,Movements!$C:$C,"Receive")-SUMIFS(Movements!$D:$D,Movements!$B:$B,$A2,Movements!$C:$C,"Issue") returns 15 when the opening balance is 12 and the log contains 8 received and 5 issued for that SKU. The result is 12 + 8 − 5 = 15. The text values in the Type column must match the formula criteria exactly.

A movement log is more auditable because it preserves individual changes and dates, but it depends on staff recording every transaction. It can also grow large, so use clear headings, filters, and a consistent entry process. For a small inventory with only occasional changes, the simpler receipts-and-issues columns may be easier to maintain. Avoid tracking the same transactions in both systems unless you have a clear reconciliation process, or the balance may be counted twice.

Make the Sheet Easier to Use and Review

Good spreadsheet controls reduce common data-entry mistakes. In Excel, select the entry cells and choose Data > Data Validation to restrict values where appropriate. For example, a dropdown list for transaction type can limit entries to Receive and Issue. A size list can standardize values such as XS, S, M, L, and XL. Validation does not replace review, but it can prevent inconsistent spelling and accidental categories.

Use Home > Conditional Formatting to highlight balances at or below the reorder level, or to flag negative stock. Keep the actual balance visible as a number; color should reinforce the information, not be the only way to identify a problem. Freeze the header row with View > Freeze Panes if the list is long, and use table filters to find a particular size, item, or location.

Protect formula cells from accidental edits if multiple people enter data, while leaving the intended input cells editable. Excel worksheet protection can reduce accidental changes, but it is not a substitute for access controls or secure storage of sensitive records. Save the workbook in a location available to the people responsible for updates, and define who owns the master data and who is allowed to change item codes.

Reconcile the Spreadsheet with Physical Stock

A calculated balance is not proof that the same number of garments is on the shelf. Items may be issued without being recorded, returned without being added back, misplaced, damaged, or counted under the wrong size. Schedule physical counts at a cadence appropriate to how quickly stock moves, and also count after a major distribution or a change of custodian.

During a count, compare the physical quantity with the spreadsheet for each item-size-location combination. Investigate differences before changing the balance: check recent receipts, issue records, returns, transfers, and whether a similar size was mistaken for another. Record an adjustment with a date and explanation rather than silently overwriting a prior figure. That leaves a trace of why the recorded balance changed.

For example, if the spreadsheet says there are 15 medium polos but the count finds 14, look for an unrecorded issue or a misfiled garment. If the reason cannot be established, record a one-unit adjustment and note the count date. Clear correction records make later reviews more useful than unexplained edits.

Spreadsheet or Dedicated Inventory System?

A spreadsheet is often a practical starting point when the catalog is modest, transactions are manageable, and a small number of people can maintain one shared source of truth. It is flexible, easy to adapt to local item names, and can support filters, formulas, and simple summaries without requiring a specialized inventory application.

Its limits become more important as activity grows. A workbook does not inherently prevent two people from issuing the same final item, guarantee that every movement is logged, or provide a complete approval and audit workflow. Multiple copies circulated by email can quickly disagree. A dedicated inventory or uniform-management system may be worth evaluating when there are many locations, high transaction volumes, barcode requirements, frequent allocations, or a need for controlled user permissions and integrated purchasing.

There is no universal number of items at which an organization must switch tools. The useful test is whether the spreadsheet can be updated promptly, reconciled reliably, and understood by its users. If errors are frequent or the time spent maintaining the workbook exceeds the value of its flexibility, compare the cost and features of alternatives against the actual workflow.

Frequently Asked Questions

What should a uniform inventory spreadsheet include?
At minimum, include a unique item identifier, description, size or other relevant variant, quantity on hand, and reorder level. Add receipts and issues or a separate movement log so the balance can be explained. Supplier, storage location, and notes are useful when they support real decisions.

Should each uniform size have its own row?
Yes, when sizes are stocked and issued independently. A medium shirt and a large shirt are separate inventory items for counting and replenishment, even if they share a style name. Apply the same principle to other variants that affect selection or availability.

How do I track uniforms issued to employees?
Keep a distribution log with the employee identifier, item or SKU, size, quantity, date, and relevant return or replacement information. Record the corresponding issue in the stock movement log so the inventory balance falls as garments are distributed. Restrict access to personal records to people who need them.

Can Excel automatically warn me when uniform stock is low?
A formula can label an item when its balance reaches a reorder level, and conditional formatting can visually highlight it. These rules only work when stock movements are recorded accurately. They do not determine the correct reorder quantity or account automatically for future demand and delivery timing.

Is a uniform inventory spreadsheet enough for a large organization?
It may be, if a controlled workbook and disciplined process meet the organization’s needs. If several sites, many users, or frequent transactions make the records difficult to reconcile, assess a dedicated system. The decision depends on workflow, controls, and cost rather than on a fixed item count.

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.