Inventory tracking answers three questions in real time: Where is every unit? Is it generating revenue? When does it need service? Operators who can answer all three instantly achieve 80%+ fleet utilization and reduce lost-unit costs by 90%.
The Tracking Challenge
The average 200-unit portable toilet fleet loses 3-5 units per year due to poor tracking. At a replacement cost of $800-$1,200 per unit, that is $4,000-$6,000 in annual loss that is entirely preventable with a proper inventory system.
When your fleet is small (under 30 units), you can track everything in your head. You know where every unit is because you delivered it yourself. But as soon as you add a second driver, a second truck, or a second depot, your personal memory fails.
Units get delivered to addresses that are not recorded. Contracts end and nobody schedules the pickup. A unit gets swapped during service and the records do not update. Small tracking failures compound into a fleet with 20% of units unaccounted for.
This guide explains how to build a tracking system that scales from 50 to 500+ units.
Tracking System Options
| System | Best For | Monthly Cost | |--------|---------|-------------| | Google Sheets with manual entry | Under 50 units | Free | | Dedicated fleet management software | 50-300 units | $100-$300/month | | Enterprise asset management (EAM) | 300+ units, multi-depot | $500-$1,500/month | | Custom-built system (API-integrated) | Operators with existing software stack | Development cost varies |
The spreadsheet ceiling: Spreadsheets work until they do not. The failure point is usually when a second person starts updating the same sheet, creating version conflicts and data loss. If you have more than one person responsible for inventory, invest in dedicated software immediately.
Regardless of which system you choose, it must track these fields for every unit:
QR Code Scanning Workflow
QR codes on every unit create a chain of accountability:
The QR code system works because it requires almost zero additional effort from the driver or technician. They are already at the unit. Scanning takes 3 seconds. The system handles everything else.
Tracking Utilization
Fleet utilization is the percentage of your fleet generating revenue at any given time:
| Utilization Rate | Assessment | |-----------------|-----------| | Below 60% | Too many idle units. Reduce fleet or increase sales. | | 60-70% | Average. Room for improvement in sales or season extension. | | 70-80% | Good. Healthy balance of deployed and available units. | | 80-90% | Excellent. But check if you are turning away orders due to low availability. | | Above 90% | Risky. No buffer for new orders, replacements, or damage repairs. |
Track utilization weekly by dividing deployed units by total fleet size. Graph it monthly to identify seasonal patterns. Most operators see peak utilization from April through October and a dip from November through March.
Use the seasonal dip for fleet maintenance: deep cleaning, repairs, refurbishment, and retirement of end-of-life units. Having units available during the slow season costs less than having units unavailable during the busy season.
Building a Multi-Site Dashboard
For operators managing 10+ active job sites simultaneously, a dashboard view is essential:
Most fleet management software includes dashboard functionality. If you are building a custom system, prioritize the map view and the overdue service alerts. These two views prevent the most costly operational failures: lost units and under-serviced units.
Related reading: Fleet Management for Operators | Health Department Inspections
