Finding 22651 (2022-006)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2023-09-11
Audit: 19281
Organization: Detroit Recovery Project, Inc. (MI)
Auditor: Yeo & Yeo PC

AI Summary

  • Core Issue: There are significant discrepancies in payroll reporting, with no supporting personnel activity reports for all transactions tested.
  • Impacted Requirements: Compliance with 2CFR200.400.430(i) is lacking, as salary charges to federal awards must be based on actual employee activity.
  • Recommended Follow-Up: Management should verify payroll accuracy by ensuring timesheets align with the payroll register and general ledger.

Finding Text

Finding 2022-006, 2021-004, 2020-002 ? Time Reporting/Personnel Activity Reports Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown Context / Criteria: 2CFR200.400.430(i) requires the distribution of salary and wages charged to federal awards should be based on actual employee activity as reflected in personnel activity reports (timesheets), prepared after the fact, which include the total activity for which employees were compensated. Condition: For all payroll transactions selected during our test work, it was noted that the payroll register did not agree to the amounts charged to each grant. Additionally, there was not a personnel activity report (PAR) or timesheet equivalent provided to support the employees? time charged to the grant. For AL 93.243 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 21 of 60 transactions lacked approval for the pay period?s time entry. For AL 93.829 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 18 of 60 transactions lacked approval for the pay period?s time entry. Cause / Effect: The Organization did not have adequate controls in place to ensure amounts charged to the grant were properly supported and approved. Recommendation: We recommend management review payroll for accuracy, including comparing the timesheets/PARs to the payroll register, and the payroll register to the general ledger to ensure time charged to the grant accurately reflects work performed relating to the grant. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.

Categories

Material Weakness Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 22644 2022-005
    Material Weakness
  • 22645 2022-006
    Material Weakness Repeat
  • 22646 2022-007
    Significant Deficiency
  • 22647 2022-005
    Material Weakness
  • 22648 2022-007
    Significant Deficiency
  • 22649 2022-006
    Material Weakness Repeat
  • 22650 2022-005
    Material Weakness
  • 22652 2022-007
    Significant Deficiency
  • 22653 2022-005
    Material Weakness
  • 22654 2022-006
    Material Weakness Repeat
  • 22655 2022-007
    Significant Deficiency
  • 22656 2022-005
    Material Weakness
  • 22657 2022-007
    Significant Deficiency
  • 22658 2022-006
    Material Weakness Repeat
  • 22659 2022-006
    Material Weakness Repeat
  • 22660 2022-005
    Material Weakness
  • 22661 2022-007
    Significant Deficiency
  • 599086 2022-005
    Material Weakness
  • 599087 2022-006
    Material Weakness Repeat
  • 599088 2022-007
    Significant Deficiency
  • 599089 2022-005
    Material Weakness
  • 599090 2022-007
    Significant Deficiency
  • 599091 2022-006
    Material Weakness Repeat
  • 599092 2022-005
    Material Weakness
  • 599093 2022-006
    Material Weakness Repeat
  • 599094 2022-007
    Significant Deficiency
  • 599095 2022-005
    Material Weakness
  • 599096 2022-006
    Material Weakness Repeat
  • 599097 2022-007
    Significant Deficiency
  • 599098 2022-005
    Material Weakness
  • 599099 2022-007
    Significant Deficiency
  • 599100 2022-006
    Material Weakness Repeat
  • 599101 2022-006
    Material Weakness Repeat
  • 599102 2022-005
    Material Weakness
  • 599103 2022-007
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.732 Mental and Behavioral Health Education and Training Grants $353,840
93.939 Hiv Prevention Activities_non-Governmental Organization Based $272,702
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $185,016
93.829 Section 223 Demonstration Programs to Improve Community Mental Health Services $121,144
16.812 Second Chance Act Reentry Initiative $103,678