Insurance Agency Desk
Independent insurance agencies and brokers
For insurance agents: policies, carriers, renewals, claims and commission statements.
Use this templateInsurance Agency Desk
Dashboard
Start here
Renewal workflow
Supporting an insured through a claim
New business intake
Weekly and monthly rhythm
Insureds
The households and businesses the agency insures.
| Insured | Status | Type | Phone | Insured since | Account manager | |
|---|---|---|---|---|---|---|
| The Halloran household | Insured | halloran.home@mailpost.net | (402) 555-0171 | Oct 10, 2022 | Tomasz Wieczorek | |
| Greer & Osei Dental | Insured | office@greerosei.net | (402) 555-0172 | Jun 1, 2024 | Rosalind Gutierrez | |
| Parisa Mohammadi | Insured | p.mohammadi@mailpost.net | (402) 555-0173 | Oct 14, 2025 | Tomasz Wieczorek | |
| Riverbend Roofing | Insured | owner@riverbendroofing.net | (402) 555-0174 | Aug 6, 2023 | Rosalind Gutierrez | |
| The Lindqvist-Banks household | Insured | lindqvistbanks@mailpost.net | (402) 555-0175 | Jan 22, 2026 | Tomasz Wieczorek | |
| Tallgrass Bakery | Insured | hello@tallgrassbakery.net | (402) 555-0176 | May 2, 2026 | Rosalind Gutierrez | |
| Desmond Achterberg | Lapsed | d.achterberg@mailpost.net | (402) 555-0177 | Feb 22, 2024 | Tomasz Wieczorek | |
| Sunrise Learning Center | Prospect | admin@sunriselearning.net | (402) 555-0178 | — | Colm Fairweather |
Policies
Each policy placed, with carrier, term dates and renewal status.
| Policy | Policy number | Status | Line | New or renewal | Carrier | Billing |
|---|---|---|---|---|---|---|
| Halloran home | HO-7741-2093 | In force | Pinnacle Mutual | |||
| Halloran auto, two vehicles | PA-30918-44 | Renewing | Harborview Insurance | |||
| Greer & Osei commercial property | CPP-118204 | In force | Northgate Casualty | |||
| Greer & Osei general liability | GL-5520-871 | In force | Northgate Casualty | |||
| Mohammadi renters | RN-2290-114 | In force | Sable Ridge Insurance | |||
| Riverbend workers compensation | WC-77013-02 | Renewing | Northgate Casualty | |||
| Riverbend general liability | GL-5521-309 | In force | Harborview Insurance | |||
| Lindqvist-Banks home and umbrella | HO-8810-5521 | In force | Pinnacle Mutual |
Claims
Claims reported on policies, tracked until the carrier closes them.
| Claim | Carrier claim number | Status | Date of loss | Reported on | Claimed amount (USD) | Paid by carrier (USD) |
|---|---|---|---|---|---|---|
| Hail damage to roof | PM-26-0418833 | Investigating | Oct 29, 2026 | Oct 31, 2026 | $14,200 | — |
| Rear-end collision, Halloran car | HV-26-0091574 | Settled | Jul 31, 2026 | Aug 1, 2026 | $3,850 | $3,410 |
| Water damage in kitchen | Waiting on carrier | Reported | Nov 14, 2026 | Nov 15, 2026 | $6,100 | — |
| Worker injury, ladder fall | NG-WC-26-2207 | Investigating | Oct 16, 2026 | Oct 17, 2026 | $28,400 | — |
| Customer slip at entrance | NG-GL-26-1185 | Denied | Aug 20, 2026 | Aug 22, 2026 | $5,200 | — |
| Stolen laptop from office | NG-CP-26-0764 | Settled | Jun 21, 2026 | Jun 22, 2026 | $1,800 | $1,600 |
Follow-ups
Calls, quotes and documents the team owes insureds.
| Follow-up | Status | Kind | Due | Completed on | Policy | Owner |
|---|---|---|---|---|---|---|
| Renewal call about auto premium change | To do | Nov 22, 2026 | — | Halloran auto, two vehicles | Tomasz Wieczorek | |
| Remarket workers compensation | Doing | Nov 20, 2026 | — | Riverbend workers compensation | Rosalind Gutierrez | |
| Send claim photos to carrier | To do | Nov 19, 2026 | — | Halloran home | Tomasz Wieczorek | |
| Review home coverage after kitchen renovation | To do | Dec 8, 2026 | — | Lindqvist-Banks home and umbrella | Tomasz Wieczorek | |
| Renewal call for home policy | To do | Dec 2, 2026 | — | Halloran home | Tomasz Wieczorek | |
| Collect signed application for liability quote | Doing | Nov 19, 2026 | — | Sunrise Learning general liability quote | Colm Fairweather | |
| Confirm lapsed auto policy status | Done | Nov 10, 2026 | Nov 10, 2026 | Achterberg auto | Tomasz Wieczorek | |
| Annual review call for dental office | To do | Nov 16, 2026 | — | Greer & Osei commercial property | Rosalind Gutierrez |
Commission statements
Carrier statements matched line by line to the policies they pay on.
| Statement line | Status | Statement date | Expected (USD) | Received (USD) | Note | Policy |
|---|---|---|---|---|---|---|
| Halloran home, renewal commission | Received | Oct 1, 2026 | $276 | $276 | — | Halloran home |
| Halloran auto, renewal commission | Received | Oct 1, 2026 | $265 | $265 | — | Halloran auto, two vehicles |
| Greer & Osei property, installment | Short paid | Oct 31, 2026 | $548 | $410 | Paid on the old premium; the mid-term endorsement is missing | Greer & Osei commercial property |
| Greer & Osei liability, installment | Received | Oct 31, 2026 | $312 | $312 | — | Greer & Osei general liability |
| Mohammadi renters, new business | Received | Sep 1, 2026 | $41 | $41 | — | Mohammadi renters |
| Riverbend workers comp, audit adjustment | Chargeback | Oct 31, 2026 | $190 | -$140 | Payroll audit lowered the premium; commission taken back | Riverbend workers compensation |
| Tallgrass package, new business | Expected | Nov 30, 2026 | $1,129 | — | — | Tallgrass commercial package |
| Lindqvist-Banks home and umbrella, rewrite | Expected | Nov 30, 2026 | $402 | — | — | Lindqvist-Banks home and umbrella |
The renewal book and open claims.
| Policy | Policy number | Status | Line | New or renewal | Carrier | Billing |
|---|---|---|---|---|---|---|
| Halloran home | HO-7741-2093 | In force | Pinnacle Mutual | |||
| Halloran auto, two vehicles | PA-30918-44 | Renewing | Harborview Insurance | |||
| Greer & Osei commercial property | CPP-118204 | In force | Northgate Casualty |
| Policy | Policy number | Status | Line | New or renewal | Carrier | Billing |
|---|---|---|---|---|---|---|
| Halloran home | HO-7741-2093 | In force | Pinnacle Mutual | |||
| Halloran auto, two vehicles | PA-30918-44 | Renewing | Harborview Insurance | |||
| Greer & Osei commercial property | CPP-118204 | In force | Northgate Casualty |
| Claim | Carrier claim number | Status | Date of loss | Reported on | Claimed amount (USD) | Paid by carrier (USD) |
|---|---|---|---|---|---|---|
| Hail damage to roof | PM-26-0418833 | Investigating | Oct 29, 2026 | Oct 31, 2026 | $14,200 | — |
| Rear-end collision, Halloran car | HV-26-0091574 | Settled | Jul 31, 2026 | Aug 1, 2026 | $3,850 | $3,410 |
| Water damage in kitchen | Waiting on carrier | Reported | Nov 14, 2026 | Nov 15, 2026 | $6,100 | — |
| Follow-up | Status | Kind | Due | Completed on | Policy | Owner |
|---|---|---|---|---|---|---|
| Renewal call about auto premium change | To do | Nov 22, 2026 | — | Halloran auto, two vehicles | Tomasz Wieczorek | |
| Remarket workers compensation | Doing | Nov 20, 2026 | — | Riverbend workers compensation | Rosalind Gutierrez | |
| Send claim photos to carrier | To do | Nov 19, 2026 | — | Halloran home | Tomasz Wieczorek |
Expiring in the next 30 days
| Policy | Policy number | Status | Line | New or renewal | Carrier | Billing |
|---|---|---|---|---|---|---|
| Halloran home | HO-7741-2093 | In force | Pinnacle Mutual | |||
| Halloran auto, two vehicles | PA-30918-44 | Renewing | Harborview Insurance | |||
| Greer & Osei commercial property | CPP-118204 | In force | Northgate Casualty |
Claims in progress
| Claim | Carrier claim number | Status | Date of loss | Reported on | Claimed amount (USD) | Paid by carrier (USD) |
|---|---|---|---|---|---|---|
| Hail damage to roof | PM-26-0418833 | Investigating | Oct 29, 2026 | Oct 31, 2026 | $14,200 | — |
| Rear-end collision, Halloran car | HV-26-0091574 | Settled | Jul 31, 2026 | Aug 1, 2026 | $3,850 | $3,410 |
| Water damage in kitchen | Waiting on carrier | Reported | Nov 14, 2026 | Nov 15, 2026 | $6,100 | — |
Follow-ups overdue
| Follow-up | Status | Kind | Due | Completed on | Policy | Owner |
|---|---|---|---|---|---|---|
| Renewal call about auto premium change | To do | Nov 22, 2026 | — | Halloran auto, two vehicles | Tomasz Wieczorek | |
| Remarket workers compensation | Doing | Nov 20, 2026 | — | Riverbend workers compensation | Rosalind Gutierrez | |
| Send claim photos to carrier | To do | Nov 19, 2026 | — | Halloran home | Tomasz Wieczorek |
How to read the numbers
Commission lines to chase
| Statement line | Status | Statement date | Expected (USD) | Received (USD) | Note | Policy |
|---|---|---|---|---|---|---|
| Halloran home, renewal commission | Received | Oct 1, 2026 | $276 | $276 | — | Halloran home |
| Halloran auto, renewal commission | Received | Oct 1, 2026 | $265 | $265 | — | Halloran auto, two vehicles |
| Greer & Osei property, installment | Short paid | Oct 31, 2026 | $548 | $410 | Paid on the old premium; the mid-term endorsement is missing | Greer & Osei commercial property |
The timeline
Step by step
When a client leaves
Set the policy to Lapsed, and note the reason in the follow-up: price, service, sold the car, moved, or went to another agency. A yearly look at these reasons tells you where you lose business.
Large increases
Checklist for business renewals
Example
Riverbend Roofing's workers compensation and liability both expire in six days. The workers compensation renewal came in 18 percent higher after the ladder-fall claim, so Rosalind is remarketing it and has a call booked with the owner before the term ends.
When a client reports a loss
What the adjuster usually needs
Keep it moving
What the agency must not do
After the claim
Claims affect renewals. Add a note to the policy's renewal follow-up so the account manager expects a premium change and can explain it.
Example
The Lindqvist-Banks household reported water damage in the kitchen four days after it happened. The claim is logged with the carrier, an adjuster is not yet assigned, and Patrice has a follow-up in two days to chase the assignment.
The first call
Ask, and write down on the insured's page:
Set it up here
Presenting quotes
Record which quote the client chose, and that the choice was theirs.
Binding
If they do not buy
Set the policy to Lapsed with a note on why, and add a follow-up 60 days before their current policy expires next year. Many clients come back at the next renewal.
Example
Sunrise Learning Center needs general liability before it opens a second classroom. The quote is out, the signed application is due by the end of this week, and the proposed start date is ten days away.
Every Monday
Every Friday
Once a month: commission statements
Carriers send a statement listing what they paid on each policy. Match it line by line.
Once a quarter
Example
The Greer & Osei property installment came in at 410 dollars against 548 expected. The note says the mid-term endorsement was not paid, so a follow-up goes to the carrier and the line stays Short paid until the next statement.
What lives where
The money columns
Your first week
The daily rhythm
Buttons you will use
Start renewal moves a policy to Renewing. Log a claim and Add follow-up open a new linked record. Tick done closes a follow-up and dates it. Assign to me takes a follow-up over.
Example
The Halloran auto policy renews in 15 days with a higher premium. Rosalind starts the renewal, books a call about the change, and notes the client's choice on the follow-up when they speak.
What's inside
6 tables · 24 views · 1 form · 3 row actions · 1 agent7 pages
- Insurance Agency Desk
- Dashboard
- Renewal workflow
- Supporting an insured through a claim
- New business intake
- Weekly and monthly rhythm
- Start here
5 tables
- Insureds3 views · 8 sample rows
- Policies8 views · 13 sample rows
- Claims4 views · 6 sample rows
- Follow-ups7 views · 9 sample rows
- Commission statements2 views · 9 sample rows
Questions
- What is included in the Insurance Agency Desk template?
- 7 pages (Insurance Agency Desk, Dashboard, Renewal workflow, Supporting an insured through a claim, New business intake and 2 more) and 5 tables (Insureds, Policies, Claims, Follow-ups and Commission statements), filled with 45 sample rows so every view opens with realistic data.
- Who is the Insurance Agency Desk template for?
- Independent insurance agencies and brokers.
- Is the Insurance Agency Desk template free?
- Yes. Sign up free, press Use this template, and a full copy is added to your workspace.
- Can I change the template after I use it?
- Yes. Every page, table, column and view in your copy is yours to rename, edit or delete, and the sample rows can be cleared.
Related workspaces
Accounting Firm DeskFor accounting firms: clients, monthly close checklists, tax deadlines, document requests.
Architecture Firm StudioFor architects: projects by phase, fees and hours, drawing sets, RFIs and submittals.
Consulting Practice DeskFor consultants: proposals, engagements, days sold versus used, deliverables and readouts.
Translation Agency DeskFor translation project managers: jobs, word counts, linguists, glossaries and reviews.
Event Planning Company DeskFor event planners: clients, events, vendor contracts, deposits, budgets and timelines.
IT Managed Services DeskFor MSP owners and techs: clients, devices, patching, tickets on SLA and agreements.