Finding 1075828 (2023-001)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2024-09-30
Audit: 322245

AI Summary

  • Core Issue: Payroll costs are being allocated based on budget estimates rather than actual employee work records, leading to potential inaccuracies.
  • Impacted Requirements: Compliance with Uniform Guidance section 200.430(h)(8)(i) is not met, as there is no effective internal control system to ensure accurate payroll documentation.
  • Recommended Follow-up: Management should implement a robust process to track and verify employee time against payroll costs allocated to federal grants.

Finding Text

2023-001 – Allowable Costs/Cost Principles (Allocation of Payroll) Federal Agency: U.S. Department of the Interior; U.S. Fish & Wildlife Service Federal program title: Endangered Species Conservation Recovery Implementation Funds Assistance Listing Number: 15.657 Award Period: 09/30/2020 – 09/30/2026 Type of Finding: Compliance and material weakness in internal control over compliance and Federal Agency: National Science Foundation Federal program title: Research and Mentoring for Postbaccalaureates in Biological Sciences Assistance Listing Number: 47.074 Award Period: 04/01/2022 – 09/30/2026 Type of Finding: Compliance and material weakness in internal control over compliance Criteria: Uniform Guidance section 200.430(h)(8)(i) indicates that the standards for documentation of personnel expenses are such that (1) Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:(i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the nonfederal entity and(iii) Reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, not exceeding 100% of compensated activities. Furthermore, subsection (viii) indicates: Budget estimates alone do not qualify as support for charges to federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) Significant changes in the corresponding work activity are identified and entered into the records in a timely manner and (C) The nonfederal entity’s system of internal controls includes processes to review after-the-fact interim charges made to a federal awards based on budget estimates. Condition: The Garden is allocating payroll costs to grants based upon budgeted amounts/percentages submitted to the funding agency and does not currently have a system for ensuring that the estimates used produce reasonable approximations of the activity actually performed. Questioned Costs: Unknown. Context: This condition occurred in all payroll transactions selected for testing. Cause: The Garden has a tracking system in place to monitor the wages by employee charged to federal grants to avoid over-allocation of individual employee wages per the grant budget; however, this tracking system does not contain a process for identifying and allocating wages based on submitted time records. Effect: Inaccurate payroll costs may be charged to federal programs if the Garden does not have procedures in place to monitor and record employee time devoted to federal programs. Recommendation: Management should develop a process whereby payroll costs allocated to federal grants are supported by a system of internal controls which provides reasonable assurance that the charges are accurate allowable and properly allocated, reasonably reflect the total activity for which the employee is compensated, and support the distribution of the employee’s wages among specific activities or cost objectives if the employee works on more than one federal award. Management’s Response Refer to the Correction Action Plan.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 499386 2023-001
    Material Weakness Repeat
  • 499387 2023-002
    Significant Deficiency Repeat
  • 499388 2023-001
    Material Weakness Repeat
  • 499389 2023-002
    Significant Deficiency Repeat
  • 1075829 2023-002
    Significant Deficiency Repeat
  • 1075830 2023-001
    Material Weakness Repeat
  • 1075831 2023-002
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
47.074 Biological Sciences $525,558
15.657 Endangered Species Recovery Implementation $393,739
45.312 National Leadership Grants $138,954
66.130 Geographic Programs - Gulf Coast Ecosystem Restoration Council Comprehensive Plan Component $118,457
10.699 Partnership Agreements $79,424
45.301 Museums for America $72,024
15.630 Coastal $51,916
15.670 Adaptive Science $37,938
15.615 Cooperative Endangered Species Conservation Fund $32,057
15.660 Candidate Species Conservation $20,885
15.664 Fish and Wildlife Coordination and Assistance $12,359
10.001 Agricultural Research Basic and Applied Research $8,715
15.631 Partners for Fish and Wildlife $7,078
47.049 Mathematical and Physical Sciences $2,000