Somewhere in your practice right now, there is a spreadsheet tracking supervision hours. It might be in Google Sheets. It might be in Excel. It might be a paper log stuffed in a binder. Whatever form it takes, it is almost certainly incomplete, potentially inaccurate, and definitely not the system you want to present during an audit.
Supervision tracking is one of the most critical compliance obligations in ABA practice, and it is one of the most commonly mismanaged. Not because practices do not care, but because the tools most practices use for tracking were never designed for it. Spreadsheets are general-purpose tools being forced into a compliance-specific role, and the cracks show.
This guide covers what BACB actually requires for supervision, why spreadsheets create genuine compliance risk, and what a modern approach to supervision tracking looks like in practice.
What BACB Actually Requires
Before we talk about how to track supervision, let us be precise about what needs to be tracked. BACB requirements are specific, and the details matter.
RBT Supervision Requirements
Registered Behavior Technicians must receive ongoing supervision that meets these criteria:
- Minimum 5% of direct service hours. If an RBT provides 120 hours of direct service in a month, they need at least 6 hours of supervision that month. This is not optional and not approximate. It is a hard minimum.
- At least two supervision contacts per month. Even if the 5% threshold is met in a single long session, BACB requires supervision to be distributed across at least two separate contacts within the calendar month.
- Direct observation required. A portion of supervision must include the supervisor directly observing the RBT delivering services to a client. Remote observation via telehealth can count when conducted appropriately, but not all supervision hours can be indirect.
- Supervision by a qualified supervisor. The supervising BCBA must maintain their own credentials and meet BACB's requirements for providing supervision.
Documentation Requirements
For each supervision contact, you need to document:
- Date and duration of the supervision session
- Whether observation of client services occurred
- Type of supervision activity (direct observation, individual meeting, group supervision)
- Topics covered and feedback provided
- Supervisor and supervisee signatures or attestation
- The client or clients involved, if observation occurred
This documentation must be maintained and available for review. BACB can request supervision records, and failure to produce them can result in disciplinary action against both the supervisor and the supervisee.
The Real Problems with Spreadsheet Tracking
Spreadsheets are not inherently bad. They are flexible, familiar, and free. But for supervision compliance tracking, their weaknesses become serious liabilities.
Manual data entry invites errors. Every supervision session requires someone to open a spreadsheet, find the right row, and enter the date, duration, type, and details. A single transposition error, such as entering 1.5 hours instead of 0.5 hours, can make it appear that a supervision requirement was met when it was not. Or vice versa, triggering unnecessary remediation for a compliant RBT.
Version control is a constant problem. Who has the latest version? Is it the one on the shared drive, the one Sarah emailed last Tuesday, or the one the clinical director downloaded to her laptop? When multiple people update the same spreadsheet, conflicts and overwrites happen. In a compliance context, a lost update is not just annoying. It is a potential audit finding.
No automatic calculations. Spreadsheets can include formulas, but those formulas must be manually built and maintained. When a new RBT is added, someone needs to extend the formula range. When the month changes, someone needs to update the date filters. These maintenance tasks are easy to forget and hard to verify.
No proactive alerts. A spreadsheet cannot send you a notification when an RBT is at 3.8% supervision with only one week left in the month. It cannot flag that a supervision contact has not occurred in 18 days. It simply holds data. The responsibility to check that data, interpret it, and act on it falls entirely on your supervisors and administrators, people who already have full schedules.
Auditor skepticism. When an auditor or BACB reviewer asks for supervision records and receives a spreadsheet, their first question is usually about data integrity. How do you know this data was not modified after the fact? A spreadsheet has no audit trail, no timestamps on individual cell edits (unless you are using an enterprise version control system, and you are not), and no way to prove that the data reflects what actually happened.
What Modern Supervision Tracking Looks Like
Moving beyond spreadsheets does not mean adding complexity. Done right, modern supervision tracking actually reduces the administrative burden while dramatically improving compliance confidence.
Automatic hour logging from scheduled sessions. When a supervision session is scheduled and completed in your practice management system, the hours should automatically flow into the supervision tracking record. No manual data entry. No remembering to update a spreadsheet after the session. The system of record and the compliance record are the same thing.
Real-time compliance dashboards. Instead of opening a spreadsheet and manually calculating percentages, a compliance dashboard shows you, at a glance, where every RBT stands relative to their supervision requirements. Green means compliant. Yellow means approaching a threshold. Red means action is needed now. This transforms supervision tracking from a monthly reconciliation exercise into an ongoing, manageable process.
Threshold alerts. When an RBT's supervision ratio drops below a configurable threshold, such as falling below 6% with two weeks remaining in the month, the system should automatically alert the responsible supervisor. When the second required monthly contact has not occurred by a certain date, an alert fires. These proactive notifications catch problems while there is still time to fix them.
Audit-ready reports generated instantly. When an auditor asks for supervision records for a specific RBT over a specific period, you should be able to generate a complete, formatted report in seconds. That report should include every supervision contact with dates, durations, types, and topics, along with calculated ratios and compliance status for each month. No scrambling, no reformatting, no hoping the spreadsheet formulas are correct.
Immutable audit trails. Every entry in a modern tracking system is timestamped, attributed to a user, and logged. If a record is modified, the original value and the modification are both preserved. This is the level of data integrity that auditors expect and that spreadsheets fundamentally cannot provide.
RBT Credential Management Beyond Supervision Hours
Supervision tracking does not exist in isolation. It is part of a broader credential management responsibility that includes:
- RBT certification tracking. Every RBT's certification has an expiration date. Tracking these expirations across a growing team, and ensuring renewals are completed in time, is a logistical challenge that compounds as your practice scales.
- Renewal alerts. A credential expiring is not the problem. A credential expiring without anyone noticing until the RBT shows up for a session they can no longer legally provide is the problem. Automated alerts at 90, 60, and 30 days before expiration give your team time to act.
- Continuing education tracking. RBTs must complete continuing education requirements for renewal. Tracking completed CEUs alongside credential expiration dates gives you a complete picture of each staff member's compliance status.
- Background check and clearance tracking. Many states require periodic background check renewals. These are easy to lose track of and costly to miss.
When supervision tracking, credential management, and staff records live in the same system, you gain a holistic view of each employee's compliance status. When they live in separate spreadsheets, binders, and email threads, things fall through the cracks.
What You Must Track Regardless of Your Tool
Whether you use a purpose-built system or continue with spreadsheets, here are the data points you must capture for every supervision contact to maintain BACB compliance:
- Supervisee name and credential number
- Supervisor name and credential number
- Date of supervision contact
- Start time and end time (duration)
- Type: individual, group, or direct observation
- If observation occurred, the client name and service setting
- Topics covered and competencies addressed
- Feedback provided and action items assigned
- Both parties' attestation that the session occurred as documented
Additionally, you need to maintain running totals of:
- Total direct service hours per RBT per month
- Total supervision hours per RBT per month
- Supervision percentage (supervision hours divided by direct service hours)
- Number of supervision contacts per month
- Number of contacts that included direct observation
If you cannot produce these data points quickly and confidently for any RBT at any point in time, your tracking system has a gap that needs to be addressed.
Making the Transition
If your practice is currently tracking supervision on spreadsheets and recognizing the risks described above, the transition to a proper tracking system does not have to be abrupt. Start by identifying your highest-risk area, which for most practices is the RBTs closest to supervision thresholds, and pilot the new approach with that group. Expand from there.
The goal is not perfection on day one. The goal is a system that gets more reliable over time rather than less. Spreadsheets degrade as practices grow. Purpose-built tracking scales with you.
Platforms like Wilma build supervision tracking directly into the practice management system, so supervision hours logged during scheduled sessions automatically feed compliance dashboards and audit-ready reports. It is not a separate module or an afterthought. It is part of how the system works, because in ABA, supervision compliance is not optional and should not depend on someone remembering to update a spreadsheet.