Audit 304432

FY End
2023-09-30
Total Expended
$73.54M
Findings
24
Programs
42
Organization: Collier County (FL)
Year: 2023 Accepted: 2024-04-24

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
394550 2023-001 Material Weakness - F
394551 2023-001 Material Weakness - F
394552 2023-001 Material Weakness - F
394553 2023-001 Material Weakness - F
394554 2023-001 Material Weakness - F
394555 2023-001 Material Weakness - F
394556 2023-001 Material Weakness - F
394557 2023-001 Material Weakness - F
394558 2023-001 Material Weakness - F
394559 2023-002 Material Weakness - N
394560 2023-003 Significant Deficiency - L
394561 2023-003 Significant Deficiency - L
970992 2023-001 Material Weakness - F
970993 2023-001 Material Weakness - F
970994 2023-001 Material Weakness - F
970995 2023-001 Material Weakness - F
970996 2023-001 Material Weakness - F
970997 2023-001 Material Weakness - F
970998 2023-001 Material Weakness - F
970999 2023-001 Material Weakness - F
971000 2023-001 Material Weakness - F
971001 2023-002 Material Weakness - N
971002 2023-003 Significant Deficiency - L
971003 2023-003 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $23.79M Yes 0
21.027 Covid-19-Coronavirus State and Local Fiscal Recovery Funds $23.46M Yes 0
21.023 Covid-19-Emergency Rental Assistance Program $3.08M Yes 0
14.218 Community Development Block Grants/entitlement Grants $3.02M Yes 1
20.507 Federal Transit_formula Grants $2.72M - 0
20.933 National Infrastructure Investments $2.57M Yes 1
14.218 Covid-19-Community Development Block Grants/entitlement Grants $2.01M Yes 1
15.226 Payments in Lieu of Taxes $1.61M - 0
20.507 Covid-19-Federal Transit_formula Grants $1.52M - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $658,940 - 0
20.509 Formula Grants for Rural Areas and Tribal Transit Program $504,624 - 0
14.239 Home Investment Partnerships Program $452,471 - 0
14.231 Emergency Solutions Grant Program $378,278 - 0
20.106 Airport Improvement Program $198,004 - 0
16.710 Public Safety Partnership and Community Policing Grants $196,769 - 0
16.575 Crime Victim Assistance $187,500 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $181,814 - 0
95.001 High Intensity Drug Trafficking Areas Program $146,181 - 0
90.404 2018 Hava Election Security Grants $118,610 - 0
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $115,421 - 0
14.231 Covid-19-Emergency Solutions Grant Program $113,465 - 0
93.044 Covid-19-Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $105,972 - 0
20.600 State and Community Highway Safety $96,382 - 0
97.042 Emergency Management Performance Grants $93,964 - 0
94.002 Retired and Senior Volunteer Program $84,624 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $78,188 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $72,761 - 0
87.052 Gulf Coast Ecosystem Restoration Council Oil Spill Impact Program $65,828 - 0
93.568 Covid-19-Low-Income Home Energy Assistance $63,812 - 0
16.585 Drug Court Discretionary Grant Program $58,500 - 0
93.053 Nutrition Services Incentive Program $40,299 - 0
93.568 Low-Income Home Energy Assistance $39,868 - 0
20.106 Covid-19-Airport Improvement Program $35,228 - 0
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $34,541 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $34,174 - 0
21.032 Covid-19-Local Assistance and Tribal Consistency Fund $21,934 - 0
97.067 Homeland Security Grant Program $21,073 - 0
14.239 Covid-19-Home Investment Partnerships Program $15,560 - 0
93.630 Developmental Disabilities Basic Support and Advocacy Grants $13,978 - 0
97.046 Fire Management Assistance Grant $11,689 - 0
93.563 Child Support Enforcement $3,047 - 0
20.205 Highway Planning and Construction $88 Yes 1

Contacts

Name Title Type
JWKJKYRPLLU6 Kelly Jones Auditee
2392527864 Christopher Kessler Auditor
No contacts on file

Notes to SEFA

Title: Contingency Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards and State Financial Assistance (the Schedule) includes the Federal and State grant activity for Collier County, Florida (the County) and is presented on the modified accrual basis of accounting for expenditures accounted for in the governmental funds and the accrual basis of accounting for expenditures in proprietary funds. Under the modified accrual basis, revenue is recognized if it is both measurable and available for use during the fiscal year and expenditures are recognized in the period liabilities are incurred, if measurable. Under the accrual basis, expenditures are recognized in the period liabilities are incurred. The information in the 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), and Section 215.97, Florida Statutes. Therefore, some amounts presented in the Schedule may differ from amounts presented, or used in the preparation of, the basic financial statements for the fiscal year ended September 30, 2023. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10 percent de minimus cost rate allowed under the Uniform Guidance. The grant revenue amounts received are subject to audit and adjustment.  If any expenditures or expenses are disallowed by the grantor agencies as a result of such an audit, any claim for reimbursement to the grantor agencies would become a liability of the County.
Title: Disaster Grants - Public Assistance (Presidentially Declared Disasters) (97.036) Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards and State Financial Assistance (the Schedule) includes the Federal and State grant activity for Collier County, Florida (the County) and is presented on the modified accrual basis of accounting for expenditures accounted for in the governmental funds and the accrual basis of accounting for expenditures in proprietary funds. Under the modified accrual basis, revenue is recognized if it is both measurable and available for use during the fiscal year and expenditures are recognized in the period liabilities are incurred, if measurable. Under the accrual basis, expenditures are recognized in the period liabilities are incurred. The information in the 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), and Section 215.97, Florida Statutes. Therefore, some amounts presented in the Schedule may differ from amounts presented, or used in the preparation of, the basic financial statements for the fiscal year ended September 30, 2023. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10 percent de minimus cost rate allowed under the Uniform Guidance. After a presidentially declared disaster, FEMA provides Disaster Grants – Public Assistance (Presidentially Declared Disasters) (Assistance Listing 97.036) to reimburse eligible costs associated with debris removal, emergency protective measures and the repair, restoration, reconstruction or replacement of public facilities or infrastructure damaged or destroyed.  Reimbursements are provided in the form of cost-shared grants.  Hurricane Irma (FEMA-4337-DR) made landfall in Collier County on September 10, 2017.  All the $75,075 reported on the Schedule for grant Z0001 was incurred in fiscal years 2018 through 2022. Hurricane Ian (FEMA-4673-DR) made landfall in Collier County on September 28, 2022.  All the $23,791,985 reported on the Schedule for grant Z2967 was incurred in fiscal year 2023.
Title: Local Assistance and Tribal Consistency Fund (21.032) Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards and State Financial Assistance (the Schedule) includes the Federal and State grant activity for Collier County, Florida (the County) and is presented on the modified accrual basis of accounting for expenditures accounted for in the governmental funds and the accrual basis of accounting for expenditures in proprietary funds. Under the modified accrual basis, revenue is recognized if it is both measurable and available for use during the fiscal year and expenditures are recognized in the period liabilities are incurred, if measurable. Under the accrual basis, expenditures are recognized in the period liabilities are incurred. The information in the 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), and Section 215.97, Florida Statutes. Therefore, some amounts presented in the Schedule may differ from amounts presented, or used in the preparation of, the basic financial statements for the fiscal year ended September 30, 2023. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10 percent de minimus cost rate allowed under the Uniform Guidance. The Department of Treasury awarded the County $1,790,192 from the Local Assistance and Tribal Consistency Fund (LATCF). The two tranches were received in 2023 and of that amount only $21,934 was expended in 2023. The balance of the revenue is restricted in the fund until the County incurs additional expenditures. Year Ending September 30 Amount 2023 LATCF Revenue $ 1,790,192 2023 LATCF Expenditures (21,934) Total $ 1,768,258

Finding Details

Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of the Transportation Federal Program Name: National Infrastructure Investments Assistance Listing Number: 20.933 Federal Award Identification Number and Year: 693JJ32040007 - 2020 Award Period: 08/03/2020 – 10/31/2024 Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under Davis-Bacon Act - 40 U.S.C. §§ 3141, et seq., as applicable under 23 U.S.C. 113, prevailing wage requirements each contractor must submit weekly certified payrolls to the contracting agency or entity certified payrolls providing information for each covered worker. Each certified payroll must be accompanied by a "Statement of Compliance" certifying compliance with applicable requirements. Per 2 CFR Section 200.303(a) 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). Condition: The County did not obtain, maintain, or review certified payrolls as required for special provisions Davis Bacon Act for all vendors. Questioned costs: None Context: For two out of the eight payrolls selected for testing, the County did not properly obtain and review certified payrolls provided by subcontractor. The certifications were subsequently collected and reviewed when they were selected for audit testing. Cause: The County did not follow its policies, procedures and internal controls related to obtaining and reviewing certified payrolls from vendors. Effect: The County was not in compliance with the special provision compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County to implement a process and to update its policies and procedures to ensure that all certified payrolls are properly verified and maintained accurately through grant award period and beyond. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Housing and Urban Development Federal Program Name: CDBG – Entitlement Grants Cluster Assistance Listing Number: 14.218 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matter Criteria or specific requirement: Under reporting for Federal Funding Accountability and Transparency Act (FFATA) requires awardees such as prime contractors and subcontractors to file a FFATA subaward report by the end of the month following the month in which the prime contractor awards or prime grant recipient is awarded any subcontract or grant greater than $30,000. Per 2 CFR Section 200.303(a) 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). Condition: The County did submit FFATA reports after grant award or grant award modifications were made by the dates required. Questioned costs: None Context: For three out of the five FFATA reports selected for testing, the County submitted reports after the due date. Cause: The County’s internal controls did not prevent or detect the noncompliance. Effect: The County was not in compliance with the reporting compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County strengthen policies and procedures to ensure that reporting due dates are adhered to as required by the Federal regulations and that internal processes mirror the requirements of the Federal regulations. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Housing and Urban Development Federal Program Name: CDBG – Entitlement Grants Cluster Assistance Listing Number: 14.218 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matter Criteria or specific requirement: Under reporting for Federal Funding Accountability and Transparency Act (FFATA) requires awardees such as prime contractors and subcontractors to file a FFATA subaward report by the end of the month following the month in which the prime contractor awards or prime grant recipient is awarded any subcontract or grant greater than $30,000. Per 2 CFR Section 200.303(a) 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). Condition: The County did submit FFATA reports after grant award or grant award modifications were made by the dates required. Questioned costs: None Context: For three out of the five FFATA reports selected for testing, the County submitted reports after the due date. Cause: The County’s internal controls did not prevent or detect the noncompliance. Effect: The County was not in compliance with the reporting compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County strengthen policies and procedures to ensure that reporting due dates are adhered to as required by the Federal regulations and that internal processes mirror the requirements of the Federal regulations. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Transportation Federal Program Name: Highway Planning and Construction Assistance Listing Number: 20.205 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under 2 CFR 200.313 equipment acquired under a Federal award must be properly managed and proper records must be maintained. These records must contain information pertaining to Federal awards including description of property, serial number or other identification number, source of funding, title, acquisition date and cost of property, condition, ultimate disposition date including disposal, sales price and inventory. A physical inventory of the property must be taken and reconciled at least every two years, control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property, adequate maintenance procedures must be developed to keep the property in good conditions. Per 2 CFR Section 200.303(a) 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). Condition: The County did not maintain accurate and updated equipment inventory listings for equipment purchased with Federal funds in accordance with 2 CFR 200.313. Questioned costs: None Context: The County’s equipment inventory listing of equipment purchased with grant funds was not maintained in a manner that complied with 2 CFR 200.313 during the year. An inventory listing that complied with 2 CFR 200.313 was prepared once it was requested during the audit. Additionally, for one of eight equipment items selected for testing from the inventory listing, the equipment serial number did not agree with the equipment inventory listing for that equipment’s location. Cause: The County did not have formal policies and procedures in place to manage and maintain equipment inventor records in compliance with 2 CFR 200.313. Effect: The County was not in compliance with the equipment compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County expand upon their capital asset inventory policies and procedures that are used for financial statement purposes to ensure that all equipment purchased with Federal funds are properly managed and maintained throughout the year to ensure all information, including the serial number and equipment location, is accurate and updated. We also recommend that the program personnel responsible for equipment records certify accuracy of the equipment records throughout the year. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of the Transportation Federal Program Name: National Infrastructure Investments Assistance Listing Number: 20.933 Federal Award Identification Number and Year: 693JJ32040007 - 2020 Award Period: 08/03/2020 – 10/31/2024 Type of Finding: Material Weakness in Internal Control over Compliance; Material Noncompliance (Modified Opinion) Criteria or specific requirement: Under Davis-Bacon Act - 40 U.S.C. §§ 3141, et seq., as applicable under 23 U.S.C. 113, prevailing wage requirements each contractor must submit weekly certified payrolls to the contracting agency or entity certified payrolls providing information for each covered worker. Each certified payroll must be accompanied by a "Statement of Compliance" certifying compliance with applicable requirements. Per 2 CFR Section 200.303(a) 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). Condition: The County did not obtain, maintain, or review certified payrolls as required for special provisions Davis Bacon Act for all vendors. Questioned costs: None Context: For two out of the eight payrolls selected for testing, the County did not properly obtain and review certified payrolls provided by subcontractor. The certifications were subsequently collected and reviewed when they were selected for audit testing. Cause: The County did not follow its policies, procedures and internal controls related to obtaining and reviewing certified payrolls from vendors. Effect: The County was not in compliance with the special provision compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County to implement a process and to update its policies and procedures to ensure that all certified payrolls are properly verified and maintained accurately through grant award period and beyond. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Housing and Urban Development Federal Program Name: CDBG – Entitlement Grants Cluster Assistance Listing Number: 14.218 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matter Criteria or specific requirement: Under reporting for Federal Funding Accountability and Transparency Act (FFATA) requires awardees such as prime contractors and subcontractors to file a FFATA subaward report by the end of the month following the month in which the prime contractor awards or prime grant recipient is awarded any subcontract or grant greater than $30,000. Per 2 CFR Section 200.303(a) 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). Condition: The County did submit FFATA reports after grant award or grant award modifications were made by the dates required. Questioned costs: None Context: For three out of the five FFATA reports selected for testing, the County submitted reports after the due date. Cause: The County’s internal controls did not prevent or detect the noncompliance. Effect: The County was not in compliance with the reporting compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County strengthen policies and procedures to ensure that reporting due dates are adhered to as required by the Federal regulations and that internal processes mirror the requirements of the Federal regulations. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Federal Agency: U.S. Department of Housing and Urban Development Federal Program Name: CDBG – Entitlement Grants Cluster Assistance Listing Number: 14.218 Federal Award Identification Number and Year: Various Award Period: Various Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matter Criteria or specific requirement: Under reporting for Federal Funding Accountability and Transparency Act (FFATA) requires awardees such as prime contractors and subcontractors to file a FFATA subaward report by the end of the month following the month in which the prime contractor awards or prime grant recipient is awarded any subcontract or grant greater than $30,000. Per 2 CFR Section 200.303(a) 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). Condition: The County did submit FFATA reports after grant award or grant award modifications were made by the dates required. Questioned costs: None Context: For three out of the five FFATA reports selected for testing, the County submitted reports after the due date. Cause: The County’s internal controls did not prevent or detect the noncompliance. Effect: The County was not in compliance with the reporting compliance requirements of the program. Repeat Finding: No Recommendation: We recommend the County strengthen policies and procedures to ensure that reporting due dates are adhered to as required by the Federal regulations and that internal processes mirror the requirements of the Federal regulations. Views of responsible officials: Management agrees with the finding. See corrective action plan.