{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":40049434.0,"national_conditional_grants":28014515.0},"ORGB":{"equitable_share":174760000.0,"national_conditional_grants":179215000.0},"SCHD":{"national_conditional_grants":165683000.0},"TRFR":{"national_conditional_grants":62076000.0}},"2022":{"ACT":{"national_conditional_grants":102735850.0},"ORGB":{"equitable_share":185019000.0,"national_conditional_grants":271438000.0},"SCHD":{"national_conditional_grants":334166000.0},"TRFR":{"national_conditional_grants":184516000.0}},"2023":{"ACT":{"national_conditional_grants":167292611.0},"ORGB":{"equitable_share":210902000.0,"provincial_transfers":1200000.0,"national_conditional_grants":280473000.0},"SCHD":{"national_conditional_grants":308742000.0},"TRFR":{"national_conditional_grants":167050000.0}},"2024":{"ACT":{"national_conditional_grants":171499312.0},"ORGB":{"equitable_share":230911000.0,"national_conditional_grants":325094000.0},"SCHD":{"national_conditional_grants":277726000.0},"TRFR":{"national_conditional_grants":155645000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":40049434.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":174760000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":185019000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":210902000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":230911000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":1200000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023}]},"national_conditional_grants":{"2021":[{"amount.sum":179000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":179000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":112200.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","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":33985000.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":10751000.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":9675359.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":33985000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":10751000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":8496227.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":52954000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":17000000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":277020.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1580000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":395000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":9453709.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":40000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":20000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021}],"2022":[{"amount.sum":2537172.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":149650000.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":28624752.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":56000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":56000000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":52531506.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":56267000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":56267000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":27346000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":27346000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1464450.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":1421000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1421000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":17577970.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":40382000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":40382000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":4999869.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":5000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":5000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":3100010.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":141692000.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":33302313.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":31250000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":31250000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":58630435.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":75738000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":75738000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":21079106.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":13485000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":13485000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1519000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1519000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1519000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":44661878.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":36958000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":36958000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":3513288.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":3100037.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":122081000.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":39511713.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":43025000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":43025000.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":73532165.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":56159000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":56159000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":9999915.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":10000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":10000000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1111008.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1111000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1111000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":40731186.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":42250000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":42250000.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":140989944.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":55715283.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":133162739.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":273644746.0,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"}]},"result_type":"R"},"cash_coverage":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"ave","result":2.2,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0.9,"cube_version":"v2"},{"date":2022,"rating":"ave","result":2.9,"cube_version":"v2"},{"date":2021,"rating":"good","result":6.3,"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":168932491.0,"rating":"bad","result":0.74,"amount_type":"AUDA","liabilities":228181037.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":148971650.0,"rating":"ave","result":1.02,"amount_type":"AUDA","liabilities":145945449.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":272741150.0,"rating":"good","result":2.02,"amount_type":"AUDA","liabilities":135142379.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":253150864.0,"rating":"good","result":2.77,"amount_type":"AUDA","liabilities":91228347.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":36946340.0,"date":"2024","year":2024,"rating":"bad","result":0.16,"amount_type":"ACT","liabilities":228181037.0,"cube_version":"v2","call_investment_deposits":0},{"cash":38209997.0,"date":"2023","year":2023,"rating":"bad","result":0.26,"amount_type":"ACT","liabilities":145945449.0,"cube_version":"v2","call_investment_deposits":0},{"cash":96367414.0,"date":"2022","year":2022,"rating":"bad","result":0.71,"amount_type":"ACT","liabilities":135142379.0,"cube_version":"v2","call_investment_deposits":0},{"cash":90467141.0,"date":"2021","year":2021,"rating":"bad","result":0.99,"amount_type":"ACT","liabilities":91228347.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":334694366.0,"percent":56.93},"total":587893746.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":253199380.0,"percent":43.07}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":23.29,"cube_version":"v2"},{"date":2023,"rating":"bad","result":13.89,"cube_version":"v2"},{"date":2022,"rating":"bad","result":36.67,"cube_version":"v2"},{"date":2021,"rating":"bad","result":16.62,"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":-85000.0,"comparison":"Original to adjusted budget","percent_changed":-2.69},{"item":"Fines","amount":263242.0,"comparison":"Original budget to audited outcome","percent_changed":8.34},{"item":"Government Transfers","amount":51250983.0,"comparison":"Original to adjusted budget","percent_changed":27.91},{"item":"Government Transfers","amount":14930087.0,"comparison":"Original budget to audited outcome","percent_changed":8.13},{"item":"Interest and investments","amount":-440000.0,"comparison":"Original to adjusted budget","percent_changed":-4.11},{"item":"Interest and investments","amount":-1787186.0,"comparison":"Original budget to audited outcome","percent_changed":-16.7},{"item":"Licenses and Permits","amount":15000.0,"comparison":"Original to adjusted budget","percent_changed":0.45},{"item":"Licenses and Permits","amount":34042.0,"comparison":"Original budget to audited outcome","percent_changed":1.03},{"item":"Other","amount":125010.0,"comparison":"Original to adjusted budget","percent_changed":1.49},{"item":"Other","amount":3371128.0,"comparison":"Original budget to audited outcome","percent_changed":40.11},{"item":"Property rates","amount":-1491353.0,"comparison":"Original to adjusted budget","percent_changed":-2.99},{"item":"Property rates","amount":-90006.0,"comparison":"Original budget to audited outcome","percent_changed":-0.18},{"item":"Rental income","amount":-40000.0,"comparison":"Original to adjusted budget","percent_changed":-1.91},{"item":"Rental income","amount":389292.0,"comparison":"Original budget to audited outcome","percent_changed":18.62},{"item":"Service Charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":-12717288.0,"comparison":"Original budget to audited outcome","percent_changed":-7.44}],"2022":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":3326642.0,"comparison":"Original budget to audited outcome","percent_changed":211.67},{"item":"Government Transfers","amount":8290944.0,"comparison":"Original to adjusted budget","percent_changed":4.03},{"item":"Government Transfers","amount":8898415.0,"comparison":"Original budget to audited outcome","percent_changed":4.32},{"item":"Interest and investments","amount":-2850000.0,"comparison":"Original to adjusted budget","percent_changed":-24.99},{"item":"Interest and investments","amount":-2254204.0,"comparison":"Original budget to audited outcome","percent_changed":-19.76},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":361682.0,"comparison":"Original budget to audited outcome","percent_changed":10.9},{"item":"Other","amount":8992732.0,"comparison":"Original to adjusted budget","percent_changed":67.45},{"item":"Other","amount":2621396.0,"comparison":"Original budget to audited outcome","percent_changed":19.66},{"item":"Property rates","amount":-1870956.0,"comparison":"Original to adjusted budget","percent_changed":-3.37},{"item":"Property rates","amount":-5513820.0,"comparison":"Original budget to audited outcome","percent_changed":-9.93},{"item":"Rental income","amount":-639000.0,"comparison":"Original to adjusted budget","percent_changed":-29.94},{"item":"Rental income","amount":1490368.0,"comparison":"Original budget to audited outcome","percent_changed":69.84},{"item":"Service Charges","amount":2700000.0,"comparison":"Original to adjusted budget","percent_changed":1.27},{"item":"Service Charges","amount":-34343874.0,"comparison":"Original budget to audited outcome","percent_changed":-16.2}],"2023":[{"item":"Fines","amount":-50000.0,"comparison":"Original to adjusted budget","percent_changed":-3.1},{"item":"Fines","amount":5945338.0,"comparison":"Original budget to audited outcome","percent_changed":369.14},{"item":"Government Transfers","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Government Transfers","amount":3506154.0,"comparison":"Original budget to audited outcome","percent_changed":1.52},{"item":"Interest and investments","amount":1550000.0,"comparison":"Original to adjusted budget","percent_changed":17.29},{"item":"Interest and investments","amount":2360722.0,"comparison":"Original budget to audited outcome","percent_changed":26.33},{"item":"Licenses and Permits","amount":50000.0,"comparison":"Original to adjusted budget","percent_changed":1.44},{"item":"Licenses and Permits","amount":165191.0,"comparison":"Original budget to audited outcome","percent_changed":4.75},{"item":"Other","amount":1601486.0,"comparison":"Original to adjusted budget","percent_changed":8.48},{"item":"Other","amount":-1396499.0,"comparison":"Original budget to audited outcome","percent_changed":-7.39},{"item":"Property rates","amount":2842836.0,"comparison":"Original to adjusted budget","percent_changed":5.49},{"item":"Property rates","amount":3181272.0,"comparison":"Original budget to audited outcome","percent_changed":6.15},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":1268379.0,"comparison":"Original budget to audited outcome","percent_changed":79.03},{"item":"Service Charges","amount":2811475.0,"comparison":"Original to adjusted budget","percent_changed":1.14},{"item":"Service Charges","amount":-65711338.0,"comparison":"Original budget to audited outcome","percent_changed":-26.69}],"2024":[{"item":"Fines","amount":55000.0,"comparison":"Original to adjusted budget","percent_changed":3.34},{"item":"Fines","amount":6603348.0,"comparison":"Original budget to audited outcome","percent_changed":401.56},{"item":"Government Transfers","amount":16596257.0,"comparison":"Original to adjusted budget","percent_changed":6.93},{"item":"Government Transfers","amount":13825380.0,"comparison":"Original budget to audited outcome","percent_changed":5.78},{"item":"Interest and investments","amount":4096848.0,"comparison":"Original to adjusted budget","percent_changed":36.19},{"item":"Interest and investments","amount":9768423.0,"comparison":"Original budget to audited outcome","percent_changed":86.29},{"item":"Licenses and Permits","amount":250000.0,"comparison":"Original to adjusted budget","percent_changed":6.73},{"item":"Licenses and Permits","amount":249666.0,"comparison":"Original budget to audited outcome","percent_changed":6.72},{"item":"Other","amount":57388613.0,"comparison":"Original to adjusted budget","percent_changed":225.52},{"item":"Other","amount":-17245149.0,"comparison":"Original budget to audited outcome","percent_changed":-67.77},{"item":"Property rates","amount":2016000.0,"comparison":"Original to adjusted budget","percent_changed":3.48},{"item":"Property rates","amount":410532.0,"comparison":"Original budget to audited outcome","percent_changed":0.71},{"item":"Rental income","amount":1.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":-344717.0,"comparison":"Original budget to audited outcome","percent_changed":-20.4},{"item":"Service Charges","amount":4450000.0,"comparison":"Original to adjusted budget","percent_changed":1.58},{"item":"Service Charges","amount":-48622768.0,"comparison":"Original budget to audited outcome","percent_changed":-17.23}]},"income_time_series":[{"amount":481326600.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":519597793.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":572592626.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":708101750.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":436385271.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":479560678.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":513106048.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":587893746.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":689798710.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":661695756.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":681219968.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":431991960.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":504974073.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":563786829.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":623249031.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":628692789.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":7758195.0,"comparison":"Original budget to audited outcome","percent_changed":8.46},{"item":"Contracted services","amount":7292886.0,"comparison":"Original to adjusted budget","percent_changed":16.32},{"item":"Contracted services","amount":2744450.0,"comparison":"Original budget to audited outcome","percent_changed":6.14},{"item":"Employee related costs","amount":-9515042.0,"comparison":"Original to adjusted budget","percent_changed":-6.09},{"item":"Employee related costs","amount":-2256042.0,"comparison":"Original budget to audited outcome","percent_changed":-1.44},{"item":"Finance charges","amount":-4214000.0,"comparison":"Original to adjusted budget","percent_changed":-69.48},{"item":"Finance charges","amount":4397568.0,"comparison":"Original budget to audited outcome","percent_changed":72.51},{"item":"Other","amount":15270782.0,"comparison":"Original to adjusted budget","percent_changed":9.01},{"item":"Other","amount":31088303.0,"comparison":"Original budget to audited outcome","percent_changed":18.35},{"item":"Remuneration of councillors","amount":86856.0,"comparison":"Original to adjusted budget","percent_changed":0.83},{"item":"Remuneration of councillors","amount":-613711.0,"comparison":"Original budget to audited outcome","percent_changed":-5.87},{"item":"Transfers and subsidies","amount":10375001.0,"comparison":"Original to adjusted budget","percent_changed":16483.95},{"item":"Transfers and subsidies","amount":-39384.0,"comparison":"Original budget to audited outcome","percent_changed":-62.57}],"2022":[{"item":"Bulk purchases","amount":17000000.0,"comparison":"Original to adjusted budget","percent_changed":18.01},{"item":"Bulk purchases","amount":26304722.0,"comparison":"Original budget to audited outcome","percent_changed":27.86},{"item":"Contracted services","amount":-12162539.0,"comparison":"Original to adjusted budget","percent_changed":-21.51},{"item":"Contracted services","amount":19533928.0,"comparison":"Original budget to audited outcome","percent_changed":34.55},{"item":"Employee related costs","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Employee related costs","amount":5309140.0,"comparison":"Original budget to audited outcome","percent_changed":3.17},{"item":"Finance charges","amount":3392.0,"comparison":"Original to adjusted budget","percent_changed":0.38},{"item":"Finance charges","amount":5614799.0,"comparison":"Original budget to audited outcome","percent_changed":623.49},{"item":"Other","amount":16918626.0,"comparison":"Original to adjusted budget","percent_changed":9.65},{"item":"Other","amount":-13898718.0,"comparison":"Original budget to audited outcome","percent_changed":-7.93},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-365885.0,"comparison":"Original budget to audited outcome","percent_changed":-3.38},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Transfers and subsidies","amount":-30000.0,"comparison":"Original budget to audited outcome","percent_changed":-50.0}],"2023":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":2237212.0,"comparison":"Original budget to audited outcome","percent_changed":1.83},{"item":"Contracted services","amount":11673500.0,"comparison":"Original to adjusted budget","percent_changed":13.9},{"item":"Contracted services","amount":13377953.0,"comparison":"Original budget to audited outcome","percent_changed":15.93},{"item":"Employee related costs","amount":-3648180.0,"comparison":"Original to adjusted budget","percent_changed":-1.92},{"item":"Employee related costs","amount":3673476.0,"comparison":"Original budget to audited outcome","percent_changed":1.93},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":2447890.0,"comparison":"Original budget to audited outcome","percent_changed":263.16},{"item":"Other","amount":4589290.0,"comparison":"Original to adjusted budget","percent_changed":2.64},{"item":"Other","amount":117536493.0,"comparison":"Original budget to audited outcome","percent_changed":67.71},{"item":"Remuneration of councillors","amount":2023453.0,"comparison":"Original to adjusted budget","percent_changed":18.26},{"item":"Remuneration of councillors","amount":2103607.0,"comparison":"Original budget to audited outcome","percent_changed":18.98},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Transfers and subsidies","amount":-1000.0,"comparison":"Original budget to audited outcome","percent_changed":-1.6}],"2024":[{"item":"Bulk purchases","amount":1000000.0,"comparison":"Original to adjusted budget","percent_changed":0.77},{"item":"Bulk purchases","amount":22962060.0,"comparison":"Original budget to audited outcome","percent_changed":17.66},{"item":"Contracted services","amount":32180637.0,"comparison":"Original to adjusted budget","percent_changed":45.74},{"item":"Contracted services","amount":45458851.0,"comparison":"Original budget to audited outcome","percent_changed":64.62},{"item":"Employee related costs","amount":-5195717.0,"comparison":"Original to adjusted budget","percent_changed":-2.08},{"item":"Employee related costs","amount":1687704.0,"comparison":"Original budget to audited outcome","percent_changed":0.68},{"item":"Finance charges","amount":255000.0,"comparison":"Original to adjusted budget","percent_changed":26.13},{"item":"Finance charges","amount":3022708.0,"comparison":"Original budget to audited outcome","percent_changed":309.77},{"item":"Other","amount":-3044266.0,"comparison":"Original to adjusted budget","percent_changed":-1.66},{"item":"Other","amount":30388969.0,"comparison":"Original budget to audited outcome","percent_changed":16.53},{"item":"Remuneration of councillors","amount":1302177.0,"comparison":"Original to adjusted budget","percent_changed":9.6},{"item":"Remuneration of councillors","amount":1242436.0,"comparison":"Original budget to audited outcome","percent_changed":9.16},{"item":"Transfers and subsidies","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Transfers and subsidies","amount":-34688.0,"comparison":"Original budget to audited outcome","percent_changed":-52.99}]},"spending_time_series":[{"amount":497868303.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":527483480.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":596437702.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":674672728.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":521651199.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":548191987.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":723175270.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":752902937.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":785624395.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":715179510.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":748272411.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":478571820.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":505724001.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":581799639.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":648174897.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":686086824.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":"ave","result":-14.2,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"good","result":-4.31,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"ave","result":-6.69,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"ave","result":-11.14,"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":58349026.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":233497379.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":1344793.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":21088634.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":8247790.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":3964437.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":8202307.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":33.34},{"date":2023,"rating":"","result":26.76},{"date":2022,"rating":"","result":31.57},{"date":2021,"rating":"","result":29.52}],"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":11.6,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"bad","result":21.2,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"good","result":3.9,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"good","result":4.8,"overunder":"over","cube_version":"v2"}],"formula":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"-",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","/",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"-",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","*","100"]},"result_type":"%"},"repairs_maintenance_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":0.98,"cube_version":"v2"},{"date":2023,"rating":"bad","result":1.99,"cube_version":"v2"},{"date":2022,"rating":"bad","result":1.79,"cube_version":"v2"},{"date":2021,"rating":"bad","result":1.3,"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":15.38},{"date":2023,"rating":"","result":13.46},{"date":2022,"rating":"","result":13.88},{"date":2021,"rating":"","result":9.09}],"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":92.66,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"good","result":95.92,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"good","result":99.2,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"good","result":99.98,"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":33002987.0},{"year":2022,"value":36940298.0},{"year":2023,"value":45574170.0},{"year":2024,"value":54791589.0},{"year":2025,"value":66478276.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":118632969.0},{"year":2022,"value":142310556.0},{"year":2023,"value":179301371.0},{"year":2024,"value":176105671.0},{"year":2025,"value":218303402.0}],"category":"Electricity "},{"values":[{"year":2021,"value":184652.0},{"year":2022,"value":201416.0},{"year":2023,"value":205367.0},{"year":2024,"value":281565.0},{"year":2025,"value":276020.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":286387165.0},{"year":2022,"value":280307946.0},{"year":2023,"value":287948887.0},{"year":2024,"value":303607316.0},{"year":2025,"value":307060130.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2023,"value":165800.0}],"category":"Other"},{"values":[{"year":2021,"value":9904910.0},{"year":2022,"value":10446755.0},{"year":2023,"value":44328443.0},{"year":2024,"value":41471064.0},{"year":2025,"value":44208011.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":8702937.0},{"year":2022,"value":9629244.0},{"year":2023,"value":12116508.0},{"year":2024,"value":16235741.0},{"year":2025,"value":18750990.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":22077334.0},{"year":2022,"value":19833034.0},{"year":2023,"value":29754477.0},{"year":2024,"value":36636929.0},{"year":2025,"value":22910305.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":4966402.0},{"year":2022,"value":15371910.0},{"year":2023,"value":46820622.0},{"year":2024,"value":44083407.0},{"year":2025,"value":21491556.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":37791843.0},{"year":2022,"value":33150828.0},{"year":2023,"value":76959625.0},{"year":2024,"value":79689655.0},{"year":2025,"value":86145705.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":"NC452"},"muni_contact":{"url":"http://www.ga-segonyana.gov.za","phone_number":"053 712 9300","street_address_1":"Municipal Building","street_address_2":"Cnr Voortrekker and School Street","street_address_3":"Kuruman","street_address_4":"8460"},"mayoral_staff":{"officials":[{"name":"Neo Masegela","role":"Mayor/Executive Mayor","email":"nmasegela@ga-segonyana.gov.za","title":"Mr","secretary":{"name":"Tshegofatso Serai","role":"Secretary of Mayor/Executive Mayor","email":"tserai@ga-segonyana.gov.za","title":"Mrs","fax_number":"053 712 3581","office_phone":"053 712 9404"},"fax_number":"053 712 3581","office_phone":"053 712 9389"},{"name":"Martin Tsatsimpe","role":"Municipal Manager","email":"mtsatsimpe@ga-segonyana.gov.za","title":"Mr","secretary":{"name":"Kobamelo Gaobusiwe","role":"Secretary of Municipal Manager","email":"kgaobusiwe@ga-segonyana.gov.za","title":"Ms","fax_number":"053 712 3581","office_phone":"053 712 9301"},"fax_number":"053 712 3581","office_phone":"053 712 9333"},{"name":"Tshegofatso Jarvis","role":"Deputy Mayor/Executive Mayor","email":"tshego.jarvis@gmail.com","title":"Mrs","secretary":{"name":"Tshegofatso Jarvis","role":"Secretary of Deputy Mayor/Executive Mayor","email":"tshego.jarvis@gmail.com","title":"Mrs","fax_number":" ","office_phone":"053 712 9345"},"fax_number":" ","office_phone":"053 712 9345"},{"name":"Levy Mashiane","role":"Chief Financial Officer","email":"gelimashiane@gmail.com","title":"Mr","secretary":{"name":"Lt Booysen","role":"Secretary of Financial Manager","email":"l.booysen@ga-segonyana.gov.za","title":"Ms","fax_number":"086 532 8495","office_phone":"053 712 9415"},"fax_number":" ","office_phone":"053 712 9370"}],"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/NC452/NC452_Audit%20Report_2024_Y_20250108T150230Z_confy.pdf"},{"date":2023,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/NC452/NC452_Audit%20Report_2023_Y_20240205T110156Z_dpelele.pdf"},{"date":2022,"rating":"qualified","result":"Qualified","report_url":"https://lg.treasury.gov.za/supportingdocs/NC452/NC452_Audit%20Report_2022_Y_20230214T162731Z_dpelele.pdf"},{"date":2021,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/NC452/NC452_Audit%20Report_2021_Y_20220307T124938Z_dpelele.pdf"}]}}