{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":6500690.0,"national_conditional_grants":8381267.0},"ORGB":{"equitable_share":102195000.0,"national_conditional_grants":44023000.0},"SCHD":{"national_conditional_grants":39623000.0},"TRFR":{"national_conditional_grants":24030000.0}},"2022":{"ACT":{"national_conditional_grants":25458515.0},"ORGB":{"equitable_share":108796000.0,"national_conditional_grants":38069000.0},"SCHD":{"national_conditional_grants":42069000.0},"TRFR":{"national_conditional_grants":38038000.0}},"2023":{"ACT":{"national_conditional_grants":37468180.0},"ORGB":{"equitable_share":126228000.0,"provincial_transfers":27339000.0,"national_conditional_grants":72479000.0},"SCHD":{"national_conditional_grants":72479000.0},"TRFR":{"national_conditional_grants":54833000.0}},"2024":{"ACT":{"national_conditional_grants":49121370.0},"ORGB":{"equitable_share":143235000.0,"national_conditional_grants":56914000.0},"SCHD":{"national_conditional_grants":50950000.0},"TRFR":{"national_conditional_grants":50443000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":6500690.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":102195000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":108796000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":126228000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":143235000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":7799000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":3000.0,"grant.code":"0005","grant.label":"Agriculture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":11623000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":294000.0,"grant.code":"0007","grant.label":"Housing and Local Government","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":7620000.0,"grant.code":"0009","grant.label":"Other Departments","amount_type.code":"ORGB","financial_year_end.year":2023}]},"national_conditional_grants":{"2021":[{"amount.sum":119000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":119000.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":1600000.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":485943.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":5652000.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":2995000.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":699773.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":5652000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":2995000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":7195551.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":21183000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":14304000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1867000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":467000.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":868527.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":4031000.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":456988.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":8355000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":8355000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":22301000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":26301000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":26301000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1832000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":1832000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1832000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":892814.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":17646000.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":9330271.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":17600000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":17600000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":25372095.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":33810000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":33810000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1873000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1873000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1873000.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":350000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":350000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1392848.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":507000.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":23658001.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":23658000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":23658000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":22507039.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":23055000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":23055000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1563482.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1830000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1830000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","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":1174730765.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":1522940324.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":805404715.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":1076100809.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":13.7,"cube_version":"v2"},{"date":2023,"rating":"good","result":19.6,"cube_version":"v2"},{"date":2022,"rating":"good","result":10.6,"cube_version":"v2"},{"date":2021,"rating":"good","result":16.5,"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":665537772.0,"rating":"good","result":5.36,"amount_type":"AUDA","liabilities":124051852.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":861366649.0,"rating":"good","result":7.06,"amount_type":"AUDA","liabilities":121940543.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":794751257.0,"rating":"good","result":6.02,"amount_type":"AUDA","liabilities":132066763.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":751362716.0,"rating":"good","result":7.58,"amount_type":"AUDA","liabilities":99162444.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":470491304.0,"date":"2024","year":2024,"rating":"good","result":3.79,"amount_type":"ACT","liabilities":124051852.0,"cube_version":"v2","call_investment_deposits":0},{"cash":722016830.0,"date":"2023","year":2023,"rating":"good","result":5.92,"amount_type":"ACT","liabilities":121940543.0,"cube_version":"v2","call_investment_deposits":0},{"cash":665090950.0,"date":"2022","year":2022,"rating":"good","result":5.04,"amount_type":"ACT","liabilities":132066763.0,"cube_version":"v2","call_investment_deposits":0},{"cash":640203998.0,"date":"2021","year":2021,"rating":"good","result":6.46,"amount_type":"ACT","liabilities":99162444.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":1007381330.0,"percent":85.44},"total":1179043597.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":171662267.0,"percent":14.56}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":1.35,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0.64,"cube_version":"v2"},{"date":2022,"rating":"bad","result":1.28,"cube_version":"v2"},{"date":2021,"rating":"bad","result":3.67,"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":-10542900.0,"comparison":"Original to adjusted budget","percent_changed":-31.92},{"item":"Fines","amount":-4628205.0,"comparison":"Original budget to audited outcome","percent_changed":-14.01},{"item":"Government Transfers","amount":18850202.0,"comparison":"Original to adjusted budget","percent_changed":15.64},{"item":"Government Transfers","amount":17572451.0,"comparison":"Original budget to audited outcome","percent_changed":14.58},{"item":"Interest and investments","amount":814430.0,"comparison":"Original to adjusted budget","percent_changed":2.31},{"item":"Interest and investments","amount":3837975.0,"comparison":"Original budget to audited outcome","percent_changed":10.87},{"item":"Licenses and Permits","amount":550000.0,"comparison":"Original to adjusted budget","percent_changed":14.63},{"item":"Licenses and Permits","amount":868118.0,"comparison":"Original budget to audited outcome","percent_changed":23.09},{"item":"Other","amount":3577098.0,"comparison":"Original to adjusted budget","percent_changed":21.16},{"item":"Other","amount":16583791.0,"comparison":"Original budget to audited outcome","percent_changed":98.1},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":4264066.0,"comparison":"Original budget to audited outcome","percent_changed":3.31},{"item":"Rental income","amount":416300.0,"comparison":"Original to adjusted budget","percent_changed":27.84},{"item":"Rental income","amount":162454.0,"comparison":"Original budget to audited outcome","percent_changed":10.86},{"item":"Service Charges","amount":5295850.0,"comparison":"Original to adjusted budget","percent_changed":1.19},{"item":"Service Charges","amount":24203900.0,"comparison":"Original budget to audited outcome","percent_changed":5.45}],"2022":[{"item":"Fines","amount":9080000.0,"comparison":"Original to adjusted budget","percent_changed":38.49},{"item":"Fines","amount":4273195.0,"comparison":"Original budget to audited outcome","percent_changed":18.11},{"item":"Government Transfers","amount":8307625.0,"comparison":"Original to adjusted budget","percent_changed":5.45},{"item":"Government Transfers","amount":20949800.0,"comparison":"Original budget to audited outcome","percent_changed":13.73},{"item":"Interest and investments","amount":446506.0,"comparison":"Original to adjusted budget","percent_changed":1.11},{"item":"Interest and investments","amount":-2171301.0,"comparison":"Original budget to audited outcome","percent_changed":-5.39},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":241661.0,"comparison":"Original budget to audited outcome","percent_changed":5.44},{"item":"Other","amount":33262962.0,"comparison":"Original to adjusted budget","percent_changed":119.81},{"item":"Other","amount":10195422.0,"comparison":"Original budget to audited outcome","percent_changed":36.72},{"item":"Property rates","amount":1945906.0,"comparison":"Original to adjusted budget","percent_changed":1.41},{"item":"Property rates","amount":3100007.0,"comparison":"Original budget to audited outcome","percent_changed":2.24},{"item":"Rental income","amount":99244.0,"comparison":"Original to adjusted budget","percent_changed":6.49},{"item":"Rental income","amount":-106412.0,"comparison":"Original budget to audited outcome","percent_changed":-6.96},{"item":"Service Charges","amount":-12053277.0,"comparison":"Original to adjusted budget","percent_changed":-2.32},{"item":"Service Charges","amount":2718059.0,"comparison":"Original budget to audited outcome","percent_changed":0.52}],"2023":[{"item":"Fines","amount":-4344000.0,"comparison":"Original to adjusted budget","percent_changed":-12.55},{"item":"Fines","amount":85587.0,"comparison":"Original budget to audited outcome","percent_changed":0.25},{"item":"Government Transfers","amount":3497901.0,"comparison":"Original to adjusted budget","percent_changed":1.88},{"item":"Government Transfers","amount":-12381151.0,"comparison":"Original budget to audited outcome","percent_changed":-6.65},{"item":"Interest and investments","amount":19790803.0,"comparison":"Original to adjusted budget","percent_changed":50.58},{"item":"Interest and investments","amount":23863039.0,"comparison":"Original budget to audited outcome","percent_changed":60.99},{"item":"Licenses and Permits","amount":124129.0,"comparison":"Original to adjusted budget","percent_changed":2.6},{"item":"Licenses and Permits","amount":309880.0,"comparison":"Original budget to audited outcome","percent_changed":6.49},{"item":"Other","amount":-5327257.0,"comparison":"Original to adjusted budget","percent_changed":-10.0},{"item":"Other","amount":-10093197.0,"comparison":"Original budget to audited outcome","percent_changed":-18.94},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":3892730.0,"comparison":"Original budget to audited outcome","percent_changed":2.63},{"item":"Rental income","amount":179830.0,"comparison":"Original to adjusted budget","percent_changed":11.05},{"item":"Rental income","amount":-37057.0,"comparison":"Original budget to audited outcome","percent_changed":-2.28},{"item":"Service Charges","amount":-11669298.0,"comparison":"Original to adjusted budget","percent_changed":-2.13},{"item":"Service Charges","amount":-25891303.0,"comparison":"Original budget to audited outcome","percent_changed":-4.72}],"2024":[{"item":"Fines","amount":7430394.0,"comparison":"Original to adjusted budget","percent_changed":23.16},{"item":"Fines","amount":6505685.0,"comparison":"Original budget to audited outcome","percent_changed":20.28},{"item":"Government Transfers","amount":4061394.0,"comparison":"Original to adjusted budget","percent_changed":2.42},{"item":"Government Transfers","amount":3626395.0,"comparison":"Original budget to audited outcome","percent_changed":2.16},{"item":"Interest and investments","amount":28058825.0,"comparison":"Original to adjusted budget","percent_changed":47.04},{"item":"Interest and investments","amount":30352843.0,"comparison":"Original budget to audited outcome","percent_changed":50.88},{"item":"Licenses and Permits","amount":35895.0,"comparison":"Original to adjusted budget","percent_changed":0.7},{"item":"Licenses and Permits","amount":-78567.0,"comparison":"Original budget to audited outcome","percent_changed":-1.52},{"item":"Other","amount":27740617.0,"comparison":"Original to adjusted budget","percent_changed":51.89},{"item":"Other","amount":25037805.0,"comparison":"Original budget to audited outcome","percent_changed":46.83},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-4655390.0,"comparison":"Original budget to audited outcome","percent_changed":-2.77},{"item":"Rental income","amount":68000.0,"comparison":"Original to adjusted budget","percent_changed":3.46},{"item":"Rental income","amount":-584142.0,"comparison":"Original budget to audited outcome","percent_changed":-29.7},{"item":"Service Charges","amount":-19979649.0,"comparison":"Original to adjusted budget","percent_changed":-3.35},{"item":"Service Charges","amount":33740730.0,"comparison":"Original budget to audited outcome","percent_changed":5.65}]},"income_time_series":[{"amount":803273255.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":949334592.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":1019127069.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":1132513714.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":847176825.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":947446057.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":996623489.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":1179043597.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":1287878125.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":1437899828.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":1585504278.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":784312275.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":908245626.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":1016874961.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":1085098238.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":1212934619.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":1179935.0,"comparison":"Original budget to audited outcome","percent_changed":0.47},{"item":"Contracted services","amount":2611842.0,"comparison":"Original to adjusted budget","percent_changed":4.54},{"item":"Contracted services","amount":-5987050.0,"comparison":"Original budget to audited outcome","percent_changed":-10.41},{"item":"Employee related costs","amount":1507900.0,"comparison":"Original to adjusted budget","percent_changed":0.63},{"item":"Employee related costs","amount":7665649.0,"comparison":"Original budget to audited outcome","percent_changed":3.2},{"item":"Finance charges","amount":2020927.0,"comparison":"Original to adjusted budget","percent_changed":16.93},{"item":"Finance charges","amount":2020927.0,"comparison":"Original budget to audited outcome","percent_changed":16.93},{"item":"Other","amount":-4534940.0,"comparison":"Original to adjusted budget","percent_changed":-2.03},{"item":"Other","amount":-21500683.0,"comparison":"Original budget to audited outcome","percent_changed":-9.62},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-614760.0,"comparison":"Original budget to audited outcome","percent_changed":-5.36},{"item":"Transfers and subsidies","amount":131936.0,"comparison":"Original to adjusted budget","percent_changed":4.09},{"item":"Transfers and subsidies","amount":-233835.0,"comparison":"Original budget to audited outcome","percent_changed":-7.26}],"2022":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-7095398.0,"comparison":"Original budget to audited outcome","percent_changed":-2.37},{"item":"Contracted services","amount":1992908.0,"comparison":"Original to adjusted budget","percent_changed":2.27},{"item":"Contracted services","amount":6789928.0,"comparison":"Original budget to audited outcome","percent_changed":7.74},{"item":"Employee related costs","amount":4311099.0,"comparison":"Original to adjusted budget","percent_changed":1.65},{"item":"Employee related costs","amount":4985356.0,"comparison":"Original budget to audited outcome","percent_changed":1.91},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":2597409.0,"comparison":"Original budget to audited outcome","percent_changed":19.77},{"item":"Other","amount":35158249.0,"comparison":"Original to adjusted budget","percent_changed":15.84},{"item":"Other","amount":7332592.0,"comparison":"Original budget to audited outcome","percent_changed":3.3},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-302309.0,"comparison":"Original budget to audited outcome","percent_changed":-2.69},{"item":"Transfers and subsidies","amount":40262.0,"comparison":"Original to adjusted budget","percent_changed":1.05},{"item":"Transfers and subsidies","amount":-76164.0,"comparison":"Original budget to audited outcome","percent_changed":-1.98}],"2023":[{"item":"Bulk purchases","amount":-19801556.0,"comparison":"Original to adjusted budget","percent_changed":-5.96},{"item":"Bulk purchases","amount":-42748605.0,"comparison":"Original budget to audited outcome","percent_changed":-12.87},{"item":"Contracted services","amount":4722124.0,"comparison":"Original to adjusted budget","percent_changed":4.49},{"item":"Contracted services","amount":-14262519.0,"comparison":"Original budget to audited outcome","percent_changed":-13.55},{"item":"Employee related costs","amount":4336205.0,"comparison":"Original to adjusted budget","percent_changed":1.47},{"item":"Employee related costs","amount":-2137417.0,"comparison":"Original budget to audited outcome","percent_changed":-0.73},{"item":"Finance charges","amount":3204130.0,"comparison":"Original to adjusted budget","percent_changed":25.92},{"item":"Finance charges","amount":3294526.0,"comparison":"Original budget to audited outcome","percent_changed":26.65},{"item":"Other","amount":3235392.0,"comparison":"Original to adjusted budget","percent_changed":1.2},{"item":"Other","amount":-38812536.0,"comparison":"Original budget to audited outcome","percent_changed":-14.38},{"item":"Remuneration of councillors","amount":308914.0,"comparison":"Original to adjusted budget","percent_changed":2.75},{"item":"Remuneration of councillors","amount":-11427.0,"comparison":"Original budget to audited outcome","percent_changed":-0.1},{"item":"Transfers and subsidies","amount":238927.0,"comparison":"Original to adjusted budget","percent_changed":5.47},{"item":"Transfers and subsidies","amount":-122691.0,"comparison":"Original budget to audited outcome","percent_changed":-2.81}],"2024":[{"item":"Bulk purchases","amount":-22216583.0,"comparison":"Original to adjusted budget","percent_changed":-6.24},{"item":"Bulk purchases","amount":-15765672.0,"comparison":"Original budget to audited outcome","percent_changed":-4.43},{"item":"Contracted services","amount":7224464.0,"comparison":"Original to adjusted budget","percent_changed":10.31},{"item":"Contracted services","amount":1591068.0,"comparison":"Original budget to audited outcome","percent_changed":2.27},{"item":"Employee related costs","amount":1846827.0,"comparison":"Original to adjusted budget","percent_changed":0.58},{"item":"Employee related costs","amount":-685162.0,"comparison":"Original budget to audited outcome","percent_changed":-0.22},{"item":"Finance charges","amount":-1542370.0,"comparison":"Original to adjusted budget","percent_changed":-10.65},{"item":"Finance charges","amount":-2151023.0,"comparison":"Original budget to audited outcome","percent_changed":-14.85},{"item":"Other","amount":14005386.0,"comparison":"Original to adjusted budget","percent_changed":4.71},{"item":"Other","amount":-28111712.0,"comparison":"Original budget to audited outcome","percent_changed":-9.46},{"item":"Remuneration of councillors","amount":338000.0,"comparison":"Original to adjusted budget","percent_changed":2.8},{"item":"Remuneration of councillors","amount":-76481.0,"comparison":"Original budget to audited outcome","percent_changed":-0.63},{"item":"Transfers and subsidies","amount":366420.0,"comparison":"Original to adjusted budget","percent_changed":7.24},{"item":"Transfers and subsidies","amount":-635799.0,"comparison":"Original budget to audited outcome","percent_changed":-12.57}]},"spending_time_series":[{"amount":799656204.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":939555180.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":1025575991.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":1071352206.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":780448722.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":912284076.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":934531186.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":1025495281.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":1109208720.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":1434463773.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":1584420816.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":797918539.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":898052662.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":1029331855.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":1071330062.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":1189045717.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":26.29,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"ave","result":-8.31,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"good","result":2.86,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"ave","result":13.73,"overunder":"over","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":163174545.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":630654582.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":1382483.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":90006738.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":38582078.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":5079409.0,"amount_type":"AUDA"},{"date":"2024","item":"Agency services","amount":5348435.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":73153060.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.79},{"date":2023,"rating":"","result":31.23},{"date":2022,"rating":"","result":29.11},{"date":2021,"rating":"","result":31.65}],"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.3,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"ave","result":-8.9,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"good","result":-2.9,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"good","result":-2.4,"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":2.85,"cube_version":"v2"},{"date":2023,"rating":"bad","result":2.92,"cube_version":"v2"},{"date":2022,"rating":"bad","result":2.63,"cube_version":"v2"},{"date":2021,"rating":"bad","result":2.39,"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.99},{"date":2023,"rating":"","result":9.74},{"date":2022,"rating":"","result":10.37},{"date":2021,"rating":"","result":6.6}],"formula":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp","item_codes":["4200"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp_v2","item_codes":["3800"],"amount_type":"AUDA"}]},"result_type":"%"},"current_debtors_collection_rate":{"ref":{"url":"http://mfma.treasury.gov.za/RegulationsandGazettes/Municipal%20Budget%20and%20Reporting%20Regulations/Pages/default.aspx","title":"Municipal Budget and Reporting Regulations"},"values":[{"date":"2024","year":2024,"rating":"good","result":158.88,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"good","result":202.81,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"good","result":94.75,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"bad","result":92.07,"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":86173514.0},{"year":2022,"value":95909842.0},{"year":2023,"value":109793095.0},{"year":2024,"value":122422190.0},{"year":2025,"value":120682467.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":294595421.0},{"year":2022,"value":336427420.0},{"year":2023,"value":338634970.0},{"year":2024,"value":391681840.0},{"year":2025,"value":461516563.0}],"category":"Electricity "},{"values":[{"year":2021,"value":141487374.0},{"year":2022,"value":150828277.0},{"year":2023,"value":149625705.0},{"year":2024,"value":180989980.0},{"year":2025,"value":191106025.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":6208082.0},{"year":2022,"value":39422277.0},{"year":2023,"value":26173765.0},{"year":2024,"value":4749953.0},{"year":2025,"value":4025860.0}],"category":"Housing"},{"values":[{"year":2021,"value":1468603.0},{"year":2022,"value":1703595.0},{"year":2023,"value":2293961.0},{"year":2024,"value":2439436.0},{"year":2025,"value":2265341.0}],"category":"Other"},{"values":[{"year":2021,"value":50123824.0},{"year":2022,"value":57666449.0},{"year":2023,"value":60694524.0},{"year":2024,"value":57304785.0},{"year":2025,"value":50864733.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":26235037.0},{"year":2022,"value":29576586.0},{"year":2023,"value":31642702.0},{"year":2024,"value":35933121.0},{"year":2025,"value":36484800.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":42534130.0},{"year":2022,"value":54868749.0},{"year":2023,"value":60289934.0},{"year":2024,"value":59896147.0},{"year":2025,"value":61868558.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":65540128.0},{"year":2022,"value":68303881.0},{"year":2023,"value":69307358.0},{"year":2024,"value":78215915.0},{"year":2025,"value":82335455.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":66082609.0},{"year":2022,"value":77577000.0},{"year":2023,"value":86075172.0},{"year":2024,"value":91861914.0},{"year":2025,"value":98058918.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":"WC015"},"muni_contact":{"url":"http://www.Swartland.org.za","phone_number":"022 487 9400","street_address_1":" ","street_address_2":"Church Street","street_address_3":"Malmesbury","street_address_4":"7299"},"mayoral_staff":{"officials":[{"name":"John Harold Cleophas","role":"Mayor/Executive Mayor","email":"mayor@swartland.org.za","title":"Mr","secretary":{"name":"Chantal Arendse","role":"Secretary of Mayor/Executive Mayor","email":"mayoradmin2@swartland.org","title":"Mrs","fax_number":"022 487 9440","office_phone":"022 487 9400"},"fax_number":"022 487 9440","office_phone":"022 487 9400"},{"name":"Joggie Scholtz","role":"Municipal Manager","email":"scholtzjj@swartland.org.za","title":"Mr","secretary":{"name":"Melanie Thiart-Wiid","role":"Secretary of Municipal Manager","email":"wiidm@swartland.org.za","title":"Ms","fax_number":"022 487 9440","office_phone":"022 487 9400"},"fax_number":"022 487 9440","office_phone":"022 487 9400"},{"name":"Ms Anet De Beer (DA)","role":"Deputy Mayor/Executive Mayor","email":"depmayor@swartland.org.za","title":"Mrs","secretary":{"name":"Michelle Morris","role":"Secretary of Deputy Mayor/Executive Mayor","email":"morrism@swartland.org.za","title":"Mrs","fax_number":"022 487 9440","office_phone":"022 487 9400"},"fax_number":"022 487 9440","office_phone":"022 487 9400"},{"name":"Mark Bolton","role":"Chief Financial Officer","email":"boltonm@swartland.org.za","title":"Mr","secretary":{"name":"","role":"Secretary of Financial Manager","email":"","title":"","fax_number":"","office_phone":""},"fax_number":"022 487 9440","office_phone":"022 487 9400"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"unqualified","result":"Unqualified - No findings","report_url":"https://lg.treasury.gov.za/supportingdocs/WC015/WC015_Audit%20Report_2024_Y_20250401T163356Z_papierh.pdf"},{"date":2023,"rating":"unqualified","result":"Unqualified - No findings","report_url":"https://lg.treasury.gov.za/supportingdocs/WC015/WC015_Audit%20Report_2023_Y_20240402T141313Z_rossouww.pdf"},{"date":2022,"rating":"unqualified","result":"Unqualified - No findings","report_url":"https://lg.treasury.gov.za/supportingdocs/WC015/WC015_Audit%20Report_2022_Y_20230216T095522Z_papierh.pdf"},{"date":2021,"rating":"unqualified","result":"Unqualified - No findings","report_url":"https://lg.treasury.gov.za/supportingdocs/WC015/WC015_Audit%20Report_2021_Y_20220217T054949Z_5039.pdf"}]}}