Assistance Listing Number, Federal Agency, and Program Name - 20.507 and 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Transit Formula Grants and Buses and Bus Facilities Formula, Competitive, and Low or No Emissions Program Federal Award Identification Number and Year - N/A Pass through Entity - Colorado Department of Transportation Finding Type - Material weakness Repeat Finding - Yes 2021-004 Criteria - 2 CFR 200.508(b) outlines the auditee responsibilities to prepare appropriate financial statements, including the schedule of expenditures of federal awards (SEFA), in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The City did not have sufficient controls in place to ensure that the schedule of expenditures of federal awards was prepared correctly. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The schedule of expenditures of federal awards required changes of approximately $2,062,000 in order for the SEFA to be correctly stated. The revisions made to the SEFA did not impact major program determination. Cause and Effect - The City included expenses spent relating to eligible expenses under the Federal Transit Cluster on the original SEFA; however, there was no approved grant award as of audit testing. Revisions to the schedule of expenditures of federal awards were required to ensure that reported expenditures were accurate and had approved grant agreements and awards. The revisions made to the SEFA did not impact major program determination. Recommendation - We recommend that the City implement sufficient processes and controls to ensure that the SEFA agrees to the underlying records of federal expenditures incurred. Views of Responsible Officials and Corrective Action Plan - The City hired a full time grants manager in February 2024 to establish procedures to track grants that are awarded to and expended by the City. A grant committee has been established with key personnel in the City that works with grants, and monitoring spreadsheets have been developed to track pending grant applications and awarded grant activity. These tools will be further enhanced with key due dates to ensure that grants are applied for by the required deadlines and requests for reimbursement are completed in a timely manner. In addition, the City will research grant management software options to further enhance grant monitoring.
Assistance Listing Number, Federal Agency, and Program Name - 20.507 and 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Transit Formula Grants and Buses and Bus Facilities Formula, Competitive, and Low or No Emissions Program Federal Award Identification Number and Year - N/A Pass through Entity - Colorado Department of Transportation Finding Type - Material weakness Repeat Finding - Yes 2021-004 Criteria - 2 CFR 200.508(b) outlines the auditee responsibilities to prepare appropriate financial statements, including the schedule of expenditures of federal awards (SEFA), in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The City did not have sufficient controls in place to ensure that the schedule of expenditures of federal awards was prepared correctly. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The schedule of expenditures of federal awards required changes of approximately $2,062,000 in order for the SEFA to be correctly stated. The revisions made to the SEFA did not impact major program determination. Cause and Effect - The City included expenses spent relating to eligible expenses under the Federal Transit Cluster on the original SEFA; however, there was no approved grant award as of audit testing. Revisions to the schedule of expenditures of federal awards were required to ensure that reported expenditures were accurate and had approved grant agreements and awards. The revisions made to the SEFA did not impact major program determination. Recommendation - We recommend that the City implement sufficient processes and controls to ensure that the SEFA agrees to the underlying records of federal expenditures incurred. Views of Responsible Officials and Corrective Action Plan - The City hired a full time grants manager in February 2024 to establish procedures to track grants that are awarded to and expended by the City. A grant committee has been established with key personnel in the City that works with grants, and monitoring spreadsheets have been developed to track pending grant applications and awarded grant activity. These tools will be further enhanced with key due dates to ensure that grants are applied for by the required deadlines and requests for reimbursement are completed in a timely manner. In addition, the City will research grant management software options to further enhance grant monitoring.
Schedule of Expenditures of Federal Awards Criteria: CFR Part 200.508 Audit Responsibilities state that the auditee must prepare the Schedule of Expenditures of Federal Awards, which must list individual federal awards by federal agency, including the total federal awards expended, name of pass-through entity, assistance listing number, and total amount provided to subrecipients. The information contained in the Schedule of Expenditures of Federal Awards should be derived from and relate directly to the underlying accounting and other records used to prepare the financial statements. Condition: The Schedule of Expenditures of Federal Awards was prepared by the auditor based on federal award contracts provided by the auditee. Also, during 2022 an additional federal award was received that management was not aware of. Cause: Management has limited knowledge on requirements of a Single Audit. Management relied on auditors to prepare the Schedule of Expenditures of Federal Awards. Effect: Potential understatement or overstatement of expenditures could exist in the Schedule of Expenditures of Federal Awards and not be detected or corrected. Questioned Costs: None noted. Recommendation: Establish procedures to prepare the annual Schedule of Expenditures of Federal Awards and reconcile amounts reported to the Organization's general ledger. The Organization should provide appropriate training to staff who work with government funding. Views of Responsible Officials and Planned Corrective Actions: Management concurs with the recommendation. Management has hired a compliance administrator to track all grants, including federal, state and county. Management and Butler CPA firm will ensure training to establish procedures and the preparation of the Schedule of Expenditures of Federal Awards.
Finding 2022-003: Reconciliation of Accounts Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1500529 (9/1/2015 – 8/31/2022), 1640791 (9/15/2016 – 8/31/2022) Federal Program: Research and Development Cluster (Mathematical and Physical Sciences) Material Weakness in Internal Control over Compliance, Material Noncompliance Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2022. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2022, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $115,244 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2022 and did not have expenses or drawdowns in 2022 but by the end of 2018 had $138,034 in federal funding provided to AAPT and $75,631 of reimbursable expenses. AAPT had not refunded the overpayment, such as by applying this $62,403 as a reduction in federal reimbursements drawn during 2022. The remaining amounts of $10,112, $8,307, $33,615, and $807 relate to award IDs 1812860, 1524963, 1500529, and 1640791, respectively, and were calculated in the same manner. The period of performance for award IDs 1812860 and 1524963 ended prior to 1/1/2022. The period of performance for award IDs 1500529 and 1640791 ended on 8/31/2022. Identification as a Repeat Finding, if Applicable: 2021-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $115,244 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 10/15/2024 Responsible Official: Michael Brosnan, CFO
Finding 2022-003: Reconciliation of Accounts Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1500529 (9/1/2015 – 8/31/2022), 1640791 (9/15/2016 – 8/31/2022) Federal Program: Research and Development Cluster (Mathematical and Physical Sciences) Material Weakness in Internal Control over Compliance, Material Noncompliance Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2022. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2022, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $115,244 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2022 and did not have expenses or drawdowns in 2022 but by the end of 2018 had $138,034 in federal funding provided to AAPT and $75,631 of reimbursable expenses. AAPT had not refunded the overpayment, such as by applying this $62,403 as a reduction in federal reimbursements drawn during 2022. The remaining amounts of $10,112, $8,307, $33,615, and $807 relate to award IDs 1812860, 1524963, 1500529, and 1640791, respectively, and were calculated in the same manner. The period of performance for award IDs 1812860 and 1524963 ended prior to 1/1/2022. The period of performance for award IDs 1500529 and 1640791 ended on 8/31/2022. Identification as a Repeat Finding, if Applicable: 2021-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $115,244 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 10/15/2024 Responsible Official: Michael Brosnan, CFO
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Finding: 2022-009 (Significant Deficiency) Agency: All Federal Agencies ALN # and Title: All Assistance Listing Numbers Federal Award Identification # and Year: All Federal Awards Criteria: Per 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (“SEFA”) that includes all federal expenditures, organized by assistance listing number and must be accurate and complete. Additionally, 2 CFR 200.508(b) requires the auditee – not the auditor – to prepare the SEFA. Condition: UCCAC did not maintain an accurate Schedule of Expenditures of Federal Awards (“SEFA”). The original SEFA omitted some federal programs and misstated expenditures for others. Adjustments were required to reconcile the SEFA to the general ledger and supporting documentation. Effect: The inaccurate SEFA could result in improper identification of major programs and insufficient audit coverage, potentially leading to noncompliance with federal audit requirements. Cause: UCCAC lacked adequate internal controls over the preparation and review of the SEFA. There was no formal reconciliation process between the SEFA and the general ledger. Recommendation: We recommend that UCCAC implement formal procedures to ensure the SEFA is complete, accurate, and reconciled to the general ledger. This should include a documented review process and training for staff involved in SEFA preparation. In addition, we recommend that additional general ledger tracking codes be entered into Fund-EZ (general ledger) to track grant expenditures and that grant programs be monitored for inclusion in the SEFA. Management’s Corrective Action Plan: Management has indicated that they have put certain procedures into place as detailed in the Corrective Action Plan located in Appendix A.
Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.
Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.
Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.
Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.
ALN, Federal Agency, and Program Name 20.106 Federal Aviation Administration - Airport Improvement Program State CFSA Number, State Agency, and Program Name - 55.004 Florida Department of Transportation Aviation Development Grants Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness Repeat Finding Yes Criteria Per 2 CFR 200.508 (b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee?s financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended Condition The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on and excluded from the SEFA related to ALN 20.106 (Airport Improvement Program) and State CFSA 55.004 (FDOT Aviation Development Grants). Cause and Effect Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the Authority's schedule of expenditures of federal awards provided to the auditors being inaccurate. Recommendation Internal control procedures should be initiated and enforced to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The Authority will strengthen its controls around the grant review process. In addition to the second-level review and approval process for grant revenue, the Authority will implement a quarterly review to identify eligible expenditures for federal and state grant reimbursements to ensure revenue is recognized in the proper period.
ALN, Federal Agency, and Program Name 20.106 Federal Aviation Administration - Airport Improvement Program State CFSA Number, State Agency, and Program Name - 55.004 Florida Department of Transportation Aviation Development Grants Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness Repeat Finding Yes Criteria Per 2 CFR 200.508 (b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee?s financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended Condition The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on and excluded from the SEFA related to ALN 20.106 (Airport Improvement Program) and State CFSA 55.004 (FDOT Aviation Development Grants). Cause and Effect Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the Authority's schedule of expenditures of federal awards provided to the auditors being inaccurate. Recommendation Internal control procedures should be initiated and enforced to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The Authority will strengthen its controls around the grant review process. In addition to the second-level review and approval process for grant revenue, the Authority will implement a quarterly review to identify eligible expenditures for federal and state grant reimbursements to ensure revenue is recognized in the proper period.
ALN, Federal Agency, and Program Name 20.106 Federal Aviation Administration - Airport Improvement Program State CFSA Number, State Agency, and Program Name - 55.004 Florida Department of Transportation Aviation Development Grants Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness Repeat Finding Yes Criteria Per 2 CFR 200.508 (b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee?s financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended Condition The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on and excluded from the SEFA related to ALN 20.106 (Airport Improvement Program) and State CFSA 55.004 (FDOT Aviation Development Grants). Cause and Effect Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the Authority's schedule of expenditures of federal awards provided to the auditors being inaccurate. Recommendation Internal control procedures should be initiated and enforced to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The Authority will strengthen its controls around the grant review process. In addition to the second-level review and approval process for grant revenue, the Authority will implement a quarterly review to identify eligible expenditures for federal and state grant reimbursements to ensure revenue is recognized in the proper period.
ALN, Federal Agency, and Program Name 20.106 Federal Aviation Administration - Airport Improvement Program State CFSA Number, State Agency, and Program Name - 55.004 Florida Department of Transportation Aviation Development Grants Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness Repeat Finding Yes Criteria Per 2 CFR 200.508 (b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee?s financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended Condition The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on and excluded from the SEFA related to ALN 20.106 (Airport Improvement Program) and State CFSA 55.004 (FDOT Aviation Development Grants). Cause and Effect Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the Authority's schedule of expenditures of federal awards provided to the auditors being inaccurate. Recommendation Internal control procedures should be initiated and enforced to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The Authority will strengthen its controls around the grant review process. In addition to the second-level review and approval process for grant revenue, the Authority will implement a quarterly review to identify eligible expenditures for federal and state grant reimbursements to ensure revenue is recognized in the proper period.
ALN, Federal Agency, and Program Name 20.106 Federal Aviation Administration - Airport Improvement Program State CFSA Number, State Agency, and Program Name - 55.004 Florida Department of Transportation Aviation Development Grants Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness Repeat Finding Yes Criteria Per 2 CFR 200.508 (b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee?s financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended Condition The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on and excluded from the SEFA related to ALN 20.106 (Airport Improvement Program) and State CFSA 55.004 (FDOT Aviation Development Grants). Cause and Effect Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the Authority's schedule of expenditures of federal awards provided to the auditors being inaccurate. Recommendation Internal control procedures should be initiated and enforced to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The Authority will strengthen its controls around the grant review process. In addition to the second-level review and approval process for grant revenue, the Authority will implement a quarterly review to identify eligible expenditures for federal and state grant reimbursements to ensure revenue is recognized in the proper period.
ALN, Federal Agency, and Program Name 20.106 Federal Aviation Administration - Airport Improvement Program State CFSA Number, State Agency, and Program Name - 55.004 Florida Department of Transportation Aviation Development Grants Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness Repeat Finding Yes Criteria Per 2 CFR 200.508 (b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee?s financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended Condition The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on and excluded from the SEFA related to ALN 20.106 (Airport Improvement Program) and State CFSA 55.004 (FDOT Aviation Development Grants). Cause and Effect Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the Authority's schedule of expenditures of federal awards provided to the auditors being inaccurate. Recommendation Internal control procedures should be initiated and enforced to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The Authority will strengthen its controls around the grant review process. In addition to the second-level review and approval process for grant revenue, the Authority will implement a quarterly review to identify eligible expenditures for federal and state grant reimbursements to ensure revenue is recognized in the proper period.
ALN, Federal Agency, and Program Name 20.106 Federal Aviation Administration - Airport Improvement Program State CFSA Number, State Agency, and Program Name - 55.004 Florida Department of Transportation Aviation Development Grants Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness Repeat Finding Yes Criteria Per 2 CFR 200.508 (b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee?s financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended Condition The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on and excluded from the SEFA related to ALN 20.106 (Airport Improvement Program) and State CFSA 55.004 (FDOT Aviation Development Grants). Cause and Effect Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the Authority's schedule of expenditures of federal awards provided to the auditors being inaccurate. Recommendation Internal control procedures should be initiated and enforced to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The Authority will strengthen its controls around the grant review process. In addition to the second-level review and approval process for grant revenue, the Authority will implement a quarterly review to identify eligible expenditures for federal and state grant reimbursements to ensure revenue is recognized in the proper period.
ALN, Federal Agency, and Program Name 20.106 Federal Aviation Administration - Airport Improvement Program State CFSA Number, State Agency, and Program Name - 55.004 Florida Department of Transportation Aviation Development Grants Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness Repeat Finding Yes Criteria Per 2 CFR 200.508 (b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee?s financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended Condition The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on and excluded from the SEFA related to ALN 20.106 (Airport Improvement Program) and State CFSA 55.004 (FDOT Aviation Development Grants). Cause and Effect Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the Authority's schedule of expenditures of federal awards provided to the auditors being inaccurate. Recommendation Internal control procedures should be initiated and enforced to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The Authority will strengthen its controls around the grant review process. In addition to the second-level review and approval process for grant revenue, the Authority will implement a quarterly review to identify eligible expenditures for federal and state grant reimbursements to ensure revenue is recognized in the proper period.
Assistance Listing Number, Federal Agency, and Program Name - 21.027 U.S. Department of the Treasury Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - YDYNCVFA9NH4 Pass through Entity - City of Raleigh, North Carolina Finding Type - Material weakness Repeat Finding - No Criteria - Per 2 CFR 200.508(b), an auditee must prepare appropriate financial statements, including the schedule of expenditures of federal awards, in accordance with 200.510 financial statements. Per 2 CFR 200.510(b), the auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502 basis for determining federal awards expended. Condition - Controls in place were not adequate to ensure the schedule of federal expenditures was complete and accurate. Questioned Costs - N/A Identification of How Questioned Costs Were Computed - N/A Context - WakeMed did not initially include the funds received through the U.S. Department of the Treasury American Rescue Plan Act of 2021, Coronavirus State and Local Fiscal Recovery Funds on the SEFA. Cause and Effect - WakeMed did not have a process in place to identify all potential sources of federal funding received during the year, resulting in the SEFA being incomplete for the year ended September 30, 2022. Upon discovery of the error, WakeMed prepared a SEFA that included the U.S. Department of the Treasury American Rescue Plan Act of 2021, Coronavirus State and Local Fiscal Recovery Funds. This lack of controls resulted in the reissuance of the 2022 single audit. Recommendation - Management should implement controls to ensure all federal funding received is properly identified as such and included on the SEFA. Views of Responsible Officials and Planned Corrective Actions - Management agrees with the finding as reported. The federal funding was not received until fiscal year 2023 while some expenditures were incurred in fiscal year 2022. The timing of events contributed to the oversight on the 2022 SEFA. WakeMed has reeducated staff on the preparation of the SEFA in order to prevent this error from reoccurring.
Assistance Listing Number, Federal Agency, and Program Name - 66.818, U.S. Environmental Protection Agency, Brownfields Assessment and Cleanup Cooperative Agreements; 14.218, U.S. Department of Housing and Urban Development, Community Development Block Grant Entitlement Grants Cluster Federal Award Identification Number and Year - N/A Passthrough Entity - 66.818, Brownfields Assessment and Cleanup of Cooperative Agreements is direct funded. 14.218, Community Development Block Grant is passed through Wayne County, Michigan. Finding Type - Material weakness Repeat Finding - No Criteria - The Single Audit Act and Uniform Guidance require a nonfederal entity that expends $750,000 or more of federal awards in a fiscal year to have a single or program specific audit. 2 CFR §200.508 (b) indicates that the auditee must prepare financial statements, including the schedule of expenditures of Federal awards in accordance with 2 CFR §200.510. Additionally, 2 CFR §200.502 describes the basis for determining the timing of when federal awards are deemed expended and, therefore, reportable on the schedule. Condition - The schedule of expenditures of federal awards (SEFA) was not accurate. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - During the fiscal year ended September 30, 2022, the City expended approximately $921,000 of federal funding. The initial draft of the SEFA included the following inaccuracies: ALN 66.818 The expenditures reported on the SEFA were understated by $125,687. ALN 14.218 The expenditures reported on the SEFA were understated by $80,468. The errors noted above have been corrected on the SEFA as of September 30, 2022. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit, as the City did not include use of program income in its review of federal expenditures. The errors resulted in the understatement of federal expenditures, as noted in the context above. Additionally, the understatement of federal expenditures on the SEFA resulted in the incorrect conclusion that federal activity was below $750,000, and, therefore, a single audit was not needed. Recommendation - We recommend the City implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan - The City will review its process for identifying and communicating Federal Grant expenditures to its auditors.
Assistance Listing Number, Federal Agency, and Program Name - 66.818, U.S. Environmental Protection Agency, Brownfields Assessment and Cleanup Cooperative Agreements; 14.218, U.S. Department of Housing and Urban Development, Community Development Block Grant Entitlement Grants Cluster Federal Award Identification Number and Year - N/A Passthrough Entity - 66.818, Brownfields Assessment and Cleanup of Cooperative Agreements is direct funded. 14.218, Community Development Block Grant is passed through Wayne County, Michigan. Finding Type - Material weakness Repeat Finding - No Criteria - The Single Audit Act and Uniform Guidance require a nonfederal entity that expends $750,000 or more of federal awards in a fiscal year to have a single or program specific audit. 2 CFR §200.508 (b) indicates that the auditee must prepare financial statements, including the schedule of expenditures of Federal awards in accordance with 2 CFR §200.510. Additionally, 2 CFR §200.502 describes the basis for determining the timing of when federal awards are deemed expended and, therefore, reportable on the schedule. Condition - The schedule of expenditures of federal awards (SEFA) was not accurate. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - During the fiscal year ended September 30, 2022, the City expended approximately $921,000 of federal funding. The initial draft of the SEFA included the following inaccuracies: ALN 66.818 The expenditures reported on the SEFA were understated by $125,687. ALN 14.218 The expenditures reported on the SEFA were understated by $80,468. The errors noted above have been corrected on the SEFA as of September 30, 2022. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit, as the City did not include use of program income in its review of federal expenditures. The errors resulted in the understatement of federal expenditures, as noted in the context above. Additionally, the understatement of federal expenditures on the SEFA resulted in the incorrect conclusion that federal activity was below $750,000, and, therefore, a single audit was not needed. Recommendation - We recommend the City implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan - The City will review its process for identifying and communicating Federal Grant expenditures to its auditors.
Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.
Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.
Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.
Section III ? Findings and Questioned Costs for Major Federal Awards 2022-002 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness ? All Awards) Criteria ? 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, #200.508 (b) The auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with #200.510, Financial Statements. Condition and Context ? The following errors were noted and corrected as a result of auditing procedures on the SEFA: * All funds for WIC were listed under agreement CD4-21-4655B. A significant amount of these funds was provided under agreement CD4-22-4655. * TANF expenditures were understated by $12,215. * TANF was incorrectly identified as part of a cluster. * ERA funds were reported as being funded through US DHHS. * Head Start was not identified as being part of a cluster. * CACFP expenditures were understated by $35,656. * CACFP expenditures were listed as being passed though ME DHHS. This agreement is through ME DOE (education). * WIC expenditures were understated by $179,782. * Several COVID-19 programs did not include the appropriate prefix. Cause ? Insufficient internal controls over the preparation, review, and documentation process for the SEFA. Effect ? Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections would have led to the SEFA being materially misstated. They would also lead to findings and corrective action with funders. Questioned Costs ? None Recommendations ? Management should seek additional training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, reporting, and the trial balance. Any inconsistencies should be resolved before beginning the audit. Management?s records should require the identification of the preparer and reviewer as well as the dates each of those tasks were performed. Management could consider requiring a preparation and review process checklist as required documentation for the Organization?s reporting records to help ensure key processes are performed and reviewed. Views of Responsible Officials and Planned Corrective Actions ? The Director of Fiscal will seek additional training on the preparation of the SEFA schedule provided to auditors for new staff to participate in. Before submission to auditors there will be a check and review process in which the Fiscal Director or delegate will review the schedule and initial for a backup copy. All back up documentation will be provided during the submission so review by auditors will be clearer. For this review to take place there will be an internal review and check list provided.
ALN, Federal Agency, and Program Name 20.106 Federal Aviation Administration - Airport Improvement Program State CFSA Number, State Agency, and Program Name - 55.004 Florida Department of Transportation Aviation Development Grants Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness Repeat Finding Yes Criteria Per 2 CFR 200.508 (b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee?s financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended Condition The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on and excluded from the SEFA related to ALN 20.106 (Airport Improvement Program) and State CFSA 55.004 (FDOT Aviation Development Grants). Cause and Effect Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the Authority's schedule of expenditures of federal awards provided to the auditors being inaccurate. Recommendation Internal control procedures should be initiated and enforced to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The Authority will strengthen its controls around the grant review process. In addition to the second-level review and approval process for grant revenue, the Authority will implement a quarterly review to identify eligible expenditures for federal and state grant reimbursements to ensure revenue is recognized in the proper period.
ALN, Federal Agency, and Program Name 20.106 Federal Aviation Administration - Airport Improvement Program State CFSA Number, State Agency, and Program Name - 55.004 Florida Department of Transportation Aviation Development Grants Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness Repeat Finding Yes Criteria Per 2 CFR 200.508 (b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee?s financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended Condition The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on and excluded from the SEFA related to ALN 20.106 (Airport Improvement Program) and State CFSA 55.004 (FDOT Aviation Development Grants). Cause and Effect Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the Authority's schedule of expenditures of federal awards provided to the auditors being inaccurate. Recommendation Internal control procedures should be initiated and enforced to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The Authority will strengthen its controls around the grant review process. In addition to the second-level review and approval process for grant revenue, the Authority will implement a quarterly review to identify eligible expenditures for federal and state grant reimbursements to ensure revenue is recognized in the proper period.
ALN, Federal Agency, and Program Name 20.106 Federal Aviation Administration - Airport Improvement Program State CFSA Number, State Agency, and Program Name - 55.004 Florida Department of Transportation Aviation Development Grants Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness Repeat Finding Yes Criteria Per 2 CFR 200.508 (b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee?s financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended Condition The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on and excluded from the SEFA related to ALN 20.106 (Airport Improvement Program) and State CFSA 55.004 (FDOT Aviation Development Grants). Cause and Effect Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the Authority's schedule of expenditures of federal awards provided to the auditors being inaccurate. Recommendation Internal control procedures should be initiated and enforced to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The Authority will strengthen its controls around the grant review process. In addition to the second-level review and approval process for grant revenue, the Authority will implement a quarterly review to identify eligible expenditures for federal and state grant reimbursements to ensure revenue is recognized in the proper period.
ALN, Federal Agency, and Program Name 20.106 Federal Aviation Administration - Airport Improvement Program State CFSA Number, State Agency, and Program Name - 55.004 Florida Department of Transportation Aviation Development Grants Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness Repeat Finding Yes Criteria Per 2 CFR 200.508 (b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee?s financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended Condition The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on and excluded from the SEFA related to ALN 20.106 (Airport Improvement Program) and State CFSA 55.004 (FDOT Aviation Development Grants). Cause and Effect Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the Authority's schedule of expenditures of federal awards provided to the auditors being inaccurate. Recommendation Internal control procedures should be initiated and enforced to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The Authority will strengthen its controls around the grant review process. In addition to the second-level review and approval process for grant revenue, the Authority will implement a quarterly review to identify eligible expenditures for federal and state grant reimbursements to ensure revenue is recognized in the proper period.
ALN, Federal Agency, and Program Name 20.106 Federal Aviation Administration - Airport Improvement Program State CFSA Number, State Agency, and Program Name - 55.004 Florida Department of Transportation Aviation Development Grants Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness Repeat Finding Yes Criteria Per 2 CFR 200.508 (b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee?s financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended Condition The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on and excluded from the SEFA related to ALN 20.106 (Airport Improvement Program) and State CFSA 55.004 (FDOT Aviation Development Grants). Cause and Effect Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the Authority's schedule of expenditures of federal awards provided to the auditors being inaccurate. Recommendation Internal control procedures should be initiated and enforced to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The Authority will strengthen its controls around the grant review process. In addition to the second-level review and approval process for grant revenue, the Authority will implement a quarterly review to identify eligible expenditures for federal and state grant reimbursements to ensure revenue is recognized in the proper period.
ALN, Federal Agency, and Program Name 20.106 Federal Aviation Administration - Airport Improvement Program State CFSA Number, State Agency, and Program Name - 55.004 Florida Department of Transportation Aviation Development Grants Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness Repeat Finding Yes Criteria Per 2 CFR 200.508 (b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee?s financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended Condition The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on and excluded from the SEFA related to ALN 20.106 (Airport Improvement Program) and State CFSA 55.004 (FDOT Aviation Development Grants). Cause and Effect Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the Authority's schedule of expenditures of federal awards provided to the auditors being inaccurate. Recommendation Internal control procedures should be initiated and enforced to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The Authority will strengthen its controls around the grant review process. In addition to the second-level review and approval process for grant revenue, the Authority will implement a quarterly review to identify eligible expenditures for federal and state grant reimbursements to ensure revenue is recognized in the proper period.
ALN, Federal Agency, and Program Name 20.106 Federal Aviation Administration - Airport Improvement Program State CFSA Number, State Agency, and Program Name - 55.004 Florida Department of Transportation Aviation Development Grants Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness Repeat Finding Yes Criteria Per 2 CFR 200.508 (b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee?s financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended Condition The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on and excluded from the SEFA related to ALN 20.106 (Airport Improvement Program) and State CFSA 55.004 (FDOT Aviation Development Grants). Cause and Effect Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the Authority's schedule of expenditures of federal awards provided to the auditors being inaccurate. Recommendation Internal control procedures should be initiated and enforced to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The Authority will strengthen its controls around the grant review process. In addition to the second-level review and approval process for grant revenue, the Authority will implement a quarterly review to identify eligible expenditures for federal and state grant reimbursements to ensure revenue is recognized in the proper period.