Audit 322165

FY End
2023-12-31
Total Expended
$13.19M
Findings
6
Programs
30
Organization: Knox County (NE)
Year: 2023 Accepted: 2024-09-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
499325 2023-001 Material Weakness - I
499326 2023-002 Material Weakness Yes I
499327 2023-002 Material Weakness Yes I
1075767 2023-001 Material Weakness - I
1075768 2023-002 Material Weakness Yes I
1075769 2023-002 Material Weakness Yes I

Programs

ALN Program Spent Major Findings
93.658 Foster Care_title IV-E $1.42M - 0
20.509 Formula Grants for Rural Areas and Tribal Transit Program $1.40M - 0
93.558 Temporary Assistance for Needy Families $1.24M - 0
20.205 Highway Planning and Construction $1.10M Yes 1
20.106 Airport Improvement Program $848,173 Yes 0
93.563 Child Support Enforcement $623,222 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $587,717 - 0
93.778 Medical Assistance Program $428,094 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $394,664 Yes 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $275,916 Yes 1
93.659 Adoption Assistance $262,826 - 0
17.258 Wia Adult Program $199,196 - 0
93.767 Children's Health Insurance Program $138,855 - 0
17.259 Wia Youth Activities $120,948 - 0
17.225 Unemployment Insurance $100,861 - 0
93.575 Child Care and Development Block Grant $64,130 - 0
17.278 Wia Dislocated Worker Formula Grants $62,048 - 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $58,247 - 0
93.556 Promoting Safe and Stable Families $52,849 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $52,037 - 0
21.032 Local Assistance and Tribal Consistency Fund $50,000 - 0
93.747 Elder Abuse Prevention Interventions Program $46,341 - 0
97.042 Emergency Management Performance Grants $44,432 - 0
93.667 Social Services Block Grant $41,258 - 0
16.575 Crime Victim Assistance $40,901 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $30,363 - 0
17.207 Employment Service/wagner-Peyser Funded Activities $13,332 - 0
93.472 Title IV-E Prevention and Family Services and Programs (a) $6,476 - 0
17.277 Workforce Investment Act (wia) National Emergency Grants $5,258 - 0
17.245 Trade Adjustment Assistance $2,131 - 0

Contacts

Name Title Type
DZJ4Q9BHKVK1 Sarah Thorne Auditee
7403936750 Thomas Dusek Auditor
No contacts on file

Notes to SEFA

Title: NOTE A – BASIS OF PRESENTATION Accounting Policies: SEFA prepared on a cash basis De Minimis Rate Used: N Rate Explanation: N/A The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of Knox 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: NOTE B – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES Accounting Policies: SEFA prepared on a cash basis De Minimis Rate Used: N Rate Explanation: N/A Expenditures reported on the Schedule are reported on the cash basis of accounting, except expenditures passed through Ohio Department of Transportation for the Formula Grants for Rural Areas Program (CFDA #20.509) are presented on an accrual basis. 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: NOTE C – INDIRECT COST RATE Accounting Policies: SEFA prepared on a cash basis De Minimis Rate Used: N Rate Explanation: N/A The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance.
Title: NOTE D - SUBRECIPIENTS Accounting Policies: SEFA prepared on a cash basis De Minimis Rate Used: N Rate Explanation: N/A The County passes certain federal awards received from Ohio Department of Jobs and Family Services 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, and that subrecipients achieve the award’s performance goals.
Title: NOTE E – COMMUNITY DEVELOPMENT BLOCK GRANT (CDBG) with REVOLVING LOAN CASH BALANCE Accounting Policies: SEFA prepared on a cash basis De Minimis Rate Used: N Rate Explanation: N/A The current cash balance on the County’s local program income account as of December 31, 2023 is $315,558.
Title: NOTE F - MATCHING REQUIREMENTS Accounting Policies: SEFA prepared on a cash basis De Minimis Rate Used: N Rate Explanation: N/A 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 G - TRANSFERS BETWEEN FEDERAL PROGRAMS Accounting Policies: SEFA prepared on a cash basis De Minimis Rate Used: N Rate Explanation: N/A During fiscal year 2023, the County made allowable transfers of $82,027.22 from the Temporary Assistance for   Needy Families (TANF) (93.558) program to the Social Services Block Grant (SSBG) (93.667) program. The Schedule shows the County spent approximately $1,236,439.56 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 2023 and the amount transferred to the Social Services Block Grant program.

Finding Details

2 CFR 1200.10 gives regulatory effect to 2 CFR 180.305 which provides that participants are prohibited from entering into a covered transaction with parties that are excluded or disqualified and 2 CFR 180.315 prohibits participants from entering into covered transactions with parties whose principals are excluded or disqualified, unless the Federal agency responsible for the transaction grants an exception under 2 CFR § 180.135, or unless the participants has obtained an exception under the disqualifying statute, Executive order, or regulation. 2 CFR 1200.10 gives regulatory effect to 2 CFR 180.200 identifies “covered transactions” as non-procurement or procurement transactions subject to the prohibitions of 2 CFR § 180 subpart B, and may be a transaction at the primary tier, between a Federal agency and a person; or at the lower tier, between a participant in a covered transaction and another person. Under 2 CFR § 180.220, procurement contracts for goods and services awarded by a participant in a non-procurement transaction (e.g., grant or cooperative agreement) are covered transactions if the contracts are expected to equal or exceed $25,000 or meet certain other specified criteria. All non-procurement transactions (i.e., sub-awards to subrecipients), irrespective of award amount, are considered covered transactions, unless exempt under 2 CFR § 180.215. 2 CFR 180.330 requires that before a participant enters into a covered transaction with another party, the participant must verify that the party the participant is seeking to do business with is not excluded or disqualified. This verification may be accomplished by checking SAM exclusions (https://sam.gov); collecting a certification from the entity, or adding a clause or condition to the covered transactions with that entity. Additionally, the County established the "Federal Procurement Policy" through Resolution # 2018-868 which states “sub awards and contract will not be permitted with parties that are debarred, suspended or otherwise excluded from or ineligible for participation in federal assistance programs or activities. Departmental Fiscal Supervisors are responsible for checking the Excluded Parties List System (EPLS) website, also known as the Debarred Contractors List prior to the approval of federal sub-awards or contacts of any amount or purchased of $50,000 or higher of federal awards.” The County did not have proper internal controls in place to help verify that all entities, with whom the County had entered into covered transactions, had not been suspended or debarred. During testing of nonpayroll disbursements for AL # 20.205 Highway Planning and Construction Program, we noted for all procurement transactions tested with a payment to a vendor of more than $25,000, there was no evidence the County checked the SAM exclusions, collected a certification from the entity, or added a clause or condition to the covered transaction with the vendor. Due to the deficient internal control structure, the required verification was not completed for the covered transaction in the AL # 20.205 Highway Planning and Construction Program during the fiscal year ended December 31, 2023. Failing to have the appropriate controls in place may result in vendors receiving federal funds that are suspended or debarred. Prior to contracting with vendors that will be paid with federal funds, the County should verify the vendor is not suspended or debarred by checking the SAM exclusions, collecting a certification from the vendor, or adding a clause or condition to the covered transaction with the vendor. In addition, the County should amend their policy to ensure the dollar threshold agrees to the CFR.
2 CFR 1201.1 gives regulatory effect to 2 CFR §200.320 that states that the non-Federal entity must have and use documented procurement procedures, consistent with the standards of 2 CFR §200.320, 200.317, 200.318, and 200.319. Furthermore, 2 CFR §200.320(a)(2) states that "small purchases are the acquisition of property or services, the aggregate dollar amount of which is higher than the micro-purchase threshold but does not exceed the simplified acquisition threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate by the non-Federal entity." Additionally, the County established the "Federal Procurement Policy" through Resolution # 2018-868 which states "for all procurements of $15,000 and greater, the purchaser should obtain documentation verifying that the purchase price is fair and reasonable. Price analysis and cost analysis are the two primary techniques used to accomplish this purpose. 1. Price Analysis: Comparison of prices of multiple bids or information from other sources, such as established catalog or market prices or prices for similar past purchases. 2. Cost Analysis: Evaluation of the separate elements (e.g., labor, materials, etc.) that make up a contractor's total cost proposal or price (for both new contracts and modifications) to determine if they are allowable, directly related to. the requirement and reasonable for the value received. A price analysis should always be performed and documented; under certain circumstances, while a cost analysis also needs to be performed and documented (cost analysis is always required if payment is based in whole or in part on reimbursement of costs, and it may also be required for other contract types when there is not adequate price competition). The County did not follow their established policy which results in errors noted during testing of federal procurement requirements. During testing of the 2023 AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds, for one of six procurements selected for testing (17%), which exceeded the micro-purchase threshold but did not exceed the small purchase threshold, the County could not provide documentation supporting that they obtained price or rate quotations from an adequate number of qualified sources. Failure to follow the County's internal policies and failure to adhere to the requirements of 2 CFR §200.320 could result in unallowable purchases, misuse of public funds, or questioned costs related to federal monies. The County should ensure they are following both their internal policies and Federal formal procurement methods when purchases fall within the small purchase threshold.
2 CFR 1201.1 gives regulatory effect to 2 CFR §200.320 that states that the non-Federal entity must have and use documented procurement procedures, consistent with the standards of 2 CFR §200.320, 200.317, 200.318, and 200.319. Furthermore, 2 CFR §200.320(a)(2) states that "small purchases are the acquisition of property or services, the aggregate dollar amount of which is higher than the micro-purchase threshold but does not exceed the simplified acquisition threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate by the non-Federal entity." Additionally, the County established the "Federal Procurement Policy" through Resolution # 2018-868 which states "for all procurements of $15,000 and greater, the purchaser should obtain documentation verifying that the purchase price is fair and reasonable. Price analysis and cost analysis are the two primary techniques used to accomplish this purpose. 1. Price Analysis: Comparison of prices of multiple bids or information from other sources, such as established catalog or market prices or prices for similar past purchases. 2. Cost Analysis: Evaluation of the separate elements (e.g., labor, materials, etc.) that make up a contractor's total cost proposal or price (for both new contracts and modifications) to determine if they are allowable, directly related to. the requirement and reasonable for the value received. A price analysis should always be performed and documented; under certain circumstances, while a cost analysis also needs to be performed and documented (cost analysis is always required if payment is based in whole or in part on reimbursement of costs, and it may also be required for other contract types when there is not adequate price competition). The County did not follow their established policy which results in errors noted during testing of federal procurement requirements. During testing of the 2023 AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds, for one of six procurements selected for testing (17%), which exceeded the micro-purchase threshold but did not exceed the small purchase threshold, the County could not provide documentation supporting that they obtained price or rate quotations from an adequate number of qualified sources. Failure to follow the County's internal policies and failure to adhere to the requirements of 2 CFR §200.320 could result in unallowable purchases, misuse of public funds, or questioned costs related to federal monies. The County should ensure they are following both their internal policies and Federal formal procurement methods when purchases fall within the small purchase threshold.
2 CFR 1200.10 gives regulatory effect to 2 CFR 180.305 which provides that participants are prohibited from entering into a covered transaction with parties that are excluded or disqualified and 2 CFR 180.315 prohibits participants from entering into covered transactions with parties whose principals are excluded or disqualified, unless the Federal agency responsible for the transaction grants an exception under 2 CFR § 180.135, or unless the participants has obtained an exception under the disqualifying statute, Executive order, or regulation. 2 CFR 1200.10 gives regulatory effect to 2 CFR 180.200 identifies “covered transactions” as non-procurement or procurement transactions subject to the prohibitions of 2 CFR § 180 subpart B, and may be a transaction at the primary tier, between a Federal agency and a person; or at the lower tier, between a participant in a covered transaction and another person. Under 2 CFR § 180.220, procurement contracts for goods and services awarded by a participant in a non-procurement transaction (e.g., grant or cooperative agreement) are covered transactions if the contracts are expected to equal or exceed $25,000 or meet certain other specified criteria. All non-procurement transactions (i.e., sub-awards to subrecipients), irrespective of award amount, are considered covered transactions, unless exempt under 2 CFR § 180.215. 2 CFR 180.330 requires that before a participant enters into a covered transaction with another party, the participant must verify that the party the participant is seeking to do business with is not excluded or disqualified. This verification may be accomplished by checking SAM exclusions (https://sam.gov); collecting a certification from the entity, or adding a clause or condition to the covered transactions with that entity. Additionally, the County established the "Federal Procurement Policy" through Resolution # 2018-868 which states “sub awards and contract will not be permitted with parties that are debarred, suspended or otherwise excluded from or ineligible for participation in federal assistance programs or activities. Departmental Fiscal Supervisors are responsible for checking the Excluded Parties List System (EPLS) website, also known as the Debarred Contractors List prior to the approval of federal sub-awards or contacts of any amount or purchased of $50,000 or higher of federal awards.” The County did not have proper internal controls in place to help verify that all entities, with whom the County had entered into covered transactions, had not been suspended or debarred. During testing of nonpayroll disbursements for AL # 20.205 Highway Planning and Construction Program, we noted for all procurement transactions tested with a payment to a vendor of more than $25,000, there was no evidence the County checked the SAM exclusions, collected a certification from the entity, or added a clause or condition to the covered transaction with the vendor. Due to the deficient internal control structure, the required verification was not completed for the covered transaction in the AL # 20.205 Highway Planning and Construction Program during the fiscal year ended December 31, 2023. Failing to have the appropriate controls in place may result in vendors receiving federal funds that are suspended or debarred. Prior to contracting with vendors that will be paid with federal funds, the County should verify the vendor is not suspended or debarred by checking the SAM exclusions, collecting a certification from the vendor, or adding a clause or condition to the covered transaction with the vendor. In addition, the County should amend their policy to ensure the dollar threshold agrees to the CFR.
2 CFR 1201.1 gives regulatory effect to 2 CFR §200.320 that states that the non-Federal entity must have and use documented procurement procedures, consistent with the standards of 2 CFR §200.320, 200.317, 200.318, and 200.319. Furthermore, 2 CFR §200.320(a)(2) states that "small purchases are the acquisition of property or services, the aggregate dollar amount of which is higher than the micro-purchase threshold but does not exceed the simplified acquisition threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate by the non-Federal entity." Additionally, the County established the "Federal Procurement Policy" through Resolution # 2018-868 which states "for all procurements of $15,000 and greater, the purchaser should obtain documentation verifying that the purchase price is fair and reasonable. Price analysis and cost analysis are the two primary techniques used to accomplish this purpose. 1. Price Analysis: Comparison of prices of multiple bids or information from other sources, such as established catalog or market prices or prices for similar past purchases. 2. Cost Analysis: Evaluation of the separate elements (e.g., labor, materials, etc.) that make up a contractor's total cost proposal or price (for both new contracts and modifications) to determine if they are allowable, directly related to. the requirement and reasonable for the value received. A price analysis should always be performed and documented; under certain circumstances, while a cost analysis also needs to be performed and documented (cost analysis is always required if payment is based in whole or in part on reimbursement of costs, and it may also be required for other contract types when there is not adequate price competition). The County did not follow their established policy which results in errors noted during testing of federal procurement requirements. During testing of the 2023 AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds, for one of six procurements selected for testing (17%), which exceeded the micro-purchase threshold but did not exceed the small purchase threshold, the County could not provide documentation supporting that they obtained price or rate quotations from an adequate number of qualified sources. Failure to follow the County's internal policies and failure to adhere to the requirements of 2 CFR §200.320 could result in unallowable purchases, misuse of public funds, or questioned costs related to federal monies. The County should ensure they are following both their internal policies and Federal formal procurement methods when purchases fall within the small purchase threshold.
2 CFR 1201.1 gives regulatory effect to 2 CFR §200.320 that states that the non-Federal entity must have and use documented procurement procedures, consistent with the standards of 2 CFR §200.320, 200.317, 200.318, and 200.319. Furthermore, 2 CFR §200.320(a)(2) states that "small purchases are the acquisition of property or services, the aggregate dollar amount of which is higher than the micro-purchase threshold but does not exceed the simplified acquisition threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate by the non-Federal entity." Additionally, the County established the "Federal Procurement Policy" through Resolution # 2018-868 which states "for all procurements of $15,000 and greater, the purchaser should obtain documentation verifying that the purchase price is fair and reasonable. Price analysis and cost analysis are the two primary techniques used to accomplish this purpose. 1. Price Analysis: Comparison of prices of multiple bids or information from other sources, such as established catalog or market prices or prices for similar past purchases. 2. Cost Analysis: Evaluation of the separate elements (e.g., labor, materials, etc.) that make up a contractor's total cost proposal or price (for both new contracts and modifications) to determine if they are allowable, directly related to. the requirement and reasonable for the value received. A price analysis should always be performed and documented; under certain circumstances, while a cost analysis also needs to be performed and documented (cost analysis is always required if payment is based in whole or in part on reimbursement of costs, and it may also be required for other contract types when there is not adequate price competition). The County did not follow their established policy which results in errors noted during testing of federal procurement requirements. During testing of the 2023 AL # 21.027 Coronavirus State and Local Fiscal Recovery Funds, for one of six procurements selected for testing (17%), which exceeded the micro-purchase threshold but did not exceed the small purchase threshold, the County could not provide documentation supporting that they obtained price or rate quotations from an adequate number of qualified sources. Failure to follow the County's internal policies and failure to adhere to the requirements of 2 CFR §200.320 could result in unallowable purchases, misuse of public funds, or questioned costs related to federal monies. The County should ensure they are following both their internal policies and Federal formal procurement methods when purchases fall within the small purchase threshold.