Finding 478875 (2023-002)

Significant Deficiency
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-07-19
Audit: 315502
Organization: El Paso County (CO)
Auditor: Rubin Brown

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) was understated due to an unaccrued construction invoice.
  • Impacted Requirements: Compliance with 2 CFR Part 200 is necessary for accurate SEFA preparation and reporting.
  • Recommended Follow-Up: Strengthen internal controls for year-end accrual reviews to ensure all federal expenditures are accurately reported.

Finding Text

Significant Deficiency: Schedule of Expenditures of Federal Awards (SEFA) - Control Finding Criteria Or Specific Requirement: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the Uniform Guidance) provides guidance related to preparation and reporting of the SEFA. 2 CFR Section 200.100 identifies the required elements of the SEFA and 2 CFR Section 200.510 specifically requires that the SEFA include information on each federal award expended during the year. The County is required to prepare a complete and accurate SEFA and to have a system of internal controls, the design and operation of which allows management or employees in the normal course of performing their assigned functions to prevent, or detect and correct, errors on a timely basis. Condition: The SEFA was understated by a construction invoice that was not accrued as of year-end. A portion of those expenditures were included under a federal grant program. Cause: Management internal control process did not function properly in this instance to ensure an accurate SEFA. Effect: The possibility exists that errors within the SEFA could become material to the financial statements or result in an incorrect major program determination or incomplete testing of a major program. Questioned Costs: Not applicable Context: A sufficient review of the federal expenditure accruals did not occur so that an error to the SEFA report were not detected by management. Identification As A Repeat Finding: N/A Recommendation: We recommend that the County strengthen the processes within the internal control framework surrounding the review of year-end accruals for federal grant programs to ensure that all federal expenditures are complete and included in the correct period’s SEFA. Views Of Responsible Officials And Planned Corrective Action: The County agrees with the finding and has put together a correction action plan for the finding.

Corrective Action Plan

Finding 2023-002 Significant Deficiency: Schedule of Expenditures of Federal Awards (SEFA) – Control Finding; Personnel Responsible for Corrective Action: Pete Vujcich, Public Works Division Manager; Anticipated Completion Date: June 30, 2024; Corrective Action Plan: In 2021, El Paso County recognized and appropriated $4 million from a CDOT grant (Fed) and $831,501 of local match that was provided by PPRTA (reimbursement) for construction on the South Academy widening project. The overall South Academy project is funded by PPRTA but managed by El Paso County. In May of 2023, PPRTA issued a Purchase Order for $59,965,997.99 to SEMA Construction and the construction contract with SEMA was executed. In December of 2023, SEMA performed work on the project resulting in billings of $4,456,362.07. A payment application was sent to the construction management firm (Wilson & Company) on January 17, 2024 from SEMA. This payment request was rejected due to insufficient certified payrolls. On February 27, 2024, Public Works received an invoice package with all required documentation. During February 2024, Public Works realized that PPRTA would not be able to submit for reimbursement because the IGA was directed to the County and not PPRTA. At that point, the project manager requested a 2024 Purchase Order to pay this invoice. On March 6, 2024, Public Works submitted the 2024 invoice along with a 2024 Purchase Order to Accounts Payable requesting payment was made to SEMA. At that point, the payment was issued and booked to 2024 without recognition of the actual work performance period. Since the invoice was booked in 2024, the expenditure was also not reflected on the 2023 SEFA. As soon as this expenditure was brought to our attention, we immediately requested Accounting record the $4.5 million on the 2023 SEFA. Standard operating procedures include a request of all project managers to identify any anticipated invoices that will be received in the following year to identify any potential reclassification situations. In this particular case, the project manager did identify this project, and anticipated payment request. At the time, this project was a PPRTA run project, and would not have had an impact on the county’s financial reports. Previously, Public Works had a very manual SEFA reporting process in place. Public Works just went live with a new Capital project tracking platform called eBuilder. eBuilder has a required field on the pay app approval screen that requires employees to enter the billing period start and end dates. When Managers go into eBuilder to approve payments, they are required to ensure the billing periods match the payment dates. In addition, as a double check, Public Works is working on customizing eBuilder to flag approvers if the invoice date has a different year listed than the billing period. Public Work has done training with employees to ensure employees understand the additional components of a progress billing pay application, to include timing issues with the review and approval process utilized. We have also reinforced the importance to communicate the correct year expenses were incurred when submitting to Accounts Payable and Accounting. eBuilder will allow Public Works to run reports showing expenses for the correct year. These reports will then be submitted to Accounting to assist with the SEFA preparation. Public Works is confident that all expenditures will be recorded correctly on the SEFA moving forward.

Categories

Reporting

Other Findings in this Audit

  • 1055317 2023-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.558 Temporary Assistance for Needy Families $18.46M
93.575 Child Care and Development Block Grant $13.85M
93.658 Foster Care_title IV-E $12.79M
93.778 Medical Assistance Program $8.41M
10.561 Supplemental Nutrition Assistance Program $6.82M
93.563 Child Support Enforcement $3.86M
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $3.50M
93.659 Adoption Assistance $3.46M
17.258 Wia Adult Program $1.52M
17.259 Wia Youth Activities $1.25M
93.645 Stephanie Tubbs Jones Child Welfare Services Program $906,007
20.205 Highway Planning and Construction $876,235
93.569 Community Services Block Grant $648,646
17.270 Reintegration of Ex-Offenders $345,284
16.575 Crime Victim Assistance $307,903
93.667 Social Services Block Grant $235,962
14.218 Community Development Block Grants/entitlement Grants $230,366
17.245 Trade Adjustment Assistance $185,754
97.042 Emergency Management Performance Grants $130,851
17.207 Employment Service/wagner-Peyser Funded Activities $126,661
95.001 High Intensity Drug Trafficking Areas Program $123,017
93.556 Promoting Safe and Stable Families $122,910
10.551 Supplemental Nutrition Assistance Program $115,498
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $92,109
93.090 Guardianship Assistance $90,502
21.027 Coronavirus State and Local Fiscal Recovery Funds $85,677
93.568 21st Century Cures Act - Precision Medicine Initiative $81,622
16.922 Equitable Sharing Program $62,029
17.225 Unemployment Insurance $59,794
16.034 Coronavirus Emergency Supplemental Funding Program $58,248
16.606 State Criminal Alien Assistance Program $52,783
90.404 2018 Hava Election Security Grants $51,750
16.738 Edward Byrne Memorial Justice Assistance Grant Program $50,275
93.747 Elder Abuse Prevention Interventions Program $45,234
17.801 Jobs for Veterans State Grants $45,116
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $35,428
17.277 Workforce Investment Act (wia) National Emergency Grants $29,220
20.600 State and Community Highway Safety $24,887
17.804 Local Veterans' Employment Representative Program $22,558
17.278 Wia Dislocated Worker Formula Grants $6,250
93.566 Refugee and Entrant Assistance_state Administered Programs $5,646
16.543 Missing Children's Assistance $4,938
21.019 Coronavirus Relief Fund $-79
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $-3,807