Bank Reconciliation

How Bank Reconciliation Works

Reconcile multiple bank statements against your accounting ledger with automated transaction matching and deterministic balance verification.

• Multi-Pass Transaction Matching: Runs multi-pass matching — starting with exact 1:1 references and amounts, followed by grouped 1:N & N:1 batch deposits or split payments, and date-proximity fuzzy matching.
• Deterministic Balance Verification: Verifies statement opening and closing balances against transaction movement (Opening + Credits − Debits = Closing). Groups statements by account and flags missing period gaps.
• Multi-File & Multi-Tab Support: Upload multiple bank statements and accounting ledgers in Excel (.xlsx, .xls) or CSV. Automatically identifies transaction worksheets and filters non-transaction summary rows.
• Categorized Exception Detection: Isolates unmatched bank items, unrecorded ledger entries, timing differences, amount variances, bank fees, and interest for streamlined month-end review.
• Audit-Ready Excel Report: Generates a downloadable multi-sheet Excel workbook with a Summary Dashboard, Bank Statement Summary, Reconciled Transactions, Grouped Matches, and Exceptions.