The medical practice dashboard: See your financial health between patients

You check your phone between patients. In 90 seconds, you scan email, glance at the schedule, and respond to a text from your office manager. Now imagine that in those same 90 seconds, you could see today's collections, this week's AR aging, your month-to-date revenue versus target, and a cash flow indicator showing whether you can cover next week's payroll without a second thought.

That is what a medical practice financial dashboard does. It pulls information from your accounting software, practice management system, and bank accounts, and surfaces the numbers that matter on a single screen that updates in real time. No logging into three systems. No waiting for month-end reports. No asking your bookkeeper to pull numbers that take two days to compile.

A well-built dashboard does not replace your monthly financial statements. It fills the gap between them, giving you weekly and daily visibility into the metrics that drive financial outcomes, so you can act on problems when they are small rather than discovering them when they have already cost you money.

The seven metrics that belong on every medical practice dashboard

Not every financial metric deserves dashboard real estate. The goal is a focused view that answers one question: Is the practice financially healthy right now? Seven metrics provide that answer.

1. Month-to-date net collections versus target. This is your revenue pulse. Set a monthly collection target based on your budget or prior year performance. Display actual collections against that target in real time. If you are 60% through the month and only at 45% of target, you know immediately that collections are lagging. Without this metric, you would not discover the shortfall until the month-end close, weeks after the opportunity to investigate and intervene.

2. Days in accounts receivable. Total AR divided by average daily charges. Display this as a single number with a trend arrow (improving or worsening) compared to the prior month. Target: below 40 days. This metric tells you whether revenue is converting to cash at a healthy pace. A rising trend signals collection slowdowns that will affect cash flow in the coming weeks. For the full breakdown of how to calculate and interpret days in AR and the steps to bring it under control, the guide to healthcare accounts receivable covers the 90-day reduction process in detail.

3. AR aging distribution. A simple bar chart or percentage breakdown showing how much AR sits in each aging bucket: 0 to 30 days, 31 to 60, 61 to 90, and 90+. The visual instantly reveals whether AR is concentrated in current claims (healthy) or aging into harder-to-collect buckets (a problem). According to the Healthcare Financial Management Association, commercial claims with AR greater than 90 days reached 36% in mid-2023, up from 27% in 2020, driven primarily by rising denials. If the 90+ bucket on your dashboard grows from 8% to 14% over two months, you can see it at a glance and assign follow-up before those dollars become write-offs. For definitions of each aging bucket and what each age range indicates about collectibility, the accounts receivable aging glossary entry covers the standard framework.

4. Current cash position. Your operating account balance updated daily. Display alongside a reference line showing one month of operating expenses. When cash dips below that line, you know reserves are thin. When cash sits comfortably above it, you have the buffer to absorb timing delays in insurance payments. This single number prevents the Friday morning surprise of wondering whether payroll will clear.

5. Denial rate (trailing 30 days). Denied claims divided by total claims submitted. Target: below 5%. A rate creeping from 4% to 7% indicates a process change, payer issue, or coding problem diverting revenue into the rework pipeline. Catching this within days means fixing it before it compounds. For how denial rate connects to net collection rate and payer-by-payer performance, the guide to medical practice collections covers payer benchmarks and the levers that drive the gap between billed and collected.

6. Patient visit volume (month-to-date versus target). Total patient visits compared to your monthly target. Revenue follows volume in a medical practice. A volume shortfall in week two predicts a collection shortfall in weeks six through ten, when those visits would have converted to cash. This gives you lead time to adjust scheduling, open appointment slots, or increase outreach before the revenue gap is locked in.

7. Operating expense run rate. Month-to-date expenses annualized versus budget. If your run rate is $1.4 million against a $1.3 million budget, expenses are 7.7% above plan. Seeing this mid-month lets you investigate before the variance becomes entrenched. For the category-level benchmarks that tell you where overhead typically concentrates, the guide to medical practice overhead covers the expense categories most likely to drive a run rate above budget.

Building your dashboard: Data sources and integration

A medical practice dashboard pulls data from three primary sources.

Your practice management system provides patient volume, charges, collections, AR balances, AR aging, and denial data. Most modern PMS platforms (Athenahealth, eClinicalWorks, Greenway, NextGen) offer reporting APIs or built-in dashboards that can surface these metrics.

Your accounting software provides expense data, cash balances, and budget comparisons. QuickBooks Online and Xero both offer API access that dashboard tools can connect to. Sage Intacct has native dashboarding for larger practices.

Your bank feeds provide real-time cash position data. Most accounting platforms pull bank balances daily through connected feeds.

Three approaches to building the actual dashboard, from simplest to most sophisticated:

Spreadsheet dashboard. A Google Sheet updated weekly by your office manager with data from PMS and accounting. Lowest cost. The trade-off is manual effort and weekly updates rather than real-time data.

PMS built-in dashboard. Many practice management systems include financial dashboards. Strong for revenue cycle metrics, but typically lack expense and cash flow data. Good as a partial solution.

Integrated dashboard platform. Tools like Power BI, Tableau, or healthcare-specific platforms connect to multiple data sources for a unified view, with investment typically running $200 to $1,000 per month. Requires setup but provides the most comprehensive real-time visibility.

Dashboard approach comparison

How to use the dashboard without drowning in data

A dashboard is only valuable if it changes behavior. Three practices prevent dashboard fatigue and ensure the data drives action.

Check once daily, review once weekly. A daily glance at collections and cash position takes 60 seconds and keeps your finger on the pulse. A weekly 15-minute review of all seven metrics identifies trends and triggers an investigation. Do not check continuously. The metrics move at a pace where daily or weekly observation is sufficient.

Set alert thresholds, not just targets. For each metric, define a green, yellow, and red threshold. Collections at 90% or more of pace: green. Between 80% and 90%: yellow. Below 80%: red. Denial rate below 5%: green. Between 5% and 8%: yellow. Above 8%: red. Visual color coding lets you scan the dashboard in seconds and focus only on metrics that need attention.

Assign follow-up actions to threshold breaches. When a metric hits yellow or red, a specific person is assigned to the investigation. Denial rate above 5%: billing manager reviews denial trends by reason code. AR aging shift: collections lead pulls a report on the 60+ bucket. Cash below threshold: office manager runs a 13-week cash forecast. The dashboard identifies the problem. The assigned action ensures someone solves it.

The dashboard changes the conversation

Without a dashboard, financial conversations in a medical practice happen monthly at best, based on backward-looking data that is already two to four weeks old. The discussion is reactive: "Why were collections low last month?" "What happened to our cash balance?"

With a dashboard, the conversation shifts to the present and near future. "Collections are pacing 8% below target this month. What is driving the shortfall?" "Denials ticked up to 6.2% this week. Is it concentrated in one payer?" "Cash position is strong. Should we accelerate the equipment purchase we have been discussing?"

That shift from reactive to proactive is the entire value. The practice owner who sees a 90-second dashboard between patients is better informed than one waiting three weeks for month-end reports. Better-informed decisions, compounded over 12 months, separate practices that grow profitably from those that grow and wonder where the money went.

The dashboard is the daily instrument; the monthly financial statements are the detailed map. For how to read all three financial statements in a structured 30-to-45-minute review each month, the guide to medical practice financial statements covers the P&L, balance sheet, and cash flow statement in a medical practice context.

Frequently asked questions

What financial metrics should be on a medical practice dashboard?

Seven metrics give a complete picture of practice financial health in real time: month-to-date net collections versus target, days in accounts receivable, AR aging distribution by bucket (0-30, 31-60, 61-90, 90+), current cash position relative to one month of operating expenses, denial rate for the trailing 30 days, patient visit volume versus monthly target, and operating expense run rate versus budget. These seven metrics, read together, answer whether the practice is financially healthy today, not three weeks from now.

How often should a practice owner review their financial dashboard?

A 60-second daily check of collections and cash position is sufficient to maintain awareness. A deeper 15-minute review of all seven metrics once per week identifies trends and triggers investigation when a metric moves into yellow or red territory. Reviewing the dashboard more frequently than once daily adds no meaningful information, since insurance payments and AR data move at a pace where daily observation captures all relevant changes.

What is a healthy denial rate for a medical practice?

Below 5% is the standard benchmark for a well-run medical practice billing operation. A denial rate between 5% and 8% indicates a process issue worth investigating by reason code and payer. Above 8% means a significant share of revenue is entering the rework pipeline rather than the bank, and the root cause requires urgent attention. The denial rate can spike quickly when a payer changes authorization requirements or when a coding error pattern emerges, which is why weekly visibility from a dashboard is more actionable than a monthly report.

What is the difference between a financial dashboard and monthly financial statements?

Monthly financial statements (P&L, balance sheet, cash flow) show a complete, auditable picture of what happened over the prior month. They are backward-looking, detailed, and typically available 10 to 22 days after month-end. A financial dashboard shows what is happening now, updated daily or in real time, covering a focused set of seven metrics. The two are complementary: the dashboard gives you weekly operational visibility so you can act before the month closes; the statements give you the full context after it does.

How do you build a financial dashboard for a medical practice?

Start by identifying your three data sources: practice management system (for AR, collections, volume, and denial data), accounting software (for expenses, cash, and budget), and bank feeds (for real-time cash position). Choose an approach based on your resources: a Google Sheet updated weekly is the lowest-cost starting point. A PMS built-in dashboard is a good partial solution for revenue cycle metrics. An integrated platform (Power BI, Tableau, or a healthcare-specific tool) provides real-time unified visibility across all three data sources for $200 to $1,000 per month. Regardless of approach, configure alert thresholds for each metric and assign a named owner to each threshold breach.

What does it mean if collections are pacing below target mid-month?

It means you have time to investigate and potentially recover the shortfall before the month closes. The first questions to ask: Is patient volume also below target, or are visit levels normal but collection conversion lagging? Is the denial rate elevated, diverting claims into the rework queue? Has AR grown, meaning charges are being billed but not collected within the normal cycle? Each of these root causes has a different fix. Seeing the shortfall in week two gives you two to three weeks to address it. Seeing it in the month-end report gives you nothing but the post-mortem.