Criteria or Specific Requirement: Title 2 of the Code of Federal Regulations (CFR) 200.302(b)(4) requires non-federal entities to maintain effective internal control over federal programs. Specifically, the organization must reconcile its federal awards with expenditures incurred and revenue received. Additionally, 2 CFR Part 200.510(b)(1-6) specifies that a Schedule of Expenditures of Federal Awards (SEFA) be prepared for each fiscal year in accordance with the applicable federal regulations. The SEFA must include, at a minimum, total federal awards expended for each individual federal program and must accurately report all federal expenditures received and expended during the fiscal year. Condition and Context: During the audit, it was noted that Solvista Health does not reconcile federal awards with the expenditures used and revenue earned. Additionally, Solvista Health did not prepare an accurate SEFA. Questioned Costs: N/A Cause: Solvista Health’s accounting and internal control systems were not designed and implemented to ensure reconciliation of federal awards with expenditures and revenue, and the preparation of an accurate SEFA. Effect: Failure to reconcile federal awards with expenditures and related revenue, along with the absence of an accurate SEFA, could lead to incorrect reporting of federal funds, misstatement of financial information, and non-compliance with federal requirements. This represents a potential risk for improper use of federal funds and an inability to meet compliance and reporting obligations. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend Solvista Health design and implement internal control procedures to reconcile federal awards with the expenditures and revenue received to ensure completeness and accuracy in financial reporting. Additionally, management should prepare and maintain an accurate SEFA in accordance with 2 CFR 200.510 to ensure proper documentation and compliance with federal reporting requirements. Additionally, we recommend that Solvista Health train appropriate personnel on the requirements related to federal award reconciliations and SEFA preparation to mitigate the risk of noncompliance in the future.
Criteria or Specific Requirement: Title 2 of the Code of Federal Regulations (CFR) 200.302(b)(4) requires non-federal entities to maintain effective internal control over federal programs. Specifically, the organization must reconcile its federal awards with expenditures incurred and revenue received. Additionally, 2 CFR Part 200.510(b)(1-6) specifies that a Schedule of Expenditures of Federal Awards (SEFA) be prepared for each fiscal year in accordance with the applicable federal regulations. The SEFA must include, at a minimum, total federal awards expended for each individual federal program and must accurately report all federal expenditures received and expended during the fiscal year. Condition and Context: During the audit, it was noted that Solvista Health does not reconcile federal awards with the expenditures used and revenue earned. Additionally, Solvista Health did not prepare an accurate SEFA. Questioned Costs: N/A Cause: Solvista Health’s accounting and internal control systems were not designed and implemented to ensure reconciliation of federal awards with expenditures and revenue, and the preparation of an accurate SEFA. Effect: Failure to reconcile federal awards with expenditures and related revenue, along with the absence of an accurate SEFA, could lead to incorrect reporting of federal funds, misstatement of financial information, and non-compliance with federal requirements. This represents a potential risk for improper use of federal funds and an inability to meet compliance and reporting obligations. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend Solvista Health design and implement internal control procedures to reconcile federal awards with the expenditures and revenue received to ensure completeness and accuracy in financial reporting. Additionally, management should prepare and maintain an accurate SEFA in accordance with 2 CFR 200.510 to ensure proper documentation and compliance with federal reporting requirements. Additionally, we recommend that Solvista Health train appropriate personnel on the requirements related to federal award reconciliations and SEFA preparation to mitigate the risk of noncompliance in the future.
Criteria or Specific Requirement: Title 2 of the Code of Federal Regulations (CFR) 200.302(b)(4) requires non-federal entities to maintain effective internal control over federal programs. Specifically, the organization must reconcile its federal awards with expenditures incurred and revenue received. Additionally, 2 CFR Part 200.510(b)(1-6) specifies that a Schedule of Expenditures of Federal Awards (SEFA) be prepared for each fiscal year in accordance with the applicable federal regulations. The SEFA must include, at a minimum, total federal awards expended for each individual federal program and must accurately report all federal expenditures received and expended during the fiscal year. Condition and Context: During the audit, it was noted that Solvista Health does not reconcile federal awards with the expenditures used and revenue earned. Additionally, Solvista Health did not prepare an accurate SEFA. Questioned Costs: N/A Cause: Solvista Health’s accounting and internal control systems were not designed and implemented to ensure reconciliation of federal awards with expenditures and revenue, and the preparation of an accurate SEFA. Effect: Failure to reconcile federal awards with expenditures and related revenue, along with the absence of an accurate SEFA, could lead to incorrect reporting of federal funds, misstatement of financial information, and non-compliance with federal requirements. This represents a potential risk for improper use of federal funds and an inability to meet compliance and reporting obligations. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend Solvista Health design and implement internal control procedures to reconcile federal awards with the expenditures and revenue received to ensure completeness and accuracy in financial reporting. Additionally, management should prepare and maintain an accurate SEFA in accordance with 2 CFR 200.510 to ensure proper documentation and compliance with federal reporting requirements. Additionally, we recommend that Solvista Health train appropriate personnel on the requirements related to federal award reconciliations and SEFA preparation to mitigate the risk of noncompliance in the future.
Criteria or Specific Requirement: Title 2 of the Code of Federal Regulations (CFR) 200.302(b)(4) requires non-federal entities to maintain effective internal control over federal programs. Specifically, the organization must reconcile its federal awards with expenditures incurred and revenue received. Additionally, 2 CFR Part 200.510(b)(1-6) specifies that a Schedule of Expenditures of Federal Awards (SEFA) be prepared for each fiscal year in accordance with the applicable federal regulations. The SEFA must include, at a minimum, total federal awards expended for each individual federal program and must accurately report all federal expenditures received and expended during the fiscal year. Condition and Context: During the audit, it was noted that Solvista Health does not reconcile federal awards with the expenditures used and revenue earned. Additionally, Solvista Health did not prepare an accurate SEFA. Questioned Costs: N/A Cause: Solvista Health’s accounting and internal control systems were not designed and implemented to ensure reconciliation of federal awards with expenditures and revenue, and the preparation of an accurate SEFA. Effect: Failure to reconcile federal awards with expenditures and related revenue, along with the absence of an accurate SEFA, could lead to incorrect reporting of federal funds, misstatement of financial information, and non-compliance with federal requirements. This represents a potential risk for improper use of federal funds and an inability to meet compliance and reporting obligations. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend Solvista Health design and implement internal control procedures to reconcile federal awards with the expenditures and revenue received to ensure completeness and accuracy in financial reporting. Additionally, management should prepare and maintain an accurate SEFA in accordance with 2 CFR 200.510 to ensure proper documentation and compliance with federal reporting requirements. Additionally, we recommend that Solvista Health train appropriate personnel on the requirements related to federal award reconciliations and SEFA preparation to mitigate the risk of noncompliance in the future.
Criteria or Specific Requirement: Title 2 of the Code of Federal Regulations (CFR) 200.302(b)(4) requires non-federal entities to maintain effective internal control over federal programs. Specifically, the organization must reconcile its federal awards with expenditures incurred and revenue received. Additionally, 2 CFR Part 200.510(b)(1-6) specifies that a Schedule of Expenditures of Federal Awards (SEFA) be prepared for each fiscal year in accordance with the applicable federal regulations. The SEFA must include, at a minimum, total federal awards expended for each individual federal program and must accurately report all federal expenditures received and expended during the fiscal year. Condition and Context: During the audit, it was noted that Solvista Health does not reconcile federal awards with the expenditures used and revenue earned. Additionally, Solvista Health did not prepare an accurate SEFA. Questioned Costs: N/A Cause: Solvista Health’s accounting and internal control systems were not designed and implemented to ensure reconciliation of federal awards with expenditures and revenue, and the preparation of an accurate SEFA. Effect: Failure to reconcile federal awards with expenditures and related revenue, along with the absence of an accurate SEFA, could lead to incorrect reporting of federal funds, misstatement of financial information, and non-compliance with federal requirements. This represents a potential risk for improper use of federal funds and an inability to meet compliance and reporting obligations. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend Solvista Health design and implement internal control procedures to reconcile federal awards with the expenditures and revenue received to ensure completeness and accuracy in financial reporting. Additionally, management should prepare and maintain an accurate SEFA in accordance with 2 CFR 200.510 to ensure proper documentation and compliance with federal reporting requirements. Additionally, we recommend that Solvista Health train appropriate personnel on the requirements related to federal award reconciliations and SEFA preparation to mitigate the risk of noncompliance in the future.
Criteria or Specific Requirement: Title 2 of the Code of Federal Regulations (CFR) 200.302(b)(4) requires non-federal entities to maintain effective internal control over federal programs. Specifically, the organization must reconcile its federal awards with expenditures incurred and revenue received. Additionally, 2 CFR Part 200.510(b)(1-6) specifies that a Schedule of Expenditures of Federal Awards (SEFA) be prepared for each fiscal year in accordance with the applicable federal regulations. The SEFA must include, at a minimum, total federal awards expended for each individual federal program and must accurately report all federal expenditures received and expended during the fiscal year. Condition and Context: During the audit, it was noted that Solvista Health does not reconcile federal awards with the expenditures used and revenue earned. Additionally, Solvista Health did not prepare an accurate SEFA. Questioned Costs: N/A Cause: Solvista Health’s accounting and internal control systems were not designed and implemented to ensure reconciliation of federal awards with expenditures and revenue, and the preparation of an accurate SEFA. Effect: Failure to reconcile federal awards with expenditures and related revenue, along with the absence of an accurate SEFA, could lead to incorrect reporting of federal funds, misstatement of financial information, and non-compliance with federal requirements. This represents a potential risk for improper use of federal funds and an inability to meet compliance and reporting obligations. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend Solvista Health design and implement internal control procedures to reconcile federal awards with the expenditures and revenue received to ensure completeness and accuracy in financial reporting. Additionally, management should prepare and maintain an accurate SEFA in accordance with 2 CFR 200.510 to ensure proper documentation and compliance with federal reporting requirements. Additionally, we recommend that Solvista Health train appropriate personnel on the requirements related to federal award reconciliations and SEFA preparation to mitigate the risk of noncompliance in the future.
Criteria or Specific Requirement: Title 2 of the Code of Federal Regulations (CFR) 200.302(b)(4) requires non-federal entities to maintain effective internal control over federal programs. Specifically, the organization must reconcile its federal awards with expenditures incurred and revenue received. Additionally, 2 CFR Part 200.510(b)(1-6) specifies that a Schedule of Expenditures of Federal Awards (SEFA) be prepared for each fiscal year in accordance with the applicable federal regulations. The SEFA must include, at a minimum, total federal awards expended for each individual federal program and must accurately report all federal expenditures received and expended during the fiscal year. Condition and Context: During the audit, it was noted that Solvista Health does not reconcile federal awards with the expenditures used and revenue earned. Additionally, Solvista Health did not prepare an accurate SEFA. Questioned Costs: N/A Cause: Solvista Health’s accounting and internal control systems were not designed and implemented to ensure reconciliation of federal awards with expenditures and revenue, and the preparation of an accurate SEFA. Effect: Failure to reconcile federal awards with expenditures and related revenue, along with the absence of an accurate SEFA, could lead to incorrect reporting of federal funds, misstatement of financial information, and non-compliance with federal requirements. This represents a potential risk for improper use of federal funds and an inability to meet compliance and reporting obligations. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend Solvista Health design and implement internal control procedures to reconcile federal awards with the expenditures and revenue received to ensure completeness and accuracy in financial reporting. Additionally, management should prepare and maintain an accurate SEFA in accordance with 2 CFR 200.510 to ensure proper documentation and compliance with federal reporting requirements. Additionally, we recommend that Solvista Health train appropriate personnel on the requirements related to federal award reconciliations and SEFA preparation to mitigate the risk of noncompliance in the future.
Criteria or Specific Requirement: Title 2 of the Code of Federal Regulations (CFR) 200.302(b)(4) requires non-federal entities to maintain effective internal control over federal programs. Specifically, the organization must reconcile its federal awards with expenditures incurred and revenue received. Additionally, 2 CFR Part 200.510(b)(1-6) specifies that a Schedule of Expenditures of Federal Awards (SEFA) be prepared for each fiscal year in accordance with the applicable federal regulations. The SEFA must include, at a minimum, total federal awards expended for each individual federal program and must accurately report all federal expenditures received and expended during the fiscal year. Condition and Context: During the audit, it was noted that Solvista Health does not reconcile federal awards with the expenditures used and revenue earned. Additionally, Solvista Health did not prepare an accurate SEFA. Questioned Costs: N/A Cause: Solvista Health’s accounting and internal control systems were not designed and implemented to ensure reconciliation of federal awards with expenditures and revenue, and the preparation of an accurate SEFA. Effect: Failure to reconcile federal awards with expenditures and related revenue, along with the absence of an accurate SEFA, could lead to incorrect reporting of federal funds, misstatement of financial information, and non-compliance with federal requirements. This represents a potential risk for improper use of federal funds and an inability to meet compliance and reporting obligations. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend Solvista Health design and implement internal control procedures to reconcile federal awards with the expenditures and revenue received to ensure completeness and accuracy in financial reporting. Additionally, management should prepare and maintain an accurate SEFA in accordance with 2 CFR 200.510 to ensure proper documentation and compliance with federal reporting requirements. Additionally, we recommend that Solvista Health train appropriate personnel on the requirements related to federal award reconciliations and SEFA preparation to mitigate the risk of noncompliance in the future.
Criteria or Specific Requirement: Title 2 of the Code of Federal Regulations (CFR) 200.302(b)(4) requires non-federal entities to maintain effective internal control over federal programs. Specifically, the organization must reconcile its federal awards with expenditures incurred and revenue received. Additionally, 2 CFR Part 200.510(b)(1-6) specifies that a Schedule of Expenditures of Federal Awards (SEFA) be prepared for each fiscal year in accordance with the applicable federal regulations. The SEFA must include, at a minimum, total federal awards expended for each individual federal program and must accurately report all federal expenditures received and expended during the fiscal year. Condition and Context: During the audit, it was noted that Solvista Health does not reconcile federal awards with the expenditures used and revenue earned. Additionally, Solvista Health did not prepare an accurate SEFA. Questioned Costs: N/A Cause: Solvista Health’s accounting and internal control systems were not designed and implemented to ensure reconciliation of federal awards with expenditures and revenue, and the preparation of an accurate SEFA. Effect: Failure to reconcile federal awards with expenditures and related revenue, along with the absence of an accurate SEFA, could lead to incorrect reporting of federal funds, misstatement of financial information, and non-compliance with federal requirements. This represents a potential risk for improper use of federal funds and an inability to meet compliance and reporting obligations. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend Solvista Health design and implement internal control procedures to reconcile federal awards with the expenditures and revenue received to ensure completeness and accuracy in financial reporting. Additionally, management should prepare and maintain an accurate SEFA in accordance with 2 CFR 200.510 to ensure proper documentation and compliance with federal reporting requirements. Additionally, we recommend that Solvista Health train appropriate personnel on the requirements related to federal award reconciliations and SEFA preparation to mitigate the risk of noncompliance in the future.
Criteria or Specific Requirement: 2 CFR 200.302(b)(4) requires non-federal entities to maintain effective internal control over federal programs. Specifically, the organization must reconcile its federal awards with expenditures incurred and revenue received. Additionally, 2 CFR Part 200.510(b)(1-6) mandates that a Schedule of Expenditures of Federal Awards (SEFA) be prepared for each fiscal year in accordance with the applicable federal regulations. The SEFA must include, at a minimum, total federal awards expended for each individual federal program and must accurately report all federal expenditures received and expended during the fiscal year. Condition and Context: During our audit procedures performed over the current year SEFA, it was noted that Solvista Health improperly excluded expenditures for two federal awards from its June 30, 2023 SEFA. Questioned Costs: N/A Cause: Solvista Health’s accounting and internal control systems were not designed and implemented to ensure reconciliation of federal awards with expenditures and revenue, and the preparation of an accurate SEFA. Effect: Failure to reconcile federal awards with expenditures, along with an incomplete and inaccurate SEFA, could lead to incorrect reporting of federal funds, misstatement of financial information, and noncompliance with federal requirements. This represents a potential risk for improper use of federal funds and an inability to meet compliance and reporting obligations. Additionally, the omission of federal awards from the June 30, 2023 SEFA resulted in noncompliance with federal reporting requirements and inaccurate representation of Solvista Health’s federal award activity. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend Solvista Health design and implement internal control procedures to reconcile federal awards with the expenditures and revenue received to ensure completeness and accuracy in financial reporting. Additionally, management should prepare and maintain an accurate SEFA in accordance with 2 CFR 200.510 to ensure proper documentation and compliance with federal reporting requirements. Additionally, we recommend that Solvista Health train appropriate personnel on the requirements related to federal award reconciliations and SEFA preparation to mitigate the risk of noncompliance in the future.
Criteria or Specific Requirement: 2 CFR 200.302(b)(4) requires non-federal entities to maintain effective internal control over federal programs. Specifically, the organization must reconcile its federal awards with expenditures incurred and revenue received. Additionally, 2 CFR Part 200.510(b)(1-6) mandates that a Schedule of Expenditures of Federal Awards (SEFA) be prepared for each fiscal year in accordance with the applicable federal regulations. The SEFA must include, at a minimum, total federal awards expended for each individual federal program and must accurately report all federal expenditures received and expended during the fiscal year. Condition and Context: During our audit procedures performed over the current year SEFA, it was noted that Solvista Health improperly excluded expenditures for two federal awards from its June 30, 2023 SEFA. Questioned Costs: N/A Cause: Solvista Health’s accounting and internal control systems were not designed and implemented to ensure reconciliation of federal awards with expenditures and revenue, and the preparation of an accurate SEFA. Effect: Failure to reconcile federal awards with expenditures, along with an incomplete and inaccurate SEFA, could lead to incorrect reporting of federal funds, misstatement of financial information, and noncompliance with federal requirements. This represents a potential risk for improper use of federal funds and an inability to meet compliance and reporting obligations. Additionally, the omission of federal awards from the June 30, 2023 SEFA resulted in noncompliance with federal reporting requirements and inaccurate representation of Solvista Health’s federal award activity. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend Solvista Health design and implement internal control procedures to reconcile federal awards with the expenditures and revenue received to ensure completeness and accuracy in financial reporting. Additionally, management should prepare and maintain an accurate SEFA in accordance with 2 CFR 200.510 to ensure proper documentation and compliance with federal reporting requirements. Additionally, we recommend that Solvista Health train appropriate personnel on the requirements related to federal award reconciliations and SEFA preparation to mitigate the risk of noncompliance in the future.
Condition: The Organization tracks grants by individual cost-centers, which allows for total revenue and total expenditures by grant to be easily identifiable. In preparation of the Schedule of Expenditures of Federal Awards (SEFA), the Organization did not include a significant grant that is sourced from federal funds and required for testing. Criteria: Section 2 CFR 200.510(b) of the Uniform Guidance requires that an auditee prepare a schedule of expenditures of federal awards, which includes individual federal programs by federal agency and total federal awards expended for each individual federal program and Assistance Listing Number. Management is responsible for establishing and maintaining an effective system of internal control to allow for complete and accurate preparation of the SEFA. Cause: The Organization received a new one-time agreement during 2024, and the granting agency did not provide sufficient information for the Organization to clarify the funds were derived from federal funds. As such, the finance team did not include the grant expenditures in the schedule of expenditures of federal awards. Effect: Inaccurate reporting of federal expenditures could result inaccurate major program determinations, risk assessments, identification of compliance requirements, and ultimately incomplete reporting of federal funds expended to granting agencies. Questioned Costs: None reported. Context/Sampling: Sampling was not used. Repeat Findings From Prior Year: No. Recommendation: We recommend management review all new grant agreements for indicators of federal awards (such as an Assistance Listing or CFDA number, references to federal regulations, references to federal laws or bills, etc.), and communicate with granting agencies for clarity. We recommend management receive confirmation in writing from any granting agencies about the source of any grants, when there is doubt about whether a grant is federally-sourced or not. Management Response: Management agrees with the recommendation and will ensure both program and financial staff understand the importance of determining the source of new grant funds, to ensure the schedule of expenditure of federal awards is accurately prepared.
PREPARATION OF SCHEDULE OF EXPENDITURES AND FEDERAL AWARDS QUESTIONED COSTS: N/A Criteria: The Uniform Guidance Subpart F section 200.510 requires the preparation of the Schedule of Expenditures of Federal Awards (SEFA) that includes an accurate reporting of federal awards expended based on the terms and conditions of the grants along with the amount of funds disbursed to sub-recipients. In order for the SEFA to be prepared accurately and properly report the amounts expended for federal awards, a system of controls should be in existence that includes the identification of federal expenditures, timely and accurate preparation and review of the amounts reported on the SEFA. Condition: The initial SEFA prepared by the School Bord’s did not accurately include or identify all the federal award expenditures. The initial SEFA provided for audit included $119,736,508 of expenditures while the final SEFA included $186,491,326. This finding is repeated from the prior year. See the Summary Schedule of Prior Year Findings and Questioned Cost item 2023-003. Universe/ Population: None Sample size: None Cause: The grant awards or agreements were not properly interpreted or reviewed to identify or determine the proper amount to be reported as expenditures or SEFA. The 2 CFR Part 200, Appendix XI, Compliance Supplement publishes and distributed by the President of the United States’ Office of Management and Budget includes requirements for SEFA reporting that were not complied with. Effect: The SEFA provided to us for audit did not contain all the federal programs or the correct amounts of federal expenditures based on the terms of the grant awards and requirements to reporting on some of the federal programs reported. Inaccuracies or excluding information on the SEFA causes delays in completing the single audit and risks filing a SEFA that is incomplete or inaccurate. In addition, auditors may not identify and test the correct major federal programs in accordance with the Uniform Guidance. Recommendation: The School Board should strengthen its controls including its review and approval processes over the identification of federal programs, and the information and balances that are accumulated and reported on the SEFA to make sure the expenditures reported are an accurate representation of federal expenditures. View of Responsible Official: Management agrees with finding. Disaster Grants through FEMA are managed by rules and processes that are not easily accounted for in traditional accounting systems. Procedures will be strengthened to fully and accurately identify all federal program expenditures and record in the appropriate accounting funds.
Assistance Listing Number, Federal Agency, and Program Name 21.011, U.S. Department of the Treasury Capital Magnet Fund Federal Award Identification Number and Year Year ended June 30, 2024 Pass through Entity Ohio Department of Development Supportive Housing Program Finding Type Significant deficiency Repeat Finding No Criteria Per 2 CFR Section 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 determined in accordance with Section 200.502. Condition The expenditures were reported for the Capital Magnet Fund throughout the award period from the year ended June 30, 2019 to the year ended June 30, 2024 on the schedule of expenditures of federal awards (SEFA) but did not accurately report the amount of administrative expenditures incurred during the performance period, and, therefore, the SEFA was not complete and accurate for the year ended June 30, 2019 to the year ended June 30, 2024. Questioned Costs None If Questioned Costs are Not Determinable, Description of Why Known Questioned Costs were Undetermined or Otherwise Could Not be Reported N/A Identification of How Questioned Costs Were Computed N/A Context The Organization did not accurately report the administration costs on the SEFA. The Organization incorrectly omitted $375,000 of administration costs that were incurred during the year ended June 30, 2019; however, management implemented controls during the year ended June 30, 2024 that discovered the error, and, therefore, the $375,000 of omitted costs were included on the SEFA during the year ended June 30, 2024. Cause and Effect The Organization did not review all previously reported expenditures on the schedule of expenditures of federal awards for the Capital Magnet Program over the award period and omitted $375,000 of expenditures related to funding received from the Capital Magnet Fund for administrative costs. Recommendation We recommend the Organization implement a process and controls to have additional review of the SEFA compared to the Capital Magnet Performance Report to ensure the expenditures on the SEFA are complete and accurate and any errors are discovered and corrected timely. Views of Responsible Officials and Corrective Action Plan Management has implemented procedures and controls to ensure reports are reviewed prior to submission and distributed funds are reported properly and in the correct period.
Reference Number 2024-005 – Incomplete Schedule of Expenditures of Federal Awards Evaluation of Finding Material Weakness and Noncompliance – Various Federal Programs Criteria According to the Government Auditing Standards (Yellow Book) and the Uniform Guidance, 2 CFR Part 200, Subpart F—Audit Requirements, sections 200.508 and 200.510, entities receiving federal awards must prepare and submit a complete and accurate Schedule of Expenditures of Federal Awards (SEFA) as part of their annual financial reporting. This schedule is crucial for auditors to determine major programs and conduct the necessary audits in compliance with federal regulations. Condition The City failed to provide a complete SEFA for the fiscal year, leading to inaccuracies pertaining to the ARPA program. This omission resulted in a direct impact on the determination of major programs. Cause The incomplete SEFA was caused by a lack of oversight and insufficient internal controls within the City's financial management department. Effect or Potential Effect The failure to provide a complete SEFA has significant implications, including: • Inaccurate determination of major programs, which can affect the scope and quality of the audit process. • Increased risk of non-compliance with federal regulations, potentially leading to financial penalties and loss of federal funding. Context The City did not submit a complete SEFA for the year ended June 30, 2024, as required by federal guidelines. This incomplete reporting could compromise transparency, affect audit procedures, and hinder compliance with federal regulations. Repeat Finding Yes, in relation to reconciliation of grant activity. Recommendation To address this material weakness, the following actions are recommended: • Develop detailed procedures and timelines: Establish and enforce comprehensive procedures and timelines for the preparation and submission of the SEFA to ensure completeness and accuracy. • Enhance staffing and resources: Allocate adequate staffing and resources to the financial management department to support the accurate compilation and timely submission of the SEFA. • Provide comprehensive training: Offer training to financial management staff on the requirements and importance of the SEFA, including techniques for ensuring its accuracy and completeness.. • Regularly audit the SEFA preparation process: Conduct regular audits of the SEFA preparation process to ensure compliance with established policies and procedures and address any deficiencies promptly. This should be completed monthly and at a minimum quarterly. By implementing these recommendations, the City can strengthen its internal controls, improve the accuracy of its financial reporting, and ensure compliance with Government Auditing Standards and other regulatory requirements. Management Response Management agrees with the finding and recommendations. The City will begin to implement policies and procedures to assist with monthly reconciliations and review processes to mitigate these errors in the future. Reference Number 2024-005 – Incomplete Schedule of Expenditures of Federal Awards Material Weakness and Noncompliance Assistance Listing Number: All Federal Programs reported on the SEFA Criteria Refer to finding 2024-005 in section II above. Condition Refer to finding 2024-005 in section II above. Cause of Condition Refer to finding 2024-005 in section II above. Effect or Potential Effect of Condition Refer to finding 2024-005 in section II above. Questioned costs None. Context Refer to finding 2024-005 in section II above. Repeat Finding Refer to finding 2024-005 in section II above. Recommendation Refer to finding 2024-005 in section II above. Management Response Refer to finding 2024-005 in section II above.
Reference Number 2024-005 – Incomplete Schedule of Expenditures of Federal Awards Evaluation of Finding Material Weakness and Noncompliance – Various Federal Programs Criteria According to the Government Auditing Standards (Yellow Book) and the Uniform Guidance, 2 CFR Part 200, Subpart F—Audit Requirements, sections 200.508 and 200.510, entities receiving federal awards must prepare and submit a complete and accurate Schedule of Expenditures of Federal Awards (SEFA) as part of their annual financial reporting. This schedule is crucial for auditors to determine major programs and conduct the necessary audits in compliance with federal regulations. Condition The City failed to provide a complete SEFA for the fiscal year, leading to inaccuracies pertaining to the ARPA program. This omission resulted in a direct impact on the determination of major programs. Cause The incomplete SEFA was caused by a lack of oversight and insufficient internal controls within the City's financial management department. Effect or Potential Effect The failure to provide a complete SEFA has significant implications, including: • Inaccurate determination of major programs, which can affect the scope and quality of the audit process. • Increased risk of non-compliance with federal regulations, potentially leading to financial penalties and loss of federal funding. Context The City did not submit a complete SEFA for the year ended June 30, 2024, as required by federal guidelines. This incomplete reporting could compromise transparency, affect audit procedures, and hinder compliance with federal regulations. Repeat Finding Yes, in relation to reconciliation of grant activity. Recommendation To address this material weakness, the following actions are recommended: • Develop detailed procedures and timelines: Establish and enforce comprehensive procedures and timelines for the preparation and submission of the SEFA to ensure completeness and accuracy. • Enhance staffing and resources: Allocate adequate staffing and resources to the financial management department to support the accurate compilation and timely submission of the SEFA. • Provide comprehensive training: Offer training to financial management staff on the requirements and importance of the SEFA, including techniques for ensuring its accuracy and completeness.. • Regularly audit the SEFA preparation process: Conduct regular audits of the SEFA preparation process to ensure compliance with established policies and procedures and address any deficiencies promptly. This should be completed monthly and at a minimum quarterly. By implementing these recommendations, the City can strengthen its internal controls, improve the accuracy of its financial reporting, and ensure compliance with Government Auditing Standards and other regulatory requirements. Management Response Management agrees with the finding and recommendations. The City will begin to implement policies and procedures to assist with monthly reconciliations and review processes to mitigate these errors in the future. Reference Number 2024-005 – Incomplete Schedule of Expenditures of Federal Awards Material Weakness and Noncompliance Assistance Listing Number: All Federal Programs reported on the SEFA Criteria Refer to finding 2024-005 in section II above. Condition Refer to finding 2024-005 in section II above. Cause of Condition Refer to finding 2024-005 in section II above. Effect or Potential Effect of Condition Refer to finding 2024-005 in section II above. Questioned costs None. Context Refer to finding 2024-005 in section II above. Repeat Finding Refer to finding 2024-005 in section II above. Recommendation Refer to finding 2024-005 in section II above. Management Response Refer to finding 2024-005 in section II above.
Reference Number 2024-005 – Incomplete Schedule of Expenditures of Federal Awards Evaluation of Finding Material Weakness and Noncompliance – Various Federal Programs Criteria According to the Government Auditing Standards (Yellow Book) and the Uniform Guidance, 2 CFR Part 200, Subpart F—Audit Requirements, sections 200.508 and 200.510, entities receiving federal awards must prepare and submit a complete and accurate Schedule of Expenditures of Federal Awards (SEFA) as part of their annual financial reporting. This schedule is crucial for auditors to determine major programs and conduct the necessary audits in compliance with federal regulations. Condition The City failed to provide a complete SEFA for the fiscal year, leading to inaccuracies pertaining to the ARPA program. This omission resulted in a direct impact on the determination of major programs. Cause The incomplete SEFA was caused by a lack of oversight and insufficient internal controls within the City's financial management department. Effect or Potential Effect The failure to provide a complete SEFA has significant implications, including: • Inaccurate determination of major programs, which can affect the scope and quality of the audit process. • Increased risk of non-compliance with federal regulations, potentially leading to financial penalties and loss of federal funding. Context The City did not submit a complete SEFA for the year ended June 30, 2024, as required by federal guidelines. This incomplete reporting could compromise transparency, affect audit procedures, and hinder compliance with federal regulations. Repeat Finding Yes, in relation to reconciliation of grant activity. Recommendation To address this material weakness, the following actions are recommended: • Develop detailed procedures and timelines: Establish and enforce comprehensive procedures and timelines for the preparation and submission of the SEFA to ensure completeness and accuracy. • Enhance staffing and resources: Allocate adequate staffing and resources to the financial management department to support the accurate compilation and timely submission of the SEFA. • Provide comprehensive training: Offer training to financial management staff on the requirements and importance of the SEFA, including techniques for ensuring its accuracy and completeness.. • Regularly audit the SEFA preparation process: Conduct regular audits of the SEFA preparation process to ensure compliance with established policies and procedures and address any deficiencies promptly. This should be completed monthly and at a minimum quarterly. By implementing these recommendations, the City can strengthen its internal controls, improve the accuracy of its financial reporting, and ensure compliance with Government Auditing Standards and other regulatory requirements. Management Response Management agrees with the finding and recommendations. The City will begin to implement policies and procedures to assist with monthly reconciliations and review processes to mitigate these errors in the future. Reference Number 2024-005 – Incomplete Schedule of Expenditures of Federal Awards Material Weakness and Noncompliance Assistance Listing Number: All Federal Programs reported on the SEFA Criteria Refer to finding 2024-005 in section II above. Condition Refer to finding 2024-005 in section II above. Cause of Condition Refer to finding 2024-005 in section II above. Effect or Potential Effect of Condition Refer to finding 2024-005 in section II above. Questioned costs None. Context Refer to finding 2024-005 in section II above. Repeat Finding Refer to finding 2024-005 in section II above. Recommendation Refer to finding 2024-005 in section II above. Management Response Refer to finding 2024-005 in section II above.
Reference Number 2024-005 – Incomplete Schedule of Expenditures of Federal Awards Evaluation of Finding Material Weakness and Noncompliance – Various Federal Programs Criteria According to the Government Auditing Standards (Yellow Book) and the Uniform Guidance, 2 CFR Part 200, Subpart F—Audit Requirements, sections 200.508 and 200.510, entities receiving federal awards must prepare and submit a complete and accurate Schedule of Expenditures of Federal Awards (SEFA) as part of their annual financial reporting. This schedule is crucial for auditors to determine major programs and conduct the necessary audits in compliance with federal regulations. Condition The City failed to provide a complete SEFA for the fiscal year, leading to inaccuracies pertaining to the ARPA program. This omission resulted in a direct impact on the determination of major programs. Cause The incomplete SEFA was caused by a lack of oversight and insufficient internal controls within the City's financial management department. Effect or Potential Effect The failure to provide a complete SEFA has significant implications, including: • Inaccurate determination of major programs, which can affect the scope and quality of the audit process. • Increased risk of non-compliance with federal regulations, potentially leading to financial penalties and loss of federal funding. Context The City did not submit a complete SEFA for the year ended June 30, 2024, as required by federal guidelines. This incomplete reporting could compromise transparency, affect audit procedures, and hinder compliance with federal regulations. Repeat Finding Yes, in relation to reconciliation of grant activity. Recommendation To address this material weakness, the following actions are recommended: • Develop detailed procedures and timelines: Establish and enforce comprehensive procedures and timelines for the preparation and submission of the SEFA to ensure completeness and accuracy. • Enhance staffing and resources: Allocate adequate staffing and resources to the financial management department to support the accurate compilation and timely submission of the SEFA. • Provide comprehensive training: Offer training to financial management staff on the requirements and importance of the SEFA, including techniques for ensuring its accuracy and completeness.. • Regularly audit the SEFA preparation process: Conduct regular audits of the SEFA preparation process to ensure compliance with established policies and procedures and address any deficiencies promptly. This should be completed monthly and at a minimum quarterly. By implementing these recommendations, the City can strengthen its internal controls, improve the accuracy of its financial reporting, and ensure compliance with Government Auditing Standards and other regulatory requirements. Management Response Management agrees with the finding and recommendations. The City will begin to implement policies and procedures to assist with monthly reconciliations and review processes to mitigate these errors in the future. Reference Number 2024-005 – Incomplete Schedule of Expenditures of Federal Awards Material Weakness and Noncompliance Assistance Listing Number: All Federal Programs reported on the SEFA Criteria Refer to finding 2024-005 in section II above. Condition Refer to finding 2024-005 in section II above. Cause of Condition Refer to finding 2024-005 in section II above. Effect or Potential Effect of Condition Refer to finding 2024-005 in section II above. Questioned costs None. Context Refer to finding 2024-005 in section II above. Repeat Finding Refer to finding 2024-005 in section II above. Recommendation Refer to finding 2024-005 in section II above. Management Response Refer to finding 2024-005 in section II above.
Reference Number 2024-005 – Incomplete Schedule of Expenditures of Federal Awards Evaluation of Finding Material Weakness and Noncompliance – Various Federal Programs Criteria According to the Government Auditing Standards (Yellow Book) and the Uniform Guidance, 2 CFR Part 200, Subpart F—Audit Requirements, sections 200.508 and 200.510, entities receiving federal awards must prepare and submit a complete and accurate Schedule of Expenditures of Federal Awards (SEFA) as part of their annual financial reporting. This schedule is crucial for auditors to determine major programs and conduct the necessary audits in compliance with federal regulations. Condition The City failed to provide a complete SEFA for the fiscal year, leading to inaccuracies pertaining to the ARPA program. This omission resulted in a direct impact on the determination of major programs. Cause The incomplete SEFA was caused by a lack of oversight and insufficient internal controls within the City's financial management department. Effect or Potential Effect The failure to provide a complete SEFA has significant implications, including: • Inaccurate determination of major programs, which can affect the scope and quality of the audit process. • Increased risk of non-compliance with federal regulations, potentially leading to financial penalties and loss of federal funding. Context The City did not submit a complete SEFA for the year ended June 30, 2024, as required by federal guidelines. This incomplete reporting could compromise transparency, affect audit procedures, and hinder compliance with federal regulations. Repeat Finding Yes, in relation to reconciliation of grant activity. Recommendation To address this material weakness, the following actions are recommended: • Develop detailed procedures and timelines: Establish and enforce comprehensive procedures and timelines for the preparation and submission of the SEFA to ensure completeness and accuracy. • Enhance staffing and resources: Allocate adequate staffing and resources to the financial management department to support the accurate compilation and timely submission of the SEFA. • Provide comprehensive training: Offer training to financial management staff on the requirements and importance of the SEFA, including techniques for ensuring its accuracy and completeness.. • Regularly audit the SEFA preparation process: Conduct regular audits of the SEFA preparation process to ensure compliance with established policies and procedures and address any deficiencies promptly. This should be completed monthly and at a minimum quarterly. By implementing these recommendations, the City can strengthen its internal controls, improve the accuracy of its financial reporting, and ensure compliance with Government Auditing Standards and other regulatory requirements. Management Response Management agrees with the finding and recommendations. The City will begin to implement policies and procedures to assist with monthly reconciliations and review processes to mitigate these errors in the future. Reference Number 2024-005 – Incomplete Schedule of Expenditures of Federal Awards Material Weakness and Noncompliance Assistance Listing Number: All Federal Programs reported on the SEFA Criteria Refer to finding 2024-005 in section II above. Condition Refer to finding 2024-005 in section II above. Cause of Condition Refer to finding 2024-005 in section II above. Effect or Potential Effect of Condition Refer to finding 2024-005 in section II above. Questioned costs None. Context Refer to finding 2024-005 in section II above. Repeat Finding Refer to finding 2024-005 in section II above. Recommendation Refer to finding 2024-005 in section II above. Management Response Refer to finding 2024-005 in section II above.
Condition: During our audit we reviewed the expenditures included on the Organization’s schedule of expenditures of federal awards. We noted the Organization did not include all federal expenditures incurred during the reporting period. Criteria: As described in 2 CFR § 200.510(b) the Organization is required to prepare a schedule of expenditures of federal awards for the period covered by the auditee’s financial statements. This schedule must include total federal awards expended. Cause: The Organization utilizes an outsourced accountants to assist with the management of the Organization’s finances. During the year the Organization received a grant related to the construction of a community center. The Organization hired another contractor to assist with the construction of the community center. There are multiple entities with unique understanding of the finances tied to the federal program selected for testing. Effect: Due to not including all federal expenditures on the schedule of expenditures of federal awards this caused the schedule to be understated to a material degree. Recommendation: After thoroughly reviewing the unique circumstance that led to this audit finding, we have determined that it is highly unlikely to recur. Given the organization's strong compliance history and familiarity with SEFA reporting under Uniform Guidance, we do not see a cost-effective benefit to revamping internal controls specifically for this issue. Instead, we recommend continuing to; review government awards, provide refresher trainings to staff, and conduct periodic reviews of internal controls to ensure ongoing compliance. These measures will effectively address the finding without incurring unnecessary costs. Views of Resposible Officials: Management agrees with the finding.
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.
2024-004 Improve Internal Controls Over the Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program(s) Information Federal Agency: Department of Transportation Award Name: National Infrastructure Investments Assistance Listing Number: 20.933 Award Year: 2024 Federal Agency: Environmental Protection Agency Award Name: Clean Water State Revolving Fund Assistance Listing Number: 66.458 Award Year: 2024 Federal Agency: Department of Housing and Urban Development Award Name: Lead Hazard Reduction Demonstration Grant Assistance Listing Number: 14.905 Award Year: 2024 Type of Finding Compliance Internal Control Over Compliance – Material Weakness SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) 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 accurately and completely report federal awards expended during the period, regardless of when reimbursements are received. The SEFA should reflect federal expenditures as incurred in accordance with program requirements and generally accepted accounting principles. Condition and Context While preparing its draft SEFA, the City did not include $1,183,881 in federal expenditures under the National Infrastructure Investment grant. In addition, expenditures reported under the Clean Water State Revolving Fund grant were understated by $30,921 and expenditures reported under the Lead Hazard Reduction Demonstration Grant Program were overstated by $391,414. As a result, an adjustment was required in order for the SEFA to be complete and accurate. 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. Certain programs within the City reported expenditures on the SEFA based on when federal reimbursements were received, rather than when expenditures were incurred. Expenditures under the Lead Hazard Reduction Demonstration Grant initially included CDBG funds and the match that was not to be reported under the program on the SEFA. The misapplication of the reporting basis led to misstatement and omission of federal expenditures. Effect or Potential Effect Incomplete and inaccurate SEFA reporting increases the risk that federal agencies and oversight bodies receive misleading financial information. It may also result in improper determination of major programs for audit testing and affect audit risk assessments. Reporting federal expenditures by reimbursement rather than when incurred is not compliant with federal requirements and generally accepted accounting principles. No questioned costs are reported as the finding relates to completeness and accuracy of reporting, not the allowability of costs. Recommendation The City should strengthen its procedures and controls for preparing the SEFA to ensure all federal awards expended during the period are included and accurately reported based on expenditures incurred, not reimbursements received. The City should ensure that adequate procedures and controls are in place to ensure that the SEFA is complete and accurate. These controls should include controls requiring the reconciliation of federal expenditures to the appropriate supporting documentation (e.g., general ledger, grant reports, etc.). SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Views of Responsible Official Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.
2024-004 Improve Internal Controls Over the Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program(s) Information Federal Agency: Department of Transportation Award Name: National Infrastructure Investments Assistance Listing Number: 20.933 Award Year: 2024 Federal Agency: Environmental Protection Agency Award Name: Clean Water State Revolving Fund Assistance Listing Number: 66.458 Award Year: 2024 Federal Agency: Department of Housing and Urban Development Award Name: Lead Hazard Reduction Demonstration Grant Assistance Listing Number: 14.905 Award Year: 2024 Type of Finding Compliance Internal Control Over Compliance – Material Weakness SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) 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 accurately and completely report federal awards expended during the period, regardless of when reimbursements are received. The SEFA should reflect federal expenditures as incurred in accordance with program requirements and generally accepted accounting principles. Condition and Context While preparing its draft SEFA, the City did not include $1,183,881 in federal expenditures under the National Infrastructure Investment grant. In addition, expenditures reported under the Clean Water State Revolving Fund grant were understated by $30,921 and expenditures reported under the Lead Hazard Reduction Demonstration Grant Program were overstated by $391,414. As a result, an adjustment was required in order for the SEFA to be complete and accurate. 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. Certain programs within the City reported expenditures on the SEFA based on when federal reimbursements were received, rather than when expenditures were incurred. Expenditures under the Lead Hazard Reduction Demonstration Grant initially included CDBG funds and the match that was not to be reported under the program on the SEFA. The misapplication of the reporting basis led to misstatement and omission of federal expenditures. Effect or Potential Effect Incomplete and inaccurate SEFA reporting increases the risk that federal agencies and oversight bodies receive misleading financial information. It may also result in improper determination of major programs for audit testing and affect audit risk assessments. Reporting federal expenditures by reimbursement rather than when incurred is not compliant with federal requirements and generally accepted accounting principles. No questioned costs are reported as the finding relates to completeness and accuracy of reporting, not the allowability of costs. Recommendation The City should strengthen its procedures and controls for preparing the SEFA to ensure all federal awards expended during the period are included and accurately reported based on expenditures incurred, not reimbursements received. The City should ensure that adequate procedures and controls are in place to ensure that the SEFA is complete and accurate. These controls should include controls requiring the reconciliation of federal expenditures to the appropriate supporting documentation (e.g., general ledger, grant reports, etc.). SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Views of Responsible Official Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.
2024-004 Improve Internal Controls Over the Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program(s) Information Federal Agency: Department of Transportation Award Name: National Infrastructure Investments Assistance Listing Number: 20.933 Award Year: 2024 Federal Agency: Environmental Protection Agency Award Name: Clean Water State Revolving Fund Assistance Listing Number: 66.458 Award Year: 2024 Federal Agency: Department of Housing and Urban Development Award Name: Lead Hazard Reduction Demonstration Grant Assistance Listing Number: 14.905 Award Year: 2024 Type of Finding Compliance Internal Control Over Compliance – Material Weakness SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) 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 accurately and completely report federal awards expended during the period, regardless of when reimbursements are received. The SEFA should reflect federal expenditures as incurred in accordance with program requirements and generally accepted accounting principles. Condition and Context While preparing its draft SEFA, the City did not include $1,183,881 in federal expenditures under the National Infrastructure Investment grant. In addition, expenditures reported under the Clean Water State Revolving Fund grant were understated by $30,921 and expenditures reported under the Lead Hazard Reduction Demonstration Grant Program were overstated by $391,414. As a result, an adjustment was required in order for the SEFA to be complete and accurate. 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. Certain programs within the City reported expenditures on the SEFA based on when federal reimbursements were received, rather than when expenditures were incurred. Expenditures under the Lead Hazard Reduction Demonstration Grant initially included CDBG funds and the match that was not to be reported under the program on the SEFA. The misapplication of the reporting basis led to misstatement and omission of federal expenditures. Effect or Potential Effect Incomplete and inaccurate SEFA reporting increases the risk that federal agencies and oversight bodies receive misleading financial information. It may also result in improper determination of major programs for audit testing and affect audit risk assessments. Reporting federal expenditures by reimbursement rather than when incurred is not compliant with federal requirements and generally accepted accounting principles. No questioned costs are reported as the finding relates to completeness and accuracy of reporting, not the allowability of costs. Recommendation The City should strengthen its procedures and controls for preparing the SEFA to ensure all federal awards expended during the period are included and accurately reported based on expenditures incurred, not reimbursements received. The City should ensure that adequate procedures and controls are in place to ensure that the SEFA is complete and accurate. These controls should include controls requiring the reconciliation of federal expenditures to the appropriate supporting documentation (e.g., general ledger, grant reports, etc.). SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Views of Responsible Official Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.
2024-004 Improve Internal Controls Over the Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program(s) Information Federal Agency: Department of Transportation Award Name: National Infrastructure Investments Assistance Listing Number: 20.933 Award Year: 2024 Federal Agency: Environmental Protection Agency Award Name: Clean Water State Revolving Fund Assistance Listing Number: 66.458 Award Year: 2024 Federal Agency: Department of Housing and Urban Development Award Name: Lead Hazard Reduction Demonstration Grant Assistance Listing Number: 14.905 Award Year: 2024 Type of Finding Compliance Internal Control Over Compliance – Material Weakness SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) 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 accurately and completely report federal awards expended during the period, regardless of when reimbursements are received. The SEFA should reflect federal expenditures as incurred in accordance with program requirements and generally accepted accounting principles. Condition and Context While preparing its draft SEFA, the City did not include $1,183,881 in federal expenditures under the National Infrastructure Investment grant. In addition, expenditures reported under the Clean Water State Revolving Fund grant were understated by $30,921 and expenditures reported under the Lead Hazard Reduction Demonstration Grant Program were overstated by $391,414. As a result, an adjustment was required in order for the SEFA to be complete and accurate. 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. Certain programs within the City reported expenditures on the SEFA based on when federal reimbursements were received, rather than when expenditures were incurred. Expenditures under the Lead Hazard Reduction Demonstration Grant initially included CDBG funds and the match that was not to be reported under the program on the SEFA. The misapplication of the reporting basis led to misstatement and omission of federal expenditures. Effect or Potential Effect Incomplete and inaccurate SEFA reporting increases the risk that federal agencies and oversight bodies receive misleading financial information. It may also result in improper determination of major programs for audit testing and affect audit risk assessments. Reporting federal expenditures by reimbursement rather than when incurred is not compliant with federal requirements and generally accepted accounting principles. No questioned costs are reported as the finding relates to completeness and accuracy of reporting, not the allowability of costs. Recommendation The City should strengthen its procedures and controls for preparing the SEFA to ensure all federal awards expended during the period are included and accurately reported based on expenditures incurred, not reimbursements received. The City should ensure that adequate procedures and controls are in place to ensure that the SEFA is complete and accurate. These controls should include controls requiring the reconciliation of federal expenditures to the appropriate supporting documentation (e.g., general ledger, grant reports, etc.). SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) Views of Responsible Official Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.
2024-004 Improve Internal Controls Over the Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program(s) Information Federal Agency: Department of Transportation Award Name: National Infrastructure Investments Assistance Listing Number: 20.933 Award Year: 2024 Federal Agency: Environmental Protection Agency Award Name: Clean Water State Revolving Fund Assistance Listing Number: 66.458 Award Year: 2024 Federal Agency: Department of Housing and Urban Development Award Name: Lead Hazard Reduction Demonstration Grant Assistance Listing Number: 14.905 Award Year: 2024 Type of Finding Compliance Internal Control Over Compliance – Material Weakness SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) 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 accurately and completely report federal awards expended during the period, regardless of when reimbursements are received. The SEFA should reflect federal expenditures as incurred in accordance with program requirements and generally accepted accounting principles. Condition and Context While preparing its draft SEFA, the City did not include $1,183,881 in federal expenditures under the National Infrastructure Investment grant. In addition, expenditures reported under the Clean Water State Revolving Fund grant were understated by $30,921 and expenditures reported under the Lead Hazard Reduction Demonstration Grant Program were overstated by $391,414. As a result, an adjustment was required in order for the SEFA to be complete and accurate. 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. Certain programs within the City reported expenditures on the SEFA based on when federal reimbursements were received, rather than when expenditures were incurred. Expenditures under the Lead Hazard Reduction Demonstration Grant initially included CDBG funds and the match that was not to be reported under the program on the SEFA. The misapplication of the reporting basis led to misstatement and omission of federal expenditures. Effect or Potential Effect Incomplete and inaccurate SEFA reporting increases the risk that federal agencies and oversight bodies receive misleading financial information. It may also result in improper determination of major programs for audit testing and affect audit risk assessments. Reporting federal expenditures by reimbursement rather than when incurred is not compliant with federal requirements and generally accepted accounting principles. No questioned costs are reported as the finding relates to completeness and accuracy of reporting, not the allowability of costs. Recommendation The City should strengthen its procedures and controls for preparing the SEFA to ensure all federal awards expended during the period are included and accurately reported based on expenditures incurred, not reimbursements received. The City should ensure that adequate procedures and controls are in place to ensure that the SEFA is complete and accurate. These controls should include controls requiring the reconciliation of federal expenditures to the appropriate supporting documentation (e.g., general ledger, grant reports, etc.). SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (CONTINUED) 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-001: Preparation of the Schedule of Expenditures of Federal Awards Material weakness/other matter noncompliance Identification of federal programs: • ALN 98.001: USAID Foreign Assistance for Programs Overseas awarded by the U.S Agency for International Development, specifically contract 72061522CA00003 for fiscal year 2024. • ALN 19.705: Trans-National Crime awarded by the U.S. Department of State Bureau of International Narcotics and Law Enforcement Affairs, specifically contract SINLEC21GR3379, and the indirect award passed though the Humane Society of the United States for fiscal year 2024. Criteria: The Uniform Guidance (2 CFR 200.510b) requires that the auditee (typically a non-federal entity receiving federal funds) must prepare a Schedule of Expenditures of Federal Awards for the period covered by its financial statements which must include the total Federal Awards expended as determined in accordance with 2 CFR 200.502. Condition: The Schedule of Expenditures of Federal Awards for the year ended June 30, 2024 improperly excluded the awards provided to sub-recipients from the total expenditures reported for the federal awards for ALN 98.001 USAID Foreign Assistance for Programs Overseas and ALN 19.705 Trans-National Crime. Cause: There was an error in the formula that linked the supporting schedule to the schedule of expenditures of federal awards. Effect: Not in compliance with the Uniform Guidance (2 CFR 200.510b). There could be impacts on future funding. Questioned costs: None. Context: Total federal awards for ALN 98.001 USAID Foreign Assistance for Programs Overseas improperly excluded subrecipient awards from the total in the amount of $143,937. Total federal awards for ALN 19.705 Trans-National Crime improperly excluded subrecipient awards from the total in the amount of $166,877. Repeat Finding: No Recommendation: We recommend that the Organization review the schedule of expenditures of federal awards prior to issuance. Views of responsible officials and planned corrective actions: Management agrees with the finding. See corrective action plan.
Finding 2024-001: Preparation of the Schedule of Expenditures of Federal Awards Material weakness/other matter noncompliance Identification of federal programs: • ALN 98.001: USAID Foreign Assistance for Programs Overseas awarded by the U.S Agency for International Development, specifically contract 72061522CA00003 for fiscal year 2024. • ALN 19.705: Trans-National Crime awarded by the U.S. Department of State Bureau of International Narcotics and Law Enforcement Affairs, specifically contract SINLEC21GR3379, and the indirect award passed though the Humane Society of the United States for fiscal year 2024. Criteria: The Uniform Guidance (2 CFR 200.510b) requires that the auditee (typically a non-federal entity receiving federal funds) must prepare a Schedule of Expenditures of Federal Awards for the period covered by its financial statements which must include the total Federal Awards expended as determined in accordance with 2 CFR 200.502. Condition: The Schedule of Expenditures of Federal Awards for the year ended June 30, 2024 improperly excluded the awards provided to sub-recipients from the total expenditures reported for the federal awards for ALN 98.001 USAID Foreign Assistance for Programs Overseas and ALN 19.705 Trans-National Crime. Cause: There was an error in the formula that linked the supporting schedule to the schedule of expenditures of federal awards. Effect: Not in compliance with the Uniform Guidance (2 CFR 200.510b). There could be impacts on future funding. Questioned costs: None. Context: Total federal awards for ALN 98.001 USAID Foreign Assistance for Programs Overseas improperly excluded subrecipient awards from the total in the amount of $143,937. Total federal awards for ALN 19.705 Trans-National Crime improperly excluded subrecipient awards from the total in the amount of $166,877. Repeat Finding: No Recommendation: We recommend that the Organization review the schedule of expenditures of federal awards prior to issuance. Views of responsible officials and planned corrective actions: Management agrees with the finding. See corrective action plan.
Finding 2024-001: Preparation of the Schedule of Expenditures of Federal Awards Material weakness/other matter noncompliance Identification of federal programs: • ALN 98.001: USAID Foreign Assistance for Programs Overseas awarded by the U.S Agency for International Development, specifically contract 72061522CA00003 for fiscal year 2024. • ALN 19.705: Trans-National Crime awarded by the U.S. Department of State Bureau of International Narcotics and Law Enforcement Affairs, specifically contract SINLEC21GR3379, and the indirect award passed though the Humane Society of the United States for fiscal year 2024. Criteria: The Uniform Guidance (2 CFR 200.510b) requires that the auditee (typically a non-federal entity receiving federal funds) must prepare a Schedule of Expenditures of Federal Awards for the period covered by its financial statements which must include the total Federal Awards expended as determined in accordance with 2 CFR 200.502. Condition: The Schedule of Expenditures of Federal Awards for the year ended June 30, 2024 improperly excluded the awards provided to sub-recipients from the total expenditures reported for the federal awards for ALN 98.001 USAID Foreign Assistance for Programs Overseas and ALN 19.705 Trans-National Crime. Cause: There was an error in the formula that linked the supporting schedule to the schedule of expenditures of federal awards. Effect: Not in compliance with the Uniform Guidance (2 CFR 200.510b). There could be impacts on future funding. Questioned costs: None. Context: Total federal awards for ALN 98.001 USAID Foreign Assistance for Programs Overseas improperly excluded subrecipient awards from the total in the amount of $143,937. Total federal awards for ALN 19.705 Trans-National Crime improperly excluded subrecipient awards from the total in the amount of $166,877. Repeat Finding: No Recommendation: We recommend that the Organization review the schedule of expenditures of federal awards prior to issuance. Views of responsible officials and planned corrective actions: Management agrees with the finding. See corrective action plan.
2024 – 002: Schedule of Expenditure of Federal Awards (SEFA) Preparation Type of Finding: • Material Weakness in Internal Control Over Financial Reporting Condition: During testing, it was noted the School’s prepared SEFA did not properly reconcile to the underlying School records, which required additional adjustments of approximately $583,000. Criteria or specific requirement: 2 CFR 200.510(b) states: Schedule of expenditures of federal awards. The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502 Basis for determining federal awards expended. 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. For example, when a federal program has multiple federal award years, the auditee may list the amount of federal awards expended for each federal award year separately. At a minimum, the schedule must: • List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. For example, the National Institutes of Health is a major subdivision in the Department of Health and Human Services. • For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. • Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. • Include the total amount provided to subrecipients from each Federal program. • For loan or loan guarantee programs described in §200.502 Basis for determining federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. • Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. Effect: Without a proper system of internal controls in place that operated effectively, material misstatements of the SEFA remained undetected. Cause: Management had not established an effective system of internal controls that would have ensured proper reporting of the SEFA. Repeat finding: Yes – 2023-004. Recommendation: We recommend the school implement internal controls over the SEFA including a reconciliation and review process before submission. Views of responsible officials and planned corrective actions: There is no disagreement with the audit finding.
2024-004: Subrecipient Determination and Monitoring Assistance Listing Number (ALN) and Title: 20.205 Highway Planning and Construction Federal Grantor: U.S. Department of Transportation (DOT) Passed-through: Oregon Department of Transportation (ODOT) Award Identification Numbers and Years: Finding is applicable to all 20.205 awards on the SEFA for 2024 Compliance Requirement: Subrecipient Monitoring Type of Finding: Noncompliance and Material Weakness in Internal Control over Compliance. Prior Year Audit Finding: No Criteria: 2 CFR 200.331 requires pass-through entities (PTEs) like LCOG to make case-by-case determinations whether an agreement casts the party receiving funds as a subrecipient or a contractor (vendor). This determination affects reporting on the SEFA (§200.510(b)(4)). Furthermore, 2 CFR 200.332 requires PTEs to evaluate each subrecipient's risk of noncompliance, monitor their activities to ensure compliance with federal requirements (including reviewing financial and performance reports), and verify that subrecipients subject to the Single Audit requirements have obtained the required audit and take appropriate action on any findings effecting the pass-through program (§200.332(b), (d), and (f)). Effective internal controls should ensure proper classification and that required monitoring activities are performed and documented. Condition: LCOG exhibited weaknesses in its process for determining and monitoring subrecipients under ALN 20.205. Specifically: LCOG did not correctly classify entities receiving funds. Multiple vendors were incorrectly identified as subrecipients on the draft SEFA provided for audit. Two entities meeting the definition of subrecipients were identified during audit procedures; however, LCOG had classified them as vendors and omitted them from the draft SEFA. As a result of misclassifying the actual subrecipients as vendors, LCOG did not perform required subrecipient monitoring activities for these entities, such as conducting and documenting a risk assessment or obtaining and reviewing their Single Audit reporting packages. Questioned Costs: None. Context: The misclassifications were identified during audit testing and review of the draft SEFA. While the entities omitted from the SEFA were later confirmed to be subrecipients, LCOG had not performed the required monitoring steps during the fiscal year. Subsequent review of the Single Audit reports for these two subrecipients during the audit process confirmed they had correctly reported the funds received from LCOG and disclosed no audit findings related to this program. No errors were noted in the initial contracting process with these entities. However, the lack of contemporaneous monitoring represents noncompliance and a control weakness. Cause: LCOG lacks adequate procedures for performing and documenting the subrecipient vs. contractor determination based on the criteria in 2 CFR 200.331. This initial failure led to inaccurate SEFA reporting and the subsequent failure to implement required monitoring protocols for entities that were, in fact, subrecipients. Effect: The failure to correctly identify and monitor subrecipients constitutes noncompliance with 2 CFR 200.332 and resulted in inaccurate SEFA reporting. Although no subrecipient noncompliance impacting the program was ultimately identified in this instance, the absence of required monitoring activities (including risk assessment and review of audit reports) creates a risk that subrecipient noncompliance could occur and not be detected by LCOG in a timely manner. This condition represents a material weakness in internal control over compliance. Recommendation: We recommend LCOG implement procedures to: 99 Formally document the determination of whether entities receiving federal funds are subrecipients or contractors prior to entering into agreements and preparing the SEFA, using the criteria in 2 CFR 200.331. Develop and implement a risk-based monitoring plan for all identified subrecipients, ensuring that required monitoring activities (including review of reports and Single Audits, where applicable) are performed and documented throughout the period of performance. Ensure the SEFA accurately reflects subrecipient relationships and amounts passed through. Auditee Views: While we agree that we did not have a formal monitoring plan in place, now that we are aware of the need for such a plan, we will put a plan in place immediately. Once we became aware, we immediately reviewed the single audit reports all subrecipients. As to whether all subrecipients were properly reported on the SEFA, LCOG and ODOT had been in discussions for several months over whether certain entities contracted by LCOG under the Secure Routes to Schools program were, in fact, subrecipients and was unclear due to conflicting guidance received from various individuals. We will begin consulting with ODOT prior to the audit to make sure they agree with the classification of fund recipients as either contractor or subrecipient.
Item 2024-003: Preparation of Schedule of Expenditures of Federal Awards Identification of federal programs: All Assistance Listing Numbers included on the schedule of expenditures of federal awards for the period from January 1, 2024 to June 30, 2024. Federal award grant number: 204645, 244603, 244590, 242754 Federal agency: U.S. Department of Agriculture, U.S. Department of Treasury Pass-through entity: Minnesota Department of Health and Minnesota Department of Human Services Criteria: The Uniform Guidance (2 CFR 200.510) requires the auditee to prepare the schedule of expenditures of federal awards to cover the correct reporting period and contain certain information to be considered complete. Condition: We noted the initial schedule of expenditures of federal awards presented for audit was incorrectly for the year ended June 30, 2024. Once the correct period was determined and the revised schedule of expenditures of federal awards was received for the period from January 1, 2024 to June 30, 2024, additional findings were noted as follows: Food Distribution Cluster program was not properly grouped by federal Assistance Listing Number. Pass-through entity identifying numbers listed for two programs were incorrect. Coronavirus State and Local Fiscal Recovery Funds had improper identification of the program and pass-through entity identifying number. This program was improperly included in the Food Distribution Cluster. Cause: The exceptions noted above were due to a breakdown in SHN’s procedures to ensure that the schedule of expenditures of federal awards is in accordance with the Uniform Guidance. Further, we noted there is no documented review and approval of the schedule of expenditures of federal awards. Effect: Improper schedule of expenditures of federal awards was presented for audit. Questioned costs: None Context: The schedule of expenditures of federal awards was not prepared consistent with the requirements of the Uniform Guidance (2 CFR 200.510). Repeat finding: No Recommendation: SHN should continue to improve its procedures around the preparation and review of the schedule of expenditures of federal awards. Views of responsible officials of the auditee: SHN concurs with this finding and a response is included in the corrective action plan.
FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR §200.510 Financial Statements, (b) states that 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. At a minimum, the schedule must: (1) list individual Federal Programs by Federal agency, (2) for Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included, (3) provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available, (4) Include the total amount provided to subrecipients from each Federal program, (5) for loan or loan guarantee programs identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. STATEMENT OF CONDITION During our audit procedures of the Schedule of Expenditures of Federal Awards (SEFA) prepared by the Department, we identified misstatements related to the programs reported in the SEFA. One Federal program was not included in the SEFA, and adjustments were proposed in order to reconcile the information included in the SEFA with the financial statement.PERSPECTIVE INFORMATION The Department failed to identify properly in its records and/or accounting records the Federal grants that they received and expended during the fiscal year, this cause that when the Department prepared the SEFA with the financial statement and for audit purposes the SEFA was incomplete and misstated. STATEMENT OF CAUSE The Department failed to identify the Federal grants expended during the fiscal year and to keep records of the transactions related to the Federal programs in order to properly identify the Federal programs and transactions when the SEFA is prepared causing the preparation of an incomplete and misstated SEFA. POSSIBLE ASSERTED EFFECT The Department may fail to include all Federal programs and total expenditures in the SEFA causing misstatements in the SEFA, errors in the determination if a Uniform Guidance audit is required to the Department and could provoke an incorrect Major Program Determination performed by the auditor, resulting in the most likely exclusion of a Major Program for audit purpose. IDENTIFICATION OF REPEAT FINDING Not applicable. RECOMMENDATIONS We recommend the Department to maintain adequate records related to the Federal programs in order to properly identify the Federal programs/transactions when the SEFA is prepared. Once a Federal award is granted or received, the information must be shared with all personnel involved in the financial statement and SEFA preparation to provide assurance that all required program activities / expenditures are included on the SEFA. In addition, the Department must perform a regular fiscal monitoring over the Federal programs transactions in order to provide reasonable assurance that all Federal programs/transactions are properly recorded and included on the SEFA
Finding 2024-003 - Material Weakness in Internal Control over Compliance and Material Noncompliance (Qualified Opinion) - Inadequate Tracking of Expenditures and Retention of Documentation: Activities Allowed or Unallowed: Allowable Costs/Cost Principles and Reporting (A/B/L) for Assistance Listing Number 19.510 and 93.567 Criteria: The Code of Federal Regulations (CFR) Section 200.510(b) states in part, “The auditee must also prepare a schedule of federal expenditures for the period covered by the auditee’s consolidated 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(b) - Financial Management, the auditees financial management system must provide 1) identification of all federal awards received and expended; 2) accurate, current, and complete disclosure of the financial results of each federal award or program; 3) records that identify adequately the source and application of funds for federally‐funded activities; 4) effective control over, and accountability for, all funds, property, and other assets; 5) comparison of expenditures with budget amounts for each Federal award; 6) written procedures to implement the requirements of section 200.305 and; 7) written procedures for determining the allowability of costs in accordance with Subpart E and the terms and conditions of the Federal award. Recipients of federal awards must submit accurate, complete and timely financial and performance reports. The Organization should have internal controls designed to ensure compliance with those provisions. The Organization should retain sufficient documentation such as invoice and allocation support for expenditures to retain documentation for audit purposes. Condition: During detail testing of expenditures, it was noted that the Organization did not maintain adequate documentation to support how certain costs were allocated to the federal program. Several transactions lacked sufficient detail, such as invoice or expense reimbursement form. Several expenditures selected for testing did not obtain sufficient approval by an individual at the Organization. There was one instance of employee compensation being processed at an approved pay rate and the Center could not provide any supporting documentation such as an offer letter, to substantiate the rate paid. It was noted that quarterly reports provided to the federal program were not reviewed by an individual at the Organization prior to submission to ensure accurate report of expenditures. 2 of the 8 monthly reports sampled were not submitted timely to the grantor. Cause: The Organization does not have an adequate system in place to ensure quarterly reports have sufficient supporting documentation, proper approval/review, and accurate reporting prior to submission. Responsibilities for expenditure tracking were not clearly assigned, and there was no formal review process in place. The Organization is not following their Document Retention Policy. Effect: The effect of this condition increases the possibility that quarterly financial reports are misstated or inaccurate and increase the risk of noncompliance with federal requirements. The effect of this condition also increases the risk that expenditures are unallowable per the grant, federal regulations, or cost principles due to the insufficient support of proper approval retained. Questioned costs: None Repeat Finding: Yes - 2023-003 Recommendation: Policies and procedures should be in place to ensure quarterly financial reports are properly supported, accurately reported, and adequately approved and reviewed. A formal review process should be established to ensure compliance. The Organization should follow the Document Retention Policy that was put in place and required by law and submit the required reporting documentation timely to the grantor to ensure compliance. Views of Responsible Officials: Management agrees with this finding and their response is included in the Corrective Action Plan.
CRITERIA/SPECIFIC REQUIREMENT: The Code of Federal Regulations (Code) (2 CFR §200.510 (b)), establishes criteria and requirements related to the preparation of the schedule of expenditures of federal awards. The Code (2 CFR §200.303 (a)) requires Regional Office of Education No. 39 to establish and maintain effective internal control over the federal award to provide reasonable assurance the Regional Office is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Effective internal controls should include procedures over preparation of the schedule of expenditures of federal awards. CONDITION: The Regional Office of Education No. 39 did not have sufficient internal controls over the preparation of the Schedule of Expenditures of Federal Awards (SEFA) to ensure all federal expenditures during the fiscal year were reported and information in the SEFA was accurately reported. CONTEXT: During our review of the SEFA, we noted the following: Program title descriptions were incorrect. Assistance listing number was incorrectly listed. EFFECT: Failure to report an accurate SEFA affects the required audit coverage to meet federal requirements and can delay an audit beyond the reporting deadline. CAUSE: Management indicated the errors on the SEFA was due to oversight. RECOMMENDATION: The Regional Office of Education No. 39 should establish and implement internal controls over preparation of the SEFA to ensure accurate reporting. MANAGEMENT’S RESPONSE: The Regional Office of Education No. 39 agrees with the audit findings and will work with contracted accounting firm to ensure that the schedule of expenditures of federal awards is accurately reported as required.
Finding 2024-003 - Schedule of Expenditures of Federal Awards (Material Weakness) CFDA Title and Number 84.425 Education Stabilization Fund Name of Federal Agency: U.S. Department of Education CFDA Title and Number 84.010 Grants to Local Education Agencies (Title I) Name of Federal Agency: U.S. Department of Education Compliance/Internal Control over Compliance: Auditee Responsibilities Criteria: CFR Part 200.508, CFR Part 200.510, Auditee Responsibilities state that the auditee must prepare the Schedule of Expenditures of Federal Awards, which must list individual Federal awards by Federal Agency, including the total Federal awards expended, name of the pass-through entity, CFDA number, and total amount provided to subrecipients. 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 on an untimely basis, and with values that were not reconciled with the general ledger. Cause: The District staff had insufficient training or support to prepare the SEFA and ensure that it was reconciled with general ledger amounts. District management did not have monitoring policies to recognize and correct the deficiency. Effect or Potential Effect: Errors in recording and reporting of revenues and expenditures of federal awards may not be detected and/or corrected. Because the Auditee’s SEFA that was presented for audit was completed incorrectly, and not reconciled to the general ledger, the SEFA was materially misstated, prior to auditor's correction recommendations. Questioned Cost: No Context: Lack of adequate controls over the Schedule of Expenditures of Federal Awards and related accounting resulted in the following: SEFA was originally presented for auditors with incorrect information. SEFA was not presented for auditors on a timely basis. No reconciliation between federal expenditures reported on the GL and the SEFA was presented. 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 correct 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 review 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 identified and reported accurately on future SEFA reports. Planned Implementation Date: August 1, 2025 Responsible Person: Director of Business Services, Yamhill County School District No. 8
Finding 2024-001: Internal Control over Preparation of the Schedule of Expenditures of Federal Awards, Assistance Listing Numbers - All Criteria: Per 2 CFR Part 200.510(b): "The auditee must also prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee's financial statements". The auditee must maintain underlying accounting records used to prepare the Schedule of Expenditures of Federal Awards (SEFA) that tie to the financial statements or a reconciliation that ties to the financial statements, for each individual award. Condition: The Organization failed to provide a complete, accurate Schedule of Expenditures of Federal Awards that reconciled to the financial statements, on a timely basis. Cause: The Organization did not maintain the appropriate underlying records for each individual award necessary to reconcile the expenditures to the financial statements on a timely basis. Effect: This could result in an inaccurate reporting of expenditures that could have a direct and material effect on the financial statements. Recommendation: We recommend management implement policies and procedures in which the Schedule of Expenditures of Federal Awards and underlying records are maintained and reconciled to the financial statements, on a regular basis. Management Response: Share Food has developed procedures and processes to manage, maintain, and reconcilethe financial statements to the schedule of expenditures of federal awards as part of our year end closing procedures. This was implemented, and it is expected that the June 30, 2025 financial reporting package will be timely and accurate.
Federal Expenditures Not Reported in the Schedule of Federal Expenditures of Federal Awards and State Financial Assistance (“SEFA”) Federal Program: Coronavirus State and Local Fiscal Recovery Funds CFDA / Assistance Listing Number: 21.027 Federal Agency: U. S. Department of Treasury Pass-Through Entity: Tennessee Department of Environment and Conservation Fiscal Year Ended June 30, 2024 Criteria Per 2 CFR §200.510(b) and 2 CFR §200.502, entities expending federal awards must accurately identify all federal awards expended during the period and prepare a complete and accurate SEFA that is consistent with amounts recorded in the financial statements. Condition and Context During a subsequent audit, it was identified that federal expenditures totaling $867,515 were not recorded as federal grant revenue or accounts receivable in the financial statements and were also omitted from the SEFA. The amounts were material to total federal expenditures reported under the Uniform Guidance. Cause The omission occurred due to oversight in year-end closing and grant reconciliation procedures, which did not capture the unrecorded federal expenditures at fiscal year-end. Effect The SEFA originally issued was incomplete and understated total federal expenditures by $867,515. As a result, the fiscal year 2024 financial statements were reissued to include the omitted federal expenditures and to present an accurate SEFA in accordance with the Uniform Guidance. Questioned Costs None. Recommendation Management should strengthen year-end grant reconciliation and review procedures to ensure that all federal expenditures are properly recorded and included in the SEFA prior to issuance. Views of Responsible Officials and Planned Corrective Actions See management’s corrective action plan.