Why Every MSP Needs a Client Equipment Tracker (And Spreadsheets Don't Cut It)

Picture this: your tech gets a call that the network is down at a hotel client. They drive 25 minutes to the site, walk in, and spend the first 15 minutes just figuring out what router is there, where it is, what the admin IP is, and whether anyone changed the credentials since the last visit.

That 15 minutes is billable time your tech is spending on discovery work instead of actual repair. Multiply that across a 5-tech team doing 4 site visits a day, and you're losing over 5 hours of billable time every week — not to mention the frustration and the unprofessional impression it makes on clients.

This is the problem a client equipment tracker solves. And it's one of the most underrated tools in an MSP's operational stack.

What MSPs Are Actually Using Today

Most MSPs track client equipment in one of four ways, all of which have serious problems:

1. Spreadsheets

The most common. Someone created a Google Sheet or Excel file for each client, and it has columns for device name, IP, model, and serial number. The problems:

• It's almost always out of date — nobody updates it after every visit
• It's not accessible from a phone in the field
• There's no connection to visit history or service records
• When the person who built it leaves, institutional knowledge goes with them

2. Notes in the PSA or RMM

Some MSPs use the notes field in Syncro, ConnectWise, or Autotask. Better than nothing, but these tools aren't designed for field inventory. The data lives in a flat text field with no structure, no warranty tracking, no firmware columns, and no way to pull up a clean device list on your phone while standing in a server room.

3. Memory

This is more common than MSPs like to admit. "The senior tech knows the setup at that client." This works until the senior tech is on vacation, out sick, or gives notice.

4. Nothing

Some MSPs simply don't track it at all and rediscover the environment every visit. This is the most expensive option even though it feels like it costs nothing.

What "Client Site Discovery" Actually Costs You

And that's just the direct billable time. There are indirect costs too: the client who watches your tech fumble around for 15 minutes before fixing anything doesn't feel great about the $125/hr they're paying. That's a retention problem.

What a Good Equipment Tracker Looks Like

A client equipment tracker built for MSPs needs to be fundamentally different from a general IT asset management tool. Here's what actually matters:

Notice what's not on this list: procurement workflows, asset depreciation schedules, CMDB integrations, software license tracking. Those are enterprise IT asset management features. For MSP field work, you need fast access to the information that gets you working — not a full ITAM suite.

The Warranty Expiry Opportunity

Here's a revenue angle most MSPs miss entirely: warranty expiry tracking is a sales tool.

When you have every client device's warranty expiry date logged, you can run a report every quarter showing what's aging out in the next 90 days. That becomes a proactive conversation with the client: "Hey, your firewall warranty expires in 8 weeks. Want us to quote a replacement before it's out of coverage?"

This is the kind of conversation that clients appreciate — it feels like you're looking out for them — and it generates hardware revenue your MSP would otherwise never see because nobody thought to ask.

Categories of Equipment to Track

For hotel and commercial MSP clients specifically, here's what should be in your tracker for every site:

Network Infrastructure

• Core router / firewall (MikroTik, Ubiquiti, Cisco, Fortinet)
• Managed switches — each one, each location
• Wireless access points and controllers
• Cable modem / ONT / ISP CPE

Communications

• PBX / UCM (Grandstream, 3CX, Cisco)
• VoIP gateways and analog adapters
• SIP trunking provider and account info

Servers & Storage

• Physical servers — make, model, RAM, storage
• NAS devices
• UPS / battery backup units

Security & Surveillance

• NVR / DVR systems
• IP cameras — quantity, location, model
• Access control panels and readers

Endpoints

• Workstations at front desk, back office
• POS terminals
• Printers

Why It Needs to Live With Your Field Service Tool

The mistake most MSPs make is keeping the equipment tracker separate from the field service workflow. It lives in a spreadsheet or a separate app, so the tech has to switch contexts to look it up — and often just doesn't bother.

When the equipment tracker is built into the same tool your tech uses to clock in and document the visit, the behavior changes automatically. They open the app, clock in, and the Devices tab is right there showing the full site inventory. No context switching. No "I'll look it up later."

That's the design principle behind FieldSentry's equipment tracker — it's a tab in the field app, not a separate tool. When your tech clocks in to a client, the inventory is one tap away.

Getting Your Equipment Tracker Started

The biggest barrier to adoption is the initial data entry. Here's the fastest way to get started without it feeling overwhelming:

1. Start with your top 5 clients — the ones your team visits most often. Don't try to do all 50 at once.
2. Add devices during visits — have techs log equipment as they encounter it on site. Within 2-3 visits per client, you'll have a complete picture.
3. Prioritize network gear first — routers, switches, and firewalls. That's where 80% of your troubleshooting starts.
4. Add the notes field religiously — "admin password is on sticky note under the switch" is worth its weight in gold at 2am.

Related Articles

• HouseCall Pro vs FieldSentry for MSPs
• How to Push MSP Field Service Invoices to QuickBooks Automatically
• View all FieldSentry articles