Reporting for Insurance: Renewal Runway, Issued Policy Conversion and the Gaps in Your Book

Most agencies spend the majority of their sales energy on new business and the majority of their income on renewals of policies written years ago. That mismatch is where insurance reporting should start. The reports below are ordered by how directly they protect existing premium before they help you add more.

Renewal runway

Every policy by renewal date, premium, adviser and last contact, starting weeks ahead of the renewal month. It decides the weekly call list. A bad number is a cluster of renewals inside thirty days with no recorded contact. The action is to assign them in batches and record outcomes, because a renewal worked early is a conversation and one worked late is a negotiation.

Quote to issued policy by product

Conversion split by product and adviser, broken at each stage: quote, proposal, underwriting decision, payment. It decides where support goes. A bad number is a stage where volume disappears. Cases stalling at underwriting usually mean documentation, while cases approved and unpaid mean somebody needs to pick up the phone today.

First year persistency

Policies still in force after twelve months, per adviser and product. It decides coaching and product focus. A bad number is one product lapsing consistently for one adviser. The action is to review what was promised at the point of sale, because persistency problems are usually expectation problems rather than client circumstances.

Lapse and decline reasons

A closed list separating affordability, competing quote, claim dissatisfaction and non contact. It decides retention effort. A bad number is non contact appearing frequently, which is the most recoverable category and the one most agencies never measure. The action is a call, not a mailer.

Cross sell coverage

Clients holding one product only, ordered by premium and tenure, with owner. It decides who gets contacted when the diary has a gap. A bad number is a large single product base nobody has ever worked. The action is a small weekly quota per adviser with the outcome recorded, so the list shrinks rather than being admired.

It uses data you already hold, requires no behaviour change, and it protects income you have already earned. Everything else on this page competes for second place. Quote to issued conversion is the natural follow up because it needs stage discipline to be worth reading, and persistency comes later still since it needs twelve months of clean records before it says anything reliable about anyone.

These reports are ordered by how quickly acting on them changes the money. Retention first, then conversion, then the structural questions about what is being sold.

Product tagged on every enquiry and policy. Accurate renewal dates, maintained rather than imported once. One adviser owning each client relationship. A fixed source list. Lapse and decline reasons from a closed list. Households merged so a client holding motor and health is one relationship rather than two records that no cross sell report can ever join together.

Merging is the step that decides whether cross sell reporting exists at all. If every policy creates a separate record, the agency cannot see that a client already trusts it with three products or that another holds only one. The book looks larger and understands less, and the cheapest new business available to the agency stays invisible.

Adviser leaderboards ranked on issued premium alone are the clearest example. They celebrate a strong month regardless of whether the business survives to month twelve, and any agency that ranks on them will steadily accumulate policies that lapse. Monthly premium totals with no forward view and cumulative policy count charts are less harmful, but equally unlikely to change what anybody does tomorrow.

HelloGrowthCRM holds clients, policies, renewal dates and conversations in one record so the runway, conversion and cross sell lists come out of everyday work instead of a monthly export exercise. It is ₹899/user/month in India, and a free plan is available while a small agency tests which of these reports it will act on each week.

More reading: CRM features, CRM with built-in dialer, WhatsApp CRM, lead management software, sales automation, and India pricing.