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.
More guides
- How to track insurance renewals and stop missing themA simple system for a small independent agency to see every renewal coming, work each one on time, and know what happened to it.
- 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.