Finding 514527 (2024-001)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2024-12-16

AI Summary

  • Core Issue: Time charged to federal grants was not always accurately reflected in timesheets, leading to discrepancies.
  • Impacted Requirements: Compliance with 2 CFR section 200.430, which mandates accurate documentation and internal controls for salary charges.
  • Recommended Follow-Up: Enhance timesheet details and ensure any reallocations are well-documented and justified to support grant charges.

Finding Text

Federal Award Finding 2024-001 US Department of Justice Crime Victims Assistance AL No. 16.575 Pass-Through Grantor New Hampshire Coalition Against Domestic and Sexual Violence Questioned costs – $0 Criteria – 2 CFR section 200.430 requires that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. The records should be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable and properly allocated. Condition – Our testing included sampling 40 timesheets and verifying that the time booked to the grants was properly supported by the approved time sheets. In 5 instances the actual amount charged to the grants deviated from the amount deemed chargeable to the grant per the time sheet. The actual time allocated to the grants was concluded as allowable thus there are no questioned costs. The sample was not intended to be, and was not, a statistically valid sample. Cause – The cause of the discrepancies is due to reallocating time after the timesheets are completed or the use of an incorrect timesheet. Effects or Potential Effects – The effect or potential effect is the lack of proper documentation to support that HAVEN has established a system of internal control that evidences that time charged to the grant was appropriately reviewed for accuracy and allowability. Auditor’s Recommendation – We recommend that time sheets comprehensively detail the employee’s program-related activities, which should then be accurately reflected in the grant allocations. If circumstances require re-allocation of an employee’s time the changes and the reason for the changes should be documented sufficiently to demonstrate the change was properly supported, reviewed and allowable. View of Responsible Officials – HAVEN agrees with the finding and the Office Manager will review all time sheets and document any required changes to support the payroll charged to the grants.

Corrective Action Plan

To ensure that employees are using the correct timesheet, the Office Manager now reviews the timesheets each pay period for grant allocation, formatting and hours prior to executing payroll.

Categories

Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 514528 2024-002
    Significant Deficiency
  • 1090969 2024-001
    Significant Deficiency
  • 1090970 2024-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
16.575 Crime Victim Assistance $419,047
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $416,318
16.736 Transitional Housing Assistance for Victims of Domestic Violence, Dating Violence, Stalking, Or Sexual Assault $251,591
16.017 Sexual Assault Services Formula Program $114,004
14.267 Continuum of Care Program $61,715
93.136 Injury Prevention and Control Research and State and Community Based Programs $40,311
21.027 Coronavirus State and Local Fiscal Recovery Funds $6,382
97.024 Emergency Food and Shelter National Board Program $3,831
94.021 Volunteer Generation Fund $3,418
14.218 Community Development Block Grants/entitlement Grants $2,498