- Before
- Spends half her week chasing records by email and re-keying payroll registers.
- Now
- Opens each audit with the records in, the payroll tied and the class questions already raised; she decides and signs.
One audit, from the first notice to a signed bill
Brightwater Framing & Carpentry, Knoxville, Tennessee: workers’ compensation and general liability with Kestrel Ridge Mutual, policy year 1 Jul 2025 – 1 Jul 2026, experience mod 0.94, virtual audit. Day 103 of 120 since expiration. Here is the audit, screen by screen, in the working solution.
- 01Monday morning
Fourteen open audits, sorted by what they need
Renata Okafor · Senior premium auditorRenata’s worklist shows 14 open audits from policies that expired June to October: 7 waiting on records, 2 to reconcile, 3 ready to sign, 1 waiting on her decision and 1 past 120 days with a site visit booked. Brightwater Framing has all 19 of 19 records in, and findings to decide.
“Two attempts logged · your decision” — Nolichucky Tree Service, where only Renata can decide on the noncompliance charge.
- 022 Jul – 9 Oct
Every record chased, every reply on the file
Record requesterThe audit notice went out on 2 July with the 11 records needed. Reminders on 16 July and 30 July were logged as documented attempts 1 and 2, each naming the records still missing and the charge. Then the targeted asks: the timecards again with job numbers, page 2 of the Q2 2026 Form 941, three missing certificates, and Megan Shore’s 46 “yard” hours. Tammy Lindqvist answered the last one on 9 October.
“All records arrived; no charge applies. Only a person can apply one.”
- 0307:13
The register tied to the 941s, to the penny
Payroll register reader47 employees and 1,224 pay lines read. Line 2 of each Form 941, Q3 2025 to Q2 2026, against the register’s gross wages: $3,548,200 on both sides, $0.00 apart. The $61,800 of overtime premium is shown separately on the register and Tennessee allows the exclusion, so reportable payroll is $3,486,400. Eight checks passed, from headcount to officers.
Never changes the insured’s figures — it reports the difference, with page and line.
- 04On the board
Payroll by class code, estimated against audited
Renata Okafor · Senior premium auditorOne column per class code — 5403 Carpentry NOC, 5645 Residential carpentry, 5437 Trim and cabinets, 5445 Wallboard, 5606 Executive supervisor, 8810 Clerical office, 8742 Outside sales — each with its rate, a twin bar and payroll blocks by job title. The deposit was $257,490 on $3,005,000 of estimated payroll. As the insured coded it, the audit stands at $287,368: +$29,878. One block in 8810 glows amber: “Title says field”.
- 0507:16
Three “clerical” employees whose titles say field work
Job title classifierDustin Mercer, Lead carpenter, $78,400. Kyle Brandt, Framing foreman, $74,200. Jorge Villanueva, Carpenter II, $57,400. All reported in 8810, with 93%, 91% and 89% of their hours on job numbers and overtime on site days — and the 2024–25 audit already noted it. 8810 needs exclusively clerical work in a separate office, and cannot be split. The classifier suggests 5403 at confidence 0.94.
It suggests; it never moves payroll — the auditor does.
- 06One drag
$210,000 moved from clerical to carpentry
Renata Okafor · Senior premium auditorRenata drags the block from 8810 at $0.21 into 5403 at $9.84. Every bar, both column totals and the premium band recount at once: workers’ compensation +$19,009, general liability +$2,646, because clerical payroll is not rated for GL and carpentry is. The move is logged with her name and the reason, and can be undone until she signs.
“$210,000 moved 8810 → 5403 · additional premium now +$51,533”
- 0707:18
One subcontractor paid while uninsured
Subcontractor certificate checkerFourteen subcontractors, 57 payments, each matched to a certificate in force on the payment date. Thirteen were covered every time; Big Ridge Painting is a sole proprietor with a verified state exemption. Ridgecrest Drywall & Trim’s certificate ran 15 Feb 2025 – 14 Feb 2026 and was renewed 5 May 2026. In between, Brightwater paid it $148,000 on 7 invoices, $96,000 of it labor.
Never treats an expired certificate as current; when labor is not shown, it flags the whole price.
- 08All decided
Uninsured labor added; one question closed with no change
Renata Okafor · Senior premium auditorRenata adds Ridgecrest’s $96,000 of labor to 5445 Wallboard installation and the $148,000 cost to general liability: workers’ compensation +$7,580, GL +$1,450. Megan Shore stays in 8810 — the insured’s reply says she logged deliveries from the front-office window and never went into the yard, and the reply is on file. Additional premium: +$60,563.
- 0907:20 · drafted
The audit report, every change explained
Premium calculator and report drafterWorkers’ compensation by class after the 0.94 mod, general liability by class and basis, and one plain line per change with its citation: +$29,878 for payroll above the estimate, +$21,655 for the three employees moved to 5403, +$9,030 for the uninsured subcontractor, $0 for Megan Shore. The letter to Ms. Lindqvist explains each change in plain words.
“Draft prepared 07:20 · not a signature.”
- 10Signed
She signs; above $25,000 her manager co-signs
Renata Okafor · then Douglas WhitfieldAudited premium $318,053 against the $257,490 deposit. Renata signs and the moves lock. Because +$60,563 is above her $25,000 limit, the audit routes to Douglas Whitfield, premium audit manager, for the second signature. Marcus Bell in billing invoices only signed audits, and Priya Raman, the underwriter, gets the audited class mix for the May renewal.
“Signed by Renata Okafor · moves are now locked”