Condition: A weakness existed in the overall reconciliation/tie-in procedures performed over the Tribe’s financial statement accounts for the fiscal year ended September 30, 2024. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included: A) Beginning Balances B) Account Receivables C) Grant Receivables/Unearned Revenues D) Accounts Payable E) Payroll and Other Current Liabilities Criteria: OMB Uniform Guidance states the following in section 200.302, “(2) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. Cause: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. Effect: In the course of performing the audit, the auditor recommended 20 adjusting journal entries be made to the financial statements for fiscal year ending September 30, 2024. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature. Recommendation: The Tribe should adopt written reconciliation and tie-in procedures into its financial policies and procedures manual. Views of Responsible Officials: See Corrective Action Plan
Condition: A weakness existed in the overall reconciliation/tie-in procedures performed over the Tribe’s financial statement accounts for the fiscal year ended September 30, 2024. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included: A) Beginning Balances B) Account Receivables C) Grant Receivables/Unearned Revenues D) Accounts Payable E) Payroll and Other Current Liabilities Criteria: OMB Uniform Guidance states the following in section 200.302, “(2) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. Cause: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. Effect: In the course of performing the audit, the auditor recommended 20 adjusting journal entries be made to the financial statements for fiscal year ending September 30, 2024. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature. Recommendation: The Tribe should adopt written reconciliation and tie-in procedures into its financial policies and procedures manual. Views of Responsible Officials: See Corrective Action Plan
Condition: A weakness existed in the overall reconciliation/tie-in procedures performed over the Tribe’s financial statement accounts for the fiscal year ended September 30, 2024. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included: A) Beginning Balances B) Account Receivables C) Grant Receivables/Unearned Revenues D) Accounts Payable E) Payroll and Other Current Liabilities Criteria: OMB Uniform Guidance states the following in section 200.302, “(2) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. Cause: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. Effect: In the course of performing the audit, the auditor recommended 20 adjusting journal entries be made to the financial statements for fiscal year ending September 30, 2024. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature. Recommendation: The Tribe should adopt written reconciliation and tie-in procedures into its financial policies and procedures manual. Views of Responsible Officials: See Corrective Action Plan
Condition: A weakness existed in the overall reconciliation/tie-in procedures performed over the Tribe’s financial statement accounts for the fiscal year ended September 30, 2024. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included: A) Beginning Balances B) Account Receivables C) Grant Receivables/Unearned Revenues D) Accounts Payable E) Payroll and Other Current Liabilities Criteria: OMB Uniform Guidance states the following in section 200.302, “(2) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. Cause: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. Effect: In the course of performing the audit, the auditor recommended 20 adjusting journal entries be made to the financial statements for fiscal year ending September 30, 2024. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature. Recommendation: The Tribe should adopt written reconciliation and tie-in procedures into its financial policies and procedures manual. Views of Responsible Officials: See Corrective Action Plan
Condition: A weakness existed in the overall reconciliation/tie-in procedures performed over the Tribe’s financial statement accounts for the fiscal year ended September 30, 2024. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included: A) Beginning Balances B) Account Receivables C) Grant Receivables/Unearned Revenues D) Accounts Payable E) Payroll and Other Current Liabilities Criteria: OMB Uniform Guidance states the following in section 200.302, “(2) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. Cause: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. Effect: In the course of performing the audit, the auditor recommended 20 adjusting journal entries be made to the financial statements for fiscal year ending September 30, 2024. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature. Recommendation: The Tribe should adopt written reconciliation and tie-in procedures into its financial policies and procedures manual. Views of Responsible Officials: See Corrective Action Plan
Condition: A weakness existed in the overall reconciliation/tie-in procedures performed over the Tribe’s financial statement accounts for the fiscal year ended September 30, 2024. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included: A) Beginning Balances B) Account Receivables C) Grant Receivables/Unearned Revenues D) Accounts Payable E) Payroll and Other Current Liabilities Criteria: OMB Uniform Guidance states the following in section 200.302, “(2) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. Cause: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. Effect: In the course of performing the audit, the auditor recommended 20 adjusting journal entries be made to the financial statements for fiscal year ending September 30, 2024. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature. Recommendation: The Tribe should adopt written reconciliation and tie-in procedures into its financial policies and procedures manual. Views of Responsible Officials: See Corrective Action Plan
Condition: A weakness existed in the overall reconciliation/tie-in procedures performed over the Tribe’s financial statement accounts for the fiscal year ended September 30, 2024. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included: A) Beginning Balances B) Account Receivables C) Grant Receivables/Unearned Revenues D) Accounts Payable E) Payroll and Other Current Liabilities Criteria: OMB Uniform Guidance states the following in section 200.302, “(2) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. Cause: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. Effect: In the course of performing the audit, the auditor recommended 20 adjusting journal entries be made to the financial statements for fiscal year ending September 30, 2024. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature. Recommendation: The Tribe should adopt written reconciliation and tie-in procedures into its financial policies and procedures manual. Views of Responsible Officials: See Corrective Action Plan
Condition: A weakness existed in the overall reconciliation/tie-in procedures performed over the Tribe’s financial statement accounts for the fiscal year ended September 30, 2024. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included: A) Beginning Balances B) Account Receivables C) Grant Receivables/Unearned Revenues D) Accounts Payable E) Payroll and Other Current Liabilities Criteria: OMB Uniform Guidance states the following in section 200.302, “(2) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. Cause: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. Effect: In the course of performing the audit, the auditor recommended 20 adjusting journal entries be made to the financial statements for fiscal year ending September 30, 2024. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature. Recommendation: The Tribe should adopt written reconciliation and tie-in procedures into its financial policies and procedures manual. Views of Responsible Officials: See Corrective Action Plan
Condition: A weakness existed in the overall reconciliation/tie-in procedures performed over the Tribe’s financial statement accounts for the fiscal year ended September 30, 2024. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included: A) Beginning Balances B) Account Receivables C) Grant Receivables/Unearned Revenues D) Accounts Payable E) Payroll and Other Current Liabilities Criteria: OMB Uniform Guidance states the following in section 200.302, “(2) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. Cause: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. Effect: In the course of performing the audit, the auditor recommended 20 adjusting journal entries be made to the financial statements for fiscal year ending September 30, 2024. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature. Recommendation: The Tribe should adopt written reconciliation and tie-in procedures into its financial policies and procedures manual. Views of Responsible Officials: See Corrective Action Plan
Condition: A weakness existed in the overall reconciliation/tie-in procedures performed over the Tribe’s financial statement accounts for the fiscal year ended September 30, 2024. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included: A) Beginning Balances B) Account Receivables C) Grant Receivables/Unearned Revenues D) Accounts Payable E) Payroll and Other Current Liabilities Criteria: OMB Uniform Guidance states the following in section 200.302, “(2) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. Cause: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. Effect: In the course of performing the audit, the auditor recommended 20 adjusting journal entries be made to the financial statements for fiscal year ending September 30, 2024. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature. Recommendation: The Tribe should adopt written reconciliation and tie-in procedures into its financial policies and procedures manual. Views of Responsible Officials: See Corrective Action Plan
Condition: A weakness existed in the overall reconciliation/tie-in procedures performed over the Tribe’s financial statement accounts for the fiscal year ended September 30, 2024. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included: A) Beginning Balances B) Account Receivables C) Grant Receivables/Unearned Revenues D) Accounts Payable E) Payroll and Other Current Liabilities Criteria: OMB Uniform Guidance states the following in section 200.302, “(2) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. Cause: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. Effect: In the course of performing the audit, the auditor recommended 20 adjusting journal entries be made to the financial statements for fiscal year ending September 30, 2024. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature. Recommendation: The Tribe should adopt written reconciliation and tie-in procedures into its financial policies and procedures manual. Views of Responsible Officials: See Corrective Action Plan
Condition: A weakness existed in the overall reconciliation/tie-in procedures performed over the Tribe’s financial statement accounts for the fiscal year ended September 30, 2024. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included: A) Beginning Balances B) Account Receivables C) Grant Receivables/Unearned Revenues D) Accounts Payable E) Payroll and Other Current Liabilities Criteria: OMB Uniform Guidance states the following in section 200.302, “(2) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. Cause: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. Effect: In the course of performing the audit, the auditor recommended 20 adjusting journal entries be made to the financial statements for fiscal year ending September 30, 2024. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature. Recommendation: The Tribe should adopt written reconciliation and tie-in procedures into its financial policies and procedures manual. Views of Responsible Officials: See Corrective Action Plan
Condition: A weakness existed in the overall reconciliation/tie-in procedures performed over the Tribe’s financial statement accounts for the fiscal year ended September 30, 2024. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included: A) Beginning Balances B) Account Receivables C) Grant Receivables/Unearned Revenues D) Accounts Payable E) Payroll and Other Current Liabilities Criteria: OMB Uniform Guidance states the following in section 200.302, “(2) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. Cause: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. Effect: In the course of performing the audit, the auditor recommended 20 adjusting journal entries be made to the financial statements for fiscal year ending September 30, 2024. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature. Recommendation: The Tribe should adopt written reconciliation and tie-in procedures into its financial policies and procedures manual. Views of Responsible Officials: See Corrective Action Plan
Earmarking Federal Agency: Department of Homeland Security Federal Program Name: Disaster Grant Public Assistance (Presidentially Declared Disasters) Assistance Listing Number: 97.036 Grant Award Number: 4337DR-FL-2024 Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance and Other Matters Criteria: Compliance: 2 CFR 200.302(b)(3) states that records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply 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). Condition: Management costs requested and received from FEMA exceeded the 5% threshold. Questioned Costs: $35,572. Context: Received the total award amount for calculation of the 5% threshold. Compared to the management costs requested and received. Cause: The County requested management fees unaware of the total expenditure amount. Effect: Over request of management fees leads to unallowable costs. Repeat finding: No Recommendation: Provide clear, updated guidance and periodic training sessions on earmarking rules and how to apply them. Conduct reviews of earmarking compliance. View responsible official and planned corrective actions: New procedures will be implemented that strengthen internal controls to ensure clear earmarking guidance and initial review of compliances.
Federal Agency: Department of Homeland Security Federal Program Name: Disaster Grant Public Assistance (Presidentially Declared Disasters) Assistance Listing Number: 97.036 Grant Award Number: 4337DR-FL-2024 Award Period: Various Type of Finding: Significant Deficiency in Internal Control Over Compliance Criteria: Compliance: 2 CFR 200.302(b)(3) states that records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply 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). Condition: It was observed that quarterly progress reports lacked documentation of review and approval by management prior to submission to the granting agency. Questioned Costs: None. Context: All quarterly progress reports selected for testing lacked documented review and approval. Cause: The City has not established formal policies and procedures for the review and approval process. Effect: The lack of a proper review and approval process for grant quarterly progress report submissions can result in the submission of inaccurate and incomplete reimbursement requests and reports, which may lead to non-compliance with grant requirements and potential financial penalties. Repeat Finding: No Recommendation: We recommend that the organization implement a review and approval process for all quarterly progress report submissions. This should include: - Training staff on the importance of the review and approval process. - Ensuring adequate staffing levels to handle the review process. - Developing clear guidelines and procedures for the review and approval process. - Regularly monitoring and auditing the review process to ensure compliance. View of Responsible Official and Planned Corrective Actions: There is no disagreement with the audit finding. See Corrective Action Plan
Federal Agency: Department of Homeland Security Federal Program Name: Disaster Grant Public Assistance (Presidentially Declared Disasters) Assistance Listing Number: 97.036 Grant Award Number: 4337DR-FL-2024 Award Period: Various Type of Finding: Significant Deficiency in Internal Control Over Compliance Criteria: Compliance: 2 CFR 200.302(b)(3) states that records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply 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). Condition: It was observed that quarterly progress reports lacked documentation of review and approval by management prior to submission to the granting agency. Questioned Costs: None. Context: All quarterly progress reports selected for testing lacked documented review and approval. Cause: The City has not established formal policies and procedures for the review and approval process. Effect: The lack of a proper review and approval process for grant quarterly progress report submissions can result in the submission of inaccurate and incomplete reimbursement requests and reports, which may lead to non-compliance with grant requirements and potential financial penalties. Repeat Finding: No Recommendation: We recommend that the organization implement a review and approval process for all quarterly progress report submissions. This should include: - Training staff on the importance of the review and approval process. - Ensuring adequate staffing levels to handle the review process. - Developing clear guidelines and procedures for the review and approval process. - Regularly monitoring and auditing the review process to ensure compliance. View of Responsible Official and Planned Corrective Actions: There is no disagreement with the audit finding. See Corrective Action Plan
U.S. Department of Health and Human Services - 93.432 Center for Independent Living 2024-007 Missing Supporting Documentation for Federal Reimbursement Claims Criteria: Per 2 CFR §200.333 (now §200.334), financial records, supporting documents, statistical records, and all other records pertinent to a federal award must be retained for a period of three years from the date of submission of the final expenditure report. Furthermore, 2 CFR §200.302(b)(3) requires recipients to maintain records that adequately identify the source and application of funds for federally funded activities. Condition: During our audit of the Centers for Independent Living funded by the U.S. Department of Health and Human Services, we noted that the League did not retain adequate supporting documentation for reimbursement claims submitted during the year. Specifically, for October - December 2023 reimbursement claims tested, the actual claim forms submitted to the funding agency were missing. Cause: The missing documentation appears to have resulted from an inadequate document retention process and a lack of oversight in ensuring that federal claim records were properly filed and stored. Effect: The absence of supporting documentation for submitted claims limits the League’s ability to demonstrate compliance with federal requirements and increases the risk of questioned costs. It also impairs transparency and accountability for federal funds. Questioned Costs: $118,023 for October – December 2023 claims. Recommendation: We recommend the League strengthen its grant management procedures by implementing a centralized tracking system for grant expenditures and claims. Staff responsible for managing grants should receive training on claiming procedures and grant deadlines, and a periodic review of unclaimed eligible expenditures should be performed to ensure timely reimbursement. Views of Responsible Officials and Planned Corrective Actions: See corrective action plan on page 50.
Condition: The Organization’s expenditure reports filed with the grantor for the cost reimbursement-based grant were overstated, and the Organization was overpaid by $182,167, of which $26,730 was received after year-end. The overpayment has not yet been refunded back to the grantor, over a year after the performance period of the grant had ended. Criteria: The Organization did not comply with 2 CFR 200.302 and 2 CFR 200.305 of the Uniform Guidance and the terms of the grant for the major program tested. Expenditure reports are required to be accurate and supported by the Organization’s financial management system, books, and records. The time between receipt of funds by the Organization and disbursement of funds by the Organization is required to be minimized. The grant agreement establishes that payments received in excess of qualifying expenditures occurred must be returned back to the grantor. Cause: The expenditure reports filed were based on estimates that later changed once more information was available. There was a weakness in controls involving the reconciliation of expenditure reports filed to the Organization’s financial management system, books, and records. Effect: The Organization was overpaid by $182,167. Recommendation: The Organization should coordinate with the grantor the return of the unspent funds. The Organization should reevaluate its grant expenditure reporting procedures to better mitigate the risk of inaccurate filing and improper reimbursement. Views of Responsible Officials and Planned Corrective Actions: The Organization agrees with the finding. See the Corrective Action Plan.
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.
CRITERIA - As per 2 CFR 200.302 and the terms and conditions of the grant, the auditee must maintain accounting records that clearly identify the source and application of federal funds and must account for federal awards separately from other funds to ensure that federal funds are used only for authorized purposes. CONDITION - During my audit of the 2024 Program Year of the National Coastal Zone Management Program, I noted the Town of Dauphin Island deposited federal program funds into a pooled bank account with non-federal funds. Program expenditures were paid from this pooled account without a separate ledger or tracking mechanism in place at the time of the transactions. As a result, the auditee was unable to immediately identify program-specific expenditures and balances. CAUSE - The auditee did not have adequate written procedures or internal controls to ensure that federal funds were maintained in separate accounts or separately tracked within the accounting system. EFFECT - The commingling of federal and non-federal funds increases the risk that federal funds could be used for unallowable purposes, could result in unallowable costs being charged to the grant, and makes timely and accurate financial reporting more difficult. Although I was ultimately able to determine the allowable costs after significant additional procedures, the lack of separate accounting records represents a weakness in internal controls over compliance. QUESTIONED COSTS - None identified. REPEAT FINDING - No. RECOMMENDATION - I recommend the Town of Dauphin Island establish procedures to ensure that federal funds are either maintained in a separate bank account or are tracked separately in the general ledger through the use of grant-specific accounts or cost centers. Federal program transactions should be clearly identified to facilitate effective monitoring of federal grant proceeds and expenditures and timely and accurate financial reporting.
2024-002 Internal Controls over Grant Management (Significant Deficiency and Noncompliance) Criteria: 2 CFR 200.302 establishes the requirements of a financial management system adequate to ensure compliance with federal regulations. This system must include written procedures to implement requirements for payment methods and determine the allowability of costs in accordance with subpart E. Statement of Condition: The City has written fiscal policies but they do not meet the financial management system requirements established in the regulations. Cause: The City has processes and procedures in place to administer grant funds but written policies do not contain compliance requirements. Effect: The City is not in compliance with financial management system requirements. Recommendation: The City should develop a grants manual or additional written policies to incorporate all the requirements of 2 CFR 200 and ensure compliance. Views of Management and Planned Corrective Action: See Corrective Action Plan included at the end
Federal Programs: U.S. Department of Health and Human Services, Consolidated Health Centers Cluster: Community Health Centers (Assistance Listing #93.224 & 93.527) Finding Type: Significant Deficiency in Internal Control over Compliance Criteria: The 2 CFR Section 200.302 requires that nonfederal entities receiving federal awards present accurate, current, and complete disclosure of the financial results of each federal award or program. The entity is required to maintain records, supported by source documentation, that identify adequately the source of funds for federally funded programs and report federal expenditures via the Federal Financial Reports at intervals specified within the applicable grant awards. Condition and Context: For the annual submission of the H80CS24107 grant, the center submitted the required federal financial report 91 days after the date the report was due. Cause: During the year, the Center experienced turnover within the finance department and which cause a lapse in duties pertaining to the submission of this report. Effect: As a result the report was not filed timely, there was no noted financial impact of the late submission. Questioned Costs: None Recommendation: The Center should implement a more robust process and related internal controls surrounding the reporting of grant expenditures. Views of Responsible Officials: Management agrees with the finding. Planned Implementation of Corrective Action: Additional preventive internal control procedures will be implemented, designating a secondary individual responsible for submission should the primary individual leave or be terminated. These procedures and internal controls have been implemented as of the date of this report. Person Responsible for Corrective Action: Chief Executive Officer
2024-032 - Delayed Final Reimbursement Due to Unresolved Agency Requests Federal Programs 23.002 - Appalachian Area Development 14.228 - Community Development Block Grants/State's Program Award Numbers ARC-20698 ARC-20699 CDBG Subgrant: 1137-21-111-PF-01 Federal Agency U.S. Department of Housing and Urban Development (HUD) Appalachian Regional Commission (ARC) Compliance Requirement Reporting and Closeout- 2 CFR §§ 200.302, 200.303, and 200.344 Type of Finding: Internal Control over Compliance - Significant Deficiency Compliance - Noncompliance Questioned Costs: None Criteria: In accordance with 2 CFR §200.302 and §200.303, non-federal entities must maintain effective internal control over federal awards and ensure timely closeout. Additionally, 2 CFR §200.344 requires that closeout be completed within one year of the end of the period of performance. Condition: Final reimbursement requests for the above federal programs were submitted over a year ago. Although the granting agencies have initiated follow-up correspondence requesting additional documentation or clarification, the final payments remain outstanding as of the audit date. No resolution has been reached, and the grants remain open. Cause: The City lacks a formalized process for tracking unresolved reimbursement requests and responding to agency inquiries in a timely and coordinated manner. This has contributed to delays in resolving outstanding issues and receiving final payments. Effect: The City has not received final reimbursement for completed federal programs, resulting in delayed revenue recognition and potential strain on local resources. The extended delay also risks noncompliance with federal closeout requirements and may affect future funding eligibility. Recommendation: Implement a grant closeout protocol that includes: A centralized tracking system for final reimbursement submissions and agency correspondence Defined timelines for follow-up and escalation Clear assignment of responsibility for resolving outstanding issues Views of Responsible Officials: Management concurs with the finding. The City acknowledges that final reimbursement requests for the referenced federal programs were submitted in a timely manner; however, final payments have not been received due to ongoing correspondence and requests for additional information from the granting agencies. While staff have responded to these inquiries, the absence of a formalized tracking and escalation process has contributed to delays in resolution.
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.
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.
Criteria: Under 2 CFR §200.302(b), §200.303, and §200.305, non-federal entities must establish internal controls over federal awards to ensure proper financial management, allowability of costs, timely and accurate reporting, and proper cash management. Additionally, under GAAP (ASC 958-605), grant revenue should be recognized when allowable costs have been incurred. Documentation and supervisory review are necessary to support revenue recognition and ensure expenditures and drawdowns are accurately reported. Condition: The Organization did not document a monthly reconciliation review process to confirm that federal revenues recorded in the general ledger and federal grant drawdowns were supported by allowable costs incurred. Additionally, there was no evidence of review or reconciliation of annual SF-425 Federal Financial Reports to verify that cumulative drawdowns reconciled to allowable costs and recorded revenue. Cause: The Organization lacked a formal internal control process requiring review and sign-off of the reconciliation of grant expenditures, grant revenue, drawdowns, and SF-425 federal financial reporting. Effect: Inadequate internal controls over allowable costs, cash management, and federal financial reporting increased the risk of improper grant revenue recognition recorded, expenditures not being accurately reported, and unallowable costs being claimed, which could lead to misstatements in the financial statements, Schedule of Expenditures of Federal Awards (SEFA), and required federal reports, and result in noncompliance with Uniform Guidance and GAAP. Questioned Cost: None Recommendation: Implement a documented monthly reconciliation process to verify that federal revenues recorded and drawn down are supported by allowable costs incurred in accordance with grant terms. Include supervisory review of SF-425 reports and supporting schedules to confirm alignment with recorded expenditures and revenues. Reconciliations should be reviewed and signed by the CFO and retained in grant records to ensure compliance with Uniform Guidance and GAAP.
SCHEDULE OF FINDINGS AND QUESTIONED COSTS Federal Award Findings and Questioned Costs July 31, 2024 Comment # 2024-002 INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION, GRANT CLOSE OUT AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED HEAD START AND EARLY HEAD START, LIHEAP, LIHWAP, CSBG, ASTHO, CACFP and CSLFRF FAL # 93.600, 93.568, 93.499, 93.569, 93.185, 10.558, 21.027 (Questioned Costs - Undetermined) Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards states in summary that management should authorize, process, reconcile and close-out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The closeout process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff does not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to present the financial statements and disclosures of the Agency as of July 31, 2024. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.). Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e. SF-425, DHS’s reports for LIHEAP, etc.). Accordingly, the Agency is not in compliance with federal and state reporting as specified by grants and contracts and the Federal Audit Clearinghouse. The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR §200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §200.328 Financial reporting and §200.329. (Continued) Effect: Monitoring and reporting program performance [2 CFR §200.302(b)(2)]. Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency as determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountant and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant’s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statements close-out process is achieved each month and annually. Accounting policies and procedures must be updated and implemented. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the Agency’s financial funding sources, the Agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst’s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and Uniform Guidance regulations. The new automated financial systems, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2025.
SCHEDULE OF FINDINGS AND QUESTIONED COSTS Federal Award Findings and Questioned Costs July 31, 2024 Comment # 2024-002 INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION, GRANT CLOSE OUT AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED HEAD START AND EARLY HEAD START, LIHEAP, LIHWAP, CSBG, ASTHO, CACFP and CSLFRF FAL # 93.600, 93.568, 93.499, 93.569, 93.185, 10.558, 21.027 (Questioned Costs - Undetermined) Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards states in summary that management should authorize, process, reconcile and close-out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The closeout process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff does not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to present the financial statements and disclosures of the Agency as of July 31, 2024. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.). Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e. SF-425, DHS’s reports for LIHEAP, etc.). Accordingly, the Agency is not in compliance with federal and state reporting as specified by grants and contracts and the Federal Audit Clearinghouse. The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR §200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §200.328 Financial reporting and §200.329. (Continued) Effect: Monitoring and reporting program performance [2 CFR §200.302(b)(2)]. Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency as determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountant and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant’s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statements close-out process is achieved each month and annually. Accounting policies and procedures must be updated and implemented. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the Agency’s financial funding sources, the Agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst’s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and Uniform Guidance regulations. The new automated financial systems, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2025.
SCHEDULE OF FINDINGS AND QUESTIONED COSTS Federal Award Findings and Questioned Costs July 31, 2024 Comment # 2024-002 INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION, GRANT CLOSE OUT AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED HEAD START AND EARLY HEAD START, LIHEAP, LIHWAP, CSBG, ASTHO, CACFP and CSLFRF FAL # 93.600, 93.568, 93.499, 93.569, 93.185, 10.558, 21.027 (Questioned Costs - Undetermined) Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards states in summary that management should authorize, process, reconcile and close-out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The closeout process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff does not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to present the financial statements and disclosures of the Agency as of July 31, 2024. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.). Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e. SF-425, DHS’s reports for LIHEAP, etc.). Accordingly, the Agency is not in compliance with federal and state reporting as specified by grants and contracts and the Federal Audit Clearinghouse. The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR §200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §200.328 Financial reporting and §200.329. (Continued) Effect: Monitoring and reporting program performance [2 CFR §200.302(b)(2)]. Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency as determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountant and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant’s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statements close-out process is achieved each month and annually. Accounting policies and procedures must be updated and implemented. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the Agency’s financial funding sources, the Agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst’s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and Uniform Guidance regulations. The new automated financial systems, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2025.
SCHEDULE OF FINDINGS AND QUESTIONED COSTS Federal Award Findings and Questioned Costs July 31, 2024 Comment # 2024-002 INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION, GRANT CLOSE OUT AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED HEAD START AND EARLY HEAD START, LIHEAP, LIHWAP, CSBG, ASTHO, CACFP and CSLFRF FAL # 93.600, 93.568, 93.499, 93.569, 93.185, 10.558, 21.027 (Questioned Costs - Undetermined) Condition: As part of our auditing procedures, we assisted in the preparation of the financial statements, related disclosures, and the schedule of expenditures of federal awards of the Agency. The preparation of these financial statements in accordance with generally accepted accounting principles (GAAP) and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is the responsibility of the grantee. The authoritative and regulatory standards states in summary that management should authorize, process, reconcile and close-out each grant and contract in a timely manner to ensure proper accounting and reporting of such activity in accordance with the specific professional standards and regulatory requirements. The closeout process is designed to reduce the risk of errors, fraud, material misstatement of financial and compliance reporting and recognition of expenditures (or revenue) in the proper period. We noted that the current system of internal controls over financial statements and compliance is not designed to ensure that the objectives are achieved. Further, the capacity and experience of the current staff does not allow for adequate analysis of grants and contracts, proper allocations of shared costs and support services provided, grantor receivables, deferred revenue, and the reconciliation of bank accounts accurately and in a timely manner. This resulted in adjustments necessary to present the financial statements and disclosures of the Agency as of July 31, 2024. We also noted significant weaknesses in internal controls over personnel payroll and the processing, maintaining and reconciling payroll activity to the general ledger and external regulatory reporting (IRS Form 941's, state filings, etc.). Therefore, the risk exists that grant receivables and/or cash from the various programs are not recorded properly during the reporting period (interim and annually). This condition also makes it difficult to prepare accurate external reports required by the various funding sources in a timely manner (i.e. SF-425, DHS’s reports for LIHEAP, etc.). Accordingly, the Agency is not in compliance with federal and state reporting as specified by grants and contracts and the Federal Audit Clearinghouse. The systemic cause appears to be the untimely resignation of key personnel, a change in the accounting system, a lack of personnel with the skills, knowledge, and experience with grant accounting and a weakness in the overall system of internal accounting controls and monitoring. Policies and procedures are not followed consistently throughout the year. Context: Review of internal control structure of the organization in accordance with Government Auditing Standards. Criteria: Controls should be in place to ensure that financial statements are prepared in accordance with GAAP. The auditee shall prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. The auditee shall also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements. [2 CFR §200.510(a) and (b)] Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §200.328 Financial reporting and §200.329. (Continued) Effect: Monitoring and reporting program performance [2 CFR §200.302(b)(2)]. Management may not be able to obtain complete and accurate financial statements on an interim or fiscal year basis to be used for internal or external reporting purposes. Cause: Turnover of key staff, change in the accounting system, limited personnel with knowledge and/or the ability to assist and provide needed information to aid in financial statement preparation. Recommendation: The degree to which the preparation of the financial statements and related disclosures are prepared by the independent auditor is a control deficiency as determined by the knowledge, skills and experience of those in the organization who are charged with the responsibility of its financial reporting. The Agency has hired a new fiscal officer (CFO) and should hire additional staff (grant accountant and a general ledger accountant) to assist the new fiscal officer. New staff should have the adequate skills, knowledge and experience to oversee and/or perform the necessary accounting functions each month. Policies and procedures should be updated to adequately address the challenges and dynamics of the community action agency. We believe that the CFO with the supporting staff and general ledger accountant should have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner so as to eliminate the risk of significant errors occurring. Budget-to-actual schedules should be an integral part of the grant accountant’s basic responsibilities. Program directors should be involved in the closing process. We further recommend that training be provided to all staff engaged in the financial reporting, allocations and reconciliation functions to ensure that a complete and accurate financial statements close-out process is achieved each month and annually. Accounting policies and procedures must be updated and implemented. Views of Responsible Officials and Planned Corrective Actions: Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the Agency’s financial funding sources, the Agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst’s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and Uniform Guidance regulations. The new automated financial systems, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2025.