{"success":true,"code":200,"message":"OK","data":{"id":31,"auditee_id":884,"category":"MUN","created_at":"2023-05-11T17:19:43.000000Z","district_id":10,"exclude":null,"map_url":null,"name":"Cederberg","parent_id":null,"slug":"9-cederberg","status":"Normal","type":"LM","required_intervention":0,"unqualified_opinion_misstatements":"No","updated_at":"2023-05-11T17:19:43.000000Z","audit_opinions":[{"id":7223,"municipality_id":31,"period":"2024-25","engagement":"FA","opinion_evaluation":"Improved","audit_opinion":"Unqualified with no findings","information_reliable":"No","not_submitted_in_time":"Yes","information_useful":"No","performance_report":"Yes","planning_documents":"Yes","predetermined_objectives":"No","compliance_legislation":"No","quality_performance_report":"R","exclude":0,"created_at":"2026-04-10T08:50:51.000000Z","updated_at":"2026-04-10T08:50:51.000000Z"},{"id":6950,"municipality_id":31,"period":"2023-24","engagement":"FA","opinion_evaluation":"Unchanged","audit_opinion":"Unqualified with findings","information_reliable":"Yes","not_submitted_in_time":"Yes","information_useful":"No","performance_report":"Yes","planning_documents":"Yes","predetermined_objectives":"Yes","compliance_legislation":"Yes","quality_performance_report":"R","exclude":0,"created_at":"2025-03-07T10:04:07.000000Z","updated_at":"2025-03-07T10:04:07.000000Z"},{"id":6676,"municipality_id":31,"period":"2022-23","engagement":"FA","opinion_evaluation":"Unchanged","audit_opinion":"Unqualified with findings","information_reliable":"Yes","not_submitted_in_time":"Yes","information_useful":"No","performance_report":"Yes","planning_documents":"Yes","predetermined_objectives":"Yes","compliance_legislation":"Yes","quality_performance_report":"R","exclude":0,"created_at":"2024-05-16T11:04:28.000000Z","updated_at":"2024-05-16T11:04:28.000000Z"},{"id":6126,"municipality_id":31,"period":"2021-22","engagement":"FA","opinion_evaluation":"Regressed","audit_opinion":"Unqualified with findings","information_reliable":"No","not_submitted_in_time":"Yes","information_useful":"No","performance_report":"Yes","planning_documents":"Yes","predetermined_objectives":"No","compliance_legislation":"Yes","quality_performance_report":"R","exclude":0,"created_at":"2023-05-23T21:55:17.000000Z","updated_at":"2023-05-23T21:55:17.000000Z"},{"id":4202,"municipality_id":31,"period":"2020-21","engagement":"FA","opinion_evaluation":"Improved","audit_opinion":"Unqualified with no findings","information_reliable":"No","not_submitted_in_time":"Yes","information_useful":"No","performance_report":"Yes","planning_documents":"Yes","predetermined_objectives":"No","compliance_legislation":"No","quality_performance_report":"R","exclude":0,"created_at":"2023-05-19T12:54:15.000000Z","updated_at":"2023-05-19T12:54:15.000000Z"},{"id":3926,"municipality_id":31,"period":"2019-20","engagement":"FA","opinion_evaluation":"Regressed","audit_opinion":"Unqualified with findings","information_reliable":"No","not_submitted_in_time":"Yes","information_useful":"No","performance_report":"Yes","planning_documents":"Yes","predetermined_objectives":"No","compliance_legislation":"Yes","quality_performance_report":"R","exclude":0,"created_at":"2023-05-19T12:53:36.000000Z","updated_at":"2023-05-19T12:53:36.000000Z"},{"id":3650,"municipality_id":31,"period":"2018-19","engagement":"FA","opinion_evaluation":"Unchanged","audit_opinion":"Unqualified with no findings","information_reliable":"No","not_submitted_in_time":"Yes","information_useful":"No","performance_report":"Yes","planning_documents":"Yes","predetermined_objectives":"No","compliance_legislation":"No","quality_performance_report":"R","exclude":0,"created_at":"2023-05-19T12:53:00.000000Z","updated_at":"2023-05-19T12:53:00.000000Z"},{"id":6400,"municipality_id":31,"period":"2017-18","engagement":"FA","opinion_evaluation":"Unchanged","audit_opinion":"Unqualified with no findings","information_reliable":"No","not_submitted_in_time":"Yes","information_useful":"No","performance_report":"Yes","planning_documents":"Yes","predetermined_objectives":"No","compliance_legislation":"No","quality_performance_report":"N","exclude":0,"created_at":"2023-05-23T21:55:50.000000Z","updated_at":"2023-05-23T21:55:50.000000Z"}],"expenditures":[{"id":2757,"municipality_id":31,"period":"2024-25","irregular_expenditure":10294906,"irregular_expenditure_balance":10294906,"unauthorised_expenditure":1513447,"unauthorised_expenditure_balance":1513447,"wasteful_expenditure":115,"wasteful_expenditure_balance":115,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":null,"exclude":0,"created_at":"2026-04-10T09:59:33.000000Z","updated_at":"2026-04-10T09:59:33.000000Z"},{"id":2484,"municipality_id":31,"period":"2023-24","irregular_expenditure":16603924,"irregular_expenditure_balance":16603924,"unauthorised_expenditure":974750,"unauthorised_expenditure_balance":974750,"wasteful_expenditure":1164184,"wasteful_expenditure_balance":14583,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":null,"exclude":0,"created_at":"2025-03-07T10:07:08.000000Z","updated_at":"2025-03-07T10:07:08.000000Z"},{"id":2210,"municipality_id":31,"period":"2022-23","irregular_expenditure":36233137,"irregular_expenditure_balance":71436932,"unauthorised_expenditure":2369206,"unauthorised_expenditure_balance":2369206,"wasteful_expenditure":3911555,"wasteful_expenditure_balance":12110781,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":null,"exclude":0,"created_at":"2024-05-16T11:09:07.000000Z","updated_at":"2024-05-16T11:09:07.000000Z"},{"id":1917,"municipality_id":31,"period":"2021-22","irregular_expenditure":35203795,"irregular_expenditure_balance":35203795,"unauthorised_expenditure":0,"unauthorised_expenditure_balance":0,"wasteful_expenditure":3406368,"wasteful_expenditure_balance":8199226,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":null,"exclude":0,"created_at":"2023-05-23T23:07:06.000000Z","updated_at":"2023-05-23T23:07:06.000000Z"},{"id":1660,"municipality_id":31,"period":"2020-21","irregular_expenditure":12793616,"irregular_expenditure_balance":12793616,"unauthorised_expenditure":1749171,"unauthorised_expenditure_balance":1749171,"wasteful_expenditure":3511254,"wasteful_expenditure_balance":4792858,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":null,"exclude":0,"created_at":"2023-05-11T18:17:20.000000Z","updated_at":"2023-05-11T18:17:20.000000Z"},{"id":1212,"municipality_id":31,"period":"2019-20","irregular_expenditure":36225140,"irregular_expenditure_balance":107584888,"unauthorised_expenditure":6144939,"unauthorised_expenditure_balance":7606054,"wasteful_expenditure":1291601,"wasteful_expenditure_balance":1296371,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":null,"exclude":0,"created_at":"2023-05-11T17:20:21.000000Z","updated_at":"2023-05-11T17:20:21.000000Z"},{"id":1213,"municipality_id":31,"period":"2018-19","irregular_expenditure":71382151,"irregular_expenditure_balance":71359748,"unauthorised_expenditure":1461115,"unauthorised_expenditure_balance":1461115,"wasteful_expenditure":4770,"wasteful_expenditure_balance":4770,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":null,"exclude":0,"created_at":"2023-05-11T17:20:21.000000Z","updated_at":"2023-05-11T17:20:21.000000Z"},{"id":1214,"municipality_id":31,"period":"2017-18","irregular_expenditure":51176640,"irregular_expenditure_balance":51176640,"unauthorised_expenditure":637243,"unauthorised_expenditure_balance":637243,"wasteful_expenditure":122438,"wasteful_expenditure_balance":378847,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":null,"exclude":0,"created_at":"2023-05-11T17:20:21.000000Z","updated_at":"2023-05-11T17:20:21.000000Z"}],"entities":[],"grant_management":{"id":1776,"municipality_id":31,"period":"2024-25","percentage_underspending":35.2,"underspend_threshold":"Yes","maintenance_spend":1613341,"percentage_maintenance_spend":0.3,"internal_control_assessment":"Good","record_keeping":"Good","dm_controls":"Good","year_end_reporting":"Good","monitor_compliance":"Good","exclude":0,"created_at":"2026-04-10T08:52:31.000000Z","updated_at":"2026-04-10T08:52:31.000000Z"},"it_control":{"id":1654,"municipality_id":31,"period":"2024-25","overall_assessment":null,"it_governance":null,"it_security":null,"it_continuity":null,"unused_expenditure":null,"expenditure_amount":0,"exclude":0,"created_at":"2026-04-10T08:54:33.000000Z","updated_at":"2026-04-10T08:54:33.000000Z"},"financial_health":{"id":1578,"municipality_id":31,"period":"2024-25","material_findings":null,"creditor_payment_period":38,"debtor_collection_period":65,"eskom_arrears":0,"debt_irrecoverable":"77.00","deficit_realised":"No","deficit_realised_amount":0,"net_current_liability_realised":null,"bank_overdraft":null,"liabilities_next_budget":26,"expenditure_next_budget":"26","expenditure_next_half_budget":"26","water_arrears":0,"years_going_concern":"No","number_of_years_of_going_concern_uncertainty":0,"years_going_concern_qualification":0,"net_liability_realised":null,"solvency_ratio":3.7,"exclude":0,"created_at":"2026-04-10T10:01:53.000000Z","updated_at":"2026-06-03T08:31:54.000000Z"},"root_cause":{"id":2516,"municipality_id":31,"period":"2024-25","slow_response_management":null,"slow_response_political":null,"slow_response_oversight":null,"no_response_management":null,"no_response_political":null,"no_response_oversight":null,"instability":null,"officials_competencies":null,"inadequate_consequences":null,"exclude":0,"created_at":"2026-04-10T10:00:50.000000Z","updated_at":"2026-04-10T10:00:50.000000Z"},"stats":{"id":494,"municipality_id":31,"households":16869,"population":55108,"unemployment_rate":10.5,"youth_unemployment_rate":13.8,"water_access":89.8,"electricity_access":87.3,"refuse_removal":75.4,"flush_toilet":88.3,"exclude":0,"created_at":"2023-05-15T14:54:04.000000Z","updated_at":"2026-06-04T07:15:46.000000Z"},"supply_chain":{"id":1980,"municipality_id":31,"period":"2024-25","unfair_procurement":"Yes","awarded_family":null,"scope_limitations":null,"awarded_employees":null,"awarded_officials":null,"scm_received":0,"irregular_expenditure":null,"inadequate_contract":null,"exclude":0,"created_at":"2026-04-10T08:53:21.000000Z","updated_at":"2026-04-10T08:53:21.000000Z"},"district":{"id":10,"province_id":9,"name":"West Coast","slug":"9-west-coast","map_url":null,"created_at":"2023-05-11T17:19:43.000000Z","updated_at":"2023-05-11T17:19:43.000000Z","province":{"id":9,"name":"Western Cape","iso":"WC","slug":"western-cape","map_url":null}},"financials":{"id":1468,"municipality_id":31,"period":"2024-25","equitable_share":71544997,"grants":51543638,"property_rates":74996749,"services_electricity":152838247,"services_water":32696026,"other_revenue":127408068,"own_revenue":418366815,"total_revenue":541455450,"repairs_and_maintenance_as_of_ppe_at_carrying_value":2,"total_infrastructure_grants":37399238,"total_property_plant_and_equipment_at_carrying_amount":629106780,"repairs_and_maintenance_total":12874780,"investment_property_carrying_amount":73790079,"infrastructure_assets_at_carrying_amount":482159320,"repairs_and_maintenance_as_of_ppe_with_investment_property":1.8,"exclude":0,"created_at":"2026-04-10T10:04:29.000000Z","updated_at":"2026-06-02T09:33:59.000000Z","total_grants":123088635},"assurance":{"id":1281,"municipality_id":31,"period":"2024-25","mc_established":"Yes","mc_instability":"No","mc_assurance_level":"Provides assurance","cfo_appointed":"Yes","cfo_total_months":9,"cfo_months_vacant":0,"finance_vacancy_rate":11,"mm_total_months":27,"mm_vacancy":"Yes","finance_resourcing":"Good","finance_resourcing_concerning":null,"sm_vacancy_rate":35,"overall_vacancy_rate":22,"mm_months_vacant":0,"mpac_established":"Yes","ia_established":"Yes","ac_established":"Yes","exclude":0,"created_at":"2026-04-10T09:59:04.000000Z","updated_at":"2026-04-10T09:59:04.000000Z"},"audit_outcome":{"id":6119,"municipality_id":31,"period":"2024-25","engagement":"FA","afs_received_date":"2025-08-29","material_misstatement":"No","irregular_expenditure":"No","afs_and_ar":"No","asset_management":"No","liability_management":null,"budgets":null,"expenditure_management":"No","consequence_management":"No","audit_committees":null,"internal_audit":null,"revenue_management":"No","performance_management":"No","grants":null,"procurement_management":"No","hr_management":"No","other":null,"afs_submitted_in_time":"Yes","afs_good_quality":null,"findings_consequence_management":null,"environmental_management":null,"fwe_not_prevented":null,"ie_not_prevented":null,"ue_not_prevented":null,"exclude":0,"created_at":"2026-04-10T08:51:09.000000Z","updated_at":"2026-04-10T08:51:09.000000Z"},"financial_qualification":{"id":1308,"municipality_id":31,"period":"2024-25","property_infrastructure":null,"investment_property":null,"non_current_intangible_assets":null,"non_current_financial_assest":null,"non_current_biological_assets":null,"other_non_current_assets":null,"heritage_assets":null,"cash_and_cash_equivalents":null,"receivables":null,"inventory":null,"other_current_assest":null,"other_current_financial_instruments":null,"payables_and_borrowings":null,"provisions_and_guarantees":null,"taxes_and_vat":null,"other_liabilities":null,"other_financial_liabilities":null,"capital_and_reserves":null,"joint_ventures":null,"leases":null,"financial_instruments":null,"cash_flow_statement":null,"related_parties":null,"events_after_reporting":null,"accounting_policies":null,"contingent_liabilities":null,"other_disclosures":null,"going_concern":null,"criminal_conduct":null,"statement_comparison":null,"revenue_exchange_transactions":null,"revenue_non_exchange_transactions":null,"expenditure":null,"employee_cost":null,"unauthorised_expenditure":null,"irregular_expenditure":null,"fruitless_wasteful_xpenditure":null,"aggregate_misstatements":null,"cash_flow_from_operating_activities":null,"cash_flow_from_investing_activities":null,"cash_flow_from_financing_activities":null,"odi_electricity_losses":null,"odi_water_losses":null,"odi_written_representations":null,"exclude":0,"created_at":"2026-04-10T10:02:21.000000Z","updated_at":"2026-04-10T10:02:21.000000Z"},"waterboard":{"id":1344,"municipality_id":31,"period":"2024-25","0_to_30days":0,"31_to_90days":0,"over_90days":0,"total_arrears":0,"total_owed":0,"interest_owed":0,"payment_arrangement":null,"bulk_purchases":857304,"water_losses_disclosed":"Yes","essential_service_provider_of_water_yn":"Yes","percentage_water_losses":39.2,"amount_losses":0,"non_disclosure_comments":null,"incomplete_reason":null,"comments":null,"water_arrears":0,"exclude":0,"created_at":"2026-04-10T10:03:53.000000Z","updated_at":"2026-04-10T10:03:53.000000Z"},"eskom":{"id":1373,"municipality_id":31,"period":"2024-25","0_to_30days":970838,"31_to_90days":0,"over_90days":0,"total_arrears":0,"total_owed":970838,"interest_owed":0,"payment_arrangement":null,"bulk_purchases":124217401,"eskom_arrears":0,"electricity_losses_amount":0,"electricity_losses_percentage":5.8,"electricity_losses_disclosed":"Yes","essential_service_provider_of_electricity_yn":"Yes","exclude":0,"created_at":"2026-04-10T10:04:12.000000Z","updated_at":"2026-04-10T10:04:12.000000Z"},"consultant":{"id":2309,"municipality_id":31,"period":"2024-25","consultant_appointed":"Yes","consultant_cost":1428470.64,"consultant_reason":"Lack of skills","consultant_reason_other_institutions":null,"consultants_ineffective":"No","ineffective_reason":null,"ineffective_reason_other_institutions":null,"financial_statements":"1428470.64","asset_management":"0","accounting_service":"0","tax_services":"0","other_services":"0","consultant_financial_reporting":"16205370.94","exclude":0,"created_at":"2026-04-10T10:00:14.000000Z","updated_at":"2026-04-10T10:00:14.000000Z"},"material_irregularities":{"status_of_ab":0,"total_notifications":0,"recently_notified_awaiting_response":0,"follow_up_or_assessment_in_process":0,"appropriate_actions_in_process":0,"resolved":0,"recommendations":0,"remedial_actions":0,"referral":0,"remedial_actions_and_referral":0,"certificate_of_debt_process":0,"follow_up_or_assessment_invoking_powers_in_process":0,"follow_up_or_assessment_assessing_actions_in_process":0,"no_longer_pursued":0,"referral_and_remedial_actions":0,"remedial_actions_not_implemented":0,"invoked_powers_status_ab":0,"invoked_powers_status_mi":0,"impact_element_list":[]},"consequence_management":{"id":843,"municipality_id":31,"period":"2024-25","investigation_into_allegations":0,"scm_findings_reported_to_investigation":0,"findings_on_consequence_management":0,"disciplinary_board_not_established":0,"disciplinary_board_not_properly_constituted":0,"created_at":"2026-04-10T10:03:01.000000Z","updated_at":"2026-04-10T10:03:01.000000Z"}}}