If your IDD agency has grown significantly in the last five years, there’s a good chance some version of this is true: your billing team has a master spreadsheet for tracking authorizations. Your program managers have their own sheets for scheduling. Your payroll person has a workbook that only they fully understand. And somewhere in there is a Google Sheet that three different people are updating simultaneously and that no one completely trusts.
This isn’t a failure of competence. It’s a rational response to growth that outpaced systems. Spreadsheets are flexible, familiar, and free, and they can handle a surprising amount of complexity if the right person is maintaining them. The problem is what happens when the volume gets too high, the regulations get more specific, or the person who built the spreadsheet leaves.
How Agencies Get Into the Spreadsheet Trap
Most IDD agencies didn’t decide to run operations on spreadsheets. They grew into it. The organization started small enough that manual tracking worked. Someone built a clever Excel model to handle billing calculations. A program manager started a Google Sheet to manage scheduling. Over time, these tools became infrastructure, woven into daily operations in ways that are hard to unwind.
The trap is that spreadsheets are easy to add complexity to and very hard to audit. Each workaround added to the original model makes it more fragile. Each person who customizes it adds a layer of undocumented logic. And because the spreadsheet feels like it’s working, until it isn’t — the urgency to replace it never quite reaches the top of the priority list.
The Real Risks, Specifically
Billing Errors That Compound Over Time
Manual billing processes using spreadsheets create error rates that increase with volume. As authorization structures become more complex, as Medicaid adds new requirements, and as agencies expand, the manual validation steps that kept the spreadsheet accurate at smaller scale stop scaling. Billing errors at IDD agencies, wrong service codes, authorization overruns, missing documentation for billed services, often originate in the data management layer, not the billing submission itself. Vertex Billing Manager automates these validations so errors are caught before they become denials.
EVV and Billing Reconciliation Failures
In 2026, EVV data must flow directly into billing claims or those claims will be rejected. Agencies reconciling EVV records against billing spreadsheets manually are operating a system that will break under hard edit enforcement. The gap between what’s in the EVV system and what’s in the billing spreadsheet is exactly the kind of discrepancy that triggers claim rejection. Vertex’s EVV Manager feeds directly into billing to eliminate this gap.
Audit Trail Gaps
When a Medicaid auditor asks for documentation supporting a specific claim, what does your current system produce? If the answer involves opening multiple spreadsheets, locating matching entries across several tabs, and manually assembling the supporting record, that process takes time your billing staff doesn’t have during an audit response window. Software systems maintain clean audit trails automatically. Every transaction, every change, every authorization alignment is logged and retrievable.
Key Person Dependency
The most acute version of spreadsheet risk is the key person problem: the organization is effectively dependent on one or two people who understand the billing models well enough to maintain the spreadsheets correctly. When those people are out sick, take vacation, or leave the organization, operations don’t just slow down, they stop. Software systems make operational knowledge institutional rather than individual. The rules are in the system, not in someone’s head.
Compliance Gap Risk
Regulatory requirements for IDD billing and documentation are updated regularly at both the state and federal level. Spreadsheets don’t update themselves. The responsibility for tracking regulatory changes and updating manual processes falls on staff who are already at capacity. Vertex carries that compliance update burden as part of the platform, including state-by-state Medicaid changes for every state where Vertex operates.
How to Identify When Spreadsheets Have Become a Risk
- Billing reconciliation takes more than a day per billing cycle
- Claim denial rates are above 3%
- Scheduling changes require updates in more than two places
- Authorization tracking is done manually with no automated alert when units are running low
- Staff turnover has left institutional knowledge gaps in billing or scheduling processes
- EVV data is reconciled manually against billing entries
The Transition Doesn’t Have to Be Disruptive
The concern most agencies have about moving away from spreadsheets isn’t whether the software would be better, it’s whether the transition would be survivable. Agencies that have made this transition successfully typically describe a short period of parallel operation, followed by a relatively clean cutover. Read how Ability Building Community made this transition with Vertex.
The operational risk of transition, in most cases, is lower than the ongoing risk of staying on manual systems. Schedule a demo to talk through what the transition would look like for your agency.