Bank Rec

Stop wrestling with spreadsheets during close. Bank Rec turns reconciliation into a repeatable workflow you can run in minutes. Start by setting up each bank account with its own rule set: match single checks one-to-one, pair voids with their original issues, link many bank lines to one book entry (or the reverse), and recognize mixed or alphanumeric references. Add your own custom rules when house conventions don’t fit standard patterns. Define amount and date tolerances, choose how to treat partials, and pick transaction type categories (ACH, wire, cash, checks, card) that guide how matches are scored.

On processing day, import your statement and your internal ledger extract, or paste from Excel if that’s your current flow. Launch auto-match and review the live results by account. Items are grouped into proposed matches with confidence indicators influenced by amount, date proximity, reference similarity, and type category alignment. Use quick filters to isolate exceptions—unapplied receipts, aging outstanding checks, duplicates, and timing differences. Approve all clean groups at once, drill into the edge cases, and lock the period when you are satisfied. The reconciliation summary is generated automatically and highlights open payments and deposits still in transit.

Complex patterns are handled without manual gymnastics. Combine multiple customer payments into a single bank deposit, split one book entry across several bank lines, or reconcile a void against its original issue in one click. If references include characters or prefixes, the alphanumeric matcher recognizes them; if not, add a user rule to normalize formats. Every confirmed group receives a unique ID, along with who matched it and when, so you can retrace any decision. Need to adjust a tolerance and rerun? Matches persist with full history, and changes are fully auditable.

When you’re done, export the reconciliation and supporting detail to PDF, PNG, or HTML for your close package. Share the audit trail with reviewers, or hand auditors the grouped evidence instead of handing over raw spreadsheets. Controllers migrating from Excel can mirror their legacy column layout on import, while AP teams focus on check clears and voids, e‑commerce ops verify daily card batches, and treasury tracks high-volume ACH and wires by type. User-defined classes let you tailor categorization to your environment, ensuring the engine prioritizes the right signals and delivers consistent, defensible results month after month.