RecMatch: Bank Reconciliation Exception Matcher

RecMatch: Bank Reconciliation Exception Matcher ships as a ready-to-import n8n automation package: load the bundled workflow JSON, connect the credentials listed on this page, and activate it on self-hosted n8n or n8n Cloud.

Stop hand-matching statement lines: this workflow reconciles your bank tab against your ledger tab every morning, files an audit trail of every pair, and emails you only the exceptions with a likely cause and next step.

• Match bank statement lines to ledger entries automatically on amount, date proximity, reference and description
• Tune the match yourself with an amount tolerance, a clearing-lag window in days, and a confidence-score floor
• Review only the exceptions — each one labelled in bank, not in ledger or in ledger, not in bank, with the closest near-miss shown
• Get an AI bookkeeper's likely cause and one concrete next step for every unmatched line
• File an audit-ready trail of every matched pair and every exception to its own sheet tab
• Never see the same line twice: reconciled lines are retired only after the audit row and the email both succeed
• Handle real-world statements — negative debits, bracketed amounts, day-first dates, and separate debit/credit columns