Finding 25332 (2022-003)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-03-26

AI Summary

  • Core Issue: Quarterly reports for HEERF funds were inaccurate and did not match the general ledger.
  • Impacted Requirements: Uniform Guidance mandates timely and accurate reporting for institutional and TCCU funds.
  • Recommended Follow-Up: Implement a grant reconciliation process for future quarterly reports to ensure accuracy.

Finding Text

2022-003 - Reporting Program - COVID-19 Education Stabilization Fund. Assistance Listing Number - 84.425. Federal Agency - U.S. Department of Education. Criteria - Uniform Guidance requires quarterly reporting of HEERF institutional funds and tribally controlled colleges and universities (TCCUs) funds. These reports need to be both timely and accurate in the postings made to the public. Condition/Context - The quarterly reports filed for institutional funds and TCCUs did not reconcile to the amounts expended in the College's general ledger. Cause - The grant payroll and indirect costs for institutional and TCCU amounts were switched between the two funding sources when completing the March 31, 2022 quarterly report. Also, an accrual payroll entry was posted after a quarterly report was filed and inappropriately excluded from the quarterly report filing. A couple of other items were excluded from the report filings in error. Effect - The quarterly institutional and TCCU reports did not agree to the amounts of institutional and TCCU funds expended. Questioned Costs - None. Recommendation - We recommend the College include a grant to date reconciliation when completing the quarterly reports to ensure the amounts reported agree to the amounts expended for each funding type. Views from Responsible Official - The College accepts the recommendation.

Corrective Action Plan

2022-003 - The corrective action plan was documented in our response to the auditor's comment. See the Schedule of Findings and Questioned Costs. Mark Vasina Director of Finance 402-878-3341 June 30, 2023

Categories

Reporting

Other Findings in this Audit

  • 25329 2022-001
    Material Weakness
  • 25330 2022-002
    Material Weakness
  • 25331 2022-001
    Material Weakness
  • 25333 2022-001
    Material Weakness
  • 25334 2022-003
    Material Weakness
  • 25335 2022-001
    Material Weakness
  • 25336 2022-003
    Material Weakness
  • 601771 2022-001
    Material Weakness
  • 601772 2022-002
    Material Weakness
  • 601773 2022-001
    Material Weakness
  • 601774 2022-003
    Material Weakness
  • 601775 2022-001
    Material Weakness
  • 601776 2022-003
    Material Weakness
  • 601777 2022-001
    Material Weakness
  • 601778 2022-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $1.22M
15.027 Assistance to Tribally Controlled Community Colleges and Universities $1.10M
84.031 Higher Education_institutional Aid $1.02M
84.063 Federal Pell Grant Program $298,123
10.500 Cooperative Extension Service $187,257
10.766 Community Facilities Loans and Grants $184,576
21.019 Coronavirus Relief Fund $142,310
10.221 Tribal Colleges Education Equity Grants $117,306
10.222 Tribal Colleges Endowment Program $79,586
47.076 Education and Human Resources $43,000
93.433 Acl National Institute on Disability, Independent Living, and Rehabilitation Research $12,795
15.028 Tribally Controlled Community College Endowments $10,279
84.007 Federal Supplemental Educational Opportunity Grants $8,000
84.033 Federal Work-Study Program $6,000
10.351 Rural Business Development Grant $-12,326