WorkflowActuarial, Reserving & Finance

Actuarial Opinion & Report Automation

Actuarial opinion and report automation: the year-end report drafted from the reserve analysis, every exhibit tied to the annual statement

The year-end report drafted from the analysis, every exhibit tied out.

See one case, screen by screen ↓
demo312of 312numbers in the report and opinion on a ribbon to their annual statement line — all holding when she signs
demo2minto re-check every ribbon against a new statement version — 2 min 13 s, six steps
demo7itemsfound needing an update after a late reclassification: 4 exhibit cells and 3 sentences
demo6of 6sign-off checks passed before the opinion can be signed
In short

What is Actuarial Opinion & Report Automation?

Software that drafts the appointed actuary's Actuarial Report and Statement of Actuarial Opinion from the reserve analysis and keeps every number tied to the annual statement. Actuarial Opinion & Report Automation uses six agents to read each statement version, keep the tie-out, draft exhibits and narrative, explain the change from the prior report, check the documentation and draft the reinsurance collectability comment. The appointed actuary accepts every change and signs.

How to choose AI solutions for insurance →

Updated

The problem

Why the year-end report is where reviewers find the errors

Every year the appointed actuary signs an opinion on carried reserves, backed by an Actuarial Report that has to tie to the annual statement, map the data to Schedule P, explain the change from the prior report and document every method, assumption and judgement. It is written in the last weeks of close — while the statement is still moving.

Reserve committees, top-side entries and line reclassifications land in the two weeks before the 1 March filing. Exhibits pasted from Excel a week earlier go stale and nobody notices; a sentence in §4 still quotes last week's carried amount. Inconsistent exhibits and thin documentation are what a peer reviewer — or the department's actuary — finds first.

estimated≈3weeksof senior actuarial time to draft the year-end report by hand
typical$7.3Badverse development in other liability – occurrence across the industry in 2025 — the judgements reviewers read first
typical$12.5Bestimated reserve deficiency in that one line, industry-wide
Where the year-end report's days goestimated
By hand15 days
With the solution3 days
  • Building and pasting exhibits, tied to the statement4 → 0.5 d
  • Re-tying after each late statement version3 → 0.5 d
  • Writing the change from the prior report3 → 0.5 d
  • Narrative on methods, assumptions and results3 → 1 d
  • Checking documentation against the instructions and ASOPs2 → 0.5 d

Estimated split of senior actuarial time for one report and opinion, by hand and with the solution.

How it works

How a statement change reaches the report

Six agents draft the report and keep every number tied to the statement; the appointed actuary accepts and signs.

What comes in
Sources in5 sources · statement versions, reserve analysis, prior report, Schedule F, memos
Agents at work
Statement readerevery version, compared
Then
Tie-out checker312 ribbons
Then
Report draftercells + sentences
Change explainerwalk from last year
Then
Documentation reviewer¶¶2–7 · ASOP 41
Reinsurance readerSchedule F comment
A person decides
Appointed actuaryaccepts and signs
What comes out
Report tied out
Gaps closed
Opinion signed
One case, step by step

One late statement change, from posted to signed

Thursday 25 February, four days before the opinion is filed. Sable Point Mutual's draft report ties to statement v13 — until statutory reporting posts v14. Here is the afternoon, screen by screen, in the working solution.

  1. 01Four days before filing

    Her report beside the statement, every number on a ribbon

    Elena Marsh · Chief Actuary and Appointed Actuary

    Elena opens the tie-out. On the left, draft v7 of her Actuarial Report — 84 pages, 41 exhibits: Exhibit A of the opinion, Exhibit 1 carried against her estimates, Exhibit 1B carried IBNR for accident year 2023. On the right, annual statement v13: the Liabilities page, Schedule P Part 1 by line. Between them a green ribbon runs from every number to its statement line. 312 hold, 0 broken. The opinion is due Monday 1 March.

    “296 more ribbons in 38 other exhibits · all hold”

  2. 0214:12

    A late reclassification lands

    Dana Whitfield · Assistant Controller

    After the reserve committee on 23 February, the umbrella book written on commercial package forms is reported under other liability – occurrence. Dana posts statement v14: $6,800k of accident year 2023 IBNR moves from Schedule P Part 1E to Part 1H-1. Four lines change; the Part 1 Summary total stays at 612,400.

    The change note: “umbrella and excess book now under other liability – occurrence; total reserves unchanged”

  3. 03One click · 2 min 13 s

    Every ribbon re-checked — four break at once

    Statement reader and tie-out checker

    Elena presses “Re-check every ribbon against v14”. The statement reader reads v14 and compares it with v13 line by line. The tie-out checker re-checks all 312 ribbons: 308 hold, 4 broken — the carried amounts for commercial multiple peril and other liability – occurrence in Exhibit 1, and their 2023 IBNR in Exhibit 1B. Exhibit A and the opinion still tie: net losses 503,950 and LAE 108,450.

    “4 ribbons broken — 4 exhibit cells and 3 sentences need updating”

  4. 0414:19

    The cells updated, the sentences redrafted

    Report drafter

    Elena updates the 4 cells and the ribbons hold again, 312 of 312. Then the report drafter shows the words that still use the old numbers — §4.2, §4.3 and §6 — each with a margin note saying why the ribbon broke and a redraft beside it: other liability – occurrence is now $95.3 million, $1.4 million above her point estimate of $93.9 million.

    “Statement v14 carries $95,260k for this line (Schedule P Part 1H-1). The sentence still says $88.5 million.”

  5. 0514:21 – 14:23

    She accepts each redraft, one by one

    Elena Marsh · Appointed Actuary

    Commercial multiple peril is now carried at $68.2 million, $1.9 million above her point estimate; workers' compensation, $3.1 million above, now carries the largest margin. The §6 sentence about one line's shortfall offsetting the other's margin no longer holds, so it is redrafted too. Each sentence changes only when she presses Accept or edits it herself.

    The report drafter never changes a selection or a judgement; every redraft waits for the appointed actuary.

  6. 06Wednesday

    The reinsurance comment, already accepted

    Reinsurance collectability reader

    Earlier in the week the agent read Schedule F, Part 3 and the ratings: ceded reserves of $150.8 million, 84% with reinsurers rated A− or better. Corvane Re, rated B and under review, owes $1.9 million on paid losses more than 90 days past due. It drafted the relevant comment; Elena accepted it on Wednesday 24 February.

    “This comment does not imply an opinion on the financial condition of any reinsurer.”

  7. 07Before you sign

    Six checks, all clear

    Elena Marsh · Appointed Actuary

    The Statement of Actuarial Opinion — identification, scope, opinion, relevant comments, Exhibit A and Exhibit B — sits beside its sign-off checks: every ribbon holds, the report's words agree with the statement, Exhibit A ties to the Liabilities page and Schedule P, the data reliance certification is attached, the reinsurance comment is accepted, peer review of the opinion is cleared. 6 of 6. Ready to sign.

    Signing is blocked while any ribbon is broken or a sentence disagrees with the statement.

  8. 0816:40 · Signed

    She signs the opinion, tied to v14

    Elena Marsh · Appointed Actuary

    The sign dialog shows what she is signing: Sable Point Mutual, as of 31 December 2026, statement v14 with 312 of 312 ribbons holding, carried net $612,400,000 — $9.0 million above her point estimate — and a Reasonable opinion. Her signature is recorded with the time, the statement version and the report draft. Statutory reporting files it with the annual statement on Monday 1 March.

  9. 09For the report

    The change from the prior report, every move cited

    Change explainer

    Her net point estimate went from $571.8 million to $603.4 million: $201.4 million paid on prior years, $219.6 million for accident year 2026 and $13.4 million of adverse development — $9.8 million of it in other liability – occurrence. Each method and assumption change carries its memo: AM-2026-11 raised the expected loss ratio for other liability – occurrence, accident years 2022–2024, from 64% to 69%.

  10. 10Due 1 May

    Two gaps left, and only she closes them

    Documentation reviewer

    The report is read against the instructions (¶¶2–7), ASOP No. 36 and ASOP No. 41. Two gaps stay open: the workers' compensation tail moving from 1.032 to 1.041 is in Exhibit 9 but not explained in §3, and the date and manner of the audit committee presentation are missing. The reviewer has drafted the missing §3 paragraph. When Elena inserts it, the gap closes, and so does Tom Okafor's matching peer-review comment.

    “Drafted by the documentation reviewer · you close it”

Who it’s for

Built for everyone who touches the opinion.

The same afternoon, seen by the four people who carry the report — what their close looked like, and what it looks like now.

EM
Elena MarshChief Actuary, FCAS, MAAA
Appointed actuary
Before
Signs an opinion on numbers that were pasted into the report days before the last statement version posted.
Now
Signs knowing every number in the report and opinion is the statement's number on the day she signs — 312 of 312, tied to v14.
PR
Priya RamanSelections and exhibits
Reserving actuary
Before
Re-pastes Exhibit 1 every time the statement moves, and hopes she caught every cell.
Now
Builds the selections; the exhibits stay tied, and the change from the prior report arrives with its memos cited.
DW
Dana WhitfieldAssistant Controller
Statutory reporting
Before
Posts a late version after the reserve committee and has no way to tell the actuaries what it touched.
Now
Posts v14; within minutes the report shows which four lines moved and which exhibits they feed.
TO
Tom OkaforFCAS · Lindqvist Actuarial Partners
Peer reviewer
Before
Spends review rounds checking that exhibits tie before he can read the judgement.
Now
Reads a report whose exhibits are tied to every posted version, and comments on the judgement — 9 comments, 7 resolved.
Built on the engine

6 agents. Each with one job, and hard limits.

Six agents draft the report and keep every number tied to the statement; the appointed actuary accepts and signs.

Statement reader

Reads every posted version of the annual statement — the Liabilities page, Schedule P Parts 1–3, Schedule F — and compares it with the last, line by line.

  • Read-only on the annual statement
  • Every value cited to schedule, line and column
  • Never infers a value that is not on a schedule
Tie-out checker

Keeps a ribbon from every number in the report and the opinion to its statement line, and re-checks all of them when either side changes.

  • Never plugs or rounds away a difference
  • A difference above $1k is never called rounding
  • Signing blocked while a ribbon is broken
Report drafter

Drafts the exhibits and narrative from the reserve analysis, last year's report and the house style; redrafts sentences when a number moves.

  • Never changes a selection, method or judgement
  • Never writes the opinion paragraph
  • Every redraft waits for the appointed actuary
Change explainer

Builds the change from the prior report by line and accident year, citing the memo or triangle behind each movement.

  • No change explained without a memo or triangle to cite
Documentation reviewer

Reads the report and opinion against the instructions ¶¶2–7, ASOP No. 36 and ASOP No. 41, and lists each gap with its paragraph.

  • Never closes a gap itself
  • Drafts the missing text for the actuary to insert or edit
Reinsurance collectability reader

Reads Schedule F, ratings and balances over 90 days, and drafts the relevant comment on collectability.

  • Never gives an opinion on a reinsurer's financial condition
  • The comment goes in only when the actuary accepts it
Appointed actuary

Accepts every redraft, closes gaps, signs; a peer reviewer comments. The agents propose; a named person decides.

Ask in plain words

Ask about any exhibit, statement line or sentence

The actuary can ask about the report in plain words — or tell it what to draft. Every answer is cited to the statement, the exhibit or the memo.

What did statement v14 break?

Dana's v14 moves the umbrella book, and $6.8 million of accident year 2023 IBNR, from commercial multiple peril to other liability – occurrence. Totals are unchanged, so Exhibit A and the opinion still tie. Four ribbons break: the carried amounts for both lines in Exhibit 1, and their 2023 IBNR in Exhibit 1B. Three sentences use the old numbers: §4.2, §4.3 and §6.

Is carried still inside my range?

Yes. Carried net reserves of $612.4 million are $9.0 million above your point estimate of $603.4 million and inside your range of $574.2–648.9 million. By line, v14 brings other liability – occurrence to $95.3 million, $1.4 million above your point, and commercial multiple peril to $68.2 million, $1.9 million above. Every line is now inside your range.

What changed since last year's report?

Your net point estimate rose from $571.8 million to $603.4 million: $201.4 million paid on prior years, $219.6 million for accident year 2026, and $13.4 million of adverse development on prior years. Other liability – occurrence is $9.8 million of that, after you raised the expected loss ratio for 2022–2024 from 64% to 69%. The report must show this walk net, and gross where relevant.

Draft the narrative for the workers' comp tail change

Drafted for §3 — it is in your documentation gaps to insert or edit: “In the 2026 analysis I extended the paid development triangle for workers' compensation to 25 years and selected a paid tail factor of 1.041, against 1.032 last year. The change adds $2.1 million to my point estimate for the line…” It closes Tom Okafor's comment 8 when you insert it.

Every screen

The working solution, as it ships.

13 screens from the working solution, on its sample data. Pick one to see it large.

The tie-outThe draft report beside the annual statement, a ribbon from every number to its line: 312 hold, 0 broken, the filing clock above.
Statement versionsEvery version statutory reporting posts, compared line by line with the exhibits each line feeds.
A late change, re-tiedStatement v14 re-checked in 2 min 13 s: four ribbons broken, and exactly which cells and sentences need updating.
Redrafts in the marginEach stale sentence marked in the report, with why its ribbon broke and a redraft to accept or edit.
The report, agreeing again§4.2, §4.3 and §6 accepted; Exhibit 1 tied to statement v14.
Reinsurance collectabilitySchedule F recoverables by reinsurer, ratings and balances over 90 days, with the drafted relevant comment.
The Statement of Actuarial OpinionIdentification, scope, opinion, relevant comments, Exhibits A and B — beside the six checks before signing.
Signing the opinionWhat is being signed — statement version, ribbons, carried amount, type of opinion — recorded with the signature.
SignedSigned at 16:40, tied to statement v14, with every step on the activity trail.
Change from the prior reportThe walk from $571.8M to $603.4M, development by line, and every method and assumption change with its memo.
Documentation gapsThe report read against the instructions and ASOP Nos. 36 and 41 — each gap by paragraph, with drafted text only the actuary closes.
Peer reviewThe peer reviewer's comments on the draft, each with its answer — 9 comments, 7 resolved.
SettingsTie tolerance, statement feed, signing rules, materiality standard, opinion wording and house style.
Governance

Built for a signed opinion: tied, cited, on the record.

Every number on a ribbonEach number in the report and the opinion keeps its source — statement version, schedule, line and column, or reserve analysis cell — and every redrafted sentence cites the exhibit and statement line it rests on.
The statement is read, never changedThe annual statement is read-only to the agents. Statutory reporting owns it and posts each version; the agents read and compare.
No plugs, no rounding awayA difference above the tie tolerance breaks the ribbon. It is never plugged, and a difference above $1k is never treated as rounding.
Signing waits until everything tiesThe opinion cannot be signed while any ribbon is broken or a sentence disagrees with the statement. The signature is recorded with the time, the statement version and the report draft.
The appointed actuary decidesAgents draft; the appointed actuary accepts every redraft, closes every documentation gap and signs. No selection, method or judgement is changed without her.
On the record for seven yearsEvery statement version, ribbon run, redraft, acceptance and signature is on the activity trail, and the report and workpapers are kept for seven years.
Configuration

Your opinion's rules, not ours

The rules every report and opinion is drafted and tied against. Changes are versioned and on the audit trail.

SettingDefaultChoose from
Tie tolerance$1k$0 to $10k — above it the ribbon breaks
Statement feedAnnual statement tool export · every posted versionEvery posted version · nightly at 02:00 · only when asked
Block signing while a ribbon is brokenOnOn · off — the opinion cannot be signed until every number ties
Redraft sentences when a number movesOnOn · off — drafted for the actuary to accept; never changed without her
Materiality standard10% of statutory surplus · $49.9M10% of statutory surplus · 5% of net reserves · a fixed $50.0M
Opinion wordingNAIC illustrative wording, 2026 instructionsNAIC illustrative wording · last year's signed opinion — the opinion paragraph is the actuary's
House styleActuarial Report 2025 (signed 28 Apr 2026)Last year's signed report · a group reserving template
Peer review before the report is finalTom Okafor, FCAS · Lindqvist Actuarial PartnersAn outside peer reviewer · an internal reviewer — every comment answered before 1 May
Connections

Works with the systems you already run

Your annual statement toolevery posted version: Liabilities page, Schedule P, Schedule F
Reserve analysisselections, triangles, point estimates and ranges by segment and accident year
Prior reports and opinionslast year's estimates and the house style
Assumption memoseach change of method or assumption, its effect and who approved it
Reinsurer ratingsratings and balances over 90 days for the collectability comment
Wordthe draft Actuarial Report, exported to Word
What it changes

The difference, in numbers.

Every figure is labelled: a target the solution is built to, an estimate, a typical published result, or a proven one.

estimated
Days
not weeks, to draft the year-end report from the reserve analysis
By hand≈ 3 weeks
With agents≈ 3 days
target
312of 312
numbers tied to the annual statement before the actuary signs
All ribbons hold
signing blocked until they do
typical
$7.3B
adverse development in other liability – occurrence in 2025: the judgements reviewers read first

“demo” = seen in the working solution, on its sample company data · “target” = the design goal, measured in the live solution · “estimated” = our estimate (about three weeks of senior actuarial time to draft the report by hand) · “typical” = published figures (Carrier Management, Apr 2026, citing S&P Global Market Intelligence — $7.3B of adverse development in other liability – occurrence in 2025 — and Assured Research — an estimated $12.5B deficiency in that line). Instruction paragraphs and filing dates are from the NAIC Annual Statement Instructions – Property and Casualty, Actuarial Opinion. People, companies and reinsurers named on this page are fictional — characters and sample data in the working solution.

Questions

What appointed actuaries ask us.

What is actuarial opinion and report automation?

Software that drafts the appointed actuary's Actuarial Report and Statement of Actuarial Opinion from the reserve analysis and keeps every number tied to the annual statement. Actuarial Opinion & Report Automation uses six agents to read each statement version, keep the tie-out, draft exhibits and narrative, explain the change from the prior report, check the documentation and draft the reinsurance collectability comment. The appointed actuary accepts every change and signs.

How does it tie the report's exhibits to the annual statement?

Every number in the report and opinion keeps a ribbon to its source: statement version, schedule, line and column. Exhibit A ties to the Liabilities page and Schedule P Part 1 Summary; Exhibit 1 ties carried amounts by line to Schedule P Part 1. A difference above the tie tolerance — $1k in the working solution — breaks the ribbon.

What happens when statutory reporting posts a late statement version?

The statement reader reads the new version and compares it with the last. The tie-out checker re-checks every ribbon and lists the exhibit cells and sentences that now need updating. In the working solution, a reclassification of $6.8 million of accident year 2023 IBNR was re-checked in 2 min 13 s: 4 ribbons broke, and 4 cells and 3 sentences were flagged.

Does the AI write the opinion or change my selections?

No. The report drafter never changes a selection, method or judgement, and never writes the opinion paragraph — the opinion starts from the instructions' illustrative wording and the opinion paragraph is the actuary's. Redrafted sentences wait for the appointed actuary to accept or edit them.

Can the opinion be signed while something does not tie?

No. Signing is blocked while any ribbon is broken or a sentence disagrees with the statement. The opinion shows six sign-off checks, and the signature is recorded with the time, the statement version and the report draft.

Which standards does it check the report against?

The documentation reviewer reads the report and opinion against the NAIC annual statement instructions for the actuarial opinion (¶¶2–7), ASOP No. 36 and ASOP No. 41, and lists each gap with its paragraph — for example, a tail factor change shown in an exhibit but not explained in the narrative. It drafts the missing text; only the appointed actuary closes a gap.

Does it change the annual statement?

No. The annual statement is read-only to the agents. Statutory reporting owns it and posts each version; the solution reads, compares and ties to it.

How long does it take to go live?

The Agentic Solution Engine builds and deploys it from your requirements — last year's signed report and opinion, your annual statement exports, your reserve analysis and assumption memos — and it goes live once every quality gate has passed. We will walk you through it on your own prior-year report first.

See it on
your year-end report.

We'll run Actuarial Opinion & Report Automation on last year's report and your annual statement versions.