Finding 1075463 (2022-002)

Material Weakness
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2024-09-27

AI Summary

  • Core Issue: Payroll costs are being allocated based on budget estimates rather than actual employee time records, leading to potential inaccuracies.
  • Impacted Requirements: Compliance with Uniform Guidance section 200.430(h)(8)(i) regarding accurate documentation and internal controls for payroll expenses.
  • Recommended Follow-up: Management should implement a robust system to ensure payroll allocations are based on actual work performed, enhancing internal controls and accuracy.

Finding Text

2022-002 – 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: U.S. Environmental Protection Agency Federal program title: Gulf Coast Ecosystem Restoration Council Comprehensive Plan Assistance Listing Number: 66.130 Award Period: 10/01/2021 – 12/31/2024 Type of Finding: Compliance and material weakness 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, but 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

  • 499020 2022-001
    Material Weakness
  • 499021 2022-002
    Material Weakness
  • 499022 2022-003
    Significant Deficiency
  • 499023 2022-001
    Material Weakness
  • 499024 2022-002
    Material Weakness
  • 499025 2022-003
    Significant Deficiency
  • 1075462 2022-001
    Material Weakness
  • 1075464 2022-003
    Significant Deficiency
  • 1075465 2022-001
    Material Weakness
  • 1075466 2022-002
    Material Weakness
  • 1075467 2022-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
15.657 Endangered Species Recovery Implementation $203,574
66.130 Geographic Programs - Gulf Coast Ecosystem Restoration Council Comprehensive Plan Component $147,787
47.074 Biological Sciences $106,636
15.670 Adaptive Science $105,954
45.312 National Leadership Grants $73,802
45.301 Museums for America $73,643
15.630 Coastal $69,461
10.699 Partnership Agreements $47,778
15.615 Cooperative Endangered Species Conservation Fund $36,804
15.644 Federal Junior Duck Stamp Conservation and Desig $10,573
47.049 Mathematical and Physical Sciences $8,502
10.325 People's Garden $2,502