IT Asset & Inventory Tracker (Pro) — Excel + Google Sheets
Know what you own, what it's worth, and what needs attention — without buying MSP software.A ready-to-use IT asset register for a small business. Track every laptop, server, license, phone, and piece of equipment in one workbook — with automatic depreciation, warranty alerts, renewal calendar, chain-of-custody log, and a live dashboard.Works in Microsoft Excel and Google Sheets. No formulas to write — just type in the white cells; the grey columns fill themselves in.— WHAT'S INSIDE —• 500-row Asset Register — 23 columns for hardware and software assets• Live Dashboard — 12 KPIs, 2 charts, updates as you add assets• Automatic depreciation — straight-line, plus current book value• Warranty alerts — Active / Expiring (90 days) / Expired flags on every asset• Software Licenses tab — 100 rows with seat tracking + renewal urgency• Warranty & Renewals calendar — auto-populated combined view• Assignments log — chain-of-custody audit trail• Physical Inventory audit — printable annual walk-around checklist• People + Vendors + Lists — editable reference tabs• 10-page PDF quick-start guide — illustrated setup + depreciation explainer— WHO THIS IS FOR —Small business owners, office managers, and IT generalists at 5-to-50-person companies who are tracking laptops, licenses, and warranty dates in scattered spreadsheets — or nothing at all — and want one workbook that does it right.Use it for insurance-claim evidence, annual IT refresh budgeting, audit prep, license-renewal discipline, and business-continuity readiness.— FILE FORMATS —One .xlsx workbook (10 tabs, opens in Excel + Google Sheets), one 10-page .pdf quick-start guide, one README. Delivered as a .zip — instant download.— GOOGLE SHEETS NOTE —Formulas, charts, freeze panes, and cell formats all survive an upload to Google Sheets. Data-validation dropdowns may need to be re-applied inside Sheets — the PDF guide walks through it in 4 steps.— UPDATES —Gumroad customers get free access to all 2026.x updates. Suggestions and bug reports welcome — reply to your receipt.— LICENSE —Personal / single-business use. Use the template for your own business, your employer, or a client. Reselling the template is not permitted.Made by Veteran Forge Strategies — a veteran-owned firm working with small businesses on IT operations, cybersecurity, and federal contracting.
Get it → veteranforge4.gumroad.com