Devices in use
9
Due for refresh
4
Out of warranty
8
IT Asset Inventory
Every laptop, phone and device with assignee, serial, warranty, age, refresh date and depreciated value, plus counts and spend by type.
SpreadsheetIT & Asset ManagementFree
Plan IT spend by category with capex and opex split, change on last year, run-rate forecast and benchmarks.
Shown with sample data
Plan IT spend by category with capex and opex split, change on last year, run-rate forecast and benchmarks.
Defend the IT budget with facts. Each line records last year’s actual, this year’s budget, capex or opex treatment and spend to date; the sheet calculates the change on last year, a run-rate forecast to year end and a status for every line, then totals by category and shows IT spend as a share of revenue and per employee, the two benchmarks boards ask for.
Capital expenditure (capex) buys assets that last more than a year, such as hardware or capitalised implementation work, and is depreciated. Operating expenditure (opex) covers running costs such as subscriptions, cloud, support and salaries, expensed in the year. Capitalisation rules vary by accounting standard and company policy.
For opex lines, actual spend to date is projected at the same monthly rate to year end. For capex lines, the forecast is the budget, or actual spend if that is already higher.
Staff and contractors, hardware, software and SaaS, cloud and hosting, network and telecoms, security, professional services and training. Include a contingency line of 5–10% for unplanned work.
Download a copy
Downloads need a free account.