{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":4676436.0,"national_conditional_grants":1946994.0},"ORGB":{"equitable_share":202505000.0,"national_conditional_grants":151003000.0},"SCHD":{"national_conditional_grants":125791000.0},"TRFR":{"national_conditional_grants":29681000.0}},"2022":{"ACT":{"national_conditional_grants":87509603.0},"ORGB":{"equitable_share":214398000.0,"national_conditional_grants":138757000.0},"SCHD":{"national_conditional_grants":155757000.0},"TRFR":{"national_conditional_grants":98757000.0}},"2023":{"ACT":{"national_conditional_grants":117144660.0},"ORGB":{"equitable_share":246748000.0,"provincial_transfers":12167000.0,"national_conditional_grants":163249000.0},"SCHD":{"national_conditional_grants":158016000.0},"TRFR":{"national_conditional_grants":107843000.0}},"2024":{"ACT":{"national_conditional_grants":104676666.0},"ORGB":{"equitable_share":276178000.0,"national_conditional_grants":117555000.0},"SCHD":{"national_conditional_grants":110462000.0},"TRFR":{"national_conditional_grants":99496000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":4676436.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":202505000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":214398000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":246748000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":276178000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":12167000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023}]},"national_conditional_grants":{"2021":[{"amount.sum":298000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":298000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":242037.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":2500000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":2500000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":5000000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":389576.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":5000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":922370.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":44366000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":14801000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":2300000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":393011.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1327000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":332000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":40000000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":25000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":11750000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021}],"2022":[{"amount.sum":1166395.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":2650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":2650000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":6635510.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":30400000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":30400000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":22448291.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":47085000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":47085000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1016767.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":1622000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1622000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":57000000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":47434044.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":8808596.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":17000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":17000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":3301062.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":2750000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":2750000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":173000.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":31052139.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":35631000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":35631000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":46202334.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":50756000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":50756000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":931582.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1523000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1523000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":50000000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":28655560.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":7001983.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":17183000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":17183000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":1000000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1000000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":170571.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":2750000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":2750000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1966000.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":27383124.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":29780000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":29780000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":55285948.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":49399000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":49399000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":741388.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":950000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":950000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":9000000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":21095635.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":15617000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":15617000.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":218519122.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":21421519.0,"cube_version":"v2"},{"date":2022,"rating":"bad","result":-172450744.0,"cube_version":"v2"},{"date":2021,"rating":"bad","result":-337630627.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":"ave","result":1.5,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0.2,"cube_version":"v2"},{"date":2022,"rating":"bad","result":0,"cube_version":"v2"},{"date":2021,"rating":"bad","result":0,"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":537738110.0,"rating":"ave","result":1.04,"amount_type":"AUDA","liabilities":514639761.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":1321420932.0,"rating":"ave","result":1.06,"amount_type":"AUDA","liabilities":1246619185.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":1483009362.0,"rating":"ave","result":1.15,"amount_type":"AUDA","liabilities":1288039430.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":1318294521.0,"rating":"ave","result":1.14,"amount_type":"AUDA","liabilities":1158574819.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":125592941.0,"date":"2024","year":2024,"rating":"bad","result":0.24,"amount_type":"ACT","liabilities":514639761.0,"cube_version":"v2","call_investment_deposits":0},{"cash":163391090.0,"date":"2023","year":2023,"rating":"bad","result":0.13,"amount_type":"ACT","liabilities":1246619185.0,"cube_version":"v2","call_investment_deposits":0},{"cash":117479060.0,"date":"2022","year":2022,"rating":"bad","result":0.09,"amount_type":"ACT","liabilities":1288039430.0,"cube_version":"v2","call_investment_deposits":0},{"cash":50975283.0,"date":"2021","year":2021,"rating":"bad","result":0.04,"amount_type":"ACT","liabilities":1158574819.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":1423295130.0,"percent":83.54},"total":1703703259.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":280408129.0,"percent":16.46}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":13.07,"cube_version":"v2"},{"date":2023,"rating":"bad","result":7.11,"cube_version":"v2"},{"date":2022,"rating":"bad","result":13.23,"cube_version":"v2"},{"date":2021,"rating":"bad","result":7.23,"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":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":-6112893.0,"comparison":"Original budget to audited outcome","percent_changed":-58.66},{"item":"Government Transfers","amount":33000960.0,"comparison":"Original to adjusted budget","percent_changed":15.79},{"item":"Government Transfers","amount":36235604.0,"comparison":"Original budget to audited outcome","percent_changed":17.34},{"item":"Interest and investments","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":937338.0,"comparison":"Original budget to audited outcome","percent_changed":2.27},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-200960.0,"comparison":"Original budget to audited outcome","percent_changed":-95.27},{"item":"Other","amount":490000.0,"comparison":"Original to adjusted budget","percent_changed":2.2},{"item":"Other","amount":-12399391.0,"comparison":"Original budget to audited outcome","percent_changed":-55.77},{"item":"Property rates","amount":-2288280.0,"comparison":"Original to adjusted budget","percent_changed":-1.09},{"item":"Property rates","amount":3482343.0,"comparison":"Original budget to audited outcome","percent_changed":1.65},{"item":"Rental income","amount":-38310.0,"comparison":"Original to adjusted budget","percent_changed":-0.61},{"item":"Rental income","amount":-371827.0,"comparison":"Original budget to audited outcome","percent_changed":-5.91},{"item":"Service Charges","amount":-6708710.0,"comparison":"Original to adjusted budget","percent_changed":-0.74},{"item":"Service Charges","amount":-109053153.0,"comparison":"Original budget to audited outcome","percent_changed":-12.03}],"2022":[{"item":"Fines","amount":-1000000.0,"comparison":"Original to adjusted budget","percent_changed":-8.62},{"item":"Fines","amount":-7315282.0,"comparison":"Original budget to audited outcome","percent_changed":-63.06},{"item":"Government Transfers","amount":1000000.0,"comparison":"Original to adjusted budget","percent_changed":0.45},{"item":"Government Transfers","amount":15206195.0,"comparison":"Original budget to audited outcome","percent_changed":6.88},{"item":"Interest and investments","amount":13800000.0,"comparison":"Original to adjusted budget","percent_changed":30.53},{"item":"Interest and investments","amount":21305964.0,"comparison":"Original budget to audited outcome","percent_changed":47.14},{"item":"Licenses and Permits","amount":-50000.0,"comparison":"Original to adjusted budget","percent_changed":-50.0},{"item":"Licenses and Permits","amount":-85350.0,"comparison":"Original budget to audited outcome","percent_changed":-85.35},{"item":"Other","amount":-960600.0,"comparison":"Original to adjusted budget","percent_changed":-4.26},{"item":"Other","amount":2574995.0,"comparison":"Original budget to audited outcome","percent_changed":11.41},{"item":"Property rates","amount":1977440.0,"comparison":"Original to adjusted budget","percent_changed":0.94},{"item":"Property rates","amount":1190609.0,"comparison":"Original budget to audited outcome","percent_changed":0.57},{"item":"Rental income","amount":425600.0,"comparison":"Original to adjusted budget","percent_changed":6.85},{"item":"Rental income","amount":474588.0,"comparison":"Original budget to audited outcome","percent_changed":7.63},{"item":"Service Charges","amount":27416425.0,"comparison":"Original to adjusted budget","percent_changed":2.79},{"item":"Service Charges","amount":-103727785.0,"comparison":"Original budget to audited outcome","percent_changed":-10.54}],"2023":[{"item":"Fines","amount":-9520000.0,"comparison":"Original to adjusted budget","percent_changed":-70.0},{"item":"Fines","amount":-10702263.0,"comparison":"Original budget to audited outcome","percent_changed":-78.69},{"item":"Government Transfers","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Government Transfers","amount":-1841175.0,"comparison":"Original budget to audited outcome","percent_changed":-0.72},{"item":"Interest and investments","amount":1800000.0,"comparison":"Original to adjusted budget","percent_changed":3.24},{"item":"Interest and investments","amount":58700909.0,"comparison":"Original budget to audited outcome","percent_changed":105.77},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-98020.0,"comparison":"Original budget to audited outcome","percent_changed":-93.35},{"item":"Other","amount":-18130000.0,"comparison":"Original to adjusted budget","percent_changed":-57.1},{"item":"Other","amount":-10430641.0,"comparison":"Original budget to audited outcome","percent_changed":-32.85},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":16997197.0,"comparison":"Original budget to audited outcome","percent_changed":8.75},{"item":"Rental income","amount":252000.0,"comparison":"Original to adjusted budget","percent_changed":3.99},{"item":"Rental income","amount":195880.0,"comparison":"Original budget to audited outcome","percent_changed":3.1},{"item":"Service Charges","amount":-87208650.0,"comparison":"Original to adjusted budget","percent_changed":-7.8},{"item":"Service Charges","amount":-242320121.0,"comparison":"Original budget to audited outcome","percent_changed":-21.68}],"2024":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":-1133543.0,"comparison":"Original budget to audited outcome","percent_changed":-26.38},{"item":"Government Transfers","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Government Transfers","amount":-2616871.0,"comparison":"Original budget to audited outcome","percent_changed":-0.92},{"item":"Interest and investments","amount":179282250.0,"comparison":"Original to adjusted budget","percent_changed":295.87},{"item":"Interest and investments","amount":87527344.0,"comparison":"Original budget to audited outcome","percent_changed":144.45},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-106055.0,"comparison":"Original budget to audited outcome","percent_changed":-95.65},{"item":"Other","amount":1912910.0,"comparison":"Original to adjusted budget","percent_changed":7.17},{"item":"Other","amount":-15623909.0,"comparison":"Original budget to audited outcome","percent_changed":-58.54},{"item":"Property rates","amount":-12885670.0,"comparison":"Original to adjusted budget","percent_changed":-5.5},{"item":"Property rates","amount":-12840900.0,"comparison":"Original budget to audited outcome","percent_changed":-5.48},{"item":"Rental income","amount":1000000.0,"comparison":"Original to adjusted budget","percent_changed":14.45},{"item":"Rental income","amount":-89452.0,"comparison":"Original budget to audited outcome","percent_changed":-1.29},{"item":"Service Charges","amount":-12058085.0,"comparison":"Original to adjusted budget","percent_changed":-1.03},{"item":"Service Charges","amount":-141237225.0,"comparison":"Original budget to audited outcome","percent_changed":-12.03}]},"income_time_series":[{"amount":1430987660.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":1543266295.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":1560777980.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":1947075275.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":1319049061.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":1430281364.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":1484086396.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":1703703259.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":1757589321.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":2265364180.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":2367286410.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":1406532000.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":1500657430.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":1673584630.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":1789823870.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":2156120360.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":832511.0,"comparison":"Original budget to audited outcome","percent_changed":0.27},{"item":"Contracted services","amount":-7719200.0,"comparison":"Original to adjusted budget","percent_changed":-6.69},{"item":"Contracted services","amount":-41518266.0,"comparison":"Original budget to audited outcome","percent_changed":-36.0},{"item":"Employee related costs","amount":-6553530.0,"comparison":"Original to adjusted budget","percent_changed":-1.73},{"item":"Employee related costs","amount":-47724331.0,"comparison":"Original budget to audited outcome","percent_changed":-12.57},{"item":"Finance charges","amount":-1830950.0,"comparison":"Original to adjusted budget","percent_changed":-35.37},{"item":"Finance charges","amount":-4417743.0,"comparison":"Original budget to audited outcome","percent_changed":-85.34},{"item":"Other","amount":41881980.0,"comparison":"Original to adjusted budget","percent_changed":7.32},{"item":"Other","amount":-54948323.0,"comparison":"Original budget to audited outcome","percent_changed":-9.61},{"item":"Remuneration of councillors","amount":359560.0,"comparison":"Original to adjusted budget","percent_changed":1.71},{"item":"Remuneration of councillors","amount":-1667123.0,"comparison":"Original budget to audited outcome","percent_changed":-7.92},{"item":"Transfers and subsidies","amount":220000.0,"comparison":"Original to adjusted budget","percent_changed":62.58},{"item":"Transfers and subsidies","amount":-253855.0,"comparison":"Original budget to audited outcome","percent_changed":-72.21}],"2022":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-1206402.0,"comparison":"Original budget to audited outcome","percent_changed":-0.36},{"item":"Contracted services","amount":-5722270.0,"comparison":"Original to adjusted budget","percent_changed":-5.28},{"item":"Contracted services","amount":-33747940.0,"comparison":"Original budget to audited outcome","percent_changed":-31.13},{"item":"Employee related costs","amount":6251700.0,"comparison":"Original to adjusted budget","percent_changed":1.55},{"item":"Employee related costs","amount":-68760832.0,"comparison":"Original budget to audited outcome","percent_changed":-17.0},{"item":"Finance charges","amount":332500.0,"comparison":"Original to adjusted budget","percent_changed":8.05},{"item":"Finance charges","amount":5221261.0,"comparison":"Original budget to audited outcome","percent_changed":126.34},{"item":"Other","amount":29115860.0,"comparison":"Original to adjusted budget","percent_changed":4.66},{"item":"Other","amount":76659012.0,"comparison":"Original budget to audited outcome","percent_changed":12.28},{"item":"Remuneration of councillors","amount":270.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-3331911.0,"comparison":"Original budget to audited outcome","percent_changed":-14.67},{"item":"Transfers and subsidies","amount":10000.0,"comparison":"Original to adjusted budget","percent_changed":2.69},{"item":"Transfers and subsidies","amount":-37550.0,"comparison":"Original budget to audited outcome","percent_changed":-10.11}],"2023":[{"item":"Bulk purchases","amount":-9500000.0,"comparison":"Original to adjusted budget","percent_changed":-2.62},{"item":"Bulk purchases","amount":-24530700.0,"comparison":"Original budget to audited outcome","percent_changed":-6.75},{"item":"Contracted services","amount":-24125680.0,"comparison":"Original to adjusted budget","percent_changed":-20.23},{"item":"Contracted services","amount":-43792491.0,"comparison":"Original budget to audited outcome","percent_changed":-36.73},{"item":"Employee related costs","amount":-35650760.0,"comparison":"Original to adjusted budget","percent_changed":-8.2},{"item":"Employee related costs","amount":-91786993.0,"comparison":"Original budget to audited outcome","percent_changed":-21.11},{"item":"Finance charges","amount":-5367000.0,"comparison":"Original to adjusted budget","percent_changed":-92.28},{"item":"Finance charges","amount":7452588.0,"comparison":"Original budget to audited outcome","percent_changed":128.14},{"item":"Other","amount":-7369390.0,"comparison":"Original to adjusted budget","percent_changed":-1.05},{"item":"Other","amount":89206910.0,"comparison":"Original budget to audited outcome","percent_changed":12.7},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-922580.0,"comparison":"Original budget to audited outcome","percent_changed":-4.42},{"item":"Transfers and subsidies","amount":49000.0,"comparison":"Original to adjusted budget","percent_changed":12.98},{"item":"Transfers and subsidies","amount":-120840.0,"comparison":"Original budget to audited outcome","percent_changed":-32.0}],"2024":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-6757968.0,"comparison":"Original budget to audited outcome","percent_changed":-1.67},{"item":"Contracted services","amount":14994475.0,"comparison":"Original to adjusted budget","percent_changed":12.36},{"item":"Contracted services","amount":-1932263.0,"comparison":"Original budget to audited outcome","percent_changed":-1.59},{"item":"Employee related costs","amount":4940900.0,"comparison":"Original to adjusted budget","percent_changed":1.1},{"item":"Employee related costs","amount":-55908123.0,"comparison":"Original budget to audited outcome","percent_changed":-12.41},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":11525915.0,"comparison":"Original budget to audited outcome","percent_changed":213.81},{"item":"Other","amount":9044850.0,"comparison":"Original to adjusted budget","percent_changed":1.24},{"item":"Other","amount":129326011.0,"comparison":"Original budget to audited outcome","percent_changed":17.77},{"item":"Remuneration of councillors","amount":4628030.0,"comparison":"Original to adjusted budget","percent_changed":21.32},{"item":"Remuneration of councillors","amount":768781.0,"comparison":"Original budget to audited outcome","percent_changed":3.54},{"item":"Transfers and subsidies","amount":408000.0,"comparison":"Original to adjusted budget","percent_changed":107.65},{"item":"Transfers and subsidies","amount":-88971.0,"comparison":"Original budget to audited outcome","percent_changed":-23.48}]},"spending_time_series":[{"amount":1430904800.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":1529182502.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":1564964560.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":1764899095.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":1254849810.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":1473990080.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":1582434284.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":1807816222.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":1697384627.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":2016544458.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":1999737328.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":1404546940.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":1499194442.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":1646928390.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":1730882840.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":1844405948.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":-48.58,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"bad","result":-41.83,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"bad","result":-45.67,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"bad","result":-79.76,"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":221435560.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":1032673435.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":6829508.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":148122574.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":3162697.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":4825.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":11066531.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":21.83},{"date":2023,"rating":"","result":21.68},{"date":2022,"rating":"","result":22.77},{"date":2021,"rating":"","result":26.46}],"formula":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp","item_codes":["3000","3100"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp_v2","item_codes":["3100"],"amount_type":"AUDA"}]},"result_type":"%"},"operating_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2024,"rating":"good","result":2.4,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"good","result":1.1,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"good","result":-3.6,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"ave","result":-12.3,"overunder":"under","cube_version":"v2"}],"formula":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"-",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","/",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"-",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","*","100"]},"result_type":"%"},"repairs_maintenance_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":2.4,"cube_version":"v2"},{"date":2023,"rating":"bad","result":1.81,"cube_version":"v2"},{"date":2022,"rating":"bad","result":3.36,"cube_version":"v2"},{"date":2021,"rating":"bad","result":1.59,"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.61},{"date":2023,"rating":"","result":4.77},{"date":2022,"rating":"","result":5.06},{"date":2021,"rating":"","result":5.88}],"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":47.95,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"bad","result":53.39,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"good","result":98.14,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"good","result":95.19,"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":52750074.0},{"year":2022,"value":53405052.0},{"year":2023,"value":53300502.0},{"year":2024,"value":59645738.0},{"year":2025,"value":67992823.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":348807932.0},{"year":2022,"value":414237060.0},{"year":2023,"value":423133286.0},{"year":2024,"value":491605537.0},{"year":2025,"value":511194992.0}],"category":"Electricity "},{"values":[{"year":2021,"value":284848080.0},{"year":2022,"value":250118204.0},{"year":2023,"value":274530186.0},{"year":2024,"value":371697658.0},{"year":2025,"value":364109665.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":-5706648.0},{"year":2022,"value":69852523.0},{"year":2023,"value":75775604.0},{"year":2024,"value":44497418.0},{"year":2025,"value":11210708.0}],"category":"Housing"},{"values":[{"year":2021,"value":2534937.0},{"year":2022,"value":3862498.0},{"year":2023,"value":3762885.0},{"year":2024,"value":3647481.0},{"year":2025,"value":3790943.0}],"category":"Other"},{"values":[{"year":2021,"value":53500906.0},{"year":2022,"value":52091851.0},{"year":2023,"value":58200642.0},{"year":2024,"value":56064838.0},{"year":2025,"value":40306482.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":33383202.0},{"year":2022,"value":33638684.0},{"year":2023,"value":33317609.0},{"year":2024,"value":37972860.0},{"year":2025,"value":64988935.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":44598838.0},{"year":2022,"value":69126219.0},{"year":2023,"value":90250452.0},{"year":2024,"value":97824693.0},{"year":2025,"value":100181585.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":50019395.0},{"year":2022,"value":60308238.0},{"year":2023,"value":67535342.0},{"year":2024,"value":69924353.0},{"year":2025,"value":67743473.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":390113094.0},{"year":2022,"value":467349751.0},{"year":2023,"value":502627776.0},{"year":2024,"value":574935646.0},{"year":2025,"value":465865021.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":"FS204"},"muni_contact":{"url":"http://www.metsimaholo.gov.za","phone_number":"016 973 8301","street_address_1":"Metsimaholo Civic Centre","street_address_2":"Fichardt Street","street_address_3":"Sasolburg","street_address_4":"1947"},"mayoral_staff":{"officials":[{"name":"Jack Malindi","role":"Mayor/Executive Mayor","email":"jack.malindi@metsimaholo.gov.za","title":"Mr","secretary":{"name":"Mami Ramokotjo","role":"Secretary of Mayor/Executive Mayor","email":"executivemayor@metsimaholo.gov.za","title":"Ms","fax_number":"016 976 2817","office_phone":"016 973 8315"},"fax_number":"016 976 2817","office_phone":"016 973 8315"},{"name":"Fusi John Motloung","role":"Municipal Manager","email":"basi.motloung@metsimaholo.gov.za","title":"Mr","secretary":{"name":"Sibongile Matumise","role":"Secretary of Municipal Manager","email":"mmsecretary@metsimaholo.gov.za","title":"Ms","fax_number":"016 976 5205","office_phone":"016 973 8313"},"fax_number":"016 976 5205","office_phone":"016 973 8313"},{"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":"Fikile Mareka","role":"Chief Financial Officer","email":"fikile.mareka@metsimaholo.gov.za","title":"Ms","secretary":{"name":"Wilma Mathee","role":"Secretary of Financial Manager","email":"cfosecretary@metsimaholo.gov.za","title":"Mrs","fax_number":" ","office_phone":"016 973 8311"},"fax_number":" ","office_phone":"016 973 8311"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/FS204/FS204_Audit%20Report_2024_Y_20250205T111141Z_nthati_motloung.pdf"},{"date":2023,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/FS204/FS204_Audit%20Report_2023_Y_20231206T113709Z_nthati_motloung.pdf"},{"date":2022,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/FS204/FS204_Audit%20Report_2022_Y_20221208T131744Z_nthati_motloung.pdf"},{"date":2021,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/FS204/FS204_Audit%20Report_2021_Y_20220523T092655Z_amanda_vorster.pdf"}]}}