Audit 33604

FY End
2022-11-30
Total Expended
$4.77M
Findings
4
Programs
11
Organization: Vermilion County (IL)
Year: 2022 Accepted: 2023-09-05

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
36129 2022-002 Significant Deficiency Yes I
36130 2022-003 Significant Deficiency - P
612571 2022-002 Significant Deficiency Yes I
612572 2022-003 Significant Deficiency - P

Contacts

Name Title Type
VX21JWKQRG41 Larry Baughn Auditee
2175546400 Sandy Cook Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Vermilion County, Illinois (the County) under programs of the federal government for the year ended November 30, 2022. 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 County, it is not intended to and does not present the financial position, changes in net position, or cash flows of the County. Expenditures reported on 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. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The County did not receive any federally provided insurance or federal loan or loan guarantees. De Minimis Rate Used: Y Rate Explanation: The County has elected to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance.

Finding Details

Criteria or specific requirement: 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 County did not complete the suspension and debarment procedures prior to entering into the transactions. Questioned costs: None Context: The County?s suspension and debarment policy has not been completely followed per the Uniform Grant Guidance. This was noted in the 5 out of 5 items tested. Cause: The processes for suspension and debarment where updated and approved near the end of the current fiscal year as a result of the prior year finding. However, the updated procedures were not implemented for the full year which resulted in the majority of the current year?s transactions following the old procedures. Effect: A lack of internal control procedures can lead to noncompliance with grant requirements. Repeat finding: The finding is a repeat of the finding in the immediately prior year. Prior year finding number was 2021-002. Recommendation: We recommend following the requirements for suspension and debarment per the Uniform Guidance, including the date performed and retain required documentation.
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 ensuring that supporting calculations are accurate. Condition: The County made errors in its support summarizing/reconciling its allowable costs, when reporting the funds it spent under COVID-19 State and Local Fiscal Recovery Funds, overclaiming $7,125 cumulatively during the fiscal year. In addition, there is no formal documentation of the review being completed. Questioned costs: $7,125 Context: The County made errors on the amounts reported in 4 out of 4 reports tested, cumulatively overclaiming $7,125 during the fiscal year. Cause: Costs were paid accurately to employees and vendors, but, incorrectly allocated and charged to the grant due to adjustments/allocations made in subsequent periods. Effect: May result in unallowable costs being charged to Federal programs. Repeat finding: No. Recommendation: We recommend the County review its procedures relative to allocating costs and reviewing support provided for reporting to Federal programs.
Criteria or specific requirement: 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 County did not complete the suspension and debarment procedures prior to entering into the transactions. Questioned costs: None Context: The County?s suspension and debarment policy has not been completely followed per the Uniform Grant Guidance. This was noted in the 5 out of 5 items tested. Cause: The processes for suspension and debarment where updated and approved near the end of the current fiscal year as a result of the prior year finding. However, the updated procedures were not implemented for the full year which resulted in the majority of the current year?s transactions following the old procedures. Effect: A lack of internal control procedures can lead to noncompliance with grant requirements. Repeat finding: The finding is a repeat of the finding in the immediately prior year. Prior year finding number was 2021-002. Recommendation: We recommend following the requirements for suspension and debarment per the Uniform Guidance, including the date performed and retain required documentation.
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 ensuring that supporting calculations are accurate. Condition: The County made errors in its support summarizing/reconciling its allowable costs, when reporting the funds it spent under COVID-19 State and Local Fiscal Recovery Funds, overclaiming $7,125 cumulatively during the fiscal year. In addition, there is no formal documentation of the review being completed. Questioned costs: $7,125 Context: The County made errors on the amounts reported in 4 out of 4 reports tested, cumulatively overclaiming $7,125 during the fiscal year. Cause: Costs were paid accurately to employees and vendors, but, incorrectly allocated and charged to the grant due to adjustments/allocations made in subsequent periods. Effect: May result in unallowable costs being charged to Federal programs. Repeat finding: No. Recommendation: We recommend the County review its procedures relative to allocating costs and reviewing support provided for reporting to Federal programs.