Industry guides
Monthly financial reports for medical and dental practices
November 19, 2026 · 10 min read

Quick answer
A practice's monthly pack should fit on five or six pages: a P&L by location, a provider report (production, adjustments, collections), collections against net production with the net collection rate, AR aged by payer and bucket, an overhead ratio you define once and keep, and a cash page with days of cash on hand. Each number needs a formula you can repeat and a trend of at least six months, so you're reading direction, not a single month.
It's the 12th of the month and the bookkeeper has sent the statements. You open a 14-page P&L with 90 expense lines, a balance sheet, and nothing that tells you whether your second office is pulling its weight, whether one insurer has quietly stopped paying on time, or whether the dentist you hired in the spring is collecting what she produces.
The fix isn't more reports. It's a short, fixed pack with the same pages in the same order every month, each built on a formula you can check.
We've covered how practice books should be set up (contractual adjustments, payer matching, HIPAA) in bookkeeping for medical and dental practices. This post is about the next step: what the monthly reports should show, how each number is calculated, and how to read them, with a worked example.
What belongs in a practice's monthly report pack?
Here's the pack we'd suggest, in the order you'd read it:
1. Summary page
- Net patient revenue, location margin and cash, this month and last six
- Three or four sentences on what changed and why
2. P&L by location
- One column per location plus a total
- Shared admin allocated on a stated basis
- Overhead ratio for each location
3. Provider report
- Gross production, contractual adjustments and net production per provider
- Collections attributed to each provider
- Ties to the practice totals
4. Collections
- Net production vs collections, month by month
- Net collection rate on a rolling three-month basis
5. Accounts receivable
- AR by payer in 0–30, 31–60, 61–90 and over-90 buckets
- AR days, practice-wide
- Credit balances that may need refunds
6. Cash
- Bank balances by account
- Days of cash on hand
- Big payments due in the next 30 days
Which formulas should the reports use?
"Collection rate" means different things to different people. Write the formulas down once, put them at the back of the pack, and don't change them without saying so.
| Metric | Formula | What it tells you |
|---|---|---|
| Net production | Gross production − contractual adjustments | What you're entitled to bill under your payer contracts |
| Gross collection rate | Collections ÷ gross production | Mostly your fee schedule vs your contracts. Not a performance measure |
| Net collection rate | Collections ÷ net production | How much of what you're owed actually arrives |
| AR days | Total AR ÷ (net production for the last 3 months ÷ days in those months) | How long, on average, billed money takes to come in |
| Over-90 share | AR over 90 days ÷ total AR | How much of your AR is getting stale |
| Overhead ratio | Operating costs excluding provider pay ÷ net patient revenue | How much of each revenue dollar the practice costs to run before paying providers |
| Days cash on hand | Cash ÷ (monthly cash operating costs ÷ 30) | How long you could run with no money coming in |
The gross and net collection rate definitions follow the way MGMA data has long been reported, as described by Physicians Practice: gross is collections divided by charges, while the adjusted (net) rate divides collections by charges after contractual adjustments. The net rate is the one to watch. A gross rate of 72% might be perfectly healthy if your PPO write-offs are large; a net rate of 90% means a tenth of what you're owed isn't showing up.
A note on timing: collections in a month pay for visits from earlier months, so a single month's net collection rate jumps around. Use a rolling three months (or twelve, if your volume is seasonal) and compare the trend.
A worked example: one month for a two-office dental practice
Say you own a general dental practice with two offices, three dentists and a hygiene team. Here's September, all numbers hypothetical.
Production and collections. Gross production was $300,000. PPO and government plan write-offs (contractual adjustments) were $72,000, so net production was $228,000. Collections were $216,600. That's a gross collection rate of 72.2% and a one-month net collection rate of 95.0%.
The single month looks fine. The trend doesn't:
Net production vs collections
Hypothetical two-office dental practice, April to September
- Net production
- Collections
Hypothetical example. Rolling net collection rate: April to June $629,000 ÷ $647,000 = 97.2%; July to September $627,600 ÷ $670,000 = 93.7%.
Show the numbers
| Net production | Collections | |
|---|---|---|
| Apr | $215,000 | $208,000 |
| May | $222,000 | $214,000 |
| Jun | $210,000 | $207,000 |
| Jul | $218,000 | $205,000 |
| Aug | $224,000 | $206,000 |
| Sep | $228,000 | $216,600 |
From April to June, collections of $629,000 against net production of $647,000 give a rolling rate of 97.2%. From July to September it's $627,600 against $670,000: 93.7%. Three and a half points on $670,000 of net production is roughly $23,000 that should have arrived and didn't. September's good month hides it unless you look at the rolling number.
Where's the gap? The provider report and the AR page answer that.
| Provider | Gross production | Contractual adj. | Net production | Collections | Net collection rate |
|---|---|---|---|---|---|
| Dentist 1 (Office A) | $118,000 | $26,000 | $92,000 | $89,240 | 97.0% |
| Dentist 2 (Office A) | $62,000 | $16,000 | $46,000 | $41,860 | 91.0% |
| Dentist 3 (Office B) | $78,000 | $20,000 | $58,000 | $54,520 | 94.0% |
| Hygiene (both offices) | $42,000 | $10,000 | $32,000 | $30,980 | 96.8% |
| Total | $300,000 | $72,000 | $228,000 | $216,600 | 95.0% |
Dentist 2 joined in the spring. A 91% rate for one month could be timing, but if it holds for three, look at whether her treatment plans are going to a payer with a lot of denials, or whether patient portions aren't being collected at checkout. (How her pay is calculated and accrued is its own subject: see recording provider compensation.)
How should you read AR by payer and bucket?
The practice-wide AR days number is a starting point. At the end of September, AR was $260,000. Net production for July to September was $670,000, or about $7,444 a day over 90 days, so AR days are about 35.
Thirty-five days doesn't tell you where the problem sits. The aging by payer does:
| Payer | 0–30 days | 31–60 days | 61–90 days | Over 90 days | Total |
|---|---|---|---|---|---|
| PPO plan A | $52,000 | $14,000 | $4,000 | $3,000 | $73,000 |
| PPO plan B | $38,000 | $22,000 | $12,000 | $9,000 | $81,000 |
| Government plan | $20,000 | $6,000 | $2,000 | $2,000 | $30,000 |
| Patient balances | $30,000 | $18,000 | $12,000 | $16,000 | $76,000 |
| Total | $140,000 | $60,000 | $30,000 | $30,000 | $260,000 |
AR older than 60 days, by payer
Same hypothetical practice, end of September
Hypothetical example. 61–90 plus over-90 buckets from the aging table: $60,000 in total.
Show the numbers
| Patient balances | $28,000 |
| PPO plan B | $21,000 |
| PPO plan A | $7,000 |
| Government plan | $4,000 |
Two things jump out. PPO plan B has $21,000 (about 26% of its balance) older than 60 days, compared with under 10% for plan A. That's a call to the billing team: denials, missing attachments, or claims sitting unworked. And patient balances have $16,000 over 90 days, which is 53% of all over-90 AR. That usually points to checkout, not to collections letters: estimates given before treatment, and payment taken at the visit.
The over-90 share for the practice is $30,000 ÷ $260,000, or 11.5%. Track it monthly. Its direction matters more than its level.
The AR in the books should tie to the aging report from your practice management system every month. If it doesn't, one of the two is wrong, and none of these ratios mean much until it's fixed.
What should a P&L by location show?
One column per office, a total, and shared costs split on a basis you state (here, roughly in line with revenue). Revenue is net patient revenue: net production of $228,000 less $3,000 of patient balances the practice doesn't expect to collect, or $225,000.
| Office A | Office B | Total | |
|---|---|---|---|
| Net patient revenue | $154,000 | $71,000 | $225,000 |
| Provider compensation | $56,000 | $28,000 | $84,000 |
| Staff wages | $24,000 | $15,000 | $39,000 |
| Rent | $10,000 | $8,000 | $18,000 |
| Dental supplies and lab | $18,000 | $9,000 | $27,000 |
| Other operating costs | $8,000 | $4,000 | $12,000 |
| Shared admin (allocated) | $10,000 | $5,000 | $15,000 |
| Location margin | $28,000 | $2,000 | $30,000 |
| Overhead ratio | 45.5% | 57.7% | 49.3% |
Overhead ratio here is operating costs excluding provider pay, divided by net patient revenue. For Office B: staff $15,000 + rent $8,000 + supplies $9,000 + other $4,000 + admin $5,000 = $41,000, divided by $71,000, is 57.7%.
Office B makes $2,000 of the practice's $30,000. That may be fine if it opened last year and is still filling its schedule. Overhead definitions differ across surveys (some include the owner's clinical pay, some divide by collections), so pick one, label it, and compare yourself against your own trend rather than a number from a forum.
What goes on the cash page?
Cash is the page owners skip and shouldn't. At the end of September the practice had $180,000 in the bank. Cash operating costs were about $195,000 for the month (total costs on the P&L, $225,000 less the $30,000 margin, with no big non-cash items), or $6,500 a day. Days of cash on hand: $180,000 ÷ $6,500, about 28 days.
With PPO plan B slowing down, 28 days is a reason to chase those claims this week, not next quarter. If you want to go further, a rolling cash flow forecast turns this page into a look ahead.
Common mistakes
Reporting deposits as revenue. If the P&L shows cash received as revenue, every ratio above is distorted by insurer timing. Record charges and contractual adjustments first.
Using gross collection rate as a scorecard. It mostly reflects your fee schedule. Raise your fees and it drops, even if nothing about collections changed.
Changing the formula quietly. Last quarter's overhead ratio included the owner's pay; this quarter's doesn't. Now the trend is meaningless.
Card fees netted out of collections. Processor deposits arrive net of fees. If only the deposit is recorded, collections look lower than they were. Recording merchant fees and patient financing covers the fix.
When should you get help?
If you run one office with salaried providers and a billing company that already sends payer aging, you can build most of this pack from your practice management system and your accounting software in an afternoon a month.
It gets harder with a second location, provider pay tied to production or collections, or AR in the books that never quite agrees with the billing system. That's where an outside team earns its fee. At Fintrix Consulting we keep a separate P&L for every location and produce provider compensation reports you can check line by line; here's how we work with healthcare practices. Whoever does it, ask for summary reports from the billing system rather than patient-level detail: an outside accountant who receives protected health information from a practice is a business associate under the HIPAA rules, which brings a written agreement.
Frequently asked questions
What's the difference between production and collections?
Production is what you billed at your fee schedule for the work done. Collections are the money that actually came in during the month, from insurers and patients, usually for work done in earlier months. Net production (production minus contractual adjustments) sits in between and is what you're entitled to under your payer contracts.
What's a good net collection rate?
It depends on your payer mix and specialty, and benchmarks from surveys aren't always defined the same way. The more useful test is your own rolling three-month trend: a drop of two or three points that holds is worth investigating, whatever the absolute level.
Should the reports be cash or accrual?
Use accrual for the management pack, because net production and net patient revenue show what each month earned. Many practices file taxes on the cash basis, which your CPA decides. The collections page gives you the cash view alongside.
How often should I look at AR by payer?
Monthly in the report pack, with a quick weekly look in a busy practice. A payer that starts aging past 60 days is easier to fix in the first month than the fourth.
The bottom line
A good monthly pack for a practice is short and repeatable: a P&L by location, a provider report that ties to the totals, collections against net production on a rolling basis, AR by payer and bucket, an overhead ratio defined once, and a cash page. Write the formulas down and keep them. Read six-month trends, not single months. Done that way, a slipping payer or a struggling office shows up in the pack weeks before it shows up in the bank balance.
Sources
This article is general information, not advice for your situation. Rules change and details matter, so talk to us or your CPA before acting on it.
More articles
- Chart of accounts for agencies and consultancies
November 19, 2026
- Getting your books ready for Form 990
November 19, 2026
- Merchant fees, patient financing and HSA payments in your books
November 19, 2026
Have a question about this article?
Ask us. A real person will reply by email within one business day. Your question isn’t published.
Ready for books you can trust?
Book a free 30-minute consultation. We'll review where your finances stand today and show you exactly how we'd help.