Linen Inventory Spreadsheet: Track Stock and Reorders

How-to basics · Updated November 21, 2026

A linen inventory spreadsheet is a simple way to record what linens you own, where they are stored, how many are available, and when to replenish them. In Excel for Microsoft 365, start with one row per linen item and columns for its ID, description, location, on-hand quantity, par level, and reorder amount; a formula can calculate the last figure automatically.

What a linen inventory spreadsheet is for

Linen inventory is the process of tracking reusable textile items such as sheets, pillowcases, towels, bath mats, tablecloths, uniforms, or cleaning cloths. A spreadsheet turns a count that might otherwise live on paper or in someone’s memory into a shared record. It can help a hotel notice a shortage before a busy period, help a care facility distinguish clean stock from items awaiting laundering, or help a household plan replacement purchases.

The spreadsheet does not make linen appear or prove that a recorded quantity is physically present. Its value comes from recording counts consistently and updating them when stock moves. A useful file therefore answers practical questions: Which items are available? Which room, floor, cupboard, or department holds them? What minimum quantity should be kept? When was the count last checked?

Keep the purpose proportional to the operation. A small household may need only a list and a count. A multi-site business may need separate storage locations, transaction records, supplier details, and controlled access. A spreadsheet is often suitable for a modest, clearly managed inventory, but it can become difficult to maintain when many people make frequent changes at once.

Choose the fields before building the sheet

Begin with fields that support decisions, not every detail that might conceivably be useful. A practical item list can use these columns:

  • Item ID: A consistent code such as TOW-BATH-01. A code helps distinguish similar products and makes transaction records easier to match.
  • Description and category: For example, “white bath towel” and “bath towel.” Use familiar names and a limited set of category labels.
  • Location: Record a specific storage point, such as “Floor 2, clean-linen cupboard,” rather than just “building.”
  • Unit: Specify whether the count is in individual pieces, pairs, or sets. Do not mix units for the same item.
  • On hand and par level: On hand is the latest verified quantity; the par level is the target quantity the operation aims to keep available.
  • Last counted and counted by: These fields make it easier to identify stale counts and follow up on discrepancies.
  • Optional purchasing details: Supplier, unit cost, reorder amount, and notes can help with purchasing, but should be maintained only if someone will use them.

Use one row for each distinct item-and-location combination if stock is managed separately by location. For instance, the same pillowcase stored in a laundry room and on a guest floor should not be combined if staff need to replenish those places independently. If the distinction does not affect decisions, a single total may be simpler.

Set up the worksheet in Excel

Put column headings in row 1 and inventory records below them. For a basic sheet, use A for Item ID, B for Description, C for Category, D for Location, E for Unit, F for On hand, G for Par level, H for To order, I for Unit cost, J for Stock value, and K for Last counted. Keep quantities numeric and store labels such as “pieces” in the Unit column, not in the quantity cells. This lets Excel calculate and sort the quantities properly.

Enter a unique ID for each row and avoid merged cells, blank rows inside the list, or multiple items in one cell. In Excel for Microsoft 365 on Windows, select the data range and use Insert > Table, leaving “My table has headers” selected. A table expands as records are added and provides filter controls in the header row. On Mac, the Table command is also available from Insert; the ribbon layout can vary slightly by version. Excel for the web has its own browser ribbon, so menu placement may differ.

Use consistent spelling for categories and locations. Where many people enter data, a controlled list reduces variations such as “Laundry,” “laundry room,” and “Laundry Rm.” In Excel for Microsoft 365 on Windows, select the entry cells and choose Data > Data Validation to create a list of permitted values. Data validation helps prevent inconsistent entries, but it does not replace checking that the selected value is correct.

Calculate reorder quantities and stock value

A par level is a target, not a universal standard. It should reflect expected use, the time required to replace stock, how often laundry returns, and the amount of reserve the operation chooses to hold. If 84 towels are on hand and the agreed par level is 120, the immediate gap is 36 towels. That does not automatically mean 36 should be ordered: damaged stock, pending deliveries, storage limits, or purchasing rules may affect the actual order.

With On hand in F and Par level in G, enter this formula in H2 to show the shortage without displaying a negative number: =MAX(0,G2-F2). For the example with 84 on hand and a par level of 120, H2 returns 36. If on hand is 130 and par is 120, it returns 0. Copy the formula down the column or let an Excel table fill it into new rows.

With the same layout, enter this formula in J2 to calculate the recorded value of the stock: =F2*I2. If F2 contains 84 and I2 contains 8.50, J2 returns 714.00 in the currency units used in the cost column. This is a simple quantity-times-unit-cost estimate; it does not include taxes, shipping, depreciation, or other accounting adjustments.

Use a consistent currency format for costs and totals. If unit costs are not maintained or the value estimate is not useful, omit those columns rather than letting outdated prices appear authoritative. For purchasing, a separate “Order quantity” may be needed because the recommended buy can differ from the gap to par. For example, a supplier may sell items in cases of 12, while a shortage is 17; the operational decision may be to buy 24, subject to the organization’s purchasing rules.

Choose between a snapshot and a movement log

The simplest design is a snapshot: staff count each item and overwrite the On hand figure. It is quick to understand and can work well when there are few items and counts happen on a reliable schedule. Its limitation is that it records the latest balance, not how the balance changed. If a count seems wrong, the sheet alone may not show whether stock was issued, received, moved, damaged, or miscounted.

A movement log records each receipt, issue, return, adjustment, or transfer as a separate row. It creates a more useful history but requires staff to record transactions promptly and use consistent item IDs and movement labels. One workable structure is a master sheet named Items with the item ID in A, opening quantity in F, and calculated current quantity in G. A second sheet named Transactions can use A for Date, B for Item ID, C for Movement, and D for Quantity. Record movement types exactly as “Received” or “Issued,” and enter quantities as positive numbers.

With those sheet names and columns, put this formula in Items!G2 to calculate current stock from the opening quantity and transaction log: =F2+SUMIFS(Transactions!$D:$D,Transactions!$B:$B,A2,Transactions!$C:$C,"Received")-SUMIFS(Transactions!$D:$D,Transactions!$B:$B,A2,Transactions!$C:$C,"Issued"). If the opening quantity is 20, the log contains 15 received and 9 issued for that ID, the result is 26. Transfers between tracked locations need more care: record both the decrease at the source and the increase at the destination, or design a movement method that explicitly identifies both locations.

Make counts repeatable and useful

A count is only comparable with earlier counts if people use the same counting rules. Decide whether staff count clean linen only, whether items at the laundry are included, and how to treat damaged, stained, or missing pieces. If clean stock and items in processing are both important, record them separately rather than combining them into an ambiguous total.

  1. Choose a counting frequency suited to how quickly stock changes. High-turnover items may need more frequent checks than seasonal or rarely used items.
  2. Count one defined location at a time, using the same unit and inclusion rules each time.
  3. Compare the physical count with the spreadsheet and investigate meaningful differences before replacing the recorded figure.
  4. Update the count date and, where appropriate, the person who counted it.
  5. Review shortages, damaged items, and unusual changes, then update par levels only when operating needs have changed.

For a broad inventory, a rotating count can spread the work across the week or month: count selected categories or locations on a schedule rather than attempting everything at once. This is a workflow choice, not an Excel feature, and it works only if the schedule makes clear which areas are current and which have not yet been counted.

Use filters, formatting, and summaries carefully

Filters make it easier to view one category or location without creating separate copies of the same list. A table’s header filters can show rows where To order is greater than zero, or display only a specific storage area. Sorting by Last counted can help locate old records. Avoid sorting just one column independently, because that can separate item details from their corresponding quantities.

Conditional formatting can draw attention to shortages. In Excel for Microsoft 365 on Windows, select the relevant cells and choose Home > Conditional Formatting > Highlight Cells Rules > Less Than, or use a formula-based rule when the comparison needs to involve two columns. Apply colors sparingly and keep the underlying text or numbers clear; color alone may be hard to distinguish for some readers or when printed in grayscale.

A summary can show total pieces by category or location, but totals are meaningful only when units are compatible. Adding towels, sheet sets, and tablecloths into one total may produce a mathematically correct number with little operational value. A PivotTable can summarize quantities by category or location, provided the source data has consistent headings and a clear row structure. Update or refresh the summary after the underlying records change.

Common problems and sensible safeguards

One frequent problem is treating a spreadsheet balance as a physical count. Receipts may not be entered, items may be moved without a record, and damaged linen may remain in the list. Set a clear owner for updates and periodically compare the sheet with what is actually present. Record adjustments with a date and explanation when auditability matters.

Another problem is using a single row for a vague group such as “towels,” even though bath towels, hand towels, and pool towels are purchased or stored separately. Split items when differences affect ordering, location, or use. Conversely, avoid creating rows for distinctions no one maintains; excessive detail makes the file harder to keep accurate.

Protect the workbook from accidental changes by limiting editing access where appropriate and keeping a reliable backup. Do not treat worksheet protection as a substitute for access control or as encryption. If the inventory is shared through OneDrive or SharePoint, use the organization’s normal permission and version-history practices. Linen counts generally do not require personal or sensitive data, so avoid adding employee or guest information that is unnecessary for stock control.

For hygiene and safety, the spreadsheet should support—not replace—written laundry, handling, and infection-prevention procedures. Keep status categories unambiguous if clean, soiled, quarantined, or damaged items must be distinguished. Follow the relevant workplace procedures and applicable guidance for the setting; a spreadsheet cannot certify that linen was cleaned or handled correctly.

When a spreadsheet is not enough

A spreadsheet is inexpensive to start and easy to adapt, but it depends on disciplined entry. Multiple users editing separate copies can create conflicting balances, and a snapshot sheet does not provide a dependable history unless changes are recorded. If an operation needs barcode scanning, purchase-order integration, automatic alerts, detailed audit trails, or controls across many sites, dedicated inventory or facilities software may be a better fit.

Before changing systems, identify the actual bottleneck. If the main issue is missed updates, a simpler process and assigned responsibility may help more than extra software. If the issue is simultaneous transactions, unreliable networked files, or complex transfers, an application designed for shared inventory may address a real limitation. Compare licensing, setup, training, data export, and support costs; do not assume that more features automatically produce more accurate counts.

Frequently Asked Questions

What should a linen inventory spreadsheet include?
At minimum, include a unique item ID, description, location, unit, current quantity, par level, and date counted. Add supplier, cost, condition, or movement history only when those fields support a real task.

How do I calculate how many linens to reorder?
Subtract the current quantity from the chosen par level and do not let a negative result become a suggested order. In a layout with current quantity in F2 and par in G2, =MAX(0,G2-F2) returns the gap. Check pending deliveries, pack sizes, and purchasing requirements before placing an order.

How often should linen stock be counted?
There is no single interval suitable for every operation. Count frequently enough to catch shortages before they disrupt service, with more frequent checks for high-use or high-value stock and a consistent schedule for slower-moving items.

Should clean and soiled linen be counted together?
Usually, keep them distinct if staff need to know what is available for immediate use. A combined number can overstate usable stock when some items are awaiting laundry, inspection, repair, or disposal.

Can I use one spreadsheet for multiple locations?
Yes, if every record identifies its location and staff update the shared source rather than maintaining disconnected copies. Use separate rows for the same item at different locations when each site needs its own balance or reorder decision.

When should I move from Excel to inventory software?
Consider a dedicated system when transaction volume, concurrent editing, barcode workflows, audit requirements, or integrations exceed what staff can maintain reliably in a workbook. The deciding factor is whether the current process produces timely, trustworthy records.

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.