{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":12505725.0,"national_conditional_grants":21370471.0},"ORGB":{"equitable_share":466536000.0,"national_conditional_grants":238999000.0},"SCHD":{"national_conditional_grants":195658000.0},"TRFR":{"national_conditional_grants":51888000.0}},"2022":{"ACT":{"national_conditional_grants":89550331.0},"ORGB":{"equitable_share":484096000.0,"national_conditional_grants":204121000.0},"SCHD":{"national_conditional_grants":202414000.0},"TRFR":{"national_conditional_grants":178387000.0}},"2023":{"ACT":{"national_conditional_grants":85773459.0},"ORGB":{"equitable_share":545300000.0,"provincial_transfers":35001000.0,"national_conditional_grants":187504000.0},"SCHD":{"national_conditional_grants":161109000.0},"TRFR":{"national_conditional_grants":158693000.0}},"2024":{"ACT":{"national_conditional_grants":123804887.0},"ORGB":{"equitable_share":599104000.0,"national_conditional_grants":211569000.0},"SCHD":{"national_conditional_grants":183697000.0},"TRFR":{"national_conditional_grants":182430000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":12505725.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":466536000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":484096000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":545300000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":599104000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":34091000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":910000.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":1013000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1013000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1200674.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":3600000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":500000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":240035.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":24246000.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":6000000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":172957.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":24246000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":6000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":5046192.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":86894000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":7322000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1410000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":13111144.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":33157000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":21530000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":536381.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":2092000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":523000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1063088.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":16000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":6000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021}],"2022":[{"amount.sum":856875.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":24577000.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":40122.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":58782556.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":97551000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":97551000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":2400000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":2950000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":27922295.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":63000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":63000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1108919.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":1786000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1786000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":839564.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":1651200.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":3000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":3000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":2018436.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":2096000.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":19077207.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":29064000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":29064000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":47604826.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":89187000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":89187000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":320000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":11485708.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":21000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":21000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":2180978.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":2181000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":2181000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1755104.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":11161000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":11161000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":1686088.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":4000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":4000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1676331.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1267000.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":5628407.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1732000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1732000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":71472621.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":101017000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":101017000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":15877210.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":21162000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":21162000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":2762539.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":2789000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":2789000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":24701691.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":48630000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":48630000.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":2833541749.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":1841374798.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":2249322991.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":2026883450.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":4.7,"cube_version":"v2"},{"date":2022,"rating":"good","result":6.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":6.0,"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":2387576985.0,"rating":"bad","result":0.37,"amount_type":"AUDA","liabilities":6370556636.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":1903958591.0,"rating":"bad","result":0.38,"amount_type":"AUDA","liabilities":4977029498.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":1734431187.0,"rating":"bad","result":0.43,"amount_type":"AUDA","liabilities":4033787545.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":1194953977.0,"rating":"bad","result":0.42,"amount_type":"AUDA","liabilities":2827376565.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":181715220.0,"date":"2024","year":2024,"rating":"bad","result":0.03,"amount_type":"ACT","liabilities":6370556636.0,"cube_version":"v2","call_investment_deposits":0},{"cash":104773263.0,"date":"2023","year":2023,"rating":"bad","result":0.02,"amount_type":"ACT","liabilities":4977029498.0,"cube_version":"v2","call_investment_deposits":0},{"cash":224921255.0,"date":"2022","year":2022,"rating":"bad","result":0.06,"amount_type":"ACT","liabilities":4033787545.0,"cube_version":"v2","call_investment_deposits":0},{"cash":-195819874.0,"date":"2021","year":2021,"rating":"bad","result":-0.07,"amount_type":"ACT","liabilities":2827376565.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":3451782693.0,"percent":84.84},"total":4068451088.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":616668395.0,"percent":15.16}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":28.53,"cube_version":"v2"},{"date":2023,"rating":"bad","result":18.57,"cube_version":"v2"},{"date":2022,"rating":"bad","result":34.35,"cube_version":"v2"},{"date":2021,"rating":"bad","result":27.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":-949258.0,"comparison":"Original to adjusted budget","percent_changed":-3.31},{"item":"Fines","amount":-3946530.0,"comparison":"Original budget to audited outcome","percent_changed":-13.76},{"item":"Government Transfers","amount":74164000.0,"comparison":"Original to adjusted budget","percent_changed":15.43},{"item":"Government Transfers","amount":49651994.0,"comparison":"Original budget to audited outcome","percent_changed":10.33},{"item":"Interest and investments","amount":15852619.0,"comparison":"Original to adjusted budget","percent_changed":4.14},{"item":"Interest and investments","amount":48879649.0,"comparison":"Original budget to audited outcome","percent_changed":12.75},{"item":"Licenses and Permits","amount":490000.0,"comparison":"Original to adjusted budget","percent_changed":6.35},{"item":"Licenses and Permits","amount":1508337.0,"comparison":"Original budget to audited outcome","percent_changed":19.54},{"item":"Other","amount":16248383.0,"comparison":"Original to adjusted budget","percent_changed":22.74},{"item":"Other","amount":-25737328.0,"comparison":"Original budget to audited outcome","percent_changed":-36.02},{"item":"Property rates","amount":5282237.0,"comparison":"Original to adjusted budget","percent_changed":1.1},{"item":"Property rates","amount":-54556437.0,"comparison":"Original budget to audited outcome","percent_changed":-11.36},{"item":"Rental income","amount":2068291.0,"comparison":"Original to adjusted budget","percent_changed":36.98},{"item":"Rental income","amount":359768519.0,"comparison":"Original budget to audited outcome","percent_changed":6432.93},{"item":"Service Charges","amount":82067163.0,"comparison":"Original to adjusted budget","percent_changed":4.23},{"item":"Service Charges","amount":-175060498.0,"comparison":"Original budget to audited outcome","percent_changed":-9.02}],"2022":[{"item":"Fines","amount":-34697216.0,"comparison":"Original to adjusted budget","percent_changed":-90.99},{"item":"Fines","amount":-30774992.0,"comparison":"Original budget to audited outcome","percent_changed":-80.71},{"item":"Government Transfers","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Government Transfers","amount":16387361.0,"comparison":"Original budget to audited outcome","percent_changed":3.31},{"item":"Interest and investments","amount":48616091.0,"comparison":"Original to adjusted budget","percent_changed":10.74},{"item":"Interest and investments","amount":62754196.0,"comparison":"Original budget to audited outcome","percent_changed":13.86},{"item":"Licenses and Permits","amount":634993.0,"comparison":"Original to adjusted budget","percent_changed":6.85},{"item":"Licenses and Permits","amount":-1250126.0,"comparison":"Original budget to audited outcome","percent_changed":-13.48},{"item":"Other","amount":10644749.0,"comparison":"Original to adjusted budget","percent_changed":26.92},{"item":"Other","amount":9898253.0,"comparison":"Original budget to audited outcome","percent_changed":25.03},{"item":"Property rates","amount":-6189317.0,"comparison":"Original to adjusted budget","percent_changed":-1.26},{"item":"Property rates","amount":-38856186.0,"comparison":"Original budget to audited outcome","percent_changed":-7.93},{"item":"Rental income","amount":575926.0,"comparison":"Original to adjusted budget","percent_changed":8.05},{"item":"Rental income","amount":244551327.0,"comparison":"Original budget to audited outcome","percent_changed":3416.43},{"item":"Service Charges","amount":34958650.0,"comparison":"Original to adjusted budget","percent_changed":1.75},{"item":"Service Charges","amount":-98252820.0,"comparison":"Original budget to audited outcome","percent_changed":-4.91}],"2023":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":3854548.0,"comparison":"Original budget to audited outcome","percent_changed":85.22},{"item":"Government Transfers","amount":154000.0,"comparison":"Original to adjusted budget","percent_changed":0.03},{"item":"Government Transfers","amount":-2304303.0,"comparison":"Original budget to audited outcome","percent_changed":-0.41},{"item":"Interest and investments","amount":69039230.0,"comparison":"Original to adjusted budget","percent_changed":13.2},{"item":"Interest and investments","amount":93320870.0,"comparison":"Original budget to audited outcome","percent_changed":17.84},{"item":"Licenses and Permits","amount":-1185250.0,"comparison":"Original to adjusted budget","percent_changed":-11.41},{"item":"Licenses and Permits","amount":-2594793.0,"comparison":"Original budget to audited outcome","percent_changed":-24.99},{"item":"Other","amount":-16849349.0,"comparison":"Original to adjusted budget","percent_changed":-17.49},{"item":"Other","amount":-55568148.0,"comparison":"Original budget to audited outcome","percent_changed":-57.67},{"item":"Property rates","amount":25490580.0,"comparison":"Original to adjusted budget","percent_changed":5.02},{"item":"Property rates","amount":-50948350.0,"comparison":"Original budget to audited outcome","percent_changed":-10.04},{"item":"Rental income","amount":728031.0,"comparison":"Original to adjusted budget","percent_changed":8.98},{"item":"Rental income","amount":98670157.0,"comparison":"Original budget to audited outcome","percent_changed":1217.36},{"item":"Service Charges","amount":-102838960.0,"comparison":"Original to adjusted budget","percent_changed":-4.46},{"item":"Service Charges","amount":-358562362.0,"comparison":"Original budget to audited outcome","percent_changed":-15.53}],"2024":[{"item":"Fines","amount":-49834.0,"comparison":"Original to adjusted budget","percent_changed":-1.61},{"item":"Fines","amount":14722349.0,"comparison":"Original budget to audited outcome","percent_changed":474.36},{"item":"Government Transfers","amount":-433000.0,"comparison":"Original to adjusted budget","percent_changed":-0.07},{"item":"Government Transfers","amount":-252205.0,"comparison":"Original budget to audited outcome","percent_changed":-0.04},{"item":"Interest and investments","amount":-49999554.0,"comparison":"Original to adjusted budget","percent_changed":-8.03},{"item":"Interest and investments","amount":159901126.0,"comparison":"Original budget to audited outcome","percent_changed":25.68},{"item":"Licenses and Permits","amount":-1500000.0,"comparison":"Original to adjusted budget","percent_changed":-16.74},{"item":"Licenses and Permits","amount":-1163932.0,"comparison":"Original budget to audited outcome","percent_changed":-12.99},{"item":"Other","amount":-25709600.0,"comparison":"Original to adjusted budget","percent_changed":-29.61},{"item":"Other","amount":-38786295.0,"comparison":"Original budget to audited outcome","percent_changed":-44.67},{"item":"Property rates","amount":-15071699.0,"comparison":"Original to adjusted budget","percent_changed":-2.69},{"item":"Property rates","amount":-53642418.0,"comparison":"Original budget to audited outcome","percent_changed":-9.56},{"item":"Rental income","amount":-151217.0,"comparison":"Original to adjusted budget","percent_changed":-1.63},{"item":"Rental income","amount":5660028.0,"comparison":"Original budget to audited outcome","percent_changed":60.86},{"item":"Service Charges","amount":-195619759.0,"comparison":"Original to adjusted budget","percent_changed":-8.48},{"item":"Service Charges","amount":-232543219.0,"comparison":"Original budget to audited outcome","percent_changed":-10.09}]},"income_time_series":[{"amount":3594365113.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":3585901845.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":3994392500.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":3926020991.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":3599649384.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":3695814982.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":3745721837.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":4068451088.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":4747518437.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":4442471088.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":4651598496.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":3399141678.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":3531357969.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":4019854218.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":4214555654.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":4264860853.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":-10000000.0,"comparison":"Original to adjusted budget","percent_changed":-1.66},{"item":"Bulk purchases","amount":145970802.0,"comparison":"Original budget to audited outcome","percent_changed":24.3},{"item":"Contracted services","amount":96434002.0,"comparison":"Original to adjusted budget","percent_changed":70.81},{"item":"Contracted services","amount":114584488.0,"comparison":"Original budget to audited outcome","percent_changed":84.13},{"item":"Employee related costs","amount":11322667.0,"comparison":"Original to adjusted budget","percent_changed":1.74},{"item":"Employee related costs","amount":62446695.0,"comparison":"Original budget to audited outcome","percent_changed":9.61},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":70940211.0,"comparison":"Original budget to audited outcome","percent_changed":2005.66},{"item":"Other","amount":-27553025.0,"comparison":"Original to adjusted budget","percent_changed":-1.41},{"item":"Other","amount":276028107.0,"comparison":"Original budget to audited outcome","percent_changed":14.13},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-2492490.0,"comparison":"Original budget to audited outcome","percent_changed":-6.39}],"2022":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-157977852.0,"comparison":"Original budget to audited outcome","percent_changed":-15.3},{"item":"Contracted services","amount":105544956.0,"comparison":"Original to adjusted budget","percent_changed":40.24},{"item":"Contracted services","amount":73575232.0,"comparison":"Original budget to audited outcome","percent_changed":28.05},{"item":"Employee related costs","amount":25197515.0,"comparison":"Original to adjusted budget","percent_changed":3.64},{"item":"Employee related costs","amount":-6115760.0,"comparison":"Original budget to audited outcome","percent_changed":-0.88},{"item":"Finance charges","amount":7360185.0,"comparison":"Original to adjusted budget","percent_changed":320.06},{"item":"Finance charges","amount":114779980.0,"comparison":"Original budget to audited outcome","percent_changed":4991.25},{"item":"Other","amount":117043640.0,"comparison":"Original to adjusted budget","percent_changed":7.03},{"item":"Other","amount":760106061.0,"comparison":"Original budget to audited outcome","percent_changed":45.62},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-3033170.0,"comparison":"Original budget to audited outcome","percent_changed":-8.15}],"2023":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-240694279.0,"comparison":"Original budget to audited outcome","percent_changed":-22.1},{"item":"Contracted services","amount":28390458.0,"comparison":"Original to adjusted budget","percent_changed":6.52},{"item":"Contracted services","amount":-186003309.0,"comparison":"Original budget to audited outcome","percent_changed":-42.71},{"item":"Employee related costs","amount":-1130000.0,"comparison":"Original to adjusted budget","percent_changed":-0.15},{"item":"Employee related costs","amount":-47200371.0,"comparison":"Original budget to audited outcome","percent_changed":-6.34},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":227410995.0,"comparison":"Original budget to audited outcome","percent_changed":2246.37},{"item":"Other","amount":398013241.0,"comparison":"Original to adjusted budget","percent_changed":24.52},{"item":"Other","amount":1045199815.0,"comparison":"Original budget to audited outcome","percent_changed":64.38},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-2544242.0,"comparison":"Original budget to audited outcome","percent_changed":-6.45}],"2024":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-98803468.0,"comparison":"Original budget to audited outcome","percent_changed":-8.91},{"item":"Contracted services","amount":3274463.0,"comparison":"Original to adjusted budget","percent_changed":0.7},{"item":"Contracted services","amount":-240620999.0,"comparison":"Original budget to audited outcome","percent_changed":-51.74},{"item":"Employee related costs","amount":-14846762.0,"comparison":"Original to adjusted budget","percent_changed":-1.89},{"item":"Employee related costs","amount":9358251.0,"comparison":"Original budget to audited outcome","percent_changed":1.19},{"item":"Finance charges","amount":-3000.0,"comparison":"Original to adjusted budget","percent_changed":-0.03},{"item":"Finance charges","amount":366677199.0,"comparison":"Original budget to audited outcome","percent_changed":3423.49},{"item":"Other","amount":-350418494.0,"comparison":"Original to adjusted budget","percent_changed":-18.69},{"item":"Other","amount":921632656.0,"comparison":"Original budget to audited outcome","percent_changed":49.15},{"item":"Remuneration of councillors","amount":1910826.0,"comparison":"Original to adjusted budget","percent_changed":4.59},{"item":"Remuneration of councillors","amount":-2547004.0,"comparison":"Original budget to audited outcome","percent_changed":-6.12}]},"spending_time_series":[{"amount":3452577583.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":3947701790.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":4366801486.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":3927624978.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":4049851752.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":4473889985.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":4737696396.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":5243404580.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":5853084578.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":4324883231.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":4319008154.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":3382373939.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":3692555494.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":3941527787.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":4287707945.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":4262640805.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":9.89,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"bad","result":-63.6,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"bad","result":-32.53,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"bad","result":-20.06,"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":507433748.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":2073123505.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":14960496.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":782598598.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":17825964.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":7795291.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":48045091.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":15.17},{"date":2023,"rating":"","result":14.71},{"date":2022,"rating":"","result":15.34},{"date":2021,"rating":"","result":17.58}],"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":"bad","result":33.5,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"ave","result":8.5,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"ave","result":13.3,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"bad","result":17.3,"overunder":"over","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":1.76,"cube_version":"v2"},{"date":2023,"rating":"bad","result":2.27,"cube_version":"v2"},{"date":2022,"rating":"bad","result":1.87,"cube_version":"v2"},{"date":2021,"rating":"bad","result":2.11,"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":4.28},{"date":2023,"rating":"","result":5.27},{"date":2022,"rating":"","result":7.51},{"date":2021,"rating":"","result":6.19}],"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":"bad","result":46.07,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"bad","result":45.37,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"bad","result":57.57,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"good","result":119.92,"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":188566243.0},{"year":2022,"value":194711078.0},{"year":2023,"value":187607603.0},{"year":2024,"value":201111411.0},{"year":2025,"value":220151712.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":1334458234.0},{"year":2022,"value":1174884184.0},{"year":2023,"value":1728546162.0},{"year":2024,"value":1398521290.0},{"year":2025,"value":1762722107.0}],"category":"Electricity "},{"values":[{"year":2021,"value":63426514.0},{"year":2022,"value":-475643.0},{"year":2023,"value":11077753.0},{"year":2024,"value":-3356811.0},{"year":2025,"value":1341421.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":880251327.0},{"year":2022,"value":1288869211.0},{"year":2023,"value":1073876190.0},{"year":2024,"value":1677278595.0},{"year":2025,"value":1273260623.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":9628702.0},{"year":2022,"value":101218.0},{"year":2023,"value":32694.0},{"year":2024,"value":109352.0},{"year":2025,"value":6356.0}],"category":"Health"},{"values":[{"year":2021,"value":4777105.0},{"year":2022,"value":3206290.0},{"year":2023,"value":16554814.0},{"year":2024,"value":16592681.0},{"year":2025,"value":15729557.0}],"category":"Housing"},{"values":[{"year":2021,"value":31824761.0},{"year":2022,"value":21364082.0},{"year":2023,"value":26209355.0},{"year":2024,"value":22985931.0},{"year":2025,"value":21476898.0}],"category":"Other"},{"values":[{"year":2021,"value":122843425.0},{"year":2022,"value":161824841.0},{"year":2023,"value":74104034.0},{"year":2024,"value":143153348.0},{"year":2025,"value":149740923.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":64624149.0},{"year":2022,"value":75253002.0},{"year":2023,"value":113483012.0},{"year":2024,"value":66754236.0},{"year":2025,"value":70778953.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":192003423.0},{"year":2022,"value":288952346.0},{"year":2023,"value":283172171.0},{"year":2024,"value":257060007.0},{"year":2025,"value":377796967.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":196134896.0},{"year":2022,"value":214452452.0},{"year":2023,"value":220259510.0},{"year":2024,"value":335744312.0},{"year":2025,"value":410149831.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":961312973.0},{"year":2022,"value":1050746924.0},{"year":2023,"value":1002773098.0},{"year":2024,"value":1127450228.0},{"year":2025,"value":1549929230.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":"NW403"},"muni_contact":{"url":"http://Www.Matlosana.Org.Za","phone_number":"018 487 8017","street_address_1":"Mayibuye","street_address_2":"C/O Braam Fisher & Emily Hobhouse Street","street_address_3":"Klerksdorp","street_address_4":"2570"},"mayoral_staff":{"officials":[{"name":"Fikile Caswell Mahlophe","role":"Mayor/Executive Mayor","email":"fmahlophe@klerksdorp.org","title":"Mr","secretary":{"name":"Audrey Mangaka Kgosing","role":"Secretary of Mayor/Executive Mayor","email":"clerk.mayor@klerksdorp.org","title":"Ms","fax_number":"018 462 3420","office_phone":"018 487 8002"},"fax_number":"018 462 3420","office_phone":"018 487 8002"},{"name":"Lesego Seametso","role":"Municipal Manager","email":"lseametso@klerksdorp.org","title":"Ms","secretary":{"name":"Dikeledi Nkosi","role":"Secretary of Municipal Manager","email":"dnkosi@klerksdorp.org","title":"Mrs","fax_number":"086 640 8548","office_phone":"018 487 8009"},"fax_number":"018 464 1780","office_phone":"018 487 8009"},{"name":"Samson Kohla","role":"Deputy Mayor/Executive Mayor","email":"skohla@klerksdorp.org","title":"Mr","secretary":{"name":"M Mogashwa","role":"Secretary of Deputy Mayor/Executive Mayor","email":"pmogakwe@klerksdorp.org","title":"Ms","fax_number":" ","office_phone":"018 487 8006"},"fax_number":"018 487 5837","office_phone":"018 487 8005"},{"name":"Tsaone Sekgala","role":"Chief Financial Officer","email":"osekgala@klerksdorp.org","title":"Mrs","secretary":{"name":"Kholeka Witbooi","role":"Secretary of Financial Manager","email":"finance@klerksdorp.org","title":"Ms","fax_number":"018 464 2318","office_phone":"018 487 8017"},"fax_number":" ","office_phone":"018 487 8040"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/NW403/NW403_Audit%20Report_2024_Y_20250116T092142Z_tvantonder.pdf"},{"date":2023,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":""},{"date":2022,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":""},{"date":2021,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/NW403/NW403_Audit%20Report_2021_Y_20220513T095055Z_tvantonder.pdf"}]}}