Audit 29432

FY End
2022-11-30
Total Expended
$77.46M
Findings
2
Programs
60
Organization: Lake County, Illinois (IL)
Year: 2022 Accepted: 2023-08-20

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
28712 2022-001 Significant Deficiency - M
605154 2022-001 Significant Deficiency - M

Programs

ALN Program Spent Major Findings
21.023 Emergency Rental Assistance Program $14.86M Yes 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $10.04M Yes 0
14.218 Community Development Block Grants/entitlement Grants $5.13M - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $2.92M - 0
93.224 Consolidated Health Centers (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $2.66M Yes 0
93.268 Immunization Cooperative Agreements $2.24M Yes 0
17.278 Wia Dislocated Worker Formula Grants $2.23M Yes 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $2.20M - 0
17.259 Wia Youth Activities $2.06M Yes 0
14.239 Home Investment Partnerships Program $1.99M - 0
17.258 Wia Adult Program $1.57M Yes 0
93.958 Block Grants for Community Mental Health Services $803,417 - 0
16.575 Crime Victim Assistance $747,371 - 0
93.563 Child Support Enforcement $747,219 - 0
14.231 Emergency Solutions Grant Program $719,940 - 0
17.277 Workforce Investment Act (wia) National Emergency Grants $668,469 - 0
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $631,337 - 0
14.267 Continuum of Care Program $630,675 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $544,854 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $461,375 - 0
93.667 Social Services Block Grant $436,267 - 0
93.069 Public Health Emergency Preparedness $423,875 - 0
97.047 Pre-Disaster Mitigation $368,801 - 0
93.778 Medical Assistance Program $335,855 - 0
20.205 Highway Planning and Construction $333,442 - 0
93.917 Hiv Care Formula Grants $303,196 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $281,571 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $236,451 - 0
93.788 Opioid Str $235,577 - 0
93.914 Hiv Emergency Relief Project Grants $220,226 - 0
95.001 High Intensity Drug Trafficking Areas Program $211,533 - 0
97.042 Emergency Management Performance Grants $194,909 - 0
16.320 Services for Trafficking Victims $176,367 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $167,965 - 0
93.217 Family Planning_services $161,460 - 0
16.606 State Criminal Alien Assistance Program $142,429 - 0
93.092 Affordable Care Act (aca) Personal Responsibility Education Program $130,284 - 0
16.825 Smart Prosecution Initiative $108,755 - 0
90.404 2018 Hava Election Security Grants $104,906 - 0
20.600 State and Community Highway Safety $94,747 - 0
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $94,502 - 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $92,185 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $84,197 - 0
16.746 Capital Case Litigation Initiative $68,389 - 0
10.555 National School Lunch Program $64,803 - 0
93.597 Grants to States for Access and Visitation Programs $62,285 - 0
97.039 Hazard Mitigation Grant $52,549 - 0
16.540 Juvenile Justice and Delinquency Prevention_allocation to States $48,177 - 0
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health $40,829 - 0
15.608 Fish and Wildlife Management Assistance $39,373 - 0
66.605 Performance Partnership Grants $31,658 - 0
93.526 Affordable Care Act (aca) Grants for Capital Development in Health Centers $31,460 - 0
10.553 School Breakfast Program $24,703 - 0
20.616 National Priority Safety Programs $21,697 - 0
97.024 Emergency Food and Shelter National Board Program $20,972 - 0
93.940 Hiv Prevention Activities_health Department Based $20,898 - 0
17.245 Trade Adjustment Assistance $19,565 - 0
16.607 Bulletproof Vest Partnership Program $19,001 - 0
93.242 Mental Health Research Grants $7,500 - 0
10.572 Wic Farmers' Market Nutrition Program (fmnp) $872 - 0

Contacts

Name Title Type
W2VMR6ZKNT21 Patrice Sutton Auditee
8473772233 Amanda Blomberg Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation 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: N Rate Explanation: The auditee did not use the de minimis cost rate. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Lake 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 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 the County, it is not intended to and does not present the financial position, changes in net position or cash flows of the County.
Title: Pass-Through Agencies 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: N Rate Explanation: The auditee did not use the de minimis cost rate. The following identifies the pass-through agency acronyms used on the schedule of expenditures offederal awards:ISBE Illinois State Board of EducationIDHS Illinois Department of Human ServicesIDNRIllinois Department of Natural ResourcesCJIA Illinois Criminal Justice Information AuthorityWauk City of WaukeganDCEO Illinois Department of Commerce and Economic OpportunityDOT Illinois Department of TransportationCMAP Chicago Metropolitan Agency for PlanningRTA Regional Transportation AuthorityIEMA Illinois Emergency Management AgencyIHFS Illinois Department of Healthcare and Family ServicesCDPH Chicago Department of Public HealthAFC Aids Foundation of ChicagoIDPH Illinois Department of Public HealthSBOEIllinois State Board of ElectionsNWU Northwestern UniversityHelunaHeluna HealthNACCHONational Association of County and City Health OfficialsIPHCA Illinois Primary Health Care AssociationIPHAIllinois Public Health AssociationONDCPOffice of National Drug Control Policy

Finding Details

Finding 2022-001 Assistance Listing Number: 21.027 COVID-19 ? Coronavirus State and Local Fiscal Recovery Funds Federal Agency: U.S. Department of Treasury Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Award Numbers/Years: ARPA 21-413010 / 2021-2022 Criteria: According to 2 CFR 200.332, all pass-through entities must ensure that every subaward is clearly identified to the subrecipient as a subaward and include specific award identification data as detailed in the Uniform Guidance. Condition/Context: Out of the three executed subrecipient agreements selected for testing, none of them included the subaward information required by the Uniform Guidance. Our sample was not statistically valid. Effect: Subrecipients may not receive the appropriate subaward information. Questioned Costs: None noted. Cause: The County did not have a process to ensure that the subaward information was included in the subrecipient contracts for this award. Recommendation: We recommend the County develop a template with the required subaward information and share it with the subrecipients of this award program. In addition, this process should be incorporated into the regular subrecipient contracting procedures. Views of Responsible Officials: Lake County acknowledges that subaward information required by the Uniform Guidance was not provided to subrecipients in a separate notice. The County had previously incorporated the information in various clauses of the contracts/agreements with each subrecipient. The County has since developed a single notification form with the required subaward information which it includes with the initial contract and upon any modifications or change orders.
Finding 2022-001 Assistance Listing Number: 21.027 COVID-19 ? Coronavirus State and Local Fiscal Recovery Funds Federal Agency: U.S. Department of Treasury Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Award Numbers/Years: ARPA 21-413010 / 2021-2022 Criteria: According to 2 CFR 200.332, all pass-through entities must ensure that every subaward is clearly identified to the subrecipient as a subaward and include specific award identification data as detailed in the Uniform Guidance. Condition/Context: Out of the three executed subrecipient agreements selected for testing, none of them included the subaward information required by the Uniform Guidance. Our sample was not statistically valid. Effect: Subrecipients may not receive the appropriate subaward information. Questioned Costs: None noted. Cause: The County did not have a process to ensure that the subaward information was included in the subrecipient contracts for this award. Recommendation: We recommend the County develop a template with the required subaward information and share it with the subrecipients of this award program. In addition, this process should be incorporated into the regular subrecipient contracting procedures. Views of Responsible Officials: Lake County acknowledges that subaward information required by the Uniform Guidance was not provided to subrecipients in a separate notice. The County had previously incorporated the information in various clauses of the contracts/agreements with each subrecipient. The County has since developed a single notification form with the required subaward information which it includes with the initial contract and upon any modifications or change orders.