The Compliance Record: what actually happened, hour by hour

Released June 18, 2026.

I’ve kept a ratio sheet in Excel by hand. Having names on a schedule was one thing. Accounting for who was working and who counted toward the ratio was another.

Imagine you’re mid-shift and a pharmacist’s status changes to stepping away. Your published schedule still shows that pharmacist working, but for those minutes, they no longer count toward the ratio. Looking back at the schedule alone won’t tell you that.

That’s the distinction behind RxShift’s Compliance Record, released June 18. It records what happened at each pharmacy location, hour by hour, using the published schedule and each person’s status changes.

What Was Planned Versus What Happened

RxShift’s Coverage Forecast shows whether your published schedule is projected to meet the ratio. The Compliance Record shows what actually happened.

For each hour, the record shows who was working, whether each person counted toward the pharmacist-to-technician ratio, and whether the ratio was met. Hours when the ratio was not met are highlighted.

Here is exactly how that record is built. It starts with the published schedule and applies each person’s status changes during the shift. A status that does not count toward the ratio, such as a break or stepping away, removes that person from the count for those minutes.

This is not a time clock, and it does not record punches. Each completed day is written into the record afterwards. It is a reconstruction from the schedule and status changes.

The Recorded Hour Stays Put

As a consultant pharmacist who audits surgery centers and cancer centers, I care about the difference between a plan and documentation of what happened. They answer different questions.

If someone with authority asks who was working at a given hour and whether the ratio was met, a schedule only answers who was supposed to be there. The Compliance Record is built to answer the question about that hour.

Once an hour is recorded, it is never edited. Managers can add notes afterwards, but those notes sit alongside the recorded hour without changing it. The notes themselves cannot be edited or deleted.

Imagine you need to explain a status change from a recorded hour. A manager can add that context without rewriting the underlying record. The hour stays as recorded, and the explanation stays with it.

Records are kept for two years and can be saved as PDFs or exported as CSV files.

Less to Reconstruct Later

The Compliance Record is for pharmacies in states that set a pharmacist-to-technician ratio.

What matters to me is having something more useful than the original plan when a question comes up later. For the pharmacist, that means a record that accounts for recorded breaks and time away. For the manager, it means an hour-by-hour record with room for explanation, without changing what was recorded.

Ultimately, a schedule tells you what you intended to happen. The Compliance Record applies status changes to that schedule to account for what happened after the shift started.