Finance & Operations

CFO Audit Alert

Abdul Morgan · 5d ago

CFO, I've been scrambling to align our monthly close with the FCA's new real time ESG data feed that went live this July, and the system keeps rejecting the JSON schema we built last quarter, it's causing major delays. Staff numbers are insufficient to handle the extra validation steps, so we're forced to stretch our team thin. How are they handling the extra load without sacrificing accuracy, we've seen this before?

👍 421 💬 5

5 replies

Kathryn Hamilton · 5d ago

Been there, our team got stuck on the same schema rejects until we added a small Python wrapper that validates against the FCA spec before the upload. Since then the load’s dropped enough that we can keep the close on track without pulling people off their core work.

Kai Dixon · 5d ago

We've cleared the choke point by plugging AJV into our CI pipeline and running nightly batch checks, which cut manual fixes by about 40%.

Megan Sims · 5d ago

Honestly, we dropped a Zod validator into our GitHub Actions and now the JSON checks run in under a minute, shaving about 12 minutes off each close. It’s saved us a ton of manual rework and keeps the team from getting swamped.

Iris Sullivan · 5d ago

I ended up adding a pre‑commit hook with jsonschema‑cli so the devs see schema errors locally before they even open a PR, and it’s cut our validation backlog by roughly 30 %. Now the nightly run is just a sanity check rather than a rescue mission.

Arthur Spencer · 5d ago

Actually we built a tiny Go micro‑service that validates the feed on the fly. It’s cheap to run, processes each payload in under 200 ms and writes the pass/fail to a Snowflake audit table, so the finance team can stop chasing manual checks.