{"success":true,"code":200,"message":"OK","data":{"id":274,"auditee_id":875,"category":"MUN","created_at":"2023-05-11T17:19:45.000000Z","district_id":1,"exclude":null,"map_url":null,"name":"Tsantsabane","parent_id":null,"slug":"7-tsantsabane","status":"Normal","type":"LM","required_intervention":0,"unqualified_opinion_misstatements":"N\/A","updated_at":"2023-05-11T17:19:45.000000Z","audit_opinions":[{"id":7391,"municipality_id":274,"period":"2024-25","engagement":"FA","opinion_evaluation":"Improved","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":"2026-04-10T08:50:58.000000Z","updated_at":"2026-04-10T09:56:10.000000Z"},{"id":7117,"municipality_id":274,"period":"2023-24","engagement":"FA","opinion_evaluation":"Regressed","audit_opinion":"Disclaimer","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":"2025-03-07T10:04:09.000000Z","updated_at":"2025-03-07T10:04:09.000000Z"},{"id":6843,"municipality_id":274,"period":"2022-23","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":"2024-05-16T11:04:30.000000Z","updated_at":"2024-05-16T11:04:30.000000Z"},{"id":6293,"municipality_id":274,"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:19.000000Z","updated_at":"2023-05-23T21:55:19.000000Z"},{"id":4369,"municipality_id":274,"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":"2026-06-02T13:44:02.000000Z"},{"id":4092,"municipality_id":274,"period":"2019-20","engagement":"FA","opinion_evaluation":"Unchanged","audit_opinion":"Qualified","information_reliable":"No","not_submitted_in_time":"Yes","information_useful":"No","performance_report":"Yes","planning_documents":"No","predetermined_objectives":"Yes","compliance_legislation":"Yes","quality_performance_report":"R","exclude":0,"created_at":"2023-05-19T12:53:38.000000Z","updated_at":"2025-05-14T06:18:36.000000Z"},{"id":3817,"municipality_id":274,"period":"2018-19","engagement":"FA","opinion_evaluation":"Improved","audit_opinion":"Qualified","information_reliable":"No","not_submitted_in_time":"Yes","information_useful":"No","performance_report":"Yes","planning_documents":"No","predetermined_objectives":"Yes","compliance_legislation":"Yes","quality_performance_report":"R","exclude":0,"created_at":"2023-05-19T12:53:01.000000Z","updated_at":"2024-05-16T11:19:15.000000Z"},{"id":6567,"municipality_id":274,"period":"2017-18","engagement":"FA","opinion_evaluation":"Unchanged","audit_opinion":"Disclaimer","information_reliable":"Yes","not_submitted_in_time":"Yes","information_useful":"Yes","performance_report":"Yes","planning_documents":"No","predetermined_objectives":"Yes","compliance_legislation":"Yes","quality_performance_report":"R","exclude":0,"created_at":"2023-05-23T21:55:52.000000Z","updated_at":"2023-05-23T21:55:52.000000Z"}],"expenditures":[{"id":2973,"municipality_id":274,"period":"2024-25","irregular_expenditure":2630800,"irregular_expenditure_balance":92786246,"unauthorised_expenditure":35674414,"unauthorised_expenditure_balance":890714712,"wasteful_expenditure":41286690,"wasteful_expenditure_balance":212027092,"ue_qualified":"R","fwe_qualified":"R","ie_qualified":"R","exclude":0,"created_at":"2026-04-10T09:59:41.000000Z","updated_at":"2026-04-10T10:02:32.000000Z"},{"id":2699,"municipality_id":274,"period":"2023-24","irregular_expenditure":9590158,"irregular_expenditure_balance":90155446,"unauthorised_expenditure":95145496,"unauthorised_expenditure_balance":855040298,"wasteful_expenditure":42685281,"wasteful_expenditure_balance":170740402,"ue_qualified":"R","fwe_qualified":"R","ie_qualified":"R","exclude":0,"created_at":"2025-03-07T10:07:10.000000Z","updated_at":"2025-03-07T10:08:34.000000Z"},{"id":2425,"municipality_id":274,"period":"2022-23","irregular_expenditure":16436787,"irregular_expenditure_balance":80565288,"unauthorised_expenditure":43960419,"unauthorised_expenditure_balance":759894802,"wasteful_expenditure":20724977,"wasteful_expenditure_balance":128055121,"ue_qualified":"R","fwe_qualified":"R","ie_qualified":"R","exclude":0,"created_at":"2024-05-16T11:09:08.000000Z","updated_at":"2024-05-16T11:10:40.000000Z"},{"id":2132,"municipality_id":274,"period":"2021-22","irregular_expenditure":19247558,"irregular_expenditure_balance":64128501,"unauthorised_expenditure":56851442,"unauthorised_expenditure_balance":715934383,"wasteful_expenditure":38608154,"wasteful_expenditure_balance":107330144,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":null,"exclude":0,"created_at":"2023-05-23T23:07:08.000000Z","updated_at":"2023-05-23T23:07:08.000000Z"},{"id":1860,"municipality_id":274,"period":"2020-21","irregular_expenditure":0,"irregular_expenditure_balance":44880943,"unauthorised_expenditure":44750238,"unauthorised_expenditure_balance":655777532,"wasteful_expenditure":0,"wasteful_expenditure_balance":68721990,"ue_qualified":null,"fwe_qualified":null,"ie_qualified":null,"exclude":0,"created_at":"2023-05-11T18:17:22.000000Z","updated_at":"2023-05-11T18:17:22.000000Z"},{"id":1167,"municipality_id":274,"period":"2019-20","irregular_expenditure":13901623,"irregular_expenditure_balance":44880943,"unauthorised_expenditure":83164727,"unauthorised_expenditure_balance":611027294,"wasteful_expenditure":15042013,"wasteful_expenditure_balance":71473266,"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":1168,"municipality_id":274,"period":"2018-19","irregular_expenditure":0,"irregular_expenditure_balance":30979320,"unauthorised_expenditure":31371879,"unauthorised_expenditure_balance":493799271,"wasteful_expenditure":13979952,"wasteful_expenditure_balance":56431253,"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":1169,"municipality_id":274,"period":"2017-18","irregular_expenditure":18605170,"irregular_expenditure_balance":30979320,"unauthorised_expenditure":47629173,"unauthorised_expenditure_balance":462427392,"wasteful_expenditure":12728201,"wasteful_expenditure_balance":42451301,"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":1922,"municipality_id":274,"period":"2024-25","percentage_underspending":14.7,"underspend_threshold":"Yes","maintenance_spend":0,"percentage_maintenance_spend":0,"internal_control_assessment":"Intervention required","record_keeping":"Intervention required","dm_controls":"Intervention required","year_end_reporting":"Intervention required","monitor_compliance":"Intervention required","exclude":0,"created_at":"2026-04-10T08:52:38.000000Z","updated_at":"2026-04-20T14:14:25.000000Z"},"it_control":{"id":1822,"municipality_id":274,"period":"2024-25","overall_assessment":null,"it_governance":"Concerning","it_security":"Good","it_continuity":"Concerning","unused_expenditure":null,"expenditure_amount":0,"exclude":0,"created_at":"2026-04-10T08:54:43.000000Z","updated_at":"2026-04-10T08:54:43.000000Z"},"financial_health":{"id":1570,"municipality_id":274,"period":"2024-25","material_findings":null,"creditor_payment_period":1199,"debtor_collection_period":23,"eskom_arrears":0,"debt_irrecoverable":"91.00","deficit_realised":"Yes","deficit_realised_amount":113692067,"net_current_liability_realised":null,"bank_overdraft":null,"liabilities_next_budget":346,"expenditure_next_budget":"346","expenditure_next_half_budget":"346","water_arrears":0,"years_going_concern":"No","number_of_years_of_going_concern_uncertainty":3,"years_going_concern_qualification":1,"net_liability_realised":null,"solvency_ratio":1.16,"exclude":0,"created_at":"2026-04-10T10:01:53.000000Z","updated_at":"2026-06-03T08:31:54.000000Z"},"root_cause":{"id":2508,"municipality_id":274,"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":485,"municipality_id":274,"households":14078,"population":30969,"unemployment_rate":26.1,"youth_unemployment_rate":32.3,"water_access":88,"electricity_access":92,"refuse_removal":78.3,"flush_toilet":85.4,"exclude":0,"created_at":"2023-05-15T14:54:04.000000Z","updated_at":"2026-06-04T07:15:46.000000Z"},"supply_chain":{"id":2196,"municipality_id":274,"period":"2024-25","unfair_procurement":"Yes","awarded_family":null,"scope_limitations":"Yes","awarded_employees":null,"awarded_officials":"Yes","scm_received":0,"irregular_expenditure":null,"inadequate_contract":"Yes","exclude":0,"created_at":"2026-04-10T08:53:37.000000Z","updated_at":"2026-04-10T09:58:01.000000Z"},"district":{"id":1,"province_id":7,"name":"ZF Mgcawu District","slug":"7-zf-mgcawu-district","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":1460,"municipality_id":274,"period":"2024-25","equitable_share":58842000,"grants":62222052,"property_rates":32584900,"services_electricity":71221647,"services_water":8902889,"other_revenue":8808017,"own_revenue":170320355,"total_revenue":291384407,"repairs_and_maintenance_as_of_ppe_at_carrying_value":0.4,"total_infrastructure_grants":36487967,"total_property_plant_and_equipment_at_carrying_amount":674330505,"repairs_and_maintenance_total":2399350,"investment_property_carrying_amount":49746139,"infrastructure_assets_at_carrying_amount":509558422,"repairs_and_maintenance_as_of_ppe_with_investment_property":0.3,"exclude":0,"created_at":"2026-04-10T10:04:29.000000Z","updated_at":"2026-06-02T09:33:59.000000Z","total_grants":121064052},"assurance":{"id":1273,"municipality_id":274,"period":"2024-25","mc_established":"Yes","mc_instability":"No","mc_assurance_level":"Provides limited or no assurance","cfo_appointed":"No","cfo_total_months":0,"cfo_months_vacant":10,"finance_vacancy_rate":35,"mm_total_months":24,"mm_vacancy":"Yes","finance_resourcing":"Concerned","finance_resourcing_concerning":null,"sm_vacancy_rate":17,"overall_vacancy_rate":31,"mm_months_vacant":0,"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":6287,"municipality_id":274,"period":"2024-25","engagement":"FA","afs_received_date":"2025-08-31","material_misstatement":"Yes","irregular_expenditure":"Yes","afs_and_ar":"Yes","asset_management":"Yes","liability_management":null,"budgets":null,"expenditure_management":"Yes","consequence_management":"Yes","audit_committees":null,"internal_audit":"N","revenue_management":"Yes","performance_management":"Yes","grants":"R","procurement_management":"Yes","hr_management":"Yes","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:18.000000Z","updated_at":"2026-05-20T00:42:40.000000Z"},"financial_qualification":{"id":1501,"municipality_id":274,"period":"2024-25","property_infrastructure":"R","investment_property":"R","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":"R","inventory":"R","other_current_assest":null,"other_current_financial_instruments":null,"payables_and_borrowings":"R","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":"A","cash_flow_statement":null,"related_parties":null,"events_after_reporting":"A","accounting_policies":"R","contingent_liabilities":"R","other_disclosures":"R","going_concern":"R","criminal_conduct":null,"statement_comparison":"N","revenue_exchange_transactions":"R","revenue_non_exchange_transactions":"R","expenditure":"R","employee_cost":null,"unauthorised_expenditure":"R","irregular_expenditure":"R","fruitless_wasteful_xpenditure":"R","aggregate_misstatements":"N","cash_flow_from_operating_activities":"R","cash_flow_from_investing_activities":"R","cash_flow_from_financing_activities":"R","odi_electricity_losses":"N","odi_water_losses":null,"odi_written_representations":null,"exclude":0,"created_at":"2026-04-10T10:02:25.000000Z","updated_at":"2026-05-12T13:21:10.000000Z"},"waterboard":{"id":1336,"municipality_id":274,"period":"2024-25","0_to_30days":0,"31_to_90days":0,"over_90days":146461312.6,"total_arrears":146461312.6,"total_owed":146461312.6,"interest_owed":12511400.8,"payment_arrangement":null,"bulk_purchases":12309070,"water_losses_disclosed":"Yes","essential_service_provider_of_water_yn":"Yes","percentage_water_losses":64.7,"amount_losses":7963679,"non_disclosure_comments":null,"incomplete_reason":null,"comments":null,"water_arrears":146461312.6,"exclude":0,"created_at":"2026-04-10T10:03:53.000000Z","updated_at":"2026-04-10T10:03:53.000000Z"},"eskom":{"id":1365,"municipality_id":274,"period":"2024-25","0_to_30days":11144209,"31_to_90days":14652047.5,"over_90days":337453506.1,"total_arrears":352105553.6,"total_owed":363249762.6,"interest_owed":26655131.6,"payment_arrangement":null,"bulk_purchases":63562897,"eskom_arrears":352105553.6,"electricity_losses_amount":16862110,"electricity_losses_percentage":26.5,"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":2508,"municipality_id":274,"period":"2024-25","consultant_appointed":"Yes","consultant_cost":2691996,"consultant_reason":"Lack of skills and vacancies","consultant_reason_other_institutions":null,"consultants_ineffective":"Yes","ineffective_reason":"Consultant appointed too late","ineffective_reason_other_institutions":null,"financial_statements":"192424","asset_management":"1544831","accounting_service":"166174","tax_services":"788567","other_services":"0","consultant_financial_reporting":"15235429.02","exclude":0,"created_at":"2026-04-10T10:00:20.000000Z","updated_at":"2026-04-10T10:00:20.000000Z"},"material_irregularities":{"0":{"id":8314,"municipality_id":274,"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:29.000000Z","updated_at":"2026-05-11T14:13:29.000000Z","notification_date":"2025-05-07","status_of_mi":"Appropriate action not taken - invoked our powers","status_of_ab":"Not appropriate actions - Invoked our powers","impact_element":"Likely substantial harm to public sector institution"},"status_of_ab":1,"total_notifications":1,"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":1,"invoked_powers_status_mi":1,"impact_element_list":[{"total":1,"impact_element":"Likely substantial harm to public sector institution"}]},"consequence_management":{"id":1059,"municipality_id":274,"period":"2024-25","investigation_into_allegations":1,"scm_findings_reported_to_investigation":1,"findings_on_consequence_management":4,"disciplinary_board_not_established":0,"disciplinary_board_not_properly_constituted":0,"created_at":"2026-04-10T10:03:05.000000Z","updated_at":"2026-04-10T10:03:05.000000Z"}}}