Many operators watch their receivables closely but still feel surprised when payroll or a vendor bill comes due and cash is tighter than expected. The reason is simple: an A/R balance tells you how much is owed, not when it will turn into cash. A short-term cash forecast bridges that gap.
You do not need a treasury department to build one. A basic rolling forecast, updated weekly, can give owners, administrators, and finance leaders a clearer view of the coming weeks.
Start with what you can see
A forecast built from information you already have is more reliable than one built from hope. Gather three things.
- Outstanding claims and balances, grouped by payer and age
- Payment history by payer, showing how long each typically takes from billing to payment
- Upcoming billing, based on current census and expected admissions and discharges
Use payer timing, not a single average
Different payers pay on different rhythms. If you look at your own history, you may find that some pay within a fairly consistent window and others vary widely. Apply each payer's typical timing to their open balances to estimate which week the money is likely to arrive.
Be conservative. If a payer's timing varies, plan around the slower end of the range and treat anything earlier as a bonus.
Separate the predictable from the uncertain
Not all receivables are equally likely to be collected on schedule. Group them roughly into categories.
- Clean claims already submitted, which are the most predictable
- Claims in follow-up or correction, which are less predictable
- Appealed or disputed claims, which are uncertain and slow
- Private-pay balances, which depend on individual circumstances
Assign each category a cautious expectation, based on your own history, and avoid counting disputed balances as near-term cash.
Add the billing still to come
Cash in a few weeks will include revenue you have not yet billed. Estimate it using current census by payer and typical billing schedules. This part of the forecast links directly to your census forecast, so a change in admissions or discharges flows through to expected cash.
Lay out the weeks
Create a simple table in a spreadsheet or dashboard with one column per week for the next eight to twelve weeks. Include expected collections, known outflows such as payroll and major vendor payments, and the resulting cash position. Update it weekly, and compare your prior forecast to what actually happened.
Learn from the gaps
Each week, note the difference between forecast and actual collections. Over time you will see systematic patterns, such as consistently slower payment from a specific payer or delays around holidays. Adjust your assumptions accordingly. A forecast that improves with feedback becomes a reliable tool.
Use it to make decisions
A cash forecast supports practical choices.
- Timing of vendor payments: knowing when cash tightens helps you plan
- Collection priorities: focusing effort on balances that will matter most to near-term cash
- Staffing and agency decisions: understanding financial room to add incentives or positions
- Conversations with owners or lenders: presenting a grounded view of the coming weeks
A hypothetical example
Imagine a hypothetical building where the forecast shows a dip in expected collections in three weeks, because a group of claims was submitted late. The business office sees it early, prioritizes the follow-up, and the administrator discusses timing of a large vendor payment with finance. Nothing dramatic happened, but the surprise was avoided.
Common mistakes
- Counting all receivables as cash. Some will take longer or never arrive.
- Using a blended average for timing. Payer-specific timing is more accurate.
- Forgetting seasonality. Holidays and year-end can slow payments.
- Not checking the forecast against reality. Accuracy improves only with feedback.
- Making it too complex. A simple forecast reviewed weekly is better than a complicated one reviewed rarely.
Keep the process light
The purpose is awareness, not precision. Spend a short time each week updating the key inputs, reviewing differences, and discussing what to do. Over a few months it becomes a habit that gives leaders confidence.
Where data helps
Much of the information needed, including claims status, payment dates, and census, sits in billing and EHR systems. Pulling it into one view automatically saves hours each week and reduces errors from manual copying.
CarePulse Analytics connects billing, A/R, and census data into forward-looking collection views. If you would like to see a rolling cash outlook built from your own numbers, a brief demo is a good place to begin.