Healthcare P&L Template

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