State Agency: Illinois Department of Employment Security (IDES) Federal Agency: U.S. Department of Labor (USDOL) Program Name: Unemployment Insurance Program ALN and Program Expenditures: 17.225 ($1,931,585,889) Award Numbers: Various – see schedule of award numbers Federal Award Year: Various – see schedule of award numbers Questioned Costs: None Compliance Requirement: None Finding 2023-042: Inaccurate Reporting of Federal Expenditures Condition Found: IDES did not accurately report Federal expenditures under the Unemployment Insurance (UI) program. Federal expenditures reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDES’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDES and the SEFA amounts reported to the IOC for the Unemployment Insurance program for the year ended June 30, 2023: "See Table in the Audit Report". Finally, we noted IDES’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure timely, complete, and accurate SEFA reporting. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) 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. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 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 reported on the SEFA. Cause: In discussing the error with IDES officials, they stated during the Financial Audit, it was determined IDES needed two adjustments to their financial statements. These adjustments affected the SEFA expenditures. The first adjustment concerning the financial statements was caused by the bank's calculation of the nightly sweep for the collateralization of our funds at INB. The bank's instructions for the nightly sweep calculation did not match the bank's actual sweep and the difference appeared like NSF returns. The second adjustment concerning the financial statement was caused by the under reporting of the Combined Wage Claims. In addition, IDES included State spending within Federal expenditures on the SEFA in error, causing an overstatement of Federal expenditures. This resulted from following pre-pandemic procedures and reports that did not contemplate the State spending of administrative funds on Federal programs. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2023-042) Recommendation: We recommend IDES establish procedures to accurately report federal expenditures used to prepare the SEFA to the IOC. Views of IDES Officials: The Agency accepts the recommendation. The Agency is updating the way it prepares the Trust Fund GAAP package to avoid these types of adjustments and/or audit findings in the future.
FINDING NO: 2023-011 (Repeat 2022-026) STATE AGENCY: Oklahoma Department of Transportation FEDERAL AGENCY: U.S. Department of Transportation ALN: 20.509 FEDERAL PROGRAM NAME: Formula Grants for Rural Areas FEDERAL AWARD NUMBER: OK-2017-023-05, OK-2018-023-03, OK-2019-025-03, OK-2020-021-02, OK- 2021-018-00, OK-2022-016-00, OK-2022-025-00, OK-2022-027-00, OK-2023-026-00 FEDERAL AWARD YEAR: 2017, 2018, 2019, 2020, 2021, 2022, 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: 2 CFR 1201.1 states, “Except as otherwise provided in this part, the Department of Transportation adopts the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (2 CFR part 200). This part supersedes and repeals the requirements of the Department of Transportation Common Rules (49 CFR part 18 - Uniform Administrative Requirements for Grants and Cooperative Agreements to State and Local Governments and 49 CFR part 19 - Uniform Administrative Requirements - Uniform Administrative Requirements for Grants and Agreements with Institutions of Higher Education, Hospitals, and other Non-Profit Organizations), except that grants and cooperative agreements executed prior to December 26, 2014 shall continue to be subject to 49 CFR parts 18 and 19 as in effect on the date of such grants or agreements. New parts with terminology specific to the Department of Transportation follow.” 2 CFR §200.303 - Internal controls states in part, “The Non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR §200.502 (a), states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR §200.510 (b), states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 [Basis for determining Federal awards expended]… (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings 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. (4) Include the total amount provided to subrecipients from each Federal program.” Condition and Context: During the review of GAAP Package Z - Schedule of Expenditures of Federal Awards (SEFA) and supporting documentation for Formula Grants for Rural Areas, AL #20.509, we noted the amounts reported as paid to subrecipients did not match the accounting system of the Oklahoma Department of Transportation. The total subrecipient payments per the SEFA subrecipient column were $19,543,377; the Oklahoma Department of Transportation Project Funding System showed expenditures totaling $23,039,138.46. Cause: The Oklahoma Department of Transportation’s review process failed to identify the discrepancy between the GAAP Package Z and the accounting system. Effect: The total of sub-recipient expenditures for AL #20.509 per SEFA were understated by a total of $3,495,761.46: Formula Grants for Rural Areas subrecipient expenditures were understated by $2,065,333.46 and Formula Grants for Rural Areas - CARES Act subrecipient expenditures were understated for $1,430,428.00. Recommendation: We recommend the Department add steps to reconcile the subrecipient expenditures during its review process to ensure subrecipient expenditure amounts reported on the GAAP Package Z SEFA are properly stated and agree with accounting software. Views of Responsible Official(s) Contact Person: Sam Ddamba Anticipated Completion Date: September 2025 Corrective Action Planned: The Oklahoma Department of Transportation agrees with the finding. See corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-011 (Repeat 2022-026) STATE AGENCY: Oklahoma Department of Transportation FEDERAL AGENCY: U.S. Department of Transportation ALN: 20.509 FEDERAL PROGRAM NAME: Formula Grants for Rural Areas FEDERAL AWARD NUMBER: OK-2017-023-05, OK-2018-023-03, OK-2019-025-03, OK-2020-021-02, OK- 2021-018-00, OK-2022-016-00, OK-2022-025-00, OK-2022-027-00, OK-2023-026-00 FEDERAL AWARD YEAR: 2017, 2018, 2019, 2020, 2021, 2022, 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: 2 CFR 1201.1 states, “Except as otherwise provided in this part, the Department of Transportation adopts the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (2 CFR part 200). This part supersedes and repeals the requirements of the Department of Transportation Common Rules (49 CFR part 18 - Uniform Administrative Requirements for Grants and Cooperative Agreements to State and Local Governments and 49 CFR part 19 - Uniform Administrative Requirements - Uniform Administrative Requirements for Grants and Agreements with Institutions of Higher Education, Hospitals, and other Non-Profit Organizations), except that grants and cooperative agreements executed prior to December 26, 2014 shall continue to be subject to 49 CFR parts 18 and 19 as in effect on the date of such grants or agreements. New parts with terminology specific to the Department of Transportation follow.” 2 CFR §200.303 - Internal controls states in part, “The Non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR §200.502 (a), states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR §200.510 (b), states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 [Basis for determining Federal awards expended]… (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings 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. (4) Include the total amount provided to subrecipients from each Federal program.” Condition and Context: During the review of GAAP Package Z - Schedule of Expenditures of Federal Awards (SEFA) and supporting documentation for Formula Grants for Rural Areas, AL #20.509, we noted the amounts reported as paid to subrecipients did not match the accounting system of the Oklahoma Department of Transportation. The total subrecipient payments per the SEFA subrecipient column were $19,543,377; the Oklahoma Department of Transportation Project Funding System showed expenditures totaling $23,039,138.46. Cause: The Oklahoma Department of Transportation’s review process failed to identify the discrepancy between the GAAP Package Z and the accounting system. Effect: The total of sub-recipient expenditures for AL #20.509 per SEFA were understated by a total of $3,495,761.46: Formula Grants for Rural Areas subrecipient expenditures were understated by $2,065,333.46 and Formula Grants for Rural Areas - CARES Act subrecipient expenditures were understated for $1,430,428.00. Recommendation: We recommend the Department add steps to reconcile the subrecipient expenditures during its review process to ensure subrecipient expenditure amounts reported on the GAAP Package Z SEFA are properly stated and agree with accounting software. Views of Responsible Official(s) Contact Person: Sam Ddamba Anticipated Completion Date: September 2025 Corrective Action Planned: The Oklahoma Department of Transportation agrees with the finding. See corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-056 STATE AGENCY: State of Oklahoma and Office of Management and Enterprise Services (OMES) FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: Per 2 CFR § 200.303, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.502(a) states in part, “Determining Federal awards expended. The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” 2 CFR § 200.510(b) states in part, “Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. The schedule must include the total Federal awards expended as determined in accordance with §200.502. … (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available.” Condition and Context: The State of Oklahoma had sixteen (16) state agencies report CSLFRF expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for SFY 2023. The state created class fund 488 (ARPA Advance Grants) for administrative costs to run the grant, and class fund 497 (Statewide Recovery Fund) to facilitate the transfer of CSLFRF funds to agencies. Class fund 488 only applies to State of Oklahoma OMES - Grants Management Office (GMO) and class fund 497 applies to all agencies. For the thirteen (13) state agencies audited by the State Auditor’s Office, we noted the following SEFA exceptions: • Four agencies (Department of Health – agency 340; Legislative Services Bureau – agency 423; J.D. McCarty Center – agency 670; and Oklahoma Supreme Court – agency 677) did not include, but should have reported expenditures for, AL #21.027 CSLFRF on their SEFA • Three agencies (Health Care Workforce Training Commission – agency 619; Career Tech – agency 800; and Department of Human Services – agency 830) included AL #21.027 CSLFRF on their SEFA but did not accurately report their expenditures • One agency (Department of Public Safety – agency 585) failed to record AL #21.027 CSLFRF federal revenue on their SEFA • One agency (Office of Management and Enterprise Services – agency 090) did not accurately report expenditures: administrative payroll for class fund 488 (ARPA Advance Grants) was not included on their SEFA Based on testwork performed by State Auditor’s Office on CSLFRF state agency SEFA expenditures for SFY 2023, we determined the state agencies reported $12,307,194; and the correct SEFA total should have been $23,003,285. Further, when including outside audits of state agency CSLFRF funds, we determined total modified accrual federal expenditures reported were $66,697,853; however, the correct CSLFRF SEFA total for SFY 2023 should have been $77,393,944. Cause: The State of Oklahoma had no process, and failed to implement adequate controls, to ensure a SEFA was completed for each agency receiving CSLFRF funds. State agencies (090, 340, 423, 585, 619, 670, 677, 800, 830) lacked adequate controls to ensure SEFA expenditures, or federal revenue, for AL #21.027 were reported correctly. State agencies (340, 423, 585, 619, 670, 677, 800, 830) did not review the Summary of Receipts and Disbursements (SRD) report for class fund 497 (Statewide Recovery Fund) to ensure all federal expenditures were included on their SEFA. In addition, agency 090 did not review the SRD report for class funds 488 and 497 to ensure expenditures were included on the statewide SEFA. Effect: The State of Oklahoma under-reported SEFA expenditures by $10,696,091 for SFY 2023. In addition, agency 585 under-reported $858,278 in federal revenue. Recommendation: We recommend OMES ensure that state agencies strengthen controls over their SEFA process to ensure accurate reporting of CSLFRF expenditures, including a review of the SRD for class fund 497 to ensure CSLFRF expenditures are reported on their SEFA. Further, we recommend the State of Oklahoma review the SRD for class fund 497 (and 488 for agency 090) for the agencies that are transferred CSLFRF funds to ensure those with expenditures complete a SEFA. In addition, we recommend the State of Oklahoma reconcile state agency SEFAs to the SRD for class fund 497 (and 488 for agency 090) to ensure expenditures are reported accurately. Views of Responsible Official(s) Contact Person: OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson Anticipated Completion Date: 06/30/2026 Corrective Action Planned: The Office of Management Enterprise Services – Grants Management Office agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-202 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: The Uniform Guidance (2 CFR 200) §200.510 states in part an auditee should “prepare a schedule of expenditures of federal awards (“SEFA”) for the period covered by the auditee’s financial statement [that]… at a minimum shall… provide total federal awards expended for each individual program…”. The SEFA, Oklahoma Office of Management and Enterprise Services’ (“OMES”) Schedule Z should accurately capture all expenditures, and be reconciled and reviewed, by the Oklahoma Water Resources Board (“OWRB”). Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to generally accepted accounting principles (“GAAP”), expenditures should be recognized in the period incurred. Condition and Context: The original SEFA submitted by OWRB to OMES included the following errors: • Approximately $193,540,000 in cash transfers to OWRB’s Trustee were improperly recorded as expenditures. • Approximately $75,979,000 of subsequent cash transfers to OWRB’s Trustee were improperly accrued as accounts payable in fiscal year 2023, resulting in a further overstatement of expenditures. Cause and Effect: OWRB received Board approval as required in accordance with Oklahoma Statue Title 785 §50.15.1 to make grant awards of American Rescue Plan Act (“ARPA”) funds to qualified entities for qualified project purposes. Upon receiving the necessary approvals, OWRB then transferred cash from the Oklahoma State Treasurer to its Trustee’s bank accounts, earmarking the cash dedicated to a subrecipient’s future project. In doing so, an approved purchase order and voucher was submitted to OMES, which resulted in expenditures being recorded in the statewide accounting system, PeopleSoft. These funds are maintained in the Trustee bank accounts and invested in highly liquid cash equivalents in accordance with Oklahoma Statute Title 62 §348.1, earning a higher rate of interest for the program. As a result of the cash transfers erroneously being reported as expenditures, the GAAP reporting of federal spending in Assistance Listing Number 21.027 was materially overstated by a total of approximately $268,407,000 for fiscal year ending June 30, 2023. Recommendation: We recommend OWRB’s management works with OMES to appropriately reflect cash transfers to the Trustee bank as a journal entry from cash to restricted cash, along with recording the actual expenditures as a reduction to restricted cash. Lastly, as expenditures are incurred, we recommend reducing the transfer in from state to then recognize the corresponding revenue earned as claim reimbursements are made to subrecipients. Views of Responsible Official(s) Contact Person: Cleve Pierce, Chief of Administrative Services/CFO, Jessica Billingsley, Comptroller/Financial Manager Anticipated Completion Date: 6/30/25 Corrective Action Planned: The Oklahoma Water Resources Board agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-206 (Repeat Finding 2022-202) STATE AGENCY: Oklahoma Department of Health FEDERAL AGENCY: United States Department of Health and Human Services ALN: 93.268 FEDERAL PROGRAM NAME: Immunizations Cooperative Agreements FEDERAL AWARD NUMBER: 6 NH23IP922575-02-05, 6 NH23IP922575-02-06, 6 NH23IP922575-03-01, 5 NH23IP922575-003-00 FEDERAL AWARD YEAR: 2020, 2021, 2022 CONTROL CATEGORY: Reporting QUESTIONED COSTS: Unknown Criteria: The Schedule of Expenditures of Federal Awards (SEFA – GAAP Package Schedule Z) should be accurately captured, reconciled, and reviewed by the Oklahoma State Department of Health (the “Department”). Adequate documentation of procedures performed, as well as evidence of thorough reviews, should be in place. According to GAAP, expenditures should be recognized in the period services are performed or goods are received. In accordance with the modified accrual basis of accounting, federal grant revenues should be recognized when applicable eligibility requirements, including reimbursement, time requirements, and other eligibility requirements, are met and the resources are available. Revenues are considered available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. In accordance with the State of Oklahoma’s Annual Comprehensive Financial Report, the State considers revenues to be available if they are collected within sixty days of the end of the fiscal year. Additionally, the Federal Financial Report (FFR), SF-425, is required on an annual basis except for awards where more frequent reporting is noted in the Notice of Award. The report also must cover any authorized extension during the reported budget period. Grant recipients submit FFRs to the U.S. Department of Health and Human Services (HHS) Payment Management System (PMS). Annual FFRs are due 90 days after the end of the budget period and final FFRs are due 90 days after the end of the period of performance. Lastly, The Uniform Guidance (2 CFR 200) § 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statement [that]….at a minimum shall…list individual Federal programs by Federal agency… [and] provide total Federal awards expended for each individual Federal program… [and] include the total amount provided to subrecipients for each Federal program” In accordance with Uniform Guidance, the Department is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Furthermore, the State of Oklahoma’s Schedule Z SEFA Conversion Package states, “The amount reported as provided by the primary recipient to state agencies should be entered in the ‘Amount Transferred to State Agencies’ column. This amount should be included in the Federal revenue but not in expense columns of the primary recipient.” Condition: The original SEFA submitted by the Department to the Office of Management and Enterprise Services (OMES) included the following errors: • AL# 93.268 reported federal revenues approximately $3,648,000 higher than its federal expenditures for a predominately reimbursement-based grant, resulting in the inability to determine completeness of the expenditure details provided for audit testing. • 29 out of 138, or 21%, of tested federal expenditure selections for AL# 93.268 were recorded in an incorrect accounting period, which totaled approximately $85,400. Additionally, the department was unable to provide supporting details of recorded transactions agreeing to the federal revenues reported in Schedule Z. Furthermore, all FFR’s tested for AL# 93.323 were not timely filed within 90 days subsequent to year end, as required by the Center for Disease Control and Prevention (CDC). Supporting schedules to FFRs for AL# 93.268 were not made available for audit testing. Cause and Effect: The Department does not have appropriate internal procedures for capturing and reporting the federal expenditures, revenues, and subrecipient payments on the SEFA in accordance with the Uniform Guidance (2 CFR 200) § 200.510. Revenues are recorded by the department on a cash basis and deposits are not recorded in the general ledger (GL) with a unique identifier to indicate which fiscal year the matching expenditures reside. Also, batched cash deposits containing sources of revenues from differing fiscal years cannot be appropriately allocated to the year in which the revenue was earned. Batched deposits are recorded as a single GL transaction regardless of the year the related deposit was earned and contain revenues where the related expenditures were recorded in differing fiscal years. As a result, the Department’s GL does not possess sufficient detail to accurately account for the required modified accrual basis conversions. The Department has not ensured that the transactional data recorded provides enough detail to accurately report the federal activity in Schedule Z and FFR’s. Recommendation: We recommend the Department review and document the current procedures and implement the necessary changes to ensure adequate reporting of program financial information in the SEFA and FFR’s. Specifically, we recommend the Department continues to review its cash reporting and deciphers batch deposits by fiscal year, with a unique identifier recorded at the GL transaction level. Additionally, we recommend retaining evidence that adequate reviews of the SEFA and FFR’s occurred. We also recommend the Department establish procedures to timely reconcile federal revenues to its federal expenditures to ensure completeness of its related federal reporting. Views of Responsible Official(s) Contact Person: Stefan Von Dollen Anticipated Completion Date: 6/30/24 Corrective Action Planned: The Oklahoma State Department of Health agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-206 (Repeat Finding 2022-202) STATE AGENCY: Oklahoma Department of Health FEDERAL AGENCY: United States Department of Health and Human Services ALN: 93.268 FEDERAL PROGRAM NAME: Immunizations Cooperative Agreements FEDERAL AWARD NUMBER: 6 NH23IP922575-02-05, 6 NH23IP922575-02-06, 6 NH23IP922575-03-01, 5 NH23IP922575-003-00 FEDERAL AWARD YEAR: 2020, 2021, 2022 CONTROL CATEGORY: Reporting QUESTIONED COSTS: Unknown Criteria: The Schedule of Expenditures of Federal Awards (SEFA – GAAP Package Schedule Z) should be accurately captured, reconciled, and reviewed by the Oklahoma State Department of Health (the “Department”). Adequate documentation of procedures performed, as well as evidence of thorough reviews, should be in place. According to GAAP, expenditures should be recognized in the period services are performed or goods are received. In accordance with the modified accrual basis of accounting, federal grant revenues should be recognized when applicable eligibility requirements, including reimbursement, time requirements, and other eligibility requirements, are met and the resources are available. Revenues are considered available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. In accordance with the State of Oklahoma’s Annual Comprehensive Financial Report, the State considers revenues to be available if they are collected within sixty days of the end of the fiscal year. Additionally, the Federal Financial Report (FFR), SF-425, is required on an annual basis except for awards where more frequent reporting is noted in the Notice of Award. The report also must cover any authorized extension during the reported budget period. Grant recipients submit FFRs to the U.S. Department of Health and Human Services (HHS) Payment Management System (PMS). Annual FFRs are due 90 days after the end of the budget period and final FFRs are due 90 days after the end of the period of performance. Lastly, The Uniform Guidance (2 CFR 200) § 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statement [that]….at a minimum shall…list individual Federal programs by Federal agency… [and] provide total Federal awards expended for each individual Federal program… [and] include the total amount provided to subrecipients for each Federal program” In accordance with Uniform Guidance, the Department is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Furthermore, the State of Oklahoma’s Schedule Z SEFA Conversion Package states, “The amount reported as provided by the primary recipient to state agencies should be entered in the ‘Amount Transferred to State Agencies’ column. This amount should be included in the Federal revenue but not in expense columns of the primary recipient.” Condition: The original SEFA submitted by the Department to the Office of Management and Enterprise Services (OMES) included the following errors: • AL# 93.268 reported federal revenues approximately $3,648,000 higher than its federal expenditures for a predominately reimbursement-based grant, resulting in the inability to determine completeness of the expenditure details provided for audit testing. • 29 out of 138, or 21%, of tested federal expenditure selections for AL# 93.268 were recorded in an incorrect accounting period, which totaled approximately $85,400. Additionally, the department was unable to provide supporting details of recorded transactions agreeing to the federal revenues reported in Schedule Z. Furthermore, all FFR’s tested for AL# 93.323 were not timely filed within 90 days subsequent to year end, as required by the Center for Disease Control and Prevention (CDC). Supporting schedules to FFRs for AL# 93.268 were not made available for audit testing. Cause and Effect: The Department does not have appropriate internal procedures for capturing and reporting the federal expenditures, revenues, and subrecipient payments on the SEFA in accordance with the Uniform Guidance (2 CFR 200) § 200.510. Revenues are recorded by the department on a cash basis and deposits are not recorded in the general ledger (GL) with a unique identifier to indicate which fiscal year the matching expenditures reside. Also, batched cash deposits containing sources of revenues from differing fiscal years cannot be appropriately allocated to the year in which the revenue was earned. Batched deposits are recorded as a single GL transaction regardless of the year the related deposit was earned and contain revenues where the related expenditures were recorded in differing fiscal years. As a result, the Department’s GL does not possess sufficient detail to accurately account for the required modified accrual basis conversions. The Department has not ensured that the transactional data recorded provides enough detail to accurately report the federal activity in Schedule Z and FFR’s. Recommendation: We recommend the Department review and document the current procedures and implement the necessary changes to ensure adequate reporting of program financial information in the SEFA and FFR’s. Specifically, we recommend the Department continues to review its cash reporting and deciphers batch deposits by fiscal year, with a unique identifier recorded at the GL transaction level. Additionally, we recommend retaining evidence that adequate reviews of the SEFA and FFR’s occurred. We also recommend the Department establish procedures to timely reconcile federal revenues to its federal expenditures to ensure completeness of its related federal reporting. Views of Responsible Official(s) Contact Person: Stefan Von Dollen Anticipated Completion Date: 6/30/24 Corrective Action Planned: The Oklahoma State Department of Health agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-207 (Repeat Finding 2022-202) STATE AGENCY: Oklahoma Department of Health FEDERAL AGENCY: United States Department of Health and Human Services ALN: 93.323 FEDERAL PROGRAM NAME: Epidemiology and Laboratory Capacity for Infectious Diseases FEDERAL AWARD NUMBER: NU50CK000535-02-04, NU50CK000535-02-06, NU50CK000535-01-04, NU50CK000535-01-05 FEDERAL AWARD YEAR: 2020, 2021, 2022 CONTROL CATEGORY: Reporting QUESTIONED COSTS: Unknown Criteria: The Schedule of Expenditures of Federal Awards (SEFA – GAAP Package Schedule Z) should be accurately captured, reconciled, and reviewed by the Oklahoma State Department of Health (the “Department”). Adequate documentation of procedures performed, as well as evidence of thorough reviews, should be in place. According to GAAP, expenditures should be recognized in the period services are performed or goods are received. In accordance with the modified accrual basis of accounting, federal grant revenues should be recognized when applicable eligibility requirements, including reimbursement, time requirements, and other eligibility requirements, are met and the resources are available. Revenues are considered available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. In accordance with the State of Oklahoma’s Annual Comprehensive Financial Report, the State considers revenues to be available if they are collected within sixty days of the end of the fiscal year. Additionally, the Federal Financial Report (FFR), SF-425, is required on an annual basis except for awards where more frequent reporting is noted in the Notice of Award. The report also must cover any authorized extension during the reported budget period. Grant recipients submit FFRs to the U.S. Department of Health and Human Services (HHS) Payment Management System (PMS). Annual FFRs are due 90 days after the end of the budget period and final FFRs are due 90 days after the end of the period of performance. Lastly, The Uniform Guidance (2 CFR 200) § 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statement [that]….at a minimum shall…list individual Federal programs by Federal agency… [and] provide total Federal awards expended for each individual Federal program… [and] include the total amount provided to subrecipients for each Federal program” In accordance with Uniform Guidance, the Department is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Furthermore, the State of Oklahoma’s Schedule Z SEFA Conversion Package states, “The amount reported as provided by the primary recipient to state agencies should be entered in the ‘Amount Transferred to State Agencies’ column. This amount should be included in the Federal revenue but not in expense columns of the primary recipient.” Condition: The original SEFA submitted by the Department to the Office of Management and Enterprise Services (OMES) included the following errors: • AL# 93.323 reported federal revenues approximately $25,358,000 higher than its federal expenditures for a predominately reimbursement-based grant, resulting in the inability to determine the completeness of the expenditure details provided for audit testing. • Approximately $9,776,000 in state transfers to the Department of Education were omitted from subrecipient payments for AL# 93.323 in accordance with the State’s Schedule Z Conversion Package. • 39 out of 138, or 28%, of tested federal expenditure selections for AL# 93.323 were recorded in an incorrect accounting period, which totaled approximately $4,993,100. Additionally, the department was unable to provide supporting details of recorded transactions agreeing to the federal revenues reported in Schedule Z. Furthermore, all FFR’s tested for AL# 93.323 were not timely filed within 90 days subsequent to year end, as required by the Center for Disease Control and Prevention (CDC). Supporting schedules to FFRs for AL# 93.323 were not made available for audit testing. Cause and Effect: The Department does not have appropriate internal procedures for capturing and reporting the federal expenditures, revenues, and subrecipient payments on the SEFA in accordance with the Uniform Guidance (2 CFR 200) § 200.510. Revenues are recorded by the department on a cash basis and deposits are not recorded in the general ledger (GL) with a unique identifier to indicate which fiscal year the matching expenditures reside. Also, batched cash deposits containing sources of revenues from differing fiscal years cannot be appropriately allocated to the year in which the revenue was earned. Batched deposits are recorded as a single GL transaction regardless of the year the related deposit was earned and contain revenues where the related expenditures were recorded in differing fiscal years. As a result, the Department’s GL does not possess sufficient detail to accurately account for the required modified accrual basis conversions. The Department has not ensured that the transactional data recorded provides enough detail to accurately report the federal activity in Schedule Z and FFR’s. Recommendation: We recommend the Department review and document the current procedures and implement the necessary changes to ensure adequate reporting of program financial information in the SEFA and FFR’s. Specifically, we recommend the Department continues to review its cash reporting and deciphers batch deposits by fiscal year, with a unique identifier recorded at the GL transaction level. Additionally, we recommend retaining evidence that adequate reviews of the SEFA and FFR’s occurred. We also recommend the Department establish procedures to timely reconcile federal revenues to its federal expenditures to ensure completeness of its related federal reporting. Views of Responsible Official(s) Contact Person: Stefan Von Dollen Anticipated Completion Date: 6/30/24 Corrective Action Planned: The Oklahoma State Department of Health agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-211 STATE AGENCY: Oklahoma Department of Education FEDERAL AGENCY: United States Department of Health and Human Services ALN: 93.323 FEDERAL PROGRAM NAME: Epidemiology and Laboratory Capacity for Infectious Diseases, passed through the Oklahoma State Department of Health FEDERAL AWARD NUMBER: NU50CK000535 FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Other/Reporting QUESTIONED COSTS: Unknown Criteria: Per 2 CFR §200.303(a), the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. A key component of an effective internal control system is a strong control environment, including a culture of integrity and ethical values fostered by the organization’s leadership. Additionally, the Uniform Guidance (2 CFR 200) § 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statement [that]….at a minimum shall… provide total Federal awards expended for each individual Federal program and the Assistance Listing Number (AL#) or other identifying number when the AL# information is not available.” In accordance with Uniform Guidance, the Department is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Condition and Context: During our audit of the AL# 93.323, Epidemiology Laboratory Capacity (“ELC”), we observed that the Oklahoma State Department of Education (OSDE”) did not adequately establish and/or enforce internal control procedures. Specifically, we noted the following: Inconsistent application of accounting and governing body policies. Leadership of OSDE did not set an adequate tone at the top for appropriate fiscal responsibility of funds. The Department’s previous management did not maintain adequate procedural manuals and internal control narratives to ensure effective internal controls over their accounting records. Accounting records were not supported by appropriate subsidiary records to permit the preparation of accurate federal expenditure reporting on a timely basis. Procedures were not in place to ensure that underlying transactions recorded in the statewide PeopleSoft accounting system were reconciled by appropriate grant source and reported to the State in accordance with the State of Oklahoma’s Schedule Z Schedule of Expenditures of Federal Awards (“SEFA”) Conversion Package, with an approximate $1,550,000 variance between the underlying accounting records versus reported spend per Schedule Z. Cause and Effect: A lack of internal control procedures increases the risk of noncompliance with federal awards. Furthermore, the tone at the top set by leadership of OSDE has not prioritized compliance with laws and regulations and allowable uses of federal awards. Significant turnover of personnel at OSDE resulted in existing management’s inability to reconcile the underlying accounting records to prior management’s reported spend of AL# 93.323 reported per the SEFA Schedule Z. As a result, a variance of approximately $1,550,000 existed between the statewide PeopleSoft accounting system and the reported federal spending per Schedule Z for AL#93.323. Recommendation: We recommend management now in place in the Comptroller’s office of OSDE adequately documents internal control procedures and reconciles federal expenditures to the appropriate funding sources in the statewide accounting system. Views of Responsible Official(s) Contact Person: Shawn Richmond, Comptroller Anticipated Completion Date: 6/30/2024 Corrective Action Planned: The Oklahoma Department of Education agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-207 (Repeat Finding 2022-202) STATE AGENCY: Oklahoma Department of Health FEDERAL AGENCY: United States Department of Health and Human Services ALN: 93.323 FEDERAL PROGRAM NAME: Epidemiology and Laboratory Capacity for Infectious Diseases FEDERAL AWARD NUMBER: NU50CK000535-02-04, NU50CK000535-02-06, NU50CK000535-01-04, NU50CK000535-01-05 FEDERAL AWARD YEAR: 2020, 2021, 2022 CONTROL CATEGORY: Reporting QUESTIONED COSTS: Unknown Criteria: The Schedule of Expenditures of Federal Awards (SEFA – GAAP Package Schedule Z) should be accurately captured, reconciled, and reviewed by the Oklahoma State Department of Health (the “Department”). Adequate documentation of procedures performed, as well as evidence of thorough reviews, should be in place. According to GAAP, expenditures should be recognized in the period services are performed or goods are received. In accordance with the modified accrual basis of accounting, federal grant revenues should be recognized when applicable eligibility requirements, including reimbursement, time requirements, and other eligibility requirements, are met and the resources are available. Revenues are considered available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. In accordance with the State of Oklahoma’s Annual Comprehensive Financial Report, the State considers revenues to be available if they are collected within sixty days of the end of the fiscal year. Additionally, the Federal Financial Report (FFR), SF-425, is required on an annual basis except for awards where more frequent reporting is noted in the Notice of Award. The report also must cover any authorized extension during the reported budget period. Grant recipients submit FFRs to the U.S. Department of Health and Human Services (HHS) Payment Management System (PMS). Annual FFRs are due 90 days after the end of the budget period and final FFRs are due 90 days after the end of the period of performance. Lastly, The Uniform Guidance (2 CFR 200) § 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statement [that]….at a minimum shall…list individual Federal programs by Federal agency… [and] provide total Federal awards expended for each individual Federal program… [and] include the total amount provided to subrecipients for each Federal program” In accordance with Uniform Guidance, the Department is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Furthermore, the State of Oklahoma’s Schedule Z SEFA Conversion Package states, “The amount reported as provided by the primary recipient to state agencies should be entered in the ‘Amount Transferred to State Agencies’ column. This amount should be included in the Federal revenue but not in expense columns of the primary recipient.” Condition: The original SEFA submitted by the Department to the Office of Management and Enterprise Services (OMES) included the following errors: • AL# 93.323 reported federal revenues approximately $25,358,000 higher than its federal expenditures for a predominately reimbursement-based grant, resulting in the inability to determine the completeness of the expenditure details provided for audit testing. • Approximately $9,776,000 in state transfers to the Department of Education were omitted from subrecipient payments for AL# 93.323 in accordance with the State’s Schedule Z Conversion Package. • 39 out of 138, or 28%, of tested federal expenditure selections for AL# 93.323 were recorded in an incorrect accounting period, which totaled approximately $4,993,100. Additionally, the department was unable to provide supporting details of recorded transactions agreeing to the federal revenues reported in Schedule Z. Furthermore, all FFR’s tested for AL# 93.323 were not timely filed within 90 days subsequent to year end, as required by the Center for Disease Control and Prevention (CDC). Supporting schedules to FFRs for AL# 93.323 were not made available for audit testing. Cause and Effect: The Department does not have appropriate internal procedures for capturing and reporting the federal expenditures, revenues, and subrecipient payments on the SEFA in accordance with the Uniform Guidance (2 CFR 200) § 200.510. Revenues are recorded by the department on a cash basis and deposits are not recorded in the general ledger (GL) with a unique identifier to indicate which fiscal year the matching expenditures reside. Also, batched cash deposits containing sources of revenues from differing fiscal years cannot be appropriately allocated to the year in which the revenue was earned. Batched deposits are recorded as a single GL transaction regardless of the year the related deposit was earned and contain revenues where the related expenditures were recorded in differing fiscal years. As a result, the Department’s GL does not possess sufficient detail to accurately account for the required modified accrual basis conversions. The Department has not ensured that the transactional data recorded provides enough detail to accurately report the federal activity in Schedule Z and FFR’s. Recommendation: We recommend the Department review and document the current procedures and implement the necessary changes to ensure adequate reporting of program financial information in the SEFA and FFR’s. Specifically, we recommend the Department continues to review its cash reporting and deciphers batch deposits by fiscal year, with a unique identifier recorded at the GL transaction level. Additionally, we recommend retaining evidence that adequate reviews of the SEFA and FFR’s occurred. We also recommend the Department establish procedures to timely reconcile federal revenues to its federal expenditures to ensure completeness of its related federal reporting. Views of Responsible Official(s) Contact Person: Stefan Von Dollen Anticipated Completion Date: 6/30/24 Corrective Action Planned: The Oklahoma State Department of Health agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-211 STATE AGENCY: Oklahoma Department of Education FEDERAL AGENCY: United States Department of Health and Human Services ALN: 93.323 FEDERAL PROGRAM NAME: Epidemiology and Laboratory Capacity for Infectious Diseases, passed through the Oklahoma State Department of Health FEDERAL AWARD NUMBER: NU50CK000535 FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Other/Reporting QUESTIONED COSTS: Unknown Criteria: Per 2 CFR §200.303(a), the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. A key component of an effective internal control system is a strong control environment, including a culture of integrity and ethical values fostered by the organization’s leadership. Additionally, the Uniform Guidance (2 CFR 200) § 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statement [that]….at a minimum shall… provide total Federal awards expended for each individual Federal program and the Assistance Listing Number (AL#) or other identifying number when the AL# information is not available.” In accordance with Uniform Guidance, the Department is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Condition and Context: During our audit of the AL# 93.323, Epidemiology Laboratory Capacity (“ELC”), we observed that the Oklahoma State Department of Education (OSDE”) did not adequately establish and/or enforce internal control procedures. Specifically, we noted the following: Inconsistent application of accounting and governing body policies. Leadership of OSDE did not set an adequate tone at the top for appropriate fiscal responsibility of funds. The Department’s previous management did not maintain adequate procedural manuals and internal control narratives to ensure effective internal controls over their accounting records. Accounting records were not supported by appropriate subsidiary records to permit the preparation of accurate federal expenditure reporting on a timely basis. Procedures were not in place to ensure that underlying transactions recorded in the statewide PeopleSoft accounting system were reconciled by appropriate grant source and reported to the State in accordance with the State of Oklahoma’s Schedule Z Schedule of Expenditures of Federal Awards (“SEFA”) Conversion Package, with an approximate $1,550,000 variance between the underlying accounting records versus reported spend per Schedule Z. Cause and Effect: A lack of internal control procedures increases the risk of noncompliance with federal awards. Furthermore, the tone at the top set by leadership of OSDE has not prioritized compliance with laws and regulations and allowable uses of federal awards. Significant turnover of personnel at OSDE resulted in existing management’s inability to reconcile the underlying accounting records to prior management’s reported spend of AL# 93.323 reported per the SEFA Schedule Z. As a result, a variance of approximately $1,550,000 existed between the statewide PeopleSoft accounting system and the reported federal spending per Schedule Z for AL#93.323. Recommendation: We recommend management now in place in the Comptroller’s office of OSDE adequately documents internal control procedures and reconciles federal expenditures to the appropriate funding sources in the statewide accounting system. Views of Responsible Official(s) Contact Person: Shawn Richmond, Comptroller Anticipated Completion Date: 6/30/2024 Corrective Action Planned: The Oklahoma Department of Education agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-207 (Repeat Finding 2022-202) STATE AGENCY: Oklahoma Department of Health FEDERAL AGENCY: United States Department of Health and Human Services ALN: 93.323 FEDERAL PROGRAM NAME: Epidemiology and Laboratory Capacity for Infectious Diseases FEDERAL AWARD NUMBER: NU50CK000535-02-04, NU50CK000535-02-06, NU50CK000535-01-04, NU50CK000535-01-05 FEDERAL AWARD YEAR: 2020, 2021, 2022 CONTROL CATEGORY: Reporting QUESTIONED COSTS: Unknown Criteria: The Schedule of Expenditures of Federal Awards (SEFA – GAAP Package Schedule Z) should be accurately captured, reconciled, and reviewed by the Oklahoma State Department of Health (the “Department”). Adequate documentation of procedures performed, as well as evidence of thorough reviews, should be in place. According to GAAP, expenditures should be recognized in the period services are performed or goods are received. In accordance with the modified accrual basis of accounting, federal grant revenues should be recognized when applicable eligibility requirements, including reimbursement, time requirements, and other eligibility requirements, are met and the resources are available. Revenues are considered available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. In accordance with the State of Oklahoma’s Annual Comprehensive Financial Report, the State considers revenues to be available if they are collected within sixty days of the end of the fiscal year. Additionally, the Federal Financial Report (FFR), SF-425, is required on an annual basis except for awards where more frequent reporting is noted in the Notice of Award. The report also must cover any authorized extension during the reported budget period. Grant recipients submit FFRs to the U.S. Department of Health and Human Services (HHS) Payment Management System (PMS). Annual FFRs are due 90 days after the end of the budget period and final FFRs are due 90 days after the end of the period of performance. Lastly, The Uniform Guidance (2 CFR 200) § 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statement [that]….at a minimum shall…list individual Federal programs by Federal agency… [and] provide total Federal awards expended for each individual Federal program… [and] include the total amount provided to subrecipients for each Federal program” In accordance with Uniform Guidance, the Department is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Furthermore, the State of Oklahoma’s Schedule Z SEFA Conversion Package states, “The amount reported as provided by the primary recipient to state agencies should be entered in the ‘Amount Transferred to State Agencies’ column. This amount should be included in the Federal revenue but not in expense columns of the primary recipient.” Condition: The original SEFA submitted by the Department to the Office of Management and Enterprise Services (OMES) included the following errors: • AL# 93.323 reported federal revenues approximately $25,358,000 higher than its federal expenditures for a predominately reimbursement-based grant, resulting in the inability to determine the completeness of the expenditure details provided for audit testing. • Approximately $9,776,000 in state transfers to the Department of Education were omitted from subrecipient payments for AL# 93.323 in accordance with the State’s Schedule Z Conversion Package. • 39 out of 138, or 28%, of tested federal expenditure selections for AL# 93.323 were recorded in an incorrect accounting period, which totaled approximately $4,993,100. Additionally, the department was unable to provide supporting details of recorded transactions agreeing to the federal revenues reported in Schedule Z. Furthermore, all FFR’s tested for AL# 93.323 were not timely filed within 90 days subsequent to year end, as required by the Center for Disease Control and Prevention (CDC). Supporting schedules to FFRs for AL# 93.323 were not made available for audit testing. Cause and Effect: The Department does not have appropriate internal procedures for capturing and reporting the federal expenditures, revenues, and subrecipient payments on the SEFA in accordance with the Uniform Guidance (2 CFR 200) § 200.510. Revenues are recorded by the department on a cash basis and deposits are not recorded in the general ledger (GL) with a unique identifier to indicate which fiscal year the matching expenditures reside. Also, batched cash deposits containing sources of revenues from differing fiscal years cannot be appropriately allocated to the year in which the revenue was earned. Batched deposits are recorded as a single GL transaction regardless of the year the related deposit was earned and contain revenues where the related expenditures were recorded in differing fiscal years. As a result, the Department’s GL does not possess sufficient detail to accurately account for the required modified accrual basis conversions. The Department has not ensured that the transactional data recorded provides enough detail to accurately report the federal activity in Schedule Z and FFR’s. Recommendation: We recommend the Department review and document the current procedures and implement the necessary changes to ensure adequate reporting of program financial information in the SEFA and FFR’s. Specifically, we recommend the Department continues to review its cash reporting and deciphers batch deposits by fiscal year, with a unique identifier recorded at the GL transaction level. Additionally, we recommend retaining evidence that adequate reviews of the SEFA and FFR’s occurred. We also recommend the Department establish procedures to timely reconcile federal revenues to its federal expenditures to ensure completeness of its related federal reporting. Views of Responsible Official(s) Contact Person: Stefan Von Dollen Anticipated Completion Date: 6/30/24 Corrective Action Planned: The Oklahoma State Department of Health agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-211 STATE AGENCY: Oklahoma Department of Education FEDERAL AGENCY: United States Department of Health and Human Services ALN: 93.323 FEDERAL PROGRAM NAME: Epidemiology and Laboratory Capacity for Infectious Diseases, passed through the Oklahoma State Department of Health FEDERAL AWARD NUMBER: NU50CK000535 FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Other/Reporting QUESTIONED COSTS: Unknown Criteria: Per 2 CFR §200.303(a), the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. A key component of an effective internal control system is a strong control environment, including a culture of integrity and ethical values fostered by the organization’s leadership. Additionally, the Uniform Guidance (2 CFR 200) § 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statement [that]….at a minimum shall… provide total Federal awards expended for each individual Federal program and the Assistance Listing Number (AL#) or other identifying number when the AL# information is not available.” In accordance with Uniform Guidance, the Department is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Condition and Context: During our audit of the AL# 93.323, Epidemiology Laboratory Capacity (“ELC”), we observed that the Oklahoma State Department of Education (OSDE”) did not adequately establish and/or enforce internal control procedures. Specifically, we noted the following: Inconsistent application of accounting and governing body policies. Leadership of OSDE did not set an adequate tone at the top for appropriate fiscal responsibility of funds. The Department’s previous management did not maintain adequate procedural manuals and internal control narratives to ensure effective internal controls over their accounting records. Accounting records were not supported by appropriate subsidiary records to permit the preparation of accurate federal expenditure reporting on a timely basis. Procedures were not in place to ensure that underlying transactions recorded in the statewide PeopleSoft accounting system were reconciled by appropriate grant source and reported to the State in accordance with the State of Oklahoma’s Schedule Z Schedule of Expenditures of Federal Awards (“SEFA”) Conversion Package, with an approximate $1,550,000 variance between the underlying accounting records versus reported spend per Schedule Z. Cause and Effect: A lack of internal control procedures increases the risk of noncompliance with federal awards. Furthermore, the tone at the top set by leadership of OSDE has not prioritized compliance with laws and regulations and allowable uses of federal awards. Significant turnover of personnel at OSDE resulted in existing management’s inability to reconcile the underlying accounting records to prior management’s reported spend of AL# 93.323 reported per the SEFA Schedule Z. As a result, a variance of approximately $1,550,000 existed between the statewide PeopleSoft accounting system and the reported federal spending per Schedule Z for AL#93.323. Recommendation: We recommend management now in place in the Comptroller’s office of OSDE adequately documents internal control procedures and reconciles federal expenditures to the appropriate funding sources in the statewide accounting system. Views of Responsible Official(s) Contact Person: Shawn Richmond, Comptroller Anticipated Completion Date: 6/30/2024 Corrective Action Planned: The Oklahoma Department of Education agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-207 (Repeat Finding 2022-202) STATE AGENCY: Oklahoma Department of Health FEDERAL AGENCY: United States Department of Health and Human Services ALN: 93.323 FEDERAL PROGRAM NAME: Epidemiology and Laboratory Capacity for Infectious Diseases FEDERAL AWARD NUMBER: NU50CK000535-02-04, NU50CK000535-02-06, NU50CK000535-01-04, NU50CK000535-01-05 FEDERAL AWARD YEAR: 2020, 2021, 2022 CONTROL CATEGORY: Reporting QUESTIONED COSTS: Unknown Criteria: The Schedule of Expenditures of Federal Awards (SEFA – GAAP Package Schedule Z) should be accurately captured, reconciled, and reviewed by the Oklahoma State Department of Health (the “Department”). Adequate documentation of procedures performed, as well as evidence of thorough reviews, should be in place. According to GAAP, expenditures should be recognized in the period services are performed or goods are received. In accordance with the modified accrual basis of accounting, federal grant revenues should be recognized when applicable eligibility requirements, including reimbursement, time requirements, and other eligibility requirements, are met and the resources are available. Revenues are considered available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. In accordance with the State of Oklahoma’s Annual Comprehensive Financial Report, the State considers revenues to be available if they are collected within sixty days of the end of the fiscal year. Additionally, the Federal Financial Report (FFR), SF-425, is required on an annual basis except for awards where more frequent reporting is noted in the Notice of Award. The report also must cover any authorized extension during the reported budget period. Grant recipients submit FFRs to the U.S. Department of Health and Human Services (HHS) Payment Management System (PMS). Annual FFRs are due 90 days after the end of the budget period and final FFRs are due 90 days after the end of the period of performance. Lastly, The Uniform Guidance (2 CFR 200) § 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statement [that]….at a minimum shall…list individual Federal programs by Federal agency… [and] provide total Federal awards expended for each individual Federal program… [and] include the total amount provided to subrecipients for each Federal program” In accordance with Uniform Guidance, the Department is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Furthermore, the State of Oklahoma’s Schedule Z SEFA Conversion Package states, “The amount reported as provided by the primary recipient to state agencies should be entered in the ‘Amount Transferred to State Agencies’ column. This amount should be included in the Federal revenue but not in expense columns of the primary recipient.” Condition: The original SEFA submitted by the Department to the Office of Management and Enterprise Services (OMES) included the following errors: • AL# 93.323 reported federal revenues approximately $25,358,000 higher than its federal expenditures for a predominately reimbursement-based grant, resulting in the inability to determine the completeness of the expenditure details provided for audit testing. • Approximately $9,776,000 in state transfers to the Department of Education were omitted from subrecipient payments for AL# 93.323 in accordance with the State’s Schedule Z Conversion Package. • 39 out of 138, or 28%, of tested federal expenditure selections for AL# 93.323 were recorded in an incorrect accounting period, which totaled approximately $4,993,100. Additionally, the department was unable to provide supporting details of recorded transactions agreeing to the federal revenues reported in Schedule Z. Furthermore, all FFR’s tested for AL# 93.323 were not timely filed within 90 days subsequent to year end, as required by the Center for Disease Control and Prevention (CDC). Supporting schedules to FFRs for AL# 93.323 were not made available for audit testing. Cause and Effect: The Department does not have appropriate internal procedures for capturing and reporting the federal expenditures, revenues, and subrecipient payments on the SEFA in accordance with the Uniform Guidance (2 CFR 200) § 200.510. Revenues are recorded by the department on a cash basis and deposits are not recorded in the general ledger (GL) with a unique identifier to indicate which fiscal year the matching expenditures reside. Also, batched cash deposits containing sources of revenues from differing fiscal years cannot be appropriately allocated to the year in which the revenue was earned. Batched deposits are recorded as a single GL transaction regardless of the year the related deposit was earned and contain revenues where the related expenditures were recorded in differing fiscal years. As a result, the Department’s GL does not possess sufficient detail to accurately account for the required modified accrual basis conversions. The Department has not ensured that the transactional data recorded provides enough detail to accurately report the federal activity in Schedule Z and FFR’s. Recommendation: We recommend the Department review and document the current procedures and implement the necessary changes to ensure adequate reporting of program financial information in the SEFA and FFR’s. Specifically, we recommend the Department continues to review its cash reporting and deciphers batch deposits by fiscal year, with a unique identifier recorded at the GL transaction level. Additionally, we recommend retaining evidence that adequate reviews of the SEFA and FFR’s occurred. We also recommend the Department establish procedures to timely reconcile federal revenues to its federal expenditures to ensure completeness of its related federal reporting. Views of Responsible Official(s) Contact Person: Stefan Von Dollen Anticipated Completion Date: 6/30/24 Corrective Action Planned: The Oklahoma State Department of Health agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-211 STATE AGENCY: Oklahoma Department of Education FEDERAL AGENCY: United States Department of Health and Human Services ALN: 93.323 FEDERAL PROGRAM NAME: Epidemiology and Laboratory Capacity for Infectious Diseases, passed through the Oklahoma State Department of Health FEDERAL AWARD NUMBER: NU50CK000535 FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Other/Reporting QUESTIONED COSTS: Unknown Criteria: Per 2 CFR §200.303(a), the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. A key component of an effective internal control system is a strong control environment, including a culture of integrity and ethical values fostered by the organization’s leadership. Additionally, the Uniform Guidance (2 CFR 200) § 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statement [that]….at a minimum shall… provide total Federal awards expended for each individual Federal program and the Assistance Listing Number (AL#) or other identifying number when the AL# information is not available.” In accordance with Uniform Guidance, the Department is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Condition and Context: During our audit of the AL# 93.323, Epidemiology Laboratory Capacity (“ELC”), we observed that the Oklahoma State Department of Education (OSDE”) did not adequately establish and/or enforce internal control procedures. Specifically, we noted the following: Inconsistent application of accounting and governing body policies. Leadership of OSDE did not set an adequate tone at the top for appropriate fiscal responsibility of funds. The Department’s previous management did not maintain adequate procedural manuals and internal control narratives to ensure effective internal controls over their accounting records. Accounting records were not supported by appropriate subsidiary records to permit the preparation of accurate federal expenditure reporting on a timely basis. Procedures were not in place to ensure that underlying transactions recorded in the statewide PeopleSoft accounting system were reconciled by appropriate grant source and reported to the State in accordance with the State of Oklahoma’s Schedule Z Schedule of Expenditures of Federal Awards (“SEFA”) Conversion Package, with an approximate $1,550,000 variance between the underlying accounting records versus reported spend per Schedule Z. Cause and Effect: A lack of internal control procedures increases the risk of noncompliance with federal awards. Furthermore, the tone at the top set by leadership of OSDE has not prioritized compliance with laws and regulations and allowable uses of federal awards. Significant turnover of personnel at OSDE resulted in existing management’s inability to reconcile the underlying accounting records to prior management’s reported spend of AL# 93.323 reported per the SEFA Schedule Z. As a result, a variance of approximately $1,550,000 existed between the statewide PeopleSoft accounting system and the reported federal spending per Schedule Z for AL#93.323. Recommendation: We recommend management now in place in the Comptroller’s office of OSDE adequately documents internal control procedures and reconciles federal expenditures to the appropriate funding sources in the statewide accounting system. Views of Responsible Official(s) Contact Person: Shawn Richmond, Comptroller Anticipated Completion Date: 6/30/2024 Corrective Action Planned: The Oklahoma Department of Education agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-207 (Repeat Finding 2022-202) STATE AGENCY: Oklahoma Department of Health FEDERAL AGENCY: United States Department of Health and Human Services ALN: 93.323 FEDERAL PROGRAM NAME: Epidemiology and Laboratory Capacity for Infectious Diseases FEDERAL AWARD NUMBER: NU50CK000535-02-04, NU50CK000535-02-06, NU50CK000535-01-04, NU50CK000535-01-05 FEDERAL AWARD YEAR: 2020, 2021, 2022 CONTROL CATEGORY: Reporting QUESTIONED COSTS: Unknown Criteria: The Schedule of Expenditures of Federal Awards (SEFA – GAAP Package Schedule Z) should be accurately captured, reconciled, and reviewed by the Oklahoma State Department of Health (the “Department”). Adequate documentation of procedures performed, as well as evidence of thorough reviews, should be in place. According to GAAP, expenditures should be recognized in the period services are performed or goods are received. In accordance with the modified accrual basis of accounting, federal grant revenues should be recognized when applicable eligibility requirements, including reimbursement, time requirements, and other eligibility requirements, are met and the resources are available. Revenues are considered available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. In accordance with the State of Oklahoma’s Annual Comprehensive Financial Report, the State considers revenues to be available if they are collected within sixty days of the end of the fiscal year. Additionally, the Federal Financial Report (FFR), SF-425, is required on an annual basis except for awards where more frequent reporting is noted in the Notice of Award. The report also must cover any authorized extension during the reported budget period. Grant recipients submit FFRs to the U.S. Department of Health and Human Services (HHS) Payment Management System (PMS). Annual FFRs are due 90 days after the end of the budget period and final FFRs are due 90 days after the end of the period of performance. Lastly, The Uniform Guidance (2 CFR 200) § 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statement [that]….at a minimum shall…list individual Federal programs by Federal agency… [and] provide total Federal awards expended for each individual Federal program… [and] include the total amount provided to subrecipients for each Federal program” In accordance with Uniform Guidance, the Department is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Furthermore, the State of Oklahoma’s Schedule Z SEFA Conversion Package states, “The amount reported as provided by the primary recipient to state agencies should be entered in the ‘Amount Transferred to State Agencies’ column. This amount should be included in the Federal revenue but not in expense columns of the primary recipient.” Condition: The original SEFA submitted by the Department to the Office of Management and Enterprise Services (OMES) included the following errors: • AL# 93.323 reported federal revenues approximately $25,358,000 higher than its federal expenditures for a predominately reimbursement-based grant, resulting in the inability to determine the completeness of the expenditure details provided for audit testing. • Approximately $9,776,000 in state transfers to the Department of Education were omitted from subrecipient payments for AL# 93.323 in accordance with the State’s Schedule Z Conversion Package. • 39 out of 138, or 28%, of tested federal expenditure selections for AL# 93.323 were recorded in an incorrect accounting period, which totaled approximately $4,993,100. Additionally, the department was unable to provide supporting details of recorded transactions agreeing to the federal revenues reported in Schedule Z. Furthermore, all FFR’s tested for AL# 93.323 were not timely filed within 90 days subsequent to year end, as required by the Center for Disease Control and Prevention (CDC). Supporting schedules to FFRs for AL# 93.323 were not made available for audit testing. Cause and Effect: The Department does not have appropriate internal procedures for capturing and reporting the federal expenditures, revenues, and subrecipient payments on the SEFA in accordance with the Uniform Guidance (2 CFR 200) § 200.510. Revenues are recorded by the department on a cash basis and deposits are not recorded in the general ledger (GL) with a unique identifier to indicate which fiscal year the matching expenditures reside. Also, batched cash deposits containing sources of revenues from differing fiscal years cannot be appropriately allocated to the year in which the revenue was earned. Batched deposits are recorded as a single GL transaction regardless of the year the related deposit was earned and contain revenues where the related expenditures were recorded in differing fiscal years. As a result, the Department’s GL does not possess sufficient detail to accurately account for the required modified accrual basis conversions. The Department has not ensured that the transactional data recorded provides enough detail to accurately report the federal activity in Schedule Z and FFR’s. Recommendation: We recommend the Department review and document the current procedures and implement the necessary changes to ensure adequate reporting of program financial information in the SEFA and FFR’s. Specifically, we recommend the Department continues to review its cash reporting and deciphers batch deposits by fiscal year, with a unique identifier recorded at the GL transaction level. Additionally, we recommend retaining evidence that adequate reviews of the SEFA and FFR’s occurred. We also recommend the Department establish procedures to timely reconcile federal revenues to its federal expenditures to ensure completeness of its related federal reporting. Views of Responsible Official(s) Contact Person: Stefan Von Dollen Anticipated Completion Date: 6/30/24 Corrective Action Planned: The Oklahoma State Department of Health agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-211 STATE AGENCY: Oklahoma Department of Education FEDERAL AGENCY: United States Department of Health and Human Services ALN: 93.323 FEDERAL PROGRAM NAME: Epidemiology and Laboratory Capacity for Infectious Diseases, passed through the Oklahoma State Department of Health FEDERAL AWARD NUMBER: NU50CK000535 FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Other/Reporting QUESTIONED COSTS: Unknown Criteria: Per 2 CFR §200.303(a), the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. A key component of an effective internal control system is a strong control environment, including a culture of integrity and ethical values fostered by the organization’s leadership. Additionally, the Uniform Guidance (2 CFR 200) § 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statement [that]….at a minimum shall… provide total Federal awards expended for each individual Federal program and the Assistance Listing Number (AL#) or other identifying number when the AL# information is not available.” In accordance with Uniform Guidance, the Department is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Condition and Context: During our audit of the AL# 93.323, Epidemiology Laboratory Capacity (“ELC”), we observed that the Oklahoma State Department of Education (OSDE”) did not adequately establish and/or enforce internal control procedures. Specifically, we noted the following: Inconsistent application of accounting and governing body policies. Leadership of OSDE did not set an adequate tone at the top for appropriate fiscal responsibility of funds. The Department’s previous management did not maintain adequate procedural manuals and internal control narratives to ensure effective internal controls over their accounting records. Accounting records were not supported by appropriate subsidiary records to permit the preparation of accurate federal expenditure reporting on a timely basis. Procedures were not in place to ensure that underlying transactions recorded in the statewide PeopleSoft accounting system were reconciled by appropriate grant source and reported to the State in accordance with the State of Oklahoma’s Schedule Z Schedule of Expenditures of Federal Awards (“SEFA”) Conversion Package, with an approximate $1,550,000 variance between the underlying accounting records versus reported spend per Schedule Z. Cause and Effect: A lack of internal control procedures increases the risk of noncompliance with federal awards. Furthermore, the tone at the top set by leadership of OSDE has not prioritized compliance with laws and regulations and allowable uses of federal awards. Significant turnover of personnel at OSDE resulted in existing management’s inability to reconcile the underlying accounting records to prior management’s reported spend of AL# 93.323 reported per the SEFA Schedule Z. As a result, a variance of approximately $1,550,000 existed between the statewide PeopleSoft accounting system and the reported federal spending per Schedule Z for AL#93.323. Recommendation: We recommend management now in place in the Comptroller’s office of OSDE adequately documents internal control procedures and reconciles federal expenditures to the appropriate funding sources in the statewide accounting system. Views of Responsible Official(s) Contact Person: Shawn Richmond, Comptroller Anticipated Completion Date: 6/30/2024 Corrective Action Planned: The Oklahoma Department of Education agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-207 (Repeat Finding 2022-202) STATE AGENCY: Oklahoma Department of Health FEDERAL AGENCY: United States Department of Health and Human Services ALN: 93.323 FEDERAL PROGRAM NAME: Epidemiology and Laboratory Capacity for Infectious Diseases FEDERAL AWARD NUMBER: NU50CK000535-02-04, NU50CK000535-02-06, NU50CK000535-01-04, NU50CK000535-01-05 FEDERAL AWARD YEAR: 2020, 2021, 2022 CONTROL CATEGORY: Reporting QUESTIONED COSTS: Unknown Criteria: The Schedule of Expenditures of Federal Awards (SEFA – GAAP Package Schedule Z) should be accurately captured, reconciled, and reviewed by the Oklahoma State Department of Health (the “Department”). Adequate documentation of procedures performed, as well as evidence of thorough reviews, should be in place. According to GAAP, expenditures should be recognized in the period services are performed or goods are received. In accordance with the modified accrual basis of accounting, federal grant revenues should be recognized when applicable eligibility requirements, including reimbursement, time requirements, and other eligibility requirements, are met and the resources are available. Revenues are considered available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. In accordance with the State of Oklahoma’s Annual Comprehensive Financial Report, the State considers revenues to be available if they are collected within sixty days of the end of the fiscal year. Additionally, the Federal Financial Report (FFR), SF-425, is required on an annual basis except for awards where more frequent reporting is noted in the Notice of Award. The report also must cover any authorized extension during the reported budget period. Grant recipients submit FFRs to the U.S. Department of Health and Human Services (HHS) Payment Management System (PMS). Annual FFRs are due 90 days after the end of the budget period and final FFRs are due 90 days after the end of the period of performance. Lastly, The Uniform Guidance (2 CFR 200) § 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statement [that]….at a minimum shall…list individual Federal programs by Federal agency… [and] provide total Federal awards expended for each individual Federal program… [and] include the total amount provided to subrecipients for each Federal program” In accordance with Uniform Guidance, the Department is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Furthermore, the State of Oklahoma’s Schedule Z SEFA Conversion Package states, “The amount reported as provided by the primary recipient to state agencies should be entered in the ‘Amount Transferred to State Agencies’ column. This amount should be included in the Federal revenue but not in expense columns of the primary recipient.” Condition: The original SEFA submitted by the Department to the Office of Management and Enterprise Services (OMES) included the following errors: • AL# 93.323 reported federal revenues approximately $25,358,000 higher than its federal expenditures for a predominately reimbursement-based grant, resulting in the inability to determine the completeness of the expenditure details provided for audit testing. • Approximately $9,776,000 in state transfers to the Department of Education were omitted from subrecipient payments for AL# 93.323 in accordance with the State’s Schedule Z Conversion Package. • 39 out of 138, or 28%, of tested federal expenditure selections for AL# 93.323 were recorded in an incorrect accounting period, which totaled approximately $4,993,100. Additionally, the department was unable to provide supporting details of recorded transactions agreeing to the federal revenues reported in Schedule Z. Furthermore, all FFR’s tested for AL# 93.323 were not timely filed within 90 days subsequent to year end, as required by the Center for Disease Control and Prevention (CDC). Supporting schedules to FFRs for AL# 93.323 were not made available for audit testing. Cause and Effect: The Department does not have appropriate internal procedures for capturing and reporting the federal expenditures, revenues, and subrecipient payments on the SEFA in accordance with the Uniform Guidance (2 CFR 200) § 200.510. Revenues are recorded by the department on a cash basis and deposits are not recorded in the general ledger (GL) with a unique identifier to indicate which fiscal year the matching expenditures reside. Also, batched cash deposits containing sources of revenues from differing fiscal years cannot be appropriately allocated to the year in which the revenue was earned. Batched deposits are recorded as a single GL transaction regardless of the year the related deposit was earned and contain revenues where the related expenditures were recorded in differing fiscal years. As a result, the Department’s GL does not possess sufficient detail to accurately account for the required modified accrual basis conversions. The Department has not ensured that the transactional data recorded provides enough detail to accurately report the federal activity in Schedule Z and FFR’s. Recommendation: We recommend the Department review and document the current procedures and implement the necessary changes to ensure adequate reporting of program financial information in the SEFA and FFR’s. Specifically, we recommend the Department continues to review its cash reporting and deciphers batch deposits by fiscal year, with a unique identifier recorded at the GL transaction level. Additionally, we recommend retaining evidence that adequate reviews of the SEFA and FFR’s occurred. We also recommend the Department establish procedures to timely reconcile federal revenues to its federal expenditures to ensure completeness of its related federal reporting. Views of Responsible Official(s) Contact Person: Stefan Von Dollen Anticipated Completion Date: 6/30/24 Corrective Action Planned: The Oklahoma State Department of Health agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-211 STATE AGENCY: Oklahoma Department of Education FEDERAL AGENCY: United States Department of Health and Human Services ALN: 93.323 FEDERAL PROGRAM NAME: Epidemiology and Laboratory Capacity for Infectious Diseases, passed through the Oklahoma State Department of Health FEDERAL AWARD NUMBER: NU50CK000535 FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Other/Reporting QUESTIONED COSTS: Unknown Criteria: Per 2 CFR §200.303(a), the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. A key component of an effective internal control system is a strong control environment, including a culture of integrity and ethical values fostered by the organization’s leadership. Additionally, the Uniform Guidance (2 CFR 200) § 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statement [that]….at a minimum shall… provide total Federal awards expended for each individual Federal program and the Assistance Listing Number (AL#) or other identifying number when the AL# information is not available.” In accordance with Uniform Guidance, the Department is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Condition and Context: During our audit of the AL# 93.323, Epidemiology Laboratory Capacity (“ELC”), we observed that the Oklahoma State Department of Education (OSDE”) did not adequately establish and/or enforce internal control procedures. Specifically, we noted the following: Inconsistent application of accounting and governing body policies. Leadership of OSDE did not set an adequate tone at the top for appropriate fiscal responsibility of funds. The Department’s previous management did not maintain adequate procedural manuals and internal control narratives to ensure effective internal controls over their accounting records. Accounting records were not supported by appropriate subsidiary records to permit the preparation of accurate federal expenditure reporting on a timely basis. Procedures were not in place to ensure that underlying transactions recorded in the statewide PeopleSoft accounting system were reconciled by appropriate grant source and reported to the State in accordance with the State of Oklahoma’s Schedule Z Schedule of Expenditures of Federal Awards (“SEFA”) Conversion Package, with an approximate $1,550,000 variance between the underlying accounting records versus reported spend per Schedule Z. Cause and Effect: A lack of internal control procedures increases the risk of noncompliance with federal awards. Furthermore, the tone at the top set by leadership of OSDE has not prioritized compliance with laws and regulations and allowable uses of federal awards. Significant turnover of personnel at OSDE resulted in existing management’s inability to reconcile the underlying accounting records to prior management’s reported spend of AL# 93.323 reported per the SEFA Schedule Z. As a result, a variance of approximately $1,550,000 existed between the statewide PeopleSoft accounting system and the reported federal spending per Schedule Z for AL#93.323. Recommendation: We recommend management now in place in the Comptroller’s office of OSDE adequately documents internal control procedures and reconciles federal expenditures to the appropriate funding sources in the statewide accounting system. Views of Responsible Official(s) Contact Person: Shawn Richmond, Comptroller Anticipated Completion Date: 6/30/2024 Corrective Action Planned: The Oklahoma Department of Education agrees with the finding. Please see the corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-009 STATE AGENCY: Oklahoma Health Care Authority (OHCA) FEDERAL AGENCY: United States Department of Health and Human Services CFDA NO: 93.767 FEDERAL PROGRAM NAME: Children’s Health Insurance Program FEDERAL AWARD NUMBER: 2205OK5021 and 2305OK5021 FEDERAL AWARD YEAR: 2022 and 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: 2 CFR §200.510(b) states, “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended…” A basic objective of Generally Accepted Accounting Principles is to provide accurate and reliable information. A component objective of an effective internal control system is to ensure accurate and reliable information through a proper review and approval process. Condition and Context: Based upon testwork performed on GAAP Package Z – Schedule of Expenditures of Federal Awards, we noted the following: • The CHIP Total Federal Expenditures were reported at $90,338,494 but should have been $254,259,621. • The CHIP (Covid) Total Federal Expenditures were reported at $12,526,052 but should have been $12,516,975. • The CHIP transfers to other state agencies were reported at $300,933 but should have been $20,397. Cause: We noted the following: • The CHIP Total Federal Expenditures were incorrectly transferred from the “CAFR Package Z Federal Expenditures” worksheet to the GAAP Package Z. The variance occurred because the MAP administrative expenditure amount was carried forward from the supporting worksheet instead of the CHIP total expenditures. Additionally, we noted three errors in the CHIP supporting documentation. • The CHIP (Covid) Total Federal Expenditures were recorded incorrectly due to an incorrect supporting figure on the CMS 21 Reconciliation worksheet. • The CHIP transfers to other state agencies were not calculated correctly on the “Schedule of Expenditures of Federal Awards – Transferred” worksheet. The variance occurred because the “2022 CMS 21 HSI Breakout worksheet” was erroneously carried forward form the prior year instead of using the 2023 worksheet. Effect: The errors on the GAAP Package Z resulted in the following: • CHIP Total Federal Expenditures were understated by $163,921,127. • CHIP (Covid) Total Federal Expenditures were overstated by $9,078. • CHIP transfers to other state agencies were overstated by $280,536. Recommendation: We recommend OHCA continue to work to strengthen their review and reconciliation controls related to the accuracy of data reported for GAAP Pkg. Z – Schedule of Expenditures of Federal Awards. Views of Responsible Official(s) Contact Person: Calvin Cole, Financial Manager III Anticipated Completion Date: 10/31/2024 Corrective Action Planned: The Oklahoma Health Care Authority agrees with the finding. See corrective action plan located in the corrective action plan section of this report.