Skip to content
AMPthilly home
Get started
Checkout & custody

Equipment Sign-Out Sheet Template (Free) and What to Include

A free equipment sign-out sheet template you can copy into Excel or Google Sheets or print as a PDF, a field-by-field guide to every column, how to run it week to week, and when to replace it with a checkout system.

AMPthilly Updated

An equipment sign-out sheet is a running log - on paper, in Excel or in Google Sheets - where borrowers record their name, the item and its asset ID, the date out, the expected return and the date back in.

An equipment sign-out sheet is a running log - on a clipboard, a wall, or a shared spreadsheet - where borrowers record their name, the item taken, the date out, and the date back in. One row per borrowing, kept where the equipment lives, typically at the door of the tool crib or store room. It is the simplest working form of a custody log: cheap, immediate, and good enough right up until the point it quietly stops being filled in.

This page gives you the template itself - the header block and the twelve columns, ready to copy into Excel or Google Sheets or print as a PDF - then explains what each field is for, how to run the sheet week to week, and how to tell when it has stopped keeping up. Call it a tool sign-out sheet, an equipment checkout sheet or an equipment sign-out log; the columns are the same.

What you will learn

A free equipment sign-out sheet template you can copy

The template has two parts: a header block at the top of each page or tab, and one row per borrowing underneath. It works on paper, in Excel or in Google Sheets exactly as shown - no formulas or macros are required, though the spreadsheet section below adds a few that help.

Header block (once per sheet):

  • Organisation and department - “Northside Electrical, Service crew” or “Room 14, Science”.
  • Sheet number - so archived pages sort in order and a missing page is noticed.
  • Date range - the first and last date-out on the page, filled in when the page is retired.
  • Responsible person - the named owner of the weekly review, with a phone number or extension.

Row layout (one row per borrowing):

Date/time outItemAsset ID / serialBorrowerDept / crewExpected returnActual returnCondition outCondition inReceived bySignatureNotes / accessories
08 Sep 06:40Torque wrenchTW-014A. LindqvistCrew 209 Sep09 Sep 16:10GoodGoodM. BergALCalibration due Nov
08 Sep 07:15Cordless drillPD-031J. OkaforSite B12 SepGoodJO2 batteries and charger

Copy the header row into a blank spreadsheet, or print it landscape with fifteen to twenty empty rows per page. The second example row is what an open loan looks like: actual return, condition in and received by are blank until the drill is back. That blank actual-return cell is the whole point of the layout - it is what lets anyone glance down the page and see what is still out.

If you want a printable equipment sign-out sheet PDF, print the spreadsheet to PDF with the header row set to repeat on each page. If twelve columns is too many for your gear, the field-by-field guide says which ones you can drop safely and which you cannot.

Field-by-field: what each column is for

Every column on the template earns its place by settling a specific question later. In order:

  • Date/time out - the date is essential; the time matters where the same item goes out twice in a day. Without it, “expected return” has nothing to count from.
  • Item - a short description in the borrower’s own words, mainly so a row still makes sense if the asset ID is misread. “Cordless drill”, not “tool”.
  • Asset ID / serial - the column that makes the row unambiguous. Two identical torque wrenches with different calibration dates are different items, and only an asset ID or serial number tells them apart. Pre-print IDs where you can, so borrowers tick or copy rather than invent.
  • Borrower - a legible name, not initials shared by three people on the crew.
  • Dept / crew - the column you use to chase. “Site B” or “Year 9 science” tells the reviewer who to phone when the row goes overdue and the borrower is not answering.
  • Expected return - the agreed loan period as a date. This is the column that turns a list into a tool for chasing: without a due date nothing is ever overdue, it is merely “still out”.
  • Actual return - when the item came back. Blank means out. The most-skipped column on most sheets, and the one that makes the sheet believable.
  • Condition out and condition in - two columns, not one, because the dispute is nearly always about pre-existing damage. A drill that went out “Worn” and came back “Worn” is fine; one that went out “Good” and came back “Damaged” is a conversation. A quick phone photo at handover is a good supplement to the written note when the item is valuable; a formal condition report is the extended version.
  • Received by - whoever took the item back and checked it. Without it, a disputed return is one person’s word; with it, two people saw the item arrive.
  • Signature / initials - the acknowledgement that makes the row mean something. It is the borrower accepting responsibility, and on higher-value gear it points to the terms in an equipment loan agreement.
  • Notes / accessories - “with charger and two batteries”, “case, no manual”. This line pays for itself the first time a charger fails to come home, because it turns a partial return from an argument into a fact.

Which can you drop? Time out, dept/crew and received by, if you run a single small room and everyone knows everyone. Which can you not? Asset ID, expected return, actual return and the signature - remove any of those and the sheet stops answering the questions it exists for.

Setting it up in Excel or Google Sheets

A shared spreadsheet adds searchability and a sortable overdue view to the same twelve columns. Five settings turn a plain equipment sign-out sheet template in Excel or Google Sheets into something that runs itself:

  1. Freeze the header row so column names stay visible as the log grows (View > Freeze panes in Excel, View > Freeze > 1 row in Google Sheets).
  2. Add a data-validation dropdown on both condition columns with the same four values - Good, Worn, Damaged, Missing parts. Free text in a condition column is unsortable and, on paper, often illegible.
  3. Format the two return columns as dates so they sort and compare correctly. Mixed “9/9”, “Sept 9” and “Tuesday” entries defeat every rule that follows.
  4. Add a conditional-formatting rule that highlights the row when the actual return cell is blank and the expected return date is before today. That highlighted set is your overdue equipment list, with no manual checking.
  5. Filter on actual return = blank for a live “currently out” view, and either filter by borrower or add a pivot table to see everything one person holds.

Archive by moving completed rows to a per-month tab, or by starting a new tab each month and keeping the old ones read-only. That keeps the working tab short and the history intact.

The trade-off is the same one every shared sheet has: it is searchable and sortable, but someone has to be at a keyboard at the moment of handover. On a site at 6 am, or in the back of a van, nobody is - which is why spreadsheet logs drift out of date the moment gear starts leaving from anywhere other than the room with the computer. Why Excel fails for asset tracking covers the longer version of that failure.

Running the sheet: sign-out, return, weekly review, retention

The template is the easy part; the routine is what keeps it honest. Four steps:

  1. At sign-out the borrower fills in date and time, item, asset ID, their name and crew, the expected return date, condition out and their initials, and lists any accessories. This should take under a minute or it will not happen.
  2. At return whoever receives the item records the actual return date, checks the item against the accessories note, writes the condition in, and adds their own name in received by. The asset return is only complete when that row is closed - an item on the shelf with an open row is still “out” as far as the record is concerned.
  3. Weekly review by one named person: scan for rows with a past expected return and a blank actual return, and chase them by crew or department. Fifteen minutes on a Friday is enough for a single room. If nobody owns this step, the expected-return column is decoration.
  4. Archive the page or tab when it is full, write the date range in the header, and file it. Keep completed sheets for at least a year - longer if your insurer, auditor or a client contract asks for it - because the sheet is the only chain of custody you have when a loss or damage question arrives months after the fact.

Sign-out sheet, checkout form, hand receipt, equipment log - which is which

Searchers use these terms interchangeably; workplaces should not, because each answers a different question.

  • Sign-out sheet - a running, multi-row log of many borrowings. Answers “who has what, and since when?”
  • Equipment checkout form (or tool checkout form) - a per-loan document, usually one page per borrower, with terms, an approval signature and a liability line. Used where the item is valuable or leaves for weeks: a school laptop for the term, a survey instrument, an IT laptop issued to a new hire. Answers “what did the borrower agree to?” The equipment loan agreement is the fuller contract version.
  • Hand receipt - the borrower’s signed acknowledgement of responsibility for specific listed property, common in public bodies and the military. Answers “who is accountable for this item right now?” See hand receipt.
  • Equipment log - a per-item history covering use, maintenance, calibration and repairs across its whole life. Answers “what has happened to this item?” See equipment log.
  • Sign-in sheet - records people arriving, not items leaving. An “equipment sign in sign out sheet” is just a sign-out sheet with the date-in column on the same row.

Underneath all of them is the same check-in / check-out event: an item leaves custody and comes back. The sheet records that event cheaply; the form and the hand receipt attach obligations to it; the equipment log accumulates it over the item’s life.

Variants by workplace

The same twelve columns adapt to most gear with one or two additions. The base sheet works for tools, laptops and keys alike - the asset ID column is what makes it portable - and the extra columns below are the ones each setting tends to need.

  • Tool crib and construction - add site and return-to-yard time; use tool numbers as the asset ID. Rows for hand tools and power tools live or die on the accessories note, because batteries and chargers are what go missing. Construction crews usually run one sheet per yard, not per site.
  • School and classroom device sign-out - student name, device number, a “plugged back in” tick and a fault-noted column. A classroom Chromebook or laptop sheet is often a per-lesson grid rather than a running log, which works because every device comes back within the hour. Schools tend to keep a per-term checkout form for devices going home and a sheet for in-class loans.
  • AV and camera kits - a kit-contents checklist per row: body, lens, two batteries, charger, card, case. AV equipment is where the condition-in column earns its keep.
  • Keys and access cards - key number, the door or area it opens, and a “no copies” line. A key sign-out sheet is the one variant where a blank actual-return cell is a security issue rather than an inconvenience.
  • Lab and medical - add calibration-due date and sterilisation or cleaning status, so an item cannot be signed out past its calibration date without the reviewer noticing. See lab equipment.

Common mistakes that make the sheet worthless

The failure modes are consistent across workplaces, and most are design faults rather than discipline faults:

  • Too many columns. A sheet that asks for supervisor, project code and cost centre gets skipped. Fewer columns, filled in, beat more columns, blank.
  • Illegible handwriting and shared initials. “JS” on a crew with two of them is not a record.
  • No asset IDs pre-printed. Borrowers write “drill” and the row can never be matched to an item.
  • No due date, so nothing is ever overdue - it is just “still out”, indefinitely.
  • Returns not recorded. People sign out conscientiously and return silently, so the sheet shows everything as out, forever, and stops being believed.
  • The sheet stays behind. Gear is loaded at 6 am from the yard; the clipboard is in the office. Concrete equipment that travels site to site rarely passes the sheet on its way out.
  • Nobody owns the weekly review, so the overdue rows are only discovered when someone needs the item.
  • No consequence for skipping it. If a missing row never comes up, the sheet becomes optional within a month.
  • Full pages binned. The history dies with the page, taking the only record of who had the torque wrenches last quarter with it.
  • No view across rows. Answering “what is overdue?” means reading every line of every page - fine for one page, hopeless for twenty.

A sheet that is 80% filled in is not 80% useful - the missing rows are precisely the handovers you will need to reconstruct.

When to move from a sheet to a checkout system

For a small pool of tools behind one door, a disciplined paper sheet is a perfectly respectable system, and far better than nothing. The signals that it has stopped keeping up are practical rather than statistical:

  • Equipment leaves from more than one exit or site, or before the office opens.
  • There are more items than fit on a page, so “what is out right now” means reading every row.
  • Return columns are mostly blank, and people have stopped trusting the sheet.
  • You had a damage dispute you could not settle from the sheet.
  • An audit or insurance question asked who had an item last quarter, and the page was gone.

What an equipment checkout system adds is the same row, captured differently: a live “who has what” list, an overdue view that needs no weekly scan, a permanent per-item history, and condition on return recorded at the moment of handover. Because the record is made by scanning a label on the item itself, it can be made wherever the handover happens - the yard at 6 am, the back of the van - which is the one thing no clipboard or spreadsheet can offer. The market includes options built on barcode or RFID hardware; the simplest route is a printable QR label and the phone camera the borrower already carries, which is how self-service checkout usually works in practice. How to keep track of company tools walks through that move step by step.

Whichever format you run, hold it to the sheet’s original promise: anyone can find out who has the item, without asking around.

FAQ

What should an equipment sign-out sheet include? One row per borrowing, with columns for the date and time out, the item and its asset ID or serial number, the borrower’s name and department or crew, the expected return date, the actual return date, the condition out and condition in, who received the item back, initials or a signature, and a notes column for accessories - “with charger and two batteries” - which prevents the most common dispute, the partial return. If a column is never filled in, drop it; an honest short sheet beats an ignored long one.

What is the difference between an equipment sign-out sheet and an equipment checkout form? A sign-out sheet is a running log: many borrowings, one row each, kept where the equipment lives. An equipment checkout form is a per-loan document, usually one page per borrower, that adds terms, an approval and a liability clause - the format a school lab, an IT department or a construction firm uses for a laptop or a high-value tool. Most workplaces run a sheet for everyday tools and reserve a form for items that leave for weeks or carry real replacement cost.

How do I make an equipment sign-out sheet in Excel or Google Sheets? Put the twelve template columns in row one and freeze that header row. Add a data-validation dropdown for the two condition columns (Good, Worn, Damaged, Missing parts), format the expected and actual return columns as dates, and add a conditional-formatting rule that highlights any row where the actual return is blank and the expected return date is in the past - that is your overdue list. A filter on the actual return column set to “blank” shows everything currently out. No formulas or macros are needed beyond that.

How long should you keep completed equipment sign-out sheets? Keep them for at least a full year after the last row is closed, and longer if your insurer, auditor or a client contract asks for it. The sheet is the only record of who had an item when a damage or loss question arrives months later, so archive completed pages by date range rather than binning them. A digital checkout log keeps this history per item indefinitely, which is one of the main reasons to move off paper.

Should a sign-out sheet require a signature? Yes - initials at minimum. The signature is the acknowledgement that the borrower took the item in the stated condition and accepts responsibility for returning it, which is what turns a row into something you can rely on in a dispute. On higher-value gear the signature usually points to a separate equipment loan agreement or hand receipt that spells out the terms; the sheet records the event, the agreement records the obligation.

What is the difference between a sign-in sheet and a sign-out sheet? A sign-in sheet records people arriving - visitors at reception, attendees at a course. A sign-out sheet records items leaving and coming back. An “equipment sign in sign out sheet” is simply a sign-out sheet with both a date-out and a date-in column on the same row, so the sheet shows the full loop rather than only the departure.

When should you replace a sign-out sheet with software? When the sheet stops being read: you cannot say what is currently out without scanning every row, return columns sit empty, or equipment leaves from places the clipboard is not. Those are scale problems, not discipline problems. A digital checkout gives you a live list of who has what, an overdue view, and a permanent history per item - things no paper sheet can offer however well it is kept.

How do you get people to actually fill in the sheet? Put the sheet physically between the equipment and the door, keep it to the fewest columns that matter, pre-print the asset IDs so borrowers tick rather than write, and have one named person chase gaps weekly. Most unfilled sheets fail on friction, not honesty - if signing out takes longer than taking the tool, the tool wins.

The takeaway

An equipment sign-out sheet is twelve columns and a routine: date out, item, asset ID, borrower, crew, expected return, actual return, condition out and in, received by, signature and accessories, reviewed weekly by one named person and archived for at least a year. Copy the template above onto paper or into a spreadsheet, keep the columns you will actually fill in, and pre-print the asset IDs. When gear starts leaving from places the sheet is not, or the return column goes quiet, the fix is not a stricter sheet - it is making the item carry its own record.

Tools that make this easier

AMPthilly replaces the clipboard with a printable QR label on each item. Scanning the label with a normal phone camera opens the asset in the browser - no app to install - where checking it out records the borrower and due date in one step, and the return captures who brought it back, when, its condition and any notes. The overdue list and “everything checked out per person or department” views replace the weekly scan down the page, and every checkout and return lands in the asset’s permanent audit history. Labels print singly or in batches on sticker sheets or a label printer. Start free - 3 users and 25 assets, no credit card required - or talk to us about a larger rollout.

Free to start, no card required

Put your register to work

AMPthilly gives every asset an owner, a location, and a history - checkouts, printable QR labels, service desk, and audit trail in one place. The free plan covers 3 users and 25 assets, with SSO and MFA included.