Why ABA Centers Outgrow Spreadsheet-Based Intake

Nearly every ABA center starts intake in a spreadsheet, and for good reason. It is free, everyone knows how to use it, and when you have a dozen referrals a month it genuinely works. One coordinator, one tab, one row per family, a column for status, and a notes cell that grows until it needs its own scroll bar.

Then the center adds a second coordinator. Then a second location. Then a payer that requires physician verification before authorization. The spreadsheet does not fail all at once — it fails in small, expensive ways that are easy to attribute to people rather than the tool. This post walks through where spreadsheet intake breaks and compares it directly with a purpose-built ABA intake pipeline.

What is spreadsheet-based intake?

Spreadsheet-based intake is the practice of tracking ABA referrals in a shared spreadsheet where each row represents a family and columns capture status, contact attempts, insurance details, and notes. Documents live elsewhere — a shared drive, email attachments, a fax machine tray — and the spreadsheet holds pointers or, more often, nothing at all about them.

It is a list, and a list is a reasonable model for a queue with one owner and one kind of work. ABA intake is neither.

Where spreadsheets break

Ownership becomes invisible

A spreadsheet has an "assigned to" column, but nothing enforces it. Rows get reassigned without notice, two people work the same family, and a family nobody is working looks identical to one being actively followed. Referral leakage traces back to this ambiguity more than anything else.

Documents are not in the row

Referral faxes, insurance cards, ADOS-2 reports, signed consents, and the Plan of Care are the substance of intake, and none of them live in a cell. A coordinator answering "do we have the diagnostic report yet?" has to leave the spreadsheet and search a drive or an inbox. The status column says "Diagnostics" but cannot say what is actually missing.

Stages have no definition

"Pending Docs" means something different to each coordinator. Without a per-stage checklist, moving a row forward is a judgment call, and reports built on the status column measure opinions rather than progress.

Eligibility is a separate errand

Insurance verification happens in a payer portal or clearinghouse and the result is typed back into a cell, if it is typed at all. There is no link between the plan on the row and the plan that was checked, and no record of when.

Multi-location means multiple spreadsheets

The second location gets its own tab or its own file. Organization-level questions — how many families are waiting on an FBA across all sites — now require someone to combine the sheets by hand, every week, forever.

Reporting is a manual project

Average age in stage, conversion by referral source, closure reasons by month: each is possible in a spreadsheet and each requires someone to build and maintain formulas that break when a column moves. Most centers give up and report counts only.

There is no audit trail

Who changed the status, when, and from what? Version history in a shared spreadsheet is technically present and practically unusable. For a workflow full of protected health information, that is a compliance gap, not just an inconvenience.

Spreadsheet vs. ABA intake pipeline: side by side

The pattern in the right column is that every piece of intake work touches one record. That is the difference between a list and a system.

What the pipeline looks like in practice

TargetFlo's Intake & Referrals module presents referrals as a kanban board across the nine ABA stages: New Intake, Insurance, Pending Documents, Diagnostics, FBA, POC, Pending Authorization, Enrolled, and Closed. Each card carries its owner, its stage checklist, its documents, and its activity history.

Inbound referral faxes arrive in the fax inbox, where OCR and AI extraction pre-fill demographics and the coordinator links the fax to a card in one step. Insurance details on the card drive a real-time eligibility check in the Insurance & Eligibility module, with the result stored on the record. Guardians sign the Plan of Care through the parent portal, and the POC checklist completes when they do.

The board is per location, and the dashboard rolls locations up. "How many families across the organization are waiting on a parent signature" takes one glance.

Signals that you have outgrown the spreadsheet

You do not need to wait for a crisis. Any of the following is a reliable signal:

• Two or more people edit the intake spreadsheet in the same week.
• You have opened a second location, or plan to within a year.
• More than about 20 referrals are open at once.
• A family has been "lost" — nobody followed up and nobody noticed for more than two weeks.
• Leadership asks for conversion by referral source and the answer takes more than a day.
• A payer audit or a compliance review asked who accessed a record and when.

For a deeper look at the multi-site version of this problem, read Managing Multi-Location ABA Centers Without Spreadsheet Chaos.

Making the move without losing history

Migrating off a spreadsheet is less painful than it looks, because the spreadsheet holds less than people think. Demographics, guardian contacts, insurance details, current stage, and owner import cleanly as client records and cards. Documents are re-linked from the shared drive, and the notes cell becomes the first entry in the record's activity log.

Most centers run both in parallel for two to four weeks, then retire the spreadsheet once the weekly review runs from the board. What they notice first is not speed — it is that nobody asks "who has the Nguyen family?" anymore, because the card says so. For the operating rhythm that makes the pipeline work, see 9-Stage ABA Intake Pipeline: Best Practices for Therapy Centers.