Audit 358921

FY End
2024-12-31
Total Expended
$14.42M
Findings
4
Programs
29
Organization: Columbiana County (OH)
Year: 2024 Accepted: 2025-06-16

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
565029 2024-001 Material Weakness Yes L
565030 2024-001 Material Weakness Yes L
1141471 2024-001 Material Weakness Yes L
1141472 2024-001 Material Weakness Yes L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $3.23M Yes 1
93.778 Medical Assistance Program $1.54M Yes 0
93.563 Child Support Services $1.34M Yes 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $681,101 - 0
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $605,379 - 0
93.658 Foster Care Title IV-E $507,794 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $473,197 - 0
93.659 Adoption Assistance $331,916 - 0
93.767 Children's Health Insurance Program $290,829 - 0
93.788 Opioid Str $273,133 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $267,741 - 0
84.181 Special Education-Grants for Infants and Families $193,510 - 0
14.239 Home Investment Partnerships Program $172,160 - 0
93.575 Child Care and Development Block Grant $148,503 - 0
84.425 Education Stabilization Fund $139,999 - 0
93.958 Block Grants for Community Mental Health Services $95,203 - 0
97.042 Emergency Management Performance Grants $82,709 - 0
93.667 Social Services Block Grant $79,019 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $60,585 - 0
93.556 Marylee Allen Promoting Safe and Stable Families Program $51,684 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $49,000 - 0
84.027 Special Education Grants to States $25,866 - 0
93.558 Temporary Assistance for Needy Families $23,235 - 0
93.747 Elder Abuse Prevention Interventions Program $22,357 - 0
16.575 Crime Victim Assistance $16,935 - 0
10.555 National School Lunch Program $14,570 - 0
10.553 School Breakfast Program $9,238 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $8,158 - 0
20.205 Highway Planning and Construction $4,106 - 0

Contacts

Name Title Type
MLK4HCUR8LS8 Nancy Milliken Auditee
3304249515 Brian Mosier 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 Columbiana County, Ohio (the County) under programs of the federal government for the year ended December 31, 2024. 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: Community Development Block Grant (CDBG) and Home Investment Partnerships Program (HOME) Grant Programs 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 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 2024 is as follows: Beginning loans receivable balance as of January 1, 2024 $264,287 Loans Disbursed 0 Loans Repaid 0 Write-offs and Adjustments (63,618) Ending loans receivable balance as of December 31, 2024 $200,669 Cash balance on hand as of December 31, 2024 $9,786 Administrative costs expended during 2024 0 Interest received 0 The table above reports the gross receivable. Of the loans receivable as of December 31, 2024, Columbiana County estimates $200,669 to be uncollectible.
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

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 obligations and current period expenditures on the quarterly project and expenditure reports 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 the following errors in the accuracy of the reporting of the current period expenditures reported on the quarterly project and expenditure report. • Two expenditures totaling $155,508 were not reported as a current period obligation or current period expenditure on the quarterly project and expenditure reports. • Thirty-eight expenditures totaling $932,433 were properly reported as obligated but not reported as current period expenditures on the quarterly project and expenditure reports. • Five expenditures totaling $1,397,823 were incorrectly reported as current period expenditures when they should have just been current period obligations on the quarterly project and expenditure reports. • One expenditure totaling $28,760 was properly reported as a current period obligation but not reported as a current period expenditure on the quarterly project and expenditure reports. Effect: The County was not in compliance with CSLFRF reporting requirements in 2024. 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.
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 obligations and current period expenditures on the quarterly project and expenditure reports 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 the following errors in the accuracy of the reporting of the current period expenditures reported on the quarterly project and expenditure report. • Two expenditures totaling $155,508 were not reported as a current period obligation or current period expenditure on the quarterly project and expenditure reports. • Thirty-eight expenditures totaling $932,433 were properly reported as obligated but not reported as current period expenditures on the quarterly project and expenditure reports. • Five expenditures totaling $1,397,823 were incorrectly reported as current period expenditures when they should have just been current period obligations on the quarterly project and expenditure reports. • One expenditure totaling $28,760 was properly reported as a current period obligation but not reported as a current period expenditure on the quarterly project and expenditure reports. Effect: The County was not in compliance with CSLFRF reporting requirements in 2024. 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.
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 obligations and current period expenditures on the quarterly project and expenditure reports 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 the following errors in the accuracy of the reporting of the current period expenditures reported on the quarterly project and expenditure report. • Two expenditures totaling $155,508 were not reported as a current period obligation or current period expenditure on the quarterly project and expenditure reports. • Thirty-eight expenditures totaling $932,433 were properly reported as obligated but not reported as current period expenditures on the quarterly project and expenditure reports. • Five expenditures totaling $1,397,823 were incorrectly reported as current period expenditures when they should have just been current period obligations on the quarterly project and expenditure reports. • One expenditure totaling $28,760 was properly reported as a current period obligation but not reported as a current period expenditure on the quarterly project and expenditure reports. Effect: The County was not in compliance with CSLFRF reporting requirements in 2024. 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.
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 obligations and current period expenditures on the quarterly project and expenditure reports 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 the following errors in the accuracy of the reporting of the current period expenditures reported on the quarterly project and expenditure report. • Two expenditures totaling $155,508 were not reported as a current period obligation or current period expenditure on the quarterly project and expenditure reports. • Thirty-eight expenditures totaling $932,433 were properly reported as obligated but not reported as current period expenditures on the quarterly project and expenditure reports. • Five expenditures totaling $1,397,823 were incorrectly reported as current period expenditures when they should have just been current period obligations on the quarterly project and expenditure reports. • One expenditure totaling $28,760 was properly reported as a current period obligation but not reported as a current period expenditure on the quarterly project and expenditure reports. Effect: The County was not in compliance with CSLFRF reporting requirements in 2024. 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.