Healthcare P&L Template

Download the .xlsx file and open it in Excel or Google Sheets. Start with the Monthly P&L tab: review the pre-loaded payer categories and expense line items, and adjust them to match your practice's chart of accounts. Most practices keep the structure as-is and rename a few line items — for example, swapping 'mid-level provider' to match your specific role titles, or splitting malpractice insurance by specialty if you have multiple. This setup takes about 15 minutes.

Once the categories are set, enter your collections by payer type for the current month. Use your practice management system or billing software to pull total collected amounts by payer — not gross charges, not allowed amounts, but actual deposits. Then enter your expenses from your accounting system or bank statement. The sheet calculates gross margin, operating expenses, and net income automatically. Fill in the AR Aging Summary from your PM system's aging report.

The template becomes most useful as a monthly discipline. Set a standing reminder to close each month within 10 days of month-end — that's usually enough time for most insurance payments to post. Compare your net collection rate to your prior months; a dip often points to a billing issue or a new denial pattern before it shows up in your bank account. Run the Dashboard once a quarter with your practice administrator or billing team to catch trends in payer mix shifts or rising overhead percentages.

Healthcare practices operate on a different financial model than most businesses. Revenue isn't recognized when you provide a service — it's recognized when you actually collect from a payer, which can be 30–120 days later and at a rate that varies by payer contract. A practice that generates $1 million in gross charges might collect $650,000 after write-offs and denials. Without a P&L that separates collections by payer and tracks your net collection rate, you can't tell whether a drop in income came from treating fewer patients or from a payer-specific billing problem.

The expense side is equally complex. Clinical labor — physician salaries, mid-level compensation, and medical assistant wages — typically runs 35–55% of collections in a well-run practice. Administrative and billing costs add another 15–25%, and that number creeps up when denial rates rise and your billing team has to work claims repeatedly. The template breaks costs into these categories specifically so you can see the full cost-per-RVU picture and compare it against industry benchmarks: most primary care practices target a physician compensation-to-revenue ratio of 35–45%, while high-acuity specialty practices can run higher.

The biggest financial risk for a medical practice isn't a bad month — it's a slow drift in metrics that goes unnoticed. Payer mix shifting toward Medicaid without a corresponding increase in volume. Net collection rate dropping two points because of a new denial code that billing hasn't caught. AR aging growing in the 90+ day bucket, signaling claims that are likely to be written off. This template is built to surface those trends monthly rather than quarterly, so you catch billing problems, staffing mismatches, and reimbursement issues while there's still time to act.