Audit 299886

FY End
2023-06-30
Total Expended
$16.49M
Findings
4
Programs
24
Organization: Trustees of Amherst College (MA)
Year: 2023 Accepted: 2024-03-28

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
387849 2023-001 - - M
387850 2023-001 - - M
964291 2023-001 - - M
964292 2023-001 - - M

Contacts

Name Title Type
KDRLUT71AFM5 Darlene Sliwa Auditee
4135422804 Carol Ruiz Auditor
No contacts on file

Notes to SEFA

Title: Federal Student Loan Programs Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant and award transactions of The Trustees of Amherst College (the “Institution”) for the year ended June 30, 2023 recorded on the accrual basis. Because the Schedule presents only the federal activity of the Institution, it is not intended to and does not present the financial position, changes in net assets and cash flows of the Institution. The Trustees of Amherst College includes the activities of Amherst College (the “College”) and Folger Shakespeare Memorial Library (the “Library”). The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Costs Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Assistance Listing numbers and pass-through entity identification numbers are presented where available. For purposes of the Schedule, federal awards include all grants, contracts and similar agreements entered into directly between the Institution and agencies and departments of the federal government and all sub-awards to the Institution by non-federal organizations pursuant to federal grants, contracts and similar agreements. De Minimis Rate Used: N Rate Explanation: The Institution’s current Facilities and Administrative Costs Rate Agreement went into effect on May 6, 2021. The approved predetermined facilities and administrative cost rates are effective for two distinct time periods. For the effective period of July 1, 2020 through June 30, 2025, the predetermined rates are 54% for on-campus research at the College, 20% for off-campus research at the College, and 76.50% for the Library. The base used to determine the facilities and administrative cost rate for both the College and the Library is direct salaries and wages, including all fringe benefits except sabbatical leave. The Institution has elected not to use the 10% de minimis indirect cost rate allowed by the Uniform Guidance. The Federal Perkins Loan is administered directly by the Institution, and balances and transactions related to this program are included in the Institution’s consolidated and individual financial statements. The balance of loans outstanding under the Federal Perkins Loan (Assistance Listing Number 84.038) as of June 30, 2023 was $75,829. The Federal Perkins Loan line item within the Schedule includes the fiscal year beginning loan balance. The Institution is responsible for certain administrative duties only with respect to the Federal Direct Student Loans and, accordingly, these loans are not included in the Institution's consolidated or individual financial statements. It is not practical to determine the balance of loans outstanding under these programs at June 30, 2023.

Finding Details

2023-001 Subrecipient Monitoring Cluster: Research and Development Cluster Grantor: Department of Health and Human Services and National Aeronautics and Space Administration Award Names: Biomedical Research and Research Training and Science Award Year: July 1, 2022 – June 30, 2023 Award Number: 5R01GM140457-03 and 80NSSC21K0753 Assistance Listing Numbers: 93.859 and 43.001 Pass-through entity: Not applicable Criteria 2 CFR 200.332(d) notes that pass-through entity monitoring of the subrecipient must include: • Reviewing financial and performance reports required by the pass-through entity. • Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. • Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by 2 CFR 200.521. 2 CFR 200.332(f) notes that a pass-through entity must verify that every subrecipient is audited as required by the Uniform Guidance when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in 2 CFR 200.501. Additionally, 2 CFR 200.332(b) indicates that entities must evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section of the guidance. In this respect, the College procedures include (amongst other items) obtaining a Commitment Form from the subrecipient, performing an initial risk assessment on all subrecipients, and updating that risk assessment based on the Controller Office’s judgement. The College also annually reviews the subrecipient's Uniform Guidance (“UG”) report and performs any necessary follow-up to issue a management decision, where applicable. Condition Through our testing of 4 subrecipients, we noted the following: • For all samples, we were unable to obtain sufficient evidence of the College’s annual subrecipient risk assessment. • For all samples, we were unable to obtain sufficient evidence of the College’s annual review of the audited financial statements and UG report, documentation of their review of the subrecipient’s audit report, and actions taken as a result of the findings in the report. Cause The College indicated subrecipient reviews, including the annual risk assessment and review of the UG report, were performed informally by the Principal Investigators and financial staff and not consistently documented. The College cites insufficient staffing needed for the formal documentation of the subrecipient risk assessment and monitoring procedures as the cause. Effect The lack of an annual review of subrecipient UG reports may result in potential compliance issues not being identified and management not addressing findings and issuing a management decision, as required under the UG. In addition, the lack of review of the risk assessment form may result in missing information not being identified. Questioned Costs None identified. Recommendation We recommend the College reassess the design of its controls around subrecipient risk assessment and monitoring during the ongoing monitoring process. The College should formalize the documentation and review of its controls related to the annual monitoring of subrecipients, inclusive of annual reviews of Uniform Guidance reports along with other required ongoing monitoring based on the risk rating of the subrecipient. Management’s Views and Corrective Action Plan Management’s Views and Corrective Action Plan are included at the end of this report after the summary schedule of prior audit findings.
2023-001 Subrecipient Monitoring Cluster: Research and Development Cluster Grantor: Department of Health and Human Services and National Aeronautics and Space Administration Award Names: Biomedical Research and Research Training and Science Award Year: July 1, 2022 – June 30, 2023 Award Number: 5R01GM140457-03 and 80NSSC21K0753 Assistance Listing Numbers: 93.859 and 43.001 Pass-through entity: Not applicable Criteria 2 CFR 200.332(d) notes that pass-through entity monitoring of the subrecipient must include: • Reviewing financial and performance reports required by the pass-through entity. • Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. • Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by 2 CFR 200.521. 2 CFR 200.332(f) notes that a pass-through entity must verify that every subrecipient is audited as required by the Uniform Guidance when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in 2 CFR 200.501. Additionally, 2 CFR 200.332(b) indicates that entities must evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section of the guidance. In this respect, the College procedures include (amongst other items) obtaining a Commitment Form from the subrecipient, performing an initial risk assessment on all subrecipients, and updating that risk assessment based on the Controller Office’s judgement. The College also annually reviews the subrecipient's Uniform Guidance (“UG”) report and performs any necessary follow-up to issue a management decision, where applicable. Condition Through our testing of 4 subrecipients, we noted the following: • For all samples, we were unable to obtain sufficient evidence of the College’s annual subrecipient risk assessment. • For all samples, we were unable to obtain sufficient evidence of the College’s annual review of the audited financial statements and UG report, documentation of their review of the subrecipient’s audit report, and actions taken as a result of the findings in the report. Cause The College indicated subrecipient reviews, including the annual risk assessment and review of the UG report, were performed informally by the Principal Investigators and financial staff and not consistently documented. The College cites insufficient staffing needed for the formal documentation of the subrecipient risk assessment and monitoring procedures as the cause. Effect The lack of an annual review of subrecipient UG reports may result in potential compliance issues not being identified and management not addressing findings and issuing a management decision, as required under the UG. In addition, the lack of review of the risk assessment form may result in missing information not being identified. Questioned Costs None identified. Recommendation We recommend the College reassess the design of its controls around subrecipient risk assessment and monitoring during the ongoing monitoring process. The College should formalize the documentation and review of its controls related to the annual monitoring of subrecipients, inclusive of annual reviews of Uniform Guidance reports along with other required ongoing monitoring based on the risk rating of the subrecipient. Management’s Views and Corrective Action Plan Management’s Views and Corrective Action Plan are included at the end of this report after the summary schedule of prior audit findings.
2023-001 Subrecipient Monitoring Cluster: Research and Development Cluster Grantor: Department of Health and Human Services and National Aeronautics and Space Administration Award Names: Biomedical Research and Research Training and Science Award Year: July 1, 2022 – June 30, 2023 Award Number: 5R01GM140457-03 and 80NSSC21K0753 Assistance Listing Numbers: 93.859 and 43.001 Pass-through entity: Not applicable Criteria 2 CFR 200.332(d) notes that pass-through entity monitoring of the subrecipient must include: • Reviewing financial and performance reports required by the pass-through entity. • Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. • Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by 2 CFR 200.521. 2 CFR 200.332(f) notes that a pass-through entity must verify that every subrecipient is audited as required by the Uniform Guidance when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in 2 CFR 200.501. Additionally, 2 CFR 200.332(b) indicates that entities must evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section of the guidance. In this respect, the College procedures include (amongst other items) obtaining a Commitment Form from the subrecipient, performing an initial risk assessment on all subrecipients, and updating that risk assessment based on the Controller Office’s judgement. The College also annually reviews the subrecipient's Uniform Guidance (“UG”) report and performs any necessary follow-up to issue a management decision, where applicable. Condition Through our testing of 4 subrecipients, we noted the following: • For all samples, we were unable to obtain sufficient evidence of the College’s annual subrecipient risk assessment. • For all samples, we were unable to obtain sufficient evidence of the College’s annual review of the audited financial statements and UG report, documentation of their review of the subrecipient’s audit report, and actions taken as a result of the findings in the report. Cause The College indicated subrecipient reviews, including the annual risk assessment and review of the UG report, were performed informally by the Principal Investigators and financial staff and not consistently documented. The College cites insufficient staffing needed for the formal documentation of the subrecipient risk assessment and monitoring procedures as the cause. Effect The lack of an annual review of subrecipient UG reports may result in potential compliance issues not being identified and management not addressing findings and issuing a management decision, as required under the UG. In addition, the lack of review of the risk assessment form may result in missing information not being identified. Questioned Costs None identified. Recommendation We recommend the College reassess the design of its controls around subrecipient risk assessment and monitoring during the ongoing monitoring process. The College should formalize the documentation and review of its controls related to the annual monitoring of subrecipients, inclusive of annual reviews of Uniform Guidance reports along with other required ongoing monitoring based on the risk rating of the subrecipient. Management’s Views and Corrective Action Plan Management’s Views and Corrective Action Plan are included at the end of this report after the summary schedule of prior audit findings.
2023-001 Subrecipient Monitoring Cluster: Research and Development Cluster Grantor: Department of Health and Human Services and National Aeronautics and Space Administration Award Names: Biomedical Research and Research Training and Science Award Year: July 1, 2022 – June 30, 2023 Award Number: 5R01GM140457-03 and 80NSSC21K0753 Assistance Listing Numbers: 93.859 and 43.001 Pass-through entity: Not applicable Criteria 2 CFR 200.332(d) notes that pass-through entity monitoring of the subrecipient must include: • Reviewing financial and performance reports required by the pass-through entity. • Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. • Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by 2 CFR 200.521. 2 CFR 200.332(f) notes that a pass-through entity must verify that every subrecipient is audited as required by the Uniform Guidance when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in 2 CFR 200.501. Additionally, 2 CFR 200.332(b) indicates that entities must evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section of the guidance. In this respect, the College procedures include (amongst other items) obtaining a Commitment Form from the subrecipient, performing an initial risk assessment on all subrecipients, and updating that risk assessment based on the Controller Office’s judgement. The College also annually reviews the subrecipient's Uniform Guidance (“UG”) report and performs any necessary follow-up to issue a management decision, where applicable. Condition Through our testing of 4 subrecipients, we noted the following: • For all samples, we were unable to obtain sufficient evidence of the College’s annual subrecipient risk assessment. • For all samples, we were unable to obtain sufficient evidence of the College’s annual review of the audited financial statements and UG report, documentation of their review of the subrecipient’s audit report, and actions taken as a result of the findings in the report. Cause The College indicated subrecipient reviews, including the annual risk assessment and review of the UG report, were performed informally by the Principal Investigators and financial staff and not consistently documented. The College cites insufficient staffing needed for the formal documentation of the subrecipient risk assessment and monitoring procedures as the cause. Effect The lack of an annual review of subrecipient UG reports may result in potential compliance issues not being identified and management not addressing findings and issuing a management decision, as required under the UG. In addition, the lack of review of the risk assessment form may result in missing information not being identified. Questioned Costs None identified. Recommendation We recommend the College reassess the design of its controls around subrecipient risk assessment and monitoring during the ongoing monitoring process. The College should formalize the documentation and review of its controls related to the annual monitoring of subrecipients, inclusive of annual reviews of Uniform Guidance reports along with other required ongoing monitoring based on the risk rating of the subrecipient. Management’s Views and Corrective Action Plan Management’s Views and Corrective Action Plan are included at the end of this report after the summary schedule of prior audit findings.