Finding 512610 (2024-004)

Significant Deficiency
Requirement
ABN
Questioned Costs
-
Year
2024
Accepted
2024-12-02

AI Summary

  • Core Issue: The College lacks proper documentation for Time and Effort reporting, which is essential for tracking hours worked on federal grants.
  • Impacted Requirements: This finding relates to compliance with 2 CFR 200.430 and 2 CFR 200.303, which mandate accurate records for salary charges and effective internal controls.
  • Recommended Follow-Up: The College should review and enhance its policies and procedures to ensure compliance with federal regulations regarding time and effort documentation.

Finding Text

Federal Agency U.S. Department of Education Federal Program Name Higher Educational Institutional Aid Assistance Listing Number 84.031X Federal Award Identification Number and Year " P031X220005 - 2024, P031X200005 - 2024, P031X230006 - 2024" Pass-Through Agency (if applicable) N/A Pass-Through Number(s) (if applicable) N/A Award Period 7/1/23 - 6/30/24 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 questioned costs-therefore we will document as a SD. Additionally qualitatively failure did not have material impact on compliance. Compliance Not Material Document judgment for your assessment Not greater than 5% and not a systemic failure. 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 College did not have proper documentation of Time and Effort reporting. Questioned costs: N/A Known Likely Context During our testing of 40 Payroll transactions, we identified 8 time and effort reports that were not documented properly to track hours worked on federal grant and 12 reports that did not have a documentation of review. Additionally during our testing of 5 key personnel with Level of Effort provisions in the grant award notification, we identified 1 key personnel did not have documentation to track hours for level of effort required by the Federal agency. Cause The College did not have proper procedures in place to track time and effort for personnel on federal grants. Effect The College could potentially expense incorrect amount to federal grants. Repeat Finding No Recommendation "We recommend the College 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 Management agrees with this finding.

Categories

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

Other Findings in this Audit

  • 512600 2024-002
    Significant Deficiency
  • 512601 2024-003
    Significant Deficiency
  • 512602 2024-002
    Significant Deficiency
  • 512603 2024-003
    Significant Deficiency
  • 512604 2024-002
    Significant Deficiency
  • 512605 2024-003
    Significant Deficiency
  • 512606 2024-002
    Significant Deficiency
  • 512607 2024-003
    Significant Deficiency
  • 512608 2024-004
    Significant Deficiency
  • 512609 2024-005
    Significant Deficiency
  • 512611 2024-005
    Significant Deficiency
  • 512612 2024-004
    Significant Deficiency
  • 512613 2024-005
    Significant Deficiency
  • 1089042 2024-002
    Significant Deficiency
  • 1089043 2024-003
    Significant Deficiency
  • 1089044 2024-002
    Significant Deficiency
  • 1089045 2024-003
    Significant Deficiency
  • 1089046 2024-002
    Significant Deficiency
  • 1089047 2024-003
    Significant Deficiency
  • 1089048 2024-002
    Significant Deficiency
  • 1089049 2024-003
    Significant Deficiency
  • 1089050 2024-004
    Significant Deficiency
  • 1089051 2024-005
    Significant Deficiency
  • 1089052 2024-004
    Significant Deficiency
  • 1089053 2024-005
    Significant Deficiency
  • 1089054 2024-004
    Significant Deficiency
  • 1089055 2024-005
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.063 Federal Pell Grant Program $5.93M
84.268 Federal Direct Student Loans $5.13M
84.047 Trio Upward Bound $363,714
21.027 Coronavirus State and Local Fiscal Recovery Funds $338,957
84.042 Trio Student Support Services $312,425
84.031 Higher Education Institutional Aid $208,600
93.558 Temporary Assistance for Needy Families $174,483
84.033 Federal Work-Study Program $164,994
84.002 Adult Education - Basic Grants to States $119,052
84.007 Federal Supplemental Educational Opportunity Grants $83,838
93.575 Child Care and Development Block Grant $67,197
10.559 Summer Food Service Program for Children $58,174
84.335 Child Care Access Means Parents in School $49,897
84.048 Career and Technical Education -- Basic Grants to States $34,852
93.788 Opioid Str $28,968