A 13-Week Cash Forecast for an Insurance-Based Practice

In an insurance-based practice, the session happens today, the claim goes out this week, and the money arrives whenever the payer pays. Payroll runs on its own calendar. A weekly cash forecast is how you keep those two clocks in view at the same time.

A practice can be busy and profitable and still have a week where the account runs thin, because revenue and cash run on different timelines. The general version of that problem is in why cash is tight when the P&L looks fine. This piece is the specific tool for a practice that bills insurance: a 13-week forecast of the actual bank account, built around claim timing.

Why weekly, and why thirteen

Thirteen weeks is a quarter, long enough to see a problem coming and short enough to forecast with real data rather than hope. Weekly matters because a practice's big outflows land on specific days. On a biweekly payroll, a 13-week window holds six or seven paydays, plus rent, debt service and the other fixed bills. A monthly forecast averages those out and hides the one week that matters.

Receipts: build them from claim timing by payer

Start with the schedule. Sessions booked for the coming weeks, adjusted for your usual cancellations and no-shows, turn into claims, and each claim turns into cash after that payer's lag. The lag comes from your own history: for each payer, how many days pass between submitting a claim and the payment landing, which your remittance data already records. Use your numbers, not someone else's.

For Medicare Part B claims, federal law sets the outer shape of the window. Medicare Part B contractors may not issue payment on an electronically submitted claim within 13 days of receiving it, and must pay at least 95% of clean claims within 30 calendar days of receipt (42 U.S.C. 1395u(c)). Commercial payers follow their contracts and your state's rules, and their actual timing is something to measure rather than assume.

Then add the receipts that do not wait on a payer: copays and coinsurance collected at the session, self-pay clients, and any card-on-file balances. Finally, make room for denials. Some share of claims, which your own denial history will tell you, comes back for correction and pays weeks later than the rest, if it pays at all. Put those dollars in the later weeks, not the expected ones.

Payments: the fixed calendar

The outflow side is easier, because most of it is scheduled. Payroll and the payroll taxes that go with it, on their actual dates. Clinician pay under a split, timed by whether it is paid on sessions held or on collections, which can move the forecast by weeks; the difference is covered in associate therapist pay: split, salary, or hybrid. Then rent, the EHR and other software, insurance, loan and line of credit payments, and owner distributions, including any the owners plan to take to cover their own estimated tax payments.

Anything lumpy belongs in its exact week: an annual software renewal, a security deposit for a new office, the first payroll for a clinician who starts mid-quarter. Those are the items that create a bad week when nobody wrote them down.

The cash floor

Pick a minimum balance the practice should not drop below, and draw it on the forecast as a line. A reasonable starting point is enough to cover the next payroll even if a large payer is late, but it is your number to set. Then every week, the forecast answers one question before any other: does any week in the next thirteen cross the floor?

If one does, you have weeks of notice instead of days. You can work the oldest claims first, move a distribution a week later, time a new clinician's start date, or draw on a line of credit early and on your own terms rather than in a hurry.

The weekly update

Once it exists, the forecast takes a short weekly routine. Replace last week's forecast with what actually happened, roll a new week onto the end, and compare forecast receipts with actual receipts by payer. That comparison is the early warning: when one payer's deposits run behind forecast for two or three weeks, something has changed, a rule, a credentialing issue, or a batch of denials, and you see it before it shows up in the monthly numbers.

The forecast also feeds the rest of the Monday routine. Runway in weeks, claims over 60 days, and payroll due in the next two weeks are all on the seven numbers a practice owner should watch weekly.

Where the data comes from

Three sources cover nearly all of it: the practice management system for scheduled sessions, claims submitted and payments posted by payer; the bank for actual receipts and payments; and payroll for pay dates and amounts. It all assumes books that are current and reconciled. A practice whose books are kept on a live dashboard has a head start, and our affiliate bookkeepz explains what a live financial dashboard is; the forecast is the forward-looking layer built on top of those books.