{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":43611558.0,"national_conditional_grants":9124469.0},"ORGB":{"equitable_share":137063000.0,"national_conditional_grants":55083000.0},"SCHD":{"national_conditional_grants":53583000.0},"TRFR":{"national_conditional_grants":17396000.0}},"2022":{"ORGB":{"equitable_share":143161000.0,"national_conditional_grants":54108000.0},"SCHD":{"national_conditional_grants":54108000.0},"TRFR":{"national_conditional_grants":43085000.0}},"2023":{"ORGB":{"equitable_share":159232000.0,"provincial_transfers":8934000.0,"national_conditional_grants":51706000.0},"SCHD":{"national_conditional_grants":42986000.0},"TRFR":{"national_conditional_grants":36856000.0}},"2024":{"ORGB":{"equitable_share":174108000.0,"national_conditional_grants":61797000.0},"SCHD":{"national_conditional_grants":54323000.0},"TRFR":{"national_conditional_grants":34095000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":43611558.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":137063000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":143161000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":159232000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":174108000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":7880000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":1054000.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":1102909.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":7876735.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":46612000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":13509000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1500000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":144825.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":2113000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":529000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","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":11023000.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":38475000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":38475000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":1510000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1510000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","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":6130000.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":32675000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":32675000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1081000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1081000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","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":20228000.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":30995000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":30995000.0,"grant.code":"MIG","grant.label":"Municipal 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":3098709776.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":2066981799.0,"cube_version":"v2"},{"date":2022,"rating":"bad","result":null,"cube_version":null},{"date":2021,"rating":"good","result":1123203253.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":59.6,"cube_version":"v2"},{"date":2023,"rating":"good","result":45.4,"cube_version":"v2"},{"date":2022,"rating":null,"result":null,"cube_version":null},{"date":2021,"rating":"good","result":22.2,"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":1241887789.0,"rating":"bad","result":0.46,"amount_type":"AUDA","liabilities":2722382270.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":1118201015.0,"rating":"bad","result":0.48,"amount_type":"AUDA","liabilities":2351192068.0,"cube_version":"v2"},{"date":2022,"year":2022,"rating":"bad","result":null,"cube_version":null},{"date":2021,"year":2021,"assets":566165873.0,"rating":"bad","result":0.48,"amount_type":"AUDA","liabilities":1185554710.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":-215864048.0,"date":"2024","year":2024,"rating":"bad","result":-0.08,"amount_type":"ACT","liabilities":2722382270.0,"cube_version":"v2","call_investment_deposits":0},{"cash":-230023410.0,"date":"2023","year":2023,"rating":"bad","result":-0.1,"amount_type":"ACT","liabilities":2351192068.0,"cube_version":"v2","call_investment_deposits":0},{"date":"2022","year":2022,"rating":"bad","result":null,"cube_version":null},{"cash":20217060.0,"date":"2021","year":2021,"rating":"bad","result":0.02,"amount_type":"ACT","liabilities":1185554710.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":162566432.0,"percent":47.38},"total":343103225.0,"rating":"bad","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":180536793.0,"percent":52.62}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":6.96,"cube_version":"v2"},{"date":2023,"rating":"bad","result":68.72,"cube_version":"v2"},{"date":2022,"rating":null,"result":null,"cube_version":null},{"date":2021,"rating":"bad","result":45.49,"cube_version":"v2"}],"formula":{"text":"= (Unauthorised, Irregular, Fruitless and Wasteful Expenditure / Actual Operating Expenditure) * 100","actual":["=","(",{"cube":"uifwexp","item_codes":["irregular","fruitless","unauthorised"]},"/",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= (Unauthorised, Irregular, Fruitless and Wasteful Expenditure / Actual Operating Expenditure) * 100","actual":["=","(",{"cube":"uifwexp","item_codes":["irregular","fruitless","unauthorised"]},"/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},")","*","100"]},"result_type":"%"},"income_adjustments":{"2021":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":1480992.0,"comparison":"Original budget to audited outcome","percent_changed":59.24},{"item":"Government Transfers","amount":36733350.0,"comparison":"Original to adjusted budget","percent_changed":25.37},{"item":"Government Transfers","amount":6279770.0,"comparison":"Original budget to audited outcome","percent_changed":4.34},{"item":"Interest and investments","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":-49761759.0,"comparison":"Original budget to audited outcome","percent_changed":-99.09},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-1518010.0,"comparison":"Original budget to audited outcome","percent_changed":-15.18},{"item":"Other","amount":-1126000.0,"comparison":"Original to adjusted budget","percent_changed":-4.38},{"item":"Other","amount":-22492442.0,"comparison":"Original budget to audited outcome","percent_changed":-87.48},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":5677554.0,"comparison":"Original budget to audited outcome","percent_changed":9.05},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Service Charges","amount":-414194.0,"comparison":"Original to adjusted budget","percent_changed":-0.18},{"item":"Service Charges","amount":135276842.0,"comparison":"Original budget to audited outcome","percent_changed":57.64}],"2022":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Government Transfers","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Government Transfers","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Interest and investments","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Other","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Other","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Service Charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Service Charges","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null}]},"income_time_series":[{"amount":566996661.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":629211926.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":605620766.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":264653100.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":343103225.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":452103573.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":541609793.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":559540111.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":531803505.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":629211926.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":584887560.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":646138000.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":501148034.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":-31000000.0,"comparison":"Original to adjusted budget","percent_changed":-17.13},{"item":"Bulk purchases","amount":-34326514.0,"comparison":"Original budget to audited outcome","percent_changed":-18.96},{"item":"Contracted services","amount":3947000.0,"comparison":"Original to adjusted budget","percent_changed":14.02},{"item":"Contracted services","amount":25830084.0,"comparison":"Original budget to audited outcome","percent_changed":91.74},{"item":"Employee related costs","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Employee related costs","amount":16689451.0,"comparison":"Original budget to audited outcome","percent_changed":9.33},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":18736508.0,"comparison":"Original budget to audited outcome","percent_changed":4547.7},{"item":"Other","amount":-134279.0,"comparison":"Original to adjusted budget","percent_changed":-0.07},{"item":"Other","amount":-25647950.0,"comparison":"Original budget to audited outcome","percent_changed":-12.75},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-603259.0,"comparison":"Original budget to audited outcome","percent_changed":-3.4}],"2022":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Contracted services","amount":1081575.0,"comparison":"Original to adjusted budget","percent_changed":3.13},{"item":"Contracted services","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Employee related costs","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Employee related costs","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Finance charges","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Finance charges","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Other","amount":-1801987.0,"comparison":"Original to adjusted budget","percent_changed":-0.84},{"item":"Other","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null}],"2023":[{"item":"Bulk purchases","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Bulk purchases","amount":6866826.0,"comparison":"Original budget to audited outcome","percent_changed":4.58},{"item":"Contracted services","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Contracted services","amount":-15720199.0,"comparison":"Original budget to audited outcome","percent_changed":-44.16},{"item":"Employee related costs","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Employee related costs","amount":79292336.0,"comparison":"Original budget to audited outcome","percent_changed":38.53},{"item":"Finance charges","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Finance charges","amount":52986815.0,"comparison":"Original budget to audited outcome","percent_changed":481.7},{"item":"Other","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Other","amount":-190168389.0,"comparison":"Original budget to audited outcome","percent_changed":-96.91},{"item":"Remuneration of councillors","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Remuneration of councillors","amount":-3343122.0,"comparison":"Original budget to audited outcome","percent_changed":-18.57}]},"spending_time_series":[{"amount":580143366.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":611879989.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":608008965.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":546532176.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":623486412.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":656449838.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":715098658.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":758128843.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":607330645.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":612600401.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":616617909.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":505170419.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":715487587.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":null,"result":null,"overunder":null,"cube_version":null},{"date":2023,"rating":null,"result":null,"overunder":null,"cube_version":null},{"date":2022,"rating":null,"result":null,"overunder":null,"cube_version":null},{"date":2021,"rating":"bad","result":-36.3,"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":83202479.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":86138936.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":421662.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":-9581035.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":2077545.0,"amount_type":"AUDA"},{"date":"2024","item":"Agency services","amount":7852.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":298993.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":46.96},{"date":2023,"rating":"","result":52.16},{"date":2022,"rating":"","result":null},{"date":2021,"rating":"","result":32.17}],"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":null,"result":null,"overunder":null,"cube_version":null},{"date":2023,"rating":null,"result":null,"overunder":null,"cube_version":null},{"date":2022,"rating":null,"result":null,"overunder":null,"cube_version":null},{"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.39,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0.06,"cube_version":"v2"},{"date":2022,"rating":null,"result":null,"cube_version":null},{"date":2021,"rating":"bad","result":0.45,"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":10.75},{"date":2023,"rating":"","result":3.64},{"date":2022,"rating":"","result":null},{"date":2021,"rating":"","result":8.88}],"formula":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp","item_codes":["4200"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp_v2","item_codes":["3800"],"amount_type":"AUDA"}]},"result_type":"%"},"current_debtors_collection_rate":{"ref":{"url":"http://mfma.treasury.gov.za/RegulationsandGazettes/Municipal%20Budget%20and%20Reporting%20Regulations/Pages/default.aspx","title":"Municipal Budget and Reporting Regulations"},"values":[{"date":"2024","year":2024,"rating":"bad","result":null,"billing":null,"receipts":null,"cube_version":null},{"date":"2023","year":2023,"rating":"bad","result":-5.48,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"bad","result":null,"billing":null,"receipts":null,"cube_version":null},{"date":"2021","year":2021,"rating":"bad","result":null,"billing":null,"receipts":null,"cube_version":null}],"formula":{"text":"= (Collected Revenue / Billed Revenue) * 100","actual":["=","(",{"cube":"cflow","item_codes":["3010","3030","3040","3050","3060","3070","3100"],"amount_type":"AUDA"},"/",{"cube":"incexp","item_codes":["0200","0400","1000","less item code","2000"],"amount_type":"AUDA"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= (Collected Revenue / Billed Revenue) * 100","actual":["=","(",{"cube":"cflow_v2","item_codes":["0120","0130","0280"],"amount_type":"AUDA"},"/",{"cube":"incexp_v2","item_codes":["1800","0300","0400","0500","0600","1400","1100","1000"],"amount_type":"AUDA"},")","*","100"]},"result_type":"%"},"expenditure_functional_breakdown":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"values":[{"year":2021,"value":708707.0},{"year":2023,"value":-69703.0},{"year":2024,"value":47791.0},{"year":2025,"value":-22248669.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":174956353.0},{"year":2023,"value":220912548.0},{"year":2024,"value":187456057.0},{"year":2025,"value":219896409.0}],"category":"Electricity "},{"values":[{"year":2021,"value":2024796.0},{"year":2023,"value":20750.0},{"year":2025,"value":4241502.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":359487953.0},{"year":2023,"value":230587965.0},{"year":2024,"value":338369195.0},{"year":2025,"value":420618448.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":1815534.0},{"year":2023,"value":1326242.0},{"year":2024,"value":393209.0},{"year":2025,"value":21784.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":387733.0},{"year":2023,"value":-10315.0},{"year":2025,"value":84637.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":594574.0},{"year":2025,"value":10728.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":189714.0},{"year":2024,"value":617230.0},{"year":2025,"value":67396.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":67843601.0},{"year":2023,"value":93764689.0},{"year":2024,"value":96602930.0},{"year":2025,"value":33757603.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":"NW384"},"muni_contact":{"url":"http://www.ditsobotla.co.za","phone_number":"018 633 3800","street_address_1":"Civic Centre","street_address_2":"Cnr Nelson Mandela Drive & Transvaal","street_address_3":"Lichtenburg","street_address_4":"2740"},"mayoral_staff":{"officials":[{"name":"cllr thabo Nkashe","role":"Mayor/Executive Mayor","email":"thabonkashe3@gmail.com","title":"Cllr","secretary":{"name":"Tsholofelo D Dintoe","role":"Secretary of Mayor/Executive Mayor","email":"tsholofelodinaane99@yahoo.com","title":"Ms","fax_number":"018 632 5247","office_phone":"018 633 3889"},"fax_number":"018 632 5247","office_phone":"018 633 3876"},{"name":"O.T. Bojosinyane","role":"Municipal Manager","email":"olaotsetheo@gmail.com","title":"Mr","secretary":{"name":"Gorataone Moiloa","role":"Secretary of Municipal Manager","email":"moiloag24@gmail.com","title":"Ms","fax_number":"018 632 5247","office_phone":"018 633 3800"},"fax_number":"018 632 5247","office_phone":"018 633 3800"},{"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":"Lacreevy Moagi","role":"Chief Financial Officer","email":"lacreevy@gmail.com","title":"Ms","secretary":{"name":"Refiloe Mosielele","role":"Secretary of Financial Manager","email":"rmosielele@gmail.com","title":"Ms","fax_number":"018 632 5247","office_phone":"018 633 3800"},"fax_number":"018 632 5247","office_phone":"018 633 3800"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"disclaimer","result":"Disclaimer of opinion","report_url":""},{"date":2023,"rating":"outstanding","result":"Outstanding","report_url":""},{"date":2022,"rating":"outstanding","result":"Outstanding","report_url":""},{"date":2021,"rating":"outstanding","result":"Outstanding","report_url":""}]}}