A billing company spends every report watching its clients' revenue — and rarely watches its own. Fee revenue, retention, and concentration risk are the metrics that decide whether the firm is a durable business, but they're buried in collections data and fee-model variation across clients. This dashboard turns the firm's own book into a retention report: what's the recurring revenue, how concentrated is it, and which relationships are at risk.
What this dashboard answers
It answers the questions an owner should ask about the firm itself: how much fee revenue are we earning, are we retaining it month over month, how dependent are we on a few big clients, and which clients are showing churn signals? The revenue page shows total fee revenue, net revenue retention, active clients, at-risk clients, and average fee yield, with a fee-by-client bar and a concentration Pareto. The retention page details collections, fee, yield, tenure, and risk per client.
The metrics that matter
Net revenue retention is the durability headline — above 100% means the existing book is growing on its own. Top-client concentration is the risk headline: a firm earning most of its fees from a handful of clients is one departure away from a bad quarter. Average fee yield is the effective take rate across percent-of-collections, flat, and hybrid contracts. At-risk client count, broken out by reason — collections decline, late fee payment, contract renewal, dissatisfaction — turns a vague worry into a worklist.
Why the data is trapped across the systems
The firm's fee revenue is derived from each client's collections, which live in that client's PM system, while fee models and contract terms live in agreements and a billing spreadsheet. Tying collections to fee structure to tenure to compute retention and yield means joining data the systems were never designed to connect — which is why most firms know their gross fee total but not their net revenue retention or concentration.
How to read it
Read net revenue retention against 100% to see whether the book is expanding or quietly shrinking. The concentration Pareto shows how many clients it takes to reach the majority of fees — a steep curve is exposure to manage. Then work the at-risk matrix: the MoM-collections-change scatter highlights clients whose volume is sliding, the leading indicator of churn, broken down by reason so you act on the fixable ones. The sample uses entirely synthetic, anonymized data, so there is no real financial data.
Metrics it tracks
| Metric | What it means |
|---|---|
| Total Billing-Fee Revenue $ | The firm's own fee revenue (percent-of-collections plus flat) across all clients. |
| Net Revenue Retention % | This period's fee revenue ÷ prior period's — recurring-revenue retention. |
| Active Client Count | Distinct clients with billing activity this period. |
| At-Risk Client Count | Client-months flagged with a churn-risk signal. |
| Avg Fee Yield % | Fee revenue ÷ client collections — the firm's effective blended take rate. |
| Top-Client Concentration % | Share of fee revenue from the top 5 clients — revenue-concentration exposure. |
Used by: Billing-company owners and account managers
Frequently asked questions
What is net revenue retention for a billing company?
Net revenue retention is this period's recurring fee revenue from the existing client book divided by the prior period's. Above 100% means the book is expanding on its own through client growth; below 100% means churn or shrinking client collections are eroding the firm's revenue even before new sales.
Why does top-client concentration matter?
If a few large clients drive most of the firm's fee revenue, losing one creates an outsized hit. Top-client concentration — the share of fees from the top handful of clients — quantifies that exposure, so an owner knows whether the book is diversified or dangerously dependent on a small number of relationships.
What signals that a client is at risk of churning?
The leading indicators are declining monthly collections (less volume flowing through), late payment of the firm's own fee, an upcoming contract renewal, and service dissatisfaction. Flagging at-risk client-months by reason turns retention from a gut feel into a worklist of the relationships to shore up first.
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 →