Finding 1034331 (2022-002)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-09-26

AI Summary

  • Core Issue: The Council missed the deadline to submit its Data Collection Form and Reporting Package to the Federal Audit Clearinghouse for the year ended June 30, 2022.
  • Impacted Requirements: This failure violates the Uniform Guidance, specifically section ?200.512, which mandates timely submission of audit reports.
  • Recommended Follow-Up: Management should establish monthly financial reporting and closeout processes to ensure timely completion of financial records.

Finding Text

Item 2022-002: Report Submission to the Federal Audit Clearinghouse (Other Matter Required to be Reported Under the Uniform Guidance) (Material Weakness) Condition: The Council did not prepare and submit its Data Collection Form and Reporting Package for the year ended June 30, 2022 to the Federal Audit Clearinghouse by the due date of March 31, 2023. Criteria: Per ?200.512 of the Uniform Guidance, Report Submission, the audit shall be completed and the Data Collection Form and Reporting Package shall be electronically transmitted within the earlier of thirty (30) days after receipt of the auditor?s reports, or nine (9) months after the end of the audit period. If the due date falls on a Saturday, Sunday, or federal holiday, the Data Collection Form and Reporting Package are due the next business day. The Uniform Guidance does not permit the recipient to extend the due date. Cause: Management did not review subsidiary ledgers for accuracy and reconcile them to the general ledger on a timely basis. The Council also replaced their Finance Director and other finance staff in fiscal year 2022, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council?s general ledger for the year ended June 30, 2022 was not closed out in a timely manner. Effect: The Council?s Data Collection Form and Reporting Package for the year ended June 30, 2022 was not prepared and submitted to the Federal Audit Clearinghouse by the due date. Recommendation: We recommend that management implement monthly financial reporting and closeout processes so that the financial closeout process can be performed timely.

Categories

Material Weakness Reporting

Other Findings in this Audit

  • 457880 2022-002
    Material Weakness
  • 457881 2022-002
    Material Weakness
  • 457882 2022-002
    Material Weakness
  • 457883 2022-002
    Material Weakness
  • 457884 2022-002
    Material Weakness
  • 457885 2022-002
    Material Weakness
  • 457886 2022-002
    Material Weakness
  • 457887 2022-002
    Material Weakness
  • 457888 2022-002
    Material Weakness
  • 457889 2022-002
    Material Weakness
  • 457890 2022-002
    Material Weakness
  • 457891 2022-002
    Material Weakness
  • 1034322 2022-002
    Material Weakness
  • 1034323 2022-002
    Material Weakness
  • 1034324 2022-002
    Material Weakness
  • 1034325 2022-002
    Material Weakness
  • 1034326 2022-002
    Material Weakness
  • 1034327 2022-002
    Material Weakness
  • 1034328 2022-002
    Material Weakness
  • 1034329 2022-002
    Material Weakness
  • 1034330 2022-002
    Material Weakness
  • 1034332 2022-002
    Material Weakness
  • 1034333 2022-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
17.258 Wia Adult Program $1.15M
20.507 Federal Transit_formula Grants $417,999
17.259 Wia Youth Activities $256,469
93.324 State Health Insurance Assistance Program $158,529
11.307 Economic Adjustment Assistance $131,781
20.205 Highway Planning and Construction $85,000
11.302 Economic Development_support for Planning Organizations $73,131
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $53,547
97.039 Hazard Mitigation Grant $43,343
93.042 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $43,188
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $29,073
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $21,843
66.468 Capitalization Grants for Drinking Water State Revolving Funds $16,829
93.052 National Family Caregiver Support, Title Iii, Part E $15,594
66.454 Water Quality Management Planning $11,993
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $3,000
17.278 Wia Dislocated Worker Formula Grants $3,000
93.048 Special Programs for the Aging_title Iv_and Title Ii_discretionary Projects $1,484
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $735