{"success":true,"code":200,"message":"OK","data":{"id":151,"auditee_id":837,"category":"MUN","created_at":"2023-05-11T17:19:44.000000Z","district_id":29,"exclude":null,"map_url":null,"name":"Magareng","parent_id":null,"slug":"7-magareng","status":"Normal","type":"LM","required_intervention":0,"unqualified_opinion_misstatements":"N\/A","updated_at":"2023-05-11T17:19:44.000000Z","audit_opinions":[{"id":7299,"municipality_id":151,"period":"2024-25","engagement":"FA","opinion_evaluation":"Unchanged","audit_opinion":"Qualified","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":"A","exclude":0,"created_at":"2026-04-10T08:50:55.000000Z","updated_at":"2026-04-10T08:50:55.000000Z"},{"id":7025,"municipality_id":151,"period":"2023-24","engagement":"FA","opinion_evaluation":"Unchanged","audit_opinion":"Qualified","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":"2025-03-07T10:04:08.000000Z","updated_at":"2025-03-07T10:04:08.000000Z"},{"id":6751,"municipality_id":151,"period":"2022-23","engagement":"FA","opinion_evaluation":"Unchanged","audit_opinion":"Qualified","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":"2024-05-16T11:04:29.000000Z","updated_at":"2024-05-16T11:04:29.000000Z"},{"id":6201,"municipality_id":151,"period":"2021-22","engagement":"FA","opinion_evaluation":"Unchanged","audit_opinion":"Qualified","information_reliable":"Yes","not_submitted_in_time":"Yes","information_useful":"Yes","performance_report":"Yes","planning_documents":"Yes","predetermined_objectives":"Yes","compliance_legislation":"Yes","quality_performance_report":"R","exclude":0,"created_at":"2023-05-23T21:55:18.000000Z","updated_at":"2023-05-23T21:55:18.000000Z"},{"id":4277,"municipality_id":151,"period":"2020-21","engagement":"FA","opinion_evaluation":"Unchanged","audit_opinion":"Qualified","information_reliable":"No","not_submitted_in_time":"Yes","information_useful":"Yes","performance_report":"Yes","planning_documents":"Yes","predetermined_objectives":"Yes","compliance_legislation":"Yes","quality_performance_report":"R","exclude":0,"created_at":"2023-05-19T12:54:16.000000Z","updated_at":"2023-05-19T12:54:16.000000Z"},{"id":4001,"municipality_id":151,"period":"2019-20","engagement":"FA","opinion_evaluation":"Unchanged","audit_opinion":"Qualified","information_reliable":"Yes","not_submitted_in_time":"Yes","information_useful":"Yes","performance_report":"Yes","planning_documents":"Yes","predetermined_objectives":"Yes","compliance_legislation":"Yes","quality_performance_report":"R","exclude":0,"created_at":"2023-05-19T12:53:37.000000Z","updated_at":"2023-05-19T12:53:37.000000Z"},{"id":3725,"municipality_id":151,"period":"2018-19","engagement":"FA","opinion_evaluation":"Unchanged","audit_opinion":"Qualified","information_reliable":"Yes","not_submitted_in_time":"Yes","information_useful":"Yes","performance_report":"Yes","planning_documents":"Yes","predetermined_objectives":"Yes","compliance_legislation":"Yes","quality_performance_report":"R","exclude":0,"created_at":"2023-05-19T12:53:00.000000Z","updated_at":"2023-05-19T12:53:00.000000Z"},{"id":6475,"municipality_id":151,"period":"2017-18","engagement":"FA","opinion_evaluation":"Unchanged","audit_opinion":"Qualified","information_reliable":"No","not_submitted_in_time":"Yes","information_useful":"Yes","performance_report":"Yes","planning_documents":"Yes","predetermined_objectives":"Yes","compliance_legislation":"Yes","quality_performance_report":"R","exclude":0,"created_at":"2023-05-23T21:55:51.000000Z","updated_at":"2023-05-23T21:55:51.000000Z"}],"expenditures":[{"id":2865,"municipality_id":151,"period":"2024-25","irregular_expenditure":115461396,"irregular_expenditure_balance":290787631,"unauthorised_expenditure":33142722,"unauthorised_expenditure_balance":297233861,"wasteful_expenditure":4344997,"wasteful_expenditure_balance":30872407,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":"A","exclude":0,"created_at":"2026-04-10T09:59:37.000000Z","updated_at":"2026-04-10T10:02:31.000000Z"},{"id":2591,"municipality_id":151,"period":"2023-24","irregular_expenditure":45806429,"irregular_expenditure_balance":175326235,"unauthorised_expenditure":33782010,"unauthorised_expenditure_balance":260770742,"wasteful_expenditure":973442,"wasteful_expenditure_balance":26527410,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":"N","exclude":0,"created_at":"2025-03-07T10:07:09.000000Z","updated_at":"2025-03-07T10:08:33.000000Z"},{"id":2317,"municipality_id":151,"period":"2022-23","irregular_expenditure":22878449,"irregular_expenditure_balance":129519806,"unauthorised_expenditure":24275080,"unauthorised_expenditure_balance":225265694,"wasteful_expenditure":6509332,"wasteful_expenditure_balance":25553968,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":"A","exclude":0,"created_at":"2024-05-16T11:09:07.000000Z","updated_at":"2024-05-16T11:10:40.000000Z"},{"id":2024,"municipality_id":151,"period":"2021-22","irregular_expenditure":26857695,"irregular_expenditure_balance":106641357,"unauthorised_expenditure":22535205,"unauthorised_expenditure_balance":200990614,"wasteful_expenditure":4100702,"wasteful_expenditure_balance":19044636,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":null,"exclude":0,"created_at":"2023-05-23T23:07:07.000000Z","updated_at":"2023-05-23T23:07:07.000000Z"},{"id":1755,"municipality_id":151,"period":"2020-21","irregular_expenditure":26104553,"irregular_expenditure_balance":79783662,"unauthorised_expenditure":57943576,"unauthorised_expenditure_balance":178455409,"wasteful_expenditure":852562,"wasteful_expenditure_balance":14943934,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":null,"exclude":0,"created_at":"2023-05-11T18:17:21.000000Z","updated_at":"2023-05-11T18:17:21.000000Z"},{"id":997,"municipality_id":151,"period":"2019-20","irregular_expenditure":22096650,"irregular_expenditure_balance":53679109,"unauthorised_expenditure":58738877,"unauthorised_expenditure_balance":120511833,"wasteful_expenditure":7820933,"wasteful_expenditure_balance":14091372,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":null,"exclude":0,"created_at":"2023-05-11T17:20:20.000000Z","updated_at":"2023-05-11T17:20:20.000000Z"},{"id":998,"municipality_id":151,"period":"2018-19","irregular_expenditure":8462741,"irregular_expenditure_balance":59560581,"unauthorised_expenditure":69543240,"unauthorised_expenditure_balance":177519151,"wasteful_expenditure":5400199,"wasteful_expenditure_balance":24882498,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":null,"exclude":0,"created_at":"2023-05-11T17:20:20.000000Z","updated_at":"2023-05-11T17:20:20.000000Z"},{"id":999,"municipality_id":151,"period":"2017-18","irregular_expenditure":22847379,"irregular_expenditure_balance":51097840,"unauthorised_expenditure":30533375,"unauthorised_expenditure_balance":107975911,"wasteful_expenditure":7987580,"wasteful_expenditure_balance":19482299,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":null,"exclude":0,"created_at":"2023-05-11T17:20:20.000000Z","updated_at":"2023-05-11T17:20:20.000000Z"}],"entities":[],"grant_management":{"id":1842,"municipality_id":151,"period":"2024-25","percentage_underspending":2.4,"underspend_threshold":"No","maintenance_spend":0,"percentage_maintenance_spend":0,"internal_control_assessment":"Concerning","record_keeping":"Concerning","dm_controls":"Concerning","year_end_reporting":"Concerning","monitor_compliance":"Concerning","exclude":0,"created_at":"2026-04-10T08:52:35.000000Z","updated_at":"2026-04-10T08:52:35.000000Z"},"it_control":{"id":1730,"municipality_id":151,"period":"2024-25","overall_assessment":null,"it_governance":"Intervention Required","it_security":"Intervention Required","it_continuity":"Intervention Required","unused_expenditure":null,"expenditure_amount":0,"exclude":0,"created_at":"2026-04-10T08:54:38.000000Z","updated_at":"2026-04-10T08:54:38.000000Z"},"financial_health":{"id":1536,"municipality_id":151,"period":"2024-25","material_findings":null,"creditor_payment_period":956,"debtor_collection_period":346,"eskom_arrears":0,"debt_irrecoverable":"89.00","deficit_realised":"No","deficit_realised_amount":0,"net_current_liability_realised":null,"bank_overdraft":null,"liabilities_next_budget":351,"expenditure_next_budget":"351","expenditure_next_half_budget":"351","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":1.64,"exclude":0,"created_at":"2026-04-10T10:01:51.000000Z","updated_at":"2026-06-03T08:31:52.000000Z"},"root_cause":{"id":2474,"municipality_id":151,"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":453,"municipality_id":151,"households":7318,"population":26816,"unemployment_rate":41.2,"youth_unemployment_rate":51.8,"water_access":73.4,"electricity_access":96.3,"refuse_removal":77.3,"flush_toilet":87.7,"exclude":0,"created_at":"2023-05-15T14:54:03.000000Z","updated_at":"2026-06-04T07:15:45.000000Z"},"supply_chain":{"id":2088,"municipality_id":151,"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":"Yes","exclude":0,"created_at":"2026-04-10T08:53:27.000000Z","updated_at":"2026-06-05T18:26:59.000000Z"},"district":{"id":29,"province_id":7,"name":"Frances Baard","slug":"7-frances-baard","map_url":null,"created_at":"2023-05-11T17:19:43.000000Z","updated_at":"2023-05-11T17:19:43.000000Z","province":{"id":7,"name":"Northern Cape","iso":"NC","slug":"northern-cape","map_url":null}},"financials":{"id":1426,"municipality_id":151,"period":"2024-25","equitable_share":65001000,"grants":82604096,"property_rates":13246627,"services_electricity":17730314,"services_water":4867558,"other_revenue":33195811,"own_revenue":85292222,"total_revenue":232897318,"repairs_and_maintenance_as_of_ppe_at_carrying_value":0.6,"total_infrastructure_grants":71924212,"total_property_plant_and_equipment_at_carrying_amount":497318261,"repairs_and_maintenance_total":2818686,"investment_property_carrying_amount":21079462,"infrastructure_assets_at_carrying_amount":146794872,"repairs_and_maintenance_as_of_ppe_with_investment_property":0.5,"exclude":0,"created_at":"2026-04-10T10:04:29.000000Z","updated_at":"2026-06-02T09:33:58.000000Z","total_grants":147605096},"assurance":{"id":1264,"municipality_id":151,"period":"2024-25","mc_established":"Yes","mc_instability":"No","mc_assurance_level":"Provides some assurance","cfo_appointed":"Yes","cfo_total_months":12,"cfo_months_vacant":0,"finance_vacancy_rate":35,"mm_total_months":0,"mm_vacancy":"No","finance_resourcing":"Concerned","finance_resourcing_concerning":null,"sm_vacancy_rate":40,"overall_vacancy_rate":40,"mm_months_vacant":36,"mpac_established":"Yes","ia_established":"Yes","ac_established":"Yes","exclude":0,"created_at":"2026-04-10T09:59:03.000000Z","updated_at":"2026-04-10T09:59:03.000000Z"},"audit_outcome":{"id":6195,"municipality_id":151,"period":"2024-25","engagement":"FA","afs_received_date":"2025-08-31","material_misstatement":"Yes","irregular_expenditure":"Yes","afs_and_ar":"No","asset_management":"No","liability_management":null,"budgets":null,"expenditure_management":"Yes","consequence_management":"Yes","audit_committees":null,"internal_audit":null,"revenue_management":"Yes","performance_management":"No","grants":"A","procurement_management":"Yes","hr_management":"No","other":null,"afs_submitted_in_time":"Yes","afs_good_quality":null,"findings_consequence_management":"R","environmental_management":null,"fwe_not_prevented":null,"ie_not_prevented":null,"ue_not_prevented":null,"exclude":0,"created_at":"2026-04-10T08:51:12.000000Z","updated_at":"2026-05-20T00:42:39.000000Z"},"financial_qualification":{"id":1400,"municipality_id":151,"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":"N","receivables":"N","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":"N","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":"R","revenue_non_exchange_transactions":"R","expenditure":null,"employee_cost":null,"unauthorised_expenditure":null,"irregular_expenditure":"A","fruitless_wasteful_xpenditure":null,"aggregate_misstatements":"A","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:23.000000Z","updated_at":"2026-04-10T10:02:23.000000Z"},"waterboard":{"id":1302,"municipality_id":151,"period":"2024-25","0_to_30days":51372.5,"31_to_90days":104135.4,"over_90days":140242468.1,"total_arrears":140346603.6,"total_owed":140397976.1,"interest_owed":0,"payment_arrangement":null,"bulk_purchases":8572334,"water_losses_disclosed":"Yes","essential_service_provider_of_water_yn":"Yes","percentage_water_losses":96,"amount_losses":6116015,"non_disclosure_comments":null,"incomplete_reason":null,"comments":null,"water_arrears":140346603.6,"exclude":0,"created_at":"2026-04-10T10:03:51.000000Z","updated_at":"2026-04-10T10:03:51.000000Z"},"eskom":{"id":1331,"municipality_id":151,"period":"2024-25","0_to_30days":3247497.3,"31_to_90days":2560811.3,"over_90days":129541701.8,"total_arrears":132102513.1,"total_owed":135350010.5,"interest_owed":0,"payment_arrangement":null,"bulk_purchases":31321989,"eskom_arrears":132102513.1,"electricity_losses_amount":4532432,"electricity_losses_percentage":41,"electricity_losses_disclosed":"Yes","essential_service_provider_of_electricity_yn":"Yes","exclude":0,"created_at":"2026-04-10T10:04:11.000000Z","updated_at":"2026-04-10T10:04:11.000000Z"},"consultant":{"id":2405,"municipality_id":151,"period":"2024-25","consultant_appointed":"Yes","consultant_cost":7890432.03,"consultant_reason":"Lack of skills and vacancies","consultant_reason_other_institutions":null,"consultants_ineffective":"Yes","ineffective_reason":"Inadequate review of work","ineffective_reason_other_institutions":null,"financial_statements":"0","asset_management":"2916019.73","accounting_service":"4577484.3","tax_services":"396928","other_services":"0","consultant_financial_reporting":"15356311.03","exclude":0,"created_at":"2026-04-10T10:00:17.000000Z","updated_at":"2026-04-10T10:00:17.000000Z"},"material_irregularities":{"0":{"id":8397,"municipality_id":151,"period":"2024-25","mi_implemented":null,"number_mis_notified":0,"action_taken":0,"follow_up":0,"resolved":0,"recommendations":0,"referral":0,"remedial_action":0,"exclude":0,"created_at":"2026-05-11T14:13:31.000000Z","updated_at":"2026-05-11T14:13:31.000000Z","notification_date":"2023-05-05","status_of_mi":"Resolved MI","status_of_ab":"Resolved","impact_element":"Material financial loss"},"1":{"id":8555,"municipality_id":151,"period":"2024-25","mi_implemented":null,"number_mis_notified":0,"action_taken":0,"follow_up":0,"resolved":0,"recommendations":0,"referral":0,"remedial_action":0,"exclude":0,"created_at":"2026-05-11T14:13:34.000000Z","updated_at":"2026-05-11T14:13:34.000000Z","notification_date":"2023-03-10","status_of_mi":"Resolved MI","status_of_ab":"Resolved in prior periods","impact_element":"Likely material financial loss"},"status_of_ab":1,"total_notifications":2,"recently_notified_awaiting_response":0,"follow_up_or_assessment_in_process":0,"appropriate_actions_in_process":0,"resolved":2,"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":[{"total":1,"impact_element":"Material financial loss"},{"total":1,"impact_element":"Likely material financial loss"}]},"consequence_management":{"id":951,"municipality_id":151,"period":"2024-25","investigation_into_allegations":0,"scm_findings_reported_to_investigation":0,"findings_on_consequence_management":3,"disciplinary_board_not_established":0,"disciplinary_board_not_properly_constituted":0,"created_at":"2026-04-10T10:03:03.000000Z","updated_at":"2026-04-10T10:03:03.000000Z"}}}