Renewal Book

Guides

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.

Start free, no card

More guides