Finding 22645 (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.

Corrective Action Plan

Audit Finding Reference Number 2022-006: Material Weakness: Time Reporting/Personnel Activity Reports Management agrees with this recommendation and has updated the policies and procedures and communicated those changes to ensure that the Agency adheres to grant requirements, including that the distribution of salary and wages charged to federal programs be based on actual employee activity as reflected in the personnel activity reports. Human Resources and Finance are working together from the date of hire to ensure that all new employees are entered into the system correctly for grant allocation purposes. Any changes to existing staff grant allocations are made only through Human Resources and Finance. A change cannot be made to the system without approval from both departments and then approved by the CEO and/or the COO. Managers and Supervisors are required to monitor and approve all time sheets before they go to Finance for payment to ensure that the proper grant is charged for all employee activity. Payroll is being reviewed by the CEO and/or COO before being submitted to the system by Finance. People and classifications can now be easily tied to grant activity for review and transparency. A periodic internal review will be performed to ensure proper procedures are being followed. These reviews will include adequate verification of approved signatures, reconciliation of time changes to job cost reports, labor distribution and payroll records and periodic floor checks that verify jobs charged are the jobs worked. Management believes these actions will remediate any concerns raised in the audit report.

Categories

Material Weakness Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 22644 2022-005
    Material Weakness
  • 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
  • 22651 2022-006
    Material Weakness Repeat
  • 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