Skip to content
Tool Inventory and Checkout cover: a sample sheet with tools owned, checked out now and in repair and a column chart, beside the Dashboard and Tools tabs

Tool Inventory and Checkout

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

Tradespeople, workshop managers and facilities teams use this workbook to keep track of power tools, hand tools, measuring kit and safety gear. The Tools tab lists every item by ID, type, usual location, status and replacement value. The Checkouts tab records each loan, fills in the tool name from its ID and shows whether a loan is Out, Overdue or Back. The Dashboard counts tools by status and type.

When a tool leaves or returns, add or close the loan on the Checkouts tab and change the status on the Tools tab to match, since the two tabs do not update each other. Check the Overdue count at the start of each day and follow up before the end of the working day. Mark anything damaged as Repair straight away, so it never goes out on a job.

Useful for

  • Keeping track of which van carries which tools
  • Chasing tools that have not come back from a job
  • Checking the replacement value of kit before an insurance review

What's included

  • 4 tabs: Dashboard, Tools, Checkouts, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Tools: a table
  • Checkouts: a table
  • 3 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Tools tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Where does a newly bought drill or saw go?

Type a new ID, the tool name, its type, usual location, status and replacement value on the first empty row of the Tools tab. The dropdowns already hold the standard types and locations. Use one ID pattern, such as TL-0111, so the lookup on the Checkouts tab keeps working.

Why is the tool name blank on a checkout?

The name fills in only when the Tool ID exactly matches an ID on the Tools tab. Check for a typo, an extra space or a missing row, then type the ID again. A blank name means the ID is not on the list.

How can I see which loans are late?

Enter the due date on each loan. The State column reads Overdue once the due date has passed and nothing is in the Returned column. The loans chart on the Dashboard counts these alongside the loans still out.

  • #inventory
  • #tool-inventory
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More inventory templates

See all 19

Also in Business operations

All business operations templates
Get this template

Preparing your template…