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).

Inside the free Excel workbook
  • 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 forecast

Key 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

The forecast in four blocks
BlockWhat goes inBuilt from
1. ReceiptsReceipts per clinic day times the clinic days in each week, plus any override you know aboutYour last 13 weeks of deposits and your closed days
2. OutflowsPayroll, rent, vendors, software, licenses, taxes, owner distributions, patient refundsThe outflow calendar, by date
3. Net cash flowReceipts minus outflows, each weekFormula
4. Projected balanceToday's bank balance plus each week's net, against your minimum cash lineFormula, 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.

Receipt sources to record each week (totals only)
SourceWhat it includesWhere to find it
Time-of-service paymentsCash, card and check taken at the desk on the day of the visitDaily close sheets
Card-on-file and statement paymentsBalances charged to a card on file, portal and mailed paymentsCard processor and payment reports
Membership duesMonthly or annual membership fees, if you offer a planMembership or card processor report
All other practice depositsEvery other deposit into the operating accountBank 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.

What to load on the outflow calendar
OutflowTiming and ruleWhere to find it
PayrollEvery pay date, including employer taxes and benefits; on an every-2-weeks schedule, 26 paydays a yearPayroll provider calendar
Payroll tax deposits you make yourselfMonthly 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 mortgageFixed monthly dateThe lease, or the owner's property schedule
Software and annual renewalsMonthly or yearly renewal datesThe recurring task board
Licenses and registrationsEach renewal cycle; a DEA registration is $888 per practitioner every 3 years (21 CFR 1301.13)The license tracker
Owner distributions for estimated taxApr 15, Jun 15, Sep 15 and Jan 15 (IRS)Your accountant
Patient refundsWithin 30 days of finding an overpayment in Texas and FloridaThe 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.

Skip the formulas

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 forecast

Set 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.

Median cash buffer days for small businesses, by industry (2015 data)Horizontal bar chart from the JPMorgan Chase Institute: real estate 47 days, health care services 30 days, all small businesses 27 days, construction 20 days, retail 19 days, restaurants 16 days. DAYS OF CASH A SMALL BUSINESS HOLDS (MEDIAN) Real estate47 Health care services30 All small businesses27 Construction20 Retail19 Restaurants16
Small health care businesses held about a month of cash. Median cash buffer days: real estate 47, health care services 30, all small businesses 27, construction 20, retail 19, restaurants 16. A quarter of small businesses held fewer than 13 days. Data from about 600,000 small businesses in 2015, so older than 2021. Source: JPMorgan Chase Institute, Cash is King, 2016.

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

Worked example
A two-physician practice starting the quarter on Monday, Nov 23, 2026 with $150,000 in the bank and a $95,000 minimum line. Receipts run $10,200 per clinic day from its last 13 weeks; Thanksgiving, Christmas and New Year's Day each take one day out. Payroll of $62,000 clears every other Friday, rent of $18,000 on the 1st, vendors about $9,500 a week. One-offs: a $14,400 software renewal on Dec 1, a $12,000 year-end bonus, a $30,000 owner distribution for the Jan 15 estimated tax, and two DEA renewals ($1,776). All figures are illustrative.
13-week forecast, worked example (illustrative)
Week ofClinic daysReceiptsOutflowsNetBalance
Nov 234$40,800$71,500−$30,700$119,300
Nov 305$51,000$41,900+$9,100$128,400
Dec 75$51,000$71,500−$20,500$107,900
Dec 145$51,000$9,500+$41,500$149,400
Dec 214$40,800$83,500−$42,700$106,700
Dec 284$40,800$27,500+$13,300$120,000
Jan 45$51,000$71,500−$20,500$99,500
Jan 115$51,000$39,500+$11,500$111,000
Jan 185$51,000$71,500−$20,500$90,500 (below line)
Jan 255$51,000$11,276+$39,724$130,224
Feb 15$51,000$89,500−$38,500$91,724 (below line)
Feb 85$51,000$9,500+$41,500$133,224
Feb 155$51,000$71,500−$20,500$112,724
13 weeks62$632,400$669,676−$37,276Lowest $90,500
Projected weekly cash balance against a $95,000 minimum line, worked exampleLine chart of the worked example. The balance starts at $150,000, swings between payroll and non-payroll weeks, and falls below the $95,000 minimum line twice: $90,500 in the week of Jan 18 and $91,724 in the week of Feb 1. The lowest point is $90,500. TWO PAYROLL WEEKS DIP BELOW THE LINE $50k $100k $150k $95,000 minimum line $90,500 12345678910111213 Week of the forecast. Worked example, illustrative figures (ClinicOps).
Two payroll weeks fall below the line. The balance drops to $90,500 in week 9 (Jan 18) and $91,724 in week 11 (Feb 1), against a $95,000 line, and the quarter spends $37,276 more than it brings in. Worked example; every number is in the table above.

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

Levers when the forecast shows a short week, cheapest first
LeverWhat it doesLead time
Move a discretionary paymentShifts a supplies order, equipment purchase or bonus out of the short weekImmediate
Time owner distributionsKeeps distributions out of payroll weeks; the estimated tax dates are known a year aheadWeeks
Ask a vendor for a different due dateMoves an annual renewal to a quieter week, only if it costs nothing extraOne call, weeks ahead
Collect self-pay balances at the visitBrings money in on the day of service instead of weeks laterWeeks; a written policy
Charge card-on-file balances on the agreed dateTurns a statement cycle into a dated receipt, with the patient's written consentOne written policy
Hold back the next discretionary purchaseRaises the minimum line one week at a time toward your days-of-cash targetA 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

The weekly update
StepTimeWho
Add last week's actual deposits, by source, with its clinic days5 minutesOffice manager or bookkeeper
Type what the forecast had said beside it, so the miss is tracked1 minuteOffice manager
Roll Week 1 forward to this Monday and type today's bank balance2 minutesOffice manager
Add new bills, renewals and refunds due to the calendar4 minutesOffice manager
Send the owner the first short week and the gap in dollars3 minutesOffice 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.

Do this this week
  1. Write down today's bank balance and your heaviest week of outflows: that is your first minimum line.
  2. Pull the last 13 weeks of deposits and count the clinic days in them.
  3. List every payroll date, rent date, renewal and tax date for the next 13 weeks.
  4. 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

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.