Audit 13388

FY End
2022-12-31
Total Expended
$37.67M
Findings
2
Programs
45
Organization: Trumbull County (OH)
Year: 2022 Accepted: 2024-01-24

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
9661 2022-003 Material Weakness - L
586103 2022-003 Material Weakness - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $7.88M Yes 1
93.563 Child Support Enforcement $2.20M Yes 0
93.667 Social Services Block Grant $1.21M - 0
17.258 Wia Adult Program $952,148 - 0
20.205 Highway Planning and Construction $461,446 - 0
17.259 Wia Youth Activities $344,968 - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $260,687 - 0
14.267 Continuum of Care Program $244,876 - 0
93.575 Child Care and Development Block Grant $197,462 - 0
17.225 Unemployment Insurance $182,855 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $155,014 - 0
93.767 Children's Health Insurance Program $154,945 - 0
93.788 Opioid Str $133,010 - 0
84.181 Special Education-Grants for Infants and Families $114,195 - 0
66.458 Capitalization Grants for Clean Water State Revolving Funds $101,038 - 0
17.278 Wia Dislocated Worker Formula Grants $67,622 - 0
10.555 National School Lunch Program $63,140 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $61,437 - 0
93.747 Elder Abuse Prevention Interventions Program $58,897 - 0
21.019 Coronavirus Relief Fund $58,400 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $54,408 - 0
84.027 Special Education_grants to States $53,699 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $50,386 - 0
93.558 Temporary Assistance for Needy Families $40,028 Yes 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $39,669 - 0
93.053 Nutrition Services Incentive Program $38,577 - 0
84.425 Education Stabilization Fund $36,708 - 0
97.042 Emergency Management Performance Grants $34,447 - 0
93.556 Promoting Safe and Stable Families $34,059 - 0
12.610 Community Economic Adjustment Assistance for Compatible Use and Joint Land Use Studies $20,749 - 0
17.277 Workforce Investment Act (wia) National Emergency Grants $19,954 - 0
10.553 School Breakfast Program $19,053 - 0
20.616 National Priority Safety Programs $16,777 - 0
16.575 Crime Victim Assistance $16,643 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $13,279 - 0
93.778 Medical Assistance Program $10,403 - 0
93.958 Block Grants for Community Mental Health Services $9,624 - 0
20.600 State and Community Highway Safety $6,504 - 0
93.659 Adoption Assistance $6,461 - 0
14.239 Home Investment Partnerships Program $5,780 - 0
17.207 Employment Service/wagner-Peyser Funded Activities $4,676 - 0
16.582 Crime Victim Assistance/discretionary Grants $2,347 - 0
17.245 Trade Adjustment Assistance $2,313 - 0
93.658 Foster Care_title IV-E $1,910 Yes 0
84.173 Special Education_preschool Grants $26 - 0

Contacts

Name Title Type
E7FLB14DFY22 Martha Yoder Auditee
3306752420 Erik Holesko Auditor
No contacts on file

Notes to SEFA

Title: 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, 2022. 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: 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: 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: 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: 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, 2022 is $327,416.
Title: 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

2 C.F.R. Subpart F 200.510(b) requires that the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the County's financial statements which must include the total federal awards expended as determined in accordance with 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal Agency (2) 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. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in 200.414 Indirect (F&A) costs. 2 CFR Part 170 "subaward" has the meaning given in 2 CFR 200.1 and means an award provided by a pass-through entity to a subrecipient for the subrecipient to carry out part of a federal award received by the pass-through entity. It does not include payments to a contractor or payments to an individual that is a beneficiary of a federal program. A subaward may be provided through any form of legal agreement, including an agreement that the pass-through entity considers a contract. The County's Federal Schedule had the following error: Funds provided to subrecipients for the Coronavirus State and Local Fiscal Recovery Funds (AL 21.027) were understated by $3,000,000. Errors and omissions to the Schedule of Expenditures of Federal Awards could adversely affect future grant awards in addition to causing an inaccurate assessment of major federal programs that would be subjected to audit. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. County management should review all grant and loan awards and be familiar with federal reporting requirements. The County should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This may help ensure the Schedule is complete and accurate and major federal programs are correctly identified for audit.
2 C.F.R. Subpart F 200.510(b) requires that the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the County's financial statements which must include the total federal awards expended as determined in accordance with 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal Agency (2) 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. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in 200.414 Indirect (F&A) costs. 2 CFR Part 170 "subaward" has the meaning given in 2 CFR 200.1 and means an award provided by a pass-through entity to a subrecipient for the subrecipient to carry out part of a federal award received by the pass-through entity. It does not include payments to a contractor or payments to an individual that is a beneficiary of a federal program. A subaward may be provided through any form of legal agreement, including an agreement that the pass-through entity considers a contract. The County's Federal Schedule had the following error: Funds provided to subrecipients for the Coronavirus State and Local Fiscal Recovery Funds (AL 21.027) were understated by $3,000,000. Errors and omissions to the Schedule of Expenditures of Federal Awards could adversely affect future grant awards in addition to causing an inaccurate assessment of major federal programs that would be subjected to audit. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. County management should review all grant and loan awards and be familiar with federal reporting requirements. The County should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This may help ensure the Schedule is complete and accurate and major federal programs are correctly identified for audit.