CRM for Book of Business Tracking
A book of business is the total portfolio of policies an agency manages: every client, every policy, every carrier, every premium dollar. It is the agency’s primary asset. Tracking the book means knowing total premium by line of business, retention rate, growth rate, average revenue per client, carrier concentration, and producer performance. When a producer leaves, their book goes with them unless it is documented in the system. When a carrier exits a market, the agency needs to know how much premium is affected and which clients need to be moved. Most CRMs track sales pipeline and deal revenue. Book of business tracking requires a policy-level view of the agency’s in-force portfolio that aggregates up to client, producer, carrier, and line of business dimensions. When your agency manages $15 million in premium across 3,000 policies and needs to know the retention rate by producer, the carrier concentration risk, and the revenue impact if your largest carrier pulls out of a line, a deal pipeline does not answer those questions.
What to look for in a CRM for book of business tracking
Policy-level data model
The book is built from policies, not deals. Each policy has a client, a carrier, a line of business, a premium, an effective date, and an expiration date. The system must store and report at the policy level. Aggregating to client or producer level is a view on top of policy data.
In-force portfolio visibility
The system must show the current in-force book: total premium, policy count, client count, and average premium per policy. Filters by producer, carrier, line of business, and client size must be available without running a custom report.
Retention rate tracking
Retention rate is the percentage of premium or policies that renew. The system must calculate retention by producer, by line of business, and by carrier. A producer with a 90% retention rate is performing differently from one with a 75% rate. The difference in revenue impact is significant.
Carrier concentration analysis
If 40% of the agency’s premium is with one carrier and that carrier tightens underwriting or exits a market, the agency faces a major disruption. The system must show premium concentration by carrier so the agency can manage concentration risk proactively.
Producer performance tracking
Each producer is responsible for a segment of the book. The system must show each producer’s book size, growth rate, retention rate, new business written, and revenue generated. This data drives compensation decisions and identifies producers who need support.
Growth and attrition analysis
The system must show how the book is changing: new business added, policies lost, premium increases, premium decreases. Net growth by month and by quarter shows whether the agency is growing or shrinking and where the changes are happening.
How the tools compare
| Tool | Price | How it handles book tracking | Where it falls short |
|---|---|---|---|
| Salesforce Financial Services Cloud | $300/user/month | Custom objects for policies and producers. Reports and dashboards for portfolio analytics. Financial Services Cloud adds relationship mapping and household views. | No native book of business structure. Building policy-level tracking with in-force views, retention calculation, carrier concentration, and producer performance requires significant custom development. The analytics require custom report types and formulas. |
| HubSpot CRM | Free to $75/user/month | Deal records can track revenue per client. Reports show revenue by owner and pipeline stage. | HubSpot reports on deals (sales events), not policies (ongoing coverage). There is no concept of in-force premium, policy expiration, carrier assignment, or retention rate. The book of business is invisible in HubSpot because the data model does not support it. |
| Zoho CRM | $13–55/user/month | Custom modules can model policies. Zoho Analytics can build portfolio dashboards. Custom fields for carrier, premium, and dates. | Building book of business analytics in Zoho requires custom modules for policies, custom analytics dashboards for retention and concentration, and formula fields for growth calculations. The platform supports it but the insurance-specific structure is entirely custom. |
Book of business tracking requires policy-level data that agency management systems maintain natively. AMS platforms (Applied Epic, Vertafore AMS360) track the in-force book as part of their core function but are operational and accounting systems, not CRM platforms. General CRMs track deal revenue but have no policy concept, so the in-force portfolio, retention rates, and carrier concentration are invisible. Most agencies report on their book by exporting policy data from the AMS into a spreadsheet, which means the analysis is periodic, manual, and disconnected from the client relationship data in the CRM.
What about agency management systems?
| Tool | Price | How it handles book tracking | Where it falls short |
|---|---|---|---|
| Vertafore AMS360 | Pricing not public | Full agency management with policy data, premium tracking, commission management, and producer reporting. Book of business views are native to the platform. | Strong on operational book management and accounting. Limited CRM and sales capability. Producer performance on new business development and pipeline is secondary to policy administration. |
| AgencyZoom (now Vertafore) | Pricing not public | Insurance-specific CRM with pipeline management, policy tracking, and producer performance reporting. Integrates with agency management systems. | Now part of Vertafore. Focused on sales pipeline and producer activity tracking. Book of business analytics (carrier concentration, retention by line) may require the AMS data rather than CRM data alone. |
What Edgevance builds for book of business tracking
Edgevance builds CRM platforms where the book of business is a live view of the in-force portfolio connected to client relationships. Every policy is tracked with carrier, premium, line of business, effective and expiration dates, and assigned producer. The in-force view shows total premium, policy count, and average revenue with filters by any dimension.
Retention rate calculates automatically as policies renew or are lost. Producer performance dashboards show each producer’s book size, growth trajectory, retention rate, and new business contribution. Carrier concentration analysis shows premium distribution and flags concentration risk before it becomes a crisis.
Growth and attrition analysis shows the book’s trajectory: new business added, policies lost, premium changes, and net growth by period. When the agency’s book grows 8% but one producer’s book shrinks 12%, the data surfaces the issue. When a carrier announces market restrictions, the system shows exactly how much premium is affected and which clients need attention.
Frequently asked questions
The book represents the recurring revenue stream. Each policy that renews generates commission income without new sales effort. An agency with $15 million in premium and 85% retention renews $12.75 million annually before writing a single new policy. The book’s value in an agency acquisition is directly tied to its size, retention rate, and diversification. An agency that cannot demonstrate these metrics with data sells for less.
Industry benchmarks vary by line. Commercial lines typically target 85 to 92% retention. Personal lines target 80 to 88%. Below these thresholds, the agency is losing more business than it should to competitors or market conditions. Above these thresholds, the agency’s service and relationship management are keeping clients. Tracking retention by producer, line, and carrier identifies where losses are concentrated and where the agency’s service model is working.
If a significant share of the book is placed with one carrier and that carrier raises rates, tightens underwriting, or exits a line of business, the agency must remarket a large volume of policies simultaneously. This creates workload spikes, client disruption, and the risk of client loss during the transition. Agencies that monitor carrier concentration and proactively diversify placement across carriers reduce this operational and revenue risk.
Your book.
Your asset.
Edgevance builds CRM platforms that give you live visibility into your in-force portfolio so retention, growth, and concentration are managed, not discovered.
Book a Call20 minutes · Google Meet · Free, no obligation