How the roll-up 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
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.
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.
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.