Cash Flow Forecast Template for Medical Practices

A medical practice delivers care today and waits weeks or months to be paid for it. Insurance claims take 30 to 90 days, some are denied and resubmitted, and patient balances trickle in. Meanwhile clinical and admin staff are paid every two weeks, and rent, supplies and malpractice insurance don’t wait. A cash flow forecast built around claim timing shows whether the practice can cover payroll through the lag.

Why practice cash flow is different

• Reimbursement lags. Most revenue arrives 30 to 90 days after the visit, depending on payer.
• Denials delay cash further. Rejected claims have to be corrected and resubmitted, pushing payment back again.
• Payer mix matters. Commercial insurers, government programs and self-pay patients all pay at different speeds.
• Payroll is biweekly. Staff costs are the largest expense and don’t move with collections.
• Large annual costs. Malpractice premiums and equipment renewals often fall in a single month.

A worked example

A practice bills about $82,500 a month in insurance claims. Insurers pay 5 percent in the month, 55 percent the next month and 30 percent the month after; the remaining 10 percent is written off or slow.

Only about 5 percent of January’s claims turn into cash in January. A new practice, or one that has just added a provider, carries two to three months of unpaid claims before collections catch up, and needs cash to fund payroll through that period.

How to build a practice cash forecast

1. Forecast visits and charges by provider and month.
2. Split by payer type and apply each payer’s typical days to payment.
3. Add patient copays and self-pay collections, with a realistic collection rate.
4. Add payroll on its actual pay dates, then rent, supplies, software and billing fees.
5. Schedule malpractice insurance and equipment leases.
6. Track days in accounts receivable monthly, since rising AR means cash is slipping.

Common mistakes

Forecasting cash from charges instead of expected collections. Ignoring denials. Adding a provider without funding the months before their claims pay. And forgetting billing service fees are a percentage of collections.

What the template gives you

The Medical Practice template includes a Claims Lag tab that converts what you bill each month into what insurers actually pay and when, and a Billing Fees tab that calculates your billing company’s percentage automatically. The dashboard shows the lowest balance in the next 13 weeks so payroll is never a surprise.

Key assumptions built into the Medical Practice template

• The Claims Lag tab turns what you invoice into cash actually collected for “Insurance reimbursements”. The example assumes 5% is paid in the month invoiced, 55% the following month and 30% two months later. Invoices sent before the start date are entered separately so the first months are right, and anything never collected shows as bad debt, so you can see what slow payers cost you.
• The Billing Fees tab calculates billing service fee at 5% of insurance reimbursements and medicare / medicaid. Change a percentage once and every month of the forecast updates, so costs rise and fall with the sales that drive them.
• 5 cash in lines and 7 cash out lines are already named for medical practice businesses, and every one can be renamed or extended.
• The example figures follow a fairly even year, which suits most medical practice businesses; add your own seasonal pattern if you have one.

Every assumption sits in a yellow input cell, so you replace the example with your own numbers in minutes. The same figures flow through a 13-week weekly view, a 12-month monthly view and a 3-year outlook, and a dashboard shows your lowest balance, the weeks that fall below your minimum buffer and your cash runway.

Free or premium?

If you only need the basics, the free 12-month template or the free 13-week template will get you started today. The premium Medical Practice template saves the setup time and adds the tabs above, best and worst case scenarios, and an actual vs forecast tracker that shows where your forecast was wrong, so next month’s is better.

Medical Practice cash flow forecasting: questions

How long do insurance claims take to pay?

Commonly 30 to 60 days for clean claims, and longer for denials or government programs. Use your own practice’s history for the forecast.

How do I forecast cash for a new medical practice?

Assume little collection in the first one to two months while claims are processed, and fund payroll and rent for that period from savings or a line of credit.

What is days in accounts receivable?

The average number of days between billing a claim and being paid. Many practices aim to keep it below 40 to 50 days.