Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesCorporate & AdministrationIT & Asset ManagementIT Budget

SpreadsheetIT & Asset ManagementFree

IT Budget

Plan IT spend by category with capex and opex split, change on last year, run-rate forecast and benchmarks.

Shown with sample data

Colour

IT Budget

Plan IT spend by category with capex and opex split, change on last year, run-rate forecast and benchmarks.

Total IT budget
$2,180,600
Change on last year
19%
Capex share
19%
Forecast vs budget
$15,000
Positive = overspend
IT spend % of revenue
4.5%
IT spend per employee
$6,814
Budget by category
  • Staff$1,022,000
  • Software and SaaS$397,600
  • Hardware$199,000
  • Cloud and hosting$168,000
  • Network and telecoms$162,000
  • Professional services$120,000
  • Security$90,000
  • Training$22,000
Share of IT budget
  • Staff$1,022,00047%
  • Software and SaaS$397,60018%
  • Hardware$199,0009%
  • Cloud and hosting$168,0008%
  • Network and telecoms$162,0007%
  • Professional services$120,0006%
  • Other$112,0005%

How to use it

  1. 1Enter revenue, headcount and months elapsed on the Settings sheet.
  2. 2List every IT cost line with its category and whether it is capex or opex.
  3. 3Enter last year’s actual and this year’s budget, then update Actual YTD each month.
  4. 4Review lines flagged Over budget and explain or act; release underspends early.
  5. 5Use the By category sheet and benchmarks in the budget pack.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

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.

Who it’s for

  • Annual IT budget planning
  • Monthly IT cost reviews with finance
  • Explaining capex vs opex to the board
  • Small businesses taking control of SaaS and cloud spend

What’s included

  • Budget sheet: Every IT cost line for the year.
  • By category sheet: Last year, budget, spend and forecast for each category.
  • Settings sheet: Inputs for the forecast and benchmarks.

How to use it

  1. 1Enter revenue, headcount and months elapsed on the Settings sheet.
  2. 2List every IT cost line with its category and whether it is capex or opex.
  3. 3Enter last year’s actual and this year’s budget, then update Actual YTD each month.
  4. 4Review lines flagged Over budget and explain or act; release underspends early.
  5. 5Use the By category sheet and benchmarks in the budget pack.

Tips

  • Cloud and SaaS are opex and grow with usage. Review them monthly; idle resources and unused licences are the quickest savings.
  • Plan device refresh as a rolling programme (for example a quarter of laptops each year) so capex does not spike every four years.
  • Typical IT spend ranges from about 2% to 7% of revenue depending on industry; compare with peers in your sector rather than an overall average.

Questions

What is the difference between IT capex and opex?

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.

How is the forecast calculated?

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.

What should an IT budget include?

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.

Related searchesit budget templateit budget spreadsheetcapex opex budgettechnology budgetit spending planit cost tracker

Details

Format
Spreadsheet
Category
IT & Asset Management
Sheets
3
Setup
30 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetIT & Asset ManagementFree

IT Budget

Plan IT spend by category with capex and opex split, change on last year, run-rate forecast and benchmarks.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
IT & Asset Management
Sheets
3
Setup
30 min
Level
Intermediate
Price
Free

Your copy is private to you.

More it & asset management templates

View all
IT Asset Inventory3 sheets

Devices in use

9

Due for refresh

4

Out of warranty

8

ABCD
1Asset tagTypeMake and modelSerial number
2IT-001LaptopMacBook Pro 14"C02FX1Z2MD6R
3IT-002LaptopDell Latitude 74407HX92K3
4IT-003MonitorLG 27" 4K405NTPC1A882
5IT-004PhoneiPhone 15F2LXK9P1N7
Assets
SpreadsheetIT & Asset Management

IT Asset Inventory

Every laptop, phone and device with assignee, serial, warranty, age, refresh date and depreciated value, plus counts and spend by type.

10 min setupPreview
Software License Tracker2 sheets

Annual software spend

$20,407

Seat utilisation

80%

Wasted per year

$5,456

ABCD
1SoftwareCategoryOwnerPlan
2Google WorkspaceProductivityITBusiness Standard
3SlackProductivityITPro
4FigmaDesignDesign leadProfessional
5GitHubEngineeringEng leadTeam
Licenses
SpreadsheetIT & Asset Management

Software License Tracker

Every subscription with seats bought and used, utilisation, annual cost, wasted spend, renewal and notice dates, plus spend by category.

10 min setupPreview
IT Help Desk Ticket Log2 sheets

Open tickets

4

Average days to resolve

2

Resolved within target

75%

ABCD
1TicketOpenedRequesterIssue
2T-1041Nov 2Lena ParkLaptop will not charge
3T-1042Nov 2Jordan LeeCannot log in to CRM after password reset
4T-1043Nov 3Grace LimAccounting software licence expired
5T-1044Nov 4Tom ReyesWi-Fi drops in meeting room 2
Tickets
SpreadsheetIT & Asset Management

IT Help Desk Ticket Log

Log support requests with priority and owner, and measure resolution time against your service targets.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ