Finding 975785 (2023-002)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-05-31

AI Summary

  • Core Issue: The Council missed the deadline to submit its Data Collection Form and Reporting Package to the Federal Audit Clearinghouse.
  • Impacted Requirements: This violates §200.512 of the Uniform Guidance, which mandates timely submission of audit reports.
  • Recommended Follow-Up: Implement monthly financial reporting and closeout processes to ensure timely submissions in the future.

Finding Text

Item 2023-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, 2023 to the Federal Audit Clearinghouse by the due date of March 31, 2024. 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 2023, which also impacted the timely reconciliation of their accounting records. Accordingly, the Council’s general ledger for the year ended June 30, 2023 was not closed out in a timely manner. Effect: The Council’s Data Collection Form and Reporting Package for the year ended June 30, 2023 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

  • 399342 2023-002
    Material Weakness Repeat
  • 399343 2023-002
    Material Weakness Repeat
  • 399344 2023-002
    Material Weakness Repeat
  • 399345 2023-002
    Material Weakness Repeat
  • 399346 2023-002
    Material Weakness Repeat
  • 399347 2023-002
    Material Weakness Repeat
  • 399348 2023-002
    Material Weakness Repeat
  • 399349 2023-002
    Material Weakness Repeat
  • 399350 2023-002
    Material Weakness Repeat
  • 975784 2023-002
    Material Weakness Repeat
  • 975786 2023-002
    Material Weakness Repeat
  • 975787 2023-002
    Material Weakness Repeat
  • 975788 2023-002
    Material Weakness Repeat
  • 975789 2023-002
    Material Weakness Repeat
  • 975790 2023-002
    Material Weakness Repeat
  • 975791 2023-002
    Material Weakness Repeat
  • 975792 2023-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
17.278 Wia Dislocated Worker Formula Grants $1.30M
17.258 Wia Adult Program $1.19M
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $457,432
20.205 Highway Planning and Construction $428,450
93.052 National Family Caregiver Support, Title Iii, Part E $418,198
11.307 Economic Adjustment Assistance $226,462
20.507 Federal Transit_formula Grants $135,079
17.259 Wia Youth Activities $125,752
93.324 State Health Insurance Assistance Program $114,313
11.302 Economic Development_support for Planning Organizations $104,785
93.042 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $75,592
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $63,775
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $37,329
93.634 Support for Ombudsman and Beneficiary Counseling Programs for States Participating in Financial Alignment Model Demonstrations for Dually Eligible Individuals $11,425
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $11,219
66.454 Water Quality Management Planning $9,827
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $2,747
97.039 Hazard Mitigation Grant $1,947