Finding 1221739 (2025-003)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2025
Accepted
2026-06-30
Audit: 406001
Organization: Women's Center (MI)

AI Summary

  • Core Issue: Minor discrepancies were found between employee hours reported on PARs and the payroll system, as well as in benefit charges.
  • Impacted Requirements: Internal controls over salary and benefit allocations must ensure accurate records reflecting actual work performed.
  • Recommended Follow-Up: Implement a review process to align payroll data with PARs and ensure benefits match supporting documents.

Finding Text

2025-003 – INTERNAL CONTROLS OVER PAYROLL AND BENEFITS ALLOCATIONS Federal Agency: U.S. Department of Justice Federal Program: Victim of Crimes Act (VOCA) Assistance Listing Number(s): 16.575 Pass-through Agency: Michigan Department of Health and Human Services Grant Number(s): E20252997, E20254232, and E20252320 Condition: The Organization utilized PARs to allocate employee time between programs. During the payroll testing some minor variances were noted between the hours reported on the PARs and the hours recorded in the payroll system. Additionally, some minor variances were noted in charges for benefits compared to supporting documents. Criteria: Organizations must have proper internal control over allocations regarding salaries and wages and fringe benefits. In addition, allocations must be based on records that accurately reflect the work performed. It is the Organization’s procedure to utilize personnel activity reports (PARs) for its records to accurately reflect the work performed. Cause: Due to limited staffing, the Organization does not have a procedure in place to review manual inputs into the accounting system. Effect: The Organization did not follow proper internal controls due to reported hours having minor differences compared to actual timesheets and fringe benefits not matching supporting documentation. Questioned Costs: Not applicable. Perspective: Of the sixty (60) transactions selected for review, twelve (12) had errors in total hours, hours allocations, or benefit allocations. Repeat Finding: No. Recommendation: The Organization should have a review process to ensure the payroll system matches the PARs and benefits match the supporting documents. Views of Responsible Officials: Management agrees with the finding. See separate Corrective Action Plan.

Corrective Action Plan

2025-003 INTERNAL CONTROLS OVER PAYROLL AND BENEFITS ALLOCATIONS Corrective Action Plan: The Organization has implemented a pre-payroll review process requiring supervisors to verify the accuracy of employee timesheets before submitting them to the Finance Manager. The Finance Manager will conduct a secondary review of timesheets before entering and processing payroll. In addition, the Organization has implemented a new benefits software administration system to improve the accuracy of benefit tracking and allocations. Any discrepancies identified during the review process will be corrected promptly before payroll is finalized. Responsible Party(ies): • Finance Manager Anticipated Date of Completion: September 30, 2026

Categories

Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1221737 2025-003
    Material Weakness Repeat
  • 1221738 2025-003
    Material Weakness Repeat
  • 1221740 2025-004
    Material Weakness Repeat
  • 1221741 2025-004
    Material Weakness Repeat
  • 1221742 2025-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.671 FAMILY VIOLENCE PREVENTION AND SERVICES/DOMESTIC VIOLENCE SHELTER AND SUPPORTIVE SERVICES $139,063
93.497 FAMILY VIOLENCE PREVENTION AND SERVICES/ SEXUAL ASSAULT/RAPE CRISIS SERVICES AND SUPPORTS $84,795
16.589 RURAL DOMESTIC VIOLENCE, DATING VIOLENCE, SEXUAL ASSAULT, AND STALKING ASSISTANCE PROGRAM $76,734
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $63,329
16.575 CRIME VICTIM ASSISTANCE $60,688
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $40,591