Finding 2024-003: SEFA Preparation— Subrecipient vs. Subcontractor Determinations Federal Program(s): • Adv HIV & AIDS Epidemic Control (AHEC) Activity - ALN 98.U01 • ASAP & ASAP II – ALN 98.U02 • Zambia Local – ALN 98.U03 Criteria: The auditee must prepare the financial statements, including the schedule of expenditures of federal awards (SEFA) in accordance with 2 CFR 200.510 (2 CFR 200.508 (b)). The SEFA must include the total amount provided to subrecipients from each Federal program (2 CFR 200.510 (b)(4)). Condition: Subcontractor amounts were improperly included in the Amounts Provided to Subrecipients column on the SEFA. Cause: Ineffective design and implementation of internal controls around SEFA preparation. Effect: There were approximately $2.6 million in subcontractor expenses incurred by IntraHealth that were improperly included in the Amounts to Subrecipients column on the SEFA as they did not represent payments to subrecipients. Questioned costs: None Context: Management made improper subrecipient vs. subcontractor determinations, resulting in inaccurate SEFA preparation. This resulted in $2.6 million being removed from the Amounts Provided to Subrecipients column in the original SEFA provided to the auditors by management. Repeat finding: No Recommendation: We recommend that management review internal controls in place around the SEFA preparation and ensure an independent review is being performed around amounts reported as Amounts to Subrecipients against 2 CFR 200.331, Subrecipient and subcontractor determinations. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Finding 2024-003: SEFA Preparation— Subrecipient vs. Subcontractor Determinations Federal Program(s): • Adv HIV & AIDS Epidemic Control (AHEC) Activity - ALN 98.U01 • ASAP & ASAP II – ALN 98.U02 • Zambia Local – ALN 98.U03 Criteria: The auditee must prepare the financial statements, including the schedule of expenditures of federal awards (SEFA) in accordance with 2 CFR 200.510 (2 CFR 200.508 (b)). The SEFA must include the total amount provided to subrecipients from each Federal program (2 CFR 200.510 (b)(4)). Condition: Subcontractor amounts were improperly included in the Amounts Provided to Subrecipients column on the SEFA. Cause: Ineffective design and implementation of internal controls around SEFA preparation. Effect: There were approximately $2.6 million in subcontractor expenses incurred by IntraHealth that were improperly included in the Amounts to Subrecipients column on the SEFA as they did not represent payments to subrecipients. Questioned costs: None Context: Management made improper subrecipient vs. subcontractor determinations, resulting in inaccurate SEFA preparation. This resulted in $2.6 million being removed from the Amounts Provided to Subrecipients column in the original SEFA provided to the auditors by management. Repeat finding: No Recommendation: We recommend that management review internal controls in place around the SEFA preparation and ensure an independent review is being performed around amounts reported as Amounts to Subrecipients against 2 CFR 200.331, Subrecipient and subcontractor determinations. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Finding 2024-003: SEFA Preparation— Subrecipient vs. Subcontractor Determinations Federal Program(s): • Adv HIV & AIDS Epidemic Control (AHEC) Activity - ALN 98.U01 • ASAP & ASAP II – ALN 98.U02 • Zambia Local – ALN 98.U03 Criteria: The auditee must prepare the financial statements, including the schedule of expenditures of federal awards (SEFA) in accordance with 2 CFR 200.510 (2 CFR 200.508 (b)). The SEFA must include the total amount provided to subrecipients from each Federal program (2 CFR 200.510 (b)(4)). Condition: Subcontractor amounts were improperly included in the Amounts Provided to Subrecipients column on the SEFA. Cause: Ineffective design and implementation of internal controls around SEFA preparation. Effect: There were approximately $2.6 million in subcontractor expenses incurred by IntraHealth that were improperly included in the Amounts to Subrecipients column on the SEFA as they did not represent payments to subrecipients. Questioned costs: None Context: Management made improper subrecipient vs. subcontractor determinations, resulting in inaccurate SEFA preparation. This resulted in $2.6 million being removed from the Amounts Provided to Subrecipients column in the original SEFA provided to the auditors by management. Repeat finding: No Recommendation: We recommend that management review internal controls in place around the SEFA preparation and ensure an independent review is being performed around amounts reported as Amounts to Subrecipients against 2 CFR 200.331, Subrecipient and subcontractor determinations. Views of responsible officials: Management agrees with the finding. See corrective action plan.
Finding 2024-001 U.S. Department of the Treasury Community Development Financial Institutions Fund Equitable Recovery Program (CDFI ERP) Assistance Listing No. 21.033 Criteria – 2 CFR 200.510(b) of the Uniform Guidance states that the auditee is responsible for preparing the Schedule of Expenditures of Federal Awards (SEFA). 2 CFR 200.302(b) of the Uniform Guidance states that a nonfederal entity must identify in its accounts all federal awards received and expended, as well as the federal programs under which they were received, and those amounts must be accurately and completely reported on the SEFA. Condition – The Organization consists of Hawaiian Community Assets, Inc. (HCA) and its subsidiary Hawaii Community Lending, Inc. (HCL). The CDFI ERP program is managed by HCL. During the year ended September 30, 2024, HCL used the CDFI ERP grant award amount of $500,000 to fund seven loans. Subsequent to the fiscal year end, but prior to the audit, HCL determined the borrower for five of the seven loans, totaling approximately $299,882, did not meet the geographical eligibility requirements. HCL was able to identify other non-federal funding to fund the five loans deemed ineligible and made the necessary corrections in its grant reporting to the federal agency. However, HCL did not make corrections to its accounting records and SEFA. Cause – HCL did not have a process in place to ensure the accurate reporting of its federal expenditures in its SEFA. Effect or Potential Effect – Federal expenditures are over/under reported or in the wrong fiscal period. A federal program may be misidentified as a major or non-major program and thus, may be improperly included or excluded from required audit procedures. Questioned Costs – None. Context – Total federal expenditures in the SEFA were reduced from $7,459,199 to $7,159,317. CDFI ERP expenditures were reduced from $500,000 to $200,118. The CDFI ERP grant award period does not end until September 30, 2028 and HCL has $299,882 remaining in CDFI ERP funding to fund future loans to borrowers who meet the eligibility requirements. Recommendation – HCL should implement procedures to ensure accurate reporting of its federal expenditures in its SEFA, including having an appropriate member of management review the SEFA. Responsible Official’s Response and Corrective Action Planned – Refer to the Corrective Action Plan.
2024-003 ─ Schedule of Expenditures of Federal Awards and State Financial Assistance (Schedule) U.S. Department of Transportation – Federal Transit Cluster (ALN No. 20.507) Federal award year 2023 Criteria: In accordance with 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. 2 CFR Section 200.502(a) states that 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 grant awards. Condition: We noted that the Schedule of Expenditures of Federal Awards and State Financial Assistance (Schedule) provided to the auditors for the fiscal year ended September 30, 2024 included $56,503,870 of federal expenditures for the Federal Transit Cluster, assistance listing number 20.507, that should have been included in the Schedule for the fiscal year ended September 30, 2023. The County executed an ARPA transportation grant in September 2023 for which prior year eligible incurred costs were applied, however, these expenditures were not reported on the County’s Schedule until FY 2024. The Schedule for fiscal year ended September 30, 2023 was reissued to include the $56,503,870 and the expenditures were removed from the Schedule for the fiscal year ended September 30, 2024. Context: The finding is considered isolated in nature to the federal program in question. Effect: Improper reporting of federal expenditures resulted in a material error on the Schedule. Identification as a repeat finding, if applicable: Yes (2023-006) Cause: The department directly administering this grant did not realize they had to immediately recognize the expenditures associated with the grant at the time of grant award when the decision was made to apply prior eligible incurred costs. The transaction was not recorded until the reimbursement request was submitted in fiscal year 2024. Recommendation: Grant activities including general ledger activity should be reconciled by the departments managing the programs and the information communicated timely to the Office of Financial Management and Budget (OFMB). Depending on the nature and size of the grant programs these reconciliations could occur, monthly, quarterly or yearly, depending on what is most efficient in each individual situation. Also additional training could be provided to help enhance the understanding of grant personnel around some of the important nuances of revenue and expenditure recognition criteria the County must comply with in accordance with generally accepted accounting principles so they provide OFMB with sufficient information to prepare the end of year Schedule or so they can ask questions of OFMB and County Finance and seek assistance for any matters they are unsure of how to process.
2024-003 ─ Schedule of Expenditures of Federal Awards and State Financial Assistance (Schedule) U.S. Department of Transportation – Federal Transit Cluster (ALN No. 20.507) Federal award year 2023 Criteria: In accordance with 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. 2 CFR Section 200.502(a) states that 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 grant awards. Condition: We noted that the Schedule of Expenditures of Federal Awards and State Financial Assistance (Schedule) provided to the auditors for the fiscal year ended September 30, 2024 included $56,503,870 of federal expenditures for the Federal Transit Cluster, assistance listing number 20.507, that should have been included in the Schedule for the fiscal year ended September 30, 2023. The County executed an ARPA transportation grant in September 2023 for which prior year eligible incurred costs were applied, however, these expenditures were not reported on the County’s Schedule until FY 2024. The Schedule for fiscal year ended September 30, 2023 was reissued to include the $56,503,870 and the expenditures were removed from the Schedule for the fiscal year ended September 30, 2024. Context: The finding is considered isolated in nature to the federal program in question. Effect: Improper reporting of federal expenditures resulted in a material error on the Schedule. Identification as a repeat finding, if applicable: Yes (2023-006) Cause: The department directly administering this grant did not realize they had to immediately recognize the expenditures associated with the grant at the time of grant award when the decision was made to apply prior eligible incurred costs. The transaction was not recorded until the reimbursement request was submitted in fiscal year 2024. Recommendation: Grant activities including general ledger activity should be reconciled by the departments managing the programs and the information communicated timely to the Office of Financial Management and Budget (OFMB). Depending on the nature and size of the grant programs these reconciliations could occur, monthly, quarterly or yearly, depending on what is most efficient in each individual situation. Also additional training could be provided to help enhance the understanding of grant personnel around some of the important nuances of revenue and expenditure recognition criteria the County must comply with in accordance with generally accepted accounting principles so they provide OFMB with sufficient information to prepare the end of year Schedule or so they can ask questions of OFMB and County Finance and seek assistance for any matters they are unsure of how to process.
2024-003 ─ Schedule of Expenditures of Federal Awards and State Financial Assistance (Schedule) U.S. Department of Transportation – Federal Transit Cluster (ALN No. 20.507) Federal award year 2023 Criteria: In accordance with 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. 2 CFR Section 200.502(a) states that 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 grant awards. Condition: We noted that the Schedule of Expenditures of Federal Awards and State Financial Assistance (Schedule) provided to the auditors for the fiscal year ended September 30, 2024 included $56,503,870 of federal expenditures for the Federal Transit Cluster, assistance listing number 20.507, that should have been included in the Schedule for the fiscal year ended September 30, 2023. The County executed an ARPA transportation grant in September 2023 for which prior year eligible incurred costs were applied, however, these expenditures were not reported on the County’s Schedule until FY 2024. The Schedule for fiscal year ended September 30, 2023 was reissued to include the $56,503,870 and the expenditures were removed from the Schedule for the fiscal year ended September 30, 2024. Context: The finding is considered isolated in nature to the federal program in question. Effect: Improper reporting of federal expenditures resulted in a material error on the Schedule. Identification as a repeat finding, if applicable: Yes (2023-006) Cause: The department directly administering this grant did not realize they had to immediately recognize the expenditures associated with the grant at the time of grant award when the decision was made to apply prior eligible incurred costs. The transaction was not recorded until the reimbursement request was submitted in fiscal year 2024. Recommendation: Grant activities including general ledger activity should be reconciled by the departments managing the programs and the information communicated timely to the Office of Financial Management and Budget (OFMB). Depending on the nature and size of the grant programs these reconciliations could occur, monthly, quarterly or yearly, depending on what is most efficient in each individual situation. Also additional training could be provided to help enhance the understanding of grant personnel around some of the important nuances of revenue and expenditure recognition criteria the County must comply with in accordance with generally accepted accounting principles so they provide OFMB with sufficient information to prepare the end of year Schedule or so they can ask questions of OFMB and County Finance and seek assistance for any matters they are unsure of how to process.
2024-003 ─ Schedule of Expenditures of Federal Awards and State Financial Assistance (Schedule) U.S. Department of Transportation – Federal Transit Cluster (ALN No. 20.507) Federal award year 2023 Criteria: In accordance with 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. 2 CFR Section 200.502(a) states that 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 grant awards. Condition: We noted that the Schedule of Expenditures of Federal Awards and State Financial Assistance (Schedule) provided to the auditors for the fiscal year ended September 30, 2024 included $56,503,870 of federal expenditures for the Federal Transit Cluster, assistance listing number 20.507, that should have been included in the Schedule for the fiscal year ended September 30, 2023. The County executed an ARPA transportation grant in September 2023 for which prior year eligible incurred costs were applied, however, these expenditures were not reported on the County’s Schedule until FY 2024. The Schedule for fiscal year ended September 30, 2023 was reissued to include the $56,503,870 and the expenditures were removed from the Schedule for the fiscal year ended September 30, 2024. Context: The finding is considered isolated in nature to the federal program in question. Effect: Improper reporting of federal expenditures resulted in a material error on the Schedule. Identification as a repeat finding, if applicable: Yes (2023-006) Cause: The department directly administering this grant did not realize they had to immediately recognize the expenditures associated with the grant at the time of grant award when the decision was made to apply prior eligible incurred costs. The transaction was not recorded until the reimbursement request was submitted in fiscal year 2024. Recommendation: Grant activities including general ledger activity should be reconciled by the departments managing the programs and the information communicated timely to the Office of Financial Management and Budget (OFMB). Depending on the nature and size of the grant programs these reconciliations could occur, monthly, quarterly or yearly, depending on what is most efficient in each individual situation. Also additional training could be provided to help enhance the understanding of grant personnel around some of the important nuances of revenue and expenditure recognition criteria the County must comply with in accordance with generally accepted accounting principles so they provide OFMB with sufficient information to prepare the end of year Schedule or so they can ask questions of OFMB and County Finance and seek assistance for any matters they are unsure of how to process.
2024-003 ─ Schedule of Expenditures of Federal Awards and State Financial Assistance (Schedule) U.S. Department of Transportation – Federal Transit Cluster (ALN No. 20.507) Federal award year 2023 Criteria: In accordance with 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. 2 CFR Section 200.502(a) states that 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 grant awards. Condition: We noted that the Schedule of Expenditures of Federal Awards and State Financial Assistance (Schedule) provided to the auditors for the fiscal year ended September 30, 2024 included $56,503,870 of federal expenditures for the Federal Transit Cluster, assistance listing number 20.507, that should have been included in the Schedule for the fiscal year ended September 30, 2023. The County executed an ARPA transportation grant in September 2023 for which prior year eligible incurred costs were applied, however, these expenditures were not reported on the County’s Schedule until FY 2024. The Schedule for fiscal year ended September 30, 2023 was reissued to include the $56,503,870 and the expenditures were removed from the Schedule for the fiscal year ended September 30, 2024. Context: The finding is considered isolated in nature to the federal program in question. Effect: Improper reporting of federal expenditures resulted in a material error on the Schedule. Identification as a repeat finding, if applicable: Yes (2023-006) Cause: The department directly administering this grant did not realize they had to immediately recognize the expenditures associated with the grant at the time of grant award when the decision was made to apply prior eligible incurred costs. The transaction was not recorded until the reimbursement request was submitted in fiscal year 2024. Recommendation: Grant activities including general ledger activity should be reconciled by the departments managing the programs and the information communicated timely to the Office of Financial Management and Budget (OFMB). Depending on the nature and size of the grant programs these reconciliations could occur, monthly, quarterly or yearly, depending on what is most efficient in each individual situation. Also additional training could be provided to help enhance the understanding of grant personnel around some of the important nuances of revenue and expenditure recognition criteria the County must comply with in accordance with generally accepted accounting principles so they provide OFMB with sufficient information to prepare the end of year Schedule or so they can ask questions of OFMB and County Finance and seek assistance for any matters they are unsure of how to process.
2024-003 ─ Schedule of Expenditures of Federal Awards and State Financial Assistance (Schedule) U.S. Department of Transportation – Federal Transit Cluster (ALN No. 20.507) Federal award year 2023 Criteria: In accordance with 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. 2 CFR Section 200.502(a) states that 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 grant awards. Condition: We noted that the Schedule of Expenditures of Federal Awards and State Financial Assistance (Schedule) provided to the auditors for the fiscal year ended September 30, 2024 included $56,503,870 of federal expenditures for the Federal Transit Cluster, assistance listing number 20.507, that should have been included in the Schedule for the fiscal year ended September 30, 2023. The County executed an ARPA transportation grant in September 2023 for which prior year eligible incurred costs were applied, however, these expenditures were not reported on the County’s Schedule until FY 2024. The Schedule for fiscal year ended September 30, 2023 was reissued to include the $56,503,870 and the expenditures were removed from the Schedule for the fiscal year ended September 30, 2024. Context: The finding is considered isolated in nature to the federal program in question. Effect: Improper reporting of federal expenditures resulted in a material error on the Schedule. Identification as a repeat finding, if applicable: Yes (2023-006) Cause: The department directly administering this grant did not realize they had to immediately recognize the expenditures associated with the grant at the time of grant award when the decision was made to apply prior eligible incurred costs. The transaction was not recorded until the reimbursement request was submitted in fiscal year 2024. Recommendation: Grant activities including general ledger activity should be reconciled by the departments managing the programs and the information communicated timely to the Office of Financial Management and Budget (OFMB). Depending on the nature and size of the grant programs these reconciliations could occur, monthly, quarterly or yearly, depending on what is most efficient in each individual situation. Also additional training could be provided to help enhance the understanding of grant personnel around some of the important nuances of revenue and expenditure recognition criteria the County must comply with in accordance with generally accepted accounting principles so they provide OFMB with sufficient information to prepare the end of year Schedule or so they can ask questions of OFMB and County Finance and seek assistance for any matters they are unsure of how to process.
2024-003 ─ Schedule of Expenditures of Federal Awards and State Financial Assistance (Schedule) U.S. Department of Transportation – Federal Transit Cluster (ALN No. 20.507) Federal award year 2023 Criteria: In accordance with 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502. 2 CFR Section 200.502(a) states that 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 grant awards. Condition: We noted that the Schedule of Expenditures of Federal Awards and State Financial Assistance (Schedule) provided to the auditors for the fiscal year ended September 30, 2024 included $56,503,870 of federal expenditures for the Federal Transit Cluster, assistance listing number 20.507, that should have been included in the Schedule for the fiscal year ended September 30, 2023. The County executed an ARPA transportation grant in September 2023 for which prior year eligible incurred costs were applied, however, these expenditures were not reported on the County’s Schedule until FY 2024. The Schedule for fiscal year ended September 30, 2023 was reissued to include the $56,503,870 and the expenditures were removed from the Schedule for the fiscal year ended September 30, 2024. Context: The finding is considered isolated in nature to the federal program in question. Effect: Improper reporting of federal expenditures resulted in a material error on the Schedule. Identification as a repeat finding, if applicable: Yes (2023-006) Cause: The department directly administering this grant did not realize they had to immediately recognize the expenditures associated with the grant at the time of grant award when the decision was made to apply prior eligible incurred costs. The transaction was not recorded until the reimbursement request was submitted in fiscal year 2024. Recommendation: Grant activities including general ledger activity should be reconciled by the departments managing the programs and the information communicated timely to the Office of Financial Management and Budget (OFMB). Depending on the nature and size of the grant programs these reconciliations could occur, monthly, quarterly or yearly, depending on what is most efficient in each individual situation. Also additional training could be provided to help enhance the understanding of grant personnel around some of the important nuances of revenue and expenditure recognition criteria the County must comply with in accordance with generally accepted accounting principles so they provide OFMB with sufficient information to prepare the end of year Schedule or so they can ask questions of OFMB and County Finance and seek assistance for any matters they are unsure of how to process.
2024-003: Preparation of Schedule of Expenditures of Federal Awards (SEFA) Finding Type: Material Weakness in Internal Controls and Noncompliance (Activities Allowed or Unallowed, Allowable Costs/Cost Principles, Reporting) Federal Program: U.S. Department of Treasury – Local Assistance and Tribal Consistency Fund (AL #21.032) Criteria: The Code of Federal Regulations (CFR) Section 200.303(b) requires non-Federal entities to establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and terms and conditions of the Federal award. CFR Section 200.502(a) states that 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 grant awards. The County reports expenditures on the SEFA when the expenditure has been incurred, or on the accrual basis of accounting, in accordance with generally accepted accounting principles. CFR Section 200.510(b) requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section 200.502(a), as stated above, and must reconcile amounts reported in the SEFA to the amounts reported in the auditee’s financial statements. Condition: The SEFA was not appropriately reconciled to federal grant revenues and expenditures recorded in the financial statements. Changes were made during the closing process and during the completion of the single audit to properly report expenditures on the SEFA. Closing procedures should be in place to reconcile grant expenditures incurred at year-end, confirm the amount as eligible with the grantor, claim the grant revenues on a timely basis, reconcile the claim to the general ledger, and ensure the expenditures that will be claimed under federal awards are properly reported on the SEFA and audited financial statements prior to the start of the single audit. If expenditures reported on the SEFA are misstated, the County could fail to have a program appropriately identified as a major program and tested as a major program during the single audit. Failure to have a program audited during the single audit would result in noncompliance with Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Cause: Closing procedures were not in place and management did not effectively communicate with County departments responsible for administering federal awards to identify all federal grant related activity. Effect: County personnel were unable to provide a complete SEFA in the appropriate format prior to the start of the annual financial statement audit and were uncertain if a single audit was required. The SEFA required material adjustments to include all federal expenditures prior to the beginning of the single audit. Questioned Costs: No costs have been questioned as a result of this finding. Recommendation: We recommend that management meet with department heads throughout the year and during the closing process to identify all expenditures under federal awards. Training should be provided to all staff to make sure they are aware of the importance of accurately reconciling and claiming grant expenditures on a timely basis and providing the information to management for inclusion on the SEFA. Views of Responsible Officials: The County will work to improve closing processes and communications with various departments to ensure the SEFA is complete and accurate.
Finding Number: 2024-030 Prior Year Finding Number: 2023-035 Compliance Requirement: Reporting Program: U.S. Department of Health and Human Services Opioid STR ALN: 93.788 Award #: Various Award Year: 09/30/2020 – 09/29/2024 Government Department/Agency: Department of Behavioral Health (DBH) Criteria - The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Federal Financial Report (FFR) Controls over Reporting Compliance: 2 CFR 200.333 requires that financial records, supporting documents, statistical records, and all other non-federal entity records pertinent to a federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the federal awarding agency or pass-through entity in the case of a subrecipient. Performance Progress Report (PPR) Underlying Data: The audit objective for the Reporting compliance requirement stated in the 2 CFR Part 200, appendix XI Compliance Supplement is as follows: Determine whether required reports for Federal awards include all activity of the reporting period, are supported by applicable accounting or performance records, and are fairly presented in accordance with governing requirements. Schedule of Expenditures of Federal Awards (SEFA) Reporting Compliance: Requirements, Cost Principles, and Audit Requirements, section 200.510(b) states the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 200.502. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. Condition – During our testing of the reporting compliance requirement, we noted the following: • FFR Controls over Reporting Compliance: DBH’s control over compliance for financial reporting is as follows: “All reports are reviewed by the Accounting Officer or Agency Fiscal Officer prior to submission to the Federal government. DBH Program and Fiscal Services staff review programmatic and financial reports.” We noted DBH did not timely review and approve the annual Financial Reporting Report (FFR or SF-425) prior to submission to the Federal government. Total population is one (1) report and sample selected is one (1). • PPR Reporting Compliance: We noted DBH did not have documentation for the information, as well as the source of the information, it used in the Opioid STR’s Performance Progress Report. Information as reported in the reports was unsupported as management did not retain the underlying data. Total population is two (2) reports and sample selected is one (1). • SEFA Reporting Compliance: During our testing for the SEFA, we noted that DBH incorrectly reported the value of subrecipient expenditures included within the subrecipient expenditure column. For the year ended September 30, 2024, DBH incurred $12.0 million in subrecipient expenditures for this program and incorrectly reported that there were no subrecipient expenditures on the initial SEFA. While the subrecipient expenditures amount was not accurate, the total expenditures amount was accurately reported. The error in the subrecipient expenditures amount was subsequently identified and corrected as a result of the audit process. Questioned Costs – None. Context – This is a condition identified per review of DBH’s compliance with specified reporting requirements using a statistically valid sample. Effect – Without proper internal controls and policies and procedures in place to ensure that correct amounts were reported and were properly reviewed as it relates to the Opioid STR program: • FFR Controls over Reporting Compliance: There is an increased risk of errors occurring and being undetected, or errors being present in reports if no review and approval occurred. • PPR Reporting Compliance: DBH cannot be assured that it reported complete and accurate information to enable the Substance Abuse and Mental Health Services Administration (SAMHSA), an operating division of the Department of Health and Human Services (HHS), to assess the outcomes of the State’s use of Opioid program funding. • SEFA Reporting Compliance: The effect of the condition is that the SEFA was not accurately prepared. Cause – Management did not have proper internal controls and policies and procedures in place to ensure that the amounts on the FFR and SEFA were properly reported, and the reports were properly reviewed and approved. Recommendation – We recommend the following: • FFR Controls over Reporting Compliance: We recommend DBH strengthen its internal control to ensure timely review and approval of the FFR before report submission. • PPR Reporting Compliance: We recommend DBH develop formal, written procedures to identify the sources of information necessary and steps needed to compile accurate and complete information for the Opioid program performance reports; and retain in a central location all documentation that it used to support information included in each performance report it submits to the federal government. • SEFA Reporting Compliance: We recommend DBH ensure that agency personnel receive proper training on subrecipient versus vendor determination; as well as review existing policies and procedures for preparing the Schedule of Expenditures of Federal Awards to ensure that it is complete and accurate. Related Noncompliance – Noncompliance. Views of Responsible Officials and Planned Corrective Actions – The DBH Office of the Chief Financial Officer (OCFO) concurs with this finding. The District’s corrective action is described in the Management’s Corrective Action Plan included as Appendix B of the attached Management’s Section.
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.
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.
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.