Audit 2756

FY End
2022-12-31
Total Expended
$10.21M
Findings
2
Programs
37
Organization: Coshocton County (OH)
Year: 2022 Accepted: 2023-11-09

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
1486 2022-005 Material Weakness - ABH
577928 2022-005 Material Weakness - ABH

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $3.44M Yes 1
93.658 Foster Care_title IV-E $803,672 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $376,645 - 0
93.667 Social Services Block Grant $207,757 - 0
14.239 Home Investment Partnerships Program $148,932 - 0
17.277 Workforce Investment Act (wia) National Emergency Grants $100,952 - 0
93.563 Child Support Enforcement $100,909 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $98,771 - 0
93.558 Temporary Assistance for Needy Families $58,845 - 0
17.259 Wia Youth Activities $50,263 - 0
21.032 Local Assistance and Tribal Consistency Fund $50,000 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $43,918 Yes 0
93.575 Child Care and Development Block Grant $43,635 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $41,029 - 0
17.278 Wia Dislocated Worker Formula Grants $38,380 - 0
16.575 Crime Victim Assistance $36,010 - 0
20.106 Airport Improvement Program $31,973 - 0
17.225 Unemployment Insurance $25,394 - 0
93.556 Promoting Safe and Stable Families $23,671 - 0
20.509 Formula Grants for Rural Areas and Tribal Transit Program $18,237 - 0
97.042 Emergency Management Performance Grants $15,791 - 0
93.747 Elder Abuse Prevention Interventions Program $14,365 - 0
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $12,545 - 0
93.767 Children's Health Insurance Program $11,854 - 0
84.425 Education Stabilization Fund $11,447 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $10,402 - 0
90.404 2018 Hava Election Security Grants $10,000 - 0
17.258 Wia Adult Program $9,373 - 0
97.047 Pre-Disaster Mitigation $8,333 - 0
93.586 State Court Improvement Program $2,497 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $2,048 - 0
84.181 Special Education-Grants for Infants and Families $1,404 - 0
93.659 Adoption Assistance $1,400 - 0
93.778 Medical Assistance Program $837 - 0
84.027 Special Education_grants to States $566 - 0
15.226 Payments in Lieu of Taxes $135 - 0
84.173 Special Education_preschool Grants $42 - 0

Contacts

Name Title Type
EVF5JVNFJYN3 Grant Daugherty Auditee
7406221243 Denise Blair Auditor
No contacts on file

Notes to SEFA

Title: NOTE C - MATCHING REQUIREMENTS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of Coshocton 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 cost principles contained in the Uniform Guidance wherein certain types of expenditures may or may not be limited to as to reimbursement. De Minimis Rate Used: N Rate Explanation: 2 CFR Section 200.414 of the Uniform Guidance allows a non-federal entity that has never received a negotiated indirect cost rate to charge a de minimis rate of 10% of modified total direct costs to indirect costs. 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: NOTE D - TRANSFERS BETWEEN FEDERAL PROGRAMS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of Coshocton 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 cost principles contained in the Uniform Guidance wherein certain types of expenditures may or may not be limited to as to reimbursement. De Minimis Rate Used: N Rate Explanation: 2 CFR Section 200.414 of the Uniform Guidance allows a non-federal entity that has never received a negotiated indirect cost rate to charge a de minimis rate of 10% of modified total direct costs to indirect costs. The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. During fiscal year 2022, the County made allowable transfers of $207,757 from the Temporary Assistance for Needy Families (TANF) (AL #93.558) program to the Social Services Block Grant (SSBG) (AL #93.667) program. The Schedule shows the County spent approximately $978,442 on the TANF program. The amount reported for the TANF program on the Schedule excludes the amount transferred to the SSBG program. The amount transferred to the SSBG program is included as SSBG expenditures when disbursed. The following table shows the gross amount drawn for the TANF program during fiscal year 2022 and the amount transferred to the Social Services Block Grant program.

Finding Details

2 C.F.R. § 1000.10 gives regulatory effect to the Department of the Treasurer for 2 C.F.R. § 200.403(a), which requires that costs be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. 2 C.F.R. § 200.403(c) documents that costs must be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non-Federal entity. The County paid stipends to various employees under the “premium pay” provisions of the State and Local Fiscal Recovery Funds (SLFRF) grant, Assistance Listing (AL) #21.027. This included reimbursements of $57,000 to the Coshocton County Job and Family Services (CCJFS). The CCJFS originally reported the premium pay stipends against various indirect cost pools which were allocated to various Federal and State grants. The reimbursement was not coded against the same cost pools which resulted in the County charging the SLFRF grant and various other Federal grants for the same cost. This error was brought to the attention of the County and the CCJFS subsequently posted adjustments in 2023 to correct this error. The County should more closely monitor the reporting of coding and reporting of expenditures against grant resources. Departments should work together to ensure that only one Federal grant is being charged when multiple grants could cover the costs. This will help improve internal controls to ensure that expenditures are accurately reported and are paid from one Federal revenue source, reducing the risk of questioned costs arising.
2 C.F.R. § 1000.10 gives regulatory effect to the Department of the Treasurer for 2 C.F.R. § 200.403(a), which requires that costs be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. 2 C.F.R. § 200.403(c) documents that costs must be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non-Federal entity. The County paid stipends to various employees under the “premium pay” provisions of the State and Local Fiscal Recovery Funds (SLFRF) grant, Assistance Listing (AL) #21.027. This included reimbursements of $57,000 to the Coshocton County Job and Family Services (CCJFS). The CCJFS originally reported the premium pay stipends against various indirect cost pools which were allocated to various Federal and State grants. The reimbursement was not coded against the same cost pools which resulted in the County charging the SLFRF grant and various other Federal grants for the same cost. This error was brought to the attention of the County and the CCJFS subsequently posted adjustments in 2023 to correct this error. The County should more closely monitor the reporting of coding and reporting of expenditures against grant resources. Departments should work together to ensure that only one Federal grant is being charged when multiple grants could cover the costs. This will help improve internal controls to ensure that expenditures are accurately reported and are paid from one Federal revenue source, reducing the risk of questioned costs arising.