{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":7185764.0,"national_conditional_grants":17058080.0},"ORGB":{"equitable_share":94039000.0,"national_conditional_grants":58708000.0},"SCHD":{"national_conditional_grants":48408000.0},"TRFR":{"national_conditional_grants":26227000.0}},"2022":{"ACT":{"national_conditional_grants":17429294.0},"ORGB":{"equitable_share":98572000.0,"national_conditional_grants":45035000.0},"SCHD":{"national_conditional_grants":43235000.0},"TRFR":{"national_conditional_grants":42736000.0}},"2023":{"ACT":{"national_conditional_grants":45756816.0},"ORGB":{"equitable_share":111170000.0,"provincial_transfers":14206000.0,"national_conditional_grants":59609000.0},"SCHD":{"national_conditional_grants":47955000.0},"TRFR":{"national_conditional_grants":47479000.0}},"2024":{"ACT":{"national_conditional_grants":78703537.0},"ORGB":{"equitable_share":122358000.0,"national_conditional_grants":94797000.0},"SCHD":{"national_conditional_grants":82049000.0},"TRFR":{"national_conditional_grants":81634000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":7185764.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":94039000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":98572000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":111170000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":122358000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":3491000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":10659000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":56000.0,"grant.code":"0007","grant.label":"Housing and Local Government","amount_type.code":"ORGB","financial_year_end.year":2023}]},"national_conditional_grants":{"2021":[{"amount.sum":417000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":417000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":379278.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1550000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1550000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":3900115.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":7486656.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":24887000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":14892000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":300000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":5000000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":4931996.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":15000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":9054000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":360035.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1254000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":314000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021}],"2022":[{"amount.sum":677713.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":1550000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1550000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":9571921.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":24460000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":24460000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1000000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":501000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":585217.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":10000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":10000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":972710.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":1118000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1118000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":5621733.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":5107000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":5107000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":1615166.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1721000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1721000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":10018402.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":10000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":10000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":27797691.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":29714000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":29714000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":476000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":5274556.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":5000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":5000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1051001.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1044000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1044000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":2600000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":2600000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1021921.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1771000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1771000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":40514192.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":40000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":40000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":24199499.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":24202000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":24202000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":415000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":8391972.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":8397000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":8397000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1245420.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1264000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1264000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":3330533.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":3400000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":3400000.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":130192996.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":175532830.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":53909001.0,"cube_version":"v2"},{"date":2021,"rating":"bad","result":-1394872897.0,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"}]},"result_type":"R"},"cash_coverage":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"ave","result":1.5,"cube_version":"v2"},{"date":2023,"rating":"ave","result":2.3,"cube_version":"v2"},{"date":2022,"rating":"bad","result":0.8,"cube_version":"v2"},{"date":2021,"rating":"bad","result":0,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end / Operating Expenditure per month","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"},"/","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"/","12",")"]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end / Operating Expenditure per month","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"},"/","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"/","12",")"]},"result_type":"months"},"current_ratio":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"year":2024,"assets":291934408.0,"rating":"ave","result":1.08,"amount_type":"AUDA","liabilities":270917457.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":220544751.0,"rating":"bad","result":0.99,"amount_type":"AUDA","liabilities":222608669.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":263098627.0,"rating":"ave","result":1.4,"amount_type":"AUDA","liabilities":187797225.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":276498553.0,"rating":"ave","result":1.2,"amount_type":"AUDA","liabilities":231370288.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":22545664.0,"date":"2024","year":2024,"rating":"bad","result":0.08,"amount_type":"ACT","liabilities":270917457.0,"cube_version":"v2","call_investment_deposits":0},{"cash":20357709.0,"date":"2023","year":2023,"rating":"bad","result":0.09,"amount_type":"ACT","liabilities":222608669.0,"cube_version":"v2","call_investment_deposits":0},{"cash":43174272.0,"date":"2022","year":2022,"rating":"bad","result":0.23,"amount_type":"ACT","liabilities":187797225.0,"cube_version":"v2","call_investment_deposits":0},{"cash":42330358.0,"date":"2021","year":2021,"rating":"bad","result":0.18,"amount_type":"ACT","liabilities":231370288.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":984515897.0,"percent":87.13},"total":1129967600.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":145451703.0,"percent":12.87}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":19.92,"cube_version":"v2"},{"date":2023,"rating":"bad","result":14.56,"cube_version":"v2"},{"date":2022,"rating":"bad","result":10.55,"cube_version":"v2"},{"date":2021,"rating":"bad","result":8.14,"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":-24094697.0,"comparison":"Original to adjusted budget","percent_changed":-19.66},{"item":"Fines","amount":-13804048.0,"comparison":"Original budget to audited outcome","percent_changed":-11.26},{"item":"Government Transfers","amount":31641541.0,"comparison":"Original to adjusted budget","percent_changed":19.61},{"item":"Government Transfers","amount":16566442.0,"comparison":"Original budget to audited outcome","percent_changed":10.27},{"item":"Interest and investments","amount":-2572827.0,"comparison":"Original to adjusted budget","percent_changed":-12.21},{"item":"Interest and investments","amount":-2967797.0,"comparison":"Original budget to audited outcome","percent_changed":-14.08},{"item":"Licenses and Permits","amount":-251575.0,"comparison":"Original to adjusted budget","percent_changed":-14.4},{"item":"Licenses and Permits","amount":-156430.0,"comparison":"Original budget to audited outcome","percent_changed":-8.95},{"item":"Other","amount":-6573269.0,"comparison":"Original to adjusted budget","percent_changed":-30.98},{"item":"Other","amount":-2256709.0,"comparison":"Original budget to audited outcome","percent_changed":-10.64},{"item":"Property rates","amount":-6638166.0,"comparison":"Original to adjusted budget","percent_changed":-2.81},{"item":"Property rates","amount":-8723647.0,"comparison":"Original budget to audited outcome","percent_changed":-3.69},{"item":"Rental income","amount":-63825.0,"comparison":"Original to adjusted budget","percent_changed":-1.11},{"item":"Rental income","amount":27885.0,"comparison":"Original budget to audited outcome","percent_changed":0.49},{"item":"Service Charges","amount":-41793084.0,"comparison":"Original to adjusted budget","percent_changed":-9.59},{"item":"Service Charges","amount":-37488445.0,"comparison":"Original budget to audited outcome","percent_changed":-8.6}],"2022":[{"item":"Fines","amount":12105212.0,"comparison":"Original to adjusted budget","percent_changed":13.08},{"item":"Fines","amount":-92354759.0,"comparison":"Original budget to audited outcome","percent_changed":-99.79},{"item":"Government Transfers","amount":18036407.0,"comparison":"Original to adjusted budget","percent_changed":11.93},{"item":"Government Transfers","amount":-5760433.0,"comparison":"Original budget to audited outcome","percent_changed":-3.81},{"item":"Interest and investments","amount":1244686.0,"comparison":"Original to adjusted budget","percent_changed":6.25},{"item":"Interest and investments","amount":1523467.0,"comparison":"Original budget to audited outcome","percent_changed":7.65},{"item":"Licenses and Permits","amount":40225.0,"comparison":"Original to adjusted budget","percent_changed":2.55},{"item":"Licenses and Permits","amount":-114508.0,"comparison":"Original budget to audited outcome","percent_changed":-7.25},{"item":"Other","amount":-790096.0,"comparison":"Original to adjusted budget","percent_changed":-6.09},{"item":"Other","amount":5083034.0,"comparison":"Original budget to audited outcome","percent_changed":39.16},{"item":"Property rates","amount":9347.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-3643548.0,"comparison":"Original budget to audited outcome","percent_changed":-1.46},{"item":"Rental income","amount":-801670.0,"comparison":"Original to adjusted budget","percent_changed":-13.48},{"item":"Rental income","amount":-1280994.0,"comparison":"Original budget to audited outcome","percent_changed":-21.54},{"item":"Service Charges","amount":12646589.0,"comparison":"Original to adjusted budget","percent_changed":2.88},{"item":"Service Charges","amount":412130.0,"comparison":"Original budget to audited outcome","percent_changed":0.09}],"2023":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":-29994937.0,"comparison":"Original budget to audited outcome","percent_changed":-25.19},{"item":"Government Transfers","amount":-19046092.0,"comparison":"Original to adjusted budget","percent_changed":-12.29},{"item":"Government Transfers","amount":1927421.0,"comparison":"Original budget to audited outcome","percent_changed":1.24},{"item":"Interest and investments","amount":8480706.0,"comparison":"Original to adjusted budget","percent_changed":39.69},{"item":"Interest and investments","amount":10662834.0,"comparison":"Original budget to audited outcome","percent_changed":49.9},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-249161.0,"comparison":"Original budget to audited outcome","percent_changed":-14.67},{"item":"Other","amount":51906728.0,"comparison":"Original to adjusted budget","percent_changed":434.66},{"item":"Other","amount":8457884.0,"comparison":"Original budget to audited outcome","percent_changed":70.83},{"item":"Property rates","amount":-3032330.0,"comparison":"Original to adjusted budget","percent_changed":-1.16},{"item":"Property rates","amount":-3124817.0,"comparison":"Original budget to audited outcome","percent_changed":-1.19},{"item":"Rental income","amount":1144909.0,"comparison":"Original to adjusted budget","percent_changed":21.03},{"item":"Rental income","amount":442061.0,"comparison":"Original budget to audited outcome","percent_changed":8.12},{"item":"Service Charges","amount":-20400073.0,"comparison":"Original to adjusted budget","percent_changed":-4.2},{"item":"Service Charges","amount":-40074990.0,"comparison":"Original budget to audited outcome","percent_changed":-8.25}],"2024":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":-23102795.0,"comparison":"Original budget to audited outcome","percent_changed":-23.31},{"item":"Government Transfers","amount":1081167.0,"comparison":"Original to adjusted budget","percent_changed":0.72},{"item":"Government Transfers","amount":-4787688.0,"comparison":"Original budget to audited outcome","percent_changed":-3.19},{"item":"Interest and investments","amount":11165213.0,"comparison":"Original to adjusted budget","percent_changed":50.05},{"item":"Interest and investments","amount":17473592.0,"comparison":"Original budget to audited outcome","percent_changed":78.32},{"item":"Licenses and Permits","amount":50869.0,"comparison":"Original to adjusted budget","percent_changed":2.84},{"item":"Licenses and Permits","amount":-254159.0,"comparison":"Original budget to audited outcome","percent_changed":-14.21},{"item":"Other","amount":-181669.0,"comparison":"Original to adjusted budget","percent_changed":-0.36},{"item":"Other","amount":-8766952.0,"comparison":"Original budget to audited outcome","percent_changed":-17.56},{"item":"Property rates","amount":9688899.0,"comparison":"Original to adjusted budget","percent_changed":3.18},{"item":"Property rates","amount":7309156.0,"comparison":"Original budget to audited outcome","percent_changed":2.4},{"item":"Rental income","amount":474879.0,"comparison":"Original to adjusted budget","percent_changed":6.84},{"item":"Rental income","amount":-1070.0,"comparison":"Original budget to audited outcome","percent_changed":-0.02},{"item":"Service Charges","amount":-18144284.0,"comparison":"Original to adjusted budget","percent_changed":-3.42},{"item":"Service Charges","amount":-22496806.0,"comparison":"Original budget to audited outcome","percent_changed":-4.24}]},"income_time_series":[{"amount":955227895.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":1015317478.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":1081112884.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":1168729396.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":956771048.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":876691167.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":1010105331.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":1129967600.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":1243219784.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":1310603724.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":1357887992.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":1005573797.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":972826778.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":1062059036.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":1164594322.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":1253643989.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":-10032034.0,"comparison":"Original to adjusted budget","percent_changed":-4.86},{"item":"Bulk purchases","amount":-7390007.0,"comparison":"Original budget to audited outcome","percent_changed":-3.58},{"item":"Contracted services","amount":12514114.0,"comparison":"Original to adjusted budget","percent_changed":7.91},{"item":"Contracted services","amount":2648541.0,"comparison":"Original budget to audited outcome","percent_changed":1.67},{"item":"Employee related costs","amount":-11274843.0,"comparison":"Original to adjusted budget","percent_changed":-3.97},{"item":"Employee related costs","amount":-4678145.0,"comparison":"Original budget to audited outcome","percent_changed":-1.65},{"item":"Finance charges","amount":-11009371.0,"comparison":"Original to adjusted budget","percent_changed":-32.34},{"item":"Finance charges","amount":-11729663.0,"comparison":"Original budget to audited outcome","percent_changed":-34.46},{"item":"Other","amount":-63116064.0,"comparison":"Original to adjusted budget","percent_changed":-18.84},{"item":"Other","amount":-57385657.0,"comparison":"Original budget to audited outcome","percent_changed":-17.13},{"item":"Remuneration of councillors","amount":-58346.0,"comparison":"Original to adjusted budget","percent_changed":-0.58},{"item":"Remuneration of councillors","amount":-1242075.0,"comparison":"Original budget to audited outcome","percent_changed":-12.39},{"item":"Transfers and subsidies","amount":-1288608.0,"comparison":"Original to adjusted budget","percent_changed":-15.32},{"item":"Transfers and subsidies","amount":-2421195.0,"comparison":"Original budget to audited outcome","percent_changed":-28.79}],"2022":[{"item":"Bulk purchases","amount":14372332.0,"comparison":"Original to adjusted budget","percent_changed":6.27},{"item":"Bulk purchases","amount":-10344537.0,"comparison":"Original budget to audited outcome","percent_changed":-4.52},{"item":"Contracted services","amount":35229336.0,"comparison":"Original to adjusted budget","percent_changed":26.45},{"item":"Contracted services","amount":8759684.0,"comparison":"Original budget to audited outcome","percent_changed":6.58},{"item":"Employee related costs","amount":5498004.0,"comparison":"Original to adjusted budget","percent_changed":1.89},{"item":"Employee related costs","amount":-16722702.0,"comparison":"Original budget to audited outcome","percent_changed":-5.76},{"item":"Finance charges","amount":-2490376.0,"comparison":"Original to adjusted budget","percent_changed":-9.33},{"item":"Finance charges","amount":-3395444.0,"comparison":"Original budget to audited outcome","percent_changed":-12.72},{"item":"Other","amount":17799520.0,"comparison":"Original to adjusted budget","percent_changed":6.42},{"item":"Other","amount":-128744354.0,"comparison":"Original budget to audited outcome","percent_changed":-46.41},{"item":"Remuneration of councillors","amount":-1052086.0,"comparison":"Original to adjusted budget","percent_changed":-10.14},{"item":"Remuneration of councillors","amount":-1345825.0,"comparison":"Original budget to audited outcome","percent_changed":-12.97},{"item":"Transfers and subsidies","amount":-723697.0,"comparison":"Original to adjusted budget","percent_changed":-14.84},{"item":"Transfers and subsidies","amount":-3333768.0,"comparison":"Original budget to audited outcome","percent_changed":-68.36}],"2023":[{"item":"Bulk purchases","amount":-5651000.0,"comparison":"Original to adjusted budget","percent_changed":-2.16},{"item":"Bulk purchases","amount":-53452242.0,"comparison":"Original budget to audited outcome","percent_changed":-20.39},{"item":"Contracted services","amount":23360886.0,"comparison":"Original to adjusted budget","percent_changed":14.02},{"item":"Contracted services","amount":1124865.0,"comparison":"Original budget to audited outcome","percent_changed":0.68},{"item":"Employee related costs","amount":-10135401.0,"comparison":"Original to adjusted budget","percent_changed":-3.38},{"item":"Employee related costs","amount":-11987450.0,"comparison":"Original budget to audited outcome","percent_changed":-4.0},{"item":"Finance charges","amount":-500001.0,"comparison":"Original to adjusted budget","percent_changed":-1.73},{"item":"Finance charges","amount":-418509.0,"comparison":"Original budget to audited outcome","percent_changed":-1.45},{"item":"Other","amount":10258120.0,"comparison":"Original to adjusted budget","percent_changed":3.51},{"item":"Other","amount":-79538372.0,"comparison":"Original budget to audited outcome","percent_changed":-27.22},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":37951.0,"comparison":"Original budget to audited outcome","percent_changed":0.39},{"item":"Transfers and subsidies","amount":228618.0,"comparison":"Original to adjusted budget","percent_changed":11.93},{"item":"Transfers and subsidies","amount":-247554.0,"comparison":"Original budget to audited outcome","percent_changed":-12.92}],"2024":[{"item":"Bulk purchases","amount":-10692186.0,"comparison":"Original to adjusted budget","percent_changed":-3.65},{"item":"Bulk purchases","amount":-41696065.0,"comparison":"Original budget to audited outcome","percent_changed":-14.22},{"item":"Contracted services","amount":-24243486.0,"comparison":"Original to adjusted budget","percent_changed":-13.08},{"item":"Contracted services","amount":-41385946.0,"comparison":"Original budget to audited outcome","percent_changed":-22.32},{"item":"Employee related costs","amount":7781315.0,"comparison":"Original to adjusted budget","percent_changed":2.55},{"item":"Employee related costs","amount":-4239396.0,"comparison":"Original budget to audited outcome","percent_changed":-1.39},{"item":"Finance charges","amount":5716306.0,"comparison":"Original to adjusted budget","percent_changed":17.95},{"item":"Finance charges","amount":7047949.0,"comparison":"Original budget to audited outcome","percent_changed":22.13},{"item":"Other","amount":31982323.0,"comparison":"Original to adjusted budget","percent_changed":9.75},{"item":"Other","amount":-65762454.0,"comparison":"Original budget to audited outcome","percent_changed":-20.04},{"item":"Remuneration of councillors","amount":372477.0,"comparison":"Original to adjusted budget","percent_changed":3.69},{"item":"Remuneration of councillors","amount":-260479.0,"comparison":"Original budget to audited outcome","percent_changed":-2.58},{"item":"Transfers and subsidies","amount":689140.0,"comparison":"Original to adjusted budget","percent_changed":47.28},{"item":"Transfers and subsidies","amount":-339200.0,"comparison":"Original budget to audited outcome","percent_changed":-23.27}]},"spending_time_series":[{"amount":951811215.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":1040737708.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":1078836221.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":1167404247.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":953878166.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":816977729.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":916793688.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":1009162767.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":1059764674.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":1268262885.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":1308137975.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":1036076367.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":972104675.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":1061274999.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":1155798358.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":1228728808.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":-30.48,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"bad","result":-24.18,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"bad","result":-20.14,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"bad","result":-56.44,"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":311562851.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":507563894.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":6937073.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":39783546.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":75987224.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":1534135.0,"amount_type":"AUDA"},{"date":"2024","item":"Agency services","amount":3988270.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":37158904.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":29.86},{"date":2023,"rating":"","result":31.4},{"date":2022,"rating":"","result":33.51},{"date":2021,"rating":"","result":29.26}],"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":-13.6,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"ave","result":-15.0,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"bad","result":-21.5,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"good","result":0.2,"overunder":"over","cube_version":"v2"}],"formula":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"-",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","/",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"-",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","*","100"]},"result_type":"%"},"repairs_maintenance_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":3.13,"cube_version":"v2"},{"date":2023,"rating":"bad","result":3.68,"cube_version":"v2"},{"date":2022,"rating":"bad","result":3.23,"cube_version":"v2"},{"date":2021,"rating":"bad","result":3.25,"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":14.27},{"date":2023,"rating":"","result":18.29},{"date":2022,"rating":"","result":17.38},{"date":2021,"rating":"","result":16.86}],"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":71.52,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"bad","result":74.75,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"bad","result":72.39,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"bad","result":65.22,"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":181401645.0},{"year":2022,"value":83744171.0},{"year":2023,"value":89830629.0},{"year":2024,"value":94875411.0},{"year":2025,"value":105000197.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":257591122.0},{"year":2022,"value":277908889.0},{"year":2023,"value":290650090.0},{"year":2024,"value":333344960.0},{"year":2025,"value":381171064.0}],"category":"Electricity "},{"values":[{"year":2021,"value":4873928.0},{"year":2022,"value":4431797.0},{"year":2023,"value":6118660.0},{"year":2024,"value":4506990.0},{"year":2025,"value":4022802.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":191591477.0},{"year":2022,"value":193174360.0},{"year":2023,"value":212141978.0},{"year":2024,"value":230839715.0},{"year":2025,"value":243464170.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":70647790.0},{"year":2022,"value":41534524.0},{"year":2023,"value":47985264.0},{"year":2024,"value":42492296.0},{"year":2025,"value":38670356.0}],"category":"Housing"},{"values":[{"year":2021,"value":33407945.0},{"year":2022,"value":29220236.0},{"year":2023,"value":32816860.0},{"year":2024,"value":45845828.0},{"year":2025,"value":39009349.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":20984226.0},{"year":2022,"value":20896554.0},{"year":2023,"value":24140187.0},{"year":2024,"value":22327394.0},{"year":2025,"value":23398889.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":53663486.0},{"year":2022,"value":45683020.0},{"year":2023,"value":46212616.0},{"year":2024,"value":54322925.0},{"year":2025,"value":65775913.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":75065192.0},{"year":2022,"value":59191021.0},{"year":2023,"value":75385087.0},{"year":2024,"value":81913954.0},{"year":2025,"value":72903323.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":64651355.0},{"year":2022,"value":61193157.0},{"year":2023,"value":91512317.0},{"year":2024,"value":98693294.0},{"year":2025,"value":86348611.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":"WC048"},"muni_contact":{"url":"http://www.knysna.gov.za","phone_number":"044 302 6300","street_address_1":"Council Offices","street_address_2":"C/O Clyde & Queen Streets","street_address_3":"Knysna","street_address_4":"6571"},"mayoral_staff":{"officials":[{"name":"Mr Thando Matika (ANC)","role":"Mayor/Executive Mayor","email":"tmatika@knysna.gov.za","title":"Mr","secretary":{"name":"Kirsty Hofhuis","role":"Secretary of Mayor/Executive Mayor","email":"khofhuis@knysna.gov.za","title":"Ms","fax_number":"044 302 6333","office_phone":"044 302 6355"},"fax_number":"044 302 6333","office_phone":"044 302 6465"},{"name":"Lulamile Mapholoba","role":"Municipal Manager","email":"lmapholoba@knysna.gov.za","title":"Dr","secretary":{"name":"Anita Strydom","role":"Secretary of Municipal Manager","email":"astrydom@knysna.gov.za","title":"Ms","fax_number":"044 302 6333","office_phone":"044 302 6590"},"fax_number":" ","office_phone":"044 302 6590"},{"name":"Mr Morton Gericke(PBI)","role":"Deputy Mayor/Executive Mayor","email":"mgericke@knysna.gov.za","title":"Mr","secretary":{"name":"Buziwe Mjamba","role":"Secretary of Deputy Mayor/Executive Mayor","email":"bmjamba@knysna.gov.za","title":"Ms","fax_number":"044 302 6333","office_phone":"044 302 6386"},"fax_number":"044 302 6333","office_phone":"044 302 6461"},{"name":"Mr Clifford Julies","role":"Chief Financial Officer","email":"cfo@knysna.gov.za","title":"Mr","secretary":{"name":"Jenny Visagie","role":"Secretary of Financial Manager","email":"jvisagie@knysna.gov.za","title":"Ms","fax_number":"044 302 6333","office_phone":"044 302 6463"},"fax_number":"044 302 6333","office_phone":"044 302 6463"}],"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/WC048/WC048_Audit%20Report_2024_Y_20241202T124032Z_nbarnard.pdf"},{"date":2023,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/WC048/WC048_Audit%20Report_2023_Y_20231204T102132Z_mvanwyk.pdf"},{"date":2022,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/WC048/WC048_Audit%20Report_2022_Y_20221206T081933Z_mvanwyk.pdf"},{"date":2021,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/WC048/WC048_Audit%20Report_2021_Y_20220217T055238Z_5039.pdf"}]}}