The three-system problem: why your admissions team keeps a spreadsheet open next to your software

Walk into most treatment centers and the clinical record is fine. The problem lives in the gaps around it. There is the CRM that tracks inquiries, the spreadsheet that holds census, the billing tool in another tab, and the group text where the real updates happen. None of them talk to each other, so someone re-keys the same patient four times a day.

This is a workflow problem, not a software quality problem. Every piece of the stack does its individual job. What is missing is the layer that would let information move between them without a human carrying it by hand.

The record works. The flow doesn't.

Behavioral health was excluded from the 2009 HITECH Act's EHR incentives, and the sector still lags on data exchange as a result. 68% of substance use and mental health facilities use an electronic health record, but only 19% can exchange data with outside systems (ONC / HealthIT.gov, 2024). The clinical record exists and does its job. The connective tissue that would let that data drive daily operations without a human copying it from one screen to another is what the sector never built.

Scale matters here too. SAMHSA's 2024 National Substance Use and Mental Health Services Survey covered 21,205 eligible treatment facilities nationwide, including 20,813 substance use treatment facilities, 17,754 mental health treatment facilities, and 10,610 offering both (SAMHSA, 2024). Facilities routinely run multiple service lines under multiple payer contracts, which means the fragmentation problem is not one bad workflow. It is a pattern that repeats across nearly every payer relationship and every level of care a center offers.

Where the time goes

Re-entry is not a rounding error. In one large national survey, 47% of clinicians said they had to sift through duplicated data to find what they needed (KLAS Arch Collaborative, 2024). Every disconnected tool adds another surface to update and another place for the truth to drift.

Prior authorization adds its own layer of scattered work. CMS estimates that requesting authorization costs providers $20 to $50 per hour and consumes an average of 13 hours per week (CMS, 2024). A federal rule finalized January 17, 2024 will require many payers to move authorization online and publish decision-time metrics, with most provisions taking effect January 1, 2026 and certain API requirements delayed to January 1, 2027 (CMS). For Medicare Advantage, standard authorization decisions must be issued within 7 days starting in 2026, with urgent requests still held to 72 hours (CMS). Faster payer turnaround does not remove the documentation work on your end. It raises the value of having one current record of what was submitted, what is still pending, and what the deadline is, instead of a status that lives differently in three places.

The funnel leaks while the tabs multiply

The scattered stack has a downstream cost. Referrals do not convert. Across a large health system, only 34.8% of referrals ever reached a documented completed appointment (JGIM, 2018). In behavioral health, where the referral relationship is the business, every handoff that lives in a disconnected tool is a place the patient, and the revenue, can slip.

There is no single national benchmark for how many hours a given center loses to re-keying, or what a normal admissions conversion rate should be. Centers should measure this locally rather than borrow a number from a vendor blog. The measures worth tracking on a rolling basis: referral to first contact time, referral to admission conversion by source and payer, the data re entry rate on new referrals, authorization cycle time from receipt to decision to scheduled admission, and the clean claim rate segmented by reason for denial. A two week time and motion study on a sample of referrals, tracing every handoff across the admissions log, authorization tracker, scheduling system, and claims system, will tell you more than any industry average.

Adoption dies in the seams

There is also a workforce cost, and it is getting worse before it gets better. As of December 2, 2025, 137 million people, 40% of the U.S. population, lived in a federally designated mental health professional shortage area (HRSA, 2025). A federal behavioral health strategy projects the workforce could shrink 28% between 2022 and 2037 while demand climbs 59%, leaving a projected 45% gap (White House, 2025). HRSA points to reimbursement challenges and burnout as two of the forces limiting access to care (HRSA, 2025).

When staff are already scarce, every duplicated intake, authorization, or billing entry competes directly with clinical and admissions time. When the tools are a patchwork, every new hire has to learn the patchwork on top of learning the job, and the path of least resistance is the whiteboard and the group text. Staff do not avoid software because they are difficult. They avoid the seams between tools that were never designed to work together.

What to measure before you fix anything

Before adding or replacing any system, get a baseline. The most decision useful numbers are the ones that expose where a referral or a claim actually stalls:

• Missing information rate: referrals delayed because a release, clinical record, or payer detail was not on hand.
• Admissions leakage: referrals closed or abandoned outside your service level target.
• Staff touch count: how many manual handoffs a single referral or authorization requires.
• System adoption: the share of required workflow steps actually completed in the system of record versus email or a spreadsheet.

Express the result in staff minutes per referral and dollars per completed admission, not as a list of tools you happen to be running.

The fix is a layer, not another tool

Connecting the clinical record to the rest of the operation is the more durable fix than swapping any single piece of software. An operational layer that reads from the EHR, unifies admissions, census, referral tracking, billing visibility, and alumni into one connected view, and ships with sensible defaults, turns four tabs into one workflow.

That layer has to respect what the clinical record already protects. Behavioral health data carries obligations under 42 CFR Part 2, HIPAA, and state confidentiality law that general business software was never built around. The goal is controlled reuse of authorized data: clear role based access, an audit trail, one owner per data field, and only the information a referral, an authorization, or a claim actually needs moving between systems. If a spreadsheet still has a job after that, it should be a governed exception report, not a second operating system running in parallel with the first.

For centers mapping this transition, the resource centers at vprogo.com and vproemr.com have further guides on connecting admissions, utilization review, and revenue cycle workflows around an existing EHR.