FAC Explorer

Audit 327310

FY End
2024-04-30
Total Expended
$4.33M
Findings
4
Programs
6
Organization: Village of Rantoul (IL)
Year: 2024 Accepted: 2024-11-05
Auditor: Cliftonlarsonallen LLP

Organization Exclusion Status:

Findings

ID Ref Severity Repeat Requirement
504695 2024-003 Significant Deficiency Yes I
504696 2024-004 Significant Deficiency Yes L
1081137 2024-003 Significant Deficiency Yes I
1081138 2024-004 Significant Deficiency Yes L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $2.42M Yes 2
11.307 Economic Adjustment Assistance $1.43M - 0
14.218 Community Development Block Grants/entitlement Grants $287,956 - 0
20.106 Airport Improvement Program, Covid-19 Airports Programs, and Infrastructure Investment and Jobs Act Programs $132,701 - 0
20.205 Highway Planning and Construction $41,857 - 0
10.558 Child and Adult Care Food Program $13,157 - 0

Contacts

Name Title Type
LJW3VQGNC4K5 Angela Schultz Auditee
2178926831 Sandy Cook Auditor
No contacts on file

Notes to SEFA

Title: NONCASH AWARDS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal award activity of the Village of Rantoul, Illinois (the Village) under programs of the federal government for the year ended April 30, 2024. The information in this Schedule is presented in accordance with the requirements of 2 CFR Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Village, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Village. Expenditures reported in the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance for all awards. Under these principles, certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The Village has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The Village did not receive noncash assistance during the fiscal year.
Title: INSURANCE IN FORCE Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal award activity of the Village of Rantoul, Illinois (the Village) under programs of the federal government for the year ended April 30, 2024. The information in this Schedule is presented in accordance with the requirements of 2 CFR Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Village, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Village. Expenditures reported in the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance for all awards. Under these principles, certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The Village has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. There was no insurance in force during the fiscal year provided by a federal agency.
Title: LOANS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal award activity of the Village of Rantoul, Illinois (the Village) under programs of the federal government for the year ended April 30, 2024. The information in this Schedule is presented in accordance with the requirements of 2 CFR Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Village, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Village. Expenditures reported in the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance for all awards. Under these principles, certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The Village has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. EDA RLF Loans: Beginning Balance: $1,607,051 Issued: $305,464 Retired: $232,710 Ending Balance: $1,679,805
Title: EDA REVOLVING LOAN PROGRAM Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal award activity of the Village of Rantoul, Illinois (the Village) under programs of the federal government for the year ended April 30, 2024. The information in this Schedule is presented in accordance with the requirements of 2 CFR Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Village, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Village. Expenditures reported in the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance for all awards. Under these principles, certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The Village has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. EDA Revolving Loan Program (Assistance Listing 11.307) represents cash, securities, and loans outstanding that are 75% funded by the United States Department of Commerce during the year ended April 30, 2024. The total outstanding loan balances for the program are disclosed in Note 1. Total cash on hand was $246,851.

Finding Details

Finding 2024-003
2024 – 003 Suspension and Debarment Federal agency: U.S. Department of Treasury Federal program title: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: N/A Award Period: March 3, 2021 – December 31, 2026 Type of Finding: • Significant Deficiency in Internal Control over Compliance • Other Matters Criteria or specific requirement: Uniform Grant Guidance (2 CFR 200.303) requires non-federal entities receiving Federal awards establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Nonfederal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred. “Covered transactions” include contracts for goods and services awarded under a nonprocurement transaction (e.g., grant or cooperative agreement) that are expected to equal or exceed $25,000 or meet certain other criteria as specified in 2 CFR section 180.220). Condition: The Village did not maintain records the vendor was not suspended or debarred prior to entering into the transactions. Questioned costs: None Context: 5 of 5 tested for suspension and debarment documentation. Cause: The processes for suspension and debarment were not properly followed during the current fiscal year. Proper documentation was not retained. Village policies have not been updated yet. Effect: May result in disallowed cost if grant requirements are not followed. Repeat finding: This is a repeat finding. Prior year finding number was 2023-003. Recommendation: We recommend the Village carefully review federal suspension and debarment requirements for proper documentation needed. The Village should consider use of a Federal procurement checklist. Views of responsible officials: There is no disagreement with the audit finding.
Finding 2024-004
2024 – 004 Reporting Federal agency: U.S. Department of Treasury Federal program title: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: N/A Award Period: March 3, 2021 – December 31, 2026 Type of Finding: • Significant Deficiency in Internal Control over Compliance • Other Matters Criteria or specific requirement: Uniform Grant Guidance (2 CFR 200.303) requires nonfederal entities receiving Federal awards establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include the annual report be reviewed, and this review should be documented. Condition: The Village did not maintain record that the annual report was reviewed and approved by an individual other than the preparer. Questioned costs: None Context: This issues was noted in 1 of 1 reports tested. Cause: The Village does not have a formal control in place to ensure the annual reports are reviewed by an individual other than the preparer. Effect: May result in inaccurate reporting and allowable costs being charged to Federal programs. Repeat finding: The finding is a partial repeat of a finding in the prior year. The prior year finding number was 2023-004. Recommendation: We recommend the Village strengthen internal controls over the review process of the annual grant reporting prior to the report submission. This review should be documented. Views of responsible officials: There is no disagreement with the audit finding.
Finding 2024-003
2024 – 003 Suspension and Debarment Federal agency: U.S. Department of Treasury Federal program title: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: N/A Award Period: March 3, 2021 – December 31, 2026 Type of Finding: • Significant Deficiency in Internal Control over Compliance • Other Matters Criteria or specific requirement: Uniform Grant Guidance (2 CFR 200.303) requires non-federal entities receiving Federal awards establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Nonfederal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred. “Covered transactions” include contracts for goods and services awarded under a nonprocurement transaction (e.g., grant or cooperative agreement) that are expected to equal or exceed $25,000 or meet certain other criteria as specified in 2 CFR section 180.220). Condition: The Village did not maintain records the vendor was not suspended or debarred prior to entering into the transactions. Questioned costs: None Context: 5 of 5 tested for suspension and debarment documentation. Cause: The processes for suspension and debarment were not properly followed during the current fiscal year. Proper documentation was not retained. Village policies have not been updated yet. Effect: May result in disallowed cost if grant requirements are not followed. Repeat finding: This is a repeat finding. Prior year finding number was 2023-003. Recommendation: We recommend the Village carefully review federal suspension and debarment requirements for proper documentation needed. The Village should consider use of a Federal procurement checklist. Views of responsible officials: There is no disagreement with the audit finding.
Finding 2024-004
2024 – 004 Reporting Federal agency: U.S. Department of Treasury Federal program title: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: N/A Award Period: March 3, 2021 – December 31, 2026 Type of Finding: • Significant Deficiency in Internal Control over Compliance • Other Matters Criteria or specific requirement: Uniform Grant Guidance (2 CFR 200.303) requires nonfederal entities receiving Federal awards establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include the annual report be reviewed, and this review should be documented. Condition: The Village did not maintain record that the annual report was reviewed and approved by an individual other than the preparer. Questioned costs: None Context: This issues was noted in 1 of 1 reports tested. Cause: The Village does not have a formal control in place to ensure the annual reports are reviewed by an individual other than the preparer. Effect: May result in inaccurate reporting and allowable costs being charged to Federal programs. Repeat finding: The finding is a partial repeat of a finding in the prior year. The prior year finding number was 2023-004. Recommendation: We recommend the Village strengthen internal controls over the review process of the annual grant reporting prior to the report submission. This review should be documented. Views of responsible officials: There is no disagreement with the audit finding.