Key takeaways
→ A spreadsheet is a reasonable way to start tracking laptops. It falls behind when people move, leave or join in other countries faster than anyone can update it.
→ What to use instead: one record per person, filled from the systems that already know (your MDM, HR system and suppliers), with a history that follows each device.
→ You don't have to replace the sheet in one go. Import it, connect one source, fix the gaps, and add the rest from there.
It usually has a name like laptops_2026_FINAL. There's a tab per office, a serial number column someone fills in when there's time, and a notes column that says things like "ask Erik". For a while it works, and if you set it up yourself, it probably worked well.
This guide is about tracking laptops without a spreadsheet: when the sheet stops keeping up, what to use instead, and how to make the switch without turning it into a project.
Is a spreadsheet good enough to track who has which laptop?
For a small team in one office where people rarely change roles, yes. A spreadsheet is free, everyone can open it, and it's a reasonable place to start.
Its limit is that it only knows what someone typed into it. As long as one person does the typing, sees every change and has time to update the row, the sheet stays right. Each of those conditions gets harder to meet as the company grows. Sebastian Rosander, CTO at Playground Tech, put the turning point plainly: "Up to 20 employees you can manage. Beyond that, it's impossible."
When does a laptop spreadsheet stop working?
When the people in it change faster than the sheet gets updated. Three moments do most of the damage:
People move
Someone changes team, gets a new manager or swaps a laptop with a colleague at their desk. The device didn't go anywhere new, but the row is now wrong, and nothing tells you.
People leave
The leave date sits in the HR system for weeks, and the row in the sheet stays untouched. Whether the laptop comes back depends on someone remembering to check, and the accessories rarely make it into the sheet at all.
People join in other countries
A new office buys from a local supplier, an office manager hands out the laptops, and the invoices arrive in a different currency. Those devices reach the sheet late, or never, because nobody in that office knows it exists.
This rarely shows up as a crisis. The sheet drifts a little each month, and you find out when finance asks what the laptops cost, an auditor asks for every device with an owner, or a new hire is waiting on a laptop you already had in a cupboard.
Your MDM helps, but only with part of it. It knows the device is enrolled and who logged in last. It doesn't know who's meant to have the laptop, what it cost, when the lease ends or that the person left last month.
What should you use instead of a spreadsheet to track who has which laptop?
Use a system that keeps one record per person and fills it from the tools that already know what's happening: your MDM, your HR system and your suppliers. Each device should carry its own history, from purchase to the day it's retired. These three things are what to look for.
One record per person
Start from the employee rather than the device. Open a person and see every laptop, phone and accessory they hold, along with their software licences and mobile plan. That's the view you need when someone joins, moves or leaves, and it's the one a spreadsheet organised by serial number can't give you.
Data pulled from MDM, HR and suppliers
The HR system already knows who's starting, who's moving and who's leaving. The MDM knows which devices exist and are enrolled. Suppliers know what was ordered and delivered. When the record fills itself from those three, nobody has to retype a change, and a new office's laptops show up whether or not anyone there has heard of your process.
A history that follows the device
A spreadsheet row holds the current owner, if it's up to date. A device history holds everyone who had it, when it went for repair, when it came back and where it went at the end. That's what lets you redeploy a returned laptop with confidence, answer an audit question about a device from two years ago, or show where a retired machine ended up.
What should you look for when you replace the spreadsheet?
Look for something that fills itself from your existing systems and lets you start with the data you already have. These questions sort the options quickly:
- Can I open one person and see everything they hold, laptops alongside licences and phone plans?
- Does it sync from my MDM and HR system, or will someone still be typing?
- Does it work with the suppliers we already use in each country, including devices bought outside the usual channel?
- Does each device keep its history: previous holders, repairs, returns, end of life?
- Can it cover several countries, currencies and legal entities in one place?
- Can I import the spreadsheet as a starting point and connect the rest later?
- Can I ask a question in plain language, like "which laptops have no owner?", and get an answer?
On the suppliers question: if a tool only tracks what you bought through one channel, the sheet creeps back in to cover everything else. Check that early.
How do you move off a spreadsheet without a big project?
Import the spreadsheet as your starting point, connect one source (usually your MDM or HR system), sort out what doesn't match, then add the next connection. You get a clearer picture on day one and it sharpens with each source you add.
This is how that works in Velory:
- Bring in what you have. Your current list becomes the first version of the record, and devices bought outside your usual suppliers can be added too.
- Connect your MDM. Devices enrolled in Intune, Jamf, Iru or another supported MDM are imported, and anything with missing details waits in a review list until someone checks it.
- Connect your HR system. People appear before their first day at work, moves and leave dates flow through, and each device sits against the person who holds it.
- Connect your suppliers. New orders link to the right person when they arrive, in whichever countries you buy.
- Build the workflows you need, such as returns when someone leaves or a laptop ready before a start date, shaped around how your company already works.
Fair warning on the hard part: the first time you line the spreadsheet up against your MDM, they'll disagree. Expect a list of laptops nobody can place and people who seem to have two. Working through that list once is the slow bit, and it's also the moment you find out what you actually own.
Playground Tech went live in less than a week with 100% visibility of its devices. At Voyado, IT Manager Jonny Sahlén described the time before as "messy and uncontrolled"; they now have 100% device visibility.
Where do you start?
Start with the question the spreadsheet answers worst for you today, whether that's who has which laptop, what came back from last month's leavers or what the new office bought. Pick the one source that answers it, connect that first, and keep the sheet open alongside until you trust the new record. You'll notice the difference the first time someone leaves and you can see everything they hold without opening a single tab. To see it with sample data, take the interactive product tour.
Frequently asked questions
Is it OK to track laptops in a spreadsheet?
Yes, as a starting point. A spreadsheet works while one person sees every change and has time to update it. It falls behind once people move, leave or join in other countries faster than the sheet gets updated.
Can my MDM replace a laptop spreadsheet?
Partly. An MDM such as Intune or Jamf knows which devices are enrolled and who signed in last. It doesn't hold who's meant to have the device, what it cost, its lease or its return when someone leaves, so it works best as one source feeding a single record per person.
What information should a laptop record include?
Who holds it, when they got it, model and serial number, purchase date and cost or lease terms, supplier, warranty, current status, and a history of earlier holders, repairs and returns.
How do you track laptops across several countries?
Keep one record per person across every country, fed by each country's HR data and by the local suppliers you buy from. That way a laptop bought and handed out in another office still appears against the right person.
Do we need to replace our spreadsheet all at once?
No. Import it as the starting point, connect one source, reconcile the differences, then add more connections over time. You can keep the sheet open alongside for the first few weeks until you trust the new record.




.jpg)