Clinic opening budget template
What it costs to open, what it costs to run each month, and how much cash you need before the clinic pays for itself. The break-even month and the peak cash need come out of your own numbers.
Download
FreeNo sign-upDownloads directlyExcel and Google Sheets
What is inside
| Settings | Clinic name, currency, country, city, opening month, working days, a safety margin on the cash, your rooms, and your services with prices and share of visits. |
|---|---|
| Set-up | Fit-out, equipment per room with lead times and an order-by date, furniture, IT and software, signage and first stock. A licence table with Egypt and Saudi columns, amounts left for you to fill. |
| Monthly running | Rent, salaries by role, marketing, utilities and software, with doctor shares, consumables and payment fees as a share of revenue. |
| Forecast | Months 1 to 18: visits per day on a ramp you set, average visit value, revenue, costs, net and cumulative cash, with a chart. |
| Summary | Total investment by category, monthly fixed cost, break-even revenue and visits per day, the break-even month, the peak cash need and the cash to have with the safety margin. |
How to use it
Set the basics
Country, opening month, working days and your services with prices.
Price the set-up
Every item with its price and lead time; licences from current quotes.
Enter running costs
Rent, salaries by role and the costs that move with revenue.
Shape the ramp
Change visits per day month by month and read the summary.
Who it is for
Doctors and investors planning a new clinic or a new branch, and the adviser preparing the numbers for a bank or a partner. The sample is a four-room dermatology clinic in Riyadh: it breaks even in month 9, and the peak cash need sits in one highlighted cell.
Read next
Profitability
Revenue, cost and profit per branch, department and doctor, updating as the day runs. Medicolize shows clinic owners where the money actually is.
Read more From the blogHow to open a clinic or a medical complex
The licence is the part everyone plans for. The decisions that cost most are the ones made in the first month and lived with for years.
Read moreMore free files
Questions
Does it work in Google Sheets?
Yes. Upload it to Google Drive and open it with Google Sheets. It uses SUMIFS, SUMPRODUCT, MATCH and EDATE, which both handle.
Can I change the currency?
Yes. Pick it on the Settings sheet. The amounts are numbers, so the sums do not change.
Is my data stored anywhere?
No. The file is yours, on your computer or your own Drive. Nothing you type reaches Medicolize.
Why are the licence fees empty?
They differ by country and city and they change. Fill them from current quotes, or ask your adviser, before you rely on the total.
The forecast against what really happens
Once the clinic opens, Medicolize shows revenue, costs and margin each month from the visits and expenses you record, so you can see whether you are ahead of the forecast or behind it. Thirty minutes on your own clinic.