Finding 1177943 (2024-001)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-03-11

AI Summary

  • Core Issue: The County failed to submit Project and Expenditure Reports on time and inaccurately reported financial data.
  • Impacted Requirements: Non-compliance with 2 CFR 200.302 and 31 CFR 35.4(c) regarding timely and accurate reporting of federal funds.
  • Recommended Follow-up: Implement internal controls to ensure accurate reporting and timely submission of quarterly reports to avoid potential penalties from the Department of Treasury.

Finding Text

2 CFR 1000.10 provides that, except for the deviations set forth elsewhere in this Part, the Department of Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards set forth at 2 CFR Part 200. 2 CFR 200.302 states, in part, the financial management system of each non-Federal entity must provide for accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. 2 CFR 200.329(c)(1) states that non-Federal entities must submit performance reports at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. Reports submitted quarterly must be due no later than 30 calendar days after the reporting period. 31 CFR 35.4(c) requires recipients, in part, during the period of performance, to provide the Secretary of the U.S. Department of Treasury periodic reports providing detailed accounting of the uses of funds, modifications to a State or Territory's tax revenue sources, and such other information as the Secretary may require for the administration of this section. The U.S. Department of Treasury provided supplementary information in its 2021 interim final rule on reporting requirements for State and Local Fiscal Recovery Funds for 31 CFR Part 35 and provided further guidance in its Project and Expenditure Report User Guide for State and Local Fiscal Recovery Funds. The 2021 interim rule supplementary information, part VIII states that counties will be required to submit quarterly Project and Expenditure reports through the end of the award period on December 31, 2026. The Department of Treasury’s Project and Expenditure Report User Guide provides, in part, that counties with a population that exceeds 250,000 residents must submit a Project and Expenditure Report by January 31, 2022 and then the last day of the month after the end of each quarter thereafter. The County did not have proper internal controls in place to ensure the timely and accurate submission of the Project and Expenditure Reports. During testing of Project and Expenditure Reports for the COVID-19 Coronavirus State and Local Fiscal Recovery Funds (AL #21.027), we noted that: • The County did not submit the Project and Expenditure Reports for the second and fourth quarters by the required deadlines of July 31, 2024 and January 31, 2025, respectively. • On the first quarter Project and Expenditure Report, the County understated current period expenditures by $1,041,688, understated cumulative expenditures by $11,564,350, and understated cumulative obligations by $1,407,879. Similarly, on the third quarter Project and Expenditure Report, the County understated current period expenditures by $385.732, understated the cumulative expenditures by $13,169,950, and understated cumulative obligations by $1,407,879. Failure to have the proper controls in place to ensure the timely and accurate submission of the Project and Expenditure Reports could result in Treasury taking action against the County for failure to comply with programmatic requirements. The County should implement and have controls in place to ensure the quarterly Project and Expenditure Reports are accurate and filed by the required due dates.

Corrective Action Plan

Now that Treasury Portal is updated with all obligations the County will utilize Oracle reporting to input all remaining expenditures in the applicable quarterly report.

Categories

Subrecipient Monitoring Allowable Costs / Cost Principles Period of Performance Reporting Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1177939 2024-001
    Material Weakness Repeat
  • 1177940 2024-001
    Material Weakness Repeat
  • 1177941 2024-001
    Material Weakness Repeat
  • 1177942 2024-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $8.82M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $7.73M
93.563 CHILD SUPPORT SERVICES $4.91M
93.659 ADOPTION ASSISTANCE $3.58M
93.658 FOSTER CARE TITLE IV-E $3.35M
93.778 MEDICAL ASSISTANCE PROGRAM $3.21M
20.106 AIRPORT IMPROVEMENT PROGRAM, INFRASTRUCTURE INVESTMENT AND JOBS ACT PROGRAMS, AND COVID-19 AIRPORTS PROGRAMS $3.04M
93.788 OPIOID STR $2.74M
93.667 SOCIAL SERVICES BLOCK GRANT $2.49M
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $2.33M
93.959 BLOCK GRANTS FOR PREVENTION AND TREATMENT OF SUBSTANCE ABUSE $1.62M
93.493 CONGRESSIONAL DIRECTIVES $1.50M
17.258 WIOA ADULT PROGRAM $1.20M
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $1.15M
17.278 WIOA DISLOCATED WORKER FORMULA GRANTS $781,724
20.507 COVID-19 FEDERAL TRANSIT FORMULA GRANTS $657,643
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $572,015
21.027 COVID-19 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $452,288
17.259 WIOA YOUTH ACTIVITIES $451,631
14.267 CONTINUUM OF CARE PROGRAM $433,298
93.471 TITLE IV-E KINSHIP NAVIGATOR PROGRAM $417,900
97.067 HOMELAND SECURITY GRANT PROGRAM $364,859
84.181 SPECIAL EDUCATION-GRANTS FOR INFANTS AND FAMILIES $348,922
17.225 UNEMPLOYMENT INSURANCE $306,189
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $279,135
20.526 BUSES AND BUS FACILITIES FORMULA, COMPETITIVE, AND LOW OR NO EMISSIONS PROGRAMS $273,820
16.575 CRIME VICTIM ASSISTANCE $190,546
93.958 BLOCK GRANTS FOR COMMUNITY MENTAL HEALTH SERVICES $181,661
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $147,521
21.027 OCJS ARPA $137,840
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $133,448
21.027 LEAD SAFE OHIO $130,701
93.556 MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES PROGRAM $118,570
16.922 EQUITABLE SHARING PROGRAM $88,770
84.027 SPECIAL EDUCATION GRANTS TO STATES $78,886
17.277 WIOA NATIONAL DISLOCATED WORKER GRANTS / WIA NATIONAL EMERGENCY GRANTS $78,010
93.150 PROJECTS FOR ASSISTANCE IN TRANSITION FROM HOMELESSNESS (PATH) $76,933
16.593 RESIDENTIAL SUBSTANCE ABUSE TREATMENT FOR STATE PRISONERS $74,311
16.585 TREATMENT COURT DISCRETIONARY GRANT PROGRAM $63,464
10.555 NATIONAL SCHOOL LUNCH PROGRAM $54,151
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $38,623
93.472 TITLE IV-E PREVENTION PROGRAM $31,908
66.815 BROWNFIELDS JOB TRAINING COOPERATIVE AGREEMENTS $29,383
17.207 EMPLOYMENT SERVICE/WAGNER-PEYSER FUNDED ACTIVITIES $27,738
93.674 JOHN H. CHAFEE FOSTER CARE PROGRAM FOR SUCCESSFUL TRANSITION TO ADULTHOOD $26,971
20.608 MINIMUM PENALTIES FOR REPEAT OFFENDERS FOR DRIVING WHILE INTOXICATED $25,654
16.838 COMPREHENSIVE OPIOID, STIMULANT, AND OTHER SUBSTANCES USE PROGRAM $20,554
10.553 SCHOOL BREAKFAST PROGRAM $15,631
93.645 STEPHANIE TUBBS JONES CHILD WELFARE SERVICES PROGRAM $10,458
17.245 TRADE ADJUSTMENT ASSISTANCE $4,475
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $4,235
93.747 ELDER ABUSE PREVENTION INTERVENTIONS PROGRAM $3,608