InkSheet Studio
Tool & Equipment Check-Out Tracker Spreadsheet | Crew Tool Log, Overdue Chase Board — Google Sheets
Tool & Equipment Check-Out Tracker Spreadsheet | Crew Tool Log, Overdue Chase Board — Google Sheets
Couldn't load pickup availability
INSTANT DOWNLOAD — HOW IT WORKS: This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.
Stop asking "who's got the rotary hammer?"
Every shop knows the moment: a crew is standing around, a job is waiting, and one tool is simply... out. With who? At which site? Since when — and when was it supposed to come back? This tracker answers all of it, for YOUR tools out with YOUR crews: one roster, one check-out log, and an Overdue Board that rebuilds itself every morning into the only list a foreman really needs — who to chase.
Log each trip out in one row — tool, crew member, job site, due date — and log it back in when it returns. The roster updates itself: every tool shows Checked Out (with the person, the site, and the days out), Available, or In Service. And because tools that never get serviced fail on site, the roster also flags SERVICE OVERDUE and SERVICE DUE SOON from each tool's next service date.
Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.
WHAT'S INSIDE — 7 focused tabs:
- Start Here — a plain-English guide and quick-start steps
- Dashboard — the yard at a glance: tools out right now, overdue count, due back today, service flags, your fleet's total value, and the dollar value sitting out on job sites
- Tool Roster — your fleet: asset ID, category, serial number, condition, purchase cost, and next service-due date — with live status, who has it now, and which site it's on
- Check-Out Log — one row per trip: out date, tool, crew member, job site, due date, in date, and the condition it left and returned in. Status and days late are automatic
- Overdue Board — the who-to-chase list: every tool still out past its due date, auto-ranked by days late, with the crew member and job site attached
- Service & Repair Log — every service, repair, inspection and calibration, with what it cost
- Settings — your crew list, job sites, tool categories, and the service due-soon window
HOW IT WORKS
1. After checkout you get a PDF with your private link. Click it and choose "Make a copy" — the tracker is yours.
2. Load your roster once: tools, asset IDs, serials, service dates. Add your crew and job sites on Settings.
3. Log each trip out and back in. The Overdue Board, the roster status and the Dashboard keep themselves current — you just work the chase list.
HOW THE FLAGS WORK, IN PLAIN ENGLISH
A log row with no In Date is still out. Once today passes its due date, that tool appears on the Overdue Board, ranked by days late — worst at the top. Service flags read each tool's Next Service Due date on the roster: SERVICE OVERDUE once it passes, SERVICE DUE SOON inside your window (starts at 30 days — change it on Settings). Need a tool off the board? Mark it In Service or Retired in the roster's Hold Note column and its status follows.
WHY THIS ONE
Plenty of spreadsheets count tools sitting on shelves. This one tracks custody — tools in motion, in your crews' hands, on real job sites — because that's where tools actually get lost. It comes loaded with a fictional sample shop (14 tools, 6 crew members, 6 job sites, 20 trips logged) so you can watch the chase board and the service flags work: in the sample, 8 tools are out and $5,609 of gear is sitting on job sites. Replace the samples with your own fleet and go.
ONE THING IT IS NOT
This is an internal crew-custody tracker — your tools, your crews. It is not a customer rental system: no bookings, no deposits, no availability calendar. (Renting gear out to customers? That's a different workflow — and a different listing in this shop.)
REQUIREMENTS: a free Google account. Your tracker lives in Google Sheets — no Excel needed, and it works at the shop, on site, and on your phone.
This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.
FINISHED FILE — PLEASE READ: This listing is for the finished file exactly as shown — nothing is customized, personalized or revised. If anything prints wrong or you find an error in a file, message us and we will fix it — error fixes are always free, with no time limit.
Share
