Finding 6860 (2023-002)

Significant Deficiency
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2023-12-28

AI Summary

  • Core Issue: The agency miscalculated payroll costs charged to grants due to outdated allocation spreadsheets not matching approved timesheets.
  • Impacted Requirements: This violates 2 CFR Section 200.303(a) and 200.302, which mandate effective internal controls and accurate financial records for federal awards.
  • Recommended Follow-Up: Update payroll allocation spreadsheets regularly to ensure they align with approved timesheets, preventing claims for unallowable costs.

Finding Text

2023-002 Compliance and Internal Controls over Allowable Costs (Significant Deficiency) Assistance Listing Number 21.027 COVID - 19 Coronavirus State and Local Fiscal Recovery Funds 2022-2023 Funding U.S. Department of Treasury Criteria: Under 2 CFR Section 200.303(a), non‐federal entities must establish and maintain effective internal controls to provide reasonable assurance that the entity is managing the federal awards in compliance with statues, regulations, and the terms and conditions of the award. Additionally, grantees are required to have a detailed breakout of these costs along with any supporting documents for those expenses for auditing and oversight. Title 2 CFR 200.302 requires the financial management system of each non-Federal entity provide records that identify adequately the source and application of funds for federally-funded activities. Condition: We noted instances of the allocation rates being used to calculate amount of payroll costs to charge to grants did not agree to the hours incurred per approved timesheets. Cause: Certain payroll allocation spreadsheets used to calculate amounts to charge grants for payroll costs were not updated to agree with the approved timesheets. Effect: The Agency requested in error reimbursement for unallowable payroll costs. Questioned Costs: $2,668 Perspective: Errors were noted during periods when the prior accounting team was in place or during transition period as the new accounting staff were being hired. Such errors resulted in certain employees’ times under / over allocated, thus reducing overall financial impact. Recommendation: The Agency should update its payroll allocation spreadsheets to agree with the approved timesheets per payroll period to ensure only allowable payroll costs are charged to grants. Views of Responsible Officials: We concur with the recommendation, please see Corrective Action Plan.

Categories

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

Other Findings in this Audit

  • 6855 2023-003
    Significant Deficiency
  • 6856 2023-003
    Significant Deficiency
  • 6857 2023-003
    Significant Deficiency
  • 6858 2023-002
    Significant Deficiency
  • 6859 2023-002
    Significant Deficiency
  • 583297 2023-003
    Significant Deficiency
  • 583298 2023-003
    Significant Deficiency
  • 583299 2023-003
    Significant Deficiency
  • 583300 2023-002
    Significant Deficiency
  • 583301 2023-002
    Significant Deficiency
  • 583302 2023-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
64.033 Va Supportive Services for Veteran Families Program $1.38M
21.027 Coronavirus State and Local Fiscal Recovery Funds $589,133
93.959 Block Grants for Prevention and Treatment of Substance Abuse $536,778
14.218 Community Development Block Grants/entitlement Grants $490,156
64.033 Va Supportive Services for Veteran Families - Shallow Subsidy $260,300
21.023 Emergency Rental Assistance Program $186,484
14.235 Supportive Housing Program $131,302
14.231 Emergency Solutions Grant Program $101,361
64.033 Va Supportive Services for Veteran Families - Legal Services $37,680