How to Create an Equipment Checkout Log in Excel (Free Template)

Every shared gear closet needs a record of what left the building. If your team is small and your gear list is short, you do not need software for that — a well-built Excel sheet does the job. The trouble is that most checkout spreadsheets are built in a hurry: no consistent item IDs, a free-text "status" column with six spellings of "returned," and no way to see what is overdue without reading every row.

This guide builds the log properly in about fifteen minutes: a clean column layout, a dropdown status field, and conditional formatting that flags overdue items automatically. If you would rather not build it yourself, the free template below includes three tabs, sample rows, status dropdowns, and overdue-formatting rules. Before relying on it, check the conditional-formatting rule order and enable the Stop error alert using Steps 3–4 below. The downloadable workbook does not have those safeguards fully configured. No email required.

Need a blank clipboard sheet rather than a running spreadsheet? Use our equipment sign out sheet generator to choose borrower, due-date and return columns, then print it without setting up a roster. Keep the Excel workbook below for a searchable digital log with overdue highlighting.

Prefer collecting separate submissions instead of editing workbook rows? Our equipment checkout with Google Forms guide explains how to match each return to a loan ID. The spreadsheet remains a coordinator-maintained ledger, not an automatic response reconciler.

Download the free template

The template has three tabs: a Checkout Log with status dropdowns and automatic overdue highlighting, an Item List for your inventory with IDs and serial numbers, and a one-page How to Use tab. Delete the sample rows and it is ready for your gear.

This workbook records equipment custody; it does not check future reservation overlaps. If customers book ahead, learn how to prevent double bookings in equipment rentals and keep a reservation register alongside the checkout log, including turnaround time before the next pickup.

Step 1: Set up the columns

Open a blank workbook, name the first sheet "Checkout Log," and put these nine headers in row 1:

• Date Out — when the item left. Format the column as a date (Home → Number Format → Short Date).
• Item ID — a short code like CAM-014 or AUD-001. IDs beat names because you can have six identical mics.
• Item Name — the human-readable name ("Sony FX3 Cinema Camera").
• Borrowed By — one accountable person, not a team. "Youth Ministry" is how gear disappears; a name is how it comes back.
• Contact — email or phone, so a reminder does not require detective work.
• Due Date — every checkout gets one. An open-ended loan is a donation.
• Date Returned — blank until the item is back. This blank cell is what drives the overdue flag.
• Status — Checked Out, Returned, Overdue, or Damaged (dropdown in Step 3).
• Condition Notes — what shape it came back in ("returned clean, all cables," "bodypack antenna bent").

Step 2: Freeze the header and format as a table

Click row 2, then View → Freeze Panes → Freeze Top Row, so the headers stay visible as the log grows. Then select your header row and a few empty rows below it, press Ctrl+T (Cmd+T on Mac), and tick "My table has headers." Formatting as a table gives you filter arrows on every column for free — which is how you will later answer "what is still out?" in two clicks (filter Date Returned to blanks, then check rows with a recorded checkout date and borrower).

While you are here, widen the Item Name and Condition Notes columns so entries do not truncate. Cosmetic, but a log people can read is a log people keep using.

Step 3: Add the status dropdown with Data Validation

Free-text status columns rot fast: "returned," "Returned," "back," "done" — and suddenly your filters miss half the rows. Lock it down with a dropdown:

• Select the Status column cells (H2 down as far as you like, e.g. H2:H500).
• Go to Data → Data Validation.
• Under Allow, choose "List."
• In Source, type: Checked Out,Returned,Overdue,Damaged
• Open the Error Alert tab, enable “Show error alert after invalid data is entered,” and choose the Stop style. Then click OK. The dropdown offers the four listed statuses, and the Stop alert blocks invalid values typed directly into those cells. Data validation does not guarantee that every pasted or imported value will be rejected, so check the Status column after bulk changes.

Step 4: Make overdue rows highlight themselves

This is the feature that turns the sheet from a list into a system. One conditional-formatting rule flags any row where the due date has passed and Date Returned is still blank:

• Select your data range, e.g. A2:I500.
• Go to Home → Conditional Formatting → New Rule → "Use a formula to determine which cells to format."
• Enter this formula: =AND($F2<>"", $F2<TODAY(), $G2="")
• Click Format, pick a red fill, and OK. (F is Due Date, G is Date Returned — adjust if your columns differ.)
• Optional: add two more rules — =$H2="Checked Out" with an amber fill and =$H2="Returned" with a green fill. Then open Home → Conditional Formatting → Manage Rules and place the overdue red rule above both status-colour rules. Rule order matters when conditions overlap: a loan can still say Checked Out after its due date has passed. Check the downloaded workbook's rule order too, so overdue rows are not shown in amber instead of red.

Step 5: Add an Item List tab

Keep your inventory on a second sheet so the log references stable IDs. Columns: Item ID, Item Name, Category, Serial Number, Home Location, Condition, Replacement Value. This is the tab insurance will ask for after a break-in, and it is where the fifty-dollar rule lives: anything over about $50 to replace gets a row and a serial number; cheap commodity items (cables, adapters) get counted by quantity instead. When it comes time to verify this list against reality, our inventory audit checklist walks the full count process.

If you would rather start from a ready-made file, the free tools & equipment inventory log generator builds this exact tab for you: pick your columns, download the CSV, or print a blank sheet to fill in by hand.

If you have not inventoried your gear yet, our church equipment inventory checklist walks the whole building area by area — the output of that walkthrough is exactly this tab.

How to run the log day to day

The routine: when gear leaves, add a row with date, item, name, and due date, and set status to Checked Out. When it comes back, fill Date Returned, flip the status, and jot a condition note if anything changed. Once a week, filter Date Returned to blanks and check rows with a recorded checkout date and borrower. This includes loans marked Checked Out or Overdue that have not been recorded as returned. Review their due dates and follow up on anything late. Keep the Status field accurate as you record returns and condition changes. Sound teams have a few extra wrinkles (wireless kits, cases, consumables) — our guide on how to keep track of church sound equipment covers those.

Two habits keep the sheet honest: log at the moment of handoff (not "later"), and never lend to a group — always a named person with a contact.

Using the same sheet as a tool checkout log

The nine columns above were written with AV and church gear in mind, but the same workbook is a solid tool checkout log for a shop, a maintenance department, a school workshop, or a small crew. Tools add three wrinkles: they travel to job sites, cordless tools come as kits (drill, two batteries, charger, case), and damage is often found days later by the next person. Keep the nine columns and change or add these:

• Item ID → Tool ID with a prefix per type: DRL-004, SAW-002, LAS-001. Paint-pen or label the same code on the tool so the row and the tool always match.
• Serial Number on the Item List tab, for anything theft-prone (cordless saws, nail guns, lasers, compressors). It is what a police report and an insurance claim will ask for.
• Job Site or Location — a new column after Borrowed By. "Out" is not enough for tools; "out at the Main St. remodel" tells you where to go and get it.
• Kit Contents — a new column listing everything that left with it: "drill + 2×5Ah batteries + charger + case." Most lost cordless value is the batteries, not the tool.
• Condition Out and Condition In instead of one Condition Notes column, so a cracked guard or missing blade shows up against the person who had it.

A worked tool checkout log example

Here is what three rows look like on a busy morning for a five-person maintenance crew. Each row reads left to right as: date out · tool ID · tool · borrowed by · job site · kit contents · due date · date returned · status.

• Sep 8 · DRL-004 · 18V hammer drill · Marcus Lee · Main St. remodel · drill, 2 batteries, charger, case · Sep 10 · Sep 10 · Returned (condition in: "one battery won't hold charge")
• Sep 9 · SAW-002 · 7¼" circular saw · Dana Ruiz · Warehouse shelving · saw, blade guard, spare blade · Sep 9 · (blank) · Overdue — row turns red the next morning
• Sep 9 · LAS-001 · Cross-line laser level · Marcus Lee · Main St. remodel · laser, tripod, case · Sep 12 · (blank) · Checked Out

Two things this example shows. First, the Overdue row is found by the conditional-formatting rule from Step 4, not by someone reading the whole sheet. Second, the battery note on the returned drill is the kind of detail that disappears without a Condition In column — and it explains the "missing" battery three weeks later.

If you are a solo tradesperson rather than a crew, the log is only one part of the job; our guide on how to keep track of tools as a handyman covers the truck layout, daily close-out, and theft-recovery side.

People search for this under several names — tool checkout sheet, tool checkout list, tool inventory log. They are the same thing: an Item List of what you own plus a log of who has it now. This workbook is both.

Where the spreadsheet breaks

Built like this, an Excel log genuinely works — for a small closet with one careful owner. But it has a structural weakness no formula fixes: the log lives on a computer, and checkouts happen at a shelf, in a hallway, at 7am while the van is loading. Every checkout that happens away from the sheet is a row someone has to remember to add later. By the second busy weekend, the sheet and the shelf disagree, and a log nobody trusts is a log nobody updates.

The fix is moving the record onto the gear itself. That is what we built WhoHasGear for: print a QR label for each item on ordinary Avery sheets, and borrowers check gear in and out by pointing any phone camera at the label — name, due date, done, in about twelve seconds. No app for borrowers, overdue items flagged on your dashboard instead of a weekly filter-and-chase, and a permanent custody history per item. Free for your first 5 items, then $1 opens everything for 7 days — and this spreadsheet is a fine way to run things until then.

Common questions

Can I use Google Sheets instead of Excel? Yes — every step translates. Data → Data validation for the dropdown, and Format → Conditional formatting with the same =AND($F2<>"", $F2<TODAY(), $G2="") custom formula. Sheets has one real advantage: it is shareable by link, so the log can live on the phone that is standing at the shelf.

How do I see everything currently checked out? Filter Date Returned to blanks, then review rows that have a checkout date and borrower. That captures equipment still out even when its Status has changed from Checked Out to Overdue. Do not filter only to Checked Out, because that excludes overdue loans recorded under their own status.

Can I use this template as a tool checkout log? Yes. Rename Item ID to Tool ID, add Job Site and Kit Contents columns, and split Condition Notes into Condition Out and Condition In. The status dropdown and overdue formula work unchanged.

How do I track tool batteries and chargers? Either list them in the Kit Contents column of the tool they leave with, or give each battery its own ID (BAT-01, BAT-02) and log it as a separate row if batteries are swapped between tools.

Should I make one log per ministry or team? No — one log, one Item List. Split logs are how the same projector ends up "available" in two places. Use a Category column and filters instead.

When should I move off the spreadsheet? When you pass roughly 25 tracked items, when more than one person needs to update it, or when you catch the sheet disagreeing with the shelf. Those are the three signs the update-at-the-shelf problem has outgrown manual logging.