Audit 309765

FY End
2023-12-31
Total Expended
$13.75M
Findings
6
Programs
29
Organization: Columbiana County (OH)
Year: 2023 Accepted: 2024-06-25

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
401869 2023-001 Material Weakness Yes L
401870 2023-001 Material Weakness Yes L
401871 2023-001 Material Weakness Yes L
978311 2023-001 Material Weakness Yes L
978312 2023-001 Material Weakness Yes L
978313 2023-001 Material Weakness Yes L

Programs

ALN Program Spent Major Findings
93.778 Medical Assistance Program $1.44M Yes 0
93.563 Child Support Enforcement $1.34M - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $609,393 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $586,203 - 0
14.239 Home Investment Partnerships Program $400,390 - 0
93.658 Foster Care_title IV-E $336,593 - 0
93.788 Opioid Str $315,649 - 0
93.767 Children's Health Insurance Program $293,347 - 0
93.659 Adoption Assistance $280,527 - 0
84.181 Special Education-Grants for Infants and Families $267,878 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $193,100 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $185,780 - 0
93.958 Block Grants for Community Mental Health Services $163,874 - 0
93.575 Child Care and Development Block Grant $126,842 - 0
93.667 Social Services Block Grant $91,702 Yes 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $52,876 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $47,200 Yes 1
93.556 Promoting Safe and Stable Families $42,717 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $35,541 - 0
20.205 Highway Planning and Construction $32,254 - 0
16.575 Crime Victim Assistance $31,098 - 0
97.042 Emergency Management Performance Grants $29,971 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $27,264 - 0
84.027 Special Education_grants to States $25,692 - 0
93.558 Temporary Assistance for Needy Families $20,334 Yes 0
90.404 2018 Hava Election Security Grants $20,083 - 0
10.555 National School Lunch Program $12,396 - 0
10.553 School Breakfast Program $7,870 - 0
93.747 Elder Abuse Prevention Interventions Program $1,895 - 0

Contacts

Name Title Type
MLK4HCUR8LS8 Nancy Milliken Auditee
3304249515 Brian Mosier Auditor
No contacts on file

Notes to SEFA

Title: A 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 Columbiana 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: B 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: C 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: D 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 established a revolving loan fund to provide low-interest loans to businesses to create jobs for persons from low-moderate income households. The Federal Department of Housing and Urban Development (HUD) grants money for these loans to the County passed through the Ohio Department of Development. The initial loan of this money is recorded as a disbursement on this schedule. Loans repaid, including interest, are used to make additional loans. Such subsequent loans are subject to certain compliance requirements imposed by HUD but are not included as disbursements on this schedule. These loans are collateralized by mortgages on the property. Activity in the Community Development Block Grant revolving loan fund during 2023 is as follows:
Title: E 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

2023-001 –Reporting – Coronavirus State and Local Fiscal Recovery Funds ALN 21.027 U.S. Department of Treasury Criteria: The U.S. Department of Treasury established reporting requirement for local governments. These requirements established methods and timelines for reporting Coronavirus State and Local Fiscal Recovery Fund (SLFRF expenditures to the U.S. Department of Treasury. Condition: The County had multiple errors in the accuracy of the reporting of current period expenditures on the quarterly project and expenditure report as well as overreporting expenditures on the schedule of federal expenditures. Context: During our review of the quarterly project and expenditure reports, we noted the County had multiple errors in the accuracy of the reporting of the current period expenditures reported on the quarterly project and expenditure report. In addition, the County over reported the amount on the quarterly project and expenditure report and over reported the total amount of expenditures for SLFRF funds on the schedule of expenditures of federal awards by $1,080,973. 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 process in the Treasury reporting portal.
2023-001 –Reporting – Coronavirus State and Local Fiscal Recovery Funds ALN 21.027 U.S. Department of Treasury Criteria: The U.S. Department of Treasury established reporting requirement for local governments. These requirements established methods and timelines for reporting Coronavirus State and Local Fiscal Recovery Fund (SLFRF expenditures to the U.S. Department of Treasury. Condition: The County had multiple errors in the accuracy of the reporting of current period expenditures on the quarterly project and expenditure report as well as overreporting expenditures on the schedule of federal expenditures. Context: During our review of the quarterly project and expenditure reports, we noted the County had multiple errors in the accuracy of the reporting of the current period expenditures reported on the quarterly project and expenditure report. In addition, the County over reported the amount on the quarterly project and expenditure report and over reported the total amount of expenditures for SLFRF funds on the schedule of expenditures of federal awards by $1,080,973. 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 process in the Treasury reporting portal.
2023-001 –Reporting – Coronavirus State and Local Fiscal Recovery Funds ALN 21.027 U.S. Department of Treasury Criteria: The U.S. Department of Treasury established reporting requirement for local governments. These requirements established methods and timelines for reporting Coronavirus State and Local Fiscal Recovery Fund (SLFRF expenditures to the U.S. Department of Treasury. Condition: The County had multiple errors in the accuracy of the reporting of current period expenditures on the quarterly project and expenditure report as well as overreporting expenditures on the schedule of federal expenditures. Context: During our review of the quarterly project and expenditure reports, we noted the County had multiple errors in the accuracy of the reporting of the current period expenditures reported on the quarterly project and expenditure report. In addition, the County over reported the amount on the quarterly project and expenditure report and over reported the total amount of expenditures for SLFRF funds on the schedule of expenditures of federal awards by $1,080,973. 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 process in the Treasury reporting portal.
2023-001 –Reporting – Coronavirus State and Local Fiscal Recovery Funds ALN 21.027 U.S. Department of Treasury Criteria: The U.S. Department of Treasury established reporting requirement for local governments. These requirements established methods and timelines for reporting Coronavirus State and Local Fiscal Recovery Fund (SLFRF expenditures to the U.S. Department of Treasury. Condition: The County had multiple errors in the accuracy of the reporting of current period expenditures on the quarterly project and expenditure report as well as overreporting expenditures on the schedule of federal expenditures. Context: During our review of the quarterly project and expenditure reports, we noted the County had multiple errors in the accuracy of the reporting of the current period expenditures reported on the quarterly project and expenditure report. In addition, the County over reported the amount on the quarterly project and expenditure report and over reported the total amount of expenditures for SLFRF funds on the schedule of expenditures of federal awards by $1,080,973. 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 process in the Treasury reporting portal.
2023-001 –Reporting – Coronavirus State and Local Fiscal Recovery Funds ALN 21.027 U.S. Department of Treasury Criteria: The U.S. Department of Treasury established reporting requirement for local governments. These requirements established methods and timelines for reporting Coronavirus State and Local Fiscal Recovery Fund (SLFRF expenditures to the U.S. Department of Treasury. Condition: The County had multiple errors in the accuracy of the reporting of current period expenditures on the quarterly project and expenditure report as well as overreporting expenditures on the schedule of federal expenditures. Context: During our review of the quarterly project and expenditure reports, we noted the County had multiple errors in the accuracy of the reporting of the current period expenditures reported on the quarterly project and expenditure report. In addition, the County over reported the amount on the quarterly project and expenditure report and over reported the total amount of expenditures for SLFRF funds on the schedule of expenditures of federal awards by $1,080,973. 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 process in the Treasury reporting portal.
2023-001 –Reporting – Coronavirus State and Local Fiscal Recovery Funds ALN 21.027 U.S. Department of Treasury Criteria: The U.S. Department of Treasury established reporting requirement for local governments. These requirements established methods and timelines for reporting Coronavirus State and Local Fiscal Recovery Fund (SLFRF expenditures to the U.S. Department of Treasury. Condition: The County had multiple errors in the accuracy of the reporting of current period expenditures on the quarterly project and expenditure report as well as overreporting expenditures on the schedule of federal expenditures. Context: During our review of the quarterly project and expenditure reports, we noted the County had multiple errors in the accuracy of the reporting of the current period expenditures reported on the quarterly project and expenditure report. In addition, the County over reported the amount on the quarterly project and expenditure report and over reported the total amount of expenditures for SLFRF funds on the schedule of expenditures of federal awards by $1,080,973. 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 process in the Treasury reporting portal.