Audit 307847

FY End
2023-11-30
Total Expended
$11.32M
Findings
2
Programs
27
Organization: Rock Island County, Illinois (IL)
Year: 2023 Accepted: 2024-05-31

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
399365 2023-003 Significant Deficiency - L
975807 2023-003 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $6.53M Yes 1
17.259 Wia Youth Activities $544,877 - 0
17.258 Wia Adult Program $445,916 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $302,547 - 0
17.278 Wia Dislocated Worker Formula Grants $204,064 - 0
20.205 Highway Planning and Construction $193,446 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $106,419 - 0
17.277 Workforce Investment Act (wia) National Emergency Grants $83,035 - 0
93.667 Social Services Block Grant $79,236 - 0
93.994 Maternal and Child Health Services Block Grant to the States $75,000 - 0
93.658 Foster Care_title IV-E $73,165 - 0
93.268 Immunization Cooperative Agreements $57,449 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $57,148 - 0
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $56,525 - 0
97.042 Emergency Management Performance Grants $52,877 - 0
93.008 Medical Reserve Corps Small Grant Program $48,750 - 0
93.069 Public Health Emergency Preparedness $45,609 - 0
97.056 Port Security Grant Program $31,961 - 0
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $31,621 - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $24,269 - 0
20.509 Formula Grants for Rural Areas and Tribal Transit Program $15,821 - 0
14.900 Lead-Based Paint Hazard Control in Privately-Owned Housing $15,311 - 0
16.606 State Criminal Alien Assistance Program $7,219 - 0
93.563 Child Support Enforcement $4,207 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $3,769 - 0
66.605 Performance Partnership Grants $2,016 - 0
10.572 Wic Farmers' Market Nutrition Program (fmnp) $1,000 - 0

Contacts

Name Title Type
GK6FBT2G4NK8 April Palmer Auditee
3095583518 Michael Malatt 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 County has not elected to use the 10% de minimis indirect cost rate. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Rock Island County (County) under programs of the federal government for the year ended November 30, 2023. 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. The reporting entity for Rock Island County is based upon criteria established by the Governmental Accounting Standards Board. Rock Island County is the primary government according to GASB criteria, while the Rock Island Tri-County Consortium (Consortium) is a component unit. Federal awards received directly by the Consortium are not included in this report since the Consortium has been audited by other auditors for their grants and those amounts are reported in a separate report.

Finding Details

Assistance Listing Number: 21.027 Program Title: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Federal Agency: United States Department of Treasury Pass-through Entity: N/A Federal Award Identification Number / Year: N/A / 2023 Criteria: Per CFR section 200.303, "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO)." Condition: Quarterly reports submitted to the United States Department of Treasury are not reviewed by someone other than the original preparer. Cause: The County has not established a formal process of review around reporting for grants received from the United States Department of Treasury. Effect: Eligible expenditure and other information included in the report submissions may include unidentified errors. Questioned Costs: None noted. Context: This represents a systemic matter as a formalized review process for reporting to the United States Department of Treasury does not exist. The sample of reports tested does not represent a statistically valid sample. Recommendation: We recommend the County implement formal, documented review controls around reports submitted to the United States Department of Treasury by someone other than the original preparer prior to submission. Management Response: Management has reviewed the finding and agrees.
Assistance Listing Number: 21.027 Program Title: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Federal Agency: United States Department of Treasury Pass-through Entity: N/A Federal Award Identification Number / Year: N/A / 2023 Criteria: Per CFR section 200.303, "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO)." Condition: Quarterly reports submitted to the United States Department of Treasury are not reviewed by someone other than the original preparer. Cause: The County has not established a formal process of review around reporting for grants received from the United States Department of Treasury. Effect: Eligible expenditure and other information included in the report submissions may include unidentified errors. Questioned Costs: None noted. Context: This represents a systemic matter as a formalized review process for reporting to the United States Department of Treasury does not exist. The sample of reports tested does not represent a statistically valid sample. Recommendation: We recommend the County implement formal, documented review controls around reports submitted to the United States Department of Treasury by someone other than the original preparer prior to submission. Management Response: Management has reviewed the finding and agrees.