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 allPrepare an administrative clinic FAQ from approved answers
A clinic FAQ and escalation guide. Start with your own evidence and finish with a reviewable next step.
Best for
Produce a clinic FAQ and escalation guide from the supplied inputs.
Summarize a nonclinical workflow problem in a clinic
A workflow map and improvement experiment brief. Start with your own evidence and finish with a reviewable next step.
Best for
Produce a workflow map and improvement experiment brief from the supplied inputs.
Multichannel No-Show Reduction System
An administrative plan or plain-language draft with source traceability, escalation and review checklist. Includes required inputs, evidence checks and a concrete next step.
Best for
Complete “Multichannel No-Show Reduction System” with an administrative plan or plain-language draft with source traceability, escalation and review checklist that can be checked against the supplied evidence.
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.
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 ($20), or choose $10/month or $100 lifetime access.