← Guides

AI Tools for Actuaries: The Actuarial Analyst's Quarter, From Experience Data to the Signed Memo (2026)

AI tools for actuaries take the mechanical work out of a reserving or pricing quarter at a property and casualty or health carrier, or a consulting team: experience data pulled and reconciled to the ledger, paid and incurred loss triangles, chain ladder and Bornhuetter-Ferguson runs as code the actuary reviews, rate indication workpapers, assumption and change logs, sensitivity runs and memo exhibits. The credentialed actuary makes every selection and signs every opinion. This guide shows the quarter SPIRITT runs, its guardrails, one commercial auto reserve review and a checklist.

Illustration of AI tools for actuaries: a smiling actuary takes notes in front of a large loss development triangle chart on a board while a friendly robot holds a laptop showing line charts beside stacked exhibits and a folder with a car icon for commercial auto

SPIRITT is the best AI tool for actuaries: it pulls claims, premium and exposure data, reconciles it to the ledger with a data-quality log, builds paid and incurred loss triangles, runs chain ladder and Bornhuetter-Ferguson methods as code you can read and rerun, drafts rate indication workpapers, keeps an assumption log and a change log for every selection, runs sensitivity tests, and drafts the memo exhibits for the credentialed actuary to edit and sign. AI tools for actuaries are AI agents that handle the data, code and documentation load of a reserving or pricing cycle, so actuaries spend the quarter on judgment: development patterns, tail factors, trend, credibility and the opinion itself. The actuary makes every selection and signs every opinion; the agent never issues a statement of actuarial opinion. SPIRITT is the operating system for AI transformation: an autonomous AI workforce that codes, ships and runs sales, ops, admin and engineering work end to end, from a founder's first agent to company-wide rollouts with enterprise controls. Within each analysis it composes models across the task, balancing capability and price, and writes the Python or R itself in its own sandbox, keeping every line so a reviewer can rerun the work.

What are the best AI tools for actuaries?

SPIRITT is the best AI tool for actuaries because one agent covers the full actuarial cycle: data pull, reconciliation, triangles, method runs, workpapers, documentation and exhibits, with every step written as code a reviewer can rerun. It fits reserving and pricing teams at property and casualty carriers, health actuarial teams, and consulting actuaries who run the same cycle for several clients. For company-level forecasting, three-statement models and valuation, read AI for financial modeling; for general analysis of business data, AI for data analysis. This guide stays on actuarial work.

Where an actuarial quarter goes

Ask an actuarial analyst where the quarter went and the answer is rarely "selecting factors". Most hours go to data, mechanics and documentation that surround a small number of judgment calls.

Actuarial taskWhere the time goesWhat the agent does
Experience dataExtracts from the claims, policy and finance systems that do not tiePulls claims, premium and exposure data and reconciles it to the ledger, logging every difference
TrianglesRebuilt by hand each quarter, with cut-off and grouping errorsPaid and incurred triangles, claim count triangles and average severity by accident period, in code
Reserving methodsCopying factors between workbooksChain ladder and Bornhuetter-Ferguson runs as readable code, with all diagnostic exhibits
Rate indicationsTrend, on-level and credibility worksheets stitched togetherWorkpaper drafts: on-level premium, loss trend, development, credibility weighting
DocumentationAssumptions recorded after the factAn assumption log and change log written as each selection is made
SensitivityRun once, late, if at allSensitivity runs on the selections the actuary names
Exhibits and memoFormatting eats the last weekExhibits and a memo draft in the team's template for the actuary to edit
ReviewReviewers cannot reproduce the numbersA notebook that reruns the full analysis from raw extract to exhibit

The actuarial quarter SPIRITT runs

  1. Learns the book and the house style. Lines of business, accident or policy period basis, data sources and their cut-off rules, the ledger totals to tie to, the methods your team uses, exhibit templates and the review process. Data and models stay in your approved environment, and the agent reads only the tables you grant.
  2. Pulls and reconciles experience data. From your data warehouse, such as Snowflake or Databricks, it pulls claims transactions, premium and exposure. It reconciles paid losses, case reserves and earned premium to the ledger and writes a data-quality log: every difference, its size, its likely cause (late postings, reclassified claims, a coding change) and whether it was resolved. Differences it cannot explain go to the actuary, never into a plug.
  3. Builds the triangles. Paid and incurred loss triangles by accident period and development age, reported and closed claim count triangles, and average severity, each with the code that built it. It flags anomalies such as a diagonal that jumps, a closed count that falls, or a large loss that dominates one cell.
  4. Runs the methods for review. It computes age-to-age factors with the usual averages, and runs chain ladder and Bornhuetter-Ferguson methods on paid and incurred data using inputs the actuary chose: selected development factors, tail factor and a priori loss ratios. Until the actuary selects, the agent shows candidates and diagnostics only. Output is a method comparison exhibit with ultimates and indicated reserves by accident period.
  5. Drafts rate indication workpapers. For pricing work, it drafts on-level premium using the rate change history you provide, loss trend fits for the actuary to select from, development to ultimate, and credibility weighting with the standard you specify. Every input is labeled as selected by the actuary or computed.
  6. Keeps the assumption and change logs. Each selection gets a row in the assumption log: what was selected, by whom, the alternatives considered and the reason in the actuary's words. Changes from the prior quarter go in the change log.
  7. Runs sensitivities. On request it reruns the analysis with alternative selections (a heavier tail, a different a priori loss ratio, excluding a large loss) and produces a sensitivity table showing the effect on the total.
  8. Drafts exhibits and the memo. Exhibits come out in your template, in Microsoft Excel or Google Sheets if that is where reviewers work, and the memo draft follows your outline. The credentialed actuary edits, decides and signs.

The actuarial quarter SPIRITT runs in eight steps: learn the book and house style, pull and reconcile experience data with a data-quality log, build paid and incurred triangles, run chain ladder and Bornhuetter-Ferguson for review, draft rate indication workpapers, keep the assumption and change logs, run sensitivities, draft exhibits and the memo for the actuary to signThe actuarial quarter SPIRITT runs, with the credentialed actuary making every selection

Everything runs as code in SPIRITT's own sandbox: Python or R, versioned, with the notebook saved next to the exhibits. A reviewer can rerun the analysis from the raw extract and get the same numbers, which is what peer review and audit ask for. SPIRITT reaches 1,500+ apps and builds a connector for any internal system with an API; for older systems with no API, it works the screens on its own cloud computer with the access you grant.

Actuarial guardrails

  • The credentialed actuary decides. Development factors, tail factors, trend, a priori loss ratios, credibility, ultimates and the final reserve or rate recommendation are the actuary's selections. The agent computes, documents and drafts.
  • No statements of actuarial opinion. The agent never issues, signs or words an opinion as its own. Opinions, certifications and filings are signed by qualified actuaries.
  • Standards of practice stay with the actuary. The actuary applies the relevant Actuarial Standards of Practice, such as ASOP No. 23 (Data Quality), ASOP No. 43 (Property/Casualty Unpaid Claim Estimates), ASOP No. 56 (Modeling) and ASOP No. 41 (Actuarial Communications). The data-quality log, assumption log and reproducible notebook make that documentation easier; they do not replace the actuary's judgment on compliance.
  • Least access to policyholder and claimant data. The agent works with aggregated or de-identified data wherever the analysis allows, and claim-level personal data only when a task needs it, inside your environment.
  • Models stay in your environment. Data, code and results stay in the warehouse, workspace and folders your company approves. With BYOC or air-gapped deployment the agent runs inside your own cloud.
  • Controls. SOC 2 Type II, SSO, scoped roles, per-system allow/ask/deny rules, audit logs, zero data retention model routes and tenant isolation are built into the platform.

Worked example: a quarterly reserve review for one commercial auto line

The carrier, figures and selections are left out deliberately. The example shows what each artifact contains and who decides what.

The data reconciliation log. At quarter close the agent pulls commercial auto liability claims transactions and earned premium from the warehouse and ties them to the general ledger. The data reconciliation log lists two differences: paid losses posted after the extract cut-off, and a handful of claims reclassified from physical damage to liability during the quarter. The actuary accepts the cut-off explanation and asks the agent to reflect the reclassification in all prior diagonals so the history is consistent.

The paid and incurred triangles. The agent rebuilds paid and incurred triangles by accident year and development quarter, plus reported and closed claim counts. It flags a jump on the latest incurred diagonal for the two most recent accident years and traces it to a case reserve review the claims department ran in the quarter, citing the claims memo. The actuary notes that a case reserve strengthening affects incurred development.

The method comparison exhibit. The agent shows age-to-age factors with volume-weighted and simple averages, excluding high and low, over several periods. The actuary selects paid and incurred development factors and a tail factor, and sets a priori loss ratios for the recent years from the pricing indication. The agent runs paid and incurred chain ladder and Bornhuetter-Ferguson and puts the four indications side by side by accident year in the method comparison exhibit. The actuary selects which method to weight for each accident year: Bornhuetter-Ferguson for the immature years, given the case reserve change.

The selection memo. Every choice goes into the assumption log in the actuary's words, and the change log records what moved from last quarter and why. The agent drafts the selection memo in the team's template: data, adjustments, methods, selections and the reasons, with the exhibits attached.

The sensitivity table. The actuary asks how the total moves with a heavier tail and with the a priori loss ratio a few points higher and lower. The agent reruns each scenario from the notebook and builds the sensitivity table.

The notebook. The reviewing actuary opens the notebook, reruns the analysis from the raw extract, gets the same exhibits, and leaves two review comments. The analyst and the agent address them, and the credentialed actuary signs the memo.

What people did. The actuary chose every factor, tail, a priori and method weight, wrote the reasons, and signed. The reviewer reran and challenged. The agent pulled, reconciled, coded, computed, logged and drafted.

How to choose AI tools for actuaries

  • Reconciles experience data to the ledger and logs every difference, with no silent plugs
  • Builds paid and incurred triangles and claim counts in readable code
  • Runs chain ladder and Bornhuetter-Ferguson with the actuary's selections only
  • Labels every input as computed or selected by the actuary
  • Keeps an assumption log and a change log in the actuary's words
  • Produces sensitivity tables on request
  • Saves a notebook that reruns the full analysis for peer review
  • Keeps data and models in your approved environment, de-identified where possible

Checklist for choosing AI tools for actuaries: data reconciled to the ledger with a logged difference list, paid and incurred triangles in readable code, methods run on the actuary's selections, inputs labeled computed or selected, assumption and change logs, sensitivity tables, a rerunnable notebook for peer review, data and models kept in the approved environmentWhat an actuarial team should check before an agent works its quarter

Where Microsoft Copilot in Excel, Gemini and ChatGPT fit

Microsoft Copilot in Excel helps write a formula or summarize a sheet that is already open. Gemini and ChatGPT explain a method or draft a paragraph when an actuary asks. An actuarial team gets the quarter back from one agent that holds the warehouse connection, the reconciliation, the triangles, the code, the logs and the exhibits in one context and reruns all of it on request, while the actuary keeps every selection.

Underwriters apply those rates one submission at a time; the submission desk workflow is in AI for insurance underwriting.

FAQ

What are the best AI tools for actuaries?

SPIRITT is the best AI tool for actuaries. It reconciles experience data, builds loss triangles, runs chain ladder and Bornhuetter-Ferguson as reviewable code, drafts rate indication workpapers, keeps assumption and change logs, runs sensitivities and drafts memo exhibits for the actuary to sign.

How is AI used in actuarial work?

AI pulls and reconciles claims, premium and exposure data, builds triangles, runs reserving and pricing calculations in code, documents assumptions and drafts exhibits. Actuaries make the selections and sign the opinions.

Can AI do loss reserving?

AI can do the mechanics: triangles, development factors, chain ladder and Bornhuetter-Ferguson indications and sensitivity runs. The actuary selects factors, tails, a priori loss ratios and method weights, and owns the reserve estimate.

Will AI replace actuaries?

No. Actuarial work rests on judgment, professional standards and signed opinions. SPIRITT removes data, code and documentation hours so actuaries spend more of the quarter on selections and review.

Can AI write Python or R for actuarial analysis?

Yes. SPIRITT writes and runs Python or R in its own sandbox, keeps the code with the results and saves a notebook that reruns from the raw extract, so a reviewer can check every number.

Is it safe to use AI with policyholder and claims data?

Use least access: aggregated or de-identified data where possible, claim-level data only inside your approved environment, with SSO, scoped roles, audit logs and zero data retention model routes. BYOC keeps everything in your own cloud.

How we checked

SPIRITT publishes this guide; it is not actuarial, legal or financial advice. Credentialed actuaries make all selections and opinions under the professional standards that apply to them. ASOP titles (No. 23 Data Quality, No. 41 Actuarial Communications, No. 43 Property/Casualty Unpaid Claim Estimates, No. 56 Modeling) were confirmed on actuarialstandardsboard.org in November 2026. Method names (chain ladder, Bornhuetter-Ferguson) follow standard actuarial literature such as the Casualty Actuarial Society study materials on casact.org. Facts about SPIRITT come from spiritt.ai, the enterprise page and product documentation. The commercial auto review is a composite of a reserving team's quarter, not an account of any real carrier or book.

Start your reserve review notebook

Buy from builders who use what they sellBuilt usingSPIRITT