Template · Published Nov 18, 2026
Medical Practice Cash Flow Forecast Template (Free Excel)
For owner-physicians and office managers who want to see a short payroll week six weeks before it arrives, using nothing but their own deposits, their bills and one spreadsheet.
A medical practice cash flow forecast projects money in and out week by week for 13 weeks, so the owner sees a short week before payroll. Build it from your deposits per clinic day and every dated payment, against a minimum cash line. Small health care businesses held a median 30 days of cash (JPMorgan Chase Institute, 2016).
- A 13-week forecast that fills itself from your deposits, your bills and the days you are closed
- A Dashboard that names the first short week, the gap in dollars and your days of cash on hand
- An outflow calendar that places weekly, every-2-weeks, monthly, quarterly and yearly payments in the right week
- Filled sample data, a 13-case Playbook and a 15-minute Monday routine
It works in Excel and Google Sheets, holds totals only, and needs no accounting software.
Get the free 13-week cash flow forecastKey takeaways
- The median small health care services business held 30 cash buffer days, against 27 for all small businesses, and a quarter of small businesses held fewer than 13 (JPMorgan Chase Institute, 2016; 2015 data, older than 2021).
- 84% of medical groups reported higher operating costs year to date in June 2026, about 11% higher on average (MGMA Stat, 2026, poll of 251 groups). Last year's cash pattern is not this year's.
- Benefits were 30.0% of private employers' compensation costs in June 2026 (BLS, Sep 2026): a payroll row that shows only net pay understates the biggest outflow.
- Monthly payroll tax depositors deposit by the 15th of the following month, Form 941 is due Apr 30, Jul 31, Oct 31 and Jan 31 (IRS Publication 15, 2026), and estimated tax is due Apr 15, Jun 15, Sep 15 and Jan 15 (IRS, 2026).
- An every-2-weeks payroll has 26 paydays, so two months carry three: with paydays every other Friday from Jan 8, 2027, those months are April and October (ClinicOps calculation).
Why a busy practice can still run short of cash
Practices rarely run short because the schedule emptied. They run short because cash leaves on fixed dates and arrives day by day. Payroll clears every other Friday, rent on the 1st, the software renewal once a year, and the owner's estimated tax four times a year, while receipts dip in every week with a closed day.
Cash and profit are different numbers: a practice can be profitable for the quarter and still have one Friday when the bank balance falls below the payroll it owes. The forecast exists to show that Friday while there is still time to move something.
Three things widen the gap: payroll rhythm (two months a year carry a third payday), bunching (an annual renewal landing on rent and payroll in the same week), and closed days (Thanksgiving, Christmas and New Year's Day can take three clinic days out of five weeks).
The medical practice cash flow forecast in four blocks
| Block | What goes in | Built from |
|---|---|---|
| 1. Receipts | Receipts per clinic day times the clinic days in each week, plus any override you know about | Your last 13 weeks of deposits and your closed days |
| 2. Outflows | Payroll, rent, vendors, software, licenses, taxes, owner distributions, patient refunds | The outflow calendar, by date |
| 3. Net cash flow | Receipts minus outflows, each week | Formula |
| 4. Projected balance | Today's bank balance plus each week's net, against your minimum cash line | Formula, with an alert below the line |
Every cell after the inputs should be a formula, because a forecast with typed totals is a guess that cannot update itself. In the free workbook you type four things: last quarter's weekly deposits, your bills, today's bank balance and your minimum line. Everything else recalculates.
Build receipts from your own deposits, per clinic day
Use deposits, not production or schedule value: the forecast cares about money that reached the bank. Add up the last 13 weeks of deposits and divide by the clinic days in those weeks. That one number, receipts per clinic day, carries your real mix of visit types, payment timing and slow weeks.
| Source | What it includes | Where to find it |
|---|---|---|
| Time-of-service payments | Cash, card and check taken at the desk on the day of the visit | Daily close sheets |
| Card-on-file and statement payments | Balances charged to a card on file, portal and mailed payments | Card processor and payment reports |
| Membership dues | Monthly or annual membership fees, if you offer a plan | Membership or card processor report |
| All other practice deposits | Every other deposit into the operating account | Bank statement |
Then count the clinic days in each coming week, Monday to Friday minus the days you close. A four-day week gets four days of receipts, which is how the forecast sees Thanksgiving coming without anyone remembering it. If something has changed that the last 13 weeks cannot show, such as a provider joining or leaving, apply a percentage adjustment and say why in a note.
The outflow calendar that never moves
The outflow side is easier because most of it is dated. Put every payment on one calendar by date, with how often it repeats, and let the forecast place it in the right week.
| Outflow | Timing and rule | Where to find it |
|---|---|---|
| Payroll | Every pay date, including employer taxes and benefits; on an every-2-weeks schedule, 26 paydays a year | Payroll provider calendar |
| Payroll tax deposits you make yourself | Monthly depositors by the 15th of the next month; semiweekly depositors by the Wednesday or Friday after payday (IRS Pub. 15) | Your deposit schedule |
| Rent or mortgage | Fixed monthly date | The lease, or the owner's property schedule |
| Software and annual renewals | Monthly or yearly renewal dates | The recurring task board |
| Licenses and registrations | Each renewal cycle; a DEA registration is $888 per practitioner every 3 years (21 CFR 1301.13) | The license tracker |
| Owner distributions for estimated tax | Apr 15, Jun 15, Sep 15 and Jan 15 (IRS) | Your accountant |
| Patient refunds | Within 30 days of finding an overpayment in Texas and Florida | The credit balance log |
Renewal dates come straight off the recurring task board, and refunds due come from the patient refund log. Payroll is two thirds of the outflows in the worked example below, and benefits were 30.0% of private employers' compensation costs in June 2026 (BLS, 2026), so enter payroll at its full cost, not net pay.
The free workbook already places weekly, every-2-weeks, monthly, quarterly and yearly payments in the right week, counts clinic days from your closed-day list, and flags the first week below your line.
Get the free forecastSet a minimum cash line you never go below
The minimum cash line is the balance that triggers action. Start with your heaviest week of outflows, usually a payroll week that lands on rent, so one bad week of deposits never misses a payroll. Then raise it toward a days-of-cash target: cash in the bank divided by average daily outflows.
The study measured cash buffer days as average daily balance divided by average daily outflows, the same calculation the workbook's Dashboard runs on your numbers. It is a description of what small businesses held, not a target; set yours with your accountant.
A worked 13-week example
| Week of | Clinic days | Receipts | Outflows | Net | Balance |
|---|---|---|---|---|---|
| Nov 23 | 4 | $40,800 | $71,500 | −$30,700 | $119,300 |
| Nov 30 | 5 | $51,000 | $41,900 | +$9,100 | $128,400 |
| Dec 7 | 5 | $51,000 | $71,500 | −$20,500 | $107,900 |
| Dec 14 | 5 | $51,000 | $9,500 | +$41,500 | $149,400 |
| Dec 21 | 4 | $40,800 | $83,500 | −$42,700 | $106,700 |
| Dec 28 | 4 | $40,800 | $27,500 | +$13,300 | $120,000 |
| Jan 4 | 5 | $51,000 | $71,500 | −$20,500 | $99,500 |
| Jan 11 | 5 | $51,000 | $39,500 | +$11,500 | $111,000 |
| Jan 18 | 5 | $51,000 | $71,500 | −$20,500 | $90,500 (below line) |
| Jan 25 | 5 | $51,000 | $11,276 | +$39,724 | $130,224 |
| Feb 1 | 5 | $51,000 | $89,500 | −$38,500 | $91,724 (below line) |
| Feb 8 | 5 | $51,000 | $9,500 | +$41,500 | $133,224 |
| Feb 15 | 5 | $51,000 | $71,500 | −$20,500 | $112,724 |
| 13 weeks | 62 | $632,400 | $669,676 | −$37,276 | Lowest $90,500 |
Two decisions, made in November, clear both weeks: pay the $12,000 bonus in March instead of December, and have the owner pay the Jan 15 estimated tax from personal savings instead of a practice distribution. With those moves the lowest balance is $107,900 and every week clears the line. What moving dates cannot fix is the $37,276 the quarter spends beyond what it brings in: that is a cost question, and it is the one to take to the owner. Days of cash on hand in this example are about 20 ($150,000 against $7,359 of average daily outflows), below the 30-day median above.
When a week falls below the line: levers, cheapest first
| Lever | What it does | Lead time |
|---|---|---|
| Move a discretionary payment | Shifts a supplies order, equipment purchase or bonus out of the short week | Immediate |
| Time owner distributions | Keeps distributions out of payroll weeks; the estimated tax dates are known a year ahead | Weeks |
| Ask a vendor for a different due date | Moves an annual renewal to a quieter week, only if it costs nothing extra | One call, weeks ahead |
| Collect self-pay balances at the visit | Brings money in on the day of service instead of weeks later | Weeks; a written policy |
| Charge card-on-file balances on the agreed date | Turns a statement cycle into a dated receipt, with the patient's written consent | One written policy |
| Hold back the next discretionary purchase | Raises the minimum line one week at a time toward your days-of-cash target | A quarter |
The front-desk side of the last two levers is set out in the patient financial policy template and the credit card on file policy. If the forecast keeps showing a quarter that spends more than it earns, the question is payroll share, schedule capacity and cost lines: that is what the Profit Leak Diagnostic on what a practice operations consultant costs answers. This is operational planning, not financial advice.
The 15-minute Monday update
| Step | Time | Who |
|---|---|---|
| Add last week's actual deposits, by source, with its clinic days | 5 minutes | Office manager or bookkeeper |
| Type what the forecast had said beside it, so the miss is tracked | 1 minute | Office manager |
| Roll Week 1 forward to this Monday and type today's bank balance | 2 minutes | Office manager |
| Add new bills, renewals and refunds due to the calendar | 4 minutes | Office manager |
| Send the owner the first short week and the gap in dollars | 3 minutes | Office manager |
A forecast nobody updates is worse than none, because it gives false comfort. Put the lowest projected balance on the owner dashboard, and feed the forecast its actuals from the month-end close.
- Write down today's bank balance and your heaviest week of outflows: that is your first minimum line.
- Pull the last 13 weeks of deposits and count the clinic days in them.
- List every payroll date, rent date, renewal and tax date for the next 13 weeks.
- Book a recurring 15-minute Monday slot to roll it forward.
Frequently asked questions
How do you make a cash flow forecast for a medical practice?
Start from your own last 13 weeks of deposits, divided by the clinic days in those weeks, to get receipts per clinic day. Multiply by the clinic days in each coming week, list every dated payment on a calendar, subtract, and carry the balance forward from today's bank balance. Flag any week that falls below a minimum cash line.
What is a 13-week cash flow forecast?
A week-by-week projection of cash in and cash out for the next quarter, rolled forward every Monday. Thirteen weeks is long enough to see payroll weeks, quarterly tax dates and annual renewals coming, and short enough that the numbers stay grounded in what you know.
How much cash should a medical practice keep on hand?
There is no official standard. A practical floor is your heaviest week of outflows, usually a payroll week that lands on rent. For context, the median small health care services business held 30 days of cash in the JPMorgan Chase Institute's study of about 600,000 firms (2015 data). Set your own target with your accountant.
Why does a profitable practice still run short of cash?
Because cash and profit run on different clocks. Payroll, rent and annual renewals leave on fixed dates, while receipts arrive day by day and dip in weeks with closed days. A quarter can be profitable and still have one payroll week where the bank balance falls below what you need.
How often should the forecast be updated?
Every Monday, in about 15 minutes: add last week's actual deposits, roll the start date forward one week, add any new bills, and read the first week that falls below the line. A forecast nobody updates gives false comfort.
What should a practice do when the forecast shows a short week?
Move a discretionary payment out of that week, time owner distributions around payroll, ask a vendor for a different due date at no extra cost, and collect self-pay balances at the visit. If every week is fine but the whole quarter spends more than it brings in, that is a cost and profit problem, not a timing one.
Next steps
- The Independent Medical Practice Hub
Every owner system, from the numbers to succession.
- The operations budget guide
The annual plan the forecast checks every week.
- The month-end close checklist
Locks last month's numbers so the forecast starts from the truth.
- The owner dashboard
Where the lowest projected balance belongs.
- What a practice operations consultant costs
Every ClinicOps engagement and fee, published.
See your short week six weeks early
Take the free workbook, load last quarter's deposits and your bills, and read the Dashboard on Monday. If the quarter keeps spending more than it brings in, book the free 20-minute Chaos Audit and we will find where the money goes with you.