7 Reports Every Nursing Home Administrator Should Review Monthly to Protect Cash Flow.

There is a version of nursing home financial management where the administrator receives a monthly summary, reviews the total numbers, and moves on. Revenue is up or down from last month. AR is higher or lower than last quarter. Everything looks manageable until it does not.

By the time a billing problem is visible in a summary report, it has usually been building for weeks or months at the account level. The specific denial pattern that is now causing a cash flow dip started three billing cycles ago. The PDPM under coding that is suppressing Medicare revenue has been in place since the last MDS audit which may have been more than a year ago. The private pay AR that is approaching write-off territory aged slowly, one missed follow-up letter at a time.

Summary reports tell you what happened. Detailed reports tell you why it happened and what to do about it. The seven reports below are the ones that, reviewed monthly with the specific questions in mind, give a nursing home administrator the visibility to manage cash flow proactively rather than react to financial problems after they have already developed.

Report 1: AR Aging by Payer Type and Aging Bucket

The AR aging report is the foundational financial management tool in any nursing home billing operation. Most facilities have one. Most administrators review it at the total level overall AR is up or down, the 90-day-plus bucket is a certain percentage of the total. That level of review generates awareness. It does not generate action.

What the AR aging report should produce is a payer-level breakdown Medicare Part A, Medicare Part B, Medicare Advantage by plan, Medicaid by program, commercial insurance, and private pay each segmented by aging bucket. A 90-day Medicare Part A balance and a 90-day Medicare Advantage balance are not the same problem. A 90-day Medicaid balance and a 90-day private pay balance require completely different responses. Reviewing a single total balance for each aging bucket obscures these differences.

When reviewing the payer-level AR aging monthly, the specific questions worth asking are: which payer category has grown the most month over month? Is any payer category approaching 30% or more of its total in the 90-day-plus bucket? Are there accounts in the 60-day-plus bucket with no documented action plan? The answers to these questions determine where billing team attention needs to be concentrated in the coming cycle.

What to look for: Any payer category where 90-day-plus AR is growing month over month without a corresponding explanation new admission volume, a specific payer dispute, a known documentation issue signals a collections process gap that is compounding. Identifying it in month two is significantly easier to address than identifying it in month five.

Report 2: Denial Trend Report by Root Cause Category

A denial trend report is not a list of denied claims. It is a categorized analysis of why claims are being denied sorted by root cause category, tracked over time. The distinction matters because a list of denied claims tells you what happened. A categorized trend report tells you whether the same thing keeps happening.

The most useful denial root cause categories for nursing home billing are eligibility and benefit period issues, PDPM coding and MDS-related denials, documentation insufficiency (missing physician orders, insufficient skilled care documentation, absent certifications), consolidated billing conflicts, authorization-related denials from Medicare Advantage plans, and timely filing failures. Each category points to a different process gap. When reviewing the denial trend report monthly, the question is not how many denials there were. It is whether the same categories appear in month two that appeared in month one and whether the volume in each category is stable, growing, or declining. A denial category that appears month after month at consistent volume is a billing process failure that has not been identified and corrected. It is not bad luck. It is a system producing predictable results from a predictable process gap.

Systemic denial patterns require process correction, not just claim correction. Resubmitting a category of denied claims without addressing the root cause produces the same denials next month. Identifying the root cause whether it is a documentation standard that is not being met, an eligibility verification step that is being skipped, or a payer configuration that has not been updated and correcting it prevents the next cycle’s version of the same denial.

What to look for: Any denial category that appears in three or more consecutive monthly reports without a declining trend is a billing process problem, not a series of individual claim errors. The specific category identifies which billing process needs correction.

Report 3: First-Pass Claim Acceptance Rate

First-pass acceptance rates the percentage of claims accepted by the payer on initial submission without correction or resubmission is the most direct measure of claim quality before denials are worked. It is also one of the least commonly tracked metrics in nursing home billing operations, because it requires separating initial submissions from resubmissions in the billing system’s reporting.

A first-pass acceptance rate above 95% for Medicare Part A claims indicates that the pre-submission billing process including Triple Check execution and charge capture is functioning at a level that produces clean claims consistently. A rate below 90% indicates that one in ten Medicare Part A claims is being submitted with an error that could have been caught before the claim left the facility.

Tracking first-pass acceptance rate monthly, and separately by payer, reveals both the overall quality of the billing process and the specific payers where pre-submission errors are most concentrated. A low first-pass rate on Medicare Advantage claims specifically may indicate an authorization management gap. A low first-pass rate on Medicaid claims may indicate a payer configuration issue or an MCO-specific billing requirement that is not being met.

What to look for: A first-pass acceptance rate below 95% on Medicare Part A claims. For each percentage point below 95%, identify which denial categories are driving the gap those categories are the Triple Check and pre-submission process failures most worth correcting.

Report 4: PDPM Case-Mix Distribution Report

This is the report that most nursing home administrators do not review monthly and the one that is most likely to be quietly draining Medicare reimbursement without appearing anywhere in the standard financial reports.

The PDPM case-mix distribution report shows the HIPPS code distribution across the facility’s active Medicare Part A residents specifically the breakdown of residents across clinical categories, functional score tiers, and Nursing and NTA component classifications. Reviewed against the clinical complexity of the resident population, it reveals whether the facility’s PDPM payment rates accurately reflect the residents being served or whether systematic under coding is producing lower rates than the population supports.

A facility that primarily serves post-surgical and post-acute residents following hip replacements, strokes, and cardiac events should have a case-mix distribution that reflects the clinical complexity of those populations. If the distribution is concentrated in lower-paying clinical categories, or if the Nursing and NTA component tiers are predominantly low despite a clinically complex population, the distribution is telling you that PDPM coding is not capturing the full clinical picture.

Reviewing this report monthly does not require a full PDPM audit every month. It requires a sanity check comparing the distribution to the resident population and identifying whether any component shows a shift toward lower tiers that warrants a closer look. When a quarterly PDPM audit confirms specific coding gaps, the case-mix distribution report is what tracks whether the corrective documentation practices are producing the expected improvement in rates.

What to look for: A Nursing component distribution that shows 60% or more of Part A residents in the lower-paying tiers despite a clinically complex census. That distribution, in a facility with active infections, IV therapy, and wound care in the resident population, is almost always a sign of Nursing component under coding rather than a genuinely low-acuity population.

Report 5: Cash Projection Report

The AR aging report shows what is owed. The cash projection report shows what is expected to arrive and when. These are different questions with different financial management implications and confusing them is one of the most common reasons nursing home administrators are surprised by cash flow gaps.

A cash projection report estimates expected collections over the coming 30 to 60 days based on current claim status, payer-specific payment timelines, and the AR aging profile. It distinguishes between accounts that are expected to pay within the projection window claims submitted and pending, accounts in payment processing and accounts that are at risk denied claims awaiting resubmission, Medicaid pending accounts without confirmed eligibility, MA authorizations in dispute.

Reviewing the cash projection monthly allows administrators to anticipate cash flow gaps before they arrive and act in advance. If the projection shows lower expected collections in month three because a large group of MA claims is in dispute, the facility can address the dispute earlier, accelerate collections on other accounts, or plan operationally for a lower-revenue period. If the projection is reviewed only when the cash flow gap is already present, the options for response are narrower.

What to look for: The gap between expected collections in the projection and the prior month’s actual collections. A projected shortfall that is not explained by seasonal volume or known one-time factors signals either a billing performance issue more claims in denied or disputed status than usual or a collections velocity problem claims aging in the queue without active follow-up.

Report 6: Write-Off and Adjustment Report

Write-offs are the permanent record of revenue that was billed and not collected. In nursing home billing, they are also the permanent record of billing process failures accounts that aged past timely filing, denials that were not appealed in time, private pay balances that escalated to collections and were not recovered.

Most administrators review write-offs in aggregate total write-offs for the month, compared to the prior month or prior year. The more useful review is by category: timely filing write-offs, contractual adjustments, medical necessity denials not appealed, private pay write-offs after collections, and bad debt. Each category tells a different story about where the billing operation is losing revenue that should have been protected.

Timely filing write-offs are entirely preventable they represent accounts that were in the billing system, subject to active management, and allowed to pass the twelve-month deadline without a payable claim being submitted. If timely filing write-offs appear in the monthly report, the billing process has a structural gap in deadline tracking that is worth addressing specifically.

Contractual adjustment variances are worth reviewing even when the adjustments themselves are expected. If a payer is consistently adjusting claims to a rate different from the contracted rate either lower or higher that pattern signals either a contract configuration error in the billing system or a payer behaviour that warrants a contract review conversation.

What to look for: Any write-off category that is growing month over month. A single month of elevated write-offs may reflect a one-time resolution of aged accounts. Three months of elevated write-offs in the same category reflects a billing process that is not protecting revenue from a specific type of loss.

Report 7: Timely Filing Exposure Report

This is the report that most nursing home billing operations do not have and the one that directly prevents the most permanent revenue loss. A timely filing exposure report identifies every open account approaching the Medicare twelve-month timely filing deadline, sorted by days remaining in the filing window and by account balance.

Medicare’s timely filing rule is absolute. A claim submitted after the twelve-month deadline from the date of service is denied permanently. There is no appeal process for timely filing denials that would override the deadline. The revenue cannot be recovered regardless of the clinical merit of the underlying claim, the reason the claim was delayed, or the dollar amount at stake.

Accounts approaching the timely filing window need to be prioritized above all other AR activity above current cycle submissions, above denial follow-up for recently denied claims, above every other collection activity. A claim that is still within the filing window can be corrected and resubmitted. A claim that passes the deadline is gone.

Most billing software platforms including PointClickCare can generate reports sorted by date of service that effectively function as a timely filing exposure report when reviewed through the lens of the twelve-month deadline. The report should be reviewed monthly at minimum, and weekly for any account that is within 60 days of the deadline.

What to look for: Any account with a date of service more than ten months ago that does not have a paid or successfully appealed status. Those accounts are in the critical window. If there are more than one or two such accounts in any given monthly review, the billing operation has a systematic AR management gap that is generating timely filing risk faster than it is resolving it.

How MCA Medical Billing Solutions L.L.C. Provides the Reporting Your Facility Needs

MCA Medical Billing Solutions, L.L.C. provides structured monthly reporting that covers all seven of these report types payer-level AR aging with aging bucket breakdowns, denial trend analysis by root cause category, first-pass acceptance rate tracking, PDPM case-mix distribution monitoring, cash projection for the upcoming 30 to 60 days, write-off and adjustment categorization, and timely filing exposure tracking for every active account.

Every report we deliver includes documented action items alongside the data, so your team always knows what is being done about each finding, not just what the numbers show. Contact MCA Medical Billing Solutions, L.L.C. for a free billing assessment and a sample of our reporting format.