Audit 43389

FY End
2022-06-30
Total Expended
$286.32M
Findings
6
Programs
35
Year: 2022 Accepted: 2023-02-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
42629 2022-001 Material Weakness - N
42630 2022-001 Material Weakness - N
42631 2022-001 Material Weakness - N
619071 2022-001 Material Weakness - N
619072 2022-001 Material Weakness - N
619073 2022-001 Material Weakness - N

Programs

ALN Program Spent Major Findings
84.063 Federal Pell Grant Program $82.33M Yes 1
84.268 Federal Direct Student Loans $33.78M Yes 1
84.007 Federal Supplemental Educational Opportunity Grants $5.09M Yes 1
21.019 Coronavirus Relief Fund $1.96M - 0
12.905 Cybersecurity Core Curriculum $697,496 - 0
84.044 Trio_talent Search $562,529 - 0
84.048 Career and Technical Education -- Basic Grants to States $376,346 Yes 0
17.207 Employment Service/wagner-Peyser Funded Activities $296,071 - 0
84.425 Education Stabilization Fund $294,301 Yes 0
84.042 Trio_student Support Services $287,725 - 0
84.047 Trio_upward Bound $263,116 - 0
84.033 Federal Work-Study Program $257,726 Yes 0
17.285 Apprenticeship USA Grants $189,377 - 0
93.142 Niehs Hazardous Waste Worker Health and Safety Training $147,283 - 0
84.002 Adult Education - Basic Grants to States $95,621 - 0
17.268 H-1b Job Training Grants $90,715 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $82,809 - 0
19.040 Public Diplomacy Programs $75,190 - 0
59.037 Small Business Development Centers $70,059 - 0
93.958 Block Grants for Community Mental Health Services $68,495 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $66,085 - 0
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health $65,834 - 0
20.235 Commercial Motor Vehicle Operator Safety Training Grants $46,194 - 0
84.016 Undergraduate International Studies and Foreign Language Programs $26,728 - 0
14.218 Community Development Block Grants/entitlement Grants $25,078 - 0
84.031 Higher Education_institutional Aid $16,109 - 0
10.902 Soil and Water Conservation $15,766 - 0
84.116 Fund for the Improvement of Postsecondary Education $12,791 - 0
84.334 Gaining Early Awareness and Readiness for Undergraduate Programs $6,270 - 0
47.076 Education and Human Resources $5,979 - 0
45.129 Promotion of the Humanities_federal/state Partnership $3,207 - 0
11.307 Economic Adjustment Assistance $1,743 - 0
84.220 Centers for International Business Education $1,296 - 0
84.015 National Resource Centers Program for Foreign Language and Area Studies Or Foreign Language and International Studies Program and Foreign Language and Area Studies Fellowship Program $847 - 0
84.305 Education Research, Development and Dissemination $390 - 0

Contacts

Name Title Type
XGMKKTCV87C1 Adam Abner Auditee
7657609638 Beth Kelley, CPA Auditor
No contacts on file

Notes to SEFA

Accounting Policies: All expenses on federal awards expended by Ivy Tech Community College of Indiana (College) have been included in the Schedule of Expenditures of Federal Awards (Schedule). Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards requires an annual audit of any entity expending a total amount of federal awards equal to or in excess of $750,000 in any fiscal year unless by constitution or statute a less frequent audit is required. In accordance with the Indiana Code (IC 5-11-1 et seq.), audits of universities shall be conducted annually. Because the Schedule presents only a selected portion of the activities of the College, it is not intended to and does not present either the financial position, change in net position, or change in cash flows of the College. The accounting principles followed by the College and used in preparing the accompanying Schedule are as follows: Awards Other Than Student Financial Assistance: Deductions (expenditures) for direct costs are recognized as incurred using the accrual method of accounting and the cost accounting principles contained in the U.S. Office of Management and Budget (OMB) Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Under those cost principles, certain types of expenditures are not allowable or are limited as to reimbursement. Moreover, expenditures include a portion of costs associated with general college activities (indirect costs) which are allocated to federal awards under negotiated indirect cost rates or rates specific to a funding opportunity. Student Financial Assistance: Expenditures are recognized and reported in the Schedule for non-loan awards made to students under various programs, e.g., Pell, SEOG and Federal Workstudy. Student loan programs are funded by the federal government mainly under the Direct Loan program. The accompanying Schedule has been prepared in a format that presents summary financial information of the federal funds awarded to the College directly from federal agencies as well as amounts received as sub grantee of other organizations. The College did not elect to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

FINDING 2022-001 Subject: Student Financial Assistance Cluster - Special Tests and Provisions - Return of Title IV Funds Federal Agency: Department of Education Federal Programs: Federal Supplemental Educational Opportunity Grants, Federal Pell Grant, Federal Direct Student Loans Assistance Listings Numbers: 84.007, 84.063, 84.268 Federal Award Number and Year (or Other Identifying Number): FY 2022 Compliance Requirement: Special Tests and Provisions - Return of Title IV Funds Audit Findings: Material Weakness, Other Matters Condition and Context The College had not designed, nor implemented an effective internal control system to ensure compliance with requirements related to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. For 2 of 25 (8 percent) return of Title IV funds tested, the amount returned to the Department of Education was incorrect. The College completed an initial return of Title IV funds and properly posted the full amount of aid to be returned to the students' accounts. During an internal review, the College discovered an error in the initial calculation and therefore calculated a new return of Title IV funds. When the subsequent calculation was performed, the College once again posted the total amount of aid to be returned to each student's account. As a result, the College incorrectly returned too much in Title IV funds to the Department of Education in the amounts of $113 and $546 for the first and second errors, respectively. In addition, this caused both students' accounts to reflect a balance due to the College that should not have been owed. The lack of internal controls and noncompliance were systemic issues throughout the audit period; however, these were isolated to students for which a corrective calculation for return of Title IV funds was performed. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 34 CFR 668.22(g) states in part: "Return of unearned aid, responsibility of the institution. (1) The institution must return, in the order specified in paragraph (i) of this section, the lesser of ? (i) (ii) Cause The total amount of unearned title IV assistance to be returned as calculated under paragraph (e)(4) of this section; or An amount equal to the total institutional charges incurred by the student for the payment period or period of enrollment multiplied by the percentage of title IV grant or loan assistance that has not been earned by the student, as described in paragraph (e)(3) of this section. . . ." Management had not developed a system of internal control that would have ensured procedures were in place in order to comply with the provisions of federal statutes, regulations, and the terms and conditions of the federal award in relation to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. The College should have considered the original amount of aid to be returned that had already been posted to each student's account. The College should have posted the additional amount of aid to be returned to the students' accounts based upon the net difference between the original calculation and the corrective calculation performed for each student. Effect The failure to design and implement an effective internal control system enabled material noncompliance to remain undetected. As a result, the College returned too much in Title IV funds to the Department of Education as outlined in the Condition and Context. Questioned Costs There were no questioned costs identified. Recommendation We recommended the College's management design and implement a system of internal control related to procedures for calculating the return of Title IV funds to ensure appropriate amounts are returned to the Department of Education and are posted to students' accounts. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response It is the College's responsibility to administer its student financial assistance programs in a manner that both complies with applicable federal regulations and guidelines as well as ensures that, when necessary, the appropriate amount of unearned financial assistance is returned to the Title IV programs. 34 CFR 668.22(g) states in part: "Return of unearned aid, responsibility of the institution. (1) The institution must return, in the order specified in paragraph (i) of this section, the lesser of ? (i) (ii) Cause The total amount of unearned title IV assistance to be returned as calculated under paragraph (e)(4) of this section; or An amount equal to the total institutional charges incurred by the student for the payment period or period of enrollment multiplied by the percentage of title IV grant or loan assistance that has not been earned by the student, as described in paragraph (e)(3) of this section. . . ." Management had not developed a system of internal control that would have ensured procedures were in place in order to comply with the provisions of federal statutes, regulations, and the terms and conditions of the federal award in relation to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. The College should have considered the original amount of aid to be returned that had already been posted to each student's account. The College should have posted the additional amount of aid to be returned to the students' accounts based upon the net difference between the original calculation and the corrective calculation performed for each student. Effect The failure to design and implement an effective internal control system enabled material noncompliance to remain undetected. As a result, the College returned too much in Title IV funds to the Department of Education as outlined in the Condition and Context. Questioned Costs There were no questioned costs identified. Recommendation We recommended the College's management design and implement a system of internal control related to procedures for calculating the return of Title IV funds to ensure appropriate amounts are returned to the Department of Education and are posted to students' accounts. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response It is the College's responsibility to administer its student financial assistance programs in a manner that both complies with applicable federal regulations and guidelines as well as ensures that, when necessary, the appropriate amount of unearned financial assistance is returned to the Title IV programs.
FINDING 2022-001 Subject: Student Financial Assistance Cluster - Special Tests and Provisions - Return of Title IV Funds Federal Agency: Department of Education Federal Programs: Federal Supplemental Educational Opportunity Grants, Federal Pell Grant, Federal Direct Student Loans Assistance Listings Numbers: 84.007, 84.063, 84.268 Federal Award Number and Year (or Other Identifying Number): FY 2022 Compliance Requirement: Special Tests and Provisions - Return of Title IV Funds Audit Findings: Material Weakness, Other Matters Condition and Context The College had not designed, nor implemented an effective internal control system to ensure compliance with requirements related to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. For 2 of 25 (8 percent) return of Title IV funds tested, the amount returned to the Department of Education was incorrect. The College completed an initial return of Title IV funds and properly posted the full amount of aid to be returned to the students' accounts. During an internal review, the College discovered an error in the initial calculation and therefore calculated a new return of Title IV funds. When the subsequent calculation was performed, the College once again posted the total amount of aid to be returned to each student's account. As a result, the College incorrectly returned too much in Title IV funds to the Department of Education in the amounts of $113 and $546 for the first and second errors, respectively. In addition, this caused both students' accounts to reflect a balance due to the College that should not have been owed. The lack of internal controls and noncompliance were systemic issues throughout the audit period; however, these were isolated to students for which a corrective calculation for return of Title IV funds was performed. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 34 CFR 668.22(g) states in part: "Return of unearned aid, responsibility of the institution. (1) The institution must return, in the order specified in paragraph (i) of this section, the lesser of ? (i) (ii) Cause The total amount of unearned title IV assistance to be returned as calculated under paragraph (e)(4) of this section; or An amount equal to the total institutional charges incurred by the student for the payment period or period of enrollment multiplied by the percentage of title IV grant or loan assistance that has not been earned by the student, as described in paragraph (e)(3) of this section. . . ." Management had not developed a system of internal control that would have ensured procedures were in place in order to comply with the provisions of federal statutes, regulations, and the terms and conditions of the federal award in relation to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. The College should have considered the original amount of aid to be returned that had already been posted to each student's account. The College should have posted the additional amount of aid to be returned to the students' accounts based upon the net difference between the original calculation and the corrective calculation performed for each student. Effect The failure to design and implement an effective internal control system enabled material noncompliance to remain undetected. As a result, the College returned too much in Title IV funds to the Department of Education as outlined in the Condition and Context. Questioned Costs There were no questioned costs identified. Recommendation We recommended the College's management design and implement a system of internal control related to procedures for calculating the return of Title IV funds to ensure appropriate amounts are returned to the Department of Education and are posted to students' accounts. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response It is the College's responsibility to administer its student financial assistance programs in a manner that both complies with applicable federal regulations and guidelines as well as ensures that, when necessary, the appropriate amount of unearned financial assistance is returned to the Title IV programs. 34 CFR 668.22(g) states in part: "Return of unearned aid, responsibility of the institution. (1) The institution must return, in the order specified in paragraph (i) of this section, the lesser of ? (i) (ii) Cause The total amount of unearned title IV assistance to be returned as calculated under paragraph (e)(4) of this section; or An amount equal to the total institutional charges incurred by the student for the payment period or period of enrollment multiplied by the percentage of title IV grant or loan assistance that has not been earned by the student, as described in paragraph (e)(3) of this section. . . ." Management had not developed a system of internal control that would have ensured procedures were in place in order to comply with the provisions of federal statutes, regulations, and the terms and conditions of the federal award in relation to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. The College should have considered the original amount of aid to be returned that had already been posted to each student's account. The College should have posted the additional amount of aid to be returned to the students' accounts based upon the net difference between the original calculation and the corrective calculation performed for each student. Effect The failure to design and implement an effective internal control system enabled material noncompliance to remain undetected. As a result, the College returned too much in Title IV funds to the Department of Education as outlined in the Condition and Context. Questioned Costs There were no questioned costs identified. Recommendation We recommended the College's management design and implement a system of internal control related to procedures for calculating the return of Title IV funds to ensure appropriate amounts are returned to the Department of Education and are posted to students' accounts. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response It is the College's responsibility to administer its student financial assistance programs in a manner that both complies with applicable federal regulations and guidelines as well as ensures that, when necessary, the appropriate amount of unearned financial assistance is returned to the Title IV programs.
FINDING 2022-001 Subject: Student Financial Assistance Cluster - Special Tests and Provisions - Return of Title IV Funds Federal Agency: Department of Education Federal Programs: Federal Supplemental Educational Opportunity Grants, Federal Pell Grant, Federal Direct Student Loans Assistance Listings Numbers: 84.007, 84.063, 84.268 Federal Award Number and Year (or Other Identifying Number): FY 2022 Compliance Requirement: Special Tests and Provisions - Return of Title IV Funds Audit Findings: Material Weakness, Other Matters Condition and Context The College had not designed, nor implemented an effective internal control system to ensure compliance with requirements related to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. For 2 of 25 (8 percent) return of Title IV funds tested, the amount returned to the Department of Education was incorrect. The College completed an initial return of Title IV funds and properly posted the full amount of aid to be returned to the students' accounts. During an internal review, the College discovered an error in the initial calculation and therefore calculated a new return of Title IV funds. When the subsequent calculation was performed, the College once again posted the total amount of aid to be returned to each student's account. As a result, the College incorrectly returned too much in Title IV funds to the Department of Education in the amounts of $113 and $546 for the first and second errors, respectively. In addition, this caused both students' accounts to reflect a balance due to the College that should not have been owed. The lack of internal controls and noncompliance were systemic issues throughout the audit period; however, these were isolated to students for which a corrective calculation for return of Title IV funds was performed. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 34 CFR 668.22(g) states in part: "Return of unearned aid, responsibility of the institution. (1) The institution must return, in the order specified in paragraph (i) of this section, the lesser of ? (i) (ii) Cause The total amount of unearned title IV assistance to be returned as calculated under paragraph (e)(4) of this section; or An amount equal to the total institutional charges incurred by the student for the payment period or period of enrollment multiplied by the percentage of title IV grant or loan assistance that has not been earned by the student, as described in paragraph (e)(3) of this section. . . ." Management had not developed a system of internal control that would have ensured procedures were in place in order to comply with the provisions of federal statutes, regulations, and the terms and conditions of the federal award in relation to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. The College should have considered the original amount of aid to be returned that had already been posted to each student's account. The College should have posted the additional amount of aid to be returned to the students' accounts based upon the net difference between the original calculation and the corrective calculation performed for each student. Effect The failure to design and implement an effective internal control system enabled material noncompliance to remain undetected. As a result, the College returned too much in Title IV funds to the Department of Education as outlined in the Condition and Context. Questioned Costs There were no questioned costs identified. Recommendation We recommended the College's management design and implement a system of internal control related to procedures for calculating the return of Title IV funds to ensure appropriate amounts are returned to the Department of Education and are posted to students' accounts. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response It is the College's responsibility to administer its student financial assistance programs in a manner that both complies with applicable federal regulations and guidelines as well as ensures that, when necessary, the appropriate amount of unearned financial assistance is returned to the Title IV programs. 34 CFR 668.22(g) states in part: "Return of unearned aid, responsibility of the institution. (1) The institution must return, in the order specified in paragraph (i) of this section, the lesser of ? (i) (ii) Cause The total amount of unearned title IV assistance to be returned as calculated under paragraph (e)(4) of this section; or An amount equal to the total institutional charges incurred by the student for the payment period or period of enrollment multiplied by the percentage of title IV grant or loan assistance that has not been earned by the student, as described in paragraph (e)(3) of this section. . . ." Management had not developed a system of internal control that would have ensured procedures were in place in order to comply with the provisions of federal statutes, regulations, and the terms and conditions of the federal award in relation to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. The College should have considered the original amount of aid to be returned that had already been posted to each student's account. The College should have posted the additional amount of aid to be returned to the students' accounts based upon the net difference between the original calculation and the corrective calculation performed for each student. Effect The failure to design and implement an effective internal control system enabled material noncompliance to remain undetected. As a result, the College returned too much in Title IV funds to the Department of Education as outlined in the Condition and Context. Questioned Costs There were no questioned costs identified. Recommendation We recommended the College's management design and implement a system of internal control related to procedures for calculating the return of Title IV funds to ensure appropriate amounts are returned to the Department of Education and are posted to students' accounts. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response It is the College's responsibility to administer its student financial assistance programs in a manner that both complies with applicable federal regulations and guidelines as well as ensures that, when necessary, the appropriate amount of unearned financial assistance is returned to the Title IV programs.
FINDING 2022-001 Subject: Student Financial Assistance Cluster - Special Tests and Provisions - Return of Title IV Funds Federal Agency: Department of Education Federal Programs: Federal Supplemental Educational Opportunity Grants, Federal Pell Grant, Federal Direct Student Loans Assistance Listings Numbers: 84.007, 84.063, 84.268 Federal Award Number and Year (or Other Identifying Number): FY 2022 Compliance Requirement: Special Tests and Provisions - Return of Title IV Funds Audit Findings: Material Weakness, Other Matters Condition and Context The College had not designed, nor implemented an effective internal control system to ensure compliance with requirements related to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. For 2 of 25 (8 percent) return of Title IV funds tested, the amount returned to the Department of Education was incorrect. The College completed an initial return of Title IV funds and properly posted the full amount of aid to be returned to the students' accounts. During an internal review, the College discovered an error in the initial calculation and therefore calculated a new return of Title IV funds. When the subsequent calculation was performed, the College once again posted the total amount of aid to be returned to each student's account. As a result, the College incorrectly returned too much in Title IV funds to the Department of Education in the amounts of $113 and $546 for the first and second errors, respectively. In addition, this caused both students' accounts to reflect a balance due to the College that should not have been owed. The lack of internal controls and noncompliance were systemic issues throughout the audit period; however, these were isolated to students for which a corrective calculation for return of Title IV funds was performed. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 34 CFR 668.22(g) states in part: "Return of unearned aid, responsibility of the institution. (1) The institution must return, in the order specified in paragraph (i) of this section, the lesser of ? (i) (ii) Cause The total amount of unearned title IV assistance to be returned as calculated under paragraph (e)(4) of this section; or An amount equal to the total institutional charges incurred by the student for the payment period or period of enrollment multiplied by the percentage of title IV grant or loan assistance that has not been earned by the student, as described in paragraph (e)(3) of this section. . . ." Management had not developed a system of internal control that would have ensured procedures were in place in order to comply with the provisions of federal statutes, regulations, and the terms and conditions of the federal award in relation to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. The College should have considered the original amount of aid to be returned that had already been posted to each student's account. The College should have posted the additional amount of aid to be returned to the students' accounts based upon the net difference between the original calculation and the corrective calculation performed for each student. Effect The failure to design and implement an effective internal control system enabled material noncompliance to remain undetected. As a result, the College returned too much in Title IV funds to the Department of Education as outlined in the Condition and Context. Questioned Costs There were no questioned costs identified. Recommendation We recommended the College's management design and implement a system of internal control related to procedures for calculating the return of Title IV funds to ensure appropriate amounts are returned to the Department of Education and are posted to students' accounts. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response It is the College's responsibility to administer its student financial assistance programs in a manner that both complies with applicable federal regulations and guidelines as well as ensures that, when necessary, the appropriate amount of unearned financial assistance is returned to the Title IV programs. 34 CFR 668.22(g) states in part: "Return of unearned aid, responsibility of the institution. (1) The institution must return, in the order specified in paragraph (i) of this section, the lesser of ? (i) (ii) Cause The total amount of unearned title IV assistance to be returned as calculated under paragraph (e)(4) of this section; or An amount equal to the total institutional charges incurred by the student for the payment period or period of enrollment multiplied by the percentage of title IV grant or loan assistance that has not been earned by the student, as described in paragraph (e)(3) of this section. . . ." Management had not developed a system of internal control that would have ensured procedures were in place in order to comply with the provisions of federal statutes, regulations, and the terms and conditions of the federal award in relation to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. The College should have considered the original amount of aid to be returned that had already been posted to each student's account. The College should have posted the additional amount of aid to be returned to the students' accounts based upon the net difference between the original calculation and the corrective calculation performed for each student. Effect The failure to design and implement an effective internal control system enabled material noncompliance to remain undetected. As a result, the College returned too much in Title IV funds to the Department of Education as outlined in the Condition and Context. Questioned Costs There were no questioned costs identified. Recommendation We recommended the College's management design and implement a system of internal control related to procedures for calculating the return of Title IV funds to ensure appropriate amounts are returned to the Department of Education and are posted to students' accounts. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response It is the College's responsibility to administer its student financial assistance programs in a manner that both complies with applicable federal regulations and guidelines as well as ensures that, when necessary, the appropriate amount of unearned financial assistance is returned to the Title IV programs.
FINDING 2022-001 Subject: Student Financial Assistance Cluster - Special Tests and Provisions - Return of Title IV Funds Federal Agency: Department of Education Federal Programs: Federal Supplemental Educational Opportunity Grants, Federal Pell Grant, Federal Direct Student Loans Assistance Listings Numbers: 84.007, 84.063, 84.268 Federal Award Number and Year (or Other Identifying Number): FY 2022 Compliance Requirement: Special Tests and Provisions - Return of Title IV Funds Audit Findings: Material Weakness, Other Matters Condition and Context The College had not designed, nor implemented an effective internal control system to ensure compliance with requirements related to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. For 2 of 25 (8 percent) return of Title IV funds tested, the amount returned to the Department of Education was incorrect. The College completed an initial return of Title IV funds and properly posted the full amount of aid to be returned to the students' accounts. During an internal review, the College discovered an error in the initial calculation and therefore calculated a new return of Title IV funds. When the subsequent calculation was performed, the College once again posted the total amount of aid to be returned to each student's account. As a result, the College incorrectly returned too much in Title IV funds to the Department of Education in the amounts of $113 and $546 for the first and second errors, respectively. In addition, this caused both students' accounts to reflect a balance due to the College that should not have been owed. The lack of internal controls and noncompliance were systemic issues throughout the audit period; however, these were isolated to students for which a corrective calculation for return of Title IV funds was performed. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 34 CFR 668.22(g) states in part: "Return of unearned aid, responsibility of the institution. (1) The institution must return, in the order specified in paragraph (i) of this section, the lesser of ? (i) (ii) Cause The total amount of unearned title IV assistance to be returned as calculated under paragraph (e)(4) of this section; or An amount equal to the total institutional charges incurred by the student for the payment period or period of enrollment multiplied by the percentage of title IV grant or loan assistance that has not been earned by the student, as described in paragraph (e)(3) of this section. . . ." Management had not developed a system of internal control that would have ensured procedures were in place in order to comply with the provisions of federal statutes, regulations, and the terms and conditions of the federal award in relation to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. The College should have considered the original amount of aid to be returned that had already been posted to each student's account. The College should have posted the additional amount of aid to be returned to the students' accounts based upon the net difference between the original calculation and the corrective calculation performed for each student. Effect The failure to design and implement an effective internal control system enabled material noncompliance to remain undetected. As a result, the College returned too much in Title IV funds to the Department of Education as outlined in the Condition and Context. Questioned Costs There were no questioned costs identified. Recommendation We recommended the College's management design and implement a system of internal control related to procedures for calculating the return of Title IV funds to ensure appropriate amounts are returned to the Department of Education and are posted to students' accounts. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response It is the College's responsibility to administer its student financial assistance programs in a manner that both complies with applicable federal regulations and guidelines as well as ensures that, when necessary, the appropriate amount of unearned financial assistance is returned to the Title IV programs. 34 CFR 668.22(g) states in part: "Return of unearned aid, responsibility of the institution. (1) The institution must return, in the order specified in paragraph (i) of this section, the lesser of ? (i) (ii) Cause The total amount of unearned title IV assistance to be returned as calculated under paragraph (e)(4) of this section; or An amount equal to the total institutional charges incurred by the student for the payment period or period of enrollment multiplied by the percentage of title IV grant or loan assistance that has not been earned by the student, as described in paragraph (e)(3) of this section. . . ." Management had not developed a system of internal control that would have ensured procedures were in place in order to comply with the provisions of federal statutes, regulations, and the terms and conditions of the federal award in relation to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. The College should have considered the original amount of aid to be returned that had already been posted to each student's account. The College should have posted the additional amount of aid to be returned to the students' accounts based upon the net difference between the original calculation and the corrective calculation performed for each student. Effect The failure to design and implement an effective internal control system enabled material noncompliance to remain undetected. As a result, the College returned too much in Title IV funds to the Department of Education as outlined in the Condition and Context. Questioned Costs There were no questioned costs identified. Recommendation We recommended the College's management design and implement a system of internal control related to procedures for calculating the return of Title IV funds to ensure appropriate amounts are returned to the Department of Education and are posted to students' accounts. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response It is the College's responsibility to administer its student financial assistance programs in a manner that both complies with applicable federal regulations and guidelines as well as ensures that, when necessary, the appropriate amount of unearned financial assistance is returned to the Title IV programs.
FINDING 2022-001 Subject: Student Financial Assistance Cluster - Special Tests and Provisions - Return of Title IV Funds Federal Agency: Department of Education Federal Programs: Federal Supplemental Educational Opportunity Grants, Federal Pell Grant, Federal Direct Student Loans Assistance Listings Numbers: 84.007, 84.063, 84.268 Federal Award Number and Year (or Other Identifying Number): FY 2022 Compliance Requirement: Special Tests and Provisions - Return of Title IV Funds Audit Findings: Material Weakness, Other Matters Condition and Context The College had not designed, nor implemented an effective internal control system to ensure compliance with requirements related to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. For 2 of 25 (8 percent) return of Title IV funds tested, the amount returned to the Department of Education was incorrect. The College completed an initial return of Title IV funds and properly posted the full amount of aid to be returned to the students' accounts. During an internal review, the College discovered an error in the initial calculation and therefore calculated a new return of Title IV funds. When the subsequent calculation was performed, the College once again posted the total amount of aid to be returned to each student's account. As a result, the College incorrectly returned too much in Title IV funds to the Department of Education in the amounts of $113 and $546 for the first and second errors, respectively. In addition, this caused both students' accounts to reflect a balance due to the College that should not have been owed. The lack of internal controls and noncompliance were systemic issues throughout the audit period; however, these were isolated to students for which a corrective calculation for return of Title IV funds was performed. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 34 CFR 668.22(g) states in part: "Return of unearned aid, responsibility of the institution. (1) The institution must return, in the order specified in paragraph (i) of this section, the lesser of ? (i) (ii) Cause The total amount of unearned title IV assistance to be returned as calculated under paragraph (e)(4) of this section; or An amount equal to the total institutional charges incurred by the student for the payment period or period of enrollment multiplied by the percentage of title IV grant or loan assistance that has not been earned by the student, as described in paragraph (e)(3) of this section. . . ." Management had not developed a system of internal control that would have ensured procedures were in place in order to comply with the provisions of federal statutes, regulations, and the terms and conditions of the federal award in relation to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. The College should have considered the original amount of aid to be returned that had already been posted to each student's account. The College should have posted the additional amount of aid to be returned to the students' accounts based upon the net difference between the original calculation and the corrective calculation performed for each student. Effect The failure to design and implement an effective internal control system enabled material noncompliance to remain undetected. As a result, the College returned too much in Title IV funds to the Department of Education as outlined in the Condition and Context. Questioned Costs There were no questioned costs identified. Recommendation We recommended the College's management design and implement a system of internal control related to procedures for calculating the return of Title IV funds to ensure appropriate amounts are returned to the Department of Education and are posted to students' accounts. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response It is the College's responsibility to administer its student financial assistance programs in a manner that both complies with applicable federal regulations and guidelines as well as ensures that, when necessary, the appropriate amount of unearned financial assistance is returned to the Title IV programs. 34 CFR 668.22(g) states in part: "Return of unearned aid, responsibility of the institution. (1) The institution must return, in the order specified in paragraph (i) of this section, the lesser of ? (i) (ii) Cause The total amount of unearned title IV assistance to be returned as calculated under paragraph (e)(4) of this section; or An amount equal to the total institutional charges incurred by the student for the payment period or period of enrollment multiplied by the percentage of title IV grant or loan assistance that has not been earned by the student, as described in paragraph (e)(3) of this section. . . ." Management had not developed a system of internal control that would have ensured procedures were in place in order to comply with the provisions of federal statutes, regulations, and the terms and conditions of the federal award in relation to the Special Tests and Provisions - Return of Title IV Funds compliance requirement. The College should have considered the original amount of aid to be returned that had already been posted to each student's account. The College should have posted the additional amount of aid to be returned to the students' accounts based upon the net difference between the original calculation and the corrective calculation performed for each student. Effect The failure to design and implement an effective internal control system enabled material noncompliance to remain undetected. As a result, the College returned too much in Title IV funds to the Department of Education as outlined in the Condition and Context. Questioned Costs There were no questioned costs identified. Recommendation We recommended the College's management design and implement a system of internal control related to procedures for calculating the return of Title IV funds to ensure appropriate amounts are returned to the Department of Education and are posted to students' accounts. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response It is the College's responsibility to administer its student financial assistance programs in a manner that both complies with applicable federal regulations and guidelines as well as ensures that, when necessary, the appropriate amount of unearned financial assistance is returned to the Title IV programs.