Insurance Policy Register Template for Excel

What an insurance policy register is

An insurance policy register is the single authoritative list of every policy an organization holds — insurer, coverage, limits, effective and expiration dates, the parties insured under each, and the certificates issued against them. A lender asks for proof of coverage three days before closing, and the answer must come from a current record, not a broker’s inbox. This insurance policy register template for Excel keeps that record ready before the request arrives.

Most insurance policy tracking spreadsheets on the market are flat lists built for a single policy, not a multi-entity portfolio. A register records what a flat list skips: who’s insured under each policy, what each endorsement changed, and every certificate issued. That structure is what turns a spreadsheet into a system of record.

This register tracks the organization’s own policies and the certificates it issues — not claims, not premium calculations, not coverage owed under someone else’s contract. It’s the place every policy fact lives, kept current enough to answer a request instead of reconstructing one under deadline. The next request, whether from a lender, a landlord, or an auditor, gets a lookup instead of a scramble.

What’s inside the Excel workbook

This insurance policy register template ships as one Excel workbook, seven sheets deep. A Start Here tab leads, followed by six data sheets covering policies, insureds, endorsements, periods, certificates, and coverage lines. Together they hold 76 tracked fields, organized behind 11 pre-built dropdown lists, and the workbook opens in Google Sheets as well as Excel.

• Start Here — column conventions and the habit of adding a row instead of overwriting one
• Insurance Policies — 20 fields
• Policy Insureds — 9 fields
• Policy Endorsements — 10 fields
• Policy Periods — 14 fields
• Certificates Issued — 16 fields
• Certificate Coverage Lines — 7 fields

Policies and insured parties

Insurance Policies — 20 fields — carries insurer, broker, policy number, policy type, and coverage description. It also holds premium frequency, renewal type, retroactive date, coverage territory, and current limits: per-occurrence, aggregate, deductible, retention, and premium. Our role marks whether the organization sits as Named Insured, Additional Insured, or Loss Payee on that policy.

Policy type covers General Liability, Professional Liability, Directors & Officers (D&O), Cyber Liability, Property, Auto, Workers Compensation, Umbrella, Crime/Fidelity, EPLI, Fiduciary, Marine, and Aviation. A dropdown list keeps every entry standardized instead of free text.

Policy Insureds — 9 fields — is where most policy trackers stop short. Every party insured under a policy gets its own dated row, complete with an insured role, effective date, and termination date. An additional insured added mid-term is a dated row, not a note scribbled next to the policy number.

Endorsements and renewal history

Policy Endorsements — 10 fields — tracks real modification types: Additional Insured, Waiver of Subrogation, Primary/Non-Contributory, and Coverage Extension or Exclusion. It also covers Limit Change, Deductible Change, Territory Change, Named Insured Change, and Other, each with its own premium impact.

Policy Periods — 14 fields — is renewal history, not a single set of numbers overwritten every year. Each period is its own row — effective and expiration dates, per-occurrence and aggregate limits, deductible, retention, and premium. A terms-changed flag means last year’s limits survive this year’s renewal.

Renewal type marks each period as a New Policy, a Renewal, or a Reinstatement. A lapse and a clean renewal never look the same in the record.

Certificates issued log

Certificates Issued — 16 fields — is a certificate of insurance issuance log template: issuer, certificate type, recipient name and role, issue date, and certificate number. Effective and expiration dates, special provisions, and request provenance — source, reference, requested by, and request date — round out the record, along with who issued it.

Request source runs Contract, Lease, Loan Agreement, Customer Request, Vendor Qualification, Ad Hoc, and Other. Every certificate shows why someone requested it.

Certificate Coverage Lines — 7 fields — connects every certificate to the policy that backs it. A certificate never floats free of the coverage it represents. Coverage line type — GL, Professional, WC, Auto, Umbrella, Property, Cyber, or Other — records exactly which coverage the certificate speaks to, line by line.

How to use the template

A landlord’s certificate request lands three days before a lease closes, and the fastest path to an answer runs through a register that’s already current. Digging through broker emails at that point costs a day the closing schedule doesn’t have. Building a register from these six sheets follows a short, repeatable sequence.

1. Log one row per policy in Insurance Policies. Insurer, policy type, current limits, and renewal type go on every row before anything else.
2. Add every insured party on its own row in Policy Insureds. Record insured role and the date it took effect.
3. Record endorsements as they’re bound, not after. Give each one its own row, with endorsement type and premium impact.
4. Log each renewal as a new row in Policy Periods. Never overwrite last year’s limits — add a period instead.
5. Log every certificate issued in Certificates Issued. Recipient, request source, and issue date go on every row, tied back through Certificate Coverage Lines.

For example, a holding company’s General Liability policy names a subsidiary as an additional insured. That gets a dated Policy Insureds row and an Additional Insured entry in Policy Endorsements, both keyed to the same policy.

When the subsidiary’s landlord asks for proof of coverage under its lease, Certificates Issued logs the certificate with request source “Lease.” A Certificate Coverage Lines row then ties that certificate back to the same GL policy.

One row per record

Insurance Policies rows should map one-to-one with policies. Insureds, endorsements, periods, and certificates each key back to that policy on their own sheet. Flattening an insured party or an endorsement into a notes column loses exactly the detail a register exists to keep.

Tracking renewals and expirations

Sort Insurance Policies by current expiration date, and read the renewal type alongside it. Log a renewed term as a new Policy Periods row instead of editing the current one, so prior limits stay on record. This insurance policy log template for Excel holds raw dates only — nothing here fires a reminder on its own.

Built for multiple entities

Primary Insured and our role sit on every row in Insurance Policies, not just the policy number. A holding company insuring ten subsidiaries under one master policy must know which entity carries which coverage, not that a policy exists somewhere. A single flat list can’t answer that; a register with an entity field on every row can.

Coverage territory and issuing entity are both structured fields, so the portfolio sorts by jurisdiction and entity when a due diligence request arrives. A cross-border group answers “which entity carries GL coverage in which state” with a filter, not a call to the broker. That same filter separates a subsidiary’s certificates from the parent’s during an acquisition review.

Risk managers, controllers, corporate counsel, and operations managers at multi-entity organizations feel this gap first. A spreadsheet built for one company has to answer for ten, often while a certificate request names one specific subsidiary. A register with entity and role on every row is ready for that question before anyone asks.

When a spreadsheet stops working

This register covers a long list of policies before it runs into real edges. There’s no version history, so an overwritten limit loses its past, and reconstructing it means doing so by hand. With more than one person editing the workbook, nothing controls who can see which policies, and nothing fires an alert on its own.

This template’s column headers match Lextree’s import templates, so it loads directly into insurance policy tracking software — no re-keying, no remapping. From there, renewal and certificate-expiration dates drive reminders instead of waiting for someone to open the sheet. Policies, insureds, endorsements, periods, and certificates all carry forward as the linked records they already are.

Certificates you collect from vendors and contractors are a different job — see certificate of insurance tracking software for that side of the work.

Frequently asked questions

What is an insurance policy register? The single authoritative list of every policy an organization holds — insurer, coverage, limits, effective and expiration dates, the parties insured under each, and the certificates issued against them.

What should an insurance policy register include? At minimum: primary insured, insurer, policy type, coverage limits, and effective and expiration dates. A complete register also tracks every insured party, every endorsement as its own record, renewal history period by period, and every certificate issued — recipient, request source, and issue date — against the policy it certifies.

What’s the difference between an insurance policy register and an insurance policy list? A list holds one row per policy and goes stale the moment an insured changes or an endorsement binds. A register keys insureds, endorsements, renewal periods, and issued certificates back to each policy, so the current picture and its full history both survive.

Who is this insurance policy register template for? Risk managers, controllers, corporate counsel, and operations managers, particularly at organizations with multiple entities. A single-policy tracker assumes one insured throughout; this register is built for a corporate family, where a holding company insures subsidiaries under one master policy.

Can I track policies for multiple companies or subsidiaries? Yes. Primary Insured sits on every row in Insurance Policies, and insured roles carry across the corporate family, so a holding company and its subsidiaries share one register instead of one spreadsheet apiece.

How do I track insurance policy renewals and expirations in Excel? Sort or filter Insurance Policies by current expiration date, and read the renewal type alongside it. Log a renewed term as a new Policy Periods row instead of editing the current one, so prior limits stay on record. The template holds raw dates only — it doesn’t fire a reminder on its own.

Can I track policy endorsements in the spreadsheet? Yes. Policy Endorsements is a separate sheet from Insurance Policies, so every modification — a Waiver of Subrogation, an Additional Insured, a limit change — gets its own row with its own premium impact and effective date.

How do I log certificates of insurance we issue? Certificates Issued has one row per certificate — issuer, recipient, certificate type, issue date, and request source, whether the request came from a contract, a lease, or a loan agreement. Certificate Coverage Lines ties each certificate back to the policy it draws from.

Does this track certificates we issue, or certificates we collect from vendors? Issuance only. This template logs certificates your organization issues to landlords, lenders, and customers who ask for proof of coverage. Certificates you collect from vendors and contractors are a different job — see certificate of insurance tracking software for the collection side.

Is this claims management software? No. This is a register — a system of record for policies and the certificates issued against them. It doesn’t manage claims or calculate premiums, and nothing here fires an alert on its own.

Is the template really free, and does it work in Google Sheets? Yes. Enter your email below and the workbook is sent to your inbox — no credit card, no sales call. It opens in Google Sheets as well as Excel, dropdowns included.