Finding 1213722 (2025-004)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-05-05
Audit: 400610
Organization: City of Lodi (CA)
Auditor: LSL CPAS

AI Summary

  • Core Issue: The City did not provide a complete Schedule of Expenditures of Federal Awards (SEFA), affecting the accuracy of the ARPA program and major program determinations.
  • Impacted Requirements: Compliance with Government Auditing Standards and Uniform Guidance mandates accurate SEFA submission for federal awards.
  • Recommended Follow-Up: Implement detailed procedures, enhance staffing, provide training, and conduct regular audits of the SEFA preparation process to ensure accuracy and compliance.

Finding Text

Reference Number 2025-004 Evaluation of Finding Material Weakness and Noncompliance: Incomplete Schedule of Expenditures of Federal Awards Condition The City failed to provide a complete schedule of expenditures of federal awards (SEFA) for the fiscal year, leading to inaccuracies pertaining to the ARPA program. This omission resulted in a direct impact on the determination of major programs. Criteria According to the Government Auditing Standards (Yellow Book) and the Uniform Guidance, 2 CFR Part 200, Subpart F—Audit Requirements, sections 200.508 and 200.510, entities receiving federal awards must prepare and submit a complete and accurate SEFA as part of their annual financial reporting. This schedule is crucial for auditors to determine major programs and conduct the necessary audits in compliance with federal regulations. Cause of Condition The incomplete SEFA was caused by a lack of oversight and insufficient internal controls within the City's financial management department. Effect or Potential Effect The failure to provide a complete SEFA has significant implications, including: • Inaccurate determination of major programs, which can affect the scope and quality of the audit process. • Increased risk of non-compliance with federal regulations, potentially leading to financial penalties and loss of federal funding. Recommendation To address this material weakness, the following actions are recommended: • Develop detailed procedures and timelines: Establish and enforce comprehensive procedures and timelines for the preparation and submission of the SEFA to ensure completeness and accuracy. • Enhance staffing and resources: Allocate adequate staffing and resources to the financial management department to support the accurate compilation and timely submission of the SEFA. • Provide comprehensive training: Offer training to financial management staff on the requirements and importance of the SEFA, including techniques for ensuring its accuracy and completeness.. • Regularly audit the SEFA preparation process: Conduct regular audits of the SEFA preparation process to ensure compliance with established policies and procedures and address any deficiencies promptly. This should be completed monthly and at a minimum quarterly. By implementing these recommendations, the City can strengthen its internal controls, improve the accuracy of its financial reporting, and ensure compliance with Government Auditing Standards and other regulatory requirements.

Corrective Action Plan

Management agrees with the finding and recommendations. The City will begin to implement policies and procedures to assist with monthly reconciliations and review processes to mitigate these errors in the future.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1213705 2025-006
    Material Weakness Repeat
  • 1213706 2025-004
    Material Weakness Repeat
  • 1213707 2025-006
    Material Weakness Repeat
  • 1213708 2025-004
    Material Weakness Repeat
  • 1213709 2025-006
    Material Weakness Repeat
  • 1213710 2025-004
    Material Weakness Repeat
  • 1213711 2025-006
    Material Weakness Repeat
  • 1213712 2025-004
    Material Weakness Repeat
  • 1213713 2025-006
    Material Weakness Repeat
  • 1213714 2025-004
    Material Weakness Repeat
  • 1213715 2025-006
    Material Weakness Repeat
  • 1213716 2025-004
    Material Weakness Repeat
  • 1213717 2025-006
    Material Weakness Repeat
  • 1213718 2025-004
    Material Weakness Repeat
  • 1213719 2025-006
    Material Weakness Repeat
  • 1213720 2025-004
    Material Weakness Repeat
  • 1213721 2025-006
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
20.507 FEDERAL TRANSIT FORMULA GRANTS $3.01M
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $2.90M
97.044 ASSISTANCE TO FIREFIGHTERS GRANT $404,796
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $391,916
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $100,090
14.251 ECONOMIC DEVELOPMENT INITIATIVE, COMMUNITY PROJECT FUNDING, AND MISCELLANEOUS GRANTS $80,922
66.818 BROWNFIELDS MULTIPURPOSE, ASSESSMENT, REVOLVING LOAN FUND, AND CLEANUP COOPERATIVE AGREEMENTS $21,026
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $20,345
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $3,872