Finding 1219164 (2025-002)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2025
Accepted
2026-06-26

AI Summary

  • Core Issue: Payroll costs are charged to federal awards based on budget estimates, not actual employee time, leading to potential inaccuracies.
  • Impacted Requirements: Compliance with Uniform Guidance (2 CFR 200.430) requires payroll systems to reflect actual work and be supported by internal controls.
  • Recommended Follow-Up: MSP should enhance timekeeping processes to ensure payroll accurately reflects work performed and reconcile budget estimates with actual time regularly.

Finding Text

Finding 2025-002 – Allowable costs – payroll Assistance Listing #: 93.671, 14.267 Criteria: In accordance with the Uniform Guidance’s compensation requirements (2 CFR 200.430), payroll systems must be based on records that accurately reflect the work performed and supported by a system of internal controls that provides reasonable assurances that charges are accurate; allowable and reasonable; and properly allocated. The Uniform Guidance allows for use of budget estimates on an interim basis. When using budget estimates on an interim basis, grantees must reconcile estimates against actual time or effort on a regular basis to ensure that estimates conform to actual staff activity. Grantees must make adjustments in the payroll distribution to align with actual time. Condition: As noted in the prior year, MSP charges payroll costs to the federal award programs using a set percentage based on budget and not based on employee’s actual time or effort amongst various programs. Cause: Individual payroll amounts were allocated to grant awards based on internally developed budgets of employees' time. Management continues to work on a solution that will capture costs across the various programs for those employees who work in multiple programs. Effect: The salary costs charged to the federal programs may have been under or over reported based on the actual level of effort. Questioned Costs: N/A Repeat Finding: Yes Recommendation: As noted previously, we recommend MSP make changes overall its timekeeping processes to ensure that payroll costs accurately reflect the work performed and if budget estimates are utilized, that they are reconciled and trued up on a consistent basis. Response: Management continues to work with ADP to modify the existing time card structure. They will assist MSP with creating time cards that will allow employees to sign in to any designated work department therefore the hours will be appropriately broken out by department/grant. The enhancement is still a work in progress and should be in effect no later than May 31, 2026.

Corrective Action Plan

Finding 2025-002: Allowable Costs – Payroll Assistance Listing #: 93.671 Recommendation: Deleon & Stang recommends MSP make changes overall its timekeeping processes to ensure that payroll costs accurately reflect work performed and if budget estimates are utilized, that they are reconciled and trued up on a consistent basis. Management Response: MSP agrees with the recommendation and remains committed to improving its timekeeping and payroll allocation processes. Management is working with ADP to implement a system that captures actual employee time by program and grant, ensuring payroll costs are accurately charged and supported by documented effort. Until full implementation is complete, periodic reconciliations between budgeted and actual time will be performed. Action Plan: 1. Complete ADP system enhancements that allow employees to record time by department,program, and grant. 2. Establish written procedures requiring staff to allocate hours based on actual workperformed. 3. Implement monthly reviews and reconciliations of payroll allocations against actual timerecords. 4. Train supervisors and employees on the revised timekeeping process. 5. Perform quarterly management reviews of payroll distributions and make necessaryadjustments to ensure compliance with Uniform Guidance requirements. 6. Target full implementation and testing of the enhanced timekeeping system prior to thenext audit cycle.

Categories

Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 1219155 2025-002
    Material Weakness Repeat
  • 1219156 2025-002
    Material Weakness Repeat
  • 1219157 2025-002
    Material Weakness Repeat
  • 1219158 2025-002
    Material Weakness Repeat
  • 1219159 2025-001
    Material Weakness Repeat
  • 1219160 2025-002
    Material Weakness Repeat
  • 1219161 2025-001
    Material Weakness Repeat
  • 1219162 2025-002
    Material Weakness Repeat
  • 1219163 2025-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
14.267 CONTINUUM OF CARE PROGRAM $170,749
93.671 FAMILY VIOLENCE PREVENTION AND SERVICES/DOMESTIC VIOLENCE SHELTER AND SUPPORTIVE SERVICES $3,690