2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-003 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness in Internal Controls over Compliance)—All Awards) Criteria: 2 CFR 200, Uniform Administrative Requirements, Cost Principles, 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: • CRA program federal expenditures (CFDA #14.228) were understated by $23,893. • ACL Independent Living State Grants federal expenditures (CFDA #93.369) were overstated by $21,856 due to errors in SEFA preparation. • Several presentational errors including incorrect identifying numbers listed, incorrect award terms listed, and incorrect CFDA #’s listed for multiple awards. Cause: Insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: Errors on reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. The above corrections, if not made, would have led to the SEFA being materially misstated. They could also lead to findings and corrective action with funders. Questioned Costs: None Recommendation: Management should continue to seek additional training for the fiscal department on preparation of the SEFA and reporting standards. In addition, review processes over the SEFA and supporting reports should be strengthened. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Steps should be taken to prevent further adjustment of supporting profit and loss reports once reconciled without the express review and approval of the Fiscal Director. Review of the standards for supporting grant reports should be strengthened to prevent errors in reporting leading to errors on the SEFA. Any inconsistencies should be resolved before beginning the audit. Management has taken steps to identify and seek training in areas they have identified as needing improvement. Views of Responsible Officials and Planned Corrective Actions: Management acknowledges the audit findings and the material weakness related to the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The errors identified stemmed from insufficient internal controls over the preparation and review process. Additionally, there were inconsistencies in how the SEFA was prepared in previous years, compounded by a quick turnover to a new controller at year-end, which disrupted continuity and contributed to the lack of clear guidance in the SEFA preparation process. To address these challenges, management has implemented immediate corrective actions, including enhanced training for all staff involved in the SEFA preparation to ensure a thorough understanding of federal reporting standards and the required minimum elements. Furthermore, all SEFA components will be reconciled with original source documents, such as grant awards and trial balances, prior to submission for audit. Management believes that, with the new internal control measures and training in place, these errors are not expected to occur in future years.
2024-001 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards and Reporting for Maine DHHS 93.667 Social Services Block Grant (SSBG) and Maine DHHS 21.027 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (Significant Deficiency in Internal Controls over Compliance and Noncompliance) 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. Federal reporting standards require the timely and accurate filing of reports as required by pass-through grantor agreements. Condition and Context: Agreement Closeout Report filed for the Agreement ADS-23-3351D (Social Services Block Grant) for the component period ended 6/30/24 was filed late by 27 days. In addition, the report contained inaccuracies including use of fee-for-service rates that were not specified by the Fee For Service Rider. Reporting for the period ended 6/30/24 contained inaccuracies resulting from budgeted income and expenses sourced from an outdated contract amendment, budgeted percentage of expenses reimbursable by state and federal agreement funds, and the total component amount received by the provider for service months in the reporting period. In addition, to the conditions noted above, the following errors were noted and corrected as a result of auditing procedures on the SEFA: • Social Services Block Grant expenditures were overstated by $159,088 due to errors in accounting for expenditures of the grant which were based on outdated calculations. • Federal expenditures were understated for the State of Maine DHHS Agreement ADS-23-3004B (93.044 Special Programs for the Aging – Title III, Part B, Grants for Supportive Services and Senior Centers) by $27,492 due to errors in reconciling grant reports to the SEFA. • Federal expenditures were overstated for the State of Maine DHHS Agreement ADS-24-3004B (Coronavirus State and Local Fiscal Recovery Funds) by $25,500 due to errors reconciling grant reports to the SEFA. Cause: There is a gap in training and understanding of the instructions for the Maine DHHS Agreement Closeout Report and Quarterly Financial Report. There are insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: The Agreement Closeout Report was filed 27 days late. The Agreement Closeout Report was filed using incorrect reporting forms. Due to errors in entering federal funds available for cost sharing and calculating department funds not utilized, Agreement Cost Sharing percentages were incorrectly calculated by the reporting form. Incorrect component agreement funds and budgeted income and expenses were referenced, as key information was omitted which prevented the quarterly reports from calculating the amounts due to or from the Agency. Errors in reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. They could also lead to findings and corrective action with funders. Recommendation: Management should review their processes and procedures over review and approval of reporting, and for tracking of reporting deadlines. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Any inconsistencies should be resolved before submission. Management should strengthen their controls for the tracking of required report filings and their due dates. Management should consider training for staff tasked with completing, reviewing, and filing these reports. Views of Responsible Officials and Planned Corrective Actions: Management will review and update processes and procedures over reporting and additional training will be provided as needed to prevent future findings.
2024-001 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards and Reporting for Maine DHHS 93.667 Social Services Block Grant (SSBG) and Maine DHHS 21.027 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (Significant Deficiency in Internal Controls over Compliance and Noncompliance) 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. Federal reporting standards require the timely and accurate filing of reports as required by pass-through grantor agreements. Condition and Context: Agreement Closeout Report filed for the Agreement ADS-23-3351D (Social Services Block Grant) for the component period ended 6/30/24 was filed late by 27 days. In addition, the report contained inaccuracies including use of fee-for-service rates that were not specified by the Fee For Service Rider. Reporting for the period ended 6/30/24 contained inaccuracies resulting from budgeted income and expenses sourced from an outdated contract amendment, budgeted percentage of expenses reimbursable by state and federal agreement funds, and the total component amount received by the provider for service months in the reporting period. In addition, to the conditions noted above, the following errors were noted and corrected as a result of auditing procedures on the SEFA: • Social Services Block Grant expenditures were overstated by $159,088 due to errors in accounting for expenditures of the grant which were based on outdated calculations. • Federal expenditures were understated for the State of Maine DHHS Agreement ADS-23-3004B (93.044 Special Programs for the Aging – Title III, Part B, Grants for Supportive Services and Senior Centers) by $27,492 due to errors in reconciling grant reports to the SEFA. • Federal expenditures were overstated for the State of Maine DHHS Agreement ADS-24-3004B (Coronavirus State and Local Fiscal Recovery Funds) by $25,500 due to errors reconciling grant reports to the SEFA. Cause: There is a gap in training and understanding of the instructions for the Maine DHHS Agreement Closeout Report and Quarterly Financial Report. There are insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: The Agreement Closeout Report was filed 27 days late. The Agreement Closeout Report was filed using incorrect reporting forms. Due to errors in entering federal funds available for cost sharing and calculating department funds not utilized, Agreement Cost Sharing percentages were incorrectly calculated by the reporting form. Incorrect component agreement funds and budgeted income and expenses were referenced, as key information was omitted which prevented the quarterly reports from calculating the amounts due to or from the Agency. Errors in reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. They could also lead to findings and corrective action with funders. Recommendation: Management should review their processes and procedures over review and approval of reporting, and for tracking of reporting deadlines. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Any inconsistencies should be resolved before submission. Management should strengthen their controls for the tracking of required report filings and their due dates. Management should consider training for staff tasked with completing, reviewing, and filing these reports. Views of Responsible Officials and Planned Corrective Actions: Management will review and update processes and procedures over reporting and additional training will be provided as needed to prevent future findings.
2024-001 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards and Reporting for Maine DHHS 93.667 Social Services Block Grant (SSBG) and Maine DHHS 21.027 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (Significant Deficiency in Internal Controls over Compliance and Noncompliance) 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. Federal reporting standards require the timely and accurate filing of reports as required by pass-through grantor agreements. Condition and Context: Agreement Closeout Report filed for the Agreement ADS-23-3351D (Social Services Block Grant) for the component period ended 6/30/24 was filed late by 27 days. In addition, the report contained inaccuracies including use of fee-for-service rates that were not specified by the Fee For Service Rider. Reporting for the period ended 6/30/24 contained inaccuracies resulting from budgeted income and expenses sourced from an outdated contract amendment, budgeted percentage of expenses reimbursable by state and federal agreement funds, and the total component amount received by the provider for service months in the reporting period. In addition, to the conditions noted above, the following errors were noted and corrected as a result of auditing procedures on the SEFA: • Social Services Block Grant expenditures were overstated by $159,088 due to errors in accounting for expenditures of the grant which were based on outdated calculations. • Federal expenditures were understated for the State of Maine DHHS Agreement ADS-23-3004B (93.044 Special Programs for the Aging – Title III, Part B, Grants for Supportive Services and Senior Centers) by $27,492 due to errors in reconciling grant reports to the SEFA. • Federal expenditures were overstated for the State of Maine DHHS Agreement ADS-24-3004B (Coronavirus State and Local Fiscal Recovery Funds) by $25,500 due to errors reconciling grant reports to the SEFA. Cause: There is a gap in training and understanding of the instructions for the Maine DHHS Agreement Closeout Report and Quarterly Financial Report. There are insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: The Agreement Closeout Report was filed 27 days late. The Agreement Closeout Report was filed using incorrect reporting forms. Due to errors in entering federal funds available for cost sharing and calculating department funds not utilized, Agreement Cost Sharing percentages were incorrectly calculated by the reporting form. Incorrect component agreement funds and budgeted income and expenses were referenced, as key information was omitted which prevented the quarterly reports from calculating the amounts due to or from the Agency. Errors in reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. They could also lead to findings and corrective action with funders. Recommendation: Management should review their processes and procedures over review and approval of reporting, and for tracking of reporting deadlines. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Any inconsistencies should be resolved before submission. Management should strengthen their controls for the tracking of required report filings and their due dates. Management should consider training for staff tasked with completing, reviewing, and filing these reports. Views of Responsible Officials and Planned Corrective Actions: Management will review and update processes and procedures over reporting and additional training will be provided as needed to prevent future findings.
2024-001 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards and Reporting for Maine DHHS 93.667 Social Services Block Grant (SSBG) and Maine DHHS 21.027 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (Significant Deficiency in Internal Controls over Compliance and Noncompliance) 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. Federal reporting standards require the timely and accurate filing of reports as required by pass-through grantor agreements. Condition and Context: Agreement Closeout Report filed for the Agreement ADS-23-3351D (Social Services Block Grant) for the component period ended 6/30/24 was filed late by 27 days. In addition, the report contained inaccuracies including use of fee-for-service rates that were not specified by the Fee For Service Rider. Reporting for the period ended 6/30/24 contained inaccuracies resulting from budgeted income and expenses sourced from an outdated contract amendment, budgeted percentage of expenses reimbursable by state and federal agreement funds, and the total component amount received by the provider for service months in the reporting period. In addition, to the conditions noted above, the following errors were noted and corrected as a result of auditing procedures on the SEFA: • Social Services Block Grant expenditures were overstated by $159,088 due to errors in accounting for expenditures of the grant which were based on outdated calculations. • Federal expenditures were understated for the State of Maine DHHS Agreement ADS-23-3004B (93.044 Special Programs for the Aging – Title III, Part B, Grants for Supportive Services and Senior Centers) by $27,492 due to errors in reconciling grant reports to the SEFA. • Federal expenditures were overstated for the State of Maine DHHS Agreement ADS-24-3004B (Coronavirus State and Local Fiscal Recovery Funds) by $25,500 due to errors reconciling grant reports to the SEFA. Cause: There is a gap in training and understanding of the instructions for the Maine DHHS Agreement Closeout Report and Quarterly Financial Report. There are insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: The Agreement Closeout Report was filed 27 days late. The Agreement Closeout Report was filed using incorrect reporting forms. Due to errors in entering federal funds available for cost sharing and calculating department funds not utilized, Agreement Cost Sharing percentages were incorrectly calculated by the reporting form. Incorrect component agreement funds and budgeted income and expenses were referenced, as key information was omitted which prevented the quarterly reports from calculating the amounts due to or from the Agency. Errors in reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. They could also lead to findings and corrective action with funders. Recommendation: Management should review their processes and procedures over review and approval of reporting, and for tracking of reporting deadlines. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Any inconsistencies should be resolved before submission. Management should strengthen their controls for the tracking of required report filings and their due dates. Management should consider training for staff tasked with completing, reviewing, and filing these reports. Views of Responsible Officials and Planned Corrective Actions: Management will review and update processes and procedures over reporting and additional training will be provided as needed to prevent future findings.
2024-001 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards and Reporting for Maine DHHS 93.667 Social Services Block Grant (SSBG) and Maine DHHS 21.027 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (Significant Deficiency in Internal Controls over Compliance and Noncompliance) 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. Federal reporting standards require the timely and accurate filing of reports as required by pass-through grantor agreements. Condition and Context: Agreement Closeout Report filed for the Agreement ADS-23-3351D (Social Services Block Grant) for the component period ended 6/30/24 was filed late by 27 days. In addition, the report contained inaccuracies including use of fee-for-service rates that were not specified by the Fee For Service Rider. Reporting for the period ended 6/30/24 contained inaccuracies resulting from budgeted income and expenses sourced from an outdated contract amendment, budgeted percentage of expenses reimbursable by state and federal agreement funds, and the total component amount received by the provider for service months in the reporting period. In addition, to the conditions noted above, the following errors were noted and corrected as a result of auditing procedures on the SEFA: • Social Services Block Grant expenditures were overstated by $159,088 due to errors in accounting for expenditures of the grant which were based on outdated calculations. • Federal expenditures were understated for the State of Maine DHHS Agreement ADS-23-3004B (93.044 Special Programs for the Aging – Title III, Part B, Grants for Supportive Services and Senior Centers) by $27,492 due to errors in reconciling grant reports to the SEFA. • Federal expenditures were overstated for the State of Maine DHHS Agreement ADS-24-3004B (Coronavirus State and Local Fiscal Recovery Funds) by $25,500 due to errors reconciling grant reports to the SEFA. Cause: There is a gap in training and understanding of the instructions for the Maine DHHS Agreement Closeout Report and Quarterly Financial Report. There are insufficient internal controls over the preparation, review, and documentation process for the SEFA and supporting documents. Effect: The Agreement Closeout Report was filed 27 days late. The Agreement Closeout Report was filed using incorrect reporting forms. Due to errors in entering federal funds available for cost sharing and calculating department funds not utilized, Agreement Cost Sharing percentages were incorrectly calculated by the reporting form. Incorrect component agreement funds and budgeted income and expenses were referenced, as key information was omitted which prevented the quarterly reports from calculating the amounts due to or from the Agency. Errors in reporting can lead to issues in reconciling and tracking of awards earned and recognized in the financial statements. They could also lead to findings and corrective action with funders. Recommendation: Management should review their processes and procedures over review and approval of reporting, and for tracking of reporting deadlines. Both the preparer and reviewer should have a clear understanding of the required minimum elements and instructions. As part of the review, all required minimum elements should be vouched to original source documents including copies of awards, grant reporting, and the trial balance profit and loss reports. Any inconsistencies should be resolved before submission. Management should strengthen their controls for the tracking of required report filings and their due dates. Management should consider training for staff tasked with completing, reviewing, and filing these reports. Views of Responsible Officials and Planned Corrective Actions: Management will review and update processes and procedures over reporting and additional training will be provided as needed to prevent future findings.
Condition: During our audit, we noted that expenditures totaling $101,308 for FAL 93.354, Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response, were originally incorrectly listed on the schedule of expenditures of federal awards (SEFA) for FAL 93.069, Public Health Emergency Preparedness. Criteria: 2 CFR 200.508(b), Auditee Responsibilities, requires the auditee to prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with § 200.510. Cause and Effect: The cause is that lack of sufficient research in obtaining the appropriate federal assistance listing. The effect is the reporting of expenditures to an incorrect federal assistance listing. Recommendation: We recommend that Yavapai County develop internal controls that ensure the reporting of federal expenditures on the SEFA to the proper federal assistance listing number. Management’s Response: Yavapai County’s responsible officials’ views and planned corrective action are in its corrective action plan at the end of the report.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Assistance Listing, Federal Agency, and Program Name – 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year – All 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 expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition – The SEFA for the year ended June 30, 2024 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2024. Questioned Costs – None Identification of How Questioned Costs Were Computed – N/A Context – Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $4,642,826 of federal expenditures where goods and services had been received as of June 30, 2024 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2024 and therefore should not have been included in the cash basis SEFA. Cause and Effect – Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation – The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan – The corrective actions implemented for capital grants on a cash basis for the SEFA will be expanded to include the operating grants.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: 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. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: 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. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: 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. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: 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. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: 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. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: 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. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: 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. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: 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. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: 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. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: 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. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: 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. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: 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. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: 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. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: 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. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.