In this guide
- A generic sales CRM isn't built for a portfolio of policies with renewals and commissions — so agents abandon it.
- The core of a useful CRM is a single client card holding all policies, contacts and communication history.
- The biggest value comes from alerts on renewals, unpaid instalments and clients who've gone quiet.
- The tool has to be usable in the field, on a phone, in under ten seconds.
- Rollout succeeds only when data is imported from existing spreadsheets and doesn't require manual re-entry.
Contents
Why a generic CRM fails in insurance
There are dozens of excellent CRM systems on the market. Almost all are built on the same logic: there's a sales funnel, opportunities move through it, and the goal is to close the deal. Once the deal is closed, the opportunity is closed and the team moves on to the next one.
For an insurance agent, closing a policy is just the beginning. The relationship that follows lasts for years: renewals, changes to sums insured, claims, instalment payments, new policies for family members. Revenue from a single client is spread across the whole term and depends on whether the policy stays in force.
In insurance, a client's value is measured in years, not a single signature. A CRM that doesn't reflect that gets used for three months and then abandoned.
Concrete shortcomings of generic tools
- No concept of a policy. A client record has no field for policy number, premium, payment method or renewal date.
- No renewal cycle. The system can't automatically generate a reminder thirty days before a policy expires.
- No link to commission. A sales CRM shows the value of a deal, but not how much commission was actually paid.
- Too many steps for a simple task. Logging a call needs to be possible in three taps on a phone, not six required fields.
- Per-user pricing. A sole agent pays the same as a corporate department while using a tenth of the features.
What this means in practice
An agent who tries a generic CRM ends up, in effect, with two systems: a CRM for contacts and a spreadsheet for policies and commissions. Data drifts apart, double entry becomes a burden, and after a few months the spreadsheet wins out. That's why the deciding question when choosing a tool isn't "how many features does it have" but "does it cover the whole cycle from contact to commission".
The core: a single client card
If you had to pick one single feature that separates a useful tool from a useless one, it would be the single client card — one screen holding everything you need to know about a client before a call or a visit.
What the card needs to hold
- Basic details: name, address, contact details, date of birth, tax ID where needed for the contract.
- Multiple addresses and multiple phone numbers, labelled by type (home, work, other). Clients often have three numbers and two addresses; a card with a single field forces improvisation.
- All of the client's policies: insurer, product, policy number, premium, payment method, start and end dates.
- Communication history: when you last spoke, about what, and what was agreed.
- Open tasks: what you still need to do for this client, and by when.
- Family and business links: spouse, children, company — natural sources of new policies.
Why this is a sales tool, not admin
An agent who sees, five seconds before a call, that a client has car insurance with one insurer, home insurance with another, and no accident cover at all, doesn't wing the conversation. They lead it with a concrete proposal.
Preparing for a call is the difference between "how are things" and "I noticed your car insurance expires on 12 October — I've put together a comparison for you".
What doesn't belong on the card
Space is limited, and every extra field lowers the odds it gets filled in. Avoid fields you won't actually use to make decisions: detailed demographic segments, "temperature" scores, or complex funnel-stage tags. In practice, three states are enough: active client, opportunity, inactive.
Renewals and alerts: where the money hides
The most profitable feature of a tool for agents isn't sales analytics — it's the renewal calendar. Every policy that lapses without contact is lost commission, and often a lost client.
Which alerts pay off in practice
- Policy renewal in 30 days. Enough time to prepare a quote and have the conversation before a competitor does.
- Unpaid premium instalment. Preventing a policy from lapsing for non-payment is the cheapest way to protect your portfolio.
- Client with no contact for over 12 months. A portfolio with no contact quietly erodes; one call a year changes that materially.
- Maturity of the insured term on life policies. An opportunity for a new product on payout.
- A change in life circumstances. A new baby, buying property, a new car — if it's recorded, it's a reason to make an offer.
How alerts should be presented
Not as a long list, but as a daily work sheet: what needs doing today and who to call. A list of three hundred upcoming renewals is information; a list of eight calls for today is work.
Measuring impact
Two figures are worth tracking:
- Renewal rate – the share of policies renewed at expiry. Even a rise from 85 to 90 percent on a portfolio of three hundred policies means fifteen policies retained a year.
- Share of clients contacted in the last year. This is the best indicator of a portfolio's health.
Usability in the field: the ten-second test
An agent spends most of their working day away from a desk. A tool that only works on a computer ends up used only half the time, and the data stays incomplete.
The test a tool has to pass
Sit in the car before a client visit, pick up your phone, and try to answer three questions in ten seconds: which policies does this client have, when did we last speak, and what did we agree? If that's not possible, the tool isn't fit for fieldwork.
What needs to work on a phone
- searching for a client by partial name or phone number,
- viewing policies and recent notes,
- logging a call or visit in a few taps,
- creating a task for the next step,
- viewing today's schedule.
What doesn't need to be on the phone
Detailed rule settings, data imports, extensive reports and exports. These belong on a computer, and there's no need to burden the tool with them on a small screen.
A rule that holds almost without exception: whatever can't be entered right after a visit will never be entered.
The link to commissions: what makes an industry tool different
This is where an industry-specific tool differs most from a generic one. An agent doesn't just need a client record — they need an answer to the question of whether their work has been paid for.
What a linked view means
When a policy portfolio and commission statements live in the same system, you get insights that separate tools can't offer:
- for every policy, you can see whether commission was paid, how much, and when,
- policies missing an expected payout surface on their own,
- a view of income by month, insurer and product is based on actual payouts,
- for each client, you can see their actual contribution to your revenue, which helps decide how much time to give them.
An example
An agent is preparing a visit to a client with five policies. The client card shows that commission on one policy was only paid in part, because the last instalment went unpaid. The conversation becomes not just a sales call but a service one: the agent flags the unpaid instalment to the client and prevents the policy from lapsing.
What this means for choosing a tool
If you're weighing two solutions and one can link policies to commissions while the other can't, the decision is straightforward — even if the first looks less modern. The value is in connecting the data, not in visual polish.
Data, privacy, and control over your own portfolio
A client database is an agent's business asset and, at the same time, a collection of personal data they're responsible for.
Three questions to ask any provider
- Where is the data stored, and is it within a jurisdiction with strong data protection standards, such as under GDPR.
- How do I get my data back if I cancel — export needs to be possible in a standard format, without special requests.
- Who at the provider has access to the content of my records.
The model that gives you the most control
There's an approach where the content of your business data never enters the provider's database at all. Client, policy and commission data stays in your own spreadsheets, and the application reads it on the fly and displays it in an organised view. Its own database holds only settings, calculation rules and metadata that you enter yourself.
The advantages are practical:
- data ownership is unambiguous — the file is yours,
- no export is ever needed, because the data never left your own space,
- switching to another tool, or going back to a spreadsheet, is always possible,
- the amount of data processed by a third-party processor is much smaller.
Commission Clarity takes this approach: the client list, policy portfolio and commission tracking run on top of your own spreadsheets, with calculations and analysis done on the fly.
Practical tips for compliance
- Collect only the data you need to write and manage a policy.
- Keep communication notes factual — notes on personal circumstances should be limited to what's actually relevant to the business relationship.
- Protect access to your devices with a password and two-factor authentication.
- When a relationship with a client ends, set a retention period and remove the data once it expires.
Two case studies: what changes after rollout
The examples below are illustrative. They describe a typical rollout, of the kind agents with a comparable portfolio size describe, and are not an account of a specific client.
Case 1: An agent with 300 policies and scattered notes
Starting point. Data lived in three spreadsheets, client notes in a notebook, and renewals in a phone calendar. Preparing for a visit took ten to fifteen minutes of searching every time.
What was introduced. A single client card with all policies, contact history and the next step. The spreadsheets stayed as the source of policy data, while the card became the entry point.
What changed. Prep time for visits dropped to a few minutes, since everything was on one screen. The first measurable effect wasn't higher sales — it was that the number of weekly visits increased, simply because the searching disappeared.
The point of this example: the biggest time saving from introducing a tool usually doesn't come from sales, but from eliminating the small, daily losses of time that repeat over and over.
Case 2: A broker who was losing renewals
Starting point. She tracked renewals by manually reviewing a spreadsheet once a month. During busy periods the review got skipped, meaning some policies lapsed without a call.
What was introduced. An automatic list of policies expiring in the next 30, 60 and 90 days, plus a logged outcome for every call. The key change wasn't the alert itself, but that the list appeared every time she logged in and didn't require anyone to remember to open it.
What changed. Renewal calls became a routine for the first working day of the week. Clients she hadn't contacted before became an opportunity to review their entire insurance portfolio, not just renew one policy.
The point of this example: a renewal system works when the alert reaches you without you having to look for it. Any alert that has to be sought out eventually gets missed.
How to roll it out so it actually sticks
Most rollouts fail not because of the tool, but because of how it's introduced. A staged approach is recommended.
Week one: import existing data
Don't start with manual entry. Take the spreadsheet you already keep, clean out duplicate records, and import it. A perfect import isn't the goal — the goal is to get the data into the system so you can start working with it.
Week two: just one habit
Introduce a single rule: every call and every visit gets logged the same day. Nothing else. Once that habit sticks, everything else builds itself, because the data stays fresh.
Week three: renewals
Turn on renewal alerts and start each day by reviewing the list. This is the moment the tool starts paying back the time invested.
First month: commissions
Set up the calculation rules for the insurers you work with, and compare expected commission against paid commission for the first time. This step usually convinces even those who were hesitant about tools.
What not to do
- Don't migrate ten years of archives you'll never use.
- Don't introduce five new habits at once.
- Don't keep running the old system in parallel for more than a month — double work kills any rollout.
The measure of a successful rollout isn't the number of records entered, but whether the client card is the first thing opened before every call. Once that becomes automatic, the tool has become part of the business.
Frequently asked questions
Does an insurance agent even need a CRM?
They need a record of clients and policies that flags renewals and overdue obligations. Whether it's called a CRM doesn't matter; what matters is that the data lives in one place and is accessible in the field.
What's the biggest difference between a generic and an industry-specific CRM?
A generic CRM tracks sales opportunities through to close. An insurance agent needs to manage the relationship after the sale: renewals, instalments, cancellations and commissions.
How long does rollout take?
If you already keep your data in a spreadsheet, rollout is a matter of a few hours. If you keep it on paper, plan for a few days of data entry and cleaning up duplicate records.
Try Commission Clarity on your own data
Client records, policy portfolio and commission control in one place. Your data stays in your own Google Sheets — Commission Clarity reads it live and highlights the discrepancies.



