Live demos: no login required HIPAA-aligned · BAA on every account Austin, TX · Built for skilled nursing operators
(405) 383-5214

Cash Forecasting for Skilled Nursing Using A/R and Census Data

A short-term cash forecast built from census, billing and A/R data gives leaders earlier warning and calmer decisions. Here is how to build a simple one.

3 min readBy CarePulse Analytics Team

Cash is the part of the business that nobody can ignore for long, yet many buildings manage it by feel. The business office knows roughly when payments arrive, the administrator watches the bank balance, and the owner asks questions at month-end. A simple short-term cash forecast, built from information you already have, can replace that uncertainty with a few weeks of visibility.

What a short-term forecast is

A short-term forecast is not a budget or a financial statement. It is a practical, rolling view of expected cash in and cash out for the next several weeks, updated regularly. Its purpose is to help you see timing gaps early, such as a payroll week that arrives before a large payment, so you can act without drama.

The inputs

Expected cash in

Cash in depends on three things: how much you have billed, how much is still to be billed, and how quickly each payer typically pays.

  • Billed A/R by payer and age: the balances already out the door
  • Unbilled revenue: services delivered that have not yet gone out, driven by census and assessment timing
  • Historical payment timing by payer: your own data on days from billing to payment

Expected cash out

  • Payroll and agency costs: the largest commitments, tied to staffing schedules
  • Vendor payments: pharmacy, food, supplies, utilities, therapy contracts
  • Fixed obligations: rent, debt service, insurance and other recurring items

Census as the driver

Because both revenue and some costs follow census, a forecast should respond to census changes. If census rises or falls, the expected revenue and certain expenses should move too.

Building it step by step

  1. Pick a horizon. Thirteen weeks is a common choice, but even four to six weeks is useful.
  2. Estimate weekly collections by payer. Use your own recent payment history. Use ranges if timing is uncertain.
  3. Layer in expected billing. Estimate what will be billed in each week based on census and payer mix.
  4. Add expected disbursements. Start with payroll dates and known vendor cycles.
  5. Compare cumulative cash to your minimum comfortable balance.
  6. Update weekly and compare forecast to actual.

That last step matters most. Every week you learn how far off you were and why, and the next forecast improves.

Measuring forecast accuracy

Track the difference between forecast and actual cash receipts each week. Large misses point to something worth understanding: a payer that slowed down, a billing delay, or a change in census. The miss is information, not failure.

What the forecast helps you decide

  • Whether to accelerate follow-up on specific accounts before a tight week
  • When to schedule larger purchases
  • Whether to talk with vendors or lenders early if a gap appears
  • How census or admissions changes affect liquidity
  • Where upstream process fixes would shorten the cash cycle

A hypothetical example

Imagine a hypothetical building whose forecast shows a tight week about a month away: payroll lands just before a large expected payment. Because the team sees it early, the business office focuses collection calls on accounts likely to resolve in time and schedules a vendor payment a few days later within agreed terms. Nothing dramatic happens, and that is exactly the point. Without the forecast, the same week might have produced a scramble.

Involving the right people

Cash forecasting is a joint effort. Admissions and the MDS coordinator influence billing speed. Nursing and scheduling influence labor cost. The business office manages collections and payables. Owners and regional finance staff care about the overall picture. A brief weekly check-in among a few of these people is often enough.

Pitfalls

  • Overbuilding. A complicated model nobody updates is worse than a simple one that is current.
  • Ignoring uncertainty. Show ranges or a conservative and expected case.
  • Mixing accrual and cash thinking. The forecast is about when money actually moves.
  • Not tracking assumptions. Write down what you assumed so you can revise.

Getting started

Begin with a six-week view using your top payers and your payroll calendar. If you would like to see how census, billing and A/R data can feed a rolling forecast, CarePulse can walk through an example with your own numbers in a demo.