Tool Gate · How it works
How the Two-List Reconciliation gate works
How the Two-List Reconciliation gate matches a bank against a ledger, key by key: each row rolled up to the worst, with an all-or-nothing gate where one disagreeing or unmatched row blocks RECONCILED — which is how a batch that's 50% clean still reads EXCEPTIONS, because reconciliation is all-or-nothing, not a percentage.
How the gate works
This tool grades two lists — a bank vs a ledger — key by key. It reads 6 rows and rolls them into one verdict — the worst, never the average — and then a gate that can only make it worse.
The 6 rows
| Row | Verdict |
|---|---|
| INV-1001 | RECONCILED$1,200 = $1,200 |
| INV-1002 | RECONCILEDwithin rounding tolerance |
| INV-1003fix first | EXCEPTIONamount: $500 vs $545 |
| INV-1004 | EXCEPTIONstatus: cleared vs pending |
| INV-1005 | ORPHAN Abank only |
| INV-1007 | RECONCILED$1,500 = $1,500 |
The verdict bands
One disagreeing or unmatched row blocks RECONCILED regardless of how many rows tie. Reconciliation releases only when nothing is left unaccounted for — 95% reconciled is still not reconciled.
In the worked sample it reads EXCEPTIONS — Three of six rows reconcile — 50% clean, and it looks close. But INV-1003's amount disagrees ($500 vs $545), INV-1004's status disagrees (cleared vs pending), and INV-1005 is on the bank only. One disagreeing or unmatched row blocks RECONCILED, so the batch is EXCEPTIONS: reconciliation is all-or-nothing, not a percentage. The one thing to fix first: INV-1003 — the amount disagrees ($500 on the ledger vs $545 on the bank). Reconcile it (plus INV-1004's status and the orphaned INV-1005) before the batch can read RECONCILED..
Common questions
Can every row look survivable on the How the Two-List Reconciliation gate works and the company still read EXCEPTIONS?
Yes. The roll-up takes the worst of 6 rows — never the average — then a worsen-only gate, the All-or-nothing gate, escalates when trouble clusters. In the worked sample it reads EXCEPTIONS because three of six rows reconcile — 50% clean, and it looks close. But INV-1003's amount disagrees ($500 vs $545), INV-1004's status disagrees (cleared vs pending), and INV-1005 is on the bank only. One disagreeing or unmatched row blocks RECONCILED, so the batch is EXCEPTIONS: reconciliation is all-or-nothing, not a percentage.
What is a worsen-only gate?
A dispositive rule that can only lower a verdict, never raise it. One fatal flaw overrides an otherwise-set of survivable lines, because a single disqualifying gap shouldn't hide behind an average of the healthy ones. The tool also names the one thing to fix first — here, "INV-1003 — the amount disagrees ($500 on the ledger vs $545 on the bank). Reconcile it (plus INV-1004's status and the orphaned INV-1005) before the batch can read RECONCILED.".
Your own two lists, matched offline with a rounding tolerance you set. Not accounting advice.
Embed this diagram
Free to share and embed with attribution (CC BY 4.0) — keep the link to redhub.ai.
Interactive — renders the live diagram
<iframe src="https://redhub.ai/visuals/tool/two-list-reconciliation-kit.html" title="How the Two-List Reconciliation gate works — RedHub AI" width="760" height="1708" loading="lazy" style="border:0;width:100%;max-width:760px"></iframe>
<p style="font:14px/1.5 system-ui,sans-serif"><a href="https://redhub.ai/visuals/tool/two-list-reconciliation-kit">How the Two-List Reconciliation gate works</a> — by <a href="https://redhub.ai">RedHub AI</a>, the AI that tells you when to doubt it.</p>Image + link — a static picture for any blog
<a href="https://redhub.ai/visuals/tool/two-list-reconciliation-kit"><img src="https://redhub.ai/visuals/tool/two-list-reconciliation-kit-share.png" alt="Diagram of the Two-List Reconciliation gate: six rows rolled up to the worst, an all-or-nothing gate, and a 50%-clean batch reading EXCEPTIONS because two rows disagree and one is one-sided." width="760" loading="lazy" style="max-width:100%;height:auto;border-radius:16px"></a>
<p style="font:14px/1.5 system-ui,sans-serif"><a href="https://redhub.ai">RedHub AI</a> — the AI that tells you when to doubt it.</p>
This is how Two-List Reconciliation Kit works. More diagrams in the Visual Field Guide.