Loaner pool: Excel vs purpose-built software
22 May 2026 · 7 min read
Most medical and dental dealers I've talked to start their loaner pool on Excel (or a Google Sheet, same difference). It's free, everyone knows it, and for the first few months it works fine.
This post is about when Excel stops being good enough. I've collected the seven specific moments where the spreadsheet breaks down, and what to look for in a replacement.
Why Excel works at first
Be honest with yourself: if you have 5 loaners and 10 customers, Excel is fine. A single sheet with columns for loaner unit, customer, date out, expected return, actual return, notes. Total cost: zero. Learning curve: zero.
The case for staying on Excel is real until certain thresholds are crossed. Don't migrate prematurely.
Seven signals it's time to migrate
1. You've lost track of a loaner at least twice this quarter
"Where's unit #4?" Nobody knows. It's been at customer X since some time in March. The spreadsheet says "still out" but doesn't tell you what stage of the workflow it's in. You call customer X to find out it was returned weeks ago — to someone else on the team — and is sitting in cleaning, unmarked.
Excel can't show you the current stage. Once that's costing you 30 minutes a week of detective work, you've crossed the line.
2. You're shipping loaners that need service
A unit returns with a sticky button. Tech notes it on the back of a printout, intends to fix it next week. Three days later, a different team member sees "Available" on the spreadsheet and ships it to a clinic for an urgent replacement. Now you have an angry clinic and a damaged trust relationship.
Excel can't enforce a "needs service" gate. Once this has happened, the cost is real and measurable.
3. Photos are in someone's phone, somewhere
Your tech takes photos at check-out (good!) but they're in their personal WhatsApp. The customer claims the loaner arrived damaged. The tech is on holiday. You can't find the photos. The customer wins the argument by default.
Centralized photo storage tied to the deployment record solves this. Excel + WhatsApp doesn't.
4. The auditor asked for a chain of custody
This one usually arrives without warning. MDR Article 18 inspection, FDA UDI verification, internal QMS audit, a recall notification from the OEM. "Give us the complete history of unit #SN-12345 between January 1 and today."
If your answer involves scrolling through a spreadsheet, cross-referencing emails, and asking colleagues to remember, you have a problem. Read our chain of custody guide for the regulatory context.
5. You're running 20+ loaners and can't see capacity
"Can we promise clinic X a loaner for next week?" To answer correctly, you need to know: how many are in the pool, how many are deployed, what stages they're in, when expected returns are, whether any are flagged for service. Excel can show you the first two with effort. The rest requires meetings.
Once your pool is 20+ units, the operational complexity outpaces what a flat spreadsheet can represent without becoming a job in itself.
6. Multiple team members touch the spreadsheet
You and two service techs and a receptionist and a customer support person all edit the file. One of you accidentally deletes a column. Someone copies the file to make "their working version." Now there are 3 versions and nobody knows which is current.
Real concurrency requires real software. Excel files in shared drives are not the answer (and Google Sheets is better but still flat).
7. The CEO asks for analytics
"What's our average cycle time? How many overdue returns last quarter? What does our pool utilization look like? Should we add more units?" These are reasonable questions. Excel can produce some of these with pivot tables — if your data is clean — but the work is manual and one-shot.
If you want continuous visibility, you need a system that aggregates as you operate.
What to look for in a replacement
Don't migrate to whatever asset tracking tool comes up first in Google. Look for these specifically:
Loaner-specific lifecycle
Not "check out / check in" but multiple distinct stages (in transit, at customer, returning, cleaning, available). Most horizontal tools miss this.
Per-customer history
Click a customer, see every loaner they've ever had, on-time/late performance. This is operationally critical.
Photo capture tied to the assignment
Not separate photo storage. The photo at check-out is part of the assignment record, retrievable in one click.
Needs-service gate
System-enforced. If a unit is flagged needs service, it cannot be deployed again until cleared.
Audit log (append-only)
Every state change captured automatically. For MDR/FDA compliance later.
Vertical pricing
Per-pool-size, not per-asset. Aligned with how medical dealers think about cost.
EU-hosted (if you're in EU)
GDPR clean. Frankfurt or similar. Avoid US-hosted tools for medical customer data.
The migration is easier than you think
If you've decided to migrate, the work itself takes a few hours of focused setup:
- Export your current Excel to CSV
- Map columns to the new system's schema (customer, loaner, dates, status, notes)
- Import customers first, then equipment, then any active deployments
- Train the team — usually 30 minutes is enough
The first week after migration is the adjustment. By week 2, the team won't go back. By month 1, you'll wonder why you waited.
If you're on the fence
Try Loaners.app's free 30-day trial. Add 5 customers, 5 loaners, do a few real deployments. If you'd rather go back to Excel after that, you've lost nothing.