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.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.