Free download

Free insurance renewal tracker template

This free insurance renewal tracker template is an Excel sheet for agents, POSPs and agencies: one row per policy, a days-left countdown that updates every day, status dropdowns from "Not contacted" to "Renewed", and colour coding that turns overdue renewals red and upcoming ones amber.

What's in the template

  • Days left, automatically: enter the renewal date and the countdown updates each time you open the file.
  • Colour-coded urgency: red when overdue, amber at 15 days or fewer, yellow at 30 days or fewer, green once renewed.
  • Status dropdowns: Not contacted, Reminder sent, Quote shared, Renewed or Lost.
  • Next follow-up column: so every open renewal has a date for the next call.
  • Line of business and insurer columns: filter motor, health, life and other renewals separately.
  • A how-to sheet: a short guide to running a weekly renewal routine.

Get the template

Excel file (.xlsx), works in Google Sheets. We may follow up about PolicyIQ products related to renewal tracking; you can ask us to stop at any time. See the Privacy Policy.

A weekly renewal routine that works

  1. Monday: filter for renewals due in the next 30 days and set a next follow-up date for each.
  2. Every day: work through red and amber rows first, and update the status after each call or message.
  3. Before each renewal: check what has changed, such as IDV for motor or members for health, before sharing a quote.
  4. Friday: count renewed against lost, and note why customers left.

When a spreadsheet stops being enough

A tracker works while one person owns it and opens it every day. It starts to fail when the book grows, when several people share it, or when renewal dates have to be copied in by hand from every new policy. Renewal Reminders in PolicyIQ | Desk and Renewal Management in PolicyIQ | One take renewal dates straight from your policy records and remind you before each one is due.

Further reading

Frequently asked questions

Renewal tracker questions

Yes. Fill in the short form and the Excel file downloads straight away. You can use and adapt it freely.

Yes. Upload the Excel file to Google Drive and open it with Google Sheets; the days-left formula, status dropdowns and colour coding carry over.

Start about a month before the renewal date, so there is time to share a quote and follow up. For motor policies, the no claim bonus is lost if a policy is not renewed within 90 days of expiry.

When renewals are missed because nobody looked at the sheet that day, or when several people share one book of business. Software reminds you automatically from your policy records instead of relying on someone opening a file.

Stop tracking renewals by hand

Book a demo to see renewal reminders driven by your own policy records.

Book Your PolicyIQ Demo

Tell us about your business and we will call you to fix a time.

All fields required. Used only to arrange the demo; see the Privacy Policy. Prefer more detail? Use the full demo form.