Lizzard Solutions

IT Asset Inventory Template: Free Sheet for Small Business

· Lizzard Solutions
IT asset inventoryIT asset managementsmall business ITcybersecurity checklistfree template

By Nemanja Vukmirović, Lizzard Solutions. Last updated 15 November 2026.

A laptop goes missing, an employee leaves, or a ransomware alert pops up, and suddenly someone asks: which devices do we actually have, who uses them, and are they encrypted? In most small companies the honest answer sits in someone's head, an old invoice folder and a few email threads.

This guide gives you a free IT asset inventory template you can copy into Excel or Google Sheets today: 13 columns that matter for security, a filled-in example for a small office, and a simple routine to keep the list current without turning it into a second job.

TL;DR

  • An IT asset inventory is one list of every device, account and key piece of software your business relies on, with an owner and a security status for each.
  • Start with the 13 columns below. Fill the list in one afternoon, then update it at every hire, departure, purchase and disposal.
  • Never put passwords in the inventory. Record whether MFA, encryption and backup are in place, not the secrets themselves.

What is an IT asset inventory template?

An IT asset inventory template is a ready-made spreadsheet structure for recording every piece of hardware, software and cloud account a business uses, together with who owns it, where it is, its warranty and support dates and its security status. It turns scattered knowledge into one list you can check, update and act on.

Security frameworks put this step first for a reason. CIS Control 1 covers the inventory of enterprise assets and CIS Control 2 the inventory of software, and the NIST Cybersecurity Framework 2.0 includes asset management (ID.AM) in its Identify function. You cannot protect, patch or back up a device you do not know exists.

Action for today: create an empty sheet called "IT assets" and share it only with the person who will own it.


The free template: 13 columns that actually matter

Copy these columns as your header row. Each one answers a question you will be asked during an incident, an audit or a staff change.

ColumnWhat to recordWhy it matters
Asset IDYour own short code, e.g. LT-001 for laptops, PH-003 for phones, SaaS-02 for subscriptionsA stable name that survives a change of user or label
TypeLaptop, desktop, phone, router, NAS, printer, software licence, cloud accountLets you filter and spot gaps by category
OwnerThe person responsible for it (for shared kit, the manager)Someone has to answer for it when something goes wrong
LocationOffice, home, server room, or the cloud region for online servicesTells you where to look and what is outside the office
Serial / licence numberManufacturer serial number or licence key reference (not the key itself if it is sensitive)Needed for warranty claims, police reports and insurance
Purchase dateDate on the invoicePlanning replacements and matching with accounting
Warranty / support endHardware warranty end or software end-of-support dateUnsupported systems stop getting security updates
OS / versione.g. Windows 11 23H2, macOS 15, Android 15, router firmware versionShows which devices are behind on updates
EncryptionYes / No / N/A, and the method (BitLocker, FileVault, built-in phone encryption)A lost encrypted laptop is a hardware loss, not a data breach
MFA / accountsMain accounts used on the device or service and whether MFA is onAccounts are the most common way in for attackers
BackupWhat is backed up, where, and the date of the last successful restore testA backup you never tested is a guess
StatusIn use / spare / in repair / lost / retiredKeeps lost and retired items from silently staying active
RetirementDate and method of disposal: wiped, destroyed, sold, returned to lessorProof that data left the building with nothing on it

If you prefer to paste it straight into a spreadsheet, here is the header as a CSV line:

Asset ID,Type,Owner,Location,Serial / licence no.,Purchase date,Warranty / support end,OS / version,Encryption,MFA / accounts,Backup,Status,Retirement

Never store secrets here

The inventory says whether MFA, encryption and backup are on. Passwords, recovery codes and licence keys belong in a password manager, not in a shared spreadsheet.

Action for today: paste the header row into your sheet and freeze it so it stays visible while you scroll.


Worked example: an 8-person office

Hypothetical example for illustration. A small accounting office with eight people, a shared printer, a router, a NAS for backups and a few cloud subscriptions. These are the first rows of its inventory:

IDTypeOwnerLocationOS / versionEncryptionMFA / accountsBackupStatus
LT-001LaptopAna (owner)Office / homeWindows 11BitLocker onMicrosoft 365, MFA onOneDrive + NAS, restore tested OctIn use
LT-002LaptopMarkoOfficeWindows 10NoMicrosoft 365, MFA onOneDrive onlyIn use, replace
PH-001PhoneAnaMobileAndroid 15Built-in, screen lock onAuthenticator appCloud backup onIn use
NAS-01NASOffice managerServer cabinetVendor firmware, check monthlyVolume encryptedAdmin account, MFA onCopy to cloud weeklyIn use
RT-01RouterOffice managerOfficeFirmware from 2022N/ADefault admin password changedConfig exportedUpdate firmware
SaaS-01Accounting softwareAnaCloudVendor-managedVendor-managedPer-user logins, MFA availableVendor + monthly exportIn use
LT-005Laptop(former employee)DrawerWindows 10NoAccounts disabledNoneRetired: wipe pending

Filling the list revealed three things in one afternoon: an unencrypted laptop, a router on old firmware and a retired laptop that still had client files on it. None of that was visible before. That is the real value of the template: the gaps show up as empty or red cells.

Action for today: fill in the rows for your own laptop and phone first. It takes ten minutes and shows you which columns you can't answer yet.


How to fill it in the first time

  1. Walk the office. List every laptop, desktop, phone, printer, router, NAS and screen with a serial number. Check drawers for old devices.
  2. Ask each person what they use for work, including personal phones that receive company email.
  3. Pull the invoices. Purchase dates and warranties come from your accounting records and supplier portals.
  4. Export accounts from admin panels. Microsoft 365 or Google Workspace, your domain registrar, hosting and accounting software all list users and devices.
  5. Mark every unknown in colour. An empty "Encryption" cell is a task, not a failure.

If an outside company manages your IT, ask them for their device list and compare it to yours. Our guide to IT outsourcing for small business explains what a provider should hand over as standard.

Action for today: book one hour this week for the office walk and invoice check.


Keeping your inventory current: a 15-minute routine

An inventory that is six months out of date is almost as risky as none. Tie updates to events you already handle:

TriggerWhat to update
New hireAdd the device and accounts, set owner, confirm encryption and MFA
DepartureChange status, record returned devices and disabled accounts
PurchaseAdd serial, purchase date and warranty end on the day it arrives
Repair or lossChange status; for a lost device, check encryption and revoke its sessions
DisposalRecord the wipe or destruction date and method
MonthlyCheck OS versions and warranty dates; flag anything near end of support
QuarterlyCompare with admin-panel exports and test one backup restore

Departures are where most lists drift. Our employee offboarding IT checklist uses the same owner and status fields, so one update covers both.

Action for today: add a recurring 15-minute calendar reminder on the first Monday of each month.


Turn the inventory into a security to-do list

Once the list exists, sort and filter it. Each filter is a short, concrete task list:

  • Encryption = No: turn on BitLocker or FileVault, starting with laptops that leave the office.
  • MFA off: enable it for email and admin accounts first. See our guide to MFA for small business.
  • Backup empty or untested: set up and test a restore. Our data backup guide for small business covers the 3-2-1 approach.
  • Support end in the past: plan replacement or isolation; unsupported systems no longer receive security fixes.
  • Status = lost or retired but accounts active: revoke sessions and disable access today.

The NCSC Small Business Guide lists the same basics: backups, protecting devices, strong passwords with MFA and keeping software updated. Your inventory tells you exactly where you stand on each.

Don't forget the website: it is an asset too. Add it as a row with hosting, domain expiry and CMS version, and run our free website security check to fill its security status.

Action for today: filter on "Encryption = No" and fix the first device on the list.


Frequently asked questions

What should an IT asset inventory include?

At minimum: a unique asset ID, type, owner, location, serial number, purchase date, warranty or support end, OS version, encryption status, accounts and MFA, backup status, current status and retirement details. Include cloud services and software licences, not just hardware, because many risks now sit in online accounts.

Is Excel good enough for an IT asset inventory?

For most businesses under about twenty people, yes. A shared spreadsheet with restricted access and a clear owner works well. Move to a dedicated asset management or device management tool when manual updates start slipping, or when you need automatic discovery of devices and software versions.

How often should I update the inventory?

Update it on every event that changes it: hires, departures, purchases, repairs, losses and disposals. Then do a short monthly check of OS versions and warranty dates, and a quarterly comparison with admin-panel exports. Event-driven updates keep it accurate without a big annual clean-up.

Should personal devices be in the inventory?

If a personal phone or laptop accesses company email or files, record it with the owner, the accounts it uses and whether it has a screen lock and MFA. You don't need its serial number, but you do need to know it exists so you can remove access when the person leaves.


Next step: from list to protected devices

The IT asset inventory template above takes an afternoon to fill and turns vague worries into a short, ordered task list. Start with your own devices, then the team, then the cloud accounts.

Want help turning your inventory into a security plan?

Send us your filled-in list or tell us about your setup, and we will suggest the first fixes in priority order. The first consultation is free.

Book a free consultation