Financial Dashboard and Cash Flow Model for Medical Clinics
Complete financial control model with health sector-specific indicators.
Implement professional financial management in a medical clinic, including cash flow, simplified income statement, and performance metrics by physician, insurance provider, and procedure.
At a glance
Access
Free prompt
Open to copy — no account or payment needed.
Prompt objective
Implement professional financial management in a medical clinic, including cash flow, simplified income statement, and performance metrics by physician, insurance provider, and procedure.
Real use case
Clínica Integra Saúde in Salvador has 4 physicians, bills $56,000/month, but founding partner Dr. Roberto doesn't know if the practice is profitable. He has never had a structured income statement and mixes personal and business expenses.
Customize these fields first
Replace the placeholders with your own context before you run the prompt. That usually improves the first output more than adding more instructions later.
Prompt
Create a complete financial management model for [CLINIC NAME], with [NUMBER] physicians, monthly revenue of $[AMOUNT], and revenue mix of [PERCENTAGE]% private / [PERCENTAGE]% insurance. **1) DAILY/WEEKLY CASH FLOW:** - Spreadsheet template with revenue categories: - Private consultations (by physician) - Insurance consultations (by carrier) - Procedures - Additional tests - Expense categories: - Payroll and benefits - Rent and condo fees - Supplies and materials - Equipment and maintenance - Marketing - Taxes (Simplified tax system / Presumed profit regime) - Software and technology **2) SIMPLIFIED MONTHLY INCOME STATEMENT:** - Gross revenue by source - (-) Claim denials and bad debt - = Net revenue - (-) Variable costs - = Contribution margin - (-) Fixed costs - = Operating income - Target net margin: [%] **3) KEY PERFORMANCE INDICATORS (KPIs):** - Average revenue per patient - Customer acquisition cost (CAC) - Revenue per square foot - Revenue per consulting room hour - Claim denial rate by carrier - Average collection time by insurance - Schedule utilization by physician (%) - Return on equipment investment **4) INSURANCE ANALYSIS:** - Actual profitability by carrier (paid amount - denials - operational cost) - Insurance ranking by profitability - Criteria for maintaining or dropping insurance contracts **5) TAX STRUCTURE:** - Comparison: Simplified tax system vs. Presumed profit regime for [NUMBER]-physician clinic - Hospital classification (when applicable): ISS savings - Salary vs. profit distribution: tax optimization **6) 12-MONTH PROJECTION:** - Revenue projection model with scenarios (conservative, realistic, optimistic) - Clinic break-even point - Priority investments for growth Current practice management software: [SOFTWARE]. Accountant: [YES/NO].
Open directly in an AI — the text is pre-filled:
How to use this prompt
- 1Replace the key placeholders first: CLINIC NAME, NUMBER, AMOUNT, PERCENTAGE.
- 2Replace any bracketed placeholders like [this] with your own context.
- 3Add extra background information when you want more tailored results.
- 4Combine multiple prompts in one conversation when you need a richer output.
- 5Save your best-performing prompts so they are easy to reuse later.
Next best step
Open the guide first, then branch only if you still need more.
A buyer guide for deciding between the free challenge, a focused learning path, and Pro membership.
If this prompt is close but not quite right, generate variants next. If the job is recurring, move into the course library after the guide.
Related prompts
View allMultichannel No-Show Reduction System
Complete strategy to reduce appointment no-shows using multiple communication channels.
Best for
Reduce a medical clinic's no-show rate to under 10% through a structured confirmation, reminder, and schedule management system.
Electronic Health Record Implementation with Migration Checklist
Step-by-step guide for migrating from paper records to a digital system.
Best for
Plan and execute EHR implementation while ensuring LGPD, medical board compliance, and uninterrupted patient care during the transition.
Medical Schedule Optimization to Maximize Productivity
Practice management scheduling model that balances productivity, quality, and patient satisfaction.
Best for
Restructure the medical schedule to increase patient volume without sacrificing quality, reducing idle time and better distributing appointment types throughout the day.
Medical Practice Expansion Plan for Second Location
Strategic roadmap for opening a medical clinic branch location.
Best for
Plan the opening of a second clinic location with viability analysis, site selection, operational model, and financial timeline.
Explore other prompt categories
Move sideways into adjacent libraries when the current category is not the full answer.
Every prompt here is free. The course teaches the thinking behind them.
Copy as many prompts as you like. When you want to move from single prompts to a repeatable AI workflow, Learn AI in 30 Days walks through it, one day at a time.
Buy the course once ($15/$20 by length), or go all-access for $10/mo with a verifiable certificate.