Net collection rate is the number a billing company is hired to move and reports back to every client — the benchmark sits above 95-96%, and the gap between that and what you actually collect is leaked revenue. But payments, allowed amounts, and contractual adjustments post into each client's own PM system, so the firm has no consolidated collection-rate view of its book. This dashboard rolls remittance data up across clients and payers into the collections picture account managers present every month.
What this dashboard answers
It answers the core RCM question: of the money we could collect, how much did we? The overview shows net collection rate (payments over allowed) and gross collection rate (payments over billed), total payments, allowed, and write-offs, with net collection rate cut by payer and by PM system. A charges-to-cash bar walks billed dollars through contractual adjustment, payments, and write-off so the whole flow is visible at a glance.
The metrics that matter
Net collection rate is the headline because it measures performance against what's actually collectible — gross collection rate moves with the fee schedule and overstates problems for high-charge specialties. The gap between allowed and payments is your real leakage. Watching net collection rate by payer exposes the payers that consistently underpay or short-pay, and by client shows which practices need attention before the monthly review.
Why the data is trapped across the systems
Remits post into each client's instance of athenahealth, AdvancedMD, Tebra/Kareo, eClinicalWorks or DrChrono — and electronic remits route through clearinghouses like Waystar before posting. Net collection rate requires both the payment and the allowed amount from the remit, joined across every client. No single login holds the whole book, so the monthly collections deck is assembled by exporting each client and re-keying the totals.
How to read it
Lead with net collection rate against the 95%+ benchmark, then read it by payer to find the underpayers and by client to find the practices to coach. The 100% stacked payer-mix bar per client shows revenue concentration — a client leaning hard on one slow payer is an exposure. The charges-to-cash bar makes write-offs visible as a share of allowed, separating contractual adjustments (expected) from bad-debt write-offs (avoidable). The sample uses entirely synthetic data, so there is no PHI.
Metrics it tracks
| Metric | What it means |
|---|---|
| Net Collection Rate | Payments ÷ allowed amount — the share of collectible revenue actually collected; the truest RCM health measure. |
| Gross Collection Rate | Payments ÷ billed charges — payments as a share of gross charges (depends heavily on fee schedule). |
| Total Payments Collected $ | Sum of payments collected across all clients and payers. |
| Total Allowed Amount $ | Contractually allowed dollars, net of contractual write-offs. |
| Write-Off / Adjustment $ | Contractual adjustments plus bad-debt write-offs. |
| Paid Claim Count | Count of paid/adjudicated claim rows contributing to collections. |
Used by: Billing-company owners and account managers
Frequently asked questions
What is a good net collection rate for a billing company?
The widely used benchmark is above 95-96%. Net collection rate is payments divided by the contractually allowed amount, so it measures how much of the genuinely collectible revenue actually landed — a far better health signal than gross collection rate, which moves with the fee schedule and varies by specialty.
Why use net collection rate instead of gross?
Gross collection rate (payments over billed charges) depends on how aggressively a practice sets its charges, so it looks 'low' for high-charge specialties even when collections are fine. Net collection rate removes contractual write-offs and measures against what the payer agreed to pay — making it comparable across clients and payers.
Can I build this across all my clients' remittance data?
Yes. You export remits from each client's PM system (and clearinghouse), and the template rolls them into one book-wide collections view with payer, client, and PM-system slicers. The sample uses synthetic data so you can see the consolidated layout before bringing your own.
Build this report on your own data
Clone this RCM / billing companies template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →