Renewal Book

Guides

The insurance renewal spreadsheet, and a free template

The columns an agency's renewal spreadsheet needs, how to lay it out so it stays useful, and a free blank template to download.

Most small agencies start tracking renewals in a spreadsheet, and a good one goes a long way. The difference between a spreadsheet that helps and one that gets ignored is mostly in the layout.

The columns that matter

One row per policy, with these columns:

Column Why
Client name Who to call. For a business, the business name.
Contact name, phone, email The person you actually reach.
Line of business Home, Auto, Business Owner Package, and so on.
Carrier For commission, and for knowing who to shop.
Policy number So the renewal matches the right policy.
Effective date When the current term started.
Expiration date The column you sort by.
Premium The premium for the current term.
Commission rate So you can see what you’re owed.
Stage Not started, contacted, quoting, renewed, lost.
Notes What was said, and when.

Rules that keep it working

  • One row per policy, not per client. A household with a home and two autos is three rows. The client’s name repeats; that’s fine.
  • Dates as dates. Enter expiration dates in one format (for example 03/14/2027) and make sure the column is a date column, so sorting works.
  • Sort by expiration date, soonest first, every time you open it.
  • Never delete a lost policy. Set its stage to lost and write the reason. The history is what tells you why clients leave.
  • When a policy renews, update the dates and the premium, and move the old ones to the notes if you want the history.

Where spreadsheets stop working

A spreadsheet doesn’t remind anyone of anything. It depends on someone opening it, sorting it and reading down the list, every day. As the book grows past a few hundred policies, or more than one person works it, rows get missed, dates get typed three different ways, and two people call the same client.

Download the template

The blank template has the columns above except the stage (a new list starts with every renewal not started), plus the client’s address, the segment (personal or commercial) and the term length in months, with one example row:

Download the renewal spreadsheet template (CSV)

It opens in Excel or Google Sheets.

From spreadsheet to morning email

When the spreadsheet stops being enough, Renewal Book imports it as it is. You match your columns to ours, see a preview of exactly what will be created, and import. The template above imports with no matching at all. After that, every policy is grouped by how soon it renews, and an email each morning lists what’s past due and what renews in the next 30 days. There’s a free plan for up to 150 policies.

Start free, no card

More guides