- Before
- Runs 57 requests from a spreadsheet and finds out on day ten that a file was wrong.
- Now
- Watches every request fill in on its business-day clock, with problems flagged and explained before she submits.
One examiner request, from sample list to submitted
Harrow Ridge Mutual is on day 6 of fieldwork in a targeted market conduct exam by the Ohio Department of Insurance. The examiner-in-charge has asked for 79 homeowners claims closed without payment, due Thursday. Here is what happens, screen by screen, in the working solution.
- 01Mon 12 Oct · 10:40
The whole exam on one screen
Nora Lindqvist · Exam coordinatorNora opens the request room, not a to-do list. The exam’s life runs across the top — call letter 21 Sep, fieldwork 5 Oct to 11 Dec, draft report Feb 2027 — and under it all 57 requests by exam area, each with its owner, its business-day clock and one cell for every file or answer it needs. 34 submitted, 11 due this week, 0 late.
“Please replace 4 claim numbers in the list sent 7 Oct — they were closed with payment. The due date is unchanged: Thursday 15 October.” — Paul Okonkwo, CIE, 09:55
- 02One click
R-23 starts filling, file by file
Call letter reader · File pullerR-23 asks for homeowners claims closed without payment, a sample of 79. Nora presses Fill R-23. The call letter reader reads the corrected sample list — 4 claim numbers replaced, due date unchanged — and counts 5 business days to Thu 15 Oct, with Columbus Day skipped. The file puller brings each file in from the claim system, the policy system and the agency mailbox: notes, letters, payments, photos. The 79 cells turn blue as they arrive.
- 03File 38 of 79
One file turns amber
Standards pre-checkerAs each file is tested, its cell turns green or amber. File 38 is HO-24-118406, the Amundsens’ water claim in Westerville. The claim system says it was acknowledged in 7 days. The pre-checker counts from the day the insureds called their agent, Kessler & Vance, on 4 March 2024 — and that is 18 days.
“Late acknowledgement · 18 days, limit 15. Acknowledged 18 days after the insured called the agent (Kessler & Vance, 4 Mar 2024); the claim system shows 7.”
- 04Tested
Every file tested the way the examiner will
Standards pre-checker79 files, 782 documents, 73 clean and 6 with an issue — each standard against the 7% claims tolerance. Acknowledgement within 15 days: 3 of 79 (3.8%). Decision within 21 days of proof of loss: 0. Status letter every 45 days: 1 of 79 (1.3%). Denial cites the policy provision: 2 of 79 (2.5%) — two free-form letters, and a repeat of the 2022 exam’s finding 3.
The pre-checker explains and routes; it never concludes that an exception is a violation.
- 05The file
Two clocks, and the email that proves the date
Nora Lindqvist · Exam coordinatorThe sampled file opens on its timeline: the call and email to the agent on 4 Mar, the agency entering the claim on 15 Mar, the acknowledgement letter on 22 Mar, inspection, proof of loss, and the denial on 16 Apr citing Section I Exclusion 2.c.(6). The agent’s email sits beside it with the margin note: under Model 902 §6A, notification to an agent is notification to the insurer.
- 06Before submission
The explanation, drafted before the examiner asks
Response drafterThe response drafter writes the company’s explanation from the file and the fix already made: since 1 July 2025 agents report claims through the direct first-notice line, and late acknowledgements on agent-reported homeowners claims fell from 4.1% to 0.6%. It cites the agency email, the first-notice record, procedure CP-03 and the acknowledgement report. Teresa Whitlock confirms the facts; Nora sends it to counsel.
The draft is marked Draft. It never goes to the examiner on its own.
- 07Checked
The count against MCAS, before the examiner compares them
Consistency checkerR-23 says 1,391 homeowners claims closed without payment in 2024; the MCAS filing says 1,427. The consistency checker finds why: 36 claims were reopened and closed again in 2024, and MCAS counts each closure. The 36 claim numbers go in the package. Elsewhere it finds a real contradiction — the complaint register is 7 short of the department’s count — and sends that one to counsel.
Never changes a number to make it agree.
- 0811:12 · 11:16
Counsel approves, the manager signs off
Daniel Ferro · Regulatory counselDaniel approves the three explanations at 11:12; Ifeoma Adeyemi, the market conduct manager, signs off the package at 11:16. Only then does Submit to the examiner light up. The package goes to Paul Okonkwo through the department’s exam portal: 79 claim files and 782 documents, a cover letter with 6 self-identified issues and 3 explanations, and the MCAS reconciliation of 36 claims.
- 0911:20 · 3 business days early
Submitted, and back to the list
Nora Lindqvist · Exam coordinatorNora submits R-23 at 11:20 on Monday, three business days before it is due. The request room now counts 35 submitted, with the agents’ run kept beside it, step by step.
- 10When a criticism lands
Agree, disagree or explain — said once, from the file
Daniel Ferro · Regulatory counselWhen the examiners write a criticism, it arrives with its draft response. C-03 says 3 of 50 complaints were answered to the department after 21 days. The draft agrees, explains the mailbox routing during a system change, cites the complaint files and procedure CH-01, and commits to a daily check of the department mailbox by 30 Nov 2026. Counsel approves every agree or disagree.