Finding 2023 – 004: Reporting – Late Data Collection Form Submission (Repeat Finding: 2019-006, 2020-006, 2021-005 and 2022-005) Criteria: Uniform Guidance requires an entity expending more than $750,000 of federal funds within a fiscal year to have the data collection form and reporting package submitted within nine months after the end of the audit period. Condition: The Governmental Department’s audited financial statements were not submitted to the Federal Audit Clearinghouse by the due date of June 30, 2024. Cause: A lack of timely general ledger reconciliations contributed to the failure to timely file reports. Effect: The Governmental Department is not in compliance with the reporting requirements set forth in the Compliance Supplement which could lead to sanctions by the funding sources. Recommendation: We recommend that the Governmental Department implement procedures to ensure submission of the data collection form and reporting package to the federal audit clearinghouse within the nine-month due date. Views of Responsible Officials: See the corrective action plan that accompanies the schedule of findings and questioned costs.
Finding 2023 – 005: Procurement (Compliance; Internal Controls Over Compliance) (Repeat Finding: 2015-004, 2016-003, 2017-005, 2018-004, 2019-005, 2020-005, 2021-004 and 2022-006) Material Weakness ALN 20.205 Highway Planning & Construction Criteria: Uniform Guidance §200.318 through §200.327 outlines the federal procurement standards for non-federal entities (such as local governments) when using federal funds. These procurement standards should be followed for each federal program the Governmental Department expends funds on. Condition: During the testing of the Highway Planning and Construction Program (ALN 20.205), we reviewed two transactions selected to assess compliance with procurement standards. However, the Governmental Department was unable to provide procurement documentation for one of these transactions, including evidence of procurement planning, bid evaluations, or contract award decisions. Furthermore, no documentation was available to confirm that the Governmental Department had conducted searches for suspended or debarred vendors, as required under federal regulations. This lack of documentation prevented us from verifying compliance with federal procurement and vendor eligibility requirements for these transactions. Questioned Costs: $350,887 Cause: The purchasing department and program director are not following established policies and procedures for procurement and suspension and debarment as outlined in the Governmental Department’s procurement policy and Uniform Guidance §200.318 through §200.327. Effect: The Governmental Department’s procurement policy, as well as, Uniform Guidance §200.318 through §200.327 are not being followed. This could lead to sanctions by the funding agency. Recommendation: We recommend the Governmental Department become familiar with the procurement regulations and standards identified in Uniform Guidance §200.318 through §200.327 and follow established procurement policies and procedures to minimize any unauthorized or unallowable purchases as it relates to procurement. Views of Responsible Officials: See the corrective action plan that accompanies the schedule of findings and questioned costs.
Finding 2023 – 006: Reporting (Compliance; Internal Controls Over Compliance) (Repeat Finding: 2014-004, 2015-008, 2016-005, 2017-006, 2018-005, 2019-006, 2020-006, 2021-005 and 2022-007) Significant Deficiency ALN 21.027 Coronavirus State and Local Fiscal Recovery Funds (ARPA) Criteria: Per the Compliance Supplement for ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds, the Governmental Department was required to submit the Project and Expenditure Report as of September 30, 2023. Condition: During the testing of the reporting compliance requirement for ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds, we noted that the necessary reports were filed timely; however, no general ledger backup was provided to verify the accuracy of the reported numbers. Questioned Costs: None. Cause: The Governmental Department did not maintain sufficient appropriate documentation related to the reporting requirements for ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds. Effect: The Governmental Department is not in compliance with the reporting requirements set forth by the Uniform Guidance Compliance Supplement as it relates to ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds. Recommendation: We recommend that the Governmental Department establish procedures to ensure that all reports submitted to funding agencies are accurate, complete, and supported by reconciled documentation. These procedures should include reconciling financial information to the general ledger and verifying the accuracy of the Project and Expenditure Report as required for ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds. Additionally, we recommend that the Governmental Department review and incorporate program-specific reporting requirements into a formal policy to maintain compliance with federal guidelines. Views of Responsible Officials: See the corrective action plan that accompanies the schedule of findings and questioned costs.
Finding 2023 – 007: Reporting: Preparation of the Schedule of Expenditures of Federal Awards (SEFA), (Repeat Finding: 2019-007, 2020-007, 2021-006 and 2022-008) Criteria: Uniform Guidance 2 CFR §200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements [that]… at a minimum shall…list individual Federal programs by Federal agency… [and] provide total Federal awards expenditures for each individual Federal program and the Assistance Listing Number (ALN) or other identifying number when the ALN information is not available.” In accordance with Uniform Guidance, the Governmental Department is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Condition: During fiscal year 2023, the Governmental Department did not have sufficient controls to ensure the SEFA accurately reflected each award’s federal expenditures. There were differences noted in reconciling expenditures from the original SEFA to the trial balance. These errors were corrected through adjustments proposed as part of the audit, and the final version of the SEFA reconciles to the Governmental Department’s general ledger. Questioned Costs: None Cause: Insufficient training or understanding of Uniform Guidance, including some of the required elements of the SEFA, contributed to this finding. Effect: The Governmental Department could not produce an accurate and timely SEFA, which required additional effort and resources by the Governmental Department and auditor during the audit process. Recommendation: We recommend that the Governmental Department becomes familiar with the SEFA reporting elements required by Uniform Guidance and develop and implement a review process to ensure compliance with those reporting requirements. These processes and controls should include reconciling SEFA federal expenditures to the current year general ledger expenditures and reviewing other grant related information to ensure accuracy. Views of Responsible Officials: See the corrective action plan that accompanies the schedule of findings and questioned costs.
Finding 2023 – 008: Activities Allowed and Unallowed, Allowable Costs, Period of Performance (Compliance; Internal Controls Over Compliance) (Repeat Finding: 2018-006, 2019-008, 2020-008, 2021-007 and 2022-009) Significant Deficiency ALN 93.441 Indian Self Determination ALN 20.205 Highway Planning & Construction ALN 93.575 Child Care and Development Block Grant Criteria: Uniform Guidance 2 CFR, Part §200.313(a) requires that non-federal entities must 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 following 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: During compliance requirement testing for Activities Allowed and Unallowed, Allowable Costs and Period of Performance for the above noted major programs, we selected 120 transactions for testing from each major program. The following number of transactions were not provided for review during the audit: ALN 93.441 – Indian Self Determination – 18 transactions ALN 20.205 – Highway Planning and Construction – 16 transactions ALN 93.575 – Child Care and Development Block Grant – 7 transactions Questioned Costs: ALN 93.441 – Indian Self Determination – $9,236 ALN 20.205 – Highway Planning and Construction - $8,367 ALN 93.575 – Child Care and Development Block Grant – $22,832 Cause: The Governmental Department did not maintain sufficient appropriate documentation for audit review. Effect: The Governmental Department is not in compliance with Activities Allowed and Unallowed, Allowable Costs and Period of Performance compliance requirements for the three major programs mentioned above. This could lead to sanctions by the funding agencies. Recommendation: We recommend the Governmental Department becomes familiar with the requirements of 2 CFR, Part §200.313(a) and establish appropriate internal control policies and procedures to ensure compliance with the requirements of Uniform Guidance and each major program. In addition, all staff should be trained in those policies and procedures, so they are familiar with the requirements. We further recommend the Governmental Department does not process payment for disbursements that do not contain sufficient, appropriate supporting documentation and necessary approvals. Views of Responsible Officials: See the corrective action plan that accompanies the schedule of findings and questioned costs.