{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":36247889.0,"national_conditional_grants":22791434.0},"ORGB":{"equitable_share":205715000.0,"national_conditional_grants":359800000.0},"SCHD":{"national_conditional_grants":310791000.0},"TRFR":{"national_conditional_grants":48502000.0}},"2022":{"ORGB":{"equitable_share":212318000.0,"national_conditional_grants":426228000.0},"SCHD":{"national_conditional_grants":347862000.0},"TRFR":{"national_conditional_grants":203706000.0}},"2023":{"ACT":{"national_conditional_grants":106883542.0},"ORGB":{"equitable_share":234466000.0,"provincial_transfers":14567000.0,"national_conditional_grants":600952000.0},"SCHD":{"national_conditional_grants":481750000.0},"TRFR":{"national_conditional_grants":223389000.0}},"2024":{"ACT":{"national_conditional_grants":187085925.0},"ORGB":{"equitable_share":251487000.0,"national_conditional_grants":333356000.0},"SCHD":{"national_conditional_grants":296854000.0},"TRFR":{"national_conditional_grants":185401000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":36247889.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":205715000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":212318000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":234466000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":251487000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":14567000.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":238000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":238000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":2000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":2000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":3890748.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":46899000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":9305000.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":1802000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":451000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":107080000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":18900686.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":103399000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":24108000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":22698000.0,"grant.code":"WS6G","grant.label":"Water Services Infrastructure Grant (Sched 6)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":26375000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":12400000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021}],"2022":[{"amount.sum":2100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":2100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":308000.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":2000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":2000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":49792000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":49792000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1989000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1989000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":113098000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":110000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":110000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":30750000.0,"grant.code":"WS6G","grant.label":"Water Services Infrastructure Grant (Sched 6)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":37825000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":37825000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":687246.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":2200000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":2200000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":12146000.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":33266201.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":53700000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":53700000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":547000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":2188000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":2188000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":185577000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":71702184.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":150000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":150000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":60638000.0,"grant.code":"WS6G","grant.label":"Water Services Infrastructure Grant (Sched 6)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":680911.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":15301000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":15301000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":2200000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":2200000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":2200000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":9303000.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":52278000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":52278000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":52278000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1750000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1750000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1750000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":70000000.0,"grant.code":"RB7G","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":115000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":115000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":115000000.0,"grant.code":"RBIG","grant.label":"Regional Bulk Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":32150000.0,"grant.code":"WS6G","grant.label":"Water Services Infrastructure Grant (Sched 6)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":15857925.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":14173000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":14173000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024}]}},"cash_balance":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"good","result":242547948.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":460551411.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":306501567.0,"cube_version":"v2"},{"date":2021,"rating":"bad","result":-274092764.0,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"}]},"result_type":"R"},"cash_coverage":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"good","result":3.4,"cube_version":"v2"},{"date":2023,"rating":"good","result":7.1,"cube_version":"v2"},{"date":2022,"rating":"good","result":4.4,"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":564821452.0,"rating":"good","result":2.23,"amount_type":"AUDA","liabilities":253053119.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":523347351.0,"rating":"good","result":2.45,"amount_type":"AUDA","liabilities":214010219.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":483913575.0,"rating":"good","result":1.72,"amount_type":"AUDA","liabilities":281431967.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":407379896.0,"rating":"good","result":1.57,"amount_type":"AUDA","liabilities":258869691.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":57062518.0,"date":"2024","year":2024,"rating":"bad","result":0.23,"amount_type":"ACT","liabilities":253053119.0,"cube_version":"v2","call_investment_deposits":0},{"cash":66207531.0,"date":"2023","year":2023,"rating":"bad","result":0.31,"amount_type":"ACT","liabilities":214010219.0,"cube_version":"v2","call_investment_deposits":0},{"cash":93197341.0,"date":"2022","year":2022,"rating":"bad","result":0.33,"amount_type":"ACT","liabilities":281431967.0,"cube_version":"v2","call_investment_deposits":0},{"cash":45525760.0,"date":"2021","year":2021,"rating":"bad","result":0.18,"amount_type":"ACT","liabilities":258869691.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":416285651.0,"percent":61.94},"total":672129668.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":255844017.0,"percent":38.06}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":10.45,"cube_version":"v2"},{"date":2023,"rating":"bad","result":22.11,"cube_version":"v2"},{"date":2022,"rating":"bad","result":27.98,"cube_version":"v2"},{"date":2021,"rating":"bad","result":44.49,"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":-660964.0,"comparison":"Original to adjusted budget","percent_changed":-78.16},{"item":"Fines","amount":259298.0,"comparison":"Original budget to audited outcome","percent_changed":30.66},{"item":"Government Transfers","amount":33703050.0,"comparison":"Original to adjusted budget","percent_changed":16.03},{"item":"Government Transfers","amount":34329907.0,"comparison":"Original budget to audited outcome","percent_changed":16.33},{"item":"Interest and investments","amount":-13432256.0,"comparison":"Original to adjusted budget","percent_changed":-31.71},{"item":"Interest and investments","amount":-11551626.0,"comparison":"Original budget to audited outcome","percent_changed":-27.27},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":24594.0,"comparison":"Original budget to audited outcome","percent_changed":53.88},{"item":"Other","amount":436152.0,"comparison":"Original to adjusted budget","percent_changed":17.2},{"item":"Other","amount":-16883558.0,"comparison":"Original budget to audited outcome","percent_changed":-665.92},{"item":"Property rates","amount":-2603688.0,"comparison":"Original to adjusted budget","percent_changed":-3.74},{"item":"Property rates","amount":-3292441.0,"comparison":"Original budget to audited outcome","percent_changed":-4.72},{"item":"Rental income","amount":-506676.0,"comparison":"Original to adjusted budget","percent_changed":-27.17},{"item":"Rental income","amount":-517063.0,"comparison":"Original budget to audited outcome","percent_changed":-27.73},{"item":"Service Charges","amount":1721316.0,"comparison":"Original to adjusted budget","percent_changed":0.78},{"item":"Service Charges","amount":-1532846.0,"comparison":"Original budget to audited outcome","percent_changed":-0.7}],"2022":[{"item":"Fines","amount":25000.0,"comparison":"Original to adjusted budget","percent_changed":12.82},{"item":"Fines","amount":695770.0,"comparison":"Original budget to audited outcome","percent_changed":356.81},{"item":"Government Transfers","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Government Transfers","amount":774059.0,"comparison":"Original budget to audited outcome","percent_changed":0.36},{"item":"Interest and investments","amount":5404.0,"comparison":"Original to adjusted budget","percent_changed":0.01},{"item":"Interest and investments","amount":-5652906.0,"comparison":"Original budget to audited outcome","percent_changed":-12.63},{"item":"Licenses and Permits","amount":-45000.0,"comparison":"Original to adjusted budget","percent_changed":-60.0},{"item":"Licenses and Permits","amount":-23799.0,"comparison":"Original budget to audited outcome","percent_changed":-31.73},{"item":"Other","amount":-115436675.0,"comparison":"Original to adjusted budget","percent_changed":-97.94},{"item":"Other","amount":-118703133.0,"comparison":"Original budget to audited outcome","percent_changed":-100.71},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-5633843.0,"comparison":"Original budget to audited outcome","percent_changed":-8.0},{"item":"Rental income","amount":-6248.0,"comparison":"Original to adjusted budget","percent_changed":-0.43},{"item":"Rental income","amount":583453.0,"comparison":"Original budget to audited outcome","percent_changed":40.48},{"item":"Service Charges","amount":116207405.0,"comparison":"Original to adjusted budget","percent_changed":93.11},{"item":"Service Charges","amount":117082399.0,"comparison":"Original budget to audited outcome","percent_changed":93.81}],"2023":[{"item":"Fines","amount":-80004.0,"comparison":"Original to adjusted budget","percent_changed":-34.78},{"item":"Fines","amount":414446.0,"comparison":"Original budget to audited outcome","percent_changed":180.19},{"item":"Government Transfers","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Government Transfers","amount":302022.0,"comparison":"Original budget to audited outcome","percent_changed":0.13},{"item":"Interest and investments","amount":7116988.0,"comparison":"Original to adjusted budget","percent_changed":18.36},{"item":"Interest and investments","amount":19945045.0,"comparison":"Original budget to audited outcome","percent_changed":51.46},{"item":"Licenses and Permits","amount":-40004.0,"comparison":"Original to adjusted budget","percent_changed":-80.0},{"item":"Licenses and Permits","amount":-22748.0,"comparison":"Original budget to audited outcome","percent_changed":-45.49},{"item":"Other","amount":7619604.0,"comparison":"Original to adjusted budget","percent_changed":349.54},{"item":"Other","amount":10538805.0,"comparison":"Original budget to audited outcome","percent_changed":483.45},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-5582642.0,"comparison":"Original budget to audited outcome","percent_changed":-7.55},{"item":"Rental income","amount":74004.0,"comparison":"Original to adjusted budget","percent_changed":462.64},{"item":"Rental income","amount":1952559.0,"comparison":"Original budget to audited outcome","percent_changed":12206.55},{"item":"Service Charges","amount":-4758088.0,"comparison":"Original to adjusted budget","percent_changed":-1.84},{"item":"Service Charges","amount":-1522130.0,"comparison":"Original budget to audited outcome","percent_changed":-0.59}],"2024":[{"item":"Fines","amount":289992.0,"comparison":"Original to adjusted budget","percent_changed":2897.6},{"item":"Fines","amount":841842.0,"comparison":"Original budget to audited outcome","percent_changed":8411.69},{"item":"Government Transfers","amount":20000.0,"comparison":"Original to adjusted budget","percent_changed":0.01},{"item":"Government Transfers","amount":407001.0,"comparison":"Original budget to audited outcome","percent_changed":0.16},{"item":"Interest and investments","amount":23056632.0,"comparison":"Original to adjusted budget","percent_changed":52.91},{"item":"Interest and investments","amount":26976648.0,"comparison":"Original budget to audited outcome","percent_changed":61.9},{"item":"Licenses and Permits","amount":120000.0,"comparison":"Original to adjusted budget","percent_changed":2000.0},{"item":"Licenses and Permits","amount":83843.0,"comparison":"Original budget to audited outcome","percent_changed":1397.38},{"item":"Other","amount":721134.0,"comparison":"Original to adjusted budget","percent_changed":9.44},{"item":"Other","amount":-1037096.0,"comparison":"Original budget to audited outcome","percent_changed":-13.57},{"item":"Property rates","amount":5000000.0,"comparison":"Original to adjusted budget","percent_changed":6.51},{"item":"Property rates","amount":-5253764.0,"comparison":"Original budget to audited outcome","percent_changed":-6.85},{"item":"Rental income","amount":502802.0,"comparison":"Original to adjusted budget","percent_changed":39.4},{"item":"Rental income","amount":516446.0,"comparison":"Original budget to audited outcome","percent_changed":40.47},{"item":"Service Charges","amount":5477352.0,"comparison":"Original to adjusted budget","percent_changed":2.0},{"item":"Service Charges","amount":-8970616.0,"comparison":"Original budget to audited outcome","percent_changed":-3.28}]},"income_time_series":[{"amount":566463090.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":577079191.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":622099192.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":693753276.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":548642421.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":565451305.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":638192049.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":672129668.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":762005038.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":803775962.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":843965062.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":547806156.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":576329305.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":612166692.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":658565364.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":765500639.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":540264.0,"comparison":"Original to adjusted budget","percent_changed":0.64},{"item":"Bulk purchases","amount":-4508867.0,"comparison":"Original budget to audited outcome","percent_changed":-5.33},{"item":"Contracted services","amount":-101884.0,"comparison":"Original to adjusted budget","percent_changed":-0.37},{"item":"Contracted services","amount":-9918453.0,"comparison":"Original budget to audited outcome","percent_changed":-36.07},{"item":"Employee related costs","amount":-3525700.0,"comparison":"Original to adjusted budget","percent_changed":-1.67},{"item":"Employee related costs","amount":11138647.0,"comparison":"Original budget to audited outcome","percent_changed":5.27},{"item":"Finance charges","amount":-484528.0,"comparison":"Original to adjusted budget","percent_changed":-6.32},{"item":"Finance charges","amount":-2548271.0,"comparison":"Original budget to audited outcome","percent_changed":-33.25},{"item":"Other","amount":-24592740.0,"comparison":"Original to adjusted budget","percent_changed":-8.56},{"item":"Other","amount":277573696.0,"comparison":"Original budget to audited outcome","percent_changed":96.64},{"item":"Remuneration of councillors","amount":-1143000.0,"comparison":"Original to adjusted budget","percent_changed":-8.08},{"item":"Remuneration of councillors","amount":-1187350.0,"comparison":"Original budget to audited outcome","percent_changed":-8.39},{"item":"Transfers and subsidies","amount":19047472.0,"comparison":"Original to adjusted budget","percent_changed":86.38},{"item":"Transfers and subsidies","amount":8551261.0,"comparison":"Original budget to audited outcome","percent_changed":38.78}],"2022":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-3677666.0,"comparison":"Original budget to audited outcome","percent_changed":-3.8},{"item":"Contracted services","amount":-2871030.0,"comparison":"Original to adjusted budget","percent_changed":-11.08},{"item":"Contracted services","amount":-84602.0,"comparison":"Original budget to audited outcome","percent_changed":-0.33},{"item":"Employee related costs","amount":-30780520.0,"comparison":"Original to adjusted budget","percent_changed":-12.3},{"item":"Employee related costs","amount":-25794771.0,"comparison":"Original budget to audited outcome","percent_changed":-10.31},{"item":"Finance charges","amount":56000.0,"comparison":"Original to adjusted budget","percent_changed":1.4},{"item":"Finance charges","amount":660728.0,"comparison":"Original budget to audited outcome","percent_changed":16.52},{"item":"Other","amount":52780667.0,"comparison":"Original to adjusted budget","percent_changed":22.12},{"item":"Other","amount":208688859.0,"comparison":"Original budget to audited outcome","percent_changed":87.45},{"item":"Remuneration of councillors","amount":-788014.0,"comparison":"Original to adjusted budget","percent_changed":-5.49},{"item":"Remuneration of councillors","amount":-1483837.0,"comparison":"Original budget to audited outcome","percent_changed":-10.34},{"item":"Transfers and subsidies","amount":10135604.0,"comparison":"Original to adjusted budget","percent_changed":218.44},{"item":"Transfers and subsidies","amount":18058916.0,"comparison":"Original budget to audited outcome","percent_changed":389.21}],"2023":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-12545453.0,"comparison":"Original budget to audited outcome","percent_changed":-12.11},{"item":"Contracted services","amount":11296208.0,"comparison":"Original to adjusted budget","percent_changed":67.17},{"item":"Contracted services","amount":16695606.0,"comparison":"Original budget to audited outcome","percent_changed":99.27},{"item":"Employee related costs","amount":1331556.0,"comparison":"Original to adjusted budget","percent_changed":0.58},{"item":"Employee related costs","amount":-8085632.0,"comparison":"Original budget to audited outcome","percent_changed":-3.54},{"item":"Finance charges","amount":-380780.0,"comparison":"Original to adjusted budget","percent_changed":-24.49},{"item":"Finance charges","amount":1842392.0,"comparison":"Original budget to audited outcome","percent_changed":118.48},{"item":"Other","amount":-13328616.0,"comparison":"Original to adjusted budget","percent_changed":-5.68},{"item":"Other","amount":134827900.0,"comparison":"Original budget to audited outcome","percent_changed":57.43},{"item":"Remuneration of councillors","amount":1747144.0,"comparison":"Original to adjusted budget","percent_changed":13.94},{"item":"Remuneration of councillors","amount":1536982.0,"comparison":"Original budget to audited outcome","percent_changed":12.26},{"item":"Transfers and subsidies","amount":8883524.0,"comparison":"Original to adjusted budget","percent_changed":60.12},{"item":"Transfers and subsidies","amount":27495995.0,"comparison":"Original budget to audited outcome","percent_changed":186.09}],"2024":[{"item":"Bulk purchases","amount":-2074457.0,"comparison":"Original to adjusted budget","percent_changed":-1.68},{"item":"Bulk purchases","amount":-17096084.0,"comparison":"Original budget to audited outcome","percent_changed":-13.87},{"item":"Contracted services","amount":6486751.0,"comparison":"Original to adjusted budget","percent_changed":25.0},{"item":"Contracted services","amount":15197954.0,"comparison":"Original budget to audited outcome","percent_changed":58.57},{"item":"Employee related costs","amount":3871830.0,"comparison":"Original to adjusted budget","percent_changed":1.65},{"item":"Employee related costs","amount":3500516.0,"comparison":"Original budget to audited outcome","percent_changed":1.49},{"item":"Finance charges","amount":-1153094.0,"comparison":"Original to adjusted budget","percent_changed":-46.09},{"item":"Finance charges","amount":1063804.0,"comparison":"Original budget to audited outcome","percent_changed":42.52},{"item":"Other","amount":176905265.0,"comparison":"Original to adjusted budget","percent_changed":81.08},{"item":"Other","amount":222120801.0,"comparison":"Original budget to audited outcome","percent_changed":101.81},{"item":"Remuneration of councillors","amount":849437.0,"comparison":"Original to adjusted budget","percent_changed":5.8},{"item":"Remuneration of councillors","amount":99784.0,"comparison":"Original budget to audited outcome","percent_changed":0.68},{"item":"Transfers and subsidies","amount":-8342279.0,"comparison":"Original to adjusted budget","percent_changed":-21.42},{"item":"Transfers and subsidies","amount":-38872769.0,"comparison":"Original budget to audited outcome","percent_changed":-99.8}]},"spending_time_series":[{"amount":644158576.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":663277315.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":621934428.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":835042973.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":933519355.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":831112235.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":774153182.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":844513526.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":886833874.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":972022512.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":1020628350.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":654418692.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":634744608.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":612385392.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":658499520.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":925731824.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":64.61,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"bad","result":49.72,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"bad","result":59.27,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"bad","result":20.94,"overunder":"over","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":71494816.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":264897044.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":1792466.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":70556664.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":851850.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":89843.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":6602968.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.24},{"date":2023,"rating":"","result":28.45},{"date":2022,"rating":"","result":27.01},{"date":2021,"rating":"","result":23.83}],"formula":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp","item_codes":["3000","3100"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp_v2","item_codes":["3100"],"amount_type":"AUDA"}]},"result_type":"%"},"operating_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2024,"rating":"good","result":1.1,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"bad","result":24.5,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"bad","result":25.3,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"bad","result":44.9,"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":0.79,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0.4,"cube_version":"v2"},{"date":2022,"rating":"bad","result":0.37,"cube_version":"v2"},{"date":2021,"rating":"bad","result":0.27,"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.87},{"date":2023,"rating":"","result":4.33},{"date":2022,"rating":"","result":3.11},{"date":2021,"rating":"","result":1.88}],"formula":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp","item_codes":["4200"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp_v2","item_codes":["3800"],"amount_type":"AUDA"}]},"result_type":"%"},"current_debtors_collection_rate":{"ref":{"url":"http://mfma.treasury.gov.za/RegulationsandGazettes/Municipal%20Budget%20and%20Reporting%20Regulations/Pages/default.aspx","title":"Municipal Budget and Reporting Regulations"},"values":[{"date":"2024","year":2024,"rating":"bad","result":48.51,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"bad","result":59.05,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"bad","result":90.1,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"bad","result":73.47,"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":17684482.0},{"year":2022,"value":40622694.0},{"year":2023,"value":39626945.0},{"year":2024,"value":32177491.0},{"year":2025,"value":28609623.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":95867617.0},{"year":2022,"value":128554960.0},{"year":2023,"value":112727465.0},{"year":2024,"value":152035177.0},{"year":2025,"value":142980064.0}],"category":"Electricity "},{"values":[{"year":2021,"value":183253825.0},{"year":2022,"value":194423689.0},{"year":2023,"value":226592128.0},{"year":2024,"value":227563325.0},{"year":2025,"value":232475784.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2024,"value":-2635724.0}],"category":"Health"},{"values":[{"year":2021,"value":19780024.0},{"year":2022,"value":20747810.0},{"year":2023,"value":17383972.0},{"year":2024,"value":12893993.0},{"year":2025,"value":74035497.0}],"category":"Housing"},{"values":[{"year":2021,"value":405292333.0},{"year":2022,"value":172161613.0},{"year":2023,"value":111793919.0},{"year":2024,"value":92858392.0},{"year":2025,"value":85612558.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":10359553.0},{"year":2022,"value":10889752.0},{"year":2023,"value":11247508.0},{"year":2024,"value":12053638.0},{"year":2025,"value":12046297.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":51775317.0},{"year":2022,"value":60205532.0},{"year":2023,"value":50008326.0},{"year":2024,"value":73214520.0},{"year":2025,"value":91466795.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":53414436.0},{"year":2022,"value":79669252.0},{"year":2023,"value":71241912.0},{"year":2024,"value":69762182.0},{"year":2025,"value":79555178.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":96091768.0},{"year":2022,"value":123836933.0},{"year":2023,"value":133531007.0},{"year":2024,"value":174590532.0},{"year":2025,"value":140052078.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":"FS191"},"muni_contact":{"url":"http://www.setsoto.gov.za","phone_number":"051 933 9300","street_address_1":"Municipal Buildings","street_address_2":"27 Voortrekker Street","street_address_3":"Ficksburg","street_address_4":"9730"},"mayoral_staff":{"officials":[{"name":"Mbiwe Seipati Justine","role":"Mayor/Executive Mayor","email":"seipati@setsoto.co.za","title":"Ms","secretary":{"name":"Lebohang Mokhemesa","role":"Secretary of Mayor/Executive Mayor","email":"pamayor@setsoto.co.za","title":"Mr","fax_number":"051 933 9398","office_phone":"051 933 9395"},"fax_number":"051 933 9398","office_phone":"051 933 9396"},{"name":"N.F Malatjie","role":"Municipal Manager","email":"mm@setsoto.co.za","title":"Mrs","secretary":{"name":"Ntsekiseng Ramokgadi","role":"Secretary of Municipal Manager","email":"admin@setsoto.co.za","title":"Mr","fax_number":"051 933 9363","office_phone":"051 933 9302"},"fax_number":"051 933 9636","office_phone":"051 933 9302"},{"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":"Daniel Van Tonder","role":"Chief Financial Officer","email":"nielvt@setsoto.co.za","title":"Mr","secretary":{"name":"Maletswela Nchodu","role":"Secretary of Financial Manager","email":"finance@setsoto.co.za","title":"Ms","fax_number":" ","office_phone":"051 933 9301"},"fax_number":" ","office_phone":"051 933 9316"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/FS191/FS191_Audit%20Report_2024_Y_20250128T084459Z_rosep.pdf"},{"date":2023,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/FS191/FS191_Audit%20Report_2023_Y_20240123T121950Z_rosep.pdf"},{"date":2022,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/FS191/FS191_Audit%20Report_2022_Y_20230316T093314Z_rosep.pdf"},{"date":2021,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/FS191/FS191_Audit%20Report_2021_Y_20220525T143010Z_nielvt.pdf"}]}}