Finding 479033 (2023-001)

-
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2024-07-22
Audit: 315556
Organization: City of Aurora, Colorado (CO)

AI Summary

  • Core Issue: The City of Aurora charged $22,602 in payroll and benefits for an employee who was no longer working on COVID-19 projects, violating SLFRF program rules.
  • Impacted Requirements: Costs must be directly related to COVID-19 response; improper charges could lead to disallowed costs and potential federal sanctions.
  • Recommended Follow-Up: Implement better internal controls to track employee job duties and increase the frequency of time and effort certifications to ensure compliance.

Finding Text

Finding: Allowable Costs Program: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Sponsoring Agency: Department of Treasury Sponsoring Award Number: None provided Award Year: 2021 "Criteria: Per the Coronavirus State and Local Fiscal Recovery Fund (SLFRF) Final Rule and Frequently Asked Questions, recipients may use SLFRF funds for various reasons including respoinding to the Public Health Emergency and negative economic impacts from the pandemic, which includes bolstering the public sector capacity and workforce such as payroll and covered benefits for employees of a recipient government for the portion of the employee's time spent responding to COVID-19. " Condition: The City of Aurora (the City) charged payroll and benefits for one employee subsequent to time in which the employee no longer was working on COVID-19 related projects for the City. Questioned Costs: $22,602 Context: The City charged three employees payroll and benefits to the SLFRF program for at total of $299,169. We compared 100% of the payroll to underlying employee contracts and cost allocation reports and noted one employee's payroll and benefits should have been charged to the SLFRF program from January to September 9, 2023, however all payroll through December 2023 was charged to the program. Effect: Unallowable costs were charged to the SLFRF program. Failure to ensure compliance with federal requirements for the SLFRF program program requirements could result in disallowed costs and federal sanctions, including the termination of the federal program. Cause: The City did not have proper internal controls in place to identify and communicate the change in employees job duties. In addition, the City's time and effort certifications happen on an annual basis which does not provide adqueate time to correct changes in employees job functions/allocations of cost. Identification as a repeat finding: Not Applicable Recommendation: We recommend City staff implement internal controls to identify changes in employee job duties and allocations of costs. In addition, we recommend the City increase the frequency of time and effort certifications in order to identify changes on a more timely basis. Views of Responsible Officials and Planned Corrective Actions: The City agrees with the finding. See separate report for planned corrective actions.

Corrective Action Plan

CITY OF AURORA PLANNED ACTION: The City agrees with the finding and City staff will implement additional internal controls, including sending payroll reports to grant managers each pay period for review and signoff for the audit file. In addition, staff will increase the frequency of time and effort certifications to quarterly to identify changes in employee job duties and cost allocations on a timely basis. CITY OF AURORA RESPONSIBLE PARTY: Nancy Wishmeyer, Controller COMPLETION DATE: Q3 2024

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
20.933 National Infrastructure Investments $7.59M
14.218 Community Development Block Grants/entitlement Grants $1.65M
21.026 Homeowner Assistance Fund $992,958
14.231 Covid 19 Emergency Solutions Grant Program $986,424
95.001 High Intensity Drug Trafficking Areas Program $625,457
14.231 Emergency Solutions Grant Program $312,096
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $228,401
16.741 Dna Backlog Reduction Program $165,993
59.037 Small Business Development Centers $160,000
97.067 Homeland Security Grant Program $151,240
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $142,562
14.218 Covid 19 Community Development Block Grants/entitlement Grants $139,207
16.922 Equitable Sharing Program $130,295
97.044 Assistance to Firefighters Grant $113,901
16.543 Missing Children's Assistance $110,436
97.132 Financial Assistance for Countering Violent Extremism $103,122
16.738 Edward Byrne Memorial Justice Assistance Grant Program $87,312
97.042 Emergency Management Performance Grants $48,839
21.027 Coronavirus State and Local Fiscal Recovery Funds $42,648
20.616 National Priority Safety Programs $36,804
16.607 Bulletproof Vest Partnership Program $24,432
14.239 Home Investment Partnerships Program $21,078
20.600 State and Community Highway Safety $21,059
16.609 Project Safe Neighborhoods $12,846
93.575 Child Care and Development Block Grant $10,329
20.205 Highway Planning and Construction $10,206
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $7,967
93.434 Every Student Succeeds Act/preschool Development Grants $6,750
14.169 Housing Counseling Assistance Program $5,752
17.529 Workforce Innovation and Opportunity Act $3,871
21.023 Emergency Rental Assistance Program $2,794
97.025 National Urban Search and Rescue (us&r) Response System $431
97.083 Staffing for Adequate Fire and Emergency Response (safer) $-200,948