Finding 583407 (2022-004)

Material Weakness
Requirement
A
Questioned Costs
$1
Year
2022
Accepted
2024-01-02

AI Summary

  • Core Issue: Payroll costs submitted for reimbursement did not match approved timesheets, violating compliance requirements.
  • Impacted Requirements: Accurate record-keeping per 2 CFR §200.430(i) is essential for reflecting work performed and ensuring allowable costs.
  • Recommended Follow-up: Implement a process to record time based on timesheets and establish a review system 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, 2022; Pass-through entity names: Virginia Department of Health and Northern Virginia Regional Commission 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 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. 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 amount 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 was a net amount of $25, which when projected onto the remaining payroll and related costs that were not tested, amounted to $1,038. Context: Timesheets of numerous employees were found to not match the hours used in calculating payroll to be submitted for reimbursement to the grant.

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

  • 6965 2022-004
    Material Weakness
  • 6966 2022-005
    Significant Deficiency
  • 583408 2022-005
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.917 Hiv Care Formula Grants $1.36M
93.914 Hiv Emergency Relief Project Grants $144,857
93.940 Hiv Prevention Activities_health Department Based $79,889
14.241 Housing Opportunities for Persons with Aids $5,044