{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":18877980.0,"national_conditional_grants":15416036.0},"ORGB":{"equitable_share":205072000.0,"national_conditional_grants":149074000.0},"SCHD":{"national_conditional_grants":129158000.0},"TRFR":{"national_conditional_grants":60469000.0}},"2022":{"ACT":{"national_conditional_grants":33710241.0},"ORGB":{"equitable_share":212328000.0,"national_conditional_grants":179593000.0},"SCHD":{"national_conditional_grants":142191000.0},"TRFR":{"national_conditional_grants":123293000.0}},"2023":{"ACT":{"national_conditional_grants":78487630.0},"ORGB":{"equitable_share":239158000.0,"provincial_transfers":105473000.0,"national_conditional_grants":152097000.0},"SCHD":{"national_conditional_grants":126497000.0},"TRFR":{"national_conditional_grants":124897000.0}},"2024":{"ACT":{"national_conditional_grants":125847970.0},"ORGB":{"equitable_share":263135000.0,"national_conditional_grants":243287000.0},"SCHD":{"national_conditional_grants":154841000.0},"TRFR":{"national_conditional_grants":146301000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":18877980.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":205072000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":212328000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":239158000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":263135000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":96973000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":8500000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023}]},"national_conditional_grants":{"2021":[{"amount.sum":434904.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":328000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":328000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","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":10000000.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":86528.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":10000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":994758.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":5000000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":3500000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":8743156.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":50955000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":20927000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":600000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":300000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":5156689.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":20000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":20000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":4170000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1043000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":162000.0,"grant.code":"WS6G","grant.label":"Water Services Infrastructure Grant (Sched 6)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":25943000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":12971000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021}],"2022":[{"amount.sum":1015000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1015000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":2420530.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":36500000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":36500000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":5500000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":5500000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":54266000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":54266000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":18425972.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":300000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":52495.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":3362000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":3362000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":18598000.0,"grant.code":"WS6G","grant.label":"Water Services Infrastructure Grant (Sched 6)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":12811244.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":21000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":21000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":3974432.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":4000000.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":4000000.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":1700000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1700000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1700000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":18716745.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":24400000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":24400000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":3764985.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":5500000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":5500000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":70390000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":70390000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":40123348.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":3959000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":3959000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":3959000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1600000.0,"grant.code":"WS6G","grant.label":"Water Services Infrastructure Grant (Sched 6)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":6249120.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":14948000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":14948000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":5742913.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":6000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":6000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1700000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1700000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1700000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":18082584.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":27104000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":27104000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":2875503.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":5000000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":5000000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":55629906.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":63395000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":63395000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":-1.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":3102000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":3102000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":3102000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":38715065.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":40000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":40000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":8540000.0,"grant.code":"WS6G","grant.label":"Water Services Infrastructure Grant (Sched 6)","amount_type.code":"SCHD","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":"bad","result":-96711629.0,"cube_version":"v2"},{"date":2023,"rating":"bad","result":-599622381.0,"cube_version":"v2"},{"date":2022,"rating":"bad","result":-668429931.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":29423154.0,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"}]},"result_type":"R"},"cash_coverage":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"bad","result":0,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0,"cube_version":"v2"},{"date":2022,"rating":"bad","result":0,"cube_version":"v2"},{"date":2021,"rating":"bad","result":0.2,"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":268097687.0,"rating":"bad","result":-0.84,"amount_type":"AUDA","liabilities":-320342992.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":2304408275.0,"rating":"good","result":1.58,"amount_type":"AUDA","liabilities":1457965532.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":2396615373.0,"rating":"good","result":1.92,"amount_type":"AUDA","liabilities":1249269882.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":1893023478.0,"rating":"good","result":2.82,"amount_type":"AUDA","liabilities":671382177.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":-83864376.0,"date":"2024","year":2024,"rating":"bad","result":0.26,"amount_type":"ACT","liabilities":-320342992.0,"cube_version":"v2","call_investment_deposits":0},{"cash":109536453.0,"date":"2023","year":2023,"rating":"bad","result":0.08,"amount_type":"ACT","liabilities":1457965532.0,"cube_version":"v2","call_investment_deposits":0},{"cash":197590756.0,"date":"2022","year":2022,"rating":"bad","result":0.16,"amount_type":"ACT","liabilities":1249269882.0,"cube_version":"v2","call_investment_deposits":0},{"cash":43007487.0,"date":"2021","year":2021,"rating":"bad","result":0.06,"amount_type":"ACT","liabilities":671382177.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":2423377692.0,"percent":82.85},"total":2925084316.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":501706624.0,"percent":17.15}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":4.81,"cube_version":"v2"},{"date":2023,"rating":"bad","result":9.37,"cube_version":"v2"},{"date":2022,"rating":"bad","result":10.74,"cube_version":"v2"},{"date":2021,"rating":"bad","result":6.01,"cube_version":"v2"}],"formula":{"text":"= (Unauthorised, Irregular, Fruitless and Wasteful Expenditure / Actual Operating Expenditure) * 100","actual":["=","(",{"cube":"uifwexp","item_codes":["irregular","fruitless","unauthorised"]},"/",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= (Unauthorised, Irregular, Fruitless and Wasteful Expenditure / Actual Operating Expenditure) * 100","actual":["=","(",{"cube":"uifwexp","item_codes":["irregular","fruitless","unauthorised"]},"/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},")","*","100"]},"result_type":"%"},"income_adjustments":{"2021":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":-3868369.0,"comparison":"Original budget to audited outcome","percent_changed":-11.6},{"item":"Government Transfers","amount":35595000.0,"comparison":"Original to adjusted budget","percent_changed":15.85},{"item":"Government Transfers","amount":35884045.0,"comparison":"Original budget to audited outcome","percent_changed":15.98},{"item":"Interest and investments","amount":-16000000.0,"comparison":"Original to adjusted budget","percent_changed":-9.76},{"item":"Interest and investments","amount":-55182737.0,"comparison":"Original budget to audited outcome","percent_changed":-33.65},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":283047.0,"comparison":"Original budget to audited outcome","percent_changed":4.64},{"item":"Other","amount":22000000.0,"comparison":"Original to adjusted budget","percent_changed":122.17},{"item":"Other","amount":5081695.0,"comparison":"Original budget to audited outcome","percent_changed":28.22},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-13032258.0,"comparison":"Original budget to audited outcome","percent_changed":-2.23},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":-422387.0,"comparison":"Original budget to audited outcome","percent_changed":-3.4},{"item":"Service Charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":-116968198.0,"comparison":"Original budget to audited outcome","percent_changed":-10.0}],"2022":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":-19319590.0,"comparison":"Original budget to audited outcome","percent_changed":-55.64},{"item":"Government Transfers","amount":6232607.0,"comparison":"Original to adjusted budget","percent_changed":2.7},{"item":"Government Transfers","amount":5346066.0,"comparison":"Original budget to audited outcome","percent_changed":2.32},{"item":"Interest and investments","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":-31916637.0,"comparison":"Original budget to audited outcome","percent_changed":-19.2},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":2031893.0,"comparison":"Original budget to audited outcome","percent_changed":31.26},{"item":"Other","amount":273600.0,"comparison":"Original to adjusted budget","percent_changed":1.41},{"item":"Other","amount":8095834.0,"comparison":"Original budget to audited outcome","percent_changed":41.71},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-3808747.0,"comparison":"Original budget to audited outcome","percent_changed":-0.63},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":3610155.0,"comparison":"Original budget to audited outcome","percent_changed":27.46},{"item":"Service Charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":-151453293.0,"comparison":"Original budget to audited outcome","percent_changed":-11.73}],"2023":[{"item":"Fines","amount":8000000.0,"comparison":"Original to adjusted budget","percent_changed":28.85},{"item":"Fines","amount":31731623.0,"comparison":"Original budget to audited outcome","percent_changed":114.43},{"item":"Government Transfers","amount":7913919.0,"comparison":"Original to adjusted budget","percent_changed":3.07},{"item":"Government Transfers","amount":6539590.0,"comparison":"Original budget to audited outcome","percent_changed":2.53},{"item":"Interest and investments","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":46031744.0,"comparison":"Original budget to audited outcome","percent_changed":28.33},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":2170708.0,"comparison":"Original budget to audited outcome","percent_changed":31.69},{"item":"Other","amount":2600000.0,"comparison":"Original to adjusted budget","percent_changed":14.33},{"item":"Other","amount":43427414.0,"comparison":"Original budget to audited outcome","percent_changed":239.34},{"item":"Property rates","amount":-17571600.0,"comparison":"Original to adjusted budget","percent_changed":-2.8},{"item":"Property rates","amount":-16654812.0,"comparison":"Original budget to audited outcome","percent_changed":-2.65},{"item":"Rental income","amount":12886000.0,"comparison":"Original to adjusted budget","percent_changed":99.05},{"item":"Rental income","amount":12990385.0,"comparison":"Original budget to audited outcome","percent_changed":99.85},{"item":"Service Charges","amount":-5060000.0,"comparison":"Original to adjusted budget","percent_changed":-0.37},{"item":"Service Charges","amount":-190544585.0,"comparison":"Original budget to audited outcome","percent_changed":-13.88}],"2024":[{"item":"Fines","amount":7250000.0,"comparison":"Original to adjusted budget","percent_changed":23.65},{"item":"Fines","amount":26106715.0,"comparison":"Original budget to audited outcome","percent_changed":85.15},{"item":"Government Transfers","amount":5682000.0,"comparison":"Original to adjusted budget","percent_changed":2.02},{"item":"Government Transfers","amount":219785624.0,"comparison":"Original budget to audited outcome","percent_changed":77.96},{"item":"Interest and investments","amount":84020000.0,"comparison":"Original to adjusted budget","percent_changed":47.77},{"item":"Interest and investments","amount":98277821.0,"comparison":"Original budget to audited outcome","percent_changed":55.88},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-180624.0,"comparison":"Original budget to audited outcome","percent_changed":-2.46},{"item":"Other","amount":47580000.0,"comparison":"Original to adjusted budget","percent_changed":254.25},{"item":"Other","amount":50183549.0,"comparison":"Original budget to audited outcome","percent_changed":268.16},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-4451150.0,"comparison":"Original budget to audited outcome","percent_changed":-0.67},{"item":"Rental income","amount":1200000.0,"comparison":"Original to adjusted budget","percent_changed":4.46},{"item":"Rental income","amount":1920882.0,"comparison":"Original budget to audited outcome","percent_changed":7.13},{"item":"Service Charges","amount":-66670000.0,"comparison":"Original to adjusted budget","percent_changed":-4.39},{"item":"Service Charges","amount":-186162295.0,"comparison":"Original budget to audited outcome","percent_changed":-12.27}]},"income_time_series":[{"amount":2254156218.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":2372217587.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":2495977291.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":2798665794.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":2064336056.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":2178297061.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":2422901039.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":2925084316.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":2999537104.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":3168498766.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":3393664117.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":2212561218.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":2365711380.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":2487208972.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":2719603794.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":2958278267.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":-8000000.0,"comparison":"Original to adjusted budget","percent_changed":-1.42},{"item":"Bulk purchases","amount":-21546585.0,"comparison":"Original budget to audited outcome","percent_changed":-3.83},{"item":"Contracted services","amount":4600000.0,"comparison":"Original to adjusted budget","percent_changed":10.23},{"item":"Contracted services","amount":-4297199.0,"comparison":"Original budget to audited outcome","percent_changed":-9.56},{"item":"Employee related costs","amount":-14200000.0,"comparison":"Original to adjusted budget","percent_changed":-1.74},{"item":"Employee related costs","amount":-88062491.0,"comparison":"Original budget to audited outcome","percent_changed":-10.81},{"item":"Finance charges","amount":12000000.0,"comparison":"Original to adjusted budget","percent_changed":50.97},{"item":"Finance charges","amount":12925402.0,"comparison":"Original budget to audited outcome","percent_changed":54.9},{"item":"Other","amount":55725000.0,"comparison":"Original to adjusted budget","percent_changed":7.86},{"item":"Other","amount":80606954.0,"comparison":"Original budget to audited outcome","percent_changed":11.37},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-2762908.0,"comparison":"Original budget to audited outcome","percent_changed":-8.37},{"item":"Transfers and subsidies","amount":-1780000.0,"comparison":"Original to adjusted budget","percent_changed":-29.37},{"item":"Transfers and subsidies","amount":-3531602.0,"comparison":"Original budget to audited outcome","percent_changed":-58.28}],"2022":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-7311113.0,"comparison":"Original budget to audited outcome","percent_changed":-1.13},{"item":"Contracted services","amount":-5465000.0,"comparison":"Original to adjusted budget","percent_changed":-11.71},{"item":"Contracted services","amount":-8524085.0,"comparison":"Original budget to audited outcome","percent_changed":-18.26},{"item":"Employee related costs","amount":5200000.0,"comparison":"Original to adjusted budget","percent_changed":0.62},{"item":"Employee related costs","amount":-63611078.0,"comparison":"Original budget to audited outcome","percent_changed":-7.61},{"item":"Finance charges","amount":41200000.0,"comparison":"Original to adjusted budget","percent_changed":185.08},{"item":"Finance charges","amount":50648664.0,"comparison":"Original budget to audited outcome","percent_changed":227.53},{"item":"Other","amount":35671207.0,"comparison":"Original to adjusted budget","percent_changed":4.74},{"item":"Other","amount":4585843.0,"comparison":"Original budget to audited outcome","percent_changed":0.61},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-3810458.0,"comparison":"Original budget to audited outcome","percent_changed":-11.03},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Transfers and subsidies","amount":-2304014.0,"comparison":"Original budget to audited outcome","percent_changed":-47.51}],"2023":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-9638000.0,"comparison":"Original budget to audited outcome","percent_changed":-1.41},{"item":"Contracted services","amount":7744000.0,"comparison":"Original to adjusted budget","percent_changed":16.68},{"item":"Contracted services","amount":-18151562.0,"comparison":"Original budget to audited outcome","percent_changed":-39.09},{"item":"Employee related costs","amount":567000.0,"comparison":"Original to adjusted budget","percent_changed":0.07},{"item":"Employee related costs","amount":-28097430.0,"comparison":"Original budget to audited outcome","percent_changed":-3.31},{"item":"Finance charges","amount":78400000.0,"comparison":"Original to adjusted budget","percent_changed":201.23},{"item":"Finance charges","amount":74994766.0,"comparison":"Original budget to audited outcome","percent_changed":192.49},{"item":"Other","amount":146365919.0,"comparison":"Original to adjusted budget","percent_changed":18.09},{"item":"Other","amount":115930675.0,"comparison":"Original budget to audited outcome","percent_changed":14.32},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-2323154.0,"comparison":"Original budget to audited outcome","percent_changed":-6.72},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Transfers and subsidies","amount":-1861082.0,"comparison":"Original budget to audited outcome","percent_changed":-41.73}],"2024":[{"item":"Bulk purchases","amount":5100000.0,"comparison":"Original to adjusted budget","percent_changed":0.65},{"item":"Bulk purchases","amount":2457231.0,"comparison":"Original budget to audited outcome","percent_changed":0.31},{"item":"Contracted services","amount":8800000.0,"comparison":"Original to adjusted budget","percent_changed":18.29},{"item":"Contracted services","amount":-3023002.0,"comparison":"Original budget to audited outcome","percent_changed":-6.28},{"item":"Employee related costs","amount":28728600.0,"comparison":"Original to adjusted budget","percent_changed":3.26},{"item":"Employee related costs","amount":12653567.0,"comparison":"Original budget to audited outcome","percent_changed":1.44},{"item":"Finance charges","amount":560000.0,"comparison":"Original to adjusted budget","percent_changed":2.87},{"item":"Finance charges","amount":103156375.0,"comparison":"Original budget to audited outcome","percent_changed":529.15},{"item":"Other","amount":49469915.0,"comparison":"Original to adjusted budget","percent_changed":5.4},{"item":"Other","amount":-5353566.0,"comparison":"Original budget to audited outcome","percent_changed":-0.58},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-1690009.0,"comparison":"Original budget to audited outcome","percent_changed":-4.75},{"item":"Transfers and subsidies","amount":-1000000.0,"comparison":"Original to adjusted budget","percent_changed":-21.93},{"item":"Transfers and subsidies","amount":-2033565.0,"comparison":"Original budget to audited outcome","percent_changed":-44.6}]},"spending_time_series":[{"amount":2241372524.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":2421590130.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":2698204587.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":2782910897.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":2166359095.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":2314657682.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":2595981881.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":2797419413.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":3137984147.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":3121200559.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":3341849115.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":2193027524.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":2344983923.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":2465127668.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":2691252382.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":2928504730.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":-18.59,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"bad","result":-33.29,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"bad","result":-23.75,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"bad","result":-23.12,"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":656442329.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":1331093240.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":28850882.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":274157821.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":56766715.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":7169376.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":68897329.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":31.97},{"date":2023,"rating":"","result":31.64},{"date":2022,"rating":"","result":33.39},{"date":2021,"rating":"","result":33.52}],"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":0.5,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"good","result":-3.8,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"good","result":-4.4,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"good","result":-3.3,"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":"good","result":373.69,"cube_version":"v2"},{"date":2023,"rating":"good","result":13.98,"cube_version":"v2"},{"date":2022,"rating":"good","result":12.36,"cube_version":"v2"},{"date":2021,"rating":"good","result":11.71,"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":1.61},{"date":2023,"rating":"","result":1.09},{"date":2022,"rating":"","result":1.65},{"date":2021,"rating":"","result":1.88}],"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":73.93,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"bad","result":72.86,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"bad","result":83.84,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"good","result":138.61,"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":79020254.0},{"year":2022,"value":85187966.0},{"year":2023,"value":86565895.0},{"year":2024,"value":92721325.0},{"year":2025,"value":90985732.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":749832583.0},{"year":2022,"value":882509838.0},{"year":2023,"value":963125090.0},{"year":2024,"value":1101327940.0},{"year":2025,"value":1280769774.0}],"category":"Electricity "},{"values":[{"year":2021,"value":664660.0},{"year":2022,"value":700441.0},{"year":2023,"value":835686.0},{"year":2024,"value":869896.0},{"year":2025,"value":907036.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":693385396.0},{"year":2022,"value":668277849.0},{"year":2023,"value":812993235.0},{"year":2024,"value":794538323.0},{"year":2025,"value":901269370.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":17367151.0},{"year":2022,"value":18658993.0},{"year":2023,"value":19082277.0},{"year":2024,"value":20412399.0},{"year":2025,"value":18678588.0}],"category":"Health"},{"values":[{"year":2021,"value":21939676.0},{"year":2022,"value":19874078.0},{"year":2023,"value":20980191.0},{"year":2024,"value":21956487.0},{"year":2025,"value":22732985.0}],"category":"Housing"},{"values":[{"year":2021,"value":9663439.0},{"year":2022,"value":10333584.0},{"year":2023,"value":10265842.0},{"year":2024,"value":10121485.0},{"year":2025,"value":9333244.0}],"category":"Other"},{"values":[{"year":2021,"value":82377797.0},{"year":2022,"value":84945688.0},{"year":2023,"value":95517412.0},{"year":2024,"value":123669214.0},{"year":2025,"value":130478729.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":47701730.0},{"year":2022,"value":53031687.0},{"year":2023,"value":59539190.0},{"year":2024,"value":66863324.0},{"year":2025,"value":63434039.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":58513214.0},{"year":2022,"value":71978233.0},{"year":2023,"value":73110426.0},{"year":2024,"value":79136062.0},{"year":2025,"value":82637006.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":91752704.0},{"year":2022,"value":92343132.0},{"year":2023,"value":104093133.0},{"year":2024,"value":122084782.0},{"year":2025,"value":117219914.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":314140491.0},{"year":2022,"value":326816193.0},{"year":2023,"value":349873504.0},{"year":2024,"value":363718176.0},{"year":2025,"value":419537730.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":"NC091"},"muni_contact":{"url":"http://www.solplaatje.org.za","phone_number":"053 830 6911","street_address_1":"Civic Centre","street_address_2":"Sol Plaatje Drive","street_address_3":"Kimberley","street_address_4":"8301"},"mayoral_staff":{"officials":[{"name":"Martha Barbara Bartlett","role":"Mayor/Executive Mayor","email":"mbartlett@solplaatje.org.za","title":"Ms","secretary":{"name":"Ben Johnson","role":"Secretary of Mayor/Executive Mayor","email":"bjohnson@solplaatje.org.za","title":"Mr","fax_number":"053 839 1431","office_phone":"053 830 6269"},"fax_number":"053 839 1431","office_phone":"053 830 6213"},{"name":"Bartholomew Matlala","role":"Municipal Manager","email":"bmatlala@solplaatje.org.za","title":"Mr","secretary":{"name":"Julia Bonokwane","role":"Secretary of Municipal Manager","email":"jbonokwane@solplaatje.org.za","title":"Ms","fax_number":"053 833 1005","office_phone":"053 830 6101"},"fax_number":"053 833 1005","office_phone":"053 830 6100"},{"name":"","role":"Deputy Mayor/Executive Mayor","email":"","title":"","secretary":{"name":"","role":"Secretary of Deputy Mayor/Executive Mayor","email":"","title":"","fax_number":"","office_phone":""},"fax_number":"","office_phone":""},{"name":"Euphonia Lehlohonolo Rapodile","role":"Chief Financial Officer","email":"lrapodile@solplaatje.org.za","title":"Ms","secretary":{"name":"Mapule Mogakwe","role":"Secretary of Financial Manager","email":"mmogakwe@solplaatje.org.za","title":"Ms","fax_number":"053 831 4658","office_phone":"053 830 6502"},"fax_number":"053 832 6571","office_phone":"053 830 6500"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/NC091/NC091_Audit%20Report_2024_Y_20250115T131914Z_ccrouch.pdf"},{"date":2023,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/NC091/NC091_Audit%20Report_2023_Y_20231201T094510Z_ccrouch.pdf"},{"date":2022,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/NC091/NC091_Audit%20Report_2022_Y_20221202T154635Z_cjenneke.pdf"},{"date":2021,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/NC091/NC091_Audit%20Report_2021_Y_20220204T155148Z_kdeklerk.pdf"}]}}