Template · Published Nov 18, 2026
Collaborative Practice Agreement Tracker for NPs and PAs (Free)
One row per NP or PA agreement, with the state clocks, physician ratios and review dates worked out, so you can hand any board the current signed copy in minutes.
The free tracker (Excel or Google Sheets)
One workbook with an Agreements tab, a physician ratio check, an events log that sets each notice due date from your state's rule, a Dashboard that scores your risk, a 13-case playbook and cited rules for Ohio, Florida and Virginia, with filled sample rows.
Get the free collaborative agreement trackerA collaborative practice agreement tracker keeps one row per NP or PA agreement: the collaborating physician, sites, signatures, board notices and the next review date. It matters in 23 states that still require NP collaboration or supervision (AANP, 2026). Set each clock from your state's rule, then check every row monthly.
Key takeaways
- On AANP's May 2026 map, 27 states and DC give NPs full practice authority, 12 require a career-long collaborative agreement and 11 require supervision (AANP, 2026).
- Ohio: an APRN reports collaborating physicians to the board within 30 days of starting to practice, and the employer keeps the current arrangement on file (Ohio Adm. Code 4723-8-04).
- Ohio caps a physician at five nurses at a time in the prescribing part of their practices, with no cap on the number of agreements (Ohio Board of Nursing, 2025).
- Florida: the protocol stays on site wherever the APRN practices, and the physician files notice within 30 days of starting or ending it (Fla. Stat. 458.348, 2026).
- Virginia: one patient care team physician may work with no more than six PAs at a time (Va. Code 54.1-2952).
The tracker, row by row
Keep one row per agreement, not per provider. An NP with two collaborating physicians, or two sites under two protocols, has two agreements, and each one has its own signatures and clocks. This is provider data, not patient data, so the file holds no protected health information.
| Field | Sample entry | Why it matters |
|---|---|---|
| Agreement ID and type | CPA-01, standard care arrangement (Ohio) | Each state uses its own name and rules |
| Provider and role | NP-01, nurse practitioner | NP and PA rules sit in different statutes |
| Collaborating physician and backup | MD-A primary, MD-B backup | A departure starts a notice clock |
| Sites covered | Main office; north satellite | Florida wants the protocol on site at every location |
| Prescribing scope | Schedules III to V | Must match the DEA registration and the state license |
| Signed date, both signatures | Mar 14, 2026, yes | An unsigned draft is not an agreement |
| Board notice filed | Mar 20, 2026, confirmation saved | Proves the 30-day clock was met |
| Last review and next review (auto) | Mar 14, 2026; next Mar 14, 2027 | Ohio requires the date of the most recent review on the arrangement |
| Hours toward a threshold | 2,140 of 3,000 | Florida's autonomous registration needs 3,000 hours in 5 years |
| Provider license expiry | Jun 30, 2028 | The agreement fails if the license lapses |
| Where the signed copy lives | Compliance drive, /agreements/CPA-01 | Produce it in minutes when a board asks |
| Alert (auto) | Review due in 21 days | Tells the owner what to do this week |
The workbook adds three things this table cannot show: a physician tab that counts each physician's active agreements against your state's cap, an events log that turns "MD-A retires Feb 28" into a dated board notice, and a Dashboard that scores how many rows would fail a board request today.
| Agreement | Provider | State | Physician | Alert |
|---|---|---|---|---|
| CPA-01 | NP-01 | Ohio | MD-A | Review due in 21 days |
| CPA-02 | NP-02 | Ohio | MD-A | Board notice overdue: signed 34 days ago, no notice date |
| CPA-03 | PA-01 | Virginia | MD-B | OK |
How to set it up in 30 minutes
The practice manager or compliance lead owns the file; each collaborating physician checks their own rows at the annual review. Set it up once, then work it monthly.
- Fill the State Rules tab first (10 minutes). Ohio, Florida and Virginia are filled in with citations. For any other state, add a row with the notice days, review interval, ratio cap and hours threshold from your board's own page, with the date you checked it.
- Add every agreement (10 minutes). One row each, provider and physician codes, signed date, board notice date and where the signed copy lives. Mark anything unsigned honestly.
- List your physicians (5 minutes). The Physicians tab counts each one's active agreements against the cap for their state.
- Read the Dashboard (5 minutes). Work the red tiles first: overdue board notices, unsigned agreements and physicians over the cap.
- Every month, and on any event: log departures, new sites and license renewals on the Events tab the day you hear of them, so the due date starts then.
State law decides the clocks
AANP sorts every state into three environments. In full-practice states the board of nursing licenses the NP alone; in reduced-practice states law requires "a career-long regulated collaborative agreement with another health provider"; in restricted-practice states it requires "career-long supervision, delegation or team management" (AANP, May 2026).
The details inside each category differ a great deal, which is why the tracker reads its clocks from a State Rules tab instead of fixing them inside formulas. Three examples, each from the statute or regulator:
| State | What the agreement is called and where it lives | Clocks and limits | Source |
|---|---|---|---|
| Ohio (APRN) | Standard care arrangement, signed by each nurse and collaborating physician; employer keeps the current copy on file; prior versions kept 3 years | Physician names to the board within 30 days of starting practice; name or address changes within 30 days; 5 nurses per physician at a time in prescribing | OAC 4723-8-04; Ohio BON FAQ, 2025 |
| Florida (APRN) | Protocol, maintained on site at every location where the APRN practices | Physician notice within 30 days of starting and of ending a protocol; supervision in no more than 4 offices beyond the primary location (primary care) or 2 (specialty care); autonomous registration after 3,000 hours in 5 years, primary care only | Fla. Stat. 464.012, 464.0123, 458.348 (2026) |
| Virginia (PA) | Practice agreement with a patient care team physician | No more than 6 PAs per physician at a time; practice without an agreement after the equivalent of 3 years full-time (1,800 hours a year) in that specialty, with a physician attestation (section carries a contingent effective date, Acts 2026, c. 418) | Va. Code 54.1-2952, 54.1-2952.01 |
Use these rows as a pattern, not as your state's rulebook. Write your own state's answers into the State Rules tab with the date and the link, and re-check them after each legislative session.
The free workbook sets every board notice due date from the State Rules tab, flags physicians over the cap and scores your exposure on one Dashboard. Filled sample rows show every alert firing.
Get the free trackerEvents that start a clock
Agreements break when people, places or hours change. Log the event the day you hear of it; the clock starts then, not when someone remembers.
| Event | Example rule | Action in the tracker |
|---|---|---|
| New collaborating physician | Ohio: report to the board within 30 days; Florida: physician notice within 30 days | New row, signatures, notice date, ratio check |
| Physician leaves or retires | Florida: physician notice within 30 days after ending the protocol; Ohio: read ORC 4723.431 for the bridge terms | Filter by physician, start replacement agreements for every row they appear on |
| New practice location | Florida: protocol on site where the APRN practices; office limit per physician | Update sites, place a copy, re-check the office count |
| Body of the agreement changes | Ohio: a modified arrangement needs reapproval | New signed date, new review date |
| Hours threshold reached | Florida autonomous APRN: 3,000 hours in 5 years; Virginia PA: 3 years full-time | Decide on the new status, file what the board requires |
| License or DEA renewal | The agreement depends on both being current | Update expiry, confirm the prescribing scope still matches |
A physician's departure is the event with the shortest runway, so the tracker shows every agreement each physician is named on. License and DEA dates belong on the same calendar: see the medical license renewal tracker and the DEA registration renewal guide.
Check the ratio before every hire
A new NP or PA can push a physician past the state limit without anyone noticing, because the limit counts the physician's agreements across every site. Run the check at the offer, not at the first shift.
Worked example. A three-physician family practice in Ohio has six NPs. MD-A collaborates with five of them in prescribing; MD-B with one; MD-C with none. The practice hires a seventh NP and the draft agreement names MD-A, because MD-A trained her. The Physicians tab turns MD-A red at six, one over Ohio's cap of five (Ohio Board of Nursing, 2025). The fix costs nothing at the offer stage: name MD-B or MD-C as the prescribing collaborator before anyone signs.
The review calendar
Most of the work is recurring, so it belongs on a calendar. Put these rows on the compliance calendar next to OSHA and HIPAA training.
| Task | Rule or basis | Frequency | Owner |
|---|---|---|---|
| Review each agreement with both signers | Ohio requires the date of the most recent review; annual is a house rule | Yearly, and on any change | Practice manager |
| Re-check your state's rules | Statutes change most sessions | After each legislative session | Compliance lead |
| Update hours toward thresholds | Florida 464.0123; Virginia 54.1-2952.01 | Quarterly | Compliance lead |
| Run the ratio check | Ohio 5 nurses; Virginia 6 PAs; Florida office limits | At every offer | Practice manager |
| Confirm licenses and DEA are current | The agreement depends on both | Monthly, 90 days before expiry | Compliance lead |
Keep the signed agreements themselves with your policies; the medical office policy templates show a folder structure a board request can be answered from. If you want the whole calendar, the license tracker and the SOP library built inside your own tools, that is our Practice Controls engagement.
Mistakes to avoid
- One row per provider. Two physicians or two protocols means two agreements, each with its own clocks. Track the agreement.
- Counting the cap per site. The limit follows the physician across every location. Count all of their active agreements.
- Waiting for the exit date. A departure announced six weeks out is six weeks of runway. Log it the day you hear.
- Filing the unsigned draft. Ohio's rule requires the signatures of each nurse and collaborating physician. Store only the signed version where a board request will look.
- Copying another state's numbers. Ohio's 30 days is not your state's clock. Fill the State Rules tab from your own board.
By the numbers
| Figure | What it measures | Source and year |
|---|---|---|
| 27, 12, 11 | States with full, reduced and restricted NP practice | AANP, May 2026 (ClinicOps count) |
| 30 days | Ohio APRN reports collaborating physicians to the board after starting practice | OAC 4723-8-04, 2022 |
| 3 years | Ohio APRN keeps previously effective arrangements | OAC 4723-8-04, 2022 |
| 5 | Ohio nurses per physician at a time in prescribing | Ohio BON FAQ, 2025 |
| 30 days | Florida physician notice of starting or ending an APRN protocol | Fla. Stat. 458.348, 2026 |
| 4 and 2 | Florida offices a physician may supervise beyond the primary location (primary care, specialty) | Fla. Stat. 458.348, 2026 |
| 3,000 hours in 5 years | Florida autonomous APRN registration | Fla. Stat. 464.0123, 2026 |
| 6 | Virginia PAs per patient care team physician at a time | Va. Code 54.1-2952 |
| 1,800 hours a year, 3 years | Virginia PA experience for practice without an agreement | Va. Code 54.1-2952.01 |
- List every NP and PA and find the signed agreement for each; mark any that are unsigned or name a physician who has left.
- Write your state's notice, review, ratio and hours rules on the State Rules tab with the date and link.
- Count each physician's active agreements and compare against your state's cap.
- Put the next review date and license expiry for every agreement on your compliance calendar.
Frequently asked questions
What is a collaborative practice agreement for a nurse practitioner?
It is the written arrangement between an NP and one or more physicians that a reduced-practice or restricted-practice state requires before the NP practices or prescribes. States name it differently: Ohio calls it a standard care arrangement and Florida calls it a protocol. It names the collaborating physician, the services the NP provides, the prescribing limits and how consultation and review happen.
Do nurse practitioners need a collaborative agreement?
It depends on the state. On AANP's May 2026 map, 27 states and DC grant full practice authority, 12 states require a career-long collaborative agreement and 11 require supervision, delegation or team management. Check your board of nursing before every new hire and after every legislative session.
How often should a collaborative agreement be reviewed?
Many states set no fixed interval. Ohio's rule requires the arrangement to show the date of its most recent review and to be reapproved when its body is modified (Ohio Administrative Code 4723-8-04). Review every agreement at least once a year as a house rule, and again whenever a physician, site or scope changes.
How many nurse practitioners can one physician collaborate with?
It depends on the state. In Ohio a physician may not collaborate with more than five nurses at the same time in the prescribing part of their practices, although the number of agreements is not capped. In Virginia a patient care team physician may work with no more than six physician assistants at a time.
What happens if the collaborating physician leaves?
Rules differ by state. In Florida the physician must file notice within 30 days after ending a protocol (Florida Statutes 458.348). In Ohio the nurse needs a standard care arrangement with a collaborating physician to keep practicing, so read Ohio Revised Code 4723.431 for the current bridge terms and start the replacement agreement the day you hear of the departure.
Can I keep this tracker in Google Sheets?
Yes. The tracker holds provider and agreement data, not patient data, so it can live in any shared drive your practice controls. Upload the Excel file and save it as a Google Sheet; the dropdowns, formulas and color flags carry over.
Next steps
- Start from the system library: medical practice operations for 1 to 10 physicians.
- Put agreement reviews next to OSHA and HIPAA dates on the compliance calendar.
- Track the licenses each agreement depends on with the license renewal tracker.
- See what it costs to have the controls built for you: what a medical practice operations consultant costs.
- Download the collaborative practice agreement tracker.
Know which agreement fails first
The tracker shows every agreement, clock and ratio on one Dashboard, with a risk score from your own rows. If you would rather have the calendar, the tracker and the license checks built and run inside your tools, start with a 20-minute Chaos Audit.