Finding 1147023 (2024-004)

Significant Deficiency
Requirement
AB
Questioned Costs
$1
Year
2024
Accepted
2025-07-08
Audit: 361612
Auditor: Sikich CPA LLC

AI Summary

  • Issue: Payroll charges were billed twice for one pay period, totaling $24,367, and administrative costs exceeded the 15% limit by $2,673.
  • Impacted Requirements: Costs must be necessary and reasonable per 2 CFR Part 200, and administrative costs cannot exceed 15% of the total budget.
  • Follow-Up: Management should enhance internal controls to ensure accurate tracking and review of federal grant billings for compliance.

Finding Text

Condition: During our testing of costs charged to the major program, we identified that one pay-date of payroll charges billed to the program for the grant period July 1, 2024 to June 30, 2025 was billed twice in error. We also identified that administrative costs billed to the grant period July 1, 2023 to June 30, 2024 exceeded the maximum allowed as noted in the criteria below. Criteria: Under 2 CFR Part 200, Subpart E -Cost Principles, costs charged to a federal program must meet certain criteria to be allowable including that they be necessary and reasonable for the performance of the federal award. In addition, the grant agreement stipulates that administrative costs charged to the federal award must not exceed 15% of the total budget for each grant period. Cause: The overbilling of one pay-period and administrative costs was caused by a manual error and an oversight when calculating the amount of federal expenditures to bill. Context: Out of a sample of 40 payroll expenditures, we noted 2 instances where the selected payroll charge was billed in 2 consecutive billings. Upon review of the full billing reports, it was determined that the full pay period was billed twice, totaling $24,367. A statistical sample was not used. For administrative costs, review of totals billed for the full grant period demonstrated that administrative costs billed for one grant exceeded 15% by $2,673 which is included in the total questioned costs below. Effect: The deficiency noted above resulted in known and likely questioned cost as costs were not allowable under the terms of the grant agreement and did not comply with the cost principles under 2 CFR Part 200, Subpart E. Questioned Costs: $27,040 Recommendation: We recommend that management review current internal controls over tracking and review of federal grant billings to include a detailed review of all costs included in the billing to ensure their allowability.

Categories

Questioned Costs Internal Control / Segregation of Duties Allowable Costs / Cost Principles

Other Findings in this Audit

  • 570580 2024-003
    Significant Deficiency
  • 570581 2024-004
    Significant Deficiency
  • 1147022 2024-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.287 Twenty-First Century Community Learning Centers $2.03M
93.558 Temporary Assistance for Needy Families $1.58M
84.425 Education Stabilization Fund $1.07M
10.558 Child and Adult Care Food Program $408,503
10.559 Summer Food Service Program for Children $136,503
16.045 Community-Based Violence Intervention and Prevention Initiative $74,295
14.218 Community Development Block Grants/entitlement Grants $19,717