Smart Bank Reconciliation for ERPNext

Smart Bank Reconciliation is a proper Frappe app (its own module, DocTypes, and hooks.py) that ECOSIRE builds for your ERPNext instance to close exactly that gap. At its core is a reconciliation workspace DocType backed by a whitelisted server method that pulls candidate vouchers for each Bank Transaction and scores them with a fuzzy matcher — normalizing reference numbers, party names, and descriptions (token-set and Levenshtein-style ratios) and weighting amount, date proximity, and party to produce a 0-100 confidence score. High-confidence matches are auto-suggested; the bookkeeper confirms or rejects them in a two-pane, statement-vs-voucher view rather than hunting through lists. Where a matching voucher does not exist yet, a one-click action creates the correct Payment Entry or Journal Entry (with the right account, party, and cost center pre-filled) and reconciles it in the same step.

Technically it is built to be safe inside your existing chart of accounts and posting rules. Entry creation goes through Frappe's ORM and standard validation — no raw SQL writes — so GL impact, party ledgers, and dimensions stay correct. Statement ingestion supports CSV, OFX, and MT940 import mapped onto Bank Transaction, with configurable column/format profiles per bank. Bulk actions let you reconcile all high-confidence matches at once or split a single bank line across multiple vouchers (partial allocations that sum to the transaction amount). We wire doc_events in hooks.py and optional scheduler_events so imported transactions can be pre-scored in the background, and we expose the whitelisted matching/reconcile methods over the Frappe REST API for any automation you want on top. Access is governed by ERPNext permissions and role profiles — typically an Accounts User can reconcile while only Accounts Manager can create adjusting journals — and every action is captured in Frappe's standard audit trail.

Because this is build-to-order, nothing is a black box you download blind. After a short scoping call we confirm your banks, statement formats, matching rules, and permission model, then build against your ERPNext version (Frappe/ERPNext v15 or v16), test on a staging copy of your data, and hand over installable source plus the git repository. Typical delivery is 2-4 weeks from confirmed scope, and you get a post-go-live support window plus a documented upgrade path — not a fire-and-forget marketplace listing.