Blue Sage Data Systems
insurance · Insurance · January 14, 2025

Renewal Prep Ate Every Senior Account Manager's Friday

Renewal prep ate every senior account manager's Friday. The version that runs alongside them takes about 20 minutes.

Migrated from earlier notebooks

At a commercial lines agency in Lincoln — 60 employees, a book spanning construction, manufacturing, and professional services — senior account managers spend three to four hours every Friday assembling renewal packages. Not just at quarter-end: the commercial book renews on a rolling 12-month cycle. There are always accounts coming up for renewal. There are always Fridays that disappear.

The renewal package isn’t complicated to understand. It’s complicated to assemble. Loss runs from the current carrier. Exposure changes since the last renewal. A market conditions summary. A coverage recommendation memo. Each piece comes from a different source, and the assembly work is mostly reading, extracting, and organizing — not judgment.

What renewal prep actually contains (loss runs, market change, risk delta, coverage rec)

A commercial P&C renewal package has four working sections.

Loss run analysis covers the client’s claims history over three to five years: frequency, severity, loss type, year-over-year trends. The account manager is looking for what will matter to underwriting — a cluster of small claims, a large loss now closed, an improved experience that warrants a rate credit conversation.

Market conditions summary captures what’s happening in the lines this account buys — property rates, carrier appetite for the client’s class, capacity in specialty lines. Not a comprehensive survey; a one-page picture of the three or four factors that affect this renewal.

Risk delta identifies what changed at the client since last renewal: new locations, payroll changes, an operational shift that affects the GL exposure. The data gathering pulls from CRM notes, the prior policy, and the renewal application.

Coverage recommendation is the account manager’s call: which coverages to propose, which limits to revisit, which carrier to lead with. This section doesn’t benefit from automation. It’s the reason the account manager is the account manager.

Where AI is good and where it’s not

AI handles loss run analysis and risk delta compilation well. Both involve pulling structured data from documents that already exist — the carrier’s loss run PDF, the prior policy, the CRM record — extracting the relevant fields, and organizing them into a consistent format. The inputs are defined. The output structure is known.

Market conditions summary is a softer fit. AI can pull from a standardized market update if the agency maintains one internally. But it shouldn’t be generating market analysis from external sources without review — confident-sounding output that’s stale or wrong is worse than no output. The right design: the agency principal maintains a brief weekly market conditions document that the pipeline applies to each renewal. AI organizes existing knowledge; it doesn’t generate it.

Coverage recommendations shouldn’t touch AI at the drafting stage. The account manager owns that section.

The shape of the build (data sources, draft format, AM review pattern)

The pipeline runs from two inputs: the client record in the AMS and the carrier’s loss run PDF. Prior policy terms, renewal application, CRM notes — all pulled from the AMS or linked to the client record.

Extraction builds the loss run analysis and risk delta sections. The market conditions section is populated from the principal’s weekly market bulletin. The coverage recommendation section is pre-loaded with the account manager’s prior recommendation so she’s updating, not starting from blank.

The output is a draft renewal package in the agency’s standard format. The account manager opens the draft, reads through it, corrects any extraction anomalies, and writes the coverage recommendation. The pipeline runs overnight on accounts renewing in the next 30 days. Monday morning: drafts in the queue, not blank pages.

The senior-AM check that has to stay

The account manager’s review is not optional.

Loss run PDFs from different carriers use different formats — calendar year vs. policy year, severity in ranges vs. individual claims listed. Extraction handles most of these, but the account manager knows the carrier’s format and catches cases where the extraction miscounted a year’s totals.

For relationship reasons: the renewal conversation is an account management conversation. An account manager who hasn’t read the package before the client call is going in underprepared. The 20 minutes of review is how the tool stays a tool and doesn’t become a crutch.

The check should be structured: the account manager signs off on each section before the package is marked ready. The draft goes to her queue, not directly to the client. That’s the workflow that preserves the relationship model the agency has built.

What it looks like Monday morning

The account manager has four renewal packages in her queue. Each has the loss run section populated, exposure changes pulled from the AMS record, and the market conditions paragraph current as of the principal’s Monday update.

Three of the four take about five minutes each to review and sign off on. The fourth has an anomaly — a claim appearing in two policy years because it was reported late. She corrects the count and adds a note for the underwriter. Twelve minutes.

By 9:30 a.m., four packages are ready and she’s been through each account’s recent history. On a prior Friday, that same preparation started at 1 p.m. and ran to 5. The recovered time goes into client calls, not spreadsheets. These ranges reflect typical outcomes from a well-implemented build; actual results depend on carrier mix, AMS configuration, and how the account manager’s review style.

See how Blue Sage approaches the full range of commercial insurance workflows at the insurance practice.

→ Start here

Text Rosey to begin.

Rosey is our executive-assistant bot. Text the number below — she'll ask two questions, offer three calendar slots, and put a 30-minute call on Jim's calendar.

Text Rosey · Schedule a call →

or call 415 481 2629