Practice Manager KPIs: The 12 Numbers to Track Weekly (Dashboard Template)

A practice rarely fails dramatically. It fails quietly, one number drifting in the wrong direction while everyone is busy: AR creeping from 35 days to 48, a denial rate sliding from 6% to 11%, a revalidation date passing unwatched. By the time those show up in the bank balance, months have gone by. A weekly dashboard is how a practice manager sees the drift while it is still small enough to fix.

Why a weekly dashboard, not a monthly report

Most practices look at their numbers monthly, if at all, which means the earliest they can catch a problem is thirty days after it started, plus however long the report takes to produce. That is a post-mortem, not management. The fast-moving numbers, denials, clean claim rate, AR, no-shows, change week to week, and a week is enough time to act before the damage compounds. The point of a weekly cadence is to shorten the distance between a problem starting and someone noticing it, from a month to a few days. You do not need every number weekly, the slower financial metrics are fine monthly, but the ones that move fast and cost fast belong on a weekly view. Benchmark the full set against MGMA and HFMA standards quarterly to confirm your targets are calibrated, but manage the drift weekly.

The 12 numbers at a glance

Here is the whole dashboard. This table is the artifact: build your view from it.

The money numbers

The first six tell you whether the practice is converting care into cash, and how much is leaking on the way. Days in AR is the average time to collect after service; target 30 to 40 days, with under 35 best-in-class under HFMA-aligned standards, and over 50 a red flag. Clean claim rate is the share of claims paid on the first submission with no rework; 90% is good, 95%+ is excellent, and every point below that is cash delayed and staff time spent reworking. Denial rate is the share of claims denied; industry rates commonly run 12 to 15%, but the target is under 5%, and because the top cause is preventable bad data Experian, 2025, most of the gap is closeable at the front end. Net collection rate is the share of collectible revenue you actually collect after contractual adjustments; 95% or higher is the mark, and a falling NCR usually signals denial or underpayment problems. AR over 90 days flags money getting old, because a claim over 90 days collects far less often than a fresh one, so watch the aging bucket, not just the average. Denials worked is the share of denials actioned before their appeal deadline; it should be near 100%, because most denials are winnable and most are never appealed Premier, so an unworked denial is money abandoned. Read these six together: a low AR only matters if NCR is high, and a good denial rate is undercut if you are not working the denials you do get. The full denial picture is in the denial statistics, the appeal odds in the appeal data, and the tool to work them in the denial tracker.

The flow numbers

The next four measure whether work and patients are moving through the practice smoothly, and they are where the money numbers are often decided upstream. Prior auth aging counts authorizations sitting past their follow-up window; the target is zero, because an auth that ages out is a cancelled procedure or a denied claim, and this number is an early warning that a denial is coming weeks before it lands. No-show rate is no-shows divided by scheduled appointments; the MGMA median runs about 5 to 7%, and above that you are leaking booked revenue, fixable with workflow rather than software as covered in the no-show guide. Schedule fill rate is the share of available slots actually booked; a low fill rate means capacity, and therefore revenue, sitting idle. Eligibility verified is the share of visits checked before arrival; it should be near 100%, because verification is the cheapest denial prevention there is, and a dip here shows up as denials two weeks later, as the verification checklist and front-desk prevention explain. The flow numbers are leading indicators: they move before the money numbers do, so watching them lets you fix a problem before it reaches the bank.

The people and compliance numbers

The last two are the ones practices forget until they cause a crisis, which is exactly why they belong on a weekly view. Renewals due in the next 120 days counts every credentialing, enrollment, or license deadline coming up, revalidation, recredentialing, CAQH re-attestation, license, DEA, and the target is that every one is already being handled, never discovered late. A single missed revalidation can deactivate billing with no coverage for the lapse, so this number protects revenue you have already earned; the full set of cycles is in the revalidation calendar. Aging open tasks counts operational tasks past their due date with no clear owner, the small things, a follow-up, a form, a callback, that slip when everyone is busy and compound into bigger failures. Zero is the target, and a rising count is the earliest possible signal that the practice is taking on more than its systems can hold. Both numbers live naturally in the recurring tasks tracker, and keeping them at zero is what stops a departure or a busy stretch from becoming the kind of crisis described in the practice-manager-quit guide.

How to build and run the dashboard

The dashboard is only useful if it is easy to maintain, so build it to fill itself. Each number should come from a system you already run, denials and AR from the billing side, prior auth aging and eligibility from the front-desk trackers, renewals from the credentialing calendar, so that updating the dashboard is a matter of reading systems, not rebuilding data. Set the target for each number so a glance tells you red or green, not just the raw figure. Review the weekly numbers in a short standing meeting, ten minutes, the same way a practice runs its morning huddle, and act on anything off target that week. Track the trend, not just the level, because a number moving the wrong way is a problem even while it is still inside the target. This is precisely the operating rhythm a fractional operations partner installs and reports on monthly, described in the fractional operations breakdown, and the automation that feeds it is the same set behind the Zero-Slip system. Built once, the dashboard turns scattered systems into a single view you can manage from.

These are your numbers

A dashboard like this changes what it means to be a practice manager. Without it, you are reacting, finding out about a denial spike when the deposit is short, learning about a missed renewal when a payer stops paying. With it, you see the problem while it is small, you direct the team's attention to exactly the number that is drifting, and you can show the physicians, in plain figures, that the practice is running well. That is the difference between managing a practice and being managed by it. These twelve numbers are how a practice manager makes sure nothing slips: not by working harder or remembering more, but by watching the right numbers weekly and acting while there is still time. The dashboard does not replace your judgment, it points it at the right place. Own it, and the practice runs on your watch, not despite it. When you want to know which single number is costing you most right now, the free Leak Audit reads them with you and names the one to fix first.

Where to go next

• 41% of Providers Now See 1 in 10 Claims Denied: The 2025 to 2026 Denial Data live

  Claim denial statistics for 2025 and 2026: 41% of providers see over 10% of claims denied,.

• 54% of Denied Claims Get Paid on Appeal, If Someone Appeals live

  Claim appeal success rates: about 54% of private-payer denials are overturned on appeal and.

• Denial and AR Follow-Up Tracker (Free): Work Every Denial to Paid live

  A free denial and AR follow-up tracker: log every denial with its appeal deadline, work each to.

Frequently asked questions

Sources

1. CAQH ProView, provider re-attestation required about every 120 days to keep an enrollment application current with participating payers. proview.caqh.org
2. Experian, 2025. experian.com
3. Premier. premierinc.com