{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":26168014.0,"national_conditional_grants":282046235.0},"ORGB":{"equitable_share":5183056000.0,"national_conditional_grants":3075784000.0},"SCHD":{"national_conditional_grants":984834000.0},"TRFR":{"national_conditional_grants":337240000.0}},"2022":{"ORGB":{"equitable_share":5467766000.0,"national_conditional_grants":3111537000.0},"SCHD":{"national_conditional_grants":1804254000.0},"TRFR":{"national_conditional_grants":1780993000.0}},"2023":{"ACT":{"national_conditional_grants":2065051490.0},"ORGB":{"equitable_share":6279400000.0,"provincial_transfers":597885000.0,"national_conditional_grants":3345411000.0},"SCHD":{"national_conditional_grants":2019132000.0},"TRFR":{"national_conditional_grants":1994050000.0}},"2024":{"ACT":{"national_conditional_grants":1580464919.0},"ORGB":{"equitable_share":7053154000.0,"national_conditional_grants":3880169000.0},"SCHD":{"national_conditional_grants":1589963000.0},"TRFR":{"national_conditional_grants":1572050000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":26168014.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":5183056000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":5467766000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":6279400000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":7053154000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":189331000.0,"grant.code":"0002","grant.label":"Health","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":2310000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":24000000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":382056000.0,"grant.code":"0007","grant.label":"Housing and Local Government","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":188000.0,"grant.code":"0009","grant.label":"Other Departments","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":2000000.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":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":51055446.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":7000000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":4000000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1000000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1824000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":62406000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":62406000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":884609000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":262879000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1803647.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":19819000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":4955000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":227363142.0,"grant.code":"USDG","grant.label":"Urban Settlement Development Grant","amount_type.code":"ACT","financial_year_end.year":2021}],"2022":[{"amount.sum":10000000.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":10000000.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":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":20261000.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":7500000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":7500000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":629375000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":629375000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":3000000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":149538000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":149538000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":80361000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":80361000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":894690000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":894690000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":8529000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":8529000.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":1000044.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":25082000.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":3474880.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":6000000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":6000000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":13458000.0,"grant.code":"MEHG","grant.label":"Municipal Emergency Housing Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":13458000.0,"grant.code":"MEHG","grant.label":"Municipal Emergency Housing Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":437192022.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":684888000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":684888000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":137420000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":137420000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":78225000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":78225000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":511592000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1065359000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1065359000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":5330200.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":7700000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":7700000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1106462344.0,"grant.code":"USDG","grant.label":"Urban Settlement Development Grant","amount_type.code":"ACT","financial_year_end.year":2023}],"2024":[{"amount.sum":61700000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":61700000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":999692.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":17913000.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":3321387.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":5569000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":5569000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":261553214.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":620962000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":620962000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":22006000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":97099000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":97099000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":35000000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":35000000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":254208455.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":737523000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":737523000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":11079666.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":13197000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":13197000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1027296505.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":3717439189.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":4722549104.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":4722549104.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":75451447666.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":"bad","result":0.6,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0.9,"cube_version":"v2"},{"date":2022,"rating":"bad","result":0.9,"cube_version":"v2"},{"date":2021,"rating":"good","result":13.2,"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":15738936940.0,"rating":"bad","result":0.56,"amount_type":"AUDA","liabilities":28278845979.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":38678893184.0,"rating":"bad","result":0.9,"amount_type":"AUDA","liabilities":42970636683.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":38678893184.0,"rating":"bad","result":0.9,"amount_type":"AUDA","liabilities":42970626683.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":28482738169.0,"rating":"ave","result":1.11,"amount_type":"AUDA","liabilities":25578246362.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":2165857035.0,"date":"2024","year":2024,"rating":"bad","result":0.08,"amount_type":"ACT","liabilities":28278845979.0,"cube_version":"v2","call_investment_deposits":0},{"cash":3673041948.0,"date":"2023","year":2023,"rating":"bad","result":0.09,"amount_type":"ACT","liabilities":42970636683.0,"cube_version":"v2","call_investment_deposits":0},{"cash":3673041948.0,"date":"2022","year":2022,"rating":"bad","result":0.09,"amount_type":"ACT","liabilities":42970626683.0,"cube_version":"v2","call_investment_deposits":0},{"cash":7216560371.0,"date":"2021","year":2021,"rating":"bad","result":0.28,"amount_type":"ACT","liabilities":25578246362.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":63322043980.0,"percent":88.95},"total":71189750980.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":7867707000.0,"percent":11.05}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":6.33,"cube_version":"v2"},{"date":2023,"rating":"bad","result":3.46,"cube_version":"v2"},{"date":2022,"rating":"bad","result":3.43,"cube_version":"v2"},{"date":2021,"rating":"bad","result":3.11,"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":-23168470.0,"comparison":"Original to adjusted budget","percent_changed":-2.06},{"item":"Fines","amount":428003984.0,"comparison":"Original budget to audited outcome","percent_changed":38.03},{"item":"Government Transfers","amount":-4397586670.0,"comparison":"Original to adjusted budget","percent_changed":-30.04},{"item":"Government Transfers","amount":336919557.0,"comparison":"Original budget to audited outcome","percent_changed":2.3},{"item":"Interest and investments","amount":-159880231.0,"comparison":"Original to adjusted budget","percent_changed":-17.97},{"item":"Interest and investments","amount":768598621.0,"comparison":"Original budget to audited outcome","percent_changed":86.37},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":7795283.0,"comparison":"Original budget to audited outcome","percent_changed":93.03},{"item":"Other","amount":-334969670.0,"comparison":"Original to adjusted budget","percent_changed":-12.67},{"item":"Other","amount":-293896707.0,"comparison":"Original budget to audited outcome","percent_changed":-11.12},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-179729620.0,"comparison":"Original budget to audited outcome","percent_changed":-1.36},{"item":"Rental income","amount":-9328088.0,"comparison":"Original to adjusted budget","percent_changed":-1.98},{"item":"Rental income","amount":-96012449.0,"comparison":"Original budget to audited outcome","percent_changed":-20.42},{"item":"Service Charges","amount":-72557000.0,"comparison":"Original to adjusted budget","percent_changed":-0.22},{"item":"Service Charges","amount":-787269084.0,"comparison":"Original budget to audited outcome","percent_changed":-2.39}],"2022":[{"item":"Fines","amount":-267878000.0,"comparison":"Original to adjusted budget","percent_changed":-23.96},{"item":"Fines","amount":-1053745237.0,"comparison":"Original budget to audited outcome","percent_changed":-94.23},{"item":"Government Transfers","amount":-81983000.0,"comparison":"Original to adjusted budget","percent_changed":-0.76},{"item":"Government Transfers","amount":-4488582.0,"comparison":"Original budget to audited outcome","percent_changed":-0.04},{"item":"Interest and investments","amount":-136530000.0,"comparison":"Original to adjusted budget","percent_changed":-17.96},{"item":"Interest and investments","amount":-57138601.0,"comparison":"Original budget to audited outcome","percent_changed":-7.52},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-1571491.0,"comparison":"Original budget to audited outcome","percent_changed":-17.98},{"item":"Other","amount":132921228.0,"comparison":"Original to adjusted budget","percent_changed":5.51},{"item":"Other","amount":-379979295.0,"comparison":"Original budget to audited outcome","percent_changed":-15.76},{"item":"Property rates","amount":360.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":22854027.0,"comparison":"Original budget to audited outcome","percent_changed":0.17},{"item":"Rental income","amount":2866673.0,"comparison":"Original to adjusted budget","percent_changed":0.59},{"item":"Rental income","amount":-112918443.0,"comparison":"Original budget to audited outcome","percent_changed":-23.19},{"item":"Service Charges","amount":-269323561.0,"comparison":"Original to adjusted budget","percent_changed":-0.73},{"item":"Service Charges","amount":-3611617705.0,"comparison":"Original budget to audited outcome","percent_changed":-9.8}],"2023":[{"item":"Fines","amount":-494599000.0,"comparison":"Original to adjusted budget","percent_changed":-55.47},{"item":"Fines","amount":-827104237.0,"comparison":"Original budget to audited outcome","percent_changed":-92.77},{"item":"Government Transfers","amount":-31758000.0,"comparison":"Original to adjusted budget","percent_changed":-0.42},{"item":"Government Transfers","amount":3099584418.0,"comparison":"Original budget to audited outcome","percent_changed":40.68},{"item":"Interest and investments","amount":-12969781.0,"comparison":"Original to adjusted budget","percent_changed":-2.13},{"item":"Interest and investments","amount":94378932.0,"comparison":"Original budget to audited outcome","percent_changed":15.51},{"item":"Licenses and Permits","amount":704000.0,"comparison":"Original to adjusted budget","percent_changed":7.67},{"item":"Licenses and Permits","amount":-2010491.0,"comparison":"Original budget to audited outcome","percent_changed":-21.9},{"item":"Other","amount":-6746431.0,"comparison":"Original to adjusted budget","percent_changed":-0.1},{"item":"Other","amount":-4616884091.0,"comparison":"Original budget to audited outcome","percent_changed":-69.45},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-630886333.0,"comparison":"Original budget to audited outcome","percent_changed":-4.46},{"item":"Rental income","amount":-10149188.0,"comparison":"Original to adjusted budget","percent_changed":-1.97},{"item":"Rental income","amount":-141924443.0,"comparison":"Original budget to audited outcome","percent_changed":-27.51},{"item":"Service Charges","amount":-2259164798.0,"comparison":"Original to adjusted budget","percent_changed":-5.71},{"item":"Service Charges","amount":-6351217073.0,"comparison":"Original budget to audited outcome","percent_changed":-16.04}],"2024":[{"item":"Fines","amount":-790318000.0,"comparison":"Original to adjusted budget","percent_changed":-83.05},{"item":"Fines","amount":-775982612.0,"comparison":"Original budget to audited outcome","percent_changed":-81.55},{"item":"Government Transfers","amount":52991000.0,"comparison":"Original to adjusted budget","percent_changed":0.64},{"item":"Government Transfers","amount":-413746000.0,"comparison":"Original budget to audited outcome","percent_changed":-5.0},{"item":"Interest and investments","amount":165638348.0,"comparison":"Original to adjusted budget","percent_changed":26.59},{"item":"Interest and investments","amount":537939907.0,"comparison":"Original budget to audited outcome","percent_changed":86.35},{"item":"Licenses and Permits","amount":-7437000.0,"comparison":"Original to adjusted budget","percent_changed":-68.42},{"item":"Licenses and Permits","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Other","amount":-567481775.0,"comparison":"Original to adjusted budget","percent_changed":-8.64},{"item":"Other","amount":811380274.0,"comparison":"Original budget to audited outcome","percent_changed":12.35},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":426179349.0,"comparison":"Original budget to audited outcome","percent_changed":2.6},{"item":"Rental income","amount":52343262.0,"comparison":"Original to adjusted budget","percent_changed":9.77},{"item":"Rental income","amount":-228434728.0,"comparison":"Original budget to audited outcome","percent_changed":-42.63},{"item":"Service Charges","amount":-3093953191.0,"comparison":"Original to adjusted budget","percent_changed":-7.36},{"item":"Service Charges","amount":-4550585562.0,"comparison":"Original budget to audited outcome","percent_changed":-10.82}]},"income_time_series":[{"amount":60905717349.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":65226855655.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":67209556748.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":71205652996.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":66087617063.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":60648176628.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":60648176628.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":71189750980.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":82066562421.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":88592255303.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":65903207478.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":65846781955.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":70024239946.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":75393870352.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":76368851404.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":-51574957.0,"comparison":"Original budget to audited outcome","percent_changed":-0.42},{"item":"Contracted services","amount":57222499.0,"comparison":"Original to adjusted budget","percent_changed":0.93},{"item":"Contracted services","amount":-802961625.0,"comparison":"Original budget to audited outcome","percent_changed":-13.0},{"item":"Employee related costs","amount":253633364.0,"comparison":"Original to adjusted budget","percent_changed":1.59},{"item":"Employee related costs","amount":-112502734.0,"comparison":"Original budget to audited outcome","percent_changed":-0.71},{"item":"Finance charges","amount":-1134862735.0,"comparison":"Original to adjusted budget","percent_changed":-27.12},{"item":"Finance charges","amount":-400532592.0,"comparison":"Original budget to audited outcome","percent_changed":-9.57},{"item":"Other","amount":-7337397069.0,"comparison":"Original to adjusted budget","percent_changed":-24.26},{"item":"Other","amount":-3261985305.0,"comparison":"Original budget to audited outcome","percent_changed":-10.79},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-8600775.0,"comparison":"Original budget to audited outcome","percent_changed":-4.87},{"item":"Transfers and subsidies","amount":-7392020.0,"comparison":"Original to adjusted budget","percent_changed":-12.19},{"item":"Transfers and subsidies","amount":4149490371.0,"comparison":"Original budget to audited outcome","percent_changed":6842.82}],"2022":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":216572368.0,"comparison":"Original budget to audited outcome","percent_changed":1.58},{"item":"Contracted services","amount":318550704.0,"comparison":"Original to adjusted budget","percent_changed":4.9},{"item":"Contracted services","amount":384221394.0,"comparison":"Original budget to audited outcome","percent_changed":5.91},{"item":"Employee related costs","amount":7007876.0,"comparison":"Original to adjusted budget","percent_changed":0.04},{"item":"Employee related costs","amount":-1361537687.0,"comparison":"Original budget to audited outcome","percent_changed":-7.95},{"item":"Finance charges","amount":-512121000.0,"comparison":"Original to adjusted budget","percent_changed":-16.12},{"item":"Finance charges","amount":-431584013.0,"comparison":"Original budget to audited outcome","percent_changed":-13.58},{"item":"Other","amount":-542987371.0,"comparison":"Original to adjusted budget","percent_changed":-2.27},{"item":"Other","amount":-1726206100.0,"comparison":"Original budget to audited outcome","percent_changed":-7.21},{"item":"Remuneration of councillors","amount":-10500000.0,"comparison":"Original to adjusted budget","percent_changed":-5.61},{"item":"Remuneration of councillors","amount":-23473628.0,"comparison":"Original budget to audited outcome","percent_changed":-12.55},{"item":"Transfers and subsidies","amount":-370577000.0,"comparison":"Original to adjusted budget","percent_changed":-72.34},{"item":"Transfers and subsidies","amount":-367921571.0,"comparison":"Original budget to audited outcome","percent_changed":-71.82}],"2023":[{"item":"Bulk purchases","amount":-1197979430.0,"comparison":"Original to adjusted budget","percent_changed":-7.8},{"item":"Bulk purchases","amount":-1446537588.0,"comparison":"Original budget to audited outcome","percent_changed":-9.42},{"item":"Contracted services","amount":-1042112808.0,"comparison":"Original to adjusted budget","percent_changed":-13.12},{"item":"Contracted services","amount":-1058751236.0,"comparison":"Original budget to audited outcome","percent_changed":-13.33},{"item":"Employee related costs","amount":-927932705.0,"comparison":"Original to adjusted budget","percent_changed":-5.05},{"item":"Employee related costs","amount":-2600671738.0,"comparison":"Original budget to audited outcome","percent_changed":-14.17},{"item":"Finance charges","amount":-207918000.0,"comparison":"Original to adjusted budget","percent_changed":-7.2},{"item":"Finance charges","amount":-142777013.0,"comparison":"Original budget to audited outcome","percent_changed":-4.94},{"item":"Other","amount":-1039201820.0,"comparison":"Original to adjusted budget","percent_changed":-4.2},{"item":"Other","amount":-3321437454.0,"comparison":"Original budget to audited outcome","percent_changed":-13.43},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-21622628.0,"comparison":"Original budget to audited outcome","percent_changed":-11.68},{"item":"Transfers and subsidies","amount":-42677265.0,"comparison":"Original to adjusted budget","percent_changed":-23.21},{"item":"Transfers and subsidies","amount":-39478571.0,"comparison":"Original budget to audited outcome","percent_changed":-21.47}],"2024":[{"item":"Bulk purchases","amount":-2763370069.0,"comparison":"Original to adjusted budget","percent_changed":-16.85},{"item":"Bulk purchases","amount":8758766869.0,"comparison":"Original budget to audited outcome","percent_changed":53.4},{"item":"Contracted services","amount":-167497855.0,"comparison":"Original to adjusted budget","percent_changed":-2.21},{"item":"Contracted services","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Employee related costs","amount":55723715.0,"comparison":"Original to adjusted budget","percent_changed":0.29},{"item":"Employee related costs","amount":356400985.0,"comparison":"Original budget to audited outcome","percent_changed":1.88},{"item":"Finance charges","amount":225702000.0,"comparison":"Original to adjusted budget","percent_changed":10.4},{"item":"Finance charges","amount":783234701.0,"comparison":"Original budget to audited outcome","percent_changed":36.08},{"item":"Other","amount":-511146579.0,"comparison":"Original to adjusted budget","percent_changed":-1.84},{"item":"Other","amount":-680564883.0,"comparison":"Original budget to audited outcome","percent_changed":-2.45},{"item":"Remuneration of councillors","amount":-1900000.0,"comparison":"Original to adjusted budget","percent_changed":-1.03},{"item":"Remuneration of councillors","amount":3276975.0,"comparison":"Original budget to audited outcome","percent_changed":1.78},{"item":"Transfers and subsidies","amount":-54411000.0,"comparison":"Original to adjusted budget","percent_changed":-39.19},{"item":"Transfers and subsidies","amount":-75131331.0,"comparison":"Original budget to audited outcome","percent_changed":-54.12}]},"spending_time_series":[{"amount":60801509827.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":64026727279.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":65191197370.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":70082618351.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":68481638170.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":61827424833.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":61017743170.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":74870489318.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":80492301367.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":85549899600.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":68970305787.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":65137354070.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":69649019398.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":73299518139.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":75668755895.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":null,"result":null,"overunder":null,"cube_version":null},{"date":2023,"rating":"good","result":2.72,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"ave","result":-9.19,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"bad","result":-20.26,"overunder":"under","cube_version":"v2"}],"formula":{"text":"= ((Actual Capital Expenditure - Budgeted Capital Expenditure) / Budgeted Capital Expenditure) * 100","actual":["=","(","(",{"cube":"capital","item_codes":["4100"],"amount_type":"AUDA"},"-",{"cube":"capital","item_codes":["4100"],"amount_type":"ADJB"},")","/",{"cube":"capital","item_codes":["4100"],"amount_type":"ADJB"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= ((Actual Capital Expenditure - Budgeted Capital Expenditure) / Budgeted Capital Expenditure) * 100","actual":["=","(","(",{"cube":"capital_v2","amount_type":"AUDA","item_description":"capital type code NEW, RENEWAL, UPGRADING"},"-",{"cube":"capital_v2","amount_type":"ADJB","item_description":"capital type code NEW, RENEWAL, UPGRADING"},")","/",{"cube":"capital_v2","amount_type":"ADJB","item_description":"capital type code NEW, RENEWAL, UPGRADING"},")","*","100"]},"result_type":"%"},"local_revenue_breakdown":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"date":"2024","item":"Property rates","amount":16798944349.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":37497875381.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":307432503.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":1160951186.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":175591388.0,"amount_type":"AUDA"},{"date":"2024","item":"Agency services","amount":969999057.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":6411250116.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.86},{"date":2023,"rating":"","result":25.82},{"date":2022,"rating":"","result":25.48},{"date":2021,"rating":"","result":23.14}],"formula":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp","item_codes":["3000","3100"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp_v2","item_codes":["3100"],"amount_type":"AUDA"}]},"result_type":"%"},"operating_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2024,"rating":"ave","result":6.8,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"ave","result":-6.4,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"good","result":-3.4,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"ave","result":12.6,"overunder":"over","cube_version":"v2"}],"formula":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"-",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","/",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"-",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","*","100"]},"result_type":"%"},"repairs_maintenance_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":1.96,"cube_version":"v2"},{"date":2023,"rating":"bad","result":1.74,"cube_version":"v2"},{"date":2022,"rating":"bad","result":1.74,"cube_version":"v2"},{"date":2021,"rating":"bad","result":2.21,"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":null},{"date":2023,"rating":"","result":11.28},{"date":2022,"rating":"","result":11.13},{"date":2021,"rating":"","result":7.84}],"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":null,"billing":null,"receipts":null,"cube_version":null},{"date":"2023","year":2023,"rating":"bad","result":null,"billing":null,"receipts":null,"cube_version":null},{"date":"2022","year":2022,"rating":"bad","result":null,"billing":null,"receipts":null,"cube_version":null},{"date":"2021","year":2021,"rating":"bad","result":89.14,"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":5054224590.0},{"year":2022,"value":4385609844.0},{"year":2023,"value":4281248584.0},{"year":2024,"value":6160673022.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":14933098263.0},{"year":2022,"value":16491867432.0},{"year":2023,"value":16491867432.0},{"year":2024,"value":17579764777.0}],"category":"Electricity "},{"values":[{"year":2021,"value":256361793.0},{"year":2022,"value":209704752.0},{"year":2023,"value":209562848.0},{"year":2024,"value":52057031.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":31640824514.0},{"year":2022,"value":26973459004.0},{"year":2023,"value":26377749424.0},{"year":2024,"value":50433723428.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":973220791.0},{"year":2022,"value":1083569526.0},{"year":2023,"value":1083106741.0},{"year":2024,"value":2223426.0}],"category":"Health"},{"values":[{"year":2021,"value":2270442348.0},{"year":2022,"value":1470734973.0},{"year":2023,"value":1467159976.0},{"year":2024,"value":212585045.0}],"category":"Housing"},{"values":[{"year":2021,"value":186425205.0},{"year":2022,"value":492511520.0},{"year":2023,"value":490560290.0},{"year":2024,"value":190717153.0}],"category":"Other"},{"values":[{"year":2021,"value":2718724232.0},{"year":2022,"value":2180627135.0},{"year":2023,"value":2077147228.0},{"year":2024,"value":191933891.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":118870785.0},{"year":2022,"value":198304659.0},{"year":2023,"value":198304659.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":2484824071.0},{"year":2022,"value":812887494.0},{"year":2023,"value":812887494.0},{"year":2024,"value":587984.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":762363694.0},{"year":2022,"value":416800421.0},{"year":2023,"value":416800421.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":7082257884.0},{"year":2022,"value":7111348073.0},{"year":2023,"value":7111348073.0},{"year":2024,"value":46223561.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":"JHB"},"muni_contact":{"url":"http://Www.Joburg.Org.Za","phone_number":"011 407 6111","street_address_1":"Metro Centre","street_address_2":"158 Civic Boulevard Street","street_address_3":"Braamfontein","street_address_4":"2000"},"mayoral_staff":{"officials":[{"name":"Dada Morero","role":"Mayor/Executive Mayor","email":"executivemayor@joburg.org.za","title":"Mr","secretary":{"name":"Mpini Seleboge","role":"Secretary of Mayor/Executive Mayor","email":"mpinis@joburg.org.za","title":"Mrs","fax_number":" ","office_phone":" "},"fax_number":"011 628 4395","office_phone":"011 407 7309"},{"name":"Floyd Brink","role":"Municipal Manager","email":"citymanager@joburg.org.za","title":"Mr","secretary":{"name":"Nolukholo Ndinisa","role":"Secretary of Municipal Manager","email":"NolukholoN@joburg.org.za","title":"Ms","fax_number":"011 403 1012","office_phone":"011 407 7307"},"fax_number":" ","office_phone":"011 407 7309"},{"name":"","role":"Deputy Mayor/Executive Mayor","email":"","title":"","secretary":{"name":"","role":"Secretary of Deputy Mayor/Executive Mayor","email":"","title":"","fax_number":"","office_phone":""},"fax_number":"","office_phone":""},{"name":"Tebogo Moraka","role":"Chief Financial Officer","email":"tebogomor@joburg.org.za","title":"Mr","secretary":{"name":"Sindiswa Boxoza","role":"Secretary of Financial Manager","email":"SindiswaB@joburg.org.za","title":"Ms","fax_number":"011 530 2034","office_phone":"011 358 3109"},"fax_number":"011 628 4395","office_phone":"011 628 4612"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/JHB/JHB_Audit%20Report_2024_Y_20241211T163730Z_ntuthuzeloa.pdf"},{"date":2023,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/JHB/JHB_Audit%20Report_2023_Y_20231231T165632Z_ntuthuzeloa.pdf"},{"date":2022,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/JHB/JHB_Audit%20Report_2022_Y_20230113T143739Z_nselelon.pdf"},{"date":2021,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/JHB/JHB_Audit%20Report_2021_Y_20220523T092018Z_ntuthuzeloa.pdf"}]}}