How to Track Employee Training in a Care Agency (Without Spreadsheets)

Ask a care agency manager how they track staff training and you'll often hear about a spreadsheet: one row per employee, one column per required course, color-coded cells and a lot of hope. It works until it doesn't, usually right before a licensing visit, when someone finds a CPR card that expired three weeks ago or a new hire who worked alone before finishing orientation.

This post explains what state rules actually expect you to track, why spreadsheets struggle with it, and what to look for in training tracking software built for human services.

What regulators expect you to prove

Training rules vary by state and service type, but they share a pattern: specific courses, specific deadlines tied to each employee's hire date, recurring renewals, and records detailed enough to prove all of it. A few examples from rules we've covered:

• Pennsylvania requires a training record for every person trained, showing the source, content, dates, length, certificates and attendees, under 55 Pa. Code § 6100.141. Orientation has to be done before a new staff member works alone, and annual training hours are required after that.
• New Jersey staggers DSP training deadlines from before a DSP works with anyone through 60, 90, 120 and 180 days after hire, with annual professional development hours on top, according to the DDD provider guide.
• New York requires every staff member certified to give medications (an AMAP) to be recertified every 365 days by a registered nurse.
• Massachusetts says plainly, in its MAP policy on training and testing, that it is the responsibility of both the service provider and the certified staff member "to track the MAP Certification period and to assure MAP Certification remains current and valid."

So the question isn't whether training gets done. It's whether you can show, for any employee on any date, that each requirement was met on time.

Why spreadsheets break down

Spreadsheets are a reasonable place to start, and plenty of agencies run on them. They tend to fail in the same few ways as an agency grows.

Every person has a different clock. Deadlines like "within 90 days of hire" and "every two years" mean each employee's due dates are different. A spreadsheet can calculate them, but only if every hire date and completion date is entered correctly and every formula survives copying and sorting.

Nothing warns you. A spreadsheet doesn't send reminders. Someone has to remember to open it, filter it and chase people, and expirations get missed when that person is out or busy.

The proof lives somewhere else. Regulators want certificates, sign-in sheets and transcripts, not just a checkmark. When those live in email, paper files and state portals, pulling a complete file for an audit becomes a project.

Multiple programs, multiple rule sets. Agencies that provide several services, or work in more than one state, may face different requirements for different staff. One grid rarely captures that cleanly.

Version control. When several managers keep their own copies, nobody is sure which one is current.

What to look for in training tracking software

If you're moving off spreadsheets, these are the capabilities that matter most for care agencies.

Requirements mapped to your rules

Generic learning systems track courses. Human services agencies need to track requirements: which training satisfies which rule, when it's first due and how often it renews. Look for software that can model state requirement sets rather than making you rebuild them yourself.

Due dates and renewals calculated per person

The system should work out each staff member's deadlines from their hire date and completion history and show what's coming due before it's late.

Automated reminders and alerts

Reminders to staff and alerts to managers about upcoming deadlines and gaps take memory out of the process.

Room for training done elsewhere

Not all required training happens in your system. CPR classes, state-run modules and in-person competency checks have to be recorded too, with the proof attached, so your records are complete in one place.

Audit-ready reports

You should be able to pull a compliance view for one person, one site or the whole agency in minutes, and export it for a surveyor.

Built for your workforce

Your staff aren't sitting at desks all day. Look for mobile-friendly access, courses in the languages your staff speak and training that fits around shift schedules.

A simple way to start

You don't need to switch systems overnight. Start by doing this:

1. List every requirement that applies to each role, with the rule it comes from, when it's first due and how often it renews.
2. Gather the proof you already have for each staff member and note what's missing.
3. Fix the urgent gaps first: anything expired, and anyone doing work they aren't yet trained for.
4. Pick one system of record and retire the extra copies.

That list of requirements is also exactly what you'll need to set up any tracking software, so it's worth doing either way.

How TES handles training tracking

Training & eTracking Solutions has spent more than 15 years building training and compliance tools for human services. Our reporting and tracking tools give managers dashboards and automated alerts for approaching deadlines and compliance gaps. The new TeTS platform adds a live compliance grid that shows every staff member against every requirement, with audit-ready exports.

Our compliance pathways map state requirement sets, showing what each requirement asks for, when it's first due and how often it renews, and they can track training completed outside TES as external evidence. For examples of what those requirements look like, see our guides to Pennsylvania's Chapter 6100 training rules and Maryland's DDA training attestation.

Ready to retire the spreadsheet? Talk to our team about setting up training tracking for your agency.

The state examples above summarize the cited rules and guidance as of October 2026. Requirements vary by state, program and role and can change, so check your state's current rules before making training or staffing decisions.