Administrators are often handed financial reports that are accurate but hard to act on: pages of aging buckets, payer breakdowns and monthly totals. A few well-chosen measures, tracked consistently, can tell you far more at a glance. Two of the most useful for a nursing home or senior-living operator are billing lag and days in accounts receivable. Together they show how quickly the care you deliver turns into money in the bank, and where the delays are.
Billing lag measures the time between providing a service and sending the bill. In long-term care, that may be the time between the end of a billing period, such as month-end, and the date the claim or invoice goes out.
Every day between the service and the bill is a day the organization is waiting to be paid. A long lag usually points to process problems upstream: incomplete documentation, missing orders, eligibility or authorization problems, or a backlog in the business office. Because those causes are fixable, billing lag is an excellent early warning.
For a given period, record the date services ended and the date each claim or invoice was submitted. The lag is the number of days between them. Report the average, and also look at the longest cases, since a few late claims can hide behind a good average. Break it out by payer type, such as Medicare, Medicaid, managed care and private pay, since each has its own pace and rules.
Days in accounts receivable, often shortened to days in AR, estimates how many days of revenue are currently waiting to be collected. It is a standard measure of collection speed.
A common approach is:
Take the total accounts receivable balance at the end of the period.
Divide it by average daily revenue, which is total revenue for the period divided by the number of days in it.
The result is days in AR.
For example, a hypothetical facility with a $900,000 receivable balance and $30,000 in average daily revenue has 30 days in AR. Use consistent definitions each month, since the number is only meaningful when the method does not change. Be clear whether you are using gross or net revenue, and keep to one.
A rising number means money is taking longer to arrive. A falling number means collections are speeding up. Because payers differ, track days in AR by payer type as well as in total. Ask your finance team or accountant what target makes sense for your organization, since benchmarks vary by payer mix and circumstances.
Alongside the two headline numbers, an aging summary shows how much is outstanding in groups such as 0 to 30 days, 31 to 60, 61 to 90 and over 90. Watch the share in the older buckets. Older balances are harder to collect, so a growing share is a sign to investigate.
Aim for something an administrator can read in a minute.
Put the headline numbers at the top: billing lag, days in AR and percentage of balances over 90 days.
Show a trend line for the last twelve months, so direction is obvious.
Show breakdowns by payer type and by building if you operate several.
Include a short list of the biggest open problems, such as the oldest balances or most common denial reasons.
Note the date of the data and the definition of each measure.
Refresh it at a steady cadence, usually monthly, and weekly for billing lag during problem periods.
Data typically comes from your billing system and the electronic record. The challenge is usually not the math, but making sure the inputs are consistent and complete. Make sure dates are captured the same way, payer categories are standardized and corrections are tracked. Where possible, automate the report instead of rebuilding it by hand each month, which reduces errors and time.
When a measure moves, ask why. Often the answer lies in documentation timing, staffing changes or payer behavior. Share the dashboard with clinical and business office leaders together, so that process improvements can be made as a team.
UnityCare IT helps operators pull data from billing and clinical systems into clear, secure dashboards that administrators can use. If your financial reports take hours to build, we can help automate them.
An outsourced IT department with proactive maintenance and one number to call.
Call or text: 405-285-3845
New customers: start@unitycareit.com
Existing customers: support@unitycareit.com
Address: UnityCare Technologies, 2524 N Broadway Ste 554, PMB 947974, Edmond, Oklahoma 73034-4172