Deterministic checks find the gaps. AI helps people understand them.
Last quarter's revenue was $14.6 million. Or $14.2 million. Or $14.1 million. The ledger says one thing. The Lakehouse table feeding your BI says another. The dashboard the board looked at this morning says a third.
None of the three numbers is obviously wrong, and that is the problem. When the same metric lives in several systems, each with its own refresh schedule, transformations and quirks, the numbers drift apart. Reconciliation is the work of finding where they disagree and deciding which one, if any, you trust. Done by hand, it is slow, it misses things, and it scales badly as you add systems.
I split the job in two. Deterministic checks establish the facts: row counts, sums, join-key coverage. AI handles triage and explanation. It learns which differences are normal, ranks the ones that are not, and drafts a plain-language account of what probably happened. The checks give you the truth.…