{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":32707187.0,"national_conditional_grants":7091965.0},"ORGB":{"equitable_share":133828000.0,"national_conditional_grants":33809000.0},"SCHD":{"national_conditional_grants":33509000.0},"TRFR":{"national_conditional_grants":2623000.0}},"2022":{"ACT":{"national_conditional_grants":11622958.0},"ORGB":{"equitable_share":138974000.0,"national_conditional_grants":44785000.0},"SCHD":{"national_conditional_grants":39085000.0},"TRFR":{"national_conditional_grants":28571000.0}},"2023":{"ACT":{"national_conditional_grants":6679705.0},"ORGB":{"equitable_share":150626000.0,"provincial_transfers":26668000.0,"national_conditional_grants":41494000.0},"SCHD":{"national_conditional_grants":32232000.0},"TRFR":{"national_conditional_grants":27014000.0}},"2024":{"ACT":{"national_conditional_grants":6074812.0},"ORGB":{"equitable_share":160330000.0,"national_conditional_grants":53252000.0},"SCHD":{"national_conditional_grants":53407000.0},"TRFR":{"national_conditional_grants":35317000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":32707187.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":133828000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":138974000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":150626000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":160330000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":25055000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":1613000.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":268000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":268000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":1500899.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1900000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1900000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":5591066.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":29224000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":300000.0,"grant.code":"MSIG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1817000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":455000.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":1535153.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":1850000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1850000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":10514000.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":9448905.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":25197000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":25197000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":638900.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":1524000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1524000.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":390841.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1890000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1890000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":5218000.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":5343042.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":23893000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":23893000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":945822.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1231000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1231000.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":1466809.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1890000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1890000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":18090000.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":3848255.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":32193000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":32193000.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":759748.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1234000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1234000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","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":28899898.0,"cube_version":"v2"},{"date":2023,"rating":"bad","result":null,"cube_version":null},{"date":2022,"rating":"good","result":365008541.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":365008541.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":17.8,"cube_version":"v2"},{"date":2023,"rating":null,"result":null,"cube_version":null},{"date":2022,"rating":"good","result":29.2,"cube_version":"v2"},{"date":2021,"rating":"good","result":29.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":-27529491.0,"rating":"good","result":15.84,"amount_type":"AUDA","liabilities":-1737690.0,"cube_version":"v2"},{"date":2023,"year":2023,"rating":"bad","result":null,"cube_version":null},{"date":2022,"year":2022,"assets":38709941.0,"rating":"good","result":29.48,"amount_type":"AUDA","liabilities":1312940.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":38709941.0,"rating":"good","result":29.48,"amount_type":"AUDA","liabilities":1312940.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":-27882712.0,"date":"2024","year":2024,"rating":"good","result":16.05,"amount_type":"ACT","liabilities":-1737690.0,"cube_version":"v2","call_investment_deposits":0},{"date":"2023","year":2023,"rating":"bad","result":null,"cube_version":null},{"cash":8894920.0,"date":"2022","year":2022,"rating":"good","result":6.77,"amount_type":"ACT","liabilities":1312940.0,"cube_version":"v2","call_investment_deposits":0},{"cash":8894920.0,"date":"2021","year":2021,"rating":"good","result":6.77,"amount_type":"ACT","liabilities":1312940.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":790088.0,"percent":99.56},"total":793551.0,"rating":"good","formula":{"text":"= Total revenue","actual":["=",{"cube":"incexp","item_codes":["0200","0300","0400","0700","0800","1000","1100","1300","1400","1500","1700","1800","1600","1610"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Total revenue","actual":["=",{"cube":"incexp_v2","item_codes":["0200","0300","0400","0500","0600","0700","0800","0900","1000","1100","1200","1300","1400","1500","1550","1570","1590","1600","1700","1800","1900","2000","2100","2300","2400","2500","2600","2700","2800","2200"],"amount_type":"AUDA"}]},"government":{"amount":3463.0,"percent":0.44}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":85.04,"cube_version":"v2"},{"date":2023,"rating":null,"result":null,"cube_version":null},{"date":2022,"rating":"bad","result":22.09,"cube_version":"v2"},{"date":2021,"rating":"bad","result":61.95,"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":-615879.0,"comparison":"Original budget to audited outcome","percent_changed":-87.16},{"item":"Government Transfers","amount":48746804.0,"comparison":"Original to adjusted budget","percent_changed":42.12},{"item":"Government Transfers","amount":31341435.0,"comparison":"Original budget to audited outcome","percent_changed":27.08},{"item":"Interest and investments","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Interest and investments","amount":424795.0,"comparison":"Original budget to audited outcome","percent_changed":25.98},{"item":"Other","amount":9501.0,"comparison":"Original to adjusted budget","percent_changed":6.34},{"item":"Other","amount":816634.0,"comparison":"Original budget to audited outcome","percent_changed":544.97},{"item":"Property rates","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-18898815.0,"comparison":"Original budget to audited outcome","percent_changed":-77.2},{"item":"Rental income","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Rental income","amount":-869581.0,"comparison":"Original budget to audited outcome","percent_changed":-43.13},{"item":"Service Charges","amount":null,"comparison":"Original to adjusted budget","percent_changed":null},{"item":"Service Charges","amount":252118.0,"comparison":"Original budget to audited outcome","percent_changed":0}],"2022":[{"item":"Fines","amount":148000.0,"comparison":"Original to adjusted budget","percent_changed":284.62},{"item":"Fines","amount":38700.0,"comparison":"Original budget to audited outcome","percent_changed":74.42},{"item":"Government Transfers","amount":9634723.0,"comparison":"Original to adjusted budget","percent_changed":6.64},{"item":"Government Transfers","amount":2000092.0,"comparison":"Original budget to audited outcome","percent_changed":1.38},{"item":"Interest and investments","amount":773868.0,"comparison":"Original to adjusted budget","percent_changed":38.98},{"item":"Interest and investments","amount":74523.0,"comparison":"Original budget to audited outcome","percent_changed":3.75},{"item":"Other","amount":-4000.0,"comparison":"Original to adjusted budget","percent_changed":-0.35},{"item":"Other","amount":-164522.0,"comparison":"Original budget to audited outcome","percent_changed":-14.55},{"item":"Property rates","amount":-1884992.0,"comparison":"Original to adjusted budget","percent_changed":-21.66},{"item":"Property rates","amount":-3121339.0,"comparison":"Original budget to audited outcome","percent_changed":-35.87},{"item":"Rental income","amount":137000.0,"comparison":"Original to adjusted budget","percent_changed":9.79},{"item":"Rental income","amount":-253581.0,"comparison":"Original budget to audited outcome","percent_changed":-18.11},{"item":"Service Charges","amount":326000.0,"comparison":"Original to adjusted budget","percent_changed":189.53},{"item":"Service Charges","amount":80118.0,"comparison":"Original budget to audited outcome","percent_changed":46.58}],"2023":[{"item":"Fines","amount":-107839.0,"comparison":"Original to adjusted budget","percent_changed":-40.56},{"item":"Fines","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Government Transfers","amount":-1209000.0,"comparison":"Original to adjusted budget","percent_changed":-0.77},{"item":"Government Transfers","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Interest and investments","amount":1799514.0,"comparison":"Original to adjusted budget","percent_changed":66.24},{"item":"Interest and investments","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Other","amount":200431.0,"comparison":"Original to adjusted budget","percent_changed":15.49},{"item":"Other","amount":null,"comparison":"Original budget to audited outcome","percent_changed":null},{"item":"Property rates","amount":602298.0,"comparison":"Original to adjusted budget","percent_changed":2.31},{"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":193487358.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":167658368.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":190647196.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":195993876.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":157181760.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":157181760.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":793551.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":226848854.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":227225233.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":223965997.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":144731053.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":158527769.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":189361792.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":186275064.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":226243140.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Contracted services","amount":1039000.0,"comparison":"Original to adjusted budget","percent_changed":5.15},{"item":"Contracted services","amount":-1873076.0,"comparison":"Original budget to audited outcome","percent_changed":-9.28},{"item":"Employee related costs","amount":1000394.0,"comparison":"Original to adjusted budget","percent_changed":1.11},{"item":"Employee related costs","amount":-6166254.0,"comparison":"Original budget to audited outcome","percent_changed":-6.82},{"item":"Finance charges","amount":100000.0,"comparison":"Original to adjusted budget","percent_changed":166.67},{"item":"Finance charges","amount":-23402.0,"comparison":"Original budget to audited outcome","percent_changed":-39.0},{"item":"Other","amount":1459107.0,"comparison":"Original to adjusted budget","percent_changed":2.89},{"item":"Other","amount":-15382733.0,"comparison":"Original budget to audited outcome","percent_changed":-30.49},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-1012109.0,"comparison":"Original budget to audited outcome","percent_changed":-8.59},{"item":"Transfers and subsidies","amount":-400000.0,"comparison":"Original to adjusted budget","percent_changed":-14.2},{"item":"Transfers and subsidies","amount":-1358703.0,"comparison":"Original budget to audited outcome","percent_changed":-48.23}]},"spending_time_series":[{"amount":178968354.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":215010931.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":177092152.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":220519212.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":149953576.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":149953577.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":19463264.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":268456573.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":260742695.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":265561211.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":175769853.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":195668117.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":189803424.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":234283992.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":257525484.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":-87.21,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":null,"result":null,"overunder":null,"cube_version":null},{"date":2022,"rating":"bad","result":-41.87,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"bad","result":-54.81,"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":"Service Charges","amount":67917.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":162233.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":427417.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":14100.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":45987.0,"amount_type":"AUDA"},{"date":"2024","item":"Agency services","amount":46264.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":26170.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":36.88},{"date":2023,"rating":"","result":null},{"date":2022,"rating":"","result":56.22},{"date":2021,"rating":"","result":56.22}],"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":-91.2,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":null,"result":null,"overunder":null,"cube_version":null},{"date":2022,"rating":"bad","result":-30.3,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"bad","result":-16.2,"overunder":"under","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":null,"result":null,"cube_version":null},{"date":2023,"rating":null,"result":null,"cube_version":null},{"date":2022,"rating":null,"result":null,"cube_version":null},{"date":2021,"rating":null,"result":null,"cube_version":null}],"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":26.18},{"date":2023,"rating":"","result":null},{"date":2022,"rating":"","result":12.21},{"date":2021,"rating":"","result":12.21}],"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":null,"billing":null,"receipts":null,"cube_version":null},{"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":25628755.0},{"year":2022,"value":25628755.0},{"year":2024,"value":1912229.0},{"year":2025,"value":30388019.0}],"category":"Community & Social Services"},{"values":[{"year":2024,"value":738.0},{"year":2025,"value":8398739.0}],"category":"Electricity "},{"values":[{"year":2021,"value":124324821.0},{"year":2022,"value":124324822.0},{"year":2024,"value":17550297.0},{"year":2025,"value":229669815.0}],"category":"Governance, Administration, Planning and Development"}],"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":"NW381"},"muni_contact":{"url":"http://ratlou.gov.za","phone_number":"018 330 7000","street_address_1":"Ratlou Local Municipality","street_address_2":"Delareyville Road","street_address_3":"Setlagole Village","street_address_4":"2772"},"mayoral_staff":{"officials":[{"name":"Matlhomola Ronald Jafta","role":"Mayor/Executive Mayor","email":"mjafta3@gmail.com","title":"Mr","secretary":{"name":"Tokelo Mogorosi","role":"Secretary of Mayor/Executive Mayor","email":"mogorositokelo215@gmail.com","title":"Mr","fax_number":"018 330 7047","office_phone":"018 330 7000"},"fax_number":"018 330 7047","office_phone":"018 330 7006"},{"name":"Lloyd Leoko","role":"Municipal Manager","email":"Lloyd@ratlou.gov.za","title":"Mr","secretary":{"name":"Riah Twala","role":"Secretary of Municipal Manager","email":"riaht@ratlou.gov.za","title":"Ms","fax_number":"018 330 7047","office_phone":"018 330 7012"},"fax_number":"018 330 7047","office_phone":"018 330 7000"},{"name":"Mr","role":"Deputy Mayor/Executive Mayor","email":"mummym@webmail.co.za","title":" ","secretary":{"name":"","role":"Secretary of Deputy Mayor/Executive Mayor","email":"","title":"","fax_number":"","office_phone":""},"fax_number":"082 451 0339","office_phone":"018 330 7028"},{"name":"Collen Tjale (Acting)","role":"Chief Financial Officer","email":"collen@ratlou.gov.za","title":"Mr","secretary":{"name":"Kgomotso Segokgo","role":"Secretary of Financial Manager","email":"kgomotso@ratlou.gov.za","title":"Ms","fax_number":"018 330 7047","office_phone":"018 330 7036"},"fax_number":"018 330 7047","office_phone":"018 330 7000"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"disclaimer","result":"Disclaimer of opinion","report_url":"https://lg.treasury.gov.za/supportingdocs/NW381/NW381_Audit%20Report_2024_Y_20250114T140455Z_pagel.pdf"},{"date":2023,"rating":"disclaimer","result":"Disclaimer of opinion","report_url":""},{"date":2022,"rating":"disclaimer","result":"Disclaimer of opinion","report_url":""},{"date":2021,"rating":"disclaimer","result":"Disclaimer of opinion","report_url":""}]}}