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 tracker
Last verified: Nov 17, 2026. State rules come from the AANP 2026 practice environment map (May 2026), the Ohio Board of Nursing APRN FAQs (effective Mar 20, 2025) and Ohio Administrative Code 4723-8-04, the 2026 Florida Statutes (464.012, 464.0123, 458.348) and the Virginia Code (54.1-2952, 54.1-2952.01). Legislatures change these most sessions: confirm with your board before relying on any example. This is an operations tool, not legal advice.

A 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.

Tracker fields, with a filled sample row (provider codes only)
FieldSample entryWhy it matters
Agreement ID and typeCPA-01, standard care arrangement (Ohio)Each state uses its own name and rules
Provider and roleNP-01, nurse practitionerNP and PA rules sit in different statutes
Collaborating physician and backupMD-A primary, MD-B backupA departure starts a notice clock
Sites coveredMain office; north satelliteFlorida wants the protocol on site at every location
Prescribing scopeSchedules III to VMust match the DEA registration and the state license
Signed date, both signaturesMar 14, 2026, yesAn unsigned draft is not an agreement
Board notice filedMar 20, 2026, confirmation savedProves the 30-day clock was met
Last review and next review (auto)Mar 14, 2026; next Mar 14, 2027Ohio requires the date of the most recent review on the arrangement
Hours toward a threshold2,140 of 3,000Florida's autonomous registration needs 3,000 hours in 5 years
Provider license expiryJun 30, 2028The agreement fails if the license lapses
Where the signed copy livesCompliance drive, /agreements/CPA-01Produce it in minutes when a board asks
Alert (auto)Review due in 21 daysTells 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.

Worked example: three sample rows and the alerts they raise (moving dates in the file)
AgreementProviderStatePhysicianAlert
CPA-01NP-01OhioMD-AReview due in 21 days
CPA-02NP-02OhioMD-ABoard notice overdue: signed 34 days ago, no notice date
CPA-03PA-01VirginiaMD-BOK

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.

  1. 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.
  2. 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.
  3. List your physicians (5 minutes). The Physicians tab counts each one's active agreements against the cap for their state.
  4. Read the Dashboard (5 minutes). Work the red tiles first: overdue board notices, unsigned agreements and physicians over the cap.
  5. 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).

23 states still require an NP collaboration or supervision agreementHorizontal bar chart of the AANP 2026 nurse practitioner practice environment map, states only: reduced practice (career-long collaborative agreement) 12 states, restricted practice (career-long supervision) 11 states, full practice 27 states plus DC. 23 states still require an NP agreement NP practice environment, states only, May 2026 Reduced: career-long collaboration 12 states Restricted: career-long supervision 11 states Full practice: board of nursing only 27 states plus DC
Nearly half the states still need an agreement on file. 12 reduced plus 11 restricted states out of 50; DC, Guam and the Northern Mariana Islands are full practice and Puerto Rico, the US Virgin Islands and American Samoa are reduced. ClinicOps count of the state colors on the AANP 2026 Nurse Practitioner State Practice Environment map (dated 05/2026). PAs follow separate state laws not shown here.

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 examples, checked Nov 17, 2026
StateWhat the agreement is called and where it livesClocks and limitsSource
Ohio (APRN)Standard care arrangement, signed by each nurse and collaborating physician; employer keeps the current copy on file; prior versions kept 3 yearsPhysician 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 prescribingOAC 4723-8-04; Ohio BON FAQ, 2025
Florida (APRN)Protocol, maintained on site at every location where the APRN practicesPhysician 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 onlyFla. Stat. 464.012, 464.0123, 458.348 (2026)
Virginia (PA)Practice agreement with a patient care team physicianNo 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.

Get the tracker with the clocks built in

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 tracker

Events 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.

Events, the rule behind each, and the action
EventExample ruleAction in the tracker
New collaborating physicianOhio: report to the board within 30 days; Florida: physician notice within 30 daysNew row, signatures, notice date, ratio check
Physician leaves or retiresFlorida: physician notice within 30 days after ending the protocol; Ohio: read ORC 4723.431 for the bridge termsFilter by physician, start replacement agreements for every row they appear on
New practice locationFlorida: protocol on site where the APRN practices; office limit per physicianUpdate sites, place a copy, re-check the office count
Body of the agreement changesOhio: a modified arrangement needs reapprovalNew signed date, new review date
Hours threshold reachedFlorida autonomous APRN: 3,000 hours in 5 years; Virginia PA: 3 years full-timeDecide on the new status, file what the board requires
License or DEA renewalThe agreement depends on both being currentUpdate 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.

Recurring agreement tasks
TaskRule or basisFrequencyOwner
Review each agreement with both signersOhio requires the date of the most recent review; annual is a house ruleYearly, and on any changePractice manager
Re-check your state's rulesStatutes change most sessionsAfter each legislative sessionCompliance lead
Update hours toward thresholdsFlorida 464.0123; Virginia 54.1-2952.01QuarterlyCompliance lead
Run the ratio checkOhio 5 nurses; Virginia 6 PAs; Florida office limitsAt every offerPractice manager
Confirm licenses and DEA are currentThe agreement depends on bothMonthly, 90 days before expiryCompliance 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

Every figure on this page
FigureWhat it measuresSource and year
27, 12, 11States with full, reduced and restricted NP practiceAANP, May 2026 (ClinicOps count)
30 daysOhio APRN reports collaborating physicians to the board after starting practiceOAC 4723-8-04, 2022
3 yearsOhio APRN keeps previously effective arrangementsOAC 4723-8-04, 2022
5Ohio nurses per physician at a time in prescribingOhio BON FAQ, 2025
30 daysFlorida physician notice of starting or ending an APRN protocolFla. Stat. 458.348, 2026
4 and 2Florida offices a physician may supervise beyond the primary location (primary care, specialty)Fla. Stat. 458.348, 2026
3,000 hours in 5 yearsFlorida autonomous APRN registrationFla. Stat. 464.0123, 2026
6Virginia PAs per patient care team physician at a timeVa. Code 54.1-2952
1,800 hours a year, 3 yearsVirginia PA experience for practice without an agreementVa. Code 54.1-2952.01
Do this in the next hour
  1. List every NP and PA and find the signed agreement for each; mark any that are unsigned or name a physician who has left.
  2. Write your state's notice, review, ratio and hours rules on the State Rules tab with the date and link.
  3. Count each physician's active agreements and compare against your state's cap.
  4. 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

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.