Expected instalments (repayment schedule) vs collected payments · debit-order & NAEDO breaks surfaced · runs on load
Anthony Apollis · Senior BI Developer FASTA FinTech Lending DW · Databricks + Fabric Governed reconciliation mart
🛡️
Automatic & governed — real data. Reconciles the realrepayment_schedule (6,247 instalments) against payments on load. Dirty source statuses (SUCCESS/success, Overdue/OVERDUE) are normalised in Silver first. Every break cites its schedule row, bank reference and NAEDO run — no invented matches.
Amount tolerance R🔍
Collections register (stratified sample of live results)
Status
Schedule
Loan
Due
Expected R
Collected R
Δ R
Method
AI Collections Agent
Reconciliation ran automatically on the real lending book. Select any row — especially a exception (failed debit order, reversal, missed instalment) or partial (short-paid) — for a plain-language explanation with full provenance.