Compliance Monitoring
Customer Master Data Integrity
Duplicate accounts, mis-flagged indigents and dormant consumers in the billing master corrupt the debtors book and subsidy reporting.
Why the billing master drives revenue assurance
The customer master is the foundation of municipal revenue: duplicate accounts inflate the debtors book, mis-flagged indigent accounts distort subsidy claims and equitable-share reporting, and dormant consumers mask meters that should be billing or disconnected. Poor master data is a root cause of the revenue-management findings the AGSA raises under the MFMA, and it directly undermines the credibility of the financial statements. AuditPro Core profiles the billing customer master for duplicates, indigent-flag integrity and dormancy so that revenue assurance starts from clean data rather than a corrupted base.
The Numbers
AuditPro Core renders this view from your tenant's live, tamper-evident records. The figures below are illustrative sample data.
Accounts profiled
1.82 m
Duplicate accounts
14 200
▼ 2 100
Unverified indigents
31 400
Missing ID link
6%
Master data defects by type
Data quality by municipality
| Municipality | Duplicates | Quality % |
|---|---|---|
| eThekwini | 4100 | 88 |
| Nelson Mandela Bay | 3200 | 81 |
| Emfuleni | 2600 | 73 |
Figures shown are illustrative sample data for demonstration. AuditPro Core renders these views from your own tenant's live, tamper-evident records.
Duplicate and merged accounts
The same consumer appearing as several accounts overstates debtors, splits payment history and frustrates credit control. De-duplication is a precondition for reliable revenue reporting.
Indigent-flag integrity
Indigent status drives subsidy and equitable-share claims. Accounts flagged indigent without a valid, current application — or genuine indigents not flagged — distort both relief and revenue.
Dormant and inactive consumers
An account showing no consumption may be a vacant property, a tampered meter or a billing error. Dormancy needs investigation, not silent acceptance, because it often hides lost revenue.
Master data as a control
Every downstream revenue control inherits the quality of the master. Cleaning and governing the master is therefore the highest-leverage revenue-assurance activity.
How AuditPro Core Bridges the Gap
- Duplicate detection: the platform identifies likely duplicate and split accounts for consolidation and credit-control accuracy.
- Indigent-flag testing: indigent flags are checked against valid current applications, exposing both unsupported flags and missed qualifiers.
- Dormancy analysis: zero-consumption and inactive accounts are surfaced for investigation rather than left silent.
- Traceability to source: each flagged account links to its billing record for resolution and audit evidence.
Key Takeaways
- Duplicate accounts overstate debtors and split payment history — consolidate them.
- Indigent flags must rest on valid current applications, both ways.
- Dormant accounts often hide lost revenue and need active investigation.
- Clean master data is the highest-leverage revenue-assurance control.
See This on Your Own Data
AuditPro Core renders this dashboard from your tenant's live, tamper-evident records — every figure traceable to source.