These templates are our own and free to adapt. Copy the column headers into Excel or Google Sheets, add the formulas, and keep one tab per month plus a summary tab. They complement the official tools listed on the QI toolkit hub and replace nothing in your EHR or MDS.
What makes a good nursing home tracking tool?
- One row per event or resident. Each fall, new pressure injury or transfer gets its own row, so you can filter and count.
- Drop-down lists, not free text. Units, injury levels, stages and infection types should be picked from a list so counts are reliable.
- A denominator tab. Record monthly resident-days and census so the tool can compute rates.
- Resident IDs, not names, in shared files. Store the minimum identifiable information and keep files on a secured drive.
- A clear owner. Every log needs a named person who updates it and a backup.
If your team keeps reinventing these logs, a shared template library for incident logs and review forms helps every unit use the same version.
Pressure injury tracking template
| Column | Entry | Why it matters |
|---|---|---|
| Resident ID / unit | ID, unit | Spot unit clusters |
| Date first observed | Date | Monthly incidence |
| Present on admission? | Yes / No | Separates facility-acquired from admitted wounds |
| Location | Sacrum, heel, ischium, device-related… | Targets prevention (e.g., heel offloading) |
| Stage at discovery | 1, 2, 3, 4, unstageable, DTPI (NPIAP) | Severity; MDS Section M alignment |
| Risk score at last assessment | Braden score and date | Was risk identified in time? |
| Prevention in place? | Surface, turning plan, nutrition, moisture | Process measure |
| Status at month end | Open, healed, worsened, discharged | Healing rate |
- Incidence: new facility-acquired stage 2+ pressure injuries in month ÷ resident-days × 1,000.
- Prevalence: residents with any stage 2+ pressure injury on a fixed day ÷ census that day × 100.
- Process: % of high-risk residents (Braden 18 or below) with a documented prevention plan.
Clinical background and staging live on our pressure injury prevention page.
Falls tracking template
| Column | Entry |
|---|---|
| Resident ID, unit, room | Text / list |
| Date, time, shift | Date, time, Day/Evening/Night |
| Location and activity | Bedroom, bathroom, hallway; toileting, transferring, walking |
| Witnessed? | Yes / No |
| Injury level | None, minor, major (fracture, joint dislocation, head injury with altered consciousness, subdural hematoma) |
| Contributing factors | New meds, sedatives, footwear, alarm, toileting need, environment |
| Post-fall huddle within 24h? | Yes / No |
| Care plan updated? | Yes / No and date |
- Fall rate: falls ÷ resident-days × 1,000.
- Injurious fall rate: falls with major injury ÷ resident-days × 1,000. The "major injury" categories match the MDS falls items (J1800/J1900) used for the long-stay Care Compare measure.
- Repeat fallers: % of residents with 2+ falls in 90 days.
For prevention strategies, see falls prevention in nursing homes; for investigating a serious fall, use our root cause analysis worked example.
Pain tracking template
| Column | Entry |
|---|---|
| Resident ID, unit | Text |
| Can self-report? | Yes / No |
| Tool used | NRS 0–10, verbal descriptor, FPS-R, PAINAD |
| Score and date | Number, date |
| Intervention | Scheduled analgesic, PRN, non-drug, therapy referral |
| Reassessment score and time | Number, time after intervention |
| Pain interfering with sleep or activity? | Yes / No |
Key rate: % of residents with moderate-to-severe pain (for example NRS 4 or more, or PAINAD 4 or more as set by your policy) at their latest assessment. Track the process measure "% of PRN doses with reassessment documented within the policy window." Tool details are on the pain assessment tools page.
Infection tracking template
| Column | Entry |
|---|---|
| Resident ID, unit, room | Text |
| Onset date | Date of first symptom |
| Infection type | UTI, respiratory, skin/soft tissue, GI, C. diff, bloodstream, other |
| Meets surveillance definition? | Yes / No (state criteria used, e.g., revised McGeer) |
| Culture / test and organism | Text |
| Antibiotic started? Name, start date | Yes / No; text |
| Antibiotic time-out at 48–72h | Continued, changed, stopped |
| Precautions | Standard, contact, enhanced barrier, droplet |
Rate: infections meeting surveillance criteria ÷ resident-days × 1,000, by type. Pair with antibiotic starts per 1,000 resident-days, an outcome measure CDC's stewardship core elements encourage. C. diff gets its own template on the C. diff infection tracking page.
Consistent assignment tracking template
Consistent assignment means the same nurse aides care for the same residents most of the time. There is no CMS measure for it, so you define it. The simplest tool is a monthly grid.
| Resident ID | Day 1 CNA | Day 2 CNA | … Day 30 CNA | Distinct CNAs (formula) |
|---|---|---|---|---|
| R-104 | Lopez | Lopez | Kim | =COUNTA(UNIQUE(B2:AE2)) |
| R-105 | Lopez | Agency | Lopez | =COUNTA(UNIQUE(B3:AE3)) |
Report the median distinct CNAs per resident per month (day shift, then all shifts) and the % of shifts covered by the resident's primary CNA. Lower distinct counts are better. Background: consistent assignment.
Staff turnover tracking template
| Column | Entry |
|---|---|
| Month | Date |
| Headcount at start / end, by role (RN, LPN, CNA) | Number |
| Separations (voluntary / involuntary) | Number |
| New hires | Number |
| Separations within 90 days of hire | Number (early turnover) |
| Agency hours | Hours |
Annual turnover % = separations over the last 12 months ÷ average headcount × 100. Run the numbers in our staff turnover calculator, which also explains how Care Compare's PBJ-based measure differs from an HR calculation.
Hospitalization tracking template
| Column | Entry |
|---|---|
| Resident ID, short-stay or long-stay | Text / list |
| Transfer date, time, shift | Date, time |
| Reason / condition | Fall, respiratory, sepsis, change in mental status, cardiac, other |
| ED only or admitted? | ED / Admitted / Observation |
| Days since admission to the facility | Number (30-day readmission flag) |
| Practitioner contacted before transfer? | Yes / No |
| Considered potentially avoidable on review? | Yes / No / Unsure |
Rates: transfers ÷ resident-days × 1,000; % of short-stay admissions transferred back to hospital within 30 days. Review a sample monthly for avoidability. INTERACT tools support this review; see avoidable hospitalizations.
Antipsychotic tracking template
| Column | Entry |
|---|---|
| Resident ID, long-stay? | Text, Yes / No |
| Drug, dose, start date | Text |
| Documented diagnosis / indication | Text |
| Excluded diagnosis for Care Compare measure? | Schizophrenia, Huntington’s disease, Tourette’s syndrome |
| Target behaviors and non-drug approaches tried | Text |
| Last gradual dose reduction (GDR) attempt | Date, outcome |
| Next review due | Date |
Rate: long-stay residents receiving an antipsychotic (excluding the listed diagnoses) ÷ eligible long-stay residents × 100. This approximates the Care Compare long-stay measure. More context: antipsychotic reduction.
How do you build a run chart from a tracking log?
- 1Summarize monthlyOn the summary tab, compute each month's rate with the formula for that measure.
- 2Plot the lineChart months on the x-axis and the rate on the y-axis. Use at least 10 to 12 data points before reading patterns.
- 3Add the medianAdd a horizontal line at the median of the baseline months (=MEDIAN(range)). Freeze it when you start your intervention.
- 4Apply the rulesA shift is six or more consecutive points above or below the median. A trend is five or more consecutive points all going up or all going down. Points on the median do not count toward or break a shift.
- 5AnnotateLabel the months when you introduced a change so the QAA committee can link actions to results.
Frequently asked questions
What should be included in a nursing home falls log?
Record the resident ID, unit, date, time and shift, location, activity at the time, whether the fall was witnessed, injury level, contributing factors, whether a post-fall huddle happened within 24 hours, and whether the care plan was updated. Those fields let you calculate fall rates, injury rates and process compliance each month.
How do you calculate a fall rate per 1,000 resident-days?
Divide the number of falls in the month by the month's resident-days, then multiply by 1,000. Resident-days are the total of each day's midnight census. For example, 12 falls in a month with 3,600 resident-days gives 3.3 falls per 1,000 resident-days.
What is the difference between pressure injury incidence and prevalence?
Incidence counts new pressure injuries that develop during a period, usually expressed per 1,000 resident-days or per 100 admissions. Prevalence is a snapshot: the percent of residents who have a pressure injury on a given day, whether it developed in the facility or before admission. Incidence is better for judging prevention.
How do you measure consistent assignment?
Build a monthly grid listing each resident and the nurse aide assigned each day, then count distinct aides per resident. Report the median for the unit and the percent of shifts covered by each resident's primary aide. CMS does not publish a consistent assignment measure, so define yours in writing and keep it stable.
What is a run chart and why use it in QAPI?
A run chart plots a measure over time with a median line. It shows whether changes are followed by real improvement or just normal variation. Simple rules flag signals: six or more points in a row on one side of the median is a shift, and five or more points steadily rising or falling is a trend.
Are these tracking tools official CMS forms?
No. These are original templates written for this independent educational site. They follow official definitions where they exist, such as NPIAP staging, MDS falls items and CDC NHSN surveillance rules, but they are not CMS or CDC forms. Check your state requirements and your EHR's built-in reports as well.
Sources
Independent resource. NHQualityCampaign.org is an independent educational resource. It is not affiliated with, endorsed by or operated by the Centers for Medicare & Medicaid Services (CMS), the U.S. Department of Health and Human Services (HHS), any government agency, or the original Advancing Excellence in America’s Nursing Homes campaign or its sponsors. Historical campaign information is summarized with attribution for educational purposes.
Related reading
QI toolkitA nursing home QI toolkit is a small set of measures, tracking logs, run charts and improvement methods that…
Staff turnover calculatorAnnual staff turnover is the number of employees who left in 12 months divided by your average headcount…
C. diff trackingTrack C. diff in a nursing home by logging each positive stool test, classifying it with CDC NHSN LabID rules…
Implementation guidesEvery nursing home improvement project follows one arc: form a team, measure a baseline, set a target, test…
Falls preventionNursing homes prevent falls best by finding and fixing each resident's specific causes: medications…
Survey readiness checklistSurvey readiness means having entrance-conference documents ready, running mock surveys against the…
