Equipment Tracking Spreadsheet: Free 2-Tab Template

October 14, 2026 · 10 min read

An equipment tracking spreadsheet works best with two tabs: an Items tab listing everything you own, and a Handouts tab logging every time something goes out. One formula on the Items tab counts what's out and what's available. Another on the Handouts tab marks anything past its due date as overdue. Build it once in Excel or Google Sheets and it does basic tracking for you.

Most equipment spreadsheets fail because they're one big tab. Inventory and movement get mixed together, someone overwrites "Location" with a name, and the list stops meaning anything. Splitting them fixes most of that. This guide gives you the full layout, the formulas, a conditional formatting rule for overdue rows, and an honest look at where a spreadsheet stops being enough.

If you want a printable clipboard version instead, use our equipment sign-out sheet template. This article is the spreadsheet and inventory version.

The equipment tracking spreadsheet layout

Create a new workbook with two tabs named exactly Items and Handouts. The formulas below reference those names.

Tab 1: Items

One row per thing you track. This tab is your equipment inventory spreadsheet. It changes rarely: when you buy something, retire something, or move its home location.

Col	Header	Example	What goes here
A	Item ID	AV-012	Short unique code. Never reuse one.
B	Name	Projector, Epson	What people call it.
C	Type	Unique	`Unique` for one specific thing, `Bulk` for stock
D	Category	AV	For filtering: AV, Tools, IT, Safety, Keys.
E	Serial no.	X4KP-22918	Unique items only.
F	Total qty	1	Always 1 for unique items. 40 for 40 vests.
G	Out	formula	Calculated from Handouts.
H	Available	formula	Total minus out.
I	Home location	Store room B	Where it lives when it's in.
J	Notes	Spare lamp in case	Anything else.

The Type column matters more than it looks. A specific laptop or a key to a specific door is unique: you care which one went out. Hi-vis vests, access cards or extension leads are bulk: you care that 32 of 40 are in, not which 32. Give bulk stock one row with a quantity instead of 40 rows of identical vests.

Tab 2: Handouts

One row every time equipment leaves. Never delete a row here. This tab is the history.

Col	Header	Example	What goes here
A	Handout ID	H-0147	Running number.
B	Date out	2026-10-14	The day it left.
C	Item ID	AV-012	Must match an ID on the Items tab.
D	Item name	formula	Looked up from Items, so nobody retypes it.
E	Qty out	1	1 for unique items, any number for bulk.
F	Client / colleague	Dana Whitfield	A named person, never "the team".
G	Due back	2026-10-17	Always fill this in.
H	Qty returned	0	Update as things come back.
I	Date fully returned	(blank)	Filled when the last piece is back.
J	Status	formula	Out, Partly back, Overdue or Returned.
K	Days overdue	formula	How late it is.
L	Handed out by	Marco	Who gave it out.
M	Notes	Cable + remote	Accessories, condition, anything odd.

Notice that Qty returned is separate from Qty out. That's how the sheet handles a crew that takes five drills and brings back three. You type 3, the row stays open, and the two missing drills stay visible.

The formulas: availability and overdue

Paste these into row 2 and fill down. They work the same in Excel and Google Sheets.

Items tab, column G (Out): how many of this item are currently out.

=SUMIFS(Handouts!E:E, Handouts!C:C, A2) - SUMIFS(Handouts!H:H, Handouts!C:C, A2)

Items tab, column H (Available):

=F2-G2

Handouts tab, column D (Item name):

=IFERROR(VLOOKUP(C2, Items!A:B, 2, FALSE), "Unknown ID")

Handouts tab, column J (Status): the overdue flag.

=IF(C2="", "", IF(H2>=E2, "Returned", IF(G2<TODAY(), "Overdue", IF(H2>0, "Partly back", "Out"))))

Handouts tab, column K (Days overdue):

=IF(J2="Overdue", TODAY()-G2, "")

A one-cell overdue counter for the top of the Items tab, or a small summary tab:

=COUNTIF(Handouts!J:J, "Overdue")

Because the status uses TODAY(), rows flip to "Overdue" on their own the morning after the due date. You don't have to go hunting.

Conditional formatting that makes problems visible

Formulas are useless if nobody looks at them. Two rules make the sheet readable at a glance.

Overdue rows in red. Select A2:M1000 on the Handouts tab. In Google Sheets choose Format, then Conditional formatting, then "Custom formula is". In Excel choose Conditional Formatting, New Rule, "Use a formula to determine which cells to format". Enter =$J2="Overdue" and pick a red fill. The $ locks the column so the whole row turns red.
Negative availability in orange. Select H2:H1000 on the Items tab and use =$H2<0. A negative number means someone logged a handout for stock you don't have, or a return was never recorded. Either way, it's worth a look.

Three small settings that save a lot of mess

Dropdown for Item ID. Use data validation on Handouts column C, with the list taken from Items!A2:A. Typos in IDs are the most common reason availability numbers drift.
Freeze the header row on both tabs so column names stay visible as the sheet grows.
Sort by Status, not by date, when you review. Overdue and Partly back rows float to one place.

That's a working Google Sheets equipment tracker, or an equipment tracking template for Excel if that's where your team lives. For a single store room with a handful of people, it's genuinely enough.

How to run the sheet day to day

The layout is the easy part. Keeping it true is the job.

Log the handout before the item leaves the room. Not at the end of the day, not from memory.
Always set a due date. Without one, nothing is ever late. It's just out, forever.
Record returns as they happen, including partial ones. Update Qty returned, and add the final date only when everything is back.
Check the overdue counter weekly. Anything red gets a message to the person who has it.
Never delete or reuse Handouts rows. If a row was wrong, add a note and a correcting row. The history is the point.

Where an equipment spreadsheet breaks down

A spreadsheet stores what people type into it. Everything that goes wrong comes from that one fact.

Two people edit at once

In a shared Google Sheet, two colleagues handing out gear at the same time can land on the same empty row. One entry overwrites the other, and nobody notices. In an Excel file on a shared drive it's worse: someone has it open, the next person saves a copy, and now there are two versions of the truth.

Every edit erases the previous answer

When someone changes "Qty returned" from 2 to 5, the 2 is gone. Version history exists, but nobody can dig through it to answer "who had projector AV-012 on the 3rd of March, and who handed it to them?" The sheet tells you what it says now, not what happened.

Anyone can overwrite anything

Every person who can log a handout can also edit the formulas, delete a row, or "tidy up" the Items tab. One accidental drag-fill and the availability column is wrong for everything below it. You can protect ranges, but then the people handing gear out can't do their job.

Nobody updates it

This is the one that actually kills spreadsheets. The handout happens in a rush, the laptop with the sheet is across the room, and the row never gets written. Returns are worse, because a returned item feels finished. A spreadsheet that's 90% accurate is a spreadsheet nobody trusts, and a sheet nobody trusts stops being opened.

One shared login hides who did what

To keep the sheet simple, teams often share one account or one file link. Then every entry looks like it came from the same place, and "Handed out by" becomes whatever someone remembered to type. We wrote about this in more detail in why a shared login ruins your sign-out log.

Overdue means a formula, not a follow-up

The red row is a good start. But the sheet can't remind the person who has the gear. Someone still has to open it, read the red rows, look up contact details and send messages. Miss two weeks and late turns into lost. Our guide to overdue equipment tracking covers how to build a chase routine that actually runs.

Spreadsheet vs. equipment tracking software

Task	Equipment tracking spreadsheet	guardable
Live availability	Correct if every row was typed right	Updates the moment gear goes out
Overdue items	Red row, if someone opens the sheet	Flagged automatically, reminder emails can go out
Partial returns	Qty returned column, edited by hand	Tracked per line: return 3 of 5, 2 stay out
History	Overwritten with every edit	Immutable audit trail of who took and returned what, and when
Who did it	Whatever was typed in "Handed out by"	Every action tied to a named user
Several sites	One file each, or one giant file	Separate workspaces with their own roles
Cost of adding colleagues	Free, but often one shared login	Unlimited users on every plan

The model stays the same: items, the people who have them, a due date, and a return. guardable keeps that model and removes the typing-and-hoping part. Items are bulk or unique, just like your Type column. Handouts become orders with a due date. Returns can be full or partial per line, and anything past its due date flags itself on the dashboard, the orders list and the client's page.

When to switch from a spreadsheet

Keep the spreadsheet if all of these are true: fewer than 30 or so items, one location, a small group of people handing things out, and nothing has gone missing lately. A good sheet beats software nobody uses.

Switch when any of these start happening:

You buy replacements because you can't find the originals.
The availability column and the shelf disagree, and you trust the shelf.
More than one person hands gear out at the same time.
Someone spends part of every week chasing overdue items.
You've had a dispute about who had something, and the sheet couldn't settle it.
A second site, store room or team needs its own list.

That's the point where equipment checkout software pays for itself in hours saved alone. If tools are what goes missing most, see our tool checkout system guide for the job-site version.

Frequently asked questions

How do I make an equipment tracking spreadsheet in Excel?

Create two tabs, Items and Handouts. List every item with an ID, type and total quantity on Items. Log each handout with date, item ID, quantity, person and due date on Handouts. Use SUMIFS on Items to calculate what's out and available, and an IF formula with TODAY() on Handouts to flag overdue rows.

Can I use Google Sheets as an equipment tracker?

Yes. The same two-tab layout and formulas work in Google Sheets, and sharing is easier than with an Excel file. The weak spots are the same too: simultaneous edits can overwrite each other, history is hard to read back, and nobody gets reminded about overdue items unless they open the sheet.

What columns should an equipment inventory spreadsheet have?

At minimum: item ID, name, type (unique or bulk), category, serial number, total quantity, quantity out, quantity available and home location. Keep handouts on a separate tab so the inventory list doesn't get overwritten with names and dates.

How do I track overdue equipment in a spreadsheet?

Add a Due back column and a Status formula such as =IF(H2>=E2,"Returned",IF(G2<TODAY(),"Overdue","Out")). Then add a conditional formatting rule that colours the row red when the status is Overdue, and a COUNTIF cell that shows the total at a glance.

Is there free software instead of a spreadsheet?

guardable has a free plan for up to 50 items with unlimited orders and unlimited users, one workspace, no time limit and no credit card. Paid plans are priced per workspace, not per seat: Starter is $39 a month ($33 billed yearly) for up to 250 items, and Pro is $99 a month ($83 yearly) for unlimited items. For keys specifically, we compare every free option in free key tracking software.

Your spreadsheet tells you what someone typed. guardable tells you what's actually out. Start free with up to 50 items, unlimited orders and unlimited users. No credit card, no time limit.