Answer page · Updated 2026-10-21
What should an IEP caseload tracker include?
An IEP caseload tracker should list every student once with their last annual IEP date and last evaluation date, then calculate the next annual review and 3-year re-evaluation due dates, the days left, and a color status. Add tabs for services and minutes, accommodations, and a meeting log with follow-ups, plus one printable page sorted by the next deadline.
The tabs and columns to set up
| Tab | Columns |
|---|---|
| Caseload | Student (initials or ID), grade, eligibility, case manager, last annual IEP date, last evaluation date, override date, parent/guardian, notes |
| Due dates | Annual IEP due, re-evaluation due, days left, status (Overdue / Urgent / Upcoming / On track), next deadline |
| Services | Service, planned minutes per week or month, delivered minutes, minutes short |
| Accommodations | A checklist grid of the accommodations on your caseload |
| Meeting log | Date, student, meeting type, attendees, decisions, follow-up task, owner, due date |
| Settings | Cycle lengths (for example 12 and 36 months), warning windows (for example 30 and 60 days), dropdown lists |
Step by step
- List each student once. One row per student with their last annual IEP and last evaluation dates. Use initials or IDs.
- Calculate the due dates. Annual due = last IEP date plus 12 months, for example =EDATE(E2,12). Re-evaluation due = last evaluation plus 36 months, =EDATE(F2,36). Confirm your state and district timelines first.
- Count down the days. Days left = due date minus =TODAY(). Color each row with conditional formatting: overdue, within 30 days, within 60 days, or on track.
- Find the next deadline. Use =MIN() of the two due dates per student, then SORT the caseload by it so the soonest is on top.
- Add services, accommodations and meetings. Keep these on their own tabs that reference the same student list, so you never retype names.
- Print a deadline list. Make one landscape view with every student's next deadline, soonest first, for planning meetings.
Skip the setup
This is the template we make for exactly this job:
IEP Caseload Tracker (Google Sheets)
Annual IEP and 3-year re-evaluation due dates counted down and color-coded for up to 60 students, plus services, a 16-item accommodations grid, a meeting log and a one-page print view. Eight tabs.
$9.99 on EtsySee it on Etsy
Frequently asked questions
What is the most important column in a caseload tracker?
The last annual IEP date and last evaluation date, because every due date and countdown is calculated from them.
How do I calculate an annual IEP due date in Google Sheets?
Use =EDATE(last_IEP_date,12) for a 12-month cycle, and =EDATE(last_eval_date,36) for a 3-year re-evaluation. Adjust if your state uses a different timeline.
Can I color-code IEP deadlines automatically?
Yes. Use Format > Conditional formatting with custom formulas on the days-left column, for example red below 0 and orange below 30.
Should the tracker include service minutes and accommodations?
It helps. Keeping services, accommodations and meetings in the same file as due dates means one place to check before a meeting.
Does a caseload tracker replace the district IEP system?
No. It is a planning aid. Always confirm due dates in your district's IEP system, and protect student privacy with initials or IDs.
Is there a ready-made caseload tracker?
Yes. The Fieldwork IEP Caseload Tracker is a Google Sheets file with Caseload, Due Dates, Services, Accommodations, Meeting Log, Print View and Settings tabs already built ($9.99 on Etsy).
More answers: all Fieldwork answer pages