{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":54398319.0,"national_conditional_grants":26531220.0},"ORGB":{"equitable_share":222794000.0,"national_conditional_grants":101870000.0},"SCHD":{"national_conditional_grants":92370000.0},"TRFR":{"national_conditional_grants":34182000.0}},"2022":{"ACT":{"national_conditional_grants":77816370.0},"ORGB":{"equitable_share":233214000.0,"national_conditional_grants":158000000.0},"SCHD":{"national_conditional_grants":160697000.0},"TRFR":{"national_conditional_grants":156771000.0}},"2023":{"ACT":{"national_conditional_grants":137534111.0},"ORGB":{"equitable_share":260646000.0,"provincial_transfers":103526000.0,"national_conditional_grants":161036000.0},"SCHD":{"national_conditional_grants":176942000.0},"TRFR":{"national_conditional_grants":164818000.0}},"2024":{"ACT":{"national_conditional_grants":198815802.0},"ORGB":{"equitable_share":285237000.0,"national_conditional_grants":234421000.0},"SCHD":{"national_conditional_grants":247727000.0},"TRFR":{"national_conditional_grants":202358000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":54398319.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":222794000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":233214000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":260646000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":285237000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":10445000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":15430000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":72651000.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":35260.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1108000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1108000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":589234.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":2000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":2000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":5000000.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":1000000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":611696.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":5000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":23880583.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":65313000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":23000000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":35710.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1500000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":3500000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":86000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":5000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":5000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1378737.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":3949000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":988000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021}],"2022":[{"amount.sum":2553951.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":4000000.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":4000000.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":466503.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":1950000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1950000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":10261000.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":6158919.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":8040000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":8040000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":58432758.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":99131000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":99131000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":500000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":6835000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":5455194.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":31257000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":31257000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":4749045.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":5558000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":5558000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":19252975.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":19100000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":19100000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":6015137.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":5000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":5000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1286127.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":11624000.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":5005480.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":5332000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":5332000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":57047181.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":81360000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":81360000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":500000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":43822196.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":46000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":46000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":5105015.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":6076000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":6076000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":78703922.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":82298000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":82298000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery 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":45369000.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":263084.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":87436132.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":88848000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":88848000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":25378663.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":24178000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":24178000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":5084001.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":5084000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":5084000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","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":177377647.0,"cube_version":"v2"},{"date":2023,"rating":"bad","result":-95875816.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":292266473.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":1415728117.0,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"}]},"result_type":"R"},"cash_coverage":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"ave","result":1.6,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0,"cube_version":"v2"},{"date":2022,"rating":"good","result":3.1,"cube_version":"v2"},{"date":2021,"rating":"good","result":16.3,"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":716900341.0,"rating":"ave","result":1.48,"amount_type":"AUDA","liabilities":483617352.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":735850924.0,"rating":"good","result":1.86,"amount_type":"AUDA","liabilities":395179154.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":630229233.0,"rating":"good","result":1.82,"amount_type":"AUDA","liabilities":345489262.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":409438898.0,"rating":"ave","result":1.49,"amount_type":"AUDA","liabilities":275087680.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":66405153.0,"date":"2024","year":2024,"rating":"bad","result":0.14,"amount_type":"ACT","liabilities":483617352.0,"cube_version":"v2","call_investment_deposits":0},{"cash":114251488.0,"date":"2023","year":2023,"rating":"bad","result":0.29,"amount_type":"ACT","liabilities":395179154.0,"cube_version":"v2","call_investment_deposits":0},{"cash":131590902.0,"date":"2022","year":2022,"rating":"bad","result":0.38,"amount_type":"ACT","liabilities":345489262.0,"cube_version":"v2","call_investment_deposits":0},{"cash":129769429.0,"date":"2021","year":2021,"rating":"bad","result":0.47,"amount_type":"ACT","liabilities":275087680.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":938276589.0,"percent":70.63},"total":1328475111.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":390198522.0,"percent":29.37}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":13.88,"cube_version":"v2"},{"date":2023,"rating":"bad","result":33.29,"cube_version":"v2"},{"date":2022,"rating":"bad","result":0.39,"cube_version":"v2"},{"date":2021,"rating":"bad","result":3.06,"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":-10000.0,"comparison":"Original to adjusted budget","percent_changed":-0.07},{"item":"Fines","amount":1935103.0,"comparison":"Original budget to audited outcome","percent_changed":13.24},{"item":"Government Transfers","amount":38208143.0,"comparison":"Original to adjusted budget","percent_changed":11.34},{"item":"Government Transfers","amount":-47236929.0,"comparison":"Original budget to audited outcome","percent_changed":-14.03},{"item":"Interest and investments","amount":-1020900.0,"comparison":"Original to adjusted budget","percent_changed":-3.88},{"item":"Interest and investments","amount":5448336.0,"comparison":"Original budget to audited outcome","percent_changed":20.72},{"item":"Licenses and Permits","amount":-642000.0,"comparison":"Original to adjusted budget","percent_changed":-4.88},{"item":"Licenses and Permits","amount":-7589216.0,"comparison":"Original budget to audited outcome","percent_changed":-57.69},{"item":"Other","amount":-525764.0,"comparison":"Original to adjusted budget","percent_changed":-3.1},{"item":"Other","amount":60126008.0,"comparison":"Original budget to audited outcome","percent_changed":354.08},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-10612006.0,"comparison":"Original budget to audited outcome","percent_changed":-2.32},{"item":"Rental income","amount":-49000.0,"comparison":"Original to adjusted budget","percent_changed":-1.16},{"item":"Rental income","amount":-443624.0,"comparison":"Original budget to audited outcome","percent_changed":-10.49},{"item":"Service Charges","amount":3418330.0,"comparison":"Original to adjusted budget","percent_changed":1.62},{"item":"Service Charges","amount":-14726823.0,"comparison":"Original budget to audited outcome","percent_changed":-6.99}],"2022":[{"item":"Fines","amount":300000.0,"comparison":"Original to adjusted budget","percent_changed":1.44},{"item":"Fines","amount":9425746.0,"comparison":"Original budget to audited outcome","percent_changed":45.39},{"item":"Government Transfers","amount":1571000.0,"comparison":"Original to adjusted budget","percent_changed":0.61},{"item":"Government Transfers","amount":-1081357.0,"comparison":"Original budget to audited outcome","percent_changed":-0.42},{"item":"Interest and investments","amount":-170570.0,"comparison":"Original to adjusted budget","percent_changed":-0.6},{"item":"Interest and investments","amount":7745079.0,"comparison":"Original budget to audited outcome","percent_changed":27.09},{"item":"Licenses and Permits","amount":-4274160.0,"comparison":"Original to adjusted budget","percent_changed":-36.54},{"item":"Licenses and Permits","amount":-3560250.0,"comparison":"Original budget to audited outcome","percent_changed":-30.43},{"item":"Other","amount":2065956.0,"comparison":"Original to adjusted budget","percent_changed":2.27},{"item":"Other","amount":-22962800.0,"comparison":"Original budget to audited outcome","percent_changed":-25.18},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-11308272.0,"comparison":"Original budget to audited outcome","percent_changed":-2.38},{"item":"Rental income","amount":1977300.0,"comparison":"Original to adjusted budget","percent_changed":424.29},{"item":"Rental income","amount":3430545.0,"comparison":"Original budget to audited outcome","percent_changed":736.13},{"item":"Service Charges","amount":-66925.0,"comparison":"Original to adjusted budget","percent_changed":-0.03},{"item":"Service Charges","amount":-23311726.0,"comparison":"Original budget to audited outcome","percent_changed":-9.78}],"2023":[{"item":"Fines","amount":7500000.0,"comparison":"Original to adjusted budget","percent_changed":33.85},{"item":"Fines","amount":1811139.0,"comparison":"Original budget to audited outcome","percent_changed":8.17},{"item":"Government Transfers","amount":176542.0,"comparison":"Original to adjusted budget","percent_changed":0.06},{"item":"Government Transfers","amount":315288.0,"comparison":"Original budget to audited outcome","percent_changed":0.11},{"item":"Interest and investments","amount":6000000.0,"comparison":"Original to adjusted budget","percent_changed":20.14},{"item":"Interest and investments","amount":15596089.0,"comparison":"Original budget to audited outcome","percent_changed":52.36},{"item":"Licenses and Permits","amount":2086508.0,"comparison":"Original to adjusted budget","percent_changed":26.67},{"item":"Licenses and Permits","amount":506311.0,"comparison":"Original budget to audited outcome","percent_changed":6.47},{"item":"Other","amount":-28331828.0,"comparison":"Original to adjusted budget","percent_changed":-37.82},{"item":"Other","amount":-14366471.0,"comparison":"Original budget to audited outcome","percent_changed":-19.18},{"item":"Property rates","amount":-6505152.0,"comparison":"Original to adjusted budget","percent_changed":-1.3},{"item":"Property rates","amount":-12482121.0,"comparison":"Original budget to audited outcome","percent_changed":-2.5},{"item":"Rental income","amount":1100000.0,"comparison":"Original to adjusted budget","percent_changed":42.14},{"item":"Rental income","amount":2075708.0,"comparison":"Original budget to audited outcome","percent_changed":79.52},{"item":"Service Charges","amount":-16927024.0,"comparison":"Original to adjusted budget","percent_changed":-6.67},{"item":"Service Charges","amount":-41189188.0,"comparison":"Original budget to audited outcome","percent_changed":-16.24}],"2024":[{"item":"Fines","amount":3467356.0,"comparison":"Original to adjusted budget","percent_changed":11.16},{"item":"Fines","amount":-10463862.0,"comparison":"Original budget to audited outcome","percent_changed":-33.69},{"item":"Government Transfers","amount":715000.0,"comparison":"Original to adjusted budget","percent_changed":0.18},{"item":"Government Transfers","amount":172518.0,"comparison":"Original budget to audited outcome","percent_changed":0.04},{"item":"Interest and investments","amount":4122464.0,"comparison":"Original to adjusted budget","percent_changed":9.03},{"item":"Interest and investments","amount":5970217.0,"comparison":"Original budget to audited outcome","percent_changed":13.08},{"item":"Licenses and Permits","amount":1100.0,"comparison":"Original to adjusted budget","percent_changed":0.01},{"item":"Licenses and Permits","amount":-606114.0,"comparison":"Original budget to audited outcome","percent_changed":-5.91},{"item":"Other","amount":46769073.0,"comparison":"Original to adjusted budget","percent_changed":291.42},{"item":"Other","amount":78746377.0,"comparison":"Original budget to audited outcome","percent_changed":490.68},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-2389133.0,"comparison":"Original budget to audited outcome","percent_changed":-0.47},{"item":"Rental income","amount":1476900.0,"comparison":"Original to adjusted budget","percent_changed":42.22},{"item":"Rental income","amount":647998.0,"comparison":"Original budget to audited outcome","percent_changed":18.53},{"item":"Service Charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":5289607.0,"comparison":"Original budget to audited outcome","percent_changed":2.16}]},"income_time_series":[{"amount":1120048813.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":1126041541.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":1139727373.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":1307659396.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":1067570853.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":1083015905.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":1126895082.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":1328475111.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":1317565961.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":1312314269.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":1360276704.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":1080670004.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":1124638940.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":1174628327.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":1251107503.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":1270141871.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":1960722.0,"comparison":"Original budget to audited outcome","percent_changed":1.85},{"item":"Contracted services","amount":-56140482.0,"comparison":"Original to adjusted budget","percent_changed":-19.11},{"item":"Contracted services","amount":-103369647.0,"comparison":"Original budget to audited outcome","percent_changed":-35.18},{"item":"Employee related costs","amount":4607785.0,"comparison":"Original to adjusted budget","percent_changed":1.07},{"item":"Employee related costs","amount":-766873.0,"comparison":"Original budget to audited outcome","percent_changed":-0.18},{"item":"Finance charges","amount":4541440.0,"comparison":"Original to adjusted budget","percent_changed":36316.99},{"item":"Finance charges","amount":11075388.0,"comparison":"Original budget to audited outcome","percent_changed":88567.68},{"item":"Other","amount":51124193.0,"comparison":"Original to adjusted budget","percent_changed":20.55},{"item":"Other","amount":22728737.0,"comparison":"Original budget to audited outcome","percent_changed":9.13},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-2002633.0,"comparison":"Original budget to audited outcome","percent_changed":-6.59},{"item":"Transfers and subsidies","amount":3000000.0,"comparison":"Original to adjusted budget","percent_changed":55.05},{"item":"Transfers and subsidies","amount":1185308.0,"comparison":"Original budget to audited outcome","percent_changed":21.75}],"2022":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-2347428.0,"comparison":"Original budget to audited outcome","percent_changed":-1.88},{"item":"Contracted services","amount":7410596.0,"comparison":"Original to adjusted budget","percent_changed":2.96},{"item":"Contracted services","amount":-36334227.0,"comparison":"Original budget to audited outcome","percent_changed":-14.52},{"item":"Employee related costs","amount":7528195.0,"comparison":"Original to adjusted budget","percent_changed":1.81},{"item":"Employee related costs","amount":30520435.0,"comparison":"Original budget to audited outcome","percent_changed":7.35},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":14257484.0,"comparison":"Original budget to audited outcome","percent_changed":251.32},{"item":"Other","amount":22200236.0,"comparison":"Original to adjusted budget","percent_changed":7.88},{"item":"Other","amount":4799735.0,"comparison":"Original budget to audited outcome","percent_changed":1.7},{"item":"Remuneration of councillors","amount":-4212395.0,"comparison":"Original to adjusted budget","percent_changed":-13.4},{"item":"Remuneration of councillors","amount":-5185514.0,"comparison":"Original budget to audited outcome","percent_changed":-16.5},{"item":"Transfers and subsidies","amount":2681067.0,"comparison":"Original to adjusted budget","percent_changed":36.48},{"item":"Transfers and subsidies","amount":2541427.0,"comparison":"Original budget to audited outcome","percent_changed":34.58}],"2023":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-29603734.0,"comparison":"Original budget to audited outcome","percent_changed":-21.6},{"item":"Contracted services","amount":-13944083.0,"comparison":"Original to adjusted budget","percent_changed":-5.69},{"item":"Contracted services","amount":-33311778.0,"comparison":"Original budget to audited outcome","percent_changed":-13.6},{"item":"Employee related costs","amount":15307315.0,"comparison":"Original to adjusted budget","percent_changed":3.42},{"item":"Employee related costs","amount":8140369.0,"comparison":"Original budget to audited outcome","percent_changed":1.82},{"item":"Finance charges","amount":-20000.0,"comparison":"Original to adjusted budget","percent_changed":-0.15},{"item":"Finance charges","amount":11140270.0,"comparison":"Original budget to audited outcome","percent_changed":86.21},{"item":"Other","amount":-2129912.0,"comparison":"Original to adjusted budget","percent_changed":-0.75},{"item":"Other","amount":36236354.0,"comparison":"Original budget to audited outcome","percent_changed":12.72},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-1867011.0,"comparison":"Original budget to audited outcome","percent_changed":-5.94},{"item":"Transfers and subsidies","amount":-100000.0,"comparison":"Original to adjusted budget","percent_changed":-0.76},{"item":"Transfers and subsidies","amount":1286774.0,"comparison":"Original budget to audited outcome","percent_changed":9.76}],"2024":[{"item":"Bulk purchases","amount":-5000000.0,"comparison":"Original to adjusted budget","percent_changed":-3.16},{"item":"Bulk purchases","amount":-15440098.0,"comparison":"Original budget to audited outcome","percent_changed":-9.75},{"item":"Contracted services","amount":8006758.0,"comparison":"Original to adjusted budget","percent_changed":2.92},{"item":"Contracted services","amount":-55562700.0,"comparison":"Original budget to audited outcome","percent_changed":-20.29},{"item":"Employee related costs","amount":444328.0,"comparison":"Original to adjusted budget","percent_changed":0.09},{"item":"Employee related costs","amount":-3323894.0,"comparison":"Original budget to audited outcome","percent_changed":-0.69},{"item":"Finance charges","amount":2000.0,"comparison":"Original to adjusted budget","percent_changed":0.02},{"item":"Finance charges","amount":13776346.0,"comparison":"Original budget to audited outcome","percent_changed":138.35},{"item":"Other","amount":84325909.0,"comparison":"Original to adjusted budget","percent_changed":29.88},{"item":"Other","amount":132196683.0,"comparison":"Original budget to audited outcome","percent_changed":46.84},{"item":"Remuneration of councillors","amount":9119114.0,"comparison":"Original to adjusted budget","percent_changed":29.26},{"item":"Remuneration of councillors","amount":9110391.0,"comparison":"Original budget to audited outcome","percent_changed":29.23},{"item":"Transfers and subsidies","amount":2092238.0,"comparison":"Original to adjusted budget","percent_changed":15.12},{"item":"Transfers and subsidies","amount":4556458.0,"comparison":"Original budget to audited outcome","percent_changed":32.93}]},"spending_time_series":[{"amount":1121102144.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":1152419061.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":1170698523.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":1352181241.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":1044780210.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":1125063274.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":1163606447.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":1338504080.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":1492645664.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":1307329636.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":1367314716.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":1113969208.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":1116811362.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":1171585203.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":1253190894.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":1249698143.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":50.9,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"good","result":-4.42,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"good","result":-1.49,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"good","result":-2.97,"overunder":"under","cube_version":"v2"}],"formula":{"text":"= ((Actual Capital Expenditure - Budgeted Capital Expenditure) / Budgeted Capital Expenditure) * 100","actual":["=","(","(",{"cube":"capital","item_codes":["4100"],"amount_type":"AUDA"},"-",{"cube":"capital","item_codes":["4100"],"amount_type":"ADJB"},")","/",{"cube":"capital","item_codes":["4100"],"amount_type":"ADJB"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= ((Actual Capital Expenditure - Budgeted Capital Expenditure) / Budgeted Capital Expenditure) * 100","actual":["=","(","(",{"cube":"capital_v2","amount_type":"AUDA","item_description":"capital type code NEW, RENEWAL, UPGRADING"},"-",{"cube":"capital_v2","amount_type":"ADJB","item_description":"capital type code NEW, RENEWAL, UPGRADING"},")","/",{"cube":"capital_v2","amount_type":"ADJB","item_description":"capital type code NEW, RENEWAL, UPGRADING"},")","*","100"]},"result_type":"%"},"local_revenue_breakdown":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"date":"2024","item":"Property rates","amount":507016897.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":250436972.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":4145746.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":51627025.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":20598006.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":9657150.0,"amount_type":"AUDA"},{"date":"2024","item":"Agency services","amount":5931164.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":88863629.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":35.91},{"date":2023,"rating":"","result":39.14},{"date":2022,"rating":"","result":39.64},{"date":2021,"rating":"","result":41.02}],"formula":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp","item_codes":["3000","3100"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp_v2","item_codes":["3100"],"amount_type":"AUDA"}]},"result_type":"%"},"operating_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2024,"rating":"good","result":-1.0,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"good","result":-0.6,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"good","result":-2.4,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"ave","result":-6.8,"overunder":"under","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":4.66,"cube_version":"v2"},{"date":2023,"rating":"bad","result":2.68,"cube_version":"v2"},{"date":2022,"rating":"bad","result":2.23,"cube_version":"v2"},{"date":2021,"rating":"bad","result":2.43,"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":16.3},{"date":2023,"rating":"","result":18.18},{"date":2022,"rating":"","result":19.01},{"date":2021,"rating":"","result":18.23}],"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":94.22,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"good","result":96.44,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"bad","result":93.74,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"bad","result":92.56,"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":65866655.0},{"year":2022,"value":85302783.0},{"year":2023,"value":91680978.0},{"year":2024,"value":124459070.0},{"year":2025,"value":143761170.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":131307913.0},{"year":2022,"value":154214313.0},{"year":2023,"value":142293907.0},{"year":2024,"value":162298916.0},{"year":2025,"value":222361739.0}],"category":"Electricity "},{"values":[{"year":2021,"value":16457980.0},{"year":2022,"value":25263513.0},{"year":2023,"value":25561996.0},{"year":2024,"value":27405097.0},{"year":2025,"value":28155207.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":450345485.0},{"year":2022,"value":485888375.0},{"year":2023,"value":543913239.0},{"year":2024,"value":582932651.0},{"year":2025,"value":667992412.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":66414731.0},{"year":2022,"value":60441697.0},{"year":2023,"value":31237767.0},{"year":2024,"value":47182556.0},{"year":2025,"value":14965766.0}],"category":"Housing"},{"values":[{"year":2021,"value":2446745.0},{"year":2022,"value":3014802.0},{"year":2023,"value":5789175.0},{"year":2024,"value":5549181.0},{"year":2025,"value":6044552.0}],"category":"Other"},{"values":[{"year":2021,"value":136665730.0},{"year":2022,"value":142373251.0},{"year":2023,"value":147044586.0},{"year":2024,"value":195906859.0},{"year":2025,"value":224926968.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":4714501.0},{"year":2022,"value":5036997.0},{"year":2023,"value":5073543.0},{"year":2024,"value":5352986.0},{"year":2025,"value":-10369134.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":170560470.0},{"year":2022,"value":163527543.0},{"year":2023,"value":171011256.0},{"year":2024,"value":187416764.0},{"year":2025,"value":194806984.0}],"category":"Waste Management"}],"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":[{"date":"2016-08-03","changes":[{"change":"disestablished","demarcation_code":"KZN215"}]}],"code":"KZN216"},"muni_contact":{"url":"http://http://rnm.gov.za/","phone_number":"039 688 2000","street_address_1":"Council Chambers","street_address_2":"10 Connor Street","street_address_3":"Port Shepstone","street_address_4":"4240"},"mayoral_staff":{"officials":[{"name":"P. Zodwa Mzindle","role":"Mayor/Executive Mayor","email":"Zodwa.Mzindle@rnm.gov.za","title":"Cllr","secretary":{"name":"Simphiwe Ntozakhe","role":"Secretary of Mayor/Executive Mayor","email":"simphiwe.ntozakhe@rnm.gov.za","title":"Ms","fax_number":"086 457 1826","office_phone":"039 688 2002"},"fax_number":" ","office_phone":"039 688 2004"},{"name":"Khethukuthula Joseph Zulu","role":"Municipal Manager","email":"mm@rnm.gov.za","title":"Mr","secretary":{"name":"Xabisa Putaza","role":"Secretary of Municipal Manager","email":"pamm@rnm.gov.za","title":"Ms","fax_number":"039 682 0327","office_phone":"039 688 2021"},"fax_number":"039 682 0327","office_phone":"039 688 2021"},{"name":"Sibusiso Godfrey Shange","role":"Deputy Mayor/Executive Mayor","email":"sibusisos@rnm.gov.za","title":"Cllr","secretary":{"name":"Noneka Diya","role":"Secretary of Deputy Mayor/Executive Mayor","email":"noneka@rnm.gov.za","title":"Ms","fax_number":"039 682 0327","office_phone":"039 688 2002"},"fax_number":"086 457 1826","office_phone":"039 688 2002"},{"name":"Sandiso Thutshini","role":"Chief Financial Officer","email":"sandiso.thutshini@rnm.gov.za","title":"Mr","secretary":{"name":"Nokukhanya Zindela","role":"Secretary of Financial Manager","email":"nokukhanyaz@rnm.gov.za","title":"Ms","fax_number":"086 529 7075","office_phone":"039 312 8302"},"fax_number":"039 682 0327","office_phone":"039 312 8301"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/KZN216/KZN216_Audit%20Report_2024_Y_20240328T090747Z_nomonde_bhengu.pdf"},{"date":2023,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/KZN216/KZN216_Audit%20Report_2023_Y_20240219T131754Z_thabani_shazi.pdf"},{"date":2022,"rating":"unqualified","result":"Unqualified - No findings","report_url":"https://lg.treasury.gov.za/supportingdocs/KZN216/KZN216_Audit%20Report_2022_Y_20221202T084916Z_thabani_shazi.pdf"},{"date":2021,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/KZN216/KZN216_Audit%20Report_2021_Y_20220301T085537Z_5405.pdf"}]}}