What changed
Kentucky launched a public dashboard showing how opioid settlement money is spent (FACT, cited headlines). Public visibility flips reporting from a filing obligation into a reputational exposure: every county's numbers (or missing numbers) are now on display.
Why now
The dashboard just launched (multiple outlets, same week). Maryland has a parallel effort per the convergence framing (HYPOTHESIS — not evidenced in the provided sources). ~$50B in national settlement funds flow over 18 years, so the reporting burden recurs annually for a decade-plus; being early in state #1 positions for the 49-state replication.
Converging signals
Three signals meet: (1) settlement money already appropriated to KY locals, (2) a state commission that collects structured expenditure data, (3) a new public dashboard that makes each local government's reporting visible. Per the forced-filer rule, the mandate + filer class + collection point is itself the convergence.
Customer pain
HYPOTHESIS (the sources prove the dashboard, not the pain): a county treasurer must map local ledger entries to the commission's approved-use categories (Exhibit-E-style abatement strategies), attest compliance, and submit on the state's schedule — done today in spreadsheets by staff with no grant-accounting background, and now with public scrutiny of the result.
Who pays
KY local governments receiving settlement shares (~120 counties plus cities — figure is inference from the convergence, not the sources). Secondary buyers: the regional consultants/CPA firms who serve multiple counties, and eventually other states' locals.
Solved today
Manual spreadsheets against state-issued templates; some counties lean on their auditor/CPA or a consultant; the state supplies forms for free. FACT gap: no source in the input evidences anyone currently paying for a dedicated tool.
Why current solutions are bad
Categories are unfamiliar (abatement strategy taxonomies), data lives in general-ledger systems that don't map to them, staff turnover loses the mapping each year, and errors are now publicly visible on a state dashboard. Annual cadence means the pain recurs but is never severe enough to hire for — ideal for cheap software, bad for consultants.
Proposed product
A micro-SaaS: import a county's expenditure ledger (CSV/Excel), guided mapping to the KY commission's reporting categories, validation against approved uses, and one-click export in the exact submission format (plus a public-facing summary the county can publish). Per-jurisdiction annual subscription. State #2 is a config file, not a rebuild.
MVP version
Obtain KY's actual reporting template/portal spec (public records request or commission website), build the CSV-in → validated-submission-out flow for that one format, and hand-onboard 3 pilot counties. No integrations, no login for v1 beyond basic auth.
30-day build
Verify the mandate (this is the kill-or-proceed gate): pull the KYOAAC reporting requirement, template, and deadline; interview 5-8 county fiscal officers (KACo directory) on how they filed last cycle and what it cost them; capture Maryland's equivalent spec.
60-day build
Ship the KY MVP, run 3 pilots free-for-feedback, convert to paid at the next reporting cycle; publish a free 'KY opioid fund reporting checklist' as the lead magnet.
90-day revenue plan
Convert 10-20 KY jurisdictions at ~$1,000-1,500/yr (or $250/filing) = first ~$10-25K ARR; sign one multi-county CPA/consultant as a channel; start Maryland templates.
Distribution path
Direct outreach to county treasurers/judge-executives (public contact info), Kentucky Association of Counties and KY League of Cities newsletters/conferences, the consultants already advising counties on settlement spending, and SEO on 'KY opioid settlement reporting requirements'.
Pricing hypothesis
$995-1,495 per jurisdiction per year, or $249 per filing for small cities; consultant multi-county license at 5x. Low enough to sit under most local procurement thresholds (credit-card purchasable — HYPOTHESIS on threshold levels).
Technical difficulty
Low. File parsing, category mapping UI, validation rules, document/export generation. Solo-buildable in weeks with AI assistance; the hard asset is the accurate encoding of each state's rules, which is also the moat.
Legal / regulatory risk
Low. The tool formats data the customer submits; founder needs no license. Risk is mis-encoding a state's rules — mitigated by citing the state's own guidance in-product.
Platform dependency
None that can deplatform: the 'platform' is a state reporting process. Risk is the state changing its template (annual maintenance, also the recurring-revenue justification) or building a good free submission tool itself.
Founder fit
Very high. This is exactly the proven ELDT shape: mandate → defined filer class → submission layer → per-filing/per-seat fee. Public-records fluency helps him extract each state's spec; demonstrated-value selling matches small local-gov buyers. Matches the high-confidence lesson that government-portal mandate opportunities fit this founder best.
Breakout potential
Real but capped: 50 states × thousands of locals × 18 years of settlement payments, and the same engine generalizes to any state pass-through reporting (ARPA-style). Ceiling is a niche compliance SaaS, likely $0.5-3M ARR territory, not venture-scale — which fits the founder's constraints.
Final recommendation
PURSUE THE 30-DAY VALIDATION, NOT THE BUILD. The shape is the founder's proven wedge and the replication story is strong, but the load-bearing claim — that KY locals face a structured, recurring, painful submission — is inference. One week of public-records work and 5 treasurer interviews settles it. Build only if the filing is genuinely painful or error-exposed; otherwise archive the state-dashboard pattern and wait for a state that attaches penalties or clawbacks to reporting.
Next action
Today: pull the Kentucky Opioid Abatement Advisory Commission's local-government reporting requirement, template, and deadline from ky.gov (or file a records request), and email 5 county fiscal officers asking how they completed their last settlement expenditure report.