Skip to content
Insurance Policy Tracker cover: a sample sheet with active policies, annual premiums and monthly cost and a bar chart, beside the Dashboard and Policies tabs

Insurance Policy Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

This tracker suits households and small business owners who hold several policies for cars, a home, renters cover, health, life or an umbrella liability. The Policies tab lists each policy with its insurer, annual premium, monthly equivalent, deductible, renewal date and status. Days to renewal counts down automatically, and active rows turn red within 45 days of renewal.

The Claims tab logs what happened, the sum requested, the sum paid out and whether the claim is open, settled or denied. The Dashboard totals your active premiums and monthly cost, counts open claims and compares premiums with claims paid by policy type in a bar chart. Sample rows show how a full year looks, so overwrite them with the policies you actually hold.

Useful for

  • Spotting renewals 45 days before they fall due
  • Totaling the yearly cost of all household cover
  • Following a claim from filing to payment

What's included

  • 4 tabs: Dashboard, Policies, Claims, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Policies: a table
  • Claims: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Policies tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I know which policies are worth renewing?

Compare the annual premium with the claims paid and the deductible on each row. A policy that costs more than it has paid out is not always a bad deal, since cover protects against large losses. Get fresh quotes before each renewal date and note the result in the Notes column.

Can I track claims for more than one insurer?

Yes. Give each policy a name and insurer, then pick its type when you log a claim. The Dashboard groups premiums and paid claims by type, so one view covers every insurer you use.

Does the sheet calculate what my insurer will pay?

No. The Paid out column holds the figure your insurer confirms. Deductibles, limits and exclusions come from your policy document, so check those before you file.

  • #bill-tracker
  • #insurance-policy-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More bill tracker templates

See all 8

Also in Finance

All finance templates
Get this template

Preparing your template…