Finding 1177813 (2024-005)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2026-03-10

AI Summary

  • Core Issue: Payroll costs for federal programs were allocated based on budget estimates instead of actual time worked, violating federal regulations.
  • Impacted Requirements: Compliance with 2 CFR §200.430(i) is at risk due to lack of proper time and effort reporting for employees charged to federal grants.
  • Recommended Follow-Up: Implement a system to ensure payroll allocations are based on actual time worked, require documentation for all employees, and establish separate approvals for payroll processing.

Finding Text

Findings 2024-005 – All Federal Programs – Significant Deficiency Type of Finding: Significant Deficiency in Internal Control over Compliance and Compliance – Allowable Costs (Payroll) Federal Agency: National Science Foundation Federal Program Name: Research and Development Cluster - NSF Technology, Innovation and Partnerships CO-WY Climate Resilience Engine Assistance Listing Number: 47.084 Federal Award Identification Number: 2315760 Award Period: March 1, 2024 – February 28, 2026 Criteria or specific requirement: Federal regulations require that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. Per 2 CFR §200.430(i), payroll allocations must be supported by after-the-fact records of actual time worked rather than budget. Condition: It was noted through our testing that the Organization allocated salaries and wages to the program based on budgeted percentages rather than after-the-fact records of time and efforts expended by employees. Individuals whose time is fully charged to federal grants are also not required to provide time and effort reporting. Further, for one of the five individuals selected, the individual timesheet could not be located. Questioned costs: Unknown Context: Based on our testing of payroll, for the one individual out of five selected that had time allocated to multiple grants and programs, no time and effort reporting was available to support the allocation to the federal grant. There was also not a consistent process of reviewing and approving payroll time sheets and registers by management. There was also no time reporting required to support individuals that were fully charged to the grant. Cause: The Organization does not currently have a payroll system whereby individuals are required to record time and effort by program or grant. Allocations are entered into the system based on expected budgets for grant programs when individuals participate in more than one program. The payroll system also did not require payroll to be initiated and approved by separate individuals. Effect: As a result, there is an increased risk that payroll costs charged to the federal program do not accurately reflect the actual effort expended, which could result in unallowable costs being charged to the grant. This practice does not comply with federal requirements for documentation of personnel expenses. Repeat finding: No Recommendation: We recommend that the Organization implement procedures to ensure that payroll allocations to federal programs are supported by after-the-fact records of actual time worked, in accordance with 2 CFR part 200.430(i). The Organization should discontinue the use of budget estimates for payroll allocations and require contemporaneous documentation of time and effort for all employees whose salaries are charged to federal awards. Payroll should be initiated and reviewed by different individuals and the process should include a way to verify either manually or electronically that payroll was approved prior to processing. Views of responsible officials: There is no disagreement with the audit finding. See Corrective Action Plan.

Corrective Action Plan

Management will implement procedures to ensure payroll costs charged to federal awards are supported by after-the-fact documentation of actual time worked, in compliance with 2 CFR §200.430(i). Employees whose time is allocated to multiple programs will be required to complete time and effort reporting. Payroll processing will include documented review and approval by separate individuals to strengthen internal controls and ensure accurate allocation of personnel costs.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1177798 2024-002
    Material Weakness Repeat
  • 1177799 2024-002
    Material Weakness Repeat
  • 1177800 2024-002
    Material Weakness Repeat
  • 1177801 2024-002
    Material Weakness Repeat
  • 1177802 2024-003
    Material Weakness Repeat
  • 1177803 2024-003
    Material Weakness Repeat
  • 1177804 2024-003
    Material Weakness Repeat
  • 1177805 2024-003
    Material Weakness Repeat
  • 1177806 2024-004
    Material Weakness Repeat
  • 1177807 2024-004
    Material Weakness Repeat
  • 1177808 2024-004
    Material Weakness Repeat
  • 1177809 2024-004
    Material Weakness Repeat
  • 1177810 2024-005
    Material Weakness Repeat
  • 1177811 2024-005
    Material Weakness Repeat
  • 1177812 2024-005
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
11.020 CLUSTER GRANTS $601,740
47.084 NSF TECHNOLOGY, INNOVATION, AND PARTNERSHIPS $436,697
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $241,387