2024-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDSFederal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All awards presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None Statement of Condition During our audit, we reviewed the Coalition’s federal-grants report for the fiscal year and identified the grants, Assistance-Listing numbers (AL #s), expenditure amounts, and all other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). Finance staff subsequently confirmed the SEFA; however, additional federal expenditures and mis-grouped grant costs were found during later reviews. Criteria2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, errors in SEFA preparation could affect the major federal program determination and lead to noncompliance with 2 CFR 200 Subpart F, which in turn could result in a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2025 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 19, 2025 (Final copy of the SEFA will not be given to the auditors until requested for the Audit).Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct.
2024-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDSFederal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All awards presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None Statement of Condition During our audit, we reviewed the Coalition’s federal-grants report for the fiscal year and identified the grants, Assistance-Listing numbers (AL #s), expenditure amounts, and all other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). Finance staff subsequently confirmed the SEFA; however, additional federal expenditures and mis-grouped grant costs were found during later reviews. Criteria2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, errors in SEFA preparation could affect the major federal program determination and lead to noncompliance with 2 CFR 200 Subpart F, which in turn could result in a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2025 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 19, 2025 (Final copy of the SEFA will not be given to the auditors until requested for the Audit).Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct.
2024-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDSFederal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All awards presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None Statement of Condition During our audit, we reviewed the Coalition’s federal-grants report for the fiscal year and identified the grants, Assistance-Listing numbers (AL #s), expenditure amounts, and all other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). Finance staff subsequently confirmed the SEFA; however, additional federal expenditures and mis-grouped grant costs were found during later reviews. Criteria2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, errors in SEFA preparation could affect the major federal program determination and lead to noncompliance with 2 CFR 200 Subpart F, which in turn could result in a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2025 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 19, 2025 (Final copy of the SEFA will not be given to the auditors until requested for the Audit).Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct.
2024-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDSFederal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All awards presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None Statement of Condition During our audit, we reviewed the Coalition’s federal-grants report for the fiscal year and identified the grants, Assistance-Listing numbers (AL #s), expenditure amounts, and all other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). Finance staff subsequently confirmed the SEFA; however, additional federal expenditures and mis-grouped grant costs were found during later reviews. Criteria2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, errors in SEFA preparation could affect the major federal program determination and lead to noncompliance with 2 CFR 200 Subpart F, which in turn could result in a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2025 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 19, 2025 (Final copy of the SEFA will not be given to the auditors until requested for the Audit).Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct.
2024-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDSFederal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All awards presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None Statement of Condition During our audit, we reviewed the Coalition’s federal-grants report for the fiscal year and identified the grants, Assistance-Listing numbers (AL #s), expenditure amounts, and all other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). Finance staff subsequently confirmed the SEFA; however, additional federal expenditures and mis-grouped grant costs were found during later reviews. Criteria2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, errors in SEFA preparation could affect the major federal program determination and lead to noncompliance with 2 CFR 200 Subpart F, which in turn could result in a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2025 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 19, 2025 (Final copy of the SEFA will not be given to the auditors until requested for the Audit).Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct.
2024-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDSFederal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All awards presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None Statement of Condition During our audit, we reviewed the Coalition’s federal-grants report for the fiscal year and identified the grants, Assistance-Listing numbers (AL #s), expenditure amounts, and all other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). Finance staff subsequently confirmed the SEFA; however, additional federal expenditures and mis-grouped grant costs were found during later reviews. Criteria2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, errors in SEFA preparation could affect the major federal program determination and lead to noncompliance with 2 CFR 200 Subpart F, which in turn could result in a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2025 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 19, 2025 (Final copy of the SEFA will not be given to the auditors until requested for the Audit).Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct.
2024-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDSFederal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All awards presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None Statement of Condition During our audit, we reviewed the Coalition’s federal-grants report for the fiscal year and identified the grants, Assistance-Listing numbers (AL #s), expenditure amounts, and all other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). Finance staff subsequently confirmed the SEFA; however, additional federal expenditures and mis-grouped grant costs were found during later reviews. Criteria2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, errors in SEFA preparation could affect the major federal program determination and lead to noncompliance with 2 CFR 200 Subpart F, which in turn could result in a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2025 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 19, 2025 (Final copy of the SEFA will not be given to the auditors until requested for the Audit).Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct.
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.
SCHEDULE OF FINDINGS AND QUESTIONED COSTS AND CORRECTIVE ACTION PLAN Federal Award Finding September 30, 2024 Comment #2024-002 Repeat Comment #2023-001 AND #2022-001 INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED LIHEAP FALN 93.568 (Questioned Costs - Undetermined) Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards states in summary, that management should authorize, process, reconcile and close-out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The close-out process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff does not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to properly present the financial statements and disclosures of the Council as of September 30, 2024. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, reports to various funding sources, etc.) Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner. The systemic cause appears to be the untimely termination of key personnel and a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR §200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §200.328 Financial reporting and 200.329 Monitoring and reporting program performance [2 CFR §200.302(b)(2)]. SCHEDULE OF FINDINGS AND QUESTIONED COSTS AND CORRECTIVE ACTION PLAN Federal Award Finding September 30, 2024 Comment #2024-002 Repeat Comment #2023-001 AND #2022-001 INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED LIHEAP FALN 93.568 (Questioned Costs - Undetermined) (Continued) Effect: Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff and limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency is determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Council has hired a new fiscal officer and should hire additional staff (grant accountant and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. The Board of Directors should be adequately trained in the areas of understanding risk assessment and financial awareness in the community action industry. A finance and audit committee should be established and trained in understanding and oversight of financial reporting responsibilities of community action associations. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant’s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statements close-out process is achieved each month and annually. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the Council’s financial funding sources, the Council will provide additional training to support the new fiscal officer. The fiscal officer will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst’s basic responsibilities. All enhancements will be implemented by July 31, 2025.
Finding 2024-002: Submission of the Audit Reporting Package and Data Collection Form Federal Agency: Various Assistance Listing Number: Multiple Compliance Requirement: Reporting Criteria: Per 2 CFR § 200.510(b), the auditee must prepare a Schedule of Expenditures 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 Clearing House (FAC) within the required deadline. 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 Management concurs with the finding. The Council recognizes the importance of timely submission of the SEFA and related audit documentation to maintain compliance with federal requirements. To address this issue, the Council has engaged an outside provider to assist with process improvements that will streamline financial reporting and ensure timely preparation and submission of all required audit materials. These enhancements will strengthen internal controls and support continued compliance in future reporting periods.
Finding 2024-010 U.S. Department of Education Higher Education Emergency Relief Fund (HEERF) 84.425E/84.425F Requirements: Reporting Condition: During our audit of the Schedule of Expenditures of Federal Awards (“SEFA”) for the year ended August 31, 2024, we noted that the amount reported by the College for the HEERF grant on the SEFA did not agree with the cumulative expenditures reported in the Federal CARES Reporting Portal. Criteria: Per 2 CFR § 200.510(b), the SEFA must be complete and accurate, and per HEERF grant terms and conditions, institutions are required to accurately report grant expenditures in both the SEFA and the CARES Act Reporting Portal. Cause: The discrepancy appears to be the result of a lack of reconciliation procedures between the general ledger, the SEFA, and the Federal Reporting Portal submissions. Effect: The inconsistency may result in inaccurate financial reporting and a risk of noncompliance with federal reporting requirements, which could impact future funding or trigger additional oversight. Repeat Finding: Not a repeat finding Recommendation: We recommend that management implement formal reconciliation procedures to ensure that amounts reported in the SEFA align with those reported in the Federal CARES Portal. The reconciliation should be documented and reviewed by a responsible official prior to finalizing federal reporting submissions. Perspective: This issue only impacts reporting for the HEERF program. Management’s Response: See corrective action plan.
Finding 2024-003: Reportable finding considered a significant deficiency - Inaccurate and Incomplete Schedule of Expenditures of Federal Awards (SEFA) Program name: Child and Adult Care Food Program Assistance Listing: 10.558 Federal awarding agency: U.S. Department of Agriculture (USDA) Pass-through Entity: Maryland State Department of Education, District of Columbia Education Office Criteria: In accordance with 2 CFR 200.510(b), the auditee must prepare a complete and accurate Schedule of Expenditures of Federal Awards (SEFA) that includes the total federal awards expended for each federal program, the assistance listing number (ALN), the name of the federal agency, and the pass-through entity identifying number. Accurate SEFA reporting is essential to support the auditor’s responsibility under 2 CFR 200.518 major program determination and for federal oversight. Condition: The Organization failed to include two federal pass-through awards received from state and local governmental entities in prior years’ SEFAs. These awards were only identified as federal during the current audit year. Furthermore, when the awards were initially included in the current year’s SEFA, they were incorrectly classified under ALN 10.555 (National School Lunch Program). After additional inquiry and evaluation, they were determined to fall under ALN 10.558 (Child and Adult Care Food Program). The Organization was unable to locate specific subaward agreements; only a master service agreement from the state government was available. Cause: There were deficiencies in the Organization’s internal controls over SEFA preparation, specifically in identifying, classifying, and documenting pass-through federal awards. The absence of award documentation and misclassification of the assistance listing number further indicate inadequate review and verification procedures. Effect: Incomplete and inaccurate SEFA reporting may lead to noncompliance with Uniform Guidance requirements and increases the risk of omitted or misclassified programs subject to audit. Misreporting ALNs may also hinder proper audit coverage and oversight by federal and pass-through entities. Repeat finding: This is not a repeat finding. Questioned costs: There are no questioned costs associated with this finding. Perspective: This issue affected two federal awards and represents a systemic control issue over SEFA preparation. There is a reasonable possibility that similar issues could recur if not addressed. Recommendation: We recommend that the Organization: • Implement procedures to require written documentation (e.g., subaward agreements) for all federal pass-through funding received. • Enhance internal controls over the SEFA preparation process to ensure federal programs are accurately identified, classified, and reported, including verification of ALNs and funding sources. • Designate responsibility within the finance team for verifying the federal nature of all awards and ensure ongoing training on SEFA and Uniform Guidance requirements. Management’s response and corrective action plan (unaudited): See corrective action plan.
Finding 2024-003: Reportable finding considered a significant deficiency - Inaccurate and Incomplete Schedule of Expenditures of Federal Awards (SEFA) Program name: Child and Adult Care Food Program Assistance Listing: 10.558 Federal awarding agency: U.S. Department of Agriculture (USDA) Pass-through Entity: Maryland State Department of Education, District of Columbia Education Office Criteria: In accordance with 2 CFR 200.510(b), the auditee must prepare a complete and accurate Schedule of Expenditures of Federal Awards (SEFA) that includes the total federal awards expended for each federal program, the assistance listing number (ALN), the name of the federal agency, and the pass-through entity identifying number. Accurate SEFA reporting is essential to support the auditor’s responsibility under 2 CFR 200.518 major program determination and for federal oversight. Condition: The Organization failed to include two federal pass-through awards received from state and local governmental entities in prior years’ SEFAs. These awards were only identified as federal during the current audit year. Furthermore, when the awards were initially included in the current year’s SEFA, they were incorrectly classified under ALN 10.555 (National School Lunch Program). After additional inquiry and evaluation, they were determined to fall under ALN 10.558 (Child and Adult Care Food Program). The Organization was unable to locate specific subaward agreements; only a master service agreement from the state government was available. Cause: There were deficiencies in the Organization’s internal controls over SEFA preparation, specifically in identifying, classifying, and documenting pass-through federal awards. The absence of award documentation and misclassification of the assistance listing number further indicate inadequate review and verification procedures. Effect: Incomplete and inaccurate SEFA reporting may lead to noncompliance with Uniform Guidance requirements and increases the risk of omitted or misclassified programs subject to audit. Misreporting ALNs may also hinder proper audit coverage and oversight by federal and pass-through entities. Repeat finding: This is not a repeat finding. Questioned costs: There are no questioned costs associated with this finding. Perspective: This issue affected two federal awards and represents a systemic control issue over SEFA preparation. There is a reasonable possibility that similar issues could recur if not addressed. Recommendation: We recommend that the Organization: • Implement procedures to require written documentation (e.g., subaward agreements) for all federal pass-through funding received. • Enhance internal controls over the SEFA preparation process to ensure federal programs are accurately identified, classified, and reported, including verification of ALNs and funding sources. • Designate responsibility within the finance team for verifying the federal nature of all awards and ensure ongoing training on SEFA and Uniform Guidance requirements. Management’s response and corrective action plan (unaudited): See corrective action plan.
Finding 2024-010 U.S. Department of Education Higher Education Emergency Relief Fund (HEERF) 84.425E/84.425F Requirements: Reporting Condition: During our audit of the Schedule of Expenditures of Federal Awards (“SEFA”) for the year ended August 31, 2024, we noted that the amount reported by the College for the HEERF grant on the SEFA did not agree with the cumulative expenditures reported in the Federal CARES Reporting Portal. Criteria: Per 2 CFR § 200.510(b), the SEFA must be complete and accurate, and per HEERF grant terms and conditions, institutions are required to accurately report grant expenditures in both the SEFA and the CARES Act Reporting Portal. Cause: The discrepancy appears to be the result of a lack of reconciliation procedures between the general ledger, the SEFA, and the Federal Reporting Portal submissions. Effect: The inconsistency may result in inaccurate financial reporting and a risk of noncompliance with federal reporting requirements, which could impact future funding or trigger additional oversight. Repeat Finding: Not a repeat finding Recommendation: We recommend that management implement formal reconciliation procedures to ensure that amounts reported in the SEFA align with those reported in the Federal CARES Portal. The reconciliation should be documented and reviewed by a responsible official prior to finalizing federal reporting submissions. Perspective: This issue only impacts reporting for the HEERF program. Management’s Response: See corrective action plan.
Finding 2024-003: Reportable finding considered a significant deficiency - Inaccurate and Incomplete Schedule of Expenditures of Federal Awards (SEFA) Program name: Child and Adult Care Food Program Assistance Listing: 10.558 Federal awarding agency: U.S. Department of Agriculture (USDA) Pass-through Entity: Maryland State Department of Education, District of Columbia Education Office Criteria: In accordance with 2 CFR 200.510(b), the auditee must prepare a complete and accurate Schedule of Expenditures of Federal Awards (SEFA) that includes the total federal awards expended for each federal program, the assistance listing number (ALN), the name of the federal agency, and the pass-through entity identifying number. Accurate SEFA reporting is essential to support the auditor’s responsibility under 2 CFR 200.518 major program determination and for federal oversight. Condition: The Organization failed to include two federal pass-through awards received from state and local governmental entities in prior years’ SEFAs. These awards were only identified as federal during the current audit year. Furthermore, when the awards were initially included in the current year’s SEFA, they were incorrectly classified under ALN 10.555 (National School Lunch Program). After additional inquiry and evaluation, they were determined to fall under ALN 10.558 (Child and Adult Care Food Program). The Organization was unable to locate specific subaward agreements; only a master service agreement from the state government was available. Cause: There were deficiencies in the Organization’s internal controls over SEFA preparation, specifically in identifying, classifying, and documenting pass-through federal awards. The absence of award documentation and misclassification of the assistance listing number further indicate inadequate review and verification procedures. Effect: Incomplete and inaccurate SEFA reporting may lead to noncompliance with Uniform Guidance requirements and increases the risk of omitted or misclassified programs subject to audit. Misreporting ALNs may also hinder proper audit coverage and oversight by federal and pass-through entities. Repeat finding: This is not a repeat finding. Questioned costs: There are no questioned costs associated with this finding. Perspective: This issue affected two federal awards and represents a systemic control issue over SEFA preparation. There is a reasonable possibility that similar issues could recur if not addressed. Recommendation: We recommend that the Organization: • Implement procedures to require written documentation (e.g., subaward agreements) for all federal pass-through funding received. • Enhance internal controls over the SEFA preparation process to ensure federal programs are accurately identified, classified, and reported, including verification of ALNs and funding sources. • Designate responsibility within the finance team for verifying the federal nature of all awards and ensure ongoing training on SEFA and Uniform Guidance requirements. Management’s response and corrective action plan (unaudited): See corrective action plan.
Finding 2024-003: Reportable finding considered a significant deficiency - Inaccurate and Incomplete Schedule of Expenditures of Federal Awards (SEFA) Program name: Child and Adult Care Food Program Assistance Listing: 10.558 Federal awarding agency: U.S. Department of Agriculture (USDA) Pass-through Entity: Maryland State Department of Education, District of Columbia Education Office Criteria: In accordance with 2 CFR 200.510(b), the auditee must prepare a complete and accurate Schedule of Expenditures of Federal Awards (SEFA) that includes the total federal awards expended for each federal program, the assistance listing number (ALN), the name of the federal agency, and the pass-through entity identifying number. Accurate SEFA reporting is essential to support the auditor’s responsibility under 2 CFR 200.518 major program determination and for federal oversight. Condition: The Organization failed to include two federal pass-through awards received from state and local governmental entities in prior years’ SEFAs. These awards were only identified as federal during the current audit year. Furthermore, when the awards were initially included in the current year’s SEFA, they were incorrectly classified under ALN 10.555 (National School Lunch Program). After additional inquiry and evaluation, they were determined to fall under ALN 10.558 (Child and Adult Care Food Program). The Organization was unable to locate specific subaward agreements; only a master service agreement from the state government was available. Cause: There were deficiencies in the Organization’s internal controls over SEFA preparation, specifically in identifying, classifying, and documenting pass-through federal awards. The absence of award documentation and misclassification of the assistance listing number further indicate inadequate review and verification procedures. Effect: Incomplete and inaccurate SEFA reporting may lead to noncompliance with Uniform Guidance requirements and increases the risk of omitted or misclassified programs subject to audit. Misreporting ALNs may also hinder proper audit coverage and oversight by federal and pass-through entities. Repeat finding: This is not a repeat finding. Questioned costs: There are no questioned costs associated with this finding. Perspective: This issue affected two federal awards and represents a systemic control issue over SEFA preparation. There is a reasonable possibility that similar issues could recur if not addressed. Recommendation: We recommend that the Organization: • Implement procedures to require written documentation (e.g., subaward agreements) for all federal pass-through funding received. • Enhance internal controls over the SEFA preparation process to ensure federal programs are accurately identified, classified, and reported, including verification of ALNs and funding sources. • Designate responsibility within the finance team for verifying the federal nature of all awards and ensure ongoing training on SEFA and Uniform Guidance requirements. Management’s response and corrective action plan (unaudited): See corrective action plan.
SCHEDULE OF FINDINGS AND QUESTIONED COSTS Federal Award Findings and Questioned Costs July 31, 2024 Comment # 2024-002 INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION, GRANT CLOSE OUT AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED HEAD START AND EARLY HEAD START, LIHEAP, LIHWAP, CSBG, ASTHO, CACFP and CSLFRF FAL # 93.600, 93.568, 93.499, 93.569, 93.185, 10.558, 21.027 (Questioned Costs - Undetermined) Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards states in summary that management should authorize, process, reconcile and close-out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The closeout process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff does not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to present the financial statements and disclosures of the Agency as of July 31, 2024. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.). Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e. SF-425, DHS’s reports for LIHEAP, etc.). Accordingly, the Agency is not in compliance with federal and state reporting as specified by grants and contracts and the Federal Audit Clearinghouse. The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR §200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §200.328 Financial reporting and §200.329. (Continued) Effect: Monitoring and reporting program performance [2 CFR §200.302(b)(2)]. Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency as determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountant and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant’s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statements close-out process is achieved each month and annually. Accounting policies and procedures must be updated and implemented. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the Agency’s financial funding sources, the Agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst’s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and Uniform Guidance regulations. The new automated financial systems, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2025.
SCHEDULE OF FINDINGS AND QUESTIONED COSTS Federal Award Findings and Questioned Costs July 31, 2024 Comment # 2024-002 INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION, GRANT CLOSE OUT AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED HEAD START AND EARLY HEAD START, LIHEAP, LIHWAP, CSBG, ASTHO, CACFP and CSLFRF FAL # 93.600, 93.568, 93.499, 93.569, 93.185, 10.558, 21.027 (Questioned Costs - Undetermined) Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards states in summary that management should authorize, process, reconcile and close-out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The closeout process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff does not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to present the financial statements and disclosures of the Agency as of July 31, 2024. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.). Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e. SF-425, DHS’s reports for LIHEAP, etc.). Accordingly, the Agency is not in compliance with federal and state reporting as specified by grants and contracts and the Federal Audit Clearinghouse. The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR §200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §200.328 Financial reporting and §200.329. (Continued) Effect: Monitoring and reporting program performance [2 CFR §200.302(b)(2)]. Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency as determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountant and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant’s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statements close-out process is achieved each month and annually. Accounting policies and procedures must be updated and implemented. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the Agency’s financial funding sources, the Agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst’s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and Uniform Guidance regulations. The new automated financial systems, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2025.
SCHEDULE OF FINDINGS AND QUESTIONED COSTS Federal Award Findings and Questioned Costs July 31, 2024 Comment # 2024-002 INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION, GRANT CLOSE OUT AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED HEAD START AND EARLY HEAD START, LIHEAP, LIHWAP, CSBG, ASTHO, CACFP and CSLFRF FAL # 93.600, 93.568, 93.499, 93.569, 93.185, 10.558, 21.027 (Questioned Costs - Undetermined) Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards states in summary that management should authorize, process, reconcile and close-out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The closeout process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff does not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to present the financial statements and disclosures of the Agency as of July 31, 2024. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.). Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e. SF-425, DHS’s reports for LIHEAP, etc.). Accordingly, the Agency is not in compliance with federal and state reporting as specified by grants and contracts and the Federal Audit Clearinghouse. The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR §200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §200.328 Financial reporting and §200.329. (Continued) Effect: Monitoring and reporting program performance [2 CFR §200.302(b)(2)]. Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency as determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountant and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant’s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statements close-out process is achieved each month and annually. Accounting policies and procedures must be updated and implemented. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the Agency’s financial funding sources, the Agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst’s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and Uniform Guidance regulations. The new automated financial systems, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2025.
SCHEDULE OF FINDINGS AND QUESTIONED COSTS Federal Award Findings and Questioned Costs July 31, 2024 Comment # 2024-002 INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION, GRANT CLOSE OUT AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED HEAD START AND EARLY HEAD START, LIHEAP, LIHWAP, CSBG, ASTHO, CACFP and CSLFRF FAL # 93.600, 93.568, 93.499, 93.569, 93.185, 10.558, 21.027 (Questioned Costs - Undetermined) Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards states in summary that management should authorize, process, reconcile and close-out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The closeout process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff does not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to present the financial statements and disclosures of the Agency as of July 31, 2024. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.). Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e. SF-425, DHS’s reports for LIHEAP, etc.). Accordingly, the Agency is not in compliance with federal and state reporting as specified by grants and contracts and the Federal Audit Clearinghouse. The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR §200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §200.328 Financial reporting and §200.329. (Continued) Effect: Monitoring and reporting program performance [2 CFR §200.302(b)(2)]. Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency as determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountant and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant’s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statements close-out process is achieved each month and annually. Accounting policies and procedures must be updated and implemented. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the Agency’s financial funding sources, the Agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst’s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and Uniform Guidance regulations. The new automated financial systems, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2025.
SCHEDULE OF FINDINGS AND QUESTIONED COSTS Federal Award Findings and Questioned Costs July 31, 2024 Comment # 2024-002 INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION, GRANT CLOSE OUT AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED HEAD START AND EARLY HEAD START, LIHEAP, LIHWAP, CSBG, ASTHO, CACFP and CSLFRF FAL # 93.600, 93.568, 93.499, 93.569, 93.185, 10.558, 21.027 (Questioned Costs - Undetermined) Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards states in summary that management should authorize, process, reconcile and close-out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The closeout process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff does not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to present the financial statements and disclosures of the Agency as of July 31, 2024. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.). Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e. SF-425, DHS’s reports for LIHEAP, etc.). Accordingly, the Agency is not in compliance with federal and state reporting as specified by grants and contracts and the Federal Audit Clearinghouse. The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR §200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §200.328 Financial reporting and §200.329. (Continued) Effect: Monitoring and reporting program performance [2 CFR §200.302(b)(2)]. Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency as determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountant and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant’s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statements close-out process is achieved each month and annually. Accounting policies and procedures must be updated and implemented. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the Agency’s financial funding sources, the Agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst’s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and Uniform Guidance regulations. The new automated financial systems, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2025.
SCHEDULE OF FINDINGS AND QUESTIONED COSTS Federal Award Findings and Questioned Costs July 31, 2024 Comment # 2024-002 INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION, GRANT CLOSE OUT AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED HEAD START AND EARLY HEAD START, LIHEAP, LIHWAP, CSBG, ASTHO, CACFP and CSLFRF FAL # 93.600, 93.568, 93.499, 93.569, 93.185, 10.558, 21.027 (Questioned Costs - Undetermined) Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards states in summary that management should authorize, process, reconcile and close-out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The closeout process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff does not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to present the financial statements and disclosures of the Agency as of July 31, 2024. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.). Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e. SF-425, DHS’s reports for LIHEAP, etc.). Accordingly, the Agency is not in compliance with federal and state reporting as specified by grants and contracts and the Federal Audit Clearinghouse. The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR §200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §200.328 Financial reporting and §200.329. (Continued) Effect: Monitoring and reporting program performance [2 CFR §200.302(b)(2)]. Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency as determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountant and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant’s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statements close-out process is achieved each month and annually. Accounting policies and procedures must be updated and implemented. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the Agency’s financial funding sources, the Agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst’s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and Uniform Guidance regulations. The new automated financial systems, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2025.