Most skilled nursing buildings have an A/R aging report. Few have one the business office actually uses to run the day. Too often it is a static document printed at month end, reviewed by a few people, and filed. By then, the invoices that needed attention are weeks older.
A useful A/R dashboard is different. It helps the team decide what to work on this morning, shows whether last week's effort made a difference, and gives the administrator and CFO a clear picture without extra explanation.
Design for the people doing the work
Start by asking the business office team what they need to know each day. Typically the answers are practical:
- Which claims or balances need follow-up today?
- Which payers are slowing down?
- Which accounts are close to a filing or appeal deadline?
- What got paid since yesterday?
A dashboard built around these questions will be opened daily. One built only for executives will be opened monthly.
The core views
Aging buckets by payer
Show balances grouped by how long they have been outstanding, such as current, a month, two months, and so on, split by payer type: Medicare, Medicaid, managed care, private pay and other. Different payers have different expected timelines, so a combined view can hide a problem in one payer behind healthy numbers in another.
Days in A/R trend
A single figure that summarizes how long it takes to collect, shown as a trend over many weeks. It is a high-level health indicator. Watch for direction more than for a specific target.
Billing completion
How much of the month's billing has been submitted, and how quickly after the close of the billing period. Delays at the front end create aging problems later.
Cash collected versus billed
A simple comparison of what was billed and what arrived over recent weeks helps identify slowdowns early.
Work queues
A prioritized list of accounts needing follow-up, ordered by age, balance and deadline. This turns the dashboard into a to-do list.
Make aging actionable
An aging report tells you what is old. An actionable dashboard also explains why. Consider adding fields such as:
- Status or reason code. Is the claim awaiting a response, rejected, or missing documentation?
- Last touch date. When did someone last follow up?
- Owner. Who is working it?
- Next step and date. What happens next?
When an old balance has no owner and no next step, it will stay old.
Watch the leading indicators
Aging itself is a lagging measure. Earlier signals often show up upstream:
- Clean submission rate. The share of claims accepted without rejection.
- Time from discharge or month end to billing. Delays here show up in aging weeks later.
- Documentation completeness. Missing information holds up submission.
- Eligibility and authorization verification at admission. Mistakes at the start become problems at the end.
Tracking these helps the business office work with admissions, nursing and MDS teams to prevent problems rather than chase them.
Create a weekly rhythm
A simple weekly meeting can be effective:
- Review the trend in days in A/R and aging by payer.
- Look at the largest or oldest balances and confirm each has a next step.
- Identify any recurring causes, such as a particular rejection reason.
- Assign one process improvement for the week.
Keep it short and focused. The most important output is clarity about who is doing what.
Avoid dashboard pitfalls
- Too many measures. A cluttered view hides the few figures that matter.
- Inconsistent definitions. If the business office and executives calculate days in A/R differently, trust will erode.
- No drill-down. Leaders need to click from a summary into the underlying accounts.
- Stale data. If the dashboard is a week behind, staff will stop using it.
- Blame orientation. Use the data to remove obstacles, not to criticize.
Protect privacy
Account-level views contain protected health information, so access should follow the minimum necessary principle. Leadership views can show totals and aging without resident names, while the business office team works from detailed queues with appropriate access controls.
Connect to the bigger picture
A/R does not exist on its own. Census, payer mix, assessment timing and documentation quality all influence cash flow. Linking these views helps leaders understand the root of a slowdown. For example, if aging grows in one payer category at the same time that assessment timing slips, the two may be related.
Where analytics helps
CarePulse pulls billing and clinical data together so the business office and leadership see the same picture, updated regularly. If you would like to see what an A/R view could look like with your data, we are happy to walk through a demo.