Reconciliation is a matching problem first, a UI problem second
Get the matching rules right and the screens become simple.
Anish KumarFintech#reconciliation#fintech#product
A reconciliation tool compares two sets of records — a ledger and a bank statement, for example — and explains the differences. It's tempting to start with the screen. The hard part is the matching.
Matching usually runs in passes, from strictest to loosest:
- Exact match on reference number and amount.
- Amount + date window, for entries with missing or mistyped references.
- One-to-many, where one payment settles several invoices.
Whatever is left is the real work for the user. A good tool doesn't just show "unmatched" — it says why: amount differs by ₹120, date is outside the window, or no counterpart found.
Store which rule matched each pair. Auditors will ask.