RedHub AIRedHub AI
Tool Gate · How it works

How the roll-up gate works

How the Two-List Reconciliation 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 — then a gate that can only make it worse.

The 6 rows

01INV-1001$1,200 = $1,200RECONCILED
02INV-1002within rounding toleranceRECONCILED
03INV-1003fix firstamount: $500 vs $545EXCEPTION
04INV-1004status: cleared vs pendingEXCEPTION
05INV-1005bank onlyORPHAN A
06INV-1007$1,500 = $1,500RECONCILED
RECONCILED
every row matches on both sides
EXCEPTIONS
a row disagrees or is one-sided
ORPHANED
unmatched rows on both sides
All-or-nothing · worsen-only

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.

EXCEPTIONS

Why: 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. 6 rows · 3 reconciled (one within tolerance) · 2 exceptions · 1 orphan · 50% clean.

Fix firstINV-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.

Half the rows tie cleanly — but reconciliation is all-or-nothing: one amount that disagrees or one row on only one side leaves money unaccounted for. The roll-up takes the worst row, the gate blocks RECONCILED regardless of the score, and it names the one row to fix first.