2024-001 Improve Internal Controls over the Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program(s) Information Federal Agency: Environmental Protection Agency Award Name: Drinking Water State Revolving Fund Assistance Listing Number: 66.468 Award Year: 2024 Type of Finding Compliance Internal Control over Compliance – Significant Deficiency Criteria or Specific Requirement Per 2 CFR 200.510(b), auditees must prepare a complete and accurate Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. The SEFA must identify all federal awards expended, organized by federal program and Assistance Listing Number (ALN), and include all required disclosures. Condition and Context While preparing its draft SEFA, the City incorrectly classified $3,473,784 in federal expenditures as Drinking Water State Revolving Fund when those expenditures should have been classified as Coronavirus State and Local Fiscal Recovery Fund program expenditures. As a result of the initial improper expenditure amounts, the auditors’ assessment over major program determination was impacted. The misclassification was limited to the preparation of the SEFA and there was no impact on amounts reported to and/or claims for reimbursement from the respective funding source(s). This classification error was corrected for purposes of the final SEFA. Cause The City did not have adequate controls in place in order to ensure the complete and accurate preparation of the SEFA, including reconciling federal expenditures reported in the general ledger with the information included on the SEFA and verifying the correct allocation to the proper federal programs. SECTION III – FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Effect or Potential Effect Due to the weakness in internal controls noted above, there is a risk that amounts reported on the SEFA are not complete and accurate. The lack of a complete and accurate SEFA may impact the determination if a single audit is required, as well as major program determination. Recommendation The City should ensure that adequate procedures and controls are in place to ensure that the SEFA is complete and accurate. This should include controls requiring the reconciliation of federal expenditures to the appropriate supporting documentation (e.g., general ledger, grant reports, etc.) and formal review by a knowledgeable individual following preparation of the SEFA. Views of Responsible Official Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.
Finding 2024-004 Accounting for Grants, Schedule of Expenditures of Federal Awards, and Fiscal Man-agement (Material Weakness) Assistance Listing Number and Title: 84.041 Impact Aid Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 84.010 Title I Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 10.553 and 10.555 National School Lunch Breakfast and Lunch Name of Federal Agency: U.S. Department of Agriculture Criteria: CFR Part 200.508, CFR Part 200.510, Auditee Responsibilities state that the auditee must prepare the Sched-ule of Expenditures of Federal Awards, which must list individual Federal awards by Federal Agency, including the to-tal Federal awards expended, name of the pass-through entity, CFDA number, and total amount provided to subrecipi-ents. The information contained in the Schedule of Expenditures of Federal Awards should be derived from and relate directly to the underlying accounting and other records used to prepare the financial statements. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was presented for audit with values that were not reconciled with the general ledger, and contained inaccuracies, including: • Overclaimed revenues for Title I • Inability to provide sufficient documentation of Impact Aid revenues and specific Impact Aid program infor-mation • Incorrect reporting of state and federal revenues for National School Lunch Program. Cause: The District does not have effective internal control over the preparation of the Schedule of Expenditures of Federal Awards. The district did not reconcile the expenditures reported on the SEFA with the amounts reported on the district's general ledger. Effect or Potential Effect: Potential understatement or overstatement of expenditures could exist in the Schedule of Expenditures of Federal Awards and not be detected and corrected. Because the SEFA was completed incorrectly, and not reconciled to the general ledger, the financial statements were materially misstated prior to the auditor's adjust-ments. Questioned Cost: No Context: Lack of adequate controls over the Schedule of Expenditures of Federal Awards and related accounting re-sulted in the following: SEFA was originally presented for auditors with incorrect information, and not reconciled to the general ledger Repeat of a Prior-Year Finding: No Recommendation: We recommend that the District establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Internal controls should be designed to prevent, detect, or cor-rect errors in a timely manner by performing periodic reconciliations of the SEFA information to the general ledger throughout the fiscal year. The District should provide appropriate training to staff who are assigned to prepare and re-view the SEFA. District’s Response: The District acknowledges the deficiencies. Corrective Action Plan: The District will establish policies and procedures to ensure that all Federal awards are identi-fied and reported accurately on future SEFAs. Planned Implementation Date: August 1, 2025 Responsible Person: District Business Manager Section IV—Summary Schedule of Prior Audit Findings There were no findings for the fiscal year ended June 30, 2023.
Finding 2024-004 Accounting for Grants, Schedule of Expenditures of Federal Awards, and Fiscal Man-agement (Material Weakness) Assistance Listing Number and Title: 84.041 Impact Aid Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 84.010 Title I Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 10.553 and 10.555 National School Lunch Breakfast and Lunch Name of Federal Agency: U.S. Department of Agriculture Criteria: CFR Part 200.508, CFR Part 200.510, Auditee Responsibilities state that the auditee must prepare the Sched-ule of Expenditures of Federal Awards, which must list individual Federal awards by Federal Agency, including the to-tal Federal awards expended, name of the pass-through entity, CFDA number, and total amount provided to subrecipi-ents. The information contained in the Schedule of Expenditures of Federal Awards should be derived from and relate directly to the underlying accounting and other records used to prepare the financial statements. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was presented for audit with values that were not reconciled with the general ledger, and contained inaccuracies, including: • Overclaimed revenues for Title I • Inability to provide sufficient documentation of Impact Aid revenues and specific Impact Aid program infor-mation • Incorrect reporting of state and federal revenues for National School Lunch Program. Cause: The District does not have effective internal control over the preparation of the Schedule of Expenditures of Federal Awards. The district did not reconcile the expenditures reported on the SEFA with the amounts reported on the district's general ledger. Effect or Potential Effect: Potential understatement or overstatement of expenditures could exist in the Schedule of Expenditures of Federal Awards and not be detected and corrected. Because the SEFA was completed incorrectly, and not reconciled to the general ledger, the financial statements were materially misstated prior to the auditor's adjust-ments. Questioned Cost: No Context: Lack of adequate controls over the Schedule of Expenditures of Federal Awards and related accounting re-sulted in the following: SEFA was originally presented for auditors with incorrect information, and not reconciled to the general ledger Repeat of a Prior-Year Finding: No Recommendation: We recommend that the District establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Internal controls should be designed to prevent, detect, or cor-rect errors in a timely manner by performing periodic reconciliations of the SEFA information to the general ledger throughout the fiscal year. The District should provide appropriate training to staff who are assigned to prepare and re-view the SEFA. District’s Response: The District acknowledges the deficiencies. Corrective Action Plan: The District will establish policies and procedures to ensure that all Federal awards are identi-fied and reported accurately on future SEFAs. Planned Implementation Date: August 1, 2025 Responsible Person: District Business Manager Section IV—Summary Schedule of Prior Audit Findings There were no findings for the fiscal year ended June 30, 2023.
Finding 2024-004 Accounting for Grants, Schedule of Expenditures of Federal Awards, and Fiscal Man-agement (Material Weakness) Assistance Listing Number and Title: 84.041 Impact Aid Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 84.010 Title I Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 10.553 and 10.555 National School Lunch Breakfast and Lunch Name of Federal Agency: U.S. Department of Agriculture Criteria: CFR Part 200.508, CFR Part 200.510, Auditee Responsibilities state that the auditee must prepare the Sched-ule of Expenditures of Federal Awards, which must list individual Federal awards by Federal Agency, including the to-tal Federal awards expended, name of the pass-through entity, CFDA number, and total amount provided to subrecipi-ents. The information contained in the Schedule of Expenditures of Federal Awards should be derived from and relate directly to the underlying accounting and other records used to prepare the financial statements. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was presented for audit with values that were not reconciled with the general ledger, and contained inaccuracies, including: • Overclaimed revenues for Title I • Inability to provide sufficient documentation of Impact Aid revenues and specific Impact Aid program infor-mation • Incorrect reporting of state and federal revenues for National School Lunch Program. Cause: The District does not have effective internal control over the preparation of the Schedule of Expenditures of Federal Awards. The district did not reconcile the expenditures reported on the SEFA with the amounts reported on the district's general ledger. Effect or Potential Effect: Potential understatement or overstatement of expenditures could exist in the Schedule of Expenditures of Federal Awards and not be detected and corrected. Because the SEFA was completed incorrectly, and not reconciled to the general ledger, the financial statements were materially misstated prior to the auditor's adjust-ments. Questioned Cost: No Context: Lack of adequate controls over the Schedule of Expenditures of Federal Awards and related accounting re-sulted in the following: SEFA was originally presented for auditors with incorrect information, and not reconciled to the general ledger Repeat of a Prior-Year Finding: No Recommendation: We recommend that the District establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Internal controls should be designed to prevent, detect, or cor-rect errors in a timely manner by performing periodic reconciliations of the SEFA information to the general ledger throughout the fiscal year. The District should provide appropriate training to staff who are assigned to prepare and re-view the SEFA. District’s Response: The District acknowledges the deficiencies. Corrective Action Plan: The District will establish policies and procedures to ensure that all Federal awards are identi-fied and reported accurately on future SEFAs. Planned Implementation Date: August 1, 2025 Responsible Person: District Business Manager Section IV—Summary Schedule of Prior Audit Findings There were no findings for the fiscal year ended June 30, 2023.
Finding 2024-004 Accounting for Grants, Schedule of Expenditures of Federal Awards, and Fiscal Man-agement (Material Weakness) Assistance Listing Number and Title: 84.041 Impact Aid Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 84.010 Title I Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 10.553 and 10.555 National School Lunch Breakfast and Lunch Name of Federal Agency: U.S. Department of Agriculture Criteria: CFR Part 200.508, CFR Part 200.510, Auditee Responsibilities state that the auditee must prepare the Sched-ule of Expenditures of Federal Awards, which must list individual Federal awards by Federal Agency, including the to-tal Federal awards expended, name of the pass-through entity, CFDA number, and total amount provided to subrecipi-ents. The information contained in the Schedule of Expenditures of Federal Awards should be derived from and relate directly to the underlying accounting and other records used to prepare the financial statements. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was presented for audit with values that were not reconciled with the general ledger, and contained inaccuracies, including: • Overclaimed revenues for Title I • Inability to provide sufficient documentation of Impact Aid revenues and specific Impact Aid program infor-mation • Incorrect reporting of state and federal revenues for National School Lunch Program. Cause: The District does not have effective internal control over the preparation of the Schedule of Expenditures of Federal Awards. The district did not reconcile the expenditures reported on the SEFA with the amounts reported on the district's general ledger. Effect or Potential Effect: Potential understatement or overstatement of expenditures could exist in the Schedule of Expenditures of Federal Awards and not be detected and corrected. Because the SEFA was completed incorrectly, and not reconciled to the general ledger, the financial statements were materially misstated prior to the auditor's adjust-ments. Questioned Cost: No Context: Lack of adequate controls over the Schedule of Expenditures of Federal Awards and related accounting re-sulted in the following: SEFA was originally presented for auditors with incorrect information, and not reconciled to the general ledger Repeat of a Prior-Year Finding: No Recommendation: We recommend that the District establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Internal controls should be designed to prevent, detect, or cor-rect errors in a timely manner by performing periodic reconciliations of the SEFA information to the general ledger throughout the fiscal year. The District should provide appropriate training to staff who are assigned to prepare and re-view the SEFA. District’s Response: The District acknowledges the deficiencies. Corrective Action Plan: The District will establish policies and procedures to ensure that all Federal awards are identi-fied and reported accurately on future SEFAs. Planned Implementation Date: August 1, 2025 Responsible Person: District Business Manager Section IV—Summary Schedule of Prior Audit Findings There were no findings for the fiscal year ended June 30, 2023.
Finding 2024-004 Accounting for Grants, Schedule of Expenditures of Federal Awards, and Fiscal Man-agement (Material Weakness) Assistance Listing Number and Title: 84.041 Impact Aid Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 84.010 Title I Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 10.553 and 10.555 National School Lunch Breakfast and Lunch Name of Federal Agency: U.S. Department of Agriculture Criteria: CFR Part 200.508, CFR Part 200.510, Auditee Responsibilities state that the auditee must prepare the Sched-ule of Expenditures of Federal Awards, which must list individual Federal awards by Federal Agency, including the to-tal Federal awards expended, name of the pass-through entity, CFDA number, and total amount provided to subrecipi-ents. The information contained in the Schedule of Expenditures of Federal Awards should be derived from and relate directly to the underlying accounting and other records used to prepare the financial statements. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was presented for audit with values that were not reconciled with the general ledger, and contained inaccuracies, including: • Overclaimed revenues for Title I • Inability to provide sufficient documentation of Impact Aid revenues and specific Impact Aid program infor-mation • Incorrect reporting of state and federal revenues for National School Lunch Program. Cause: The District does not have effective internal control over the preparation of the Schedule of Expenditures of Federal Awards. The district did not reconcile the expenditures reported on the SEFA with the amounts reported on the district's general ledger. Effect or Potential Effect: Potential understatement or overstatement of expenditures could exist in the Schedule of Expenditures of Federal Awards and not be detected and corrected. Because the SEFA was completed incorrectly, and not reconciled to the general ledger, the financial statements were materially misstated prior to the auditor's adjust-ments. Questioned Cost: No Context: Lack of adequate controls over the Schedule of Expenditures of Federal Awards and related accounting re-sulted in the following: SEFA was originally presented for auditors with incorrect information, and not reconciled to the general ledger Repeat of a Prior-Year Finding: No Recommendation: We recommend that the District establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Internal controls should be designed to prevent, detect, or cor-rect errors in a timely manner by performing periodic reconciliations of the SEFA information to the general ledger throughout the fiscal year. The District should provide appropriate training to staff who are assigned to prepare and re-view the SEFA. District’s Response: The District acknowledges the deficiencies. Corrective Action Plan: The District will establish policies and procedures to ensure that all Federal awards are identi-fied and reported accurately on future SEFAs. Planned Implementation Date: August 1, 2025 Responsible Person: District Business Manager Section IV—Summary Schedule of Prior Audit Findings There were no findings for the fiscal year ended June 30, 2023.
Finding 2024-004 Accounting for Grants, Schedule of Expenditures of Federal Awards, and Fiscal Man-agement (Material Weakness) Assistance Listing Number and Title: 84.041 Impact Aid Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 84.010 Title I Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 10.553 and 10.555 National School Lunch Breakfast and Lunch Name of Federal Agency: U.S. Department of Agriculture Criteria: CFR Part 200.508, CFR Part 200.510, Auditee Responsibilities state that the auditee must prepare the Sched-ule of Expenditures of Federal Awards, which must list individual Federal awards by Federal Agency, including the to-tal Federal awards expended, name of the pass-through entity, CFDA number, and total amount provided to subrecipi-ents. The information contained in the Schedule of Expenditures of Federal Awards should be derived from and relate directly to the underlying accounting and other records used to prepare the financial statements. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was presented for audit with values that were not reconciled with the general ledger, and contained inaccuracies, including: • Overclaimed revenues for Title I • Inability to provide sufficient documentation of Impact Aid revenues and specific Impact Aid program infor-mation • Incorrect reporting of state and federal revenues for National School Lunch Program. Cause: The District does not have effective internal control over the preparation of the Schedule of Expenditures of Federal Awards. The district did not reconcile the expenditures reported on the SEFA with the amounts reported on the district's general ledger. Effect or Potential Effect: Potential understatement or overstatement of expenditures could exist in the Schedule of Expenditures of Federal Awards and not be detected and corrected. Because the SEFA was completed incorrectly, and not reconciled to the general ledger, the financial statements were materially misstated prior to the auditor's adjust-ments. Questioned Cost: No Context: Lack of adequate controls over the Schedule of Expenditures of Federal Awards and related accounting re-sulted in the following: SEFA was originally presented for auditors with incorrect information, and not reconciled to the general ledger Repeat of a Prior-Year Finding: No Recommendation: We recommend that the District establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Internal controls should be designed to prevent, detect, or cor-rect errors in a timely manner by performing periodic reconciliations of the SEFA information to the general ledger throughout the fiscal year. The District should provide appropriate training to staff who are assigned to prepare and re-view the SEFA. District’s Response: The District acknowledges the deficiencies. Corrective Action Plan: The District will establish policies and procedures to ensure that all Federal awards are identi-fied and reported accurately on future SEFAs. Planned Implementation Date: August 1, 2025 Responsible Person: District Business Manager Section IV—Summary Schedule of Prior Audit Findings There were no findings for the fiscal year ended June 30, 2023.
Finding 2024-004 Accounting for Grants, Schedule of Expenditures of Federal Awards, and Fiscal Man-agement (Material Weakness) Assistance Listing Number and Title: 84.041 Impact Aid Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 84.010 Title I Name of Federal Agency: U.S. Department of Education Assistance Listing Number and Title: 10.553 and 10.555 National School Lunch Breakfast and Lunch Name of Federal Agency: U.S. Department of Agriculture Criteria: CFR Part 200.508, CFR Part 200.510, Auditee Responsibilities state that the auditee must prepare the Sched-ule of Expenditures of Federal Awards, which must list individual Federal awards by Federal Agency, including the to-tal Federal awards expended, name of the pass-through entity, CFDA number, and total amount provided to subrecipi-ents. The information contained in the Schedule of Expenditures of Federal Awards should be derived from and relate directly to the underlying accounting and other records used to prepare the financial statements. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was presented for audit with values that were not reconciled with the general ledger, and contained inaccuracies, including: • Overclaimed revenues for Title I • Inability to provide sufficient documentation of Impact Aid revenues and specific Impact Aid program infor-mation • Incorrect reporting of state and federal revenues for National School Lunch Program. Cause: The District does not have effective internal control over the preparation of the Schedule of Expenditures of Federal Awards. The district did not reconcile the expenditures reported on the SEFA with the amounts reported on the district's general ledger. Effect or Potential Effect: Potential understatement or overstatement of expenditures could exist in the Schedule of Expenditures of Federal Awards and not be detected and corrected. Because the SEFA was completed incorrectly, and not reconciled to the general ledger, the financial statements were materially misstated prior to the auditor's adjust-ments. Questioned Cost: No Context: Lack of adequate controls over the Schedule of Expenditures of Federal Awards and related accounting re-sulted in the following: SEFA was originally presented for auditors with incorrect information, and not reconciled to the general ledger Repeat of a Prior-Year Finding: No Recommendation: We recommend that the District establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Internal controls should be designed to prevent, detect, or cor-rect errors in a timely manner by performing periodic reconciliations of the SEFA information to the general ledger throughout the fiscal year. The District should provide appropriate training to staff who are assigned to prepare and re-view the SEFA. District’s Response: The District acknowledges the deficiencies. Corrective Action Plan: The District will establish policies and procedures to ensure that all Federal awards are identi-fied and reported accurately on future SEFAs. Planned Implementation Date: August 1, 2025 Responsible Person: District Business Manager Section IV—Summary Schedule of Prior Audit Findings There were no findings for the fiscal year ended June 30, 2023.
Finding 2024-003 – Preparation of Schedule of Expenditures of Federal Awards (SEFA) (Material Weakness) (Repeat Finding) Program: All Assistance Listing (AL) No.: N/A Federal Agency: N/A Passed Through: N/A Award Year: Fiscal Year 2023-2024 Compliance Requirement: N/A Questioned Costs: None Criteria Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the Agency) must prepare a SEFA for the period covered by the auditee’s financial statements, which must include the total federal awards expended as determined in accordance with §200.502. In addition, §200.303 of the Uniform Guidance states that the Agency must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition During audit procedures performed over the SEFA, we noted that the Agency incorrectly included Federal expenditures from AL No. 20.507 and AL No. 20.509 that were accrued and recorded in fiscal year 2023 in the amount of $2,160,408, and excluded expenditures from AL No. 20.507 Federal Transit Formula Grants in the amount of $2,924,012 and 20.509 Formula Grants for Rural Areas and Tribal Transit Program in the amount of $2,259,151 on its preliminary SEFA. Cause of Condition The Agency’s existing internal control system is not designed to provide an accurate and complete SEFA. The procedures currently in place did not include sufficient review of the information and supporting documentation relating to federal awards before the SEFA was provided to the external auditors. The first version of the SEFA provided by the Agency reported total expenditures of $2,842,283; the final revised expenditures totaled $5,865,038. Effect of Condition The SEFA, which is prepared by the Agency and considered supplementary information to the financial statements, is a key part of the reporting package required by the Uniform Guidance. The SEFA also serves as the primary basis that the external auditors use to determine which programs will be audited as part of the single audit; therefore, the Agency’s responsibility for preparing an accurate and complete SEFA is critical. The inability to properly identify and track federal expenditures in the SEFA increases the likelihood that federal expenditures would not be fairly reported. There is increased risk of noncompliance with the requirements set forth in the U.S. Office of Management and Budget (OMB) Compliance Supplement, which can jeopardize future federal funding as well as result in the payback of federal awards. Recommendation We recommend the Agency implement internal controls to ensure the accuracy of program information, expenditure amounts, and assistance listing numbers. We also recommend the Agency strengthen its year-end closing procedures to ensure that all transactions and federal awards related to the fiscal year are properly captured and recorded in the general ledger to ensure the accuracy and completeness of the financial statements and supplementary schedules. Additionally, we recommend that the Agency provide sufficient resources and adequate oversight within the Agency to oversee the year-end closing procedures and preparation of the financial statements and supporting schedules. Lastly, we recommend the Agency provide training on an as needed basis for employees with financial reporting responsibilities. Management Response and Corrective Action Plan We acknowledge the findings regarding the preparation of the Schedule of Expenditures of Federal Awards (SEFA). Management agrees that there were errors in the classification and reporting of federal expenditures during the fiscal year 2023-2024, which resulted from inadequate review controls and documentation procedures. The Agency is committed to enhancing internal controls and year-end closing processes to ensure that the SEFA is complete, accurate, and compliant with 2 CFR Part 200 requirements.
Finding 2024-003 – Preparation of Schedule of Expenditures of Federal Awards (SEFA) (Material Weakness) (Repeat Finding) Program: All Assistance Listing (AL) No.: N/A Federal Agency: N/A Passed Through: N/A Award Year: Fiscal Year 2023-2024 Compliance Requirement: N/A Questioned Costs: None Criteria Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the Agency) must prepare a SEFA for the period covered by the auditee’s financial statements, which must include the total federal awards expended as determined in accordance with §200.502. In addition, §200.303 of the Uniform Guidance states that the Agency must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition During audit procedures performed over the SEFA, we noted that the Agency incorrectly included Federal expenditures from AL No. 20.507 and AL No. 20.509 that were accrued and recorded in fiscal year 2023 in the amount of $2,160,408, and excluded expenditures from AL No. 20.507 Federal Transit Formula Grants in the amount of $2,924,012 and 20.509 Formula Grants for Rural Areas and Tribal Transit Program in the amount of $2,259,151 on its preliminary SEFA. Cause of Condition The Agency’s existing internal control system is not designed to provide an accurate and complete SEFA. The procedures currently in place did not include sufficient review of the information and supporting documentation relating to federal awards before the SEFA was provided to the external auditors. The first version of the SEFA provided by the Agency reported total expenditures of $2,842,283; the final revised expenditures totaled $5,865,038. Effect of Condition The SEFA, which is prepared by the Agency and considered supplementary information to the financial statements, is a key part of the reporting package required by the Uniform Guidance. The SEFA also serves as the primary basis that the external auditors use to determine which programs will be audited as part of the single audit; therefore, the Agency’s responsibility for preparing an accurate and complete SEFA is critical. The inability to properly identify and track federal expenditures in the SEFA increases the likelihood that federal expenditures would not be fairly reported. There is increased risk of noncompliance with the requirements set forth in the U.S. Office of Management and Budget (OMB) Compliance Supplement, which can jeopardize future federal funding as well as result in the payback of federal awards. Recommendation We recommend the Agency implement internal controls to ensure the accuracy of program information, expenditure amounts, and assistance listing numbers. We also recommend the Agency strengthen its year-end closing procedures to ensure that all transactions and federal awards related to the fiscal year are properly captured and recorded in the general ledger to ensure the accuracy and completeness of the financial statements and supplementary schedules. Additionally, we recommend that the Agency provide sufficient resources and adequate oversight within the Agency to oversee the year-end closing procedures and preparation of the financial statements and supporting schedules. Lastly, we recommend the Agency provide training on an as needed basis for employees with financial reporting responsibilities. Management Response and Corrective Action Plan We acknowledge the findings regarding the preparation of the Schedule of Expenditures of Federal Awards (SEFA). Management agrees that there were errors in the classification and reporting of federal expenditures during the fiscal year 2023-2024, which resulted from inadequate review controls and documentation procedures. The Agency is committed to enhancing internal controls and year-end closing processes to ensure that the SEFA is complete, accurate, and compliant with 2 CFR Part 200 requirements.
Finding 2024-003 – Preparation of Schedule of Expenditures of Federal Awards (SEFA) (Material Weakness) (Repeat Finding) Program: All Assistance Listing (AL) No.: N/A Federal Agency: N/A Passed Through: N/A Award Year: Fiscal Year 2023-2024 Compliance Requirement: N/A Questioned Costs: None Criteria Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the Agency) must prepare a SEFA for the period covered by the auditee’s financial statements, which must include the total federal awards expended as determined in accordance with §200.502. In addition, §200.303 of the Uniform Guidance states that the Agency must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition During audit procedures performed over the SEFA, we noted that the Agency incorrectly included Federal expenditures from AL No. 20.507 and AL No. 20.509 that were accrued and recorded in fiscal year 2023 in the amount of $2,160,408, and excluded expenditures from AL No. 20.507 Federal Transit Formula Grants in the amount of $2,924,012 and 20.509 Formula Grants for Rural Areas and Tribal Transit Program in the amount of $2,259,151 on its preliminary SEFA. Cause of Condition The Agency’s existing internal control system is not designed to provide an accurate and complete SEFA. The procedures currently in place did not include sufficient review of the information and supporting documentation relating to federal awards before the SEFA was provided to the external auditors. The first version of the SEFA provided by the Agency reported total expenditures of $2,842,283; the final revised expenditures totaled $5,865,038. Effect of Condition The SEFA, which is prepared by the Agency and considered supplementary information to the financial statements, is a key part of the reporting package required by the Uniform Guidance. The SEFA also serves as the primary basis that the external auditors use to determine which programs will be audited as part of the single audit; therefore, the Agency’s responsibility for preparing an accurate and complete SEFA is critical. The inability to properly identify and track federal expenditures in the SEFA increases the likelihood that federal expenditures would not be fairly reported. There is increased risk of noncompliance with the requirements set forth in the U.S. Office of Management and Budget (OMB) Compliance Supplement, which can jeopardize future federal funding as well as result in the payback of federal awards. Recommendation We recommend the Agency implement internal controls to ensure the accuracy of program information, expenditure amounts, and assistance listing numbers. We also recommend the Agency strengthen its year-end closing procedures to ensure that all transactions and federal awards related to the fiscal year are properly captured and recorded in the general ledger to ensure the accuracy and completeness of the financial statements and supplementary schedules. Additionally, we recommend that the Agency provide sufficient resources and adequate oversight within the Agency to oversee the year-end closing procedures and preparation of the financial statements and supporting schedules. Lastly, we recommend the Agency provide training on an as needed basis for employees with financial reporting responsibilities. Management Response and Corrective Action Plan We acknowledge the findings regarding the preparation of the Schedule of Expenditures of Federal Awards (SEFA). Management agrees that there were errors in the classification and reporting of federal expenditures during the fiscal year 2023-2024, which resulted from inadequate review controls and documentation procedures. The Agency is committed to enhancing internal controls and year-end closing processes to ensure that the SEFA is complete, accurate, and compliant with 2 CFR Part 200 requirements.
Finding 2024-003 – Preparation of Schedule of Expenditures of Federal Awards (SEFA) (Material Weakness) (Repeat Finding) Program: All Assistance Listing (AL) No.: N/A Federal Agency: N/A Passed Through: N/A Award Year: Fiscal Year 2023-2024 Compliance Requirement: N/A Questioned Costs: None Criteria Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the Agency) must prepare a SEFA for the period covered by the auditee’s financial statements, which must include the total federal awards expended as determined in accordance with §200.502. In addition, §200.303 of the Uniform Guidance states that the Agency must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition During audit procedures performed over the SEFA, we noted that the Agency incorrectly included Federal expenditures from AL No. 20.507 and AL No. 20.509 that were accrued and recorded in fiscal year 2023 in the amount of $2,160,408, and excluded expenditures from AL No. 20.507 Federal Transit Formula Grants in the amount of $2,924,012 and 20.509 Formula Grants for Rural Areas and Tribal Transit Program in the amount of $2,259,151 on its preliminary SEFA. Cause of Condition The Agency’s existing internal control system is not designed to provide an accurate and complete SEFA. The procedures currently in place did not include sufficient review of the information and supporting documentation relating to federal awards before the SEFA was provided to the external auditors. The first version of the SEFA provided by the Agency reported total expenditures of $2,842,283; the final revised expenditures totaled $5,865,038. Effect of Condition The SEFA, which is prepared by the Agency and considered supplementary information to the financial statements, is a key part of the reporting package required by the Uniform Guidance. The SEFA also serves as the primary basis that the external auditors use to determine which programs will be audited as part of the single audit; therefore, the Agency’s responsibility for preparing an accurate and complete SEFA is critical. The inability to properly identify and track federal expenditures in the SEFA increases the likelihood that federal expenditures would not be fairly reported. There is increased risk of noncompliance with the requirements set forth in the U.S. Office of Management and Budget (OMB) Compliance Supplement, which can jeopardize future federal funding as well as result in the payback of federal awards. Recommendation We recommend the Agency implement internal controls to ensure the accuracy of program information, expenditure amounts, and assistance listing numbers. We also recommend the Agency strengthen its year-end closing procedures to ensure that all transactions and federal awards related to the fiscal year are properly captured and recorded in the general ledger to ensure the accuracy and completeness of the financial statements and supplementary schedules. Additionally, we recommend that the Agency provide sufficient resources and adequate oversight within the Agency to oversee the year-end closing procedures and preparation of the financial statements and supporting schedules. Lastly, we recommend the Agency provide training on an as needed basis for employees with financial reporting responsibilities. Management Response and Corrective Action Plan We acknowledge the findings regarding the preparation of the Schedule of Expenditures of Federal Awards (SEFA). Management agrees that there were errors in the classification and reporting of federal expenditures during the fiscal year 2023-2024, which resulted from inadequate review controls and documentation procedures. The Agency is committed to enhancing internal controls and year-end closing processes to ensure that the SEFA is complete, accurate, and compliant with 2 CFR Part 200 requirements.
Finding 2024-003 – Preparation of Schedule of Expenditures of Federal Awards (SEFA) (Material Weakness) (Repeat Finding) Program: All Assistance Listing (AL) No.: N/A Federal Agency: N/A Passed Through: N/A Award Year: Fiscal Year 2023-2024 Compliance Requirement: N/A Questioned Costs: None Criteria Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the Agency) must prepare a SEFA for the period covered by the auditee’s financial statements, which must include the total federal awards expended as determined in accordance with §200.502. In addition, §200.303 of the Uniform Guidance states that the Agency must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition During audit procedures performed over the SEFA, we noted that the Agency incorrectly included Federal expenditures from AL No. 20.507 and AL No. 20.509 that were accrued and recorded in fiscal year 2023 in the amount of $2,160,408, and excluded expenditures from AL No. 20.507 Federal Transit Formula Grants in the amount of $2,924,012 and 20.509 Formula Grants for Rural Areas and Tribal Transit Program in the amount of $2,259,151 on its preliminary SEFA. Cause of Condition The Agency’s existing internal control system is not designed to provide an accurate and complete SEFA. The procedures currently in place did not include sufficient review of the information and supporting documentation relating to federal awards before the SEFA was provided to the external auditors. The first version of the SEFA provided by the Agency reported total expenditures of $2,842,283; the final revised expenditures totaled $5,865,038. Effect of Condition The SEFA, which is prepared by the Agency and considered supplementary information to the financial statements, is a key part of the reporting package required by the Uniform Guidance. The SEFA also serves as the primary basis that the external auditors use to determine which programs will be audited as part of the single audit; therefore, the Agency’s responsibility for preparing an accurate and complete SEFA is critical. The inability to properly identify and track federal expenditures in the SEFA increases the likelihood that federal expenditures would not be fairly reported. There is increased risk of noncompliance with the requirements set forth in the U.S. Office of Management and Budget (OMB) Compliance Supplement, which can jeopardize future federal funding as well as result in the payback of federal awards. Recommendation We recommend the Agency implement internal controls to ensure the accuracy of program information, expenditure amounts, and assistance listing numbers. We also recommend the Agency strengthen its year-end closing procedures to ensure that all transactions and federal awards related to the fiscal year are properly captured and recorded in the general ledger to ensure the accuracy and completeness of the financial statements and supplementary schedules. Additionally, we recommend that the Agency provide sufficient resources and adequate oversight within the Agency to oversee the year-end closing procedures and preparation of the financial statements and supporting schedules. Lastly, we recommend the Agency provide training on an as needed basis for employees with financial reporting responsibilities. Management Response and Corrective Action Plan We acknowledge the findings regarding the preparation of the Schedule of Expenditures of Federal Awards (SEFA). Management agrees that there were errors in the classification and reporting of federal expenditures during the fiscal year 2023-2024, which resulted from inadequate review controls and documentation procedures. The Agency is committed to enhancing internal controls and year-end closing processes to ensure that the SEFA is complete, accurate, and compliant with 2 CFR Part 200 requirements.
Assistance Listing Number: 10.553, 10.555, 10.559 – Child Nutrition Cluster Pass-through Entity: Michigan Department of Education Finding Type: Material weakness in internal controls over compliance. Repeat Finding: No Criteria: 2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided by the School District was not complete and accurate. The audit team identified numerous errors throughout the course of our procedures which were brought to management’s attention. Questioned Costs: None Cause: Controls and processes in place to prepare the SEFA did not ensure that the SEFA was complete and accurate. Effect: The School District accumulates the financial data and other required information to complete the SEFA. The original SEFA provided by the School District to the audit team included several inaccuracies, including missing or incomplete expenditure amounts. The SEFA most significantly included the following inaccuracies: - $18,063 spent under ALN 10.553 (National School Breakfast Program) was improperly excluded from the SEFA. - $41,653 spent under ALN 10.555 (National School Lunch Program) was improperly excluded from the SEFA. Recommendation: The School District’s process for preparing the SEFA should be adjusted to ensure that accounting records are closed timely, internal accounts are reconciled (the SEFA should reconcile to the federal revenues recorded), and appropriate workpapers are prepared to support the SEFA balances. View of Responsible Officials: Management agrees with the finding and will implement procedures to ensure the SEFA is prepared accurately in the future.
Assistance Listing Number: 10.553, 10.555, 10.559 – Child Nutrition Cluster Pass-through Entity: Michigan Department of Education Finding Type: Material weakness in internal controls over compliance. Repeat Finding: No Criteria: 2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided by the School District was not complete and accurate. The audit team identified numerous errors throughout the course of our procedures which were brought to management’s attention. Questioned Costs: None Cause: Controls and processes in place to prepare the SEFA did not ensure that the SEFA was complete and accurate. Effect: The School District accumulates the financial data and other required information to complete the SEFA. The original SEFA provided by the School District to the audit team included several inaccuracies, including missing or incomplete expenditure amounts. The SEFA most significantly included the following inaccuracies: - $18,063 spent under ALN 10.553 (National School Breakfast Program) was improperly excluded from the SEFA. - $41,653 spent under ALN 10.555 (National School Lunch Program) was improperly excluded from the SEFA. Recommendation: The School District’s process for preparing the SEFA should be adjusted to ensure that accounting records are closed timely, internal accounts are reconciled (the SEFA should reconcile to the federal revenues recorded), and appropriate workpapers are prepared to support the SEFA balances. View of Responsible Officials: Management agrees with the finding and will implement procedures to ensure the SEFA is prepared accurately in the future.
Assistance Listing Number: 10.553, 10.555, 10.559 – Child Nutrition Cluster Pass-through Entity: Michigan Department of Education Finding Type: Material weakness in internal controls over compliance. Repeat Finding: No Criteria: 2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided by the School District was not complete and accurate. The audit team identified numerous errors throughout the course of our procedures which were brought to management’s attention. Questioned Costs: None Cause: Controls and processes in place to prepare the SEFA did not ensure that the SEFA was complete and accurate. Effect: The School District accumulates the financial data and other required information to complete the SEFA. The original SEFA provided by the School District to the audit team included several inaccuracies, including missing or incomplete expenditure amounts. The SEFA most significantly included the following inaccuracies: - $18,063 spent under ALN 10.553 (National School Breakfast Program) was improperly excluded from the SEFA. - $41,653 spent under ALN 10.555 (National School Lunch Program) was improperly excluded from the SEFA. Recommendation: The School District’s process for preparing the SEFA should be adjusted to ensure that accounting records are closed timely, internal accounts are reconciled (the SEFA should reconcile to the federal revenues recorded), and appropriate workpapers are prepared to support the SEFA balances. View of Responsible Officials: Management agrees with the finding and will implement procedures to ensure the SEFA is prepared accurately in the future.
Assistance Listing Number: 10.553, 10.555, 10.559 – Child Nutrition Cluster Pass-through Entity: Michigan Department of Education Finding Type: Material weakness in internal controls over compliance. Repeat Finding: No Criteria: 2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided by the School District was not complete and accurate. The audit team identified numerous errors throughout the course of our procedures which were brought to management’s attention. Questioned Costs: None Cause: Controls and processes in place to prepare the SEFA did not ensure that the SEFA was complete and accurate. Effect: The School District accumulates the financial data and other required information to complete the SEFA. The original SEFA provided by the School District to the audit team included several inaccuracies, including missing or incomplete expenditure amounts. The SEFA most significantly included the following inaccuracies: - $18,063 spent under ALN 10.553 (National School Breakfast Program) was improperly excluded from the SEFA. - $41,653 spent under ALN 10.555 (National School Lunch Program) was improperly excluded from the SEFA. Recommendation: The School District’s process for preparing the SEFA should be adjusted to ensure that accounting records are closed timely, internal accounts are reconciled (the SEFA should reconcile to the federal revenues recorded), and appropriate workpapers are prepared to support the SEFA balances. View of Responsible Officials: Management agrees with the finding and will implement procedures to ensure the SEFA is prepared accurately in the future.
Assistance Listing Number: 10.553, 10.555, 10.559 – Child Nutrition Cluster Pass-through Entity: Michigan Department of Education Finding Type: Material weakness in internal controls over compliance. Repeat Finding: No Criteria: 2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided by the School District was not complete and accurate. The audit team identified numerous errors throughout the course of our procedures which were brought to management’s attention. Questioned Costs: None Cause: Controls and processes in place to prepare the SEFA did not ensure that the SEFA was complete and accurate. Effect: The School District accumulates the financial data and other required information to complete the SEFA. The original SEFA provided by the School District to the audit team included several inaccuracies, including missing or incomplete expenditure amounts. The SEFA most significantly included the following inaccuracies: - $18,063 spent under ALN 10.553 (National School Breakfast Program) was improperly excluded from the SEFA. - $41,653 spent under ALN 10.555 (National School Lunch Program) was improperly excluded from the SEFA. Recommendation: The School District’s process for preparing the SEFA should be adjusted to ensure that accounting records are closed timely, internal accounts are reconciled (the SEFA should reconcile to the federal revenues recorded), and appropriate workpapers are prepared to support the SEFA balances. View of Responsible Officials: Management agrees with the finding and will implement procedures to ensure the SEFA is prepared accurately in the future.
2024-001 – Reporting - Preparation of the Schedule of Expenditures of Federal Awards Identification of the Federal Program – Department of Housing and Urban Development - 14.128 Mortgage Insurance Hospitals - FHA Section 242 Mortgage Insurance Program Loan Criteria – CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (Schedule) for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502”. Also, in accordance with CFR Section §200.302, a non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Condition – We noted that there were adjustments needed to the Schedule to include initial debt issuance costs incurred and drawn during the period in connection with the new HUD mortgage secured during January 2024. Cause – Internal controls over review of the completeness of the Schedule were not properly implemented during the period of additional mortgages secured. Such internal controls were designed to require timely review of the completeness of the Schedule by appropriate personnel. Effect – The Schedule for the year ended June 30, 2024 inappropriately excluded $845,273 of related expenditures against the latest HUD mortgage established during January 2024. Questioned costs – none Context – Internal controls did not operate as intended to ensure the Schedule captured nonrecurring expenditures. In connection with securing the January 2024 HUD mortgage, certain debt issuance costs were charged against the mortgage upon closing. These expenditures were not part of the routine expenditure and draw processes and controls in place at the Authority due to their unique nature and infrequency. Therefore, management did not identify such initial closing costs for capture on the Schedule. Repeat finding – No Recommendation – We recommend the Schedule to be reviewed timely and with sufficient precision by the appropriate level of personnel and reconciliation of new HUD mortgage closing documents. View of Responsible Officials - Management agrees with the Federal Award Finding regarding the determination of when a Federal award is expended. As part of the Corrective Action Plan, management will validate mortgage activity against HUD mortgage provided information.
Criteria: 2 CFR section 200.510(b) requires the auditee to prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that must contain all federal awards expended during the period. 2 CFR section 200.502 requires proper tracking and accounting of federal expenditures incurred under the same basis of accounting as the basic financial statements to ensure proper cutoff and reporting. Condition: The School failed to timely prepare a complete and accurate SEFA. Cause: The School did not have an adequate process to track expenditures of federal awards for which purchases were made on the School’s behalf by the pass-through grantor. This resulted in the School’s initial draft of their SEFA not including all federal expenditures made by the School. Effect: Failure to adequately track all expenditures of federal awards could result in the SEFA being prepared inaccurately or in an untimely manner. Recommendation: Marshall Jones recommends that the School establish a process to track the expenditures of federal awards during the year, including awards for which purchases are made on the School’s behalf by the pass-through grantor. This will better enable the School to timely prepare a complete and accurate SEFA. Views of Responsible Officials: Management of the School concurs with the finding. Please refer to the Corrective Action Plan.
Material Weakness in Internal Control Over Compliance Information on the Federal Programs: Assistance Listing Number 14.157 – Section 202 Supportive Housing for the Elderly, U.S. Department of Housing and Urban Development Assistance Listing Number 14.218 – Community Development Block Grants/Entitlement Grants, U.S. Department of Housing and Urban Development Assistance Listing Number 14.239 – HOME Investments Partnership Program, U.S. Department of Housing and Urban Development Criteria: The regulations in 2 CFR 200.510 requires the auditee to prepare a schedule of expenditures of Federal awards which includes the Federal awards expended for each individual Federal program and in total. Condition: For the year June 30, 2024, the unadjusted schedule of expenditures of Federal awards did not report the correct Federal awards expended for each individual Federal program or in total. Cause: Management does not have internal control over preparation of the schedule of expenditures of Federal awards or reconciliation of the reported expenditures to source documentation. Effect or Potential Effect: Material misstatements of the schedule of expenditures of Federal awards could be undetected and determination of major program(s) could be based on inaccurate information. Questioned Costs: None Context: This finding relates to all aspects of the schedule of expenditures of federal awards. Recommendation: We recommend that management develop and implement internal controls over the preparation of the schedule of expenditures of Federal awards. At a minimum, they should require identification of Federal award source documentation and documentation of how the expenditure amount reported for each was calculated. Views of Responsible Official: Management will develop internal controls and oversight over the schedule of expenditures of Federal awards.
Material Weakness in Internal Control Over Compliance Information on the Federal Programs: Assistance Listing Number 14.157 – Section 202 Supportive Housing for the Elderly, U.S. Department of Housing and Urban Development Assistance Listing Number 14.218 – Community Development Block Grants/Entitlement Grants, U.S. Department of Housing and Urban Development Assistance Listing Number 14.239 – HOME Investments Partnership Program, U.S. Department of Housing and Urban Development Criteria: The regulations in 2 CFR 200.510 requires the auditee to prepare a schedule of expenditures of Federal awards which includes the Federal awards expended for each individual Federal program and in total. Condition: For the year June 30, 2024, the unadjusted schedule of expenditures of Federal awards did not report the correct Federal awards expended for each individual Federal program or in total. Cause: Management does not have internal control over preparation of the schedule of expenditures of Federal awards or reconciliation of the reported expenditures to source documentation. Effect or Potential Effect: Material misstatements of the schedule of expenditures of Federal awards could be undetected and determination of major program(s) could be based on inaccurate information. Questioned Costs: None Context: This finding relates to all aspects of the schedule of expenditures of federal awards. Recommendation: We recommend that management develop and implement internal controls over the preparation of the schedule of expenditures of Federal awards. At a minimum, they should require identification of Federal award source documentation and documentation of how the expenditure amount reported for each was calculated. Views of Responsible Official: Management will develop internal controls and oversight over the schedule of expenditures of Federal awards.
Material Weakness in Internal Control Over Compliance Information on the Federal Programs: Assistance Listing Number 14.157 – Section 202 Supportive Housing for the Elderly, U.S. Department of Housing and Urban Development Assistance Listing Number 14.218 – Community Development Block Grants/Entitlement Grants, U.S. Department of Housing and Urban Development Assistance Listing Number 14.239 – HOME Investments Partnership Program, U.S. Department of Housing and Urban Development Criteria: The regulations in 2 CFR 200.510 requires the auditee to prepare a schedule of expenditures of Federal awards which includes the Federal awards expended for each individual Federal program and in total. Condition: For the year June 30, 2024, the unadjusted schedule of expenditures of Federal awards did not report the correct Federal awards expended for each individual Federal program or in total. Cause: Management does not have internal control over preparation of the schedule of expenditures of Federal awards or reconciliation of the reported expenditures to source documentation. Effect or Potential Effect: Material misstatements of the schedule of expenditures of Federal awards could be undetected and determination of major program(s) could be based on inaccurate information. Questioned Costs: None Context: This finding relates to all aspects of the schedule of expenditures of federal awards. Recommendation: We recommend that management develop and implement internal controls over the preparation of the schedule of expenditures of Federal awards. At a minimum, they should require identification of Federal award source documentation and documentation of how the expenditure amount reported for each was calculated. Views of Responsible Official: Management will develop internal controls and oversight over the schedule of expenditures of Federal awards.
Material Weakness in Internal Control Over Compliance Information on the Federal Programs: Assistance Listing Number 14.157 – Section 202 Supportive Housing for the Elderly, U.S. Department of Housing and Urban Development Assistance Listing Number 14.218 – Community Development Block Grants/Entitlement Grants, U.S. Department of Housing and Urban Development Assistance Listing Number 14.239 – HOME Investments Partnership Program, U.S. Department of Housing and Urban Development Criteria: The regulations in 2 CFR 200.510 requires the auditee to prepare a schedule of expenditures of Federal awards which includes the Federal awards expended for each individual Federal program and in total. Condition: For the year June 30, 2024, the unadjusted schedule of expenditures of Federal awards did not report the correct Federal awards expended for each individual Federal program or in total. Cause: Management does not have internal control over preparation of the schedule of expenditures of Federal awards or reconciliation of the reported expenditures to source documentation. Effect or Potential Effect: Material misstatements of the schedule of expenditures of Federal awards could be undetected and determination of major program(s) could be based on inaccurate information. Questioned Costs: None Context: This finding relates to all aspects of the schedule of expenditures of federal awards. Recommendation: We recommend that management develop and implement internal controls over the preparation of the schedule of expenditures of Federal awards. At a minimum, they should require identification of Federal award source documentation and documentation of how the expenditure amount reported for each was calculated. Views of Responsible Official: Management will develop internal controls and oversight over the schedule of expenditures of Federal awards.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, £200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, £200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, £200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, £200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, £200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, £200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, £200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, £200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, £200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, £200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, £200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
Finding 2024-002: Schedule of Expenditures of Federal Awards (Significant Deficiency) Information on the Federal Program: 93.243 - U.S. Department of Health and Human Services. See Finding 2024-001. Finding 2024-002 is a significant deficiency in internal control over compliance in addition to non-compliance related to the Reporting compliance area. There were no questioned costs as a result of excluding the awards provided by pass-through entities.Criteria or Specific Requirement: Management is responsible for the complete and fair presentation of the financial statements, including any supplementary information that is presented in relation to the financial statements, such as the Schedule of Expenditures of Federal Awards (SEFA). Also, in accordance with 2 CFR Section 200.510 (b)(2), the Council is required to include all direct and pass-through Federal awards expended during the fiscal year in the SEFA. Condition: During the audit management noted that several pass-through awards totaling $278,811 for the year ended June 30, 2024, had not been included on the SEFA. As a result, management provided a revised SEFA after audit testing had begun. Cause: The Council has not received pass-through awards in prior years and the omission appears to be due to a misunderstanding of the SEFA reporting requirements for pass-through awards. Effect or Potential Effect: The SEFA was missing federal expenditures of $278,811 at the start of the audit. When the SEFA is not accurately prepared, it could have an effect on the auditor's determination of major programs and on the auditor's sample selections. Recommendation: We recommend that the Council enhance its procedures related to the preparation of the SEFA to ensure all required amounts are included. Repeat Finding: This is not a repeat finding.
Finding 2024-002: Schedule of Expenditures of Federal Awards (Significant Deficiency) Information on the Federal Program: 93.243 - U.S. Department of Health and Human Services. See Finding 2024-001. Finding 2024-002 is a significant deficiency in internal control over compliance in addition to non-compliance related to the Reporting compliance area. There were no questioned costs as a result of excluding the awards provided by pass-through entities.Criteria or Specific Requirement: Management is responsible for the complete and fair presentation of the financial statements, including any supplementary information that is presented in relation to the financial statements, such as the Schedule of Expenditures of Federal Awards (SEFA). Also, in accordance with 2 CFR Section 200.510 (b)(2), the Council is required to include all direct and pass-through Federal awards expended during the fiscal year in the SEFA. Condition: During the audit management noted that several pass-through awards totaling $278,811 for the year ended June 30, 2024, had not been included on the SEFA. As a result, management provided a revised SEFA after audit testing had begun. Cause: The Council has not received pass-through awards in prior years and the omission appears to be due to a misunderstanding of the SEFA reporting requirements for pass-through awards. Effect or Potential Effect: The SEFA was missing federal expenditures of $278,811 at the start of the audit. When the SEFA is not accurately prepared, it could have an effect on the auditor's determination of major programs and on the auditor's sample selections. Recommendation: We recommend that the Council enhance its procedures related to the preparation of the SEFA to ensure all required amounts are included. Repeat Finding: This is not a repeat finding.
Finding 2024-002: Schedule of Expenditures of Federal Awards (Significant Deficiency) Information on the Federal Program: 93.243 - U.S. Department of Health and Human Services. See Finding 2024-001. Finding 2024-002 is a significant deficiency in internal control over compliance in addition to non-compliance related to the Reporting compliance area. There were no questioned costs as a result of excluding the awards provided by pass-through entities.Criteria or Specific Requirement: Management is responsible for the complete and fair presentation of the financial statements, including any supplementary information that is presented in relation to the financial statements, such as the Schedule of Expenditures of Federal Awards (SEFA). Also, in accordance with 2 CFR Section 200.510 (b)(2), the Council is required to include all direct and pass-through Federal awards expended during the fiscal year in the SEFA. Condition: During the audit management noted that several pass-through awards totaling $278,811 for the year ended June 30, 2024, had not been included on the SEFA. As a result, management provided a revised SEFA after audit testing had begun. Cause: The Council has not received pass-through awards in prior years and the omission appears to be due to a misunderstanding of the SEFA reporting requirements for pass-through awards. Effect or Potential Effect: The SEFA was missing federal expenditures of $278,811 at the start of the audit. When the SEFA is not accurately prepared, it could have an effect on the auditor's determination of major programs and on the auditor's sample selections. Recommendation: We recommend that the Council enhance its procedures related to the preparation of the SEFA to ensure all required amounts are included. Repeat Finding: This is not a repeat finding.
Finding 2024-002: Schedule of Expenditures of Federal Awards (Significant Deficiency) Information on the Federal Program: 93.243 - U.S. Department of Health and Human Services. See Finding 2024-001. Finding 2024-002 is a significant deficiency in internal control over compliance in addition to non-compliance related to the Reporting compliance area. There were no questioned costs as a result of excluding the awards provided by pass-through entities.Criteria or Specific Requirement: Management is responsible for the complete and fair presentation of the financial statements, including any supplementary information that is presented in relation to the financial statements, such as the Schedule of Expenditures of Federal Awards (SEFA). Also, in accordance with 2 CFR Section 200.510 (b)(2), the Council is required to include all direct and pass-through Federal awards expended during the fiscal year in the SEFA. Condition: During the audit management noted that several pass-through awards totaling $278,811 for the year ended June 30, 2024, had not been included on the SEFA. As a result, management provided a revised SEFA after audit testing had begun. Cause: The Council has not received pass-through awards in prior years and the omission appears to be due to a misunderstanding of the SEFA reporting requirements for pass-through awards. Effect or Potential Effect: The SEFA was missing federal expenditures of $278,811 at the start of the audit. When the SEFA is not accurately prepared, it could have an effect on the auditor's determination of major programs and on the auditor's sample selections. Recommendation: We recommend that the Council enhance its procedures related to the preparation of the SEFA to ensure all required amounts are included. Repeat Finding: This is not a repeat finding.
Finding 2024-002: Schedule of Expenditures of Federal Awards (Significant Deficiency) Information on the Federal Program: 93.243 - U.S. Department of Health and Human Services. See Finding 2024-001. Finding 2024-002 is a significant deficiency in internal control over compliance in addition to non-compliance related to the Reporting compliance area. There were no questioned costs as a result of excluding the awards provided by pass-through entities.Criteria or Specific Requirement: Management is responsible for the complete and fair presentation of the financial statements, including any supplementary information that is presented in relation to the financial statements, such as the Schedule of Expenditures of Federal Awards (SEFA). Also, in accordance with 2 CFR Section 200.510 (b)(2), the Council is required to include all direct and pass-through Federal awards expended during the fiscal year in the SEFA. Condition: During the audit management noted that several pass-through awards totaling $278,811 for the year ended June 30, 2024, had not been included on the SEFA. As a result, management provided a revised SEFA after audit testing had begun. Cause: The Council has not received pass-through awards in prior years and the omission appears to be due to a misunderstanding of the SEFA reporting requirements for pass-through awards. Effect or Potential Effect: The SEFA was missing federal expenditures of $278,811 at the start of the audit. When the SEFA is not accurately prepared, it could have an effect on the auditor's determination of major programs and on the auditor's sample selections. Recommendation: We recommend that the Council enhance its procedures related to the preparation of the SEFA to ensure all required amounts are included. Repeat Finding: This is not a repeat finding.
Criteria: 2 CFR 200.510 (b) requires an entity to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. The schedule must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 (a), which states that determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs. Condition: During the FY2024 Uniform Guidance audit, we noted that there were $1.2 million of funds from this program that had underlying transaction dates from FY2023. These expenditures were not reported on the FY2023 SEFA but rather were included in the FY2024 SEFA. The omission in the prior year did not result in a change to the major program determination for the 2023 or 2024 audits. Cause: In April 2023, Drexel received a subaward for the SNAP Cluster and a new active fund account was created in the accounting system to track expenses after the subaward was signed. This was set up as a new active award in the system, however there was already an existing advance fund account set up in pre-award status prior to the subaward being executed. The FY2023 expenditures were recorded in pre-award fund account and not the new active fund account. Management included the new active fund account in the population for FY2023 SEFA reporting which had no expenditures and excluded the pre-award fund account with the $1.2 million of charges. This accounting for the FY2023 expenditures was corrected in July 2023 (FY2024) but not in time for SEFA reporting purposes. Effect: FY2023 SEFA expenditures for the SNAP cluster were understated by $1.2 million. This amount has been reported in the FY2024 SEFA. Questioned Costs: None; Recommendation: Management should enhance the control in place to perform a more precise review of award status and other reconciling items when preparing and reviewing the SEFA reconciliation to the financial statements. Management's View and Corrective Action Plan: Management agrees with the finding. Refer to the Management Corrective Action Plan on page 81.
Criteria: 2 CFR 200.510 (b) requires an entity to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. The schedule must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 (a), which states that determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs. Condition: During the FY2024 Uniform Guidance audit, we noted that there were $1.2 million of funds from this program that had underlying transaction dates from FY2023. These expenditures were not reported on the FY2023 SEFA but rather were included in the FY2024 SEFA. The omission in the prior year did not result in a change to the major program determination for the 2023 or 2024 audits. Cause: In April 2023, Drexel received a subaward for the SNAP Cluster and a new active fund account was created in the accounting system to track expenses after the subaward was signed. This was set up as a new active award in the system, however there was already an existing advance fund account set up in pre-award status prior to the subaward being executed. The FY2023 expenditures were recorded in pre-award fund account and not the new active fund account. Management included the new active fund account in the population for FY2023 SEFA reporting which had no expenditures and excluded the pre-award fund account with the $1.2 million of charges. This accounting for the FY2023 expenditures was corrected in July 2023 (FY2024) but not in time for SEFA reporting purposes. Effect: FY2023 SEFA expenditures for the SNAP cluster were understated by $1.2 million. This amount has been reported in the FY2024 SEFA. Questioned Costs: None; Recommendation: Management should enhance the control in place to perform a more precise review of award status and other reconciling items when preparing and reviewing the SEFA reconciliation to the financial statements. Management's View and Corrective Action Plan: Management agrees with the finding. Refer to the Management Corrective Action Plan on page 81.
Criteria: 2 CFR 200.510 (b) requires an entity to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. The schedule must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 (a), which states that determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs. Condition: During the FY2024 Uniform Guidance audit, we noted that there were $1.2 million of funds from this program that had underlying transaction dates from FY2023. These expenditures were not reported on the FY2023 SEFA but rather were included in the FY2024 SEFA. The omission in the prior year did not result in a change to the major program determination for the 2023 or 2024 audits. Cause: In April 2023, Drexel received a subaward for the SNAP Cluster and a new active fund account was created in the accounting system to track expenses after the subaward was signed. This was set up as a new active award in the system, however there was already an existing advance fund account set up in pre-award status prior to the subaward being executed. The FY2023 expenditures were recorded in pre-award fund account and not the new active fund account. Management included the new active fund account in the population for FY2023 SEFA reporting which had no expenditures and excluded the pre-award fund account with the $1.2 million of charges. This accounting for the FY2023 expenditures was corrected in July 2023 (FY2024) but not in time for SEFA reporting purposes. Effect: FY2023 SEFA expenditures for the SNAP cluster were understated by $1.2 million. This amount has been reported in the FY2024 SEFA. Questioned Costs: None; Recommendation: Management should enhance the control in place to perform a more precise review of award status and other reconciling items when preparing and reviewing the SEFA reconciliation to the financial statements. Management's View and Corrective Action Plan: Management agrees with the finding. Refer to the Management Corrective Action Plan on page 81.
Finding 2024-004 U.S. Department of Treasury Federal Award Year Ending June 30, 2024 COVID-19: Coronavirus State and Local Fiscal Recovery Funds Lack of internal controls over the preparation of the Schedule of Expenditures of Federal Awards Criteria: In accordance with 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Condition: The Schedule of Expenditures for Federal Awards for the year ended June 30, 2024, was initially overstated by $529,900 due to an improper subrecipient verses beneficiary determination for a grant. Cause: While this original grant agreement specified that the Foundation was a subrecipient, the Foundation did not timely review a 2024 grant amendment or obtain further correspondence from the granter that updated the initial subrecipient determination to now identify the Foundation as a beneficiary, resulting in the removal of $529,900 from the Schedule of Expenditures for Federal Awards. Effect or potential effect: Improper reporting of federal expenditures results in errors on the Schedule of Expenditures for Federal Awards and can lead to inaccurate major program determination. In this instance, the error did result in an update to the major program determination. Questioned costs: None. Context: During the audit, we reviewed a July 2024 grant amendment from the grantor that removed a number of the original grant requirements and reclassified the Foundation as a “grantee.” Upon further inquiry with the grantor, it was discovered that the Foundation is no longer considered a subrecipient. Thus, the Foundation is a beneficiary, which resulted in the removal of incurred costs of $529,900 from the Schedule of Expenditures of Federal Awards. Recommendation: To ensure accuracy of the Schedule of Expenditures of Federal Awards, the Foundation should improve the processes and controls around timely identification of potential federal awards, which includes enhancing the review of any grant amendments and timely contacting passthrough entities to verify potential updates to the subrecipient verses beneficiary determination. Views of responsible officials of the auditee: The Foundation agrees with the above finding, and its response is included in the corrective action plan.
Assistance Listing Number, Federal Agency, and Program Name 84.425D, U.S. Department of Education, Education Stabilization Fund COVID 19 ESSER II Formula Fund II and 98c Learning Loss, and 84.425U, COVID 19 ESSER Education Equity Fund III Federal Award Identification Number and Year 213712, 213782, 213713, 2023 Pass through Entity Michigan Department of Education Finding Type Material weakness Criteria Per 2 CFR 200.510(b) and Section 500.508(b) of Title 2, Subtitle A, Chapter II, Part 200, Subpart F, auditees must prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) contained inaccuracies and incomplete information that was identified during the audit. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context Multiple grants were presented inaccurately from the SEFA prepared by management in federal payments received and expenditures reported, which was identified by the auditor during the annual audit and subsequently corrected on the SEFA. The inaccuracies was a combination of amounts recorded in the School District's ledger that were incorrectly reflected on the SEFA, and amounts that required adjustment in the School District's ledger and also on the SEFA that was identified in the course of the audit. Cause and Effect The School District did not have sufficient controls in place to properly reconcile federal revenue to the federal expenditures reflected on the SEFA to validate that all federal grants awarded and expended were included in the SEFA and presented accurately. Recommendation The School District should implement a process to ensure that the SEFA is prepared timely and that all grant expenditures are included accurately. Views of Responsible Officials and Corrective Action Plan The School District will develop a SEFA checklist to help ensure all federal expenditures are properly reported. Additional processes will be put in place by management to review the SEFA in advance of the annual audit to effectively meet audit report timelines and help ensure completeness, validity, and accuracy of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name 84.425D, U.S. Department of Education, Education Stabilization Fund COVID 19 ESSER II Formula Fund II and 98c Learning Loss, and 84.425U, COVID 19 ESSER Education Equity Fund III Federal Award Identification Number and Year 213712, 213782, 213713, 2023 Pass through Entity Michigan Department of Education Finding Type Material weakness Criteria Per 2 CFR 200.510(b) and Section 500.508(b) of Title 2, Subtitle A, Chapter II, Part 200, Subpart F, auditees must prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) contained inaccuracies and incomplete information that was identified during the audit. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context Multiple grants were presented inaccurately from the SEFA prepared by management in federal payments received and expenditures reported, which was identified by the auditor during the annual audit and subsequently corrected on the SEFA. The inaccuracies was a combination of amounts recorded in the School District's ledger that were incorrectly reflected on the SEFA, and amounts that required adjustment in the School District's ledger and also on the SEFA that was identified in the course of the audit. Cause and Effect The School District did not have sufficient controls in place to properly reconcile federal revenue to the federal expenditures reflected on the SEFA to validate that all federal grants awarded and expended were included in the SEFA and presented accurately. Recommendation The School District should implement a process to ensure that the SEFA is prepared timely and that all grant expenditures are included accurately. Views of Responsible Officials and Corrective Action Plan The School District will develop a SEFA checklist to help ensure all federal expenditures are properly reported. Additional processes will be put in place by management to review the SEFA in advance of the annual audit to effectively meet audit report timelines and help ensure completeness, validity, and accuracy of the final SEFA reporting.
Assistance Listing Number, Federal Agency, and Program Name 84.425D, U.S. Department of Education, Education Stabilization Fund COVID 19 ESSER II Formula Fund II and 98c Learning Loss, and 84.425U, COVID 19 ESSER Education Equity Fund III Federal Award Identification Number and Year 213712, 213782, 213713, 2023 Pass through Entity Michigan Department of Education Finding Type Material weakness Criteria Per 2 CFR 200.510(b) and Section 500.508(b) of Title 2, Subtitle A, Chapter II, Part 200, Subpart F, auditees must prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition The schedule of expenditures of federal awards (SEFA) contained inaccuracies and incomplete information that was identified during the audit. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context Multiple grants were presented inaccurately from the SEFA prepared by management in federal payments received and expenditures reported, which was identified by the auditor during the annual audit and subsequently corrected on the SEFA. The inaccuracies was a combination of amounts recorded in the School District's ledger that were incorrectly reflected on the SEFA, and amounts that required adjustment in the School District's ledger and also on the SEFA that was identified in the course of the audit. Cause and Effect The School District did not have sufficient controls in place to properly reconcile federal revenue to the federal expenditures reflected on the SEFA to validate that all federal grants awarded and expended were included in the SEFA and presented accurately. Recommendation The School District should implement a process to ensure that the SEFA is prepared timely and that all grant expenditures are included accurately. Views of Responsible Officials and Corrective Action Plan The School District will develop a SEFA checklist to help ensure all federal expenditures are properly reported. Additional processes will be put in place by management to review the SEFA in advance of the annual audit to effectively meet audit report timelines and help ensure completeness, validity, and accuracy of the final SEFA reporting.
Item 2024-007: Schedule of expenditures of federal awards presentation Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: HOME Investment Partnerships Program (ALN 14.239); Housing Trust Fund (ALN 14.275); COVID-19 - Emergency Rental Assistance (ALN 21.023); Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR section 200.510(b) which requires that the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502. Further, the Agency is required to comply with 2 CFR 200.512 which requires that the information included in the reporting package is accurate and complete. Condition: We noted the following errors in the original SEFA we received for the audit: Loans provided under the HOME Investment Partnerships Program (ALN 14.239) were understated by $8,641,271 Loans provided under the Housing Trust Fund (ALN 14.275) were understated by $4,466,122 Expenditures under the Emergency Rental Assistance Program (ALN 21.023) were understated by $382,418 Expenditures under the COVID-19—Homeowner Assistance Fund Program (ALN 21.026) are overstated $403,795 Expenditures under the COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) are overstated $99,928 Cause: There was a breakdown in the Agency’s procedures related to preparation and review of the SEFA. The Agency’s procedures for preparing the SEFA did not account for classification of certain loans subject to continuing compliance requirements. The errors of $8,641,271 related to ALN 14.239 and $4,466,122 related to ALN 14.275 were caused by the Agency not properly identifying certain loans required to be included on the SEFA. The error of $382,418 related to ALN 21.023 was caused by the Agency reducing a subscription software disbursement by the portion of the disbursement related to payments on the subscription liability. The errors of $403,795 and $99,928 related to ALN 21.026 and ALN 14.239, respectively, were caused by the Agency charging certain direct and indirect costs from fiscal year 2021, 2022, and 2023 to the programs in fiscal year 2024. Effect: The Agency adjusted its fiscal year 2024 SEFA by $13,489,811 for the errors related to ALN 14.239, 14.275, and 21.023. The expenditures for ALN 21.026 and 14.239 are overstated $403,795 and $99,928, respectively. Questioned Costs: None Context: The Agency’s expenditures of federal awards reported on the SEFA were understated by $13,489,811 which was corrected during the audit. The Agency’s expenditures of federal awards reported on the SEFA for ALN 21.026 and ALN 14.239 are overstated $403,795 and $99,928, respectively, which the Agency did not correct. Total expenditures reported on the SEFA, as adjusted for this matter, are $422,678,239. Repeat Finding?: No Recommendation: We recommend that the Agency review and strengthen its processes and controls over the preparation of the SEFA. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-007: Schedule of expenditures of federal awards presentation Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: HOME Investment Partnerships Program (ALN 14.239); Housing Trust Fund (ALN 14.275); COVID-19 - Emergency Rental Assistance (ALN 21.023); Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR section 200.510(b) which requires that the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502. Further, the Agency is required to comply with 2 CFR 200.512 which requires that the information included in the reporting package is accurate and complete. Condition: We noted the following errors in the original SEFA we received for the audit: Loans provided under the HOME Investment Partnerships Program (ALN 14.239) were understated by $8,641,271 Loans provided under the Housing Trust Fund (ALN 14.275) were understated by $4,466,122 Expenditures under the Emergency Rental Assistance Program (ALN 21.023) were understated by $382,418 Expenditures under the COVID-19—Homeowner Assistance Fund Program (ALN 21.026) are overstated $403,795 Expenditures under the COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) are overstated $99,928 Cause: There was a breakdown in the Agency’s procedures related to preparation and review of the SEFA. The Agency’s procedures for preparing the SEFA did not account for classification of certain loans subject to continuing compliance requirements. The errors of $8,641,271 related to ALN 14.239 and $4,466,122 related to ALN 14.275 were caused by the Agency not properly identifying certain loans required to be included on the SEFA. The error of $382,418 related to ALN 21.023 was caused by the Agency reducing a subscription software disbursement by the portion of the disbursement related to payments on the subscription liability. The errors of $403,795 and $99,928 related to ALN 21.026 and ALN 14.239, respectively, were caused by the Agency charging certain direct and indirect costs from fiscal year 2021, 2022, and 2023 to the programs in fiscal year 2024. Effect: The Agency adjusted its fiscal year 2024 SEFA by $13,489,811 for the errors related to ALN 14.239, 14.275, and 21.023. The expenditures for ALN 21.026 and 14.239 are overstated $403,795 and $99,928, respectively. Questioned Costs: None Context: The Agency’s expenditures of federal awards reported on the SEFA were understated by $13,489,811 which was corrected during the audit. The Agency’s expenditures of federal awards reported on the SEFA for ALN 21.026 and ALN 14.239 are overstated $403,795 and $99,928, respectively, which the Agency did not correct. Total expenditures reported on the SEFA, as adjusted for this matter, are $422,678,239. Repeat Finding?: No Recommendation: We recommend that the Agency review and strengthen its processes and controls over the preparation of the SEFA. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-007: Schedule of expenditures of federal awards presentation Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: HOME Investment Partnerships Program (ALN 14.239); Housing Trust Fund (ALN 14.275); COVID-19 - Emergency Rental Assistance (ALN 21.023); Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR section 200.510(b) which requires that the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502. Further, the Agency is required to comply with 2 CFR 200.512 which requires that the information included in the reporting package is accurate and complete. Condition: We noted the following errors in the original SEFA we received for the audit: Loans provided under the HOME Investment Partnerships Program (ALN 14.239) were understated by $8,641,271 Loans provided under the Housing Trust Fund (ALN 14.275) were understated by $4,466,122 Expenditures under the Emergency Rental Assistance Program (ALN 21.023) were understated by $382,418 Expenditures under the COVID-19—Homeowner Assistance Fund Program (ALN 21.026) are overstated $403,795 Expenditures under the COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) are overstated $99,928 Cause: There was a breakdown in the Agency’s procedures related to preparation and review of the SEFA. The Agency’s procedures for preparing the SEFA did not account for classification of certain loans subject to continuing compliance requirements. The errors of $8,641,271 related to ALN 14.239 and $4,466,122 related to ALN 14.275 were caused by the Agency not properly identifying certain loans required to be included on the SEFA. The error of $382,418 related to ALN 21.023 was caused by the Agency reducing a subscription software disbursement by the portion of the disbursement related to payments on the subscription liability. The errors of $403,795 and $99,928 related to ALN 21.026 and ALN 14.239, respectively, were caused by the Agency charging certain direct and indirect costs from fiscal year 2021, 2022, and 2023 to the programs in fiscal year 2024. Effect: The Agency adjusted its fiscal year 2024 SEFA by $13,489,811 for the errors related to ALN 14.239, 14.275, and 21.023. The expenditures for ALN 21.026 and 14.239 are overstated $403,795 and $99,928, respectively. Questioned Costs: None Context: The Agency’s expenditures of federal awards reported on the SEFA were understated by $13,489,811 which was corrected during the audit. The Agency’s expenditures of federal awards reported on the SEFA for ALN 21.026 and ALN 14.239 are overstated $403,795 and $99,928, respectively, which the Agency did not correct. Total expenditures reported on the SEFA, as adjusted for this matter, are $422,678,239. Repeat Finding?: No Recommendation: We recommend that the Agency review and strengthen its processes and controls over the preparation of the SEFA. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.