Finding 1152918 (2024-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-09-14
Audit: 366244
Organization: City of Roseville (CA)
Auditor: Lsl LLP

AI Summary

  • Core Issue: An expenditure of $945,041 was recorded in the wrong period, affecting financial reporting accuracy.
  • Impacted Requirements: Compliance with 2 CFR 200.302(b)(3) and 2 CFR 200.303 regarding internal controls over financial reporting.
  • Recommended Follow-Up: Strengthen internal controls with enhanced review procedures and periodic reconciliations for accurate expenditure recognition.

Finding Text

Reference Number 2024-002 Federal Program: 21.027 – Coronavirus State and Local Fiscal Recovery Funds Federal Agency U.S. Department of Treasury Pass-Through Entity State of California Evaluation of Finding Significant Deficiency Compliance Area L – Reporting Condition During the allowable cost testing for the 21.027 Coronavirus State and Local Fiscal Recovery Funds program, it was found that an expenditure of $945,041 was recorded in the wrong period. The invoice indicated that the services were rendered as of June 30, 2023, but the expenditure was recorded as July 1, 2023 instead. This misstatement impacts the accuracy of financial reporting and grant compliance. Criteria According to 2 CFR 200.302(b)(3) and 2 CFR 200.303, entities receiving federal funds must maintain effective internal controls over financial reporting to ensure accurate and timely recognition of expenditures in the appropriate period. Cause of Condition The City's internal controls over financial reporting and expenditure recognition were not effectively designed or implemented, leading to recurring errors in the timing of recorded expenditures. Effect or Potential Effect of Condition Improper recording of expenditures can lead to misstatements in financial reports, noncompliance with federal grant requirements, and potential audit findings. Continued recurrence of this issue may impact the entity’s ability to demonstrate sound financial management practices. Recommendation We recommend that management continue to strengthen internal controls over expenditure recognition by implementing enhanced review procedures and periodic reconciliations to ensure expenditures are recorded in the appropriate period. Client Response The City agrees with the recommendation and has implemented new procedures and review processes to ensure expenditures for federal programs are recognized in the appropriate fiscal year's Schedule of Expenditures of Federal Awards (SEFA).

Corrective Action Plan

Name of Contact Person: Teri Quinlan, Accounting Manager Corrective Action: The City agrees with the auditors’ finding and recommendation. The City has implemented, and is in the process of documenting, new procedures and review processes to ensure expenditures for federal programs are recognized in the appropriate fiscal year’s Schedule of Expenditures of Federal Awards (SEFA). Proposed Completion Date: October 13, 2025

Categories

Reporting

Programs in Audit

ALN Program Name Expenditures
14.871 Section 8 Housing Choice Vouchers $9.94M
14.239 Home Investment Partnerships Program $7.88M
66.458 Clean Water State Revolving Fund $6.69M
21.027 Coronavirus State and Local Fiscal Recovery Funds $5.55M
20.205 Highway Planning and Construction $5.20M
14.218 Community Development Block Grants/entitlement Grants $2.99M
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $1.27M
14.879 Mainstream Vouchers $648,074
20.507 Federal Transit Formula Grants $505,489
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $388,703
93.575 Child Care and Development Block Grant $276,802
97.039 Hazard Mitigation Grant $107,184
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $58,658
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $57,584
97.067 Homeland Security Grant Program $55,747
45.301 Museums for America $46,273
16.738 Edward Byrne Memorial Justice Assistance Grant Program $19,483
97.106 Securing the Cities Program $11,579
16.922 Equitable Sharing Program $5,937