Reconciliation
Run rr-0715 · 15 Jul 2026 · 06:00
Records compared
255
Matched
97.6%
249 records
Exceptions
6
need a human
Auto-resolved
2
timing only
| Reference | Provider | Platform | Provider amt | Delta | Exception | |
|---|---|---|---|---|---|---|
| MIX9001TZ | FriMi | LKR 20,735 | - none - | - | Missing at provider | |
| MPX8871TZ | eZ Cash (Dialog) | LKR 12,400 | LKR 12,800 | +LKR 400 | Amount mismatch | |
| AIR8802TZ | mCash | - none - | LKR 6,900 | - | Missing on platform | |
| MPX8790TZ | eZ Cash (Dialog) | LKR 9,200 | LKR 9,200 | 0 | Duplicate at provider | |
| AIR8997TZ | mCash | LKR -9,410 | LKR -9,000 | +LKR 410 | Refund mismatch | |
| VIS8712TZ | Visa / Mastercard | LKR 18,600 | - none - | - | Missing at provider |
Worst two, plainly
Not every exception is equal
MPX8790TZ - possible double debit
Two provider records for one capture. If it is real, a customer paid twice and has not told us. Do not wait for them to notice - confirm with the provider and refund proactively.
MIX9001TZ - energy delivered, never billed
LKR 20,735 of electricity left the charger and no payment was captured. That is revenue loss, not a customer problem - the customer did nothing wrong and should not be chased for it.
Run configuration
Schedule
Daily · 06:00 EAT
Match window
±48 hours
Amount tolerance
LKR 0
Auto-resolve
Timing differences only
Tolerance is deliberately zero. A tolerance of “a few hundred shillings” would have silently swallowed the MPX8871TZ mismatch, and small consistent gaps are exactly how integration bugs hide.