Finding 519969 (2024-001)

Significant Deficiency
Requirement
B
Questioned Costs
$1
Year
2024
Accepted
2025-01-22
Audit: 339414
Organization: Peckham Inc. and Subsidiaries (MI)
Auditor: Maner Costerisan

AI Summary

  • Core Issue: There was a significant deficiency in internal controls, leading to incorrect mapping of employee time to federal grants.
  • Impacted Requirements: Compliance with 2 CFR § 200.430 was not met, resulting in overbilling of labor costs to federal awards.
  • Recommended Follow-Up: Review and adjust the mapping process between timesheets and payroll to ensure accurate allocation of time worked on federal grants.

Finding Text

Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.

Corrective Action Plan

Action to be Taken: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future. This issue was isolated to a specific payroll, where a report did not function as intended. No issues were detected with either prior or future payrolls. However, we have implemented the additional step of checking these reports to timesheets to ensure there are no discrepancies.

Categories

Questioned Costs Allowable Costs / Cost Principles Reporting Significant Deficiency

Other Findings in this Audit

  • 519970 2024-001
    Significant Deficiency
  • 519971 2024-001
    Significant Deficiency
  • 519972 2024-001
    Significant Deficiency
  • 519973 2024-001
    Significant Deficiency
  • 519974 2024-001
    Significant Deficiency
  • 519975 2024-001
    Significant Deficiency
  • 519976 2024-001
    Significant Deficiency
  • 519977 2024-001
    Significant Deficiency
  • 519978 2024-001
    Significant Deficiency
  • 519979 2024-001
    Significant Deficiency
  • 519980 2024-001
    Significant Deficiency
  • 519981 2024-001
    Significant Deficiency
  • 519982 2024-001
    Significant Deficiency
  • 519983 2024-001
    Significant Deficiency
  • 519984 2024-001
    Significant Deficiency
  • 519985 2024-001
    Significant Deficiency
  • 519986 2024-001
    Significant Deficiency
  • 519987 2024-001
    Significant Deficiency
  • 519988 2024-001
    Significant Deficiency
  • 519989 2024-001
    Significant Deficiency
  • 519990 2024-001
    Significant Deficiency
  • 519991 2024-001
    Significant Deficiency
  • 519992 2024-001
    Significant Deficiency
  • 1096411 2024-001
    Significant Deficiency
  • 1096412 2024-001
    Significant Deficiency
  • 1096413 2024-001
    Significant Deficiency
  • 1096414 2024-001
    Significant Deficiency
  • 1096415 2024-001
    Significant Deficiency
  • 1096416 2024-001
    Significant Deficiency
  • 1096417 2024-001
    Significant Deficiency
  • 1096418 2024-001
    Significant Deficiency
  • 1096419 2024-001
    Significant Deficiency
  • 1096420 2024-001
    Significant Deficiency
  • 1096421 2024-001
    Significant Deficiency
  • 1096422 2024-001
    Significant Deficiency
  • 1096423 2024-001
    Significant Deficiency
  • 1096424 2024-001
    Significant Deficiency
  • 1096425 2024-001
    Significant Deficiency
  • 1096426 2024-001
    Significant Deficiency
  • 1096427 2024-001
    Significant Deficiency
  • 1096428 2024-001
    Significant Deficiency
  • 1096429 2024-001
    Significant Deficiency
  • 1096430 2024-001
    Significant Deficiency
  • 1096431 2024-001
    Significant Deficiency
  • 1096432 2024-001
    Significant Deficiency
  • 1096433 2024-001
    Significant Deficiency
  • 1096434 2024-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
17.270 Reintegration of Ex-Offenders $485,414
14.267 Continuum of Care Program $154,491
94.006 Americorps $133,511
93.558 Temporary Assistance for Needy Families $100,150
17.258 Wia Adult Program $83,475
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $47,516
16.726 Juvenile Mentoring Program $33,707
17.259 Wia Youth Activities $24,230
17.278 Wia Dislocated Worker Formula Grants $19,403