Finding 511975 (2023-004)

Material Weakness Repeat Finding
Requirement
A
Questioned Costs
$1
Year
2023
Accepted
2024-11-25

AI Summary

  • Core Issue: Payroll costs submitted for reimbursement did not match approved timesheets, violating compliance with allowable cost requirements.
  • Impacted Requirements: Records must accurately reflect work performed, supported by internal controls ensuring accurate and allowable time charges.
  • Recommended Follow-Up: Implement a process to record time based on timesheets and establish a review to compare payroll hours with approved timesheets.

Finding Text

Allowable Costs – Ryan White Part B HIV Care Formula Grants – Federal Assistance Listing Number 93.917; Award Period: Year ended June 30, 2023; Pass-through entity names: Virginia Department of Health and Northern Virginia Regional Commission. Allowable Costs – Housing Opportunities For Persons With AIDS – Federal Assistance Listing Number 14.241; Award Period: Year ended June 30, 2023. Criteria: Per 2 CFR §200.430(i), non-federal entities are required to maintain records that accurately reflect work performed. These records must be supported by a system of internal control which provides reasonable assurance that the time being charged is accurate, allowable and properly allocated, are incorporated in the official records, such as payroll records, reasonably reflect the employee’s total activity, provide a time or percentage breakdown on all activities, both federally and non-federally funded, for the employee, and comply with the non-federal entity’s pre-established accounting practices and procedures. Condition: The Organization allowed payroll related costs to be submitted for reimbursement under the grant for time that did not match approved timesheets. This is not in compliance with program allowable cost requirements. Cause: There is a lack of review of payroll registers to compare to timesheets to ensure the proper number of hours are submitted for reimbursement. Effect: The Organization billed the incorrect amount of payroll and related costs to the federal program, resulting in questioned costs. Questioned Costs: The amount of payroll and related costs discovered to be incorrect. Context: Timesheets of numerous employees were found to not match the hours used in calculating payroll to be submitted for reimbursement to the grant. Recommendation: We recommend the Organization implement a process to first record time into the payroll system based on timesheets, then further implement a review process to compare the payroll register hours to the approved timesheets. Views of Responsible Officials: The Organization would like to note that the repeat finding is a result of the prior audit being completed near the end of the year ended June 30, 2023. The auditee agrees with this recommendation and has taken the necessary steps to prevent a re-occurrence. Lack of timesheets and pay rates resulted in the inability to show that time and payroll were accurately recorded. This resulted in additional procedures during the audit process being performed to obtain reasonable assurance over these balances.

Corrective Action Plan

Finding: The Organization allowed payroll related costs to be submitted for reimbursement under the grant for time that did not match approved timesheets. This is not in compliance with program allowable cost requirements. The amount of payroll and related costs discovered to be incorrect was a net amount of $1,336, which when projected onto the remaining payroll and related costs that were not tested, amounted to $28,521. Corrective Action Taken or Planned: The Organization will review audit findings and ensure accurate future reimbursements, develop a comprehensive process for verifying time sheets against service delivery, and implement a paper timesheet system in which supervisors must enter time based on timesheets, ensuring 1:1 reimbursement. Name of Contact Person: Jacob Ducey, Grants Manager Phone Number of Contact Person: (540) 907-4555 Projected Completion Date: October 31, 2024

Categories

Questioned Costs Internal Control / Segregation of Duties Subrecipient Monitoring Allowable Costs / Cost Principles Cash Management Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 511976 2023-004
    Material Weakness Repeat
  • 511977 2023-004
    Material Weakness Repeat
  • 511978 2023-004
    Material Weakness Repeat
  • 511979 2023-004
    Material Weakness Repeat
  • 1088417 2023-004
    Material Weakness Repeat
  • 1088418 2023-004
    Material Weakness Repeat
  • 1088419 2023-004
    Material Weakness Repeat
  • 1088420 2023-004
    Material Weakness Repeat
  • 1088421 2023-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.917 Hiv Care Formula Grants $1.15M
93.914 Hiv Emergency Relief Project Grants $151,012
93.940 Hiv Prevention Activities_health Department Based $68,056
14.241 Housing Opportunities for Persons with Aids $16,814
14.218 Community Development Block Grants/entitlement Grants $4,515