2 CFR Subpart F § 200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the District’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 ALN number or other identifying number when the ALN 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 District’s internal control procedures did not identify $258,972 of expenses in the Schedule of Expenditures of Federal Awards related to the Elementary and Secondary School Emergency Relief Funds. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. 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 agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
Program: Provider Relief Fund Federal Agency Name: U.S. Department of Health and Human Services Federal Award Number: N/A Federal Award Year: 2021 – 2022 Federal Assistance Listing Number: 93.498 Compliance Requirement: Other – Inaccurate Reporting on 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 entity’s financial statements, which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, CFR 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 and completely reported on the Schedule. Conditions Found QHS did not have adequate internal controls related to the reporting of expenditures on the Schedule for the Provider Relief Fund. Specifically, QHS did not have a control to reconcile the Provider Relief Funds received and submitted on the Health Resources and Services Administration (HRSA) Provider Relief Fund reporting portal to the amounts reported on the Schedule. As a result, QHS determined that $5,000,000 of Provider Relief Fund expenditures were inadvertently omitted from the June 30, 2022 Schedule. Cause In discussing the conditions with QHS management, they stated it was caused by failure to implement a reconciliation control related to the Provider Relief Funds received and submitted on the HRSA Provider Relief Fund reporting portal to the amounts reported on the SEFA. Effect Failure to establish effective internal controls regarding the financial reporting for the preparation of the Schedule may prevent QHS from completing an audit in accordance with 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 that QHS implement a system of internal control that is designed and operating effectively to ensure the Schedule is complete and accurate. Views of Responsible Officials QHS agrees with the finding and accepts the recommendation.
Condition: The Single Audit reporting package, as defined and required in 2 CRF 200.512 for fiscal year ended June 30, 2022, was not submitted timely. Context: Despite the Municipality’s best efforts to provide, on a timely basis, the information needed to complete the preparation and subsequent audit of their financial statements, the effects of the major disaster area declaration due to Hurricane Fiona delayed the submission of the Single Audit reporting package of the current year. Criteria: As per 2 CRF 200.512, the audit, data collection form, and reporting package must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report, or nine months after the end of the audit period. However, for any 2022 submissions with fiscal periods ending between January 1, 2022, and October 31, 2022, the requirement stating that single audits are due to the Federal Audit Clearinghouse 30 days after receipt of the auditor’s report(s), is waived. These audits will be considered on time if they are submitted within nine months after their fiscal period end date. Cause: On September 18, 2022, Puerto Rico was declared a major disaster area due to the passage of Hurricane Fiona. As a result of this declaration, the OMB granted a six-month extension for all single audits that cover recipients in Puerto Rico and have due dates between September 18, 2022 and December 31, 2022. For June 30, 2021, the extended due date was March 31, 2023. The Municipality benefited from this extension and submitted their financial statements and data collection form on March 17, 2023. The due date of the current fiscal year, June 30, 2022 however was not extended and was also due on March 31, 2023. This situation prevented the timely submission of the current fiscal year Single Audit reporting package. Effect: Because of the situation described above, the Municipality did not comply with the report submission requirement since the audit was not submitted within nine months after their fiscal period end date. Auditor’s recommendation: Management should continue to fulfill their auditee responsibilities as stated in 2 CRF 200.508 which among other things, require management to prepare appropriate financial statements and provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit to ensure that subsequent financial reporting packages are submitted timely. Views of Responsible officials and corrective actions: The Municipality Administration is committed to complying with all submissions and has ensured the proper signing of an external auditors firm to comply with such requirements. Auditor Comments: 2 CFR 200.501 states that a non-federal entity that expends $750,000 or more in Federal awards during the non-Federal entity’s fiscal year must have a single audit conducted in accordance with 2 CFR 200.514. 2 CFR 200.508 states that it is the auditee responsibility to (1) prepare financial statements, including, the schedule of expenditures of Federal awards in accordance with 2 CFR 200.510, (2) promptly follow up and take corrective action on audit findings, including preparing a summary schedule of prior audit findings and a corrective plan, and (3) provide the auditor access to personnel, accounts, books, records, supporting documentation, and any other information needed for the auditor to perform the audit required by this part, among other things. Audit Status: In process of completion.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must 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. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) 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. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
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