Audit 316600

FY End
2023-12-31
Total Expended
$38.11M
Findings
2
Programs
44
Organization: Clermont County (OH)
Year: 2023 Accepted: 2024-08-05

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
480345 2023-001 - - L
1056787 2023-001 - - L

Programs

ALN Program Spent Major Findings
93.563 Child Support Enforcement $3.79M - 0
21.023 Covid-19 Emergency Rental Assistance Program $2.60M Yes 1
93.558 Temporary Assistance for Needy Families $2.43M - 0
93.658 Foster Care_title IV-E $1.61M Yes 0
93.778 Medical Assistance Program $1.15M - 0
93.788 Opioid Str $1.15M - 0
20.507 Covid-19 Federal Transit_formula Grants $1.00M - 0
93.667 Social Services Block Grant $878,527 - 0
93.659 Adoption Assistance $873,373 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $756,094 - 0
17.258 Wia Adult Program $446,916 - 0
17.278 Wia Dislocated Worker Formula Grants $250,316 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $247,226 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $207,171 - 0
14.218 Community Development Block Grants/entitlement Grants $159,111 - 0
93.575 Child Care and Development Block Grant $142,636 - 0
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $128,802 Yes 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $119,744 - 0
84.181 Special Education-Grants for Infants and Families $119,058 - 0
97.042 Emergency Management Performance Grants $110,980 - 0
93.556 Promoting Safe and Stable Families $88,387 - 0
84.013 Title I State Agency Program for Neglected and Delinquent Children and Youth $81,274 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $79,106 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $70,515 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $61,478 - 0
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $48,000 - 0
20.600 State and Community Highway Safety $47,066 - 0
84.181 Covid-19 Special Education-Grants for Infants and Families $44,860 - 0
93.747 Elder Abuse Prevention Interventions Program $39,945 - 0
84.425 Covid-19 Education Stabilization Fund $35,968 - 0
16.575 Crime Victim Assistance $34,909 - 0
10.553 School Breakfast Program $30,740 - 0
84.027 Special Education_grants to States $25,244 - 0
10.760 Water and Waste Disposal Systems for Rural Communities $21,932 Yes 0
10.555 National School Lunch Program $12,599 - 0
20.507 Federal Transit_formula Grants $11,714 - 0
93.669 Child Abuse and Neglect State Grants $8,997 - 0
17.207 Employment Service/wagner-Peyser Funded Activities $7,373 - 0
20.205 Highway Planning and Construction $5,600 - 0
97.039 Hazard Mitigation Grant $2,070 - 0
21.016 Equitable Sharing $2,000 - 0
17.245 Trade Adjustment Assistance $1,179 - 0
93.958 Block Grants for Community Mental Health Services $599 - 0
90.404 2018 Hava Election Security Grants $483 - 0

Contacts

Name Title Type
GR1JFLSDX7K5 Linda Fraley Auditee
5137327150 Nick Chisek, CPA Auditor
No contacts on file

Notes to SEFA

Title: NOTE C – CHILD NUTRITION CLUSTER Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of Clermont 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 Federal Regulations Part 200, Uniform Guidance 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. Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Guidance Requirements, Costs Principles and Audit Requirements for Federal Awards, 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 not elected 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 D – MATCHING REQUIREMENTS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of Clermont 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 Federal Regulations Part 200, Uniform Guidance 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. Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Guidance Requirements, Costs Principles and Audit Requirements for Federal Awards, 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 not elected 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.
Title: NOTE E – SUBRECIPIENTS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of Clermont 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 Federal Regulations Part 200, Uniform Guidance 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. Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Guidance Requirements, Costs Principles and Audit Requirements for Federal Awards, 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 not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The County passes certain federal awards received from the U.S. Department of Treasury 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 subrecipient, 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 F – USDA LOANS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of Clermont 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 Federal Regulations Part 200, Uniform Guidance 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. Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Guidance Requirements, Costs Principles and Audit Requirements for Federal Awards, 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 not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The County received two loans from the United States Department of Agriculture Assistance Listing 10.760 Water and Waste Disposal Systems for Rural Communities; Newtonsville Collection Loan #05 and Newtonsvilee WWTP Loan #07. These loans were not reported on the 2022 schedule and therefore are reported this year as combined amount for 2022 and 2023, which was approved by the USDA. The Newtonsville Collection Loan #05 was for $4,218,000 with $1,249,658 expended in 2022 and $2,968,342 expended in 2023; and has been fully expended. The Newtonsville WWTP Loan #07 was for $4,000,000 with $35,000 expended in 2022 and $3,227,193 expended in 2023; for a total expended of $3,262,193.

Finding Details

Recipients must use the standard financial reporting forms or such other forms as may be authorized by OMB (approval is indicated by an OMB paperwork control number on the form) when reporting to the Federal awarding agency. Each recipient must report program outlays and program income on a cash or accrual basis, as prescribed by the Federal awarding agency. The standard financial reporting forms for grants and cooperative agreements for the Emergency Rental Assistance program are as follows: Federal Financial Report (FFR) (SF-425/SF-425A) (OMB No. 0348-0061). Recipients use the FFR as a standardized format to report expenditures under Federal awards, as well as, when applicable, cash status (lines 10.a, 10.b, and 10c). References to this report include its applicability as both an expenditure and a cash status report unless otherwise indicated. Non-Federal entities may be required to submit performance reports at least annually but not more frequently than quarterly, except in unusual circumstances, using a form or format authorized by OMB (2 CFR 200.329(c)(1)). They also may be required to submit special reports as required by the terms and conditions of the Federal award. During testing we noted reported expenditures per quarter did not agree with supporting invoices paid by the County. Additionally, beginning with the second quarter report 2023, key line items which included area demographics were not included in the reports provided. By not properly filing the required reports, the County is in noncompliance with the requirements set forth by the U.S. Department of Treasury. This could result in the Treasury not fully being aware of how the County is utilizing the funding in determining if the County is following other requirements and using the funding properly. We recommend the County add additional procedures or controls to ensure all components of reporting federal expenditures are accurately reported.
Recipients must use the standard financial reporting forms or such other forms as may be authorized by OMB (approval is indicated by an OMB paperwork control number on the form) when reporting to the Federal awarding agency. Each recipient must report program outlays and program income on a cash or accrual basis, as prescribed by the Federal awarding agency. The standard financial reporting forms for grants and cooperative agreements for the Emergency Rental Assistance program are as follows: Federal Financial Report (FFR) (SF-425/SF-425A) (OMB No. 0348-0061). Recipients use the FFR as a standardized format to report expenditures under Federal awards, as well as, when applicable, cash status (lines 10.a, 10.b, and 10c). References to this report include its applicability as both an expenditure and a cash status report unless otherwise indicated. Non-Federal entities may be required to submit performance reports at least annually but not more frequently than quarterly, except in unusual circumstances, using a form or format authorized by OMB (2 CFR 200.329(c)(1)). They also may be required to submit special reports as required by the terms and conditions of the Federal award. During testing we noted reported expenditures per quarter did not agree with supporting invoices paid by the County. Additionally, beginning with the second quarter report 2023, key line items which included area demographics were not included in the reports provided. By not properly filing the required reports, the County is in noncompliance with the requirements set forth by the U.S. Department of Treasury. This could result in the Treasury not fully being aware of how the County is utilizing the funding in determining if the County is following other requirements and using the funding properly. We recommend the County add additional procedures or controls to ensure all components of reporting federal expenditures are accurately reported.