Skip to content
IT Asset Inventory cover: a sample sheet with devices on the register, in use and spare and a bar chart, beside the Dashboard, Assets and Licences tabs

IT Asset Inventory

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

This template is for an IT team or office manager who keeps a register of company devices and software. The Assets tab lists each device with its tag, type, model, owner, department, purchase date, warranty end date, cost and status. The Licences tab records seats bought, seats in use, free seats, renewal date and annual cost for each product, and flags any product where more seats are in use than were bought. The Dashboard counts devices by type and by status.

Give every device a tag before it goes out, and write the tag on the device itself. Update the status when a device changes hands, goes to repair or is retired, so the counts stay correct. Check the Licences tab before each renewal, because an over-used product shows negative free seats. Keep warranty dates in the register so you can see which devices are still covered when one fails.

Useful for

  • Tracking laptops and monitors for a team of staff
  • Knowing which warranties end in the next quarter
  • Checking licence seats before a software renewal

What's included

  • 4 tabs: Dashboard, Assets, Licences, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Assets: a table
  • Licences: a table
  • 2 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 Assets 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

How do I record a device that moves to a new person?

Change the Assigned to and Department cells on that row, and keep the asset tag the same so the record follows the device. If you need the previous owner for your records, add a note in a spare column or keep a separate handover log.

What does a negative number of free seats mean?

It means more people or machines are using the product than the licence allows. Either buy extra seats, remove some users, or check whether the vendor's terms allow a higher count. Confirm the rules with the vendor before you change the sheet.

Can I track devices that are not owned by the company?

The register works for any device the team manages. Use the Department column and a note to mark personal devices that are enrolled for work. Check your device policy before storing personal device details in a shared file.

  • #inventory
  • #it-asset-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…