Finding 7952 (2023-001)

-
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-01-09
Audit: 10362
Organization: Village of Algonquin (IL)
Auditor: Sikich LLP

AI Summary

  • Core Issue: The Village did not submit required financial reports on time for the Coronavirus State and Local Fiscal Recovery Funds.
  • Impacted Requirements: This is a violation of the reporting compliance outlined in the grant agreement.
  • Recommended Follow-Up: The Village should enhance controls over reporting to prevent future delays.

Finding Text

2023-001 Reporting – Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number 21.027 Grant Period - Year Ended April 30, 2023 Criteria: In accordance with the grant agreement the Village was required to submit periodic financial reports to the Illinois Department of Commerce and Economic Opportunity as outlined on the schedule provided within the agreement. Condition: The Village failed to submit the periodic performance report and periodic financial report for the period ending December 31, 2022, in a timely manner. We consider this to be an instance of non-compliance relating to the Reporting Compliance Requirement. Effect: The result is that the Village did not submit the required information to the Illinois Department of Commerce and Economic Opportunity in a timely fashion. Cause: The condition was an administrative oversight. Recommendation: We recommend the Village increase controls over reporting. Views of Responsible Officials: Management agrees with the Single Audit finding and a response is included in the Corrective Action Plan.

Corrective Action Plan

RECOMMENDATION: IT IS RECOMMENDED THAT THE VILLAGE INCREASE CONTROLS OVER REPORTING. CORRECTIVE ACTION: IN ORDER TO ENSURE THAT ALL REPORTING REQUIREMENTS ARE BEING MET IN A TIMELY FASHION, ALL GRANT AGREEMENTS WILL BE FORWARDED TO THE FINANCE DEPARTMENT TO REVIEW. THE DEPUTY CHIEF FINANCIAL OFFICER WILL REVIEW THE AGREEMENT FOR ANY AND ALL REPORTING REQUIREMENTS. THESE REQUIREMENTS WILL THEN BE TRACKED AND FOLLOWED UP ON WITH THE RESPONSIBLE DEPARTMENT THROUGHOUT THE YEAR, AS DEADLINES APPROACH. PERSON RESPONSIBLE FOR CORRECTIVE ACTION: DEPUTY CHIEF FINANCIAL OFFICER. ANTICIPATED COMPLETION DATE FOR CORRECTIVE ACTION: THE CORRECTIVE ACTION WILL BE FULLY IMPLEMENTED BY THE END OF FISCAL YEAR 2024.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $3.30M
66.458 Capitalization Grants for Clean Water State Revolving Funds $896,638
66.046 Climate Pollution Reduction Grants $419,706
20.600 State and Community Highway Safety $11,460
16.607 Bulletproof Vest Partnership Program $7,474