Audit 30185

FY End
2022-06-30
Total Expended
$15.44M
Findings
4
Programs
18
Organization: Colgate University (NY)
Year: 2022 Accepted: 2023-03-30
Auditor: Kpmg LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
35881 2022-001 Significant Deficiency - L
35882 2022-001 Significant Deficiency - L
612323 2022-001 Significant Deficiency - L
612324 2022-001 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
84.268 Federal Direct Student Loans $6.07M - 0
84.063 Federal Pell Grant Program $2.13M - 0
84.425 Covid-19 - Education Stabilization Fund $2.11M Yes 1
84.038 Federal Perkins Loan Program $828,266 - 0
47.049 Mathematical and Physical Sciences $707,969 Yes 0
84.007 Federal Supplemental Educational Opportunity Grants $287,503 - 0
84.033 Federal Work-Study Program $271,059 - 0
47.050 Geosciences $251,617 Yes 0
93.859 Biomedical Research and Research Training $187,054 Yes 0
47.070 Computer and Information Science and Engineering $79,661 Yes 0
47.074 Biological Sciences $49,245 Yes 0
45.163 Promotion of the Humanities_professional Development $41,793 Yes 0
47.075 Social, Behavioral, and Economic Sciences $32,777 Yes 0
47.076 Education and Human Resources $19,671 Yes 0
15.922 Native American Graves Protection and Repatriation Act $16,776 Yes 0
43.008 Education $6,876 Yes 0
43.001 Science $5,146 Yes 0
10.652 Forestry Research $953 Yes 0

Contacts

Name Title Type
D4P7H8NWZER7 Kyle Dombrowski Auditee
3152287235 Dean Geesler Auditor
No contacts on file

Notes to SEFA

Title: Loan/loan guarantee outstanding balances Accounting Policies: The accompanying Supplementary Schedule of Expenditures of Federal Awards (the Schedule) includes the federal grant activity of Colgate University (the University). The Schedule is presented on the accrual basis of accounting in accordance with U.S. generally accepted accounting principles and the requirements of U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in the Schedule may differ from amounts presented in, or used in the preparation of, the basic consolidated financial statements. De Minimis Rate Used: N Rate Explanation: Administrative costs are included in the reported expenditures to the extent such costs are included in the federal financial reports used as the source for the data presented. The University has not elected to utilize the 10% deminimus indirect cost rate in Part 200.514 of the Uniform Guidance. Federal Perkins Loan Program - For the year ended June 30, 2022, the University made no loans under the Federal Perkins Loan Program and there was no administrative cost allowance claimed. The outstanding balance of loans receivable under this program was $646,940 and $828,266 at June 30, 2022 and 2021, respectively. The amount reported on the Schedule represents the June 30, 2021 outstanding loan balance. Federal Direct Student Loan Program - During the year ended June 30, 2022, the University processed $6,067,678 of new loans under the Federal Direct Student Loan Program (which includes subsidized and unsubsidized Direct Loans and Direct Parents Loans for Undergraduate Students). With respect to the Federal Direct Student Loan Program, the University is only responsible for the performance of certain administrative duties; therefore, the University's financial statements do not include any amounts relative to these loans. The cumulative amount of total loans guaranteed and outstanding at June 30, 2022 is undeterminable.

Finding Details

Criteria There are three components to reporting for HEERF: 1) public reporting on the (a)(1) Student Aid Portion; 2) public reporting on the (a)(1) Institutional Portion (a)(2) and (a)(3) subprograms (Quarterly Reporting Form), as applicable; and 3) the annual report. The CARES Act 18004(e) and the CRRSAA 314(e) require an institution receiving funds under HEERF I and HEERF II to submit a report to the secretary, at such time in such a manner as the secretary may require. While ARP does not explicitly identify procedures by which institutions must report on their uses of HEERF grant funds, ED exercises this reporting authority under 2 CFR section 200.328 and 2 CFR section 200.329. Annual Reporting (all HEERF Grantees) ED required an annual report from HEERF grantees in April 2022 that included reporting uses of HEERF I CARES Act funds, HEERF II CRRSAA funds, and HEERF III ARP funds for the 2021 calendar year. Quarterly Public Reporting for (a)(1) Institutional Portion, (a)(2), and (a)(3) Funds The CARES, CRRSAA, and ARP institutional quarterly portion reporting requirements involve publicly posting completed forms on the institution?s website. The forms must be conspicuously posted on the institution?s primary website on the same page the reports of the IHE?s activities as to the emergency financial aid grants to students (Student Aid Portion) are posted. IHEs must post this quarterly report form no later than 10 days after the end of each calendar quarter. Quarterly Public Reporting for (a)(1) Student Aid Portion ED requires institutions that received Student Aid Portion awards under CARES Act, CRRSAA and ARP to publicly post certain information on their website. Under the requirements to post student aid public reporting for CRRSAA and ARP, there is a requirement to include certain information on their website. Institutions must publicly post their report as soon as possible, but no later than 30 days after the publication of the notice or 30 days after the date ED first obligated funds under HEERF I, II, or III to the institution for Emergency Financial Aid Grants to Students, whichever comes later. The report must be updated not later than 10 days after the end of each calendar quarter. Further, in accordance with 2 CFR 200.303(a), non-federal entities must 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. Condition During our testwork over institutional reporting, it was noted that for one of two quarterly required instances of reporting selected for testing was submitted untimely. This quarterly update was provided 23 days after the date it was required to be updated. Additionally, the required reporting included the University?s final disbursements was not appropriately marked as the final report. Additionally, internal controls were not effective as evidence of review of the reporting prior to posting on the University?s website was not retained by management. As such we could not see evidence the management review control was operating effectively. Cause The University?s HEERF reporting process did not include a requirement to maintain the review documentation and did not operate at a level of precision sufficient to ensure timely and accurate reporting. Effect If appropriate controls are not designed and operating effectively over the HEERF reporting process, HEERF expenditures reported on the University?s website and to U.S. Department of Education may be incomplete, inaccurate, or not posted within the timeframe required resulting in non-compliance. Questioned Costs None noted. Recommendation We recommend that the University implement a implement a requirement to maintain the review documentation and incorporate a detailed review of the various fields of the form to ensure accuracy as well as to ensure the HEERF reporting is completed timely.
Criteria There are three components to reporting for HEERF: 1) public reporting on the (a)(1) Student Aid Portion; 2) public reporting on the (a)(1) Institutional Portion (a)(2) and (a)(3) subprograms (Quarterly Reporting Form), as applicable; and 3) the annual report. The CARES Act 18004(e) and the CRRSAA 314(e) require an institution receiving funds under HEERF I and HEERF II to submit a report to the secretary, at such time in such a manner as the secretary may require. While ARP does not explicitly identify procedures by which institutions must report on their uses of HEERF grant funds, ED exercises this reporting authority under 2 CFR section 200.328 and 2 CFR section 200.329. Annual Reporting (all HEERF Grantees) ED required an annual report from HEERF grantees in April 2022 that included reporting uses of HEERF I CARES Act funds, HEERF II CRRSAA funds, and HEERF III ARP funds for the 2021 calendar year. Quarterly Public Reporting for (a)(1) Institutional Portion, (a)(2), and (a)(3) Funds The CARES, CRRSAA, and ARP institutional quarterly portion reporting requirements involve publicly posting completed forms on the institution?s website. The forms must be conspicuously posted on the institution?s primary website on the same page the reports of the IHE?s activities as to the emergency financial aid grants to students (Student Aid Portion) are posted. IHEs must post this quarterly report form no later than 10 days after the end of each calendar quarter. Quarterly Public Reporting for (a)(1) Student Aid Portion ED requires institutions that received Student Aid Portion awards under CARES Act, CRRSAA and ARP to publicly post certain information on their website. Under the requirements to post student aid public reporting for CRRSAA and ARP, there is a requirement to include certain information on their website. Institutions must publicly post their report as soon as possible, but no later than 30 days after the publication of the notice or 30 days after the date ED first obligated funds under HEERF I, II, or III to the institution for Emergency Financial Aid Grants to Students, whichever comes later. The report must be updated not later than 10 days after the end of each calendar quarter. Further, in accordance with 2 CFR 200.303(a), non-federal entities must 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. Condition During our testwork over institutional reporting, it was noted that for one of two quarterly required instances of reporting selected for testing was submitted untimely. This quarterly update was provided 23 days after the date it was required to be updated. Additionally, the required reporting included the University?s final disbursements was not appropriately marked as the final report. Additionally, internal controls were not effective as evidence of review of the reporting prior to posting on the University?s website was not retained by management. As such we could not see evidence the management review control was operating effectively. Cause The University?s HEERF reporting process did not include a requirement to maintain the review documentation and did not operate at a level of precision sufficient to ensure timely and accurate reporting. Effect If appropriate controls are not designed and operating effectively over the HEERF reporting process, HEERF expenditures reported on the University?s website and to U.S. Department of Education may be incomplete, inaccurate, or not posted within the timeframe required resulting in non-compliance. Questioned Costs None noted. Recommendation We recommend that the University implement a implement a requirement to maintain the review documentation and incorporate a detailed review of the various fields of the form to ensure accuracy as well as to ensure the HEERF reporting is completed timely.
Criteria There are three components to reporting for HEERF: 1) public reporting on the (a)(1) Student Aid Portion; 2) public reporting on the (a)(1) Institutional Portion (a)(2) and (a)(3) subprograms (Quarterly Reporting Form), as applicable; and 3) the annual report. The CARES Act 18004(e) and the CRRSAA 314(e) require an institution receiving funds under HEERF I and HEERF II to submit a report to the secretary, at such time in such a manner as the secretary may require. While ARP does not explicitly identify procedures by which institutions must report on their uses of HEERF grant funds, ED exercises this reporting authority under 2 CFR section 200.328 and 2 CFR section 200.329. Annual Reporting (all HEERF Grantees) ED required an annual report from HEERF grantees in April 2022 that included reporting uses of HEERF I CARES Act funds, HEERF II CRRSAA funds, and HEERF III ARP funds for the 2021 calendar year. Quarterly Public Reporting for (a)(1) Institutional Portion, (a)(2), and (a)(3) Funds The CARES, CRRSAA, and ARP institutional quarterly portion reporting requirements involve publicly posting completed forms on the institution?s website. The forms must be conspicuously posted on the institution?s primary website on the same page the reports of the IHE?s activities as to the emergency financial aid grants to students (Student Aid Portion) are posted. IHEs must post this quarterly report form no later than 10 days after the end of each calendar quarter. Quarterly Public Reporting for (a)(1) Student Aid Portion ED requires institutions that received Student Aid Portion awards under CARES Act, CRRSAA and ARP to publicly post certain information on their website. Under the requirements to post student aid public reporting for CRRSAA and ARP, there is a requirement to include certain information on their website. Institutions must publicly post their report as soon as possible, but no later than 30 days after the publication of the notice or 30 days after the date ED first obligated funds under HEERF I, II, or III to the institution for Emergency Financial Aid Grants to Students, whichever comes later. The report must be updated not later than 10 days after the end of each calendar quarter. Further, in accordance with 2 CFR 200.303(a), non-federal entities must 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. Condition During our testwork over institutional reporting, it was noted that for one of two quarterly required instances of reporting selected for testing was submitted untimely. This quarterly update was provided 23 days after the date it was required to be updated. Additionally, the required reporting included the University?s final disbursements was not appropriately marked as the final report. Additionally, internal controls were not effective as evidence of review of the reporting prior to posting on the University?s website was not retained by management. As such we could not see evidence the management review control was operating effectively. Cause The University?s HEERF reporting process did not include a requirement to maintain the review documentation and did not operate at a level of precision sufficient to ensure timely and accurate reporting. Effect If appropriate controls are not designed and operating effectively over the HEERF reporting process, HEERF expenditures reported on the University?s website and to U.S. Department of Education may be incomplete, inaccurate, or not posted within the timeframe required resulting in non-compliance. Questioned Costs None noted. Recommendation We recommend that the University implement a implement a requirement to maintain the review documentation and incorporate a detailed review of the various fields of the form to ensure accuracy as well as to ensure the HEERF reporting is completed timely.
Criteria There are three components to reporting for HEERF: 1) public reporting on the (a)(1) Student Aid Portion; 2) public reporting on the (a)(1) Institutional Portion (a)(2) and (a)(3) subprograms (Quarterly Reporting Form), as applicable; and 3) the annual report. The CARES Act 18004(e) and the CRRSAA 314(e) require an institution receiving funds under HEERF I and HEERF II to submit a report to the secretary, at such time in such a manner as the secretary may require. While ARP does not explicitly identify procedures by which institutions must report on their uses of HEERF grant funds, ED exercises this reporting authority under 2 CFR section 200.328 and 2 CFR section 200.329. Annual Reporting (all HEERF Grantees) ED required an annual report from HEERF grantees in April 2022 that included reporting uses of HEERF I CARES Act funds, HEERF II CRRSAA funds, and HEERF III ARP funds for the 2021 calendar year. Quarterly Public Reporting for (a)(1) Institutional Portion, (a)(2), and (a)(3) Funds The CARES, CRRSAA, and ARP institutional quarterly portion reporting requirements involve publicly posting completed forms on the institution?s website. The forms must be conspicuously posted on the institution?s primary website on the same page the reports of the IHE?s activities as to the emergency financial aid grants to students (Student Aid Portion) are posted. IHEs must post this quarterly report form no later than 10 days after the end of each calendar quarter. Quarterly Public Reporting for (a)(1) Student Aid Portion ED requires institutions that received Student Aid Portion awards under CARES Act, CRRSAA and ARP to publicly post certain information on their website. Under the requirements to post student aid public reporting for CRRSAA and ARP, there is a requirement to include certain information on their website. Institutions must publicly post their report as soon as possible, but no later than 30 days after the publication of the notice or 30 days after the date ED first obligated funds under HEERF I, II, or III to the institution for Emergency Financial Aid Grants to Students, whichever comes later. The report must be updated not later than 10 days after the end of each calendar quarter. Further, in accordance with 2 CFR 200.303(a), non-federal entities must 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. Condition During our testwork over institutional reporting, it was noted that for one of two quarterly required instances of reporting selected for testing was submitted untimely. This quarterly update was provided 23 days after the date it was required to be updated. Additionally, the required reporting included the University?s final disbursements was not appropriately marked as the final report. Additionally, internal controls were not effective as evidence of review of the reporting prior to posting on the University?s website was not retained by management. As such we could not see evidence the management review control was operating effectively. Cause The University?s HEERF reporting process did not include a requirement to maintain the review documentation and did not operate at a level of precision sufficient to ensure timely and accurate reporting. Effect If appropriate controls are not designed and operating effectively over the HEERF reporting process, HEERF expenditures reported on the University?s website and to U.S. Department of Education may be incomplete, inaccurate, or not posted within the timeframe required resulting in non-compliance. Questioned Costs None noted. Recommendation We recommend that the University implement a implement a requirement to maintain the review documentation and incorporate a detailed review of the various fields of the form to ensure accuracy as well as to ensure the HEERF reporting is completed timely.