Audit 317972

FY End
2023-12-31
Total Expended
$36.97M
Findings
6
Programs
44
Organization: Trumbull County (OH)
Year: 2023 Accepted: 2024-08-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
485161 2023-002 Material Weakness - L
485162 2023-002 Material Weakness - L
485163 2023-002 Material Weakness - L
1061603 2023-002 Material Weakness - L
1061604 2023-002 Material Weakness - L
1061605 2023-002 Material Weakness - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $6.76M Yes 1
14.267 Continuum of Care Program $922,680 - 0
93.778 Medical Assistance Program $838,512 - 0
93.563 Child Support Enforcement $765,552 - 0
93.658 Foster Care_title IV-E $714,520 - 0
20.205 Highway Planning and Construction $679,979 Yes 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $521,455 Yes 0
93.575 Child Care and Development Block Grant $366,524 - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $288,870 - 0
93.667 Social Services Block Grant $260,865 Yes 0
23.002 Appalachian Area Development $250,000 - 0
97.042 Emergency Management Performance Grants $196,073 - 0
12.610 Community Economic Adjustment Assistance for Compatible Use and Joint Land Use Studies $156,906 - 0
93.558 Temporary Assistance for Needy Families $156,469 - 0
66.458 Capitalization Grants for Clean Water State Revolving Funds $156,016 - 0
11.307 Economic Adjustment Assistance $153,081 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $152,672 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $130,387 Yes 0
17.259 Wia Youth Activities $130,012 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $119,456 - 0
14.239 Home Investment Partnerships Program $73,115 - 0
93.958 Block Grants for Community Mental Health Services $68,553 - 0
93.472 Title IV-E Prevention and Family Services and Programs (a) $48,320 - 0
93.767 Children's Health Insurance Program $46,692 - 0
17.258 Wia Adult Program $22,986 - 0
10.555 National School Lunch Program $20,588 - 0
84.181 Special Education-Grants for Infants and Families $18,888 - 0
84.137 Early Childhood Education $17,858 - 0
93.788 Opioid Str $17,534 - 0
17.225 Unemployment Insurance $14,683 - 0
17.207 Employment Service/wagner-Peyser Funded Activities $13,617 - 0
93.556 Promoting Safe and Stable Families $12,687 - 0
84.027 Special Education_grants to States $12,337 - 0
16.575 Crime Victim Assistance $11,097 - 0
93.659 Adoption Assistance $8,098 Yes 0
10.553 School Breakfast Program $7,451 - 0
93.747 Elder Abuse Prevention Interventions Program $6,081 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $2,610 - 0
16.582 Crime Victim Assistance/discretionary Grants $2,347 - 0
17.245 Trade Adjustment Assistance $2,170 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $1,568 - 0
17.277 Workforce Investment Act (wia) National Emergency Grants $1,196 - 0
17.270 Reintegration of Ex-Offenders $906 - 0
17.278 Wia Dislocated Worker Formula Grants $523 - 0

Contacts

Name Title Type
E7FLB14DFY22 Martha Yoder Auditee
3306752420 Brian Mosier Auditor
No contacts on file

Notes to SEFA

Title: NOTE A – BASIS OF PRESENTATION Accounting Policies: Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of Trumbull County (the County) under programs of the federal government for the year ended December 31, 2023. The information on this Schedule is prepared 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: NOTE B – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES Accounting Policies: Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement.
Title: NOTE C – INDIRECT COST RATE Accounting Policies: Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance.
Title: NOTE D - SUBRECIPIENTS Accounting Policies: Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The County passes certain federal awards received from U.S. Department of Housing and Urban Development, the Ohio Department of Developmental Disabilities, the Ohio Department of Mental Health and Addiction Services, and the Ohio Department of Jobs and Family Services to other governments or not-for-profit agencies (subrecipients). As Note B describes the County reports expenditures of Federal awards to subrecipients when paid in cash. As a pass-through entity, the County has certain compliance responsibilities, such as monitoring its subrecipients to help assure they use these subawards as authorized by laws, regulations, and the provisions of contracts or grant agreements, and that subrecipients achieve the award’s performance goals.
Title: NOTE E - CHILD NUTRITION CLUSTER Accounting Policies: Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The County commingles cash receipts from the U.S. Department of Agriculture with similar State grants. When reporting expenditures on this Schedule, the County assumes it expends federal monies first.
Title: NOTE F – FOOD DONATION PROGRAM Accounting Policies: Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The County reports commodities consumed on the Schedule at the fair value. The County allocated donated food commodities to the respective program that benefitted from the use of those donated food commodities.
Title: NOTE G - COMMUNITY DEVELOPMENT BLOCK GRANT (CDBG) WITH REVOLVING LOAN CASH BALANCE Accounting Policies: Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The current cash balance on the County’s local program income account as of December 31, 2023 is $310,219.
Title: NOTE I - MATCHING REQUIREMENTS Accounting Policies: Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. Certain Federal programs require the County to contribute non-Federal funds (matching funds) to support the Federally-funded programs. The County has met its matching requirements. The Schedule does not include the expenditure of non-Federal matching funds.

Finding Details

Finding 2023-002 – Material Weakness/Reporting Noncompliance COVID-19 Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 U.S. DEPARMENT OF TREASURY Criteria: The U.S. Department of Treasury established reporting requirements for local governments. These requirements established methods and timelines for reporting Coronavirus State and Local Fiscal Recovery Funds (SLFRF expenditures to the U.S. Department of Treasury) Condition: The County misidentified contractors and beneficiaries as subrecipients on the quarterly reports to Treasury. Context: During our review of the quarterly project and expenditure reports, we noted the County improperly reported 22 and 33 contractors and beneficiaries as subrecipients on the 2023 Quarter 1 and 3 SLFRF Compliance Reports, respectively. Cause: Lack of sufficient internal controls over the reporting requirements of the Coronavirus State and Local Fiscal Recovery Funds. Effect: The County was not in compliance with reporting requirements in 2023. Recommendation: We recommend the County improve controls over the reporting requirements associated with this program. This includes obtaining a better understanding of the reporting processes in the Treasury reporting portal.
Finding 2023-002 – Material Weakness/Reporting Noncompliance COVID-19 Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 U.S. DEPARMENT OF TREASURY Criteria: The U.S. Department of Treasury established reporting requirements for local governments. These requirements established methods and timelines for reporting Coronavirus State and Local Fiscal Recovery Funds (SLFRF expenditures to the U.S. Department of Treasury) Condition: The County misidentified contractors and beneficiaries as subrecipients on the quarterly reports to Treasury. Context: During our review of the quarterly project and expenditure reports, we noted the County improperly reported 22 and 33 contractors and beneficiaries as subrecipients on the 2023 Quarter 1 and 3 SLFRF Compliance Reports, respectively. Cause: Lack of sufficient internal controls over the reporting requirements of the Coronavirus State and Local Fiscal Recovery Funds. Effect: The County was not in compliance with reporting requirements in 2023. Recommendation: We recommend the County improve controls over the reporting requirements associated with this program. This includes obtaining a better understanding of the reporting processes in the Treasury reporting portal.
Finding 2023-002 – Material Weakness/Reporting Noncompliance COVID-19 Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 U.S. DEPARMENT OF TREASURY Criteria: The U.S. Department of Treasury established reporting requirements for local governments. These requirements established methods and timelines for reporting Coronavirus State and Local Fiscal Recovery Funds (SLFRF expenditures to the U.S. Department of Treasury) Condition: The County misidentified contractors and beneficiaries as subrecipients on the quarterly reports to Treasury. Context: During our review of the quarterly project and expenditure reports, we noted the County improperly reported 22 and 33 contractors and beneficiaries as subrecipients on the 2023 Quarter 1 and 3 SLFRF Compliance Reports, respectively. Cause: Lack of sufficient internal controls over the reporting requirements of the Coronavirus State and Local Fiscal Recovery Funds. Effect: The County was not in compliance with reporting requirements in 2023. Recommendation: We recommend the County improve controls over the reporting requirements associated with this program. This includes obtaining a better understanding of the reporting processes in the Treasury reporting portal.
Finding 2023-002 – Material Weakness/Reporting Noncompliance COVID-19 Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 U.S. DEPARMENT OF TREASURY Criteria: The U.S. Department of Treasury established reporting requirements for local governments. These requirements established methods and timelines for reporting Coronavirus State and Local Fiscal Recovery Funds (SLFRF expenditures to the U.S. Department of Treasury) Condition: The County misidentified contractors and beneficiaries as subrecipients on the quarterly reports to Treasury. Context: During our review of the quarterly project and expenditure reports, we noted the County improperly reported 22 and 33 contractors and beneficiaries as subrecipients on the 2023 Quarter 1 and 3 SLFRF Compliance Reports, respectively. Cause: Lack of sufficient internal controls over the reporting requirements of the Coronavirus State and Local Fiscal Recovery Funds. Effect: The County was not in compliance with reporting requirements in 2023. Recommendation: We recommend the County improve controls over the reporting requirements associated with this program. This includes obtaining a better understanding of the reporting processes in the Treasury reporting portal.
Finding 2023-002 – Material Weakness/Reporting Noncompliance COVID-19 Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 U.S. DEPARMENT OF TREASURY Criteria: The U.S. Department of Treasury established reporting requirements for local governments. These requirements established methods and timelines for reporting Coronavirus State and Local Fiscal Recovery Funds (SLFRF expenditures to the U.S. Department of Treasury) Condition: The County misidentified contractors and beneficiaries as subrecipients on the quarterly reports to Treasury. Context: During our review of the quarterly project and expenditure reports, we noted the County improperly reported 22 and 33 contractors and beneficiaries as subrecipients on the 2023 Quarter 1 and 3 SLFRF Compliance Reports, respectively. Cause: Lack of sufficient internal controls over the reporting requirements of the Coronavirus State and Local Fiscal Recovery Funds. Effect: The County was not in compliance with reporting requirements in 2023. Recommendation: We recommend the County improve controls over the reporting requirements associated with this program. This includes obtaining a better understanding of the reporting processes in the Treasury reporting portal.
Finding 2023-002 – Material Weakness/Reporting Noncompliance COVID-19 Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 U.S. DEPARMENT OF TREASURY Criteria: The U.S. Department of Treasury established reporting requirements for local governments. These requirements established methods and timelines for reporting Coronavirus State and Local Fiscal Recovery Funds (SLFRF expenditures to the U.S. Department of Treasury) Condition: The County misidentified contractors and beneficiaries as subrecipients on the quarterly reports to Treasury. Context: During our review of the quarterly project and expenditure reports, we noted the County improperly reported 22 and 33 contractors and beneficiaries as subrecipients on the 2023 Quarter 1 and 3 SLFRF Compliance Reports, respectively. Cause: Lack of sufficient internal controls over the reporting requirements of the Coronavirus State and Local Fiscal Recovery Funds. Effect: The County was not in compliance with reporting requirements in 2023. Recommendation: We recommend the County improve controls over the reporting requirements associated with this program. This includes obtaining a better understanding of the reporting processes in the Treasury reporting portal.