School Counselor Caseload Tracker
A practical guide to managing and documenting your counseling caseload — including ASCA recommended ratios, Texas SB 179 80/20 compliance, what to track, and how to stop losing hours to paperwork.
A practical guide to managing and documenting your counseling caseload — including ASCA recommended ratios, Texas SB 179 80/20 compliance, what to track, and how to stop losing hours to paperwork.
School counselors are stretched thin. The American School Counselor Association (ASCA) recommends a ratio of 250 students to 1 counselor. The national average exceeds 385:1. In many Texas districts, the number is even higher — some secondary campuses operate at 450:1 or more.
When your caseload is that heavy, documentation is usually the first thing that suffers. But documentation is exactly what you need to (a) protect yourself professionally, (b) demonstrate the value of your program, and (c) comply with state requirements that carry real consequences.
Without a tracking system, counselors cannot answer basic questions their principal or superintendent might ask: How many students did you see this month? What percentage of your time went to responsive services versus testing coordination? Are you meeting the SB 179 threshold?
Texas Senate Bill 179 (86th Legislature, 2019) reshapes how counselors spend their time. Under TEC §33.006, school counselors must spend at least 80% of their total work time on duties that are components of the school counseling program as defined by the Texas Model for Comprehensive School Counseling Programs. (Note: this is distinct from "David's Law" / SB 179 of the 2017 session, which addressed cyberbullying and added TEC §37.0832.)
The remaining 20% can include administrative tasks, testing coordination, substitute coverage, lunch duty, and other non-counseling responsibilities that districts often assign to counselors by default.
What counts toward the 80%:
Direct services (individual counseling, small group counseling, classroom guidance lessons, crisis response) and indirect services (consultation with teachers/parents, referrals to outside agencies, program planning, data analysis for student outcomes).
What falls in the 20%:
Testing coordination, 504 chairing (unless it involves counseling), scheduling, administrative meetings unrelated to student counseling, clerical tasks, and substitute teaching.
Principals are responsible for ensuring compliance, and TEA can request documentation during monitoring visits. If a counselor cannot show that the 80/20 split is being met, the district — not just the counselor — is out of compliance.
An effective caseload tracker captures more than just "I met with a student." Here is what a complete system documents:
Student name, date, duration, presenting concern, session notes (brief and FERPA-appropriate), and follow-up plan. Track whether the session was scheduled or responsive (walk-in, crisis). This distinction matters for SB 179 reporting and for understanding your responsive services load.
Group name, topic (grief, social skills, academic motivation, etc.), student roster, session number in the series, attendance, and facilitator notes. Small groups are one of the most effective interventions counselors deliver, but they are also one of the hardest to document consistently.
Teacher, grade level, topic, date, and alignment to the Texas Model domains (academic, career, personal/social). Track student count for program evaluation data.
Crisis interventions, threat assessment participation, suicide risk screenings, and parent contacts related to student safety. These need timestamps, not just dates, because response time matters in crisis situations.
Meetings with teachers, parents, or outside agencies on behalf of students. Document the purpose, participants, and outcome. Track referrals to community mental health providers, including whether the family followed through.
Testing coordination time, schedule changes, 504 paperwork, lunch/hall duty, and any other task that falls outside the counseling program. You need to track this to prove you are staying within the 20% cap.
The best caseload tracking systems share a few characteristics:
Beacon is our counselor command center designed around the Texas Model for Comprehensive School Counseling Programs. It handles caseload tracking, SB 179 time compliance, small group management, and responsive services logging — all in one place.
Learn About Beacon →The American School Counselor Association (ASCA) recommends a ratio of 250 students to 1 counselor. The national average is significantly higher, often exceeding 385:1. Texas averages vary by district, but many campuses — particularly at the secondary level — operate well above the ASCA recommendation.
Texas Senate Bill 179 (David's Law, amended) requires school counselors to spend at least 80% of their time on direct and indirect counseling services as defined by the Texas Model for Comprehensive School Counseling Programs. The remaining 20% can be used for administrative tasks, testing coordination, and other non-counseling duties. Counselors must be able to document this time split, and principals are responsible for ensuring compliance.
An effective caseload tracker should document individual counseling sessions, small group sessions, classroom guidance lessons, responsive services (crisis intervention, threat assessment participation), consultation and collaboration with staff and parents, referrals to outside agencies, and time spent on non-counseling duties. It should categorize each activity to generate SB 179 compliance reports automatically.
Counselors need a time-tracking system that categorizes each activity as either direct/indirect counseling services (counting toward the 80%) or non-counseling duties (the 20%). At minimum, districts should be able to generate a monthly or quarterly report showing the percentage split. Principals and district administrators may be asked to verify this data during TEA reviews.