Every debt-review instalment reconciled: expected plan amount vs collected vs distributed to creditors · missed / short-paid exceptions · runs on load
Anthony Apollis · Senior BI Developer DebtBusters Intelligence Platform · Databricks Governed reconciliation mart
🛡️
Automatic & governed — real data. Reconciles the realpayments fact (1,500,000 debt-review instalments across 23 creditors) — each client's court-accepted plan amount vs what the PDA actually collected and distributed. Every break cites its creditor and PDA references; a payment counts as collected only from the real actual-amount field.
Creditor collection register🔍
Creditors (live aggregate of all 1.5M instalments)
Creditor
Type
Instalments
Collection %
Expected R
Collected R
Shortfall R
AI Collection Agent
Reconciliation ran automatically over all 1,500,000 instalments. Select any creditor — especially one with a low collection rate or large shortfall — for a plain-language explanation with full provenance and a recommended action.