Skip to content
NHQualityCampaign.orgIndependent nursing home quality resource
Professional ToolkitFor professionals

Nursing Home Tracking Tool Templates: Columns, Formulas, Run Charts

A good nursing home tracking tool is a one-row-per-event log with fixed columns, a monthly rate formula and a run chart. Below are free, original templates for pressure injuries, falls, pain, infections, consistent assignment, turnover, hospitalizations and antipsychotics that you can rebuild in any spreadsheet.

Updated 7 min readHow we research
Clinician writing on a patient chart on a clipboard
Photo: Vitaly Gariev (Unsplash License). Credits

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

Pressure injury log: one row per wound
ColumnEntryWhy it matters
Resident ID / unitID, unitSpot unit clusters
Date first observedDateMonthly incidence
Present on admission?Yes / NoSeparates facility-acquired from admitted wounds
LocationSacrum, heel, ischium, device-related…Targets prevention (e.g., heel offloading)
Stage at discovery1, 2, 3, 4, unstageable, DTPI (NPIAP)Severity; MDS Section M alignment
Risk score at last assessmentBraden score and dateWas risk identified in time?
Prevention in place?Surface, turning plan, nutrition, moistureProcess measure
Status at month endOpen, healed, worsened, dischargedHealing 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

Falls log: one row per fall
ColumnEntry
Resident ID, unit, roomText / list
Date, time, shiftDate, time, Day/Evening/Night
Location and activityBedroom, bathroom, hallway; toileting, transferring, walking
Witnessed?Yes / No
Injury levelNone, minor, major (fracture, joint dislocation, head injury with altered consciousness, subdural hematoma)
Contributing factorsNew 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

Pain monitoring log: one row per resident per assessment
ColumnEntry
Resident ID, unitText
Can self-report?Yes / No
Tool usedNRS 0–10, verbal descriptor, FPS-R, PAINAD
Score and dateNumber, date
InterventionScheduled analgesic, PRN, non-drug, therapy referral
Reassessment score and timeNumber, 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

Infection surveillance line list
ColumnEntry
Resident ID, unit, roomText
Onset dateDate of first symptom
Infection typeUTI, respiratory, skin/soft tissue, GI, C. diff, bloodstream, other
Meets surveillance definition?Yes / No (state criteria used, e.g., revised McGeer)
Culture / test and organismText
Antibiotic started? Name, start dateYes / No; text
Antibiotic time-out at 48–72hContinued, changed, stopped
PrecautionsStandard, 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.

Consistent assignment grid (one tab per unit per month)
Resident IDDay 1 CNADay 2 CNA… Day 30 CNADistinct CNAs (formula)
R-104LopezLopezKim=COUNTA(UNIQUE(B2:AE2))
R-105LopezAgencyLopez=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

Monthly staff stability log
ColumnEntry
MonthDate
Headcount at start / end, by role (RN, LPN, CNA)Number
Separations (voluntary / involuntary)Number
New hiresNumber
Separations within 90 days of hireNumber (early turnover)
Agency hoursHours

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

Hospital transfer log: one row per transfer
ColumnEntry
Resident ID, short-stay or long-stayText / list
Transfer date, time, shiftDate, time
Reason / conditionFall, respiratory, sepsis, change in mental status, cardiac, other
ED only or admitted?ED / Admitted / Observation
Days since admission to the facilityNumber (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

Psychotropic review log
ColumnEntry
Resident ID, long-stay?Text, Yes / No
Drug, dose, start dateText
Documented diagnosis / indicationText
Excluded diagnosis for Care Compare measure?Schizophrenia, Huntington’s disease, Tourette’s syndrome
Target behaviors and non-drug approaches triedText
Last gradual dose reduction (GDR) attemptDate, outcome
Next review dueDate

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?

  1. 1
    Summarize monthly
    On the summary tab, compute each month's rate with the formula for that measure.
  2. 2
    Plot the line
    Chart months on the x-axis and the rate on the y-axis. Use at least 10 to 12 data points before reading patterns.
  3. 3
    Add the median
    Add a horizontal line at the median of the baseline months (=MEDIAN(range)). Freeze it when you start your intervention.
  4. 4
    Apply the rules
    A 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.
  5. 5
    Annotate
    Label 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

  1. CMS Nursing Home Quality Measures
  2. CMS MDS 3.0 Resident Assessment Instrument (RAI) Manual
  3. NPIAP pressure injury stages (staging poster)
  4. CDC Core Elements of Antibiotic Stewardship for Nursing Homes
  5. IHI Run Chart Tool

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.