A hotel laundry list template in Excel is a tracking sheet for recording laundry sent out, returned, missing, or damaged. Start with columns for date, room or department, item, quantity sent, quantity returned, missing quantity, damage, and notes; add rates and charge fields only if your hotel needs them.
What a Hotel Laundry List Tracks
“Laundry list” can mean two related things in a hotel. For guest laundry, it is the record that accompanies clothing collected from a room and sent for cleaning. For hotel operations, it may track linen and uniforms sent to an in-house laundry or an outside service. Both use the same basic idea: identify each batch, list its items and quantities, and reconcile what comes back.
An Excel sheet can help staff spot discrepancies and create a consistent handoff record, but it is not automatically a laundry-management system. It will not verify a physical count, contact a laundry vendor, or establish a hotel’s prices and service policies. Staff still need to record counts accurately and agree on how exceptions are handled.
Before building the sheet, decide who will use it and what decision it supports. A guest-laundry record may need a guest or room reference and service instructions. A linen-control sheet may need a department, stock location, or vendor batch number instead. Avoid collecting fields that the workflow does not need.
Recommended Template Columns
A practical starting point is one row per item type within a laundry batch. If a room sends three shirts and two pairs of trousers, record two rows with the same batch reference rather than putting several quantities in one free-text cell. This makes sorting, filtering, and checking totals much easier.
| Column | What to enter |
|---|---|
| Date collected | Date the laundry was received or dispatched |
| Batch or ticket ID | A unique reference used on the paper ticket or bag |
| Room or department | Room number, housekeeping, restaurant, or another relevant location |
| Guest or account reference | Only when needed; use the hotel’s approved identifier |
| Item | Specific description such as shirt, bath towel, or chef jacket |
| Quantity sent | Count handed to the laundry |
| Quantity returned | Count received back and checked |
| Missing | Difference between sent and returned quantities |
| Damaged or rejected | Count and, if useful, a brief description of the issue |
| Rate or charge | Optional; include only when the workflow calls for a documented amount |
| Status and notes | For example, pending, complete, recount required, or stain reported |
Keep the batch ID on every item row. It connects the separate item lines to one collection and return, and is often more reliable than trying to identify a batch by room and date alone. If a paper laundry ticket is used, the Excel reference should match the ticket.
How to Set Up the Sheet in Excel
- Open a blank workbook and put a clear title and the reporting period above the data area. Place the column headings in one row, with no blank columns between fields.
- Enter the recommended headings, then select the heading row and a few rows beneath it. Choose Insert > Table and confirm that the table has headers. Excel tables expand as rows are added and provide filter controls in the headings.
- Use one row per item type and batch. Keep dates as dates, quantities as numbers, and notes as text. Do not combine a count and a description in one cell, such as “3 towels”; use a separate item and quantity field.
- Set sensible number formats. Quantities should be whole numbers; rates and charges, if included, should use the appropriate currency format. Do not type currency symbols into a quantity field.
- Save the workbook with a descriptive name and store it in the hotel’s approved location. If multiple staff members need to update it, establish who owns the master copy and how duplicate or conflicting edits will be handled.
For a reusable item list, use consistent names rather than spelling the same item several ways. Excel’s Data > Data Validation can restrict entries to a list, such as a maintained set of item types or statuses. Keep that list practical and review it when the hotel adds uniforms or changes linen specifications.
Recording Returns and Calculating Discrepancies
Enter the quantity sent when the bag or batch leaves the collection point, then fill in the returned quantity only after someone has checked the delivery. A formula can calculate the difference, while the status field records whether it still needs investigation. A negative difference should not be silently treated as zero: it can indicate an extra item, a typing error, or a counting problem.
With quantity sent in E2 and quantity returned in F2, enter this formula in G2 for the missing or excess difference:
=E2-F2
For example, if 12 towels were sent and 11 returned, the result is 1. If 13 were returned, the result is -1, which flags an apparent extra item for checking. Copy the formula down the column, or enter it in the first data row of an Excel table so the table can extend the calculated column to new rows.
Do not confuse damaged items with missing items. A damaged piece may still be physically returned, so record its quantity in a separate field and describe the condition. That distinction helps the hotel investigate loss and quality complaints separately.
If the hotel has an approved rate for chargeable missing or damaged pieces, a charge calculation can be added, but it should reflect the actual policy and avoid counting the same item twice. With missing quantity in G2, damaged quantity in H2, and an applicable per-item rate in I2, this illustrative formula in J2 calculates a charge when the two counts are separate:
=(G2+H2)*I2
If one item could appear in both categories, define a counting rule before using that calculation. For example, a missing item cannot also be a returned damaged item in the same batch. An illustrative row with 1 missing item, 2 separate damaged items, and a rate of $4 returns $12. Treat that as an arithmetic example, not a recommended hotel fee; use the rate and rules actually approved for the operation.
With quantities sent in E2:E500, the following formula in a summary cell adds the recorded sent quantities:
=SUM(E2:E500)
If the entries are 12, 8, and 5, the result is 25 items sent. Make sure the chosen range covers the records being summarized; an Excel table’s totals row is another option for summarizing a table column.
Daily Handoff and Reconciliation
The value of the template comes from using it at both ends of the process. A consistent handoff reduces ambiguity about whether a discrepancy happened during collection, transport, processing, or return. A simple operating sequence is:
- Assign or write down a batch ID when items are collected; put the same reference on the physical ticket or bag.
- Count items by type with the person handing them over, and record the date, destination, and relevant room or department.
- On return, count each item type before marking the batch complete. Record damaged, stained, or rejected items separately from missing quantities.
- Compare the sent and returned counts, note any difference, and assign a person or team to follow up.
- Close the record only when the hotel’s reconciliation process is complete, retaining any required supporting ticket or vendor documentation.
For instance, a housekeeping batch might show 20 bath towels sent, 19 returned, and one missing. The sheet should preserve the original sent count, the checked return count, and the follow-up note; changing the sent count to 19 would erase the evidence needed to investigate. A later correction should be recorded transparently according to the hotel’s recordkeeping practice.
Formatting, Filters, and Data Quality
Make the workbook easy to scan without relying on color alone. Use clear headings, a frozen header row for longer sheets, and filters to view a date, room, department, or status. In Excel for Microsoft 365 on Windows, select View > Freeze Panes > Freeze Top Row to keep the headings visible while scrolling. On a Mac, the View tab also contains Freeze Panes; ribbon placement can vary slightly by window layout.
Conditional formatting can draw attention to unresolved differences. For example, select the difference cells and use Home > Conditional Formatting > Highlight Cells Rules > Greater Than to highlight positive discrepancies. Consider a separate rule for values below zero. Keep the underlying number visible, and do not use a highlight as a substitute for a written status or follow-up note.
Common data-quality problems include blank batch IDs, inconsistent item labels, text entered in quantity cells, and returned counts entered before the physical check. Review these points at the end of a shift or service cycle. A short controlled list of statuses—such as Pending, Complete, and Investigate—is usually more useful than many near-duplicates such as “done,” “finished,” and “closed.”
Guest Laundry Versus Hotel Linen
A guest-laundry template often needs an item description, quantity, service selection, collection and return times, and a place to note special instructions. It may also need a reference that connects the record to the hotel’s existing guest-service process. Avoid putting unnecessary personal information into a broadly shared spreadsheet. Where guest identification is required, follow the hotel’s privacy and access-control procedures.
A linen or uniform template is usually more focused on operational quantities and location. Useful additions might include stockroom, department, vendor, delivery note number, or garment condition. A hotel handling several departments may want a department field rather than separate workbooks, because one consistent list is easier to filter and summarize. Separate sheets can still make sense when access or processes genuinely differ.
Neither version should assume that every laundry provider uses the same terminology, item codes, or billing method. If the workbook is used to check an outside invoice, match its item names and units to the vendor’s documentation, and keep the supporting invoice or delivery record. A hotel’s own count and a vendor’s count are separate records until reconciled.
Common Mistakes and Practical Safeguards
- Using one row for an entire bag: A note such as “shirts and towels” cannot be reliably totaled. Separate item types into rows under the same batch ID.
- Overwriting the original count: Keep sent and returned quantities in separate columns so a discrepancy remains visible.
- Mixing different units: Do not add pieces, kilograms, and bags together as if they were equivalent. Label the unit and summarize comparable values only.
- Adding automatic fees without a rule: A formula can multiply quantities, but it cannot decide which losses are chargeable or what rate applies. Confirm the approved process first.
- Leaving the workbook open to accidental edits: Limit access to people who need it, retain backups according to hotel practice, and consider protecting formula columns from casual changes.
Excel records are only as reliable as the people and process behind them. A shared workbook may be suitable for a modest operation, but high transaction volumes, multiple locations, or complex vendor reconciliation may call for a dedicated system with user permissions, audit history, and links to purchasing or inventory records.
Frequently Asked Questions
Can I download a hotel laundry list template in Excel?
This page provides a structure you can build in Excel rather than a downloadable workbook. Copy the column headings into a new sheet, format the range as a table with Insert > Table, and add formulas only for the calculations your process requires.
What should a hotel laundry list include?
At minimum, include a date, batch reference, room or department, item, quantity sent, quantity returned, and a notes or status field. Add damage, guest reference, vendor, or rate details only when they support a real operational need.
How do I calculate missing laundry in Excel?
Put the sent count and returned count in separate cells. With sent quantity in E2 and returned quantity in F2, =E2-F2 returns the difference: a positive result means fewer items came back, while a negative result means more were recorded as returned.
Can one spreadsheet track both guest laundry and hotel linen?
Yes, if the records share a consistent structure and users can distinguish the workflow with a field such as service type or department. If guest records require stricter access or different handling, separate workbooks or an approved hotel system may be more appropriate.
Should the template calculate guest laundry charges?
Only if the hotel has an approved rate and a defined method for recording chargeable items. A spreadsheet can perform arithmetic, but staff should verify the service record and applicable policy before relying on a calculated amount.
Related
- Find Matching Names in Two Excel Lists: Methods That Work
- Find Excel Product Key: Where to Look and What to Do
- Find Duplicate Names in Excel: Methods That Work Well
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Append Tables in Excel Without Power Query: Best MethodsYes. To append tables in Excel without Power Query, copy the data rows from one table and paste…
- Excel: Highlight Cells With Dates Before TodayTo highlight dates before today in Excel for Microsoft 365 on Windows, select the date cells, then choose…
- How to Double Space Text in Microsoft Word Step by StepTo double-space text in Microsoft Word, select the text—or press Ctrl+A on Windows or Command+A on Mac to…
- Freeze Data in Excel: Keep Rows and Columns VisibleTo keep headings visible while you scroll in Excel, select the cell just below the rows and to…
- Copy an Entire Excel Spreadsheet to a New FileTo copy an entire Excel spreadsheet into a separate file, open the workbook in Excel for Microsoft 365…
- Excel Keyboard Shortcuts Mouse Pad: Guide to ChoosingAn Excel keyboard shortcuts mouse pad is a physical mouse pad or desk mat printed with a quick-reference…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.