Finding 513747 (2024-005)

Significant Deficiency
Requirement
ABN
Questioned Costs
$1
Year
2024
Accepted
2024-12-10

AI Summary

  • Core Issue: The University lacks proper documentation for time and effort reporting on federal grants, leading to a significant deficiency in internal controls.
  • Impacted Requirements: Compliance with 2 CFR 200.430(g)(1)(vi) and 2 CFR 200.303 regarding accurate tracking of salaries and wages for federal awards.
  • Recommended Follow-Up: Review and update policies and procedures to ensure all personnel on federal grants properly document time and effort reports as required by federal regulations.

Finding Text

Federal Agency US Department of Education Federal Program Name Higher Education Institutional Aid Assistance Listing Number 84.031S Federal Award Identification Number and Year P031S200249 - 2024 Pass-Through Agency (if applicable) N/A Pass-Through Number(s) (if applicable) N/A Award Period 7/1/2023-6/30/2024 Compliance Requirement Affected Allowable Costs and Special Tests and Provisions Type of Finding Internal Control Significant Deficiency Document judgment for your assessment Control finding did not result in material known questioned costs-therefore we will document as a SD. Additionally the client provided narrative response documents that the project directors complete, but do not quantify actual hours charged to the grant. based on expenditure of grant funds and activities in narrative responses and performance reports the grant work is being adequately completed, but the quantified hour tracking is not present. As such, based on these factors we will consider this to be a significant deficiency. Compliance Not Material Document judgment for your assessment See line 28 for more detailed response Criteria or specific requirement "Per 2 CFR 200.430(g)(1)(vi), Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records should support 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 allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Per 2 CFR 200.303, nonfederal entities receiving federal awards are required to establish and maintain internal controls designed to reasonably ensure compliance with federal laws, regulations, and program compliance requirements." Condition The University did not have proper documentation of Time and Effort reporting. Questioned costs: N/A Known 12,965.60 Likely 333907.5 Context During our testing of 40 Payroll transactions, we identified 38 time and effort reports that were not documented properly to track hours worked on federal grant and did not have a documentation of review. Additionally during our testing of 1 key personnel with Level of Effort provisions in the grant award notification, we identified the key personnel did not have documentation to track hours for level of effort required by the Federal agency. Cause The University did not have proper procedures in place to track time and effort for personnel on federal grants. Effect The University could potentially expense incorrect amount to federal grants. Repeat Finding No Recommendation We recommend the University review policies and procedures to ensure all personnel on federal grants documented time and effort reports as stated in federal regulations. Views of Responsible Officials Agree

Corrective Action Plan

Higher Education Institutional Aid-Assistance Listing No. 84.031S Recommendation: We recommend the University review policies and procedures to ensure all personnel on federal grants documented time and effort reports as stated in federal regulations. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: Time and effort reports will be reviewed and submitted monthly. Name(s) of the contact person(s) responsible for corrective action: Elizabeth McMurphy Planned completion date for corrective action plan: January 31, 2025

Categories

Questioned Costs Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking Special Tests & Provisions

Other Findings in this Audit

  • 513738 2024-002
    Significant Deficiency
  • 513739 2024-003
    Material Weakness Repeat
  • 513740 2024-004
    Significant Deficiency Repeat
  • 513741 2024-002
    Significant Deficiency
  • 513742 2024-003
    Material Weakness Repeat
  • 513743 2024-004
    Significant Deficiency Repeat
  • 513744 2024-002
    Significant Deficiency
  • 513745 2024-003
    Material Weakness Repeat
  • 513746 2024-004
    Significant Deficiency Repeat
  • 513748 2024-006
    Significant Deficiency
  • 513749 2024-002
    Significant Deficiency
  • 513750 2024-003
    Material Weakness Repeat
  • 513751 2024-004
    Significant Deficiency Repeat
  • 1090180 2024-002
    Significant Deficiency
  • 1090181 2024-003
    Material Weakness Repeat
  • 1090182 2024-004
    Significant Deficiency Repeat
  • 1090183 2024-002
    Significant Deficiency
  • 1090184 2024-003
    Material Weakness Repeat
  • 1090185 2024-004
    Significant Deficiency Repeat
  • 1090186 2024-002
    Significant Deficiency
  • 1090187 2024-003
    Material Weakness Repeat
  • 1090188 2024-004
    Significant Deficiency Repeat
  • 1090189 2024-005
    Significant Deficiency
  • 1090190 2024-006
    Significant Deficiency
  • 1090191 2024-002
    Significant Deficiency
  • 1090192 2024-003
    Material Weakness Repeat
  • 1090193 2024-004
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $3.09M
84.063 Federal Pell Grant Program $2.71M
84.031 Higher Education Institutional Aid $950,042
84.047 Trio Upward Bound $344,827
21.027 Coronavirus State and Local Fiscal Recovery Funds $163,840
84.007 Federal Supplemental Educational Opportunity Grants $89,650
84.425 Education Stabilization Fund $54,098
84.033 Federal Work-Study Program $42,337
93.788 Opioid Str $33,516
47.076 Stem Education (formerly Education and Human Resources) $2,456