{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":1853595.0,"national_conditional_grants":6237852.0},"ORGB":{"equitable_share":138115000.0,"national_conditional_grants":62542000.0},"SCHD":{"national_conditional_grants":62542000.0},"TRFR":{"national_conditional_grants":25710000.0}},"2022":{"ORGB":{"equitable_share":143541000.0,"national_conditional_grants":94579000.0},"SCHD":{"national_conditional_grants":94579000.0},"TRFR":{"national_conditional_grants":74118000.0}},"2023":{"ORGB":{"equitable_share":159404000.0,"provincial_transfers":7338000.0,"national_conditional_grants":105633000.0},"SCHD":{"national_conditional_grants":105633000.0},"TRFR":{"national_conditional_grants":66426000.0}},"2024":{"ORGB":{"equitable_share":171953000.0,"national_conditional_grants":107655000.0},"SCHD":{"national_conditional_grants":108176000.0},"TRFR":{"national_conditional_grants":90266000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":1853595.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":138115000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":143541000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":159404000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":171953000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":6339000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":999000.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":358000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":358000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":3000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":3000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":6237852.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":28042000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":2066000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1142000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":286000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":30000000.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":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":20461000.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":39632000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":39632000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1386000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1386000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":30000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":30000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022}],"2023":[{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"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":39207000.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":31782000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":31782000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1544000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1544000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":30000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":30000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023}],"2024":[{"amount.sum":3100000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"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":17910000.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":30850000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":30850000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1316000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1316000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":55000000.0,"grant.code":"WSIG","grant.label":"Water Services Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":55000000.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":1104033266.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":410764161.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":411834124.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":320938452.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":16.6,"cube_version":"v2"},{"date":2023,"rating":"good","result":5.9,"cube_version":"v2"},{"date":2022,"rating":"good","result":7.6,"cube_version":"v2"},{"date":2021,"rating":"good","result":6.6,"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":206992196.0,"rating":"bad","result":0.31,"amount_type":"AUDA","liabilities":667843675.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":225756402.0,"rating":"bad","result":0.36,"amount_type":"AUDA","liabilities":622855382.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":142356088.0,"rating":"bad","result":0.2,"amount_type":"AUDA","liabilities":699431648.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":309682396.0,"rating":"bad","result":0.44,"amount_type":"AUDA","liabilities":701439617.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":3240935.0,"date":"2024","year":2024,"rating":"bad","result":0.0,"amount_type":"ACT","liabilities":667843675.0,"cube_version":"v2","call_investment_deposits":0},{"cash":26226988.0,"date":"2023","year":2023,"rating":"bad","result":0.04,"amount_type":"ACT","liabilities":622855382.0,"cube_version":"v2","call_investment_deposits":0},{"cash":12882138.0,"date":"2022","year":2022,"rating":"bad","result":0.02,"amount_type":"ACT","liabilities":699431648.0,"cube_version":"v2","call_investment_deposits":0},{"cash":21953943.0,"date":"2021","year":2021,"rating":"bad","result":0.03,"amount_type":"ACT","liabilities":701439617.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":435027809.0,"percent":67.76},"total":642008401.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":206980592.0,"percent":32.24}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":31.26,"cube_version":"v2"},{"date":2023,"rating":"bad","result":6.81,"cube_version":"v2"},{"date":2022,"rating":"bad","result":35.72,"cube_version":"v2"},{"date":2021,"rating":"bad","result":24.94,"cube_version":"v2"}],"formula":{"text":"= (Unauthorised, Irregular, Fruitless and Wasteful Expenditure / Actual Operating Expenditure) * 100","actual":["=","(",{"cube":"uifwexp","item_codes":["irregular","fruitless","unauthorised"]},"/",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= (Unauthorised, Irregular, Fruitless and Wasteful Expenditure / Actual Operating Expenditure) * 100","actual":["=","(",{"cube":"uifwexp","item_codes":["irregular","fruitless","unauthorised"]},"/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},")","*","100"]},"result_type":"%"},"income_adjustments":{"2021":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":-3333821.0,"comparison":"Original budget to audited outcome","percent_changed":-44.45},{"item":"Government Transfers","amount":-4520757.0,"comparison":"Original to adjusted budget","percent_changed":-2.65},{"item":"Government Transfers","amount":18526746.0,"comparison":"Original budget to audited outcome","percent_changed":10.88},{"item":"Interest and investments","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":-10169437.0,"comparison":"Original budget to audited outcome","percent_changed":-12.84},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-15185788.0,"comparison":"Original budget to audited outcome","percent_changed":-87.53},{"item":"Other","amount":-1943891.0,"comparison":"Original to adjusted budget","percent_changed":-53.54},{"item":"Other","amount":2800317.0,"comparison":"Original budget to audited outcome","percent_changed":77.13},{"item":"Property rates","amount":6978000.0,"comparison":"Original to adjusted budget","percent_changed":15.72},{"item":"Property rates","amount":9227782.0,"comparison":"Original budget to audited outcome","percent_changed":20.79},{"item":"Rental income","amount":246000.0,"comparison":"Original to adjusted budget","percent_changed":49.2},{"item":"Rental income","amount":-218153.0,"comparison":"Original budget to audited outcome","percent_changed":-43.63},{"item":"Service Charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":32128953.0,"comparison":"Original budget to audited outcome","percent_changed":16.99}],"2022":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":-7001888.0,"comparison":"Original budget to audited outcome","percent_changed":-66.56},{"item":"Government Transfers","amount":807331.0,"comparison":"Original to adjusted budget","percent_changed":0.55},{"item":"Government Transfers","amount":36638457.0,"comparison":"Original budget to audited outcome","percent_changed":24.74},{"item":"Interest and investments","amount":-2000.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":-287946.0,"comparison":"Original budget to audited outcome","percent_changed":-0.33},{"item":"Licenses and Permits","amount":1700000.0,"comparison":"Original to adjusted budget","percent_changed":11.89},{"item":"Licenses and Permits","amount":-10179076.0,"comparison":"Original budget to audited outcome","percent_changed":-71.18},{"item":"Other","amount":-686290.0,"comparison":"Original to adjusted budget","percent_changed":-27.85},{"item":"Other","amount":10128437.0,"comparison":"Original budget to audited outcome","percent_changed":411.02},{"item":"Property rates","amount":-7116952.0,"comparison":"Original to adjusted budget","percent_changed":-11.7},{"item":"Property rates","amount":-9505624.0,"comparison":"Original budget to audited outcome","percent_changed":-15.62},{"item":"Rental income","amount":522504.0,"comparison":"Original to adjusted budget","percent_changed":60.55},{"item":"Rental income","amount":-540931.0,"comparison":"Original budget to audited outcome","percent_changed":-62.68},{"item":"Service Charges","amount":24589976.0,"comparison":"Original to adjusted budget","percent_changed":12.12},{"item":"Service Charges","amount":-21146355.0,"comparison":"Original budget to audited outcome","percent_changed":-10.43}],"2023":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":-3451500.0,"comparison":"Original budget to audited outcome","percent_changed":-62.75},{"item":"Government Transfers","amount":1474566.0,"comparison":"Original to adjusted budget","percent_changed":0.89},{"item":"Government Transfers","amount":35166459.0,"comparison":"Original budget to audited outcome","percent_changed":21.31},{"item":"Interest and investments","amount":36895724.0,"comparison":"Original to adjusted budget","percent_changed":43.39},{"item":"Interest and investments","amount":44545771.0,"comparison":"Original budget to audited outcome","percent_changed":52.39},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-11955705.0,"comparison":"Original budget to audited outcome","percent_changed":-74.96},{"item":"Other","amount":-1.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Other","amount":144985328.0,"comparison":"Original budget to audited outcome","percent_changed":1897.81},{"item":"Property rates","amount":8715053.0,"comparison":"Original to adjusted budget","percent_changed":13.81},{"item":"Property rates","amount":6764033.0,"comparison":"Original budget to audited outcome","percent_changed":10.72},{"item":"Rental income","amount":-443034.0,"comparison":"Original to adjusted budget","percent_changed":-67.83},{"item":"Rental income","amount":-93656.0,"comparison":"Original budget to audited outcome","percent_changed":-14.34},{"item":"Service Charges","amount":-7342871.0,"comparison":"Original to adjusted budget","percent_changed":-3.52},{"item":"Service Charges","amount":-38220620.0,"comparison":"Original budget to audited outcome","percent_changed":-18.31}],"2024":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":-4786490.0,"comparison":"Original budget to audited outcome","percent_changed":-83.97},{"item":"Government Transfers","amount":1060756.0,"comparison":"Original to adjusted budget","percent_changed":0.6},{"item":"Government Transfers","amount":30177298.0,"comparison":"Original budget to audited outcome","percent_changed":17.07},{"item":"Interest and investments","amount":13252352.0,"comparison":"Original to adjusted budget","percent_changed":10.32},{"item":"Interest and investments","amount":33676243.0,"comparison":"Original budget to audited outcome","percent_changed":26.23},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-10654245.0,"comparison":"Original budget to audited outcome","percent_changed":-80.03},{"item":"Other","amount":245000.0,"comparison":"Original to adjusted budget","percent_changed":184.91},{"item":"Other","amount":28421475.0,"comparison":"Original budget to audited outcome","percent_changed":21450.17},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-9393594.0,"comparison":"Original budget to audited outcome","percent_changed":-12.39},{"item":"Rental income","amount":42000.0,"comparison":"Original to adjusted budget","percent_changed":14.0},{"item":"Rental income","amount":1935356.0,"comparison":"Original budget to audited outcome","percent_changed":645.12},{"item":"Service Charges","amount":-41530350.0,"comparison":"Original to adjusted budget","percent_changed":-18.91},{"item":"Service Charges","amount":-47436566.0,"comparison":"Original budget to audited outcome","percent_changed":-21.6}]},"income_time_series":[{"amount":512656333.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":546230729.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":590945829.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":593138682.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":545673580.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":524521234.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":729386502.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":642008401.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":644999364.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":658589845.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":682862550.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":511896981.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":526416160.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":551646392.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":620068924.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":633671720.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2022":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":23144351.0,"comparison":"Original budget to audited outcome","percent_changed":40.07},{"item":"Contracted services","amount":20469773.0,"comparison":"Original to adjusted budget","percent_changed":221.58},{"item":"Contracted services","amount":23608344.0,"comparison":"Original budget to audited outcome","percent_changed":255.56},{"item":"Employee related costs","amount":-3642786.0,"comparison":"Original to adjusted budget","percent_changed":-3.51},{"item":"Employee related costs","amount":-12597468.0,"comparison":"Original budget to audited outcome","percent_changed":-12.14},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":2477225.0,"comparison":"Original budget to audited outcome","percent_changed":36.24},{"item":"Other","amount":9599031.0,"comparison":"Original to adjusted budget","percent_changed":2.41},{"item":"Other","amount":29394426.0,"comparison":"Original budget to audited outcome","percent_changed":7.37},{"item":"Remuneration of councillors","amount":106930.0,"comparison":"Original to adjusted budget","percent_changed":1.06},{"item":"Remuneration of councillors","amount":-1094114.0,"comparison":"Original budget to audited outcome","percent_changed":-10.88}],"2023":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":5645150.0,"comparison":"Original budget to audited outcome","percent_changed":8.67},{"item":"Contracted services","amount":10447945.0,"comparison":"Original to adjusted budget","percent_changed":58.88},{"item":"Contracted services","amount":25285873.0,"comparison":"Original budget to audited outcome","percent_changed":142.51},{"item":"Employee related costs","amount":1675313.0,"comparison":"Original to adjusted budget","percent_changed":1.41},{"item":"Employee related costs","amount":-18225601.0,"comparison":"Original budget to audited outcome","percent_changed":-15.38},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":11041249.0,"comparison":"Original budget to audited outcome","percent_changed":223.27},{"item":"Other","amount":20732569.0,"comparison":"Original to adjusted budget","percent_changed":7.04},{"item":"Other","amount":298651615.0,"comparison":"Original budget to audited outcome","percent_changed":101.37},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":330592.0,"comparison":"Original budget to audited outcome","percent_changed":3.52}],"2024":[{"item":"Bulk purchases","amount":-10288032.0,"comparison":"Original to adjusted budget","percent_changed":-15.0},{"item":"Bulk purchases","amount":7448145.0,"comparison":"Original budget to audited outcome","percent_changed":10.86},{"item":"Contracted services","amount":9004681.0,"comparison":"Original to adjusted budget","percent_changed":38.51},{"item":"Contracted services","amount":19427600.0,"comparison":"Original budget to audited outcome","percent_changed":83.08},{"item":"Employee related costs","amount":3101816.0,"comparison":"Original to adjusted budget","percent_changed":2.51},{"item":"Employee related costs","amount":-9295830.0,"comparison":"Original budget to audited outcome","percent_changed":-7.53},{"item":"Finance charges","amount":3611973.0,"comparison":"Original to adjusted budget","percent_changed":70.46},{"item":"Finance charges","amount":8525316.0,"comparison":"Original budget to audited outcome","percent_changed":166.3},{"item":"Other","amount":-21896372.0,"comparison":"Original to adjusted budget","percent_changed":-6.17},{"item":"Other","amount":187387797.0,"comparison":"Original budget to audited outcome","percent_changed":52.77},{"item":"Remuneration of councillors","amount":651804.0,"comparison":"Original to adjusted budget","percent_changed":6.66},{"item":"Remuneration of councillors","amount":-959094.0,"comparison":"Original budget to audited outcome","percent_changed":-9.8}]},"spending_time_series":[{"amount":491932673.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":613005354.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":543162157.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":569636599.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":583753681.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":651405170.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":833035208.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":797984663.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":804417495.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":696036115.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":720208816.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":168088605.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":586472406.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":510306330.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":585450729.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":670618556.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":-102.18,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"ave","result":-7.4,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"bad","result":-74.55,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"bad","result":-41.33,"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":66399238.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":172223602.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":2235356.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":162043213.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":913510.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":2658915.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":28553975.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":14.31},{"date":2023,"rating":"","result":12.03},{"date":2022,"rating":"","result":14.0},{"date":2021,"rating":"","result":14.9}],"formula":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp","item_codes":["3000","3100"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp_v2","item_codes":["3100"],"amount_type":"AUDA"}]},"result_type":"%"},"operating_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2024,"rating":"bad","result":40.1,"overunder":"over","cube_version":"v2"},{"date":2023,"rating":"bad","result":53.4,"overunder":"over","cube_version":"v2"},{"date":2022,"rating":"ave","result":6.3,"overunder":"over","cube_version":"v2"},{"date":2021,"rating":"bad","result":18.7,"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":2.5,"cube_version":"v2"},{"date":2023,"rating":"bad","result":1.28,"cube_version":"v2"},{"date":2022,"rating":"bad","result":0.79,"cube_version":"v2"},{"date":2021,"rating":"bad","result":6.14,"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":5.36},{"date":2023,"rating":"","result":5.17},{"date":2022,"rating":"","result":5.04},{"date":2021,"rating":"","result":17.91}],"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":23.77,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"bad","result":17.87,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"good","result":304.95,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"bad","result":4.8,"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":1480876.0},{"year":2022,"value":1633281.0},{"year":2023,"value":5749181.0},{"year":2024,"value":9152725.0},{"year":2025,"value":10796736.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":76266823.0},{"year":2022,"value":91835399.0},{"year":2023,"value":81764225.0},{"year":2024,"value":92438325.0},{"year":2025,"value":111084669.0}],"category":"Electricity "},{"values":[{"year":2021,"value":382208859.0},{"year":2022,"value":447760900.0},{"year":2023,"value":603362196.0},{"year":2024,"value":516494035.0},{"year":2025,"value":265560684.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":168665.0},{"year":2022,"value":178755.0},{"year":2023,"value":183269.0},{"year":2024,"value":193158.0},{"year":2025,"value":204787.0}],"category":"Health"},{"values":[{"year":2021,"value":3054326.0},{"year":2022,"value":2914226.0},{"year":2023,"value":3179896.0},{"year":2024,"value":2611505.0},{"year":2025,"value":2795926.0}],"category":"Housing"},{"values":[{"year":2021,"value":14011634.0},{"year":2022,"value":20181468.0},{"year":2023,"value":23076295.0},{"year":2024,"value":54821238.0},{"year":2025,"value":25069594.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":1702921.0},{"year":2022,"value":1651586.0},{"year":2023,"value":1899975.0},{"year":2024,"value":2406775.0},{"year":2025,"value":2191241.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":7653672.0},{"year":2022,"value":7931704.0},{"year":2023,"value":10063848.0},{"year":2024,"value":9680613.0},{"year":2025,"value":45635170.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":32367193.0},{"year":2022,"value":14287848.0},{"year":2023,"value":16886205.0},{"year":2024,"value":18675501.0},{"year":2025,"value":77293550.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":64838712.0},{"year":2022,"value":63030003.0},{"year":2023,"value":86870118.0},{"year":2024,"value":91510788.0},{"year":2025,"value":263785138.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":"NW404"},"muni_contact":{"url":"http://www.maquassihills.co.za","phone_number":"018 596 3025","street_address_1":"Municipal Offices","street_address_2":"19 Kruger Street","street_address_3":"Wolmaransstad","street_address_4":"2630"},"mayoral_staff":{"officials":[{"name":"Mzwandile Feliti","role":"Mayor/Executive Mayor","email":"felitim74@gmail.com","title":"Cllr","secretary":{"name":"Sibongile Mkhwane","role":"Secretary of Mayor/Executive Mayor","email":"sibongilem@maquassihills.org","title":"Ms","fax_number":"018 596 1555","office_phone":"018 596 1074"},"fax_number":"018 596 1555","office_phone":"018 596 1074"},{"name":"Nokuthula Mbonani","role":"Municipal Manager","email":"mbonanin@maquassihills.org","title":"Mrs","secretary":{"name":"Sibongile Mkhwane","role":"Secretary of Municipal Manager","email":"sibongilem@maquassihills.org","title":"Ms","fax_number":"018 596 1555","office_phone":"018 596 1074"},"fax_number":"018 596 1555","office_phone":"018 596 1074"},{"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":"Ariel Madisha","role":"Chief Financial Officer","email":"arielm@maquassihills.org","title":"Mr","secretary":{"name":"","role":"Secretary of Financial Manager","email":"","title":"","fax_number":"","office_phone":""},"fax_number":"018 596 1555","office_phone":"018 596 3025"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"adverse","result":"Adverse opinion","report_url":"https://lg.treasury.gov.za/supportingdocs/NW404/NW404_Audit%20Report_2024_Y_20241211T123736Z_moketemoswang.pdf"},{"date":2023,"rating":"disclaimer","result":"Disclaimer of opinion","report_url":"https://lg.treasury.gov.za/supportingdocs/NW404/NW404_Audit%20Report_2023_Y_20240208T104600Z_moketemoswang.pdf"},{"date":2022,"rating":"disclaimer","result":"Disclaimer of opinion","report_url":""},{"date":2021,"rating":"disclaimer","result":"Disclaimer of opinion","report_url":""}]}}