Audit 44058

FY End
2022-12-31
Total Expended
$17.38M
Findings
2
Programs
27
Organization: Columbiana County (OH)
Year: 2022 Accepted: 2023-07-05

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
39733 2022-001 Material Weakness Yes L
616175 2022-001 Material Weakness Yes L

Programs

ALN Program Spent Major Findings
93.658 Foster Care_title IV-E $1.54M Yes 0
93.778 Medical Assistance Program $1.41M - 0
93.563 Child Support Enforcement $1.34M Yes 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $610,413 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $535,498 - 0
20.205 Highway Planning and Construction $520,400 Yes 0
93.788 Opioid Str $393,647 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $328,397 - 0
93.767 Children's Health Insurance Program $281,887 - 0
93.659 Adoption Assistance $237,186 - 0
14.239 Home Investment Partnerships Program $231,031 - 0
84.181 Special Education-Grants for Infants and Families $153,203 - 0
93.958 Block Grants for Community Mental Health Services $120,732 - 0
93.575 Child Care and Development Block Grant $104,433 - 0
97.042 Emergency Management Performance Grants $104,037 - 0
93.556 Promoting Safe and Stable Families $76,638 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $68,350 Yes 0
93.667 Social Services Block Grant $67,340 - 0
16.575 Crime Victim Assistance $42,255 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $41,388 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $35,791 - 0
93.747 Elder Abuse Prevention Interventions Program $24,981 - 0
93.558 Temporary Assistance for Needy Families $18,661 - 0
10.553 School Breakfast Program $17,114 - 0
10.555 National School Lunch Program $9,992 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $2,426 - 0
84.027 Special Education_grants to States $2,105 - 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 (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.
Title: 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 2022 is as follows:Beginning loans receivable balance as of January 1, 2022 $264,287Loans Disbursed 0Loans Repaid 0Write-offs and Adjustments (264,287)Ending loans receivable balance as of December 31, 2022 $0Cash balance on hand as of December 31, 2022 $46,234Administrative costs expended during 2022 0Interest received 0The table above reports the gross receivable. Of the loans receivable as of December 31, 2022, Columbiana County estimates $264,287 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

2022-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 requirements 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 subrecipients, subawards, and accuracy in the amount reported on the quarterly project and expenditure report. Context: During our review of the quarterly project and expenditure report, we noted the County incorrectly reported 16 beneficiaries as subrecipients and 21 subawards that were project expenditures paid to vendors of the County. In addition, the County over reported $1,403,460 in expenditures on the quarterly project and expenditure report. Effect: The County was not in compliance with reporting requirements in 2022. Cause: Lack of sufficient internal controls over the reporting requirements of the SLFRF program. Recommendation: We recommend the County improve controls over reporting requirements associated with this program. This includes obtaining a better understanding of the reporting processes in the Treasury reporting portal.
2022-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 requirements 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 subrecipients, subawards, and accuracy in the amount reported on the quarterly project and expenditure report. Context: During our review of the quarterly project and expenditure report, we noted the County incorrectly reported 16 beneficiaries as subrecipients and 21 subawards that were project expenditures paid to vendors of the County. In addition, the County over reported $1,403,460 in expenditures on the quarterly project and expenditure report. Effect: The County was not in compliance with reporting requirements in 2022. Cause: Lack of sufficient internal controls over the reporting requirements of the SLFRF program. Recommendation: We recommend the County improve controls over reporting requirements associated with this program. This includes obtaining a better understanding of the reporting processes in the Treasury reporting portal.