Payment reconciliation engine
An automated reconciliation platform that matches thousands of daily transactions across payment providers, banks and ledgers, flagging only the exceptions for human review.
Client
NorthPay
Year
2024
Duration
7 weeks
Team
2 engineers + 1 designer
The challenge.
NorthPay's finance team spent 30+ hours every week manually matching settlements from four payment providers against bank statements and internal ledgers. Mismatches were caught late, reconciliation reports were built by hand, and month-end close took five days.
What we built.
We built a streaming reconciliation engine that ingests provider settlement files and bank feeds in real time, normalises them into a single ledger format, and runs deterministic + fuzzy matching rules. A dashboard shows unmatched transactions with context so operators can resolve them in a few clicks. Month-end reports are now generated automatically.
Results.
- ▸Manual reconciliation hours cut by 72% in the first month
- ▸Month-end close reduced from 5 days to under 8 hours
- ▸Exception queue now handles < 2% of total transaction volume
- ▸Zero data migration downtime; cutover ran in parallel for 2 weeks
They replaced a six-month internal backlog in seven weeks. The demo cadence kept everyone honest.
Rakib Hasan
CTO, NorthPay
Next project
Fleet tracking dashboard
