Create an IT inventory list: What belongs in it

Written by Milutin Jokić | Nov 20, 2026, 2:37:26 PM

Most inventories start out as a spreadsheet. That is perfectly fine. What matters is that the list has the right fields from day one and that someone owns it. Then you always know who has which device and what needs to come back when someone leaves. In this guide we show what belongs in an IT inventory list and how to get started in five steps.

Key points

  • Every device needs at least an asset number, type and model, serial number, assigned person, location and status.
  • Purchase date, purchase price and warranty or lease end help with replacements and budgeting.
  • Decide upfront who adds new devices and who handles returns when someone leaves.
  • A spreadsheet works for a few devices. Once people join and leave regularly or work from home, it quickly gets out of date.

What belongs in an IT inventory list

A hardware inventory does not need many columns. These are enough to start.

  • Asset number. A unique number per device, ideally also on a label on the device.
  • Device type and model. Laptop, monitor, phone or headset, plus the exact model.
  • Serial number. It helps you find the device with the manufacturer, for warranty claims and in your MDM.
  • Assigned person. Who has the device right now? If nobody is listed, it is in storage.
  • Location. Office, home office or storage.
  • Status. In use, in storage, in repair or retired.
  • Purchase date and price. Important for depreciation and replacement planning.
  • Warranty or lease end. So you know in time which devices will need replacing soon.

If you want to track software as well, you need a second list with tool, number of licenses, price, renewal date and notice period. Our 15-minute license check shows how to review licenses without a tool.

How to get started in five steps

  • Define the scope. Only laptops or also phones, monitors, accessories and software? Start small and expand later.
  • Merge existing lists. Old spreadsheets, invoices and exports from Google Workspace, Microsoft Entra or your MDM. They often already hold half the data.
  • Assign devices to people. Who has which device and what is in storage? When in doubt, ask the team.
  • Fill the gaps. Pull what you can automatically via an agent or MDM. Add the rest by hand.
  • Assign responsibilities. Who adds new devices and who handles returns when someone leaves?

Our guide to managing company laptops shows how handovers and returns work day to day.

When a spreadsheet is no longer enough

For a handful of laptops, a well-kept spreadsheet is enough. It reaches its limits as soon as one of these applies.

  • Devices are at people's homes and nobody can see whether they are encrypted and up to date.
  • People join and leave regularly and returns get forgotten.
  • Licenses keep running even though nobody uses them anymore.
  • Several people maintain the list and nobody knows which version is right.

A spreadsheet only shows what someone entered. A tool with an agent or MDM keeps device data up to date on its own. Our comparison of IT inventory software shows which tools exist and what they cost.

With Sovaro you upload your old spreadsheet or take photos of device labels, and AI creates the devices for you. Laptops with the agent then report on their own, with software and security status. 14-day free trial without payment details. Start free trial

FAQ

What information is required in an IT inventory?

At least asset number, device type and model, serial number, assigned person, location and status. Purchase date, purchase price and warranty end are very helpful.

Should monitors and accessories be in the inventory?

Yes, at least everything that should come back when someone leaves. Monitors, docks and headsets are otherwise the easiest to lose.

How often should we review the inventory?

A full stocktake once a year, plus every time someone joins or leaves. With an agent or MDM, device data stays up to date in between.