{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":53508.0,"national_conditional_grants":1091873431.0},"ORGB":{"equitable_share":593405000.0,"national_conditional_grants":273663000.0},"SCHD":{"national_conditional_grants":273663000.0},"TRFR":{"national_conditional_grants":64716000.0}},"2022":{"ACT":{"national_conditional_grants":24123752.0},"ORGB":{"equitable_share":616262000.0,"national_conditional_grants":356250000.0},"SCHD":{"national_conditional_grants":364150000.0},"TRFR":{"national_conditional_grants":322442000.0}},"2023":{"ACT":{"national_conditional_grants":356803089.0},"ORGB":{"equitable_share":696056000.0,"provincial_transfers":265032000.0,"national_conditional_grants":434107000.0},"SCHD":{"national_conditional_grants":435427000.0},"TRFR":{"national_conditional_grants":358608000.0}},"2024":{"ACT":{"national_conditional_grants":262187856.0},"ORGB":{"equitable_share":767222000.0,"national_conditional_grants":446466000.0},"SCHD":{"national_conditional_grants":426225000.0},"TRFR":{"national_conditional_grants":357832000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":53508.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":593405000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":616262000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":696056000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":767222000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":83260000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":15977000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":160795000.0,"grant.code":"0007","grant.label":"Housing and Local Government","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":5000000.0,"grant.code":"0009","grant.label":"Other Departments","amount_type.code":"ORGB","financial_year_end.year":2023}]},"national_conditional_grants":{"2021":[{"amount.sum":1192000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1192000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":7381796.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1636786.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":11310994.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":132178781.0,"grant.code":"MEHG","grant.label":"Municipal Emergency Housing Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":400279083.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":196128000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":30000000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":2000000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":277000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":11929915.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":35000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":10450000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":443568539.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":4200000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":4388000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1097000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":79387537.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":33255000.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":1900000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1900000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":42503000.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":4000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":20000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":20000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":17282000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":209331000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":209331000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1000000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1795000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":13972000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":34000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":34000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":11900000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":11900000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":2637000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":3516000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":3516000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":-13767248.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":40000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":40000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":620000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":620000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":620000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1950000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1950000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1950000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":75119000.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":27379642.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":29154000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":29154000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":227126295.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":227153000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":227153000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1700000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":34499417.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":34500000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":34500000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":5228151.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":5231000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":5231000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":59999584.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":60000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":60000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":8021559.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":39600000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":39600000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":5000001.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":1950000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1950000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1950000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":68100000.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":12218873.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":10500000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":10500000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":178170822.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":229322000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":229322000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":293000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":12973388.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":13100000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":13100000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":4700998.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":4701000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":4701000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":39152215.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":53659000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":53659000.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":366360225.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":695267165.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":302817318.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":478860290.0,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"}]},"result_type":"R"},"cash_coverage":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"bad","result":0.5,"cube_version":"v2"},{"date":2023,"rating":"ave","result":1.3,"cube_version":"v2"},{"date":2022,"rating":"bad","result":0.5,"cube_version":"v2"},{"date":2021,"rating":"bad","result":0.9,"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":2297434589.0,"rating":"bad","result":0.56,"amount_type":"AUDA","liabilities":4104188052.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":4168889115.0,"rating":"ave","result":1.07,"amount_type":"AUDA","liabilities":3885789678.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":2542368079.0,"rating":"ave","result":1.01,"amount_type":"AUDA","liabilities":2520762905.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":3064611443.0,"rating":"ave","result":1.18,"amount_type":"AUDA","liabilities":2607040809.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":456935122.0,"date":"2024","year":2024,"rating":"bad","result":0.11,"amount_type":"ACT","liabilities":4104188052.0,"cube_version":"v2","call_investment_deposits":0},{"cash":482433140.0,"date":"2023","year":2023,"rating":"bad","result":0.12,"amount_type":"ACT","liabilities":3885789678.0,"cube_version":"v2","call_investment_deposits":0},{"cash":321822849.0,"date":"2022","year":2022,"rating":"bad","result":0.13,"amount_type":"ACT","liabilities":2520762905.0,"cube_version":"v2","call_investment_deposits":0},{"cash":343637666.0,"date":"2021","year":2021,"rating":"bad","result":0.13,"amount_type":"ACT","liabilities":2607040809.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":6102991932.0,"percent":88.1},"total":6927536750.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":824544818.0,"percent":11.9}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":0.73,"cube_version":"v2"},{"date":2023,"rating":"bad","result":3.42,"cube_version":"v2"},{"date":2022,"rating":"bad","result":9.97,"cube_version":"v2"},{"date":2021,"rating":"bad","result":15.31,"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":14263484.0,"comparison":"Original budget to audited outcome","percent_changed":793.05},{"item":"Government Transfers","amount":151705547.0,"comparison":"Original to adjusted budget","percent_changed":22.46},{"item":"Government Transfers","amount":80711217.0,"comparison":"Original budget to audited outcome","percent_changed":11.95},{"item":"Interest and investments","amount":108900.0,"comparison":"Original to adjusted budget","percent_changed":0.05},{"item":"Interest and investments","amount":-21175107.0,"comparison":"Original budget to audited outcome","percent_changed":-9.73},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-516780.0,"comparison":"Original budget to audited outcome","percent_changed":-46.16},{"item":"Other","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Other","amount":-15857934.0,"comparison":"Original budget to audited outcome","percent_changed":-10.78},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-65118280.0,"comparison":"Original budget to audited outcome","percent_changed":-5.13},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":-14519885.0,"comparison":"Original budget to audited outcome","percent_changed":-49.93},{"item":"Service Charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":-387468841.0,"comparison":"Original budget to audited outcome","percent_changed":-10.84}],"2022":[{"item":"Fines","amount":-36.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":12594163.0,"comparison":"Original budget to audited outcome","percent_changed":664.67},{"item":"Government Transfers","amount":64741213.0,"comparison":"Original to adjusted budget","percent_changed":9.79},{"item":"Government Transfers","amount":14956174.0,"comparison":"Original budget to audited outcome","percent_changed":2.26},{"item":"Interest and investments","amount":-120.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":-69958492.0,"comparison":"Original budget to audited outcome","percent_changed":-30.5},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-195255.0,"comparison":"Original budget to audited outcome","percent_changed":-16.55},{"item":"Other","amount":1.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Other","amount":-93627831.0,"comparison":"Original budget to audited outcome","percent_changed":-60.44},{"item":"Property rates","amount":1.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-59840179.0,"comparison":"Original budget to audited outcome","percent_changed":-4.53},{"item":"Rental income","amount":1.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":-5219201.0,"comparison":"Original budget to audited outcome","percent_changed":-17.04},{"item":"Service Charges","amount":-1.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":-397952464.0,"comparison":"Original budget to audited outcome","percent_changed":-9.9}],"2023":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":18124491.0,"comparison":"Original budget to audited outcome","percent_changed":904.02},{"item":"Government Transfers","amount":-55133390.0,"comparison":"Original to adjusted budget","percent_changed":-6.44},{"item":"Government Transfers","amount":-54090758.0,"comparison":"Original budget to audited outcome","percent_changed":-6.32},{"item":"Interest and investments","amount":1.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":-3412493.0,"comparison":"Original budget to audited outcome","percent_changed":-1.41},{"item":"Licenses and Permits","amount":-1.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":915455.0,"comparison":"Original budget to audited outcome","percent_changed":61.03},{"item":"Other","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Other","amount":-74480112.0,"comparison":"Original budget to audited outcome","percent_changed":-41.92},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-56915426.0,"comparison":"Original budget to audited outcome","percent_changed":-3.99},{"item":"Rental income","amount":2.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":-17353024.0,"comparison":"Original budget to audited outcome","percent_changed":-46.37},{"item":"Service Charges","amount":-3.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":-436497016.0,"comparison":"Original budget to audited outcome","percent_changed":-10.13}],"2024":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":19587236.0,"comparison":"Original budget to audited outcome","percent_changed":133.61},{"item":"Government Transfers","amount":6780645.0,"comparison":"Original to adjusted budget","percent_changed":0.81},{"item":"Government Transfers","amount":-13590332.0,"comparison":"Original budget to audited outcome","percent_changed":-1.62},{"item":"Interest and investments","amount":1.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":209913193.0,"comparison":"Original budget to audited outcome","percent_changed":78.64},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-430621.0,"comparison":"Original budget to audited outcome","percent_changed":-17.56},{"item":"Other","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Other","amount":-120668412.0,"comparison":"Original budget to audited outcome","percent_changed":-52.21},{"item":"Property rates","amount":1.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-167898355.0,"comparison":"Original budget to audited outcome","percent_changed":-11.0},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":-71233204.0,"comparison":"Original budget to audited outcome","percent_changed":-67.96},{"item":"Service Charges","amount":-219463339.0,"comparison":"Original to adjusted budget","percent_changed":-4.27},{"item":"Service Charges","amount":-1048868878.0,"comparison":"Original budget to audited outcome","percent_changed":-20.42}]},"income_time_series":[{"amount":6069624705.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":6483155253.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":6995636869.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":7908043431.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":5508128132.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":5819171109.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":6427061377.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":6927536750.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":8388152949.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":9956259487.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":11170211957.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":5917810258.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":6418414194.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":7050770260.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":8120726123.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":8963903226.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":-42414082.0,"comparison":"Original to adjusted budget","percent_changed":-2.17},{"item":"Bulk purchases","amount":-49330796.0,"comparison":"Original budget to audited outcome","percent_changed":-2.52},{"item":"Contracted services","amount":170557947.0,"comparison":"Original to adjusted budget","percent_changed":36.7},{"item":"Contracted services","amount":85431804.0,"comparison":"Original budget to audited outcome","percent_changed":18.38},{"item":"Employee related costs","amount":7034749.0,"comparison":"Original to adjusted budget","percent_changed":0.48},{"item":"Employee related costs","amount":-51210759.0,"comparison":"Original budget to audited outcome","percent_changed":-3.46},{"item":"Finance charges","amount":4712122.0,"comparison":"Original to adjusted budget","percent_changed":14.82},{"item":"Finance charges","amount":10743752.0,"comparison":"Original budget to audited outcome","percent_changed":33.79},{"item":"Other","amount":-8121064.0,"comparison":"Original to adjusted budget","percent_changed":-0.54},{"item":"Other","amount":898438198.0,"comparison":"Original budget to audited outcome","percent_changed":59.63},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-2009151.0,"comparison":"Original budget to audited outcome","percent_changed":-3.74},{"item":"Transfers and subsidies","amount":20999999.0,"comparison":"Original to adjusted budget","percent_changed":83.73},{"item":"Transfers and subsidies","amount":-8210158.0,"comparison":"Original budget to audited outcome","percent_changed":-32.74}],"2022":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":764814276.0,"comparison":"Original budget to audited outcome","percent_changed":35.0},{"item":"Contracted services","amount":75839215.0,"comparison":"Original to adjusted budget","percent_changed":11.57},{"item":"Contracted services","amount":37985548.0,"comparison":"Original budget to audited outcome","percent_changed":5.8},{"item":"Employee related costs","amount":25301624.0,"comparison":"Original to adjusted budget","percent_changed":1.65},{"item":"Employee related costs","amount":-55052766.0,"comparison":"Original budget to audited outcome","percent_changed":-3.58},{"item":"Finance charges","amount":-1.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":-7808737.0,"comparison":"Original budget to audited outcome","percent_changed":-22.49},{"item":"Other","amount":5610986.0,"comparison":"Original to adjusted budget","percent_changed":0.35},{"item":"Other","amount":92174546.0,"comparison":"Original budget to audited outcome","percent_changed":5.75},{"item":"Remuneration of councillors","amount":-14.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-6803476.0,"comparison":"Original budget to audited outcome","percent_changed":-12.08},{"item":"Transfers and subsidies","amount":15357069.0,"comparison":"Original to adjusted budget","percent_changed":33.48},{"item":"Transfers and subsidies","amount":-13450209.0,"comparison":"Original budget to audited outcome","percent_changed":-29.33}],"2023":[{"item":"Bulk purchases","amount":100000000.0,"comparison":"Original to adjusted budget","percent_changed":4.55},{"item":"Bulk purchases","amount":150400905.0,"comparison":"Original budget to audited outcome","percent_changed":6.84},{"item":"Contracted services","amount":93821928.0,"comparison":"Original to adjusted budget","percent_changed":14.12},{"item":"Contracted services","amount":134742020.0,"comparison":"Original budget to audited outcome","percent_changed":20.27},{"item":"Employee related costs","amount":53553920.0,"comparison":"Original to adjusted budget","percent_changed":3.39},{"item":"Employee related costs","amount":-112843322.0,"comparison":"Original budget to audited outcome","percent_changed":-7.14},{"item":"Finance charges","amount":-42178620.0,"comparison":"Original to adjusted budget","percent_changed":-44.77},{"item":"Finance charges","amount":56596732.0,"comparison":"Original budget to audited outcome","percent_changed":60.07},{"item":"Other","amount":-10205222.0,"comparison":"Original to adjusted budget","percent_changed":-0.57},{"item":"Other","amount":-416620660.0,"comparison":"Original budget to audited outcome","percent_changed":-23.23},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-7613709.0,"comparison":"Original budget to audited outcome","percent_changed":-12.81},{"item":"Transfers and subsidies","amount":-25461014.0,"comparison":"Original to adjusted budget","percent_changed":-40.12},{"item":"Transfers and subsidies","amount":-33906916.0,"comparison":"Original budget to audited outcome","percent_changed":-53.42}],"2024":[{"item":"Bulk purchases","amount":200000000.0,"comparison":"Original to adjusted budget","percent_changed":7.96},{"item":"Bulk purchases","amount":200396462.0,"comparison":"Original budget to audited outcome","percent_changed":7.97},{"item":"Contracted services","amount":-139574175.0,"comparison":"Original to adjusted budget","percent_changed":-14.03},{"item":"Contracted services","amount":-90753891.0,"comparison":"Original budget to audited outcome","percent_changed":-9.12},{"item":"Employee related costs","amount":-88514501.0,"comparison":"Original to adjusted budget","percent_changed":-4.94},{"item":"Employee related costs","amount":-180230039.0,"comparison":"Original budget to audited outcome","percent_changed":-10.05},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":45650609.0,"comparison":"Original budget to audited outcome","percent_changed":112.99},{"item":"Other","amount":-105187562.0,"comparison":"Original to adjusted budget","percent_changed":-4.68},{"item":"Other","amount":380206736.0,"comparison":"Original budget to audited outcome","percent_changed":16.92},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":842076.0,"comparison":"Original budget to audited outcome","percent_changed":1.34},{"item":"Transfers and subsidies","amount":-6439067.0,"comparison":"Original to adjusted budget","percent_changed":-12.62},{"item":"Transfers and subsidies","amount":-25784034.0,"comparison":"Original budget to audited outcome","percent_changed":-50.53}]},"spending_time_series":[{"amount":5669247138.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":6240522841.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":6624477882.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":7564072490.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":6400330357.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":6930273144.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":6225701940.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":8034115714.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":8898835361.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":9139219635.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":9986715470.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":5516477467.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":6118413962.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":6454946890.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":7703787795.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":8380270950.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"capital_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2024,"rating":"ave","result":9.91,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"good","result":4.84,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"bad","result":613.76,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"bad","result":989.18,"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":1359086727.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":4086762355.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":33590328.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":476830689.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":34247150.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":2021123.0,"amount_type":"AUDA"},{"date":"2024","item":"Agency services","amount":2666696.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":107786864.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":20.08},{"date":2023,"rating":"","result":23.56},{"date":2022,"rating":"","result":21.4},{"date":2021,"rating":"","result":22.3}],"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":6.2,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"ave","result":-6.0,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"ave","result":11.1,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"ave","result":12.9,"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":null,"result":null,"cube_version":null},{"date":2023,"rating":null,"result":null,"cube_version":null},{"date":2022,"rating":"bad","result":3.18,"cube_version":"v2"},{"date":2021,"rating":"bad","result":4.22,"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":11.25},{"date":2023,"rating":"","result":12.84},{"date":2022,"rating":"","result":10.01},{"date":2021,"rating":"","result":8.6}],"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":89.9,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"bad","result":26.88,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"bad","result":22.03,"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":105337321.0},{"year":2022,"value":81328846.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":1963797205.0},{"year":2022,"value":3029735115.0},{"year":2023,"value":2350400905.0},{"year":2024,"value":2714396462.0},{"year":2025,"value":3238484968.0}],"category":"Electricity "},{"values":[{"year":2021,"value":150065.0},{"year":2022,"value":131163.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":2599118070.0},{"year":2022,"value":2389959989.0},{"year":2023,"value":3246200807.0},{"year":2024,"value":4600265009.0},{"year":2025,"value":3840091031.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":296374.0},{"year":2022,"value":474865.0}],"category":"Housing"},{"values":[{"year":2021,"value":18063706.0},{"year":2022,"value":2293227.0}],"category":"Other"},{"values":[{"year":2021,"value":127043289.0},{"year":2022,"value":225802231.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":29517314.0},{"year":2022,"value":59712569.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":45429164.0},{"year":2022,"value":566189860.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":270874575.0},{"year":2022,"value":267964614.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":1240703274.0},{"year":2022,"value":306680665.0},{"year":2023,"value":629100228.0},{"year":2024,"value":719454243.0},{"year":2025,"value":1820259362.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":"KZN225"},"muni_contact":{"url":"http://www.msunduzi.gov.za","phone_number":"033 392 3000","street_address_1":"City Hall","street_address_2":"Chief Albert Luthuli Street","street_address_3":"Pietermaritzburg","street_address_4":"3201"},"mayoral_staff":{"officials":[{"name":"Mzimkhulu Meshack Thebolla","role":"Mayor/Executive Mayor","email":"Mzimkhulu.Thebolla@msunduzi.gov.za","title":"Cllr","secretary":{"name":"Nontokozo Mazibuko","role":"Secretary of Mayor/Executive Mayor","email":"Nontokozo.Mazibuko@msunduzi.gov.za","title":"Ms","fax_number":"033 345 1637","office_phone":"033 392 2036"},"fax_number":"033 345 1637","office_phone":"033 392 2036"},{"name":"Simon Felani Mndebele","role":"Municipal Manager","email":"felani.mndebele@msunduzi.gov.za","title":"Mr","secretary":{"name":"Mandy Gavu","role":"Secretary of Municipal Manager","email":"mandy.gavu@msunduzi.gov.za","title":"Ms","fax_number":"033 392 2397","office_phone":"033 392 2002"},"fax_number":"033 392 2506","office_phone":"033 392 2002"},{"name":"Mxolisi Theophilus Mkhize","role":"Deputy Mayor/Executive Mayor","email":"Mxolisi.Mkhize2@msunduzi.gov.za","title":"Cllr","secretary":{"name":"Ashreena Jethoo","role":"Secretary of Deputy Mayor/Executive Mayor","email":"Ashreena.Jethoo@msunduzi.gov.za","title":"Ms","fax_number":"033 345 1637","office_phone":"033 392 2037"},"fax_number":"033 345 1637","office_phone":"033 392 2037"},{"name":"Nelisiwe Ngcobo","role":"Chief Financial Officer","email":"nelisiwe.ngcobo@msunduzi.gov.za","title":"Mrs","secretary":{"name":"Thobeka Masango","role":"Secretary of Financial Manager","email":"thobeka.masango@msunduzi.gov.za","title":"Ms","fax_number":"033 392 2506","office_phone":"033 392 2601"},"fax_number":"033 392 2506","office_phone":"033 392 2601"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"outstanding","result":"Outstanding","report_url":"https://lg.treasury.gov.za/supportingdocs/KZN225/KZN225_Audit%20Report_2024_Y_20250320T083201Z_thumeka_ndudane.pdf"},{"date":2023,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/KZN225/KZN225_Audit%20Report_2023_Y_20240219T124731Z_mbalenhle_khubone.pdf"},{"date":2022,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/KZN225/KZN225_Audit%20Report_2022_Y_20230123T113122Z_mbalenhle_khubone.pdf"},{"date":2021,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":""}]}}