Reporting
A thousand filings a year, off undocumented spreadsheets
AI-built
AI reads the legacy workbooks and writes down their logic; what ships is governed, auditable code. 80%+ less manual effort in the proof of concept.
The engagement: existing, as built, in production
Existing
The challenge
Group finance prepares around a thousand statutory and regulatory filings a year across 50+ jurisdictions, mostly on hundreds of interconnected spreadsheet workbooks. The numbers are trusted, but the logic is undocumented and hard to trace, each cycle takes heavy manual effort, and owners, deputies and overdue filings were tracked by hand across every legal entity.
As built
What we built
- Spreadsheet reverse-engineering: AI analyses the legacy workbooks and documents the business logic in plain language for the business to validate
- AI used to harmonise data in every format, wire the pipelines and validate the logic; what ships is deterministic, auditable, reproducible Python and R
- A global filing tracker covering owners, deputies, delegation, escalation and audit events across all legal entities
In production
The impact
- 80%+ less manual effort in the proof of concept, turning weeks of work into hours
- Undocumented spreadsheets became governed digital assets with full traceability
- One governed blueprint that applies to around a thousand filings in 50+ jurisdictions
80%+
less manual effort in the proof of concept
Existing
The challenge
Group finance prepares around a thousand statutory and regulatory filings a year across 50+ jurisdictions, mostly on hundreds of interconnected spreadsheet workbooks. The numbers are trusted, but the logic is undocumented and hard to trace, each cycle takes heavy manual effort, and owners, deputies and overdue filings were tracked by hand across every legal entity.
As built
What we built
- Spreadsheet reverse-engineering: AI analyses the legacy workbooks and documents the business logic in plain language for the business to validate
- AI used to harmonise data in every format, wire the pipelines and validate the logic; what ships is deterministic, auditable, reproducible Python and R
- A global filing tracker covering owners, deputies, delegation, escalation and audit events across all legal entities
In production
The impact
- 80%+ less manual effort in the proof of concept, turning weeks of work into hours
- Undocumented spreadsheets became governed digital assets with full traceability
- One governed blueprint that applies to around a thousand filings in 50+ jurisdictions
80%+
less manual effort in the proof of concept
The same problem elsewhere
The same approach applies to any reporting that runs on inherited workbooks nobody fully understands: statutory returns, tax packs, safety reports, grant reporting.
- Insurance & reinsurance
- Statutory and regulatory filings across entities and jurisdictions, each with its own workbook chain.
- Banking & capital markets
- Regulatory returns assembled from spreadsheets whose logic left with the people who built them.
- Energy & utilities
- Regulatory and environmental returns per jurisdiction, prepared on inherited workbooks.
- Public sector
- Statutory reporting across agencies where the method lives in a few spreadsheets.
Bring us the version of this you are living
Every engagement here started as somebody’s stuck programme. Tell us where yours stands.
contact@ainurinsights.com