{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":8020435.0,"national_conditional_grants":252239.0},"ORGB":{"equitable_share":91546000.0,"national_conditional_grants":146251000.0},"SCHD":{"national_conditional_grants":117351000.0},"TRFR":{"national_conditional_grants":29911000.0}},"2022":{"ACT":{"national_conditional_grants":26601604.0},"ORGB":{"equitable_share":95002000.0,"national_conditional_grants":91037000.0},"SCHD":{"national_conditional_grants":113939000.0},"TRFR":{"national_conditional_grants":86169000.0}},"2023":{"ACT":{"national_conditional_grants":96038469.0},"ORGB":{"equitable_share":106741000.0,"provincial_transfers":3000000.0,"national_conditional_grants":148166000.0},"SCHD":{"national_conditional_grants":158530000.0},"TRFR":{"national_conditional_grants":71545000.0}},"2024":{"ACT":{"national_conditional_grants":62223197.0},"ORGB":{"equitable_share":116595000.0,"national_conditional_grants":135992000.0},"SCHD":{"national_conditional_grants":89708000.0},"TRFR":{"national_conditional_grants":61310000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":8020435.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":91546000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":95002000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":106741000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":116595000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":3000000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023}]},"national_conditional_grants":{"2021":[{"amount.sum":268000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":268000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":245220.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":3000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":3000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":7800000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":7800000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":7019.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":24946000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":8884000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":600000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":20000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":10000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1033000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":259000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":36904000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":15000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":7500000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021}],"2022":[{"amount.sum":1185944.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":3000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":3000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":863000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":5237814.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":25475000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":25475000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":9129601.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":26323000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":26323000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":165000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":258000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":5721069.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":20000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":20000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1113000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1113000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":27000000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1128743.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":4198433.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":10000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":10000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":2786655.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":3000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":3000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":32342000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":197871.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":7425000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":7425000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":28280438.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":28183000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":28183000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":16954015.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":26864000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":26864000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1073000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1073000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":54643000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":41271533.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":6547957.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":5000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":5000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":1311688.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":3000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":3000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":25398000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":23336092.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":16700000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":16700000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":27331003.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":27331000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":27331000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":2544413.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":6579000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":6579000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":950000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":950000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":950000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":3000000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":6750001.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":6750000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":6750000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024}]}},"cash_balance":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"good","result":507995340.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":492052456.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":341140726.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":17696317.0,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"}]},"result_type":"R"},"cash_coverage":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"good","result":6.5,"cube_version":"v2"},{"date":2023,"rating":"good","result":7.1,"cube_version":"v2"},{"date":2022,"rating":"good","result":4.8,"cube_version":"v2"},{"date":2021,"rating":"bad","result":0.3,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end / Operating Expenditure per month","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"},"/","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"/","12",")"]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end / Operating Expenditure per month","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"},"/","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"/","12",")"]},"result_type":"months"},"current_ratio":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"year":2024,"assets":312509730.0,"rating":"bad","result":0.92,"amount_type":"AUDA","liabilities":341221651.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":219115340.0,"rating":"bad","result":0.77,"amount_type":"AUDA","liabilities":283054099.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":137919904.0,"rating":"bad","result":0.59,"amount_type":"AUDA","liabilities":235646918.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":127327026.0,"rating":"bad","result":0.64,"amount_type":"AUDA","liabilities":198179702.0,"cube_version":"v2"}],"formula":{"text":"= Current Assets / Current Liabilities","actual":["=",{"cube":"bsheet","item_codes":["2150"],"amount_type":"AUDA"},"/",{"cube":"bsheet","item_codes":["1600"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= Current Assets / Current Liabilities","actual":["=",{"cube":"financial_position_v2","item_codes":["0120","0125","0130","0140","0150","0160","0170","0180"],"amount_type":"AUDA"},"/",{"cube":"financial_position_v2","item_codes":["0330","0340","0350","0360","0370","0380","0390","0400","0410","0420"],"amount_type":"AUDA"}]},"result_type":"ratio"},"liquidity_ratio":{"ref":{"url":"http://mfma.treasury.gov.za/RegulationsandGazettes/Municipal%20Budget%20and%20Reporting%20Regulations/Pages/default.aspx","title":"Municipal Budget and Reporting Regulations"},"values":[{"cash":48574089.0,"date":"2024","year":2024,"rating":"bad","result":0.14,"amount_type":"ACT","liabilities":341221651.0,"cube_version":"v2","call_investment_deposits":0},{"cash":32994573.0,"date":"2023","year":2023,"rating":"bad","result":0.12,"amount_type":"ACT","liabilities":283054099.0,"cube_version":"v2","call_investment_deposits":0},{"cash":14319586.0,"date":"2022","year":2022,"rating":"bad","result":0.06,"amount_type":"ACT","liabilities":235646918.0,"cube_version":"v2","call_investment_deposits":0},{"cash":26724373.0,"date":"2021","year":2021,"rating":"bad","result":0.13,"amount_type":"ACT","liabilities":198179702.0,"cube_version":"v2","call_investment_deposits":0}],"formula":{"text":"= (Cash + Call Investment Deposits) / Current Liabilities","actual":["=",{"cube":"bsheet","item_codes":["1800","2200"],"amount_type":"AUDA"},"/",{"cube":"bsheet","item_codes":["1600"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= (Cash + Call Investment Deposits) / Current Liabilities","actual":["=",{"cube":"financial_position_v2","item_codes":["0120","0125"],"amount_type":"AUDA"},"/",{"cube":"financial_position_v2","item_codes":["0330","0340","0350","0360","0370","0380","0390","0400","0410","0420"],"amount_type":"AUDA"}]},"result_type":"ratio"},"revenue_sources":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"year":2024,"local":{"amount":815896418.0,"percent":85.03},"total":959490200.0,"rating":"good","formula":{"text":"= Total revenue","actual":["=",{"cube":"incexp","item_codes":["0200","0300","0400","0700","0800","1000","1100","1300","1400","1500","1700","1800","1600","1610"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Total revenue","actual":["=",{"cube":"incexp_v2","item_codes":["0200","0300","0400","0500","0600","0700","0800","0900","1000","1100","1200","1300","1400","1500","1550","1570","1590","1600","1700","1800","1900","2000","2100","2300","2400","2500","2600","2700","2800","2200"],"amount_type":"AUDA"}]},"government":{"amount":143593782.0,"percent":14.97}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":3.96,"cube_version":"v2"},{"date":2023,"rating":"bad","result":1.57,"cube_version":"v2"},{"date":2022,"rating":"bad","result":9.09,"cube_version":"v2"},{"date":2021,"rating":"bad","result":6.95,"cube_version":"v2"}],"formula":{"text":"= (Unauthorised, Irregular, Fruitless and Wasteful Expenditure / Actual Operating Expenditure) * 100","actual":["=","(",{"cube":"uifwexp","item_codes":["irregular","fruitless","unauthorised"]},"/",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= (Unauthorised, Irregular, Fruitless and Wasteful Expenditure / Actual Operating Expenditure) * 100","actual":["=","(",{"cube":"uifwexp","item_codes":["irregular","fruitless","unauthorised"]},"/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},")","*","100"]},"result_type":"%"},"income_adjustments":{"2021":[{"item":"Fines","amount":10494.0,"comparison":"Original to adjusted budget","percent_changed":0.16},{"item":"Fines","amount":-1059279.0,"comparison":"Original budget to audited outcome","percent_changed":-16.51},{"item":"Government Transfers","amount":1681766.0,"comparison":"Original to adjusted budget","percent_changed":1.54},{"item":"Government Transfers","amount":7655850.0,"comparison":"Original budget to audited outcome","percent_changed":6.99},{"item":"Interest and investments","amount":1137371.0,"comparison":"Original to adjusted budget","percent_changed":16.6},{"item":"Interest and investments","amount":1098421.0,"comparison":"Original budget to audited outcome","percent_changed":16.04},{"item":"Licenses and Permits","amount":-38173.0,"comparison":"Original to adjusted budget","percent_changed":-3.24},{"item":"Licenses and Permits","amount":1204279.0,"comparison":"Original budget to audited outcome","percent_changed":102.27},{"item":"Other","amount":13866932.0,"comparison":"Original to adjusted budget","percent_changed":23.84},{"item":"Other","amount":18441689.0,"comparison":"Original budget to audited outcome","percent_changed":31.7},{"item":"Property rates","amount":2586590.0,"comparison":"Original to adjusted budget","percent_changed":2.3},{"item":"Property rates","amount":245840.0,"comparison":"Original budget to audited outcome","percent_changed":0.22},{"item":"Rental income","amount":-1841590.0,"comparison":"Original to adjusted budget","percent_changed":-29.56},{"item":"Rental income","amount":-1247081.0,"comparison":"Original budget to audited outcome","percent_changed":-20.02},{"item":"Service Charges","amount":-32874309.0,"comparison":"Original to adjusted budget","percent_changed":-6.52},{"item":"Service Charges","amount":-46220305.0,"comparison":"Original budget to audited outcome","percent_changed":-9.17}],"2022":[{"item":"Fines","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Fines","amount":-2845715.0,"comparison":"Original budget to audited outcome","percent_changed":-44.17},{"item":"Government Transfers","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Government Transfers","amount":3043925.0,"comparison":"Original budget to audited outcome","percent_changed":2.61},{"item":"Interest and investments","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Interest and investments","amount":-1853491.0,"comparison":"Original budget to audited outcome","percent_changed":-23.21},{"item":"Licenses and Permits","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Licenses and Permits","amount":-166640.0,"comparison":"Original budget to audited outcome","percent_changed":-7.91},{"item":"Other","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Other","amount":-6658072.0,"comparison":"Original budget to audited outcome","percent_changed":-5.11},{"item":"Property rates","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Property rates","amount":3496280.0,"comparison":"Original budget to audited outcome","percent_changed":2.92},{"item":"Rental income","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Rental income","amount":-67482.0,"comparison":"Original budget to audited outcome","percent_changed":-1.19},{"item":"Service Charges","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Service Charges","amount":-33507124.0,"comparison":"Original budget to audited outcome","percent_changed":-6.38}],"2023":[{"item":"Fines","amount":-289294.0,"comparison":"Original to adjusted budget","percent_changed":-6.82},{"item":"Fines","amount":-460834.0,"comparison":"Original budget to audited outcome","percent_changed":-10.87},{"item":"Government Transfers","amount":799199.0,"comparison":"Original to adjusted budget","percent_changed":0.62},{"item":"Government Transfers","amount":-1157572.0,"comparison":"Original budget to audited outcome","percent_changed":-0.9},{"item":"Interest and investments","amount":3297182.0,"comparison":"Original to adjusted budget","percent_changed":47.07},{"item":"Interest and investments","amount":5018129.0,"comparison":"Original budget to audited outcome","percent_changed":71.64},{"item":"Licenses and Permits","amount":-2855208.0,"comparison":"Original to adjusted budget","percent_changed":-61.39},{"item":"Licenses and Permits","amount":-2856365.0,"comparison":"Original budget to audited outcome","percent_changed":-61.41},{"item":"Other","amount":-31320294.0,"comparison":"Original to adjusted budget","percent_changed":-22.1},{"item":"Other","amount":-107537451.0,"comparison":"Original budget to audited outcome","percent_changed":-75.88},{"item":"Property rates","amount":3121243.0,"comparison":"Original to adjusted budget","percent_changed":2.45},{"item":"Property rates","amount":4872444.0,"comparison":"Original budget to audited outcome","percent_changed":3.82},{"item":"Rental income","amount":49327.0,"comparison":"Original to adjusted budget","percent_changed":0.77},{"item":"Rental income","amount":543469.0,"comparison":"Original budget to audited outcome","percent_changed":8.44},{"item":"Service Charges","amount":-31164224.0,"comparison":"Original to adjusted budget","percent_changed":-5.75},{"item":"Service Charges","amount":-48267013.0,"comparison":"Original budget to audited outcome","percent_changed":-8.91}],"2024":[{"item":"Fines","amount":1065655.0,"comparison":"Original to adjusted budget","percent_changed":22.75},{"item":"Fines","amount":477052.0,"comparison":"Original budget to audited outcome","percent_changed":10.19},{"item":"Government Transfers","amount":-5284478.0,"comparison":"Original to adjusted budget","percent_changed":-3.82},{"item":"Government Transfers","amount":5160174.0,"comparison":"Original budget to audited outcome","percent_changed":3.73},{"item":"Interest and investments","amount":18550000.0,"comparison":"Original to adjusted budget","percent_changed":172.56},{"item":"Interest and investments","amount":9896905.0,"comparison":"Original budget to audited outcome","percent_changed":92.06},{"item":"Licenses and Permits","amount":73637.0,"comparison":"Original to adjusted budget","percent_changed":3.9},{"item":"Licenses and Permits","amount":-5144.0,"comparison":"Original budget to audited outcome","percent_changed":-0.27},{"item":"Other","amount":905350.0,"comparison":"Original to adjusted budget","percent_changed":0.87},{"item":"Other","amount":-39771466.0,"comparison":"Original budget to audited outcome","percent_changed":-38.32},{"item":"Property rates","amount":1198011.0,"comparison":"Original to adjusted budget","percent_changed":0.86},{"item":"Property rates","amount":5587377.0,"comparison":"Original budget to audited outcome","percent_changed":4.03},{"item":"Rental income","amount":-1776359.0,"comparison":"Original to adjusted budget","percent_changed":-23.46},{"item":"Rental income","amount":-512329.0,"comparison":"Original budget to audited outcome","percent_changed":-6.77},{"item":"Service Charges","amount":-21502356.0,"comparison":"Original to adjusted budget","percent_changed":-3.75},{"item":"Service Charges","amount":-152365.0,"comparison":"Original budget to audited outcome","percent_changed":-0.03}]},"income_time_series":[{"amount":789395305.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":904510414.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":972039456.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":784985638.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":875220554.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":813027290.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":959490200.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":1022491680.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":1083169569.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":1175718947.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":804866224.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":913778873.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":962872483.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":978809996.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":1008785316.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":-5500000.0,"comparison":"Original to adjusted budget","percent_changed":-2.46},{"item":"Bulk purchases","amount":-29083236.0,"comparison":"Original budget to audited outcome","percent_changed":-12.98},{"item":"Contracted services","amount":-4391534.0,"comparison":"Original to adjusted budget","percent_changed":-13.36},{"item":"Contracted services","amount":-13853373.0,"comparison":"Original budget to audited outcome","percent_changed":-42.16},{"item":"Employee related costs","amount":-7947748.0,"comparison":"Original to adjusted budget","percent_changed":-2.42},{"item":"Employee related costs","amount":20326821.0,"comparison":"Original budget to audited outcome","percent_changed":6.18},{"item":"Finance charges","amount":-80818.0,"comparison":"Original to adjusted budget","percent_changed":-0.7},{"item":"Finance charges","amount":-1089428.0,"comparison":"Original budget to audited outcome","percent_changed":-9.43},{"item":"Other","amount":-6811909.0,"comparison":"Original to adjusted budget","percent_changed":-3.26},{"item":"Other","amount":-6337813.0,"comparison":"Original budget to audited outcome","percent_changed":-3.04},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-959308.0,"comparison":"Original budget to audited outcome","percent_changed":-7.65},{"item":"Transfers and subsidies","amount":-339630.0,"comparison":"Original to adjusted budget","percent_changed":-28.11},{"item":"Transfers and subsidies","amount":-604128.0,"comparison":"Original budget to audited outcome","percent_changed":-50.01}],"2022":[{"item":"Bulk purchases","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Bulk purchases","amount":-1819598.0,"comparison":"Original budget to audited outcome","percent_changed":-0.73},{"item":"Contracted services","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Contracted services","amount":-9601613.0,"comparison":"Original budget to audited outcome","percent_changed":-31.95},{"item":"Employee related costs","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Employee related costs","amount":-18154223.0,"comparison":"Original budget to audited outcome","percent_changed":-5.07},{"item":"Finance charges","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Finance charges","amount":-511028.0,"comparison":"Original budget to audited outcome","percent_changed":-4.26},{"item":"Other","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Other","amount":13234617.0,"comparison":"Original budget to audited outcome","percent_changed":6.14},{"item":"Remuneration of councillors","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Remuneration of councillors","amount":-910230.0,"comparison":"Original budget to audited outcome","percent_changed":-6.91},{"item":"Transfers and subsidies","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Transfers and subsidies","amount":-433735.0,"comparison":"Original budget to audited outcome","percent_changed":-49.01}],"2023":[{"item":"Bulk purchases","amount":998.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-14656626.0,"comparison":"Original budget to audited outcome","percent_changed":-5.74},{"item":"Contracted services","amount":-8000657.0,"comparison":"Original to adjusted budget","percent_changed":-22.0},{"item":"Contracted services","amount":-17769975.0,"comparison":"Original budget to audited outcome","percent_changed":-48.86},{"item":"Employee related costs","amount":-17270034.0,"comparison":"Original to adjusted budget","percent_changed":-4.83},{"item":"Employee related costs","amount":-34886836.0,"comparison":"Original budget to audited outcome","percent_changed":-9.75},{"item":"Finance charges","amount":1922098.0,"comparison":"Original to adjusted budget","percent_changed":15.33},{"item":"Finance charges","amount":9904145.0,"comparison":"Original budget to audited outcome","percent_changed":78.97},{"item":"Other","amount":14182475.0,"comparison":"Original to adjusted budget","percent_changed":6.46},{"item":"Other","amount":-11691002.0,"comparison":"Original budget to audited outcome","percent_changed":-5.33},{"item":"Remuneration of councillors","amount":-122876.0,"comparison":"Original to adjusted budget","percent_changed":-0.93},{"item":"Remuneration of councillors","amount":-521718.0,"comparison":"Original budget to audited outcome","percent_changed":-3.96},{"item":"Transfers and subsidies","amount":-683000.0,"comparison":"Original to adjusted budget","percent_changed":-35.8},{"item":"Transfers and subsidies","amount":-913830.0,"comparison":"Original budget to audited outcome","percent_changed":-47.89}],"2024":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-11369274.0,"comparison":"Original budget to audited outcome","percent_changed":-3.8},{"item":"Contracted services","amount":-3011085.0,"comparison":"Original to adjusted budget","percent_changed":-10.45},{"item":"Contracted services","amount":-10748111.0,"comparison":"Original budget to audited outcome","percent_changed":-37.32},{"item":"Employee related costs","amount":-10297611.0,"comparison":"Original to adjusted budget","percent_changed":-2.8},{"item":"Employee related costs","amount":-20231225.0,"comparison":"Original budget to audited outcome","percent_changed":-5.49},{"item":"Finance charges","amount":6834374.0,"comparison":"Original to adjusted budget","percent_changed":54.76},{"item":"Finance charges","amount":12015042.0,"comparison":"Original budget to audited outcome","percent_changed":96.27},{"item":"Other","amount":14014840.0,"comparison":"Original to adjusted budget","percent_changed":5.79},{"item":"Other","amount":9100935.0,"comparison":"Original budget to audited outcome","percent_changed":3.76},{"item":"Remuneration of councillors","amount":348869.0,"comparison":"Original to adjusted budget","percent_changed":2.63},{"item":"Remuneration of councillors","amount":-56800.0,"comparison":"Original budget to audited outcome","percent_changed":-0.43},{"item":"Transfers and subsidies","amount":149751.0,"comparison":"Original to adjusted budget","percent_changed":13.93},{"item":"Transfers and subsidies","amount":128435.0,"comparison":"Original budget to audited outcome","percent_changed":11.95}]},"spending_time_series":[{"amount":794789834.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":886491614.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":973155956.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":788261008.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":861289120.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":825926768.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":943955820.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":1104920785.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":1082559775.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":1155631174.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":819861473.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":879484930.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":896462610.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":965116818.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":1016098337.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"capital_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2024,"rating":"ave","result":-13.94,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"ave","result":-12.89,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":null,"result":null,"overunder":null,"cube_version":null},{"date":2021,"rating":"bad","result":-22.44,"overunder":"under","cube_version":"v2"}],"formula":{"text":"= ((Actual Capital Expenditure - Budgeted Capital Expenditure) / Budgeted Capital Expenditure) * 100","actual":["=","(","(",{"cube":"capital","item_codes":["4100"],"amount_type":"AUDA"},"-",{"cube":"capital","item_codes":["4100"],"amount_type":"ADJB"},")","/",{"cube":"capital","item_codes":["4100"],"amount_type":"ADJB"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= ((Actual Capital Expenditure - Budgeted Capital Expenditure) / Budgeted Capital Expenditure) * 100","actual":["=","(","(",{"cube":"capital_v2","amount_type":"AUDA","item_description":"capital type code NEW, RENEWAL, UPGRADING"},"-",{"cube":"capital_v2","amount_type":"ADJB","item_description":"capital type code NEW, RENEWAL, UPGRADING"},")","/",{"cube":"capital_v2","amount_type":"ADJB","item_description":"capital type code NEW, RENEWAL, UPGRADING"},")","*","100"]},"result_type":"%"},"local_revenue_breakdown":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"date":"2024","item":"Property rates","amount":144090086.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":573048765.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":7059736.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":20646905.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":5160302.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":1884178.0,"amount_type":"AUDA"},{"date":"2024","item":"Agency services","amount":2515461.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":61490985.0,"amount_type":"AUDA"}],"formula":{"text":"= Breakdown of local income","actual":["=",{"cube":"incexp","item_codes":["0200","0300","0400","0700","0800","1000","1100","1300","1400","1500","1700","1800","1600","1610"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Breakdown of local income","actual":["=",{"cube":"incexp_v2","item_codes":["0200","0300","0400","0500","0600","0700","0800","0900","1000","1100","1200","1300","1400","1500","1550","1570","1590","1600","1700","1800","1900","2000","2100","2300","2400","2500","2600","2700","2800","2200"],"amount_type":"AUDA"}]}},"expenditure_trends_staff":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"date":2024,"rating":"","result":36.88},{"date":2023,"rating":"","result":39.1},{"date":2022,"rating":"","result":39.43},{"date":2021,"rating":"","result":44.31}],"formula":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp","item_codes":["3000","3100"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp_v2","item_codes":["3100"],"amount_type":"AUDA"}]},"result_type":"%"},"operating_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2024,"rating":"good","result":-3.0,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"ave","result":-6.8,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":null,"result":null,"overunder":null,"cube_version":null},{"date":2021,"rating":"good","result":-0.8,"overunder":"under","cube_version":"v2"}],"formula":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"-",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","/",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"-",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","*","100"]},"result_type":"%"},"repairs_maintenance_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":0.22,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0.22,"cube_version":"v2"},{"date":2022,"rating":"bad","result":0.2,"cube_version":"v2"},{"date":2021,"rating":"bad","result":0.51,"cube_version":"v2"}],"formula":{"text":"= (Repairs and maintenance expenditure / (Property, Plant and Equipment + Investment Property)) * 100","actual":["=","(",{"cube":"capital","item_codes":["4100"],"amount_type":"AUDA"},"/","(",{"cube":"bsheet","item_codes":["1300"],"amount_type":"AUDA"},"+",{"cube":"bsheet","item_codes":["1401"],"amount_type":"AUDA"},")",")","*","100"]},"last_year":2024,"formula_v2":{"text":"= (Repairs and maintenance expenditure / (Property, Plant and Equipment + Investment Property)) * 100","actual":["=","(",{"cube":"capital_v2","amount_type":"AUDA","item_description":"capital type code REPAIR_MNT Total"},"/","(",{"cube":"financial_position_v2","item_codes":["0230","0220"],"amount_type":"AUDA"},")",")","*","100"]},"result_type":"%"},"expenditure_trends_contracting":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"date":2024,"rating":"","result":1.91},{"date":2023,"rating":"","result":2.25},{"date":2022,"rating":"","result":2.37},{"date":2021,"rating":"","result":2.41}],"formula":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp","item_codes":["4200"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp_v2","item_codes":["3800"],"amount_type":"AUDA"}]},"result_type":"%"},"current_debtors_collection_rate":{"ref":{"url":"http://mfma.treasury.gov.za/RegulationsandGazettes/Municipal%20Budget%20and%20Reporting%20Regulations/Pages/default.aspx","title":"Municipal Budget and Reporting Regulations"},"values":[{"date":"2024","year":2024,"rating":"good","result":98.65,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"good","result":98.8,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"bad","result":89.42,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"bad","result":6.71,"amount_type":"AUDA","cube_version":"v2"}],"formula":{"text":"= (Collected Revenue / Billed Revenue) * 100","actual":["=","(",{"cube":"cflow","item_codes":["3010","3030","3040","3050","3060","3070","3100"],"amount_type":"AUDA"},"/",{"cube":"incexp","item_codes":["0200","0400","1000","less item code","2000"],"amount_type":"AUDA"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= (Collected Revenue / Billed Revenue) * 100","actual":["=","(",{"cube":"cflow_v2","item_codes":["0120","0130","0280"],"amount_type":"AUDA"},"/",{"cube":"incexp_v2","item_codes":["1800","0300","0400","0500","0600","1400","1100","1000"],"amount_type":"AUDA"},")","*","100"]},"result_type":"%"},"expenditure_functional_breakdown":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"values":[{"year":2021,"value":50408803.0},{"year":2022,"value":51064242.0},{"year":2023,"value":52198331.0},{"year":2024,"value":55302109.0},{"year":2025,"value":59587464.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":236882097.0},{"year":2022,"value":296300336.0},{"year":2023,"value":295700423.0},{"year":2024,"value":340666541.0},{"year":2025,"value":409653689.0}],"category":"Electricity "},{"values":[{"year":2021,"value":291945055.0},{"year":2022,"value":288942677.0},{"year":2023,"value":253370642.0},{"year":2024,"value":315076052.0},{"year":2025,"value":371969642.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":5245193.0},{"year":2022,"value":5267798.0},{"year":2023,"value":5292679.0},{"year":2024,"value":5440415.0},{"year":2025,"value":5411790.0}],"category":"Housing"},{"values":[{"year":2021,"value":2711768.0},{"year":2022,"value":3774125.0},{"year":2023,"value":4132581.0},{"year":2024,"value":4526867.0},{"year":2025,"value":4589442.0}],"category":"Other"},{"values":[{"year":2021,"value":42550275.0},{"year":2022,"value":44699256.0},{"year":2023,"value":50574507.0},{"year":2024,"value":49404486.0},{"year":2025,"value":56051900.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":39005922.0},{"year":2022,"value":35881724.0},{"year":2023,"value":32603489.0},{"year":2024,"value":34373281.0},{"year":2025,"value":39573478.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":29833010.0},{"year":2022,"value":31181382.0},{"year":2023,"value":27579555.0},{"year":2024,"value":26668885.0},{"year":2025,"value":24768272.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":32111539.0},{"year":2022,"value":36506229.0},{"year":2023,"value":36599122.0},{"year":2024,"value":36831026.0},{"year":2025,"value":44208625.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":57567346.0},{"year":2022,"value":67671351.0},{"year":2023,"value":67875439.0},{"year":2024,"value":75666158.0},{"year":2025,"value":89106483.0}],"category":"Water"}],"formula":{"text":"= All expenditure by function","actual":["=",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= All expenditure by function","actual":["=",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"}]}}},"demarcation":{"land_lost":[],"land_gained":[],"code":"NC087"},"muni_contact":{"url":"http://www.dkm.gov.za","phone_number":"054 338 7000","street_address_1":"Civic Centre","street_address_2":"2 Mark Street","street_address_3":"Upington","street_address_4":"8801"},"mayoral_staff":{"officials":[{"name":"David Kazi","role":"Mayor/Executive Mayor","email":"david.kazi@dkm.gov.za","title":"Mr","secretary":{"name":"Katriena Saal","role":"Secretary of Mayor/Executive Mayor","email":"katriena.saal@dkm.gov.za","title":"Mrs","fax_number":"054 338 7352","office_phone":"054 338 7020"},"fax_number":"054 338 7352","office_phone":"054 338 7022"},{"name":"Elias Ntoba","role":"Municipal Manager","email":"manager@dkm.gov.za","title":"Mr","secretary":{"name":"Nicolen Suzzelle","role":"Secretary of Municipal Manager","email":"suzelle.coetzee@dkm.gov.za","title":"Ms","fax_number":"054 338 7351","office_phone":"054 338 7002"},"fax_number":"054 338 7351","office_phone":"054 338 7001"},{"name":"","role":"Deputy Mayor/Executive Mayor","email":"","title":"","secretary":{"name":"","role":"Secretary of Deputy Mayor/Executive Mayor","email":"","title":"","fax_number":"","office_phone":""},"fax_number":"","office_phone":""},{"name":"Ruaan Strauss","role":"Chief Financial Officer","email":"ruaan.strauss@dkm.gov.za","title":"Mr","secretary":{"name":"Muriël Sishuba","role":"Secretary of Financial Manager","email":"muriel.sishuba@dkm.gov.za","title":"Ms","fax_number":"054 338 7375","office_phone":"054 338 7025"},"fax_number":"054 338 7374","office_phone":"054 338 7024"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/NC087/NC087_Audit%20Report_2024_Y_20241201T092506Z_judith_louw.pdf"},{"date":2023,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/NC087/NC087_Audit%20Report_2023_Y_20231204T072941Z_judith_louw.pdf"},{"date":2022,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/NC087/NC087_Audit%20Report_2022_Y_20221130T153801Z_judith_louw.pdf"},{"date":2021,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/NC087/NC087_Audit%20Report_2021_Y_20211201T090736Z_5405.pdf"}]}}