Physical Therapy Patient Progress and Outcome Tracker
Visits-remaining against plan-of-care expiry, shown together. A PT loses money and a patient loses care when either runs out unnoticed. The file computes visits used, visits authorised, visits remaining, days to recert, and the visits-per-week pace needed to finish the plan on time — then flags the mismatch. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is reusable every school year.
What it does
- Visits-remaining against plan-of-care expiry, shown together.
- Built around the dates that actually bite: Plan of care recertification dates, visit authorisation limits, progress note due dates.
- Patients tab
- Plan Of Care tab
- Visit Log tab
- Measures tab
- Recert Watch tab
- Patient Snapshot tab
- Every threshold and dropdown editable on the Lists tab, nothing hardcoded
- Two files included: a blank workbook and a filled example to learn from
- Works in Excel and Google Sheets, no add-ons or macros
Every tab in the workbook
These are the actual sheet names in the file, not a feature list.
- Getting Started
- Dashboard
- Patients
- Plan Of Care
- Visit Log
- Measures
- Recert Watch
- Patient Snapshot
- Lists
What it looks like
Works in
- Microsoft Excel 2016 or later, Windows and Mac
- Google Sheets - upload to Drive and open
- No macros, no add-ins, no subscription
Honest scope
This is an organizational template. It reports the data you enter. It does not determine mastery, eligibility or compliance, and it does not replace your district or clinic documentation system - those stay your professional judgement.