BCBA Caseload/Hours Tracker | Google Sheets Template for Client & Authorization Management

Simplify your BCBA caseload management with our BCBA Caseload & Authorization Hours Tracker! Designed for busy BCBAs, this comprehensive tool allows you to effortlessly manage client schedules, track authorized hours, and stay organized with supervision notes—all in one easy-to-use Google Sheets template.

Key Features:

1. Client Info Sheet: Keep all essential client details in one place, including client names, assigned RBTs, therapy schedules, and supervision hours. This clear structure helps ensure that client management is both organized and efficient.

2. Authorization Hours Tracking: Stay on top of authorization hours for 97155, 97156, 97153, and 97151 service codes. The spreadsheet automatically calculates used and remaining hours, preventing you from exceeding authorization limits.

3. Time Sheet: Log daily session times for each client with auto-calculated session durations, helping you keep accurate records of service delivery.

4. Data Analysis: Get instant insights with built-in data analysis for tracking hours worked and supervised. This feature helps you easily monitor your service provision and adjust as needed.

5. Weekly & Monthly Views: The tracker is optimized to handle both weekly and monthly schedules, giving you flexibility based on your needs.

6. Simple Setup Instructions: A ‘How To Use’ tab provides clear guidance for quick and easy setup.

Why Choose This Tracker?

1. Saves Time: Automatically tracks and updates client hours, giving you more time to focus on delivering quality services.

2. Customizable & User-Friendly: Designed for easy navigation, this spreadsheet is ideal for BCBAs looking for a practical and professional way to manage their caseload.
3. Clear Visualization: Color-coded and auto-updated features provide a visual representation of used vs. remaining hours, so you never miss a beat.

If this tracker doesn’t quite fit your needs, feel free to message me! I offer custom templates to suit your unique requirements.