Accounts receivable aging is one of the most familiar reports in a nursing facility business office, and one of the most underused. The classic version lists balances by how many days they are outstanding. It tells you how much is old. It rarely tells you why, or what to do about it.
The following five views take the same underlying data and slice it in ways that point toward action.
1. Aging by payer
Start by separating Medicare, Medicare Advantage, Medicaid, managed care, private pay and other sources. Each behaves differently. Medicaid timelines, managed care authorization requirements and private-pay collection practices all lead to different kinds of delay.
An overall aging bucket can look flat while one payer quietly grows older. A payer view shows where attention should go first and which payer relationships need a conversation.
2. Aging by reason or status
Not all old balances are the same. Some are waiting on authorization, some on a corrected claim, some on a secondary payer, some on a resident's responsibility, and some are simply unworked. If your billing system supports status codes or notes, summarize balances by status.
The question this answers is whether old money is stuck because of something known and being addressed, or because no one has looked at it. Unworked balances are the easiest wins.
3. Aging by cause upstream
Many billing problems begin before the claim. Missing eligibility checks, incomplete admission paperwork, and late assessments all show up later as delays or denials. Tag balances by upstream cause when you can, and look for repeat sources.
A hypothetical example: if a large share of delayed claims traces back to a single missing document at admission, the fix belongs in the admissions workflow, not the billing office.
4. Days in A/R trended over time
A single day's snapshot can be misleading. Trend days in A/R, or a similar measure that fits your accounting practices, over several months and compare against census changes and payer mix. If the trend is moving, look for the event that coincided: a new software system, a staffing change in the business office, a payer policy change or an increase in a particular admission source.
Trends give you an early signal while the problem is still small.
5. Work queue productivity
Finally, look at the people and process side. How many accounts does each biller handle? How many are touched each week? How long do balances sit before first follow-up? This is not about measuring individuals harshly. It is about seeing whether the work queue is manageable and whether follow-up is consistent.
An account that goes untouched for weeks tends to get harder to collect. A simple view of days since last activity highlights where that is happening.
Pulling the views into a rhythm
Review these regularly instead of at month end only:
- Weekly: the business office manager reviews status and last-activity views and assigns follow-up.
- Monthly: the administrator and CFO or controller review payer trends and upstream causes.
- Quarterly: the leadership team picks one upstream process to improve, such as eligibility verification at admission, and tracks it.
Common pitfalls
- Treating the oldest balances as the only priority, when newer ones are cheaper to resolve.
- Allowing balances to sit in vague categories like other or miscellaneous.
- Looking at A/R in isolation from census and assessment timeliness.
- Reviewing the report but not recording who owns each follow-up.
Getting there
Start small. Pick two of the views above, build them for the last six months, and bring them to your next business office meeting. The conversation they start is usually more valuable than the charts themselves.
None of this requires exotic tools, but it does require combining billing data with information from other systems, and doing so on a schedule. CarePulse can pull from your EHR and billing data to produce these views automatically, so the business office spends time working accounts instead of building spreadsheets. If you would like to see them with your own figures, we are happy to set up a demo.