Skip to main content

Free Excel spreadsheet

Know Exactly Who’s Trained, And Who’s Overdue

CMS requires documented evidence of staff training and competency. One missing record during a survey can trigger a deficiency. This tracker ensures every employee’s training status is visible at a glance.

  • Free download
  • Excel format, fully editable
  • Staffing template

The problem

Nursing homes are required to provide and document mandatory training on topics including abuse prevention, infection control, fire safety, HIPAA, and resident rights, plus role-specific competency evaluations for clinical staff. With high turnover rates, tracking who has completed which training becomes a logistical challenge. Most facilities rely on paper sign-in sheets stored in binders that nobody cross-references. When surveyors ask to see training documentation for a specific employee or topic, the resulting scramble reveals gaps that could have been prevented with systematic tracking.

What this template gives you

Our SNF Training & Competency Tracker is an Excel workbook that provides complete visibility into your facility’s training compliance. Track mandatory training completion by employee and topic, monitor upcoming due dates for annual renewals, document competency evaluations with pass/fail results, and generate reports showing facility-wide training completion rates. Color-coded alerts highlight overdue training before it becomes a survey finding.

What is inside

  • Employee training matrix showing completion status for all mandatory topics by staff member
  • Training schedule with CMS-required topics, frequency requirements, and next-due-date tracking
  • Competency evaluation log for clinical staff with skills checklists and assessor documentation
  • Automated alerts for training approaching renewal (30, 60, 90 days) with color-coded status
  • Facility-wide compliance dashboard showing overall training completion rates by topic and department

Who it is for

  • Staff development coordinators responsible for mandatory training programs and documentation
  • Directors of Nursing tracking clinical competency evaluations for nursing staff
  • SNF administrators who need survey-ready training documentation across all departments
  • Facilities with recent survey deficiencies related to incomplete training records

SNF Training & Competency Tracker FAQs

What training topics are included in the tracker?

The tracker comes pre-configured with CMS-required training topics: abuse prevention and reporting, infection control, fire safety and emergency preparedness, HIPAA and privacy, resident rights, fall prevention, dementia care, restraint reduction, and bloodborne pathogens. It also includes role-specific sections for CNA skills competencies, medication administration competencies (for licensed nurses), and dietary safety training. You can add custom training topics for your facility or state requirements.

How do the training due date alerts work?

Each training topic has a defined frequency (annual, semi-annual, or custom). The tracker calculates the next due date based on the last completion date and automatically color-codes the status: green (current), yellow (due within 60 days), orange (due within 30 days), and red (overdue). The dashboard provides a summary count of overdue items so you can prioritize scheduling.

Can I track competency evaluations separately from classroom training?

Yes. The tracker has separate sections for classroom/online training completion and hands-on competency evaluations. Competency evaluations include fields for the skill assessed, the evaluator’s name and credentials, the assessment method (observation, demonstration, return demonstration), the result (met/not met), and any remediation required. This distinction is important because surveyors evaluate both training attendance and demonstrated competency.

How does this handle new hires?

When you add a new employee to the tracker, it automatically flags all required orientation training as due. You can set orientation-specific deadlines (e.g., abuse prevention within 24 hours of hire, HIPAA within first week) and track completion against those targets. This ensures new hires complete all required training within regulatory timeframes, a common area where facilities fall short during surveys.

Can I generate reports for survey binder preparation?

Yes. The tracker can generate filtered reports by employee (showing all training for one person), by topic (showing all employees’ completion for one training), or by department. These reports format neatly for printing and inclusion in your survey binder. Having this documentation organized and ready to present demonstrates proactive compliance management to surveyors.

Free 15-minute call

Want help putting this template to work?

  1. Free 15-minute callTell us what is going on. You will get honest feedback on what to fix first, even if you never hire us.
  2. A clear scopeWe put the plan, the team and the hourly rate in writing before any work starts.
  3. Ongoing supportYour HR and payroll team takes it from there. Scale hours up or down whenever you need.