IT Asset Register

Description:

You cannot secure what you cannot see. Get every IT asset, license, and IP address documented in one workbook.

A comprehensive IT asset management spreadsheet covering hardware assets, software licenses, and network documentation. Pre-configured for SADC and global operations with 24 sites and 17 hardware categories.

6 sheets, 67 formulas, zero errors:

— Hardware Assets: 12 sample assets (servers, switches, firewalls, UPS, access points, NVRs, PCs, laptops, printers) with hostname, IP, MAC, serial number, purchase date, warranty expiry, assigned user, purchase cost, and current value. Warranty expiry highlights in red when expired, yellow when expiring within 90 days. — Software Licenses: 10 sample licenses (Microsoft 365, Windows Server, FortiGate, Veeam, SAP, Meraki, Kaspersky) with license type, quantity tracking, cost per license, total cost, expiry date, and renewal cost. Available licenses auto-calculate. — Network Register: 12 VLANs across 4 sites with subnet, gateway, DHCP range, and purpose — ready for your network documentation. — Dashboard: Total hardware count, total licenses, expiring licenses, expired warranties, total asset value, assets by category, assets by site, license cost summary, annual renewal cost. — Config: 24 SADC and global sites with currencies, 17 hardware categories.

Features: Dropdown validations for category, site, status. Conditional formatting for warranty and license expiry alerts. Auto-filters and frozen panes on all data sheets.

Works in Excel and Google Sheets. Download immediately.

Created by Richard Beukes | GrimmGear tcf.grimmgear.com | richard.grimmgear.com