Know how many garments each person still holds after partial returns and size exchanges. Use a linked movement log and balance sheet instead of treating every signed receipt as a closed record.
A uniform issue and return register should answer a practical question: how many of each issued garment are still with this wearer? A receipt saying “three shirts issued” cannot answer that after one shirt comes back, another is exchanged for a larger size, and the final shirt is returned at a different site.
This copy-ready resource is for ordinary reusable work clothing managed by a workplace, stores or service-operations team. It is not a protective-equipment inspection record, hygiene protocol, employment agreement or payroll authorization. All control rules and review timings below are recommended operating choices to adapt to your organization.
Copy the register into two linked sheets
Create a Movements sheet with one row per garment type, size and transaction. Create a Balances sheet with one row per issue lot. An issue lot is a specific issue of a particular style and size to one wearer. A later top-up gets a new lot, even if it contains identical shirts. This preserves the original issue date and return obligation.
Keep a small controlled item list, such as POLO-NAVY / size M / unit each. Do not combine different sizes or styles in a “uniform set” unless you also record every component separately. Serialized garments can have one-unit lots; unnumbered garments can use quantity lots.
Sheet 1: movement columns and rules
| Column | Field | Entry and validation |
|---|---|---|
| A | Movement ID | Required unique text, never reused; for example UM-001. |
| B | Event date/time | Required actual handoff time, with one agreed site time zone. |
| C | Issue lot ID | Required existing balance-row ID. New issues create a new lot first. |
| D | Wearer ID | Required internal employee or worker ID; match the lot. Keep names in the restricted balance sheet. |
| E–G | Item code, size, site | Required controlled values; code and size must match the lot. Site records where the handoff happened. |
| H | Movement type | Issue, Return, Approved loss, or Reversal. Use the separate reason field for size exchange, wear, departure or correction. |
| I | Quantity | Required positive whole number; no negative input or fractions. |
| J | Balance effect | Calculated: Issue adds quantity; Return and Approved loss subtract it. Reversal negates the referenced original row’s effect. |
| K | Related movement / exchange ID | Required for reversals and exchanges. A reversal references one movement; an exchange code joins the old-size return and new-size issue. |
| L–M | Condition and disposition | Issue: new or serviceable. Return: serviceable, needs assessment or damaged; disposition: inspection, laundry, repair or approved restock. A return is not automatic permission to reissue. |
| N–O | Reason and evidence reference | Required brief reason and durable receipt or acknowledgment reference. Do not put medical or unrelated personal details in notes. |
| P–Q | Processed by; review reference | Named issuer/receiver and timestamped verification. Loss and corrections require the accountable manager’s approval reference. |
For ordinary rows, spreadsheet column J can use =IF(H2="Issue",I2,IF(OR(H2="Return",H2="Approved loss"),-I2,"")). A Reversal intentionally stays blank until a reviewer enters the opposite of the original row’s J value and verifies the linked movement. Treat a blank effect on a posted row as a blocking error, not zero.
Sheet 2: issue-lot balances
| Column | Field | Entry and validation |
|---|---|---|
| A–E | Lot ID, wearer ID, wearer name, item code, size | Unique lot ID; one wearer/style/size per lot. Match every linked movement. |
| F–H | Issue date, return trigger, due date | Return trigger: dated loan, role change, departure or manager request. A dated loan needs an agreed due date; other issues remain open until the trigger sets a date. |
| I | Outstanding quantity | Calculated net of all posted movement effects for this lot. Must never be negative. |
| J | Exception flag | None, disputed count, missing evidence, loss review or correction review. A non-None flag prevents closure. |
| K–M | Owner, next review date, closure reference | Named stores coordinator; next action date for open exceptions; closure reference only after reconciliation. |
In I2 use =SUMIF(Movements!C:C,A2,Movements!J:J), then copy down. This formula assumes all movement rows are posted, validated entries; keep unapproved entries on a separate pending sheet. Do not mix proposals into the posted ledger. For large files, use bounded ranges or your spreadsheet’s table references.
Derive the review status in this order: negative balance or an incomplete posted movement = Blocked; any exception flag = Review; zero balance with complete evidence = Ready to close; positive balance past its agreed due date = Overdue; otherwise = Open. “Closed” requires the coordinator’s dated reconciliation reference, not just a formula.
A worked size exchange and partial return
The following example is fictional. Wearer W-42 receives three medium polos in lot UL-001. They later return one, exchange a second for a large polo, and eventually return the last medium. The large polo remains with them.
| Movement | Lot / size | Type and quantity | Effect | Reason / link | Lot balance after event |
|---|---|---|---|---|---|
| UM-001 | UL-001 / M | Issue 3 | +3 | Initial issue; receipt R-001 | 3 |
| UM-002 | UL-001 / M | Return 1 | −1 | Partial return; R-002 | 2 |
| UM-003 | UL-001 / M | Return 1 | −1 | Size exchange EX-01; R-003 | 1 |
| UM-004 | UL-002 / L | Issue 1 | +1 | Size exchange EX-01; R-003 | 1 in UL-002 |
| UM-005 | UL-001 / M | Return 1 | −1 | Role change; R-004 | 0 in UL-001 |
UL-001 reconciles as 3 − 1 − 1 − 1 = 0. UL-002 remains 1. Across both lots, four garments were issued and three returned, leaving one with W-42. Closing the original lot must not close the replacement lot. Store actual dates, processor names, condition and review references in the full sheets even though this compact example omits those columns.
Record the handoff, then reconcile the obligation
- Before issue: the coordinator confirms the approved wearer, correct style/size, actual stock and return trigger. If approval or stock is missing, keep the request pending; do not post an issue.
- At handoff: the issuer and wearer count the garments together, record condition and acknowledge the movement. Give the wearer a copy or accessible reference. Use an asset handover form for the transfer acknowledgment, linked to the movement rather than substituted for the balance record.
- At return: the receiver counts what physically arrived against the original lot, records condition and signs the receipt. The University of New Mexico’s uniform return receipt illustrates quantity and receiving-signature fields; it is one institution’s form, not a universal rule.
- At reconciliation: the coordinator compares issue effects, return effects and approved adjustments. Zero with missing evidence stays in Review. Positive quantities remain open, even if the employment or assignment record has ended.
Acknowledgment text to adapt
I confirm the quantities and garment descriptions recorded for this handoff, subject to the exceptions written on this record. I have received a copy or reference. This acknowledgment records receipt or return only; it does not authorize a wage deduction or settle a disputed charge.
Add movement IDs, both participants’ names, date/time and any disagreement. If someone will not acknowledge the count, retain the receiver’s factual record and route the dispute to the manager; do not represent an unsigned record as agreed.
Exceptions that must remain visible
- Partial return: subtract only the counted units. The coordinator records the remaining quantity, agreed next action and review date. Never mark the whole lot returned.
- Exchange without an immediate return: create the new issue lot and keep the old lot open. Link both to the exchange reference. Record the manager’s approval if your policy allows a replacement before recovery.
- Return at another site: the receiving coordinator records the physical handoff against the original lot and sends the receipt reference to its owner. Do not post another return when the garment later reaches the central store; that is an internal stock transfer, not a second wearer return.
- Loss or unresolved shortage: keep the balance outstanding during investigation. Only an authorized manager’s documented loss disposition permits an Approved loss movement. This resolves custody accounting, not recovery of money.
- Wrong lot or quantity: preserve the original row. Post a reviewed reversal referencing it, then a corrected movement. Reverse a row at most once; a reversal cannot itself be reversed under this simple design. Escalate more complex corrections for controlled reconciliation.
- Damaged return: reduce wearer custody when physically received, but record the garment’s separate inspection/disposition. An unserviceable return must not silently increase available stock.
A practical starting cadence is a coordinator review each working day for due returns and exceptions, with unresolved discrepancies escalated to the manager by the next working day. These are suggested service targets, not legal deadlines. Assign a backup reviewer and record the next action whenever the owner is absent.
Keep charges and garment balances separate
Do not add automatic replacement charges or payroll instructions to this template. In the United States, the Department of Labor’s Fact Sheet 16 explains federal minimum-wage and overtime limits on employee-borne uniform costs. Applicable rules and authorization requirements need separate review by HR, payroll or counsel. A missing shirt and a lawful financial recovery are different decisions.
Limit access to people who issue, receive or reconcile garments. Set your organization’s retention and access rules separately. The register needs an internal wearer identifier and operational evidence—not home addresses, identity documents or sensitive explanations for a size change.
Where Workhint fits
The sheets work without a software purchase. If requests and exception reviews cross teams, Workhint’s Workflow Engine describes routing requests and approvals to defined roles and requiring details or files before work proceeds. Those are relevant building blocks for issue approval and disputed-return review.
The workflow automation software solution describes structured forms, conditional routing, assigned owners and review stages. A useful configuration discussion would cover the wearer request, stores verification, missing-receipt exception and manager decision. Verify how balances would be calculated and reconciled before implementation; these pages do not establish a native garment-inventory module, laundry integration or payroll deduction function.
Questions before you roll it out
Can one row track an entire uniform set?
Only if components never need separate returns or exchanges. Otherwise record each style and size separately. Returning one shirt must not clear trousers that remain outstanding.
Does an approved loss count as a physical return?
No. It reduces the unresolved custody obligation after a documented decision. Report returned quantities and approved losses separately so the summary does not overstate recovery.
Should routine laundry exchanges use this register?
This design tracks issue custody and final returns. If your operation transfers garments through a laundry service, add a separate controlled laundry-movement process; do not treat a laundry handoff as a final wearer return without defining the custody boundary.
Check a small batch before using it at scale
Test one ordinary issue, one partial return, one size exchange and one correction. Confirm that every movement has evidence, no lot goes negative, and closing one lot leaves other open lots unchanged. Start with a small verified balance list rather than importing uncertain quantities as if they were established facts.

Leave a Reply