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