Audit 313692

FY End
2022-12-31
Total Expended
$27.79M
Findings
4
Programs
47
Organization: Clermont County (OH)
Year: 2022 Accepted: 2023-08-24

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
453169 2022-001 Significant Deficiency - C
453170 2022-001 Significant Deficiency - C
1029611 2022-001 Significant Deficiency - C
1029612 2022-001 Significant Deficiency - C

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $6.99M Yes 0
21.023 Covid-19 - Emergency Rental Assistance Program $3.91M Yes 0
93.563 Child Support Enforcement $2.39M Yes 0
93.558 Temporary Assistance for Needy Families $1.81M - 0
93.667 Social Services Block Grant $1.41M - 0
93.658 Foster Care_title IV-E $1.35M - 0
93.778 Medical Assistance Program $1.08M Yes 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $878,595 - 0
20.507 Covid-19 - Federal Transit_formula Grants $847,335 Yes 1
93.659 Adoption Assistance $810,813 - 0
17.258 Wioa Adult Program $391,266 - 0
20.205 Roundbottom Road Bridge $247,335 - 0
93.788 Opioid Str $219,124 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $204,631 - 0
17.278 Wia Dislocated Worker Formula Grants $201,953 - 0
90.404 Cares Act Election Preparedness $199,659 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $153,975 - 0
93.575 Child Care and Development Block Grant - Childcare/quality $126,890 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $95,037 - 0
93.556 Promoting Safe and Stable Families $94,420 - 0
21.019 Covid-19 - Coronavirus Relief Fund $89,365 - 0
84.013 Title I State Agency Program for Neglected and Delinquent Children and Youth $85,543 - 0
20.507 Federal Transit_formula Grants $80,085 Yes 1
93.959 Covid-19 - Block Grants for Prevention and Treatment of Substance Abuse $70,891 Yes 0
93.958 Block Grants for Community Mental Health Services $65,125 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $56,645 - 0
14.218 Community Development Block Grants/entitlement Grants $55,000 - 0
16.575 Crime Victim Assistance $45,704 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $44,805 Yes 0
45.310 Covid-19 - Grants to States $44,067 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $43,704 - 0
10.555 National School Lunch Program $40,265 - 0
97.042 Emergency Management Performance Grants $34,766 - 0
10.561 Covid-19 - State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $34,481 - 0
93.104 Comprehensive Community Mental Health Services for Children with Serious Emotional Disturbances (sed) $32,315 - 0
97.042 Emergency Management Performance Grants, Covid-19 Supplement $31,949 - 0
20.600 State and Community Highway Safety $31,511 - 0
93.669 Communities of Support Grant $30,107 - 0
84.027 Special Education_grants to States $25,991 - 0
93.747 Elder Abuse Prevention Interventions Program $22,535 - 0
10.553 School Breakfast Program $19,877 - 0
21.016 Equitable Sharing $15,086 - 0
17.207 Employment Service/wagner-Peyser Funded Activities $7,227 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $4,118 - 0
17.245 Trade Adjustment Assistance $1,135 - 0
20.616 National Priority Safety Programs $492 - 0
90.404 2022 Help America Vote Act (hava) $395 - 0

Contacts

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

Notes to SEFA

Title: 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, 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. 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 Administrative Requirements, Cost 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 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: 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, 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. 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 Administrative Requirements, Cost 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 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.
Title: SUBRECIPIENT AWARDS: 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, 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. 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 Administrative Requirements, Cost 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 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 various agencies 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, ant the subrecipients achieve the awards performance goals.

Finding Details

2 CFR 1201.1 gives regulatory effect to the Department of Transportation for 2 CFR 200.305(b)(3), which states, in part, when the reimbursement method is used, the Federal awarding agency or pass-through entity must make payment within 30 calendar days after receipt of the billing, unless the Federal awarding agency or pass-through entity reasonably believes the request to be improper.The County receives grants, tax rebates, and farebox revenues that are reported to reduce the total expenditures eligible for reimbursement. In the first half of 2022, the formula to calculate the drawdown contained an error that resulted in overstated expenditures. The reimbursement request was submitted based on this work paper and due to the formula error, the drawdown of funds in excess of the eligible expenditures by $50,946.By requesting funds in excess of the calculated eligible expenditures, the County cannot properly account for and expend these funds within the 30 calendar days allotted for the reimbursement method, ultimately resulting in a noncompliance.We recommend the County add additional procedures or controls to further test the accuracy of the work papers used to calculate the reimbursements, prior to submitting them.
2 CFR 1201.1 gives regulatory effect to the Department of Transportation for 2 CFR 200.305(b)(3), which states, in part, when the reimbursement method is used, the Federal awarding agency or pass-through entity must make payment within 30 calendar days after receipt of the billing, unless the Federal awarding agency or pass-through entity reasonably believes the request to be improper.The County receives grants, tax rebates, and farebox revenues that are reported to reduce the total expenditures eligible for reimbursement. In the first half of 2022, the formula to calculate the drawdown contained an error that resulted in overstated expenditures. The reimbursement request was submitted based on this work paper and due to the formula error, the drawdown of funds in excess of the eligible expenditures by $50,946.By requesting funds in excess of the calculated eligible expenditures, the County cannot properly account for and expend these funds within the 30 calendar days allotted for the reimbursement method, ultimately resulting in a noncompliance.We recommend the County add additional procedures or controls to further test the accuracy of the work papers used to calculate the reimbursements, prior to submitting them.
2 CFR 1201.1 gives regulatory effect to the Department of Transportation for 2 CFR 200.305(b)(3), which states, in part, when the reimbursement method is used, the Federal awarding agency or pass-through entity must make payment within 30 calendar days after receipt of the billing, unless the Federal awarding agency or pass-through entity reasonably believes the request to be improper.The County receives grants, tax rebates, and farebox revenues that are reported to reduce the total expenditures eligible for reimbursement. In the first half of 2022, the formula to calculate the drawdown contained an error that resulted in overstated expenditures. The reimbursement request was submitted based on this work paper and due to the formula error, the drawdown of funds in excess of the eligible expenditures by $50,946.By requesting funds in excess of the calculated eligible expenditures, the County cannot properly account for and expend these funds within the 30 calendar days allotted for the reimbursement method, ultimately resulting in a noncompliance.We recommend the County add additional procedures or controls to further test the accuracy of the work papers used to calculate the reimbursements, prior to submitting them.
2 CFR 1201.1 gives regulatory effect to the Department of Transportation for 2 CFR 200.305(b)(3), which states, in part, when the reimbursement method is used, the Federal awarding agency or pass-through entity must make payment within 30 calendar days after receipt of the billing, unless the Federal awarding agency or pass-through entity reasonably believes the request to be improper.The County receives grants, tax rebates, and farebox revenues that are reported to reduce the total expenditures eligible for reimbursement. In the first half of 2022, the formula to calculate the drawdown contained an error that resulted in overstated expenditures. The reimbursement request was submitted based on this work paper and due to the formula error, the drawdown of funds in excess of the eligible expenditures by $50,946.By requesting funds in excess of the calculated eligible expenditures, the County cannot properly account for and expend these funds within the 30 calendar days allotted for the reimbursement method, ultimately resulting in a noncompliance.We recommend the County add additional procedures or controls to further test the accuracy of the work papers used to calculate the reimbursements, prior to submitting them.