Finding 30922 (2022-013)

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

AI Summary

  • Core Issue: Payroll transactions showed a lack of proper documentation, including an unsigned timesheet and an outdated salary contract, leading to potential employee underpayment.
  • Impacted Requirements: Compliance with 2 CFR 200.303(a) and 2 CFR 200.430(i)(1) regarding internal controls and accurate payroll records.
  • Recommended Follow-up: Implement stronger internal controls in payroll processes and ensure timely updates to employee contracts to prevent future discrepancies.

Finding Text

2022-013 ? Activities Allowed or Unallowed, Allowable Costs/Cost Principles, and Period of Performance ? Payroll ? Significant Deficiency 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 - During our review of payroll related transactions, the following were noted. ? For one of 25 payroll transactions tested, the supervisor did not sign the timesheet. ? For one of 25 payroll transactions tested, the employee?s contract was not updated as of July 1, 2021 to the correct salary amount. Therefore, the employee was underpaid a total of $475.29 during the fiscal year. 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) requires that 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; and (ii) be incorporated into the official records of the non-federal entity. Questioned Costs - Not applicable. Effect - The College may unintentionally overpay or underpay employees during their fiscal year. Cause - The College could not locate payroll records due to transition within the payroll and HR departments. In addition, the unsigned timesheet was overlooked.

Corrective Action Plan

Auditors? Recommendation - We recommend the College enhance the design of its control activities and develop procedures to ensure that employee documentation is retained and updated within the employee file and the payroll system.Views of Responsible Officials and Planned Corrective Action - The College agrees with the finding and will instruct supervisors and payroll officials to receive and document all authorizations before payroll is run. Accordingly, Human Resources staff will review each contract with the rate of pay in the payroll system to ensure validation. Responsible Official - Denise Montoya, Vice President for Finance & Administration, Theresa Storey, Chief Financial Officer, and Ken Lucero, Director of Human Resources Timeline and Estimated Completion Date - June 30, 2023

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 30920 2022-011
    Significant Deficiency
  • 30921 2022-012
    Material Weakness
  • 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
  • 607429 2022-012
    Material Weakness
  • 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