{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":35982284.0,"national_conditional_grants":43837128.0},"ORGB":{"equitable_share":794688000.0,"national_conditional_grants":451222000.0},"SCHD":{"national_conditional_grants":406108000.0},"TRFR":{"national_conditional_grants":127434000.0}},"2022":{"ACT":{"national_conditional_grants":304954980.0},"ORGB":{"equitable_share":834510000.0,"national_conditional_grants":564529000.0},"SCHD":{"national_conditional_grants":720938000.0},"TRFR":{"national_conditional_grants":665130000.0}},"2023":{"ACT":{"national_conditional_grants":399648684.0},"ORGB":{"equitable_share":948458000.0,"provincial_transfers":83697000.0,"national_conditional_grants":558862000.0},"SCHD":{"national_conditional_grants":707362000.0},"TRFR":{"national_conditional_grants":643610000.0}},"2024":{"ACT":{"national_conditional_grants":460710394.0},"ORGB":{"equitable_share":1049002000.0,"national_conditional_grants":539015000.0},"SCHD":{"national_conditional_grants":482540000.0},"TRFR":{"national_conditional_grants":459250000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":35982284.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":794688000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":834510000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":948458000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":1049002000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":83158000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":508000.0,"grant.code":"0005","grant.label":"Agriculture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":31000.0,"grant.code":"0008","grant.label":"Office of the Premier","amount_type.code":"ORGB","financial_year_end.year":2023}]},"national_conditional_grants":{"2021":[{"amount.sum":4735.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1073000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1073000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":6300000.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":2000000.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":226766.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":2500000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":2500000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":27904000.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":10000000.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":2788462.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":27904000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":10000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":37240113.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":331383000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":100800000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":300000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":2000000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":2500000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":3577052.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":4244000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1061000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021}],"2022":[{"amount.sum":6000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":6000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":6000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":801564.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":2550000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":2550000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":53808000.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":47378677.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":69206000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":69206000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":232448695.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":353929000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":353929000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":2000000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":7661573.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":11153000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":11153000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":198256000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":198256000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":7036000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":7036000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":7036000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":2000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":2000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":3628471.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":15000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":15000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":4284001.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":4284000.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":4284000.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":1634904.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":2650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":2650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":61352000.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":50100102.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":54659000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":54659000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":286236396.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":384362000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":384362000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":2400000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":19379039.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":148100000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":148100000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":8555000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":8555000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":8555000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":9908446.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":10000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":10000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":19550796.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":30000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":30000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":3686496.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":20117000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":20117000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":3650083.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":11805000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":11805000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":4540905.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":1520570.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":2650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":2650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":23290000.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":29999999.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":30000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":30000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":383020000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":383020000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":383020000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1082216.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":5000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":5000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":26460675.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":6658000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":6658000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":6658000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":91450.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"ACT","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":"bad","result":-3377992979.0,"cube_version":"v2"},{"date":2023,"rating":"bad","result":-525222970.0,"cube_version":"v2"},{"date":2022,"rating":"bad","result":-3169730695.0,"cube_version":"v2"},{"date":2021,"rating":"bad","result":-1057653431.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":"bad","result":0,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0,"cube_version":"v2"},{"date":2022,"rating":"bad","result":0,"cube_version":"v2"},{"date":2021,"rating":"bad","result":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":1364015960.0,"rating":"bad","result":0.47,"amount_type":"AUDA","liabilities":2888509093.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":1046223053.0,"rating":"bad","result":0.3,"amount_type":"AUDA","liabilities":3458611734.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":977840780.0,"rating":"bad","result":0.31,"amount_type":"AUDA","liabilities":3133343957.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":693419010.0,"rating":"bad","result":0.29,"amount_type":"AUDA","liabilities":2401939880.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":140091127.0,"date":"2024","year":2024,"rating":"bad","result":0.05,"amount_type":"ACT","liabilities":2888509093.0,"cube_version":"v2","call_investment_deposits":0},{"cash":205310447.0,"date":"2023","year":2023,"rating":"bad","result":0.06,"amount_type":"ACT","liabilities":3458611734.0,"cube_version":"v2","call_investment_deposits":0},{"cash":144510599.0,"date":"2022","year":2022,"rating":"bad","result":0.05,"amount_type":"ACT","liabilities":3133343957.0,"cube_version":"v2","call_investment_deposits":0},{"cash":62333725.0,"date":"2021","year":2021,"rating":"bad","result":0.03,"amount_type":"ACT","liabilities":2401939880.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":3045272461.0,"percent":74.04},"total":4113274388.0,"rating":"ave","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":1068001927.0,"percent":25.96}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":19.03,"cube_version":"v2"},{"date":2023,"rating":"bad","result":24.63,"cube_version":"v2"},{"date":2022,"rating":"bad","result":18.47,"cube_version":"v2"},{"date":2021,"rating":"bad","result":13.22,"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":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":-2951686.0,"comparison":"Original budget to audited outcome","percent_changed":-34.38},{"item":"Government Transfers","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Government Transfers","amount":61238278.0,"comparison":"Original budget to audited outcome","percent_changed":6.55},{"item":"Interest and investments","amount":-4500000.0,"comparison":"Original to adjusted budget","percent_changed":-9.8},{"item":"Interest and investments","amount":9391460.0,"comparison":"Original budget to audited outcome","percent_changed":20.45},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-6584829.0,"comparison":"Original budget to audited outcome","percent_changed":-99.3},{"item":"Other","amount":45000000.0,"comparison":"Original to adjusted budget","percent_changed":78.12},{"item":"Other","amount":22683665.0,"comparison":"Original budget to audited outcome","percent_changed":39.38},{"item":"Property rates","amount":20000000.0,"comparison":"Original to adjusted budget","percent_changed":2.94},{"item":"Property rates","amount":27238109.0,"comparison":"Original budget to audited outcome","percent_changed":4.0},{"item":"Rental income","amount":-5100000.0,"comparison":"Original to adjusted budget","percent_changed":-56.85},{"item":"Rental income","amount":-655474.0,"comparison":"Original budget to audited outcome","percent_changed":-7.31},{"item":"Service Charges","amount":574246.0,"comparison":"Original to adjusted budget","percent_changed":0.04},{"item":"Service Charges","amount":-69765264.0,"comparison":"Original budget to audited outcome","percent_changed":-4.74}],"2022":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":-3960150.0,"comparison":"Original budget to audited outcome","percent_changed":-43.93},{"item":"Government Transfers","amount":6000000.0,"comparison":"Original to adjusted budget","percent_changed":0.71},{"item":"Government Transfers","amount":69161829.0,"comparison":"Original budget to audited outcome","percent_changed":8.19},{"item":"Interest and investments","amount":-7056353.0,"comparison":"Original to adjusted budget","percent_changed":-16.23},{"item":"Interest and investments","amount":-10397169.0,"comparison":"Original budget to audited outcome","percent_changed":-23.91},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-6960145.0,"comparison":"Original budget to audited outcome","percent_changed":-99.96},{"item":"Other","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Other","amount":-44390168.0,"comparison":"Original budget to audited outcome","percent_changed":-38.63},{"item":"Property rates","amount":5000000.0,"comparison":"Original to adjusted budget","percent_changed":0.67},{"item":"Property rates","amount":1090345.0,"comparison":"Original budget to audited outcome","percent_changed":0.15},{"item":"Rental income","amount":524000.0,"comparison":"Original to adjusted budget","percent_changed":1.02},{"item":"Rental income","amount":-6030890.0,"comparison":"Original budget to audited outcome","percent_changed":-11.75},{"item":"Service Charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":-111597186.0,"comparison":"Original budget to audited outcome","percent_changed":-6.72}],"2023":[{"item":"Fines","amount":-6123295.0,"comparison":"Original to adjusted budget","percent_changed":-52.25},{"item":"Fines","amount":-7719348.0,"comparison":"Original budget to audited outcome","percent_changed":-65.87},{"item":"Government Transfers","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Government Transfers","amount":1.0,"comparison":"Original budget to audited outcome","percent_changed":0.0},{"item":"Interest and investments","amount":7000000.0,"comparison":"Original to adjusted budget","percent_changed":21.54},{"item":"Interest and investments","amount":13999731.0,"comparison":"Original budget to audited outcome","percent_changed":43.08},{"item":"Licenses and Permits","amount":-6000000.0,"comparison":"Original to adjusted budget","percent_changed":-78.34},{"item":"Licenses and Permits","amount":-7618160.0,"comparison":"Original budget to audited outcome","percent_changed":-99.46},{"item":"Other","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Other","amount":278110833.0,"comparison":"Original budget to audited outcome","percent_changed":148.74},{"item":"Property rates","amount":42000000.0,"comparison":"Original to adjusted budget","percent_changed":5.15},{"item":"Property rates","amount":-12962294.0,"comparison":"Original budget to audited outcome","percent_changed":-1.59},{"item":"Rental income","amount":-20000000.0,"comparison":"Original to adjusted budget","percent_changed":-35.07},{"item":"Rental income","amount":-31740218.0,"comparison":"Original budget to audited outcome","percent_changed":-55.66},{"item":"Service Charges","amount":-11650000.0,"comparison":"Original to adjusted budget","percent_changed":-0.64},{"item":"Service Charges","amount":-252044677.0,"comparison":"Original budget to audited outcome","percent_changed":-13.79}],"2024":[{"item":"Fines","amount":-2566856.0,"comparison":"Original to adjusted budget","percent_changed":-41.7},{"item":"Fines","amount":760313.0,"comparison":"Original budget to audited outcome","percent_changed":12.35},{"item":"Government Transfers","amount":-394000.0,"comparison":"Original to adjusted budget","percent_changed":-0.04},{"item":"Government Transfers","amount":5297717.0,"comparison":"Original budget to audited outcome","percent_changed":0.5},{"item":"Interest and investments","amount":52204462.0,"comparison":"Original to adjusted budget","percent_changed":120.16},{"item":"Interest and investments","amount":51524252.0,"comparison":"Original budget to audited outcome","percent_changed":118.6},{"item":"Licenses and Permits","amount":-1622106.0,"comparison":"Original to adjusted budget","percent_changed":-88.88},{"item":"Licenses and Permits","amount":-1656011.0,"comparison":"Original budget to audited outcome","percent_changed":-90.73},{"item":"Other","amount":104065354.0,"comparison":"Original to adjusted budget","percent_changed":79.65},{"item":"Other","amount":58860115.0,"comparison":"Original budget to audited outcome","percent_changed":45.05},{"item":"Property rates","amount":-20607162.0,"comparison":"Original to adjusted budget","percent_changed":-2.0},{"item":"Property rates","amount":-54444628.0,"comparison":"Original budget to audited outcome","percent_changed":-5.29},{"item":"Rental income","amount":-9546782.0,"comparison":"Original to adjusted budget","percent_changed":-23.44},{"item":"Rental income","amount":-17150774.0,"comparison":"Original budget to audited outcome","percent_changed":-42.11},{"item":"Service Charges","amount":-8740733.0,"comparison":"Original to adjusted budget","percent_changed":-0.48},{"item":"Service Charges","amount":-84727090.0,"comparison":"Original budget to audited outcome","percent_changed":-4.61}]},"income_time_series":[{"amount":3269466617.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":3478701310.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":3908758318.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":4267602671.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":3254086630.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":3361150129.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":3883557481.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":4113274388.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":4315459841.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":4882899630.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":5353393602.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":3213492371.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":3474233663.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":3903531613.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":4154810494.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":4464918647.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":-12593000.0,"comparison":"Original to adjusted budget","percent_changed":-1.55},{"item":"Bulk purchases","amount":73024637.0,"comparison":"Original budget to audited outcome","percent_changed":8.97},{"item":"Contracted services","amount":113946209.0,"comparison":"Original to adjusted budget","percent_changed":26.79},{"item":"Contracted services","amount":259996232.0,"comparison":"Original budget to audited outcome","percent_changed":61.13},{"item":"Employee related costs","amount":-1220000.0,"comparison":"Original to adjusted budget","percent_changed":-0.11},{"item":"Employee related costs","amount":61005423.0,"comparison":"Original budget to audited outcome","percent_changed":5.61},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":57700114.0,"comparison":"Original budget to audited outcome","percent_changed":206.23},{"item":"Other","amount":-106851033.0,"comparison":"Original to adjusted budget","percent_changed":-8.91},{"item":"Other","amount":-2458024.0,"comparison":"Original budget to audited outcome","percent_changed":-0.2},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-4336961.0,"comparison":"Original budget to audited outcome","percent_changed":-6.82},{"item":"Transfers and subsidies","amount":-1050785.0,"comparison":"Original to adjusted budget","percent_changed":-50.52},{"item":"Transfers and subsidies","amount":-944945.0,"comparison":"Original budget to audited outcome","percent_changed":-45.43}],"2022":[{"item":"Bulk purchases","amount":177600578.0,"comparison":"Original to adjusted budget","percent_changed":20.41},{"item":"Bulk purchases","amount":187513385.0,"comparison":"Original budget to audited outcome","percent_changed":21.55},{"item":"Contracted services","amount":161706471.0,"comparison":"Original to adjusted budget","percent_changed":36.22},{"item":"Contracted services","amount":196125085.0,"comparison":"Original budget to audited outcome","percent_changed":43.93},{"item":"Employee related costs","amount":10503618.0,"comparison":"Original to adjusted budget","percent_changed":0.93},{"item":"Employee related costs","amount":70657232.0,"comparison":"Original budget to audited outcome","percent_changed":6.27},{"item":"Finance charges","amount":8500000.0,"comparison":"Original to adjusted budget","percent_changed":28.93},{"item":"Finance charges","amount":86029222.0,"comparison":"Original budget to audited outcome","percent_changed":292.84},{"item":"Other","amount":69620316.0,"comparison":"Original to adjusted budget","percent_changed":8.53},{"item":"Other","amount":271832563.0,"comparison":"Original budget to audited outcome","percent_changed":33.32},{"item":"Remuneration of councillors","amount":-2500000.0,"comparison":"Original to adjusted budget","percent_changed":-3.93},{"item":"Remuneration of councillors","amount":-3657240.0,"comparison":"Original budget to audited outcome","percent_changed":-5.75},{"item":"Transfers and subsidies","amount":718000.0,"comparison":"Original to adjusted budget","percent_changed":69.42},{"item":"Transfers and subsidies","amount":38300821.0,"comparison":"Original budget to audited outcome","percent_changed":3703.09}],"2023":[{"item":"Bulk purchases","amount":-24400000.0,"comparison":"Original to adjusted budget","percent_changed":-2.14},{"item":"Bulk purchases","amount":-27133144.0,"comparison":"Original budget to audited outcome","percent_changed":-2.38},{"item":"Contracted services","amount":15798266.0,"comparison":"Original to adjusted budget","percent_changed":3.45},{"item":"Contracted services","amount":145243492.0,"comparison":"Original budget to audited outcome","percent_changed":31.71},{"item":"Employee related costs","amount":655554.0,"comparison":"Original to adjusted budget","percent_changed":0.06},{"item":"Employee related costs","amount":67276677.0,"comparison":"Original budget to audited outcome","percent_changed":5.66},{"item":"Finance charges","amount":-5004620.0,"comparison":"Original to adjusted budget","percent_changed":-14.36},{"item":"Finance charges","amount":133835147.0,"comparison":"Original budget to audited outcome","percent_changed":384.06},{"item":"Other","amount":-34728603.0,"comparison":"Original to adjusted budget","percent_changed":-4.11},{"item":"Other","amount":457957751.0,"comparison":"Original budget to audited outcome","percent_changed":54.21},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-143723.0,"comparison":"Original budget to audited outcome","percent_changed":-0.23},{"item":"Transfers and subsidies","amount":14821767.0,"comparison":"Original to adjusted budget","percent_changed":811.48},{"item":"Transfers and subsidies","amount":45445237.0,"comparison":"Original budget to audited outcome","percent_changed":2488.1}],"2024":[{"item":"Bulk purchases","amount":-70000000.0,"comparison":"Original to adjusted budget","percent_changed":-5.33},{"item":"Bulk purchases","amount":10816234.0,"comparison":"Original budget to audited outcome","percent_changed":0.82},{"item":"Contracted services","amount":145952695.0,"comparison":"Original to adjusted budget","percent_changed":35.31},{"item":"Contracted services","amount":317408978.0,"comparison":"Original budget to audited outcome","percent_changed":76.79},{"item":"Employee related costs","amount":50000000.0,"comparison":"Original to adjusted budget","percent_changed":4.16},{"item":"Employee related costs","amount":126974483.0,"comparison":"Original budget to audited outcome","percent_changed":10.56},{"item":"Finance charges","amount":4297935.0,"comparison":"Original to adjusted budget","percent_changed":16.07},{"item":"Finance charges","amount":122703047.0,"comparison":"Original budget to audited outcome","percent_changed":458.89},{"item":"Other","amount":83572524.0,"comparison":"Original to adjusted budget","percent_changed":9.35},{"item":"Other","amount":317817731.0,"comparison":"Original budget to audited outcome","percent_changed":35.57},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-2221162.0,"comparison":"Original budget to audited outcome","percent_changed":-3.43},{"item":"Transfers and subsidies","amount":-2210804.0,"comparison":"Original to adjusted budget","percent_changed":-64.33},{"item":"Transfers and subsidies","amount":43292916.0,"comparison":"Original budget to audited outcome","percent_changed":1259.75}]},"spending_time_series":[{"amount":3610884727.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":3780027252.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":3696095891.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":4128000850.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":4062639812.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":4200679337.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":4551434964.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":4853180727.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":5063229822.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":4593195214.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":4952836860.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":3618653336.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":3353878269.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":3728953527.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":3916388500.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":4248685512.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":"bad","result":-66.43,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"bad","result":-67.29,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"bad","result":-66.47,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"bad","result":-73.76,"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":975218182.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":1754918417.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":23574544.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":94968866.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":6915328.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":169132.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":189507992.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":27.38},{"date":2023,"rating":"","result":27.6},{"date":2022,"rating":"","result":28.53},{"date":2021,"rating":"","result":28.25}],"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":17.6,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"bad","result":23.1,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"ave","result":11.1,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"ave","result":12.5,"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":6.07,"cube_version":"v2"},{"date":2023,"rating":"bad","result":5.01,"cube_version":"v2"},{"date":2022,"rating":"bad","result":6.6,"cube_version":"v2"},{"date":2021,"rating":"bad","result":3.36,"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":15.06},{"date":2023,"rating":"","result":13.26},{"date":2022,"rating":"","result":15.3},{"date":2021,"rating":"","result":16.87}],"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":84.5,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"bad","result":93.0,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"bad","result":94.11,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"bad","result":56.86,"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":210527874.0},{"year":2022,"value":239305268.0},{"year":2023,"value":225735120.0},{"year":2024,"value":260889659.0},{"year":2025,"value":283310103.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":1115429506.0},{"year":2022,"value":1313945568.0},{"year":2023,"value":1320011403.0},{"year":2024,"value":1574099962.0},{"year":2025,"value":1797867494.0}],"category":"Electricity "},{"values":[{"year":2021,"value":17273319.0},{"year":2022,"value":14072658.0},{"year":2023,"value":7351550.0},{"year":2024,"value":18125111.0},{"year":2025,"value":9004363.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":1128294201.0},{"year":2022,"value":1085210574.0},{"year":2023,"value":1381579904.0},{"year":2024,"value":1292672663.0},{"year":2025,"value":1342747030.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":36055040.0},{"year":2022,"value":12518323.0},{"year":2023,"value":25047883.0},{"year":2024,"value":13325930.0},{"year":2025,"value":12739977.0}],"category":"Housing"},{"values":[{"year":2021,"value":5707731.0},{"year":2022,"value":6359386.0},{"year":2023,"value":8500525.0},{"year":2024,"value":9267269.0},{"year":2025,"value":9843881.0}],"category":"Other"},{"values":[{"year":2021,"value":378268104.0},{"year":2022,"value":314958681.0},{"year":2023,"value":392461570.0},{"year":2024,"value":367064934.0},{"year":2025,"value":215920478.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":135517025.0},{"year":2022,"value":131494949.0},{"year":2023,"value":145826443.0},{"year":2024,"value":161329246.0},{"year":2025,"value":169804926.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":447288691.0},{"year":2022,"value":432075547.0},{"year":2023,"value":329806355.0},{"year":2024,"value":347101543.0},{"year":2025,"value":401848761.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":98508365.0},{"year":2022,"value":181685227.0},{"year":2023,"value":130694747.0},{"year":2024,"value":125269463.0},{"year":2025,"value":111553247.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":489769956.0},{"year":2022,"value":469053156.0},{"year":2023,"value":584419464.0},{"year":2024,"value":684034947.0},{"year":2025,"value":708589562.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":"MP326"},"muni_contact":{"url":"http://www.mbombela.gov.za","phone_number":"013 759 9111","street_address_1":"Civic Centre","street_address_2":"1 Nel Street","street_address_3":"Mbombela","street_address_4":"1200"},"mayoral_staff":{"officials":[{"name":"Sibongile Makushe","role":"Mayor/Executive Mayor","email":"sibongile.makushe@mbombela.gov.za","title":"Ms","secretary":{"name":"Sifiso Shabangu","role":"Secretary of Mayor/Executive Mayor","email":"sifiso.shabangu@mbombela.gov.za","title":"Mr","fax_number":"013 759 2253","office_phone":"013 759 9279"},"fax_number":"013 759 2253","office_phone":"013 759 2003"},{"name":"Wiseman Khumalo","role":"Municipal Manager","email":"wiseman.khumalo@mbombela.gov.za","title":"Mr","secretary":{"name":"Busi Sithole","role":"Secretary of Municipal Manager","email":"busi.sithole@mbombela.gov.za","title":"Ms","fax_number":"013 759 9055","office_phone":"013 759 9328"},"fax_number":"013 759 9055","office_phone":"013 759 9060"},{"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":"Sabelo Abednigo Dube","role":"Chief Financial Officer","email":"sabelo.dube@mbombela.gov.za","title":"Mr","secretary":{"name":"Gugu Ngomane","role":"Secretary of Financial Manager","email":"gugu.ngomane@mbombela.gov.za","title":"Ms","fax_number":"013 759 9055","office_phone":"013 759 2005"},"fax_number":"013 759 9055","office_phone":"013 759 9024"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/MP326/MP326_Audit%20Report_2024_Y_20250114T090952Z_hazel_mhlabane.pdf"},{"date":2023,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/MP326/MP326_Audit%20Report_2023_Y_20231206T113130Z_quintonv.pdf"},{"date":2022,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/MP326/MP326_Audit%20Report_2022_Y_20230201T153739Z_quintonv.pdf"},{"date":2021,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/MP326/MP326_Audit%20Report_2021_Y_20220218T082513Z_5039.pdf"}]}}