Close the Gap
Reconcile
Why two files disagree, traced row by row, to the penny.
Two sets of data that should agree and do not. It matches them, measures the gap, tests explanations against the actual rows, and bridges one total to the other.
More about Reconcile
Twelve detectors look for the ordinary causes (leading zeros, amounts in pence, a missing filter, duplicate rows, gross against net), each measured on your rows before you see it, and a model can propose more under the same test. On the motor example, taking 12% IPT off 518 premiums explains £36,312; on the annuity one, multiplying 57 incomes by 12 explains £136,727 of the difference. A model sees a profile of your columns, never your rows. Accept the causes you believe and it draws the bridge from one total to the other, with whatever is left standing in its own colour.
Every actuarial team reconciles, and the afternoon goes on hunting for the reason. Drop in two files and it pairs the columns, joins on the key and splits the difference by whatever you group on. Then twelve detectors look for the ordinary causes (leading zeros, amounts in pence, a missing filter, duplicate rows, gross against net), each applied to your rows and measured before you see it. A model can propose more under the same test, so on the worked example what you read is “multiplying these 57 annuity incomes by 12 explains £136,727 of the difference, and here they are”. Accept the ones you believe and it draws the bridge, with whatever is left standing in its own colour. Nothing is uploaded: a model sees a profile of your columns, never your rows.
- Runs in your browser, AI on a server
- Data
- Validation
- Automation









