The Problem
A managed IT services provider was tracking client hardware — devices, warranties, refresh cycles, ownership, lifecycle status — in a spreadsheet. The spreadsheet had grown for years. Multiple people were editing it. Updates were inconsistent, formulas had been broken and patched, and nobody fully trusted what was in there.
The spreadsheet wasn't the bottleneck for any one task. It was the bottleneck for growth. Adding more clients meant adding more rows, and the brittleness compounded with every new column the team had to track.
What We Diagnosed
Replacing the spreadsheet with a "spreadsheet-but-cleaner" would have solved nothing. The team needed a system that made hardware data structured, queryable, and stable as the client base grew — without forcing anyone to learn a heavy PSA workflow they'd reject.
We also identified what NOT to automate at first: warranty renewal decisions and end-of-life recommendations. Those still need a human, but a human looking at clean data instead of stale spreadsheet rows.
What We Built
- Structured hardware records with proper ownership: device, client, serial, purchase date, warranty status, refresh schedule, lifecycle stage
- Input flow that's faster than the spreadsheet was on its best day — fewer clicks, validated fields, no broken formulas
- Reporting views for the whole portfolio: what's aging out, what's due for refresh, what's under warranty, what's not
- A foundation that scales — adding a new client doesn't add brittle rows, it adds clean records
The Results
| Metric | Before | After |
|---|---|---|
| Where hardware data lived | Spreadsheet (brittle) | Structured system |
| Time per week on hardware admin | High | ~10 hrs back |
| Trust in the data | Mixed | High |
| Ability to scale to more clients | Constrained | Unblocked |
The hours-saved number is the easy win. The harder-to-measure win is that the team can take on more clients without the tracking system buckling — which is what was actually holding them back.