FINDING NO: 2023-102 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Period of Performance; Subrecipient Monitoring QUESTIONED COSTS: $348,761 Criteria: 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.334 – Retention requirements for records states, in part, “Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.” Condition and Context: The State of Oklahoma transfers all CSLFRF funds to state agencies so they can work directly with the subrecipient to ensure the project(s) are executed correctly. The State of Oklahoma had seven (7) state agencies make payments totaling $51,454,078 to subrecipients during SFY 2023. For the three (3) state agencies selected for testing, we sampled 14 of 43 subrecipient payments totaling $5,192,951 from a population of $8,694,772; and noted the following issue: • An Oklahoma State Department of Health (OSDH) subrecipient was reimbursed $825,223.40 on 6/16/23; however, $429,592.97 was later determined unallowed on 8/21/23 after an internal review. The subrecipient purchased pharmacy supplies which were unallowed. The subrecipient was only approved to purchase buildings and perform renovations in accordance with the contract and funding packet between OSDH and the subrecipient. The subrecipient then submitted an additional $80,831.48 of allowable costs on 11/8/23 to be applied against the unallowed costs he was already reimbursed. The remaining $348,761.49 was to be paid by the subrecipient for future capital expenditures. We requested supporting documentation for the $348,761.49 submitted by subrecipient for future capital expenditures; however, support could not be provided. Cause: The Oklahoma State Department of Health (OSDH) did not obtain and adequately review all supporting documents prior to payment. Effect: Unallowable costs, totaling $348,761.49, were charged to the CSLFRF program and not supported. Recommendation: We recommend the Oklahoma State Department of Health (OSDH) strengthen their internal controls to ensure adequate supporting documentation for program expenditures incurred is obtained, reviewed, and maintained to ensure subrecipients are expending CSLFRF funds for allowable costs. Views of Responsible Official(s) Contact Person: OMES: Parker Wise OSDH: Diane Brown, Danielle Smith, Tracey Douglas Anticipated Completion Date: 5/1/2025 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-102 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Period of Performance; Subrecipient Monitoring QUESTIONED COSTS: $348,761 Criteria: 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.334 – Retention requirements for records states, in part, “Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.” Condition and Context: The State of Oklahoma transfers all CSLFRF funds to state agencies so they can work directly with the subrecipient to ensure the project(s) are executed correctly. The State of Oklahoma had seven (7) state agencies make payments totaling $51,454,078 to subrecipients during SFY 2023. For the three (3) state agencies selected for testing, we sampled 14 of 43 subrecipient payments totaling $5,192,951 from a population of $8,694,772; and noted the following issue: • An Oklahoma State Department of Health (OSDH) subrecipient was reimbursed $825,223.40 on 6/16/23; however, $429,592.97 was later determined unallowed on 8/21/23 after an internal review. The subrecipient purchased pharmacy supplies which were unallowed. The subrecipient was only approved to purchase buildings and perform renovations in accordance with the contract and funding packet between OSDH and the subrecipient. The subrecipient then submitted an additional $80,831.48 of allowable costs on 11/8/23 to be applied against the unallowed costs he was already reimbursed. The remaining $348,761.49 was to be paid by the subrecipient for future capital expenditures. We requested supporting documentation for the $348,761.49 submitted by subrecipient for future capital expenditures; however, support could not be provided. Cause: The Oklahoma State Department of Health (OSDH) did not obtain and adequately review all supporting documents prior to payment. Effect: Unallowable costs, totaling $348,761.49, were charged to the CSLFRF program and not supported. Recommendation: We recommend the Oklahoma State Department of Health (OSDH) strengthen their internal controls to ensure adequate supporting documentation for program expenditures incurred is obtained, reviewed, and maintained to ensure subrecipients are expending CSLFRF funds for allowable costs. Views of Responsible Official(s) Contact Person: OMES: Parker Wise OSDH: Diane Brown, Danielle Smith, Tracey Douglas Anticipated Completion Date: 5/1/2025 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-102 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Period of Performance; Subrecipient Monitoring QUESTIONED COSTS: $348,761 Criteria: 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.334 – Retention requirements for records states, in part, “Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.” Condition and Context: The State of Oklahoma transfers all CSLFRF funds to state agencies so they can work directly with the subrecipient to ensure the project(s) are executed correctly. The State of Oklahoma had seven (7) state agencies make payments totaling $51,454,078 to subrecipients during SFY 2023. For the three (3) state agencies selected for testing, we sampled 14 of 43 subrecipient payments totaling $5,192,951 from a population of $8,694,772; and noted the following issue: • An Oklahoma State Department of Health (OSDH) subrecipient was reimbursed $825,223.40 on 6/16/23; however, $429,592.97 was later determined unallowed on 8/21/23 after an internal review. The subrecipient purchased pharmacy supplies which were unallowed. The subrecipient was only approved to purchase buildings and perform renovations in accordance with the contract and funding packet between OSDH and the subrecipient. The subrecipient then submitted an additional $80,831.48 of allowable costs on 11/8/23 to be applied against the unallowed costs he was already reimbursed. The remaining $348,761.49 was to be paid by the subrecipient for future capital expenditures. We requested supporting documentation for the $348,761.49 submitted by subrecipient for future capital expenditures; however, support could not be provided. Cause: The Oklahoma State Department of Health (OSDH) did not obtain and adequately review all supporting documents prior to payment. Effect: Unallowable costs, totaling $348,761.49, were charged to the CSLFRF program and not supported. Recommendation: We recommend the Oklahoma State Department of Health (OSDH) strengthen their internal controls to ensure adequate supporting documentation for program expenditures incurred is obtained, reviewed, and maintained to ensure subrecipients are expending CSLFRF funds for allowable costs. Views of Responsible Official(s) Contact Person: OMES: Parker Wise OSDH: Diane Brown, Danielle Smith, Tracey Douglas Anticipated Completion Date: 5/1/2025 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-102 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Period of Performance; Subrecipient Monitoring QUESTIONED COSTS: $348,761 Criteria: 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.334 – Retention requirements for records states, in part, “Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.” Condition and Context: The State of Oklahoma transfers all CSLFRF funds to state agencies so they can work directly with the subrecipient to ensure the project(s) are executed correctly. The State of Oklahoma had seven (7) state agencies make payments totaling $51,454,078 to subrecipients during SFY 2023. For the three (3) state agencies selected for testing, we sampled 14 of 43 subrecipient payments totaling $5,192,951 from a population of $8,694,772; and noted the following issue: • An Oklahoma State Department of Health (OSDH) subrecipient was reimbursed $825,223.40 on 6/16/23; however, $429,592.97 was later determined unallowed on 8/21/23 after an internal review. The subrecipient purchased pharmacy supplies which were unallowed. The subrecipient was only approved to purchase buildings and perform renovations in accordance with the contract and funding packet between OSDH and the subrecipient. The subrecipient then submitted an additional $80,831.48 of allowable costs on 11/8/23 to be applied against the unallowed costs he was already reimbursed. The remaining $348,761.49 was to be paid by the subrecipient for future capital expenditures. We requested supporting documentation for the $348,761.49 submitted by subrecipient for future capital expenditures; however, support could not be provided. Cause: The Oklahoma State Department of Health (OSDH) did not obtain and adequately review all supporting documents prior to payment. Effect: Unallowable costs, totaling $348,761.49, were charged to the CSLFRF program and not supported. Recommendation: We recommend the Oklahoma State Department of Health (OSDH) strengthen their internal controls to ensure adequate supporting documentation for program expenditures incurred is obtained, reviewed, and maintained to ensure subrecipients are expending CSLFRF funds for allowable costs. Views of Responsible Official(s) Contact Person: OMES: Parker Wise OSDH: Diane Brown, Danielle Smith, Tracey Douglas Anticipated Completion Date: 5/1/2025 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-102 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Period of Performance; Subrecipient Monitoring QUESTIONED COSTS: $348,761 Criteria: 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.334 – Retention requirements for records states, in part, “Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.” Condition and Context: The State of Oklahoma transfers all CSLFRF funds to state agencies so they can work directly with the subrecipient to ensure the project(s) are executed correctly. The State of Oklahoma had seven (7) state agencies make payments totaling $51,454,078 to subrecipients during SFY 2023. For the three (3) state agencies selected for testing, we sampled 14 of 43 subrecipient payments totaling $5,192,951 from a population of $8,694,772; and noted the following issue: • An Oklahoma State Department of Health (OSDH) subrecipient was reimbursed $825,223.40 on 6/16/23; however, $429,592.97 was later determined unallowed on 8/21/23 after an internal review. The subrecipient purchased pharmacy supplies which were unallowed. The subrecipient was only approved to purchase buildings and perform renovations in accordance with the contract and funding packet between OSDH and the subrecipient. The subrecipient then submitted an additional $80,831.48 of allowable costs on 11/8/23 to be applied against the unallowed costs he was already reimbursed. The remaining $348,761.49 was to be paid by the subrecipient for future capital expenditures. We requested supporting documentation for the $348,761.49 submitted by subrecipient for future capital expenditures; however, support could not be provided. Cause: The Oklahoma State Department of Health (OSDH) did not obtain and adequately review all supporting documents prior to payment. Effect: Unallowable costs, totaling $348,761.49, were charged to the CSLFRF program and not supported. Recommendation: We recommend the Oklahoma State Department of Health (OSDH) strengthen their internal controls to ensure adequate supporting documentation for program expenditures incurred is obtained, reviewed, and maintained to ensure subrecipients are expending CSLFRF funds for allowable costs. Views of Responsible Official(s) Contact Person: OMES: Parker Wise OSDH: Diane Brown, Danielle Smith, Tracey Douglas Anticipated Completion Date: 5/1/2025 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-102 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Period of Performance; Subrecipient Monitoring QUESTIONED COSTS: $348,761 Criteria: 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.334 – Retention requirements for records states, in part, “Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.” Condition and Context: The State of Oklahoma transfers all CSLFRF funds to state agencies so they can work directly with the subrecipient to ensure the project(s) are executed correctly. The State of Oklahoma had seven (7) state agencies make payments totaling $51,454,078 to subrecipients during SFY 2023. For the three (3) state agencies selected for testing, we sampled 14 of 43 subrecipient payments totaling $5,192,951 from a population of $8,694,772; and noted the following issue: • An Oklahoma State Department of Health (OSDH) subrecipient was reimbursed $825,223.40 on 6/16/23; however, $429,592.97 was later determined unallowed on 8/21/23 after an internal review. The subrecipient purchased pharmacy supplies which were unallowed. The subrecipient was only approved to purchase buildings and perform renovations in accordance with the contract and funding packet between OSDH and the subrecipient. The subrecipient then submitted an additional $80,831.48 of allowable costs on 11/8/23 to be applied against the unallowed costs he was already reimbursed. The remaining $348,761.49 was to be paid by the subrecipient for future capital expenditures. We requested supporting documentation for the $348,761.49 submitted by subrecipient for future capital expenditures; however, support could not be provided. Cause: The Oklahoma State Department of Health (OSDH) did not obtain and adequately review all supporting documents prior to payment. Effect: Unallowable costs, totaling $348,761.49, were charged to the CSLFRF program and not supported. Recommendation: We recommend the Oklahoma State Department of Health (OSDH) strengthen their internal controls to ensure adequate supporting documentation for program expenditures incurred is obtained, reviewed, and maintained to ensure subrecipients are expending CSLFRF funds for allowable costs. Views of Responsible Official(s) Contact Person: OMES: Parker Wise OSDH: Diane Brown, Danielle Smith, Tracey Douglas Anticipated Completion Date: 5/1/2025 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-102 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Period of Performance; Subrecipient Monitoring QUESTIONED COSTS: $348,761 Criteria: 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.334 – Retention requirements for records states, in part, “Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.” Condition and Context: The State of Oklahoma transfers all CSLFRF funds to state agencies so they can work directly with the subrecipient to ensure the project(s) are executed correctly. The State of Oklahoma had seven (7) state agencies make payments totaling $51,454,078 to subrecipients during SFY 2023. For the three (3) state agencies selected for testing, we sampled 14 of 43 subrecipient payments totaling $5,192,951 from a population of $8,694,772; and noted the following issue: • An Oklahoma State Department of Health (OSDH) subrecipient was reimbursed $825,223.40 on 6/16/23; however, $429,592.97 was later determined unallowed on 8/21/23 after an internal review. The subrecipient purchased pharmacy supplies which were unallowed. The subrecipient was only approved to purchase buildings and perform renovations in accordance with the contract and funding packet between OSDH and the subrecipient. The subrecipient then submitted an additional $80,831.48 of allowable costs on 11/8/23 to be applied against the unallowed costs he was already reimbursed. The remaining $348,761.49 was to be paid by the subrecipient for future capital expenditures. We requested supporting documentation for the $348,761.49 submitted by subrecipient for future capital expenditures; however, support could not be provided. Cause: The Oklahoma State Department of Health (OSDH) did not obtain and adequately review all supporting documents prior to payment. Effect: Unallowable costs, totaling $348,761.49, were charged to the CSLFRF program and not supported. Recommendation: We recommend the Oklahoma State Department of Health (OSDH) strengthen their internal controls to ensure adequate supporting documentation for program expenditures incurred is obtained, reviewed, and maintained to ensure subrecipients are expending CSLFRF funds for allowable costs. Views of Responsible Official(s) Contact Person: OMES: Parker Wise OSDH: Diane Brown, Danielle Smith, Tracey Douglas Anticipated Completion Date: 5/1/2025 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-102 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Period of Performance; Subrecipient Monitoring QUESTIONED COSTS: $348,761 Criteria: 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.334 – Retention requirements for records states, in part, “Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.” Condition and Context: The State of Oklahoma transfers all CSLFRF funds to state agencies so they can work directly with the subrecipient to ensure the project(s) are executed correctly. The State of Oklahoma had seven (7) state agencies make payments totaling $51,454,078 to subrecipients during SFY 2023. For the three (3) state agencies selected for testing, we sampled 14 of 43 subrecipient payments totaling $5,192,951 from a population of $8,694,772; and noted the following issue: • An Oklahoma State Department of Health (OSDH) subrecipient was reimbursed $825,223.40 on 6/16/23; however, $429,592.97 was later determined unallowed on 8/21/23 after an internal review. The subrecipient purchased pharmacy supplies which were unallowed. The subrecipient was only approved to purchase buildings and perform renovations in accordance with the contract and funding packet between OSDH and the subrecipient. The subrecipient then submitted an additional $80,831.48 of allowable costs on 11/8/23 to be applied against the unallowed costs he was already reimbursed. The remaining $348,761.49 was to be paid by the subrecipient for future capital expenditures. We requested supporting documentation for the $348,761.49 submitted by subrecipient for future capital expenditures; however, support could not be provided. Cause: The Oklahoma State Department of Health (OSDH) did not obtain and adequately review all supporting documents prior to payment. Effect: Unallowable costs, totaling $348,761.49, were charged to the CSLFRF program and not supported. Recommendation: We recommend the Oklahoma State Department of Health (OSDH) strengthen their internal controls to ensure adequate supporting documentation for program expenditures incurred is obtained, reviewed, and maintained to ensure subrecipients are expending CSLFRF funds for allowable costs. Views of Responsible Official(s) Contact Person: OMES: Parker Wise OSDH: Diane Brown, Danielle Smith, Tracey Douglas Anticipated Completion Date: 5/1/2025 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-102 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Period of Performance; Subrecipient Monitoring QUESTIONED COSTS: $348,761 Criteria: 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.334 – Retention requirements for records states, in part, “Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.” Condition and Context: The State of Oklahoma transfers all CSLFRF funds to state agencies so they can work directly with the subrecipient to ensure the project(s) are executed correctly. The State of Oklahoma had seven (7) state agencies make payments totaling $51,454,078 to subrecipients during SFY 2023. For the three (3) state agencies selected for testing, we sampled 14 of 43 subrecipient payments totaling $5,192,951 from a population of $8,694,772; and noted the following issue: • An Oklahoma State Department of Health (OSDH) subrecipient was reimbursed $825,223.40 on 6/16/23; however, $429,592.97 was later determined unallowed on 8/21/23 after an internal review. The subrecipient purchased pharmacy supplies which were unallowed. The subrecipient was only approved to purchase buildings and perform renovations in accordance with the contract and funding packet between OSDH and the subrecipient. The subrecipient then submitted an additional $80,831.48 of allowable costs on 11/8/23 to be applied against the unallowed costs he was already reimbursed. The remaining $348,761.49 was to be paid by the subrecipient for future capital expenditures. We requested supporting documentation for the $348,761.49 submitted by subrecipient for future capital expenditures; however, support could not be provided. Cause: The Oklahoma State Department of Health (OSDH) did not obtain and adequately review all supporting documents prior to payment. Effect: Unallowable costs, totaling $348,761.49, were charged to the CSLFRF program and not supported. Recommendation: We recommend the Oklahoma State Department of Health (OSDH) strengthen their internal controls to ensure adequate supporting documentation for program expenditures incurred is obtained, reviewed, and maintained to ensure subrecipients are expending CSLFRF funds for allowable costs. Views of Responsible Official(s) Contact Person: OMES: Parker Wise OSDH: Diane Brown, Danielle Smith, Tracey Douglas Anticipated Completion Date: 5/1/2025 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-102 STATE AGENCY: State of Oklahoma FEDERAL AGENCY: U.S. Department of the Treasury ALN: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) FEDERAL AWARD NUMBER: N/A FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Period of Performance; Subrecipient Monitoring QUESTIONED COSTS: $348,761 Criteria: 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.334 – Retention requirements for records states, in part, “Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.” Condition and Context: The State of Oklahoma transfers all CSLFRF funds to state agencies so they can work directly with the subrecipient to ensure the project(s) are executed correctly. The State of Oklahoma had seven (7) state agencies make payments totaling $51,454,078 to subrecipients during SFY 2023. For the three (3) state agencies selected for testing, we sampled 14 of 43 subrecipient payments totaling $5,192,951 from a population of $8,694,772; and noted the following issue: • An Oklahoma State Department of Health (OSDH) subrecipient was reimbursed $825,223.40 on 6/16/23; however, $429,592.97 was later determined unallowed on 8/21/23 after an internal review. The subrecipient purchased pharmacy supplies which were unallowed. The subrecipient was only approved to purchase buildings and perform renovations in accordance with the contract and funding packet between OSDH and the subrecipient. The subrecipient then submitted an additional $80,831.48 of allowable costs on 11/8/23 to be applied against the unallowed costs he was already reimbursed. The remaining $348,761.49 was to be paid by the subrecipient for future capital expenditures. We requested supporting documentation for the $348,761.49 submitted by subrecipient for future capital expenditures; however, support could not be provided. Cause: The Oklahoma State Department of Health (OSDH) did not obtain and adequately review all supporting documents prior to payment. Effect: Unallowable costs, totaling $348,761.49, were charged to the CSLFRF program and not supported. Recommendation: We recommend the Oklahoma State Department of Health (OSDH) strengthen their internal controls to ensure adequate supporting documentation for program expenditures incurred is obtained, reviewed, and maintained to ensure subrecipients are expending CSLFRF funds for allowable costs. Views of Responsible Official(s) Contact Person: OMES: Parker Wise OSDH: Diane Brown, Danielle Smith, Tracey Douglas Anticipated Completion Date: 5/1/2025 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-059 (Partial Repeat 2022-049) STATE AGENCY: Oklahoma State Department of Education (OSDE) FEDERAL AGENCY: United States Department of Education (USDE) ALN: 84.425 – 84.425D, 84.425U; 84.425R FEDERAL PROGRAM NAME: Education Stabilization Fund (ESF) - Elementary and Secondary Schools Emergency Relief Fund (ESSER II); American Rescue Plan – Elementary and Secondary Schools Emergency Relief Fund (ARP ESSER III); Coronavirus Response and Relief Supplemental Appropriations Act, 2021 – Emergency Assistance To Non-Public Schools (CRRSA EANS) FEDERAL AWARD NUMBER: S425D210024; S425U210024 FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: 2 CFR § 200.303(a) – Internal Controls states in part, “The Non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.334 Record retention requirements states in part, “The recipient and subrecipient must retain all Federal award records for three years from the date of submission of their final financial report. For awards that are renewed quarterly or annually, the recipient and subrecipient must retain records for three years from the date of submission of their quarterly or annual financial report, respectively. Records to be retained include but are not limited to, financial records, supporting documentation, and statistical records. Federal agencies or pass-through entities may not impose any other record retention requirements except for the following: (a) The records must be retained until all litigation, claims, or audit findings involving the records have been resolved and final action taken if any litigation, claim, or audit is started before the expiration of the three-year period.” United States Department of Education website ESSER Annual Reporting states in part, “All grantees are required to report on ESSER funds received under the Coronavirus Aid, Relief, and Economic Security (CARES) Act; the Coronavirus Response and Relief Supplemental Appropriations (CRRSA) Act; and the American Rescue Plan (ARP) Act. Grantees must submit an annual report describing how the State and subrecipients used the awarded funds during the performance period. Similar to CARES Act Year 1 annual reporting, grantees will use the Annual Report Data Collection Tool to submit the State report.” Condition and Context: We were unable to verify compliance with several key line items on the ESSER I, ESSER II, ARP ESSER III, and CRRSA EANS SFY 22 Annual Reports submitted during the audit period due to a lack of supporting documentation (i.e., supporting data and questionnaires sent to LEAs/nonpublic schools to collect the FTE, Student Participation data, and expenditures by category and object code). These key line items include the following: • Line 3.b1 LEA expenditures by category, and object code for ESSER I, ESSER II and ARP ESSER III • Line 3.b10 Number of specific positions supported with ESSER Funds • Line 5.a Full Time Equivalent positions for ESSER I, ESSER II and ARP ESSER III • SEA obligations (including reimbursements) by allowable activity for CRRSA EANS • Other information for Non-public schools receiving services or assistance under CRRSA EANS While documenting controls over the Annual Report we noted one LEA with a subaward/allocation of $16,832,303.63 and re-allocation of $28,177.30 and SFY 22 current expenditures of $5,509,241.03 was not included on the ARP ESSER III Annual Report. While reviewing a sample of 62 of 1,275 LEA subaward allocations and total expenditures reported on the ESSER Annual Reports, we noted the following: • For 25 of 62 (40.32%) subawards tested, the SFY 22 allocations reported on the LEA’s Grant Management System (GMS) application was less than the amount reported on the ESSER II Annual Report, totaling $12,707.62. In addition, OSDE did not provide the supporting documentation for ESSER II re-allocations. Therefore, we were unable to verify whether the total allocation for these LEAs were reported correctly in the ESSER II Annual Report. • For three of 62 (4.84%) subawards tested, the SFY 22 current expenditures reported on the LEA’s GMS Closeout Report or Summary Expenditures reports were less than the amount reported on the ARP ESSER III Annual Report. OSDE was unable to provide support for the variances totaling $218,392.41. Cause: Due to staff turnover and inadequate record retention policies and procedures, OSDE was unable to locate and/or provide all the supporting documentation used by previous staff members to prepare the reports. Effect: The amount reported for the total ARP ESSER III subaward was understated by $16,860,480.93, and the amount reported for the total ARP ESSER III current year expenditures was understated by $5,290,848.62 Information being reported on the USDOE website is not accurate and/or complete. Data previously reported cannot be verified by current staff or other entities required to perform audits or reviews. Recommendation: We recommend OSDE develop and implement appropriate record retention policies and procedures to ensure records are maintained, especially during staff turnovers. We recommend OSDE develop and implement policies and procedures to ensure personnel have an adequate understanding of the requirements for the Annual Report and to ensure the amounts reported are correct. Views of Responsible Official(s) Contact Person: Tammy Smith, Senior Director of Federal Programs | Office of Title Services Anticipated Completion Date: March 2024 Corrective Action Planned: The Oklahoma State Department of Education agrees with the finding. See corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-059 (Partial Repeat 2022-049) STATE AGENCY: Oklahoma State Department of Education (OSDE) FEDERAL AGENCY: United States Department of Education (USDE) ALN: 84.425 – 84.425D, 84.425U; 84.425R FEDERAL PROGRAM NAME: Education Stabilization Fund (ESF) - Elementary and Secondary Schools Emergency Relief Fund (ESSER II); American Rescue Plan – Elementary and Secondary Schools Emergency Relief Fund (ARP ESSER III); Coronavirus Response and Relief Supplemental Appropriations Act, 2021 – Emergency Assistance To Non-Public Schools (CRRSA EANS) FEDERAL AWARD NUMBER: S425D210024; S425U210024 FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: 2 CFR § 200.303(a) – Internal Controls states in part, “The Non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.334 Record retention requirements states in part, “The recipient and subrecipient must retain all Federal award records for three years from the date of submission of their final financial report. For awards that are renewed quarterly or annually, the recipient and subrecipient must retain records for three years from the date of submission of their quarterly or annual financial report, respectively. Records to be retained include but are not limited to, financial records, supporting documentation, and statistical records. Federal agencies or pass-through entities may not impose any other record retention requirements except for the following: (a) The records must be retained until all litigation, claims, or audit findings involving the records have been resolved and final action taken if any litigation, claim, or audit is started before the expiration of the three-year period.” United States Department of Education website ESSER Annual Reporting states in part, “All grantees are required to report on ESSER funds received under the Coronavirus Aid, Relief, and Economic Security (CARES) Act; the Coronavirus Response and Relief Supplemental Appropriations (CRRSA) Act; and the American Rescue Plan (ARP) Act. Grantees must submit an annual report describing how the State and subrecipients used the awarded funds during the performance period. Similar to CARES Act Year 1 annual reporting, grantees will use the Annual Report Data Collection Tool to submit the State report.” Condition and Context: We were unable to verify compliance with several key line items on the ESSER I, ESSER II, ARP ESSER III, and CRRSA EANS SFY 22 Annual Reports submitted during the audit period due to a lack of supporting documentation (i.e., supporting data and questionnaires sent to LEAs/nonpublic schools to collect the FTE, Student Participation data, and expenditures by category and object code). These key line items include the following: • Line 3.b1 LEA expenditures by category, and object code for ESSER I, ESSER II and ARP ESSER III • Line 3.b10 Number of specific positions supported with ESSER Funds • Line 5.a Full Time Equivalent positions for ESSER I, ESSER II and ARP ESSER III • SEA obligations (including reimbursements) by allowable activity for CRRSA EANS • Other information for Non-public schools receiving services or assistance under CRRSA EANS While documenting controls over the Annual Report we noted one LEA with a subaward/allocation of $16,832,303.63 and re-allocation of $28,177.30 and SFY 22 current expenditures of $5,509,241.03 was not included on the ARP ESSER III Annual Report. While reviewing a sample of 62 of 1,275 LEA subaward allocations and total expenditures reported on the ESSER Annual Reports, we noted the following: • For 25 of 62 (40.32%) subawards tested, the SFY 22 allocations reported on the LEA’s Grant Management System (GMS) application was less than the amount reported on the ESSER II Annual Report, totaling $12,707.62. In addition, OSDE did not provide the supporting documentation for ESSER II re-allocations. Therefore, we were unable to verify whether the total allocation for these LEAs were reported correctly in the ESSER II Annual Report. • For three of 62 (4.84%) subawards tested, the SFY 22 current expenditures reported on the LEA’s GMS Closeout Report or Summary Expenditures reports were less than the amount reported on the ARP ESSER III Annual Report. OSDE was unable to provide support for the variances totaling $218,392.41. Cause: Due to staff turnover and inadequate record retention policies and procedures, OSDE was unable to locate and/or provide all the supporting documentation used by previous staff members to prepare the reports. Effect: The amount reported for the total ARP ESSER III subaward was understated by $16,860,480.93, and the amount reported for the total ARP ESSER III current year expenditures was understated by $5,290,848.62 Information being reported on the USDOE website is not accurate and/or complete. Data previously reported cannot be verified by current staff or other entities required to perform audits or reviews. Recommendation: We recommend OSDE develop and implement appropriate record retention policies and procedures to ensure records are maintained, especially during staff turnovers. We recommend OSDE develop and implement policies and procedures to ensure personnel have an adequate understanding of the requirements for the Annual Report and to ensure the amounts reported are correct. Views of Responsible Official(s) Contact Person: Tammy Smith, Senior Director of Federal Programs | Office of Title Services Anticipated Completion Date: March 2024 Corrective Action Planned: The Oklahoma State Department of Education agrees with the finding. See corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-059 (Partial Repeat 2022-049) STATE AGENCY: Oklahoma State Department of Education (OSDE) FEDERAL AGENCY: United States Department of Education (USDE) ALN: 84.425 – 84.425D, 84.425U; 84.425R FEDERAL PROGRAM NAME: Education Stabilization Fund (ESF) - Elementary and Secondary Schools Emergency Relief Fund (ESSER II); American Rescue Plan – Elementary and Secondary Schools Emergency Relief Fund (ARP ESSER III); Coronavirus Response and Relief Supplemental Appropriations Act, 2021 – Emergency Assistance To Non-Public Schools (CRRSA EANS) FEDERAL AWARD NUMBER: S425D210024; S425U210024 FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: 2 CFR § 200.303(a) – Internal Controls states in part, “The Non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.334 Record retention requirements states in part, “The recipient and subrecipient must retain all Federal award records for three years from the date of submission of their final financial report. For awards that are renewed quarterly or annually, the recipient and subrecipient must retain records for three years from the date of submission of their quarterly or annual financial report, respectively. Records to be retained include but are not limited to, financial records, supporting documentation, and statistical records. Federal agencies or pass-through entities may not impose any other record retention requirements except for the following: (a) The records must be retained until all litigation, claims, or audit findings involving the records have been resolved and final action taken if any litigation, claim, or audit is started before the expiration of the three-year period.” United States Department of Education website ESSER Annual Reporting states in part, “All grantees are required to report on ESSER funds received under the Coronavirus Aid, Relief, and Economic Security (CARES) Act; the Coronavirus Response and Relief Supplemental Appropriations (CRRSA) Act; and the American Rescue Plan (ARP) Act. Grantees must submit an annual report describing how the State and subrecipients used the awarded funds during the performance period. Similar to CARES Act Year 1 annual reporting, grantees will use the Annual Report Data Collection Tool to submit the State report.” Condition and Context: We were unable to verify compliance with several key line items on the ESSER I, ESSER II, ARP ESSER III, and CRRSA EANS SFY 22 Annual Reports submitted during the audit period due to a lack of supporting documentation (i.e., supporting data and questionnaires sent to LEAs/nonpublic schools to collect the FTE, Student Participation data, and expenditures by category and object code). These key line items include the following: • Line 3.b1 LEA expenditures by category, and object code for ESSER I, ESSER II and ARP ESSER III • Line 3.b10 Number of specific positions supported with ESSER Funds • Line 5.a Full Time Equivalent positions for ESSER I, ESSER II and ARP ESSER III • SEA obligations (including reimbursements) by allowable activity for CRRSA EANS • Other information for Non-public schools receiving services or assistance under CRRSA EANS While documenting controls over the Annual Report we noted one LEA with a subaward/allocation of $16,832,303.63 and re-allocation of $28,177.30 and SFY 22 current expenditures of $5,509,241.03 was not included on the ARP ESSER III Annual Report. While reviewing a sample of 62 of 1,275 LEA subaward allocations and total expenditures reported on the ESSER Annual Reports, we noted the following: • For 25 of 62 (40.32%) subawards tested, the SFY 22 allocations reported on the LEA’s Grant Management System (GMS) application was less than the amount reported on the ESSER II Annual Report, totaling $12,707.62. In addition, OSDE did not provide the supporting documentation for ESSER II re-allocations. Therefore, we were unable to verify whether the total allocation for these LEAs were reported correctly in the ESSER II Annual Report. • For three of 62 (4.84%) subawards tested, the SFY 22 current expenditures reported on the LEA’s GMS Closeout Report or Summary Expenditures reports were less than the amount reported on the ARP ESSER III Annual Report. OSDE was unable to provide support for the variances totaling $218,392.41. Cause: Due to staff turnover and inadequate record retention policies and procedures, OSDE was unable to locate and/or provide all the supporting documentation used by previous staff members to prepare the reports. Effect: The amount reported for the total ARP ESSER III subaward was understated by $16,860,480.93, and the amount reported for the total ARP ESSER III current year expenditures was understated by $5,290,848.62 Information being reported on the USDOE website is not accurate and/or complete. Data previously reported cannot be verified by current staff or other entities required to perform audits or reviews. Recommendation: We recommend OSDE develop and implement appropriate record retention policies and procedures to ensure records are maintained, especially during staff turnovers. We recommend OSDE develop and implement policies and procedures to ensure personnel have an adequate understanding of the requirements for the Annual Report and to ensure the amounts reported are correct. Views of Responsible Official(s) Contact Person: Tammy Smith, Senior Director of Federal Programs | Office of Title Services Anticipated Completion Date: March 2024 Corrective Action Planned: The Oklahoma State Department of Education agrees with the finding. See corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-059 (Partial Repeat 2022-049) STATE AGENCY: Oklahoma State Department of Education (OSDE) FEDERAL AGENCY: United States Department of Education (USDE) ALN: 84.425 – 84.425D, 84.425U; 84.425R FEDERAL PROGRAM NAME: Education Stabilization Fund (ESF) - Elementary and Secondary Schools Emergency Relief Fund (ESSER II); American Rescue Plan – Elementary and Secondary Schools Emergency Relief Fund (ARP ESSER III); Coronavirus Response and Relief Supplemental Appropriations Act, 2021 – Emergency Assistance To Non-Public Schools (CRRSA EANS) FEDERAL AWARD NUMBER: S425D210024; S425U210024 FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: 2 CFR § 200.303(a) – Internal Controls states in part, “The Non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.334 Record retention requirements states in part, “The recipient and subrecipient must retain all Federal award records for three years from the date of submission of their final financial report. For awards that are renewed quarterly or annually, the recipient and subrecipient must retain records for three years from the date of submission of their quarterly or annual financial report, respectively. Records to be retained include but are not limited to, financial records, supporting documentation, and statistical records. Federal agencies or pass-through entities may not impose any other record retention requirements except for the following: (a) The records must be retained until all litigation, claims, or audit findings involving the records have been resolved and final action taken if any litigation, claim, or audit is started before the expiration of the three-year period.” United States Department of Education website ESSER Annual Reporting states in part, “All grantees are required to report on ESSER funds received under the Coronavirus Aid, Relief, and Economic Security (CARES) Act; the Coronavirus Response and Relief Supplemental Appropriations (CRRSA) Act; and the American Rescue Plan (ARP) Act. Grantees must submit an annual report describing how the State and subrecipients used the awarded funds during the performance period. Similar to CARES Act Year 1 annual reporting, grantees will use the Annual Report Data Collection Tool to submit the State report.” Condition and Context: We were unable to verify compliance with several key line items on the ESSER I, ESSER II, ARP ESSER III, and CRRSA EANS SFY 22 Annual Reports submitted during the audit period due to a lack of supporting documentation (i.e., supporting data and questionnaires sent to LEAs/nonpublic schools to collect the FTE, Student Participation data, and expenditures by category and object code). These key line items include the following: • Line 3.b1 LEA expenditures by category, and object code for ESSER I, ESSER II and ARP ESSER III • Line 3.b10 Number of specific positions supported with ESSER Funds • Line 5.a Full Time Equivalent positions for ESSER I, ESSER II and ARP ESSER III • SEA obligations (including reimbursements) by allowable activity for CRRSA EANS • Other information for Non-public schools receiving services or assistance under CRRSA EANS While documenting controls over the Annual Report we noted one LEA with a subaward/allocation of $16,832,303.63 and re-allocation of $28,177.30 and SFY 22 current expenditures of $5,509,241.03 was not included on the ARP ESSER III Annual Report. While reviewing a sample of 62 of 1,275 LEA subaward allocations and total expenditures reported on the ESSER Annual Reports, we noted the following: • For 25 of 62 (40.32%) subawards tested, the SFY 22 allocations reported on the LEA’s Grant Management System (GMS) application was less than the amount reported on the ESSER II Annual Report, totaling $12,707.62. In addition, OSDE did not provide the supporting documentation for ESSER II re-allocations. Therefore, we were unable to verify whether the total allocation for these LEAs were reported correctly in the ESSER II Annual Report. • For three of 62 (4.84%) subawards tested, the SFY 22 current expenditures reported on the LEA’s GMS Closeout Report or Summary Expenditures reports were less than the amount reported on the ARP ESSER III Annual Report. OSDE was unable to provide support for the variances totaling $218,392.41. Cause: Due to staff turnover and inadequate record retention policies and procedures, OSDE was unable to locate and/or provide all the supporting documentation used by previous staff members to prepare the reports. Effect: The amount reported for the total ARP ESSER III subaward was understated by $16,860,480.93, and the amount reported for the total ARP ESSER III current year expenditures was understated by $5,290,848.62 Information being reported on the USDOE website is not accurate and/or complete. Data previously reported cannot be verified by current staff or other entities required to perform audits or reviews. Recommendation: We recommend OSDE develop and implement appropriate record retention policies and procedures to ensure records are maintained, especially during staff turnovers. We recommend OSDE develop and implement policies and procedures to ensure personnel have an adequate understanding of the requirements for the Annual Report and to ensure the amounts reported are correct. Views of Responsible Official(s) Contact Person: Tammy Smith, Senior Director of Federal Programs | Office of Title Services Anticipated Completion Date: March 2024 Corrective Action Planned: The Oklahoma State Department of Education agrees with the finding. See corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-059 (Partial Repeat 2022-049) STATE AGENCY: Oklahoma State Department of Education (OSDE) FEDERAL AGENCY: United States Department of Education (USDE) ALN: 84.425 – 84.425D, 84.425U; 84.425R FEDERAL PROGRAM NAME: Education Stabilization Fund (ESF) - Elementary and Secondary Schools Emergency Relief Fund (ESSER II); American Rescue Plan – Elementary and Secondary Schools Emergency Relief Fund (ARP ESSER III); Coronavirus Response and Relief Supplemental Appropriations Act, 2021 – Emergency Assistance To Non-Public Schools (CRRSA EANS) FEDERAL AWARD NUMBER: S425D210024; S425U210024 FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: 2 CFR § 200.303(a) – Internal Controls states in part, “The Non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.334 Record retention requirements states in part, “The recipient and subrecipient must retain all Federal award records for three years from the date of submission of their final financial report. For awards that are renewed quarterly or annually, the recipient and subrecipient must retain records for three years from the date of submission of their quarterly or annual financial report, respectively. Records to be retained include but are not limited to, financial records, supporting documentation, and statistical records. Federal agencies or pass-through entities may not impose any other record retention requirements except for the following: (a) The records must be retained until all litigation, claims, or audit findings involving the records have been resolved and final action taken if any litigation, claim, or audit is started before the expiration of the three-year period.” United States Department of Education website ESSER Annual Reporting states in part, “All grantees are required to report on ESSER funds received under the Coronavirus Aid, Relief, and Economic Security (CARES) Act; the Coronavirus Response and Relief Supplemental Appropriations (CRRSA) Act; and the American Rescue Plan (ARP) Act. Grantees must submit an annual report describing how the State and subrecipients used the awarded funds during the performance period. Similar to CARES Act Year 1 annual reporting, grantees will use the Annual Report Data Collection Tool to submit the State report.” Condition and Context: We were unable to verify compliance with several key line items on the ESSER I, ESSER II, ARP ESSER III, and CRRSA EANS SFY 22 Annual Reports submitted during the audit period due to a lack of supporting documentation (i.e., supporting data and questionnaires sent to LEAs/nonpublic schools to collect the FTE, Student Participation data, and expenditures by category and object code). These key line items include the following: • Line 3.b1 LEA expenditures by category, and object code for ESSER I, ESSER II and ARP ESSER III • Line 3.b10 Number of specific positions supported with ESSER Funds • Line 5.a Full Time Equivalent positions for ESSER I, ESSER II and ARP ESSER III • SEA obligations (including reimbursements) by allowable activity for CRRSA EANS • Other information for Non-public schools receiving services or assistance under CRRSA EANS While documenting controls over the Annual Report we noted one LEA with a subaward/allocation of $16,832,303.63 and re-allocation of $28,177.30 and SFY 22 current expenditures of $5,509,241.03 was not included on the ARP ESSER III Annual Report. While reviewing a sample of 62 of 1,275 LEA subaward allocations and total expenditures reported on the ESSER Annual Reports, we noted the following: • For 25 of 62 (40.32%) subawards tested, the SFY 22 allocations reported on the LEA’s Grant Management System (GMS) application was less than the amount reported on the ESSER II Annual Report, totaling $12,707.62. In addition, OSDE did not provide the supporting documentation for ESSER II re-allocations. Therefore, we were unable to verify whether the total allocation for these LEAs were reported correctly in the ESSER II Annual Report. • For three of 62 (4.84%) subawards tested, the SFY 22 current expenditures reported on the LEA’s GMS Closeout Report or Summary Expenditures reports were less than the amount reported on the ARP ESSER III Annual Report. OSDE was unable to provide support for the variances totaling $218,392.41. Cause: Due to staff turnover and inadequate record retention policies and procedures, OSDE was unable to locate and/or provide all the supporting documentation used by previous staff members to prepare the reports. Effect: The amount reported for the total ARP ESSER III subaward was understated by $16,860,480.93, and the amount reported for the total ARP ESSER III current year expenditures was understated by $5,290,848.62 Information being reported on the USDOE website is not accurate and/or complete. Data previously reported cannot be verified by current staff or other entities required to perform audits or reviews. Recommendation: We recommend OSDE develop and implement appropriate record retention policies and procedures to ensure records are maintained, especially during staff turnovers. We recommend OSDE develop and implement policies and procedures to ensure personnel have an adequate understanding of the requirements for the Annual Report and to ensure the amounts reported are correct. Views of Responsible Official(s) Contact Person: Tammy Smith, Senior Director of Federal Programs | Office of Title Services Anticipated Completion Date: March 2024 Corrective Action Planned: The Oklahoma State Department of Education agrees with the finding. See corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-059 (Partial Repeat 2022-049) STATE AGENCY: Oklahoma State Department of Education (OSDE) FEDERAL AGENCY: United States Department of Education (USDE) ALN: 84.425 – 84.425D, 84.425U; 84.425R FEDERAL PROGRAM NAME: Education Stabilization Fund (ESF) - Elementary and Secondary Schools Emergency Relief Fund (ESSER II); American Rescue Plan – Elementary and Secondary Schools Emergency Relief Fund (ARP ESSER III); Coronavirus Response and Relief Supplemental Appropriations Act, 2021 – Emergency Assistance To Non-Public Schools (CRRSA EANS) FEDERAL AWARD NUMBER: S425D210024; S425U210024 FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: 2 CFR § 200.303(a) – Internal Controls states in part, “The Non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.334 Record retention requirements states in part, “The recipient and subrecipient must retain all Federal award records for three years from the date of submission of their final financial report. For awards that are renewed quarterly or annually, the recipient and subrecipient must retain records for three years from the date of submission of their quarterly or annual financial report, respectively. Records to be retained include but are not limited to, financial records, supporting documentation, and statistical records. Federal agencies or pass-through entities may not impose any other record retention requirements except for the following: (a) The records must be retained until all litigation, claims, or audit findings involving the records have been resolved and final action taken if any litigation, claim, or audit is started before the expiration of the three-year period.” United States Department of Education website ESSER Annual Reporting states in part, “All grantees are required to report on ESSER funds received under the Coronavirus Aid, Relief, and Economic Security (CARES) Act; the Coronavirus Response and Relief Supplemental Appropriations (CRRSA) Act; and the American Rescue Plan (ARP) Act. Grantees must submit an annual report describing how the State and subrecipients used the awarded funds during the performance period. Similar to CARES Act Year 1 annual reporting, grantees will use the Annual Report Data Collection Tool to submit the State report.” Condition and Context: We were unable to verify compliance with several key line items on the ESSER I, ESSER II, ARP ESSER III, and CRRSA EANS SFY 22 Annual Reports submitted during the audit period due to a lack of supporting documentation (i.e., supporting data and questionnaires sent to LEAs/nonpublic schools to collect the FTE, Student Participation data, and expenditures by category and object code). These key line items include the following: • Line 3.b1 LEA expenditures by category, and object code for ESSER I, ESSER II and ARP ESSER III • Line 3.b10 Number of specific positions supported with ESSER Funds • Line 5.a Full Time Equivalent positions for ESSER I, ESSER II and ARP ESSER III • SEA obligations (including reimbursements) by allowable activity for CRRSA EANS • Other information for Non-public schools receiving services or assistance under CRRSA EANS While documenting controls over the Annual Report we noted one LEA with a subaward/allocation of $16,832,303.63 and re-allocation of $28,177.30 and SFY 22 current expenditures of $5,509,241.03 was not included on the ARP ESSER III Annual Report. While reviewing a sample of 62 of 1,275 LEA subaward allocations and total expenditures reported on the ESSER Annual Reports, we noted the following: • For 25 of 62 (40.32%) subawards tested, the SFY 22 allocations reported on the LEA’s Grant Management System (GMS) application was less than the amount reported on the ESSER II Annual Report, totaling $12,707.62. In addition, OSDE did not provide the supporting documentation for ESSER II re-allocations. Therefore, we were unable to verify whether the total allocation for these LEAs were reported correctly in the ESSER II Annual Report. • For three of 62 (4.84%) subawards tested, the SFY 22 current expenditures reported on the LEA’s GMS Closeout Report or Summary Expenditures reports were less than the amount reported on the ARP ESSER III Annual Report. OSDE was unable to provide support for the variances totaling $218,392.41. Cause: Due to staff turnover and inadequate record retention policies and procedures, OSDE was unable to locate and/or provide all the supporting documentation used by previous staff members to prepare the reports. Effect: The amount reported for the total ARP ESSER III subaward was understated by $16,860,480.93, and the amount reported for the total ARP ESSER III current year expenditures was understated by $5,290,848.62 Information being reported on the USDOE website is not accurate and/or complete. Data previously reported cannot be verified by current staff or other entities required to perform audits or reviews. Recommendation: We recommend OSDE develop and implement appropriate record retention policies and procedures to ensure records are maintained, especially during staff turnovers. We recommend OSDE develop and implement policies and procedures to ensure personnel have an adequate understanding of the requirements for the Annual Report and to ensure the amounts reported are correct. Views of Responsible Official(s) Contact Person: Tammy Smith, Senior Director of Federal Programs | Office of Title Services Anticipated Completion Date: March 2024 Corrective Action Planned: The Oklahoma State Department of Education agrees with the finding. See corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-059 (Partial Repeat 2022-049) STATE AGENCY: Oklahoma State Department of Education (OSDE) FEDERAL AGENCY: United States Department of Education (USDE) ALN: 84.425 – 84.425D, 84.425U; 84.425R FEDERAL PROGRAM NAME: Education Stabilization Fund (ESF) - Elementary and Secondary Schools Emergency Relief Fund (ESSER II); American Rescue Plan – Elementary and Secondary Schools Emergency Relief Fund (ARP ESSER III); Coronavirus Response and Relief Supplemental Appropriations Act, 2021 – Emergency Assistance To Non-Public Schools (CRRSA EANS) FEDERAL AWARD NUMBER: S425D210024; S425U210024 FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: 2 CFR § 200.303(a) – Internal Controls states in part, “The Non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.334 Record retention requirements states in part, “The recipient and subrecipient must retain all Federal award records for three years from the date of submission of their final financial report. For awards that are renewed quarterly or annually, the recipient and subrecipient must retain records for three years from the date of submission of their quarterly or annual financial report, respectively. Records to be retained include but are not limited to, financial records, supporting documentation, and statistical records. Federal agencies or pass-through entities may not impose any other record retention requirements except for the following: (a) The records must be retained until all litigation, claims, or audit findings involving the records have been resolved and final action taken if any litigation, claim, or audit is started before the expiration of the three-year period.” United States Department of Education website ESSER Annual Reporting states in part, “All grantees are required to report on ESSER funds received under the Coronavirus Aid, Relief, and Economic Security (CARES) Act; the Coronavirus Response and Relief Supplemental Appropriations (CRRSA) Act; and the American Rescue Plan (ARP) Act. Grantees must submit an annual report describing how the State and subrecipients used the awarded funds during the performance period. Similar to CARES Act Year 1 annual reporting, grantees will use the Annual Report Data Collection Tool to submit the State report.” Condition and Context: We were unable to verify compliance with several key line items on the ESSER I, ESSER II, ARP ESSER III, and CRRSA EANS SFY 22 Annual Reports submitted during the audit period due to a lack of supporting documentation (i.e., supporting data and questionnaires sent to LEAs/nonpublic schools to collect the FTE, Student Participation data, and expenditures by category and object code). These key line items include the following: • Line 3.b1 LEA expenditures by category, and object code for ESSER I, ESSER II and ARP ESSER III • Line 3.b10 Number of specific positions supported with ESSER Funds • Line 5.a Full Time Equivalent positions for ESSER I, ESSER II and ARP ESSER III • SEA obligations (including reimbursements) by allowable activity for CRRSA EANS • Other information for Non-public schools receiving services or assistance under CRRSA EANS While documenting controls over the Annual Report we noted one LEA with a subaward/allocation of $16,832,303.63 and re-allocation of $28,177.30 and SFY 22 current expenditures of $5,509,241.03 was not included on the ARP ESSER III Annual Report. While reviewing a sample of 62 of 1,275 LEA subaward allocations and total expenditures reported on the ESSER Annual Reports, we noted the following: • For 25 of 62 (40.32%) subawards tested, the SFY 22 allocations reported on the LEA’s Grant Management System (GMS) application was less than the amount reported on the ESSER II Annual Report, totaling $12,707.62. In addition, OSDE did not provide the supporting documentation for ESSER II re-allocations. Therefore, we were unable to verify whether the total allocation for these LEAs were reported correctly in the ESSER II Annual Report. • For three of 62 (4.84%) subawards tested, the SFY 22 current expenditures reported on the LEA’s GMS Closeout Report or Summary Expenditures reports were less than the amount reported on the ARP ESSER III Annual Report. OSDE was unable to provide support for the variances totaling $218,392.41. Cause: Due to staff turnover and inadequate record retention policies and procedures, OSDE was unable to locate and/or provide all the supporting documentation used by previous staff members to prepare the reports. Effect: The amount reported for the total ARP ESSER III subaward was understated by $16,860,480.93, and the amount reported for the total ARP ESSER III current year expenditures was understated by $5,290,848.62 Information being reported on the USDOE website is not accurate and/or complete. Data previously reported cannot be verified by current staff or other entities required to perform audits or reviews. Recommendation: We recommend OSDE develop and implement appropriate record retention policies and procedures to ensure records are maintained, especially during staff turnovers. We recommend OSDE develop and implement policies and procedures to ensure personnel have an adequate understanding of the requirements for the Annual Report and to ensure the amounts reported are correct. Views of Responsible Official(s) Contact Person: Tammy Smith, Senior Director of Federal Programs | Office of Title Services Anticipated Completion Date: March 2024 Corrective Action Planned: The Oklahoma State Department of Education agrees with the finding. See corrective action plan located in the corrective action plan section of this report.
FINDING NO: 2023-059 (Partial Repeat 2022-049) STATE AGENCY: Oklahoma State Department of Education (OSDE) FEDERAL AGENCY: United States Department of Education (USDE) ALN: 84.425 – 84.425D, 84.425U; 84.425R FEDERAL PROGRAM NAME: Education Stabilization Fund (ESF) - Elementary and Secondary Schools Emergency Relief Fund (ESSER II); American Rescue Plan – Elementary and Secondary Schools Emergency Relief Fund (ARP ESSER III); Coronavirus Response and Relief Supplemental Appropriations Act, 2021 – Emergency Assistance To Non-Public Schools (CRRSA EANS) FEDERAL AWARD NUMBER: S425D210024; S425U210024 FEDERAL AWARD YEAR: 2023 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Criteria: 2 CFR § 200.303(a) – Internal Controls states in part, “The Non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.” 2 CFR § 200.334 Record retention requirements states in part, “The recipient and subrecipient must retain all Federal award records for three years from the date of submission of their final financial report. For awards that are renewed quarterly or annually, the recipient and subrecipient must retain records for three years from the date of submission of their quarterly or annual financial report, respectively. Records to be retained include but are not limited to, financial records, supporting documentation, and statistical records. Federal agencies or pass-through entities may not impose any other record retention requirements except for the following: (a) The records must be retained until all litigation, claims, or audit findings involving the records have been resolved and final action taken if any litigation, claim, or audit is started before the expiration of the three-year period.” United States Department of Education website ESSER Annual Reporting states in part, “All grantees are required to report on ESSER funds received under the Coronavirus Aid, Relief, and Economic Security (CARES) Act; the Coronavirus Response and Relief Supplemental Appropriations (CRRSA) Act; and the American Rescue Plan (ARP) Act. Grantees must submit an annual report describing how the State and subrecipients used the awarded funds during the performance period. Similar to CARES Act Year 1 annual reporting, grantees will use the Annual Report Data Collection Tool to submit the State report.” Condition and Context: We were unable to verify compliance with several key line items on the ESSER I, ESSER II, ARP ESSER III, and CRRSA EANS SFY 22 Annual Reports submitted during the audit period due to a lack of supporting documentation (i.e., supporting data and questionnaires sent to LEAs/nonpublic schools to collect the FTE, Student Participation data, and expenditures by category and object code). These key line items include the following: • Line 3.b1 LEA expenditures by category, and object code for ESSER I, ESSER II and ARP ESSER III • Line 3.b10 Number of specific positions supported with ESSER Funds • Line 5.a Full Time Equivalent positions for ESSER I, ESSER II and ARP ESSER III • SEA obligations (including reimbursements) by allowable activity for CRRSA EANS • Other information for Non-public schools receiving services or assistance under CRRSA EANS While documenting controls over the Annual Report we noted one LEA with a subaward/allocation of $16,832,303.63 and re-allocation of $28,177.30 and SFY 22 current expenditures of $5,509,241.03 was not included on the ARP ESSER III Annual Report. While reviewing a sample of 62 of 1,275 LEA subaward allocations and total expenditures reported on the ESSER Annual Reports, we noted the following: • For 25 of 62 (40.32%) subawards tested, the SFY 22 allocations reported on the LEA’s Grant Management System (GMS) application was less than the amount reported on the ESSER II Annual Report, totaling $12,707.62. In addition, OSDE did not provide the supporting documentation for ESSER II re-allocations. Therefore, we were unable to verify whether the total allocation for these LEAs were reported correctly in the ESSER II Annual Report. • For three of 62 (4.84%) subawards tested, the SFY 22 current expenditures reported on the LEA’s GMS Closeout Report or Summary Expenditures reports were less than the amount reported on the ARP ESSER III Annual Report. OSDE was unable to provide support for the variances totaling $218,392.41. Cause: Due to staff turnover and inadequate record retention policies and procedures, OSDE was unable to locate and/or provide all the supporting documentation used by previous staff members to prepare the reports. Effect: The amount reported for the total ARP ESSER III subaward was understated by $16,860,480.93, and the amount reported for the total ARP ESSER III current year expenditures was understated by $5,290,848.62 Information being reported on the USDOE website is not accurate and/or complete. Data previously reported cannot be verified by current staff or other entities required to perform audits or reviews. Recommendation: We recommend OSDE develop and implement appropriate record retention policies and procedures to ensure records are maintained, especially during staff turnovers. We recommend OSDE develop and implement policies and procedures to ensure personnel have an adequate understanding of the requirements for the Annual Report and to ensure the amounts reported are correct. Views of Responsible Official(s) Contact Person: Tammy Smith, Senior Director of Federal Programs | Office of Title Services Anticipated Completion Date: March 2024 Corrective Action Planned: The Oklahoma State Department of Education agrees with the finding. See corrective action plan located in the corrective action plan section of this report.
2023-007 – Internal Control over Reporting Requirements Identification of the Federal Program: Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: County of San Bernadino Community Development and Housing Federal Award Identification Number: ADEL-22-1-03K/0175, ADEL-21-1-05M/5262, ADEL-23-2-05Z/3679 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): In accordance with 2 CFR 200.415 Required Certifications, Subrecipients under the Federal award must certify to the pass-through entity whenever applying for funds, requesting payment, and submitting financial reports. A signature by the responsible official serves as evidence that the reimbursement request has been reviewed and approved in compliance with these requirements. As a subrecipient, the City receives funding on a reimbursement basis. The City prepares the reimbursement package, including all the required supporting documentation. Prior to the submission to the County, the package must be reviewed and approved by the responsible official as evidenced by the signature on the reimbursement request form. Further, pursuant to 2 CFR 200.334 Record retention requirements, the recipient and subrecipient must retain all Federal award records for three years from the date of submission of their final financial report. For awards that are renewed quarterly or annually, the recipient and subrecipient must retain records for three years from the date of submission of their quarterly or annual financial report, respectively. Records to be retained include but are not limited to, financial records, supporting documentation, and statistical records. Condition: During our audit, we noted that one of the reimbursement request forms was submitted to the County without proper signature and certification from the City’s responsible official. Cause: The City does not have adequate internal controls to ensure that reimbursement packages are reviewed and approved by the responsible official prior to submission. Effect or Potential Effect: The absence of certification resulted in noncompliance with the compliance requirement. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommended the City establish internal control procedures to ensure that all reimbursement requests are reviewed and approved by an authorized official prior to submission. Views of Responsible Officials: Management concurs the finding.
2023-008 – Special Tests and Revisions – Internal Control and Compliance over Wage Rate Requirements Identification of the Federal Program: Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grants-Entitlement Grants Cluster Federal Agency: U.S. Department of Housing and Urban Development Pass-Through Entity: County of San Bernadino Community Development and Housing Federal Award Identification Number: ADEL-20-1-03K/0222, ADEL-21-1-03K/0235, and ADEL-22-1-03K/0175 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to 2 CFR 200.334 Record Retention Requirements, the recipient and subrecipient must retain all Federal award records for three years from the date of submission of their final financial report. Further, in accordance with the 2 CFR 200.303 Internal Controls, the recipient and subrecipient must also establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Programs subject to wage-rate rules (e.g., Davis-Bacon Act or program-specific requirements) must maintain weekly certified payrolls and supporting documentation for all working weeks to demonstrate compliance with prevailing wage requirements. Condition: For the fiscal year ended June 30, 2023, the City was unable to provide a complete listing of construction working weeks. The City provided only ten (10) documents supporting wage-rate compliance testing, representing ten (10) working weeks. However, during the audit, we noted that the reimbursement requests submitted by the City covered the period of July 1, 2022 through April 30, 2023, indicating that the documentation provided did not represent the full population of construction activity for the fiscal year. As a result, the auditor was unable to obtain sufficient documentation to determine whether wage-rate requirements were met for all applicable working weeks. Cause: The City did not have adequate internal controls to ensure that documentation for all construction working weeks was tracked, retained, and made available for audit. Effect or Potential Effect: Due to the insufficient documentation provided, the auditor could not determine whether the City complied with wage rate requirements for the fiscal year. Hence, resulted in non-compliance with wage rate documentation requirements, and internal control deficiency related to retention requirements and compliance monitoring. Questioned Costs: None. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommend the City enhance its internal control by implementing policies and procedures to track wage rate requirements compliance, and ensure that all certified payrolls and supporting wage-rate documentation are retained. Views of Responsible Officials: Management concurs with the finding.
Finding 2023-007: Document Retention – Material Weakness Information on the federal program: Federal program is Crime Victim Assistance from the U.S. Department of Justice passed through the Criminal Justice Information Authority. Criteria: Under 2 CFR 200.334, non-federal entities must retain financial and programmatic records, supporting documentation, statistical records, and all other records pertinent to a federal award for the required retention period. Records must be maintained in a manner that allows them to be readily accessible for audit and monitoring purposes. Effective internal controls include maintaining complete, organized, and retrievable documentation to support financial reporting and compliance. Condition: The Organization does not have an effective document retention process or internal controls to ensure that key financial records are consistently preserved, organized, and readily retrievable. Supporting documentation such as invoices, contracts, reconciliations, journal entry support, and grant documentation was frequently incomplete, missing, or delayed in being provided. These gaps resulted in incomplete audit trails and limited management’s ability to demonstrate the completeness, accuracy, and validity of financial information. Cause: The Organization has not designed, implemented, or maintained adequate document retention procedures, nor assigned responsibility to ensure consistent storage, organization, and retrieval of supporting financial documentation. Effect: Without complete and accessible supporting documentation, the Organization cannot substantiate recorded amounts, validate the occurrence or completeness of transactions, or demonstrate the functioning of key internal controls. This increases the risk that material misstatements in the financial statements or noncompliance with federal requirements may not be prevented or detected in a timely manner. Questioned Costs: $29,414 Context: During the audit, we requested various supporting documents needed to verify financial transactions, account balances, and management representations for the period under audit. In multiple instances, the Organization was unable to locate or provide the requested documentation in a timely manner. These difficulties occurred across several financial areas, including invoices, reconciliations, journal entry support, grant-related documentation, and valuation records, indicating that document retention challenges were pervasive rather than isolated to one type of record. Identification as a Repeat Finding: This is not a repeat finding. Recommendation: We recommend that management implement a comprehensive document retention and recordkeeping policy that establishes standardized retention requirements for all key financial documentation, including invoices, contracts, reconciliations, journal entries, and grant support. Management should develop procedures for centralized and secure storage, either physical or electronic, to ensure records are properly preserved and readily accessible. Additionally, periodic monitoring should be performed to confirm compliance with retention procedures, and staff should receive training to reinforce expectations regarding documentation maintenance and timely retrieval. Views of responsible officials and planned corrective actions: Subsequent to this grant commencing, the Organization hired a new grant and partnership specialist. This specialist attaches all relevant support for expenditure to the internal monthly grant reporting and ensures that all expenditures are fully supported by appropriate detail. This detail is on a shared drive with finance and is reviewed by the vice president of finance.
FINDING 2023-004 Subject: Title I Grants to Local Educational Agencies - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A200014, S010A210014, S010A220014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Repeat Findings This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. Condition and Context Costs charged to grant funds must be adequately documented. To adequately document payroll expenses charged to the grant fund, contracts or other documentation supporting the employees' approved rates of pay are necessary. The School Corporation utilized a financial software system that has two different sides, an employee portal side and an administrator side. Employee contracts are approved by the employee, the Superintendent of Schools, and the President of the School Board within the system on the employee portal side. Once approved, the data in the employee portal side is fed into a process in the administrator side. The School Corporation could not provide contracts or approved payroll rates for 6 out of 24 employees tested. As such, we could not verify the employees were paid its correct rates for hours spent working on grant related activities. This resulted in known questioned costs of $149,870. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 24 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 25 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause The School Corporation did not maintain or provide adequate documentation to support payroll expenses charged to the grant fund. While employee contracts are approved within the financial software system, the process lacked sufficient oversight and record retention practices to ensure that approved pay rates were accessible and verifiable. Effect Without access to approved contracts or documentation verifying payroll rates for 6 of the 24 employees tested, the School Corporation could not demonstrate that payroll costs charged to the grant were accurate and allowable. This lack of documentation resulted in known questioned costs totaling $149,870. Additionally, the absence of reliable records increases the risk of noncompliance with federal grant requirements and necessitates expanded audit procedures, which will likely lead to higher audit costs. Questioned Costs Questioned costs in the amount of $149,870 were identified as described in the Condition and Context. Recommendation The School Corporation should establish and enforce formal documentation procedures to verify payroll rates for all employees whose compensation is charged to federal grants. This includes maintaining approved contracts, salary schedules, and supporting records that clearly demonstrate the accuracy and allowability of payroll costs. A review and approval process by a second knowledgeable party should be implemented to ensure compliance prior to submission. Additionally, the School Corporation should provide necessary support and resources for staff involved in payroll and grant management to strengthen recordkeeping practices. These measures will reduce the risk of noncompliance, minimize questioned costs, and help control future audit expenses. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Title I Grants to Local Educational Agencies - Reporting Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A200014, S010A210014, S010A220014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-004. Condition and Context The School Corporation was required to submit reimbursement requests and final expenditure reports that included, among other data, both current and prior period expenditures. However, the required reports for federal awards did not capture all activity for the reporting period and were not supported by the School Corporation's records. Reimbursement Requests The School Corporation uses reimbursement requests to claim allowable expenses paid from Title I funds. These requests must be based on and supported by transactions recorded within the School Corporation's Title I accounts. Summary-level reports were generated from the School Corporation's financial system by the Director of Federal Grants for the reimbursement period and attached to the reimbursement request. While reimbursement requests were to be prepared by the Director of Federal Grants and reviewed by the Title I Director or Title I Budget Supervisor, no evidence of this review or oversight process was available. Of the four reimbursement requests selected for testing, three could not be verified against either the summary-level detail attached to the request or a detailed transaction listing. Because the amounts requested for reimbursement could not be traced to underlying records or to reports that accumulated or summarized the data, the accuracy and completeness of the reimbursement requests could not be verified. Final Expenditure Reports Final expenditure reports were expected to be prepared by the Director of Federal Grants using year-to-date expenditure data and reviewed by either the Director of Internal Audit or the Title I Budget Supervisor. However, no evidence was available to show that this review or oversight process took place. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 29 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Criteria 2 CFR 200.303 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. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (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 §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause The School Corporation did not design or implement an effective internal control system to ensure the accuracy and compliance of reimbursement and final expenditure reporting processes. Specifically, the School Corporation did not have established procedures requiring the retention of detailed supporting documentation for reimbursement requests, and oversight responsibilities were not consistently carried out or evidenced over the reimbursement requests and final expenditure reports. Additionally, the employee responsible for preparing reimbursement requests during the audit period did not maintain the required documentation, and no secondary review process was in place to detect or correct these deficiencies. INDIANA STATE BOARD OF ACCOUNTS 30 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Because the School Corporation did not retain detailed documentation to support reimbursement requests or provide evidence of the required review of final expenditure reports, the audit team could not verify the accuracy, allowability, or completeness of expenditures charged to the grant. These gaps in documentation increased the audit time and administrative burden, as additional testing and follow-up were necessary to address missing records. As a result, the risk of misreporting, misallocation of federal funds, and potential violations of grant requirements were significantly heightened. Questioned Costs There were no questioned costs identified. Recommendation The School Corporation should establish and implement a formal internal control system to ensure accurate financial reporting and compliance with federal grant requirements. This system should include documented review procedures, clear segregation of duties, and consistent oversight of reimbursement requests and expenditure reports. All financial submissions should be supported by verifiable documentation and reconciled with internal records prior to submission. Additionally, the School Corporation should provide necessary support and resources to staff responsible for ensuring grant compliance. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-009 Subject: COVID-19 - Education Stabilization Fund - Allowable Costs/Costs Principles Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U, 84.425C, 84.425W Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013, S425C200018, S425W210015 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Costs Principles Audit Findings: Material Weakness, Other Matters Condition and Context The COVID-19 - Education Stabilization Fund established by the Coronavirus Aid, Relief, and Economic Security (CARES) Act, and further funded by the Coronavirus Response and Relief Supplemental Appropriations Act (CRSSA) and the American Rescue Plan (ARP) Act, was for the purpose of preventing, preparing for, or responding to the novel coronavirus. Based on information obtained during the audit, the scope of testing was expanded to include additional transactions in order to assess compliance with federal grant requirements. The expanded testing was necessary to obtain sufficient evidence regarding the allowability and documentation of grant expenditures. The following issues were noted during testing: Vendor Disbursements The School Corporation was unable to provide supporting documentation for three vendors tested: Mamas Against Violence, LTIA, and Kingdom Life. Although Memorandums of Understanding (MOUs) were initiated by the Treasurer, no evidence was provided to demonstrate that the MOUs were reviewed or approved by the School Board at the time of execution. Information provided was based on documentation generated by the School Corporation, including purchase orders, handwritten vendor claim forms, and copies of check payments. However, no itemized vendor invoices were submitted to substantiate the services provided or the payments made, nor to detail the nature of the services rendered. In addition, the School Corporation was unable to provide supporting documentation to verify student participation or substantiate any of the reported metrics associated with the MOU agreements. Payroll Records Out of ten additional payroll transactions tested, three employee pay rates could not be verified. One employee's pay rate did not agree with the salary ordinance, and the School Corporation was unable to provide documentation confirming School Board approval of the rate. The second employee's compensation could not be traced to specific work performed, as neither an hourly rate nor the number of hours worked was documented. The third employee's authorized salary was $30 per hour; however, the issued paycheck reflected $20 per hour. These issues combined resulted in known questioned costs of $38,400. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 35 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 36 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause The School Corporation demonstrated weaknesses in documentation and compliance practices. Vendor contracts and payments lacked adequate supporting records, including evidence of the School Board approval for MOUs and itemized invoices. The School Board approved pay rates, hours worked, and reconciliation of authorized salaries to amounts paid, limiting the ability to verify the accuracy and appropriateness of expenditures. Effect Without proper documentation, the allowability of grant expenditures cannot be substantiated, creating a risk that unallowable costs may be charged to the federal grant. In addition, incomplete payroll records prevent verification of compensation, heightening the risk of inaccurate payments, unsupported variances, and potential misuse of federal funds. Questioned Costs Questioned costs in the amount of $38,400 were identified as described in the Condition and Context. Recommendation To address these deficiencies, the School Corporation should strengthen documentation practices by ensuring all vendor contracts, MOUs, and invoices are properly reviewed, approved by the School Board, and retained. Payroll internal controls should be improved by reconciling authorized salary ordinances to actual pay rates, documenting hours worked, and retaining evidence of the School Board approval for all compensation. In addition, periodic monitoring and internal reviews should be implemented to verify adherence to federal grant requirements and School Corporation policies, thereby reducing the risk of noncompliance and enhancing accountability. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-010 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U, 84.425C, 84.425W Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013, S425C200018, S425W210015 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-007. INDIANA STATE BOARD OF ACCOUNTS 37 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted one ESSER I report, one ESSER II report, and one ESSER III report, for a total of three reports. An effective internal control system was not in place at the School Corporation to ensure these reports were accurate. As such, the annual data reports were prepared and submitted to the IDOE without an oversight or review process to prevent or detect and correct errors. All three reports submitted during the audit period were not supported by the School Corporation's records. The following errors were identified: The ESSER I, Year 3 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $1,526,046 in expenditures. However, actual expenditures for the applicable reporting period totaled $1,601,347. The ESSER II, Year 2 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $10,293,210 in expenditures. However, actual expenditures for the applicable reporting period totaled $9,750,555. The ESSER III, Year 2 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $15,939,167 in expenditures. However, actual expenditures for the applicable reporting period totaled $17,220,521. During the audit period, the School Corporation also received eight total reimbursements related to the COVID-19 - Education Stabilization Fund grant. The School Corporation received two GEER reimbursements, two ESSER I reimbursements, two ESSER II reimbursements, two ESSER III reimbursements, and 2 ARP HCY reimbursements. All reimbursement request forms were tested against the School Corporations records for accuracy. Of the eight reimbursements requested, six forms tested were not supported by the School Corporation's records. The following errors were identified: GEER reimbursement requests forms were overstated by $3,580 compared to the School Corporation's records. ESSER I reimbursement request forms were $860,284 overstated compared to the School Corporation's records. ESSER II reimbursement request forms were overstated by $221,808 compared to the School Corporation's records. ESSER III reimbursement request forms were understated by $220,484 compared to the School Corporation's records. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 38 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Criteria 2 CFR 200.303 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. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following. . . . (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 §§ 200.328 and 200.329. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause The School Corporation did not establish or implement a properly designed internal control system, including appropriate segregation of duties, to ensure the accuracy and reliability of financial data submitted to the IDOE. The absence of formal review procedures, oversight mechanisms, and reconciliation processes resulted in the submission of materially misstated annual data reports and reimbursement requests. Contributing factors included inadequate staff training on federal reporting requirements, the lack of documented financial reporting policies, and insufficient allocation of resources to monitor compliance with grant guidelines. Effect As a result, the annual data reports submitted to the IDOE via JotForm were materially misstated and lacked proper support from the School Corporation's financial records. Additionally, six out of eight reimbursement request forms tested during the audit period were either overstated or understated, reflecting inconsistent and inaccurate financial reporting tied to federal grant activity. These systemic errors represent significant noncompliance and undermine the reliability of reporting used for state and federal oversight. INDIANA STATE BOARD OF ACCOUNTS 39 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified Recommendation The School Corporation should strengthen its financial reporting processes related to federal grant activity by implementing a formal internal control system that ensures accuracy, consistency, and proper documentation. This includes reconciling financial records with data submitted through JotForm, establishing review procedures for reimbursement requests, and assigning qualified personnel to verify all reports prior to submission. Staff responsible for grant management and financial reporting should receive necessary support and resources regarding federal documentation standards and reporting requirements. The School Corporation should adopt standardized documentation policies and procedures across all departments to ensure compliance and oversight. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
2023-001 Improve Internal Controls and Documentation over Allowable Costs and Eligibility Determinations Federal Program Information Federal Agency: Department of the Treasury Award Name: COVID-19 Emergency Rental Assistance Program Assistance Listing Number: 21.023 Award Year: 2022 Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles, Eligibility Type of Finding Compliance Internal Control over Compliance – Significant Deficiency Criteria or Specific Requirement Per 2 CFR 200.303, the County is required to establish and maintain effective internal controls over federal programs to provide reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of the award. Additionally, 2 CFR 200.334 requires the retention of records and supporting documentation to demonstrate eligibility determinations and allowability of expenditures under the program. Condition and Context During our audit, we tested a sample of 40 selections for allowable costs, as well as a sample of 40 for individual eligibility determinations under the program in which 38 selections were leveraged between the two tests. For 1 of the items selected for testing under allowable cost compliance and eligibility requirements, the County was unable to provide some of the required supporting documentation to demonstrate that individuals met the program’s eligibility requirements. However, lease agreements supporting the amount ultimately paid to the individual were provided to support allowability. The documentation was retained in an online portal to which the County no longer had access at the time of our audit procedures. Cause The County did not establish sufficient procedures or controls to ensure ongoing access to required supporting documentation maintained in the external portal used for program administration. Effect or Potential Effect Due to the weakness in internal controls noted above, the County could not demonstrate compliance with eligibility requirements for the sampled transaction. This also constitutes noncompliance with record retention requirements and impairs the ability for sufficient procedures to be performed over the program. Questioned Costs None reported. Identification as a Repeat Finding This is a repeat of finding 2022-002. Recommendation The County should implement policies and procedures to ensure required documentation for the program is retained in a manner that ensures continued access, even if administration platforms change or external portals are no longer accessible. The County should also periodically verify that it retains all necessary support for program transactions as required under federal regulations. Views of Responsible Official and Planned Corrective Action Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.
Criteria Under 2 CFR 200.303, non-Federal entities are required to establish and maintain effective internal controls over Federal awards. In addition, 2 CFR 200.334 requires financial and programmatic records supporting Federal awards to be retained and made available for examination. Condition During testing of expenditures and related reimbursement requests for compliance with the period of performance compliance requirement, the Organization was unable to provide the original reimbursement request summary supporting certain selected drawdowns. Management subsequently regenerated expenditure detail for the applicable billing periods and provided supporting documentation supporting eligible program expenditures in excess of the amounts requested for reimbursement. Cause The Organization did not maintain adequate controls to ensure reimbursement request documentation was retained and readily accessible to support amounts claimed under the Federal award. Effect The inability to maintain and readily provide supporting reimbursement documentation increases the risk that noncompliance with Federal program requirements may not be timely detected and may impair monitoring and audit activities. The lack of retained documentation also limits the ability to efficiently demonstrate compliance with Federal award requirements. Recommendation We recommend that the Organization strengthen document retention procedures to ensure reimbursement request packages and supporting documentation are maintained and readily accessible for review to support federal expenditures and reimbursement requests. Views of Responsible Officials and Planned Corrective Action Management agrees with the finding and will implement procedures to ensure reimbursement request documentation and supporting schedules are retained in a centralized location and readily accessible for future monitoring and audit purposes.
FINDING 2022-003 Subject: CDBG - Entitlement Grants Cluster - Reporting Federal Agency: Department of Housing and Urban Development Federal Program: Community Development Block Grants/Entitlement Grants Assistance Listings Number: 14.218 Federal Award Numbers and Years (or Other Identifying Numbers): B-20-MC-0010, B-21-MC-18-0010, B-22-MC-18-0010, M-20-MW-18-0010 Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2021-003. Condition and Context The City had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties that would likely be effective in preventing, or detecting and correcting, noncompliance. Recipients are required to submit financial, performance, and special reports annually or quarterly depending on the specifics of their CDBG - Entitlement Grant. Financial reports are entered into the Integrated Disbursement and Information System (IDIS). Grantees may include reports generated by the IDIS as part of their annual performance and evaluation reports that must be submitted 90 days after the end of the grantee's program year. Information to be tested from the IDIS is in the following system-generated reports: PR-26 - CDBG Financial Summary Report, PR26 - CDBG-CV Financial Summary Report, PR-26 CDBG Activity Summary by Selected Grant, PR-29 CDBG Cash on Hand Quarterly Reporting, and the PR-29 CDBG-CV Cash on Hand Quarterly Report. In addition, under the Federal Funding Accountability and Transparency Act (FFATA) grantees are required to report first-tier subawards of $30,000 or more to the FFATA Subaward System. The City, based on the grants received, was required to submit the following reports during the audit period: the PR-29 CDBG Cash on Hand Quarterly Report, the PR-26 CDBG Financial Summary Report, and the FFATA reports. PR-29 CDBG CV Cash on Hand Reporting The City submitted the four required quarterly reports; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent, or detect and correct, errors. Federal Funding and Transparency Act (FFATA) Reporting The City submitted the two required FFATA reports for the two subaward recipients that received over $30,000. Although the reports were prepared by one individual and approved by another, the internal control was not effective and did not detect and allow correction of errors prior to submission. Due to the lack of effective internal controls the following key data elements were missing: Subawardee DUNS number, Subaward obligation/action date, and the date of report submission (report submitted timely). The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 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. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 170, Appendix A(I)(a) states in part: "Reporting of first-tier subawards. Applicability. Unless you are exempt as provided in paragraph d. of this award term, you must report each action that equals or exceeds $30,000 in Federal funds for a subaward to a non- Federal entity or Federal agency . . . 2. Where and when to report. i. The non-Federal entity or Federal agency must report each obligating action described in paragraph a.1. of this award term to http://www.fsrs.gov. ii. For subaward information, report no later than the end of the month following the month in which the obligation was made. (For example, if the obligation was made on November 7, 2010, the obligation must be reported by no later than December 31, 2010.) 3. What to report. You must report the information about each obligating action that the submission instructions posted at http://www.fsrs.gov specify . . ." Cause A proper system of internal controls was not designed by management of the City, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the City's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not filed timely with all required key line items. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the City. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City establish a proper system of internal controls, including strengthening their policies and procedures to ensure all required reports are filed and all required information is provided and supported by the City's records in a timely manner. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 Subject: Medicaid Cluster - Reporting Federal Agency: Department of Health and Human Services Federal Program: Medical Assistance Program Assistance Listings Number: 93.778 Federal Award Number and Year (or Other Identifying Number): FY2022 Pass-Through Entity: Indiana Family and Social Services Administration Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The Township had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties that would likely be effective in preventing, or detecting and correcting, material noncompliance related to expenditures made from the Medicaid Cluster. The Medicaid Cluster consists of three federal programs. However, the Township received funding from only one program, the Medicaid Assistance Program. The Medicaid Assistance Program grant funding is provided by the Indiana Family and Social Services Administration (FSSA) to Freestanding Governmental Ambulance Providers, such as the Township, based on a Cost Report for funding. The Cost Report for funding utilizes all costs associated with the operation of the Township's ambulance program in conjunction with other metrics such as ambulance runs, total charges, and Medicaid charges to determine the federal ambulance payment adjustment, the amount received by the Township. The Township utilized its Fire Operations fund to account for both fire and ambulance services. Costs were allocated between fire and ambulance services as necessary. Expenditures related to ambulance services were included in the Township's Cost Report to determine the reimbursement due to the Township. The funding received during the audit period was based on expenditures and data from January 1, 2019 to December 31, 2019, and as such, internal controls for that period were reviewed. The Cost Report for the Medicaid Program was prepared by the Township's contracted CPA firm using information provided by the Township. The Township provided reports detailing run data, expenditures, and charges (both Medicaid and non-Medicaid) to the CPA firm. The CPA firm prepared the report and submitted it to the Indiana FSSA. The Township did not participate in the preparation or submission process, nor complete a review of the report prior to submission. As such, the Township could not ensure that the information provided was properly utilized or that the report was accurate. Additionally, for five of the seven key line items tested, the Township could not provide supporting documentation. The lack of supporting documentation for Ambulance Runs, Fire Runs, EMT Salaries, Fire Salaries, and Total Ambulance Cost on the 2019 Cost Report prevented the determination of the accuracy of these line items. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 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. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. Federal awarding agencies and pass-through entities must not impose any other record retention requirements upon non-Federal entities. . . ." Cause A proper system of internal controls over the Medicaid Cluster expenditures was not designed by management of the Township, which would include segregation of key functions to ensure the Medicaid Cluster funds were appropriately reported. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the Township's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the Township. In addition, not supporting key line items increases the likelihood that information is not accurate and properly reported to FSSA and the public. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the Township design and implement a proper system of internal controls that would provide segregation of duties for the preparation of the Cost Report for Reimbursement for the Medicaid Cluster awards. Additionally, policies and procedures should be implemented to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-004 Subject: Staffing for Adequate Fire and Emergency Response (SAFER) - Cash Management Federal Agency: Department of Homeland Security Federal Program: Staffing for Adequate Fire and Emergency Response (SAFER) Assistance Listings Number: 97.083 Federal Award Number and Year (or Other Identifying Number): EMW-2019-FF-00944 Compliance Requirement: Cash Management Audit Findings: Material Weakness, Modified Opinion Condition and Context The Township submits request for reimbursements to the Federal Emergency Management Agency of the Department of Homeland Security. The reimbursement method of cash management requires the Township to retain supporting documentation that shows the costs for which reimbursement was requested were paid prior to the reimbursement date. The Township was awarded a SAFER grant to increase the number of firefighters and was approved for personnel and fringe benefits costs, which includes health insurance, for nine additional firefighters. The Township is self-insured and would make payments to third-party administrators and other benefit coordinators. The Township would pay a large dollar amount at the end of each year to its selfinsurance benefit coordinators for the next year's benefit, and then additional payments throughout the year as needed for employee's medical claim coverage. These payments were made from various Township funds and the Payroll Deductions fund. Additionally, the payroll deductions for health insurance, including those for employees paid from the grant, would accumulate in the Payroll Deductions fund, and be used for payments to the benefit coordinators as needed and the payment of the next year's required funding. The amount submitted for reimbursement for health insurance benefits were based upon a calculation. The Township did not have supporting documentation for the calculation of those benefits that were claimed. In addition, the health insurance benefits claimed for reimbursement were not paid out of the SAFER Grant Fund and were not at a transaction level in the ledger. The health insurance benefit submitted for reimbursement could not be tied to a specific payment; thus, we were unable to determine the Township's compliance for the health benefit reimbursements being incurred and paid prior to the Township's request for reimbursement. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 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. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302 states in part: "(a) Each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. See also ? 200.450. (b) The financial management system of each non-Federal entity must provide for the following (see also ?? 200.334, 200.335, 200.336, and 200.337): (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number and year, name of the Federal agency, and name of the pass-through entity, if any. (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 ?? 200.328 and 200.329. If a Federal awarding agency requires reporting on an accrual basis from a recipient that maintains its records on other than an accrual basis, the recipient must not be required to establish an accrual accounting system. This recipient may develop accrual data for its reports on the basis of an analysis of the documentation on hand. Similarly, a pass-through entity must not require a subrecipient to establish an accrual accounting system and must allow the subrecipient to develop accrual data for its reports on the basis of an analysis of the documentation on hand. (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. (4) Effective control over, and accountability for, all funds, property, and other assets. The non-Federal entity must adequately safeguard all assets and assure that they are used solely for authorized purposes. See ? 200.303. . . ." Cause A system of internal controls was not designed or implemented by management of the Township which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect management's expectation of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, health insurance benefits were requested for reimbursement without adequate supporting documentation that the amount was paid prior to the request. Noncompliance with the grant agreement and the cash management compliance requirement could result in the loss of future federal funds to the Township. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the Township establish a proper system of internal controls and develop policies and procedures to ensure expenses are paid prior to requesting reimbursement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
2022-003 Filing system and document retention. CURRENT CONDITION: The Housing Authority of the City of Greeley was unable to efficiently locate documents for the audit. CFDA#: 14.850, 14.871 CRITERIA: 24 CFR section 200.334 requires the retention of supporting documentation. CAUSE: The Authority did not have procedures or controls in place to systematically file information. EFFECT: Documents could not be located in a timely fashion. RECOMMENDATION: The Authority should standardize procedures and employee responsibilities. VIEWS OF RESPONSIBLE OFFICIALS: We will comply with the Auditor?s recommendation. DISCUSSED WITH: Tom Teixeira, September 15, 2022
FINDING 2022-001 DOCUMENT RETENTION SIGNIFICANT DEFICIENCY Federal Program: Child Care Development Block Grant Assistance Listing Number: 93.575 Criteria Per 7 CFR 200.334, ?Financial records, supporting documents, statistical records, and all other non- Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.? Condition Salary expenses were included in the administrative costs applied to the program. Employees were to be applied to the program based on percentages set in the grant budget. IAN did not maintain documentation to support the amounts for each employee applied to the program during the year. Total payroll costs were provided for these employees. It was determined that total salary expenses applied to the grant were within the budget allotment, and no questioned costs were identified. Cause IAN did not maintain documentation to show amounts applied to the program by individual employees. Effect We were unable to see how much of each employee?s salary was specifically applied to the grant. Recommendation We recommend IAN develop internal controls requiring the maintenance of documentation to support employee allocations to federal programs. Views of Responsible Officials The School?s Corrective Action Plan is included on page 25.
#2022-011 - Major Federal Award Finding - Document Retention Nature of Finding: Compliance Finding - Uniform Guidance Administrative Requirements and Material Weakness in Internal Controls Over Compliance Criteria/Condition: Federal regulations 2 CFR 200.334 provides that a non-federal entity must retain all records pertinent to a federal award for a minimum period of three years from the date of submission of the annual financial report. We noted during testing that records were not consistently being maintained. Cause/Context: For 2 of the 40 expenditures selected for testing, the Organization was unable to provide appropriate invoice documentation supporting the amount charged to the grant. Effect: Federal expenditures could be charged to the grant at incorrect amounts or for unallowable costs. Recommendation: We recommend the Organization implement a document retention policy that is consistent with the federal document retention requirements. Views of Responsible Officials and Planned Corrective Actions: MARR will retain a CPA consultant to implement a document retention policy that is consistent with federal document retention requirements.
#2022-011 - Major Federal Award Finding - Document Retention Nature of Finding: Compliance Finding - Uniform Guidance Administrative Requirements and Material Weakness in Internal Controls Over Compliance Criteria/Condition: Federal regulations 2 CFR 200.334 provides that a non-federal entity must retain all records pertinent to a federal award for a minimum period of three years from the date of submission of the annual financial report. We noted during testing that records were not consistently being maintained. Cause/Context: For 2 of the 40 expenditures selected for testing, the Organization was unable to provide appropriate invoice documentation supporting the amount charged to the grant. Effect: Federal expenditures could be charged to the grant at incorrect amounts or for unallowable costs. Recommendation: We recommend the Organization implement a document retention policy that is consistent with the federal document retention requirements. Views of Responsible Officials and Planned Corrective Actions: MARR will retain a CPA consultant to implement a document retention policy that is consistent with federal document retention requirements.
FINDING 2022-003 Subject: CDBG - Entitlement Grants Cluster - Reporting Federal Agency: Department of Housing and Urban Development Federal Program: Community Development Block Grants/Entitlement Grants Assistance Listings Number: 14.218 Federal Award Numbers and Years (or Other Identifying Numbers): B-20-MC-0010, B-21-MC-18-0010, B-22-MC-18-0010, M-20-MW-18-0010 Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2021-003. Condition and Context The City had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties that would likely be effective in preventing, or detecting and correcting, noncompliance. Recipients are required to submit financial, performance, and special reports annually or quarterly depending on the specifics of their CDBG - Entitlement Grant. Financial reports are entered into the Integrated Disbursement and Information System (IDIS). Grantees may include reports generated by the IDIS as part of their annual performance and evaluation reports that must be submitted 90 days after the end of the grantee's program year. Information to be tested from the IDIS is in the following system-generated reports: PR-26 - CDBG Financial Summary Report, PR26 - CDBG-CV Financial Summary Report, PR-26 CDBG Activity Summary by Selected Grant, PR-29 CDBG Cash on Hand Quarterly Reporting, and the PR-29 CDBG-CV Cash on Hand Quarterly Report. In addition, under the Federal Funding Accountability and Transparency Act (FFATA) grantees are required to report first-tier subawards of $30,000 or more to the FFATA Subaward System. The City, based on the grants received, was required to submit the following reports during the audit period: the PR-29 CDBG Cash on Hand Quarterly Report, the PR-26 CDBG Financial Summary Report, and the FFATA reports. PR-29 CDBG CV Cash on Hand Reporting The City submitted the four required quarterly reports; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent, or detect and correct, errors. Federal Funding and Transparency Act (FFATA) Reporting The City submitted the two required FFATA reports for the two subaward recipients that received over $30,000. Although the reports were prepared by one individual and approved by another, the internal control was not effective and did not detect and allow correction of errors prior to submission. Due to the lack of effective internal controls the following key data elements were missing: Subawardee DUNS number, Subaward obligation/action date, and the date of report submission (report submitted timely). The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 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. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 170, Appendix A(I)(a) states in part: "Reporting of first-tier subawards. Applicability. Unless you are exempt as provided in paragraph d. of this award term, you must report each action that equals or exceeds $30,000 in Federal funds for a subaward to a non- Federal entity or Federal agency . . . 2. Where and when to report. i. The non-Federal entity or Federal agency must report each obligating action described in paragraph a.1. of this award term to http://www.fsrs.gov. ii. For subaward information, report no later than the end of the month following the month in which the obligation was made. (For example, if the obligation was made on November 7, 2010, the obligation must be reported by no later than December 31, 2010.) 3. What to report. You must report the information about each obligating action that the submission instructions posted at http://www.fsrs.gov specify . . ." Cause A proper system of internal controls was not designed by management of the City, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the City's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not filed timely with all required key line items. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the City. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City establish a proper system of internal controls, including strengthening their policies and procedures to ensure all required reports are filed and all required information is provided and supported by the City's records in a timely manner. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 Subject: Medicaid Cluster - Reporting Federal Agency: Department of Health and Human Services Federal Program: Medical Assistance Program Assistance Listings Number: 93.778 Federal Award Number and Year (or Other Identifying Number): FY2022 Pass-Through Entity: Indiana Family and Social Services Administration Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The Township had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties that would likely be effective in preventing, or detecting and correcting, material noncompliance related to expenditures made from the Medicaid Cluster. The Medicaid Cluster consists of three federal programs. However, the Township received funding from only one program, the Medicaid Assistance Program. The Medicaid Assistance Program grant funding is provided by the Indiana Family and Social Services Administration (FSSA) to Freestanding Governmental Ambulance Providers, such as the Township, based on a Cost Report for funding. The Cost Report for funding utilizes all costs associated with the operation of the Township's ambulance program in conjunction with other metrics such as ambulance runs, total charges, and Medicaid charges to determine the federal ambulance payment adjustment, the amount received by the Township. The Township utilized its Fire Operations fund to account for both fire and ambulance services. Costs were allocated between fire and ambulance services as necessary. Expenditures related to ambulance services were included in the Township's Cost Report to determine the reimbursement due to the Township. The funding received during the audit period was based on expenditures and data from January 1, 2019 to December 31, 2019, and as such, internal controls for that period were reviewed. The Cost Report for the Medicaid Program was prepared by the Township's contracted CPA firm using information provided by the Township. The Township provided reports detailing run data, expenditures, and charges (both Medicaid and non-Medicaid) to the CPA firm. The CPA firm prepared the report and submitted it to the Indiana FSSA. The Township did not participate in the preparation or submission process, nor complete a review of the report prior to submission. As such, the Township could not ensure that the information provided was properly utilized or that the report was accurate. Additionally, for five of the seven key line items tested, the Township could not provide supporting documentation. The lack of supporting documentation for Ambulance Runs, Fire Runs, EMT Salaries, Fire Salaries, and Total Ambulance Cost on the 2019 Cost Report prevented the determination of the accuracy of these line items. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 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. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. Federal awarding agencies and pass-through entities must not impose any other record retention requirements upon non-Federal entities. . . ." Cause A proper system of internal controls over the Medicaid Cluster expenditures was not designed by management of the Township, which would include segregation of key functions to ensure the Medicaid Cluster funds were appropriately reported. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the Township's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the Township. In addition, not supporting key line items increases the likelihood that information is not accurate and properly reported to FSSA and the public. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the Township design and implement a proper system of internal controls that would provide segregation of duties for the preparation of the Cost Report for Reimbursement for the Medicaid Cluster awards. Additionally, policies and procedures should be implemented to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-004 Subject: Staffing for Adequate Fire and Emergency Response (SAFER) - Cash Management Federal Agency: Department of Homeland Security Federal Program: Staffing for Adequate Fire and Emergency Response (SAFER) Assistance Listings Number: 97.083 Federal Award Number and Year (or Other Identifying Number): EMW-2019-FF-00944 Compliance Requirement: Cash Management Audit Findings: Material Weakness, Modified Opinion Condition and Context The Township submits request for reimbursements to the Federal Emergency Management Agency of the Department of Homeland Security. The reimbursement method of cash management requires the Township to retain supporting documentation that shows the costs for which reimbursement was requested were paid prior to the reimbursement date. The Township was awarded a SAFER grant to increase the number of firefighters and was approved for personnel and fringe benefits costs, which includes health insurance, for nine additional firefighters. The Township is self-insured and would make payments to third-party administrators and other benefit coordinators. The Township would pay a large dollar amount at the end of each year to its selfinsurance benefit coordinators for the next year's benefit, and then additional payments throughout the year as needed for employee's medical claim coverage. These payments were made from various Township funds and the Payroll Deductions fund. Additionally, the payroll deductions for health insurance, including those for employees paid from the grant, would accumulate in the Payroll Deductions fund, and be used for payments to the benefit coordinators as needed and the payment of the next year's required funding. The amount submitted for reimbursement for health insurance benefits were based upon a calculation. The Township did not have supporting documentation for the calculation of those benefits that were claimed. In addition, the health insurance benefits claimed for reimbursement were not paid out of the SAFER Grant Fund and were not at a transaction level in the ledger. The health insurance benefit submitted for reimbursement could not be tied to a specific payment; thus, we were unable to determine the Township's compliance for the health benefit reimbursements being incurred and paid prior to the Township's request for reimbursement. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 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. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302 states in part: "(a) Each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. See also ? 200.450. (b) The financial management system of each non-Federal entity must provide for the following (see also ?? 200.334, 200.335, 200.336, and 200.337): (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number and year, name of the Federal agency, and name of the pass-through entity, if any. (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 ?? 200.328 and 200.329. If a Federal awarding agency requires reporting on an accrual basis from a recipient that maintains its records on other than an accrual basis, the recipient must not be required to establish an accrual accounting system. This recipient may develop accrual data for its reports on the basis of an analysis of the documentation on hand. Similarly, a pass-through entity must not require a subrecipient to establish an accrual accounting system and must allow the subrecipient to develop accrual data for its reports on the basis of an analysis of the documentation on hand. (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. (4) Effective control over, and accountability for, all funds, property, and other assets. The non-Federal entity must adequately safeguard all assets and assure that they are used solely for authorized purposes. See ? 200.303. . . ." Cause A system of internal controls was not designed or implemented by management of the Township which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect management's expectation of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, health insurance benefits were requested for reimbursement without adequate supporting documentation that the amount was paid prior to the request. Noncompliance with the grant agreement and the cash management compliance requirement could result in the loss of future federal funds to the Township. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the Township establish a proper system of internal controls and develop policies and procedures to ensure expenses are paid prior to requesting reimbursement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
2022-003 Filing system and document retention. CURRENT CONDITION: The Housing Authority of the City of Greeley was unable to efficiently locate documents for the audit. CFDA#: 14.850, 14.871 CRITERIA: 24 CFR section 200.334 requires the retention of supporting documentation. CAUSE: The Authority did not have procedures or controls in place to systematically file information. EFFECT: Documents could not be located in a timely fashion. RECOMMENDATION: The Authority should standardize procedures and employee responsibilities. VIEWS OF RESPONSIBLE OFFICIALS: We will comply with the Auditor?s recommendation. DISCUSSED WITH: Tom Teixeira, September 15, 2022
FINDING 2022-001 DOCUMENT RETENTION SIGNIFICANT DEFICIENCY Federal Program: Child Care Development Block Grant Assistance Listing Number: 93.575 Criteria Per 7 CFR 200.334, ?Financial records, supporting documents, statistical records, and all other non- Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.? Condition Salary expenses were included in the administrative costs applied to the program. Employees were to be applied to the program based on percentages set in the grant budget. IAN did not maintain documentation to support the amounts for each employee applied to the program during the year. Total payroll costs were provided for these employees. It was determined that total salary expenses applied to the grant were within the budget allotment, and no questioned costs were identified. Cause IAN did not maintain documentation to show amounts applied to the program by individual employees. Effect We were unable to see how much of each employee?s salary was specifically applied to the grant. Recommendation We recommend IAN develop internal controls requiring the maintenance of documentation to support employee allocations to federal programs. Views of Responsible Officials The School?s Corrective Action Plan is included on page 25.
#2022-011 - Major Federal Award Finding - Document Retention Nature of Finding: Compliance Finding - Uniform Guidance Administrative Requirements and Material Weakness in Internal Controls Over Compliance Criteria/Condition: Federal regulations 2 CFR 200.334 provides that a non-federal entity must retain all records pertinent to a federal award for a minimum period of three years from the date of submission of the annual financial report. We noted during testing that records were not consistently being maintained. Cause/Context: For 2 of the 40 expenditures selected for testing, the Organization was unable to provide appropriate invoice documentation supporting the amount charged to the grant. Effect: Federal expenditures could be charged to the grant at incorrect amounts or for unallowable costs. Recommendation: We recommend the Organization implement a document retention policy that is consistent with the federal document retention requirements. Views of Responsible Officials and Planned Corrective Actions: MARR will retain a CPA consultant to implement a document retention policy that is consistent with federal document retention requirements.
#2022-011 - Major Federal Award Finding - Document Retention Nature of Finding: Compliance Finding - Uniform Guidance Administrative Requirements and Material Weakness in Internal Controls Over Compliance Criteria/Condition: Federal regulations 2 CFR 200.334 provides that a non-federal entity must retain all records pertinent to a federal award for a minimum period of three years from the date of submission of the annual financial report. We noted during testing that records were not consistently being maintained. Cause/Context: For 2 of the 40 expenditures selected for testing, the Organization was unable to provide appropriate invoice documentation supporting the amount charged to the grant. Effect: Federal expenditures could be charged to the grant at incorrect amounts or for unallowable costs. Recommendation: We recommend the Organization implement a document retention policy that is consistent with the federal document retention requirements. Views of Responsible Officials and Planned Corrective Actions: MARR will retain a CPA consultant to implement a document retention policy that is consistent with federal document retention requirements.
Finding 2022-005: Insufficient Support for Costs Charged to Federal Award Programs Federal Agency: U.S. Department of the Treasury Assistance Listing Number: 21.027 Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Pass-through Entity: Snohomish County Human Services Pass-through Award Number: EL-22-AR-11-394 Criteria: Under 2 CFR 200.334, financial records and other supporting documents must be retained for a period of three years from the date of the submission of the annual financial report. Condition: Invoices, check copies, and other source documents could not be located to support the allowability of the costs charged to the major federal award program. Cause: The Organization had limited management and administrative staff and did not utilize a formal recordkeeping system during the year ended December 31, 2022. Further, as described in finding 2022-001, there were no written policies and procedures in place. Effect: Inadequate source documentation for costs charged to federal award programs may lead to findings in monitoring performed by oversight agencies and potential disallowed costs and/or decreases in future federal funding. Questioned Costs: Source documents could not be located for costs totaling $99,444, which represents 50% of our sample of transactions tested. Recommendation: We recommend that management implements and follows a formal record retention policy and retains receipts, invoices, and other source documents for costs charged to federal awards for a period of at least three years from the date the final financial report is submitted. Views of Responsible Officials: There is no disagreement with the finding.
Criteria: The Company should establish and maintain effective internal control over federal awards to provide reasonable assurance that the award is managed in compliance with federal statutes, regulations, and the terms and conditions of the award. Adequate documentation must be maintained to support internal control activities and compliance with federal requirements. Statement of Condition: During our walkthroughs and substantive testing, supporting documentation was not available to allow us to evaluate whether required internal controls were performed. The documents were unavailable due to the expiration of the entity’s document retention period and employee turnover, which resulted in the loss of institutional knowledge about the controls performed during the award period. Because the requested documentation could not be provided, we were unable to verify the performance or effectiveness of internal controls related to the compliance requirement tested. Cause of Condition: The entity did not maintain documentation of internal control activities beyond the minimum required retention period and did not have processes in place to preserve institutional knowledge during employee turnover. As a result, supporting records necessary for testing internal controls over federal awards were no longer available. Effect of Condition: Due to the absence of supporting documentation, we were unable to determine whether internal controls over the compliance requirement were properly designed and operating effectively. This results in the inability to test internal controls and assess control risk at a “low” level. Recommendation: We recommend that management (1) strengthen record retention practices to ensure that documentation of internal control activities is preserved in accordance with 2 CFR 200.334 and is available for future audits, (2) implement procedures to maintain institutional knowledge, particularly during periods of employee turnover (e.g., documented policies, cross-training, centralized recordkeeping), and (3) consider extending retention periods for documents supporting high-risk federal programs or key internal control activities. Management should ensure documentation is sufficient to demonstrate compliance and support internal control operations. Identification of Repeat Finding: This finding is a repeat of the finding noted in the audit for December 31, 2021 as finding 2021-003. Views of Responsible Officials: Management understands and accepts the recommendation as outlined in the Corrective Action Plan.
Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Health Center Program Assistance Listing Number: 93.224/93.527 Federal Award Identification Number: H80CS04200-17-01 and H80CS04200-18.01 Award Periods: May 1, 2021 ? April 30, 2022; May 1, 2022 ? April 30, 2023 Type of Finding: Compliance and Significant deficiency in internal control over compliance Criteria: 2 CFR 200.329(b) requires the Federal awarding agency to use OMB approved common information collections, when providing financial and performance reporting information. As appropriate and in accordance with above mentioned information collections, the Federal awarding agency must require the recipient to relate financial data and accomplishments to performance goals and objectives of the Federal award. In addition, OMB Compliance Supplement Part IV for assistance listing number 93.224/93.527 has designated key line items within the Uniform Data System (UDS) report. 2 CFR 200.334 indicates that financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency. Condition: The organization was not able to provide sufficient supporting documentation for amounts reported in Table 8A of the UDS report for calendar year 2021. Questioned Costs: None. Context: Two (2) of Seven (7) key line items tested. Cause: During the time in which the UDS report was being prepared, the organization experienced a flood at its corporate headquarters resulting in disruption of operations. As the preparation of the UDS report occurred during the aforementioned disruption, the applicable supporting documentation for two of the key line items within the UDS report, were not saved and/or maintained in electronic format in order to allow for ease of recovery.
Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Health Center Program Assistance Listing Number: 93.224/93.527 Federal Award Identification Number: H80CS04200-17-01 and H80CS04200-18.01 Award Periods: May 1, 2021 ? April 30, 2022; May 1, 2022 ? April 30, 2023 Type of Finding: Compliance and Significant deficiency in internal control over compliance Criteria: 2 CFR 200.329(b) requires the Federal awarding agency to use OMB approved common information collections, when providing financial and performance reporting information. As appropriate and in accordance with above mentioned information collections, the Federal awarding agency must require the recipient to relate financial data and accomplishments to performance goals and objectives of the Federal award. In addition, OMB Compliance Supplement Part IV for assistance listing number 93.224/93.527 has designated key line items within the Uniform Data System (UDS) report. 2 CFR 200.334 indicates that financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency. Condition: The organization was not able to provide sufficient supporting documentation for amounts reported in Table 8A of the UDS report for calendar year 2021. Questioned Costs: None. Context: Two (2) of Seven (7) key line items tested. Cause: During the time in which the UDS report was being prepared, the organization experienced a flood at its corporate headquarters resulting in disruption of operations. As the preparation of the UDS report occurred during the aforementioned disruption, the applicable supporting documentation for two of the key line items within the UDS report, were not saved and/or maintained in electronic format in order to allow for ease of recovery.
Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Health Center Program Assistance Listing Number: 93.224/93.527 Federal Award Identification Number: H80CS04200-17-01 and H80CS04200-18.01 Award Periods: May 1, 2021 ? April 30, 2022; May 1, 2022 ? April 30, 2023 Type of Finding: Compliance and Significant deficiency in internal control over compliance Criteria: 2 CFR 200.329(b) requires the Federal awarding agency to use OMB approved common information collections, when providing financial and performance reporting information. As appropriate and in accordance with above mentioned information collections, the Federal awarding agency must require the recipient to relate financial data and accomplishments to performance goals and objectives of the Federal award. In addition, OMB Compliance Supplement Part IV for assistance listing number 93.224/93.527 has designated key line items within the Uniform Data System (UDS) report. 2 CFR 200.334 indicates that financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency. Condition: The organization was not able to provide sufficient supporting documentation for amounts reported in Table 8A of the UDS report for calendar year 2021. Questioned Costs: None. Context: Two (2) of Seven (7) key line items tested. Cause: During the time in which the UDS report was being prepared, the organization experienced a flood at its corporate headquarters resulting in disruption of operations. As the preparation of the UDS report occurred during the aforementioned disruption, the applicable supporting documentation for two of the key line items within the UDS report, were not saved and/or maintained in electronic format in order to allow for ease of recovery.
Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Health Center Program Assistance Listing Number: 93.224/93.527 Federal Award Identification Number: H80CS04200-17-01 and H80CS04200-18.01 Award Periods: May 1, 2021 ? April 30, 2022; May 1, 2022 ? April 30, 2023 Type of Finding: Compliance and Significant deficiency in internal control over compliance Criteria: 2 CFR 200.329(b) requires the Federal awarding agency to use OMB approved common information collections, when providing financial and performance reporting information. As appropriate and in accordance with above mentioned information collections, the Federal awarding agency must require the recipient to relate financial data and accomplishments to performance goals and objectives of the Federal award. In addition, OMB Compliance Supplement Part IV for assistance listing number 93.224/93.527 has designated key line items within the Uniform Data System (UDS) report. 2 CFR 200.334 indicates that financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency. Condition: The organization was not able to provide sufficient supporting documentation for amounts reported in Table 8A of the UDS report for calendar year 2021. Questioned Costs: None. Context: Two (2) of Seven (7) key line items tested. Cause: During the time in which the UDS report was being prepared, the organization experienced a flood at its corporate headquarters resulting in disruption of operations. As the preparation of the UDS report occurred during the aforementioned disruption, the applicable supporting documentation for two of the key line items within the UDS report, were not saved and/or maintained in electronic format in order to allow for ease of recovery.
Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Health Center Program Assistance Listing Number: 93.224/93.527 Federal Award Identification Number: H80CS04200-17-01 and H80CS04200-18.01 Award Periods: May 1, 2021 ? April 30, 2022; May 1, 2022 ? April 30, 2023 Type of Finding: Compliance and Significant deficiency in internal control over compliance Criteria: 2 CFR 200.329(b) requires the Federal awarding agency to use OMB approved common information collections, when providing financial and performance reporting information. As appropriate and in accordance with above mentioned information collections, the Federal awarding agency must require the recipient to relate financial data and accomplishments to performance goals and objectives of the Federal award. In addition, OMB Compliance Supplement Part IV for assistance listing number 93.224/93.527 has designated key line items within the Uniform Data System (UDS) report. 2 CFR 200.334 indicates that financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency. Condition: The organization was not able to provide sufficient supporting documentation for amounts reported in Table 8A of the UDS report for calendar year 2021. Questioned Costs: None. Context: Two (2) of Seven (7) key line items tested. Cause: During the time in which the UDS report was being prepared, the organization experienced a flood at its corporate headquarters resulting in disruption of operations. As the preparation of the UDS report occurred during the aforementioned disruption, the applicable supporting documentation for two of the key line items within the UDS report, were not saved and/or maintained in electronic format in order to allow for ease of recovery.
Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Health Center Program Assistance Listing Number: 93.224/93.527 Federal Award Identification Number: H80CS04200-17-01 and H80CS04200-18.01 Award Periods: May 1, 2021 ? April 30, 2022; May 1, 2022 ? April 30, 2023 Type of Finding: Compliance and Significant deficiency in internal control over compliance Criteria: 2 CFR 200.329(b) requires the Federal awarding agency to use OMB approved common information collections, when providing financial and performance reporting information. As appropriate and in accordance with above mentioned information collections, the Federal awarding agency must require the recipient to relate financial data and accomplishments to performance goals and objectives of the Federal award. In addition, OMB Compliance Supplement Part IV for assistance listing number 93.224/93.527 has designated key line items within the Uniform Data System (UDS) report. 2 CFR 200.334 indicates that financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency. Condition: The organization was not able to provide sufficient supporting documentation for amounts reported in Table 8A of the UDS report for calendar year 2021. Questioned Costs: None. Context: Two (2) of Seven (7) key line items tested. Cause: During the time in which the UDS report was being prepared, the organization experienced a flood at its corporate headquarters resulting in disruption of operations. As the preparation of the UDS report occurred during the aforementioned disruption, the applicable supporting documentation for two of the key line items within the UDS report, were not saved and/or maintained in electronic format in order to allow for ease of recovery.
FINDING 2022-032 Pandemic EBT Food Benefits, ALN 10.542, Reporting ? Report of Disaster Supplemental Nutrition Assistance Benefit Issuance See Schedule of Findings and Questioned Costs for chart/table. Condition MDHHS did not have a process in place to ensure it maintained documentation to support the submitted Report of Disaster Supplemental Nutrition Assistance Benefit Issuance (FNS-292B). For all 3 sampled reports, MDHHS did not retain auditable submitted information, such as copies or screen prints of submitted reports. Rather, MDHHS provided us an e-mail disclosing the information which it represented as submitted. Criteria Federal regulation 2 CFR 200.334 requires financial records, supporting documents, statistical records, and all other nonfederal entity records pertinent to a federal award must be retained for a period of three years from the date of submission of the final expenditure report. Federal Register 86:89 (11 May 2021) page 25,837 requires state agencies to report the number of eligible children and households receiving P-EBT benefits and total value of the benefits monthly. Cause MDHHS informed us it electronically submitted the FNS-292B using the Food Program Reporting System (FPRS), but it did not retain copies of the submitted reports and the submitted reports were not available in FPRS. Effect We were unable to validate the information submitted to USDA on the FNS-292B. The federal grantor agency could issue sanctions or disallowances related to noncompliance. Known Questioned Costs None. Recommendation We recommend MDHHS establish a process to ensure it maintains documentation to support submitted FNS-292B reports. Management Views MDHHS disagrees that federal regulations require MDHHS to maintain copies or screenshots of FNS-292B information reported on the federal website. MDHHS normally has the ability to access the information on the federal system. However, during audit fieldwork, the FNS-292B information MDHHS submitted on the federal website was not viewable to the auditors because the reports were under federal review. MDHHS did not a retain a copy or screen prints of the submitted reports; however, MDHHS did maintain the underlying reports used to compile the submitted FNS-292B reports and this was provided to the auditors during fieldwork. Auditor's Comments to Management View MDHHS acknowledges it did not maintain a copy or screen prints of submitted reports. Documentation of submitted reports is necessary to provide auditable information to validate the accuracy of the report submission. MDHHS provided a spreadsheet and an e-mail disclosing the information which it represented as submitted; however, this information did not substantiate the FNS-292B was accurately submitted. Therefore, the finding stands as written.