State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S. Department of Agriculture (USDA), U.S. Department of Education (USDE), U.S. Department of Health and Human Services (USDHHS), U.S. Social Security Administration (USSSA) Program Name: Supplemental Nutrition Assistance Program Cluster, Special Supplemental Nutrition Program for Women, Infants, and Children, Rehabilitation Services – Vocational Rehabilitation, Temporary Assistance for Needy Families, Child Care and Development Fund (CCDF) Cluster, Social Services Block Grant, Block Grants for Prevention and Treatment of Substance Abuse, Disability Insurance/SSI Cluster ALN and Program Expenditures: 10.551/10.561 ($5,991,938,129), 10.557 ($168,740,425), 84.126 ($127,053,406), 93.558 ($578,867,422), 93.575/93.596 ($783,907,069), 93.667 ($57,147,970), 93.959 ($101,011,200), 96.001/96.006 ($72,937,910) 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-012: Inaccurate Reporting of Federal Expenditures Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Supplemental Nutrition for Women, Infants, and Children (WIC) programs, Vocational Rehabilitation (VR), Temporary Assistance for Needy Families (TANF), Child Care and Development Funds (CCC) Cluster, Social Services Block Grants (SSBG), Block Grants for Prevention and Treatment of Substance Abuse (SAPT), and Disability Insurance/SSI (SSDI) Cluster programs. Federal expenditures, including amounts provided to subrecipients, 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 IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2023: "See Table in the Audit Report". Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: "See Table in the Audit Report". We also noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. Further, we noted amounts passed through to other State agencies from IDHS provided by IDHS for our audit procedures included accrued (not paid) expendituresr. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures in the following amounts which were not paid in fiscal year ended June 30, 2023 and were erroneously reported as cash basis expenditures for the year ended June 30, 2023: "See Table in the Audit Report". Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. 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 control 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 and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to differences in reporting methods fort he SEFA and IDHS’ records. The expenditures in the IDHS’ records come from the agency financial accounting system, SAP. The expenditures in the SEFA come from the annual GAAP reports must reconcile to the Illinois Office of the Comptroller accounting system (SAMS). 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 reported in the prior year audit as finding number 2022-010. (Finding Code 2023-012, 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: The Department accepts the recommendation. The Department has created a spreadsheet with all federal expenditure data grouped by ALN, and a tab with only the major program expenditure data comparing it to the IDHS Records/Bucket amount. Any discrepancies between the reporting methodologies are identified and researched.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S. Department of Agriculture (USDA), U.S. Department of Education (USDE), U.S. Department of Health and Human Services (USDHHS), U.S. Social Security Administration (USSSA) Program Name: Supplemental Nutrition Assistance Program Cluster, Special Supplemental Nutrition Program for Women, Infants, and Children, Rehabilitation Services – Vocational Rehabilitation, Temporary Assistance for Needy Families, Child Care and Development Fund (CCDF) Cluster, Social Services Block Grant, Block Grants for Prevention and Treatment of Substance Abuse, Disability Insurance/SSI Cluster ALN and Program Expenditures: 10.551/10.561 ($5,991,938,129), 10.557 ($168,740,425), 84.126 ($127,053,406), 93.558 ($578,867,422), 93.575/93.596 ($783,907,069), 93.667 ($57,147,970), 93.959 ($101,011,200), 96.001/96.006 ($72,937,910) 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-012: Inaccurate Reporting of Federal Expenditures Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Supplemental Nutrition for Women, Infants, and Children (WIC) programs, Vocational Rehabilitation (VR), Temporary Assistance for Needy Families (TANF), Child Care and Development Funds (CCC) Cluster, Social Services Block Grants (SSBG), Block Grants for Prevention and Treatment of Substance Abuse (SAPT), and Disability Insurance/SSI (SSDI) Cluster programs. Federal expenditures, including amounts provided to subrecipients, 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 IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2023: "See Table in the Audit Report". Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: "See Table in the Audit Report". We also noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. Further, we noted amounts passed through to other State agencies from IDHS provided by IDHS for our audit procedures included accrued (not paid) expendituresr. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures in the following amounts which were not paid in fiscal year ended June 30, 2023 and were erroneously reported as cash basis expenditures for the year ended June 30, 2023: "See Table in the Audit Report". Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. 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 control 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 and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to differences in reporting methods fort he SEFA and IDHS’ records. The expenditures in the IDHS’ records come from the agency financial accounting system, SAP. The expenditures in the SEFA come from the annual GAAP reports must reconcile to the Illinois Office of the Comptroller accounting system (SAMS). 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 reported in the prior year audit as finding number 2022-010. (Finding Code 2023-012, 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: The Department accepts the recommendation. The Department has created a spreadsheet with all federal expenditure data grouped by ALN, and a tab with only the major program expenditure data comparing it to the IDHS Records/Bucket amount. Any discrepancies between the reporting methodologies are identified and researched.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S. Department of Agriculture (USDA), U.S. Department of Education (USDE), U.S. Department of Health and Human Services (USDHHS), U.S. Social Security Administration (USSSA) Program Name: Supplemental Nutrition Assistance Program Cluster, Special Supplemental Nutrition Program for Women, Infants, and Children, Rehabilitation Services – Vocational Rehabilitation, Temporary Assistance for Needy Families, Child Care and Development Fund (CCDF) Cluster, Social Services Block Grant, Block Grants for Prevention and Treatment of Substance Abuse, Disability Insurance/SSI Cluster ALN and Program Expenditures: 10.551/10.561 ($5,991,938,129), 10.557 ($168,740,425), 84.126 ($127,053,406), 93.558 ($578,867,422), 93.575/93.596 ($783,907,069), 93.667 ($57,147,970), 93.959 ($101,011,200), 96.001/96.006 ($72,937,910) 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-012: Inaccurate Reporting of Federal Expenditures Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Supplemental Nutrition for Women, Infants, and Children (WIC) programs, Vocational Rehabilitation (VR), Temporary Assistance for Needy Families (TANF), Child Care and Development Funds (CCC) Cluster, Social Services Block Grants (SSBG), Block Grants for Prevention and Treatment of Substance Abuse (SAPT), and Disability Insurance/SSI (SSDI) Cluster programs. Federal expenditures, including amounts provided to subrecipients, 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 IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2023: "See Table in the Audit Report". Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: "See Table in the Audit Report". We also noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. Further, we noted amounts passed through to other State agencies from IDHS provided by IDHS for our audit procedures included accrued (not paid) expendituresr. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures in the following amounts which were not paid in fiscal year ended June 30, 2023 and were erroneously reported as cash basis expenditures for the year ended June 30, 2023: "See Table in the Audit Report". Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. 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 control 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 and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to differences in reporting methods fort he SEFA and IDHS’ records. The expenditures in the IDHS’ records come from the agency financial accounting system, SAP. The expenditures in the SEFA come from the annual GAAP reports must reconcile to the Illinois Office of the Comptroller accounting system (SAMS). 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 reported in the prior year audit as finding number 2022-010. (Finding Code 2023-012, 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: The Department accepts the recommendation. The Department has created a spreadsheet with all federal expenditure data grouped by ALN, and a tab with only the major program expenditure data comparing it to the IDHS Records/Bucket amount. Any discrepancies between the reporting methodologies are identified and researched.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S. Department of Agriculture (USDA), U.S. Department of Education (USDE), U.S. Department of Health and Human Services (USDHHS), U.S. Social Security Administration (USSSA) Program Name: Supplemental Nutrition Assistance Program Cluster, Special Supplemental Nutrition Program for Women, Infants, and Children, Rehabilitation Services – Vocational Rehabilitation, Temporary Assistance for Needy Families, Child Care and Development Fund (CCDF) Cluster, Social Services Block Grant, Block Grants for Prevention and Treatment of Substance Abuse, Disability Insurance/SSI Cluster ALN and Program Expenditures: 10.551/10.561 ($5,991,938,129), 10.557 ($168,740,425), 84.126 ($127,053,406), 93.558 ($578,867,422), 93.575/93.596 ($783,907,069), 93.667 ($57,147,970), 93.959 ($101,011,200), 96.001/96.006 ($72,937,910) 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-012: Inaccurate Reporting of Federal Expenditures Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Supplemental Nutrition for Women, Infants, and Children (WIC) programs, Vocational Rehabilitation (VR), Temporary Assistance for Needy Families (TANF), Child Care and Development Funds (CCC) Cluster, Social Services Block Grants (SSBG), Block Grants for Prevention and Treatment of Substance Abuse (SAPT), and Disability Insurance/SSI (SSDI) Cluster programs. Federal expenditures, including amounts provided to subrecipients, 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 IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2023: "See Table in the Audit Report". Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: "See Table in the Audit Report". We also noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. Further, we noted amounts passed through to other State agencies from IDHS provided by IDHS for our audit procedures included accrued (not paid) expendituresr. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures in the following amounts which were not paid in fiscal year ended June 30, 2023 and were erroneously reported as cash basis expenditures for the year ended June 30, 2023: "See Table in the Audit Report". Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. 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 control 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 and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to differences in reporting methods fort he SEFA and IDHS’ records. The expenditures in the IDHS’ records come from the agency financial accounting system, SAP. The expenditures in the SEFA come from the annual GAAP reports must reconcile to the Illinois Office of the Comptroller accounting system (SAMS). 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 reported in the prior year audit as finding number 2022-010. (Finding Code 2023-012, 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: The Department accepts the recommendation. The Department has created a spreadsheet with all federal expenditure data grouped by ALN, and a tab with only the major program expenditure data comparing it to the IDHS Records/Bucket amount. Any discrepancies between the reporting methodologies are identified and researched.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S. Department of Agriculture (USDA), U.S. Department of Education (USDE), U.S. Department of Health and Human Services (USDHHS), U.S. Social Security Administration (USSSA) Program Name: Supplemental Nutrition Assistance Program Cluster, Special Supplemental Nutrition Program for Women, Infants, and Children, Rehabilitation Services – Vocational Rehabilitation, Temporary Assistance for Needy Families, Child Care and Development Fund (CCDF) Cluster, Social Services Block Grant, Block Grants for Prevention and Treatment of Substance Abuse, Disability Insurance/SSI Cluster ALN and Program Expenditures: 10.551/10.561 ($5,991,938,129), 10.557 ($168,740,425), 84.126 ($127,053,406), 93.558 ($578,867,422), 93.575/93.596 ($783,907,069), 93.667 ($57,147,970), 93.959 ($101,011,200), 96.001/96.006 ($72,937,910) 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-012: Inaccurate Reporting of Federal Expenditures Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Supplemental Nutrition for Women, Infants, and Children (WIC) programs, Vocational Rehabilitation (VR), Temporary Assistance for Needy Families (TANF), Child Care and Development Funds (CCC) Cluster, Social Services Block Grants (SSBG), Block Grants for Prevention and Treatment of Substance Abuse (SAPT), and Disability Insurance/SSI (SSDI) Cluster programs. Federal expenditures, including amounts provided to subrecipients, 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 IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2023: "See Table in the Audit Report". Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: "See Table in the Audit Report". We also noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. Further, we noted amounts passed through to other State agencies from IDHS provided by IDHS for our audit procedures included accrued (not paid) expendituresr. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures in the following amounts which were not paid in fiscal year ended June 30, 2023 and were erroneously reported as cash basis expenditures for the year ended June 30, 2023: "See Table in the Audit Report". Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. 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 control 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 and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to differences in reporting methods fort he SEFA and IDHS’ records. The expenditures in the IDHS’ records come from the agency financial accounting system, SAP. The expenditures in the SEFA come from the annual GAAP reports must reconcile to the Illinois Office of the Comptroller accounting system (SAMS). 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 reported in the prior year audit as finding number 2022-010. (Finding Code 2023-012, 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: The Department accepts the recommendation. The Department has created a spreadsheet with all federal expenditure data grouped by ALN, and a tab with only the major program expenditure data comparing it to the IDHS Records/Bucket amount. Any discrepancies between the reporting methodologies are identified and researched.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S. Department of Agriculture (USDA), U.S. Department of Education (USDE), U.S. Department of Health and Human Services (USDHHS), U.S. Social Security Administration (USSSA) Program Name: Supplemental Nutrition Assistance Program Cluster, Special Supplemental Nutrition Program for Women, Infants, and Children, Rehabilitation Services – Vocational Rehabilitation, Temporary Assistance for Needy Families, Child Care and Development Fund (CCDF) Cluster, Social Services Block Grant, Block Grants for Prevention and Treatment of Substance Abuse, Disability Insurance/SSI Cluster ALN and Program Expenditures: 10.551/10.561 ($5,991,938,129), 10.557 ($168,740,425), 84.126 ($127,053,406), 93.558 ($578,867,422), 93.575/93.596 ($783,907,069), 93.667 ($57,147,970), 93.959 ($101,011,200), 96.001/96.006 ($72,937,910) 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-012: Inaccurate Reporting of Federal Expenditures Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Supplemental Nutrition for Women, Infants, and Children (WIC) programs, Vocational Rehabilitation (VR), Temporary Assistance for Needy Families (TANF), Child Care and Development Funds (CCC) Cluster, Social Services Block Grants (SSBG), Block Grants for Prevention and Treatment of Substance Abuse (SAPT), and Disability Insurance/SSI (SSDI) Cluster programs. Federal expenditures, including amounts provided to subrecipients, 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 IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2023: "See Table in the Audit Report". Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: "See Table in the Audit Report". We also noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. Further, we noted amounts passed through to other State agencies from IDHS provided by IDHS for our audit procedures included accrued (not paid) expendituresr. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures in the following amounts which were not paid in fiscal year ended June 30, 2023 and were erroneously reported as cash basis expenditures for the year ended June 30, 2023: "See Table in the Audit Report". Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. 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 control 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 and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to differences in reporting methods fort he SEFA and IDHS’ records. The expenditures in the IDHS’ records come from the agency financial accounting system, SAP. The expenditures in the SEFA come from the annual GAAP reports must reconcile to the Illinois Office of the Comptroller accounting system (SAMS). 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 reported in the prior year audit as finding number 2022-010. (Finding Code 2023-012, 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: The Department accepts the recommendation. The Department has created a spreadsheet with all federal expenditure data grouped by ALN, and a tab with only the major program expenditure data comparing it to the IDHS Records/Bucket amount. Any discrepancies between the reporting methodologies are identified and researched.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S. Department of Agriculture (USDA), U.S. Department of Education (USDE), U.S. Department of Health and Human Services (USDHHS), U.S. Social Security Administration (USSSA) Program Name: Supplemental Nutrition Assistance Program Cluster, Special Supplemental Nutrition Program for Women, Infants, and Children, Rehabilitation Services – Vocational Rehabilitation, Temporary Assistance for Needy Families, Child Care and Development Fund (CCDF) Cluster, Social Services Block Grant, Block Grants for Prevention and Treatment of Substance Abuse, Disability Insurance/SSI Cluster ALN and Program Expenditures: 10.551/10.561 ($5,991,938,129), 10.557 ($168,740,425), 84.126 ($127,053,406), 93.558 ($578,867,422), 93.575/93.596 ($783,907,069), 93.667 ($57,147,970), 93.959 ($101,011,200), 96.001/96.006 ($72,937,910) 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-012: Inaccurate Reporting of Federal Expenditures Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Supplemental Nutrition for Women, Infants, and Children (WIC) programs, Vocational Rehabilitation (VR), Temporary Assistance for Needy Families (TANF), Child Care and Development Funds (CCC) Cluster, Social Services Block Grants (SSBG), Block Grants for Prevention and Treatment of Substance Abuse (SAPT), and Disability Insurance/SSI (SSDI) Cluster programs. Federal expenditures, including amounts provided to subrecipients, 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 IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2023: "See Table in the Audit Report". Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: "See Table in the Audit Report". We also noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. Further, we noted amounts passed through to other State agencies from IDHS provided by IDHS for our audit procedures included accrued (not paid) expendituresr. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures in the following amounts which were not paid in fiscal year ended June 30, 2023 and were erroneously reported as cash basis expenditures for the year ended June 30, 2023: "See Table in the Audit Report". Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. 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 control 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 and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to differences in reporting methods fort he SEFA and IDHS’ records. The expenditures in the IDHS’ records come from the agency financial accounting system, SAP. The expenditures in the SEFA come from the annual GAAP reports must reconcile to the Illinois Office of the Comptroller accounting system (SAMS). 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 reported in the prior year audit as finding number 2022-010. (Finding Code 2023-012, 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: The Department accepts the recommendation. The Department has created a spreadsheet with all federal expenditure data grouped by ALN, and a tab with only the major program expenditure data comparing it to the IDHS Records/Bucket amount. Any discrepancies between the reporting methodologies are identified and researched.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S. Department of Agriculture (USDA), U.S. Department of Education (USDE), U.S. Department of Health and Human Services (USDHHS), U.S. Social Security Administration (USSSA) Program Name: Supplemental Nutrition Assistance Program Cluster, Special Supplemental Nutrition Program for Women, Infants, and Children, Rehabilitation Services – Vocational Rehabilitation, Temporary Assistance for Needy Families, Child Care and Development Fund (CCDF) Cluster, Social Services Block Grant, Block Grants for Prevention and Treatment of Substance Abuse, Disability Insurance/SSI Cluster ALN and Program Expenditures: 10.551/10.561 ($5,991,938,129), 10.557 ($168,740,425), 84.126 ($127,053,406), 93.558 ($578,867,422), 93.575/93.596 ($783,907,069), 93.667 ($57,147,970), 93.959 ($101,011,200), 96.001/96.006 ($72,937,910) 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-012: Inaccurate Reporting of Federal Expenditures Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Supplemental Nutrition for Women, Infants, and Children (WIC) programs, Vocational Rehabilitation (VR), Temporary Assistance for Needy Families (TANF), Child Care and Development Funds (CCC) Cluster, Social Services Block Grants (SSBG), Block Grants for Prevention and Treatment of Substance Abuse (SAPT), and Disability Insurance/SSI (SSDI) Cluster programs. Federal expenditures, including amounts provided to subrecipients, 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 IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2023: "See Table in the Audit Report". Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: "See Table in the Audit Report". We also noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. Further, we noted amounts passed through to other State agencies from IDHS provided by IDHS for our audit procedures included accrued (not paid) expendituresr. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures in the following amounts which were not paid in fiscal year ended June 30, 2023 and were erroneously reported as cash basis expenditures for the year ended June 30, 2023: "See Table in the Audit Report". Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. 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 control 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 and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to differences in reporting methods fort he SEFA and IDHS’ records. The expenditures in the IDHS’ records come from the agency financial accounting system, SAP. The expenditures in the SEFA come from the annual GAAP reports must reconcile to the Illinois Office of the Comptroller accounting system (SAMS). 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 reported in the prior year audit as finding number 2022-010. (Finding Code 2023-012, 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: The Department accepts the recommendation. The Department has created a spreadsheet with all federal expenditure data grouped by ALN, and a tab with only the major program expenditure data comparing it to the IDHS Records/Bucket amount. Any discrepancies between the reporting methodologies are identified and researched.
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.
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.
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.
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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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.
2023 006 Other – Inaccurate Reporting of the Schedule of Expenditures of Federal Awards U.S. Department of Homeland Security Pass Through – SNJ Office of Emergency Management Disaster Grants - Public Assistance (Presidentially Declared Disasters) (ALN 97.036) Federal Grant Numbers: Grant #4488 Proj F#2105 and Grant #4614 Proj F#690 Statistically valid sample: Not applicable. Repeat finding: Not a repeat finding. Finding Type: Material weakness Criteria: 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. Additionally, 2 CFR section 200.303 requires that 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 and information provided for audit purposes is complete and accurate. Condition and Context: The University did not have adequate internal controls related to the identification and reporting of federal expenditures that are managed outside of their normal grant process. Specifically, the University lacked controls to ensure proper communication between the Office of Emergency Management, University Controller’s Office and the Office for Research related to obligations of the Federal Emergency Management Agency Disaster Grants - Public Assistance (Presidentially Declared Disasters) (ALN 97.036) program (FEMA). As a result, $7,077,293 of FEMA expenditures were omitted from the June 30, 2023 SEFA. Cause: Applications for reimbursement from FEMA were handled outside of the normal grant process at the University, which is overseen by the Office for Research. Management did not perform appropriate risk assessment procedures associated with allowing federal awards to be executed outside of their normal grant process. Effect: Lack of an adequate risk assessment procedure for federal awards executed outside the normal grant process resulted in internal controls not being effective or adequately established upon the initiation of the award and reporting of expenditures. Questioned Costs: Not applicable. Recommendation: We recommend the University implement a system of internal control that is designed and operating upon initiation of new and/or amended awards through reporting on the SEFA to ensure the SEFA is complete and accurate. Views of Responsible Official: Management agrees with the finding. Management acknowledges that the University did not have an adequate risk assessment framework in place for federal awards executed outside of the standard grant administration process. In addition, communication and coordination among the Office of Emergency Management (within Institutional Planning & Operations), the Office for Research, and the University Controller’s Office were not sufficiently formalized at the time of initiation for new and/or amended awards executed outside of the standard grant administration process. To address these deficiencies, leadership across these offices has developed and implemented a formal Standard Operating Procedure (SOP) to establish a consistent institutional framework for the administration and oversight of federally funded capital projects, emergency recovery programs, and other non-traditional sponsored funding mechanisms. The SOP defines roles and responsibilities, establishes risk assessment and communication protocols, and implemented internal control requirements to ensure appropriate coordination at award initiation and throughout the lifecycle of the award, including financial reporting.
Criteria or Specific Requirement: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Condition: The City has not historically created or provided a Schedule of Federal Awards for audit purposes and did not include all federal expenditures as required under 2 CFR Part 200.502. Context: The City did not have all federal expenditures recorded in their trial balance, and did not have accurate records of all expenditures spent during the audit period. In addition, they did not have all of the necessary information or training to create the Schedule of Federal Awards. Questioned Costs: None Effect: The City was unable to provide auditors with a complete Schedule of Federal Awards, and could not verify the completeness of expenditures recorded in their financial statements as provided for the audit. Cause: The City does not have processes in place to track all grant spending. Repeat: No Auditor's Recommendation: We recommend that the City create processes and procedures that capture all federal funding received, and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made, and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the City will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. View of Responsible Officials: Management concurs with the Auditor’s recommendation and will review with the third-party North Central Illinois Council of Governments (NCICG) to establish appropriate City monitoring and review. City will also review with prior City Auditors to ensure proper overall procedures are in place to ensure all grants in the aggregate are monitored.
Criteria or Specific Requirement: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Condition: The City has not historically created or provided a Schedule of Federal Awards for audit purposes and did not include all federal expenditures as required under 2 CFR Part 200.502. Context: The City did not have all federal expenditures recorded in their trial balance, and did not have accurate records of all expenditures spent during the audit period. In addition, they did not have all of the necessary information or training to create the Schedule of Federal Awards. Questioned Costs: None Effect: The City was unable to provide auditors with a complete Schedule of Federal Awards, and could not verify the completeness of expenditures recorded in their financial statements as provided for the audit. Cause: The City does not have processes in place to track all grant spending. Repeat: No Auditor's Recommendation: We recommend that the City create processes and procedures that capture all federal funding received, and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made, and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the City will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. View of Responsible Officials: Management concurs with the Auditor’s recommendation and will review with the third-party North Central Illinois Council of Governments (NCICG) to establish appropriate City monitoring and review. City will also review with prior City Auditors to ensure proper overall procedures are in place to ensure all grants in the aggregate are monitored.
Criteria or Specific Requirement: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Condition: The City has not historically created or provided a Schedule of Federal Awards for audit purposes and did not include all federal expenditures as required under 2 CFR Part 200.502. Context: The City did not have all federal expenditures recorded in their trial balance, and did not have accurate records of all expenditures spent during the audit period. In addition, they did not have all of the necessary information or training to create the Schedule of Federal Awards. Questioned Costs: None Effect: The City was unable to provide auditors with a complete Schedule of Federal Awards, and could not verify the completeness of expenditures recorded in their financial statements as provided for the audit. Cause: The City does not have processes in place to track all grant spending. Repeat: No Auditor's Recommendation: We recommend that the City create processes and procedures that capture all federal funding received, and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made, and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the City will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. View of Responsible Officials: Management concurs with the Auditor’s recommendation and will review with the third-party North Central Illinois Council of Governments (NCICG) to establish appropriate City monitoring and review. City will also review with prior City Auditors to ensure proper overall procedures are in place to ensure all grants in the aggregate are monitored.
Criteria or Specific Requirement: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Condition: The City has not historically created or provided a Schedule of Federal Awards for audit purposes and did not include all federal expenditures as required under 2 CFR Part 200.502. Context: The City did not have all federal expenditures recorded in their trial balance, and did not have accurate records of all expenditures spent during the audit period. In addition, they did not have all of the necessary information or training to create the Schedule of Federal Awards. Questioned Costs: None Effect: The City was unable to provide auditors with a complete Schedule of Federal Awards, and could not verify the completeness of expenditures recorded in their financial statements as provided for the audit. Cause: The City does not have processes in place to track all grant spending. Repeat: No Auditor's Recommendation: We recommend that the City create processes and procedures that capture all federal funding received, and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made, and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the City will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. View of Responsible Officials: Management concurs with the Auditor’s recommendation and will review with the third-party North Central Illinois Council of Governments (NCICG) to establish appropriate City monitoring and review. City will also review with prior City Auditors to ensure proper overall procedures are in place to ensure all grants in the aggregate are monitored.
Criteria or Specific Requirement: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Condition: The City has not historically created or provided a Schedule of Federal Awards for audit purposes and did not include all federal expenditures as required under 2 CFR Part 200.502. Context: The City did not have all federal expenditures recorded in their trial balance, and did not have accurate records of all expenditures spent during the audit period. In addition, they did not have all of the necessary information or training to create the Schedule of Federal Awards. Questioned Costs: None Effect: The City was unable to provide auditors with a complete Schedule of Federal Awards, and could not verify the completeness of expenditures recorded in their financial statements as provided for the audit. Cause: The City does not have processes in place to track all grant spending. Repeat: No Auditor's Recommendation: We recommend that the City create processes and procedures that capture all federal funding received, and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made, and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the City will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. View of Responsible Officials: Management concurs with the Auditor’s recommendation and will review with the third-party North Central Illinois Council of Governments (NCICG) to establish appropriate City monitoring and review. City will also review with prior City Auditors to ensure proper overall procedures are in place to ensure all grants in the aggregate are monitored.
Criteria or Specific Requirement: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Condition: The City has not historically created or provided a Schedule of Federal Awards for audit purposes and did not include all federal expenditures as required under 2 CFR Part 200.502. Context: The City did not have all federal expenditures recorded in their trial balance, and did not have accurate records of all expenditures spent during the audit period. In addition, they did not have all of the necessary information or training to create the Schedule of Federal Awards. Questioned Costs: None Effect: The City was unable to provide auditors with a complete Schedule of Federal Awards, and could not verify the completeness of expenditures recorded in their financial statements as provided for the audit. Cause: The City does not have processes in place to track all grant spending. Repeat: No Auditor's Recommendation: We recommend that the City create processes and procedures that capture all federal funding received, and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made, and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the City will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. View of Responsible Officials: Management concurs with the Auditor’s recommendation and will review with the third-party North Central Illinois Council of Governments (NCICG) to establish appropriate City monitoring and review. City will also review with prior City Auditors to ensure proper overall procedures are in place to ensure all grants in the aggregate are monitored.
Criteria or Specific Requirement: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Condition: The City has not historically created or provided a Schedule of Federal Awards for audit purposes and did not include all federal expenditures as required under 2 CFR Part 200.502. Context: The City did not have all federal expenditures recorded in their trial balance, and did not have accurate records of all expenditures spent during the audit period. In addition, they did not have all of the necessary information or training to create the Schedule of Federal Awards. Questioned Costs: None Effect: The City was unable to provide auditors with a complete Schedule of Federal Awards, and could not verify the completeness of expenditures recorded in their financial statements as provided for the audit. Cause: The City does not have processes in place to track all grant spending. Repeat: No Auditor's Recommendation: We recommend that the City create processes and procedures that capture all federal funding received, and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made, and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the City will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. View of Responsible Officials: Management concurs with the Auditor’s recommendation and will review with the third-party North Central Illinois Council of Governments (NCICG) to establish appropriate City monitoring and review. City will also review with prior City Auditors to ensure proper overall procedures are in place to ensure all grants in the aggregate are monitored.
Criteria or Specific Requirement: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Condition: The City has not historically created or provided a Schedule of Federal Awards for audit purposes and did not include all federal expenditures as required under 2 CFR Part 200.502. Context: The City did not have all federal expenditures recorded in their trial balance, and did not have accurate records of all expenditures spent during the audit period. In addition, they did not have all of the necessary information or training to create the Schedule of Federal Awards. Questioned Costs: None Effect: The City was unable to provide auditors with a complete Schedule of Federal Awards, and could not verify the completeness of expenditures recorded in their financial statements as provided for the audit. Cause: The City does not have processes in place to track all grant spending. Repeat: No Auditor's Recommendation: We recommend that the City create processes and procedures that capture all federal funding received, and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made, and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the City will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. View of Responsible Officials: Management concurs with the Auditor’s recommendation and will review with the third-party North Central Illinois Council of Governments (NCICG) to establish appropriate City monitoring and review. City will also review with prior City Auditors to ensure proper overall procedures are in place to ensure all grants in the aggregate are monitored.
Federal Agency: US Department of Housing and Urban Development Federal Program Title: Community Development Block Grants/Entitlement Grants ALN Number: 14.228 Award Periods: April 1, 2022 March 31, 2023 Type of Finding: Significant Deficiency in Internal Control over Compliance also reported as Other Noncompliance Criteria or specific requirement: 2 CFR Subpart D 200.302 (1) and 200.303 (a) stipulates that the auditee must identify, in its accounts, all Federal awards received and expended and the Federal programs under which they were received. Federal programs and award identification shall include, as applicable, the ALN title and number, Federal award identification number and year, name of Federal agency, and name of the pass-through entity; establish and maintain effective internal control over Federal award that provides reasonable assurance that the auditee is managing Federal awards in compliance with Federal statutes, regulation, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Controller General of the United States and the Internal Control Integrated Framework, issued by the Committee on Sponsoring Organizations of the Treadway Commission (COSO). In addition, 2 CFR 200.502(b) states that since the Federal Government is at risk for loans until the debt is repaid, the following guidelines must be used to calculate the value of Federal awards expended under loan programs, except as noted in paragraphs (c) and (d) of this section: (1) Value of new loans made or received during the audit period; plus (2) Beginning of the audit period balance of loans from previous years for which the Federal Government imposes continuing compliance requirements; plus (3) Any interest subsidy, cash, or administrative cost allowance received. Condition: The Authoritys schedule of expenditures of federal awards (SEFA) did not report loan balances on the SEFA as required by Uniform Guidance for federal program 14.228. Questioned costs: Not able to determine. Context: The Agency did not report loan balances on the SEFA. Cause: The Agency was not aware of the requirements to include loan balances on the SEFA. Effect: The SEFA omitted loan balances for federal program 14.228. Therefore, it was not in compliance with 2 CFR Subpart D 200.302 (1), 200.303 (a) and 200.502 (b). The Agencys program expenditures may be disallowed if the expenditures are not reported correctly on the SEFA. Recommendation: We recommend that the Agency review current procedures for creating the SEFA to ensure that it is accurately reporting loan balances and expenditures during the year under audit for all federal programs to ensure compliance with Uniform Guidance. Views of responsible officials: There is no disagreement with the audit finding.
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 66.458, Environmental Protection Agency. Capitalization Grants for Clean Water State Revolving Funds. Federal Award Identification Number and Year: 5749-01, Loan Period 06/18/2022-11/15/2024 Pass-through Entity: Michigan Department of Environment, Great Lakes, and Energy Finance Division - Water Infrastructure Financing Section Type: Material weakness in internal controls and material noncompliance with laws and regulations Repeat Finding: No Criteria: Per 2 CFR 200.510 (b), the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee’s financial statements, which must include the total federal awards expended as determined with section 200.502. Condition: The Township did not identify that they were subject to an audit under the Uniform Guidance (U.G.) and a schedule of expenditures of federal awards (SEFA) was not prepared by management. Identification of How Likely Questioned Costs Were Computed: N/A Known Questioned Costs: None Context: In fiscal year 2023, the Township had $1,072,983 in expenditures under three federal awards to report on the SEFA. The Capitalization Grants of Clean Water Revolving Funds was determined to have $980,228 in federal expenditures subject to audit under the U.G. Cause/Effect: The Township's controls were not adequate to ensure that they identify the requirement to have an audit under the Uniform Guidance and the preparation of an accurate and complete SEFA. As a result, management may fail to identify that an audit under the Uniform Guidance is required and that all federal dollars are included. Recommendation: We recommend the Township review federal, state, and local grants to determine if they are federally funded and, if federally funded, utilize the account number outlined in the State of Michigan chart of accounts to track federal funding. View of responsible officials and planned corrective action plan: See attached corrective action plan.
Federal Agency: US Department of Housing and Urban Development Federal Program Title: Community Development Block Grants/Entitlement Grants ALN Number: 14.228 Award Periods: April 1, 2022 March 31, 2023 Type of Finding: Significant Deficiency in Internal Control over Compliance also reported as Other Noncompliance Criteria or specific requirement: 2 CFR Subpart D 200.302 (1) and 200.303 (a) stipulates that the auditee must identify, in its accounts, all Federal awards received and expended and the Federal programs under which they were received. Federal programs and award identification shall include, as applicable, the ALN title and number, Federal award identification number and year, name of Federal agency, and name of the pass-through entity; establish and maintain effective internal control over Federal award that provides reasonable assurance that the auditee is managing Federal awards in compliance with Federal statutes, regulation, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Controller General of the United States and the Internal Control Integrated Framework, issued by the Committee on Sponsoring Organizations of the Treadway Commission (COSO). In addition, 2 CFR 200.502(b) states that since the Federal Government is at risk for loans until the debt is repaid, the following guidelines must be used to calculate the value of Federal awards expended under loan programs, except as noted in paragraphs (c) and (d) of this section: (1) Value of new loans made or received during the audit period; plus (2) Beginning of the audit period balance of loans from previous years for which the Federal Government imposes continuing compliance requirements; plus (3) Any interest subsidy, cash, or administrative cost allowance received. Condition: The Authoritys schedule of expenditures of federal awards (SEFA) did not report loan balances on the SEFA as required by Uniform Guidance for federal program 14.228. Questioned costs: Not able to determine. Context: The Agency did not report loan balances on the SEFA. Cause: The Agency was not aware of the requirements to include loan balances on the SEFA. Effect: The SEFA omitted loan balances for federal program 14.228. Therefore, it was not in compliance with 2 CFR Subpart D 200.302 (1), 200.303 (a) and 200.502 (b). The Agencys program expenditures may be disallowed if the expenditures are not reported correctly on the SEFA. Recommendation: We recommend that the Agency review current procedures for creating the SEFA to ensure that it is accurately reporting loan balances and expenditures during the year under audit for all federal programs to ensure compliance with Uniform Guidance. Views of responsible officials: There is no disagreement with the audit finding.
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 66.458, Environmental Protection Agency. Capitalization Grants for Clean Water State Revolving Funds. Federal Award Identification Number and Year: 5749-01, Loan Period 06/18/2022-11/15/2024 Pass-through Entity: Michigan Department of Environment, Great Lakes, and Energy Finance Division - Water Infrastructure Financing Section Type: Material weakness in internal controls and material noncompliance with laws and regulations Repeat Finding: No Criteria: Per 2 CFR 200.510 (b), the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee’s financial statements, which must include the total federal awards expended as determined with section 200.502. Condition: The Township did not identify that they were subject to an audit under the Uniform Guidance (U.G.) and a schedule of expenditures of federal awards (SEFA) was not prepared by management. Identification of How Likely Questioned Costs Were Computed: N/A Known Questioned Costs: None Context: In fiscal year 2023, the Township had $1,072,983 in expenditures under three federal awards to report on the SEFA. The Capitalization Grants of Clean Water Revolving Funds was determined to have $980,228 in federal expenditures subject to audit under the U.G. Cause/Effect: The Township's controls were not adequate to ensure that they identify the requirement to have an audit under the Uniform Guidance and the preparation of an accurate and complete SEFA. As a result, management may fail to identify that an audit under the Uniform Guidance is required and that all federal dollars are included. Recommendation: We recommend the Township review federal, state, and local grants to determine if they are federally funded and, if federally funded, utilize the account number outlined in the State of Michigan chart of accounts to track federal funding. View of responsible officials and planned corrective action plan: See attached corrective action plan.
Finding 2023-003 – Significant Deficiency – Corrections needed to SEFA Award No.: 15.574 Federal Grantor: U.S. Department of the Interior, Bureau of Reclamation. Compliance Requirement: Other compliance requirements. Condition: The schedule of Expenditures of Federal Awards (SEFA) was not complete, and expenditures reported on the SEFA were revised during the single audit. Criteria: 2 CFR Part 200, Subpart F (Uniform Guidance) Section 200.502 states, “The auditee should prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee’s financial statements.” Internal controls over the SEFA should be in place to ensure accrual basis expenses incurred under the federal program are properly reported as expenses on the SEFA and are properly reported as revenue in the financial statements prior to the start of the single audit. Cause: SEFA was not fully reconciled and finalized until after the single audit began. Effect: Expenses were omitted from the SEFA that should have been included. The SEFA had to be revised over the course of the audit. This delayed the audit testing and could have resulted in the auditor not selecting the correct expenses for testing and could have resulted in the single audit not satisfying the requirements of the Uniform Guidance. Context: The Authority recorded federal contributions on a cash basis method of accounting, which resulted in allowable federal expenditures being subsequently discovered in the amount of $835,371 that should have been accrued as revenue as of year ended February 28, 2022. Additionally, $1,256,145 of allowable federal expenditures were discovered in the year ending February 28, 2023 that were accrued as revenue during the audit. The full amount of $2,091,516 of prior year and current year allowable federal expenditures were tested during the February 28, 2023 single audit. Recommendation: We recommend additional review procedures be implemented to ensure the SEFA is complete and accurate when the single audit begins, which includes reconciling all expenses incurred under each federal award down to the invoice, payroll check and lowest level of other costs claimed, cutting-off each expense at year-end and claiming the reconciled qualifying expenses within 45 days after each quarter end. At year-end, programs should be reviewed for cost adjustments, extensions, and other changes that should be reflected on the SEFA when reconciling expenses for the SEFA. Separate program codes should be used for each grant on the SEFA that summarizes expenses down to the individual invoice level that should be provided to the auditor for the single audit. If overclaimed amounts are identified, the grantor and/or pass-though agency should be contacted to determine whether to return the funds or apply the overclaimed amounts to future claims. Views of Responsible Officials and Planned Corrective Actions: Management’s response and planned corrective action is included in the Corrective Action Plan included at the end of the report.
Finding 2022-001 Preparation of Schedule of Expenditures of Federal Awards Federal Agency and Pass-through Entity: U.S. Environmental Protection Agency – Georgia Environmental Finance Authority Program Title/Cluster: Clean Water State Revolving Fund Cluster (CWSRF) Criteria: The Schedule of Expenditures of Federal Awards is a supplemental schedule to the financial statements required to be produced when the entity is subject to a single audit. The single audit requirement is triggered when the federal expenditures reported on the Schedule of Expenditures of Federal Awards exceed $750,000 or more within an entity’s fiscal year. Uniform Guidance 2 CFR §200.510(b) states “The auditee must prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with §200.502.” Condition: For the year ended December 31, 2022, the City kept records of all expenditures and receipts of funding from drawdown requests together with support of payments and deposits of funds related to all federal expenditures but did not present those expenditures correctly or completely on a Schedule of Expenditure of Federal Awards that met minimum requirements as established by Uniform Guidance 2 CFR §200.510(b). Effect: An accurate representation of total federal expenditures for the fiscal year is required to clearly identify federal expenditures for the audit period. The absence of a complete and accurate Schedule of Expenditures of Federal Awards for the audit period is noncompliant with the requirements set forth under Uniform Guidance 2 CFR §200.510(b) but does not constitute a significant deficiency or material weakness in internal control over compliance. Questioned Costs: None reported. Recommendation: The City should implement a policy requiring entry of any federal expenditures to the Schedule of Expenditures of Federal Awards as part of the drawdown or pay request processes when submitting expenditures to the Federal Agency or Pass-through Entity providing funding. The procedures should be followed consistently to ensure that federal funds are appropriately accounted for and clearly identifiable for the period in which they occurred. The City of Hartwell should refer to the compliance requirements of Title 2 U.S. Code of Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, and ensure the City meets the minimum Schedule of Expenditures of Federal Awards requirements as described in 2 CFR §200.510(b).
Program Information: Temporary Assistance for Needy Families (ALN #93.558) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting- The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing 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. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. Condition: The SEFA, as prepared by management, erroneously excluded certain pass-through federal funds from the State. Cause: Administrative oversight with respect to preparation of the SEFA. Effect or Potential Effect: The original draft SEFA was prepared in error. Questioned Costs: None. Context: The original draft SEFA was prepared in error. Identification as a Repeat Finding: No similar findings noted in the prior year. Recommendation: We recommend that the Alliance enhance its procedures and internal controls with respect to preparation and review of the SEFA. Views of Responsible Officials and Planned Corrective Actions: Grant agreements will be reviewed to confirm if expenditures from pass-through entities are related to federal or state grants, and appropriately include applicable federal grants and pass-through funds in the SEFA.
U.S. Department of the Treasury State of New Jersey Department of Community Affairs COVID-19 Coronavirus State and Local Fiscal Recovery Funds (ALN 21.027) Federal Award Number and Years: G2022-09 (03/02/2021 – 12/31/2024) Statistically Valid Sample: The sample was not intended to be, and was not, a statistically valid sample Repeat Finding: No Finding Type: Material Weakness, Material Non-compliance Criteria Reporting Per 2 CFR 200.502, the determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs. Generally, the activity pertains to events that require the non-Federal entity to comply with Federal statutes, regulations, and the terms and conditions of Federal awards, such as: expenditure/expense transactions associated with awards including grants. Further, the Uniform Guidance compliance supplement notes, each recipient must report program outlays and program income on a cash or accrual basis, as prescribed by the federal awarding agency. Also, in accordance with the grant agreement and the reporting requirements for the State of New Jersey Department of Community Affairs, direct grants and pass-through funds are fulfilled utilizing an advanced payment method and tracking reports. The grantee shall submit quarterly financial reports, in a format to be provided by the Department, and including the number of government full-time employees responding to COVID-19 as supported by this funding. The reports are prepared and submitted to allow for relevant and reliable information to be provided to the Federal government or State of New Jersey for tracking purposes. The reports are the source documents for the grantee to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the grantee’s financial statements in accordance with 2 CFR 200.502, Basis for determining Federal awards expended, for the SEFA. Procurement Non-federal entities other than states, including those operating federal programs as subrecipients of states, must follow the procurement standards set out at 2 CFR sections 200.318 through 200.326. They must use their own documented procurement procedures, which reflect applicable state and local laws and regulations, provided that the procurements conform to applicable federal statutes and the procurement requirements identified in 2 CFR Part 200. A non-federal entity must: 1. Meet the general procurement standards in 2 CFR section 200.318, which include oversight of contractors’ performance, maintaining written standards of conduct for employees involved in contracting, awarding contracts only to responsible contractors, and maintaining records to document history of procurements. 2. Conduct all procurement transactions in a manner providing full and open competition, in accordance with 2 CFR section 200.319. 3. Use the micro-purchase and small purchase methods only for procurements that meet the applicable criteria under 2 CFR sections 200.320(a) (1) and (2). Under the micro-purchase method, the aggregate dollar amount does not exceed $10,000 ($2,000 in the case of acquisition for construction subject to the Wage Rate Requirements (Davis-Bacon Act)). Small purchase procedures are used for purchases that exceed the micro-purchase amount but do not exceed the simplified acquisition threshold ($250,000). Micro-purchases may be awarded without soliciting competitive quotations if the non-federal entity considers the price to be reasonable (2 CFR section 200.320(a)). If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources (2 CFR section 200.320(b)). In accordance with the grant agreement and the reporting requirements for the State of New Jersey Department of Community Affairs, recipients may use award funds to enter into contracts to procure goods and services necessary to implement one or more of the eligible purposes outlined in sections 602(c) and 603(c) of the Act and Treasury’s Interim Final Rule and Final Rule. As such, recipients are expected to have procurement policies and procedures in place that comply with the procurement standards outlined in the Uniform Guidance. Under the program, St. Joseph’s Health, Inc. must follow the procurement standards in 2 CFR sections 200.318 through 200.327, including ensuring that the procurement method used for the contracts are appropriate based on the dollar amount and conditions specified in 2 CFR section 200.320. Additionally, in accordance with Federal requirements, a non-Federal entity shall maintain internal controls over Federal programs designed to provide reasonable assurance that transactions are executed in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award that could have a direct and material effect on a Federal program. Condition and Context Reporting On a quarterly basis, St. Joseph’s Health, Inc. (the System) prepares and reports to the State of New Jersey Department of Community Affairs (the Department) the program expenditures for Federal funding amounts on the tracking report of expenditures, which are then used to prepare the annual SEFA in conjunction with the general ledger detail at the end of the fiscal year. While the expenditures per the SEFA as prepared by the System was accurate and the quarterly reporting was accepted by the State, the System’s expenditures per the report of expenditures were based upon purchase order amounts, which includes expenditures that were incurred subsequent to year-end. Procurement The System has procurement policies and guidelines that are in accordance with the respective provisions of the Uniform Guidance. The System contracted with multiple vendors for several projects under the G2022-09 grant that were above the micro purchase threshold of $10,000, but below the simplified acquisition threshold of $250,000. However, the System did not obtain multiple quotes from different vendors to encourage fair competition in the market as per the System’s prescribed procurement policies and guidelines. The vendors were not suspended or debarred and the associated expenditures with these vendors incurred in fiscal year 2022 were determined to be allowable. The System’s policies and procedures to ensure compliance with the above compliance requirements did not include certain internal controls that were designed properly and operating effectively to ensure that the System’s report of expenditures submitted to the Department includes a reconciliation between incurred expenditures and purchase order balances or obtained the necessary quotes from potential bidders for procurements over the micro purchase threshold. Cause Management’s review of the submitted tracking report of expenditures did not identify the need for a reconciliation of incurred expenditures and purchase order balances reported to the Department and as such, as there is a variance between the amounts reported on the SEFA and the amounts reported to the Department on the quarterly reports of approximately $2.2 million. Additionally, they System did not retain or obtain the required documentation for procurements entered into with vendors for the grant in accordance with the System’s procurement policies and guidelines. Effect The System had a material variance in the amount of expenditures reported to the Department as compared to the SEFA, as well as did not comply with Federal regulations or its own policies and guidelines for procurement transactions and related document retention. Questioned costs None Recommendation Reporting We recommend that the System strengthen its processes and internal controls to ensure the tracking report of expenditures provided to the Department has a reconciliation of the amount of expenditures incurred in the period based upon the general ledger and accounting records, used to prepare the annual SEFA, as compared to the purchase order balances. Procurement We recommend that the System strengthen its processes and internal controls to ensure the System obtains and retains the required documentation for each procurement based upon the type of procurement and dollar thresholds. View of Responsible Official Management agrees with the auditor’s recommendation and will strengthen its processes and internal controls to ensure the report of expenditures provided to the Department has a reconciliation of the amount of expenditures incurred in the period compared to the purchase order balances. In addition, Management will strengthen its processes and internal controls to ensure the System obtains and retains the required documentation for each procurement based upon the type of procurement and dollar thresholds.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502. Basis for determining Federal awards expended.” The SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 200.302 Financial Management, a non-federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in Section 200.328 Financial Reporting and Section 200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502. Basis for determining Federal awards expended.” The SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 200.302 Financial Management, a non-federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in Section 200.328 Financial Reporting and Section 200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502. Basis for determining Federal awards expended.” The SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 200.302 Financial Management, a non-federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in Section 200.328 Financial Reporting and Section 200.329 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.