{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":15033659.0,"national_conditional_grants":12555939.0},"ORGB":{"equitable_share":208102000.0,"national_conditional_grants":161415000.0},"SCHD":{"national_conditional_grants":186100000.0},"TRFR":{"national_conditional_grants":55179000.0}},"2022":{"ACT":{"national_conditional_grants":54670410.0},"ORGB":{"equitable_share":215960000.0,"national_conditional_grants":164408000.0},"SCHD":{"national_conditional_grants":167999000.0},"TRFR":{"national_conditional_grants":164333000.0}},"2023":{"ACT":{"national_conditional_grants":122058375.0},"ORGB":{"equitable_share":241451000.0,"provincial_transfers":8183000.0,"national_conditional_grants":143056000.0},"SCHD":{"national_conditional_grants":128290000.0},"TRFR":{"national_conditional_grants":128237000.0}},"2024":{"ACT":{"national_conditional_grants":79911568.0},"ORGB":{"equitable_share":261348000.0,"national_conditional_grants":149012000.0},"SCHD":{"national_conditional_grants":104701000.0},"TRFR":{"national_conditional_grants":104701000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":15033659.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":208102000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":215960000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":241451000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":261348000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":8183000.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":745000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":745000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":4500000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":500000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":3000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":3000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":5500000.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":2100000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":5500000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":2100000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":4760125.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":41704000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":26067000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1500000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":618350.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1466000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":367000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":49685000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":47500000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":9000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":7177464.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","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":11300000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021}],"2022":[{"amount.sum":400000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":3000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":3000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":75000.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":474002.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":10000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":10000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":22577180.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":44240000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":44240000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1391344.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":1672000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1672000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":3591000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":28653032.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":78921000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":78921000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1174852.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":26500000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":26500000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":53000.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":8857592.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":15000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":15000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":22370059.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":42897000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":42897000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":2240000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":2240000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":2240000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":62687683.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":50000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":50000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":22803041.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":15000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":15000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":4500000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":4500000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":26630006.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":36926000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":36926000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":2154000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":2154000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":2154000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":38520649.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":40000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":40000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":9506913.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":18021000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":18021000.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":-220160467.0,"cube_version":"v2"},{"date":2023,"rating":"bad","result":-168586859.0,"cube_version":"v2"},{"date":2022,"rating":"bad","result":-1732383658.0,"cube_version":"v2"},{"date":2021,"rating":"bad","result":-83213972.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":"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":563997213.0,"rating":"bad","result":0.2,"amount_type":"AUDA","liabilities":2797836954.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":803656202.0,"rating":"bad","result":0.29,"amount_type":"AUDA","liabilities":2790683151.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":668564955.0,"rating":"bad","result":0.27,"amount_type":"AUDA","liabilities":2452289994.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":634393032.0,"rating":"bad","result":0.3,"amount_type":"AUDA","liabilities":2117125250.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":62989338.0,"date":"2024","year":2024,"rating":"bad","result":0.02,"amount_type":"ACT","liabilities":2797836954.0,"cube_version":"v2","call_investment_deposits":0},{"cash":46712871.0,"date":"2023","year":2023,"rating":"bad","result":0.02,"amount_type":"ACT","liabilities":2790683151.0,"cube_version":"v2","call_investment_deposits":0},{"cash":-1790333.0,"date":"2022","year":2022,"rating":"bad","result":0.0,"amount_type":"ACT","liabilities":2452289994.0,"cube_version":"v2","call_investment_deposits":0},{"cash":56699798.0,"date":"2021","year":2021,"rating":"bad","result":0.03,"amount_type":"ACT","liabilities":2117125250.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":806893294.0,"percent":75.14},"total":1073831651.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":266938357.0,"percent":24.86}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":39.77,"cube_version":"v2"},{"date":2023,"rating":"bad","result":36.68,"cube_version":"v2"},{"date":2022,"rating":"bad","result":31.0,"cube_version":"v2"},{"date":2021,"rating":"bad","result":13.79,"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":-1885854.0,"comparison":"Original budget to audited outcome","percent_changed":-87.92},{"item":"Government Transfers","amount":36142267.0,"comparison":"Original to adjusted budget","percent_changed":16.45},{"item":"Government Transfers","amount":38530409.0,"comparison":"Original budget to audited outcome","percent_changed":17.54},{"item":"Interest and investments","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":-1763817.0,"comparison":"Original budget to audited outcome","percent_changed":-3.63},{"item":"Other","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Other","amount":15899566.0,"comparison":"Original budget to audited outcome","percent_changed":519.25},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-2212186.0,"comparison":"Original budget to audited outcome","percent_changed":-2.24},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":-404045.0,"comparison":"Original budget to audited outcome","percent_changed":-55.79},{"item":"Service Charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":-63359531.0,"comparison":"Original budget to audited outcome","percent_changed":-14.68}],"2022":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":-1916353.0,"comparison":"Original budget to audited outcome","percent_changed":-89.34},{"item":"Government Transfers","amount":-35905000.0,"comparison":"Original to adjusted budget","percent_changed":-16.11},{"item":"Government Transfers","amount":10208095.0,"comparison":"Original budget to audited outcome","percent_changed":4.58},{"item":"Interest and investments","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":-825542.0,"comparison":"Original budget to audited outcome","percent_changed":-1.82},{"item":"Other","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Other","amount":6661407.0,"comparison":"Original budget to audited outcome","percent_changed":435.09},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":1563218.0,"comparison":"Original budget to audited outcome","percent_changed":1.52},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":-12838.0,"comparison":"Original budget to audited outcome","percent_changed":-3.55},{"item":"Service Charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":-98652067.0,"comparison":"Original budget to audited outcome","percent_changed":-19.45}],"2023":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":-1781517.0,"comparison":"Original budget to audited outcome","percent_changed":-97.71},{"item":"Government Transfers","amount":292727.0,"comparison":"Original to adjusted budget","percent_changed":0.12},{"item":"Government Transfers","amount":-1977626.0,"comparison":"Original budget to audited outcome","percent_changed":-0.79},{"item":"Interest and investments","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":25850946.0,"comparison":"Original budget to audited outcome","percent_changed":55.79},{"item":"Other","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Other","amount":8843629.0,"comparison":"Original budget to audited outcome","percent_changed":545.11},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-22402466.0,"comparison":"Original budget to audited outcome","percent_changed":-18.77},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":118.0,"comparison":"Original budget to audited outcome","percent_changed":0.04},{"item":"Service Charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":-145755057.0,"comparison":"Original budget to audited outcome","percent_changed":-28.13}],"2024":[{"item":"Fines","amount":-791000.0,"comparison":"Original to adjusted budget","percent_changed":-41.2},{"item":"Fines","amount":-1771850.0,"comparison":"Original budget to audited outcome","percent_changed":-92.29},{"item":"Government Transfers","amount":290357.0,"comparison":"Original to adjusted budget","percent_changed":0.11},{"item":"Government Transfers","amount":-2148593.0,"comparison":"Original budget to audited outcome","percent_changed":-0.8},{"item":"Interest and investments","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":50390307.0,"comparison":"Original budget to audited outcome","percent_changed":103.28},{"item":"Other","amount":225500.0,"comparison":"Original to adjusted budget","percent_changed":13.2},{"item":"Other","amount":91502096.0,"comparison":"Original budget to audited outcome","percent_changed":5356.22},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-21865600.0,"comparison":"Original budget to audited outcome","percent_changed":-17.4},{"item":"Rental income","amount":170000.0,"comparison":"Original to adjusted budget","percent_changed":59.36},{"item":"Rental income","amount":56898.0,"comparison":"Original budget to audited outcome","percent_changed":19.87},{"item":"Service Charges","amount":-24827878.0,"comparison":"Original to adjusted budget","percent_changed":-4.08},{"item":"Service Charges","amount":-98675782.0,"comparison":"Original budget to audited outcome","percent_changed":-16.21}]},"income_time_series":[{"amount":840597935.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":846535145.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":937014623.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":1031411154.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":789260210.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":799466065.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":799499923.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":1073831651.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":900240628.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":1086334096.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":1130666969.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":804455668.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":882440145.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":936721896.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":1056344175.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":1044363089.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":6878125.0,"comparison":"Original budget to audited outcome","percent_changed":3.05},{"item":"Contracted services","amount":-1980797.0,"comparison":"Original to adjusted budget","percent_changed":-9.04},{"item":"Contracted services","amount":17818365.0,"comparison":"Original budget to audited outcome","percent_changed":81.36},{"item":"Employee related costs","amount":2.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Employee related costs","amount":17443694.0,"comparison":"Original budget to audited outcome","percent_changed":7.53},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":6171651.0,"comparison":"Original budget to audited outcome","percent_changed":21.45},{"item":"Other","amount":37123064.0,"comparison":"Original to adjusted budget","percent_changed":12.42},{"item":"Other","amount":69976359.0,"comparison":"Original budget to audited outcome","percent_changed":23.41},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-1655131.0,"comparison":"Original budget to audited outcome","percent_changed":-9.65},{"item":"Transfers and subsidies","amount":1000000.0,"comparison":"Original to adjusted budget","percent_changed":555.56},{"item":"Transfers and subsidies","amount":-15000.0,"comparison":"Original budget to audited outcome","percent_changed":-8.33}],"2022":[{"item":"Bulk purchases","amount":-30000000.0,"comparison":"Original to adjusted budget","percent_changed":-9.76},{"item":"Bulk purchases","amount":-25627814.0,"comparison":"Original budget to audited outcome","percent_changed":-8.33},{"item":"Contracted services","amount":8073000.0,"comparison":"Original to adjusted budget","percent_changed":46.19},{"item":"Contracted services","amount":30641596.0,"comparison":"Original budget to audited outcome","percent_changed":175.3},{"item":"Employee related costs","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Employee related costs","amount":2195609.0,"comparison":"Original budget to audited outcome","percent_changed":0.85},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":18299234.0,"comparison":"Original budget to audited outcome","percent_changed":99.4},{"item":"Other","amount":-15678220.0,"comparison":"Original to adjusted budget","percent_changed":-5.51},{"item":"Other","amount":202350132.0,"comparison":"Original budget to audited outcome","percent_changed":71.16},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-1558642.0,"comparison":"Original budget to audited outcome","percent_changed":-9.09},{"item":"Transfers and subsidies","amount":1700000.0,"comparison":"Original to adjusted budget","percent_changed":944.44},{"item":"Transfers and subsidies","amount":-30000.0,"comparison":"Original budget to audited outcome","percent_changed":-16.67}],"2023":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-105423756.0,"comparison":"Original budget to audited outcome","percent_changed":-29.9},{"item":"Contracted services","amount":614000.0,"comparison":"Original to adjusted budget","percent_changed":2.34},{"item":"Contracted services","amount":19186061.0,"comparison":"Original budget to audited outcome","percent_changed":73.03},{"item":"Employee related costs","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Employee related costs","amount":-6410416.0,"comparison":"Original budget to audited outcome","percent_changed":-2.41},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":57131488.0,"comparison":"Original budget to audited outcome","percent_changed":269.85},{"item":"Other","amount":-321273.0,"comparison":"Original to adjusted budget","percent_changed":-0.1},{"item":"Other","amount":123716207.0,"comparison":"Original budget to audited outcome","percent_changed":37.66},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-468985.0,"comparison":"Original budget to audited outcome","percent_changed":-2.73},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Transfers and subsidies","amount":-1957.0,"comparison":"Original budget to audited outcome","percent_changed":-1.09}],"2024":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-36002342.0,"comparison":"Original budget to audited outcome","percent_changed":-10.54},{"item":"Contracted services","amount":-10203475.0,"comparison":"Original to adjusted budget","percent_changed":-28.07},{"item":"Contracted services","amount":15802263.0,"comparison":"Original budget to audited outcome","percent_changed":43.47},{"item":"Employee related costs","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Employee related costs","amount":1598603.0,"comparison":"Original budget to audited outcome","percent_changed":0.57},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":83420780.0,"comparison":"Original budget to audited outcome","percent_changed":374.2},{"item":"Other","amount":-40019940.0,"comparison":"Original to adjusted budget","percent_changed":-9.22},{"item":"Other","amount":32743364.0,"comparison":"Original budget to audited outcome","percent_changed":7.55},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-274453.0,"comparison":"Original budget to audited outcome","percent_changed":-1.52},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Transfers and subsidies","amount":-3913.0,"comparison":"Original budget to audited outcome","percent_changed":-2.17}]},"spending_time_series":[{"amount":859784394.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":866508229.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":1012416881.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":1082962420.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":940260188.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":1128683564.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":1099852796.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":1230470137.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":1395767390.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":1147724472.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":1200191869.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":823642125.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":902413449.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":1012124154.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":1133185835.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":1098744916.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":-15.68,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"ave","result":11.04,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"bad","result":-50.01,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"bad","result":-99.6,"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":103832293.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":510179153.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":343275.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":99180110.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":148032.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":93210431.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":22.96},{"date":2023,"rating":"","result":23.62},{"date":2022,"rating":"","result":22.99},{"date":2021,"rating":"","result":26.49}],"formula":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp","item_codes":["3000","3100"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp_v2","item_codes":["3100"],"amount_type":"AUDA"}]},"result_type":"%"},"operating_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2024,"rating":"ave","result":13.6,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"ave","result":8.6,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"bad","result":30.3,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"ave","result":9.4,"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":3.01,"cube_version":"v2"},{"date":2023,"rating":"bad","result":3.92,"cube_version":"v2"},{"date":2022,"rating":"bad","result":4.19,"cube_version":"v2"},{"date":2021,"rating":"bad","result":2.9,"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":4.24},{"date":2023,"rating":"","result":4.13},{"date":2022,"rating":"","result":4.26},{"date":2021,"rating":"","result":4.22}],"formula":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp","item_codes":["4200"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp_v2","item_codes":["3800"],"amount_type":"AUDA"}]},"result_type":"%"},"current_debtors_collection_rate":{"ref":{"url":"http://mfma.treasury.gov.za/RegulationsandGazettes/Municipal%20Budget%20and%20Reporting%20Regulations/Pages/default.aspx","title":"Municipal Budget and Reporting Regulations"},"values":[{"date":"2024","year":2024,"rating":"good","result":153.7,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"bad","result":84.13,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"bad","result":60.65,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"good","result":123.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":73588526.0},{"year":2022,"value":131255937.0},{"year":2023,"value":70631919.0},{"year":2024,"value":70146323.0},{"year":2025,"value":72276256.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":257417776.0},{"year":2022,"value":303177532.0},{"year":2023,"value":272833087.0},{"year":2024,"value":359727071.0},{"year":2025,"value":441961709.0}],"category":"Electricity "},{"values":[{"year":2021,"value":367840165.0},{"year":2022,"value":404296373.0},{"year":2023,"value":490595018.0},{"year":2024,"value":555333155.0},{"year":2025,"value":438586243.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":133880.0},{"year":2022,"value":467010.0},{"year":2023,"value":515596.0},{"year":2024,"value":2344589.0},{"year":2025,"value":2217821.0}],"category":"Housing"},{"values":[{"year":2021,"value":179854159.0},{"year":2022,"value":212950410.0},{"year":2023,"value":158079917.0},{"year":2024,"value":121047654.0},{"year":2025,"value":81595661.0}],"category":"Road Transport"},{"values":[{"year":2023,"value":2085053.0},{"year":2024,"value":9099179.0},{"year":2025,"value":10704542.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":2533162.0},{"year":2022,"value":1668178.0},{"year":2023,"value":4111019.0},{"year":2024,"value":15519704.0},{"year":2025,"value":56469166.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":26453393.0},{"year":2022,"value":33947787.0},{"year":2023,"value":31547455.0},{"year":2024,"value":33300361.0},{"year":2025,"value":75629877.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":32439127.0},{"year":2022,"value":40920337.0},{"year":2023,"value":69453732.0},{"year":2024,"value":63952101.0},{"year":2025,"value":216326115.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":"FS203"},"muni_contact":{"url":"http://www.ngwathe.fs.gov.za","phone_number":"056 816 2700","street_address_1":"Municipal Building","street_address_2":"Liebenberg Street","street_address_3":"Parys","street_address_4":"9585"},"mayoral_staff":{"officials":[{"name":"Victoria De Beers","role":"Mayor/Executive Mayor","email":"deomohapi@gmail.com","title":"Cllr","secretary":{"name":"Magauta Lethea","role":"Secretary of Mayor/Executive Mayor","email":"magautal@ngwathe.co.za","title":"Ms","fax_number":"056 817 7131","office_phone":"056 816 2700"},"fax_number":"056 817 7131","office_phone":"056 816 2700"},{"name":"Futhuli Mothamaha","role":"Municipal Manager","email":"mmadmin@ngwathe.co.za","title":"Mr","secretary":{"name":"Seipati Mohanane","role":"Secretary of Municipal Manager","email":"mmadmin@ngwathe.co.za","title":"Ms","fax_number":"056 811 2046","office_phone":"056 816 2700"},"fax_number":"056 811 5159","office_phone":"056 816 2700"},{"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":"Serame Phetoane","role":"Chief Financial Officer","email":"phetoanes@ngwathe.co.za","title":"Mr","secretary":{"name":"Sekgomotso Martins","role":"Secretary of Financial Manager","email":"cfoadmin@ngwathe.co.za","title":"Ms","fax_number":"056 211 2734","office_phone":"056 819 2700"},"fax_number":" ","office_phone":"083 665 5053"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/FS203/FS203_Audit%20Report_2024_Y_20250206T191148Z_lepelel.pdf"},{"date":2023,"rating":"qualified","result":"Qualified","report_url":""},{"date":2022,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/FS203/FS203_Audit%20Report_2022_Y_20230113T143700Z_mogoera.pdf"},{"date":2021,"rating":"qualified","result":"Qualified","report_url":""}]}}