ReconBanker
Self-hosted bank-to-order reconciliation platform for financial operations teams.
April 2026 – Present
Open-source bank-to-order reconciliation platform for financial operations teams. Built with TypeScript, Node.js, Express, PostgreSQL, Redis/BullMQ, Playwright and React. It ingests bank transactions, polls customer order systems, matches payments through deterministic and heuristic rules, and notifies external systems through webhooks.
Problem
Finance operations teams reconcile incoming bank payments against customer orders by hand, exporting statements and cross-checking them in spreadsheets. The process is slow, error-prone, and leaves unmatched or duplicated payments undetected until they cause accounting and customer-facing problems.
Solution
ReconBanker automates the full pipeline: it ingests bank transactions through Playwright-powered scraping, polls customer order systems for the orders that should be paid, and runs a matching engine that pairs them using deterministic rules first and heuristic rules for the fuzzy cases. Matched, unmatched, and flagged results are exposed in a React dashboard, and external systems are notified in real time through outbound webhooks.
Outcome
Reconciliation that used to take hours of manual spreadsheet work now runs continuously and surfaces discrepancies within minutes. Downstream systems react automatically through webhooks, and the self-hosted model keeps bank credentials inside the team's own infrastructure.
Learnings
Matching real payments means handling messiness: partial amounts, timing gaps between banks and order systems, and inconsistent references. Separating deterministic rules from heuristic ones kept the engine predictable while still catching the hard cases, and made it easy to add new banks and order sources without breaking existing matches.