How to track insurance renewals and stop missing them
A simple system for a small independent agency to see every renewal coming, work each one on time, and know what happened to it.
A renewal is missed for one of three reasons: nobody saw it coming, somebody saw it and nobody owned it, or it was worked but nobody wrote down what happened. A tracking system has to fix all three. Here is one that works for an agency of one to fifteen people.
1. Keep one list of every policy, sorted by expiration date
Every policy the agency writes goes on one list, with at least:
- the client’s name, and a phone number and email address;
- the line of business and the carrier;
- the policy number;
- the effective date and the expiration date;
- the premium.
The expiration date is the one that matters most. A list sorted by it answers the only question that counts each morning: what is coming up next?
If the list lives in several places (a management system, a spreadsheet, a notebook), pick one as the source of truth for renewals and bring the rest into it.
2. Look 90 days ahead, in bands
Ninety days out is when a renewal needs its first look: time to review coverage, ask the client about changes, and shop the market if the premium is going up. Group what’s coming into bands:
- Past due: expired, and not yet marked renewed or lost. These come first.
- Within 30 days: act now.
- 31 to 60 days: start marketing, if it needs it.
- 61 to 90 days: first touch.
A renewal that’s past due and still open is the one that turns into a lapse.
3. Give every renewal a stage
A date tells you when; a stage tells you where it stands. Keep the stages few:
- Not started
- Contacted
- Quoting
- Renewed or won (the new term is in place)
- Lost (with the reason, and who took it if you know)
A renewal leaves the list only when it’s renewed or lost. Anything else stays in front of you.
4. Look at the list every morning
A list nobody opens doesn’t prevent anything. The simplest habit is one short email each morning with what’s past due and what expires in the next 30 days, with each client’s phone and email, so the day starts with the calls to make.
5. When a new term starts, roll the policy forward
Renewing a policy means recording the new term: new dates, new premium, and often a new policy number. Keep the old term as history, so you can see how the premium moved year to year.
6. Learn from the ones you lose
Record why each lost renewal was lost: price, coverage, service, or the client moved or closed. After a few months the reasons show a pattern. Flag the ones worth winning back, and look at them again about 90 days before their next anniversary.
Doing this in a spreadsheet, or in Renewal Book
All of this can live in a spreadsheet: sort by expiration date, add a stage column, and check it every morning. Our renewal spreadsheet guide has a layout and a blank template to start from.
Renewal Book does the same work for you. It imports the spreadsheet you already keep (CSV or Excel), groups every policy into past due, 30, 60 and 90 days, tracks each renewal’s stage, records renewals as new terms, keeps lost reasons and win-backs, and emails you the list each morning at the time you choose. Plans start free, and the paid plans start at $49 a month per agency.
More guides
- The insurance renewal spreadsheet, and a free templateThe columns an agency's renewal spreadsheet needs, how to lay it out so it stays useful, and a free blank template to download.
- How to track commissions at a small insurance agencyWork out what each carrier owes you, check what was actually paid, and catch the short payments, without an accounting system.
- How to measure and improve your agency's retention rateHow to calculate policy retention for a small independent agency, why it's the number that drives agency value, and what to do about the renewals you lose.
- A 90-day renewal checklist for independent agenciesWhat to do 90, 60 and 30 days before a policy renews, and on the day, so renewals are worked early and nothing lapses.