What Belongs on an Accounts Receivable Dashboard

An accounts receivable dashboard, or AR dashboard, is one screen that shows where your unpaid claims stand and which billing step is about to slow your cash. A good one warns. A weak one only confirms. It stops at days in AR, the aging report and collections, which all move after the problem that drives them. You can post record collections in a month when your denial rate is climbing. This month's deposits pay for claims sent weeks earlier.

A dashboard fails in one of two ways. It tracks too little, and a problem gets expensive before anyone sees it. Or it tracks so much that nobody acts on it. "A red indicator with no owner produces concern without corrective action," MGMA wrote in a July 2026 article on the data behind practice dashboards. The fix is a short front screen with the numbers that move first on top, and an owner for each one.

What belongs on an AR dashboard and what stays in the drill-down

An AR dashboard needs two layers: a front screen and a drill-down. The front screen holds a vital few tiles and tells you whether anything is getting worse. You open the drill-down only when one of those tiles starts to move, and it tells you where.

The top row covers your own steps: verified eligibility, charge lag and claims no payer has accepted yet. The middle row shows the payer's response: first-pass denials, authorization denials, short payments and takebacks. The bottom row holds days in AR, the oldest aging buckets and net collection rate. A payer panel beside them splits denials, takebacks and aging by payer.

The drill-down holds everything else: denials by reason code, procedure code and provider, plus noncontractual write-offs by category. It also holds appeal overturn rates and accepted claims still waiting on a payer decision. Our post on AR metrics that predict financial health covers the formulas, benchmarks and review schedule for days in AR, aging, denial rate and net collection rate.

How to lay out an accounts receivable dashboard

Lay out an accounts receivable dashboard in the order a claim travels: your steps on top, the payer's response in the middle and the lagging totals at the bottom. HFMA's MAP Keys, the industry-standard revenue cycle measures, follow the same path, in five groups from patient access to financial management. HFMA says they apply to physician organizations as well as hospitals.

The line between the top and middle rows follows the first question MGMA asks about a delay in AR: who controls it. MGMA puts eligibility checks, registration accuracy, unsigned encounters, charge-posting lag, denial follow-up and patient collections on the practice's side. Slow claim decisions, denials, downcoding and appeal processing sit with the payer. You can still track those by payer and escalate the ones that recur. A tile that mixes both sides tells you something moved, not who has to act.

The upstream tiles on an AR dashboard and the data behind them

The top row of an AR dashboard tracks what happens before a payer decides anything, starting with eligibility. The eligibility tile reads the 271 response to your 270 eligibility inquiry, the electronic transaction pair adopted under HIPAA in 45 CFR 162.1202. HFMA's MAP Key PA-3 measures the same step as an insurance verification rate: verified encounters over registered encounters. HFMA lets each practice decide what counts as verified.

An eligibility problem missed at the front desk comes back after the claim goes out, as a rejection or a denial. In UnitedHealthcare's 2026 administrative guide, incomplete or inaccurate eligibility information is "one of the primary reasons for claims rejection," and checking before care reduces denials for noncoverage.

The charge lag tile reads your practice management system: each charge's posting date minus its date of service. HFMA's MAP Key PB-4 averages that gap, and CL-2 counts any charge posted more than three days after the service date as late. Show both, split by provider. Unsigned encounters and slow charge posting both sit on the practice's side of MGMA's line, so the fix is yours. Each day a charge waits also comes off the filing window, which Medicare counts from the date of service.

The third upstream tile counts claims no payer has accepted yet, starting with the scrubber's hold queue. The scrubber is the software that runs error checks, called edits, on each claim before it goes out. Electronic claims use the 837, the HIPAA standard claim format. HFMA's MAP Key PB-2 starts from the dollars in 837 claims "held by edits in claims processing tool that have not been sent to payer," plus payer rejections at submission. The same data gives you a clean claim rate: HFMA's CL-1 divides claims that pass edits with no manual intervention by claims accepted into the scrubber.

The other feed is the acknowledgments: the clearinghouse's rejection report, the 999 and the 277CA. These are the receipts that tell you whether a claim got in. In Medicare's process, the 999 reports whether a batch of claims passed format checks. The 277CA then reports claim-level rejections and a control number for each accepted claim, according to the CMS claims manual. A claim rejected at the clearinghouse or on the 277CA never reaches the remittance, so a denial tile cannot count it. Our post on what a clearinghouse does to your claims covers the 999, the 277CA and what happens to a rejected claim.

Denial and payment tiles on an AR dashboard

The middle row of an AR dashboard reads the payer's answer from the 835 remittance and checks it against your contracted rates. The 835 is the electronic remittance advice adopted under HIPAA in 45 CFR 162.1602. Each adjustment on the 835 carries a claim adjustment reason code, or CARC, explaining why a line paid other than as billed. A group code says who carries the amount, such as PR for the patient.

Build the first-pass denial rate from those codes, by claim count and by dollars. HFMA's Claim Integrity Task Force calls it the initial denial rate and counts only the first denial on each claim. Then check what your report leaves out. A second HFMA measure, the remittance denial rate in MAP Key AR-5, leaves out patient responsibility denials, including non-covered services under group code PR. It also leaves out recovery audit recoupments and duplicate claims. Two reports that differ on those exclusions give two rates for one month.

Give authorization denials their own line. In Kodiak Solutions' 2025 data, centered on hospitals and health systems, denials for missing authorizations and medical necessity made up almost all of the rise in denial rates. Then split that line in two. The first counts claims denied for a missing authorization, such as CARC 197, and points back to your own process. The second counts claims denied with an approval on file. UnitedHealthcare's 2026 guide says prior authorization "is not a guarantee of payment."

Paid versus expected, the short-payment tile, is the one a denial rate cannot replace. It compares each allowed amount with the rate in your provider contract for that payer, code, modifier and place of service. AAFP tells practices to keep fee schedules on hand "to get an accurate picture of what you should have been paid" and avoid inappropriate write-offs. A claim paid short with no line denied never reaches a denial worklist. Our post on underpayments covers the common kinds and how to catch them.

Takebacks need their own tile. UnitedHealthcare's guide says it may apply an overpayment "against future claim payments," so the money leaves through a remittance for other claims. X12's provider adjustment reason codes cover adjustments "not related to a specific claim, bill, or service," including WO for an overpayment recovery. Total those by payer each month. On Kodiak Solutions' platform of hospitals and physician practices, insurers clawed back 1.57% of accounts receivable in the first half of 2026, up from 1.38% a year earlier. The increase held in every payer and patient setting it analyzed.

Days in AR and aging on an AR dashboard

The bottom row of an AR dashboard holds the lagging totals: days in AR, the share of AR over 90 and 120 days, and net collection rate. Our AR metrics post covers their formulas and benchmarks. On the dashboard, show each one as a trend line. The data comes from your practice management system: the AR aging report, plus posted charges, payments and adjustments. Split days in AR into insurance and patient balances, which have different owners and fixes. Show net collection rate over a trailing 12 months, the window AAFP recommends.

Aging belongs on the dashboard twice: in total on the bottom row and by payer in the payer panel. A slow payer shows up as one payer's buckets swelling while the others hold. Unworked claims show up as old balances across many payers. The total cannot tell those apart. The payer split can.

How to read an AR dashboard: tiles in pairs

Read AR dashboard tiles in pairs. Any tile can move for more than one reason, and the tile you pair it with tells you which.

Days in AR blends changes that can cancel each other out. MGMA warns that a stable number "may conceal" faster submission on one side while payer rework, staffing shortages or patient balances add days on the other. In one practice MGMA cites, insurance AR stayed within 28 days, but self-pay balances pushed the overall figure to 32. If days in AR rises while first-pass denials hold steady, look to a slow payer, stalled follow-up or patient balances.

If denials rise while your scrubber's clean claim rate holds, your claims pass your own edits as often as before. Look to the payer's side: a new authorization requirement, a changed medical necessity policy or a new edit. Our post on how a payer policy change triggers a denial spike describes its signature: a cluster on one payer, one code and one start date. If rejections climb instead, start with the eligibility tile.

Denials falling while cash does not improve is the pattern Kodiak found for the first half of 2026: insurers offset lower denials with takebacks. Kodiak advises measuring results by "the final revenue yield from claims." On the dashboard, that means reading the denial rate beside the takeback and paid-versus-expected tiles.

If net collection rate holds while the gap between paid and contracted amounts grows, short payments are likely posting as contractual adjustments. Failing to distinguish noncontractual from contractual adjustments gives "a misleading view of how well your practice collects the money it has earned," in AAFP's words.

Segmenting an AR dashboard by payer, plan and reason code

Split the denial, aging and takeback tiles by payer and plan type, then split denials by reason code. An aggregate denial rate tells you how much went wrong. Split by payer, it tells you where. HFMA's MAP Key AR-2 ages billed AR by payer group and calls the result a "trending indicator of receivable collectability" for each group. MGMA tells practices to run aging by payer, not only in total, and to take payer-level aging to contract talks.

Plan type matters too. In Kodiak's 2025 data, Medicare Advantage plans had initial and final denial rates more than double those of traditional Medicare. Its first-half 2026 analysis found more than double the percentage of takebacks at those plans, again compared with traditional Medicare. Both releases draw on more than 2,300 hospitals and 375,000 physicians, so they describe that mix, not a small practice. Still, a Medicare row that blends the two plan types hides both gaps.

MGMA advises reviewing the five most common denial codes for preventable causes. Keep authorized-then-denied claims on their own line here too, so a payer that denies after approving stands apart. HFMA's task force defines the percentage of initial denials overturned, a measure that can point to "potential issues with specific plans or types of denials," in HFMA's words. Split this way, the denial tile becomes an early warning for each payer. Our post on what a good denial rate looks like covers payer mix, reason codes and overturn rates in more depth.

Benchmarks on an AR dashboard: your own trend first

Show benchmarks as reference lines, and compare each tile with your own past months first. HFMA describes its clean claim rate, remittance denial rate and aging by payer each as a "trending indicator" in its MAP Key definitions. Outside figures come second, and only from a cohort like yours. AAFP wrote its days in AR guidance, below 50 at minimum with 30 to 40 preferable, for family medicine. In a 2018 MGMA article, David Gans wrote that revenue cycle performance differs by type of practice and ownership, with payer mix explaining part of the gap. Our AR metrics post covers the days in AR benchmark and where it misleads, and our denial rate post covers how specialty changes the comparison.

What to leave off an AR dashboard

Leave off any number nobody acts on, starting with gross collection rate. MGMA's formula divides net fee-for-service revenue by gross charges, valued "at the practice's undiscounted rates" in MGMA's DataDive definitions. Raise your charges and the rate falls, though nothing in billing changed. Net collection rate is the one to keep: it shows how much of what payers and patients owed you came in.

Volume totals come off the front screen too. Charges billed and claims sent tell you how busy the practice was, not how billing is going, so keep them as the denominators behind the rates. Give every tile an owner and a next step, or drop it.

Then check the definitions behind the tiles you keep. AAFP tells practices to subtract credits from receivables, or days in AR will look better than it is. It also suggests computing days in AR with and without revenue from accounts sent to a collection agency, and tracking patients on payment plans as a separate account. Write down each tile's source, denominator and exclusions, and recheck them after any system change. A report can break after an update and "will keep producing a plausible number the whole time," MGMA warns.

Altair runs the whole revenue cycle, from eligibility checks to payment posting and reconciliation, with AI backed by expert in-house billers. The practice owner sees every claim and every dollar as it moves, not in a monthly report. That view includes expected payment by payer, every underpayment with the reason and denials by payer and cause. Altair works every denial. The practice hires no one and manages no one, and it keeps the EMR and clearinghouse it already uses. Every claim is checked against the payer's current policy before it goes out, so it holds up if the payer reviews it later, and the money stays with the practice. See how Altair shows what each payer will pay.

The test of an AR dashboard comes on the morning a tile moves. A good one names the payer and the step while the claims behind it can still be paid.

Common questions