2023-003: Significant deficiency over preparation of the Schedule of Expenditures of Federal Awards
Assistance listing number(s): All
Agency: All
Program: All
Grant Year: 2023
Criteria: According to 2 CFR 200.510(b), the audit is responsible for the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The SEFA must include, at a minimum, the information required by 2 CFR 200.510(b).
Condition: One award was initially excluded from the Schedule of Expenditures of Federal Awards (SEFA) despite being a federal subaward. In addition, certain award balances were not correctly calculated by improperly excluding amounts already expended that will be reimbursed under the federal award, or improperly including amounts advanced and not yet expended.
Cause: Balances on the schedule were calculated in-line with internal budgets rather than actual expenditures.
Effect: The SEFA was not properly prepared for the year ended September 30, 2023.
Questioned costs: There were no questioned costs related to this finding.
Repeat finding: This is not a repeat finding.
Auditor’s recommendation: We recommend all agreements be reviewed to determine whether they are grants or contracts. Written policies and procedures should detail how the SEFA gets compiled to ensure proper and complete information. The calculations on the SEFA should be reviewed and approved by a supervisor and compared against expected balances.
Views of Responsible Officials and Corrective Action Plan (unaudited): See corrective action plan.
2023-003: Significant deficiency over preparation of the Schedule of Expenditures of Federal Awards
Assistance listing number(s): All
Agency: All
Program: All
Grant Year: 2023
Criteria: According to 2 CFR 200.510(b), the audit is responsible for the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The SEFA must include, at a minimum, the information required by 2 CFR 200.510(b).
Condition: One award was initially excluded from the Schedule of Expenditures of Federal Awards (SEFA) despite being a federal subaward. In addition, certain award balances were not correctly calculated by improperly excluding amounts already expended that will be reimbursed under the federal award, or improperly including amounts advanced and not yet expended.
Cause: Balances on the schedule were calculated in-line with internal budgets rather than actual expenditures.
Effect: The SEFA was not properly prepared for the year ended September 30, 2023.
Questioned costs: There were no questioned costs related to this finding.
Repeat finding: This is not a repeat finding.
Auditor’s recommendation: We recommend all agreements be reviewed to determine whether they are grants or contracts. Written policies and procedures should detail how the SEFA gets compiled to ensure proper and complete information. The calculations on the SEFA should be reviewed and approved by a supervisor and compared against expected balances.
Views of Responsible Officials and Corrective Action Plan (unaudited): See corrective action plan.
2023-003: Significant deficiency over preparation of the Schedule of Expenditures of Federal Awards
Assistance listing number(s): All
Agency: All
Program: All
Grant Year: 2023
Criteria: According to 2 CFR 200.510(b), the audit is responsible for the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The SEFA must include, at a minimum, the information required by 2 CFR 200.510(b).
Condition: One award was initially excluded from the Schedule of Expenditures of Federal Awards (SEFA) despite being a federal subaward. In addition, certain award balances were not correctly calculated by improperly excluding amounts already expended that will be reimbursed under the federal award, or improperly including amounts advanced and not yet expended.
Cause: Balances on the schedule were calculated in-line with internal budgets rather than actual expenditures.
Effect: The SEFA was not properly prepared for the year ended September 30, 2023.
Questioned costs: There were no questioned costs related to this finding.
Repeat finding: This is not a repeat finding.
Auditor’s recommendation: We recommend all agreements be reviewed to determine whether they are grants or contracts. Written policies and procedures should detail how the SEFA gets compiled to ensure proper and complete information. The calculations on the SEFA should be reviewed and approved by a supervisor and compared against expected balances.
Views of Responsible Officials and Corrective Action Plan (unaudited): See corrective action plan.
2023-003: Significant deficiency over preparation of the Schedule of Expenditures of Federal Awards
Assistance listing number(s): All
Agency: All
Program: All
Grant Year: 2023
Criteria: According to 2 CFR 200.510(b), the audit is responsible for the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The SEFA must include, at a minimum, the information required by 2 CFR 200.510(b).
Condition: One award was initially excluded from the Schedule of Expenditures of Federal Awards (SEFA) despite being a federal subaward. In addition, certain award balances were not correctly calculated by improperly excluding amounts already expended that will be reimbursed under the federal award, or improperly including amounts advanced and not yet expended.
Cause: Balances on the schedule were calculated in-line with internal budgets rather than actual expenditures.
Effect: The SEFA was not properly prepared for the year ended September 30, 2023.
Questioned costs: There were no questioned costs related to this finding.
Repeat finding: This is not a repeat finding.
Auditor’s recommendation: We recommend all agreements be reviewed to determine whether they are grants or contracts. Written policies and procedures should detail how the SEFA gets compiled to ensure proper and complete information. The calculations on the SEFA should be reviewed and approved by a supervisor and compared against expected balances.
Views of Responsible Officials and Corrective Action Plan (unaudited): See corrective action plan.
2023-003: Significant deficiency over preparation of the Schedule of Expenditures of Federal Awards
Assistance listing number(s): All
Agency: All
Program: All
Grant Year: 2023
Criteria: According to 2 CFR 200.510(b), the audit is responsible for the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The SEFA must include, at a minimum, the information required by 2 CFR 200.510(b).
Condition: One award was initially excluded from the Schedule of Expenditures of Federal Awards (SEFA) despite being a federal subaward. In addition, certain award balances were not correctly calculated by improperly excluding amounts already expended that will be reimbursed under the federal award, or improperly including amounts advanced and not yet expended.
Cause: Balances on the schedule were calculated in-line with internal budgets rather than actual expenditures.
Effect: The SEFA was not properly prepared for the year ended September 30, 2023.
Questioned costs: There were no questioned costs related to this finding.
Repeat finding: This is not a repeat finding.
Auditor’s recommendation: We recommend all agreements be reviewed to determine whether they are grants or contracts. Written policies and procedures should detail how the SEFA gets compiled to ensure proper and complete information. The calculations on the SEFA should be reviewed and approved by a supervisor and compared against expected balances.
Views of Responsible Officials and Corrective Action Plan (unaudited): See corrective action plan.
2023-003: Significant deficiency over preparation of the Schedule of Expenditures of Federal Awards
Assistance listing number(s): All
Agency: All
Program: All
Grant Year: 2023
Criteria: According to 2 CFR 200.510(b), the audit is responsible for the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The SEFA must include, at a minimum, the information required by 2 CFR 200.510(b).
Condition: One award was initially excluded from the Schedule of Expenditures of Federal Awards (SEFA) despite being a federal subaward. In addition, certain award balances were not correctly calculated by improperly excluding amounts already expended that will be reimbursed under the federal award, or improperly including amounts advanced and not yet expended.
Cause: Balances on the schedule were calculated in-line with internal budgets rather than actual expenditures.
Effect: The SEFA was not properly prepared for the year ended September 30, 2023.
Questioned costs: There were no questioned costs related to this finding.
Repeat finding: This is not a repeat finding.
Auditor’s recommendation: We recommend all agreements be reviewed to determine whether they are grants or contracts. Written policies and procedures should detail how the SEFA gets compiled to ensure proper and complete information. The calculations on the SEFA should be reviewed and approved by a supervisor and compared against expected balances.
Views of Responsible Officials and Corrective Action Plan (unaudited): See corrective action plan.
2023-004: Significant deficiency over Subrecipient Monitoring
Assistance listing number: 97.132
Agency: Department of Homeland Security
Program: Targeted Violence and Terrorism Prevention Grant Program
Grant Year: 2023
Criteria: According to, § 200.332(a) Requirements for pass-through entities, all pass-through entities must ensure that every subaward is clearly identified to the subrecipient as a subaward and includes specified information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward.
Condition: Certain required disclosures, including the assistance listing number, monitoring requirements, and audit requirements, were missing from the subaward.
Cause: The subaward was prepared using a format more suited for a contract.
Effect: Award requirements may not have been properly communicated to the subawardee.
Questioned costs: There were no questioned costs related to this finding.
Repeat finding: This is not a repeat finding.
Auditor’s recommendation: We recommend all agreements are prepared with the required information before they are finalized. Written processes and control should be developed of subawards and subrecipient monitoring. Utilize a checklist of required communications when completing the agreement to ensure all required elements are included.
Views of Responsible Officials and Corrective Action Plan (unaudited): See corrective action plan.
2023-003: Significant deficiency over preparation of the Schedule of Expenditures of Federal Awards
Assistance listing number(s): All
Agency: All
Program: All
Grant Year: 2023
Criteria: According to 2 CFR 200.510(b), the audit is responsible for the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The SEFA must include, at a minimum, the information required by 2 CFR 200.510(b).
Condition: One award was initially excluded from the Schedule of Expenditures of Federal Awards (SEFA) despite being a federal subaward. In addition, certain award balances were not correctly calculated by improperly excluding amounts already expended that will be reimbursed under the federal award, or improperly including amounts advanced and not yet expended.
Cause: Balances on the schedule were calculated in-line with internal budgets rather than actual expenditures.
Effect: The SEFA was not properly prepared for the year ended September 30, 2023.
Questioned costs: There were no questioned costs related to this finding.
Repeat finding: This is not a repeat finding.
Auditor’s recommendation: We recommend all agreements be reviewed to determine whether they are grants or contracts. Written policies and procedures should detail how the SEFA gets compiled to ensure proper and complete information. The calculations on the SEFA should be reviewed and approved by a supervisor and compared against expected balances.
Views of Responsible Officials and Corrective Action Plan (unaudited): See corrective action plan.
2023-003: Significant deficiency over preparation of the Schedule of Expenditures of Federal Awards
Assistance listing number(s): All
Agency: All
Program: All
Grant Year: 2023
Criteria: According to 2 CFR 200.510(b), the audit is responsible for the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The SEFA must include, at a minimum, the information required by 2 CFR 200.510(b).
Condition: One award was initially excluded from the Schedule of Expenditures of Federal Awards (SEFA) despite being a federal subaward. In addition, certain award balances were not correctly calculated by improperly excluding amounts already expended that will be reimbursed under the federal award, or improperly including amounts advanced and not yet expended.
Cause: Balances on the schedule were calculated in-line with internal budgets rather than actual expenditures.
Effect: The SEFA was not properly prepared for the year ended September 30, 2023.
Questioned costs: There were no questioned costs related to this finding.
Repeat finding: This is not a repeat finding.
Auditor’s recommendation: We recommend all agreements be reviewed to determine whether they are grants or contracts. Written policies and procedures should detail how the SEFA gets compiled to ensure proper and complete information. The calculations on the SEFA should be reviewed and approved by a supervisor and compared against expected balances.
Views of Responsible Officials and Corrective Action Plan (unaudited): See corrective action plan.
2023-003: Significant deficiency over preparation of the Schedule of Expenditures of Federal Awards
Assistance listing number(s): All
Agency: All
Program: All
Grant Year: 2023
Criteria: According to 2 CFR 200.510(b), the audit is responsible for the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The SEFA must include, at a minimum, the information required by 2 CFR 200.510(b).
Condition: One award was initially excluded from the Schedule of Expenditures of Federal Awards (SEFA) despite being a federal subaward. In addition, certain award balances were not correctly calculated by improperly excluding amounts already expended that will be reimbursed under the federal award, or improperly including amounts advanced and not yet expended.
Cause: Balances on the schedule were calculated in-line with internal budgets rather than actual expenditures.
Effect: The SEFA was not properly prepared for the year ended September 30, 2023.
Questioned costs: There were no questioned costs related to this finding.
Repeat finding: This is not a repeat finding.
Auditor’s recommendation: We recommend all agreements be reviewed to determine whether they are grants or contracts. Written policies and procedures should detail how the SEFA gets compiled to ensure proper and complete information. The calculations on the SEFA should be reviewed and approved by a supervisor and compared against expected balances.
Views of Responsible Officials and Corrective Action Plan (unaudited): See corrective action plan.
2023-003: Significant deficiency over preparation of the Schedule of Expenditures of Federal Awards
Assistance listing number(s): All
Agency: All
Program: All
Grant Year: 2023
Criteria: According to 2 CFR 200.510(b), the audit is responsible for the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The SEFA must include, at a minimum, the information required by 2 CFR 200.510(b).
Condition: One award was initially excluded from the Schedule of Expenditures of Federal Awards (SEFA) despite being a federal subaward. In addition, certain award balances were not correctly calculated by improperly excluding amounts already expended that will be reimbursed under the federal award, or improperly including amounts advanced and not yet expended.
Cause: Balances on the schedule were calculated in-line with internal budgets rather than actual expenditures.
Effect: The SEFA was not properly prepared for the year ended September 30, 2023.
Questioned costs: There were no questioned costs related to this finding.
Repeat finding: This is not a repeat finding.
Auditor’s recommendation: We recommend all agreements be reviewed to determine whether they are grants or contracts. Written policies and procedures should detail how the SEFA gets compiled to ensure proper and complete information. The calculations on the SEFA should be reviewed and approved by a supervisor and compared against expected balances.
Views of Responsible Officials and Corrective Action Plan (unaudited): See corrective action plan.
2023-003: Significant deficiency over preparation of the Schedule of Expenditures of Federal Awards
Assistance listing number(s): All
Agency: All
Program: All
Grant Year: 2023
Criteria: According to 2 CFR 200.510(b), the audit is responsible for the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The SEFA must include, at a minimum, the information required by 2 CFR 200.510(b).
Condition: One award was initially excluded from the Schedule of Expenditures of Federal Awards (SEFA) despite being a federal subaward. In addition, certain award balances were not correctly calculated by improperly excluding amounts already expended that will be reimbursed under the federal award, or improperly including amounts advanced and not yet expended.
Cause: Balances on the schedule were calculated in-line with internal budgets rather than actual expenditures.
Effect: The SEFA was not properly prepared for the year ended September 30, 2023.
Questioned costs: There were no questioned costs related to this finding.
Repeat finding: This is not a repeat finding.
Auditor’s recommendation: We recommend all agreements be reviewed to determine whether they are grants or contracts. Written policies and procedures should detail how the SEFA gets compiled to ensure proper and complete information. The calculations on the SEFA should be reviewed and approved by a supervisor and compared against expected balances.
Views of Responsible Officials and Corrective Action Plan (unaudited): See corrective action plan.
2023-003: Significant deficiency over preparation of the Schedule of Expenditures of Federal Awards
Assistance listing number(s): All
Agency: All
Program: All
Grant Year: 2023
Criteria: According to 2 CFR 200.510(b), the audit is responsible for the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The SEFA must include, at a minimum, the information required by 2 CFR 200.510(b).
Condition: One award was initially excluded from the Schedule of Expenditures of Federal Awards (SEFA) despite being a federal subaward. In addition, certain award balances were not correctly calculated by improperly excluding amounts already expended that will be reimbursed under the federal award, or improperly including amounts advanced and not yet expended.
Cause: Balances on the schedule were calculated in-line with internal budgets rather than actual expenditures.
Effect: The SEFA was not properly prepared for the year ended September 30, 2023.
Questioned costs: There were no questioned costs related to this finding.
Repeat finding: This is not a repeat finding.
Auditor’s recommendation: We recommend all agreements be reviewed to determine whether they are grants or contracts. Written policies and procedures should detail how the SEFA gets compiled to ensure proper and complete information. The calculations on the SEFA should be reviewed and approved by a supervisor and compared against expected balances.
Views of Responsible Officials and Corrective Action Plan (unaudited): See corrective action plan.
2023-004: Significant deficiency over Subrecipient Monitoring
Assistance listing number: 97.132
Agency: Department of Homeland Security
Program: Targeted Violence and Terrorism Prevention Grant Program
Grant Year: 2023
Criteria: According to, § 200.332(a) Requirements for pass-through entities, all pass-through entities must ensure that every subaward is clearly identified to the subrecipient as a subaward and includes specified information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward.
Condition: Certain required disclosures, including the assistance listing number, monitoring requirements, and audit requirements, were missing from the subaward.
Cause: The subaward was prepared using a format more suited for a contract.
Effect: Award requirements may not have been properly communicated to the subawardee.
Questioned costs: There were no questioned costs related to this finding.
Repeat finding: This is not a repeat finding.
Auditor’s recommendation: We recommend all agreements are prepared with the required information before they are finalized. Written processes and control should be developed of subawards and subrecipient monitoring. Utilize a checklist of required communications when completing the agreement to ensure all required elements are included.
Views of Responsible Officials and Corrective Action Plan (unaudited): See corrective action plan.