MONEY SYSTEM OF PROOF
Payment reconciliation lab
Provider event ≠ allocation ≠ settlement. See duplicates, bad references, overpayments and bank/provider variance.
4
2
3
KSh 500
Provider → ledger → bills
Provider TxReferenceAmountStatus
RCP1001WP-100284KSh 1,240processedRCP1002BAD-REFKSh 2,100unmatchedRCP1001WP-100284KSh 1,240processedRCP1004WP-100500KSh 3,000processedAllocation journal
₭bill-sep-284KSh 1240 · acct-284
₭bill-aug-500KSh 900 · acct-500
₭bill-sep-500KSh 1600 · acct-500
Settlement comparison
Internal verified total versus provider settlement rows.
InternalKSh 4240
SettledKSh 4230
VarianceKSh -10
Exceptions
duplicate
Duplicate provider transaction retained for audit but not allocated twice.
unknown_reference
No account mapping for reference BAD-REF.
overpayment
Payment exceeds currently open bill balance; retain unapplied cash until policy/accounting action.
settlement_amount_mismatch
Internal KSh 3000 vs settlement KSh 2990.