Finding 528779 (2024-003)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2025-03-19

AI Summary

  • Core Issue: Significant errors in payroll calculations were found, impacting compliance with federal cost principles.
  • Impacted Requirements: Federal regulations require accurate payroll records for salary charges to federal awards.
  • Recommended Follow-Up: Implement a more thorough review process to ensure accuracy in reimbursement requests.

Finding Text

Finding 2024-003: Allowable Costs/Cost Principles—Payroll Calculation Errors—Significant Deficiency in Controls over Compliance and Noncompliance Federal Program: Coronavirus State and Local Fiscal Recovery Funds—ALN 21.027 Year(s): 2024 Federal Agency: U.S. Department of Treasury Contract—DHA SA-01-22/A2 Pass-Through Entity: Sacramento County Criteria—In accordance with 2 CFR 200.430 (g)(1) and (g)(1)(i) charges to Federal awards for salaries and wages must be based on accurate records and calculations. Condition/Context—Out of 31 payroll selections, 6 selections had calculation errors. In the process of recording the payroll cost for the grant, spreadsheet related errors were made in transferring the general ledger data into the reimbursement requests which were then used to populate the schedule of federal awards of expenditures. Questions Costs—Under the reportable threshold, hence not applicable Cause—The control to review the recording of the payroll general ledger details into the reimbursement request was not precise enough to identify the calculation errors. Effect—Incorrect cost can be charged to the grant which can lead to the potential disallowance of costs. Recommendation—We recommend the Division implement a more detailed and precise review process to ensure the accuracy and completeness of the reimbursement request. Views of the Responsible Officials—See Corrective Action Plan

Corrective Action Plan

Corrective Action Plan: The Division will implement a more detailed and precise review process to ensure the accuracy and completeness of the reimbursement request. Anticipated Date: April 2025 Name of Person Responsible for Implementation: Al Agpoon, Controller

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 528777 2024-002
    Material Weakness
  • 528778 2024-002
    Material Weakness
  • 1105219 2024-002
    Material Weakness
  • 1105220 2024-002
    Material Weakness
  • 1105221 2024-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $877,372
93.575 Child Care and Development Block Grant $310,493
10.569 Emergency Food Assistance Program (food Commodities) $91,270
14.231 Emergency Solutions Grant Program $72,413
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $54,661
10.559 Summer Food Service Program for Children $26,093
14.218 Community Development Block Grants/entitlement Grants $14,500
93.569 Community Services Block Grant $9,333
97.024 Emergency Food and Shelter National Board Program $3,000
10.558 Child and Adult Care Food Program $1,674