{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":165918484.0,"national_conditional_grants":1430611017.0},"ORGB":{"equitable_share":2924283000.0,"national_conditional_grants":2455198000.0},"SCHD":{"national_conditional_grants":677993000.0},"TRFR":{"national_conditional_grants":158688000.0}},"2022":{"ACT":{"national_conditional_grants":1088197623.0},"ORGB":{"equitable_share":3088576000.0,"national_conditional_grants":2401497000.0},"SCHD":{"national_conditional_grants":1484051000.0},"TRFR":{"national_conditional_grants":1476380000.0}},"2023":{"ACT":{"national_conditional_grants":-24652144.0},"ORGB":{"equitable_share":3551250000.0,"provincial_transfers":428610000.0,"national_conditional_grants":2628046000.0},"SCHD":{"national_conditional_grants":1583435000.0},"TRFR":{"national_conditional_grants":1575809000.0}},"2024":{"ACT":{"national_conditional_grants":2323379145.0},"ORGB":{"equitable_share":3993570000.0,"national_conditional_grants":2812367000.0},"SCHD":{"national_conditional_grants":1510946000.0},"TRFR":{"national_conditional_grants":1482606000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":165918484.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":2924283000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":3088576000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":3551250000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":3993570000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":86870000.0,"grant.code":"0002","grant.label":"Health","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":58000.0,"grant.code":"0005","grant.label":"Agriculture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":21750000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":319932000.0,"grant.code":"0007","grant.label":"Housing and Local Government","amount_type.code":"ORGB","financial_year_end.year":2023}]},"national_conditional_grants":{"2021":[{"amount.sum":9000000.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":128.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":2000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":2000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":15997728.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":300000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":5000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":68984353.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":649422000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":153620000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":12271000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":3068000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1345628808.0,"grant.code":"USDG","grant.label":"Urban Settlement Development Grant","amount_type.code":"ACT","financial_year_end.year":2021}],"2022":[{"amount.sum":1899658.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":5000000.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":5000000.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":208765.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":2100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":2100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":-334376.0,"grant.code":"ICDG","grant.label":"Integrated City Development Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":3671000.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":549985238.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":560301000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":560301000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":4000000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":5448302.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":159111000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":159111000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":55375000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":55375000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":195670718.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":675462000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":675462000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":13321000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":19031000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":19031000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":321998318.0,"grant.code":"USDG","grant.label":"Urban Settlement Development Grant","amount_type.code":"ACT","financial_year_end.year":2022}],"2023":[{"amount.sum":9000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":9000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":2200000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":2200000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":7626000.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":-38960.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":-24613184.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":593685000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":593685000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":150215000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":150215000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":51532000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":51532000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":753681000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":753681000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":15496000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":15496000.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":1999124.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":2000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":2000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1407527.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":2200000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":2200000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":28340000.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":521991085.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":535042000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":535042000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":119459275.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":140465000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":140465000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":46509248.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":47000000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":47000000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":675944200.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":740319000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":740319000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":15580000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":15580000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":15580000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":940488686.0,"grant.code":"USDG","grant.label":"Urban Settlement Development Grant","amount_type.code":"ACT","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":79869581301.0,"cube_version":"v2"},{"date":2023,"rating":"bad","result":-32299801.0,"cube_version":"v2"},{"date":2022,"rating":"bad","result":null,"cube_version":null},{"date":2021,"rating":"bad","result":null,"cube_version":null}],"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":21.2,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0.0,"cube_version":"v2"},{"date":2022,"rating":null,"result":null,"cube_version":null},{"date":2021,"rating":null,"result":null,"cube_version":null}],"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":5915992111.0,"rating":"bad","result":0.31,"amount_type":"AUDA","liabilities":19013545885.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":10727355918.0,"rating":"bad","result":0.54,"amount_type":"AUDA","liabilities":19748164183.0,"cube_version":"v2"},{"date":2022,"year":2022,"rating":"bad","result":null,"cube_version":null},{"date":2021,"year":2021,"rating":"bad","result":null,"cube_version":null}],"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":-5246160345.0,"date":"2024","year":2024,"rating":"bad","result":-0.28,"amount_type":"ACT","liabilities":19013545885.0,"cube_version":"v2","call_investment_deposits":0},{"cash":257942072.0,"date":"2023","year":2023,"rating":"bad","result":0.01,"amount_type":"ACT","liabilities":19748164183.0,"cube_version":"v2","call_investment_deposits":0},{"date":"2022","year":2022,"rating":"bad","result":null,"cube_version":null},{"date":"2021","year":2021,"rating":"bad","result":null,"cube_version":null}],"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":40956561346.0,"percent":89.3},"total":45863046759.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":4906485413.0,"percent":10.7}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":11.81,"cube_version":"v2"},{"date":2023,"rating":"bad","result":13.24,"cube_version":"v2"},{"date":2022,"rating":null,"result":null,"cube_version":null},{"date":2021,"rating":null,"result":null,"cube_version":null}],"formula":{"text":"= (Unauthorised, Irregular, Fruitless and Wasteful Expenditure / Actual Operating Expenditure) * 100","actual":["=","(",{"cube":"uifwexp","item_codes":["irregular","fruitless","unauthorised"]},"/",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= (Unauthorised, Irregular, Fruitless and Wasteful Expenditure / Actual Operating Expenditure) * 100","actual":["=","(",{"cube":"uifwexp","item_codes":["irregular","fruitless","unauthorised"]},"/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},")","*","100"]},"result_type":"%"},"income_adjustments":{"2021":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Government Transfers","amount":529154558.0,"comparison":"Original to adjusted budget","percent_changed":15.46},{"item":"Government Transfers","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Interest and investments","amount":-907662.0,"comparison":"Original to adjusted budget","percent_changed":-0.13},{"item":"Interest and investments","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Other","amount":-38596722.0,"comparison":"Original to adjusted budget","percent_changed":-1.52},{"item":"Other","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Property rates","amount":101503109.0,"comparison":"Original to adjusted budget","percent_changed":1.2},{"item":"Property rates","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Rental income","amount":-1412278.0,"comparison":"Original to adjusted budget","percent_changed":-0.87},{"item":"Rental income","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Service Charges","amount":-845735087.0,"comparison":"Original to adjusted budget","percent_changed":-3.83},{"item":"Service Charges","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null}],"2022":[{"item":"Fines","amount":-6553683.0,"comparison":"Original to adjusted budget","percent_changed":-2.61},{"item":"Fines","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Government Transfers","amount":297475722.0,"comparison":"Original to adjusted budget","percent_changed":8.07},{"item":"Government Transfers","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Interest and investments","amount":-130210376.0,"comparison":"Original to adjusted budget","percent_changed":-13.26},{"item":"Interest and investments","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Licenses and Permits","amount":-500000.0,"comparison":"Original to adjusted budget","percent_changed":-0.95},{"item":"Licenses and Permits","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Other","amount":-30534126.0,"comparison":"Original to adjusted budget","percent_changed":-1.2},{"item":"Other","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Rental income","amount":-21507715.0,"comparison":"Original to adjusted budget","percent_changed":-12.65},{"item":"Rental income","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Service Charges","amount":247180928.0,"comparison":"Original to adjusted budget","percent_changed":1.08},{"item":"Service Charges","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null}],"2023":[{"item":"Fines","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Fines","amount":-55236079.0,"comparison":"Original budget to audited outcome","percent_changed":-20.1},{"item":"Government Transfers","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Government Transfers","amount":326200710.0,"comparison":"Original budget to audited outcome","percent_changed":7.26},{"item":"Interest and investments","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Interest and investments","amount":578317463.0,"comparison":"Original budget to audited outcome","percent_changed":64.81},{"item":"Licenses and Permits","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Licenses and Permits","amount":-9399691.0,"comparison":"Original budget to audited outcome","percent_changed":-17.24},{"item":"Other","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Other","amount":237655150.0,"comparison":"Original budget to audited outcome","percent_changed":8.92},{"item":"Property rates","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Property rates","amount":23900518.0,"comparison":"Original budget to audited outcome","percent_changed":0.26},{"item":"Rental income","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Rental income","amount":-19059285.0,"comparison":"Original budget to audited outcome","percent_changed":-10.28},{"item":"Service Charges","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Service Charges","amount":-1696800202.0,"comparison":"Original budget to audited outcome","percent_changed":-6.93}],"2024":[{"item":"Fines","amount":27144.0,"comparison":"Original to adjusted budget","percent_changed":0.01},{"item":"Fines","amount":-50839066.0,"comparison":"Original budget to audited outcome","percent_changed":-17.41},{"item":"Government Transfers","amount":-89593508.0,"comparison":"Original to adjusted budget","percent_changed":-1.75},{"item":"Government Transfers","amount":-206134439.0,"comparison":"Original budget to audited outcome","percent_changed":-4.03},{"item":"Interest and investments","amount":502898418.0,"comparison":"Original to adjusted budget","percent_changed":51.79},{"item":"Interest and investments","amount":1368448430.0,"comparison":"Original budget to audited outcome","percent_changed":140.94},{"item":"Licenses and Permits","amount":-4219204.0,"comparison":"Original to adjusted budget","percent_changed":-9.67},{"item":"Licenses and Permits","amount":-708.0,"comparison":"Original budget to audited outcome","percent_changed":0.0},{"item":"Other","amount":99932722.0,"comparison":"Original to adjusted budget","percent_changed":3.86},{"item":"Other","amount":488402690.0,"comparison":"Original budget to audited outcome","percent_changed":18.86},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":248716907.0,"comparison":"Original budget to audited outcome","percent_changed":2.58},{"item":"Rental income","amount":-40886731.0,"comparison":"Original to adjusted budget","percent_changed":-20.07},{"item":"Rental income","amount":22380802.0,"comparison":"Original budget to audited outcome","percent_changed":10.99},{"item":"Service Charges","amount":-94244509.0,"comparison":"Original to adjusted budget","percent_changed":-0.36},{"item":"Service Charges","amount":-712858471.0,"comparison":"Original budget to audited outcome","percent_changed":-2.76}]},"income_time_series":[{"amount":37488157597.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":39515637555.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":45078844946.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":41537418881.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":45863046759.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":51436768038.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":51230932742.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":55242653562.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":37744151679.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":39160286805.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":42151840297.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":44704930614.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":48474258969.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":1.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Contracted services","amount":470571954.0,"comparison":"Original to adjusted budget","percent_changed":11.97},{"item":"Contracted services","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Employee related costs","amount":-151571817.0,"comparison":"Original to adjusted budget","percent_changed":-1.3},{"item":"Employee related costs","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Finance charges","amount":3.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Other","amount":-549554794.0,"comparison":"Original to adjusted budget","percent_changed":-5.02},{"item":"Other","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Remuneration of councillors","amount":3985377.0,"comparison":"Original to adjusted budget","percent_changed":2.65},{"item":"Remuneration of councillors","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Transfers and subsidies","amount":-1080915.0,"comparison":"Original to adjusted budget","percent_changed":-2.37},{"item":"Transfers and subsidies","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null}],"2022":[{"item":"Bulk purchases","amount":-1.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Contracted services","amount":567259757.0,"comparison":"Original to adjusted budget","percent_changed":15.39},{"item":"Contracted services","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Employee related costs","amount":-280115576.0,"comparison":"Original to adjusted budget","percent_changed":-2.3},{"item":"Employee related costs","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Finance charges","amount":333621.0,"comparison":"Original to adjusted budget","percent_changed":0.02},{"item":"Finance charges","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Other","amount":152210101.0,"comparison":"Original to adjusted budget","percent_changed":1.46},{"item":"Other","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Transfers and subsidies","amount":-7106512.0,"comparison":"Original to adjusted budget","percent_changed":-16.46},{"item":"Transfers and subsidies","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null}],"2023":[{"item":"Bulk purchases","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Bulk purchases","amount":-620416007.0,"comparison":"Original budget to audited outcome","percent_changed":-5.12},{"item":"Contracted services","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Contracted services","amount":-49100781.0,"comparison":"Original budget to audited outcome","percent_changed":-1.13},{"item":"Employee related costs","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Employee related costs","amount":-1233033500.0,"comparison":"Original budget to audited outcome","percent_changed":-9.76},{"item":"Finance charges","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Finance charges","amount":437959759.0,"comparison":"Original budget to audited outcome","percent_changed":29.04},{"item":"Other","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Other","amount":1469458497.0,"comparison":"Original budget to audited outcome","percent_changed":12.95},{"item":"Remuneration of councillors","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Remuneration of councillors","amount":-31950344.0,"comparison":"Original budget to audited outcome","percent_changed":-19.5},{"item":"Transfers and subsidies","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Transfers and subsidies","amount":63921986.0,"comparison":"Original budget to audited outcome","percent_changed":167.96}],"2024":[{"item":"Bulk purchases","amount":-368000000.0,"comparison":"Original to adjusted budget","percent_changed":-2.56},{"item":"Bulk purchases","amount":-1001186656.0,"comparison":"Original budget to audited outcome","percent_changed":-6.96},{"item":"Contracted services","amount":617293410.0,"comparison":"Original to adjusted budget","percent_changed":16.34},{"item":"Contracted services","amount":17498132.0,"comparison":"Original budget to audited outcome","percent_changed":0.46},{"item":"Employee related costs","amount":-26861035.0,"comparison":"Original to adjusted budget","percent_changed":-0.21},{"item":"Employee related costs","amount":-1044399432.0,"comparison":"Original budget to audited outcome","percent_changed":-8.26},{"item":"Finance charges","amount":216235713.0,"comparison":"Original to adjusted budget","percent_changed":14.43},{"item":"Finance charges","amount":851089774.0,"comparison":"Original budget to audited outcome","percent_changed":56.79},{"item":"Other","amount":-3909236.0,"comparison":"Original to adjusted budget","percent_changed":-0.03},{"item":"Other","amount":1801365896.0,"comparison":"Original budget to audited outcome","percent_changed":14.81},{"item":"Remuneration of councillors","amount":141598.0,"comparison":"Original to adjusted budget","percent_changed":0.09},{"item":"Remuneration of councillors","amount":-20473249.0,"comparison":"Original budget to audited outcome","percent_changed":-13.31},{"item":"Transfers and subsidies","amount":-250000.0,"comparison":"Original to adjusted budget","percent_changed":-2.58},{"item":"Transfers and subsidies","amount":90171089.0,"comparison":"Original budget to audited outcome","percent_changed":931.23}]},"spending_time_series":[{"amount":37478511906.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":39572135463.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":45052028385.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":42185371898.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":45311443489.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":51118261935.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":51169652470.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":55032741601.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":37706162097.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":39139554073.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":42148532288.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":44617377935.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":48318745013.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":-56.19,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"bad","result":381.69,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":null,"result":null,"overunder":null,"cube_version":null},{"date":2021,"rating":null,"result":null,"overunder":null,"cube_version":null}],"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":9875872847.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":25153058184.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":226080346.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":2339391165.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":241157889.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":43618141.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":3077382774.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":25.59},{"date":2023,"rating":"","result":27.02},{"date":2022,"rating":"","result":null},{"date":2021,"rating":"","result":null}],"formula":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp","item_codes":["3000","3100"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp_v2","item_codes":["3100"],"amount_type":"AUDA"}]},"result_type":"%"},"operating_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2024,"rating":"good","result":0.6,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":null,"result":null,"overunder":null,"cube_version":null},{"date":2022,"rating":null,"result":null,"overunder":null,"cube_version":null},{"date":2021,"rating":null,"result":null,"overunder":null,"cube_version":null}],"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":1.89,"cube_version":"v2"},{"date":2023,"rating":"bad","result":2.31,"cube_version":"v2"},{"date":2022,"rating":null,"result":null,"cube_version":null},{"date":2021,"rating":null,"result":null,"cube_version":null}],"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":8.37},{"date":2023,"rating":"","result":10.16},{"date":2022,"rating":"","result":null},{"date":2021,"rating":"","result":null}],"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":0.04,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"bad","result":-0.9,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"bad","result":null,"billing":null,"receipts":null,"cube_version":null},{"date":"2021","year":2021,"rating":"bad","result":null,"billing":null,"receipts":null,"cube_version":null}],"formula":{"text":"= (Collected Revenue / Billed Revenue) * 100","actual":["=","(",{"cube":"cflow","item_codes":["3010","3030","3040","3050","3060","3070","3100"],"amount_type":"AUDA"},"/",{"cube":"incexp","item_codes":["0200","0400","1000","less item code","2000"],"amount_type":"AUDA"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= (Collected Revenue / Billed Revenue) * 100","actual":["=","(",{"cube":"cflow_v2","item_codes":["0120","0130","0280"],"amount_type":"AUDA"},"/",{"cube":"incexp_v2","item_codes":["1800","0300","0400","0500","0600","1400","1100","1000"],"amount_type":"AUDA"},")","*","100"]},"result_type":"%"},"expenditure_functional_breakdown":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"values":[{"year":2023,"value":4389302221.0},{"year":2024,"value":4512698075.0},{"year":2025,"value":5442246299.0}],"category":"Community & Social Services"},{"values":[{"year":2023,"value":14872985317.0},{"year":2024,"value":16255765825.0},{"year":2025,"value":18874684958.0}],"category":"Electricity "},{"values":[{"year":2023,"value":214524901.0},{"year":2024,"value":247409353.0},{"year":2025,"value":199420875.0}],"category":"Environmental Protection"},{"values":[{"year":2023,"value":9937082009.0},{"year":2024,"value":10905040110.0},{"year":2025,"value":10792365123.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2023,"value":990655479.0},{"year":2024,"value":1041261159.0},{"year":2025,"value":939201976.0}],"category":"Health"},{"values":[{"year":2023,"value":930568843.0},{"year":2024,"value":868061451.0},{"year":2025,"value":1127640228.0}],"category":"Housing"},{"values":[{"year":2023,"value":218764713.0},{"year":2024,"value":180240984.0},{"year":2025,"value":314666248.0}],"category":"Other"},{"values":[{"year":2023,"value":2802310656.0},{"year":2024,"value":2355425108.0},{"year":2025,"value":2287122153.0}],"category":"Road Transport"},{"values":[{"year":2023,"value":594608190.0},{"year":2024,"value":565587917.0},{"year":2025,"value":807612616.0}],"category":"Sport And Recreation"},{"values":[{"year":2023,"value":1578074755.0},{"year":2024,"value":1445907399.0},{"year":2025,"value":1586145669.0}],"category":"Waste Management"},{"values":[{"year":2023,"value":744539694.0},{"year":2024,"value":896095092.0},{"year":2025,"value":799321833.0}],"category":"Waste Water Management"},{"values":[{"year":2023,"value":4911955120.0},{"year":2024,"value":6037951016.0},{"year":2025,"value":7947833957.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":"TSH"},"muni_contact":{"url":"http://Www.Tshwane.Gov.Za","phone_number":"012 358 7911","street_address_1":"Tshwane House","street_address_2":"Cnr Lilian Ngoiyi & Madiba Street","street_address_3":"Pretoria","street_address_4":"0002"},"mayoral_staff":{"officials":[{"name":"Nasiphi Moya","role":"Mayor/Executive Mayor","email":"nasiphim@tshwane.gov.za","title":"Mrs","secretary":{"name":"Sally Motebele","role":"Secretary of Mayor/Executive Mayor","email":"sallym@tshwane.gov.za","title":"Ms","fax_number":"086 732 5458","office_phone":"012 358 4903"},"fax_number":" ","office_phone":"012 358 0796"},{"name":"Johann Mettler","role":"Municipal Manager","email":"citymanager@tshwane.gov.za","title":"Mr","secretary":{"name":"Ninette Botha","role":"Secretary of Municipal Manager","email":"ninetteb@tshwane.gov.za","title":"Ms","fax_number":"086 214 9544","office_phone":"012 358 4904"},"fax_number":"012 358 1112","office_phone":"012 358 4901"},{"name":"Nasiphi Moya","role":"Deputy Mayor/Executive Mayor","email":"nasiphim@tshwane.gov.za","title":"Mrs","secretary":{"name":"Nomakhosi Chiane","role":"Secretary of Deputy Mayor/Executive Mayor","email":"nomakhosic@tshwane.gov.za","title":"Ms","fax_number":" ","office_phone":"012 358 5520"},"fax_number":" ","office_phone":"012 358 0796"},{"name":"Gareth Mnisi","role":"Chief Financial Officer","email":"cfo@tshwane.gov.za","title":"Mr","secretary":{"name":"Sarah Masevhe","role":"Secretary of Financial Manager","email":"sarahmas@tshwane.gov.za","title":"Ms","fax_number":"012 358 8111","office_phone":"012 358 8101"},"fax_number":" ","office_phone":"012 358 8100"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/TSH/TSH_Audit%20Report_2024_Y_20250319T170622Z_tsakanin.pdf"},{"date":2023,"rating":"qualified","result":"Qualified","report_url":""},{"date":2022,"rating":"adverse","result":"Adverse opinion","report_url":"https://lg.treasury.gov.za/supportingdocs/TSH/TSH_Audit%20Report_2022_Y_20230322T115902Z_nontandoq.pdf"},{"date":2021,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/TSH/TSH_Audit%20Report_2021_Y_20230316T144214Z_nontandoq.pdf"}]}}