Finding 521103 (2024-002)

Material Weakness
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2025-02-03
Audit: 341029
Organization: City of Auburn (CA)
Auditor: Eide Bailly LLP

AI Summary

  • Core Issue: The City charged 50% of budgeted employee compensation to the program without verifying it against actual costs.
  • Impacted Requirements: Compliance with 2 CFR 200.430(g)(vii) regarding allowable costs and internal controls for budget estimates.
  • Recommended Follow-Up: Implement procedures for regular reviews of budgeted versus actual costs to ensure accurate charges to the program.

Finding Text

Program: Coronavirus State and Local Fiscal Recovery Funds Federal Financial Assistance Listing No.: 21.027 Federal Agency: U.S. Department of Treasury Passed-through: California Department of Finance Award Number and Year: CSLFRF Compliance Requirement: Allowable Costs Type of Finding: Material Weakness in Internal Control over Compliance, Instance of Noncompliance Criteria: 2 CFR 200.430(g)(vii) states that budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: a) the system for establishing the estimates produces reasonable approximations of the activity performed; b) significant changes in the related work activity (as defined by the recipient’s written policies) are promptly identified and entered in to the records, and c) the recipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We found that although the City charged 50% of the budgeted amount of an employees compensation to the program, the City did not perform a lookback to ensure that only 50% of the employees actual compensation was charged to the program. Cause: The City did not have procedures in place to perform a lookback of budgeted costs charged to grant programs. Effect: The City overcharged the program by the excess of the budgeted costs against the actual costs. Questioned Costs: None reported. Context/Sampling: We selected 100% of the City’s payroll costs of the program. Repeat Finding from Prior Year(s): No. Recommendation: We recommend that the City establish procedures to perform a lookback of budgeted expenditures charged to grants. Views of Responsible Officials: Management agrees with the finding. See separate corrective action plan.

Corrective Action Plan

Planned Corrective Action: The City will ensure actual costs are charged to the program as part of the annual reporting process. Anticipated Completion Date: December 30, 2024 Responsible Contact Person: Gretchen Johnson, Finance Director

Categories

Allowable Costs / Cost Principles Material Weakness

Other Findings in this Audit

  • 521104 2024-003
    Material Weakness
  • 521105 2024-004
    Material Weakness
  • 1097545 2024-002
    Material Weakness
  • 1097546 2024-003
    Material Weakness
  • 1097547 2024-004
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $653,810
20.509 Formula Grants for Rural Areas and Tribal Transit Program $80,062
20.106 Airport Improvement Program, Covid-19 Airports Programs, and Infrastructure Investment and Jobs Act Programs $36,656