90-Day Rolling Cash Flow Forecasting for Medical Practices
Reviewed by Scott Nielson, CPA, Partner, Director of Tax on
An annual budget tells a medical practice what it hopes will happen. A 90-day cash flow forecast tells it what is actually going to happen. For a practice where insurance reimbursement lags service by 30 to 60 days and payroll runs every two weeks like clockwork, the gap between promise and payment is where liquidity squeezes hide. Most practices only see the squeeze the week payroll clears the operating account and the balance is uncomfortably low.
A rolling 90-day forecast, updated weekly, is the single most useful cash management tool a small-group practice can build. It does not require a CFO, and it does not require software the practice does not already have. This piece covers why 90 days is the right window, what rows belong in the model, how to tie it to DSO and payer mix, and how to keep it current without spending Sunday nights in Excel.
Why 90 Days (Not 12 Months)
A 12-month forecast is useful for planning big moves: a new provider hire, a build-out, a new location. It is close to useless for managing next Tuesday’s payroll. Twelve-month forecasts smooth out the timing that matters. A practice with $2.4 million in annual collections averages $200,000 a month, but the actual pattern is lumpy: a $260,000 month follows a $170,000 month, and the payroll obligations do not care.
Ninety days is the window where receivables are close enough to predict but far enough out to give the practice time to react. If a squeeze is coming eight weeks out, there is time to adjust. If it is coming next week, there is not.
The Rows That Belong in a Medical Practice Cash Flow
The model does not need every account. It needs the ones that move.
On the inflow side: net collections by payer category (commercial, Medicare, Medicaid, self-pay, workers’ comp), patient responsibility collections, and any known ancillary revenue like lab pass-through. Split by payer so a slowdown in one category is visible immediately.
On the outflow side: provider compensation, staff payroll and payroll taxes, occupancy, malpractice, medical supplies, software and clearinghouse fees, and debt service. Group everything else as “other” and only break it out if it exceeds 3% of monthly spend.
The bottom row is opening balance, plus inflow, minus outflow, equals ending balance, which becomes the next week’s opening balance. That single line, forward 13 weeks, is the whole model.
Tying Inflow to DSO and Payer Mix
The inflow side is where most cash flow forecasts fail. Practices project future collections based on future charges, which double-counts the reimbursement lag. Charges submitted today do not become cash for 30 to 60 days depending on payer. The forecast has to reflect that timing.
The cleanest way is to use current AR by payer as the base for the next 60 days and only lean on charge projections for weeks 9 through 13. That treats the aged AR as a known quantity (it is, more or less) and only forecasts the parts still in the future. Practices with meaningful DSO drift can build a payer-level collection curve from their own last 90 days and apply it forward. The model is not exact; it does not need to be. It needs to be closer than the alternative, which is guessing.
How to Update It Weekly Without a CFO
The update takes 20 to 30 minutes if the source data is clean. The steps are:
- Pull last week’s actual collections by payer from the practice management system
- Replace the projection for that week with actuals
- Roll the model forward one week
- Add a fresh week at the end based on charges submitted the prior week
- Look at the ending balance line for any week that goes negative or below the target reserve
Practices that assign this to a specific person on a specific day (Wednesday morning is common) keep it running. Practices that treat it as “the CPA’s job” usually let it lapse.
The Warning Signs a 90-Day Model Catches
A well-run model surfaces three patterns early: a payer slowdown that is not showing up in the P&L yet, a payroll or vendor cost drift that is quietly eating margin, and a receivables aging drift that means the practice is billing fine but collecting slower. Each one has a fix, and each one is much easier to fix at week eight than at week one.
Cooper Norman’s healthcare accounting team builds and maintains 90-day cash flow models for practices across Idaho and Utah, and connects them to the practice’s revenue cycle and comp planning. To set one up for your practice, talk with a Cooper Norman advisor.