A cash collections dashboard should help a leader answer one question quickly: is money coming in at the pace and from the sources we expect? Many dashboards fail because they try to answer fifty questions and answer none well. This post offers a framework for choosing what to show, what to skip and how to make the view useful for administrators, business office managers and owners.
Start with the audience
Different readers need different depth.
- Administrator or executive director: a quick view of cash versus expectation, major risks and anything needing a decision.
- Business office manager: work queues, aging detail and resident-level drill-down.
- Regional or finance leader: comparisons across buildings, trends and exceptions.
- Owner or board: summary trends and notable changes, in plain language.
Design a top view for the broadest audience and let others click deeper.
The core measures
Cash collected versus expected
Show cash received for the period compared with your own expectation, such as the prior period or a forecast based on billed amounts and typical payment timing. Present it as a simple trend rather than a single number.
Days in A/R
A familiar summary, best shown over time. Define the calculation clearly and keep it consistent so trends are meaningful.
A/R aging by payer class
Show how balances distribute across aging buckets for major payer groups, such as Medicare, managed care, Medicaid and private pay. Different payers have different normal payment rhythms, so combining them can hide problems.
Claim status pipeline
A simple flow showing claims unbilled, billed and pending, rejected, denied and paid. It reveals where money is waiting.
Denials and rework
Open denials by category and age, plus resolution rate. This points to process fixes.
Private-pay and patient-balance collections
Private-pay balances need their own view because collection depends on relationships and communication, not payer systems.
What to skip or demote
- Vanity totals that cannot trigger action, such as lifetime billed amounts
- Too many decimal places that suggest false precision
- Every payer on one chart, which creates unreadable clutter
- Metrics without definitions, which spark arguments about the number rather than the action
- Real-time updates for data that changes monthly, which add noise without insight
Design principles
- Lead with the exception. Highlight what changed or needs attention.
- Show trends, not just snapshots. A number without context invites misreading.
- Use consistent time frames. Compare like periods.
- Label definitions clearly. A small note under each measure avoids confusion.
- Make drill-down easy. Click from a summary to the accounts behind it.
- Keep it to one screen for the top view. If it scrolls, prioritize.
Pair numbers with owners and next steps
A dashboard that shows a problem but not who is working on it creates frustration. Add a column for owner and next action on key exception lists, such as the ten oldest balances or the largest denied claims. Review that list in a weekly business office meeting.
Cadence
- Daily: cash posted and any unusual rejections
- Weekly: aging movement, work queues, denials and cash versus expectation
- Monthly: trend review, process changes and communication with ownership
Watch for data traps
- Timing differences. Payments received near period end can shift between periods.
- Unapplied cash. Cash received but not posted can make A/R look worse than it is.
- Adjustments and write-offs. Track them separately so they do not hide collection problems.
- Inconsistent payer grouping. Standardize mapping so comparisons are fair.
A hypothetical use case
Suppose a regional finance leader notices on the dashboard that days in A/R at one building has crept upward for three months while others are flat. Drilling down shows a rising share of managed care claims waiting on authorization information. The business office, administrator and admissions lead agree on a verification step at admission. The dashboard then lets them watch whether the aging improves over the following months.
Closing thought
The best collections dashboard is the one people open every week because it tells them where to look. Fewer, clearer measures with owners and next steps beat a wall of charts.
CarePulse Analytics can build a collections view from your billing and bank data, and a demo is an easy way to see how your own cash picture looks.