Intsika Yethu

Revenue Reconciliation

Export Reports

Download reconciliation results as formatted Excel spreadsheets. Colour-coded by severity with auto-filter enabled.

Reconciliation Reports

Export discrepancy and summary reporting by scope or severity.

Full Reconciliation Report

All discrepancies from all comparisons

Critical Issues Only

Properties completely missing billing accounts

Deeds vs Valuation

Missing/mismatched valuation records

Valuation vs Billing

Market value mismatches and missing billing accounts

Deeds vs Billing

Wrong owners billed, unbilled properties, delayed activation

High-Priority Impact

High severity issues only

Uploaded Data Exports

Download the exact datasets currently stored after upload.

Uploaded Deeds Master

Export records from deeds_property_master

Uploaded Deeds Owner

Export records from deeds_property_owner_reference

Uploaded Deeds Owner History

Export records from deeds_property_owner_history_reference

Uploaded Deeds Titledeed

Export records from deeds_property_titledeed_reference

Uploaded Deeds Titledeed History

Export records from deeds_property_titledeed_history_reference

Uploaded Deeds Endorsement

Export records from deeds_property_endorsement_reference

Uploaded Deeds Endorsement History

Export records from deeds_property_endorsement_history_reference

Uploaded Valuation

Export records from valuation_records

Uploaded Billing

Export records from billing_records

About the Excel exports

  • Each export contains a Discrepancies sheet and a Summary sheet.
  • Rows are colour-coded: red = critical, orange = high, yellow = medium, green = low.
  • Auto-filter is enabled on all columns.
  • Estimated impact uses the stored value gap from each discrepancy.
  • For missing billing records in Valuation vs Billing, impact equals the valuation market value.