{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":18726473.0,"national_conditional_grants":4591377.0},"ORGB":{"equitable_share":103419000.0,"national_conditional_grants":47618000.0},"SCHD":{"national_conditional_grants":43744000.0},"TRFR":{"national_conditional_grants":10475000.0}},"2022":{"ACT":{"national_conditional_grants":14270565.0},"ORGB":{"equitable_share":106976000.0,"national_conditional_grants":62282000.0},"SCHD":{"national_conditional_grants":53282000.0},"TRFR":{"national_conditional_grants":43093000.0}},"2023":{"ACT":{"national_conditional_grants":21405527.0},"ORGB":{"equitable_share":120101000.0,"provincial_transfers":17181000.0,"national_conditional_grants":40129000.0},"SCHD":{"national_conditional_grants":56691000.0},"TRFR":{"national_conditional_grants":47695000.0}},"2024":{"ACT":{"national_conditional_grants":28295931.0},"ORGB":{"equitable_share":131583000.0,"national_conditional_grants":50876000.0},"SCHD":{"national_conditional_grants":96244000.0},"TRFR":{"national_conditional_grants":82160000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":18726473.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":103419000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":106976000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":120101000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":131583000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":6250000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":4000.0,"grant.code":"0005","grant.label":"Agriculture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":9815000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":112000.0,"grant.code":"0007","grant.label":"Housing and Local Government","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":1000000.0,"grant.code":"0009","grant.label":"Other Departments","amount_type.code":"ORGB","financial_year_end.year":2023}]},"national_conditional_grants":{"2021":[{"amount.sum":238000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":238000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":3600000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":307090.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1700000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1700000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":5000000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1500000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1104012.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":5000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1500000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":2610911.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":26275000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":4054000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":569364.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1931000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":483000.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":863040.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":4500000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":4500000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1098450.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":1650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":10189000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":219576.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":7120000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":7120000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":9770980.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":25602000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":25602000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1138074.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":1721000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1721000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1180445.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":2500000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":2500000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":11940000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":11940000.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":-67329.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":-3453932.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":-27486.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":6674000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":-2116144.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":2239925.0,"grant.code":"MEHG","grant.label":"Municipal Emergency Housing Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":4622000.0,"grant.code":"MEHG","grant.label":"Municipal Emergency Housing Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":2300000.0,"grant.code":"MEHG","grant.label":"Municipal Emergency Housing Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":26125754.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":29728000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":29728000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":787929.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":2077000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":2077000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":-2083190.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023}],"2024":[{"amount.sum":465901.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":41304000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":41304000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":2376240.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":4000000.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":4000000.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":1386218.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":14084000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":17297270.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":23842000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":23842000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1459322.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1684000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1684000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":5310980.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":9630000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":9630000.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":534484523.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":437868977.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":359893639.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":45344693.0,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"}]},"result_type":"R"},"cash_coverage":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"good","result":7.1,"cube_version":"v2"},{"date":2023,"rating":"good","result":6.5,"cube_version":"v2"},{"date":2022,"rating":"good","result":7.0,"cube_version":"v2"},{"date":2021,"rating":"bad","result":1.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":129696441.0,"rating":"bad","result":0.39,"amount_type":"AUDA","liabilities":331407873.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":181053769.0,"rating":"bad","result":0.9,"amount_type":"AUDA","liabilities":201087125.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":244825833.0,"rating":"good","result":1.87,"amount_type":"AUDA","liabilities":130788643.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":240273016.0,"rating":"good","result":1.94,"amount_type":"AUDA","liabilities":123652167.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":31009444.0,"date":"2024","year":2024,"rating":"bad","result":0.09,"amount_type":"ACT","liabilities":331407873.0,"cube_version":"v2","call_investment_deposits":0},{"cash":85916361.0,"date":"2023","year":2023,"rating":"bad","result":0.43,"amount_type":"ACT","liabilities":201087125.0,"cube_version":"v2","call_investment_deposits":0},{"cash":165982868.0,"date":"2022","year":2022,"rating":"good","result":1.27,"amount_type":"ACT","liabilities":130788643.0,"cube_version":"v2","call_investment_deposits":0},{"cash":164089992.0,"date":"2021","year":2021,"rating":"good","result":1.33,"amount_type":"ACT","liabilities":123652167.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":554603659.0,"percent":78.28},"total":708475583.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":153871924.0,"percent":21.72}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":34.74,"cube_version":"v2"},{"date":2023,"rating":"bad","result":37.41,"cube_version":"v2"},{"date":2022,"rating":"bad","result":0.32,"cube_version":"v2"},{"date":2021,"rating":"bad","result":0.81,"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":-32547440.0,"comparison":"Original to adjusted budget","percent_changed":-88.42},{"item":"Fines","amount":-22880762.0,"comparison":"Original budget to audited outcome","percent_changed":-62.16},{"item":"Government Transfers","amount":25931307.0,"comparison":"Original to adjusted budget","percent_changed":18.47},{"item":"Government Transfers","amount":-1027957.0,"comparison":"Original budget to audited outcome","percent_changed":-0.73},{"item":"Interest and investments","amount":-9400000.0,"comparison":"Original to adjusted budget","percent_changed":-29.19},{"item":"Interest and investments","amount":-11783969.0,"comparison":"Original budget to audited outcome","percent_changed":-36.6},{"item":"Licenses and Permits","amount":-4000.0,"comparison":"Original to adjusted budget","percent_changed":-6.2},{"item":"Licenses and Permits","amount":44098.0,"comparison":"Original budget to audited outcome","percent_changed":68.37},{"item":"Other","amount":559627.0,"comparison":"Original to adjusted budget","percent_changed":3.97},{"item":"Other","amount":-650020.0,"comparison":"Original budget to audited outcome","percent_changed":-4.61},{"item":"Property rates","amount":-826000.0,"comparison":"Original to adjusted budget","percent_changed":-0.71},{"item":"Property rates","amount":4217515.0,"comparison":"Original budget to audited outcome","percent_changed":3.61},{"item":"Rental income","amount":-140000.0,"comparison":"Original to adjusted budget","percent_changed":-6.51},{"item":"Rental income","amount":-90806.0,"comparison":"Original budget to audited outcome","percent_changed":-4.22},{"item":"Service Charges","amount":-10557006.0,"comparison":"Original to adjusted budget","percent_changed":-4.22},{"item":"Service Charges","amount":3149391.0,"comparison":"Original budget to audited outcome","percent_changed":1.26}],"2022":[{"item":"Fines","amount":9463682.0,"comparison":"Original to adjusted budget","percent_changed":60.44},{"item":"Fines","amount":10963550.0,"comparison":"Original budget to audited outcome","percent_changed":70.02},{"item":"Government Transfers","amount":785324.0,"comparison":"Original to adjusted budget","percent_changed":0.55},{"item":"Government Transfers","amount":-14678290.0,"comparison":"Original budget to audited outcome","percent_changed":-10.27},{"item":"Interest and investments","amount":-9872000.0,"comparison":"Original to adjusted budget","percent_changed":-29.49},{"item":"Interest and investments","amount":-6022942.0,"comparison":"Original budget to audited outcome","percent_changed":-17.99},{"item":"Licenses and Permits","amount":-46370.0,"comparison":"Original to adjusted budget","percent_changed":-67.82},{"item":"Licenses and Permits","amount":-32579.0,"comparison":"Original budget to audited outcome","percent_changed":-47.65},{"item":"Other","amount":1388557.0,"comparison":"Original to adjusted budget","percent_changed":8.54},{"item":"Other","amount":6652050.0,"comparison":"Original budget to audited outcome","percent_changed":40.89},{"item":"Property rates","amount":1450645.0,"comparison":"Original to adjusted budget","percent_changed":1.16},{"item":"Property rates","amount":3130883.0,"comparison":"Original budget to audited outcome","percent_changed":2.51},{"item":"Rental income","amount":-213934.0,"comparison":"Original to adjusted budget","percent_changed":-9.38},{"item":"Rental income","amount":-114894.0,"comparison":"Original budget to audited outcome","percent_changed":-5.04},{"item":"Service Charges","amount":-5094684.0,"comparison":"Original to adjusted budget","percent_changed":-1.84},{"item":"Service Charges","amount":-9517846.0,"comparison":"Original budget to audited outcome","percent_changed":-3.43}],"2023":[{"item":"Fines","amount":22751314.0,"comparison":"Original to adjusted budget","percent_changed":148.17},{"item":"Fines","amount":20314855.0,"comparison":"Original budget to audited outcome","percent_changed":132.3},{"item":"Government Transfers","amount":14036529.0,"comparison":"Original to adjusted budget","percent_changed":9.61},{"item":"Government Transfers","amount":-1173174.0,"comparison":"Original budget to audited outcome","percent_changed":-0.8},{"item":"Interest and investments","amount":273000.0,"comparison":"Original to adjusted budget","percent_changed":0.84},{"item":"Interest and investments","amount":2259800.0,"comparison":"Original budget to audited outcome","percent_changed":6.92},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-18958.0,"comparison":"Original budget to audited outcome","percent_changed":-81.3},{"item":"Other","amount":-258457.0,"comparison":"Original to adjusted budget","percent_changed":-0.94},{"item":"Other","amount":9103982.0,"comparison":"Original budget to audited outcome","percent_changed":33.08},{"item":"Property rates","amount":933275.0,"comparison":"Original to adjusted budget","percent_changed":0.67},{"item":"Property rates","amount":-2023048.0,"comparison":"Original budget to audited outcome","percent_changed":-1.46},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":-335711.0,"comparison":"Original budget to audited outcome","percent_changed":-15.33},{"item":"Service Charges","amount":-13968383.0,"comparison":"Original to adjusted budget","percent_changed":-4.8},{"item":"Service Charges","amount":-16939320.0,"comparison":"Original budget to audited outcome","percent_changed":-5.83}],"2024":[{"item":"Fines","amount":-9722000.0,"comparison":"Original to adjusted budget","percent_changed":-25.51},{"item":"Fines","amount":-17321003.0,"comparison":"Original budget to audited outcome","percent_changed":-45.44},{"item":"Government Transfers","amount":10818999.0,"comparison":"Original to adjusted budget","percent_changed":6.71},{"item":"Government Transfers","amount":-7442738.0,"comparison":"Original budget to audited outcome","percent_changed":-4.61},{"item":"Interest and investments","amount":4293300.0,"comparison":"Original to adjusted budget","percent_changed":12.24},{"item":"Interest and investments","amount":968047.0,"comparison":"Original budget to audited outcome","percent_changed":2.76},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-21743.0,"comparison":"Original budget to audited outcome","percent_changed":-93.48},{"item":"Other","amount":-12768343.0,"comparison":"Original to adjusted budget","percent_changed":-30.15},{"item":"Other","amount":-4117911.0,"comparison":"Original budget to audited outcome","percent_changed":-9.72},{"item":"Property rates","amount":-4568742.0,"comparison":"Original to adjusted budget","percent_changed":-2.89},{"item":"Property rates","amount":-4400036.0,"comparison":"Original budget to audited outcome","percent_changed":-2.78},{"item":"Rental income","amount":-591100.0,"comparison":"Original to adjusted budget","percent_changed":-25.61},{"item":"Rental income","amount":-1730052.0,"comparison":"Original budget to audited outcome","percent_changed":-74.95},{"item":"Service Charges","amount":4565975.0,"comparison":"Original to adjusted budget","percent_changed":1.51},{"item":"Service Charges","amount":2199269.0,"comparison":"Original budget to audited outcome","percent_changed":0.73}]},"income_time_series":[{"amount":566010240.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":610285818.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":676678319.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":732369839.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":563971242.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":602804530.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":664099467.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":708475583.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":752602157.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":826515247.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":876797645.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":592993752.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":612424598.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":652911041.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":740341750.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":787656993.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":-1939361.0,"comparison":"Original to adjusted budget","percent_changed":-2.56},{"item":"Bulk purchases","amount":-315093.0,"comparison":"Original budget to audited outcome","percent_changed":-0.42},{"item":"Contracted services","amount":6339373.0,"comparison":"Original to adjusted budget","percent_changed":12.5},{"item":"Contracted services","amount":-7244473.0,"comparison":"Original budget to audited outcome","percent_changed":-14.28},{"item":"Employee related costs","amount":-2572827.0,"comparison":"Original to adjusted budget","percent_changed":-1.05},{"item":"Employee related costs","amount":-19296125.0,"comparison":"Original budget to audited outcome","percent_changed":-7.91},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":1357005.0,"comparison":"Original budget to audited outcome","percent_changed":8.75},{"item":"Other","amount":-19450534.0,"comparison":"Original to adjusted budget","percent_changed":-9.09},{"item":"Other","amount":-38081722.0,"comparison":"Original budget to audited outcome","percent_changed":-17.8},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-1420282.0,"comparison":"Original budget to audited outcome","percent_changed":-10.47},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Transfers and subsidies","amount":889472.0,"comparison":"Original budget to audited outcome","percent_changed":444.74}],"2022":[{"item":"Bulk purchases","amount":-860000.0,"comparison":"Original to adjusted budget","percent_changed":-0.99},{"item":"Bulk purchases","amount":-978488.0,"comparison":"Original budget to audited outcome","percent_changed":-1.12},{"item":"Contracted services","amount":-4215496.0,"comparison":"Original to adjusted budget","percent_changed":-7.97},{"item":"Contracted services","amount":-7159491.0,"comparison":"Original budget to audited outcome","percent_changed":-13.53},{"item":"Employee related costs","amount":-12434241.0,"comparison":"Original to adjusted budget","percent_changed":-4.89},{"item":"Employee related costs","amount":-15468207.0,"comparison":"Original budget to audited outcome","percent_changed":-6.09},{"item":"Finance charges","amount":4844284.0,"comparison":"Original to adjusted budget","percent_changed":31.24},{"item":"Finance charges","amount":4504825.0,"comparison":"Original budget to audited outcome","percent_changed":29.05},{"item":"Other","amount":34071598.0,"comparison":"Original to adjusted budget","percent_changed":18.63},{"item":"Other","amount":26389295.0,"comparison":"Original budget to audited outcome","percent_changed":14.43},{"item":"Remuneration of councillors","amount":-1429492.0,"comparison":"Original to adjusted budget","percent_changed":-10.32},{"item":"Remuneration of councillors","amount":-1949750.0,"comparison":"Original budget to audited outcome","percent_changed":-14.08},{"item":"Transfers and subsidies","amount":-1715774.0,"comparison":"Original to adjusted budget","percent_changed":-10.46},{"item":"Transfers and subsidies","amount":-14632961.0,"comparison":"Original budget to audited outcome","percent_changed":-89.23}],"2023":[{"item":"Bulk purchases","amount":-158513.0,"comparison":"Original to adjusted budget","percent_changed":-0.16},{"item":"Bulk purchases","amount":-8331384.0,"comparison":"Original budget to audited outcome","percent_changed":-8.67},{"item":"Contracted services","amount":-1305021.0,"comparison":"Original to adjusted budget","percent_changed":-2.27},{"item":"Contracted services","amount":65205340.0,"comparison":"Original budget to audited outcome","percent_changed":113.43},{"item":"Employee related costs","amount":-23886873.0,"comparison":"Original to adjusted budget","percent_changed":-8.68},{"item":"Employee related costs","amount":-28065694.0,"comparison":"Original budget to audited outcome","percent_changed":-10.2},{"item":"Finance charges","amount":-3313448.0,"comparison":"Original to adjusted budget","percent_changed":-13.15},{"item":"Finance charges","amount":7289436.0,"comparison":"Original budget to audited outcome","percent_changed":28.94},{"item":"Other","amount":38914522.0,"comparison":"Original to adjusted budget","percent_changed":19.91},{"item":"Other","amount":98706219.0,"comparison":"Original budget to audited outcome","percent_changed":50.5},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-870681.0,"comparison":"Original budget to audited outcome","percent_changed":-6.42},{"item":"Transfers and subsidies","amount":12946551.0,"comparison":"Original to adjusted budget","percent_changed":148.21},{"item":"Transfers and subsidies","amount":-207419.0,"comparison":"Original budget to audited outcome","percent_changed":-2.37}],"2024":[{"item":"Bulk purchases","amount":18467339.0,"comparison":"Original to adjusted budget","percent_changed":21.98},{"item":"Bulk purchases","amount":17016445.0,"comparison":"Original budget to audited outcome","percent_changed":20.26},{"item":"Contracted services","amount":15840053.0,"comparison":"Original to adjusted budget","percent_changed":17.04},{"item":"Contracted services","amount":48956843.0,"comparison":"Original budget to audited outcome","percent_changed":52.67},{"item":"Employee related costs","amount":1791315.0,"comparison":"Original to adjusted budget","percent_changed":0.62},{"item":"Employee related costs","amount":-15881839.0,"comparison":"Original budget to audited outcome","percent_changed":-5.45},{"item":"Finance charges","amount":17015984.0,"comparison":"Original to adjusted budget","percent_changed":59.43},{"item":"Finance charges","amount":13069506.0,"comparison":"Original budget to audited outcome","percent_changed":45.65},{"item":"Other","amount":77429561.0,"comparison":"Original to adjusted budget","percent_changed":32.02},{"item":"Other","amount":80125089.0,"comparison":"Original budget to audited outcome","percent_changed":33.13},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-798385.0,"comparison":"Original budget to audited outcome","percent_changed":-5.71},{"item":"Transfers and subsidies","amount":826568.0,"comparison":"Original to adjusted budget","percent_changed":8.18},{"item":"Transfers and subsidies","amount":-8154250.0,"comparison":"Original budget to audited outcome","percent_changed":-80.69}]},"spending_time_series":[{"amount":596112884.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":641239266.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":694799406.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":894133664.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":549625015.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":613683610.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":805328005.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":897096253.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":797487759.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":822301613.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":864230040.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":613736233.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":622978387.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":671602188.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":762762844.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":787444506.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":-42.07,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"bad","result":-46.98,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"bad","result":-36.48,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"bad","result":-59.22,"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":153615706.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":305339926.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":578336.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":36039747.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":20794953.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":1517.0,"amount_type":"AUDA"},{"date":"2024","item":"Agency services","amount":7938120.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":30295354.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":30.7},{"date":2023,"rating":"","result":30.67},{"date":2022,"rating":"","result":38.9},{"date":2021,"rating":"","result":40.86}],"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.3,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"bad","result":15.9,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"good","result":-4.3,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"ave","result":-7.8,"overunder":"under","cube_version":"v2"}],"formula":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"-",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","/",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"-",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","*","100"]},"result_type":"%"},"repairs_maintenance_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"good","result":13.2,"cube_version":"v2"},{"date":2023,"rating":"good","result":10.76,"cube_version":"v2"},{"date":2022,"rating":"good","result":10.92,"cube_version":"v2"},{"date":2021,"rating":"good","result":10.76,"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":15.82},{"date":2023,"rating":"","result":15.24},{"date":2022,"rating":"","result":7.46},{"date":2021,"rating":"","result":7.91}],"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":89.78,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"bad","result":84.65,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"bad","result":85.92,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"bad","result":null,"billing":null,"receipts":null,"cube_version":null}],"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":43636032.0},{"year":2022,"value":53556671.0},{"year":2023,"value":67471766.0},{"year":2024,"value":60155981.0},{"year":2025,"value":63974505.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":95215106.0},{"year":2022,"value":110461562.0},{"year":2023,"value":115261439.0},{"year":2024,"value":125739950.0},{"year":2025,"value":153602450.0}],"category":"Electricity "},{"values":[{"year":2021,"value":115514.0},{"year":2022,"value":6820.0},{"year":2024,"value":33992.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":186379348.0},{"year":2022,"value":214426211.0},{"year":2023,"value":233077143.0},{"year":2024,"value":355305624.0},{"year":2025,"value":275321828.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":10678004.0},{"year":2022,"value":9377676.0},{"year":2023,"value":22878944.0},{"year":2024,"value":16928139.0},{"year":2025,"value":21414251.0}],"category":"Housing"},{"values":[{"year":2021,"value":29766.0},{"year":2022,"value":197325.0},{"year":2023,"value":170298.0},{"year":2024,"value":552662.0},{"year":2025,"value":67673.0}],"category":"Other"},{"values":[{"year":2021,"value":39636231.0},{"year":2022,"value":40405684.0},{"year":2023,"value":43228703.0},{"year":2024,"value":61515948.0},{"year":2025,"value":45027120.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":10036131.0},{"year":2022,"value":9756801.0},{"year":2023,"value":15184821.0},{"year":2024,"value":15292004.0},{"year":2025,"value":10328788.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":56586146.0},{"year":2022,"value":60677421.0},{"year":2023,"value":65076408.0},{"year":2024,"value":66510443.0},{"year":2025,"value":73910653.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":46157463.0},{"year":2022,"value":47659078.0},{"year":2023,"value":50530180.0},{"year":2024,"value":66273638.0},{"year":2025,"value":64615762.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":61155274.0},{"year":2022,"value":67158361.0},{"year":2023,"value":192448303.0},{"year":2024,"value":128787872.0},{"year":2025,"value":89224729.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":"WC031"},"muni_contact":{"url":"http://www.twk.gov.za","phone_number":"028 214 3300","street_address_1":" ","street_address_2":"6 Plein Street","street_address_3":"Caledon","street_address_4":"7230"},"mayoral_staff":{"officials":[{"name":"Lincoln de Bruyn","role":"Mayor/Executive Mayor","email":"mayor@twk.gov.za","title":"Mr","secretary":{"name":"Celeste Kellis","role":"Secretary of Mayor/Executive Mayor","email":"celesteke@twk.gov.za","title":"Ms","fax_number":"028 214 1289","office_phone":"028 214 3318"},"fax_number":"028 214 1289","office_phone":"028 214 3300"},{"name":"Walter Hendricks","role":"Municipal Manager","email":"mm@twk.gov.za","title":"Mr","secretary":{"name":"Annette Swart","role":"Secretary of Municipal Manager","email":"annettesw@twk.gov.za","title":"Mrs","fax_number":"028 214 1289","office_phone":"028 214 3363"},"fax_number":"028 214 1289","office_phone":"028 214 3300"},{"name":"Cynthia Clayton","role":"Deputy Mayor/Executive Mayor","email":"cclayton@twk.gov.za","title":"Ms","secretary":{"name":"Jane Arendse","role":"Secretary of Deputy Mayor/Executive Mayor","email":"janear@twk.gov.za","title":"Ms","fax_number":" ","office_phone":" "},"fax_number":" ","office_phone":" "},{"name":"Paul Mabhena","role":"Chief Financial Officer","email":"paulma@twk.gov.za","title":"Mr","secretary":{"name":"Tarin Holworthy","role":"Secretary of Financial Manager","email":"tarinho@twk.gov.za","title":"Ms","fax_number":"028 214 1289","office_phone":"028 214 3453"},"fax_number":" ","office_phone":"028 214 3300"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/WC031/WC031_Audit%20Report_2024_Y_20250220T100055Z_agathaho.pdf"},{"date":2023,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/WC031/WC031_Audit%20Report_2023_Y_20231207T155828Z_carishajo.pdf"},{"date":2022,"rating":"unqualified","result":"Unqualified - No findings","report_url":"https://lg.treasury.gov.za/supportingdocs/WC031/WC031_Audit%20Report_2022_Y_20221205T155910Z_carishajo.pdf"},{"date":2021,"rating":"unqualified","result":"Unqualified - No findings","report_url":"https://lg.treasury.gov.za/supportingdocs/WC031/WC031_Audit%20Report_2021_Y_20220207T121617Z_5039.pdf"}]}}