Audit 20257

FY End
2022-11-30
Total Expended
$28.29M
Findings
4
Programs
46
Organization: Madison County (IL)
Year: 2022 Accepted: 2023-08-29
Auditor: Scheffel Boyle

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
21164 2022-002 - - L
21165 2022-001 - Yes L
597606 2022-002 - - L
597607 2022-001 - Yes L

Programs

ALN Program Spent Major Findings
93.568 Low-Income Home Energy Assistance $7.44M - 0
21.023 Emergency Rental Assistance Program $5.86M Yes 1
14.218 Community Development Block Grants/entitlement Grants $3.20M Yes 1
93.569 Community Services Block Grant $1.24M Yes 0
17.258 Wia Adult Program $1.21M - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $1.04M - 0
14.239 Home Investment Partnerships Program $815,440 - 0
17.259 Wia Youth Activities $649,864 - 0
14.231 Emergency Solutions Grant Program $615,404 - 0
17.278 Wia Dislocated Worker Formula Grants $547,985 - 0
21.019 Coronavirus Relief Fund $541,485 - 0
93.268 Immunization Cooperative Agreements $507,700 - 0
14.267 Continuum of Care Program $457,229 - 0
16.575 Crime Victim Assistance $445,491 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $417,312 - 0
93.563 Child Support Enforcement $344,954 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $262,134 - 0
81.042 Weatherization Assistance for Low-Income Persons $247,361 - 0
93.069 Public Health Emergency Preparedness $232,965 - 0
16.585 Drug Court Discretionary Grant Program $120,784 - 0
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $112,432 - 0
21.016 Equitable Sharing $104,535 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $94,882 - 0
17.277 Workforce Investment Act (wia) National Emergency Grants $84,208 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $58,000 Yes 0
16.835 Body Worn Camera Policy and Implementation $53,589 - 0
93.586 State Court Improvement Program $50,400 - 0
93.669 Child Abuse and Neglect State Grants $45,620 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $43,736 - 0
16.922 Equitable Sharing Program $36,827 - 0
97.042 Emergency Management Performance Grants $34,026 - 0
15.226 Payments in Lieu of Taxes $31,047 - 0
10.555 National School Lunch Program $29,485 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $22,669 - 0
10.559 Summer Food Service Program for Children $21,150 - 0
10.553 School Breakfast Program $17,341 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $16,836 - 0
20.600 State and Community Highway Safety $16,266 - 0
17.245 Trade Adjustment Assistance $15,708 - 0
93.940 Hiv Prevention Activities_health Department Based $15,405 - 0
97.067 Homeland Security Grant Program $15,371 - 0
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $11,072 - 0
66.032 State Indoor Radon Grants $7,371 - 0
93.103 Food and Drug Administration_research $5,517 - 0
17.285 Apprenticeship USA Grants $1,902 - 0
66.605 Performance Partnership Grants $1,159 - 0

Contacts

Name Title Type
X8NUNEUB6RU8 David Michael Auditee
6182964014 Scott Weber Auditor
No contacts on file

Notes to SEFA

Title: SUBRECIPIENTS Accounting Policies: EXPENDITURES REPORTED ON THE SCHEDULE ARE REPORTED ON THE MODIFIED ACCRUAL BASIS OF ACCOUNTING, WHICH IS DESCRIBED IN NOTE 1 OF THE COUNTY'S FINANCIAL STATEMENTS. SUCH EXPENDITURES ARE RECOGNIZED FOLLOWING THE COST PRINCIPLES CONTAINED IN THE UNIFORM GUIDANCE FOR ALL AWARDS WITH THE EXCEPTION OF AL #21.019 WHICH FOLLOWS CRITERIA DETERMINED BY THE DEPARTMENT OF TREASURY FOR ALLOWBILITY OF COST. UNDER THESE PRINCIPLES, CERTAIN TYPES OF EXPENDITURES ARE NOT ALLOWABLE OR ARE LIMITED AS TO REIMBURSEMENT. FEDERAL FINANCIAL REPORTS ARE FILED ON THE CASH BASIS OF ACCOUNTING. De Minimis Rate Used: Both Rate Explanation: THE COUNTY UTILIZES A NEGOTIATED RATE WHEN CHARGING INDIRECT COSTS TO FEDERAL AWARDS RATHER THAN THE 10% DE MINIMUS INDIRECT COST RATE ALLOWED UNDER THE UNIFORM GUIDANCE. THE COUNTY HEALTH DEPARTMENT, UNDER THEIR UNIQUE ENTITY IDENTIFIER (UEI) X4MDCBEKL655, UTILIZES THE 10% DE MINIMIS INDIRECT COST RATE. OF THE FOLLOWING EXPENDITURES PRESENTED IN THE SCHEDULE, MADISON COUNTY, ILLINOIS PROVIDED FEDERAL AWARDS TO SUBRECIPIENTS AS FOLLOWS: AL #16.585 TREATMENT COURT DISCRETIONARY GRANT PROGRAM $23,324, AL#17.278 WIOA-DISLOCATED WORKER FORMULA GRANTS $24,000, AL#93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $175,794. TOTAL SUBRECIPIENTS FOR THE FISCAL YEAR TOTAL $223,118
Title: BASIS OF PRESENTATION Accounting Policies: EXPENDITURES REPORTED ON THE SCHEDULE ARE REPORTED ON THE MODIFIED ACCRUAL BASIS OF ACCOUNTING, WHICH IS DESCRIBED IN NOTE 1 OF THE COUNTY'S FINANCIAL STATEMENTS. SUCH EXPENDITURES ARE RECOGNIZED FOLLOWING THE COST PRINCIPLES CONTAINED IN THE UNIFORM GUIDANCE FOR ALL AWARDS WITH THE EXCEPTION OF AL #21.019 WHICH FOLLOWS CRITERIA DETERMINED BY THE DEPARTMENT OF TREASURY FOR ALLOWBILITY OF COST. UNDER THESE PRINCIPLES, CERTAIN TYPES OF EXPENDITURES ARE NOT ALLOWABLE OR ARE LIMITED AS TO REIMBURSEMENT. FEDERAL FINANCIAL REPORTS ARE FILED ON THE CASH BASIS OF ACCOUNTING. De Minimis Rate Used: Both Rate Explanation: THE COUNTY UTILIZES A NEGOTIATED RATE WHEN CHARGING INDIRECT COSTS TO FEDERAL AWARDS RATHER THAN THE 10% DE MINIMUS INDIRECT COST RATE ALLOWED UNDER THE UNIFORM GUIDANCE. THE COUNTY HEALTH DEPARTMENT, UNDER THEIR UNIQUE ENTITY IDENTIFIER (UEI) X4MDCBEKL655, UTILIZES THE 10% DE MINIMIS INDIRECT COST RATE. THE ACCOMPANYING SCHEDULE INCLUDES THE FEDERAL GRANT ACTIVITY OF THE COUNTY UNDER PROGRAMS OF THE FEDERAL GOVERNEMNT 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, CHANGE IN NET ASSETS, OR CASH FLOWS OF THE COUNTY.
Title: GENERAL Accounting Policies: EXPENDITURES REPORTED ON THE SCHEDULE ARE REPORTED ON THE MODIFIED ACCRUAL BASIS OF ACCOUNTING, WHICH IS DESCRIBED IN NOTE 1 OF THE COUNTY'S FINANCIAL STATEMENTS. SUCH EXPENDITURES ARE RECOGNIZED FOLLOWING THE COST PRINCIPLES CONTAINED IN THE UNIFORM GUIDANCE FOR ALL AWARDS WITH THE EXCEPTION OF AL #21.019 WHICH FOLLOWS CRITERIA DETERMINED BY THE DEPARTMENT OF TREASURY FOR ALLOWBILITY OF COST. UNDER THESE PRINCIPLES, CERTAIN TYPES OF EXPENDITURES ARE NOT ALLOWABLE OR ARE LIMITED AS TO REIMBURSEMENT. FEDERAL FINANCIAL REPORTS ARE FILED ON THE CASH BASIS OF ACCOUNTING. De Minimis Rate Used: Both Rate Explanation: THE COUNTY UTILIZES A NEGOTIATED RATE WHEN CHARGING INDIRECT COSTS TO FEDERAL AWARDS RATHER THAN THE 10% DE MINIMUS INDIRECT COST RATE ALLOWED UNDER THE UNIFORM GUIDANCE. THE COUNTY HEALTH DEPARTMENT, UNDER THEIR UNIQUE ENTITY IDENTIFIER (UEI) X4MDCBEKL655, UTILIZES THE 10% DE MINIMIS INDIRECT COST RATE. THE ACCOMPANYING SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (THE SCHEDULE) PRESENTS THE ACTIVITY OF ALL FEDERAL AWARD PROGRAMS OF MADISON COUNTY, ILLINOIS (THE COUNTY). THE COUNTY'S REPORTING ENTITY IS DEFINED IN NOTE 1 TO THE COUNTY'S FINANCIAL STATEMENTS. FEDERAL AWARDS RECEIVED DIRECTLY FROM THE FEDERAL AGENCIES AS WELL AS PASSED THROUGH OTHER GOVERNMENT AGENCIES ARE INCLUDED IN THIS SCHEDULE.
Title: RELATIONSHIP TO THE FINANCIAL STATEMENTS Accounting Policies: EXPENDITURES REPORTED ON THE SCHEDULE ARE REPORTED ON THE MODIFIED ACCRUAL BASIS OF ACCOUNTING, WHICH IS DESCRIBED IN NOTE 1 OF THE COUNTY'S FINANCIAL STATEMENTS. SUCH EXPENDITURES ARE RECOGNIZED FOLLOWING THE COST PRINCIPLES CONTAINED IN THE UNIFORM GUIDANCE FOR ALL AWARDS WITH THE EXCEPTION OF AL #21.019 WHICH FOLLOWS CRITERIA DETERMINED BY THE DEPARTMENT OF TREASURY FOR ALLOWBILITY OF COST. UNDER THESE PRINCIPLES, CERTAIN TYPES OF EXPENDITURES ARE NOT ALLOWABLE OR ARE LIMITED AS TO REIMBURSEMENT. FEDERAL FINANCIAL REPORTS ARE FILED ON THE CASH BASIS OF ACCOUNTING. De Minimis Rate Used: Both Rate Explanation: THE COUNTY UTILIZES A NEGOTIATED RATE WHEN CHARGING INDIRECT COSTS TO FEDERAL AWARDS RATHER THAN THE 10% DE MINIMUS INDIRECT COST RATE ALLOWED UNDER THE UNIFORM GUIDANCE. THE COUNTY HEALTH DEPARTMENT, UNDER THEIR UNIQUE ENTITY IDENTIFIER (UEI) X4MDCBEKL655, UTILIZES THE 10% DE MINIMIS INDIRECT COST RATE. FEDERAL FINANCIAL ASSISTANCE IS REPORTED IN THE COUNTY'S FINANCIAL STATEMENTS WITHIN PROGRAM REVENUE GRANTS OF THE GOVERNMENT WIDE FINANCIAL STATEMENTS AND WITHIN INTERGOVERNMENTAL REVENUES OF THE GENERAL AND SPECIAL REVENUE FUND TYPES IN THE FUND FINANCIAL STATEMENTS.
Title: AMOUNTS OF FEDERAL INSURANCE IN EFFECT DURING THE YEAR Accounting Policies: EXPENDITURES REPORTED ON THE SCHEDULE ARE REPORTED ON THE MODIFIED ACCRUAL BASIS OF ACCOUNTING, WHICH IS DESCRIBED IN NOTE 1 OF THE COUNTY'S FINANCIAL STATEMENTS. SUCH EXPENDITURES ARE RECOGNIZED FOLLOWING THE COST PRINCIPLES CONTAINED IN THE UNIFORM GUIDANCE FOR ALL AWARDS WITH THE EXCEPTION OF AL #21.019 WHICH FOLLOWS CRITERIA DETERMINED BY THE DEPARTMENT OF TREASURY FOR ALLOWBILITY OF COST. UNDER THESE PRINCIPLES, CERTAIN TYPES OF EXPENDITURES ARE NOT ALLOWABLE OR ARE LIMITED AS TO REIMBURSEMENT. FEDERAL FINANCIAL REPORTS ARE FILED ON THE CASH BASIS OF ACCOUNTING. De Minimis Rate Used: Both Rate Explanation: THE COUNTY UTILIZES A NEGOTIATED RATE WHEN CHARGING INDIRECT COSTS TO FEDERAL AWARDS RATHER THAN THE 10% DE MINIMUS INDIRECT COST RATE ALLOWED UNDER THE UNIFORM GUIDANCE. THE COUNTY HEALTH DEPARTMENT, UNDER THEIR UNIQUE ENTITY IDENTIFIER (UEI) X4MDCBEKL655, UTILIZES THE 10% DE MINIMIS INDIRECT COST RATE. NONE
Title: NON-CASH AWARDS Accounting Policies: EXPENDITURES REPORTED ON THE SCHEDULE ARE REPORTED ON THE MODIFIED ACCRUAL BASIS OF ACCOUNTING, WHICH IS DESCRIBED IN NOTE 1 OF THE COUNTY'S FINANCIAL STATEMENTS. SUCH EXPENDITURES ARE RECOGNIZED FOLLOWING THE COST PRINCIPLES CONTAINED IN THE UNIFORM GUIDANCE FOR ALL AWARDS WITH THE EXCEPTION OF AL #21.019 WHICH FOLLOWS CRITERIA DETERMINED BY THE DEPARTMENT OF TREASURY FOR ALLOWBILITY OF COST. UNDER THESE PRINCIPLES, CERTAIN TYPES OF EXPENDITURES ARE NOT ALLOWABLE OR ARE LIMITED AS TO REIMBURSEMENT. FEDERAL FINANCIAL REPORTS ARE FILED ON THE CASH BASIS OF ACCOUNTING. De Minimis Rate Used: Both Rate Explanation: THE COUNTY UTILIZES A NEGOTIATED RATE WHEN CHARGING INDIRECT COSTS TO FEDERAL AWARDS RATHER THAN THE 10% DE MINIMUS INDIRECT COST RATE ALLOWED UNDER THE UNIFORM GUIDANCE. THE COUNTY HEALTH DEPARTMENT, UNDER THEIR UNIQUE ENTITY IDENTIFIER (UEI) X4MDCBEKL655, UTILIZES THE 10% DE MINIMIS INDIRECT COST RATE. NONMONETARY ASSISTANCE IS REPORTED IN THE SCHEDULE AT FAIR MARKET VALUE OF THE SUPPLIES RECEIVED AND DISBURSED. THE COUNTY RECEIVED AND DISPENSED $132,216 WORTH OF IMMUNIZATIONS THROUGH THE ILLINOIS DEPARTMENT OF PUBLIC HEALTH. THE COUNTY ALSO RECEIVED $15,371 OF EQUIPMENT FROM THE EAST-WEST GATEWAY COUNCIL OF GOVERNMENTS.
Title: SECTION 108 LOAN GUARANTEES Accounting Policies: EXPENDITURES REPORTED ON THE SCHEDULE ARE REPORTED ON THE MODIFIED ACCRUAL BASIS OF ACCOUNTING, WHICH IS DESCRIBED IN NOTE 1 OF THE COUNTY'S FINANCIAL STATEMENTS. SUCH EXPENDITURES ARE RECOGNIZED FOLLOWING THE COST PRINCIPLES CONTAINED IN THE UNIFORM GUIDANCE FOR ALL AWARDS WITH THE EXCEPTION OF AL #21.019 WHICH FOLLOWS CRITERIA DETERMINED BY THE DEPARTMENT OF TREASURY FOR ALLOWBILITY OF COST. UNDER THESE PRINCIPLES, CERTAIN TYPES OF EXPENDITURES ARE NOT ALLOWABLE OR ARE LIMITED AS TO REIMBURSEMENT. FEDERAL FINANCIAL REPORTS ARE FILED ON THE CASH BASIS OF ACCOUNTING. De Minimis Rate Used: Both Rate Explanation: THE COUNTY UTILIZES A NEGOTIATED RATE WHEN CHARGING INDIRECT COSTS TO FEDERAL AWARDS RATHER THAN THE 10% DE MINIMUS INDIRECT COST RATE ALLOWED UNDER THE UNIFORM GUIDANCE. THE COUNTY HEALTH DEPARTMENT, UNDER THEIR UNIQUE ENTITY IDENTIFIER (UEI) X4MDCBEKL655, UTILIZES THE 10% DE MINIMIS INDIRECT COST RATE. THE COUNTY BOARD AUTHORIZED THE SUBMISSION OF A COMMUNITY DEVELOPMENT BLOCK GRANT SECTION 108 LOAN GUARANTEE APPLICATION IN THE AMOUNT OF $3,500,000 IN JUNE OF 2009. THE COUNTY BOARD ALSO AUTHORIZED UP TO $3,500,000 OF THE PROCEEDS OF THE SECTION 108 LOAN GUARANTEE TO BE LENT TO WELLSPRING RESOURCES, FORMERLY COMMUNITY COUNSELING CENTER OF NORTHERN MADISON COUNTY, FOR THE CONSTRUCTION OF THEIR NEW MENTAL HEALTH FACILITY. THE RESULT WAS A NOTE IN THE AMOUNT OF $2,247,000 DATED FEBRUARY 2, 2010, WITH MADISON COUNTY BEING THE LENDER AND WELLSPRING RESOURCES BEING THE BORRROWER. PRINCIPAL ON THIS LOAN IS PAID ANNUALLY AND INTEREST IS PAID SEMI-ANNUALLY AT VARIABLE RATES RANGING FROM 2.4% TO 3.2% THROUGH 2028. AS OF 11/30/2022 THE OUSTANDING BALANCE ON THIS LOAN WAS $1,009,766. THE LOAN IS NOT CONSIDERED TO HAVE CONTINUING COMPLIANCE REQUIREMENTS, AND THEREFORE, IS ONLY REPORTED IN THE SEFA IN THE YEAR IN WHICH FUNDS WERE EXPENDED AND DRAWN.

Finding Details

Finding 2022-002 Federal Program Name: Community Development Block Grant AL Number: 14.218 Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Grantor: N/A Criteria: Quarterly reports are required to be submitted within ninety calendar days following the end of the quarter. Statement of Condition: The County did not submit timely reports for the reporting period July-September 2022. Questioned Costs: None Effect of Condition: Failure to submit reports within the required time period puts the grantee in noncompliance with laws, regulations and provisions of contracts or grant agreements. Cause of Condition: Management oversight. Recommendation: The County should schedule the due dates of all project reports in order to avoid late filings. Response: MCCD recognizes the importance of timely filing of quarterly reports for this program and will continue to work to prevent this from occurring in the future. A department wide calendar of report deadlines will be prepared and made available to all departmental employees. Reminders will be set for future submission dates with notifications going to more than one employee. Extensions will be requested as needed and will be well documented and saved on a network drive accessible to all employees. MCCD?s policies and procedures will be updated to include the planned submission dates for future reporting. Please note, the employee charged with completing and submitting these reports is no longer with the County. MCCD will stress the importance of timely filing of these reports to the employee filling this position.
Finding 2022-001 Federal Program Name: COVID-19 Emergency Rental Assistance Program AL Number: 21.023 Federal Agency: U.S. Department of the Treasury Pass-Through Grantor: N/A Criteria: Quarterly reports (ERA 1 and ERA 2) are required to be submitted by the 15th of the month following the end of the quarterly reporting period. Statement of Condition: The County did not submit timely reports for the following quarterly reporting periods: October-December 2021 and January-March 2022. Questioned Costs: None Effect of Condition: Failure to submit reports within the required time period puts the grantee in noncompliance with laws, regulations and provisions of contracts or grant agreements. Cause of Condition: Management oversight. Recommendation: The County should schedule the due dates of all project reports in order to avoid late filings. Response: MCCD recognizes the importance of timely filing of quarterly reports for this program and will continue to work to prevent this from occurring in the future. A department wide calendar of report deadlines will be prepared and made available to all departmental employees. Reminders will be set for future submission dates with notifications going to more than one employee. Extensions will be requested as needed and will be well documented and saved on a network drive accessible to all employees. MCCD?s policies and procedures will be updated to include the planned submission dates for future reporting. Please note, the employee charged with completing and submitting these reports is no longer with the County. MCCD will stress the importance of timely filing of these reports to the employee filling this position.
Finding 2022-002 Federal Program Name: Community Development Block Grant AL Number: 14.218 Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Grantor: N/A Criteria: Quarterly reports are required to be submitted within ninety calendar days following the end of the quarter. Statement of Condition: The County did not submit timely reports for the reporting period July-September 2022. Questioned Costs: None Effect of Condition: Failure to submit reports within the required time period puts the grantee in noncompliance with laws, regulations and provisions of contracts or grant agreements. Cause of Condition: Management oversight. Recommendation: The County should schedule the due dates of all project reports in order to avoid late filings. Response: MCCD recognizes the importance of timely filing of quarterly reports for this program and will continue to work to prevent this from occurring in the future. A department wide calendar of report deadlines will be prepared and made available to all departmental employees. Reminders will be set for future submission dates with notifications going to more than one employee. Extensions will be requested as needed and will be well documented and saved on a network drive accessible to all employees. MCCD?s policies and procedures will be updated to include the planned submission dates for future reporting. Please note, the employee charged with completing and submitting these reports is no longer with the County. MCCD will stress the importance of timely filing of these reports to the employee filling this position.
Finding 2022-001 Federal Program Name: COVID-19 Emergency Rental Assistance Program AL Number: 21.023 Federal Agency: U.S. Department of the Treasury Pass-Through Grantor: N/A Criteria: Quarterly reports (ERA 1 and ERA 2) are required to be submitted by the 15th of the month following the end of the quarterly reporting period. Statement of Condition: The County did not submit timely reports for the following quarterly reporting periods: October-December 2021 and January-March 2022. Questioned Costs: None Effect of Condition: Failure to submit reports within the required time period puts the grantee in noncompliance with laws, regulations and provisions of contracts or grant agreements. Cause of Condition: Management oversight. Recommendation: The County should schedule the due dates of all project reports in order to avoid late filings. Response: MCCD recognizes the importance of timely filing of quarterly reports for this program and will continue to work to prevent this from occurring in the future. A department wide calendar of report deadlines will be prepared and made available to all departmental employees. Reminders will be set for future submission dates with notifications going to more than one employee. Extensions will be requested as needed and will be well documented and saved on a network drive accessible to all employees. MCCD?s policies and procedures will be updated to include the planned submission dates for future reporting. Please note, the employee charged with completing and submitting these reports is no longer with the County. MCCD will stress the importance of timely filing of these reports to the employee filling this position.