Finding 2024-009 – Reporting (Noncompliance) Identification of the Federal Program: Community Program to Improve Minority Health, ALN 93.137, Department of Health and Human Services (Minority Health); Community Development Block Grants, ALN 14.218, Department of Housing and Urban Development (CDBG); Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027, Department of the Treasury (CRF). Criteria: 2 CFR 200.328-330 establish the requirements of nonfederal entities for financial and performance reporting that include timely and accurate reporting. Reporting requirements are unique to each awarding agency and criteria is based on the guidelines and regulations set forth by the funding agency. Each program required quarterly reports to be submitted. Condition: We selected nine reports for the three grant programs tested to test for timely and accurate reporting requirements. The following exceptions were noted: • Minority Health: Two Federal Financial Report (FFR) and two Federal Performance Report (FPR) reports tested; the two FFR reports were not submitted by the due date and one FFR report did not agree or reconcile to the accounting records • CDBG: Two quarterly cash reports and the FY23 Consolidated Annual Performance and Evaluation Report (CAPER) tested; the two cash on hand reports did not have supporting documentation for the amounts reported or documentation that amounts were reconciled to the City's accounting system. One cash report was also filed late. • CRF: Two project and expenditure reports tested; one was not submitted and the other was submitted late. Expenditure information for one subrecipient was underreported by $186,364. Cause: Minority Health FFR reports were not submitted until February 2025, well past the due date. In addition, one FFR was not properly supported. CDBG project profit and loss statements did not tie to the numbers on the reports, the reports were submitted based on the IDIS reports from the HUD site and were not reconciled to the general ledger. CRF subaward amounts reported did not reconcile back to the general ledger. Various reports were filed after the due date. Effect: The City did not submit timely and accurate reports in compliance with federal reporting requirements. Questioned Costs: None reported. Recommendation: The City should ensure responsible personnel have a clear understanding of the reporting guidance. The City should implement policies and procedures to monitor due dates and review all reports prepared by the grants department or its designee to ensure accurate and timely reporting. Views of Responsible Officials: The City agrees with the finding. See Management’s View and Corrective Action Plan included at the end of the report.
Finding 2024-008 – Reporting (Material Weakness) Identification of the Federal Program: Community Program to Improve Minority Health, ALN 93.137, Department of Health and Human Services (Minority Health); Community Development Block Grants, ALN 14.218, Department of Housing and Urban Development (CDBG); Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027, Department of the Treasury (CRF). Criteria: 2 CFR 200.328-330 establish the requirements of nonfederal entities for financial and performance reporting. 2 CFR 200.303 requires nonfederal entities to establish, document and maintain effective internal control over the federal award that provides reasonable assurance that the recipient or subrecipient is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Typical control procedures related to reporting are to verify the filed report is supported by supporting documentation and inspecting filed report and supporting documentation, noting supervisory review of reports performed to assure accuracy and completeness of data and information included in the report. Condition: We selected nine reports for the three grant programs tested to test for controls over reporting requirements. No documentation of review or approval of the reports was available. Cause: The City did not retain documentation of a review and approval of federal reports submitted. Effect: The City did not have appropriate controls in place over documentation of reporting requirements. Questioned Costs: None reported. Recommendation: We recommend the City strengthen its policies and procedures over the grant reporting process to ensure controls are properly implemented and working effectively. Views of Responsible Officials: The City agrees with the finding. See Management’s View and Corrective Action Plan included at the end of the report.
Finding 2024-009 – Reporting (Noncompliance) Identification of the Federal Program: Community Program to Improve Minority Health, ALN 93.137, Department of Health and Human Services (Minority Health); Community Development Block Grants, ALN 14.218, Department of Housing and Urban Development (CDBG); Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027, Department of the Treasury (CRF). Criteria: 2 CFR 200.328-330 establish the requirements of nonfederal entities for financial and performance reporting that include timely and accurate reporting. Reporting requirements are unique to each awarding agency and criteria is based on the guidelines and regulations set forth by the funding agency. Each program required quarterly reports to be submitted. Condition: We selected nine reports for the three grant programs tested to test for timely and accurate reporting requirements. The following exceptions were noted: • Minority Health: Two Federal Financial Report (FFR) and two Federal Performance Report (FPR) reports tested; the two FFR reports were not submitted by the due date and one FFR report did not agree or reconcile to the accounting records • CDBG: Two quarterly cash reports and the FY23 Consolidated Annual Performance and Evaluation Report (CAPER) tested; the two cash on hand reports did not have supporting documentation for the amounts reported or documentation that amounts were reconciled to the City's accounting system. One cash report was also filed late. • CRF: Two project and expenditure reports tested; one was not submitted and the other was submitted late. Expenditure information for one subrecipient was underreported by $186,364. Cause: Minority Health FFR reports were not submitted until February 2025, well past the due date. In addition, one FFR was not properly supported. CDBG project profit and loss statements did not tie to the numbers on the reports, the reports were submitted based on the IDIS reports from the HUD site and were not reconciled to the general ledger. CRF subaward amounts reported did not reconcile back to the general ledger. Various reports were filed after the due date. Effect: The City did not submit timely and accurate reports in compliance with federal reporting requirements. Questioned Costs: None reported. Recommendation: The City should ensure responsible personnel have a clear understanding of the reporting guidance. The City should implement policies and procedures to monitor due dates and review all reports prepared by the grants department or its designee to ensure accurate and timely reporting. Views of Responsible Officials: The City agrees with the finding. See Management’s View and Corrective Action Plan included at the end of the report.
Finding 2024-008 – Reporting (Material Weakness) Identification of the Federal Program: Community Program to Improve Minority Health, ALN 93.137, Department of Health and Human Services (Minority Health); Community Development Block Grants, ALN 14.218, Department of Housing and Urban Development (CDBG); Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027, Department of the Treasury (CRF). Criteria: 2 CFR 200.328-330 establish the requirements of nonfederal entities for financial and performance reporting. 2 CFR 200.303 requires nonfederal entities to establish, document and maintain effective internal control over the federal award that provides reasonable assurance that the recipient or subrecipient is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Typical control procedures related to reporting are to verify the filed report is supported by supporting documentation and inspecting filed report and supporting documentation, noting supervisory review of reports performed to assure accuracy and completeness of data and information included in the report. Condition: We selected nine reports for the three grant programs tested to test for controls over reporting requirements. No documentation of review or approval of the reports was available. Cause: The City did not retain documentation of a review and approval of federal reports submitted. Effect: The City did not have appropriate controls in place over documentation of reporting requirements. Questioned Costs: None reported. Recommendation: We recommend the City strengthen its policies and procedures over the grant reporting process to ensure controls are properly implemented and working effectively. Views of Responsible Officials: The City agrees with the finding. See Management’s View and Corrective Action Plan included at the end of the report.
Finding 2024-009 – Reporting (Noncompliance) Identification of the Federal Program: Community Program to Improve Minority Health, ALN 93.137, Department of Health and Human Services (Minority Health); Community Development Block Grants, ALN 14.218, Department of Housing and Urban Development (CDBG); Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027, Department of the Treasury (CRF). Criteria: 2 CFR 200.328-330 establish the requirements of nonfederal entities for financial and performance reporting that include timely and accurate reporting. Reporting requirements are unique to each awarding agency and criteria is based on the guidelines and regulations set forth by the funding agency. Each program required quarterly reports to be submitted. Condition: We selected nine reports for the three grant programs tested to test for timely and accurate reporting requirements. The following exceptions were noted: • Minority Health: Two Federal Financial Report (FFR) and two Federal Performance Report (FPR) reports tested; the two FFR reports were not submitted by the due date and one FFR report did not agree or reconcile to the accounting records • CDBG: Two quarterly cash reports and the FY23 Consolidated Annual Performance and Evaluation Report (CAPER) tested; the two cash on hand reports did not have supporting documentation for the amounts reported or documentation that amounts were reconciled to the City's accounting system. One cash report was also filed late. • CRF: Two project and expenditure reports tested; one was not submitted and the other was submitted late. Expenditure information for one subrecipient was underreported by $186,364. Cause: Minority Health FFR reports were not submitted until February 2025, well past the due date. In addition, one FFR was not properly supported. CDBG project profit and loss statements did not tie to the numbers on the reports, the reports were submitted based on the IDIS reports from the HUD site and were not reconciled to the general ledger. CRF subaward amounts reported did not reconcile back to the general ledger. Various reports were filed after the due date. Effect: The City did not submit timely and accurate reports in compliance with federal reporting requirements. Questioned Costs: None reported. Recommendation: The City should ensure responsible personnel have a clear understanding of the reporting guidance. The City should implement policies and procedures to monitor due dates and review all reports prepared by the grants department or its designee to ensure accurate and timely reporting. Views of Responsible Officials: The City agrees with the finding. See Management’s View and Corrective Action Plan included at the end of the report.
Finding 2024-008 – Reporting (Material Weakness) Identification of the Federal Program: Community Program to Improve Minority Health, ALN 93.137, Department of Health and Human Services (Minority Health); Community Development Block Grants, ALN 14.218, Department of Housing and Urban Development (CDBG); Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027, Department of the Treasury (CRF). Criteria: 2 CFR 200.328-330 establish the requirements of nonfederal entities for financial and performance reporting. 2 CFR 200.303 requires nonfederal entities to establish, document and maintain effective internal control over the federal award that provides reasonable assurance that the recipient or subrecipient is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Typical control procedures related to reporting are to verify the filed report is supported by supporting documentation and inspecting filed report and supporting documentation, noting supervisory review of reports performed to assure accuracy and completeness of data and information included in the report. Condition: We selected nine reports for the three grant programs tested to test for controls over reporting requirements. No documentation of review or approval of the reports was available. Cause: The City did not retain documentation of a review and approval of federal reports submitted. Effect: The City did not have appropriate controls in place over documentation of reporting requirements. Questioned Costs: None reported. Recommendation: We recommend the City strengthen its policies and procedures over the grant reporting process to ensure controls are properly implemented and working effectively. Views of Responsible Officials: The City agrees with the finding. See Management’s View and Corrective Action Plan included at the end of the report.
Finding 2024-009 – Reporting (Noncompliance) Identification of the Federal Program: Community Program to Improve Minority Health, ALN 93.137, Department of Health and Human Services (Minority Health); Community Development Block Grants, ALN 14.218, Department of Housing and Urban Development (CDBG); Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027, Department of the Treasury (CRF). Criteria: 2 CFR 200.328-330 establish the requirements of nonfederal entities for financial and performance reporting that include timely and accurate reporting. Reporting requirements are unique to each awarding agency and criteria is based on the guidelines and regulations set forth by the funding agency. Each program required quarterly reports to be submitted. Condition: We selected nine reports for the three grant programs tested to test for timely and accurate reporting requirements. The following exceptions were noted: • Minority Health: Two Federal Financial Report (FFR) and two Federal Performance Report (FPR) reports tested; the two FFR reports were not submitted by the due date and one FFR report did not agree or reconcile to the accounting records • CDBG: Two quarterly cash reports and the FY23 Consolidated Annual Performance and Evaluation Report (CAPER) tested; the two cash on hand reports did not have supporting documentation for the amounts reported or documentation that amounts were reconciled to the City's accounting system. One cash report was also filed late. • CRF: Two project and expenditure reports tested; one was not submitted and the other was submitted late. Expenditure information for one subrecipient was underreported by $186,364. Cause: Minority Health FFR reports were not submitted until February 2025, well past the due date. In addition, one FFR was not properly supported. CDBG project profit and loss statements did not tie to the numbers on the reports, the reports were submitted based on the IDIS reports from the HUD site and were not reconciled to the general ledger. CRF subaward amounts reported did not reconcile back to the general ledger. Various reports were filed after the due date. Effect: The City did not submit timely and accurate reports in compliance with federal reporting requirements. Questioned Costs: None reported. Recommendation: The City should ensure responsible personnel have a clear understanding of the reporting guidance. The City should implement policies and procedures to monitor due dates and review all reports prepared by the grants department or its designee to ensure accurate and timely reporting. Views of Responsible Officials: The City agrees with the finding. See Management’s View and Corrective Action Plan included at the end of the report.
Finding 2024-008 – Reporting (Material Weakness) Identification of the Federal Program: Community Program to Improve Minority Health, ALN 93.137, Department of Health and Human Services (Minority Health); Community Development Block Grants, ALN 14.218, Department of Housing and Urban Development (CDBG); Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027, Department of the Treasury (CRF). Criteria: 2 CFR 200.328-330 establish the requirements of nonfederal entities for financial and performance reporting. 2 CFR 200.303 requires nonfederal entities to establish, document and maintain effective internal control over the federal award that provides reasonable assurance that the recipient or subrecipient is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Typical control procedures related to reporting are to verify the filed report is supported by supporting documentation and inspecting filed report and supporting documentation, noting supervisory review of reports performed to assure accuracy and completeness of data and information included in the report. Condition: We selected nine reports for the three grant programs tested to test for controls over reporting requirements. No documentation of review or approval of the reports was available. Cause: The City did not retain documentation of a review and approval of federal reports submitted. Effect: The City did not have appropriate controls in place over documentation of reporting requirements. Questioned Costs: None reported. Recommendation: We recommend the City strengthen its policies and procedures over the grant reporting process to ensure controls are properly implemented and working effectively. Views of Responsible Officials: The City agrees with the finding. See Management’s View and Corrective Action Plan included at the end of the report.
Finding 2024-009 – Reporting (Noncompliance) Identification of the Federal Program: Community Program to Improve Minority Health, ALN 93.137, Department of Health and Human Services (Minority Health); Community Development Block Grants, ALN 14.218, Department of Housing and Urban Development (CDBG); Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027, Department of the Treasury (CRF). Criteria: 2 CFR 200.328-330 establish the requirements of nonfederal entities for financial and performance reporting that include timely and accurate reporting. Reporting requirements are unique to each awarding agency and criteria is based on the guidelines and regulations set forth by the funding agency. Each program required quarterly reports to be submitted. Condition: We selected nine reports for the three grant programs tested to test for timely and accurate reporting requirements. The following exceptions were noted: • Minority Health: Two Federal Financial Report (FFR) and two Federal Performance Report (FPR) reports tested; the two FFR reports were not submitted by the due date and one FFR report did not agree or reconcile to the accounting records • CDBG: Two quarterly cash reports and the FY23 Consolidated Annual Performance and Evaluation Report (CAPER) tested; the two cash on hand reports did not have supporting documentation for the amounts reported or documentation that amounts were reconciled to the City's accounting system. One cash report was also filed late. • CRF: Two project and expenditure reports tested; one was not submitted and the other was submitted late. Expenditure information for one subrecipient was underreported by $186,364. Cause: Minority Health FFR reports were not submitted until February 2025, well past the due date. In addition, one FFR was not properly supported. CDBG project profit and loss statements did not tie to the numbers on the reports, the reports were submitted based on the IDIS reports from the HUD site and were not reconciled to the general ledger. CRF subaward amounts reported did not reconcile back to the general ledger. Various reports were filed after the due date. Effect: The City did not submit timely and accurate reports in compliance with federal reporting requirements. Questioned Costs: None reported. Recommendation: The City should ensure responsible personnel have a clear understanding of the reporting guidance. The City should implement policies and procedures to monitor due dates and review all reports prepared by the grants department or its designee to ensure accurate and timely reporting. Views of Responsible Officials: The City agrees with the finding. See Management’s View and Corrective Action Plan included at the end of the report.
Finding 2024-008 – Reporting (Material Weakness) Identification of the Federal Program: Community Program to Improve Minority Health, ALN 93.137, Department of Health and Human Services (Minority Health); Community Development Block Grants, ALN 14.218, Department of Housing and Urban Development (CDBG); Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027, Department of the Treasury (CRF). Criteria: 2 CFR 200.328-330 establish the requirements of nonfederal entities for financial and performance reporting. 2 CFR 200.303 requires nonfederal entities to establish, document and maintain effective internal control over the federal award that provides reasonable assurance that the recipient or subrecipient is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Typical control procedures related to reporting are to verify the filed report is supported by supporting documentation and inspecting filed report and supporting documentation, noting supervisory review of reports performed to assure accuracy and completeness of data and information included in the report. Condition: We selected nine reports for the three grant programs tested to test for controls over reporting requirements. No documentation of review or approval of the reports was available. Cause: The City did not retain documentation of a review and approval of federal reports submitted. Effect: The City did not have appropriate controls in place over documentation of reporting requirements. Questioned Costs: None reported. Recommendation: We recommend the City strengthen its policies and procedures over the grant reporting process to ensure controls are properly implemented and working effectively. Views of Responsible Officials: The City agrees with the finding. See Management’s View and Corrective Action Plan included at the end of the report.
Finding 2024-009 – Reporting (Noncompliance) Identification of the Federal Program: Community Program to Improve Minority Health, ALN 93.137, Department of Health and Human Services (Minority Health); Community Development Block Grants, ALN 14.218, Department of Housing and Urban Development (CDBG); Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027, Department of the Treasury (CRF). Criteria: 2 CFR 200.328-330 establish the requirements of nonfederal entities for financial and performance reporting that include timely and accurate reporting. Reporting requirements are unique to each awarding agency and criteria is based on the guidelines and regulations set forth by the funding agency. Each program required quarterly reports to be submitted. Condition: We selected nine reports for the three grant programs tested to test for timely and accurate reporting requirements. The following exceptions were noted: • Minority Health: Two Federal Financial Report (FFR) and two Federal Performance Report (FPR) reports tested; the two FFR reports were not submitted by the due date and one FFR report did not agree or reconcile to the accounting records • CDBG: Two quarterly cash reports and the FY23 Consolidated Annual Performance and Evaluation Report (CAPER) tested; the two cash on hand reports did not have supporting documentation for the amounts reported or documentation that amounts were reconciled to the City's accounting system. One cash report was also filed late. • CRF: Two project and expenditure reports tested; one was not submitted and the other was submitted late. Expenditure information for one subrecipient was underreported by $186,364. Cause: Minority Health FFR reports were not submitted until February 2025, well past the due date. In addition, one FFR was not properly supported. CDBG project profit and loss statements did not tie to the numbers on the reports, the reports were submitted based on the IDIS reports from the HUD site and were not reconciled to the general ledger. CRF subaward amounts reported did not reconcile back to the general ledger. Various reports were filed after the due date. Effect: The City did not submit timely and accurate reports in compliance with federal reporting requirements. Questioned Costs: None reported. Recommendation: The City should ensure responsible personnel have a clear understanding of the reporting guidance. The City should implement policies and procedures to monitor due dates and review all reports prepared by the grants department or its designee to ensure accurate and timely reporting. Views of Responsible Officials: The City agrees with the finding. See Management’s View and Corrective Action Plan included at the end of the report.
Reference Number: 2024-003 L. Reporting Compliance Requirement ALN 21.027 Coronavirus State and Local Fiscal Recovery Fund Federal Award Agreement Number: 17460025442 Award Year: 2023-2024 Federal Agency: U.S. Department of Treasury Criteria: Non-federal entities are required to establish and maintain effective internal controls over compliance in accordance with 2 CFR 200.328 and 31 CFR section 35.4 (c), states metropolitan cities and counties with a population below 250,000 residents that are allocated more than $10 million in SLFRF funding are required to submit quarterly Project and Expenditure Reports. Condition Found: During our review of the quarterly reporting process, CRI identified two quarterly reports that did not reflect current quarterly activity and no documentation was maintained to support evidence that the report was reviewed. Cause: Documentation of review and accurate submission regarding Q1 and Q2 2024 project and expenditure reports were not maintained. Effect: The Department of Treasury uses the reports internally for oversight purposes and to fulfill Treasury’s transparency and legal obligations. The results of the City not correctly submitting a report timely could lead to a finding of non-compliance, which could result in development of corrective action plan or other consequences. Questioned Cost: $0 Recommendation: We recommend the City to document and maintain all proper controls and review of all quarterly reports that are submitted through the portal to ensure complete and accurate reports. Views of Responsible Officials: Management agrees with the findings. See corrective action plan beginning on page 230.
Criteria: 2 CFR Section 200.328 requires that the non-federal entity must submit the Federal Financial Report (SF-425) no later than 30 days after the end of a quarterly or semiannually reporting period (or 90 days for annual reporting periods). Condition and context: During testing of the Alliance’s compliance over reporting, we identified the Alliance did not submit the SF-425 forms timely during the year ended September 30, 2024. Cause: The Alliance’s controls and processes were not effectively designed to ensure all reporting requirements are executed timely. Effect: The Alliance was not fully in compliance with the reporting requirements of the Uniform Guidance. Questioned Costs: None. Identification as a Repeat Finding: N/A. Recommendation: We recommend that the Alliance implement internal controls such as a compliance calendar and designated review procedures to ensure that all federal reporting requirements, including SF-425 filings, are completed accurately and on time. Views of Responsible Official: Management agrees with the finding. See Corrective Action Plan.
Finding 2024-001: Preparation of Schedule of Expenditures of Federal Awards (SEFA) Program Name: Multiple federal programs Criteria 1. The code of federal regulations – 2 CFR 200.302 Financial management requires that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State’s funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient’s and subrecipient’s financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in § 200.328 and § 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. 2. The code of federal regulations – 2 CFR 200.303 Internal controls requires that recipients and subrecipients must: (a) Establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should align with the guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control-Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). (b) Comply with the U.S. Constitution, Federal statutes, regulations, and the terms and conditions of the Federal award. (c) Evaluate and monitor the recipient’s or subrecipient’s compliance with statutes, regulations, and the terms and conditions of Federal awards. (d) Take prompt action when instances of noncompliance are identified. Condition The following exceptions to the criteria were observed during the performance of the audit procedures: 1. After the completion of internal review and approval process that Amtrak has established for SEFA preparation and review, we have received multiple updated versions of the schedule with changes to FY24 expenditure amounts for three Assistance Listings included on the SEFA. Total expenditures increased by $80.2 million from version 1 to the final version received. 2. The starting point of the SEFA preparation for the current year was not the audited FY23 SEFA submitted to Federal Audit Clearinghouse, as we have identified that Amtrak subsequently made changes to the FY23 internal SEFA document without reconciling the changes to the audited FY23 SEFA, which resulted in the total cumulative expenditures as of 9/30/2023 to be updated and as such impacting the FY24 expenditures for the respective federal programs. One of the adjustments related to the Hudson Yards Concrete Casing project (HYCC-3) which initially incorrectly recorded $25.0 million of prepaid expenditures. 3. As Assistance Listing #20.314 has been obligated as of 9/27/2024, Amtrak has recorded expenditures related to the HYCC-3 project under this program for the established pre-award period, which dated from January 30, 2023 as part of the FY24 expenditures. Previously, a portion of the total expenditures was included within the FY23 SEFA under Assistance Listing #20.315, for the total amount of $15.6 million. This amount was not adjusted out of the cumulative expenditures for Assistance Listing #20.315 until 2025. Consequently, these expenditures were listed both within the FY23 SEFA under Assistance Listing #20.315 and under the FY24 SEFA as Assistance Listing #20.314 expenditures. 4. As part of SEFA preparation as it relates to allocation of operating expenditures across multiple funding sources, certain projects were incorrectly mapped to annual grants funding source, which resulted in approximately $0.3 million of operating expenses to be included within Assistance Listing #20.315 that were also reported under Assistance Listing #97.075. Cause Amtrak’s control procedures in place as it relates to the preparation of the SEFA were not operating in a manner that would timely identify the conditions noted. Additionally, Amtrak’s controls around allocation of federal funding to project codes were not designed in a manner that would timely identify the conditions noted. In reviewing management’s controls around the SEFA preparation, the design of key controls identified by management does not include an overarching review of the SEFA and reconciliation of what’s been reported on the SEFA from individual projects’ standpoint when such projects have multiple assistance listings as funding sources. We also noted that there was not a specific control that ensures timely updates of Work Breakdown Structure (WBS) funding assignments and allocations when there is a change such as a new grant agreement signed. Effect Amtrak’s control procedures in place as it relates to the preparation of the SEFA were not designed in such a manner that would timely identify the conditions noted, which resulted in several versions of the SEFA that were erroneous and inclusion of expenditures that were double counted within the SEFA. This puts Amtrak at greater risk of non-compliance with its grant agreements with respect to questioned costs and an inaccurate SEFA. Questioned Costs None. Context The SEFA, as originally provided, had exceptions as described in the Condition section above noted for matters 1 and 2 in the Criteria section above, indicating that certain internal controls were not functioning as designed and others were not designed effectively. Identification as a Repeat Finding Not a repeat finding. Recommendation We recommend Amtrak to strengthen the SEFA oversight process to ensure appropriate preparation and review of the SEFA to validate its accuracy, including reconciliation with prior year audited SEFA. This should include having one reviewer take overall responsibility for the completeness and accuracy of the final submitted SEFA. This robust review process should include appropriate procedures to confirm accuracy of the SEFA, which may include a protocol where representatives from various groups (both discretionary and non-discretionary federal programs) work collaboratively to review the SEFA and underlying details of expenditures, to ensure all the adjustments have been properly reflected as well as any projects that might have multiple fund sources are identified timely and reviewed for appropriate inclusion within the SEFA. Additionally, Amtrak should establish a process where any modifications of WBS funding assignments and allocations are updated in a timely manner. Views of Responsible Officials Amtrak recognizes the need to improve the preparation and review of the SEFA. The company has documented the steps for preparing and reviewing the SEFA within its process narrative. The company will update the narrative to address the preparation and review issues that led to the multiple versions of the SEFA being provided during the audit. The company will review and update the Grants Management Compliance Narrative and controls to improve timing of updates for modifications of WBS funding assignments. The company is in the process of updating the SEFA preparation documentation for FY2025, which will be used at the end of the year. The review procedures and controls are being enhanced to include a checklist to improve the review.
Finding 2024-001: Preparation of Schedule of Expenditures of Federal Awards (SEFA) Program Name: Multiple federal programs Criteria 1. The code of federal regulations – 2 CFR 200.302 Financial management requires that: (a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State’s funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The recipient’s and subrecipient’s financial management system must provide for the following: (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in § 200.328 and § 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. 2. The code of federal regulations – 2 CFR 200.303 Internal controls requires that recipients and subrecipients must: (a) Establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should align with the guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control-Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). (b) Comply with the U.S. Constitution, Federal statutes, regulations, and the terms and conditions of the Federal award. (c) Evaluate and monitor the recipient’s or subrecipient’s compliance with statutes, regulations, and the terms and conditions of Federal awards. (d) Take prompt action when instances of noncompliance are identified. Condition The following exceptions to the criteria were observed during the performance of the audit procedures: 1. After the completion of internal review and approval process that Amtrak has established for SEFA preparation and review, we have received multiple updated versions of the schedule with changes to FY24 expenditure amounts for three Assistance Listings included on the SEFA. Total expenditures increased by $80.2 million from version 1 to the final version received. 2. The starting point of the SEFA preparation for the current year was not the audited FY23 SEFA submitted to Federal Audit Clearinghouse, as we have identified that Amtrak subsequently made changes to the FY23 internal SEFA document without reconciling the changes to the audited FY23 SEFA, which resulted in the total cumulative expenditures as of 9/30/2023 to be updated and as such impacting the FY24 expenditures for the respective federal programs. One of the adjustments related to the Hudson Yards Concrete Casing project (HYCC-3) which initially incorrectly recorded $25.0 million of prepaid expenditures. 3. As Assistance Listing #20.314 has been obligated as of 9/27/2024, Amtrak has recorded expenditures related to the HYCC-3 project under this program for the established pre-award period, which dated from January 30, 2023 as part of the FY24 expenditures. Previously, a portion of the total expenditures was included within the FY23 SEFA under Assistance Listing #20.315, for the total amount of $15.6 million. This amount was not adjusted out of the cumulative expenditures for Assistance Listing #20.315 until 2025. Consequently, these expenditures were listed both within the FY23 SEFA under Assistance Listing #20.315 and under the FY24 SEFA as Assistance Listing #20.314 expenditures. 4. As part of SEFA preparation as it relates to allocation of operating expenditures across multiple funding sources, certain projects were incorrectly mapped to annual grants funding source, which resulted in approximately $0.3 million of operating expenses to be included within Assistance Listing #20.315 that were also reported under Assistance Listing #97.075. Cause Amtrak’s control procedures in place as it relates to the preparation of the SEFA were not operating in a manner that would timely identify the conditions noted. Additionally, Amtrak’s controls around allocation of federal funding to project codes were not designed in a manner that would timely identify the conditions noted. In reviewing management’s controls around the SEFA preparation, the design of key controls identified by management does not include an overarching review of the SEFA and reconciliation of what’s been reported on the SEFA from individual projects’ standpoint when such projects have multiple assistance listings as funding sources. We also noted that there was not a specific control that ensures timely updates of Work Breakdown Structure (WBS) funding assignments and allocations when there is a change such as a new grant agreement signed. Effect Amtrak’s control procedures in place as it relates to the preparation of the SEFA were not designed in such a manner that would timely identify the conditions noted, which resulted in several versions of the SEFA that were erroneous and inclusion of expenditures that were double counted within the SEFA. This puts Amtrak at greater risk of non-compliance with its grant agreements with respect to questioned costs and an inaccurate SEFA. Questioned Costs None. Context The SEFA, as originally provided, had exceptions as described in the Condition section above noted for matters 1 and 2 in the Criteria section above, indicating that certain internal controls were not functioning as designed and others were not designed effectively. Identification as a Repeat Finding Not a repeat finding. Recommendation We recommend Amtrak to strengthen the SEFA oversight process to ensure appropriate preparation and review of the SEFA to validate its accuracy, including reconciliation with prior year audited SEFA. This should include having one reviewer take overall responsibility for the completeness and accuracy of the final submitted SEFA. This robust review process should include appropriate procedures to confirm accuracy of the SEFA, which may include a protocol where representatives from various groups (both discretionary and non-discretionary federal programs) work collaboratively to review the SEFA and underlying details of expenditures, to ensure all the adjustments have been properly reflected as well as any projects that might have multiple fund sources are identified timely and reviewed for appropriate inclusion within the SEFA. Additionally, Amtrak should establish a process where any modifications of WBS funding assignments and allocations are updated in a timely manner. Views of Responsible Officials Amtrak recognizes the need to improve the preparation and review of the SEFA. The company has documented the steps for preparing and reviewing the SEFA within its process narrative. The company will update the narrative to address the preparation and review issues that led to the multiple versions of the SEFA being provided during the audit. The company will review and update the Grants Management Compliance Narrative and controls to improve timing of updates for modifications of WBS funding assignments. The company is in the process of updating the SEFA preparation documentation for FY2025, which will be used at the end of the year. The review procedures and controls are being enhanced to include a checklist to improve the review.
2024-002 - Late Submission of Reports Finding Type. Immaterial Noncompliance; Significant Deficiency over Compliance (Reporting). Program. VA Supportive Services for Veteran Families Program; Department of Veterans Affairs, Assistance Listing Number 64.033; All Award Numbers. Criteria. Per 2 CFR Part 200.328 (c), the recipient or subrecipient must submit financial reports as required by the federal award. Timely submission of these reports is essential for compliance with the terms and conditions of the federal award. Condition. The Agency failed to submit the required report for the federal grant within the stipulated deadlines as outlined in the grant agreement and Uniform Guidance. During reporting testing, it was noted that the Final FFR report was not submitted into the Payment Management Services (PMS) prior to the required due date. Cause. The delay in reporting was due to inadequate internal controls over the grant management process, including insufficient staffing and lack of proper training for personnel responsible for preparing and submitting the reports. Processes in place were not sufficient to prevent the report from being submitted late. Effect. Late submission of reports results in noncompliance with federal regulations, potentially leading to administrative actions such as withholding of future grant funds, increased monitoring, or other penalties as deemed appropriate by the Federal awarding agency. The Agency did not comply with contractual reporting requirements. Questioned Costs. No costs are required to be questioned as a result of this finding, inasmuch as no unallowable expenditures were noted. Recommendation. We recommend the Agency implement procedures to ensure timely submission of all required reports. View of Responsible Official. Management agrees with this finding and has prepared a Corrective Action Plan.
2024-002 - Late Submission of Reports Finding Type. Immaterial Noncompliance; Significant Deficiency over Compliance (Reporting). Program. VA Supportive Services for Veteran Families Program; Department of Veterans Affairs, Assistance Listing Number 64.033; All Award Numbers. Criteria. Per 2 CFR Part 200.328 (c), the recipient or subrecipient must submit financial reports as required by the federal award. Timely submission of these reports is essential for compliance with the terms and conditions of the federal award. Condition. The Agency failed to submit the required report for the federal grant within the stipulated deadlines as outlined in the grant agreement and Uniform Guidance. During reporting testing, it was noted that the Final FFR report was not submitted into the Payment Management Services (PMS) prior to the required due date. Cause. The delay in reporting was due to inadequate internal controls over the grant management process, including insufficient staffing and lack of proper training for personnel responsible for preparing and submitting the reports. Processes in place were not sufficient to prevent the report from being submitted late. Effect. Late submission of reports results in noncompliance with federal regulations, potentially leading to administrative actions such as withholding of future grant funds, increased monitoring, or other penalties as deemed appropriate by the Federal awarding agency. The Agency did not comply with contractual reporting requirements. Questioned Costs. No costs are required to be questioned as a result of this finding, inasmuch as no unallowable expenditures were noted. Recommendation. We recommend the Agency implement procedures to ensure timely submission of all required reports. View of Responsible Official. Management agrees with this finding and has prepared a Corrective Action Plan.
2024-002 - Late Submission of Reports Finding Type. Immaterial Noncompliance; Significant Deficiency over Compliance (Reporting). Program. VA Supportive Services for Veteran Families Program; Department of Veterans Affairs, Assistance Listing Number 64.033; All Award Numbers. Criteria. Per 2 CFR Part 200.328 (c), the recipient or subrecipient must submit financial reports as required by the federal award. Timely submission of these reports is essential for compliance with the terms and conditions of the federal award. Condition. The Agency failed to submit the required report for the federal grant within the stipulated deadlines as outlined in the grant agreement and Uniform Guidance. During reporting testing, it was noted that the Final FFR report was not submitted into the Payment Management Services (PMS) prior to the required due date. Cause. The delay in reporting was due to inadequate internal controls over the grant management process, including insufficient staffing and lack of proper training for personnel responsible for preparing and submitting the reports. Processes in place were not sufficient to prevent the report from being submitted late. Effect. Late submission of reports results in noncompliance with federal regulations, potentially leading to administrative actions such as withholding of future grant funds, increased monitoring, or other penalties as deemed appropriate by the Federal awarding agency. The Agency did not comply with contractual reporting requirements. Questioned Costs. No costs are required to be questioned as a result of this finding, inasmuch as no unallowable expenditures were noted. Recommendation. We recommend the Agency implement procedures to ensure timely submission of all required reports. View of Responsible Official. Management agrees with this finding and has prepared a Corrective Action Plan.
Criteria: Per Title 2 CFR § 200.328, the recipient must submit annual financial reports no later than 90 calendar days after the reporting period, and semi-annual reports no later than 30 days after the reporting period. Condition: The semi-annual SF-425 financial report was not submitted timely. Cause: The semi-annual SF-425 financial report was not submitted within the 30-day timeframe as required by the Head Start Grant Program. Effect or Potential Effect: Late submissions resulted in non-compliance with reporting requirements and could result in loss or reduction of funding for the program. Context: The semi-annual SF-425 financial report was not filed within 30-days of period end as required in the grant agreement. Recommendation: We recommend that the Organization implement procedure to ensure compliance with filing requirements. Views of Management: Management acknowledges the lapse in regularly meeting the grant requirement of submitting financial reports within the specified 30-day period. To address this issue, the Organization has initiated a comprehensive procedural shift.
Criteria or Specific Requirements: In accordance with 2 CFR §170, prime awardees awarded a federal grant are required to file a Federal Funding Accountability and Transparency Act (FFATA) sub-award report by the end of the month following the month in which the prime awardee awards any sub-grant equal to or greater than $30,000. Further, the Organization is subject to reporting requirements for both financial and progress reporting. In accordance with 2 CFR §200.328, Federal Financial Reports (FFR) should be submitted based on frequency required by the terms and conditions. Under grant agreements, program 10.761 and 66.446 require both financial and performance reports to be submitted quarterly within 12 days after quarter-end, while ALN program 93.570 requires semiannual financial and performance reports within 30 days after period-end. Condition: During the review of reporting compliance for the major programs, it was determined that the Organization did not file the FFATA report for program 93.570 within the required 30-day period, and did not submit quarterly financial reports for program 10.761 within the required 12-day deadline after quarter-end. Cause: Internal controls over financial reporting were not operating effectively to file the FFATA report a timely manner. Management was not aware of the FFATA requirements for prime awards. Further, internal controls over financial reporting were not operating effectively to file financial reports in a timely manner. Effect: Failure to submit the FFATA report by the end of the month following award of a subgrant over $30,000 results in noncompliance with 2 CFR § 170. Additionally, failure to submit quarterly financial reports for program 10.761 within the required deadline constitutes noncompliance with the Federal Financial Reporting requirement under 2 CFR § 200.328. Questioned Costs: Questioned costs were not identified. Perspective information: It is noted that the Organization has not established policies and procedures that will ensure that FFATA reports are submitted within the required timeline and therefore one out of one samples tested for this compliance requirement were not completed. Further, for program 10.761 quarterly financial reports, one out of two samples tested – drawn from a population of 10 – was not submitted within the required 12-day time frame. Noncompliance surrounding reporting was identified for the following awards during the fiscal 2024: Federal Agency Pass-Through Entity ALN Federal Award Name Award Year Department of Health and Human Services Direct 93.570 HHS RCD 9/30/2023 – 9/29/2024 United States Department of Agriculture Rural Community Assistance Partnership Inc. 10.761 Technitrain 2023 – 2024 9/1/2023 – 9/30/2026 United States Department of Agriculture Rural Community Assistance Partnership Inc. 10.761 Tribal 2023 - 2024 9/1/2023 – 9/30/2026 Repeat Finding: Yes – Repeat of FY 2024 Finding 2023-005. Recommendations: We recommend that management and relevant staff participate in comprehensive training on federal grant compliance—emphasizing FFATA obligations and financial reporting deadlines—to ensure a clear understanding of requirements. Management should then formalize and document procedures for FFATA reporting, including a calendar-driven workflow with designated preparers and approvers, mandatory sign-off checklists, and automated reminders. Finally, the Organization should implement a centralized reporting-tracking system that monitors all federal award deadlines and captures evidence of timely preparation, review, and submission for both financial and performance reports.
Criteria or Specific Requirements: In accordance with 2 CFR §170, prime awardees awarded a federal grant are required to file a Federal Funding Accountability and Transparency Act (FFATA) sub-award report by the end of the month following the month in which the prime awardee awards any sub-grant equal to or greater than $30,000. Further, the Organization is subject to reporting requirements for both financial and progress reporting. In accordance with 2 CFR §200.328, Federal Financial Reports (FFR) should be submitted based on frequency required by the terms and conditions. Under grant agreements, program 10.761 and 66.446 require both financial and performance reports to be submitted quarterly within 12 days after quarter-end, while ALN program 93.570 requires semiannual financial and performance reports within 30 days after period-end. Condition: During the review of reporting compliance for the major programs, it was determined that the Organization did not file the FFATA report for program 93.570 within the required 30-day period, and did not submit quarterly financial reports for program 10.761 within the required 12-day deadline after quarter-end. Cause: Internal controls over financial reporting were not operating effectively to file the FFATA report a timely manner. Management was not aware of the FFATA requirements for prime awards. Further, internal controls over financial reporting were not operating effectively to file financial reports in a timely manner. Effect: Failure to submit the FFATA report by the end of the month following award of a subgrant over $30,000 results in noncompliance with 2 CFR § 170. Additionally, failure to submit quarterly financial reports for program 10.761 within the required deadline constitutes noncompliance with the Federal Financial Reporting requirement under 2 CFR § 200.328. Questioned Costs: Questioned costs were not identified. Perspective information: It is noted that the Organization has not established policies and procedures that will ensure that FFATA reports are submitted within the required timeline and therefore one out of one samples tested for this compliance requirement were not completed. Further, for program 10.761 quarterly financial reports, one out of two samples tested – drawn from a population of 10 – was not submitted within the required 12-day time frame. Noncompliance surrounding reporting was identified for the following awards during the fiscal 2024: Federal Agency Pass-Through Entity ALN Federal Award Name Award Year Department of Health and Human Services Direct 93.570 HHS RCD 9/30/2023 – 9/29/2024 United States Department of Agriculture Rural Community Assistance Partnership Inc. 10.761 Technitrain 2023 – 2024 9/1/2023 – 9/30/2026 United States Department of Agriculture Rural Community Assistance Partnership Inc. 10.761 Tribal 2023 - 2024 9/1/2023 – 9/30/2026 Repeat Finding: Yes – Repeat of FY 2024 Finding 2023-005. Recommendations: We recommend that management and relevant staff participate in comprehensive training on federal grant compliance—emphasizing FFATA obligations and financial reporting deadlines—to ensure a clear understanding of requirements. Management should then formalize and document procedures for FFATA reporting, including a calendar-driven workflow with designated preparers and approvers, mandatory sign-off checklists, and automated reminders. Finally, the Organization should implement a centralized reporting-tracking system that monitors all federal award deadlines and captures evidence of timely preparation, review, and submission for both financial and performance reports.
Criteria or Specific Requirements: In accordance with 2 CFR §170, prime awardees awarded a federal grant are required to file a Federal Funding Accountability and Transparency Act (FFATA) sub-award report by the end of the month following the month in which the prime awardee awards any sub-grant equal to or greater than $30,000. Further, the Organization is subject to reporting requirements for both financial and progress reporting. In accordance with 2 CFR §200.328, Federal Financial Reports (FFR) should be submitted based on frequency required by the terms and conditions. Under grant agreements, program 10.761 and 66.446 require both financial and performance reports to be submitted quarterly within 12 days after quarter-end, while ALN program 93.570 requires semiannual financial and performance reports within 30 days after period-end. Condition: During the review of reporting compliance for the major programs, it was determined that the Organization did not file the FFATA report for program 93.570 within the required 30-day period, and did not submit quarterly financial reports for program 10.761 within the required 12-day deadline after quarter-end. Cause: Internal controls over financial reporting were not operating effectively to file the FFATA report a timely manner. Management was not aware of the FFATA requirements for prime awards. Further, internal controls over financial reporting were not operating effectively to file financial reports in a timely manner. Effect: Failure to submit the FFATA report by the end of the month following award of a subgrant over $30,000 results in noncompliance with 2 CFR § 170. Additionally, failure to submit quarterly financial reports for program 10.761 within the required deadline constitutes noncompliance with the Federal Financial Reporting requirement under 2 CFR § 200.328. Questioned Costs: Questioned costs were not identified. Perspective information: It is noted that the Organization has not established policies and procedures that will ensure that FFATA reports are submitted within the required timeline and therefore one out of one samples tested for this compliance requirement were not completed. Further, for program 10.761 quarterly financial reports, one out of two samples tested – drawn from a population of 10 – was not submitted within the required 12-day time frame. Noncompliance surrounding reporting was identified for the following awards during the fiscal 2024: Federal Agency Pass-Through Entity ALN Federal Award Name Award Year Department of Health and Human Services Direct 93.570 HHS RCD 9/30/2023 – 9/29/2024 United States Department of Agriculture Rural Community Assistance Partnership Inc. 10.761 Technitrain 2023 – 2024 9/1/2023 – 9/30/2026 United States Department of Agriculture Rural Community Assistance Partnership Inc. 10.761 Tribal 2023 - 2024 9/1/2023 – 9/30/2026 Repeat Finding: Yes – Repeat of FY 2024 Finding 2023-005. Recommendations: We recommend that management and relevant staff participate in comprehensive training on federal grant compliance—emphasizing FFATA obligations and financial reporting deadlines—to ensure a clear understanding of requirements. Management should then formalize and document procedures for FFATA reporting, including a calendar-driven workflow with designated preparers and approvers, mandatory sign-off checklists, and automated reminders. Finally, the Organization should implement a centralized reporting-tracking system that monitors all federal award deadlines and captures evidence of timely preparation, review, and submission for both financial and performance reports.
Finding 2024-005 – REPORTING (repeat finding) Type: Material Weakness in Internal Control/Noncompliance. Program: ALN 93.493 Congressional Directives Grant Name: Access to Behavioral Crisis Services Grantor Number: FG-22-099 Criteria: Pursuant to 2 CFR 200.328(c), “The recipient or subrecipient must submit financial reports as required by the Federal award.” According to the closeout requirements of the Federal award, recipients must, “Reconcile financial expenditures to the reported total disbursement and charges in PMS.” Condition: The CMHSP did not file the required annual Federal Financial Report as required for this grant. Cause: This condition was caused by an insufficient internal control process for grant reporting. Effect: Reporting requirements required by the grant were not met. Questioned Cost: None. Context: Amounts received as Federal reimbursement, as detailed in PMS, were supported by the CMHSP’s internal records. However, the final report of expenses was never submitted. Recommendation: We recommend that the CMHSP review their internal controls and make necessary changes to ensure that reports are filed in accordance with the grant requirements. Management’s Resp: We are in agreement with this finding.
Condition: In accordance with 2 CFR-200.328 and 2 CFR-200.303, non-federal entities must submit performance and financial reports as required by the awarding agency and must establish and maintain effective internal control over compliance with federal statutes, regulations, and the terms and conditions of the federal award. Context: The City is required to submit monthly progress reports ten calendar days after the end of each month, quarterly progress reports no later than the 10th of quarter end, and a bi-annual Contract and Subcontract Activity form (HUD-2516), to be submitted by April 15 and October 15 each year. Per testing, monthly and quarterly reports were submitted 10 to 27 days after the deadline. ABPA was unable to obtain evidence that form HUD-2516 was submitted by either of the required due dates. Effect: Failure to submit required reports in a timely manner, and the lack of supporting documentation, represents a deficiency in internal control over compliance. This increases the risk of noncompliance with federal reporting requirements, which could result in questioned costs, delayed reimbursements, or jeopardize future funding. Cause: Delays in report submission were primarily due to insufficient internal controls over the reporting process, lack of clear assignment of responsibilities, and inadequate monitoring of reporting deadlines. Questioned costs: None. Recommendation: We recommend that the City strengthen its internal controls over compliance by implementing a centralized reporting calendar or system to monitor federal reporting deadlines. In addition, procedures should be established to ensure that documentation of timely report submission is retained in the grant files. Staff responsible for grant administration should also receive training on federal reporting requirements.
Finding 2024-001 – REPORTING Type: Significant Deficiency in Internal Control/Noncompliance Program: ALN 93.788 Opioid STR Grant Name: State Opioid Response - SOR 3 Criteria: Pursuant to 2 CFR 200.328(c), “The recipient or subrecipient must submit financial reports as required by the Federal award.” According to the reporting requirements of the Federal award, recipients must, “Submit Monthly reports on the number of individuals assisted and followed up by the Recovery Coaches by the 7th of the month to the SOR 3 Grant coordinator.” Condition: The CMHSP did not file the required report within the 7th of the month as required for this grant. Cause: This condition was caused by an insufficient internal control process for grant reporting. Effect: Reporting requirements required by the grant were not met. Questioned Cost: None. Context: One of two monthly reports selected for testing was not submitted timely. Recommendation: We recommend that the CMHSP review their internal controls and make necessary changes to ensure that reports are filed in accordance with the grant requirements. Management’s Resp: We are in agreement with this finding.
SCHEDULE OF FINDINGS AND QUESTIONED COSTS AND CORRECTIVE ACTION PLAN Federal Award Finding September 30, 2024 Comment #2024-002 Repeat Comment #2023-001 AND #2022-001 INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED LIHEAP FALN 93.568 (Questioned Costs - Undetermined) Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards states in summary, that management should authorize, process, reconcile and close-out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The close-out process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff does not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to properly present the financial statements and disclosures of the Council as of September 30, 2024. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, reports to various funding sources, etc.) Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner. The systemic cause appears to be the untimely termination of key personnel and a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR §200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §200.328 Financial reporting and 200.329 Monitoring and reporting program performance [2 CFR §200.302(b)(2)]. SCHEDULE OF FINDINGS AND QUESTIONED COSTS AND CORRECTIVE ACTION PLAN Federal Award Finding September 30, 2024 Comment #2024-002 Repeat Comment #2023-001 AND #2022-001 INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED LIHEAP FALN 93.568 (Questioned Costs - Undetermined) (Continued) Effect: Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff and limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency is determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Council has hired a new fiscal officer and should hire additional staff (grant accountant and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. The Board of Directors should be adequately trained in the areas of understanding risk assessment and financial awareness in the community action industry. A finance and audit committee should be established and trained in understanding and oversight of financial reporting responsibilities of community action associations. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant’s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statements close-out process is achieved each month and annually. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the Council’s financial funding sources, the Council will provide additional training to support the new fiscal officer. The fiscal officer will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst’s basic responsibilities. All enhancements will be implemented by July 31, 2025.
Finding 2024-002: Insufficient Documentation of Management Review of Section 3 Quarterly and Annual Reporting Audit Finding: Significant Deficiency Federal Program: Community Development Block Grant Mitigation Program Citywide Drainage Improvements (Assistance Listing 14.228) Compliance Requirement: Reporting and Special Tests and Provisions – Section 3 Requirements Criteria: In accordance with Title 2 of the Code of Federal Regulations (2 CFR) § 200.303, the City must establish and maintain effective internal controls over federal awards that provide reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of the award. Additionally, 2 CFR § 200.328 requires the City to ensure that reports submitted to the pass-through entity are accurate, complete, and supported by adequate review and oversight. The U.S. Department of Housing and Urban Development’s (HUD) Section 3 regulations at 24 CFR Part 75 require recipients to prepare and submit quarterly and cumulative annual Section 3 reports documenting efforts to provide employment, training, and contracting opportunities to low- and moderate-income persons and businesses within the project area. Condition: The City’s grant administrator is responsible for preparing and submitting the required quarterly and annual Section 3 reports to the Texas General Land Office on behalf of the City. However, there is no documentation demonstrating that City management reviews or approves these reports prior to and after submission. Cause: The City has not established procedures requiring City management to review and document approval of the Section 3 reports prepared and submitted to the Texas General Land Office. Effect: Without documentation of City management review and approval of the Section 3 reports prepared and submitted by the grant administrator, there is an increased risk that reports submitted to the passthrough entity may be inaccurate, incomplete, or not fully compliant with federal reporting requirements. Questioned Costs: None noted. Recommendation: The City should strengthen internal controls over federal reporting by establishing and documenting procedures to ensure City management reviews and approves all Section 3 reports prepared and submitted by the grant administrator. Evidence of this review, such as sign-offs or approval correspondence, should be retained in the grant files to demonstrate compliance with Uniform Guidance and HUD Section 3 reporting requirements. View of Responsible Officials: Management concurs with the recommendation. Please refer to the Corrective Action Plan for additional details.
Federal Program: Community Development Block Grants – Non Entitlement (Assistance Listing 14.228) Criteria: In accordance with Title 2 of the Code of Federal Regulations (2 CFR) § 200.303, the City must establish and maintain effective internal controls over federal awards that provide reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of the award. Additionally, 2 CFR § 200.328 requires the City to ensure that reports submitted to the pass-through entity are accurate, complete, and supported by adequate review and oversight. The U.S. Department of Housing and Urban Development’s (HUD) Section 3 regulations at 24 CFR Part 75 require recipients to prepare and submit quarterly and cumulative annual Section 3 reports documenting efforts to provide employment, training, and contracting opportunities to low- and moderate-income persons and businesses within the project area. Condition: During single audit testing for reporting, it was noted that management could not provide documentation for review of performance and Section 3 reports for the Community Development Block Grant – State’s Program grant. The grant administrator performs and submits all required reports. Cause: The City has not established procedures requiring City management to review and document approval of the Section 3 reports prepared and submitted to the Texas General Land Office. Effect or Potential Effect: The absence of documented reviews increases the risk that errors or irregularities in financial reporting or compliance with federal program requirements may not be detected and corrected in a timely manner. Recommendations: The City should strengthen internal controls over federal reporting by establishing and documenting procedures to ensure City management reviews and approves all Section 3 reports prepared and submitted by the grant administrator. Evidence of this review, such as sign-offs or approval correspondence, should be retained in the grant files to demonstrate compliance with Uniform Guidance and HUD Section 3 reporting requirements. Repeat Finding: No Views of Responsible Officials: See Corrective Action Plan.
2024-044 - Untimely Submission of Required Performance Reports Federal Programs 23.002 - Appalachian Area Development (ARC) Award Numbers ARC MS-20698 ARC MS~20699 Federal Agency Appalachian Regional Commission (ARC) Compliance Requirement Reporting - 2 CFR §200.328 and §200.303 Type of Finding Internal Control over Compliance - Significant Deficiency Compliance - Noncompliance Questioned Costs None. The reporting noncompliance did not affect the allowability of costs charged to the grant. Criteria 2 CFR §200.328(b)(1) requires recipients to submit performance reports at intervals required by the federal awarding agency or pass-through entity. These reports must contain a comparison of actual accomplishments to the objectives of the award and be submitted in accordance with the terms and conditions of the grant. 2 CFR §200.303 requires recipients to establish and maintain effective internal controls over federal awards to ensure compliance with federal statutes, regulations, and the terms and conditions of the award. This includes controls over timely and accurate reporting. Under the ARC grant agreements, semi-annual performance reports are required to be submitted within 15 days following the end of each six-month reporting period. Condition The City did not submit required semi-annual performance reports for ARC grants MS-20698 and MS-20699 within the timeframes established by the grant agreements. Reports were submitted significantly past the 15-day deadline following the end of each six-month reporting period. In some cases, multiple reports were submitted on the same day, and one report due during the audit period had not been filed as of fieldwork completion. Additionally, the reports lacked clear identification of the reporting period covered. Cause The City did not have adequate procedures in place to ensure timely tracking and submission of required performance reports. Internal controls over reporting deadlines were not operating effectively. Effect Failure to submit timely and complete performance reports limits the pass-through entity's and federal awarding agency's ability to monitor project progress and ensure compliance with grant terms. This represents noncompliance with federal reporting requirements and a deficiency in internal control over federal programs. Recommendation We recommend the City implement procedures to ensure timely submission of required performance reports, including: Maintaining a reporting calendar with automated reminders Assigning responsibility for monitoring deadlines Retaining documentation that clearly identifies the reporting period covered Views of Responsible Officials Management concurs with the finding. The City acknowledges that performance reports were submitted late and that documentation lacked clarity regarding the reporting periods. To address this, the City will implement a reporting calendar with automated reminders and assign staff responsibility for monitoring deadlines. A standardized reporting template will be adopted to ensure each submission clearly identifies the reporting period covered. These measures will strengthen internal controls and improve compliance with ARC reporting requirements.
Reporting – Financial Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Aging Cluster ALN: 93.044 93.045 93.053 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXOACM 10/1/2021 – 9/30/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR 200.303(a), Health and Human Services Commission (HHSC) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that it is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of six SF-425 reports submitted during the fiscal year. For the March 31, 2024, report for the 2201TXOACM award, audit procedures included comparing the reported amounts to the general ledger. We noted the following variances: See chart or table in the Schedule of Findings and Questioned Costs. Questioned costs: None. Context: See “Condition.” Cause: Amounts in the supporting general ledger documentation were accurate. However, the corresponding line items on the SF-425 report were not reported accurately. Management did not revise the March 31, 2024, report as the report is cumulative and the final report for the 2201TXOACM grant will include the corrected amounts. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No. Recommendation: We recommend management reconcile all amounts reported on the SF-425 reports to the general ledger or other supporting documentation to ensure completeness and accuracy prior to submission. Views of responsible officials: HHSC concurs with the finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Aging Cluster ALN: 93.044 93.045 93.053 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXOACM 10/1/2021 – 9/30/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR 200.303(a), Health and Human Services Commission (HHSC) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that it is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of six SF-425 reports submitted during the fiscal year. For the March 31, 2024, report for the 2201TXOACM award, audit procedures included comparing the reported amounts to the general ledger. We noted the following variances: See chart or table in the Schedule of Findings and Questioned Costs. Questioned costs: None. Context: See “Condition.” Cause: Amounts in the supporting general ledger documentation were accurate. However, the corresponding line items on the SF-425 report were not reported accurately. Management did not revise the March 31, 2024, report as the report is cumulative and the final report for the 2201TXOACM grant will include the corrected amounts. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No. Recommendation: We recommend management reconcile all amounts reported on the SF-425 reports to the general ledger or other supporting documentation to ensure completeness and accuracy prior to submission. Views of responsible officials: HHSC concurs with the finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Aging Cluster ALN: 93.044 93.045 93.053 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXOACM 10/1/2021 – 9/30/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR 200.303(a), Health and Human Services Commission (HHSC) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that it is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of six SF-425 reports submitted during the fiscal year. For the March 31, 2024, report for the 2201TXOACM award, audit procedures included comparing the reported amounts to the general ledger. We noted the following variances: See chart or table in the Schedule of Findings and Questioned Costs. Questioned costs: None. Context: See “Condition.” Cause: Amounts in the supporting general ledger documentation were accurate. However, the corresponding line items on the SF-425 report were not reported accurately. Management did not revise the March 31, 2024, report as the report is cumulative and the final report for the 2201TXOACM grant will include the corrected amounts. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No. Recommendation: We recommend management reconcile all amounts reported on the SF-425 reports to the general ledger or other supporting documentation to ensure completeness and accuracy prior to submission. Views of responsible officials: HHSC concurs with the finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Aging Cluster ALN: 93.044 93.045 93.053 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXOACM 10/1/2021 – 9/30/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR 200.303(a), Health and Human Services Commission (HHSC) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that it is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of six SF-425 reports submitted during the fiscal year. For the March 31, 2024, report for the 2201TXOACM award, audit procedures included comparing the reported amounts to the general ledger. We noted the following variances: See chart or table in the Schedule of Findings and Questioned Costs. Questioned costs: None. Context: See “Condition.” Cause: Amounts in the supporting general ledger documentation were accurate. However, the corresponding line items on the SF-425 report were not reported accurately. Management did not revise the March 31, 2024, report as the report is cumulative and the final report for the 2201TXOACM grant will include the corrected amounts. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No. Recommendation: We recommend management reconcile all amounts reported on the SF-425 reports to the general ledger or other supporting documentation to ensure completeness and accuracy prior to submission. Views of responsible officials: HHSC concurs with the finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Aging Cluster ALN: 93.044 93.045 93.053 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXOACM 10/1/2021 – 9/30/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR 200.303(a), Health and Human Services Commission (HHSC) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that it is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of six SF-425 reports submitted during the fiscal year. For the March 31, 2024, report for the 2201TXOACM award, audit procedures included comparing the reported amounts to the general ledger. We noted the following variances: See chart or table in the Schedule of Findings and Questioned Costs. Questioned costs: None. Context: See “Condition.” Cause: Amounts in the supporting general ledger documentation were accurate. However, the corresponding line items on the SF-425 report were not reported accurately. Management did not revise the March 31, 2024, report as the report is cumulative and the final report for the 2201TXOACM grant will include the corrected amounts. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No. Recommendation: We recommend management reconcile all amounts reported on the SF-425 reports to the general ledger or other supporting documentation to ensure completeness and accuracy prior to submission. Views of responsible officials: HHSC concurs with the finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Aging Cluster ALN: 93.044 93.045 93.053 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXOACM 10/1/2021 – 9/30/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR 200.303(a), Health and Human Services Commission (HHSC) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that it is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of six SF-425 reports submitted during the fiscal year. For the March 31, 2024, report for the 2201TXOACM award, audit procedures included comparing the reported amounts to the general ledger. We noted the following variances: See chart or table in the Schedule of Findings and Questioned Costs. Questioned costs: None. Context: See “Condition.” Cause: Amounts in the supporting general ledger documentation were accurate. However, the corresponding line items on the SF-425 report were not reported accurately. Management did not revise the March 31, 2024, report as the report is cumulative and the final report for the 2201TXOACM grant will include the corrected amounts. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No. Recommendation: We recommend management reconcile all amounts reported on the SF-425 reports to the general ledger or other supporting documentation to ensure completeness and accuracy prior to submission. Views of responsible officials: HHSC concurs with the finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Aging Cluster ALN: 93.044 93.045 93.053 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXOACM 10/1/2021 – 9/30/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR 200.303(a), Health and Human Services Commission (HHSC) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that it is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of six SF-425 reports submitted during the fiscal year. For the March 31, 2024, report for the 2201TXOACM award, audit procedures included comparing the reported amounts to the general ledger. We noted the following variances: See chart or table in the Schedule of Findings and Questioned Costs. Questioned costs: None. Context: See “Condition.” Cause: Amounts in the supporting general ledger documentation were accurate. However, the corresponding line items on the SF-425 report were not reported accurately. Management did not revise the March 31, 2024, report as the report is cumulative and the final report for the 2201TXOACM grant will include the corrected amounts. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No. Recommendation: We recommend management reconcile all amounts reported on the SF-425 reports to the general ledger or other supporting documentation to ensure completeness and accuracy prior to submission. Views of responsible officials: HHSC concurs with the finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Transportation Federal Program Title: Airport Improvement program ALN: 20.106 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 3-48-SBGP-147-2022 September 14, 2022 – September 13, 2026 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), Texas Department of Transportation (TXDOT): Establish and maintain effective internal control over the Federal award that provides reasonable assurance that TXDOT is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of five SF-425, Federal Financial Reports submitted during the fiscal year. For the SF-425 report for the 3-48-SBGP-147-2022 grant award submitted on March 6, 2024, we noted TXDOT did not report the recipient share of expenditures required. The recipient share of expenditures was incurred for the project; however, they were inadvertently omitted from the report. Questioned costs: None Context: See “Condition.” Cause: TXDOT prepares financial reports based on expenditures reported in its Peoplesoft system. The project for grant 3-48-SBGP-147-2022 was set up as 100% federal as the match was being met by the subrecipient. As such, TXDOT was reimbursing the subrecipient at 100% while the subrecipient met the 10% match with local funds. Accordingly, the matching funds, as incurred by the subrecipient, were not considered when preparing and reviewing the SF-425 report. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No Recommendation: We recommend management enhance its internal controls over the review and approval of the SF-425 reports to include a review of the grant award to ensure the subrecipient share of expenditures are reported properly reported. Views of responsible officials: TxDOT AVN agrees with this finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Transportation Federal Program Title: Airport Improvement program ALN: 20.106 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 3-48-SBGP-147-2022 September 14, 2022 – September 13, 2026 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), Texas Department of Transportation (TXDOT): Establish and maintain effective internal control over the Federal award that provides reasonable assurance that TXDOT is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of five SF-425, Federal Financial Reports submitted during the fiscal year. For the SF-425 report for the 3-48-SBGP-147-2022 grant award submitted on March 6, 2024, we noted TXDOT did not report the recipient share of expenditures required. The recipient share of expenditures was incurred for the project; however, they were inadvertently omitted from the report. Questioned costs: None Context: See “Condition.” Cause: TXDOT prepares financial reports based on expenditures reported in its Peoplesoft system. The project for grant 3-48-SBGP-147-2022 was set up as 100% federal as the match was being met by the subrecipient. As such, TXDOT was reimbursing the subrecipient at 100% while the subrecipient met the 10% match with local funds. Accordingly, the matching funds, as incurred by the subrecipient, were not considered when preparing and reviewing the SF-425 report. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No Recommendation: We recommend management enhance its internal controls over the review and approval of the SF-425 reports to include a review of the grant award to ensure the subrecipient share of expenditures are reported properly reported. Views of responsible officials: TxDOT AVN agrees with this finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Transportation Federal Program Title: Airport Improvement program ALN: 20.106 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 3-48-SBGP-147-2022 September 14, 2022 – September 13, 2026 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), Texas Department of Transportation (TXDOT): Establish and maintain effective internal control over the Federal award that provides reasonable assurance that TXDOT is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of five SF-425, Federal Financial Reports submitted during the fiscal year. For the SF-425 report for the 3-48-SBGP-147-2022 grant award submitted on March 6, 2024, we noted TXDOT did not report the recipient share of expenditures required. The recipient share of expenditures was incurred for the project; however, they were inadvertently omitted from the report. Questioned costs: None Context: See “Condition.” Cause: TXDOT prepares financial reports based on expenditures reported in its Peoplesoft system. The project for grant 3-48-SBGP-147-2022 was set up as 100% federal as the match was being met by the subrecipient. As such, TXDOT was reimbursing the subrecipient at 100% while the subrecipient met the 10% match with local funds. Accordingly, the matching funds, as incurred by the subrecipient, were not considered when preparing and reviewing the SF-425 report. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No Recommendation: We recommend management enhance its internal controls over the review and approval of the SF-425 reports to include a review of the grant award to ensure the subrecipient share of expenditures are reported properly reported. Views of responsible officials: TxDOT AVN agrees with this finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Transportation Federal Program Title: Airport Improvement program ALN: 20.106 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 3-48-SBGP-147-2022 September 14, 2022 – September 13, 2026 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), Texas Department of Transportation (TXDOT): Establish and maintain effective internal control over the Federal award that provides reasonable assurance that TXDOT is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of five SF-425, Federal Financial Reports submitted during the fiscal year. For the SF-425 report for the 3-48-SBGP-147-2022 grant award submitted on March 6, 2024, we noted TXDOT did not report the recipient share of expenditures required. The recipient share of expenditures was incurred for the project; however, they were inadvertently omitted from the report. Questioned costs: None Context: See “Condition.” Cause: TXDOT prepares financial reports based on expenditures reported in its Peoplesoft system. The project for grant 3-48-SBGP-147-2022 was set up as 100% federal as the match was being met by the subrecipient. As such, TXDOT was reimbursing the subrecipient at 100% while the subrecipient met the 10% match with local funds. Accordingly, the matching funds, as incurred by the subrecipient, were not considered when preparing and reviewing the SF-425 report. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No Recommendation: We recommend management enhance its internal controls over the review and approval of the SF-425 reports to include a review of the grant award to ensure the subrecipient share of expenditures are reported properly reported. Views of responsible officials: TxDOT AVN agrees with this finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Aging Cluster ALN: 93.044 93.045 93.053 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXOACM 10/1/2021 – 9/30/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR 200.303(a), Health and Human Services Commission (HHSC) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that it is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of six SF-425 reports submitted during the fiscal year. For the March 31, 2024, report for the 2201TXOACM award, audit procedures included comparing the reported amounts to the general ledger. We noted the following variances: See chart or table in the Schedule of Findings and Questioned Costs. Questioned costs: None. Context: See “Condition.” Cause: Amounts in the supporting general ledger documentation were accurate. However, the corresponding line items on the SF-425 report were not reported accurately. Management did not revise the March 31, 2024, report as the report is cumulative and the final report for the 2201TXOACM grant will include the corrected amounts. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No. Recommendation: We recommend management reconcile all amounts reported on the SF-425 reports to the general ledger or other supporting documentation to ensure completeness and accuracy prior to submission. Views of responsible officials: HHSC concurs with the finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Aging Cluster ALN: 93.044 93.045 93.053 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXOACM 10/1/2021 – 9/30/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR 200.303(a), Health and Human Services Commission (HHSC) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that it is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of six SF-425 reports submitted during the fiscal year. For the March 31, 2024, report for the 2201TXOACM award, audit procedures included comparing the reported amounts to the general ledger. We noted the following variances: See chart or table in the Schedule of Findings and Questioned Costs. Questioned costs: None. Context: See “Condition.” Cause: Amounts in the supporting general ledger documentation were accurate. However, the corresponding line items on the SF-425 report were not reported accurately. Management did not revise the March 31, 2024, report as the report is cumulative and the final report for the 2201TXOACM grant will include the corrected amounts. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No. Recommendation: We recommend management reconcile all amounts reported on the SF-425 reports to the general ledger or other supporting documentation to ensure completeness and accuracy prior to submission. Views of responsible officials: HHSC concurs with the finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Aging Cluster ALN: 93.044 93.045 93.053 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXOACM 10/1/2021 – 9/30/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR 200.303(a), Health and Human Services Commission (HHSC) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that it is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of six SF-425 reports submitted during the fiscal year. For the March 31, 2024, report for the 2201TXOACM award, audit procedures included comparing the reported amounts to the general ledger. We noted the following variances: See chart or table in the Schedule of Findings and Questioned Costs. Questioned costs: None. Context: See “Condition.” Cause: Amounts in the supporting general ledger documentation were accurate. However, the corresponding line items on the SF-425 report were not reported accurately. Management did not revise the March 31, 2024, report as the report is cumulative and the final report for the 2201TXOACM grant will include the corrected amounts. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No. Recommendation: We recommend management reconcile all amounts reported on the SF-425 reports to the general ledger or other supporting documentation to ensure completeness and accuracy prior to submission. Views of responsible officials: HHSC concurs with the finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Aging Cluster ALN: 93.044 93.045 93.053 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXOACM 10/1/2021 – 9/30/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR 200.303(a), Health and Human Services Commission (HHSC) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that it is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of six SF-425 reports submitted during the fiscal year. For the March 31, 2024, report for the 2201TXOACM award, audit procedures included comparing the reported amounts to the general ledger. We noted the following variances: See chart or table in the Schedule of Findings and Questioned Costs. Questioned costs: None. Context: See “Condition.” Cause: Amounts in the supporting general ledger documentation were accurate. However, the corresponding line items on the SF-425 report were not reported accurately. Management did not revise the March 31, 2024, report as the report is cumulative and the final report for the 2201TXOACM grant will include the corrected amounts. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No. Recommendation: We recommend management reconcile all amounts reported on the SF-425 reports to the general ledger or other supporting documentation to ensure completeness and accuracy prior to submission. Views of responsible officials: HHSC concurs with the finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Aging Cluster ALN: 93.044 93.045 93.053 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXOACM 10/1/2021 – 9/30/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR 200.303(a), Health and Human Services Commission (HHSC) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that it is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of six SF-425 reports submitted during the fiscal year. For the March 31, 2024, report for the 2201TXOACM award, audit procedures included comparing the reported amounts to the general ledger. We noted the following variances: See chart or table in the Schedule of Findings and Questioned Costs. Questioned costs: None. Context: See “Condition.” Cause: Amounts in the supporting general ledger documentation were accurate. However, the corresponding line items on the SF-425 report were not reported accurately. Management did not revise the March 31, 2024, report as the report is cumulative and the final report for the 2201TXOACM grant will include the corrected amounts. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No. Recommendation: We recommend management reconcile all amounts reported on the SF-425 reports to the general ledger or other supporting documentation to ensure completeness and accuracy prior to submission. Views of responsible officials: HHSC concurs with the finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Aging Cluster ALN: 93.044 93.045 93.053 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXOACM 10/1/2021 – 9/30/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR 200.303(a), Health and Human Services Commission (HHSC) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that it is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of six SF-425 reports submitted during the fiscal year. For the March 31, 2024, report for the 2201TXOACM award, audit procedures included comparing the reported amounts to the general ledger. We noted the following variances: See chart or table in the Schedule of Findings and Questioned Costs. Questioned costs: None. Context: See “Condition.” Cause: Amounts in the supporting general ledger documentation were accurate. However, the corresponding line items on the SF-425 report were not reported accurately. Management did not revise the March 31, 2024, report as the report is cumulative and the final report for the 2201TXOACM grant will include the corrected amounts. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No. Recommendation: We recommend management reconcile all amounts reported on the SF-425 reports to the general ledger or other supporting documentation to ensure completeness and accuracy prior to submission. Views of responsible officials: HHSC concurs with the finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Aging Cluster ALN: 93.044 93.045 93.053 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXOACM 10/1/2021 – 9/30/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR 200.303(a), Health and Human Services Commission (HHSC) must establish and maintain effective internal control over the Federal award that provides reasonable assurance that it is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of six SF-425 reports submitted during the fiscal year. For the March 31, 2024, report for the 2201TXOACM award, audit procedures included comparing the reported amounts to the general ledger. We noted the following variances: See chart or table in the Schedule of Findings and Questioned Costs. Questioned costs: None. Context: See “Condition.” Cause: Amounts in the supporting general ledger documentation were accurate. However, the corresponding line items on the SF-425 report were not reported accurately. Management did not revise the March 31, 2024, report as the report is cumulative and the final report for the 2201TXOACM grant will include the corrected amounts. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No. Recommendation: We recommend management reconcile all amounts reported on the SF-425 reports to the general ledger or other supporting documentation to ensure completeness and accuracy prior to submission. Views of responsible officials: HHSC concurs with the finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Transportation Federal Program Title: Airport Improvement program ALN: 20.106 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 3-48-SBGP-147-2022 September 14, 2022 – September 13, 2026 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), Texas Department of Transportation (TXDOT): Establish and maintain effective internal control over the Federal award that provides reasonable assurance that TXDOT is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of five SF-425, Federal Financial Reports submitted during the fiscal year. For the SF-425 report for the 3-48-SBGP-147-2022 grant award submitted on March 6, 2024, we noted TXDOT did not report the recipient share of expenditures required. The recipient share of expenditures was incurred for the project; however, they were inadvertently omitted from the report. Questioned costs: None Context: See “Condition.” Cause: TXDOT prepares financial reports based on expenditures reported in its Peoplesoft system. The project for grant 3-48-SBGP-147-2022 was set up as 100% federal as the match was being met by the subrecipient. As such, TXDOT was reimbursing the subrecipient at 100% while the subrecipient met the 10% match with local funds. Accordingly, the matching funds, as incurred by the subrecipient, were not considered when preparing and reviewing the SF-425 report. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No Recommendation: We recommend management enhance its internal controls over the review and approval of the SF-425 reports to include a review of the grant award to ensure the subrecipient share of expenditures are reported properly reported. Views of responsible officials: TxDOT AVN agrees with this finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Transportation Federal Program Title: Airport Improvement program ALN: 20.106 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 3-48-SBGP-147-2022 September 14, 2022 – September 13, 2026 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), Texas Department of Transportation (TXDOT): Establish and maintain effective internal control over the Federal award that provides reasonable assurance that TXDOT is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of five SF-425, Federal Financial Reports submitted during the fiscal year. For the SF-425 report for the 3-48-SBGP-147-2022 grant award submitted on March 6, 2024, we noted TXDOT did not report the recipient share of expenditures required. The recipient share of expenditures was incurred for the project; however, they were inadvertently omitted from the report. Questioned costs: None Context: See “Condition.” Cause: TXDOT prepares financial reports based on expenditures reported in its Peoplesoft system. The project for grant 3-48-SBGP-147-2022 was set up as 100% federal as the match was being met by the subrecipient. As such, TXDOT was reimbursing the subrecipient at 100% while the subrecipient met the 10% match with local funds. Accordingly, the matching funds, as incurred by the subrecipient, were not considered when preparing and reviewing the SF-425 report. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No Recommendation: We recommend management enhance its internal controls over the review and approval of the SF-425 reports to include a review of the grant award to ensure the subrecipient share of expenditures are reported properly reported. Views of responsible officials: TxDOT AVN agrees with this finding.
Reporting – Financial Reporting Federal Agency: U.S. Department of Transportation Federal Program Title: Airport Improvement program ALN: 20.106 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 3-48-SBGP-147-2022 September 14, 2022 – September 13, 2026 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), Texas Department of Transportation (TXDOT): Establish and maintain effective internal control over the Federal award that provides reasonable assurance that TXDOT is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.328(c), the recipient or subrecipient must submit financial reports as required by the Federal award. Per 2 CFR 200.302(b)(2), the recipient's and subrecipient's financial management system must provide for the following: accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. Condition: Audit procedures included a sample of five SF-425, Federal Financial Reports submitted during the fiscal year. For the SF-425 report for the 3-48-SBGP-147-2022 grant award submitted on March 6, 2024, we noted TXDOT did not report the recipient share of expenditures required. The recipient share of expenditures was incurred for the project; however, they were inadvertently omitted from the report. Questioned costs: None Context: See “Condition.” Cause: TXDOT prepares financial reports based on expenditures reported in its Peoplesoft system. The project for grant 3-48-SBGP-147-2022 was set up as 100% federal as the match was being met by the subrecipient. As such, TXDOT was reimbursing the subrecipient at 100% while the subrecipient met the 10% match with local funds. Accordingly, the matching funds, as incurred by the subrecipient, were not considered when preparing and reviewing the SF-425 report. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on federal reports. Repeat Finding: No Recommendation: We recommend management enhance its internal controls over the review and approval of the SF-425 reports to include a review of the grant award to ensure the subrecipient share of expenditures are reported properly reported. Views of responsible officials: TxDOT AVN agrees with this finding.