Audit 363072

FY End
2024-11-30
Total Expended
$57.73M
Findings
4
Programs
47
Organization: Will County (IL)
Year: 2024 Accepted: 2025-07-25
Auditor: Baker Tilly

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
571980 2024-003 Significant Deficiency - M
571981 2024-004 Significant Deficiency - M
1148422 2024-003 Significant Deficiency - M
1148423 2024-004 Significant Deficiency - M

Programs

ALN Program Spent Major Findings
21.023 Emergency Rental Assistance Program $3.76M Yes 0
14.239 Home Investment Partnerships Program $1.65M - 0
17.259 Wioa Youth Activities $1.10M - 0
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $927,684 - 0
17.258 Wioa Adult Program $844,918 - 0
16.575 Crime Victim Assistance $404,213 - 0
17.277 Wioa National Dislocated Worker Grants / Wia National Emergency Grants $370,233 - 0
20.205 Highway Planning and Construction $315,380 - 0
21.016 Equitable Sharing $302,866 - 0
14.218 Community Development Block Grants/entitlement Grants $273,740 - 0
93.967 Centers for Disease Control and Prevention Collaboration with Academia to Strengthen Public Health $265,404 - 0
97.042 Emergency Management Performance Grants $177,439 - 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $145,040 - 0
93.276 Drug-Free Communities Support Program Grants $138,818 - 0
93.958 Block Grants for Community Mental Health Services $124,390 - 0
93.788 Opioid Str $122,206 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $119,325 - 0
93.044 Special Programs for the Aging, Title Iii, Part B, Grants for Supportive Services and Senior Centers $118,805 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $112,097 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $105,734 Yes 0
16.585 Treatment Court Discretionary Grant Program $102,708 - 0
93.150 Projects for Assistance in Transition From Homelessness (path) $97,103 - 0
93.977 Sexually Transmitted Diseases (std) Prevention and Control Grants $97,076 - 0
16.922 Equitable Sharing Program $93,073 - 0
93.217 Family Planning Services $92,664 - 0
20.600 State and Community Highway Safety $91,200 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $83,947 - 0
93.527 Grants for New and Expanded Services Under the Health Center Program $83,301 - 0
93.994 Maternal and Child Health Services Block Grant to the States $75,491 - 0
93.069 Public Health Emergency Preparedness $74,918 - 0
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $58,624 - 0
59.059 Congressional Grants $54,206 - 0
93.667 Social Services Block Grant $53,547 - 0
10.555 National School Lunch Program $44,398 - 0
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $37,757 - 0
93.224 Health Center Program (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $34,001 - 0
93.268 Immunization Cooperative Agreements $31,566 - 0
16.043 Veterans Treatment Court Discretionary Grant Program $30,708 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $29,327 - 0
93.236 Grants to States to Support Oral Health Workforce Activities $24,329 - 0
10.553 School Breakfast Program $19,712 - 0
14.231 Emergency Solutions Grant Program $15,591 - 0
66.605 Performance Partnership Grants $9,150 - 0
93.493 Congressional Directives $9,062 - 0
66.032 State and Tribal Indoor Radon Grants $6,966 - 0
17.278 Wioa Dislocated Worker Formula Grants $4,400 - 0
17.245 Trade Adjustment Assistance $3,925 - 0

Contacts

Name Title Type
RBJAKXVDNY65 Karen Hennessy Auditee
8157746359 Nick Cavaliere Auditor
No contacts on file

Notes to SEFA

Title: Note 1 Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein 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. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: Y Rate Explanation: Will County has elected to use the 10% de minimis indirect cost rate. 1. Basis of Presentation The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Will County, Illinois under programs of the federal government for the year ended November 30, 2024. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations 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 Will County, Illinois, it is not intended to and does not present the financial position and changes in net position of Will County, Illinois. The reporting entity for the County is based upon criteria established by the Governmental Accounting Standards Board. Will County is the primary government according to GASB criteria, while the Forest Preserve District of Will County is a discretely presented component unit. Federal awards of the component unit are not included in this report.
Title: Note 2 Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein 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. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: Y Rate Explanation: Will County has elected to use the 10% de minimis indirect cost rate. 2. Summary of Significant Accounting Policies Expenditures reported on the Schedule are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein 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. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred.
Title: Note 3 Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein 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. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: Y Rate Explanation: Will County has elected to use the 10% de minimis indirect cost rate. 3. Pass-Through Agencies The following identifies the pass-through agency acronyms used on the schedule of expenditures of federal awards: SBE Illinois State Board of Education DPH Illinois Department of Public Health DHS Illinois Department of Human Services DCEO Illinois Department of Commerce and Economic Opportunity CJIA Illinois Criminal Justice Information Authority DOT Illinois Department of Transportation EMA Illinois Emergency Management Agency NHTSA National Highway Traffic Safety Administration IDHS Illinois Department of Human Services RTA Regional Transportation Authority USDA United States Department of Agriculture CAC Child Advocacy Centers HRSA Health Resources and Services Administration
Title: Note 4 Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein 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. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: Y Rate Explanation: Will County has elected to use the 10% de minimis indirect cost rate. 4. Indirect Cost Rate Will County has elected to use the 10% de minimis indirect cost rate.
Title: Note 5 Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein 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. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: Y Rate Explanation: Will County has elected to use the 10% de minimis indirect cost rate. 5. Loan and Loan Guarantee Programs During the year ended November 30, 2024, Will County received no insurance, loans, or loan guarantees for the purpose of administering federal programs.
Title: Note 6 Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein 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. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: Y Rate Explanation: Will County has elected to use the 10% de minimis indirect cost rate. 6. Noncash Payments During the year ended November 30, 2024, Will County received no noncash payments.

Finding Details

Finding 2024-003 - Subrecipient Monitoring Criteria: In accordance with 2 CFR §200.332(b), a pass-through entity should ensure that every subaward is clearly identified to the subrecipient as a subaward and that includes appropriate federal award identification. Condition: During our audit of the County’s administration of federal funds under the CSLFRF program, we noted the County failed to provide a subrecipient agreement to two subrecipient entities that would have included appropriate information related to federal award identification. Cause: The County failed to review for a proper distribution of a subrecipient agreement to subrecipient entities that would have included appropriate information related to federal award identification. Effect: There is an increased risk that subrecipient noncompliance with federal requirements may go undetected. Recommendation:. We recommend that the County develop a subrecipient monitoring checklist that includes verifying that a subrecipient agreement was provided to the entity receiving an award.
Criteria: In accordance with 2 CFR §200.332(f), a pass-through entity must monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with federal statutes, regulations, and the terms and conditions of the subaward. This includes verifying that subrecipients expending $750,000 or more in federal awards during the subrecipient’s fiscal year have met the audit requirements of 2 CFR Part 200, Subpart F—Audit Requirements. Condition: During our audit of the County’s administration of federal funds under the CSLFRF program, we noted that the County did not have a documented process in place to track and maintain copies of all Single Audit reports for subrecipients to whom it awarded federal funds. Specifically, the County was unable to provide evidence that it had verified with the pass-through entities that have received federal funds below $750,000 whether they were subject to a single audit, the County only followed the verification process for pass-through entities that received federal award in excess of $750,000. Cause: The County did not establish or implement formal procedures to track subrecipient audit status or to obtain and review Single Audit reports. Effect: Without a process to obtain and review Single Audit reports, the County cannot ensure that subrecipients are complying with federal requirements, which increases the risk of undetected noncompliance or misuse of federal funds. Recommendation:. We recommend that the County develop and implement formal procedures to identify subrecipients subject to the Single Audit requirements, obtain and review their audit reports annually, and follow up on any audit findings that may impact the County’s federal programs.
Finding 2024-003 - Subrecipient Monitoring Criteria: In accordance with 2 CFR §200.332(b), a pass-through entity should ensure that every subaward is clearly identified to the subrecipient as a subaward and that includes appropriate federal award identification. Condition: During our audit of the County’s administration of federal funds under the CSLFRF program, we noted the County failed to provide a subrecipient agreement to two subrecipient entities that would have included appropriate information related to federal award identification. Cause: The County failed to review for a proper distribution of a subrecipient agreement to subrecipient entities that would have included appropriate information related to federal award identification. Effect: There is an increased risk that subrecipient noncompliance with federal requirements may go undetected. Recommendation:. We recommend that the County develop a subrecipient monitoring checklist that includes verifying that a subrecipient agreement was provided to the entity receiving an award.
Criteria: In accordance with 2 CFR §200.332(f), a pass-through entity must monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with federal statutes, regulations, and the terms and conditions of the subaward. This includes verifying that subrecipients expending $750,000 or more in federal awards during the subrecipient’s fiscal year have met the audit requirements of 2 CFR Part 200, Subpart F—Audit Requirements. Condition: During our audit of the County’s administration of federal funds under the CSLFRF program, we noted that the County did not have a documented process in place to track and maintain copies of all Single Audit reports for subrecipients to whom it awarded federal funds. Specifically, the County was unable to provide evidence that it had verified with the pass-through entities that have received federal funds below $750,000 whether they were subject to a single audit, the County only followed the verification process for pass-through entities that received federal award in excess of $750,000. Cause: The County did not establish or implement formal procedures to track subrecipient audit status or to obtain and review Single Audit reports. Effect: Without a process to obtain and review Single Audit reports, the County cannot ensure that subrecipients are complying with federal requirements, which increases the risk of undetected noncompliance or misuse of federal funds. Recommendation:. We recommend that the County develop and implement formal procedures to identify subrecipients subject to the Single Audit requirements, obtain and review their audit reports annually, and follow up on any audit findings that may impact the County’s federal programs.