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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
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.
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.
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.
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.
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.
Condition: For the fiscal year ended June 30, 2022, we requested that Day One prepare and send us a Schedule of Expenditures of Federal Awards. Requested that the expenditures reported in the SEFA be reconciled to Day One’s accounting records. We reviewed the SEFA and compared them to the accounting records; we noted that the expenditures reported were inaccurate. Criteria: Recipients of federal awards are subject to requirements documented in section of the Uniform Guidance Sections 200.510, 200.502, and 200.302. The criteria for each are as follows: § 200.510 Financial statements (b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502.” § 200.502 Basis for determining Federal awards expended (a) Determining Federal awards expended. The determination of when a federal award is expended must be based on when the activity related to the Federal award occurs. Generally, the activity pertains to events that require the non-Federal entity to comply with Federal statutes, regulations, and the terms and conditions of Federal awards, such as: expenditure/expense transactions associated with awards including grants, cost-reimbursement contracts under the FAR, compacts with Indian Tribes, cooperative agreements, and direct appropriations; the disbursement of funds to subrecipients; the use of loan proceeds under loan and loan guarantee programs; the receipt of property; the receipt of surplus property; the receipt or use of program income; the distribution or use of food commodities; the disbursement of amounts entitling the non-Federal entity to an interest subsidy; and the period when insurance is in force. § 200.302 Financial management (a) Each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award.The financial management system of each non-Federal entity must provide for (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements…..” Questioned Costs: None Cause: The Organization has not implemented policies and procedures requiring that the Schedule of Federal Awards to complete and accurate. Effect and Context: The Organization reported expenditures that exceeded $750,000 for 2022. In determining the major program to be audited for 2022, the auditor could not rely on the SEFA provided because the SEFA was not complete and expenditures reported were inaccurate. Which could have lead to an inaccurate reporting of federal expenditures for the Organization for 2022. Recommendation: We recommend that management implement policies and procedures requiring all federal expenditures be accurately reported in the year end Schedule of Federal Awards. Management’s Response and Corrective Action Plan: See management’s responses documented on page 46-47.
Condition: For the fiscal year ended June 30, 2022, we requested that Day One prepare and send us a Schedule of Expenditures of Federal Awards. Requested that the expenditures reported in the SEFA be reconciled to Day One’s accounting records. We reviewed the SEFA and compared them to the accounting records; we noted that the expenditures reported were inaccurate. Criteria: Recipients of federal awards are subject to requirements documented in section of the Uniform Guidance Sections 200.510, 200.502, and 200.302. The criteria for each are as follows: § 200.510 Financial statements (b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502.” § 200.502 Basis for determining Federal awards expended (a) Determining Federal awards expended. The determination of when a federal award is expended must be based on when the activity related to the Federal award occurs. Generally, the activity pertains to events that require the non-Federal entity to comply with Federal statutes, regulations, and the terms and conditions of Federal awards, such as: expenditure/expense transactions associated with awards including grants, cost-reimbursement contracts under the FAR, compacts with Indian Tribes, cooperative agreements, and direct appropriations; the disbursement of funds to subrecipients; the use of loan proceeds under loan and loan guarantee programs; the receipt of property; the receipt of surplus property; the receipt or use of program income; the distribution or use of food commodities; the disbursement of amounts entitling the non-Federal entity to an interest subsidy; and the period when insurance is in force. § 200.302 Financial management (a) Each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award.The financial management system of each non-Federal entity must provide for (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements…..” Questioned Costs: None Cause: The Organization has not implemented policies and procedures requiring that the Schedule of Federal Awards to complete and accurate. Effect and Context: The Organization reported expenditures that exceeded $750,000 for 2022. In determining the major program to be audited for 2022, the auditor could not rely on the SEFA provided because the SEFA was not complete and expenditures reported were inaccurate. Which could have lead to an inaccurate reporting of federal expenditures for the Organization for 2022. Recommendation: We recommend that management implement policies and procedures requiring all federal expenditures be accurately reported in the year end Schedule of Federal Awards. Management’s Response and Corrective Action Plan: See management’s responses documented on page 46-47.
Condition: During our review and reconciliation of the Schedule of Expenditures of Federal Awards (SEFA) as initially prepared by the County, we identified federal programs that were not listed accurately which resulted in federal expenditures being overstated stated by $2,412,977. • Expenditures reported on the SEFA for ALN 16.607 - Bulletproof Vest Partnership Program were $36,810. Actual federal expenditures obtained from the County’s records confirm $0 expended for a variance of $36,810. • Expenditures reported on the SEFA for ALN 21.019 - Coronavirus Relief Fund were $2,376,264. Actual federal expenditures obtained from the County’s records confirm $0 expended for a variance of $2,376,264. Expenditures reported on the SEFA for ALN 97.042 - Emergency Management Performance Grants were $24,864. Actual federal expenditures obtained from the County’s records confirm $24,961 expended for a variance of ($97). Additionally, the County failed to present $500,000 in subrecipient expenditures on the SEFA for ALN 21.027 - Coronavirus State and Local Fiscal Recovery Funds. Cause of Condition: Policies and procedures have not been designed and implemented to ensure accurate reporting of expenditures for all federal awards. Effect of Condition: This condition resulted in inaccurate recording of the federal expenditures on the SEFA. Recommendation: OSAI recommends county officials and department heads gain an understanding of federal programs awarded to Rogers County. Internal control procedures should be designed and implemented to ensure accurate reporting of expenditures on the SEFA and to ensure compliance with federal requirements. The Board of County Commissioners (BOCC) should review and approve the SEFA in an open meeting. Management Response: Board of County Commissioners: The Board of County Commissioners is responsible for the overall fiscal concerns of the county. See OKLA. STAT. Title 19, § 345. The Board of County Commissioners, with the cooperation and participation of all elected officials, reviews, develops and implements policies and procedures to create a strong internal control environment. Additionally, the Board of County Commissioners conducts meetings with all elected officials and officers responsible for the receipt and/or expenditure of county funds. These meetings address fiscal matters, including but not limited to, policy discussions and implementation, financial reports, budget oversight, SEFA reporting, and legal compliance. Policies and procedures, combined with fiscal oversight meetings, are intended to: 1) prevent or detect material misstatements in the financial statements; 2) prevent or detect fraud within the county; 3) increase communication between the Board of County Commissioners and those elected officials and officers responsible for the receipt and/or expenditure of public funds; 4) provide oversight over the fiscal concerns of the county; 5) identify and address risks related to financial reporting; 6) ensure the accuracy of Rogers County’s financial statements, Estimate of Needs, and the SEFA; and 7) ensure compliance with all applicable federal and state laws, regulations, and/or codes. The Board of County Commissioners, with the cooperation of all elected officials and officers responsible for the receipt or expenditure of federal funds, will evaluate the processes and procedures currently in place to ensure the accuracy of SEFA reporting and detect potential inaccuracies and/or misstatements. Criteria: 2 CFR § 200.303(a) Internal Controls reads as follows: The non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). 2 CFR § 200.508(b) Auditee responsibilities reads as follows: The auditee must: Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. 2 CFR § 200.510(b) Financial statements reads, in part, as follows: Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. Further, GAO Standards – Section 2 – Objectives of an Entity - OV2.23 states in part: Compliance Objectives Management conducts activities in accordance with applicable laws and regulations. As part of specifying compliance objectives, the entity determines which laws and regulations apply to the entity. Management is expected to set objectives that incorporate these requirements.
Finding 2022 – 003: Reporting: Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Criteria: Uniform Guidance 2 CFR §200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements [that]… at a minimum shall…list individual Federal programs by Federal agency… [and] provide total Federal awards expenditures for each individual Federal program and the Assistance Listing Number (ALN) or other identifying number when the ALN information is not available.” In accordance with Uniform Guidance, the School District is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Condition: During fiscal year 2022, the School District did not have sufficient controls in place to ensure the SEFA accurately reflected each award’s federal expenditures. There were differences noted in reconciling expenditures from the original SEFA to the trial balance. These errors were corrected through adjustments proposed as part of the audit, and the final version of the SEFA reconciles to the School District’s general ledger. Questioned Costs: None. Cause: Insufficient training or understanding of Uniform Guidance, including some of the required elements of the SEFA, contributed to this finding. Effect: The School District could not produce an accurate and timely SEFA, which required additional effort and resources by the School District and auditor during the audit process. Recommendation: We recommend that the School District becomes familiar with the SEFA reporting elements required by Uniform Guidance and develop and implement a review process to ensure compliance with those reporting requirements. These processes and controls should include reconciling SEFA federal expenditures to the current year general ledger expenditures and reviewing other grant related information to ensure accuracy. Views of Responsible Officials: See the corrective action plan that accompanies the schedule of findings and questioned costs.
2022-003: Breckinridge County Fiscal Court did not prepare their Schedule of Expenditures of Federal Awards The Breckinridge County Fiscal Court did not complete their Scheule of Expenditures of Federal Awards (SEFA) report in a timely manner. The deficiency is due to the lack of internal controls over SEFA reporting. Failure to complete the SEFA report caused the financial statement report to be incomplete. As a result of not preparing their SEFA report, the Breckinridge County Fiscal Court was not in compliance with 2 CFR 200.510(b), which states “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502”. We recommend that the Breckinridge County Fiscal Court put internal controls in place to ensure proper and timely reporting. Views of Responsible Official and Planned Corrective Action: Judge Lucas Response: This was an oversight on our part. Steps have been taken to fully comply with all SEFA reporting in the future.
Finding 2022-004 – Inadequate Segregation of Federal and Non-Federal Expenditures (Major and Non-Major Program) (Material Weakness) Federal Program: 66.468 Capitalization Grants for Drinking Water, State Revolving Funds Name of Federal Agency: U.S. Environmental Protection Agency Compliance/Internal Control over Compliance: Auditee Responsibilities Federal Program: 21.027 Coronavirus Sate Fiscal Recovery Fund, Parks and Trail Name of Federal Agency: U.S. Department of Treasury, Oregon Department of Administrative Services Compliance/Internal Control over Compliance: Auditee Responsibilities Criteria: Per CFR §200.302(b)(1), non-federal entities must maintain financial management systems that identify Federal expenditures separately to facilitate accurate reporting. Additionally, CFR §200.510(b) requires the SEFA to present complete and accurate Federal expenditures. Condition: For Federal programs, both major program, and a non-major program, Federal and non-Federal expenditures were recorded within the same general ledger accounts. For the major program, additional costs beyond the reportable amounts were combined in the general ledger. For a non-major program, significant amounts of non-federal project costs were combined in the general ledger accounts, with the federal costs, rather than clearly isolating all applicable Federal expenditures. This issue complicated the gathering and reporting of federal expenditures for review and creation of the SEFA. Cause: The issue appears to stem from inadequate procedures and controls over identification, tracking and reporting of federal awards. Management had insufficient accounting structure and controls to track project expenditures by funding source (Federal vs. Non-Federal), and did not implement a formal process to compile and review SEFA information for completeness and accuracy. Effect: • Potential for incomplete or inaccurate SEFA reporting. • Increased risk that Federal expenditures are misreported or misclassified. • Reduced audit trail supporting compliance with Uniform Guidance. Questioned Cost: None noted. Context: During our testing of Federal programs, we reviewed project-level expenditures and the client’s process for accumulating amounts reported on the SEFA. We noted that for certain projects, Federal and non-Federal expenditures were recorded in the same general ledger accounts without clear identifiers by funding source. As a result, the client relied on external and manual information to determine and report the Federal portion, and only a subset of total expensed project costs was reported as Federal expenditures. This condition demonstrates that management did not have sufficient processes in place to identify, accumulate, and report federal expenditures, and the general ledger did not provide accurate information for the SEFA preparation without additional analysis and selection of amounts. Repeat of a Prior-Year Finding: No Recommendation: We recommend that The City of North Plains: • Establish policies and procedures to ensure that all Federal awards are identified and reported accurately on the general ledger, utilizing separate general ledger accounts, cost centers, or project codes for Federal awards. • Establish procedures to track expenditures by funding source throughout the project lifecycle. • Internal Controls should be designed to perform periodic reconciliations of the SEFA information to the general ledger accounts throughout the fiscal year. • Provide appropriate training to staff who are assigned to prepare and review the SEFA. Client's Response: The City of North Plains concurs with the recommendation and will work through the Corrective Action Plan to improve or solve the deficiency. Corrective Action Plan: __________________To be developed by City of North Plains. Planned Implementation Date: In progress. Responsible Person: City of North Plains Mayor. Section IV—Summary Schedule of Prior Audit Findings
Inaccurate Grant Reporting (Material Weakness) Assistance Listing: 10.766 Federal Program: Community Facilities Loans and Grants Condition: During our audit, the City did not identify and report federal expenditures related to Community Facilities Loans and Grants (Assistance Listing 10.766) on the originally issued SEFA for the year ended June 30, 2022. As a result, the SEFA did not include the expenditures associated with Assistance Listing 10.766, which affected the completeness of the SEFA and the related major program determination performed for the originally issued 2022 single audit reporting package. The underlying loan and loan activity were properly recorded and disclosed in the basic financial statements. The deficiency was limited to the identification and reporting of the federal award on the SEFA, which in turn affected major program determination for singleaudit purposes. Criteria: In accordance with 2 CFR §200.510(b) and 2 CFR §200.518, the City is responsible for preparing a complete and accurate SEFA that includes all federal awards expended during the fiscal year, including loan programs, and for identifying federal programs and determining which programs are major for purposes of the Uniform Guidance single audit. Cause: Management’s SEFA preparation and review procedures were not sufficiently designed and/or operating effectively to: 1) identify all federal programs and Assistance Listings applicable to the City’s activities, including loan programs; and 2) ensure amounts recorded in the general ledger and related financial statement balances were appropriately evaluated for federal award classification and SEFA inclusion (including evaluating whether activity recorded as loans payable/receivable or related loan activity represented federal awards expended for SEFA reporting). Effect: The omission of Assistance Listing 10.766 from the originally issued SEFA caused: 1) total federal expenditures reported on the SEFA to be understated; and 2) an error in the identification and reporting of the City’s federal award activity, which could affect the auditor’s understanding of the City’s federal award universe and the overall major program risk assessment and determination under Uniform Guidance, even if Assistance Listing 10.766 was not individually a Type A program for the 2022 audit year. Questioned Cost: None Repeat Finding: No Recommendation: We recommend that the City strengthen internal control over compliance related to SEFA preparation and Uniform Guidance single-audit reporting by implementing procedures to ensure all federal programs are identified and properly reported on the SEFA, including loan programs. Such procedures should include at a minimum: 1) maintaining a complete listing of all federal programs (by Assistance Listing, awarding agency/pass-through entity, and award/loan identifiers) applicable to the fiscal year; 2) performing a formal annual SEFA planning process that includes inquiry of finance and program personnel and review of grant/loan agreements and communications from federal/pass-through entities to identify all federal awards; 3) incorporating targeted procedures to identify federal loan programs and related expenditures/loan balances that must be included on the SEFA, including reconciliation of loan activity and balances to SEFA amounts and required SEFA disclosures; and 4) performing an independent review of the draft SEFA and the major program determination to confirm completeness and accuracy prior to issuance. Response: The City submitted all required information in a timely manner to facilitate completion and filing of the Data Collection Form. The City will implement enhanced review and communication procedures with external auditors, as the condition was significantly impacted by deficiencies in the auditors’ evaluation and classification of major programs during the audit process.
Material Weakness Internal Controls Over Finacial Reporting Deficiencies in the Design of Controls Conditions: During our audit, we noted the organization does not have the following written Standard Operating Procedures (SOP), inadequate design of controls over the preparation of the financial statements, inadequate design of controls over significant accounts and processes, inadequate documentation of the components of internal controls. We have also found inadequate segregation of duties. The client has personnel and management under their employ who lack the qualifications and training to fulfill their assigned functions. There is also inadequate design of monitoring controls used to assess the design and operating effectiveness of the entity's internal control environment. Failures in the Operation of Internal Control Conditions: Failure of the information and communication component of internal control to provide complete and accurate output because of deficiencies in timeliness, completeness, and accuracy, failure to perform reconciliations of significant accounts. Poor Documentation Conditions: Lack of clear policies and procedures, making it difficult to monitor compliance and identify potential problems. Risk Assessment Failures Conditions: Not properly identifying and mitigating key risks within the organization. Lack of Management Review Conditions: Not actively monitoring and reviewing internal controls for effectiveness. Human Error Conditions: Mistakes made by employees due to poor training or lack of attention to detail. Criteria: 2 CFR Section 200.510 (a) - The auditee shall prepare financial statements that reflect its financial position, results of operation or change in net assets, and, where appropriate, cash flows for the fiscal year audited. Management is responsible for implementing a system of internal control over reconciling, verifying, and evaluating the nature of awards in accordance with applicable accounting standards. Management must assign accountable departmental employees and procedures must be in place for evaluating and documenting the nature of the various accounting steps of rollforwards and reconciliations in accordance with accounting standards and to ensure the accounts are being represented accurately. Effects of Conditions: Without SOPs there is a higher error rate, increased risk of compliance issues, operations stop or a lack of segregation of duties occur when key personnel are unavailable. Without internal controls over the preparation of the financial statements there is no assurance that management has accurate, timely and complete information, including accounting records. The organization faces an increased risk of fraud, errors in accounting, operational inefficiencies, compliance issues, damage to reputation, and difficulty in detecting and investigating fraudulent activity because of a lack of segregation of duties. The lack of monitoring can cause inaccurate financial reporting, increased risk of fraud, poor decision-making due to unreliable data, potential reputational damage, and missed opportunities to identify and correct financial problems early on, ultimately impacting the company's financial stability and overall performance. Cause of Conditions: The lack of SOPs (financial statement close, procure to pay, order tocash) created an environment that is not conducive for monitoring, reconciliation, and communication and can have a material impact on the entity’s financials. Policies and proceduresare not in place to ensure the effectiveness of financial management and oversight. The financial statement close process is not performed in a time manner to allow for reasonable financial statements to be prepared and reviewed by management and those charged with governance. Also, the entity lacks qualified staff in critical roles to ensure that the financial processes are initiated andmonitored and reported in a timely manner. Auditor’s Recommendation: We recommend that internal controls, along with a control matrix and SOPs, are documented and appropriately implemented and distributed to staff and management along with implementing an ongoing process of regularly reviewing and assessing the financial data. Also, we recommend hiring additional qualified staff and providing the training needed to the current staff and new hires.