Commercial Insurance Renewal Checklist & 120/90/60/30 Timeline
Enter your renewal date once and every task gets a due date. The timeline covers what to do at 120, 90, 60, 30, and 0 days: exposure updates, loss runs, marketing decisions, proposal review, binding, and certificates. A Policy Review sheet walks each line of coverage, and the Word version prints as a one-pager.
Excel + Word
Who it is for
Business owners and office managers who handle insurance as one of many jobs, risk managers running a formal renewal, and agents who want to hand clients a shared timeline.
What is inside
- Timeline sheet: 120/90/60/30/0-day tasks with owner, due-date formulas driven by a single renewal date cell, done checkbox column, and a status formula (Done / Overdue / Due soon / Open)
- Policy Review sheet: one row per line of coverage with limits, deductibles, exclusions to confirm, and changes since last year
- Conditional formatting for overdue and due-soon tasks
- Word one-page printable checklist in the same order
- Notes on what brokers need and when, and why 120 days matters for marketed accounts
AI prompt pack: fill this template with ChatGPT or Claude
Paste the prompt below into ChatGPT or Claude together with your own documents (declarations pages, certificates, P&L, contracts). It is written to return results in this template's column order.
Check anything an AI tool returns against the source document before you rely on it. The prompt is a starting point, not a substitute for reading the policy.
Questions
Why start 120 days out?
If the account will be marketed, brokers need 90 days to approach carriers and carriers need updated exposures and loss runs before they quote. Starting at 120 days gives you the 30 days to gather the information that everything else depends on.
What goes on the Policy Review sheet?
One row per line of coverage with the current limit and deductible, exclusions you want confirmed, and what changed in the business since last year: new locations, vehicles, products, acquisitions, or contracts with insurance requirements.
Can I use this for a single policy?
Yes. Delete the lines you do not carry on the Policy Review sheet; the timeline tasks apply regardless of how many policies renew.
Do the due dates update automatically?
Enter the renewal date in the one highlighted cell and every due date and status recalculates. The Word version is a printed snapshot; regenerate it from the spreadsheet if the date changes.
Related templates
COI Tracker
Track every vendor and subcontractor certificate of insurance in one workbook. Enter the limits a certificate shows, and the sheet compares them to the...
Vendor Insurance Requirements
An insurance exhibit you attach to vendor and subcontractor agreements. It sets required coverages and minimum limits for three vendor tiers, spells out...
Business Income Worksheet
Estimate how much business income coverage you actually need. The workbook follows the ISO CP 15 15 worksheet structure, calculates net income plus continuing...
Free insurance tools
Use the letter generators in your browser, or download the free home inventory and proof-of-loss guide.