Finding 48147 (2022-001)

Material Weakness
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2023-01-18

AI Summary

  • Core Issue: The Foundation's payroll system lacks consistent supervisor approval for hourly employee timecards, and salaried employee allocations are not properly documented.
  • Impacted Requirements: This finding violates 2 CFR section 200.430, which mandates accurate documentation of employee compensation and after-the-fact reviews for budgeted payroll costs.
  • Recommended Follow-Up: Strengthen controls to ensure compliance with established procedures for hourly employees and implement documentation processes for salaried employees' time allocations.

Finding Text

Finding #: 2022-001 Federal Program: Research and Development Cluster Type of Finding: Allowable Costs/Cost Principles Criteria: In accordance with the documentation standards of 2 CFR section 200.430(i), costs of compensation for personal services are allowable to the extent the total compensation for individual employees is determined and supported as provided in 2 CFR section 200.430(i), including that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. Furthermore, as provided in 2 CFR section 200.430(i), budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: 1. The system for establishing the estimates produces reasonable approximations of the activity actually performed; 2. Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and 3. The non-Federal entity's system of internal controls includes processes to review after-the-fact interim charges made to a Federal award based on budget estimates. All necessary adjustment must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated. 2 CFR section 200.303 requires that federal award recipients establish and maintain internal control over federal awards that provides reasonable assurance that the recipient is managing the federal awards in compliance with federal statues, regulations, and the terms and conditions of the federal awards. Condition: The Foundation has a payroll system in place that requires hourly employees to submit time cards for approval by their direct supervisors. The approval is a key control ensuring that time coded to a federal award is allowable under the terms of that award. In our sample of timecards for hourly employees charged to Research and Development awards, there were multiple instances in which the time cards were not approved by the supervisor. Salaried employees are not required to submit time cards, and instead, the allocation of salaried employees? level of effort and payroll amount is determined during the budgeting phase. Documentation of an after-the-fact review to ensure that budgeted allocation was reflective of actual effort incurred was not retained as required by 2 CFR 200.430. Context: Of the $965,346 in expenditures coded to the Research and Development cluster of awards for the year ended June 30, 2022, $255,617 represented payroll costs. Cause: The Foundation has an established process and control procedures for approval of hourly employee?s costs charged to federal awards but that process was not followed consistently. The Foundation also has processes and procedures in place over salaried employees, however they were not documented to sufficiently support the provision under Uniform Guidance which requires an after-the-fact review of any budgeted payroll costs allocated to awards to ensure they are reflective of actual time incurred.Effect: Internal controls were not operating effectively. Questioned Costs: N/A Recommendation: We recommend that the Foundation strengthen controls to ensure adherence to its own established procedures for hourly employees and to supplement controls for salaried employees.

Categories

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

Other Findings in this Audit

  • 48131 2022-001
    Material Weakness
  • 48132 2022-001
    Material Weakness
  • 48133 2022-001
    Material Weakness
  • 48134 2022-001
    Material Weakness
  • 48135 2022-001
    Material Weakness
  • 48136 2022-001
    Material Weakness
  • 48137 2022-001
    Material Weakness
  • 48138 2022-001
    Material Weakness
  • 48139 2022-001
    Material Weakness
  • 48140 2022-001
    Material Weakness
  • 48141 2022-001
    Material Weakness
  • 48142 2022-001
    Material Weakness
  • 48143 2022-001
    Material Weakness
  • 48144 2022-001
    Material Weakness
  • 48145 2022-001
    Material Weakness
  • 48146 2022-001
    Material Weakness
  • 624573 2022-001
    Material Weakness
  • 624574 2022-001
    Material Weakness
  • 624575 2022-001
    Material Weakness
  • 624576 2022-001
    Material Weakness
  • 624577 2022-001
    Material Weakness
  • 624578 2022-001
    Material Weakness
  • 624579 2022-001
    Material Weakness
  • 624580 2022-001
    Material Weakness
  • 624581 2022-001
    Material Weakness
  • 624582 2022-001
    Material Weakness
  • 624583 2022-001
    Material Weakness
  • 624584 2022-001
    Material Weakness
  • 624585 2022-001
    Material Weakness
  • 624586 2022-001
    Material Weakness
  • 624587 2022-001
    Material Weakness
  • 624588 2022-001
    Material Weakness
  • 624589 2022-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
59.075 Shuttered Venue Operators Grant $10.00M
11.011 Noaa: Paleolandscapes, Paleoecology, and Cultural Heritage $163,123
47.076 Collaborative Research: Re-Living Paleontology: Studying How Augmented Reality Immersion and Interaction Impact Engagement and Communicating Science to the Public $162,365
47.074 Digitization Tcn: Collaborative Research: Documenting Marine Biodiversity Through Digitization of Invertebrate Collections (digin) $136,158
47.074 Mri: Acquisition of A Scanning Electron Microscope for Research, Education, and Exhibit Programs at the Natural History Museum of Los Angeles County $130,809
47.074 Collaborative Research: Digitization Tcn: Extending Anthophila Research Through Image and Trait Digitization (big-Bee) $70,146
47.050 Collaborative Research: Gateway to North America--the Great American Biotic Interchange (gabi) in Mexico and Origin of C4 Grassland $54,631
47.074 Digitization Pen: Cryptovert - Digitizing Small-Bodied Cryptobenthic Fishes for the Overttcn $54,206
47.050 Collaborative Research: Understanding the Evolution of High-Latitude Permo-Triassic Paleoenvironments and Their Vertebrate Communities $48,841
47.074 Digitization Pen-Collaborative Research: the Cretaceous World $39,011
81.086 Informed Design of Crystalline Ion Exchangers: Improved I>-Mno2 Phase for Lithium Extraction From Geologic Fluids $29,274
45.312 Bears Ears: Living Land $27,823
43.001 NASA Surviving A Mass Extinction $25,313
47.076 Developing Elementary and Secondary Master Teachers in Mathematics and Science (subaward) $24,394
45.301 La Brea Tart Pits Mobile Museum $16,782
47.074 Digitization Tcn: Collaborative Research: Mobilizing Millions of Marine Mollusks of the Eastern Seaboard $11,755
47.050 Collaborative Research: Assessing Millennial-Scale Community Dynamics Using Highly-Resolved Mammal and Vegetation Food Webs $7,165
15.923 Natl Center for Preservation Technology and Training $5,109
47.076 Science Learning $2,864
47.050 Collaborative Research: Chronology and Ecology of Late Pleistocene Megafauna at Rancho La Brea $182