{"indicators":{"grants":{"totals":{"2021":{"ACT":{"national_conditional_grants":19404052.0},"ORGB":{"equitable_share":164466000.0,"national_conditional_grants":119969000.0},"SCHD":{"national_conditional_grants":99669000.0},"TRFR":{"national_conditional_grants":25651000.0}},"2022":{"ACT":{"national_conditional_grants":38023302.0},"ORGB":{"equitable_share":171259000.0,"national_conditional_grants":83353000.0},"SCHD":{"national_conditional_grants":84703000.0},"TRFR":{"national_conditional_grants":84953000.0}},"2023":{"ACT":{"national_conditional_grants":81890528.0},"ORGB":{"equitable_share":194355000.0,"provincial_transfers":41171000.0,"national_conditional_grants":77778000.0},"SCHD":{"national_conditional_grants":83678000.0},"TRFR":{"national_conditional_grants":83678000.0}},"2024":{"ACT":{"national_conditional_grants":381615384.0},"ORGB":{"equitable_share":215718000.0,"national_conditional_grants":405839000.0},"SCHD":{"national_conditional_grants":388674000.0},"TRFR":{"national_conditional_grants":388674000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":164466000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":171259000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":194355000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":215718000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":19448000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":19954000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":1169000.0,"grant.code":"0007","grant.label":"Housing and Local Government","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":600000.0,"grant.code":"0009","grant.label":"Other Departments","amount_type.code":"ORGB","financial_year_end.year":2023}]},"national_conditional_grants":{"2021":[{"amount.sum":477000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":477000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":269397.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":17000000.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":5000000.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":7149722.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":17000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":5000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":58649000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":12600000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development 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":600000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":877663.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":4093000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1024000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":11107270.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021}],"2022":[{"amount.sum":3307507.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":2999017.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":4000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":4000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":929752.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":4187256.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":18315000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":18315000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":23312771.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":52256000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":52256000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":-1.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":1200000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1450000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":3287000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":3287000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":3287000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":4095000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":4095000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":1213922.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1550000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1550000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":16000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":16000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":16000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":60537605.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":61989000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":61989000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":4139000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":4139000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":4139000.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":197873.0,"grant.code":"DRCG","grant.label":"Municipal Disaster Recovery Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":435000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":435000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1441474.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1550000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1550000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":9999999.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":10000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":10000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":58540788.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":58616000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":58616000.0,"grant.code":"IUDG","grant.label":"Integrated Urban Development Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":2668576.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":10000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":10000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":4363000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":4363000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":4363000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":291160134.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":290310000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":290310000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":13243540.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":13400000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":13400000.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":1196917341.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":4326454632.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":1614179796.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":1402773085.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":4.8,"cube_version":"v2"},{"date":2023,"rating":"good","result":18.8,"cube_version":"v2"},{"date":2022,"rating":"good","result":7.4,"cube_version":"v2"},{"date":2021,"rating":"good","result":6.8,"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":1250373385.0,"rating":"good","result":2.18,"amount_type":"AUDA","liabilities":572495810.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":909830552.0,"rating":"good","result":2.02,"amount_type":"AUDA","liabilities":451079836.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":710668907.0,"rating":"ave","result":1.21,"amount_type":"AUDA","liabilities":586309512.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":557897958.0,"rating":"bad","result":0.81,"amount_type":"AUDA","liabilities":692867899.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":697505824.0,"date":"2024","year":2024,"rating":"good","result":1.22,"amount_type":"ACT","liabilities":572495810.0,"cube_version":"v2","call_investment_deposits":0},{"cash":445270434.0,"date":"2023","year":2023,"rating":"bad","result":0.99,"amount_type":"ACT","liabilities":451079836.0,"cube_version":"v2","call_investment_deposits":0},{"cash":229883612.0,"date":"2022","year":2022,"rating":"bad","result":0.39,"amount_type":"ACT","liabilities":586309512.0,"cube_version":"v2","call_investment_deposits":0},{"cash":138741650.0,"date":"2021","year":2021,"rating":"bad","result":0.2,"amount_type":"ACT","liabilities":692867899.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":2884492311.0,"percent":92.56},"total":3116282587.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":231790276.0,"percent":7.44}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":5.78,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0.07,"cube_version":"v2"},{"date":2022,"rating":"bad","result":1.04,"cube_version":"v2"},{"date":2021,"rating":"bad","result":0.13,"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":57777931.0,"comparison":"Original to adjusted budget","percent_changed":72.32},{"item":"Fines","amount":48707408.0,"comparison":"Original budget to audited outcome","percent_changed":60.96},{"item":"Government Transfers","amount":-36720119.0,"comparison":"Original to adjusted budget","percent_changed":-13.85},{"item":"Government Transfers","amount":-31816711.0,"comparison":"Original budget to audited outcome","percent_changed":-12.0},{"item":"Interest and investments","amount":-2125410.0,"comparison":"Original to adjusted budget","percent_changed":-13.01},{"item":"Interest and investments","amount":-2971672.0,"comparison":"Original budget to audited outcome","percent_changed":-18.19},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-729119.0,"comparison":"Original budget to audited outcome","percent_changed":-21.76},{"item":"Other","amount":1988500.0,"comparison":"Original to adjusted budget","percent_changed":4.62},{"item":"Other","amount":4608378.0,"comparison":"Original budget to audited outcome","percent_changed":10.7},{"item":"Property rates","amount":11440601.0,"comparison":"Original to adjusted budget","percent_changed":3.45},{"item":"Property rates","amount":12174652.0,"comparison":"Original budget to audited outcome","percent_changed":3.67},{"item":"Rental income","amount":-9730584.0,"comparison":"Original to adjusted budget","percent_changed":-62.51},{"item":"Rental income","amount":-10375559.0,"comparison":"Original budget to audited outcome","percent_changed":-66.66},{"item":"Service Charges","amount":-24629990.0,"comparison":"Original to adjusted budget","percent_changed":-1.47},{"item":"Service Charges","amount":-49248004.0,"comparison":"Original budget to audited outcome","percent_changed":-2.94}],"2022":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":24599651.0,"comparison":"Original budget to audited outcome","percent_changed":30.51},{"item":"Government Transfers","amount":10605392.0,"comparison":"Original to adjusted budget","percent_changed":5.28},{"item":"Government Transfers","amount":3310706.0,"comparison":"Original budget to audited outcome","percent_changed":1.65},{"item":"Interest and investments","amount":-31198.0,"comparison":"Original to adjusted budget","percent_changed":-0.22},{"item":"Interest and investments","amount":3901426.0,"comparison":"Original budget to audited outcome","percent_changed":27.45},{"item":"Licenses and Permits","amount":280800.0,"comparison":"Original to adjusted budget","percent_changed":8.74},{"item":"Licenses and Permits","amount":356966.0,"comparison":"Original budget to audited outcome","percent_changed":11.11},{"item":"Other","amount":17478665.0,"comparison":"Original to adjusted budget","percent_changed":28.98},{"item":"Other","amount":9964568.0,"comparison":"Original budget to audited outcome","percent_changed":16.52},{"item":"Property rates","amount":12138030.0,"comparison":"Original to adjusted budget","percent_changed":3.01},{"item":"Property rates","amount":13042892.0,"comparison":"Original budget to audited outcome","percent_changed":3.23},{"item":"Rental income","amount":-286052.0,"comparison":"Original to adjusted budget","percent_changed":-5.48},{"item":"Rental income","amount":27247.0,"comparison":"Original budget to audited outcome","percent_changed":0.52},{"item":"Service Charges","amount":-28202108.0,"comparison":"Original to adjusted budget","percent_changed":-1.53},{"item":"Service Charges","amount":-14134399.0,"comparison":"Original budget to audited outcome","percent_changed":-0.77}],"2023":[{"item":"Fines","amount":12758730.0,"comparison":"Original to adjusted budget","percent_changed":11.88},{"item":"Fines","amount":-2903257.0,"comparison":"Original budget to audited outcome","percent_changed":-2.7},{"item":"Government Transfers","amount":-17787810.0,"comparison":"Original to adjusted budget","percent_changed":-7.05},{"item":"Government Transfers","amount":-45445969.0,"comparison":"Original budget to audited outcome","percent_changed":-18.01},{"item":"Interest and investments","amount":13534674.0,"comparison":"Original to adjusted budget","percent_changed":92.71},{"item":"Interest and investments","amount":37345977.0,"comparison":"Original budget to audited outcome","percent_changed":255.82},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-19470.0,"comparison":"Original budget to audited outcome","percent_changed":-0.59},{"item":"Other","amount":-12262621.0,"comparison":"Original to adjusted budget","percent_changed":-18.71},{"item":"Other","amount":31116213.0,"comparison":"Original budget to audited outcome","percent_changed":47.48},{"item":"Property rates","amount":12412412.0,"comparison":"Original to adjusted budget","percent_changed":2.94},{"item":"Property rates","amount":15493796.0,"comparison":"Original budget to audited outcome","percent_changed":3.67},{"item":"Rental income","amount":-983382.0,"comparison":"Original to adjusted budget","percent_changed":-19.33},{"item":"Rental income","amount":1993121.0,"comparison":"Original budget to audited outcome","percent_changed":39.17},{"item":"Service Charges","amount":-50410631.0,"comparison":"Original to adjusted budget","percent_changed":-2.56},{"item":"Service Charges","amount":-93382626.0,"comparison":"Original budget to audited outcome","percent_changed":-4.75}],"2024":[{"item":"Fines","amount":149000.0,"comparison":"Original to adjusted budget","percent_changed":0.12},{"item":"Fines","amount":-22820603.0,"comparison":"Original budget to audited outcome","percent_changed":-19.0},{"item":"Government Transfers","amount":-25996775.0,"comparison":"Original to adjusted budget","percent_changed":-9.33},{"item":"Government Transfers","amount":-46931724.0,"comparison":"Original budget to audited outcome","percent_changed":-16.84},{"item":"Interest and investments","amount":41833001.0,"comparison":"Original to adjusted budget","percent_changed":90.21},{"item":"Interest and investments","amount":49847263.0,"comparison":"Original budget to audited outcome","percent_changed":107.49},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":66849.0,"comparison":"Original budget to audited outcome","percent_changed":1.94},{"item":"Other","amount":40412255.0,"comparison":"Original to adjusted budget","percent_changed":99.58},{"item":"Other","amount":75487134.0,"comparison":"Original budget to audited outcome","percent_changed":186.01},{"item":"Property rates","amount":5908672.0,"comparison":"Original to adjusted budget","percent_changed":1.3},{"item":"Property rates","amount":11032979.0,"comparison":"Original budget to audited outcome","percent_changed":2.42},{"item":"Rental income","amount":385898.0,"comparison":"Original to adjusted budget","percent_changed":6.9},{"item":"Rental income","amount":2716294.0,"comparison":"Original budget to audited outcome","percent_changed":48.54},{"item":"Service Charges","amount":38881917.0,"comparison":"Original to adjusted budget","percent_changed":1.9},{"item":"Service Charges","amount":54502655.0,"comparison":"Original budget to audited outcome","percent_changed":2.67}]},"income_time_series":[{"amount":2429221127.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":2620781404.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":2793827174.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":3093955708.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":2401569571.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":2649866932.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":2780763587.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":3116282587.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":3530736835.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":3644901339.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":3907914220.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":2431220198.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":2608797875.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":2836565802.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":2992381740.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":3331200801.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":-10000000.0,"comparison":"Original to adjusted budget","percent_changed":-1.2},{"item":"Bulk purchases","amount":-21727076.0,"comparison":"Original budget to audited outcome","percent_changed":-2.6},{"item":"Contracted services","amount":-62738823.0,"comparison":"Original to adjusted budget","percent_changed":-29.66},{"item":"Contracted services","amount":-68356386.0,"comparison":"Original budget to audited outcome","percent_changed":-32.32},{"item":"Employee related costs","amount":16178229.0,"comparison":"Original to adjusted budget","percent_changed":2.35},{"item":"Employee related costs","amount":23077454.0,"comparison":"Original budget to audited outcome","percent_changed":3.35},{"item":"Finance charges","amount":-2153761.0,"comparison":"Original to adjusted budget","percent_changed":-1.18},{"item":"Finance charges","amount":-2480988.0,"comparison":"Original budget to audited outcome","percent_changed":-1.36},{"item":"Other","amount":74592038.0,"comparison":"Original to adjusted budget","percent_changed":13.41},{"item":"Other","amount":32037086.0,"comparison":"Original budget to audited outcome","percent_changed":5.76},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-608145.0,"comparison":"Original budget to audited outcome","percent_changed":-1.92},{"item":"Transfers and subsidies","amount":1293820.0,"comparison":"Original to adjusted budget","percent_changed":13.68},{"item":"Transfers and subsidies","amount":-925841.0,"comparison":"Original budget to audited outcome","percent_changed":-9.79}],"2022":[{"item":"Bulk purchases","amount":-23645574.0,"comparison":"Original to adjusted budget","percent_changed":-2.43},{"item":"Bulk purchases","amount":-23166021.0,"comparison":"Original budget to audited outcome","percent_changed":-2.38},{"item":"Contracted services","amount":12847669.0,"comparison":"Original to adjusted budget","percent_changed":8.42},{"item":"Contracted services","amount":-9902376.0,"comparison":"Original budget to audited outcome","percent_changed":-6.49},{"item":"Employee related costs","amount":3223357.0,"comparison":"Original to adjusted budget","percent_changed":0.43},{"item":"Employee related costs","amount":-23144444.0,"comparison":"Original budget to audited outcome","percent_changed":-3.11},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":-154700.0,"comparison":"Original budget to audited outcome","percent_changed":-0.09},{"item":"Other","amount":22664685.0,"comparison":"Original to adjusted budget","percent_changed":4.05},{"item":"Other","amount":24760770.0,"comparison":"Original budget to audited outcome","percent_changed":4.42},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-1986314.0,"comparison":"Original budget to audited outcome","percent_changed":-5.9},{"item":"Transfers and subsidies","amount":-1563448.0,"comparison":"Original to adjusted budget","percent_changed":-8.63},{"item":"Transfers and subsidies","amount":-2773846.0,"comparison":"Original budget to audited outcome","percent_changed":-15.31}],"2023":[{"item":"Bulk purchases","amount":-36400000.0,"comparison":"Original to adjusted budget","percent_changed":-3.53},{"item":"Bulk purchases","amount":-101027522.0,"comparison":"Original budget to audited outcome","percent_changed":-9.8},{"item":"Contracted services","amount":-14289394.0,"comparison":"Original to adjusted budget","percent_changed":-6.81},{"item":"Contracted services","amount":-41395714.0,"comparison":"Original budget to audited outcome","percent_changed":-19.72},{"item":"Employee related costs","amount":5107388.0,"comparison":"Original to adjusted budget","percent_changed":0.64},{"item":"Employee related costs","amount":-43701420.0,"comparison":"Original budget to audited outcome","percent_changed":-5.51},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":-130721.0,"comparison":"Original budget to audited outcome","percent_changed":-0.07},{"item":"Other","amount":55646705.0,"comparison":"Original to adjusted budget","percent_changed":9.2},{"item":"Other","amount":70108946.0,"comparison":"Original budget to audited outcome","percent_changed":11.6},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-2041832.0,"comparison":"Original budget to audited outcome","percent_changed":-5.79},{"item":"Transfers and subsidies","amount":-1938322.0,"comparison":"Original to adjusted budget","percent_changed":-7.14},{"item":"Transfers and subsidies","amount":-2252571.0,"comparison":"Original budget to audited outcome","percent_changed":-8.29}],"2024":[{"item":"Bulk purchases","amount":34674320.0,"comparison":"Original to adjusted budget","percent_changed":3.14},{"item":"Bulk purchases","amount":6945321.0,"comparison":"Original budget to audited outcome","percent_changed":0.63},{"item":"Contracted services","amount":4261628.0,"comparison":"Original to adjusted budget","percent_changed":1.84},{"item":"Contracted services","amount":-27344890.0,"comparison":"Original budget to audited outcome","percent_changed":-11.81},{"item":"Employee related costs","amount":-9365039.0,"comparison":"Original to adjusted budget","percent_changed":-1.12},{"item":"Employee related costs","amount":-32495513.0,"comparison":"Original budget to audited outcome","percent_changed":-3.9},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":661300.0,"comparison":"Original budget to audited outcome","percent_changed":0.4},{"item":"Other","amount":38337681.0,"comparison":"Original to adjusted budget","percent_changed":5.7},{"item":"Other","amount":-14658761.0,"comparison":"Original budget to audited outcome","percent_changed":-2.18},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-2818673.0,"comparison":"Original budget to audited outcome","percent_changed":-7.59},{"item":"Transfers and subsidies","amount":-2837792.0,"comparison":"Original to adjusted budget","percent_changed":-15.55},{"item":"Transfers and subsidies","amount":-3394446.0,"comparison":"Original budget to audited outcome","percent_changed":-18.6}]},"spending_time_series":[{"amount":2532355924.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":2674095050.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":2886129606.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":3130031059.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":2476200525.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":2624201430.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":2757562395.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":2991854599.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":3285100588.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":3609249350.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":3894434068.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":2515184421.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":2660568361.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":2878003229.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":3064960261.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":3328778915.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":"good","result":-1.62,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"good","result":-2.63,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"ave","result":-7.49,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"ave","result":-7.28,"overunder":"under","cube_version":"v2"}],"formula":{"text":"= ((Actual Capital Expenditure - Budgeted Capital Expenditure) / Budgeted Capital Expenditure) * 100","actual":["=","(","(",{"cube":"capital","item_codes":["4100"],"amount_type":"AUDA"},"-",{"cube":"capital","item_codes":["4100"],"amount_type":"ADJB"},")","/",{"cube":"capital","item_codes":["4100"],"amount_type":"ADJB"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= ((Actual Capital Expenditure - Budgeted Capital Expenditure) / Budgeted Capital Expenditure) * 100","actual":["=","(","(",{"cube":"capital_v2","amount_type":"AUDA","item_description":"capital type code NEW, RENEWAL, UPGRADING"},"-",{"cube":"capital_v2","amount_type":"ADJB","item_description":"capital type code NEW, RENEWAL, UPGRADING"},")","/",{"cube":"capital_v2","amount_type":"ADJB","item_description":"capital type code NEW, RENEWAL, UPGRADING"},")","*","100"]},"result_type":"%"},"local_revenue_breakdown":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"date":"2024","item":"Property rates","amount":466404866.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":2096677275.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":8312161.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":96222048.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":97292325.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":3514151.0,"amount_type":"AUDA"},{"date":"2024","item":"Agency services","amount":17652143.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":98417342.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":26.8},{"date":2023,"rating":"","result":27.2},{"date":2022,"rating":"","result":27.45},{"date":2021,"rating":"","result":28.72}],"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":-4.4,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"good","result":-4.5,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"good","result":-1.9,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"good","result":-2.2,"overunder":"under","cube_version":"v2"}],"formula":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"-",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","/",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"-",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","*","100"]},"result_type":"%"},"repairs_maintenance_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":4.62,"cube_version":"v2"},{"date":2023,"rating":"bad","result":4.22,"cube_version":"v2"},{"date":2022,"rating":"bad","result":4.07,"cube_version":"v2"},{"date":2021,"rating":"bad","result":4.02,"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":6.82},{"date":2023,"rating":"","result":6.11},{"date":2022,"rating":"","result":5.43},{"date":2021,"rating":"","result":5.78}],"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.66,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"bad","result":91.15,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"good","result":110.67,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"bad","result":45.39,"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":262028835.0},{"year":2022,"value":245980811.0},{"year":2023,"value":239525355.0},{"year":2024,"value":259771796.0},{"year":2025,"value":275188555.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":1041990078.0},{"year":2022,"value":1174108267.0},{"year":2023,"value":1159701603.0},{"year":2024,"value":1351303169.0},{"year":2025,"value":1558459628.0}],"category":"Electricity "},{"values":[{"year":2021,"value":1658762.0},{"year":2022,"value":1691433.0},{"year":2023,"value":1770721.0},{"year":2024,"value":1874882.0},{"year":2025,"value":2012695.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":556287356.0},{"year":2022,"value":567332740.0},{"year":2023,"value":637959952.0},{"year":2024,"value":656859944.0},{"year":2025,"value":685474651.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":85877528.0},{"year":2022,"value":78240885.0},{"year":2023,"value":77217497.0},{"year":2024,"value":75547045.0},{"year":2025,"value":76879470.0}],"category":"Housing"},{"values":[{"year":2021,"value":132405648.0},{"year":2022,"value":148429929.0},{"year":2023,"value":163396248.0},{"year":2024,"value":142063267.0},{"year":2025,"value":161589402.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":63086712.0},{"year":2022,"value":65697137.0},{"year":2023,"value":64328683.0},{"year":2024,"value":66165984.0},{"year":2025,"value":75273992.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":89342195.0},{"year":2022,"value":87857566.0},{"year":2023,"value":126928512.0},{"year":2024,"value":127715146.0},{"year":2025,"value":126208008.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":129168640.0},{"year":2022,"value":135615612.0},{"year":2023,"value":154252034.0},{"year":2024,"value":142443575.0},{"year":2025,"value":160206956.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":114354771.0},{"year":2022,"value":119247050.0},{"year":2023,"value":132481790.0},{"year":2024,"value":168109791.0},{"year":2025,"value":163807231.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":"WC023"},"muni_contact":{"url":"http://www.drakenstein.gov.za","phone_number":"021 807 4500","street_address_1":"Civic Centre","street_address_2":"Bergriver Boulevard","street_address_3":"Paarl","street_address_4":"7646"},"mayoral_staff":{"officials":[{"name":"Mr Stephen Korabie (DA)","role":"Mayor/Executive Mayor","email":"mayor@drakenstein.gov.za","title":"Mr","secretary":{"name":"Suene Cyster","role":"Secretary of Mayor/Executive Mayor","email":"suene.cyster@drakenstein.gov.za","title":"Mrs","fax_number":"021 872 8054","office_phone":"021 807 4752"},"fax_number":"021 872 8054","office_phone":"021 807 4613"},{"name":"Johan Leibbrandt","role":"Municipal Manager","email":"mm@drakenstein.gov.za","title":"Dr","secretary":{"name":"Melany Brown","role":"Secretary of Municipal Manager","email":"melany@drakenstein.gov.za","title":"Mrs","fax_number":"021 872 8054","office_phone":"021 807 4615"},"fax_number":"021 872 8054","office_phone":"021 807 4615"},{"name":"Gert Combrink","role":"Deputy Mayor/Executive Mayor","email":"g.combrink@drakenstein.gov.za","title":"Mr","secretary":{"name":"Lamees Cassim","role":"Secretary of Deputy Mayor/Executive Mayor","email":"lamees.cassim@drakenstein.gov.za","title":"Mrs","fax_number":"021 872 8054","office_phone":"021 807 6467"},"fax_number":"021 872 8054","office_phone":"021 807 4627"},{"name":"Bradley Brown","role":"Chief Financial Officer","email":"bradley.brown@drakenstein.gov.za","title":"Mr","secretary":{"name":"Candice Boonzaaier","role":"Secretary of Financial Manager","email":"candice.boonzaaier@drakenstein.gov.za","title":"Mrs","fax_number":"021 872 8054","office_phone":"021 807 4624"},"fax_number":"021 872 8054","office_phone":"021 807 4623"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"unqualified","result":"Unqualified - No findings","report_url":"https://lg.treasury.gov.za/supportingdocs/WC023/WC023_Audit%20Report_2024_Y_20241202T101718Z_kevin_carse.pdf"},{"date":2023,"rating":"unqualified","result":"Unqualified - No findings","report_url":"https://lg.treasury.gov.za/supportingdocs/WC023/WC023_Audit%20Report_2023_Y_20231212T092825Z_kevin_carse.pdf"},{"date":2022,"rating":"unqualified","result":"Unqualified - No findings","report_url":"https://lg.treasury.gov.za/supportingdocs/WC023/WC023_Audit%20Report_2022_Y_20221205T152200Z_kevin_carse.pdf"},{"date":2021,"rating":"unqualified","result":"Unqualified - No findings","report_url":"https://lg.treasury.gov.za/supportingdocs/WC023/WC023_Audit%20Report_2021_Y_20220217T055012Z_5039.pdf"}]}}