Audit 4513

FY End
2023-06-30
Total Expended
$6.49M
Findings
4
Programs
7
Organization: Lincoln County, Nebraska (NE)
Year: 2023 Accepted: 2023-11-29

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
2675 2023-002 - Yes L
2676 2023-003 Significant Deficiency - I
579117 2023-002 - Yes L
579118 2023-003 Significant Deficiency - I

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $5.68M Yes 2
93.563 Child Support Enforcement $350,846 - 0
97.067 Homeland Security Grant Program $251,312 - 0
16.575 Crime Victim Assistance $63,013 - 0
20.600 State and Community Highway Safety $31,960 - 0
20.616 National Priority Safety Programs $26,550 - 0
97.042 Emergency Management Performance Grants $19,513 - 0

Contacts

Name Title Type
LAC9VJEC61B4 Rebecca Rossell Auditee
3085344350 Rachel Wittler 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 the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Lincoln County has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: Lincoln County has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of Federal awards (Schedule) includes the Federal award activity of Lincoln County (County) under programs of the Federal government for the year ended June 30, 2023. The information in this Schedule is presented 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 Lincoln County, it is not intended to and does not present the financial position or changes in net assets of the County. The County’s reporting entity is defined in Note 1.A. to the County’s financial statements. Federal awards received directly from Federal agencies, as well as those passed through other government agencies, are included in the Schedule. Unless otherwise noted on the Schedule, all programs are received directly from the respective Federal agency.
Title: Summary of Significant Accounting Policies 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 the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Lincoln County has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: Lincoln County has elected not to use the 10 percent de minimis indirect cost rate 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 the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Lincoln County has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance.

Finding Details

Program - AL #21.027 – COVID-19 Coronavirus State and Local Fiscal Recovery Funds - Reporting Grant Number & Year - SLFRP2949, March 3, 2021, through December 31, 2024 Federal Grantor Agency - U.S. Department of the Treasury Criteria - Title 2 of the U.S. Code of Federal Regulations (CFR) § 200.303 (January 1, 2023) states the following, in relevant part: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ‘‘Standards for Internal Control in the Federal Government’’ issued by the Comptroller General of the United States or the ‘‘Internal Control Integrated Framework’’, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). The U.S. Department of the Treasury adopted the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards in 2 CFR § 1000.10 (January 1, 2023), which states the following: Except for the deviations set forth elsewhere in this Part, the Department of the Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, set forth at 2 CFR part 200. The U.S. Department of the Treasury issued “Compliance and Reporting Guidance” and frequently asked questions, which specify the reporting requirements related to Coronavirus State and Local Fiscal Recovery Funds. Such guidance required the completion of a Project and Expenditure Report by April 30, 2023. A good internal control plan includes establishing effective internal controls through written policies and procedures to ensure Federal reporting requirements are completed accurately. Such plan should include, among other things, appropriate training on Federal reporting requirements and require a documented, detailed review of each report to be completed by a knowledgeable individual, who did not prepare the report, prior to submission. Condition - Lincoln County did not implement effective internal controls to ensure that the reporting requirements of the Coronavirus State and Local Fiscal Recovery Funds were completed accurately. Consequently, the Project and Expenditure Report submitted on April 7, 2023, did not contain accurate information. Repeat Finding - Yes Questioned Costs - None Statistical Sample - No Context - Lincoln County reported Current Period Expenditures of $5,355,379; however, this amount did not include an expenditure of $253,681 made on November 28, 2022. Additionally, all expenditures were reported under one project using Project Expenditure Category of Revenue Replacement and Project Expenditure Subcategory as Provision of Government Services. Based on the expenditures made by Lincoln County using Coronavirus State and Local Fiscal Recovery Funds, it appears more appropriate for the County to have reported two projects. The first project provided $189,305 to local non-profits to support their food pantry operations. As such, it appears a Project Category of Negative Economic Impacts, and a project subcategory of Aid to Nonprofit Organizations would be more appropriate. The second project included expenses totaling $5,419,755 and was correctly reported using a Project Category of Revenue Replacement and project subcategory of Provision of Government Services. The Project Description on the Project and Expenditure Report described the County's efforts to provide food assistance. As only $189,305, or 3.5% of the reported expenditures, was paid to non-profit entities, it appears that a Project Description outlining how that majority of the funds were spent would be more appropriate. Cause - Lack of procedures and knowledge relating to Federal reporting requirements. Effect - Inaccurate information was reported to the U.S. Department of the Treasury on the April 2023 Project and Expenditure report. Additionally, the County is not in compliance with the reporting requirements set by the U.S. Department of the Treasury. Recommendation - We recommend Lincoln County establish written policies and procedures to ensure Federal reporting requirements are completed accurately. Such procedures should include, among other things, appropriate training on Federal reporting requirements and a documented review by a knowledgeable individual who was not involved in the preparation of the report. View of Officials - West Central NE Development District will need to collect reports from various offices (County Clerk & County Treasurer) to verify all expenditures and disbursements match and perform their own calculations.
Program - AL #21.027 – COVID-19 Coronavirus State and Local Fiscal Recovery Funds – Suspension and Debarment Grant Number & Year - SLFRP2949, March 3, 2021, through December 31, 2024 Federal Grantor Agency - U.S. Department of the Treasury Criteria - Title 2 of the U.S. Code of Federal Regulations (CFR) § 200.303 (January 1, 2023) states the following, in relevant part: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). 2 CFR § 200.214 (January 1, 2023) states the following: Non-Federal entities are subject to the non-procurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, 2 CFR part 180. The regulations in 2 CFR part 180 restrict awards, subawards, and contracts with certain parties that are debarred, suspended, or otherwise excluded from or ineligible for participation in Federal assistance programs or activities. The U.S. Department of the Treasury adopted the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards in 2 CFR § 1000.10 (January 1, 2023), which states the following: Except for the deviations set forth elsewhere in this Part, the Department of the Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, set forth at 2 CFR part 200. 2 CFR § 180.300 (January 1, 2023) requires non-Federal entities to verify that an entity is not excluded or disqualified prior to entering into a covered transaction by “(a) Checking SAM Exclusions; or (b) Collecting a certification from that . . . [entity]; or (c) Adding a clause or condition to the covered transaction with that . . . [entity].” A good internal control plan requires the County to have proper procedures in place to verify that all contractors paid with Federal funds are not suspended, debarred, or otherwise excluded from or ineligible for participation in Federal programs or activities. Condition - Lincoln County had controls in place to ensure that suspension and debarment requirements were followed and adequately documented; however, the County did not follow these controls for every vendor. We noted the County used Coronavirus State and Local Fiscal Recovery Funds to pay seven vendors over $25,000 each, totaling $5,540,320, during the fiscal year ended June 30, 2023. The County failed to ensure that these vendors, with whom the County regularly does business, were not excluded or disqualified prior to entering into these covered transactions. We reviewed SAM.gov, and noted that none of these vendors were suspended, debarred, or otherwise excluded from participation in Federal programs or activities as of the date testing was performed. Repeat Finding - No Questioned Costs - None Statistical Sample - No Context - The following table provides details of the covered transactions noted: Cause - Lack of procedures and knowledge regarding suspension and debarment requirements. Effect - Without adequate procedures to ensure all contractors are not suspended, debarred, or otherwise excluded from or ineligible for participation in Federal programs or activities, there is an increased risk for the misuse of Federal funds and noncompliance with Federal regulations, leading to possible Federal sanctions. Recommendation - We recommend the County implement procedures to ensure, prior to entering into a covered transaction, that all contractors are not suspended, debarred, or otherwise excluded from or ineligible for participation in Federal programs or activities, and those procedures are adequately documented. View of Officials - Lincoln County (submitting Department and County Clerk’s Office) will verify through Sam.Gov that all claims submitted for payment using federal funds are not suspended, debarred, or excluded from receiving federal dollars prior to payment of the claim.
Program - AL #21.027 – COVID-19 Coronavirus State and Local Fiscal Recovery Funds - Reporting Grant Number & Year - SLFRP2949, March 3, 2021, through December 31, 2024 Federal Grantor Agency - U.S. Department of the Treasury Criteria - Title 2 of the U.S. Code of Federal Regulations (CFR) § 200.303 (January 1, 2023) states the following, in relevant part: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ‘‘Standards for Internal Control in the Federal Government’’ issued by the Comptroller General of the United States or the ‘‘Internal Control Integrated Framework’’, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). The U.S. Department of the Treasury adopted the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards in 2 CFR § 1000.10 (January 1, 2023), which states the following: Except for the deviations set forth elsewhere in this Part, the Department of the Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, set forth at 2 CFR part 200. The U.S. Department of the Treasury issued “Compliance and Reporting Guidance” and frequently asked questions, which specify the reporting requirements related to Coronavirus State and Local Fiscal Recovery Funds. Such guidance required the completion of a Project and Expenditure Report by April 30, 2023. A good internal control plan includes establishing effective internal controls through written policies and procedures to ensure Federal reporting requirements are completed accurately. Such plan should include, among other things, appropriate training on Federal reporting requirements and require a documented, detailed review of each report to be completed by a knowledgeable individual, who did not prepare the report, prior to submission. Condition - Lincoln County did not implement effective internal controls to ensure that the reporting requirements of the Coronavirus State and Local Fiscal Recovery Funds were completed accurately. Consequently, the Project and Expenditure Report submitted on April 7, 2023, did not contain accurate information. Repeat Finding - Yes Questioned Costs - None Statistical Sample - No Context - Lincoln County reported Current Period Expenditures of $5,355,379; however, this amount did not include an expenditure of $253,681 made on November 28, 2022. Additionally, all expenditures were reported under one project using Project Expenditure Category of Revenue Replacement and Project Expenditure Subcategory as Provision of Government Services. Based on the expenditures made by Lincoln County using Coronavirus State and Local Fiscal Recovery Funds, it appears more appropriate for the County to have reported two projects. The first project provided $189,305 to local non-profits to support their food pantry operations. As such, it appears a Project Category of Negative Economic Impacts, and a project subcategory of Aid to Nonprofit Organizations would be more appropriate. The second project included expenses totaling $5,419,755 and was correctly reported using a Project Category of Revenue Replacement and project subcategory of Provision of Government Services. The Project Description on the Project and Expenditure Report described the County's efforts to provide food assistance. As only $189,305, or 3.5% of the reported expenditures, was paid to non-profit entities, it appears that a Project Description outlining how that majority of the funds were spent would be more appropriate. Cause - Lack of procedures and knowledge relating to Federal reporting requirements. Effect - Inaccurate information was reported to the U.S. Department of the Treasury on the April 2023 Project and Expenditure report. Additionally, the County is not in compliance with the reporting requirements set by the U.S. Department of the Treasury. Recommendation - We recommend Lincoln County establish written policies and procedures to ensure Federal reporting requirements are completed accurately. Such procedures should include, among other things, appropriate training on Federal reporting requirements and a documented review by a knowledgeable individual who was not involved in the preparation of the report. View of Officials - West Central NE Development District will need to collect reports from various offices (County Clerk & County Treasurer) to verify all expenditures and disbursements match and perform their own calculations.
Program - AL #21.027 – COVID-19 Coronavirus State and Local Fiscal Recovery Funds – Suspension and Debarment Grant Number & Year - SLFRP2949, March 3, 2021, through December 31, 2024 Federal Grantor Agency - U.S. Department of the Treasury Criteria - Title 2 of the U.S. Code of Federal Regulations (CFR) § 200.303 (January 1, 2023) states the following, in relevant part: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). 2 CFR § 200.214 (January 1, 2023) states the following: Non-Federal entities are subject to the non-procurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, 2 CFR part 180. The regulations in 2 CFR part 180 restrict awards, subawards, and contracts with certain parties that are debarred, suspended, or otherwise excluded from or ineligible for participation in Federal assistance programs or activities. The U.S. Department of the Treasury adopted the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards in 2 CFR § 1000.10 (January 1, 2023), which states the following: Except for the deviations set forth elsewhere in this Part, the Department of the Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, set forth at 2 CFR part 200. 2 CFR § 180.300 (January 1, 2023) requires non-Federal entities to verify that an entity is not excluded or disqualified prior to entering into a covered transaction by “(a) Checking SAM Exclusions; or (b) Collecting a certification from that . . . [entity]; or (c) Adding a clause or condition to the covered transaction with that . . . [entity].” A good internal control plan requires the County to have proper procedures in place to verify that all contractors paid with Federal funds are not suspended, debarred, or otherwise excluded from or ineligible for participation in Federal programs or activities. Condition - Lincoln County had controls in place to ensure that suspension and debarment requirements were followed and adequately documented; however, the County did not follow these controls for every vendor. We noted the County used Coronavirus State and Local Fiscal Recovery Funds to pay seven vendors over $25,000 each, totaling $5,540,320, during the fiscal year ended June 30, 2023. The County failed to ensure that these vendors, with whom the County regularly does business, were not excluded or disqualified prior to entering into these covered transactions. We reviewed SAM.gov, and noted that none of these vendors were suspended, debarred, or otherwise excluded from participation in Federal programs or activities as of the date testing was performed. Repeat Finding - No Questioned Costs - None Statistical Sample - No Context - The following table provides details of the covered transactions noted: Cause - Lack of procedures and knowledge regarding suspension and debarment requirements. Effect - Without adequate procedures to ensure all contractors are not suspended, debarred, or otherwise excluded from or ineligible for participation in Federal programs or activities, there is an increased risk for the misuse of Federal funds and noncompliance with Federal regulations, leading to possible Federal sanctions. Recommendation - We recommend the County implement procedures to ensure, prior to entering into a covered transaction, that all contractors are not suspended, debarred, or otherwise excluded from or ineligible for participation in Federal programs or activities, and those procedures are adequately documented. View of Officials - Lincoln County (submitting Department and County Clerk’s Office) will verify through Sam.Gov that all claims submitted for payment using federal funds are not suspended, debarred, or excluded from receiving federal dollars prior to payment of the claim.