Finding 1161698 (2024-001)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2025-10-31

AI Summary

  • Core Issue: Two instances of over-allocation to grant-funded programs were identified, leading to inaccurate payroll reporting.
  • Impacted Requirements: Compliance with OMB Uniform Guidance and accurate documentation of employee compensation were not met due to weaknesses in the payroll allocation process.
  • Recommended Follow-Up: Enhance the payroll allocation process by ensuring salary distributions reflect actual work, maintain a robust review and approval process, and periodically assess the allocation methodology for compliance.

Finding Text

Criteria and Context: Organizations that receive federal funding are required to accurately report employee compensation and allocate salaries to programs in accordance with the Office of Management and Budget (OMB) Uniform Guidance, specifically 2 CFR Part 200. These regulations establish a framework to ensure that costs charged to federal awards are reasonable, allocable, and properly documented. When it comes to employee costs, organizations must maintain time and effort records that reflect the actual work performed, especially when staff are funded by multiple programs. These records must account for the total activity for which an employee is compensated and be verified by the employee or a supervisor with direct knowledge of the work. Salary allocations must be based on the relative benefit received by each program, meaning organizations cannot rely on arbitrary splits or budget estimates. Instead, they must use consistent and documented methodologies that align with their internal policies and federal requirements. Compensation must also conform to the terms and conditions of each award and be supported by internal controls that ensure accuracy and compliance. Effective internal control over compliance requires that payroll expenditures be accurately allocated to appropriate funding sources and that such allocations be subject to proper review and approval Condition: During our audit procedures over allowable costs for payroll expenditures, out of a sample of forty we identified two instances of over-allocation to grant-funded programs that occurred in the early part of the fiscal year. These overallocated funds resulted in inaccurate reporting of payroll costs charged to specific grants. Cause and effect: The over-allocations were primarily due to weaknesses in the payroll allocation process. At the beginning of the fiscal year, management utilized a monthly allocation methodology, which lacked sufficient precision and oversight. Additionally, there were instances where payroll allocations were not appropriately reviewed or approved prior to posting. Inaccurate allocation of payroll expenditures may result in noncompliance with grant requirements. Questioned Costs: None reported Identified as a Repeat Finding: No Recommendation: Management should continue enhancing the payroll allocation process by ensuring that all salary distributions are at the actual time worked and substantiated with appropriate documentation. A consistent and well-documented review and approval process should be maintained to uphold transparency and accountability. Additionally, the allocation methodology should be periodically assessed to confirm its alignment with grant requirements and internal control best practices, allowing the organization to remain compliant and responsive to evolving standards. Management Response and Remediation: In the second half of the fiscal year, management transitioned to a more granular allocation approach based on actual pay periods. A more frequent review process was also implemented to monitor payroll allocations and ensure accuracy.

Corrective Action Plan

Audit Finding 2024-001 Reference: Over-allocation of payroll expenditures to grant-funded programs (2 instances out of 40 sampled) ________________________________________ 1. Issue Summary During the audit of allowable payroll costs, two instances of over-allocation to grant-funded programs were identified. These occurred early in the fiscal year due to imprecise monthly allocation methods and insufficient review prior to posting. ________________________________________ 2. Root Cause Analysis • Use of a monthly allocation methodology lacking precision. • Insufficient review and approval of payroll allocations before posting. • Lack of real-time substantiation of salary distributions with actual time worked. ________________________________________ 3. Corrective Actions • Already implemented in the second half of the fiscal year, continue using the granular allocation method based on actual pay periods; including ongoing monitoring. • Implement a mandatory review of payroll allocations by project staff with support from SP&F accountants • Require timesheets or effort certifications and manager’s approval for personnel charged to federal awards. • Update internal payroll allocation policies to reflect new methodology and controls. • Conduct training sessions for finance and staff assigned to grants on revised payroll allocation procedures and compliance requirements. ________________________________________ 4. Responsible Parties Sponsored Projects Finance Team: Transaction reviews Finance Director: Oversight and implementation of corrective actions ________________________________________ 5. Timeline Action Item Target Completion Date Allocation Actual Pay Already implemented Review of Allocations Already implemented Timesheet/Policy Development Already implemented Staff Training Completed initial training, additional will be ongoing

Categories

Allowable Costs / Cost Principles Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1161696 2024-001
    Material Weakness Repeat
  • 1161697 2024-001
    Material Weakness Repeat
  • 1161699 2024-002
    Material Weakness Repeat
  • 1161700 2024-002
    Material Weakness Repeat
  • 1161701 2024-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
98.001 USAID FOREIGN ASSISTANCE FOR PROGRAMS OVERSEAS $12.24M
19.345 INTERNATIONAL PROGRAMS TO SUPPORT DEMOCRACY, HUMAN RIGHTS AND LABOR $281,621
19.510 U.S. REFUGEE ADMISSIONS PROGRAM $83,133
19.121 CONFLICT AND STABILIZATION OPERATIONS $2,931