Finding 2024-005: Material Weakness and Noncompliance, Compiling and Reporting an Accurate Schedule of Expenditures of Federal Awards and State Financial Assistance (Repeat) Department of Health and Human Services Assistance Listing Number: 93.600 Program Name: Head Start Cluster, Program Year 2022, 2023 and 2024 Department of the Treasury Passed through the State of Florida Department of State Assistance Listing Number: 21.027 Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds, Program Year 2023 Department of Health and Human Services Passed through the State of Florida Department of Revenue Assistance Listing Number: 93.563 Program Name: Child Support Enforcement – Title IV-D, Program Year 2024 Department of Environmental Protection Catalog of State Financial Assistance Number: 37.039 Program Name: Statewide Water Quality Restoration Projects, Program Year 2024 Department of Economic Opportunity Catalog of State Financial Assistance Number: 40.040 Program Name: Facilities for New Professional Sports Retained Professional Sports, or Retained Spring Franchise, Program Year 2024 Department of Education and Commissioner of Education Passed through Early Learning Coalition of Hillsborough County Inc. Catalog of State Financial Assistance Number: 48.108 Program Name: Head Start Program, Program Year 2023 and 2024 Department of Children and Families Catalog of State Financial Assistance Number: 60.074 Program Name: Out of Home Supports, Program Year 2024 Criteria: The schedule of expenditures of federal awards and state financial assistance (the Schedule) should reflect expenditures of federal and state programs. 2 CFR 200.510(b) indicates 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 total federal awards expended as determined in accordance with 2 CFR 200.502. Rule 69I-5.003 of the Department of Financial Services, Rules, Chapter 69I-5, Florida Administrative Code, State Financial Assistance (Florida Code), requires an auditee to prepare a schedule of expenditures of state financial assistance for the period covered by the auditee’s financial statements. Condition: During our audit, we observed that Schedule preparation, analysis, and review was not sufficient to detect and correct errors in the amount of federal and state award expenditures. This resulted in multiple iterations of the Schedule provided to the auditor and material changes to the balances reported on the Schedule. As a result, the Schedule did not comply with the requirements of the Uniform Guidance and the Florida Code. The County’s total federal and state program expenditures increased (decreased) by $31.2 and ($8.4) million, respectively to correct the errors Cause: Internal controls over financial reporting related to the Schedule were not sufficient to ensure that the Schedule and related grant reconciliations were accurate and timely. Questioned Costs: None Context: Federal award program expenditures were understated by approximately $31.2 million and state award program expenditures were overstated by approximately $8.4 million. Effect or potential effect: Misstatements in the SEFA/SESA can result in the inaccurate identification of major programs, audit inefficiencies and SEFA/SESA amounts provided to the users of the compliance report that are misstated. Recommendation: We recommend that management enhance controls and procedures to ensure federal and state award expenditures are accurately reported and reviewed regularly throughout the fiscal year in order to enhance the timeliness and accuracy of Schedule reporting. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Finding 2024-005: Material Weakness and Noncompliance, Compiling and Reporting an Accurate Schedule of Expenditures of Federal Awards and State Financial Assistance (Repeat) Department of Health and Human Services Assistance Listing Number: 93.600 Program Name: Head Start Cluster, Program Year 2022, 2023 and 2024 Department of the Treasury Passed through the State of Florida Department of State Assistance Listing Number: 21.027 Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds, Program Year 2023 Department of Health and Human Services Passed through the State of Florida Department of Revenue Assistance Listing Number: 93.563 Program Name: Child Support Enforcement – Title IV-D, Program Year 2024 Department of Environmental Protection Catalog of State Financial Assistance Number: 37.039 Program Name: Statewide Water Quality Restoration Projects, Program Year 2024 Department of Economic Opportunity Catalog of State Financial Assistance Number: 40.040 Program Name: Facilities for New Professional Sports Retained Professional Sports, or Retained Spring Franchise, Program Year 2024 Department of Education and Commissioner of Education Passed through Early Learning Coalition of Hillsborough County Inc. Catalog of State Financial Assistance Number: 48.108 Program Name: Head Start Program, Program Year 2023 and 2024 Department of Children and Families Catalog of State Financial Assistance Number: 60.074 Program Name: Out of Home Supports, Program Year 2024 Criteria: The schedule of expenditures of federal awards and state financial assistance (the Schedule) should reflect expenditures of federal and state programs. 2 CFR 200.510(b) indicates 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 total federal awards expended as determined in accordance with 2 CFR 200.502. Rule 69I-5.003 of the Department of Financial Services, Rules, Chapter 69I-5, Florida Administrative Code, State Financial Assistance (Florida Code), requires an auditee to prepare a schedule of expenditures of state financial assistance for the period covered by the auditee’s financial statements. Condition: During our audit, we observed that Schedule preparation, analysis, and review was not sufficient to detect and correct errors in the amount of federal and state award expenditures. This resulted in multiple iterations of the Schedule provided to the auditor and material changes to the balances reported on the Schedule. As a result, the Schedule did not comply with the requirements of the Uniform Guidance and the Florida Code. The County’s total federal and state program expenditures increased (decreased) by $31.2 and ($8.4) million, respectively to correct the errors Cause: Internal controls over financial reporting related to the Schedule were not sufficient to ensure that the Schedule and related grant reconciliations were accurate and timely. Questioned Costs: None Context: Federal award program expenditures were understated by approximately $31.2 million and state award program expenditures were overstated by approximately $8.4 million. Effect or potential effect: Misstatements in the SEFA/SESA can result in the inaccurate identification of major programs, audit inefficiencies and SEFA/SESA amounts provided to the users of the compliance report that are misstated. Recommendation: We recommend that management enhance controls and procedures to ensure federal and state award expenditures are accurately reported and reviewed regularly throughout the fiscal year in order to enhance the timeliness and accuracy of Schedule reporting. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Finding 2024-005: Material Weakness and Noncompliance, Compiling and Reporting an Accurate Schedule of Expenditures of Federal Awards and State Financial Assistance (Repeat) Department of Health and Human Services Assistance Listing Number: 93.600 Program Name: Head Start Cluster, Program Year 2022, 2023 and 2024 Department of the Treasury Passed through the State of Florida Department of State Assistance Listing Number: 21.027 Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds, Program Year 2023 Department of Health and Human Services Passed through the State of Florida Department of Revenue Assistance Listing Number: 93.563 Program Name: Child Support Enforcement – Title IV-D, Program Year 2024 Department of Environmental Protection Catalog of State Financial Assistance Number: 37.039 Program Name: Statewide Water Quality Restoration Projects, Program Year 2024 Department of Economic Opportunity Catalog of State Financial Assistance Number: 40.040 Program Name: Facilities for New Professional Sports Retained Professional Sports, or Retained Spring Franchise, Program Year 2024 Department of Education and Commissioner of Education Passed through Early Learning Coalition of Hillsborough County Inc. Catalog of State Financial Assistance Number: 48.108 Program Name: Head Start Program, Program Year 2023 and 2024 Department of Children and Families Catalog of State Financial Assistance Number: 60.074 Program Name: Out of Home Supports, Program Year 2024 Criteria: The schedule of expenditures of federal awards and state financial assistance (the Schedule) should reflect expenditures of federal and state programs. 2 CFR 200.510(b) indicates 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 total federal awards expended as determined in accordance with 2 CFR 200.502. Rule 69I-5.003 of the Department of Financial Services, Rules, Chapter 69I-5, Florida Administrative Code, State Financial Assistance (Florida Code), requires an auditee to prepare a schedule of expenditures of state financial assistance for the period covered by the auditee’s financial statements. Condition: During our audit, we observed that Schedule preparation, analysis, and review was not sufficient to detect and correct errors in the amount of federal and state award expenditures. This resulted in multiple iterations of the Schedule provided to the auditor and material changes to the balances reported on the Schedule. As a result, the Schedule did not comply with the requirements of the Uniform Guidance and the Florida Code. The County’s total federal and state program expenditures increased (decreased) by $31.2 and ($8.4) million, respectively to correct the errors Cause: Internal controls over financial reporting related to the Schedule were not sufficient to ensure that the Schedule and related grant reconciliations were accurate and timely. Questioned Costs: None Context: Federal award program expenditures were understated by approximately $31.2 million and state award program expenditures were overstated by approximately $8.4 million. Effect or potential effect: Misstatements in the SEFA/SESA can result in the inaccurate identification of major programs, audit inefficiencies and SEFA/SESA amounts provided to the users of the compliance report that are misstated. Recommendation: We recommend that management enhance controls and procedures to ensure federal and state award expenditures are accurately reported and reviewed regularly throughout the fiscal year in order to enhance the timeliness and accuracy of Schedule reporting. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Finding 2024-005: Material Weakness and Noncompliance, Compiling and Reporting an Accurate Schedule of Expenditures of Federal Awards and State Financial Assistance (Repeat) Department of Health and Human Services Assistance Listing Number: 93.600 Program Name: Head Start Cluster, Program Year 2022, 2023 and 2024 Department of the Treasury Passed through the State of Florida Department of State Assistance Listing Number: 21.027 Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds, Program Year 2023 Department of Health and Human Services Passed through the State of Florida Department of Revenue Assistance Listing Number: 93.563 Program Name: Child Support Enforcement – Title IV-D, Program Year 2024 Department of Environmental Protection Catalog of State Financial Assistance Number: 37.039 Program Name: Statewide Water Quality Restoration Projects, Program Year 2024 Department of Economic Opportunity Catalog of State Financial Assistance Number: 40.040 Program Name: Facilities for New Professional Sports Retained Professional Sports, or Retained Spring Franchise, Program Year 2024 Department of Education and Commissioner of Education Passed through Early Learning Coalition of Hillsborough County Inc. Catalog of State Financial Assistance Number: 48.108 Program Name: Head Start Program, Program Year 2023 and 2024 Department of Children and Families Catalog of State Financial Assistance Number: 60.074 Program Name: Out of Home Supports, Program Year 2024 Criteria: The schedule of expenditures of federal awards and state financial assistance (the Schedule) should reflect expenditures of federal and state programs. 2 CFR 200.510(b) indicates 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 total federal awards expended as determined in accordance with 2 CFR 200.502. Rule 69I-5.003 of the Department of Financial Services, Rules, Chapter 69I-5, Florida Administrative Code, State Financial Assistance (Florida Code), requires an auditee to prepare a schedule of expenditures of state financial assistance for the period covered by the auditee’s financial statements. Condition: During our audit, we observed that Schedule preparation, analysis, and review was not sufficient to detect and correct errors in the amount of federal and state award expenditures. This resulted in multiple iterations of the Schedule provided to the auditor and material changes to the balances reported on the Schedule. As a result, the Schedule did not comply with the requirements of the Uniform Guidance and the Florida Code. The County’s total federal and state program expenditures increased (decreased) by $31.2 and ($8.4) million, respectively to correct the errors Cause: Internal controls over financial reporting related to the Schedule were not sufficient to ensure that the Schedule and related grant reconciliations were accurate and timely. Questioned Costs: None Context: Federal award program expenditures were understated by approximately $31.2 million and state award program expenditures were overstated by approximately $8.4 million. Effect or potential effect: Misstatements in the SEFA/SESA can result in the inaccurate identification of major programs, audit inefficiencies and SEFA/SESA amounts provided to the users of the compliance report that are misstated. Recommendation: We recommend that management enhance controls and procedures to ensure federal and state award expenditures are accurately reported and reviewed regularly throughout the fiscal year in order to enhance the timeliness and accuracy of Schedule reporting. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Finding 2024-005: Material Weakness and Noncompliance, Compiling and Reporting an Accurate Schedule of Expenditures of Federal Awards and State Financial Assistance (Repeat) Department of Health and Human Services Assistance Listing Number: 93.600 Program Name: Head Start Cluster, Program Year 2022, 2023 and 2024 Department of the Treasury Passed through the State of Florida Department of State Assistance Listing Number: 21.027 Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds, Program Year 2023 Department of Health and Human Services Passed through the State of Florida Department of Revenue Assistance Listing Number: 93.563 Program Name: Child Support Enforcement – Title IV-D, Program Year 2024 Department of Environmental Protection Catalog of State Financial Assistance Number: 37.039 Program Name: Statewide Water Quality Restoration Projects, Program Year 2024 Department of Economic Opportunity Catalog of State Financial Assistance Number: 40.040 Program Name: Facilities for New Professional Sports Retained Professional Sports, or Retained Spring Franchise, Program Year 2024 Department of Education and Commissioner of Education Passed through Early Learning Coalition of Hillsborough County Inc. Catalog of State Financial Assistance Number: 48.108 Program Name: Head Start Program, Program Year 2023 and 2024 Department of Children and Families Catalog of State Financial Assistance Number: 60.074 Program Name: Out of Home Supports, Program Year 2024 Criteria: The schedule of expenditures of federal awards and state financial assistance (the Schedule) should reflect expenditures of federal and state programs. 2 CFR 200.510(b) indicates 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 total federal awards expended as determined in accordance with 2 CFR 200.502. Rule 69I-5.003 of the Department of Financial Services, Rules, Chapter 69I-5, Florida Administrative Code, State Financial Assistance (Florida Code), requires an auditee to prepare a schedule of expenditures of state financial assistance for the period covered by the auditee’s financial statements. Condition: During our audit, we observed that Schedule preparation, analysis, and review was not sufficient to detect and correct errors in the amount of federal and state award expenditures. This resulted in multiple iterations of the Schedule provided to the auditor and material changes to the balances reported on the Schedule. As a result, the Schedule did not comply with the requirements of the Uniform Guidance and the Florida Code. The County’s total federal and state program expenditures increased (decreased) by $31.2 and ($8.4) million, respectively to correct the errors Cause: Internal controls over financial reporting related to the Schedule were not sufficient to ensure that the Schedule and related grant reconciliations were accurate and timely. Questioned Costs: None Context: Federal award program expenditures were understated by approximately $31.2 million and state award program expenditures were overstated by approximately $8.4 million. Effect or potential effect: Misstatements in the SEFA/SESA can result in the inaccurate identification of major programs, audit inefficiencies and SEFA/SESA amounts provided to the users of the compliance report that are misstated. Recommendation: We recommend that management enhance controls and procedures to ensure federal and state award expenditures are accurately reported and reviewed regularly throughout the fiscal year in order to enhance the timeliness and accuracy of Schedule reporting. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Finding 2024-005: Material Weakness and Noncompliance, Compiling and Reporting an Accurate Schedule of Expenditures of Federal Awards and State Financial Assistance (Repeat) Department of Health and Human Services Assistance Listing Number: 93.600 Program Name: Head Start Cluster, Program Year 2022, 2023 and 2024 Department of the Treasury Passed through the State of Florida Department of State Assistance Listing Number: 21.027 Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds, Program Year 2023 Department of Health and Human Services Passed through the State of Florida Department of Revenue Assistance Listing Number: 93.563 Program Name: Child Support Enforcement – Title IV-D, Program Year 2024 Department of Environmental Protection Catalog of State Financial Assistance Number: 37.039 Program Name: Statewide Water Quality Restoration Projects, Program Year 2024 Department of Economic Opportunity Catalog of State Financial Assistance Number: 40.040 Program Name: Facilities for New Professional Sports Retained Professional Sports, or Retained Spring Franchise, Program Year 2024 Department of Education and Commissioner of Education Passed through Early Learning Coalition of Hillsborough County Inc. Catalog of State Financial Assistance Number: 48.108 Program Name: Head Start Program, Program Year 2023 and 2024 Department of Children and Families Catalog of State Financial Assistance Number: 60.074 Program Name: Out of Home Supports, Program Year 2024 Criteria: The schedule of expenditures of federal awards and state financial assistance (the Schedule) should reflect expenditures of federal and state programs. 2 CFR 200.510(b) indicates 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 total federal awards expended as determined in accordance with 2 CFR 200.502. Rule 69I-5.003 of the Department of Financial Services, Rules, Chapter 69I-5, Florida Administrative Code, State Financial Assistance (Florida Code), requires an auditee to prepare a schedule of expenditures of state financial assistance for the period covered by the auditee’s financial statements. Condition: During our audit, we observed that Schedule preparation, analysis, and review was not sufficient to detect and correct errors in the amount of federal and state award expenditures. This resulted in multiple iterations of the Schedule provided to the auditor and material changes to the balances reported on the Schedule. As a result, the Schedule did not comply with the requirements of the Uniform Guidance and the Florida Code. The County’s total federal and state program expenditures increased (decreased) by $31.2 and ($8.4) million, respectively to correct the errors Cause: Internal controls over financial reporting related to the Schedule were not sufficient to ensure that the Schedule and related grant reconciliations were accurate and timely. Questioned Costs: None Context: Federal award program expenditures were understated by approximately $31.2 million and state award program expenditures were overstated by approximately $8.4 million. Effect or potential effect: Misstatements in the SEFA/SESA can result in the inaccurate identification of major programs, audit inefficiencies and SEFA/SESA amounts provided to the users of the compliance report that are misstated. Recommendation: We recommend that management enhance controls and procedures to ensure federal and state award expenditures are accurately reported and reviewed regularly throughout the fiscal year in order to enhance the timeliness and accuracy of Schedule reporting. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Finding 2024-005: Material Weakness and Noncompliance, Compiling and Reporting an Accurate Schedule of Expenditures of Federal Awards and State Financial Assistance (Repeat) Department of Health and Human Services Assistance Listing Number: 93.600 Program Name: Head Start Cluster, Program Year 2022, 2023 and 2024 Department of the Treasury Passed through the State of Florida Department of State Assistance Listing Number: 21.027 Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds, Program Year 2023 Department of Health and Human Services Passed through the State of Florida Department of Revenue Assistance Listing Number: 93.563 Program Name: Child Support Enforcement – Title IV-D, Program Year 2024 Department of Environmental Protection Catalog of State Financial Assistance Number: 37.039 Program Name: Statewide Water Quality Restoration Projects, Program Year 2024 Department of Economic Opportunity Catalog of State Financial Assistance Number: 40.040 Program Name: Facilities for New Professional Sports Retained Professional Sports, or Retained Spring Franchise, Program Year 2024 Department of Education and Commissioner of Education Passed through Early Learning Coalition of Hillsborough County Inc. Catalog of State Financial Assistance Number: 48.108 Program Name: Head Start Program, Program Year 2023 and 2024 Department of Children and Families Catalog of State Financial Assistance Number: 60.074 Program Name: Out of Home Supports, Program Year 2024 Criteria: The schedule of expenditures of federal awards and state financial assistance (the Schedule) should reflect expenditures of federal and state programs. 2 CFR 200.510(b) indicates 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 total federal awards expended as determined in accordance with 2 CFR 200.502. Rule 69I-5.003 of the Department of Financial Services, Rules, Chapter 69I-5, Florida Administrative Code, State Financial Assistance (Florida Code), requires an auditee to prepare a schedule of expenditures of state financial assistance for the period covered by the auditee’s financial statements. Condition: During our audit, we observed that Schedule preparation, analysis, and review was not sufficient to detect and correct errors in the amount of federal and state award expenditures. This resulted in multiple iterations of the Schedule provided to the auditor and material changes to the balances reported on the Schedule. As a result, the Schedule did not comply with the requirements of the Uniform Guidance and the Florida Code. The County’s total federal and state program expenditures increased (decreased) by $31.2 and ($8.4) million, respectively to correct the errors Cause: Internal controls over financial reporting related to the Schedule were not sufficient to ensure that the Schedule and related grant reconciliations were accurate and timely. Questioned Costs: None Context: Federal award program expenditures were understated by approximately $31.2 million and state award program expenditures were overstated by approximately $8.4 million. Effect or potential effect: Misstatements in the SEFA/SESA can result in the inaccurate identification of major programs, audit inefficiencies and SEFA/SESA amounts provided to the users of the compliance report that are misstated. Recommendation: We recommend that management enhance controls and procedures to ensure federal and state award expenditures are accurately reported and reviewed regularly throughout the fiscal year in order to enhance the timeliness and accuracy of Schedule reporting. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Finding 2024-005: Material Weakness and Noncompliance, Compiling and Reporting an Accurate Schedule of Expenditures of Federal Awards and State Financial Assistance (Repeat) Department of Health and Human Services Assistance Listing Number: 93.600 Program Name: Head Start Cluster, Program Year 2022, 2023 and 2024 Department of the Treasury Passed through the State of Florida Department of State Assistance Listing Number: 21.027 Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds, Program Year 2023 Department of Health and Human Services Passed through the State of Florida Department of Revenue Assistance Listing Number: 93.563 Program Name: Child Support Enforcement – Title IV-D, Program Year 2024 Department of Environmental Protection Catalog of State Financial Assistance Number: 37.039 Program Name: Statewide Water Quality Restoration Projects, Program Year 2024 Department of Economic Opportunity Catalog of State Financial Assistance Number: 40.040 Program Name: Facilities for New Professional Sports Retained Professional Sports, or Retained Spring Franchise, Program Year 2024 Department of Education and Commissioner of Education Passed through Early Learning Coalition of Hillsborough County Inc. Catalog of State Financial Assistance Number: 48.108 Program Name: Head Start Program, Program Year 2023 and 2024 Department of Children and Families Catalog of State Financial Assistance Number: 60.074 Program Name: Out of Home Supports, Program Year 2024 Criteria: The schedule of expenditures of federal awards and state financial assistance (the Schedule) should reflect expenditures of federal and state programs. 2 CFR 200.510(b) indicates 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 total federal awards expended as determined in accordance with 2 CFR 200.502. Rule 69I-5.003 of the Department of Financial Services, Rules, Chapter 69I-5, Florida Administrative Code, State Financial Assistance (Florida Code), requires an auditee to prepare a schedule of expenditures of state financial assistance for the period covered by the auditee’s financial statements. Condition: During our audit, we observed that Schedule preparation, analysis, and review was not sufficient to detect and correct errors in the amount of federal and state award expenditures. This resulted in multiple iterations of the Schedule provided to the auditor and material changes to the balances reported on the Schedule. As a result, the Schedule did not comply with the requirements of the Uniform Guidance and the Florida Code. The County’s total federal and state program expenditures increased (decreased) by $31.2 and ($8.4) million, respectively to correct the errors Cause: Internal controls over financial reporting related to the Schedule were not sufficient to ensure that the Schedule and related grant reconciliations were accurate and timely. Questioned Costs: None Context: Federal award program expenditures were understated by approximately $31.2 million and state award program expenditures were overstated by approximately $8.4 million. Effect or potential effect: Misstatements in the SEFA/SESA can result in the inaccurate identification of major programs, audit inefficiencies and SEFA/SESA amounts provided to the users of the compliance report that are misstated. Recommendation: We recommend that management enhance controls and procedures to ensure federal and state award expenditures are accurately reported and reviewed regularly throughout the fiscal year in order to enhance the timeliness and accuracy of Schedule reporting. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Finding 2024-005: Material Weakness and Noncompliance, Compiling and Reporting an Accurate Schedule of Expenditures of Federal Awards and State Financial Assistance (Repeat) Department of Health and Human Services Assistance Listing Number: 93.600 Program Name: Head Start Cluster, Program Year 2022, 2023 and 2024 Department of the Treasury Passed through the State of Florida Department of State Assistance Listing Number: 21.027 Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds, Program Year 2023 Department of Health and Human Services Passed through the State of Florida Department of Revenue Assistance Listing Number: 93.563 Program Name: Child Support Enforcement – Title IV-D, Program Year 2024 Department of Environmental Protection Catalog of State Financial Assistance Number: 37.039 Program Name: Statewide Water Quality Restoration Projects, Program Year 2024 Department of Economic Opportunity Catalog of State Financial Assistance Number: 40.040 Program Name: Facilities for New Professional Sports Retained Professional Sports, or Retained Spring Franchise, Program Year 2024 Department of Education and Commissioner of Education Passed through Early Learning Coalition of Hillsborough County Inc. Catalog of State Financial Assistance Number: 48.108 Program Name: Head Start Program, Program Year 2023 and 2024 Department of Children and Families Catalog of State Financial Assistance Number: 60.074 Program Name: Out of Home Supports, Program Year 2024 Criteria: The schedule of expenditures of federal awards and state financial assistance (the Schedule) should reflect expenditures of federal and state programs. 2 CFR 200.510(b) indicates 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 total federal awards expended as determined in accordance with 2 CFR 200.502. Rule 69I-5.003 of the Department of Financial Services, Rules, Chapter 69I-5, Florida Administrative Code, State Financial Assistance (Florida Code), requires an auditee to prepare a schedule of expenditures of state financial assistance for the period covered by the auditee’s financial statements. Condition: During our audit, we observed that Schedule preparation, analysis, and review was not sufficient to detect and correct errors in the amount of federal and state award expenditures. This resulted in multiple iterations of the Schedule provided to the auditor and material changes to the balances reported on the Schedule. As a result, the Schedule did not comply with the requirements of the Uniform Guidance and the Florida Code. The County’s total federal and state program expenditures increased (decreased) by $31.2 and ($8.4) million, respectively to correct the errors Cause: Internal controls over financial reporting related to the Schedule were not sufficient to ensure that the Schedule and related grant reconciliations were accurate and timely. Questioned Costs: None Context: Federal award program expenditures were understated by approximately $31.2 million and state award program expenditures were overstated by approximately $8.4 million. Effect or potential effect: Misstatements in the SEFA/SESA can result in the inaccurate identification of major programs, audit inefficiencies and SEFA/SESA amounts provided to the users of the compliance report that are misstated. Recommendation: We recommend that management enhance controls and procedures to ensure federal and state award expenditures are accurately reported and reviewed regularly throughout the fiscal year in order to enhance the timeliness and accuracy of Schedule reporting. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Finding 2024-005: Material Weakness and Noncompliance, Compiling and Reporting an Accurate Schedule of Expenditures of Federal Awards and State Financial Assistance (Repeat) Department of Health and Human Services Assistance Listing Number: 93.600 Program Name: Head Start Cluster, Program Year 2022, 2023 and 2024 Department of the Treasury Passed through the State of Florida Department of State Assistance Listing Number: 21.027 Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds, Program Year 2023 Department of Health and Human Services Passed through the State of Florida Department of Revenue Assistance Listing Number: 93.563 Program Name: Child Support Enforcement – Title IV-D, Program Year 2024 Department of Environmental Protection Catalog of State Financial Assistance Number: 37.039 Program Name: Statewide Water Quality Restoration Projects, Program Year 2024 Department of Economic Opportunity Catalog of State Financial Assistance Number: 40.040 Program Name: Facilities for New Professional Sports Retained Professional Sports, or Retained Spring Franchise, Program Year 2024 Department of Education and Commissioner of Education Passed through Early Learning Coalition of Hillsborough County Inc. Catalog of State Financial Assistance Number: 48.108 Program Name: Head Start Program, Program Year 2023 and 2024 Department of Children and Families Catalog of State Financial Assistance Number: 60.074 Program Name: Out of Home Supports, Program Year 2024 Criteria: The schedule of expenditures of federal awards and state financial assistance (the Schedule) should reflect expenditures of federal and state programs. 2 CFR 200.510(b) indicates 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 total federal awards expended as determined in accordance with 2 CFR 200.502. Rule 69I-5.003 of the Department of Financial Services, Rules, Chapter 69I-5, Florida Administrative Code, State Financial Assistance (Florida Code), requires an auditee to prepare a schedule of expenditures of state financial assistance for the period covered by the auditee’s financial statements. Condition: During our audit, we observed that Schedule preparation, analysis, and review was not sufficient to detect and correct errors in the amount of federal and state award expenditures. This resulted in multiple iterations of the Schedule provided to the auditor and material changes to the balances reported on the Schedule. As a result, the Schedule did not comply with the requirements of the Uniform Guidance and the Florida Code. The County’s total federal and state program expenditures increased (decreased) by $31.2 and ($8.4) million, respectively to correct the errors Cause: Internal controls over financial reporting related to the Schedule were not sufficient to ensure that the Schedule and related grant reconciliations were accurate and timely. Questioned Costs: None Context: Federal award program expenditures were understated by approximately $31.2 million and state award program expenditures were overstated by approximately $8.4 million. Effect or potential effect: Misstatements in the SEFA/SESA can result in the inaccurate identification of major programs, audit inefficiencies and SEFA/SESA amounts provided to the users of the compliance report that are misstated. Recommendation: We recommend that management enhance controls and procedures to ensure federal and state award expenditures are accurately reported and reviewed regularly throughout the fiscal year in order to enhance the timeliness and accuracy of Schedule reporting. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Finding 2024-005: Material Weakness and Noncompliance, Compiling and Reporting an Accurate Schedule of Expenditures of Federal Awards and State Financial Assistance (Repeat) Department of Health and Human Services Assistance Listing Number: 93.600 Program Name: Head Start Cluster, Program Year 2022, 2023 and 2024 Department of the Treasury Passed through the State of Florida Department of State Assistance Listing Number: 21.027 Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds, Program Year 2023 Department of Health and Human Services Passed through the State of Florida Department of Revenue Assistance Listing Number: 93.563 Program Name: Child Support Enforcement – Title IV-D, Program Year 2024 Department of Environmental Protection Catalog of State Financial Assistance Number: 37.039 Program Name: Statewide Water Quality Restoration Projects, Program Year 2024 Department of Economic Opportunity Catalog of State Financial Assistance Number: 40.040 Program Name: Facilities for New Professional Sports Retained Professional Sports, or Retained Spring Franchise, Program Year 2024 Department of Education and Commissioner of Education Passed through Early Learning Coalition of Hillsborough County Inc. Catalog of State Financial Assistance Number: 48.108 Program Name: Head Start Program, Program Year 2023 and 2024 Department of Children and Families Catalog of State Financial Assistance Number: 60.074 Program Name: Out of Home Supports, Program Year 2024 Criteria: The schedule of expenditures of federal awards and state financial assistance (the Schedule) should reflect expenditures of federal and state programs. 2 CFR 200.510(b) indicates 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 total federal awards expended as determined in accordance with 2 CFR 200.502. Rule 69I-5.003 of the Department of Financial Services, Rules, Chapter 69I-5, Florida Administrative Code, State Financial Assistance (Florida Code), requires an auditee to prepare a schedule of expenditures of state financial assistance for the period covered by the auditee’s financial statements. Condition: During our audit, we observed that Schedule preparation, analysis, and review was not sufficient to detect and correct errors in the amount of federal and state award expenditures. This resulted in multiple iterations of the Schedule provided to the auditor and material changes to the balances reported on the Schedule. As a result, the Schedule did not comply with the requirements of the Uniform Guidance and the Florida Code. The County’s total federal and state program expenditures increased (decreased) by $31.2 and ($8.4) million, respectively to correct the errors Cause: Internal controls over financial reporting related to the Schedule were not sufficient to ensure that the Schedule and related grant reconciliations were accurate and timely. Questioned Costs: None Context: Federal award program expenditures were understated by approximately $31.2 million and state award program expenditures were overstated by approximately $8.4 million. Effect or potential effect: Misstatements in the SEFA/SESA can result in the inaccurate identification of major programs, audit inefficiencies and SEFA/SESA amounts provided to the users of the compliance report that are misstated. Recommendation: We recommend that management enhance controls and procedures to ensure federal and state award expenditures are accurately reported and reviewed regularly throughout the fiscal year in order to enhance the timeliness and accuracy of Schedule reporting. Views of responsible officials: Management agrees with the finding. See corrective action plan.
U.S. Department of Education - 84.177B Independent Living Services for Older Individuals who are Blind U.S. Department of Health and Human Services - 93.071 Benefits Enrollment Center, 93.369 ACL Independent Living State Grants, 93.432 Center for Independent Living, 93.958 Block Grants for Community Mental Health Services, 93.959 Substance Abuse Prevention and Treatment Block grant 2024-003 Inaccurate Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a SEFA that includes the total federal awards expended, the name of the federal agency, the Assistance Listing Number, the pass-through entity identifying number (if applicable), and other relevant details to ensure complete and accurate reporting. Condition: During our audit of the federal awards received by the League, we noted that the SEFA was not prepared in accordance with the requirements of 2 CFR Part 200, Subpart F. Specifically, the initial SEFA provided to auditors omitted two federal programs and included inaccurate amounts for one other programs. In addition, required elements for the federal agency and pass through entities were missing. Cause: The errors occurred due to a lack of formal procedures and oversight in compiling and reviewing the SEFA. The League relied on documents that were not reconciled to the general ledger or grant agreements. Effect: Errors in the preparation of the SEFA could lead funding agencies to misinterpret the level of spending for a particular program for the period under audit. Additionally, the identification of major federal award programs chosen for specific compliance testing could be erroneous, depending on the misstatement in the total amount of federal expenditures for the year. Questioned Costs: None noted. Recommendation: We recommend that the League implement a formal process for preparing the SEFA that includes reconciling the schedule to the general ledger and grant records. In addition, staff responsible for federal grant reporting should receive training on SEFA preparation requirements under 2 CFR Part 200. Views of Rsponsible Officials and Planned Corrective Actions: See corrective action plan on page 50.
U.S. Department of Education - 84.177B Independent Living Services for Older Individuals who are Blind U.S. Department of Health and Human Services - 93.071 Benefits Enrollment Center, 93.369 ACL Independent Living State Grants, 93.432 Center for Independent Living, 93.958 Block Grants for Community Mental Health Services, 93.959 Substance Abuse Prevention and Treatment Block grant 2024-003 Inaccurate Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a SEFA that includes the total federal awards expended, the name of the federal agency, the Assistance Listing Number, the pass-through entity identifying number (if applicable), and other relevant details to ensure complete and accurate reporting. Condition: During our audit of the federal awards received by the League, we noted that the SEFA was not prepared in accordance with the requirements of 2 CFR Part 200, Subpart F. Specifically, the initial SEFA provided to auditors omitted two federal programs and included inaccurate amounts for one other programs. In addition, required elements for the federal agency and pass through entities were missing. Cause: The errors occurred due to a lack of formal procedures and oversight in compiling and reviewing the SEFA. The League relied on documents that were not reconciled to the general ledger or grant agreements. Effect: Errors in the preparation of the SEFA could lead funding agencies to misinterpret the level of spending for a particular program for the period under audit. Additionally, the identification of major federal award programs chosen for specific compliance testing could be erroneous, depending on the misstatement in the total amount of federal expenditures for the year. Questioned Costs: None noted. Recommendation: We recommend that the League implement a formal process for preparing the SEFA that includes reconciling the schedule to the general ledger and grant records. In addition, staff responsible for federal grant reporting should receive training on SEFA preparation requirements under 2 CFR Part 200. Views of Rsponsible Officials and Planned Corrective Actions: See corrective action plan on page 50.
U.S. Department of Education - 84.177B Independent Living Services for Older Individuals who are Blind U.S. Department of Health and Human Services - 93.071 Benefits Enrollment Center, 93.369 ACL Independent Living State Grants, 93.432 Center for Independent Living, 93.958 Block Grants for Community Mental Health Services, 93.959 Substance Abuse Prevention and Treatment Block grant 2024-003 Inaccurate Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a SEFA that includes the total federal awards expended, the name of the federal agency, the Assistance Listing Number, the pass-through entity identifying number (if applicable), and other relevant details to ensure complete and accurate reporting. Condition: During our audit of the federal awards received by the League, we noted that the SEFA was not prepared in accordance with the requirements of 2 CFR Part 200, Subpart F. Specifically, the initial SEFA provided to auditors omitted two federal programs and included inaccurate amounts for one other programs. In addition, required elements for the federal agency and pass through entities were missing. Cause: The errors occurred due to a lack of formal procedures and oversight in compiling and reviewing the SEFA. The League relied on documents that were not reconciled to the general ledger or grant agreements. Effect: Errors in the preparation of the SEFA could lead funding agencies to misinterpret the level of spending for a particular program for the period under audit. Additionally, the identification of major federal award programs chosen for specific compliance testing could be erroneous, depending on the misstatement in the total amount of federal expenditures for the year. Questioned Costs: None noted. Recommendation: We recommend that the League implement a formal process for preparing the SEFA that includes reconciling the schedule to the general ledger and grant records. In addition, staff responsible for federal grant reporting should receive training on SEFA preparation requirements under 2 CFR Part 200. Views of Rsponsible Officials and Planned Corrective Actions: See corrective action plan on page 50.
U.S. Department of Education - 84.177B Independent Living Services for Older Individuals who are Blind U.S. Department of Health and Human Services - 93.071 Benefits Enrollment Center, 93.369 ACL Independent Living State Grants, 93.432 Center for Independent Living, 93.958 Block Grants for Community Mental Health Services, 93.959 Substance Abuse Prevention and Treatment Block grant 2024-003 Inaccurate Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a SEFA that includes the total federal awards expended, the name of the federal agency, the Assistance Listing Number, the pass-through entity identifying number (if applicable), and other relevant details to ensure complete and accurate reporting. Condition: During our audit of the federal awards received by the League, we noted that the SEFA was not prepared in accordance with the requirements of 2 CFR Part 200, Subpart F. Specifically, the initial SEFA provided to auditors omitted two federal programs and included inaccurate amounts for one other programs. In addition, required elements for the federal agency and pass through entities were missing. Cause: The errors occurred due to a lack of formal procedures and oversight in compiling and reviewing the SEFA. The League relied on documents that were not reconciled to the general ledger or grant agreements. Effect: Errors in the preparation of the SEFA could lead funding agencies to misinterpret the level of spending for a particular program for the period under audit. Additionally, the identification of major federal award programs chosen for specific compliance testing could be erroneous, depending on the misstatement in the total amount of federal expenditures for the year. Questioned Costs: None noted. Recommendation: We recommend that the League implement a formal process for preparing the SEFA that includes reconciling the schedule to the general ledger and grant records. In addition, staff responsible for federal grant reporting should receive training on SEFA preparation requirements under 2 CFR Part 200. Views of Rsponsible Officials and Planned Corrective Actions: See corrective action plan on page 50.
U.S. Department of Education - 84.177B Independent Living Services for Older Individuals who are Blind U.S. Department of Health and Human Services - 93.071 Benefits Enrollment Center, 93.369 ACL Independent Living State Grants, 93.432 Center for Independent Living, 93.958 Block Grants for Community Mental Health Services, 93.959 Substance Abuse Prevention and Treatment Block grant 2024-003 Inaccurate Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a SEFA that includes the total federal awards expended, the name of the federal agency, the Assistance Listing Number, the pass-through entity identifying number (if applicable), and other relevant details to ensure complete and accurate reporting. Condition: During our audit of the federal awards received by the League, we noted that the SEFA was not prepared in accordance with the requirements of 2 CFR Part 200, Subpart F. Specifically, the initial SEFA provided to auditors omitted two federal programs and included inaccurate amounts for one other programs. In addition, required elements for the federal agency and pass through entities were missing. Cause: The errors occurred due to a lack of formal procedures and oversight in compiling and reviewing the SEFA. The League relied on documents that were not reconciled to the general ledger or grant agreements. Effect: Errors in the preparation of the SEFA could lead funding agencies to misinterpret the level of spending for a particular program for the period under audit. Additionally, the identification of major federal award programs chosen for specific compliance testing could be erroneous, depending on the misstatement in the total amount of federal expenditures for the year. Questioned Costs: None noted. Recommendation: We recommend that the League implement a formal process for preparing the SEFA that includes reconciling the schedule to the general ledger and grant records. In addition, staff responsible for federal grant reporting should receive training on SEFA preparation requirements under 2 CFR Part 200. Views of Rsponsible Officials and Planned Corrective Actions: See corrective action plan on page 50.
U.S. Department of Education - 84.177B Independent Living Services for Older Individuals who are Blind U.S. Department of Health and Human Services - 93.071 Benefits Enrollment Center, 93.369 ACL Independent Living State Grants, 93.432 Center for Independent Living, 93.958 Block Grants for Community Mental Health Services, 93.959 Substance Abuse Prevention and Treatment Block grant 2024-003 Inaccurate Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a SEFA that includes the total federal awards expended, the name of the federal agency, the Assistance Listing Number, the pass-through entity identifying number (if applicable), and other relevant details to ensure complete and accurate reporting. Condition: During our audit of the federal awards received by the League, we noted that the SEFA was not prepared in accordance with the requirements of 2 CFR Part 200, Subpart F. Specifically, the initial SEFA provided to auditors omitted two federal programs and included inaccurate amounts for one other programs. In addition, required elements for the federal agency and pass through entities were missing. Cause: The errors occurred due to a lack of formal procedures and oversight in compiling and reviewing the SEFA. The League relied on documents that were not reconciled to the general ledger or grant agreements. Effect: Errors in the preparation of the SEFA could lead funding agencies to misinterpret the level of spending for a particular program for the period under audit. Additionally, the identification of major federal award programs chosen for specific compliance testing could be erroneous, depending on the misstatement in the total amount of federal expenditures for the year. Questioned Costs: None noted. Recommendation: We recommend that the League implement a formal process for preparing the SEFA that includes reconciling the schedule to the general ledger and grant records. In addition, staff responsible for federal grant reporting should receive training on SEFA preparation requirements under 2 CFR Part 200. Views of Rsponsible Officials and Planned Corrective Actions: See corrective action plan on page 50.
Federal Agency: Various Assistance Listing Number: Multiple Compliance Requirement: Reporting Finding 2024-001: Submission of the Audit Reporting Package and Data Collection Form (Repeat of Finding 2023-001) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a Schedule of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. Per §200.512(a), the SEFA must be submitted to the Federal Audit Clearinghouse (FAC) within the required deadline. Condition: The audit reporting package and data collection form for the year ended September 30, 2024, was not submitted to the FAC within the timeframe as required by the Uniform Guidance. Cause: The delay was due to a lack of capacity in the finance department and not following the year-end closing schedule. Effect: To qualify as a low-risk auditee, 2 CFR section 200.520 requires the audit reporting package and data collection form to be submitted to the FAC by the due date for each of the previous two years. Late filing will result in noncompliance with timely submission of financial information to the grantor agencies. Recommendation: Management should address the lack of capacity in the finance department and monitor the year-end closing schedule for a timely audit reporting package and data collection form to ensure compliance with federal deadlines. Questioned costs: None Responsible Official's Response: We agree with the auditors’ comments, and the following action will be taken to improve the situation. At the beginning of fiscal year 2025 we have added capacity to the finance department by one full-time employee. Semcac has also contracted with an outsourcing accounting firm to enhance and improve our internal controls, processes, and procedures to ensure we both follow our year-end closing schedule and provide a timely audit reporting package.
Federal Agency: Various Assistance Listing Number: Multiple Compliance Requirement: Reporting Finding 2024-001: Submission of the Audit Reporting Package and Data Collection Form (Repeat of Finding 2023-001) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a Schedule of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. Per §200.512(a), the SEFA must be submitted to the Federal Audit Clearinghouse (FAC) within the required deadline. Condition: The audit reporting package and data collection form for the year ended September 30, 2024, was not submitted to the FAC within the timeframe as required by the Uniform Guidance. Cause: The delay was due to a lack of capacity in the finance department and not following the year-end closing schedule. Effect: To qualify as a low-risk auditee, 2 CFR section 200.520 requires the audit reporting package and data collection form to be submitted to the FAC by the due date for each of the previous two years. Late filing will result in noncompliance with timely submission of financial information to the grantor agencies. Recommendation: Management should address the lack of capacity in the finance department and monitor the year-end closing schedule for a timely audit reporting package and data collection form to ensure compliance with federal deadlines. Questioned costs: None Responsible Official's Response: We agree with the auditors’ comments, and the following action will be taken to improve the situation. At the beginning of fiscal year 2025 we have added capacity to the finance department by one full-time employee. Semcac has also contracted with an outsourcing accounting firm to enhance and improve our internal controls, processes, and procedures to ensure we both follow our year-end closing schedule and provide a timely audit reporting package.
Federal Agency: Various Assistance Listing Number: Multiple Compliance Requirement: Reporting Finding 2024-001: Submission of the Audit Reporting Package and Data Collection Form (Repeat of Finding 2023-001) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a Schedule of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. Per §200.512(a), the SEFA must be submitted to the Federal Audit Clearinghouse (FAC) within the required deadline. Condition: The audit reporting package and data collection form for the year ended September 30, 2024, was not submitted to the FAC within the timeframe as required by the Uniform Guidance. Cause: The delay was due to a lack of capacity in the finance department and not following the year-end closing schedule. Effect: To qualify as a low-risk auditee, 2 CFR section 200.520 requires the audit reporting package and data collection form to be submitted to the FAC by the due date for each of the previous two years. Late filing will result in noncompliance with timely submission of financial information to the grantor agencies. Recommendation: Management should address the lack of capacity in the finance department and monitor the year-end closing schedule for a timely audit reporting package and data collection form to ensure compliance with federal deadlines. Questioned costs: None Responsible Official's Response: We agree with the auditors’ comments, and the following action will be taken to improve the situation. At the beginning of fiscal year 2025 we have added capacity to the finance department by one full-time employee. Semcac has also contracted with an outsourcing accounting firm to enhance and improve our internal controls, processes, and procedures to ensure we both follow our year-end closing schedule and provide a timely audit reporting package.
Federal Agency: Various Assistance Listing Number: Multiple Compliance Requirement: Reporting Finding 2024-001: Submission of the Audit Reporting Package and Data Collection Form (Repeat of Finding 2023-001) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a Schedule of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. Per §200.512(a), the SEFA must be submitted to the Federal Audit Clearinghouse (FAC) within the required deadline. Condition: The audit reporting package and data collection form for the year ended September 30, 2024, was not submitted to the FAC within the timeframe as required by the Uniform Guidance. Cause: The delay was due to a lack of capacity in the finance department and not following the year-end closing schedule. Effect: To qualify as a low-risk auditee, 2 CFR section 200.520 requires the audit reporting package and data collection form to be submitted to the FAC by the due date for each of the previous two years. Late filing will result in noncompliance with timely submission of financial information to the grantor agencies. Recommendation: Management should address the lack of capacity in the finance department and monitor the year-end closing schedule for a timely audit reporting package and data collection form to ensure compliance with federal deadlines. Questioned costs: None Responsible Official's Response: We agree with the auditors’ comments, and the following action will be taken to improve the situation. At the beginning of fiscal year 2025 we have added capacity to the finance department by one full-time employee. Semcac has also contracted with an outsourcing accounting firm to enhance and improve our internal controls, processes, and procedures to ensure we both follow our year-end closing schedule and provide a timely audit reporting package.
Federal Agency: Various Assistance Listing Number: Multiple Compliance Requirement: Reporting Finding 2024-001: Submission of the Audit Reporting Package and Data Collection Form (Repeat of Finding 2023-001) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a Schedule of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. Per §200.512(a), the SEFA must be submitted to the Federal Audit Clearinghouse (FAC) within the required deadline. Condition: The audit reporting package and data collection form for the year ended September 30, 2024, was not submitted to the FAC within the timeframe as required by the Uniform Guidance. Cause: The delay was due to a lack of capacity in the finance department and not following the year-end closing schedule. Effect: To qualify as a low-risk auditee, 2 CFR section 200.520 requires the audit reporting package and data collection form to be submitted to the FAC by the due date for each of the previous two years. Late filing will result in noncompliance with timely submission of financial information to the grantor agencies. Recommendation: Management should address the lack of capacity in the finance department and monitor the year-end closing schedule for a timely audit reporting package and data collection form to ensure compliance with federal deadlines. Questioned costs: None Responsible Official's Response: We agree with the auditors’ comments, and the following action will be taken to improve the situation. At the beginning of fiscal year 2025 we have added capacity to the finance department by one full-time employee. Semcac has also contracted with an outsourcing accounting firm to enhance and improve our internal controls, processes, and procedures to ensure we both follow our year-end closing schedule and provide a timely audit reporting package.
Federal Agency: Various Assistance Listing Number: Multiple Compliance Requirement: Reporting Finding 2024-001: Submission of the Audit Reporting Package and Data Collection Form (Repeat of Finding 2023-001) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a Schedule of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. Per §200.512(a), the SEFA must be submitted to the Federal Audit Clearinghouse (FAC) within the required deadline. Condition: The audit reporting package and data collection form for the year ended September 30, 2024, was not submitted to the FAC within the timeframe as required by the Uniform Guidance. Cause: The delay was due to a lack of capacity in the finance department and not following the year-end closing schedule. Effect: To qualify as a low-risk auditee, 2 CFR section 200.520 requires the audit reporting package and data collection form to be submitted to the FAC by the due date for each of the previous two years. Late filing will result in noncompliance with timely submission of financial information to the grantor agencies. Recommendation: Management should address the lack of capacity in the finance department and monitor the year-end closing schedule for a timely audit reporting package and data collection form to ensure compliance with federal deadlines. Questioned costs: None Responsible Official's Response: We agree with the auditors’ comments, and the following action will be taken to improve the situation. At the beginning of fiscal year 2025 we have added capacity to the finance department by one full-time employee. Semcac has also contracted with an outsourcing accounting firm to enhance and improve our internal controls, processes, and procedures to ensure we both follow our year-end closing schedule and provide a timely audit reporting package.
Federal Agency: Various Assistance Listing Number: Multiple Compliance Requirement: Reporting Finding 2024-001: Submission of the Audit Reporting Package and Data Collection Form (Repeat of Finding 2023-001) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a Schedule of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. Per §200.512(a), the SEFA must be submitted to the Federal Audit Clearinghouse (FAC) within the required deadline. Condition: The audit reporting package and data collection form for the year ended September 30, 2024, was not submitted to the FAC within the timeframe as required by the Uniform Guidance. Cause: The delay was due to a lack of capacity in the finance department and not following the year-end closing schedule. Effect: To qualify as a low-risk auditee, 2 CFR section 200.520 requires the audit reporting package and data collection form to be submitted to the FAC by the due date for each of the previous two years. Late filing will result in noncompliance with timely submission of financial information to the grantor agencies. Recommendation: Management should address the lack of capacity in the finance department and monitor the year-end closing schedule for a timely audit reporting package and data collection form to ensure compliance with federal deadlines. Questioned costs: None Responsible Official's Response: We agree with the auditors’ comments, and the following action will be taken to improve the situation. At the beginning of fiscal year 2025 we have added capacity to the finance department by one full-time employee. Semcac has also contracted with an outsourcing accounting firm to enhance and improve our internal controls, processes, and procedures to ensure we both follow our year-end closing schedule and provide a timely audit reporting package.
Federal Agency: Various Assistance Listing Number: Multiple Compliance Requirement: Reporting Finding 2024-001: Submission of the Audit Reporting Package and Data Collection Form (Repeat of Finding 2023-001) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a Schedule of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. Per §200.512(a), the SEFA must be submitted to the Federal Audit Clearinghouse (FAC) within the required deadline. Condition: The audit reporting package and data collection form for the year ended September 30, 2024, was not submitted to the FAC within the timeframe as required by the Uniform Guidance. Cause: The delay was due to a lack of capacity in the finance department and not following the year-end closing schedule. Effect: To qualify as a low-risk auditee, 2 CFR section 200.520 requires the audit reporting package and data collection form to be submitted to the FAC by the due date for each of the previous two years. Late filing will result in noncompliance with timely submission of financial information to the grantor agencies. Recommendation: Management should address the lack of capacity in the finance department and monitor the year-end closing schedule for a timely audit reporting package and data collection form to ensure compliance with federal deadlines. Questioned costs: None Responsible Official's Response: We agree with the auditors’ comments, and the following action will be taken to improve the situation. At the beginning of fiscal year 2025 we have added capacity to the finance department by one full-time employee. Semcac has also contracted with an outsourcing accounting firm to enhance and improve our internal controls, processes, and procedures to ensure we both follow our year-end closing schedule and provide a timely audit reporting package.
Federal Agency: Various Assistance Listing Number: Multiple Compliance Requirement: Reporting Finding 2024-001: Submission of the Audit Reporting Package and Data Collection Form (Repeat of Finding 2023-001) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a Schedule of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. Per §200.512(a), the SEFA must be submitted to the Federal Audit Clearinghouse (FAC) within the required deadline. Condition: The audit reporting package and data collection form for the year ended September 30, 2024, was not submitted to the FAC within the timeframe as required by the Uniform Guidance. Cause: The delay was due to a lack of capacity in the finance department and not following the year-end closing schedule. Effect: To qualify as a low-risk auditee, 2 CFR section 200.520 requires the audit reporting package and data collection form to be submitted to the FAC by the due date for each of the previous two years. Late filing will result in noncompliance with timely submission of financial information to the grantor agencies. Recommendation: Management should address the lack of capacity in the finance department and monitor the year-end closing schedule for a timely audit reporting package and data collection form to ensure compliance with federal deadlines. Questioned costs: None Responsible Official's Response: We agree with the auditors’ comments, and the following action will be taken to improve the situation. At the beginning of fiscal year 2025 we have added capacity to the finance department by one full-time employee. Semcac has also contracted with an outsourcing accounting firm to enhance and improve our internal controls, processes, and procedures to ensure we both follow our year-end closing schedule and provide a timely audit reporting package.
Federal Agency: Various Assistance Listing Number: Multiple Compliance Requirement: Reporting Finding 2024-001: Submission of the Audit Reporting Package and Data Collection Form (Repeat of Finding 2023-001) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a Schedule of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. Per §200.512(a), the SEFA must be submitted to the Federal Audit Clearinghouse (FAC) within the required deadline. Condition: The audit reporting package and data collection form for the year ended September 30, 2024, was not submitted to the FAC within the timeframe as required by the Uniform Guidance. Cause: The delay was due to a lack of capacity in the finance department and not following the year-end closing schedule. Effect: To qualify as a low-risk auditee, 2 CFR section 200.520 requires the audit reporting package and data collection form to be submitted to the FAC by the due date for each of the previous two years. Late filing will result in noncompliance with timely submission of financial information to the grantor agencies. Recommendation: Management should address the lack of capacity in the finance department and monitor the year-end closing schedule for a timely audit reporting package and data collection form to ensure compliance with federal deadlines. Questioned costs: None Responsible Official's Response: We agree with the auditors’ comments, and the following action will be taken to improve the situation. At the beginning of fiscal year 2025 we have added capacity to the finance department by one full-time employee. Semcac has also contracted with an outsourcing accounting firm to enhance and improve our internal controls, processes, and procedures to ensure we both follow our year-end closing schedule and provide a timely audit reporting package.
Federal Agency: Various Assistance Listing Number: Multiple Compliance Requirement: Reporting Finding 2024-001: Submission of the Audit Reporting Package and Data Collection Form (Repeat of Finding 2023-001) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a Schedule of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. Per §200.512(a), the SEFA must be submitted to the Federal Audit Clearinghouse (FAC) within the required deadline. Condition: The audit reporting package and data collection form for the year ended September 30, 2024, was not submitted to the FAC within the timeframe as required by the Uniform Guidance. Cause: The delay was due to a lack of capacity in the finance department and not following the year-end closing schedule. Effect: To qualify as a low-risk auditee, 2 CFR section 200.520 requires the audit reporting package and data collection form to be submitted to the FAC by the due date for each of the previous two years. Late filing will result in noncompliance with timely submission of financial information to the grantor agencies. Recommendation: Management should address the lack of capacity in the finance department and monitor the year-end closing schedule for a timely audit reporting package and data collection form to ensure compliance with federal deadlines. Questioned costs: None Responsible Official's Response: We agree with the auditors’ comments, and the following action will be taken to improve the situation. At the beginning of fiscal year 2025 we have added capacity to the finance department by one full-time employee. Semcac has also contracted with an outsourcing accounting firm to enhance and improve our internal controls, processes, and procedures to ensure we both follow our year-end closing schedule and provide a timely audit reporting package.
Federal Agency: Various Assistance Listing Number: Multiple Compliance Requirement: Reporting Finding 2024-001: Submission of the Audit Reporting Package and Data Collection Form (Repeat of Finding 2023-001) Criteria: Per 2 CFR §200.510(b), the auditee must prepare a Schedule of Federal Awards (SEFA) for the period covered by the auditee’s financial statements. Per §200.512(a), the SEFA must be submitted to the Federal Audit Clearinghouse (FAC) within the required deadline. Condition: The audit reporting package and data collection form for the year ended September 30, 2024, was not submitted to the FAC within the timeframe as required by the Uniform Guidance. Cause: The delay was due to a lack of capacity in the finance department and not following the year-end closing schedule. Effect: To qualify as a low-risk auditee, 2 CFR section 200.520 requires the audit reporting package and data collection form to be submitted to the FAC by the due date for each of the previous two years. Late filing will result in noncompliance with timely submission of financial information to the grantor agencies. Recommendation: Management should address the lack of capacity in the finance department and monitor the year-end closing schedule for a timely audit reporting package and data collection form to ensure compliance with federal deadlines. Questioned costs: None Responsible Official's Response: We agree with the auditors’ comments, and the following action will be taken to improve the situation. At the beginning of fiscal year 2025 we have added capacity to the finance department by one full-time employee. Semcac has also contracted with an outsourcing accounting firm to enhance and improve our internal controls, processes, and procedures to ensure we both follow our year-end closing schedule and provide a timely audit reporting package.
Finding 2024-002: Schedule of Expenditures of Federal Awards (Significant Deficiency) Information on the Federal Program: Assistance Listing Number 19.518 See Finding 2024-001. Finding 2024-002 is a significant deficiency in internal control over compliance in addition to non-compliance related to the Reporting compliance area. There were no questioned costs as a result of the corrections to the SEFA.Criteria or Specific Requirement: Management is responsible for the complete and fair presentation of the financial statements, including any supplementary information that is presented in relation to the financial statements, such as the Schedule of Expenditures of Federal Awards (SEFA). Also, in accordance with 2 CFR Section 200.510 (b)(2), WRC is required to include all direct and pass-through Federal awards expended during the fiscal year in the SEFA. Condition: After the start of the audit, we noted that two pass-through federal awards had been excluded from the SEFA. As a result, the SEFA was understated by $329,598 for the year ended September 30, 2024. Management provided a revised SEFA to correct these items after the major program had been determined and audit testing had already completed. The corrections to the SEFA did not change the major program determination and no questioned costs were noted. Cause: One of the pass-through federal awards was a new source of funding for WRC, which is why the expenditures were not originally included on the SEFA. The other pass-through federal award was not classified correctly as federal, which is why the expenditures were not originally included on the SEFA. Effect or Potential Effect: The SEFA provided at the start of the audit was understated by $329,598 and, as a result, it did not accurately report WRC’s federal expenditures. When the SEFA is not accurately prepared, this could have an effect on the determination of the major programs. Identification as a Repeat Finding: Not applicable. Recommendation: We recommend that WRC enhance its procedures related to the preparation of the SEFA to ensure that all required amounts are included, depending upon the terms of the grant award.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Title and Assistance Listing Number of Federal Program - N/A Finding Type - Significant deficiency Repeat Finding - No Criteria - 2 CFR 200.510(b) requires organizations to prepare a schedule of expenditures of federal awards (SEFA), which includes total federal awards expended, as determined in accordance with 2 CFR 200.502. Condition - Expenditures incurred for the year ended September 30, 2024 were charged to various federal programs and were not reported on the SEFA for the year ended September 30, 2024. Context - The controls in place to ensure the completeness and accuracy of the SEFA were not operating as designed. As a result, $327,215 of expenditures of federal awards was not reported on the SEFA. These missing expenditures did not relate to major programs. Cause and Effect - The lack of a proper reconciliation of the SEFA to the financial records and lack of a review of the SEFA could result in an inaccurate SEFA and potentially impact major program determinations. Recommendation - We recommend the Board implement a process to ensure completion and timely review of a proper reconciliation of the SEFA to the financial statements prior to commencement of the audit. Views of Responsible Officials and Corrective Action Plan - Management will document a formal control to ensure proper reconciliation of the SEFA to the financial statements. The control will include the following: A report in substantially the same form as the annual SEFA will be developed at least quarterly and will include a reconciliation of grants receivable activity. Meetings will be held at least quarterly to review grant activity, including the aforementioned report, and assess impacts to the financial statements. These meetings will be conducted by treasury and accounting staff, and evidence of document review will be maintained. A centralized repository of information pertaining to federal grants activity will be maintained to ensure timely access to grant and expenditure data for relevant staff.
Assistance Listing, Federal Agency, and Program Name - 66.818, U.S. Environmental Protection Agency, Brownfields Assessment and Cleanup Cooperative Agreements; 21.027, U.S. Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 21.027 SLFRP0127 Pass through Entity - ALN 21.027 - State of Michigan Finding Type - Material weakness Repeat Finding - Yes 2023-002 Criteria - The Single Audit Act and Uniform Guidance require a nonfederal entity that expends $750,000 or more of federal awards in a fiscal year to have a single or program-specific audit. 2 CFR §200.508 (b) indicates that the auditee must prepare financial statements, including the schedule of expenditures of federal awards in accordance with 2 CFR §200.510. Additionally, 2 CFR §200.502 describes the basis for determining the timing of when federal awards are deemed expended and, therefore, reportable on the schedule. Condition - The schedule of expenditures of federal awards (SEFA) was not accurate. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - During the fiscal year ended September 30, 2024, the City expended approximately $2,831,000 of federal funding. The initial draft of the SEFA included the following inaccuracies: ALN 66.818 - The expenditures reported on the SEFA were understated by $148,474. ALN 21.027 - The expenditures reported on the SEFA were overstated by $2,078,221. The SEFA was also ovestated by $116,625 related to a non federal program. The errors noted above have been corrected on the SEFA as of September 30, 2024. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit. The errors resulted in the overstatement of federal expenditures. Recommendation - We recommend the City implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - The City will review its process for identifying and communicating federal grant expenditures to its auditors.