Finding 1241157 (2025-002)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2025
Accepted
2026-10-23
Audit: 415229
Organization: Madison County (OH)
Auditor: JULIAN AND GRUBE

AI Summary

  • Core Issue: The County did not include $2,897,918 in federal expenditures in the Schedule of Expenditures of Federal Awards (SEFA), leading to a material misstatement.
  • Impacted Requirements: Compliance with 2 CFR §200.510(b) regarding accurate reporting of federal awards, including details on individual programs and subrecipients.
  • Recommended Follow-Up: The County should collaborate with departments to ensure all grant activities are reported accurately and seek assistance from Ohio agencies to clarify federal activities.

Finding Text

Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 15% de minimis cost rate as covered in §200.414. During the audit, it was noted $2,897,918 in expenditures was not included in the unaudited SEFA. An adjustment was necessary to properly present the SEFA. Management posted the adjustment to the SEFA as presented. The aggregate effect of the adjustment was material to the program and SEFA. The County failed to properly report all federal expenditures spent during the year. Inaccurate completion of the SEFA could lead to inaccurate reporting of federal expenditures by the County and could jeopardize future federal funding. We recommend the County work with its departments to ensure all grant activity is properly included and a materially accurate Schedule is presented for audit. Furthermore, the County should reach out to various Ohio agencies to assist in determining Federal activity.

Corrective Action Plan

The County Auditor will ensure all federal awards are accurately presented on the SEFA in the future.

Categories

Reporting Subrecipient Monitoring

Programs in Audit

ALN Program Name Expenditures
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $1.11M
12.U01 Section 594 of the Water Resources Development Act of 1999 $925,000
93.658 FOSTER CARE TITLE IV-E $366,049
93.600 HEAD START $317,749
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $270,508
93.563 CHILD SUPPORT SERVICES $255,772
16.548 DELINQUENCY PREVENTION PROGRAM $200,046
93.659 ADOPTION ASSISTANCE $152,065
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $102,038
20.263 BRIDGE FORMULA PROGRAM $96,956
84.181 SPECIAL EDUCATION-GRANTS FOR INFANTS AND FAMILIES $77,622
20.106 AIRPORT IMPROVEMENT PROGRAM, INFRASTRUCTURE INVESTMENT AND JOBS ACT PROGRAMS, AND COVID-19 AIRPORTS PROGRAMS $67,498
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $56,224
93.556 MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES PROGRAM $45,003
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $36,900
17.258 WIOA ADULT PROGRAM $35,715
93.472 TITLE IV-E PREVENTION PROGRAM $35,171
17.278 WIOA DISLOCATED WORKER FORMULA GRANTS $32,943
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $32,600
16.575 CRIME VICTIM ASSISTANCE $25,618
93.667 SOCIAL SERVICES BLOCK GRANT $25,375
17.225 UNEMPLOYMENT INSURANCE $21,043
93.674 JOHN H. CHAFEE FOSTER CARE PROGRAM FOR SUCCESSFUL TRANSITION TO ADULTHOOD $20,527
93.778 GRANTS TO STATES FOR MEDICAID $9,971
93.645 STEPHANIE TUBBS JONES CHILD WELFARE SERVICES PROGRAM $4,886
93.747 ELDER ABUSE PREVENTION INTERVENTIONS PROGRAM $1,871
20.205 HIGHWAY PLANNING AND CONSTRUCTION $1,544
17.259 WIOA YOUTH ACTIVITIES $1,203