{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":10013434.0,"national_conditional_grants":215978160.0},"ORGB":{"equitable_share":756697000.0,"national_conditional_grants":584990000.0},"SCHD":{"national_conditional_grants":529833000.0},"TRFR":{"national_conditional_grants":116591000.0}},"2022":{"ACT":{"national_conditional_grants":115981390.0},"ORGB":{"equitable_share":808419000.0,"national_conditional_grants":601046000.0},"SCHD":{"national_conditional_grants":545283000.0},"TRFR":{"national_conditional_grants":522600000.0}},"2023":{"ACT":{"national_conditional_grants":736547969.0},"ORGB":{"equitable_share":941352000.0,"provincial_transfers":5264000.0,"national_conditional_grants":659575000.0},"SCHD":{"national_conditional_grants":771469000.0},"TRFR":{"national_conditional_grants":650463000.0}},"2024":{"ACT":{"national_conditional_grants":758034349.0},"ORGB":{"equitable_share":1072059000.0,"national_conditional_grants":744018000.0},"SCHD":{"national_conditional_grants":971016000.0},"TRFR":{"national_conditional_grants":950230000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":10013434.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":756697000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":808419000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":941352000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":1072059000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":3555000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":1709000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023}]},"national_conditional_grants":{"2021":[{"amount.sum":1341000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1341000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":4500000.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":296571.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1700000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1700000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":2000000.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":12687390.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":2000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":26840492.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":233448000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":34460000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":2000000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":300000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":3126772.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":10000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":21661619.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":194282000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":57734000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":711340.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":5422000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1356000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":150653976.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":72840000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":20000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021}],"2022":[{"amount.sum":4500000.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":4500000.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":1650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":22583000.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":-4845920.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":8000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":8000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":75682434.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":249229000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":249229000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":100000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":4184000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":4184000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":42965653.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":213649000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":213649000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":2179223.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":6388000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":6388000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":35000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":35000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":207231.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":2343957.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1700000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1700000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":43671000.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":14618289.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":26000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":26000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":279448122.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":308524000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":231189000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":791453.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","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":425978875.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":338721000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":338721000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1683930.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":2853000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":2853000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":11476112.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":49000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":49000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":4328482.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":5000000.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":5000000.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":1700000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1700000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1700000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":20786000.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":15367988.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":31000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":31000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":214426294.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":271731000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":271731000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":823757.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":476750564.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":568603000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":568603000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":2045470.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":2196000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":2196000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":42591794.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":65000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":65000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024}]}},"cash_balance":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"good","result":31674462463.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":17608175622.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":6715325926.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":5156716608.0,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"}]},"result_type":"R"},"cash_coverage":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"good","result":58.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":29.8,"cube_version":"v2"},{"date":2022,"rating":"good","result":12.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":12.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":1360051415.0,"rating":"bad","result":0.56,"amount_type":"AUDA","liabilities":2444527797.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":1172229029.0,"rating":"bad","result":0.51,"amount_type":"AUDA","liabilities":2277776321.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":1266616741.0,"rating":"bad","result":0.57,"amount_type":"AUDA","liabilities":2235458145.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":1016809875.0,"rating":"bad","result":0.52,"amount_type":"AUDA","liabilities":1953305568.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":979908897.0,"date":"2024","year":2024,"rating":"bad","result":0.4,"amount_type":"ACT","liabilities":2444527797.0,"cube_version":"v2","call_investment_deposits":0},{"cash":861511545.0,"date":"2023","year":2023,"rating":"bad","result":0.38,"amount_type":"ACT","liabilities":2277776321.0,"cube_version":"v2","call_investment_deposits":0},{"cash":667525319.0,"date":"2022","year":2022,"rating":"bad","result":0.3,"amount_type":"ACT","liabilities":2235458145.0,"cube_version":"v2","call_investment_deposits":0},{"cash":504429089.0,"date":"2021","year":2021,"rating":"bad","result":0.26,"amount_type":"ACT","liabilities":1953305568.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":4380791245.0,"percent":73.01},"total":6000410651.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":1619619406.0,"percent":26.99}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":5.02,"cube_version":"v2"},{"date":2023,"rating":"bad","result":6.07,"cube_version":"v2"},{"date":2022,"rating":"bad","result":7.41,"cube_version":"v2"},{"date":2021,"rating":"bad","result":11.96,"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":7284013.0,"comparison":"Original budget to audited outcome","percent_changed":80.93},{"item":"Government Transfers","amount":99932452.0,"comparison":"Original to adjusted budget","percent_changed":11.51},{"item":"Government Transfers","amount":4052805.0,"comparison":"Original budget to audited outcome","percent_changed":0.47},{"item":"Interest and investments","amount":-4544266.0,"comparison":"Original to adjusted budget","percent_changed":-1.08},{"item":"Interest and investments","amount":-52522064.0,"comparison":"Original budget to audited outcome","percent_changed":-12.42},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-9152519.0,"comparison":"Original budget to audited outcome","percent_changed":-76.83},{"item":"Other","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Other","amount":36152204.0,"comparison":"Original budget to audited outcome","percent_changed":27.83},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":14646235.0,"comparison":"Original budget to audited outcome","percent_changed":3.68},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":-524637.0,"comparison":"Original budget to audited outcome","percent_changed":-5.0},{"item":"Service Charges","amount":-66399999.0,"comparison":"Original to adjusted budget","percent_changed":-1.99},{"item":"Service Charges","amount":-205900082.0,"comparison":"Original budget to audited outcome","percent_changed":-6.16}],"2022":[{"item":"Fines","amount":-100000.0,"comparison":"Original to adjusted budget","percent_changed":-1.07},{"item":"Fines","amount":10058456.0,"comparison":"Original budget to audited outcome","percent_changed":107.36},{"item":"Government Transfers","amount":-426552.0,"comparison":"Original to adjusted budget","percent_changed":-0.05},{"item":"Government Transfers","amount":5983736.0,"comparison":"Original budget to audited outcome","percent_changed":0.63},{"item":"Interest and investments","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":-9687265.0,"comparison":"Original budget to audited outcome","percent_changed":-2.22},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-12246979.0,"comparison":"Original budget to audited outcome","percent_changed":-98.76},{"item":"Other","amount":54028556.0,"comparison":"Original to adjusted budget","percent_changed":42.26},{"item":"Other","amount":62672894.0,"comparison":"Original budget to audited outcome","percent_changed":49.02},{"item":"Property rates","amount":1.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":276625238.0,"comparison":"Original budget to audited outcome","percent_changed":55.76},{"item":"Rental income","amount":1000000.0,"comparison":"Original to adjusted budget","percent_changed":9.03},{"item":"Rental income","amount":329951.0,"comparison":"Original budget to audited outcome","percent_changed":2.98},{"item":"Service Charges","amount":839417164.0,"comparison":"Original to adjusted budget","percent_changed":23.13},{"item":"Service Charges","amount":529354056.0,"comparison":"Original budget to audited outcome","percent_changed":14.59}],"2023":[{"item":"Fines","amount":-54.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":9912726.0,"comparison":"Original budget to audited outcome","percent_changed":105.46},{"item":"Government Transfers","amount":-110458.0,"comparison":"Original to adjusted budget","percent_changed":-0.01},{"item":"Government Transfers","amount":228126056.0,"comparison":"Original budget to audited outcome","percent_changed":20.24},{"item":"Interest and investments","amount":30000000.0,"comparison":"Original to adjusted budget","percent_changed":6.6},{"item":"Interest and investments","amount":63460606.0,"comparison":"Original budget to audited outcome","percent_changed":13.97},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-4580585.0,"comparison":"Original budget to audited outcome","percent_changed":-40.58},{"item":"Other","amount":-19372151.0,"comparison":"Original to adjusted budget","percent_changed":-14.29},{"item":"Other","amount":23903160.0,"comparison":"Original budget to audited outcome","percent_changed":17.64},{"item":"Property rates","amount":10000000.0,"comparison":"Original to adjusted budget","percent_changed":1.93},{"item":"Property rates","amount":-23367464.0,"comparison":"Original budget to audited outcome","percent_changed":-4.52},{"item":"Rental income","amount":-1500000.0,"comparison":"Original to adjusted budget","percent_changed":-10.65},{"item":"Rental income","amount":-4483144.0,"comparison":"Original budget to audited outcome","percent_changed":-31.84},{"item":"Service Charges","amount":-10000000.0,"comparison":"Original to adjusted budget","percent_changed":-0.21},{"item":"Service Charges","amount":-486059062.0,"comparison":"Original budget to audited outcome","percent_changed":-10.11}],"2024":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":6339092.0,"comparison":"Original budget to audited outcome","percent_changed":66.12},{"item":"Government Transfers","amount":31887286.0,"comparison":"Original to adjusted budget","percent_changed":2.5},{"item":"Government Transfers","amount":346426835.0,"comparison":"Original budget to audited outcome","percent_changed":27.21},{"item":"Interest and investments","amount":60000000.0,"comparison":"Original to adjusted budget","percent_changed":11.87},{"item":"Interest and investments","amount":221656987.0,"comparison":"Original budget to audited outcome","percent_changed":43.87},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":2333908.0,"comparison":"Original budget to audited outcome","percent_changed":19.24},{"item":"Other","amount":13997000.0,"comparison":"Original to adjusted budget","percent_changed":11.48},{"item":"Other","amount":67057241.0,"comparison":"Original budget to audited outcome","percent_changed":54.98},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-28044398.0,"comparison":"Original budget to audited outcome","percent_changed":-5.1},{"item":"Rental income","amount":-1838132.0,"comparison":"Original to adjusted budget","percent_changed":-11.59},{"item":"Rental income","amount":-4139511.0,"comparison":"Original budget to audited outcome","percent_changed":-26.1},{"item":"Service Charges","amount":-219937711.0,"comparison":"Original to adjusted budget","percent_changed":-4.01},{"item":"Service Charges","amount":-2578674955.0,"comparison":"Original budget to audited outcome","percent_changed":-47.06}]},"income_time_series":[{"amount":5219737101.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":6563657623.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":7083827634.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":7851563895.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":4984784869.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":6532828541.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":6881722590.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":6000410651.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":6470934707.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":8474321624.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":8880272725.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":5190748914.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":5669738454.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":7074810297.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":7967455452.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":8072585801.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":439555113.0,"comparison":"Original to adjusted budget","percent_changed":40.85},{"item":"Bulk purchases","amount":1015204168.0,"comparison":"Original budget to audited outcome","percent_changed":94.35},{"item":"Contracted services","amount":91125007.0,"comparison":"Original to adjusted budget","percent_changed":25.79},{"item":"Contracted services","amount":40674081.0,"comparison":"Original budget to audited outcome","percent_changed":11.51},{"item":"Employee related costs","amount":6610393.0,"comparison":"Original to adjusted budget","percent_changed":0.83},{"item":"Employee related costs","amount":-31889797.0,"comparison":"Original budget to audited outcome","percent_changed":-4.02},{"item":"Finance charges","amount":-5276938.0,"comparison":"Original to adjusted budget","percent_changed":-12.15},{"item":"Finance charges","amount":26501255.0,"comparison":"Original budget to audited outcome","percent_changed":61.0},{"item":"Other","amount":82302180.0,"comparison":"Original to adjusted budget","percent_changed":4.16},{"item":"Other","amount":-180011340.0,"comparison":"Original budget to audited outcome","percent_changed":-9.1},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-3900538.0,"comparison":"Original budget to audited outcome","percent_changed":-6.07},{"item":"Transfers and subsidies","amount":50000.0,"comparison":"Original to adjusted budget","percent_changed":0.27},{"item":"Transfers and subsidies","amount":-17941869.0,"comparison":"Original budget to audited outcome","percent_changed":-96.03}],"2022":[{"item":"Bulk purchases","amount":839417159.0,"comparison":"Original to adjusted budget","percent_changed":51.57},{"item":"Bulk purchases","amount":1399576623.0,"comparison":"Original budget to audited outcome","percent_changed":85.98},{"item":"Contracted services","amount":70647434.0,"comparison":"Original to adjusted budget","percent_changed":11.54},{"item":"Contracted services","amount":-175742604.0,"comparison":"Original budget to audited outcome","percent_changed":-28.71},{"item":"Employee related costs","amount":-35160885.0,"comparison":"Original to adjusted budget","percent_changed":-4.02},{"item":"Employee related costs","amount":-122124910.0,"comparison":"Original budget to audited outcome","percent_changed":-13.95},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":-24879391.0,"comparison":"Original budget to audited outcome","percent_changed":-29.5},{"item":"Other","amount":14645993.0,"comparison":"Original to adjusted budget","percent_changed":0.72},{"item":"Other","amount":277162476.0,"comparison":"Original budget to audited outcome","percent_changed":13.7},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-9114671.0,"comparison":"Original budget to audited outcome","percent_changed":-13.36},{"item":"Transfers and subsidies","amount":49972.0,"comparison":"Original to adjusted budget","percent_changed":0.26},{"item":"Transfers and subsidies","amount":48649921.0,"comparison":"Original budget to audited outcome","percent_changed":249.46}],"2023":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":524146858.0,"comparison":"Original budget to audited outcome","percent_changed":20.03},{"item":"Contracted services","amount":4646340.0,"comparison":"Original to adjusted budget","percent_changed":0.66},{"item":"Contracted services","amount":94147451.0,"comparison":"Original budget to audited outcome","percent_changed":13.3},{"item":"Employee related costs","amount":688036.0,"comparison":"Original to adjusted budget","percent_changed":0.08},{"item":"Employee related costs","amount":-87022189.0,"comparison":"Original budget to audited outcome","percent_changed":-9.61},{"item":"Finance charges","amount":-26000000.0,"comparison":"Original to adjusted budget","percent_changed":-30.44},{"item":"Finance charges","amount":-27390692.0,"comparison":"Original budget to audited outcome","percent_changed":-32.07},{"item":"Other","amount":22538306.0,"comparison":"Original to adjusted budget","percent_changed":1.07},{"item":"Other","amount":98422513.0,"comparison":"Original budget to audited outcome","percent_changed":4.68},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-8915319.0,"comparison":"Original budget to audited outcome","percent_changed":-12.56},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Transfers and subsidies","amount":-19584127.0,"comparison":"Original budget to audited outcome","percent_changed":-96.51}],"2024":[{"item":"Bulk purchases","amount":-160000000.0,"comparison":"Original to adjusted budget","percent_changed":-5.13},{"item":"Bulk purchases","amount":-1272458261.0,"comparison":"Original budget to audited outcome","percent_changed":-40.83},{"item":"Contracted services","amount":57927264.0,"comparison":"Original to adjusted budget","percent_changed":6.56},{"item":"Contracted services","amount":-77561375.0,"comparison":"Original budget to audited outcome","percent_changed":-8.78},{"item":"Employee related costs","amount":1621610.0,"comparison":"Original to adjusted budget","percent_changed":0.17},{"item":"Employee related costs","amount":-84403224.0,"comparison":"Original budget to audited outcome","percent_changed":-9.1},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":16923887.0,"comparison":"Original budget to audited outcome","percent_changed":27.24},{"item":"Other","amount":39050649.0,"comparison":"Original to adjusted budget","percent_changed":1.72},{"item":"Other","amount":648819118.0,"comparison":"Original budget to audited outcome","percent_changed":28.62},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-6605396.0,"comparison":"Original budget to audited outcome","percent_changed":-9.19},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Transfers and subsidies","amount":-20576840.0,"comparison":"Original budget to audited outcome","percent_changed":-97.23}]},"spending_time_series":[{"amount":4940456160.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":6199788428.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":6513946040.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":7288468107.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":5174726365.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":6703716199.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":7085877853.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":6554006493.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":6686842957.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":7901790971.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":8255081687.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":4326090405.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":5310188755.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":6512073358.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":7349868584.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":7531866059.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":-40.68,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"bad","result":2337.77,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"bad","result":2771.95,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"bad","result":2480.64,"overunder":"over","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":521601587.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":2901091845.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":11719745.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":726959348.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":15926519.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":14463416.0,"amount_type":"AUDA"},{"date":"2024","item":"Agency services","amount":138718848.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":50309937.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":12.86},{"date":2023,"rating":"","result":11.55},{"date":2022,"rating":"","result":11.24},{"date":2021,"rating":"","result":14.7}],"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":"ave","result":-10.1,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"ave","result":8.8,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"ave","result":8.1,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"good","result":4.7,"overunder":"over","cube_version":"v2"}],"formula":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"-",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","/",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"-",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","*","100"]},"result_type":"%"},"repairs_maintenance_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":1.04,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0.68,"cube_version":"v2"},{"date":2022,"rating":"bad","result":0.41,"cube_version":"v2"},{"date":2021,"rating":"bad","result":0.48,"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.29},{"date":2023,"rating":"","result":11.32},{"date":2022,"rating":"","result":6.51},{"date":2021,"rating":"","result":7.61}],"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":null,"billing":null,"receipts":null,"cube_version":null},{"date":"2023","year":2023,"rating":"bad","result":null,"billing":null,"receipts":null,"cube_version":null},{"date":"2022","year":2022,"rating":"bad","result":null,"billing":null,"receipts":null,"cube_version":null},{"date":"2021","year":2021,"rating":"bad","result":null,"billing":null,"receipts":null,"cube_version":null}],"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":356933628.0},{"year":2022,"value":386510009.0},{"year":2023,"value":403493881.0},{"year":2024,"value":442116823.0},{"year":2025,"value":464250716.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":3078194466.0},{"year":2022,"value":4063464918.0},{"year":2023,"value":4315957059.0},{"year":2024,"value":2682926065.0},{"year":2025,"value":2358619404.0}],"category":"Electricity "},{"values":[{"year":2021,"value":3453172.0},{"year":2022,"value":3708581.0},{"year":2023,"value":3964515.0},{"year":2024,"value":4503903.0},{"year":2025,"value":4415329.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":583044182.0},{"year":2022,"value":656750704.0},{"year":2023,"value":671002330.0},{"year":2024,"value":760114236.0},{"year":2025,"value":932616894.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":15274990.0},{"year":2022,"value":16005380.0},{"year":2023,"value":17789633.0},{"year":2024,"value":18395299.0},{"year":2025,"value":20297235.0}],"category":"Housing"},{"values":[{"year":2021,"value":88976839.0},{"year":2022,"value":233735291.0},{"year":2023,"value":443594379.0},{"year":2024,"value":534647241.0},{"year":2025,"value":719996860.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":39947539.0},{"year":2022,"value":36358588.0},{"year":2023,"value":37213070.0},{"year":2024,"value":41817520.0},{"year":2025,"value":43550950.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":229461893.0},{"year":2022,"value":327793303.0},{"year":2023,"value":295056275.0},{"year":2024,"value":241062311.0},{"year":2025,"value":289430591.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":145989329.0},{"year":2022,"value":110221161.0},{"year":2023,"value":150106583.0},{"year":2024,"value":215513262.0},{"year":2025,"value":277665653.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":633450327.0},{"year":2022,"value":869168264.0},{"year":2023,"value":747700128.0},{"year":2024,"value":1612909833.0},{"year":2025,"value":1575999325.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":"NW373"},"muni_contact":{"url":"http://www.rustenburg.gov.za","phone_number":"014 590 3111","street_address_1":"Missionary Mpheni House","street_address_2":"C/O Nelson Mandela & Beyers Naude Drive","street_address_3":"Rustenburg","street_address_4":"0300"},"mayoral_staff":{"officials":[{"name":"Sheila Mabale-Huma","role":"Mayor/Executive Mayor","email":"executive.mayor@rustenburg.gov.za","title":"Cllr","secretary":{"name":"Koketso Mokale","role":"Secretary of Mayor/Executive Mayor","email":"executive.mayor@rustenburg.gov.za","title":"Mrs","fax_number":"014 590 3006","office_phone":"014 590 3004"},"fax_number":"014 590 3006","office_phone":"014 590 3004"},{"name":"Ashmar Khuduge","role":"Municipal Manager","email":"akhuduge@rustenburg.gov.za","title":"Adv","secretary":{"name":"Nkele Matabane","role":"Secretary of Municipal Manager","email":"munman@rustenburg.gov.za","title":"Ms","fax_number":"014 590 3003","office_phone":"014 590 3551"},"fax_number":"014 590 3003","office_phone":"014 590 3551"},{"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":"Godfrey Ditsele","role":"Chief Financial Officer","email":"gditsele@rustenburg.gov.za","title":"Mr","secretary":{"name":"Ofentse Setlhare","role":"Secretary of Financial Manager","email":"secretary_bto@rustenburg.gov.za","title":"Ms","fax_number":"014 590 3399","office_phone":"014 590 3129"},"fax_number":"014 590 3399","office_phone":"014 590 3312"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/NW373/NW373_Audit%20Report_2024_Y_20250128T083403Z_rmonageng.pdf"},{"date":2023,"rating":"qualified","result":"Qualified","report_url":""},{"date":2022,"rating":"qualified","result":"Qualified","report_url":""},{"date":2021,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/NW373/NW373_Audit%20Report_2021_Y_20220525T093052Z_rmonageng.pdf"}]}}