{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":6331261.0,"national_conditional_grants":17206445.0},"ORGB":{"equitable_share":403064000.0,"national_conditional_grants":179156000.0},"SCHD":{"national_conditional_grants":167656000.0},"TRFR":{"national_conditional_grants":83181000.0}},"2022":{"ACT":{"national_conditional_grants":102332445.0},"ORGB":{"equitable_share":417790000.0,"national_conditional_grants":210365000.0},"SCHD":{"national_conditional_grants":189305000.0},"TRFR":{"national_conditional_grants":175220000.0}},"2023":{"ACT":{"national_conditional_grants":197928644.0},"ORGB":{"equitable_share":466902000.0,"provincial_transfers":640000000.0,"national_conditional_grants":233397000.0},"SCHD":{"national_conditional_grants":243297000.0},"TRFR":{"national_conditional_grants":212744000.0}},"2024":{"ACT":{"national_conditional_grants":242931725.0},"ORGB":{"equitable_share":506803000.0,"national_conditional_grants":257880000.0},"SCHD":{"national_conditional_grants":262682000.0},"TRFR":{"national_conditional_grants":250483000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":6331261.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":403064000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":417790000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":466902000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":506803000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":5907000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":21036000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":608057000.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":757000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":757000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":700.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":7000000.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":7000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":15997612.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":111804000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":70000000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","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":2895000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":724000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1208133.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":35000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":10000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021}],"2022":[{"amount.sum":273700.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":378035.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":1650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":13985000.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":223503.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":82817440.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":119182000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":119182000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":100000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":7440000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":7440000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":2549814.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":2948000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":2948000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":16089953.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":965483.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1850000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1850000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":30553000.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":804475.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":126616843.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":129141000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":129141000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":17861663.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":30000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":30000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":3753396.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":3753000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":3753000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":47926784.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":48000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":48000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":14682589.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":20652000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":20652000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1849999.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1850000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1850000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":12199000.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":20549999.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":20550000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":20550000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1659701.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":130507053.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":133499000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":133499000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":21000270.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":21000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":21000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":2682113.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":2932000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":2932000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":50000001.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":50000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":50000000.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":2137839670.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":2507200460.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":3135834666.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":2682652316.0,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"}]},"result_type":"R"},"cash_coverage":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"good","result":8.7,"cube_version":"v2"},{"date":2023,"rating":"good","result":11.4,"cube_version":"v2"},{"date":2022,"rating":"good","result":16.2,"cube_version":"v2"},{"date":2021,"rating":"good","result":14.1,"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":952237029.0,"rating":"bad","result":0.72,"amount_type":"AUDA","liabilities":1330865906.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":898898415.0,"rating":"bad","result":0.83,"amount_type":"AUDA","liabilities":1076983528.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":7113603128.0,"rating":"ave","result":1.02,"amount_type":"AUDA","liabilities":6968820692.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":824540620.0,"rating":"bad","result":0.96,"amount_type":"AUDA","liabilities":862671356.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":26385906.0,"date":"2024","year":2024,"rating":"bad","result":0.02,"amount_type":"ACT","liabilities":1330865906.0,"cube_version":"v2","call_investment_deposits":0},{"cash":19316795.0,"date":"2023","year":2023,"rating":"bad","result":0.02,"amount_type":"ACT","liabilities":1076983528.0,"cube_version":"v2","call_investment_deposits":0},{"cash":45047144.0,"date":"2022","year":2022,"rating":"bad","result":0.01,"amount_type":"ACT","liabilities":6968820692.0,"cube_version":"v2","call_investment_deposits":0},{"cash":-21619904.0,"date":"2021","year":2021,"rating":"bad","result":-0.03,"amount_type":"ACT","liabilities":862671356.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":1825276805.0,"percent":75.87},"total":2405952145.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":580675340.0,"percent":24.13}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":9.45,"cube_version":"v2"},{"date":2023,"rating":"bad","result":10.83,"cube_version":"v2"},{"date":2022,"rating":"bad","result":4.81,"cube_version":"v2"},{"date":2021,"rating":"bad","result":1.58,"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":-4500506.0,"comparison":"Original to adjusted budget","percent_changed":-34.32},{"item":"Fines","amount":-7712424.0,"comparison":"Original budget to audited outcome","percent_changed":-58.81},{"item":"Government Transfers","amount":88577963.0,"comparison":"Original to adjusted budget","percent_changed":13.93},{"item":"Government Transfers","amount":-60291210.0,"comparison":"Original budget to audited outcome","percent_changed":-9.48},{"item":"Interest and investments","amount":-1342000.0,"comparison":"Original to adjusted budget","percent_changed":-15.21},{"item":"Interest and investments","amount":-2160952.0,"comparison":"Original budget to audited outcome","percent_changed":-24.5},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":86298.0,"comparison":"Original budget to audited outcome","percent_changed":568.72},{"item":"Other","amount":3120592.0,"comparison":"Original to adjusted budget","percent_changed":19.82},{"item":"Other","amount":17563906.0,"comparison":"Original budget to audited outcome","percent_changed":111.58},{"item":"Property rates","amount":-47710000.0,"comparison":"Original to adjusted budget","percent_changed":-12.03},{"item":"Property rates","amount":-53998249.0,"comparison":"Original budget to audited outcome","percent_changed":-13.62},{"item":"Rental income","amount":-1053286.0,"comparison":"Original to adjusted budget","percent_changed":-12.4},{"item":"Rental income","amount":-1401642.0,"comparison":"Original budget to audited outcome","percent_changed":-16.5},{"item":"Service Charges","amount":498177.0,"comparison":"Original to adjusted budget","percent_changed":0.05},{"item":"Service Charges","amount":-1387166.0,"comparison":"Original budget to audited outcome","percent_changed":-0.14}],"2022":[{"item":"Fines","amount":1838814.0,"comparison":"Original to adjusted budget","percent_changed":87.36},{"item":"Fines","amount":3247783.0,"comparison":"Original budget to audited outcome","percent_changed":154.29},{"item":"Government Transfers","amount":148066035.0,"comparison":"Original to adjusted budget","percent_changed":21.3},{"item":"Government Transfers","amount":-218808239.0,"comparison":"Original budget to audited outcome","percent_changed":-31.48},{"item":"Interest and investments","amount":-397650.0,"comparison":"Original to adjusted budget","percent_changed":-5.73},{"item":"Interest and investments","amount":1370025.0,"comparison":"Original budget to audited outcome","percent_changed":19.75},{"item":"Licenses and Permits","amount":-63505.0,"comparison":"Original to adjusted budget","percent_changed":-60.52},{"item":"Licenses and Permits","amount":-59115.0,"comparison":"Original budget to audited outcome","percent_changed":-56.33},{"item":"Other","amount":35144.0,"comparison":"Original to adjusted budget","percent_changed":0.17},{"item":"Other","amount":49057970.0,"comparison":"Original budget to audited outcome","percent_changed":233.76},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-9103739.0,"comparison":"Original budget to audited outcome","percent_changed":-2.51},{"item":"Rental income","amount":1384714.0,"comparison":"Original to adjusted budget","percent_changed":18.38},{"item":"Rental income","amount":840935.0,"comparison":"Original budget to audited outcome","percent_changed":11.16},{"item":"Service Charges","amount":13394295.0,"comparison":"Original to adjusted budget","percent_changed":1.2},{"item":"Service Charges","amount":9101328.0,"comparison":"Original budget to audited outcome","percent_changed":0.81}],"2023":[{"item":"Fines","amount":377058.0,"comparison":"Original to adjusted budget","percent_changed":9.02},{"item":"Fines","amount":1548669.0,"comparison":"Original budget to audited outcome","percent_changed":37.05},{"item":"Government Transfers","amount":-486245350.0,"comparison":"Original to adjusted budget","percent_changed":-43.7},{"item":"Government Transfers","amount":-572744519.0,"comparison":"Original budget to audited outcome","percent_changed":-51.47},{"item":"Interest and investments","amount":4074617.0,"comparison":"Original to adjusted budget","percent_changed":57.13},{"item":"Interest and investments","amount":4803289.0,"comparison":"Original budget to audited outcome","percent_changed":67.34},{"item":"Licenses and Permits","amount":-15633.0,"comparison":"Original to adjusted budget","percent_changed":-32.62},{"item":"Licenses and Permits","amount":13779.0,"comparison":"Original budget to audited outcome","percent_changed":28.75},{"item":"Other","amount":-9477886.0,"comparison":"Original to adjusted budget","percent_changed":-48.64},{"item":"Other","amount":-8082843.0,"comparison":"Original budget to audited outcome","percent_changed":-41.48},{"item":"Property rates","amount":12690609.0,"comparison":"Original to adjusted budget","percent_changed":3.49},{"item":"Property rates","amount":12865918.0,"comparison":"Original budget to audited outcome","percent_changed":3.54},{"item":"Rental income","amount":-1145661.0,"comparison":"Original to adjusted budget","percent_changed":-12.12},{"item":"Rental income","amount":-1463816.0,"comparison":"Original budget to audited outcome","percent_changed":-15.49},{"item":"Service Charges","amount":34919626.0,"comparison":"Original to adjusted budget","percent_changed":2.97},{"item":"Service Charges","amount":-26362969.0,"comparison":"Original budget to audited outcome","percent_changed":-2.24}],"2024":[{"item":"Fines","amount":2415000.0,"comparison":"Original to adjusted budget","percent_changed":49.99},{"item":"Fines","amount":7238472.0,"comparison":"Original budget to audited outcome","percent_changed":149.84},{"item":"Government Transfers","amount":26528691.0,"comparison":"Original to adjusted budget","percent_changed":4.59},{"item":"Government Transfers","amount":3052330.0,"comparison":"Original budget to audited outcome","percent_changed":0.53},{"item":"Interest and investments","amount":-1930000.0,"comparison":"Original to adjusted budget","percent_changed":-17.22},{"item":"Interest and investments","amount":491215.0,"comparison":"Original budget to audited outcome","percent_changed":4.38},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":5818.0,"comparison":"Original budget to audited outcome","percent_changed":17.0},{"item":"Other","amount":10063144.0,"comparison":"Original to adjusted budget","percent_changed":95.93},{"item":"Other","amount":97182215.0,"comparison":"Original budget to audited outcome","percent_changed":926.41},{"item":"Property rates","amount":-126500.0,"comparison":"Original to adjusted budget","percent_changed":-0.03},{"item":"Property rates","amount":3328317.0,"comparison":"Original budget to audited outcome","percent_changed":0.84},{"item":"Rental income","amount":2295000.0,"comparison":"Original to adjusted budget","percent_changed":26.07},{"item":"Rental income","amount":586485.0,"comparison":"Original budget to audited outcome","percent_changed":6.66},{"item":"Service Charges","amount":2318689.0,"comparison":"Original to adjusted budget","percent_changed":0.17},{"item":"Service Charges","amount":-61400617.0,"comparison":"Original budget to audited outcome","percent_changed":-4.56}]},"income_time_series":[{"amount":2131252362.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":2378499571.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":2248439991.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":2397031934.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":1984359983.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":2049888672.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":2103840119.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":2405952145.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":2669372811.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":2677997674.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":2891032037.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":2093661422.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":2214241724.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":2693262611.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":2355467910.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":2480656032.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":-34769992.0,"comparison":"Original to adjusted budget","percent_changed":-6.51},{"item":"Bulk purchases","amount":-97564713.0,"comparison":"Original budget to audited outcome","percent_changed":-18.26},{"item":"Contracted services","amount":47709364.0,"comparison":"Original to adjusted budget","percent_changed":14.13},{"item":"Contracted services","amount":-58432967.0,"comparison":"Original budget to audited outcome","percent_changed":-17.3},{"item":"Employee related costs","amount":-49854608.0,"comparison":"Original to adjusted budget","percent_changed":-8.39},{"item":"Employee related costs","amount":-47772156.0,"comparison":"Original budget to audited outcome","percent_changed":-8.04},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":22097976.0,"comparison":"Original budget to audited outcome","percent_changed":51.53},{"item":"Other","amount":36257676.0,"comparison":"Original to adjusted budget","percent_changed":4.22},{"item":"Other","amount":72223269.0,"comparison":"Original budget to audited outcome","percent_changed":8.4},{"item":"Remuneration of councillors","amount":-1108800.0,"comparison":"Original to adjusted budget","percent_changed":-3.9},{"item":"Remuneration of councillors","amount":-2840244.0,"comparison":"Original budget to audited outcome","percent_changed":-9.98}],"2022":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-38307100.0,"comparison":"Original budget to audited outcome","percent_changed":-6.88},{"item":"Contracted services","amount":176802061.0,"comparison":"Original to adjusted budget","percent_changed":45.53},{"item":"Contracted services","amount":-126324220.0,"comparison":"Original budget to audited outcome","percent_changed":-32.53},{"item":"Employee related costs","amount":1899557.0,"comparison":"Original to adjusted budget","percent_changed":0.33},{"item":"Employee related costs","amount":14413290.0,"comparison":"Original budget to audited outcome","percent_changed":2.53},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":24598988.0,"comparison":"Original budget to audited outcome","percent_changed":61.88},{"item":"Other","amount":-13379948.0,"comparison":"Original to adjusted budget","percent_changed":-1.48},{"item":"Other","amount":-34574367.0,"comparison":"Original budget to audited outcome","percent_changed":-3.82},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-5140216.0,"comparison":"Original budget to audited outcome","percent_changed":-17.8}],"2023":[{"item":"Bulk purchases","amount":-41605341.0,"comparison":"Original to adjusted budget","percent_changed":-6.88},{"item":"Bulk purchases","amount":-77202025.0,"comparison":"Original budget to audited outcome","percent_changed":-12.76},{"item":"Contracted services","amount":-571040750.0,"comparison":"Original to adjusted budget","percent_changed":-69.59},{"item":"Contracted services","amount":-535234549.0,"comparison":"Original budget to audited outcome","percent_changed":-65.22},{"item":"Employee related costs","amount":35272081.0,"comparison":"Original to adjusted budget","percent_changed":5.87},{"item":"Employee related costs","amount":75984845.0,"comparison":"Original budget to audited outcome","percent_changed":12.64},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":40210571.0,"comparison":"Original budget to audited outcome","percent_changed":112.18},{"item":"Other","amount":14473165.0,"comparison":"Original to adjusted budget","percent_changed":1.57},{"item":"Other","amount":128752214.0,"comparison":"Original budget to audited outcome","percent_changed":14.01},{"item":"Remuneration of councillors","amount":-1897510.0,"comparison":"Original to adjusted budget","percent_changed":-6.53},{"item":"Remuneration of councillors","amount":-2077367.0,"comparison":"Original budget to audited outcome","percent_changed":-7.15}],"2024":[{"item":"Bulk purchases","amount":-6800000.0,"comparison":"Original to adjusted budget","percent_changed":-1.03},{"item":"Bulk purchases","amount":-40696842.0,"comparison":"Original budget to audited outcome","percent_changed":-6.16},{"item":"Contracted services","amount":59439401.0,"comparison":"Original to adjusted budget","percent_changed":28.62},{"item":"Contracted services","amount":116305384.0,"comparison":"Original budget to audited outcome","percent_changed":55.99},{"item":"Employee related costs","amount":-16170036.0,"comparison":"Original to adjusted budget","percent_changed":-2.23},{"item":"Employee related costs","amount":-43689458.0,"comparison":"Original budget to audited outcome","percent_changed":-6.03},{"item":"Finance charges","amount":340000.0,"comparison":"Original to adjusted budget","percent_changed":1.06},{"item":"Finance charges","amount":53721025.0,"comparison":"Original budget to audited outcome","percent_changed":166.81},{"item":"Other","amount":11106488.0,"comparison":"Original to adjusted budget","percent_changed":1.04},{"item":"Other","amount":129198176.0,"comparison":"Original budget to audited outcome","percent_changed":12.07},{"item":"Remuneration of councillors","amount":-1456000.0,"comparison":"Original to adjusted budget","percent_changed":-5.12},{"item":"Remuneration of councillors","amount":3345224.0,"comparison":"Original budget to audited outcome","percent_changed":11.76}]},"spending_time_series":[{"amount":2395707402.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":2654252420.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":2446077665.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":2771048563.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":2285184927.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":2323597125.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":2641309709.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":2942772219.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":3136559111.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":2756156919.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":2926487764.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":2397473762.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":2488930750.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":3010876020.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":2724588710.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":2617459526.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"capital_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2024,"rating":"bad","result":40.22,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"bad","result":82.2,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"ave","result":5.42,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"bad","result":-64.28,"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":400069256.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":1284336250.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":9390932.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":11698575.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":12069361.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":40042.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":107672389.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":23.14},{"date":2023,"rating":"","result":25.63},{"date":2022,"rating":"","result":25.16},{"date":2021,"rating":"","result":23.92}],"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":8.0,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"ave","result":-12.5,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"good","result":-4.6,"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":0.94,"cube_version":"v2"},{"date":2023,"rating":"bad","result":1.09,"cube_version":"v2"},{"date":2022,"rating":"bad","result":1.59,"cube_version":"v2"},{"date":2021,"rating":"bad","result":0.1,"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.01},{"date":2023,"rating":"","result":10.81},{"date":2022,"rating":"","result":11.27},{"date":2021,"rating":"","result":12.22}],"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":"good","result":104.64,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"bad","result":84.53,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"bad","result":88.3,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"bad","result":1.54,"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":92069339.0},{"year":2022,"value":113548979.0},{"year":2023,"value":139949180.0},{"year":2024,"value":132646996.0},{"year":2025,"value":180821560.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":567838924.0},{"year":2022,"value":649951620.0},{"year":2023,"value":666348990.0},{"year":2024,"value":816474695.0},{"year":2025,"value":894394429.0}],"category":"Electricity "},{"values":[{"year":2021,"value":9332.0},{"year":2022,"value":7397.0},{"year":2023,"value":6770.0},{"year":2024,"value":3174.0},{"year":2025,"value":3030.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":676813523.0},{"year":2022,"value":707120724.0},{"year":2023,"value":708934249.0},{"year":2024,"value":711362163.0},{"year":2025,"value":724545804.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":9188204.0},{"year":2022,"value":9592835.0},{"year":2023,"value":9615960.0},{"year":2024,"value":9381266.0},{"year":2025,"value":10589360.0}],"category":"Health"},{"values":[{"year":2021,"value":48669009.0},{"year":2022,"value":25047643.0},{"year":2023,"value":37907120.0},{"year":2024,"value":37161640.0},{"year":2025,"value":26476605.0}],"category":"Housing"},{"values":[{"year":2021,"value":800533.0},{"year":2022,"value":2866834.0},{"year":2023,"value":2954805.0},{"year":2024,"value":-20150909.0},{"year":2025,"value":4569620.0}],"category":"Other"},{"values":[{"year":2021,"value":207822476.0},{"year":2022,"value":191752993.0},{"year":2023,"value":204251792.0},{"year":2024,"value":205983556.0},{"year":2025,"value":247073745.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":78605750.0},{"year":2022,"value":67979185.0},{"year":2023,"value":73909315.0},{"year":2024,"value":67210093.0},{"year":2025,"value":72694839.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":34754817.0},{"year":2022,"value":41491130.0},{"year":2023,"value":83145139.0},{"year":2024,"value":163686436.0},{"year":2025,"value":137054241.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":73545229.0},{"year":2022,"value":53933979.0},{"year":2023,"value":104648004.0},{"year":2024,"value":206483338.0},{"year":2025,"value":239864880.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":495067791.0},{"year":2022,"value":460303806.0},{"year":2023,"value":609638385.0},{"year":2024,"value":612529771.0},{"year":2025,"value":598470998.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":"KZN252"},"muni_contact":{"url":"http://www.newcastle.gov.za","phone_number":"034 328 7600","street_address_1":"Newcastle Civic Center","street_address_2":"37 Murchison Street","street_address_3":"Newcastle","street_address_4":"2940"},"mayoral_staff":{"officials":[{"name":"David Xolani Dube","role":"Mayor/Executive Mayor","email":"david.dube@newcastle.gov.za","title":"Cllr","secretary":{"name":"Sabelo Fairman Dlamini","role":"Secretary of Mayor/Executive Mayor","email":"sabelo.dlamini@newcastle.gov.za","title":"Mr","fax_number":" ","office_phone":"034 328 7776"},"fax_number":"086 692 9147","office_phone":"034 328 7776"},{"name":"Zamokwakhe Wesley Mcineka","role":"Municipal Manager","email":"zamani.mcineka@newcastle.gov.za","title":"Mr","secretary":{"name":"Hlongozile Precious Zulu","role":"Secretary of Municipal Manager","email":"hlongozile.zulu@newcastle.gov.za","title":"Mrs","fax_number":"034 312 7089","office_phone":"034 328 7750"},"fax_number":"034 312 7089","office_phone":"034 328 7750"},{"name":"Andile Nkosi","role":"Deputy Mayor/Executive Mayor","email":"andile.nkosi@newcastle.gov.za","title":"Cllr","secretary":{"name":"Lungile Mnguni","role":"Secretary of Deputy Mayor/Executive Mayor","email":"lungile.mnguni@newcastle.gov.za","title":"Ms","fax_number":" ","office_phone":"034 328 7762"},"fax_number":" ","office_phone":"034 328 7924"},{"name":"Pearl Kubheka","role":"Chief Financial Officer","email":"pearl.kubheka@newcastle.gov.za","title":"Mrs","secretary":{"name":"Lizelle Oberholster","role":"Secretary of Financial Manager","email":"Lizelle.Oberholster@newcastle.gov.za","title":"Mrs","fax_number":"034 328 7769","office_phone":"034 328 7752"},"fax_number":"034 328 7769","office_phone":"034 328 7655"}],"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/KZN252/KZN252_Audit%20Report_2024_Y_20241203T123332Z_nomthandazo_zondo.pdf"},{"date":2023,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/KZN252/KZN252_Audit%20Report_2023_Y_20231204T140749Z_xolile_msibi.pdf"},{"date":2022,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/KZN252/KZN252_Audit%20Report_2022_Y_20230301T113606Z_xolile_msibi.pdf"},{"date":2021,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/KZN252/KZN252_Audit%20Report_2021_Y_20220301T084716Z_5405.pdf"}]}}