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

SpreadsheetIT & Asset ManagementFree

IT Asset Inventory

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

Shown with sample data

Colour

IT Asset Inventory

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

Devices in use
9
Due for refresh
4
Overdue or within 6 months
Out of warranty
8
Current value
$3,486
Current value by type
  • Laptop$2,35367%
  • Phone$56116%
  • Monitor$38711%
  • Tablet$1695%
  • Network$160%
Devices in use by type
  • Laptop3
  • Monitor2
  • Phone1
  • Tablet1
  • Printer1
  • Network1

How to use it

  1. 1Tag every device and record make, model and serial number.
  2. 2Set each device's status (In use, Spare, In repair, Retired) and who or where it is assigned to.
  3. 3Set the useful life for each device type on the Settings sheet.
  4. 4Check Refresh and Warranty each quarter and budget for replacements.

In this workbook

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

About this template

Know who has which device and when it needs replacing. Record each asset with type, model, serial number, assignee, status, purchase date, cost and warranty end; the inventory works out its age, warranty status, when it is due for refresh based on the useful life you set for each type, and its current value using straight-line depreciation. A summary by type shows how many devices you have in use, spare and in repair, and what they are worth.

Who it’s for

  • Onboarding and offboarding equipment
  • Insurance, audit and security records
  • Planning hardware refresh budgets

What’s included

  • Assets sheet: Every device with owner, warranty, refresh date and value.
  • By type sheet: Device counts, refresh needs and value by type.
  • Settings sheet: Useful life for each device type.

How to use it

  1. 1Tag every device and record make, model and serial number.
  2. 2Set each device's status (In use, Spare, In repair, Retired) and who or where it is assigned to.
  3. 3Set the useful life for each device type on the Settings sheet.
  4. 4Check Refresh and Warranty each quarter and budget for replacements.

Tips

  • Collect devices on an employee's last day and mark them Spare before reissuing.
  • Retire devices rather than deleting them so you keep the disposal record.

Questions

How is the current value estimated?

Straight-line depreciation: cost reduced evenly to zero over the useful life for that device type.

When is a device due for refresh?

When its age reaches the useful life set on the Settings sheet; Refresh soon means within 6 months.

Related searchesit asset inventoryhardware inventoryequipment registerasset trackingdevice refreshdepreciation

Details

Format
Spreadsheet
Category
IT & Asset Management
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetIT & Asset ManagementFree

IT Asset Inventory

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

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
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More it & asset management templates

View all
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

IT Access Request Form

Request access to systems, software and hardware with manager approval.

Full name *

Work email *

Department *

Submit request
FormIT & Asset Management

IT Access Request Form

Request access to systems, software and hardware with manager approval.

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