Finding 607429 (2022-012)

Material Weakness
Requirement
ABH
Questioned Costs
-
Year
2022
Accepted
2023-03-30
Audit: 30350
Organization: Northern New Mexico College (NM)

AI Summary

  • Core Issue: Nine salaried employees lacked required time and effort documentation, violating federal compliance standards.
  • Impacted Requirements: Non-compliance with 2 CFR 200.303(a) and 2 CFR 200.430(i)(1) regarding accurate payroll records and internal controls.
  • Recommended Follow-up: Implement a system to ensure timely collection and review of time and effort certifications to prevent payroll misallocations.

Finding Text

2022-012 ? Activities Allowed or Unallowed, Allowable Costs/Cost Principles, and Period of Performance ? Payroll ? Material Weakness and Material Noncompliance Federal Program Information Funding Agency: Department of Defense, National Science Foundation, Department of Education, Department of Health and Human Services ? National Institute of Health Federal Award Agreement Number: Not Applicable Award Year: Fiscal year 2022 Title: Research and Development Cluster Assistance Listing Number: 12.598, 47.050, 47.076, 84.031, and 93.859 Pass-through Agency: Not Applicable, Direct Program Pass-through Identification Number: Not Applicable, Direct Program Condition - For nine of nine salaried employees tested, there was no time and effort documentation provided for the period under review. Criteria - 2 CFR 200.303(a) requires non-Federal entities to establish and maintain effective internal controls over compliance with Federal statutes, regulations, and the terms and conditions of grant agreements. 2 CFR 200.430(i)(1)(vii) requires that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed, which includes support for the distribution of the employee?s salary or wages among specific activities or cost objectives if the employee works on more than one federal award; a federal award and non-federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. In addition, 2 CFR 200.430(i)(1)(viii) indicates that budget estimates alone do not qualify as support for charges to federal awards, but may be used for interim accounting purposes, provided that (B) significant changes in the corresponding work activity are identified and entered into the records in a timely manner. Short term fluctuations between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) 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.In addition, the College?s grant fiscal management guide requires bi-annual reviews of time and effort certifications and related reports pertaining to split allocations of personnel charges, including the allocation of fringe benefits, will be conducted and maintained for all federal awards by the Compliance Officer. Questioned Costs - Not applicable. Effect - The College could over allocate payroll costs to a particular grant in which the employee did not participate. Cause - The College could not locate the time and effort certifications for the employees selected due to transitions within the payroll and the grant monitoring functions.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 30920 2022-011
    Significant Deficiency
  • 30921 2022-012
    Material Weakness
  • 30922 2022-013
    Significant Deficiency
  • 30923 2022-010
    Material Weakness
  • 30924 2022-011
    Significant Deficiency
  • 30925 2022-012
    Material Weakness
  • 30926 2022-013
    Significant Deficiency
  • 30927 2022-010
    Material Weakness
  • 30928 2022-011
    Significant Deficiency
  • 30979 2022-012
    Material Weakness
  • 30980 2022-013
    Significant Deficiency
  • 30981 2022-010
    Material Weakness
  • 30982 2022-011
    Significant Deficiency
  • 30983 2022-012
    Material Weakness
  • 30984 2022-013
    Significant Deficiency
  • 30985 2022-010
    Material Weakness
  • 30986 2022-011
    Significant Deficiency
  • 30987 2022-012
    Material Weakness
  • 30988 2022-013
    Significant Deficiency
  • 30989 2022-009
    Significant Deficiency Repeat
  • 30990 2022-009
    Significant Deficiency Repeat
  • 30991 2022-009
    Significant Deficiency Repeat
  • 30992 2022-007
    Material Weakness Repeat
  • 30993 2022-008
    Significant Deficiency
  • 30994 2022-007
    Material Weakness Repeat
  • 30995 2022-008
    Significant Deficiency
  • 30996 2022-007
    Material Weakness Repeat
  • 30997 2022-008
    Significant Deficiency
  • 30998 2022-007
    Material Weakness Repeat
  • 30999 2022-008
    Significant Deficiency
  • 31000 2022-007
    Material Weakness Repeat
  • 31001 2022-008
    Significant Deficiency
  • 37998 2022-010
    Material Weakness
  • 607362 2022-011
    Significant Deficiency
  • 607363 2022-012
    Material Weakness
  • 607364 2022-013
    Significant Deficiency
  • 607365 2022-010
    Material Weakness
  • 607366 2022-011
    Significant Deficiency
  • 607367 2022-012
    Material Weakness
  • 607368 2022-013
    Significant Deficiency
  • 607369 2022-010
    Material Weakness
  • 607370 2022-011
    Significant Deficiency
  • 607421 2022-012
    Material Weakness
  • 607422 2022-013
    Significant Deficiency
  • 607423 2022-010
    Material Weakness
  • 607424 2022-011
    Significant Deficiency
  • 607425 2022-012
    Material Weakness
  • 607426 2022-013
    Significant Deficiency
  • 607427 2022-010
    Material Weakness
  • 607428 2022-011
    Significant Deficiency
  • 607430 2022-013
    Significant Deficiency
  • 607431 2022-009
    Significant Deficiency Repeat
  • 607432 2022-009
    Significant Deficiency Repeat
  • 607433 2022-009
    Significant Deficiency Repeat
  • 607434 2022-007
    Material Weakness Repeat
  • 607435 2022-008
    Significant Deficiency
  • 607436 2022-007
    Material Weakness Repeat
  • 607437 2022-008
    Significant Deficiency
  • 607438 2022-007
    Material Weakness Repeat
  • 607439 2022-008
    Significant Deficiency
  • 607440 2022-007
    Material Weakness Repeat
  • 607441 2022-008
    Significant Deficiency
  • 607442 2022-007
    Material Weakness Repeat
  • 607443 2022-008
    Significant Deficiency
  • 614440 2022-010
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.063 Federal Pell Grant Program $2.03M
84.425 Covid-19 Higher Education Emergency Relief Fund-Student Aid Portion $1.71M
84.425 Covid-19 Higher Education Emergency Relief Fund-Institutional Portion $1.38M
84.031 Higher Education Institutional Aid $944,439
84.149 Migrant Education College Assistance Migrant Program $416,392
84.141 Migrant Education High School Equivalency Program $378,027
84.047 Trio-Upward Bound $293,217
93.859 Biomedical Research and Research Training $152,114
84.268 Federal Direct Student Loans-Unsubsidized $151,771
84.268 Federal Direct Student Loans-Subsidized $143,289
84.007 Federal Supplemental Education Opportunitygrant $142,902
84.425 Covid-19 Higher Education Emergency Relief Fund-Minority Servinginstitutions Portion $121,532
47.050 Geosciences $85,207
84.066 Trio_educational Opportunity Centers $72,318
84.048 Career and Technical Education -- Basic Grants to States $71,679
84.002 Adult Education - Basic Grants to States $67,633
84.033 Federal Work Study Program $48,682
47.076 Education and Human Resources $16,739
12.598 Centers for Academic Excellence $4,493