2 CFR 200 § 200.502

Findings Citing § 200.502

Basis for determining Federal awards expended.

Total Findings
5,799
Across all audits in database
Showing Page
114 of 116
50 findings per page
About this section
Section 200.502 outlines how to determine when Federal awards are considered expended, focusing on activities that require compliance with Federal rules, such as grant transactions, fund disbursements, and loan usage. It affects non-Federal entities, including institutions of higher education, by specifying how to calculate the value of Federal awards, particularly in relation to loans and their compliance requirements.
View full section details →
FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
Clarkson University
Compliance Requirement: P
Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Va...

Finding Number: 2022-002 Program: Research and Development Cluster Federal Agency Names: U.S. National Aeronoautics and Space Adminstration; U.S. Department of Agriculture; U.S. Department of Defense; U.S. Department of Energy; U.S. Department of Health and Human Services; U.S. Department of Transportation; U.S. Department of Commerce; U.S. Environmental Protection Agency; U.S. Department of Homeland Security; U.S. Department of Interior; and National Science Foundation Federal Award Numbers: Various – as listed on the Schedule Federal Award Years: Various Federal Assistance Listing Numbers: Various – as listed on the Schedule Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the Schedule and information provided for audit purposes is complete and accurate. Conditions Found The University did not have adequate controls relating to the reporting of expenditures on the Schedule for the Research and Development Cluster. Specifically, the University did not have documented procedures on how to query and analyze expenditure data from the Peoplesoft system and the management review controls over the preparation of the Schedule were not designed to operate at an appropriate level of precision. As a result, during 2023 the University determined that $1,552,891 related to the Research and Development Cluster were inadvertently omitted from the June 30, 2022 Schedule. Additionally, expenditures in the amount of $14,289 related to the National Endowment for the Humanities – Promotion of the Humanities Teaching and Learning Resources (ALN 45.162) had been incorrectly included as part of the Research and Development Cluster. The combination of these errors resulted in a total of $1,538,602 of Research and Development Cluster expenditures being added to the June 30, 2022 Schedule. The University also had incorrectly reported encumbrances, which represent future expenditures that have been obligated but not incurred. Cause In discussing these conditions with the University, they stated the errors were primarily due to turnover in staff responsible for preparation of the Schedule as well as a lack of documented procedures. Additionally, the management review controls in place were not operating at a sufficient level of precision to detect the errors. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the University from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable. Statistical Sample Not applicable. Repeat Finding This finding is not a repeat finding in the immediately prior audit. Recommendation We recommend the University implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate

FY End: 2022-06-30
So Consortium
Compliance Requirement: ABCGHLM
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the...

2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.

FY End: 2022-06-30
So Consortium
Compliance Requirement: ABCGHLM
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the...

2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.

FY End: 2022-06-30
So Consortium
Compliance Requirement: ABCGHLM
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the...

2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.

FY End: 2022-06-30
So Consortium
Compliance Requirement: ABCGHLM
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the...

2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.

« 1 112 113 115 116 »