2023-002 – Internal Control over Compliance and Compliance with Period of Performance Information on the Major Federal Program - Federal Agency: United States Agency for International Development (USAID) Program Name: USAID Foreign Assistance for Program Overseas Assistance Listing Number: 98.001 Award Number: Various Award Period: Various Criteria – A non-Federal entity may charge to the Federal award only allowable costs incurred during the period of performance and any costs incurred before the Federal awarding agency or pass-through entity made the Federal award, only to the extent that they would have been allowable if incurred after the date of the Federal award and only with the written approval of the Federal awarding agency. Additionally, the Uniform Guidance in 2 CFR Section 200.344(b), states that unless the federal awarding agency or pass-through entity authorized an extension, a non-Federal entity must liquidate all financial obligations incurred under the Federal award not later than 120 calendar days after the end date of the period of performance as specified in the terms and conditions of the Federal award. Further, the Uniform Guidance in 2 CFR Section 200.303, Internal Controls, requires the non-federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonable ensure compliance with Federal statutes, regulations, and other terms and conditions of the Federal Award. The Uniform Guidance in 2 CFR Section 200.510 (b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR Section 200.502 Basis for determining Federal awards expended.” The SEFA must provide total Federal awards expended for each individual Federal program. Condition – During our testing, we identified one (1) out of 40 sampled transactions was incurred outside the period of performance. Corus did not obtain written approval from the federal awarding agency for the specific project. As a result, total expenditure totaling $106,400 was improperly included in the SEFA. Cause - The internal controls established for the review and reconciliation of the SEFA to the underlying accounting records were not consistently followed to ensure accurate charging of expenditures to the SEFA in the correct period. Questioned Costs - None. Context – This is a condition identified per review of Corus’ compliance with the specified requirements. Total expenditures of the specific project charged to the program was $106,400. These charges were removed from the SEFA presented for the year ended September 30, 2023. Effect - Failure to properly review and support expenditures reported in the SEFA can result in inaccurate reporting and non-compliance with laws and regulations. Repeat Finding - This is not a repeat finding. Recommendation - Internal controls should be designed to prevent, detect and correct errors and/or omissions in a timely manner. Without adequate controls, Corus cannot provide reasonable assurance that the SEFA is fairly presented. We recommend management to strengthen its internal control to ensure complete and accurate SEFA. Views of Responsible Officials - Corus management agrees with the findings and recommendations. The planned corrective actions are presented in Corus management’s corrective action plan attached as Appendix B to the Single Audit Report.
2023-002 – Internal Control over Compliance and Compliance with Period of Performance Information on the Major Federal Program - Federal Agency: United States Agency for International Development (USAID) Program Name: USAID Foreign Assistance for Program Overseas Assistance Listing Number: 98.001 Award Number: Various Award Period: Various Criteria – A non-Federal entity may charge to the Federal award only allowable costs incurred during the period of performance and any costs incurred before the Federal awarding agency or pass-through entity made the Federal award, only to the extent that they would have been allowable if incurred after the date of the Federal award and only with the written approval of the Federal awarding agency. Additionally, the Uniform Guidance in 2 CFR Section 200.344(b), states that unless the federal awarding agency or pass-through entity authorized an extension, a non-Federal entity must liquidate all financial obligations incurred under the Federal award not later than 120 calendar days after the end date of the period of performance as specified in the terms and conditions of the Federal award. Further, the Uniform Guidance in 2 CFR Section 200.303, Internal Controls, requires the non-federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonable ensure compliance with Federal statutes, regulations, and other terms and conditions of the Federal Award. The Uniform Guidance in 2 CFR Section 200.510 (b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR Section 200.502 Basis for determining Federal awards expended.” The SEFA must provide total Federal awards expended for each individual Federal program. Condition – During our testing, we identified one (1) out of 40 sampled transactions was incurred outside the period of performance. Corus did not obtain written approval from the federal awarding agency for the specific project. As a result, total expenditure totaling $106,400 was improperly included in the SEFA. Cause - The internal controls established for the review and reconciliation of the SEFA to the underlying accounting records were not consistently followed to ensure accurate charging of expenditures to the SEFA in the correct period. Questioned Costs - None. Context – This is a condition identified per review of Corus’ compliance with the specified requirements. Total expenditures of the specific project charged to the program was $106,400. These charges were removed from the SEFA presented for the year ended September 30, 2023. Effect - Failure to properly review and support expenditures reported in the SEFA can result in inaccurate reporting and non-compliance with laws and regulations. Repeat Finding - This is not a repeat finding. Recommendation - Internal controls should be designed to prevent, detect and correct errors and/or omissions in a timely manner. Without adequate controls, Corus cannot provide reasonable assurance that the SEFA is fairly presented. We recommend management to strengthen its internal control to ensure complete and accurate SEFA. Views of Responsible Officials - Corus management agrees with the findings and recommendations. The planned corrective actions are presented in Corus management’s corrective action plan attached as Appendix B to the Single Audit Report.
2023-002 – Internal Control over Compliance and Compliance with Period of Performance Information on the Major Federal Program - Federal Agency: United States Agency for International Development (USAID) Program Name: USAID Foreign Assistance for Program Overseas Assistance Listing Number: 98.001 Award Number: Various Award Period: Various Criteria – A non-Federal entity may charge to the Federal award only allowable costs incurred during the period of performance and any costs incurred before the Federal awarding agency or pass-through entity made the Federal award, only to the extent that they would have been allowable if incurred after the date of the Federal award and only with the written approval of the Federal awarding agency. Additionally, the Uniform Guidance in 2 CFR Section 200.344(b), states that unless the federal awarding agency or pass-through entity authorized an extension, a non-Federal entity must liquidate all financial obligations incurred under the Federal award not later than 120 calendar days after the end date of the period of performance as specified in the terms and conditions of the Federal award. Further, the Uniform Guidance in 2 CFR Section 200.303, Internal Controls, requires the non-federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonable ensure compliance with Federal statutes, regulations, and other terms and conditions of the Federal Award. The Uniform Guidance in 2 CFR Section 200.510 (b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR Section 200.502 Basis for determining Federal awards expended.” The SEFA must provide total Federal awards expended for each individual Federal program. Condition – During our testing, we identified one (1) out of 40 sampled transactions was incurred outside the period of performance. Corus did not obtain written approval from the federal awarding agency for the specific project. As a result, total expenditure totaling $106,400 was improperly included in the SEFA. Cause - The internal controls established for the review and reconciliation of the SEFA to the underlying accounting records were not consistently followed to ensure accurate charging of expenditures to the SEFA in the correct period. Questioned Costs - None. Context – This is a condition identified per review of Corus’ compliance with the specified requirements. Total expenditures of the specific project charged to the program was $106,400. These charges were removed from the SEFA presented for the year ended September 30, 2023. Effect - Failure to properly review and support expenditures reported in the SEFA can result in inaccurate reporting and non-compliance with laws and regulations. Repeat Finding - This is not a repeat finding. Recommendation - Internal controls should be designed to prevent, detect and correct errors and/or omissions in a timely manner. Without adequate controls, Corus cannot provide reasonable assurance that the SEFA is fairly presented. We recommend management to strengthen its internal control to ensure complete and accurate SEFA. Views of Responsible Officials - Corus management agrees with the findings and recommendations. The planned corrective actions are presented in Corus management’s corrective action plan attached as Appendix B to the Single Audit Report.
2023-002 – Internal Control over Compliance and Compliance with Period of Performance Information on the Major Federal Program - Federal Agency: United States Agency for International Development (USAID) Program Name: USAID Foreign Assistance for Program Overseas Assistance Listing Number: 98.001 Award Number: Various Award Period: Various Criteria – A non-Federal entity may charge to the Federal award only allowable costs incurred during the period of performance and any costs incurred before the Federal awarding agency or pass-through entity made the Federal award, only to the extent that they would have been allowable if incurred after the date of the Federal award and only with the written approval of the Federal awarding agency. Additionally, the Uniform Guidance in 2 CFR Section 200.344(b), states that unless the federal awarding agency or pass-through entity authorized an extension, a non-Federal entity must liquidate all financial obligations incurred under the Federal award not later than 120 calendar days after the end date of the period of performance as specified in the terms and conditions of the Federal award. Further, the Uniform Guidance in 2 CFR Section 200.303, Internal Controls, requires the non-federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonable ensure compliance with Federal statutes, regulations, and other terms and conditions of the Federal Award. The Uniform Guidance in 2 CFR Section 200.510 (b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR Section 200.502 Basis for determining Federal awards expended.” The SEFA must provide total Federal awards expended for each individual Federal program. Condition – During our testing, we identified one (1) out of 40 sampled transactions was incurred outside the period of performance. Corus did not obtain written approval from the federal awarding agency for the specific project. As a result, total expenditure totaling $106,400 was improperly included in the SEFA. Cause - The internal controls established for the review and reconciliation of the SEFA to the underlying accounting records were not consistently followed to ensure accurate charging of expenditures to the SEFA in the correct period. Questioned Costs - None. Context – This is a condition identified per review of Corus’ compliance with the specified requirements. Total expenditures of the specific project charged to the program was $106,400. These charges were removed from the SEFA presented for the year ended September 30, 2023. Effect - Failure to properly review and support expenditures reported in the SEFA can result in inaccurate reporting and non-compliance with laws and regulations. Repeat Finding - This is not a repeat finding. Recommendation - Internal controls should be designed to prevent, detect and correct errors and/or omissions in a timely manner. Without adequate controls, Corus cannot provide reasonable assurance that the SEFA is fairly presented. We recommend management to strengthen its internal control to ensure complete and accurate SEFA. Views of Responsible Officials - Corus management agrees with the findings and recommendations. The planned corrective actions are presented in Corus management’s corrective action plan attached as Appendix B to the Single Audit Report.
2023-002 – Internal Control over Compliance and Compliance with Period of Performance Information on the Major Federal Program - Federal Agency: United States Agency for International Development (USAID) Program Name: USAID Foreign Assistance for Program Overseas Assistance Listing Number: 98.001 Award Number: Various Award Period: Various Criteria – A non-Federal entity may charge to the Federal award only allowable costs incurred during the period of performance and any costs incurred before the Federal awarding agency or pass-through entity made the Federal award, only to the extent that they would have been allowable if incurred after the date of the Federal award and only with the written approval of the Federal awarding agency. Additionally, the Uniform Guidance in 2 CFR Section 200.344(b), states that unless the federal awarding agency or pass-through entity authorized an extension, a non-Federal entity must liquidate all financial obligations incurred under the Federal award not later than 120 calendar days after the end date of the period of performance as specified in the terms and conditions of the Federal award. Further, the Uniform Guidance in 2 CFR Section 200.303, Internal Controls, requires the non-federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonable ensure compliance with Federal statutes, regulations, and other terms and conditions of the Federal Award. The Uniform Guidance in 2 CFR Section 200.510 (b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR Section 200.502 Basis for determining Federal awards expended.” The SEFA must provide total Federal awards expended for each individual Federal program. Condition – During our testing, we identified one (1) out of 40 sampled transactions was incurred outside the period of performance. Corus did not obtain written approval from the federal awarding agency for the specific project. As a result, total expenditure totaling $106,400 was improperly included in the SEFA. Cause - The internal controls established for the review and reconciliation of the SEFA to the underlying accounting records were not consistently followed to ensure accurate charging of expenditures to the SEFA in the correct period. Questioned Costs - None. Context – This is a condition identified per review of Corus’ compliance with the specified requirements. Total expenditures of the specific project charged to the program was $106,400. These charges were removed from the SEFA presented for the year ended September 30, 2023. Effect - Failure to properly review and support expenditures reported in the SEFA can result in inaccurate reporting and non-compliance with laws and regulations. Repeat Finding - This is not a repeat finding. Recommendation - Internal controls should be designed to prevent, detect and correct errors and/or omissions in a timely manner. Without adequate controls, Corus cannot provide reasonable assurance that the SEFA is fairly presented. We recommend management to strengthen its internal control to ensure complete and accurate SEFA. Views of Responsible Officials - Corus management agrees with the findings and recommendations. The planned corrective actions are presented in Corus management’s corrective action plan attached as Appendix B to the Single Audit Report.
Finding Number: 2023-009 Prior Year Finding Number: N/A Compliance Requirement: Reporting Program: Government Department/Agency: U.S. Department of Labor Unemployment Insurance ALN: 17.225 Award #: UI-37216-22-55-A-11 Award Year: 10/01/2021 – 12/31/2024 Department of Employment Services (DOES) 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. The Uniform Guidance in 2 CFR Section 200.510(b), Schedule of Expenditures of Federal awards, states that 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 2 CFR section 200.502, Basis for determining Federal Awards expended. Condition – During our review of grant carryover analysis in relation to the fiscal year 2023 audit, we noted that DOES recorded $3.3 million of federal administrative expenditures in the current year SEFA in excess of the overall grant award amount for Unemployment Insurance program Award #UI-37216-22-55-A-11. BDO noted that the amount is related to the year-end closing entry reconciling DIFS R100 vs. R51 and should have been reversed in fiscal year 2023. The SEFA was adjusted to reflect the correct amount of expenditures incurred for the program. Questioned Costs – Not determinable. Context – This is a condition identified per review of the actual vs. budgeted expenditure for the Unemployment Insurance grant. Effect – DOES is not in compliance with the stated provisions. Failure to properly review and support expenditures can result in noncompliance with laws and regulations along with loss of funding. Cause – DOES did not adhere to internal control procedures to reasonably ensure that the SEFA be fairly presented. Recommendation – We recommend that DOES adhere to internal control procedures to reasonably ensure that expenditures do not exceed budget or grant award amounts. Related Noncompliance – Noncompliance. Views of Responsible Officials and Planned Corrective Actions – DOES concurs with this finding. The introduction of the new financial system resulted in the creation of several clearing accounts, necessitating ongoing monitoring and adjustments. One such account is the PNG Clearing Account. The specific transaction in question arose from a general ledger adjustment made during the fiscal year 2023 year-end close to reconcile outstanding balances within the PNG clearing account. This adjustment occurred subsequent to the closure of the subledger, prompting corrections at the source and resulting in discrepancies between subledger and general ledger balances. Management has taken prompt action to address this issue by rectifying discrepancies in the SEFA. Additionally, as part of a agency-wide remediation, we have implemented enhanced controls to facilitate timely reconciliation of subledgers with the general ledger, thus mitigating the risk of future discrepancies. It is important to highlight that this incident is an isolated occurrence within the context of the grant program, stemming from the transition to a new financial system, process changes, and the introduction of subledgers. Importantly, this discrepancy pertains solely to the initial SEFA amount based on general ledger reporting and does not impact federal reporting to the grantor, which is based on subledger data. Furthermore, it does not indicate overspending of federal resources. The District’s corrective action is described in the Management’s Corrective Action Plan included as Appendix B of the attached Management’s Section.
Finding Number: 2023-009 Prior Year Finding Number: N/A Compliance Requirement: Reporting Program: Government Department/Agency: U.S. Department of Labor Unemployment Insurance ALN: 17.225 Award #: UI-37216-22-55-A-11 Award Year: 10/01/2021 – 12/31/2024 Department of Employment Services (DOES) 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. The Uniform Guidance in 2 CFR Section 200.510(b), Schedule of Expenditures of Federal awards, states that 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 2 CFR section 200.502, Basis for determining Federal Awards expended. Condition – During our review of grant carryover analysis in relation to the fiscal year 2023 audit, we noted that DOES recorded $3.3 million of federal administrative expenditures in the current year SEFA in excess of the overall grant award amount for Unemployment Insurance program Award #UI-37216-22-55-A-11. BDO noted that the amount is related to the year-end closing entry reconciling DIFS R100 vs. R51 and should have been reversed in fiscal year 2023. The SEFA was adjusted to reflect the correct amount of expenditures incurred for the program. Questioned Costs – Not determinable. Context – This is a condition identified per review of the actual vs. budgeted expenditure for the Unemployment Insurance grant. Effect – DOES is not in compliance with the stated provisions. Failure to properly review and support expenditures can result in noncompliance with laws and regulations along with loss of funding. Cause – DOES did not adhere to internal control procedures to reasonably ensure that the SEFA be fairly presented. Recommendation – We recommend that DOES adhere to internal control procedures to reasonably ensure that expenditures do not exceed budget or grant award amounts. Related Noncompliance – Noncompliance. Views of Responsible Officials and Planned Corrective Actions – DOES concurs with this finding. The introduction of the new financial system resulted in the creation of several clearing accounts, necessitating ongoing monitoring and adjustments. One such account is the PNG Clearing Account. The specific transaction in question arose from a general ledger adjustment made during the fiscal year 2023 year-end close to reconcile outstanding balances within the PNG clearing account. This adjustment occurred subsequent to the closure of the subledger, prompting corrections at the source and resulting in discrepancies between subledger and general ledger balances. Management has taken prompt action to address this issue by rectifying discrepancies in the SEFA. Additionally, as part of a agency-wide remediation, we have implemented enhanced controls to facilitate timely reconciliation of subledgers with the general ledger, thus mitigating the risk of future discrepancies. It is important to highlight that this incident is an isolated occurrence within the context of the grant program, stemming from the transition to a new financial system, process changes, and the introduction of subledgers. Importantly, this discrepancy pertains solely to the initial SEFA amount based on general ledger reporting and does not impact federal reporting to the grantor, which is based on subledger data. Furthermore, it does not indicate overspending of federal resources. The District’s corrective action is described in the Management’s Corrective Action Plan included as Appendix B of the attached Management’s Section.
Finding Number: 2023-009 Prior Year Finding Number: N/A Compliance Requirement: Reporting Program: Government Department/Agency: U.S. Department of Labor Unemployment Insurance ALN: 17.225 Award #: UI-37216-22-55-A-11 Award Year: 10/01/2021 – 12/31/2024 Department of Employment Services (DOES) 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. The Uniform Guidance in 2 CFR Section 200.510(b), Schedule of Expenditures of Federal awards, states that 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 2 CFR section 200.502, Basis for determining Federal Awards expended. Condition – During our review of grant carryover analysis in relation to the fiscal year 2023 audit, we noted that DOES recorded $3.3 million of federal administrative expenditures in the current year SEFA in excess of the overall grant award amount for Unemployment Insurance program Award #UI-37216-22-55-A-11. BDO noted that the amount is related to the year-end closing entry reconciling DIFS R100 vs. R51 and should have been reversed in fiscal year 2023. The SEFA was adjusted to reflect the correct amount of expenditures incurred for the program. Questioned Costs – Not determinable. Context – This is a condition identified per review of the actual vs. budgeted expenditure for the Unemployment Insurance grant. Effect – DOES is not in compliance with the stated provisions. Failure to properly review and support expenditures can result in noncompliance with laws and regulations along with loss of funding. Cause – DOES did not adhere to internal control procedures to reasonably ensure that the SEFA be fairly presented. Recommendation – We recommend that DOES adhere to internal control procedures to reasonably ensure that expenditures do not exceed budget or grant award amounts. Related Noncompliance – Noncompliance. Views of Responsible Officials and Planned Corrective Actions – DOES concurs with this finding. The introduction of the new financial system resulted in the creation of several clearing accounts, necessitating ongoing monitoring and adjustments. One such account is the PNG Clearing Account. The specific transaction in question arose from a general ledger adjustment made during the fiscal year 2023 year-end close to reconcile outstanding balances within the PNG clearing account. This adjustment occurred subsequent to the closure of the subledger, prompting corrections at the source and resulting in discrepancies between subledger and general ledger balances. Management has taken prompt action to address this issue by rectifying discrepancies in the SEFA. Additionally, as part of a agency-wide remediation, we have implemented enhanced controls to facilitate timely reconciliation of subledgers with the general ledger, thus mitigating the risk of future discrepancies. It is important to highlight that this incident is an isolated occurrence within the context of the grant program, stemming from the transition to a new financial system, process changes, and the introduction of subledgers. Importantly, this discrepancy pertains solely to the initial SEFA amount based on general ledger reporting and does not impact federal reporting to the grantor, which is based on subledger data. Furthermore, it does not indicate overspending of federal resources. The District’s corrective action is described in the Management’s Corrective Action Plan included as Appendix B of the attached Management’s Section.
Finding Number: 2023-035 Prior Year Finding Number: N/A Compliance Requirement: Reporting Program: Government Department/Agency: U.S. Department of Health and Human Services Opioid STR ALN: 93.788 Award #: Various Award Year: 09/30/2020 – 09/29/2024 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 Awardee Performance and Integrity Information System (FAPIIS) Reporting Compliance: In accordance with the regulatory requirements provided at 45 CFR 75.113 and Appendix XII to 45 CFR Part 75, recipients that have currently active Federal grants, cooperative agreements, and procurement contracts with cumulative total value greater than $10,000,000 must report and maintain information in the System for Award Management (SAM) about civil, criminal, and administrative proceedings in connection with the award or performance of a Federal award that reached final disposition within the most recent five-year period or affirm that there is no new information to report. The recipient must also make semiannual disclosures regarding such proceedings. Proceedings information will be made publicly available in the designated integrity and performance system (currently the FAPIIS). Federal Funding Accountability and Transparency Act (FFATA) Reporting Compliance: The FFATA (Pub. L. No. 109-282, as amended by Section 6202 of Public Law 110-252, hereafter referred as the “Transparency Act” that are codified in 2 CFR Part 170) requires prime recipients of federal awards who make first-tier subawards to report the subaward on the Federal Funding Accountability and Transparency Subaward Reporting System (FSRS) website maintained by the federal Office of Management and Budget. Under the requirements of 2 CFR Part 170, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more on the FSRS website. Prime recipients must report by the end of the month following the month in which the obligation is made. It is management’s responsibility to design and implement internal controls to reasonably ensure compliance with laws and regulations and to ensure management’s objectives are achieved. Federal Financial Report (FFR) Controls over Reporting Compliance: In addition, 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: • FAPIIS Reporting Compliance: During our testing of FAPIIS reporting for fiscal year ended September 30, 2023, it was noted that the program’s reporting regarding civil, criminal, and administrative proceedings in connection with the award or performance of a Federal award that reached final disposition within the most recent five-year period or affirmation that there was no new information to report was not submitted by the DBH program management. • FFATA Reporting Compliance: During our testing of FFATA reporting, it was noted that reports were not submitted by the DBH program management. DBH program management was not aware of FFATA reporting requirement and did not report subawards within the FSRS website during the award year. None of the ten subawards selected for testing were reported to FSRS. Total subawards tested were $3,559,912, and $0 was reported as required by FFATA requirements. • 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 have documentation of the control over compliance, as well as the review and approval of the Financial Reporting Report (FFR or SF-425). • PPR Reporting Compliance: We found DBH did not have documentation for the information, and the source of the information, it used in its Opioid program’s Performance Progress Report. Information as reported on the reports is unsupported as management did not retain the underlying data. • 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, 2023, DBH incurred $12,800,130 in subrecipient expenditures for this program and incorrectly reported that there were no subrecipient expenditures on the draft SEFA. The error was subsequently identified and corrected as a result of the audit process. While the subrecipient expenditure column was not accurate, the total expenditure column was accurately reported. 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, the Opioid STR program: • FAPIIS Reporting Compliance: DBH management did not report the necessary FAPIIS information for Opioid STR in accordance with Federal requirements. • FFATA Reporting Compliance: DBH management did not report the necessary FFATA report for Opioid STR first-tier subawards over $30,000 to the FFATA Subaward Reporting System in accordance with FFATA requirements. • FFR Controls over Reporting Compliance: There is an increased risk of errors occurring and going 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 found 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 FAPIIS, FFATA, FFR, PPR and SEFA were properly reported, and the reports were properly reviewed and approved. Recommendation – We recommend the following: • FAPIIS Reporting Compliance: We recommend DBH to evaluate its reporting control procedures and update them as necessary to ensure they promote compliance with the Federal regulations. These procedures should include a supervisory review of the report information before it is submitted. Further, we recommend that DBH collect, and report complete and accurate information regarding FAPIIS. • FFATA Reporting Compliance: We recommend DBH to evaluate its Transparency Act reporting control procedures and update them as necessary to ensure they promote compliance with the Federal regulations. These procedures should include a supervisory review of the report information before it is submitted on the FSRS website. Further, we recommend DBH collect and report on the FSRS website complete and accurate information regarding subawards made for all programs subject to the Transparency Act. • FFR Controls over Reporting Compliance: We recommend DBH to design and implement procedures to ensure sufficient documentation is maintained that supports the review and approval of the FFR. • PPR Reporting Compliance: We recommend DBH to 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 to ensure that agency personnel receive proper training on subrecipient versus vendor determination; as well as review its existing policies and procedures for preparing the Schedule of Expenditures of Federal Awards to ensure that it is complete and accurate. Related Noncompliance – Material noncompliance. Views of Responsible Officials and Planned Corrective Actions – DBH agrees with these findings and plans to address reporting requirements to ensure that the FAPIIS, FFATA, FFR, PPR and SEFA are completed accurately and on the required schedule. The District’s corrective action is described in the Management’s Corrective Action Plan included as Appendix B of the attached Management’s Section.
Section III – Federal Award Findings and Questioned Costs 2023-001 Federal Award Omitted from Schedule of Expenditures of Federal Awards Grantor: Department of Health and Human Services Award Name: Medical Assistance Program Award Year: FY2020, FY2021, FY2022 Assistance Listing Number: 93.778 Condition During the FY 2023 Uniform Guidance audit, Management identified funds from this program that were not appropriately reported for the fiscal years ended September 30, 2022, 2021, and 2020 in the amounts of $136,828, $18,921, and $71,915, respectively. Criteria 2 CFR 200.510 Financial statements require auditees to prepare a Schedule of Expenditures of Federal Awards (the “Schedule”) for the period covered by the auditee’s financial statements, which must include in the total Federal Awards expensed as determined in accordance with 2 CFR 200.502. The information presented should be consistent with the accounting records and other federal guidance. Cause The cause of the finding was due to insufficient review of the Schedule. Effect A Schedule that is not complete and accurate could impact the scoping of an entity’s major programs and result in incomplete information being provided to the federal government. There was not an impact on our major program determinations in the prior years. Questioned Cost There are no questioned costs associated with this finding. Recommendation Management should enhance the controls in place to review and verify the completeness and accuracy of the Schedule. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal 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 presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 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, the errors could result in improper selections of major program(s) for the single audit and 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 2024 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 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 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. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
Assistance Listing, Federal Agency, and Program Name - ALN 97.036, U.S. Department of Homeland Security, Disaster Grants - Public Assistance (FEMA) Federal Award Identification Number and Year - All grants under ALN Pass-through Entity - Michigan Department of State Police Finding Type - Material weakness Repeat Finding - Yes 2022-004 Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. Condition - The FEMA expenditures on the schedule of expenditures of federal awards (SEFA) initially presented for audit were not complete and accurate. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - In fiscal year 2023, the County expended approximately $122 million of federal funding. The funding was received by various departments within the County and from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The FEMA expenditures on the SEFA were understated by $2,449,502. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for FEMA, and, as a result, FEMA expenditures of $2,449,502 were added to the SEFA, impacting major program determination. Recommendation - The County should implement a process to ensure the FEMA expenditures reported on the SEFA are complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Training on FEMA reporting for the SEFA was requested and performed by our auditors. Fiscal year 2024 is the last year any FEMA obligations will happen. A full understanding of the reported amount has been noted.
Assistance Listing, Federal Agency, and Program Name - ALN 97.036, U.S. Department of Homeland Security, Disaster Grants - Public Assistance (FEMA) Federal Award Identification Number and Year - All grants under ALN Pass-through Entity - Michigan Department of State Police Finding Type - Material weakness Repeat Finding - Yes 2022-004 Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. Condition - The FEMA expenditures on the schedule of expenditures of federal awards (SEFA) initially presented for audit were not complete and accurate. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - In fiscal year 2023, the County expended approximately $122 million of federal funding. The funding was received by various departments within the County and from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The FEMA expenditures on the SEFA were understated by $2,449,502. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for FEMA, and, as a result, FEMA expenditures of $2,449,502 were added to the SEFA, impacting major program determination. Recommendation - The County should implement a process to ensure the FEMA expenditures reported on the SEFA are complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Training on FEMA reporting for the SEFA was requested and performed by our auditors. Fiscal year 2024 is the last year any FEMA obligations will happen. A full understanding of the reported amount has been noted.
Assistance Listing, Federal Agency, and Program Name - ALN 97.036, U.S. Department of Homeland Security, Disaster Grants - Public Assistance (FEMA) Federal Award Identification Number and Year - All grants under ALN Pass-through Entity - Michigan Department of State Police Finding Type - Material weakness Repeat Finding - Yes 2022-004 Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. Condition - The FEMA expenditures on the schedule of expenditures of federal awards (SEFA) initially presented for audit were not complete and accurate. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - In fiscal year 2023, the County expended approximately $122 million of federal funding. The funding was received by various departments within the County and from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The FEMA expenditures on the SEFA were understated by $2,449,502. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for FEMA, and, as a result, FEMA expenditures of $2,449,502 were added to the SEFA, impacting major program determination. Recommendation - The County should implement a process to ensure the FEMA expenditures reported on the SEFA are complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Training on FEMA reporting for the SEFA was requested and performed by our auditors. Fiscal year 2024 is the last year any FEMA obligations will happen. A full understanding of the reported amount has been noted.
Assistance Listing, Federal Agency, and Program Name - ALN 97.036, U.S. Department of Homeland Security, Disaster Grants - Public Assistance (FEMA) Federal Award Identification Number and Year - All grants under ALN Pass-through Entity - Michigan Department of State Police Finding Type - Material weakness Repeat Finding - Yes 2022-004 Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. Condition - The FEMA expenditures on the schedule of expenditures of federal awards (SEFA) initially presented for audit were not complete and accurate. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - In fiscal year 2023, the County expended approximately $122 million of federal funding. The funding was received by various departments within the County and from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The FEMA expenditures on the SEFA were understated by $2,449,502. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for FEMA, and, as a result, FEMA expenditures of $2,449,502 were added to the SEFA, impacting major program determination. Recommendation - The County should implement a process to ensure the FEMA expenditures reported on the SEFA are complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Training on FEMA reporting for the SEFA was requested and performed by our auditors. Fiscal year 2024 is the last year any FEMA obligations will happen. A full understanding of the reported amount has been noted.
Finding Number: 2023-011 Program: Disaster Grants – Public Assistance (Presidentially Declared Disasters) ALN #: 97.036 Pass-through Entity: State of California – Office of Emergency Services Federal Agency: Federal Emergency Management Agency (FEMA) Grant Award Numbers: 3100202051, 3100202055, 3100202058, and 3100202059 Federal Award Years: January 27, 2023, March 12, 2023, July 17, 2023, July 21, 2023 Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designated to reasonably ensure compliance with Federal laws, regulations and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately and completely reported on the SEFA. Conditions Found The City did not have adequate internal controls related to the reporting of expenditures on the SEFA for Disaster Grants – Public Assistance (Presidentially Declared Disasters) (Disaster Grants) program. The City incorrectly reported $2,165,166 in expenditures on the September 30, 2023 draft Schedule of Expenditures of Federal Awards (SEFA) related to grants that were not obligated by the Federal Emergency Management Agency (FEMA) as of September 30, 2023, resulting in the draft SEFA being overstated. While the City had incurred costs under these FEMA projects, nonfederal entities may not record expenditures on the SEFA until FEMA has approved the nonfederal entity’s project and has obligated those expenditures to the nonfederal entity. The City subsequently revised the SEFA so that the expenditures reported are accurate. Cause In discussing these conditions with the City, it stated the error was primarily due to the City not understanding the updated guidance issued by FEMA that notes FEMA expenditures are to be recorded on the SEFA at the later of the FEMA obligation date or the incurrence of an allowable expense. Effect Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the City from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs Not applicable Repeat finding A similar finding was not reported in the prior year. Statistical sample The sample was not intended to be, and was not, a statistically valid sample. Recommendation We recommend the City implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate. View of Responsible Officials The Financial Management Department acknowledges there was a deficiency in the manner that expenditures were reported for a declared disaster on the SEFA for the fiscal year ended September 30, 2023. The $2,165,166 overstatement represented expenditures that FEMA obligated within 60 days of September 30, 2023. Given the program is maintained in a Governmental Fund, the Department recorded a revenue accrual in the FY 2023 Annual Comprehensive Financial Report (ACFR) to align with the City’s existing policy to record grant revenue expected to be collected within one year in the same fiscal year expenditures are reported. The Department recognizes FEMA Disaster Grants should be an exception and will prevent this reporting error by updating the Revenue Recognition Policy and issuing a Financial Management Disaster Procedure Manual that will include a narrative on this specific matter. The Procedures Manual will be published on the City Intranet and utilized for all City Staff as a resource for all future disaster grants funded by FEMA’s Public Assistance Program (ALN 97.036). Revisions to the Procedure Manual will be made as needed to ensure the City is current with the latest compliance changes. In addition to attending regular meetings and obtaining direct correspondence and guidance from FEMA representatives, Financial Management will also perform its own research to obtain, read, and apply the latest Uniform Guidance Compliance Supplement prior to the annual SEFA preparation process to ensure the City is meeting compliance requirements. The proper FEMA expenditures amount for fiscal year ended September 30, 2023, was revised in subsequent SEFA drafts and is reflected in the final Single Audit report.
2023-006: Preparing Accurate and Complete Schedule of Expenditures of Federal Awards (SEFA) Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 93.696, Certified Community Behavioral Health Clinic Expansion Grant Federal Award Identification Number and Year: 1H79SM086680-01, Program Grant Period 09/29/2022-09/29/2023 Pass-through Entity: N/A Type: Material weakness in internal controls and material noncompliance with laws and regulations Repeat Finding: No Criteria: Per 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 with section 200.502. Condition: The Authority did not identify that they were subject to an audit under the Uniform Guidance (U.G.) and a schedule of expenditures of federal awards (SEFA) was not prepared by management. Identification of How Likely Questioned Costs Were Computed: N/A Known Questioned Costs: None Context: This was the first year of the CCBHC grant which was $568,350 of the total of $1,029,718 federal awards. In reviewing if a single audit was required only the CCBHC grant was consider which was below the $750,000 threshold, however when combined with the entities other federal awards the amount exceed the $750,000 threshold. As a result, management may fail to identify that an audit under the Uniform Guidance is required and that all federal dollars are included. Cause/Effect: The Authority’s controls were not adequate to ensure that they identify the requirement to have an audit under the Uniform Guidance and the preparation of an accurate and complete SEFA. As a result, management may fail to identify that an audit under the Uniform Guidance is required and that all federal dollars are included. Recommendation: We recommend the Authority review federal, state, and local grants to determine if they are federally funded and, if federally funded, utilize the account number outlined in the State of Michigan chart of accounts to track federal funding. View of Responsible Officials and Planned Corrective Action Plan: See attached corrective action plan.
Preparation of Schedule of Expenditures of Federal Awards (SEFA) (repeat) Finding Type: Material Weakness in Internal Controls and Noncompliance (Reporting, Cash Management and Allowable Costs/Cost Principles) Federal Program: U.S. Department of Treasury – Coronavirus State and Local Fiscal Recovery Funds (AL #21.027) and 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 nonFederal 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 to major program expenditures, as well as expenditures of other programs, 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 g ant 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: The SEFA required material adjustments to include all federal expenditures prior to the single audit beginning, which resulted in a misstated preliminary SEFA and inefficiencies during the single audit. In addition, the lack of closing procedures resulted in audit delays which caused the 2022 and 2023 financial reporting process, including data collection form submission, to be untimely. 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.
Preparation of Schedule of Expenditures of Federal Awards (SEFA) (repeat) Finding Type: Material Weakness in Internal Controls and Noncompliance (Reporting, Cash Management and Allowable Costs/Cost Principles) Federal Program: U.S. Department of Treasury – Coronavirus State and Local Fiscal Recovery Funds (AL #21.027) and 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 nonFederal 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 to major program expenditures, as well as expenditures of other programs, 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 g ant 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: The SEFA required material adjustments to include all federal expenditures prior to the single audit beginning, which resulted in a misstated preliminary SEFA and inefficiencies during the single audit. In addition, the lack of closing procedures resulted in audit delays which caused the 2022 and 2023 financial reporting process, including data collection form submission, to be untimely. 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.
Assistance Listing, Federal Agency, and Program Name 66.818, U.S. Environmental Protection Agency, Brownfields Assessment and Cleanup Cooperative Agreements; 14.218, U.S. Department of Housing and Urban Development, CDBG Entitlement Grants Cluster Community Development Block Grant Federal Award Identification Number and Year N/A Pass through Entity ALN 14.218 Wayne County Finding Type Material weakness Repeat Finding Yes 2022 002 Criteria The Single Audit Act and Uniform Guidance require a nonfederal entity that expends $750,000 or more of federal awards in a fiscal year to have a single or program specific audit. 2 CFR §200.508 (b) indicates that the auditee must prepare financial statements, including the schedule of expenditures of Federal awards in accordance with 2 CFR §200.510. Additionally, 2 CFR §200.502 describes the basis for determining the timing of when federal awards are deemed expended and, therefore, reportable on the schedule. Condition The schedule of expenditures of federal awards (SEFA) was not accurate. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context During the fiscal year ended September 30, 2023, the City expended approximately $921,000 of federal funding. The initial draft of the SEFA included the following inaccuracies: ALN 66.818 The expenditures reported on the SEFA were understated by $689,255. ALN 14.218 The expenditures reported on the SEFA were understated by $55,192. The errors noted above have been corrected on the SEFA as of September 30, 2023. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit. The errors resulted in the understatement of federal expenditures. Additionally, the understatement of federal expenditures on the SEFA resulted in the incorrect conclusion that federal activity was below $750,000 and, therefore, a single audit was not needed. Recommendation We recommend the City implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The City will review its process for identifying and communicating Federal Grant expenditures to its auditors.
Assistance Listing, Federal Agency, and Program Name 66.818, U.S. Environmental Protection Agency, Brownfields Assessment and Cleanup Cooperative Agreements; 14.218, U.S. Department of Housing and Urban Development, CDBG Entitlement Grants Cluster Community Development Block Grant Federal Award Identification Number and Year N/A Pass through Entity ALN 14.218 Wayne County Finding Type Material weakness Repeat Finding Yes 2022 002 Criteria The Single Audit Act and Uniform Guidance require a nonfederal entity that expends $750,000 or more of federal awards in a fiscal year to have a single or program specific audit. 2 CFR §200.508 (b) indicates that the auditee must prepare financial statements, including the schedule of expenditures of Federal awards in accordance with 2 CFR §200.510. Additionally, 2 CFR §200.502 describes the basis for determining the timing of when federal awards are deemed expended and, therefore, reportable on the schedule. Condition The schedule of expenditures of federal awards (SEFA) was not accurate. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context During the fiscal year ended September 30, 2023, the City expended approximately $921,000 of federal funding. The initial draft of the SEFA included the following inaccuracies: ALN 66.818 The expenditures reported on the SEFA were understated by $689,255. ALN 14.218 The expenditures reported on the SEFA were understated by $55,192. The errors noted above have been corrected on the SEFA as of September 30, 2023. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit. The errors resulted in the understatement of federal expenditures. Additionally, the understatement of federal expenditures on the SEFA resulted in the incorrect conclusion that federal activity was below $750,000 and, therefore, a single audit was not needed. Recommendation We recommend the City implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan The City will review its process for identifying and communicating Federal Grant expenditures to its auditors.
Assistance Listing Number, Federal Agency, and Program Name - ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) Federal Award Identification Number and Year - All grants under ALN Pass through Entity - Michigan Department of State Police Finding Type - Material weakness Repeat Finding - Yes 2022 004 Criteria - Per 2 CFR Section 200.510(b), the auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. Condition - The FEMA expenditures on the schedule of expenditures of federal awards (SEFA) initially presented for audit were not complete and accurate. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - In fiscal year 2023, the County expended approximately $122 million of federal funding. The funding was received by various departments within the County and from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The FEMA expenditures on the SEFA were understated by $2,449,502. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for FEMA, and, as a result, FEMA expenditures of $2,449,502 were added to the SEFA, impacting major program determination. Recommendation - The County should implement a process to ensure the FEMA expenditures reported on the SEFA are complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Training on FEMA reporting for the SEFA was requested and performed by our auditors. Fiscal year 2024 is the last year any FEMA obligations will happen. A full understanding of the reported amount has been noted.
Assistance Listing Number, Federal Agency, and Program Name - ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) Federal Award Identification Number and Year - All grants under ALN Pass through Entity - Michigan Department of State Police Finding Type - Material weakness Repeat Finding - Yes 2022 004 Criteria - Per 2 CFR Section 200.510(b), the auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. Condition - The FEMA expenditures on the schedule of expenditures of federal awards (SEFA) initially presented for audit were not complete and accurate. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - In fiscal year 2023, the County expended approximately $122 million of federal funding. The funding was received by various departments within the County and from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The FEMA expenditures on the SEFA were understated by $2,449,502. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for FEMA, and, as a result, FEMA expenditures of $2,449,502 were added to the SEFA, impacting major program determination. Recommendation - The County should implement a process to ensure the FEMA expenditures reported on the SEFA are complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Training on FEMA reporting for the SEFA was requested and performed by our auditors. Fiscal year 2024 is the last year any FEMA obligations will happen. A full understanding of the reported amount has been noted.
Assistance Listing Number, Federal Agency, and Program Name - ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) Federal Award Identification Number and Year - All grants under ALN Pass through Entity - Michigan Department of State Police Finding Type - Material weakness Repeat Finding - Yes 2022 004 Criteria - Per 2 CFR Section 200.510(b), the auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. Condition - The FEMA expenditures on the schedule of expenditures of federal awards (SEFA) initially presented for audit were not complete and accurate. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - In fiscal year 2023, the County expended approximately $122 million of federal funding. The funding was received by various departments within the County and from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The FEMA expenditures on the SEFA were understated by $2,449,502. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for FEMA, and, as a result, FEMA expenditures of $2,449,502 were added to the SEFA, impacting major program determination. Recommendation - The County should implement a process to ensure the FEMA expenditures reported on the SEFA are complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Training on FEMA reporting for the SEFA was requested and performed by our auditors. Fiscal year 2024 is the last year any FEMA obligations will happen. A full understanding of the reported amount has been noted.
Assistance Listing Number, Federal Agency, and Program Name - ALN 97.036, U.S. Department of Homeland Security, Disaster Grants Public Assistance (FEMA) Federal Award Identification Number and Year - All grants under ALN Pass through Entity - Michigan Department of State Police Finding Type - Material weakness Repeat Finding - Yes 2022 004 Criteria - Per 2 CFR Section 200.510(b), the auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. Condition - The FEMA expenditures on the schedule of expenditures of federal awards (SEFA) initially presented for audit were not complete and accurate. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - In fiscal year 2023, the County expended approximately $122 million of federal funding. The funding was received by various departments within the County and from several federal and nonfederal entities. The County accumulates the financial data and other required information to complete the SEFA. The FEMA expenditures on the SEFA were understated by $2,449,502. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for FEMA, and, as a result, FEMA expenditures of $2,449,502 were added to the SEFA, impacting major program determination. Recommendation - The County should implement a process to ensure the FEMA expenditures reported on the SEFA are complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Training on FEMA reporting for the SEFA was requested and performed by our auditors. Fiscal year 2024 is the last year any FEMA obligations will happen. A full understanding of the reported amount has been noted.
Assistance Listing Number, Federal Agency, and Program Name - ALN 66.458, U.S. Environment Protection Agency Capitalization Grants for Clean Water State Revolving Funds (CWSRF) Federal Award Identification Number and Year - Project Number 5834 01 (2023) Pass through Entity - Michigan Department Environment, Great Lakes and Energy Finding Type - Material weakness Repeat Finding - No Criteria - Per 2 CFR 200.508(b), an auditee must prepare appropriate financial statements, including the schedule of expenditures of federal awards, in accordance with 200.510 financial statements. Per 2 CFR 200.510(b), the auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502 basis for determining federal awards expended. Condition - Controls in place were not adequate to ensure the schedule of federal expenditures was complete and accurate. If Questioned Costs Are Not Determinable, Description of Why Known Questioned Costs Were Undetermined or Otherwise Could Not Be Reported - N/A Identification of How Questioned Costs Were Computed - N/A Context - The County did not initially include the funds received through the Capitalization Grants for Clean Water State Revolving Funds. Cause and Effect - The County did not have a process in place to identify all potential sources of federal funding received during the year, resulting in the SEFA being incomplete for the year ended September 30, 2023. Upon discovery of the error, the County prepared a SEFA that included the Capitalization Grants for Clean Water State Revolving Funds. This lack of controls resulted in the reissuance of the 2023 single audit. Recommendation - Management should implement controls to ensure all federal funding received is properly identified as such and included on the SEFA. Views of Responsible Officials and Planned Corrective Actions - Management agrees with the finding as reported. The federal funding was not received until fiscal year 2023, while expenditures were incurred prior to fiscal year 2023. The timing of events contributed to the oversight on the 2023 SEFA. The County has reeducated staff on the preparation of the SEFA in order to prevent this error from reoccurring.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with §200.502. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.