FAC Explorer

Audit 10362

FY End
2023-04-30
Total Expended
$4.65M
Findings
4
Programs
5
Organization: Village of Algonquin (IL)
Year: 2023 Accepted: 2024-01-09
Auditor: Sikich LLP

Organization Exclusion Status:

Findings

ID Ref Severity Repeat Requirement
7952 2023-001 - - L
7953 2023-001 - - L
584394 2023-001 - - L
584395 2023-001 - - L

Programs

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

Contacts

Name Title Type
HSV9ZCZJBNF7 Amanda Lichtenberger Auditee
8473090861 Jim Savio Auditor
No contacts on file

Notes to SEFA

Title: SUBRECIPIENTS Accounting Policies: The accompanying schedule of expenditures of federal awards is a summary of the activity of the Village’s federal award programs presented on the modified accrual basis of accounting in accordance with generally accepted accounting principles. Accordingly, revenues are recognized when the qualifying expenditure has been incurred and expenditures have been recognized when the fund liability has been incurred. De Minimis Rate Used: Y Rate Explanation: The Village has elected to use the 10% de minimis indirect cost rate as permitted by 2 CFR Section 200.414. The Village did not provide federal awards to subrecipients for the fiscal year ending April 30, 2023.
Title: OTHER INFORMATION Accounting Policies: The accompanying schedule of expenditures of federal awards is a summary of the activity of the Village’s federal award programs presented on the modified accrual basis of accounting in accordance with generally accepted accounting principles. Accordingly, revenues are recognized when the qualifying expenditure has been incurred and expenditures have been recognized when the fund liability has been incurred. De Minimis Rate Used: Y Rate Explanation: The Village has elected to use the 10% de minimis indirect cost rate as permitted by 2 CFR Section 200.414. No noncash assistance was provided and no federal insurance was in effect.
Title: OUTSTANDING FEDERAL LOANS Accounting Policies: The accompanying schedule of expenditures of federal awards is a summary of the activity of the Village’s federal award programs presented on the modified accrual basis of accounting in accordance with generally accepted accounting principles. Accordingly, revenues are recognized when the qualifying expenditure has been incurred and expenditures have been recognized when the fund liability has been incurred. De Minimis Rate Used: Y Rate Explanation: The Village has elected to use the 10% de minimis indirect cost rate as permitted by 2 CFR Section 200.414. The Village had Illinois Environmental Protection Agency Loans outstanding in the amount of $24,471,204 at April 30, 2023. The loans have no continuing compliance requirements aside from loan repayment.

Finding Details

Finding 2023-001
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.
Finding 2023-001
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.
Finding 2023-001
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.
Finding 2023-001
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.