{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":20611482.0,"national_conditional_grants":3651608.0},"ORGB":{"equitable_share":222134000.0,"national_conditional_grants":84600000.0},"SCHD":{"national_conditional_grants":74300000.0},"TRFR":{"national_conditional_grants":23088000.0}},"2022":{"ORGB":{"equitable_share":230417000.0,"national_conditional_grants":84068000.0},"SCHD":{"national_conditional_grants":90118000.0},"TRFR":{"national_conditional_grants":64614000.0}},"2023":{"ACT":{"national_conditional_grants":30204912.0},"ORGB":{"equitable_share":257433000.0,"provincial_transfers":14986000.0,"national_conditional_grants":59686000.0},"SCHD":{"national_conditional_grants":61609000.0},"TRFR":{"national_conditional_grants":61537000.0}},"2024":{"ACT":{"national_conditional_grants":43080531.0},"ORGB":{"equitable_share":279982000.0,"national_conditional_grants":123464000.0},"SCHD":{"national_conditional_grants":117026000.0},"TRFR":{"national_conditional_grants":82065000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":20611482.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":222134000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":230417000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":257433000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":279982000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":14986000.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":1013000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1013000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":126474.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":2000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":2000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1890260.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":49924000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":12268000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":300000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":258080.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1228000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":307000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":4010000.0,"grant.code":"WS6G","grant.label":"Water Services Infrastructure Grant (Sched 6)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1376794.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":15825000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":7500000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021}],"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":9140000.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":1500000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1500000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":42336000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":46022000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1392000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1392000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1050000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":19000000.0,"grant.code":"WS6G","grant.label":"Water Services Infrastructure Grant (Sched 6)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":13500000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":13500000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":1291400.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":72000.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":1923000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1923000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":21833358.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":45594000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":45594000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":625189.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1428000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1428000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":6454965.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":10292000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":10292000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":11000000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":11000000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","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":4961000.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":2050000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":2050000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":37534558.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":44352000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":44352000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1430743.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1463000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1463000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":30000000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":4115230.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":20900000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":20900000.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":"bad","result":-6806642.0,"cube_version":"v2"},{"date":2023,"rating":"bad","result":-47393385.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":384499421.0,"cube_version":"v2"},{"date":2021,"rating":"bad","result":-28609067.0,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"}]},"result_type":"R"},"cash_coverage":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"bad","result":0,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0,"cube_version":"v2"},{"date":2022,"rating":"good","result":3.9,"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":687940693.0,"rating":"bad","result":0.46,"amount_type":"AUDA","liabilities":1504976158.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":517615581.0,"rating":"bad","result":0.44,"amount_type":"AUDA","liabilities":1178048725.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":571102225.0,"rating":"bad","result":0.6,"amount_type":"AUDA","liabilities":948829811.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":505001286.0,"rating":"bad","result":0.72,"amount_type":"AUDA","liabilities":699642937.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":-9904956.0,"date":"2024","year":2024,"rating":"bad","result":-0.01,"amount_type":"ACT","liabilities":1504976158.0,"cube_version":"v2","call_investment_deposits":0},{"cash":-21364321.0,"date":"2023","year":2023,"rating":"bad","result":-0.02,"amount_type":"ACT","liabilities":1178048725.0,"cube_version":"v2","call_investment_deposits":0},{"cash":-14103832.0,"date":"2022","year":2022,"rating":"bad","result":-0.01,"amount_type":"ACT","liabilities":948829811.0,"cube_version":"v2","call_investment_deposits":0},{"cash":-55689.0,"date":"2021","year":2021,"rating":"bad","result":0.0,"amount_type":"ACT","liabilities":699642937.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":900539587.0,"percent":74.14},"total":1214593440.0,"rating":"ave","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":314053853.0,"percent":25.86}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":14.75,"cube_version":"v2"},{"date":2023,"rating":"bad","result":34.26,"cube_version":"v2"},{"date":2022,"rating":"bad","result":21.25,"cube_version":"v2"},{"date":2021,"rating":"bad","result":21.92,"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":-2573449.0,"comparison":"Original to adjusted budget","percent_changed":-34.65},{"item":"Fines","amount":-5022275.0,"comparison":"Original budget to audited outcome","percent_changed":-67.63},{"item":"Government Transfers","amount":36708000.0,"comparison":"Original to adjusted budget","percent_changed":16.25},{"item":"Government Transfers","amount":36515315.0,"comparison":"Original budget to audited outcome","percent_changed":16.17},{"item":"Interest and investments","amount":-140631.0,"comparison":"Original to adjusted budget","percent_changed":-0.44},{"item":"Interest and investments","amount":-6885843.0,"comparison":"Original budget to audited outcome","percent_changed":-21.41},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Other","amount":34999.0,"comparison":"Original to adjusted budget","percent_changed":0.25},{"item":"Other","amount":-3573964.0,"comparison":"Original budget to audited outcome","percent_changed":-25.46},{"item":"Property rates","amount":-1368222.0,"comparison":"Original to adjusted budget","percent_changed":-1.7},{"item":"Property rates","amount":-3884102.0,"comparison":"Original budget to audited outcome","percent_changed":-4.81},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":-227897.0,"comparison":"Original budget to audited outcome","percent_changed":-4.78},{"item":"Service Charges","amount":40971906.0,"comparison":"Original to adjusted budget","percent_changed":7.22},{"item":"Service Charges","amount":-53652537.0,"comparison":"Original budget to audited outcome","percent_changed":-9.45}],"2022":[{"item":"Fines","amount":-20000.0,"comparison":"Original to adjusted budget","percent_changed":-0.33},{"item":"Fines","amount":-2140016.0,"comparison":"Original budget to audited outcome","percent_changed":-35.55},{"item":"Government Transfers","amount":6500000.0,"comparison":"Original to adjusted budget","percent_changed":2.75},{"item":"Government Transfers","amount":4993884.0,"comparison":"Original budget to audited outcome","percent_changed":2.11},{"item":"Interest and investments","amount":250517.0,"comparison":"Original to adjusted budget","percent_changed":0.76},{"item":"Interest and investments","amount":-1743484.0,"comparison":"Original budget to audited outcome","percent_changed":-5.31},{"item":"Other","amount":5704388.0,"comparison":"Original to adjusted budget","percent_changed":38.3},{"item":"Other","amount":912040.0,"comparison":"Original budget to audited outcome","percent_changed":6.12},{"item":"Property rates","amount":-5856885.0,"comparison":"Original to adjusted budget","percent_changed":-6.94},{"item":"Property rates","amount":-10013058.0,"comparison":"Original budget to audited outcome","percent_changed":-11.86},{"item":"Rental income","amount":900.0,"comparison":"Original to adjusted budget","percent_changed":0.01},{"item":"Rental income","amount":-2770549.0,"comparison":"Original budget to audited outcome","percent_changed":-34.88},{"item":"Service Charges","amount":14149645.0,"comparison":"Original to adjusted budget","percent_changed":2.22},{"item":"Service Charges","amount":-79394678.0,"comparison":"Original budget to audited outcome","percent_changed":-12.45}],"2023":[{"item":"Fines","amount":30000.0,"comparison":"Original to adjusted budget","percent_changed":0.64},{"item":"Fines","amount":-141975.0,"comparison":"Original budget to audited outcome","percent_changed":-3.02},{"item":"Government Transfers","amount":18725172.0,"comparison":"Original to adjusted budget","percent_changed":7.15},{"item":"Government Transfers","amount":12396406.0,"comparison":"Original budget to audited outcome","percent_changed":4.73},{"item":"Interest and investments","amount":-2274183.0,"comparison":"Original to adjusted budget","percent_changed":-6.44},{"item":"Interest and investments","amount":9955478.0,"comparison":"Original budget to audited outcome","percent_changed":28.21},{"item":"Other","amount":-3908200.0,"comparison":"Original to adjusted budget","percent_changed":-20.8},{"item":"Other","amount":-12056212.0,"comparison":"Original budget to audited outcome","percent_changed":-64.16},{"item":"Property rates","amount":-7633023.0,"comparison":"Original to adjusted budget","percent_changed":-8.52},{"item":"Property rates","amount":-5327929.0,"comparison":"Original budget to audited outcome","percent_changed":-5.95},{"item":"Rental income","amount":-21162.0,"comparison":"Original to adjusted budget","percent_changed":-0.28},{"item":"Rental income","amount":-1862156.0,"comparison":"Original budget to audited outcome","percent_changed":-24.51},{"item":"Service Charges","amount":477581.0,"comparison":"Original to adjusted budget","percent_changed":0.07},{"item":"Service Charges","amount":-117672352.0,"comparison":"Original budget to audited outcome","percent_changed":-16.53}],"2024":[{"item":"Fines","amount":280000.0,"comparison":"Original to adjusted budget","percent_changed":5.63},{"item":"Fines","amount":1595120.0,"comparison":"Original budget to audited outcome","percent_changed":32.07},{"item":"Government Transfers","amount":30000000.0,"comparison":"Original to adjusted budget","percent_changed":10.55},{"item":"Government Transfers","amount":29816821.0,"comparison":"Original budget to audited outcome","percent_changed":10.49},{"item":"Interest and investments","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":43768435.0,"comparison":"Original budget to audited outcome","percent_changed":116.38},{"item":"Other","amount":2223478.0,"comparison":"Original to adjusted budget","percent_changed":11.15},{"item":"Other","amount":17199837.0,"comparison":"Original budget to audited outcome","percent_changed":86.25},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":1925828.0,"comparison":"Original budget to audited outcome","percent_changed":2.23},{"item":"Rental income","amount":133166.0,"comparison":"Original to adjusted budget","percent_changed":1.66},{"item":"Rental income","amount":-1410374.0,"comparison":"Original budget to audited outcome","percent_changed":-17.62},{"item":"Service Charges","amount":41384620.0,"comparison":"Original to adjusted budget","percent_changed":5.52},{"item":"Service Charges","amount":-69580867.0,"comparison":"Original budget to audited outcome","percent_changed":-9.27}]},"income_time_series":[{"amount":1006360761.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":1040460396.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":1135157799.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":1265299904.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":895996521.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":929575970.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":1015052874.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":1214593440.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":1279021784.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":1407527202.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":1472273456.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":932728158.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":1019731831.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":1129761614.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":1191278640.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":1345628246.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":27000.0,"comparison":"Original to adjusted budget","percent_changed":0.01},{"item":"Bulk purchases","amount":11523372.0,"comparison":"Original budget to audited outcome","percent_changed":4.12},{"item":"Contracted services","amount":15622280.0,"comparison":"Original to adjusted budget","percent_changed":13.24},{"item":"Contracted services","amount":-19948749.0,"comparison":"Original budget to audited outcome","percent_changed":-16.91},{"item":"Employee related costs","amount":13520408.0,"comparison":"Original to adjusted budget","percent_changed":4.42},{"item":"Employee related costs","amount":4275325.0,"comparison":"Original budget to audited outcome","percent_changed":1.4},{"item":"Finance charges","amount":-2225000.0,"comparison":"Original to adjusted budget","percent_changed":-33.09},{"item":"Finance charges","amount":95876.0,"comparison":"Original budget to audited outcome","percent_changed":1.43},{"item":"Other","amount":38249578.0,"comparison":"Original to adjusted budget","percent_changed":20.69},{"item":"Other","amount":105298149.0,"comparison":"Original budget to audited outcome","percent_changed":56.97},{"item":"Remuneration of councillors","amount":839550.0,"comparison":"Original to adjusted budget","percent_changed":4.33},{"item":"Remuneration of councillors","amount":353765.0,"comparison":"Original budget to audited outcome","percent_changed":1.83}],"2022":[{"item":"Bulk purchases","amount":-969959.0,"comparison":"Original to adjusted budget","percent_changed":-0.3},{"item":"Bulk purchases","amount":18187176.0,"comparison":"Original budget to audited outcome","percent_changed":5.71},{"item":"Contracted services","amount":2760076.0,"comparison":"Original to adjusted budget","percent_changed":2.12},{"item":"Contracted services","amount":-7932451.0,"comparison":"Original budget to audited outcome","percent_changed":-6.09},{"item":"Employee related costs","amount":10109685.0,"comparison":"Original to adjusted budget","percent_changed":3.13},{"item":"Employee related costs","amount":12109788.0,"comparison":"Original budget to audited outcome","percent_changed":3.75},{"item":"Finance charges","amount":4980000.0,"comparison":"Original to adjusted budget","percent_changed":137.57},{"item":"Finance charges","amount":62300188.0,"comparison":"Original budget to audited outcome","percent_changed":1721.0},{"item":"Other","amount":13541188.0,"comparison":"Original to adjusted budget","percent_changed":6.69},{"item":"Other","amount":115498409.0,"comparison":"Original budget to audited outcome","percent_changed":57.06},{"item":"Remuneration of councillors","amount":540251.0,"comparison":"Original to adjusted budget","percent_changed":2.61},{"item":"Remuneration of councillors","amount":-1199118.0,"comparison":"Original budget to audited outcome","percent_changed":-5.79}],"2023":[{"item":"Bulk purchases","amount":3399361.0,"comparison":"Original to adjusted budget","percent_changed":0.98},{"item":"Bulk purchases","amount":-288564.0,"comparison":"Original budget to audited outcome","percent_changed":-0.08},{"item":"Contracted services","amount":3841446.0,"comparison":"Original to adjusted budget","percent_changed":2.71},{"item":"Contracted services","amount":-25781958.0,"comparison":"Original budget to audited outcome","percent_changed":-18.18},{"item":"Employee related costs","amount":9691537.0,"comparison":"Original to adjusted budget","percent_changed":2.66},{"item":"Employee related costs","amount":-20400750.0,"comparison":"Original budget to audited outcome","percent_changed":-5.59},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":53118975.0,"comparison":"Original budget to audited outcome","percent_changed":610.84},{"item":"Other","amount":-33272434.0,"comparison":"Original to adjusted budget","percent_changed":-15.32},{"item":"Other","amount":344649515.0,"comparison":"Original budget to audited outcome","percent_changed":158.72},{"item":"Remuneration of councillors","amount":1477978.0,"comparison":"Original to adjusted budget","percent_changed":6.64},{"item":"Remuneration of councillors","amount":-1447065.0,"comparison":"Original budget to audited outcome","percent_changed":-6.5},{"item":"Transfers and subsidies","amount":40000.0,"comparison":"Original to adjusted budget","percent_changed":16.0},{"item":"Transfers and subsidies","amount":-72104.0,"comparison":"Original budget to audited outcome","percent_changed":-28.84}],"2024":[{"item":"Bulk purchases","amount":88879094.0,"comparison":"Original to adjusted budget","percent_changed":27.9},{"item":"Bulk purchases","amount":100014918.0,"comparison":"Original budget to audited outcome","percent_changed":31.4},{"item":"Contracted services","amount":-9881436.0,"comparison":"Original to adjusted budget","percent_changed":-6.18},{"item":"Contracted services","amount":-24552981.0,"comparison":"Original budget to audited outcome","percent_changed":-15.36},{"item":"Employee related costs","amount":1598685.0,"comparison":"Original to adjusted budget","percent_changed":0.4},{"item":"Employee related costs","amount":13463724.0,"comparison":"Original budget to audited outcome","percent_changed":3.4},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":-2571238.0,"comparison":"Original budget to audited outcome","percent_changed":-29.9},{"item":"Other","amount":-6404599.0,"comparison":"Original to adjusted budget","percent_changed":-2.93},{"item":"Other","amount":227376535.0,"comparison":"Original budget to audited outcome","percent_changed":104.14},{"item":"Remuneration of councillors","amount":3163947.0,"comparison":"Original to adjusted budget","percent_changed":12.64},{"item":"Remuneration of councillors","amount":-2780839.0,"comparison":"Original budget to audited outcome","percent_changed":-11.11},{"item":"Transfers and subsidies","amount":538870.0,"comparison":"Original to adjusted budget","percent_changed":116.86},{"item":"Transfers and subsidies","amount":-377500.0,"comparison":"Original budget to audited outcome","percent_changed":-81.86}]},"spending_time_series":[{"amount":980403368.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":1029370896.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":1086180031.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":1204883486.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":1015967290.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":1197373647.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":1450780192.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":1437561544.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":1698065117.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":1371792896.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":1434895359.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":914369552.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":998409655.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":1101002143.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":1126988925.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":1311466113.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":-95.66,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"bad","result":-95.55,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"bad","result":-91.02,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"bad","result":-96.66,"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":88207116.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":680650773.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":6592630.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":81377570.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":6568784.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":37142714.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":28.49},{"date":2023,"rating":"","result":23.75},{"date":2022,"rating":"","result":27.98},{"date":2021,"rating":"","result":30.5}],"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":19.3,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"bad","result":33.6,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"bad","result":16.3,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"good","result":3.6,"overunder":"over","cube_version":"v2"}],"formula":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"-",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","/",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"-",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","*","100"]},"result_type":"%"},"repairs_maintenance_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":4.84,"cube_version":"v2"},{"date":2023,"rating":"bad","result":5.99,"cube_version":"v2"},{"date":2022,"rating":"bad","result":4.58,"cube_version":"v2"},{"date":2021,"rating":"bad","result":3.41,"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":9.41},{"date":2023,"rating":"","result":8.0},{"date":2022,"rating":"","result":10.22},{"date":2021,"rating":"","result":9.65}],"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":57.98,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"bad","result":66.07,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"good","result":104.01,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"bad","result":null,"billing":null,"receipts":null,"cube_version":null}],"formula":{"text":"= (Collected Revenue / Billed Revenue) * 100","actual":["=","(",{"cube":"cflow","item_codes":["3010","3030","3040","3050","3060","3070","3100"],"amount_type":"AUDA"},"/",{"cube":"incexp","item_codes":["0200","0400","1000","less item code","2000"],"amount_type":"AUDA"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= (Collected Revenue / Billed Revenue) * 100","actual":["=","(",{"cube":"cflow_v2","item_codes":["0120","0130","0280"],"amount_type":"AUDA"},"/",{"cube":"incexp_v2","item_codes":["1800","0300","0400","0500","0600","1400","1100","1000"],"amount_type":"AUDA"},")","*","100"]},"result_type":"%"},"expenditure_functional_breakdown":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"values":[{"year":2021,"value":52287010.0},{"year":2022,"value":46511271.0},{"year":2023,"value":51760988.0},{"year":2024,"value":54845963.0},{"year":2025,"value":57259072.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":381929833.0},{"year":2022,"value":444700300.0},{"year":2023,"value":441553473.0},{"year":2024,"value":554894521.0},{"year":2025,"value":593105890.0}],"category":"Electricity "},{"values":[{"year":2021,"value":2590265.0},{"year":2022,"value":2643943.0},{"year":2023,"value":2597040.0},{"year":2024,"value":3221867.0},{"year":2025,"value":2822177.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":235267672.0},{"year":2022,"value":339479115.0},{"year":2023,"value":360222346.0},{"year":2024,"value":370683758.0},{"year":2025,"value":436996230.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":5598829.0},{"year":2022,"value":7336566.0},{"year":2023,"value":7724989.0},{"year":2024,"value":7909616.0},{"year":2025,"value":8612088.0}],"category":"Housing"},{"values":[{"year":2021,"value":197350.0},{"year":2022,"value":12089.0},{"year":2023,"value":236687.0},{"year":2024,"value":1097781.0},{"year":2025,"value":1316492.0}],"category":"Other"},{"values":[{"year":2021,"value":60623840.0},{"year":2022,"value":65330261.0},{"year":2023,"value":72382072.0},{"year":2024,"value":75090564.0},{"year":2025,"value":86152077.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":32315067.0},{"year":2022,"value":39450689.0},{"year":2023,"value":34878274.0},{"year":2024,"value":36698769.0},{"year":2025,"value":48457423.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":28127319.0},{"year":2022,"value":49256572.0},{"year":2023,"value":77795917.0},{"year":2024,"value":68782414.0},{"year":2025,"value":107822105.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":85208901.0},{"year":2022,"value":82861390.0},{"year":2023,"value":105698300.0},{"year":2024,"value":100272834.0},{"year":2025,"value":139276882.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":131821204.0},{"year":2022,"value":119791451.0},{"year":2023,"value":295930106.0},{"year":2024,"value":164063457.0},{"year":2025,"value":216244681.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":"FS201"},"muni_contact":{"url":"http://www.moqhaka.gov.za","phone_number":"056 216 9911","street_address_1":"Municipal Offices","street_address_2":"Hill Street","street_address_3":"Kroonstad","street_address_4":"9499"},"mayoral_staff":{"officials":[{"name":"Motloheloa Ellis Mokatsane","role":"Mayor/Executive Mayor","email":"Executivemayor@moqhaka.gov.za","title":"Cllr","secretary":{"name":"Lisebo Taba","role":"Secretary of Mayor/Executive Mayor","email":"lisebot@moqhaka.gov.za","title":"Mr","fax_number":"056 216 9145","office_phone":"056 216 9102"},"fax_number":"056 216 9145","office_phone":"056 216 9100"},{"name":"Portia Tshabalala","role":"Municipal Manager","email":"portiat@moqhaka.gov.za","title":"Mrs","secretary":{"name":"Jankie Mthimkulu","role":"Secretary of Municipal Manager","email":"mms@moqhaka.gov.za","title":"Mr","fax_number":"056 216 9105","office_phone":"056 216 9378"},"fax_number":" ","office_phone":"056 216 9377"},{"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":"Irene Mokheseng","role":"Chief Financial Officer","email":"irenem@moqhaka.gov.za","title":"Mrs","secretary":{"name":"Dumezweni Mathebula","role":"Secretary of Financial Manager","email":"cfosec@moqhaka.gov.za","title":"Mr","fax_number":"056 216 9146","office_phone":"056 216 9140"},"fax_number":" ","office_phone":"056 216 9141"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/FS201/FS201_Audit%20Report_2024_Y_20250206T112223Z_ikelengm.pdf"},{"date":2023,"rating":"outstanding","result":"Outstanding","report_url":""},{"date":2022,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/FS201/FS201_Audit%20Report_2022_Y_20230125T130304Z_ikelengm.pdf"},{"date":2021,"rating":"qualified","result":"Qualified","report_url":""}]}}