Skip to content

Why your QM tracker spreadsheet is always out of date

The spreadsheet isn’t the problem. The data it’s built from is two quarters old before anyone types it in. What that lag costs, and what a live tracker does differently.

September 29, 2026 · 4 min read · SuperLTC

Almost every building has one: a spreadsheet with a row per resident and a column per quality measure, kept by whoever has the time. It's a good instinct. It just can't keep up, and it isn't the fault of the person keeping it.

The numbers are old before you type them

Care Compare publishes quality measures as a four-quarter average, refreshed four times a year. Each refresh ends two quarters behind the calendar: the July 2026 refresh covered April 2025 through March 2026. State programs read those same files, later still. So a tracker built from published numbers is showing you work that finished six months to a year ago.

The spreadsheet only knows what someone told it

A resident triggers a measure because of what's coded on an assessment. Whether that code matches the chart, whether an assessment is coming that will change it, whether one more resident tips a measure into a lower band: none of that is in the spreadsheet unless someone looked it up and typed it in. Most weeks nobody has time.

What it misses

  • A fall coded as a major injury when the note says no injury, which then counts for about nine months.
  • A UTI that would stay off the quarter's rate if the next assessment were scheduled a few days later.
  • A building one resident from a state floor, where the difference is hundreds of thousands of dollars.

What a live tracker does instead

It reads the assessments and the notes directly, every day, and marks each resident against each measure the way CMS will. It flags a code that doesn't match the chart, the date a look-back ends, and the distance to the next star or the state floor, in dollars. And when something needs fixing, it tells the person who can fix it and keeps asking until it's done.

That's SuperQM: the QM tracker that builds itself. See how it works, or start with the free report for your building or group.

See your building’s published measures, free.

See where your building stands.

Your stars, your measures and your state program. Free, from public data.

Rather talk first? Book 20 minutes