{"indicators":{"grants":{"totals":{"2021":{"ACT":{"national_conditional_grants":410533600.0},"ORGB":{"equitable_share":3444498000.0,"national_conditional_grants":2988446000.0},"SCHD":{"national_conditional_grants":837975000.0},"TRFR":{"national_conditional_grants":287798000.0}},"2022":{"ACT":{"national_conditional_grants":907140380.0},"ORGB":{"equitable_share":3580447000.0,"national_conditional_grants":2996863000.0},"SCHD":{"national_conditional_grants":2123860000.0},"TRFR":{"national_conditional_grants":2111543000.0}},"2023":{"ACT":{"national_conditional_grants":2663858068.0},"ORGB":{"equitable_share":4057189000.0,"provincial_transfers":1158234000.0,"national_conditional_grants":3401197000.0},"SCHD":{"national_conditional_grants":3712948000.0},"TRFR":{"national_conditional_grants":3663554000.0}},"2024":{"ACT":{"national_conditional_grants":4281148664.0},"ORGB":{"equitable_share":4497334000.0,"national_conditional_grants":3551153000.0},"SCHD":{"national_conditional_grants":1779461000.0},"TRFR":{"national_conditional_grants":1743215000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":3444498000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":3580447000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":4057189000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":4497334000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":256596000.0,"grant.code":"0002","grant.label":"Health","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":500485000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":70712000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":327641000.0,"grant.code":"0007","grant.label":"Housing and Local Government","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":2800000.0,"grant.code":"0009","grant.label":"Other Departments","amount_type.code":"ORGB","financial_year_end.year":2023}]},"national_conditional_grants":{"2021":[{"amount.sum":9000000.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":3000000.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":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1404997.0,"grant.code":"ICDG","grant.label":"Integrated City Development Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":-449347.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":15397598.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":32327000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":19000000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":8029456.0,"grant.code":"MEHG","grant.label":"Municipal Emergency Housing Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":3205215.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":500000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":331000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":20431861.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":56700000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":48759000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":185305280.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":659256000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":195910000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":60597768.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":79192000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":19798000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":116610772.0,"grant.code":"USDG","grant.label":"Urban Settlement Development Grant","amount_type.code":"ACT","financial_year_end.year":2021}],"2022":[{"amount.sum":9000000.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":9000000.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":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":7740000.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":290380.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":33500000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":33500000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":333553000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":829536000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":829536000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":5000000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":423000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":333732000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":333732000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":49949000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":49949000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":772712000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":772712000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":81691000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":81691000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":573297000.0,"grant.code":"USDG","grant.label":"Urban Settlement Development Grant","amount_type.code":"ACT","financial_year_end.year":2022}],"2023":[{"amount.sum":91706567.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1534785000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1534785000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":185000000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":185000000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":226518.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":9000000.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":9000000.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":999999.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":47554000.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":28628349.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":35500000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":35500000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":-74674445.0,"grant.code":"MEHG","grant.label":"Municipal Emergency Housing Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":673237000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":819371000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":819371000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1840000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":345803763.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":192924000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":192924000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":61324000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":61324000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":357637317.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":763393000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":763393000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":61257000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":61257000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":61257000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1179036000.0,"grant.code":"USDG","grant.label":"Urban Settlement Development Grant","amount_type.code":"ACT","financial_year_end.year":2023}],"2024":[{"amount.sum":1346471816.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":16442000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":16442000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":106870168.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":6320120.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":8000000.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":8000000.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":999999.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":19580000.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":28194163.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":29470000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":29470000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":751140070.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":769653000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":769653000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":16666000.0,"grant.code":"MS6G","grant.label":"Municipal Systems Improvement Grant (Sched 6)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":205139419.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":225523000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":225523000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":18836807.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":30000000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":30000000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":430332102.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":602337000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":602337000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":60790000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":60790000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":60790000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1326054000.0,"grant.code":"USDG","grant.label":"Urban Settlement Development 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":"good","result":9605546916.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":8061390826.0,"cube_version":"v2"},{"date":2022,"rating":"bad","result":-226612765.0,"cube_version":"v2"},{"date":2021,"rating":"bad","result":-132739875.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":"ave","result":2.1,"cube_version":"v2"},{"date":2023,"rating":"ave","result":2.1,"cube_version":"v2"},{"date":2022,"rating":"bad","result":0,"cube_version":"v2"},{"date":2021,"rating":"bad","result":0.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":1558477861.0,"rating":"bad","result":0.63,"amount_type":"AUDA","liabilities":2487149763.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":5978862401.0,"rating":"good","result":2.27,"amount_type":"AUDA","liabilities":2630607191.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":260836918.0,"rating":"bad","result":0.61,"amount_type":"AUDA","liabilities":429052709.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":1527587547.0,"rating":"ave","result":1.13,"amount_type":"AUDA","liabilities":1356010967.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":-335647823.0,"date":"2024","year":2024,"rating":"bad","result":-0.13,"amount_type":"ACT","liabilities":2487149763.0,"cube_version":"v2","call_investment_deposits":0},{"cash":3516932444.0,"date":"2023","year":2023,"rating":"good","result":1.34,"amount_type":"ACT","liabilities":2630607191.0,"cube_version":"v2","call_investment_deposits":0},{"cash":-160598294.0,"date":"2022","year":2022,"rating":"bad","result":-0.37,"amount_type":"ACT","liabilities":429052709.0,"cube_version":"v2","call_investment_deposits":0},{"cash":758799192.0,"date":"2021","year":2021,"rating":"bad","result":0.56,"amount_type":"ACT","liabilities":1356010967.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":49129105515.0,"percent":89.47},"total":54910296140.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":5781190625.0,"percent":10.53}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":2.92,"cube_version":"v2"},{"date":2023,"rating":"bad","result":5.13,"cube_version":"v2"},{"date":2022,"rating":"bad","result":3.38,"cube_version":"v2"},{"date":2021,"rating":"bad","result":1.89,"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":2684219.0,"comparison":"Original to adjusted budget","percent_changed":3.67},{"item":"Fines","amount":117181580.0,"comparison":"Original budget to audited outcome","percent_changed":160.26},{"item":"Government Transfers","amount":618609420.0,"comparison":"Original to adjusted budget","percent_changed":15.12},{"item":"Government Transfers","amount":409901584.0,"comparison":"Original budget to audited outcome","percent_changed":10.02},{"item":"Interest and investments","amount":-270432877.0,"comparison":"Original to adjusted budget","percent_changed":-28.26},{"item":"Interest and investments","amount":-716235060.0,"comparison":"Original budget to audited outcome","percent_changed":-74.84},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-4904691.0,"comparison":"Original budget to audited outcome","percent_changed":-12.37},{"item":"Other","amount":-104545586.0,"comparison":"Original to adjusted budget","percent_changed":-3.1},{"item":"Other","amount":-141385620.0,"comparison":"Original budget to audited outcome","percent_changed":-4.19},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-105578615.0,"comparison":"Original budget to audited outcome","percent_changed":-1.13},{"item":"Rental income","amount":-125193552.0,"comparison":"Original to adjusted budget","percent_changed":-13.41},{"item":"Rental income","amount":-184763882.0,"comparison":"Original budget to audited outcome","percent_changed":-19.8},{"item":"Service Charges","amount":255108900.0,"comparison":"Original to adjusted budget","percent_changed":1.18},{"item":"Service Charges","amount":-518895445.0,"comparison":"Original budget to audited outcome","percent_changed":-2.41}],"2022":[{"item":"Fines","amount":169450.0,"comparison":"Original to adjusted budget","percent_changed":0.24},{"item":"Fines","amount":69868773.0,"comparison":"Original budget to audited outcome","percent_changed":99.05},{"item":"Government Transfers","amount":224484232.0,"comparison":"Original to adjusted budget","percent_changed":5.09},{"item":"Government Transfers","amount":-155816008.0,"comparison":"Original budget to audited outcome","percent_changed":-3.54},{"item":"Interest and investments","amount":-494943.0,"comparison":"Original to adjusted budget","percent_changed":-0.08},{"item":"Interest and investments","amount":125698019.0,"comparison":"Original budget to audited outcome","percent_changed":20.06},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":3414670.0,"comparison":"Original budget to audited outcome","percent_changed":8.37},{"item":"Other","amount":-31101583.0,"comparison":"Original to adjusted budget","percent_changed":-0.9},{"item":"Other","amount":1041093856.0,"comparison":"Original budget to audited outcome","percent_changed":30.13},{"item":"Property rates","amount":-202000000.0,"comparison":"Original to adjusted budget","percent_changed":-1.98},{"item":"Property rates","amount":-458542369.0,"comparison":"Original budget to audited outcome","percent_changed":-4.49},{"item":"Rental income","amount":15936346.0,"comparison":"Original to adjusted budget","percent_changed":1.81},{"item":"Rental income","amount":-43277504.0,"comparison":"Original budget to audited outcome","percent_changed":-4.91},{"item":"Service Charges","amount":-317608000.0,"comparison":"Original to adjusted budget","percent_changed":-1.33},{"item":"Service Charges","amount":-1395320727.0,"comparison":"Original budget to audited outcome","percent_changed":-5.86}],"2023":[{"item":"Fines","amount":-606204.0,"comparison":"Original to adjusted budget","percent_changed":-1.25},{"item":"Fines","amount":197071064.0,"comparison":"Original budget to audited outcome","percent_changed":407.57},{"item":"Government Transfers","amount":164569430.0,"comparison":"Original to adjusted budget","percent_changed":3.22},{"item":"Government Transfers","amount":-61772159.0,"comparison":"Original budget to audited outcome","percent_changed":-1.21},{"item":"Interest and investments","amount":284394846.0,"comparison":"Original to adjusted budget","percent_changed":37.39},{"item":"Interest and investments","amount":1266762540.0,"comparison":"Original budget to audited outcome","percent_changed":166.53},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":30269435.0,"comparison":"Original budget to audited outcome","percent_changed":97.24},{"item":"Other","amount":422126863.0,"comparison":"Original to adjusted budget","percent_changed":10.93},{"item":"Other","amount":778933754.0,"comparison":"Original budget to audited outcome","percent_changed":20.17},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":1228641890.0,"comparison":"Original budget to audited outcome","percent_changed":11.47},{"item":"Rental income","amount":34405578.0,"comparison":"Original to adjusted budget","percent_changed":3.87},{"item":"Rental income","amount":93811712.0,"comparison":"Original budget to audited outcome","percent_changed":10.54},{"item":"Service Charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":-834866776.0,"comparison":"Original budget to audited outcome","percent_changed":-3.37}],"2024":[{"item":"Fines","amount":-16568.0,"comparison":"Original to adjusted budget","percent_changed":-0.04},{"item":"Fines","amount":189690579.0,"comparison":"Original budget to audited outcome","percent_changed":443.88},{"item":"Government Transfers","amount":119588767.0,"comparison":"Original to adjusted budget","percent_changed":2.14},{"item":"Government Transfers","amount":202298615.0,"comparison":"Original budget to audited outcome","percent_changed":3.63},{"item":"Interest and investments","amount":361201149.0,"comparison":"Original to adjusted budget","percent_changed":25.4},{"item":"Interest and investments","amount":1537908346.0,"comparison":"Original budget to audited outcome","percent_changed":108.15},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-4049626.0,"comparison":"Original budget to audited outcome","percent_changed":-7.12},{"item":"Other","amount":-24829062.0,"comparison":"Original to adjusted budget","percent_changed":-0.54},{"item":"Other","amount":530213959.0,"comparison":"Original budget to audited outcome","percent_changed":11.47},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":1580864113.0,"comparison":"Original budget to audited outcome","percent_changed":14.37},{"item":"Rental income","amount":-17191990.0,"comparison":"Original to adjusted budget","percent_changed":-1.64},{"item":"Rental income","amount":-35887485.0,"comparison":"Original budget to audited outcome","percent_changed":-3.42},{"item":"Service Charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":-1653658031.0,"comparison":"Original budget to audited outcome","percent_changed":-5.74}]},"income_time_series":[{"amount":40740353044.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":43187005362.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":47070986813.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":53001667966.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":39219442371.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":42684738570.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":48864947760.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":54910296140.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":58452293320.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":60594713850.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":66811374810.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":40364122520.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":43497619860.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":46166096300.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":52562915670.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":56060883310.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":414831800.0,"comparison":"Original to adjusted budget","percent_changed":4.06},{"item":"Bulk purchases","amount":393207086.0,"comparison":"Original budget to audited outcome","percent_changed":3.85},{"item":"Contracted services","amount":-376057287.0,"comparison":"Original to adjusted budget","percent_changed":-7.62},{"item":"Contracted services","amount":-409922135.0,"comparison":"Original budget to audited outcome","percent_changed":-8.3},{"item":"Employee related costs","amount":479243322.0,"comparison":"Original to adjusted budget","percent_changed":4.46},{"item":"Employee related costs","amount":1874029359.0,"comparison":"Original budget to audited outcome","percent_changed":17.43},{"item":"Finance charges","amount":-58687446.0,"comparison":"Original to adjusted budget","percent_changed":-6.94},{"item":"Finance charges","amount":-20875101.0,"comparison":"Original budget to audited outcome","percent_changed":-2.47},{"item":"Other","amount":-549268677.0,"comparison":"Original to adjusted budget","percent_changed":-4.33},{"item":"Other","amount":-595086512.0,"comparison":"Original budget to audited outcome","percent_changed":-4.69},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-12088015.0,"comparison":"Original budget to audited outcome","percent_changed":-8.64},{"item":"Transfers and subsidies","amount":49833391.0,"comparison":"Original to adjusted budget","percent_changed":8.77},{"item":"Transfers and subsidies","amount":-42309249.0,"comparison":"Original budget to audited outcome","percent_changed":-7.45}],"2022":[{"item":"Bulk purchases","amount":-317067160.0,"comparison":"Original to adjusted budget","percent_changed":-2.53},{"item":"Bulk purchases","amount":-473170336.0,"comparison":"Original budget to audited outcome","percent_changed":-3.78},{"item":"Contracted services","amount":340377867.0,"comparison":"Original to adjusted budget","percent_changed":6.67},{"item":"Contracted services","amount":-7456371.0,"comparison":"Original budget to audited outcome","percent_changed":-0.15},{"item":"Employee related costs","amount":-192761903.0,"comparison":"Original to adjusted budget","percent_changed":-1.59},{"item":"Employee related costs","amount":208736438.0,"comparison":"Original budget to audited outcome","percent_changed":1.73},{"item":"Finance charges","amount":150000.0,"comparison":"Original to adjusted budget","percent_changed":0.02},{"item":"Finance charges","amount":17057973.0,"comparison":"Original budget to audited outcome","percent_changed":1.92},{"item":"Other","amount":-99341579.0,"comparison":"Original to adjusted budget","percent_changed":-0.82},{"item":"Other","amount":1179520067.0,"comparison":"Original budget to audited outcome","percent_changed":9.68},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-7749870.0,"comparison":"Original budget to audited outcome","percent_changed":-5.47},{"item":"Transfers and subsidies","amount":136515151.0,"comparison":"Original to adjusted budget","percent_changed":24.39},{"item":"Transfers and subsidies","amount":-70082726.0,"comparison":"Original budget to audited outcome","percent_changed":-12.52}],"2023":[{"item":"Bulk purchases","amount":-256024800.0,"comparison":"Original to adjusted budget","percent_changed":-1.93},{"item":"Bulk purchases","amount":-532159203.0,"comparison":"Original budget to audited outcome","percent_changed":-4.01},{"item":"Contracted services","amount":337990526.0,"comparison":"Original to adjusted budget","percent_changed":6.21},{"item":"Contracted services","amount":209812816.0,"comparison":"Original budget to audited outcome","percent_changed":3.86},{"item":"Employee related costs","amount":-31318794.0,"comparison":"Original to adjusted budget","percent_changed":-0.25},{"item":"Employee related costs","amount":-341912527.0,"comparison":"Original budget to audited outcome","percent_changed":-2.68},{"item":"Finance charges","amount":93088.0,"comparison":"Original to adjusted budget","percent_changed":0.01},{"item":"Finance charges","amount":61482674.0,"comparison":"Original budget to audited outcome","percent_changed":6.83},{"item":"Other","amount":503658025.0,"comparison":"Original to adjusted budget","percent_changed":3.99},{"item":"Other","amount":1707552488.0,"comparison":"Original budget to audited outcome","percent_changed":13.52},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-2908771.0,"comparison":"Original budget to audited outcome","percent_changed":-2.1},{"item":"Transfers and subsidies","amount":-16088808.0,"comparison":"Original to adjusted budget","percent_changed":-2.32},{"item":"Transfers and subsidies","amount":-4916539.0,"comparison":"Original budget to audited outcome","percent_changed":-0.71}],"2024":[{"item":"Bulk purchases","amount":-320000000.0,"comparison":"Original to adjusted budget","percent_changed":-2.11},{"item":"Bulk purchases","amount":-300472706.0,"comparison":"Original budget to audited outcome","percent_changed":-1.98},{"item":"Contracted services","amount":798527750.0,"comparison":"Original to adjusted budget","percent_changed":12.32},{"item":"Contracted services","amount":239885693.0,"comparison":"Original budget to audited outcome","percent_changed":3.7},{"item":"Employee related costs","amount":-228276131.0,"comparison":"Original to adjusted budget","percent_changed":-1.67},{"item":"Employee related costs","amount":-231323664.0,"comparison":"Original budget to audited outcome","percent_changed":-1.7},{"item":"Finance charges","amount":-11929402.0,"comparison":"Original to adjusted budget","percent_changed":-1.2},{"item":"Finance charges","amount":43646274.0,"comparison":"Original budget to audited outcome","percent_changed":4.39},{"item":"Other","amount":352039024.0,"comparison":"Original to adjusted budget","percent_changed":2.32},{"item":"Other","amount":3250043098.0,"comparison":"Original budget to audited outcome","percent_changed":21.43},{"item":"Remuneration of councillors","amount":138247.0,"comparison":"Original to adjusted budget","percent_changed":0.1},{"item":"Remuneration of councillors","amount":-3126001.0,"comparison":"Original budget to audited outcome","percent_changed":-2.15},{"item":"Transfers and subsidies","amount":41683664.0,"comparison":"Original to adjusted budget","percent_changed":5.87},{"item":"Transfers and subsidies","amount":200602305.0,"comparison":"Original budget to audited outcome","percent_changed":28.25}]},"spending_time_series":[{"amount":40121705663.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":43356553486.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":46376201567.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":52921651732.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":41348765993.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":44335536285.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":46934843268.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":55488723579.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":60881623239.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":60446332690.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":66463844160.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":40161810560.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":43488681110.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":45837892330.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":52289468580.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":55640743920.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":-11.78,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"bad","result":-28.98,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"bad","result":-29.16,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"bad","result":-27.6,"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":12580864123.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":27136123959.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":1014745145.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":2959891106.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":232424759.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":52857534.0,"amount_type":"AUDA"},{"date":"2024","item":"Agency services","amount":28719363.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":5123479526.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":24.18},{"date":2023,"rating":"","result":26.48},{"date":2022,"rating":"","result":27.74},{"date":2021,"rating":"","result":30.53}],"formula":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp","item_codes":["3000","3100"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp_v2","item_codes":["3100"],"amount_type":"AUDA"}]},"result_type":"%"},"operating_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2024,"rating":"good","result":4.9,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"good","result":1.2,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"good","result":2.3,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"good","result":3.1,"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":"good","result":109.51,"cube_version":"v2"},{"date":2023,"rating":"good","result":215.89,"cube_version":"v2"},{"date":2022,"rating":"good","result":309.9,"cube_version":"v2"},{"date":2021,"rating":"good","result":243.9,"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":12.11},{"date":2023,"rating":"","result":12.03},{"date":2022,"rating":"","result":11.49},{"date":2021,"rating":"","result":10.95}],"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":23.09,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"bad","result":21.13,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"bad","result":-0.63,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"bad","result":-0.42,"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":2966286883.0},{"year":2022,"value":2988028197.0},{"year":2023,"value":3050060725.0},{"year":2024,"value":3375301822.0},{"year":2025,"value":3657138162.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":14047468309.0},{"year":2022,"value":15981454100.0},{"year":2023,"value":16916209860.0},{"year":2024,"value":19794535350.0},{"year":2025,"value":22000345983.0}],"category":"Electricity "},{"values":[{"year":2021,"value":258321134.0},{"year":2022,"value":248597407.0},{"year":2023,"value":234928047.0},{"year":2024,"value":252379376.0},{"year":2025,"value":253695870.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":8080146203.0},{"year":2022,"value":7934234795.0},{"year":2023,"value":8301721772.0},{"year":2024,"value":10248817262.0},{"year":2025,"value":9993380687.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":610450484.0},{"year":2022,"value":603609397.0},{"year":2023,"value":594287183.0},{"year":2024,"value":614889505.0},{"year":2025,"value":641267357.0}],"category":"Health"},{"values":[{"year":2021,"value":329216155.0},{"year":2022,"value":660479501.0},{"year":2023,"value":633813924.0},{"year":2024,"value":859752142.0},{"year":2025,"value":1149208516.0}],"category":"Housing"},{"values":[{"year":2021,"value":232526682.0},{"year":2022,"value":237315072.0},{"year":2023,"value":237514729.0},{"year":2024,"value":262892612.0},{"year":2025,"value":288710650.0}],"category":"Other"},{"values":[{"year":2021,"value":2581491615.0},{"year":2022,"value":2892944849.0},{"year":2023,"value":3174703806.0},{"year":2024,"value":3348133283.0},{"year":2025,"value":3455534286.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":1808861029.0},{"year":2022,"value":1830487977.0},{"year":2023,"value":1748046447.0},{"year":2024,"value":1871542319.0},{"year":2025,"value":2081435711.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":1365732268.0},{"year":2022,"value":1426647188.0},{"year":2023,"value":1512079754.0},{"year":2024,"value":1597381840.0},{"year":2025,"value":1625708810.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":1890255529.0},{"year":2022,"value":2077149193.0},{"year":2023,"value":2397940534.0},{"year":2024,"value":2965355401.0},{"year":2025,"value":3447572895.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":7178009702.0},{"year":2022,"value":7454588609.0},{"year":2023,"value":8133536487.0},{"year":2024,"value":10297742667.0},{"year":2025,"value":12287624312.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":"ETH"},"muni_contact":{"url":"http://www.Durban.Gov.Za","phone_number":"031 311 1111","street_address_1":"City Hall","street_address_2":"263 Dr Pixley Kaseme Street","street_address_3":"Durban","street_address_4":"4001"},"mayoral_staff":{"officials":[{"name":"Cyril Xaba","role":"Mayor/Executive Mayor","email":"cyril.xaba@durban.gov.za","title":"Mr","secretary":{"name":"Nokukhanya Mkhize","role":"Secretary of Mayor/Executive Mayor","email":"nokukhanya.mkhize@durban.gov.za","title":"Ms","fax_number":"031 311 2111","office_phone":"031 311 2110"},"fax_number":" ","office_phone":"031 311 2110"},{"name":"Thompson Bongumusa Mbhele (Known As Musa","role":"Municipal Manager","email":"Musa.Mbhele@durban.gov.za","title":"Mr","secretary":{"name":"Zanele Ncube","role":"Secretary of Municipal Manager","email":"Zanele.Ncube2@durban.gov.za","title":"Ms","fax_number":"031 311 2170","office_phone":"031 311 2132"},"fax_number":"031 311 2170","office_phone":"031 311 2132"},{"name":"Zandile Prudence Myeni","role":"Deputy Mayor/Executive Mayor","email":" Zandile.Myeni@durban.gov.za","title":"Ms","secretary":{"name":"Thembelihle Dlamini","role":"Secretary of Deputy Mayor/Executive Mayor","email":"nompumelelo.mbhele@durban.gov.za","title":"Ms","fax_number":"031 311 2049","office_phone":"031 322 9475"},"fax_number":" ","office_phone":"031 322 9475"},{"name":"Sandile Mnguni","role":"Chief Financial Officer","email":"sandile.mnguni@durban.gov.za","title":"Mr","secretary":{"name":"Soraya Marnitz","role":"Secretary of Financial Manager","email":"soraya.marnitz@durban.gov.za","title":"Ms","fax_number":"031 305 2730","office_phone":"031 311 1101"},"fax_number":"031 305 2730","office_phone":"031 311 1101"}],"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/ETH/ETH_Audit%20Report_2024_Y_20241211T140608Z_kuselo_nteleko.pdf"},{"date":2023,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/ETH/ETH_Audit%20Report_2023_Y_20240108T120955Z_kuselo_nteleko.pdf"},{"date":2022,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/ETH/ETH_Audit%20Report_2022_Y_20230127T095933Z_kuselo_nteleko.pdf"},{"date":2021,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/ETH/ETH_Audit%20Report_2021_Y_20220303T105151Z_1671.pdf"}]}}