trio.so
Templates

Device Cost Management Template (Free Excel, PDF + Word)

Free device cost management template: an Excel tracker for device TCO per device and department, lease vs buy and licenses, plus a cost checklist.

Mountain landscape representing leadership perspective and vision
Written by
Atena Ladchartabi

Content writer, trio.so

Published on
Modified on

Device cost management is the habit of knowing what every company phone, tablet and laptop really costs, from the day it is bought or leased to the day it is wiped and sold, and acting on what you find. The purchase price is the easy part. The carrier plan, the licenses, the repairs, the accessories, the setup time and the spare devices nobody uses add up to more than most budgets show.

This free template gives you an Excel Device Cost Tracker that works out the total cost of ownership (TCO) of each device per month and over its life, sums it per department and per employee, flags idle devices, overdue replacements and leases about to end, compares leasing with buying, tracks license seats and compares budget with actual spend. A checklist and policy in PDF and Word adds monthly, quarterly and yearly review steps and the rules that keep costs down.

In short

  • Track cost per device, not only per invoice: purchase or lease, carrier plan, accessories, licenses, support and repairs, minus what you get back at the end.
  • Spread one-time costs over the expected life to get a monthly TCO you can compare across devices, departments and years.
  • The quickest wins are usually visible in the register: devices with no owner, plans on spare devices, license seats nobody uses and leases that renew by default.
  • Review monthly for changes, quarterly with finance and yearly for the catalog, budget and contracts.

What Mobile Device Cost Management Covers

Mobile device cost management is the work of tracking and controlling everything company devices cost over their life: buying or leasing them, connecting them, licensing the software on them, supporting and repairing them, and retiring them. It answers three questions finance asks sooner or later: what does a device really cost us, where does that money go, and which of it could we stop paying.

The method behind it is total cost of ownership. Instead of looking at the price on the invoice, you add up every cost a device causes over its expected life and subtract what you get back when it leaves. That turns a laptop that looked cheap into one that may cost more than a pricier model once repairs are counted, and it shows that a phone's carrier plan can outweigh the phone itself.

Device cost management sits between two neighbors. Your IT budget template covers all IT spending, from cloud services to salaries; this template goes one level down, to each device. Your IT asset management policy sets how assets are recorded and owned; this template adds the cost columns and the review rhythm. If you are building IT asset management from scratch, start with the device register here and grow from it.

Mobile Cost Management vs Telecom Expense Management

"Mobile cost management" is often used to mean telecom expense management (TEM): auditing carrier bills, matching data usage to plans, pooling data and catching roaming charges. TEM is one part of device cost, and dedicated TEM tools read carrier invoices and usage feeds to do it.

This template covers the whole device instead. It records each device's carrier plan cost so you can see it next to the hardware, licenses and repairs, and it flags plans still running on spare or idle devices. For usage and roaming detail, use your carrier's bills or business portal and adjust the plan column when a plan changes.

The Real Cost of a Device: What Goes Into TCO

Every device carries these cost lines. The template has a column for each, so nothing is left out because it arrives on a different invoice:

Cost lineWhat it includesWhenTemplate column
Purchase or leasePurchase price, or the monthly lease payment and any upfront or end-of-lease feesOne-time or monthlyPurchase cost, Monthly lease
Carrier planVoice and data plan for phones, tablets and laptops with a SIM or eSIMMonthlyCarrier plan per month
AccessoriesCases, chargers, docks, keyboards and external displays issued with the deviceOne-timeAccessories
LicensesDevice management (MDM) and other per-device software: security, productivity, support toolsMonthlyLicenses per month
Support and repairsRepairs, replacement screens and batteries, warranty or insurance, help desk time you choose to chargeAs they happenSupport and repairs to date
Setup and admin timeEnrollment, configuration, app installs and offboarding workPer deviceAdd to Support and repairs if you track it
Replacement and disposalExpected life in months, and what the device is worth when it leaves (resale or trade-in value)End of lifeExpected life, Disposal value

Setup and admin time is the line most often skipped. If you charge IT time to devices, add it to Support and repairs. If you don't, count it at least once when you compare options: a device type that needs an hour of manual setup costs more to roll out than one that enrolls itself.

How to Calculate Device TCO

The tracker uses one formula for every device, so results are comparable:

  • Hardware per month = (purchase cost + accessories - disposal value) / expected life in months, plus the monthly lease for leased devices.
  • Monthly TCO = hardware per month + carrier plan + licenses + support and repairs to date / months in service.
  • Lifetime TCO = monthly TCO x expected life.

Here is how it works out for three devices from the template's example tab. The company and every amount are made up, and the example leaves the Licenses column empty, so add your own license costs per device:

DeviceHardware per monthCarrier plan per monthMonthly TCOLifetime TCO
Phone, bought (iPhone 15, 36 months)$19.17$35$54.17$1,950
Laptop, bought (MacBook Air, 48 months)$24.38$0$24.38$1,170
Laptop, leased (MacBook Pro, 36-month lease)$95$0$95$3,420
Monthly TCO of three example devices, split into hardware and carrier plan
Monthly TCO of three example devices, split into hardware and carrier plan

Two things stand out even in made-up numbers. The phone costs more per month than the laptop that was bought for more, because its carrier plan runs every month. And the leased laptop is the most expensive line of the three, which is not a verdict on leasing: a lease spreads a higher-end machine over a shorter term. That is what the lease-vs-buy calculator further down is for.

Monthly TCO is a planning number. It spreads one-time costs over the device's life, so it won't match the cash you spend in any given month. Use it to compare devices and departments, and use the Budget vs Actual tab for cash.

What Drives MDM Cost per Device

The device management tool is one of the license lines in the TCO, and people often ask what it should cost per device. Vendors price differently, so compare on what you will actually pay, not the headline number. Four things drive it:

DriverWhat to check
License tierWhich features sit in which plan. Patching, compliance and identity features are often in higher tiers.
Device countMinimums, volume steps and whether phones, tablets and computers are priced the same.
Add-onsRemote support, app catalogs, identity and security modules sold on top of the base plan.
Setup and admin timeHours to enroll, configure and support devices. A cheaper tool that needs more manual work can cost more per device.

Put the license cost per device in the Licenses column, and the hours in Support and repairs if you track them. For published vendor prices, see our overview of MDM pricing.

Lease vs Buy: How to Decide

Leasing turns a large purchase into even monthly payments and makes refresh cycles automatic. Buying usually costs less in total when you keep devices longer than a lease term or sell them for a good price. The honest answer depends on your numbers, so compare both over the same period:

FactorBuyLease
Total cost over the same periodLower when you keep devices past the lease term or sell them wellLower when the term matches how long you keep devices
Cash flowLarge payment up frontEven monthly payments
Support and repairsYour cost, unless a warranty covers itOften included; check the contract
UpgradesWhen you decideAt the end of each term
End of lifeYou sell, trade in or recycle and keep the valueYou return the device; fees for damage or missing items may apply
AdminTrack purchase date and expected lifeTrack lease end dates and return conditions

The workbook's Lease vs Buy tab compares three device types side by side. In its example values, buying wins for the laptop ($1,330 against $1,720 over 36 months) and the phone, and leasing wins for the tablet ($708 against $754), because that lease includes support and the tablet's resale value is low. The calculator leaves out financing cost, tax and depreciation, so check those with finance before you sign. The PDF and Word files include a decision page to record what you chose and why.

Whatever you choose, track lease end dates. Many leases roll over or charge for late returns, and the register flags any lease ending within 60 days (you can change the window).

Cost per Department and per Employee

Totals hide where the money goes. The Department Summary tab adds up devices, monthly TCO, annual TCO and lifetime TCO for each department, and divides by headcount to give device cost per employee. Type your departments and headcount once; the register's Department column then offers the same list, so names match.

Cost per employee is the number finance can plan with: multiply it by planned hires to budget next year's devices. It also shows outliers worth a question. A team with more devices than people may be carrying spares nobody returned, and a team with a much higher cost per head may have a good reason or an old lease. For splitting shared IT costs across departments more broadly, see our IT resource allocation template.

License Tracking: Seats You Pay for and Don't Use

Per-device and per-user licenses grow quietly. People leave, projects end, and the seats stay on the invoice until renewal. The License Tracker tab lists each product with its cost per seat, seats bought and seats assigned, and works out the unused seats, what they cost each month and which renewals are coming up within 60 days.

In the example, 56 unused seats across three products cost $372 a month, and one product has more seats assigned than bought, which is its own problem at audit time. Check seats a quarter before each renewal, while you can still change the count. Your device management tool's app inventory shows which apps are actually installed where, which is a useful cross-check against what you pay for. When a license sits with an outside supplier, our vendor management policy template covers the contract side.

Mobile Device Cost Control: Where Savings Usually Hide

Cost control is mostly about finding money that is spent without anyone deciding to spend it. The register's flags point at the usual places:

  • Idle devices. A device with no owner still carries its share of hardware cost, and often a carrier plan and licenses. Reissue it, or retire and sell it while it still has resale value.
  • Plans on spare devices. Suspend or downgrade carrier plans on devices in a drawer, and cancel them on retired ones.
  • Devices past their replacement date. Some are fine to keep while they get security updates; others cost more in repairs than they are worth. The flag makes it a decision instead of an accident.
  • Leases ending soon. Decide return, extension or buyout before the lease decides for you.
  • Too many models. A standard device catalog with one or two models per role cuts support time, spare stock and accessories.
  • Repairs that cost more than replacement. The policy template sets a limit, for example half the price of a new device.

Better data beats harder negotiation: you can't renegotiate a carrier contract or a license renewal well without knowing how many lines and seats are really in use.

BYOD Stipends vs Company Devices

Letting staff use their own phones moves the hardware cost to them, but it doesn't make device cost disappear. Most companies pay a stipend or reimburse business use, still pay for licenses, and still spend support time. Count all of it before you compare: a stipend per person per month against the monthly TCO of a company phone from the register.

The checklist and policy include a BYOD stipend section with placeholders for the amount, eligible roles and when payment stops. Expense, tax and wage rules for stipends differ by country and state, so confirm the terms with finance and legal counsel. The BYOD policy template covers the rest of the agreement for personal devices, and the mobile device management policy covers how company devices are managed.

Replacement, Disposal and Resale

Expected life drives the biggest number in the TCO, so set it per device type in the standard catalog and stick to it unless a device earns an exception. Replace devices at the end of their expected life, when they stop getting security updates from their maker, or when a repair would cost more than the limit you set, whichever comes first. Our guide to device lifecycle management covers the stages around it.

At the end, the device still has value. Record the resale or trade-in amount as the disposal value: the TCO formula subtracts it, which rewards devices that hold their value. Before a company device is reissued, sold, returned to a lessor or recycled, wipe it, remove it from your device management tool and from any zero-touch enrollment program, and sanitize the storage in line with your asset disposal policy. NIST SP 800-88 Rev. 2 describes how to clear, purge or destroy data on storage, and a factory reset counts as clearing for many devices. A wipe is one step; it does not replace verified sanitization when drives leave your control.

A Cost Review Rhythm: Monthly, Quarterly, Yearly

A tracker only works if someone reads it. The checklist splits the work into three rhythms:

The cost review rhythm in the checklist: monthly upkeep, a quarterly review with finance and a yearly reset
The cost review rhythm in the checklist: monthly upkeep, a quarterly review with finance and a yearly reset
WhenWhat to do
MonthlyAdd new devices to the device register and mark devices that left as Retired. Check the register's flags: idle devices with no owner, devices past their replacement date, leases ending soon. Reassign or suspend carrier plans on spare and idle devices. Enter last month's actual spend by category on the Budget vs Actual tab and look at the variance.
QuarterlyRun the quarterly cost review (the one-page form in this document) with IT and finance. Compare license seats bought with seats assigned and remove unused seats before the next renewal. List leases ending in the next two quarters and decide: return, extend or buy out. Check that each device in the register still matches the device list in your device management tool (owner and serial number).
YearlyReview the standard device catalog: models, expected life and accessories per role. Set next year's device budget from the register's run rate, planned hires and planned replacements. Review purchase approval thresholds and the lease-vs-buy rules. Renegotiate or rebid carrier, leasing and repair contracts where terms allow.

The quarterly review gets its own one-page form: the numbers from the Dashboard, the decisions and who owns each, and sign-off from IT and finance. Checking the register against your device management tool's device list every quarter matters more than it sounds: CIS Controls v8.1 Safeguard 1.1 asks for an asset inventory with each device's owner and department, reviewed at least every six months, and the register is that inventory with costs added.

What's in the Download

The workbook's Example tab: a made-up company's devices with monthly TCO and flags
The workbook's Example tab: a made-up company's devices with monthly TCO and flags
  • Excel Device Cost Tracker (Device-Cost-Tracker-trio.so.xlsx): a device register with monthly and lifetime TCO and flags for idle devices, devices past their replacement date, leases ending soon and missing inputs; a department summary with cost per employee; a lease vs buy calculator for three device types; a license tracker with unused seats and renewals; budget vs actual by month in six categories; a filled-in example for a made-up company; a dashboard; and sources. Formulas only, no macros.
  • PDF checklist and policy (Device-Cost-Management-Checklist-trio.so.pdf): monthly, quarterly and yearly cost review checklists, a 13-section device cost management policy, a standard device catalog, a lease vs buy decision page and a one-page quarterly cost review, ready to print.
  • Word version (Device-Cost-Management-Checklist-trio.so.docx): the same checklist and policy to edit, with fillable fields, tick boxes and date pickers.
The checklist and policy PDF: cover, the cost review checklist and the lease vs buy decision page
The checklist and policy PDF: cover, the cost review checklist and the lease vs buy decision page

The example has 14 devices at a made-up 160-person company, including a spare laptop past its replacement date with no owner, a spare tablet still on a carrier plan, a phone and a tablet past their replacement dates, two leases ending within 60 days and a retired phone that stays on record but out of the totals. Its monthly device TCO comes to $582.84, about $3.64 per employee, so you can see every flag and total before you add your own devices.

Where trio.so Fits

trio.so is device management for Windows, macOS, Linux, iOS/iPadOS and Android, from one console. For device costs it gives you the device list the spreadsheet starts from; the cost columns live in the workbook. Use trio.so's device list, with each device's owner, serial number and installed apps, as the source for the register, and keep the cost columns in the workbook. It helps with the cost lines themselves too:

  • A device inventory that shows each device's owner and serial number, so devices with no owner stand out and every register row matches a real device.
  • The installed apps on each Windows, macOS, iOS/iPadOS and Android device, to compare with the license seats you pay for.
  • Per-device policy status, so you can see on which devices each policy applied, failed or is still pending.
  • Remote desktop and terminal in every plan, so many support issues are handled without a desk visit or a courier.
  • App deployment to enrolled devices, so a reissued device is ready without manual installs.
  • OS update policies that keep devices on current updates, which helps older devices stay in service until their planned replacement.
  • Zero-touch enrollment for Apple, Windows and Android devices, which cuts setup time for each new or reissued device.
  • Remote wipe of company-owned devices before they are reissued, returned, sold or recycled.

Read more about mobile device management with trio.so, or our guide to unified endpoint management. Plans start at $5 per device.

Start free trial Book a demo

14-day free trial. No credit card required.

Related Templates

Sources. Last reviewed November 2026. The cost method (total cost of ownership as the sum of purchase or lease, running and support costs over a device's life) is general practice; the wording, formulas and example are ours. References to CIS Controls v8.1 and NIST SP 800-88 are general pointers. trio.so is not affiliated with or endorsed by CIS or NIST.

Ready-to-use Templates

Must-have Template Toolkit for IT Admins

Explore All
Template Toolkit

Start your device register from a real device list

trio.so shows every device with its owner, serial number and installed apps, and supports users through remote desktop and terminal, on Windows, macOS, Linux, iOS/iPadOS and Android.

Start free trial

Manage Every Device From One Console

trio.so brings device management, patching and security policies for Windows, macOS, Linux, iOS/iPadOS and Android into one console. Enroll a device and see it in the console within minutes.

14-day free trial. No credit card required.

trio.so brings device management, patching and security policies for Windows, macOS, Linux, iOS/iPadOS and Android into one console. Enroll a device and see it in the console within minutes.

Smiling womanAbstract geometric patternAbstract geometric patternSmiling womanSmiling woman

Frequently Asked Questions (FAQ)

Have questions? We've got answers. This section covers some of the most commonly asked questions related to this topic.

It is the practice of tracking and controlling everything company phones, tablets and laptops cost over their life: purchase or lease, carrier plans, accessories, licenses, support and repairs, setup time, replacement and disposal. The usual method is total cost of ownership per device, reviewed regularly so idle devices, unused license seats and expiring leases are caught early.

Add the purchase cost and accessories, subtract the expected resale or trade-in value, and divide by the expected life in months. Add the monthly lease if the device is leased, plus the carrier plan, licenses and support and repair costs per month. Multiply the monthly figure by the expected life to get the lifetime TCO. The template does this for every device.

Telecom expense management focuses on carrier costs: auditing phone bills, matching data usage to plans and catching roaming charges. Mobile device cost management covers the whole device, with the carrier plan as one line next to the hardware, licenses, repairs and disposal value. Many teams use both: carrier bills or a TEM tool for usage detail, and a device register for total cost.

It depends on the license tier, the number of devices, add-ons and how much setup and admin time the tool needs. Compare tools on the total you would pay per device for the features you need, not the entry price; our MDM pricing overview lists vendors' published prices. With trio.so, the answer is short: Plans start at $5 per device.

Buying usually costs less in total when you keep devices longer than a typical lease term or resell them well. Leasing can cost less when support is included, resale value is low or you replace devices on a fixed cycle anyway, and it spreads payments evenly. Compare both over the same term, then check financing cost and tax treatment with your finance team.

Update the register every month as devices arrive, move and leave, and review costs with finance every quarter, in line with budget cycles and before license renewals. Once a year, revisit the standard device catalog, expected life per device type, approval thresholds and supplier contracts.

It can reduce hardware spend, because employees buy their own phones or laptops, but stipends or reimbursement, licenses and support time remain. Compare the stipend per person with the monthly TCO of a company device for the same role, and check expense and tax rules for stipends with finance and legal counsel before you decide.

Related

From the blog

The related industry news, interviews, technologies, and resources.