{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":54622622.0,"national_conditional_grants":24088417.0},"ORGB":{"equitable_share":331821000.0,"national_conditional_grants":294994000.0},"SCHD":{"national_conditional_grants":220672000.0},"TRFR":{"national_conditional_grants":82777000.0}},"2022":{"ORGB":{"equitable_share":346639000.0,"national_conditional_grants":251560000.0},"SCHD":{"national_conditional_grants":224660000.0},"TRFR":{"national_conditional_grants":189024000.0}},"2023":{"ACT":{"national_conditional_grants":228579592.0},"ORGB":{"equitable_share":393139000.0,"provincial_transfers":56438000.0,"national_conditional_grants":376111000.0},"SCHD":{"national_conditional_grants":367153000.0},"TRFR":{"national_conditional_grants":209704000.0}},"2024":{"ACT":{"national_conditional_grants":276866827.0},"ORGB":{"equitable_share":435302000.0,"national_conditional_grants":246318000.0},"SCHD":{"national_conditional_grants":278918000.0},"TRFR":{"national_conditional_grants":277369000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":54622622.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":331821000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":346639000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":393139000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":435302000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":41766000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":14672000.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":1192000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1192000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":3600000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":600000.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":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":38284000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":10000000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1130061.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":38284000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":10000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":18239669.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":90534000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":43367000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":2000000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":600000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1500000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":2471000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":618000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1747000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":4718687.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":38460000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":15000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021}],"2022":[{"amount.sum":4000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":4000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":2200000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":2200000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":5385000.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":22800000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":22800000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":96442000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":96442000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":900000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":649000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":2933000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":2933000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":30000000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":60000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":60000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":4001670.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":4000000.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":4000000.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":2300001.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":2300000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":2300000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":66967000.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":31088999.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":31089000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":31089000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":107871512.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":104417000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":104417000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":482000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":3878000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":3878000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":3878000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":90000000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":79439410.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":64020000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":64020000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":4000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":4000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":4000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1963524.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":2300000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":2300000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1549000.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":58000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":58000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":58000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":135783795.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":136863000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":136863000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":4969429.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":5000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":5000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":2548000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":2548000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":2548000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":69602079.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":68658000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":68658000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024}]}},"cash_balance":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"good","result":4593885682.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":429638218.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":234863018.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":1704146664.0,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"}]},"result_type":"R"},"cash_coverage":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"good","result":17.3,"cube_version":"v2"},{"date":2023,"rating":"ave","result":1.8,"cube_version":"v2"},{"date":2022,"rating":"bad","result":1.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":8.8,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end / Operating Expenditure per month","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"},"/","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"/","12",")"]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end / Operating Expenditure per month","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"},"/","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"/","12",")"]},"result_type":"months"},"current_ratio":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"year":2024,"assets":1984587092.0,"rating":"bad","result":0.53,"amount_type":"AUDA","liabilities":3758892975.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":1816005695.0,"rating":"bad","result":0.51,"amount_type":"AUDA","liabilities":3581837176.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":1463494979.0,"rating":"bad","result":0.52,"amount_type":"AUDA","liabilities":2827508324.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":1354703497.0,"rating":"bad","result":0.53,"amount_type":"AUDA","liabilities":2566531922.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":177495294.0,"date":"2024","year":2024,"rating":"bad","result":0.05,"amount_type":"ACT","liabilities":3758892975.0,"cube_version":"v2","call_investment_deposits":0},{"cash":255484947.0,"date":"2023","year":2023,"rating":"bad","result":0.07,"amount_type":"ACT","liabilities":3581837176.0,"cube_version":"v2","call_investment_deposits":0},{"cash":110997632.0,"date":"2022","year":2022,"rating":"bad","result":0.04,"amount_type":"ACT","liabilities":2827508324.0,"cube_version":"v2","call_investment_deposits":0},{"cash":90968439.0,"date":"2021","year":2021,"rating":"bad","result":0.04,"amount_type":"ACT","liabilities":2566531922.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":2332787579.0,"percent":82.0},"total":2844787855.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":512000276.0,"percent":18.0}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":23.4,"cube_version":"v2"},{"date":2023,"rating":"bad","result":15.65,"cube_version":"v2"},{"date":2022,"rating":"bad","result":29.1,"cube_version":"v2"},{"date":2021,"rating":"bad","result":18.31,"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":228799.0,"comparison":"Original to adjusted budget","percent_changed":1.56},{"item":"Fines","amount":6169759.0,"comparison":"Original budget to audited outcome","percent_changed":41.93},{"item":"Government Transfers","amount":8499995.0,"comparison":"Original to adjusted budget","percent_changed":2.02},{"item":"Government Transfers","amount":-3034426.0,"comparison":"Original budget to audited outcome","percent_changed":-0.72},{"item":"Interest and investments","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":6963808.0,"comparison":"Original budget to audited outcome","percent_changed":14.19},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-2501.0,"comparison":"Original budget to audited outcome","percent_changed":-2.99},{"item":"Other","amount":-1862022.0,"comparison":"Original to adjusted budget","percent_changed":-3.71},{"item":"Other","amount":-25222358.0,"comparison":"Original budget to audited outcome","percent_changed":-50.23},{"item":"Property rates","amount":36578305.0,"comparison":"Original to adjusted budget","percent_changed":14.62},{"item":"Property rates","amount":24802865.0,"comparison":"Original budget to audited outcome","percent_changed":9.91},{"item":"Rental income","amount":-459923.0,"comparison":"Original to adjusted budget","percent_changed":-28.26},{"item":"Rental income","amount":2917651.0,"comparison":"Original budget to audited outcome","percent_changed":179.28},{"item":"Service Charges","amount":14861049.0,"comparison":"Original to adjusted budget","percent_changed":1.23},{"item":"Service Charges","amount":-15647707.0,"comparison":"Original budget to audited outcome","percent_changed":-1.3}],"2022":[{"item":"Fines","amount":-6000000.0,"comparison":"Original to adjusted budget","percent_changed":-36.51},{"item":"Fines","amount":-1163937.0,"comparison":"Original budget to audited outcome","percent_changed":-7.08},{"item":"Government Transfers","amount":643000.0,"comparison":"Original to adjusted budget","percent_changed":0.16},{"item":"Government Transfers","amount":-2913536.0,"comparison":"Original budget to audited outcome","percent_changed":-0.74},{"item":"Interest and investments","amount":5000000.0,"comparison":"Original to adjusted budget","percent_changed":8.25},{"item":"Interest and investments","amount":1917804.0,"comparison":"Original budget to audited outcome","percent_changed":3.16},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-42920.0,"comparison":"Original budget to audited outcome","percent_changed":-46.68},{"item":"Other","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Other","amount":-124264459.0,"comparison":"Original budget to audited outcome","percent_changed":-235.17},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":18576404.0,"comparison":"Original budget to audited outcome","percent_changed":5.59},{"item":"Rental income","amount":1000000.0,"comparison":"Original to adjusted budget","percent_changed":77.87},{"item":"Rental income","amount":2291391.0,"comparison":"Original budget to audited outcome","percent_changed":178.42},{"item":"Service Charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":-54351393.0,"comparison":"Original budget to audited outcome","percent_changed":-4.08}],"2023":[{"item":"Fines","amount":9016640.0,"comparison":"Original to adjusted budget","percent_changed":78.54},{"item":"Fines","amount":5953055.0,"comparison":"Original budget to audited outcome","percent_changed":51.86},{"item":"Government Transfers","amount":473215.0,"comparison":"Original to adjusted budget","percent_changed":0.11},{"item":"Government Transfers","amount":3909852.0,"comparison":"Original budget to audited outcome","percent_changed":0.88},{"item":"Interest and investments","amount":5397029.0,"comparison":"Original to adjusted budget","percent_changed":7.48},{"item":"Interest and investments","amount":25074382.0,"comparison":"Original budget to audited outcome","percent_changed":34.74},{"item":"Licenses and Permits","amount":-40871.0,"comparison":"Original to adjusted budget","percent_changed":-40.38},{"item":"Licenses and Permits","amount":-38059.0,"comparison":"Original budget to audited outcome","percent_changed":-37.6},{"item":"Other","amount":8337244.0,"comparison":"Original to adjusted budget","percent_changed":14.65},{"item":"Other","amount":-69330591.0,"comparison":"Original budget to audited outcome","percent_changed":-121.81},{"item":"Property rates","amount":24731841.0,"comparison":"Original to adjusted budget","percent_changed":7.03},{"item":"Property rates","amount":16608364.0,"comparison":"Original budget to audited outcome","percent_changed":4.72},{"item":"Rental income","amount":524857.0,"comparison":"Original to adjusted budget","percent_changed":20.89},{"item":"Rental income","amount":436024.0,"comparison":"Original budget to audited outcome","percent_changed":17.35},{"item":"Service Charges","amount":20077786.0,"comparison":"Original to adjusted budget","percent_changed":1.39},{"item":"Service Charges","amount":-65011768.0,"comparison":"Original budget to audited outcome","percent_changed":-4.49}],"2024":[{"item":"Fines","amount":-5000394.0,"comparison":"Original to adjusted budget","percent_changed":-22.18},{"item":"Fines","amount":-9020583.0,"comparison":"Original budget to audited outcome","percent_changed":-40.01},{"item":"Government Transfers","amount":42308279.0,"comparison":"Original to adjusted budget","percent_changed":8.69},{"item":"Government Transfers","amount":25218284.0,"comparison":"Original budget to audited outcome","percent_changed":5.18},{"item":"Interest and investments","amount":5759225.0,"comparison":"Original to adjusted budget","percent_changed":5.88},{"item":"Interest and investments","amount":27604357.0,"comparison":"Original budget to audited outcome","percent_changed":28.21},{"item":"Licenses and Permits","amount":274398.0,"comparison":"Original to adjusted budget","percent_changed":413.44},{"item":"Licenses and Permits","amount":174390.0,"comparison":"Original budget to audited outcome","percent_changed":262.75},{"item":"Other","amount":-9480190.0,"comparison":"Original to adjusted budget","percent_changed":-2.05},{"item":"Other","amount":363540444.0,"comparison":"Original budget to audited outcome","percent_changed":78.8},{"item":"Property rates","amount":-22857001.0,"comparison":"Original to adjusted budget","percent_changed":-5.75},{"item":"Property rates","amount":-17825445.0,"comparison":"Original budget to audited outcome","percent_changed":-4.48},{"item":"Rental income","amount":1413058.0,"comparison":"Original to adjusted budget","percent_changed":42.29},{"item":"Rental income","amount":263138.0,"comparison":"Original budget to audited outcome","percent_changed":7.88},{"item":"Service Charges","amount":-20535990.0,"comparison":"Original to adjusted budget","percent_changed":-1.63},{"item":"Service Charges","amount":-272427631.0,"comparison":"Original budget to audited outcome","percent_changed":-21.66}]},"income_time_series":[{"amount":2051525112.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":2187593955.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":2459357049.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":2719142286.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":1990626000.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":2027000309.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":2308440567.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":2844787855.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":2922408528.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":3171670328.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":3446909931.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":1993678909.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":2186950955.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":2390839308.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":2727260901.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":2926392097.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":109456811.0,"comparison":"Original budget to audited outcome","percent_changed":19.69},{"item":"Contracted services","amount":5669429.0,"comparison":"Original to adjusted budget","percent_changed":3.91},{"item":"Contracted services","amount":-1890555.0,"comparison":"Original budget to audited outcome","percent_changed":-1.31},{"item":"Employee related costs","amount":-12058347.0,"comparison":"Original to adjusted budget","percent_changed":-2.11},{"item":"Employee related costs","amount":-8000270.0,"comparison":"Original budget to audited outcome","percent_changed":-1.4},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":23750008.0,"comparison":"Original budget to audited outcome","percent_changed":55.21},{"item":"Other","amount":63941766.0,"comparison":"Original to adjusted budget","percent_changed":8.65},{"item":"Other","amount":122171663.0,"comparison":"Original budget to audited outcome","percent_changed":16.54},{"item":"Remuneration of councillors","amount":-1700000.0,"comparison":"Original to adjusted budget","percent_changed":-5.72},{"item":"Remuneration of councillors","amount":-1516568.0,"comparison":"Original budget to audited outcome","percent_changed":-5.1}],"2023":[{"item":"Bulk purchases","amount":201533322.0,"comparison":"Original to adjusted budget","percent_changed":31.2},{"item":"Bulk purchases","amount":151000461.0,"comparison":"Original budget to audited outcome","percent_changed":23.38},{"item":"Contracted services","amount":-71823445.0,"comparison":"Original to adjusted budget","percent_changed":-46.23},{"item":"Contracted services","amount":15377312.0,"comparison":"Original budget to audited outcome","percent_changed":9.9},{"item":"Employee related costs","amount":-13750804.0,"comparison":"Original to adjusted budget","percent_changed":-2.29},{"item":"Employee related costs","amount":-49577284.0,"comparison":"Original budget to audited outcome","percent_changed":-8.27},{"item":"Finance charges","amount":1070322.0,"comparison":"Original to adjusted budget","percent_changed":2.28},{"item":"Finance charges","amount":88696428.0,"comparison":"Original budget to audited outcome","percent_changed":189.2},{"item":"Other","amount":-49224087.0,"comparison":"Original to adjusted budget","percent_changed":-5.39},{"item":"Other","amount":186590696.0,"comparison":"Original budget to audited outcome","percent_changed":20.44},{"item":"Remuneration of councillors","amount":-44.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":4843161.0,"comparison":"Original budget to audited outcome","percent_changed":16.62},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original budget to audited outcome","percent_changed":0.0}],"2024":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-52870065.0,"comparison":"Original budget to audited outcome","percent_changed":-5.25},{"item":"Contracted services","amount":10000001.0,"comparison":"Original to adjusted budget","percent_changed":6.37},{"item":"Contracted services","amount":38072800.0,"comparison":"Original budget to audited outcome","percent_changed":24.27},{"item":"Employee related costs","amount":-249.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Employee related costs","amount":-12608514.0,"comparison":"Original budget to audited outcome","percent_changed":-2.12},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":42241100.0,"comparison":"Original budget to audited outcome","percent_changed":80.09},{"item":"Other","amount":-18667495.0,"comparison":"Original to adjusted budget","percent_changed":-2.11},{"item":"Other","amount":447349638.0,"comparison":"Original budget to audited outcome","percent_changed":50.57},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":4246988.0,"comparison":"Original budget to audited outcome","percent_changed":13.9},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Transfers and subsidies","amount":-72000.0,"comparison":"Original budget to audited outcome","percent_changed":-9.09}]},"spending_time_series":[{"amount":2138525744.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":2187509371.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":2458343893.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":2717953065.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":2326643985.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":2730176251.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":2787469403.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":3192980755.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":3652068151.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":3163550118.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":3416258240.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":2082672896.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":2186566793.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":2390538629.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":2726620808.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":2926016919.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":203.26,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"good","result":2.11,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"bad","result":113.58,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"bad","result":-33.77,"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":379962762.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":985106956.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":3604448.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":125470407.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":13525339.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":240760.0,"amount_type":"AUDA"},{"date":"2024","item":"Agency services","amount":22020876.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":802856031.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":18.22},{"date":2023,"rating":"","result":19.73},{"date":2022,"rating":"","result":20.3},{"date":2021,"rating":"","result":24.17}],"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":"bad","result":17.5,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"ave","result":13.4,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"bad","result":24.8,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"ave","result":8.8,"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.43,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0.98,"cube_version":"v2"},{"date":2022,"rating":"bad","result":1.8,"cube_version":"v2"},{"date":2021,"rating":"bad","result":1.47,"cube_version":"v2"}],"formula":{"text":"= (Repairs and maintenance expenditure / (Property, Plant and Equipment + Investment Property)) * 100","actual":["=","(",{"cube":"capital","item_codes":["4100"],"amount_type":"AUDA"},"/","(",{"cube":"bsheet","item_codes":["1300"],"amount_type":"AUDA"},"+",{"cube":"bsheet","item_codes":["1401"],"amount_type":"AUDA"},")",")","*","100"]},"last_year":2024,"formula_v2":{"text":"= (Repairs and maintenance expenditure / (Property, Plant and Equipment + Investment Property)) * 100","actual":["=","(",{"cube":"capital_v2","amount_type":"AUDA","item_description":"capital type code REPAIR_MNT Total"},"/","(",{"cube":"financial_position_v2","item_codes":["0230","0220"],"amount_type":"AUDA"},")",")","*","100"]},"result_type":"%"},"expenditure_trends_contracting":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"date":2024,"rating":"","result":6.11},{"date":2023,"rating":"","result":6.13},{"date":2022,"rating":"","result":6.9},{"date":2021,"rating":"","result":6.14}],"formula":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp","item_codes":["4200"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp_v2","item_codes":["3800"],"amount_type":"AUDA"}]},"result_type":"%"},"current_debtors_collection_rate":{"ref":{"url":"http://mfma.treasury.gov.za/RegulationsandGazettes/Municipal%20Budget%20and%20Reporting%20Regulations/Pages/default.aspx","title":"Municipal Budget and Reporting Regulations"},"values":[{"date":"2024","year":2024,"rating":"good","result":236.24,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"bad","result":69.5,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"bad","result":26.63,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"bad","result":23.95,"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":97745723.0},{"year":2022,"value":106174715.0},{"year":2023,"value":111642077.0},{"year":2024,"value":118826699.0},{"year":2025,"value":126519835.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":728780185.0},{"year":2022,"value":891741503.0},{"year":2023,"value":1141212024.0},{"year":2024,"value":1015778693.0},{"year":2025,"value":1239045081.0}],"category":"Electricity "},{"values":[{"year":2021,"value":11505.0},{"year":2022,"value":24443.0},{"year":2024,"value":699890.0},{"year":2025,"value":910735.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":783067425.0},{"year":2022,"value":1150162715.0},{"year":2023,"value":598825156.0},{"year":2024,"value":884056864.0},{"year":2025,"value":1826352313.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":10684712.0},{"year":2022,"value":11270146.0},{"year":2023,"value":11817723.0},{"year":2024,"value":12734566.0},{"year":2025,"value":7652101.0}],"category":"Health"},{"values":[{"year":2021,"value":6005614.0},{"year":2022,"value":2856884.0},{"year":2023,"value":2110106.0},{"year":2024,"value":1283548.0},{"year":2025,"value":2678110.0}],"category":"Housing"},{"values":[{"year":2021,"value":209981243.0},{"year":2022,"value":46153566.0},{"year":2023,"value":25845065.0},{"year":2024,"value":29202997.0},{"year":2025,"value":55893683.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":18158640.0},{"year":2022,"value":36063851.0},{"year":2023,"value":35038692.0},{"year":2024,"value":36082045.0},{"year":2025,"value":38417813.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":99753519.0},{"year":2022,"value":93990620.0},{"year":2023,"value":243969411.0},{"year":2024,"value":360543788.0},{"year":2025,"value":-56149873.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":71297709.0},{"year":2022,"value":70695966.0},{"year":2023,"value":78976495.0},{"year":2024,"value":59956298.0},{"year":2025,"value":98492194.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":301157710.0},{"year":2022,"value":321041842.0},{"year":2023,"value":538032654.0},{"year":2024,"value":673815367.0},{"year":2025,"value":312256159.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":"GT485"},"muni_contact":{"url":"http://www.randwestcity.gov.za","phone_number":"010 496 5632","street_address_1":"Rand West City Local Municipality","street_address_2":"Cnr Sutherland Streets & Pollock Street","street_address_3":"Randfontein","street_address_4":"1760"},"mayoral_staff":{"officials":[{"name":"William Matsheke","role":"Mayor/Executive Mayor","email":"william.matsheke@randwestcity.gov.za","title":"Mr","secretary":{"name":"Vivian Liau","role":"Secretary of Mayor/Executive Mayor","email":"vivian.liau@randwestcity.gov.za","title":"Ms","fax_number":"011 693 1736","office_phone":"010 496 5569"},"fax_number":"011 693 1736","office_phone":"010 496 5569"},{"name":"Thabo Ndlovu","role":"Municipal Manager","email":"thabo.ndlovu@randwestcity.gov.za","title":"Mr","secretary":{"name":"Nomsa Shilubane","role":"Secretary of Municipal Manager","email":"nomsa.shilubane@randwestcity.gov.za","title":"Ms","fax_number":" ","office_phone":"010 496 5551"},"fax_number":" ","office_phone":"010 496 5551"},{"name":"Nontombi Molatlhegi","role":"Deputy Mayor/Executive Mayor","email":"nontombi.molatlhegi@randwestcity.gov.za","title":"Ms","secretary":{"name":"Chris Stoffels","role":"Secretary of Deputy Mayor/Executive Mayor","email":"chris.stoffels@randwestcity.gov.za","title":"Mr","fax_number":" ","office_phone":" "},"fax_number":" ","office_phone":" "},{"name":"Xolani Malindi","role":"Chief Financial Officer","email":"xolani.malindi@randwestcity.gov.za","title":"Mr","secretary":{"name":"Lisa Van Dyk","role":"Secretary of Financial Manager","email":"lisa.vandyk@randwestcity.gov.za","title":"Ms","fax_number":"011 693 1394","office_phone":"011 411 0086"},"fax_number":"011 693 1736","office_phone":"010 496 5552"}],"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/GT485/GT485_Audit%20Report_2024_Y_20250123T083358Z_itumeleng_mogalobe.pdf"},{"date":2023,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/GT485/GT485_Audit%20Report_2023_Y_20231215T091912Z_itumeleng_mogalobe.pdf"},{"date":2022,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/GT485/GT485_Audit%20Report_2022_Y_20221208T083556Z_sandile_nxumalo.pdf"},{"date":2021,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/GT485/GT485_Audit%20Report_2021_Y_20220421T134015Z_sandile_nxumalo.pdf"}]}}