A clinic can be fully booked and still run short of cash. Insurers pay weeks after treatment, payroll and rent do not wait, and a delayed claim payment can leave the account thin at the worst moment. A 13 week cash flow forecast is the simplest tool for seeing that problem before it arrives.
It is a weekly forecast of the cash you expect to receive and pay over the next quarter, updated every week. This guide shows how a clinic or small clinic group can build a 13 week cash flow forecast without special software, plus a simple layout you can copy.
Why a 13 Week Cash Flow Forecast Suits a Clinic
Thirteen weeks is one quarter. It is long enough to see payroll cycles, supplier terms and insurer payment patterns, and short enough that your estimates stay believable. A yearly budget tells you whether the business is profitable. A 13-week forecast tells you whether you can pay everyone next month. For a general overview of the method, see BDO’s guide to rolling 13-week cash flow forecasts. It is written for retailers, but the mechanics are the same.
What Goes into the Forecast
Cash in:
- Self-pay patients, usually collected the same week as treatment.
- Insurer payments, which follow claim submission by a delay that you can measure from your own history.
- Other receipts, such as rent from a sub-let room or a loan drawdown.
Cash out:
- Payroll and doctor payouts on their real pay dates.
- Rent and utilities.
- Suppliers for consumables, medicines and lab services, on their agreed terms.
- Tax and government payments on their due dates.
- Loan repayments and planned equipment purchases.
How to Build Your 13 Week Cash Flow Forecast, Step by Step
1. Start from the Bank, Not the Ledger
Your opening balance is the cash actually in the bank today, across every account. Accounting profit is not cash, so begin with what you can spend.
2. Forecast Insurer Receipts by How You Really Get Paid
Do not assume an insurer pays on the invoice date. Look at the last six months of claims and note how many days each major payer takes from submission to payment, and what share of claims comes back rejected. Use those real delays to place each expected payment in the right week. A rejected claim is not lost, but it moves the cash later. For the receipts side in more depth, our guide to healthcare revenue forecasting shows how to walk from gross charges to the cash you will actually collect.
3. List Every Payment by Its Due Date
Go through payroll, rent, supplier invoices and tax obligations and put each one in the week it is actually paid, not the week it is incurred.
4. Put It in a Weekly Table
One column per week, thirteen in total. Rows for opening cash, each type of receipt, each type of payment, net movement and closing cash. The closing cash of one week becomes the opening cash of the next.
5. Set a Minimum Cash Buffer
Decide the lowest balance you are willing to hold, for example two to three weeks of fixed costs. Any week where closing cash falls below it is a warning, and you have weeks of notice to act.
6. Update It Every Week and Compare with Actuals
Each week, replace the forecast for the week just ended with what really happened, then add a new week at the end. The differences teach you where your assumptions are wrong, especially insurer timing.
Free Download
13 Week Cash Flow Forecast Template
Skip the setup. This Excel workbook has the layout built, with insurer delays, scenarios, charts and checks. Enter your numbers once and see your cash week by week.
A Simple 13 Week Cash Flow Forecast Layout You Can Copy
| Row | Week 1 | Week 2 | Week 3 | … |
|---|---|---|---|---|
| Opening cash | from the bank | = Week 1 closing | = Week 2 closing | … |
| Self-pay receipts | ||||
| Insurer receipts | ||||
| Payroll and doctor payouts | ||||
| Rent and utilities | ||||
| Suppliers | ||||
| Tax and other payments | ||||
| Closing cash | opening plus receipts minus payments | |||
| Minimum buffer | your chosen floor |
Common Mistakes
- Forecasting revenue instead of cash. Billing is not collection. Put money in the week it arrives.
- Assuming insurers pay on time. Use your own payment history.
- Forgetting the lumpy items. Annual licence renewals, insurance premiums and equipment servicing can empty a week.
- Building it once and never updating it. The value is in the weekly routine.
How This Connects to Working Capital and Treasury
Your 13 week cash flow forecast shows you when cash is tight. Improving the underlying numbers is a working capital job: collecting faster, holding less stock and paying suppliers on agreed terms. Our guide to healthcare working capital management covers that. Once you can see the weeks ahead, decisions about bank accounts, buffers and funding belong to healthcare treasury management. If slow insurer payments are your main pressure, see how to reduce AR days in a GCC healthcare group.
Frequently Asked Questions
What Is a 13 Week Cash Flow Forecast?
A 13 week cash flow forecast is a weekly forecast of expected cash receipts and payments for the next 13 weeks, rolled forward every week, that shows your expected bank balance at the end of each week.
How Often Should a Clinic Update Its Cash Forecast?
Every week. Replace the week that has just ended with actual figures and add a new week at the end, so the forecast always looks 13 weeks ahead.
Do I Need Special Software?
No. A spreadsheet is enough to start. What matters is using real bank balances and real payment timing, and keeping it up to date.
Related Service
Want this handled for you? See our Finance and CFO Advisory service.
Need help setting up a 13 week cash flow forecast for your clinic or group? Talk to OzaniX Partners about finance support built for healthcare.