Audit 364485

Issue: Noncompliance with Uniform Guidance Late Filing of Single Audit Reporting Package Classification: Material Noncompliance Federal Agency: U.S. Department of Treasury; U.S. Department of Housing and Urban Development Federal Program: Coronavirus State and Local Fiscal Recovery Funds; Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 21.027; 14.228 Pass-Through Agency: NYS Office of the State Comptroller; NYS Office of Community Renewal Criteria: Under the Single Audit Act of 1996 and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), §200.512, Report Submission, the Single audit reporting package is required to be filed within the earlier of 30 calendar days after receipt of the auditors' report, or 9 months after the end of the audit period. Condition: This deadline was not met on a timely basis for the year ended December 31, 2023. Cause: Staffing shortages caused the delays in financial reporting. Effect or Potential Effect: As a result, the entity is not incompliance with §200.512 of the Uniform Guidance. Questioned Costs: None. Context: This year's Single Audit reissued reporting package was filed in mid August, after the required filing date. This compares with the prior year, when the initial Single Audit reporting package was filed timely, but the reissued reporting package was filed after the required filing date. Repeat Finding: This finding is a repeat of finding 2022-008 from the prior year. Recommendation: We recommend the requirements of §200.512 of the Uniform guidance be adhered to by striving to have all information required for the audit available on a timely basis. This will help to ensure timely audit report issuance and compliance with the filing deadline. Views of Responsible Officials of the Auditee: The City is still facing staffing shortages and is working to get the subsequent financial statements completed. It is expected the 2024 reporting package will be filed on time.

Issue: Noncompliance with Uniform Guidance Late Filing of Single Audit Reporting Package Classification: Material Noncompliance Federal Agency: U.S. Department of Treasury; U.S. Department of Housing and Urban Development Federal Program: Coronavirus State and Local Fiscal Recovery Funds; Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 21.027; 14.228 Pass-Through Agency: NYS Office of the State Comptroller; NYS Office of Community Renewal Criteria: Under the Single Audit Act of 1996 and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), §200.512, Report Submission, the Single audit reporting package is required to be filed within the earlier of 30 calendar days after receipt of the auditors' report, or 9 months after the end of the audit period. Condition: This deadline was not met on a timely basis for the year ended December 31, 2023. Cause: Staffing shortages caused the delays in financial reporting. Effect or Potential Effect: As a result, the entity is not incompliance with §200.512 of the Uniform Guidance. Questioned Costs: None. Context: This year's Single Audit reissued reporting package was filed in mid August, after the required filing date. This compares with the prior year, when the initial Single Audit reporting package was filed timely, but the reissued reporting package was filed after the required filing date. Repeat Finding: This finding is a repeat of finding 2022-008 from the prior year. Recommendation: We recommend the requirements of §200.512 of the Uniform guidance be adhered to by striving to have all information required for the audit available on a timely basis. This will help to ensure timely audit report issuance and compliance with the filing deadline. Views of Responsible Officials of the Auditee: The City is still facing staffing shortages and is working to get the subsequent financial statements completed. It is expected the 2024 reporting package will be filed on time.

Issue: Noncompliance with Uniform Guidance Late Filing of Single Audit Reporting Package Classification: Material Noncompliance Federal Agency: U.S. Department of Treasury; U.S. Department of Housing and Urban Development Federal Program: Coronavirus State and Local Fiscal Recovery Funds; Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 21.027; 14.228 Pass-Through Agency: NYS Office of the State Comptroller; NYS Office of Community Renewal Criteria: Under the Single Audit Act of 1996 and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), §200.512, Report Submission, the Single audit reporting package is required to be filed within the earlier of 30 calendar days after receipt of the auditors' report, or 9 months after the end of the audit period. Condition: This deadline was not met on a timely basis for the year ended December 31, 2023. Cause: Staffing shortages caused the delays in financial reporting. Effect or Potential Effect: As a result, the entity is not incompliance with §200.512 of the Uniform Guidance. Questioned Costs: None. Context: This year's Single Audit reissued reporting package was filed in mid August, after the required filing date. This compares with the prior year, when the initial Single Audit reporting package was filed timely, but the reissued reporting package was filed after the required filing date. Repeat Finding: This finding is a repeat of finding 2022-008 from the prior year. Recommendation: We recommend the requirements of §200.512 of the Uniform guidance be adhered to by striving to have all information required for the audit available on a timely basis. This will help to ensure timely audit report issuance and compliance with the filing deadline. Views of Responsible Officials of the Auditee: The City is still facing staffing shortages and is working to get the subsequent financial statements completed. It is expected the 2024 reporting package will be filed on time.

Issue: Noncompliance with Uniform Guidance Late Filing of Single Audit Reporting Package Classification: Material Noncompliance Federal Agency: U.S. Department of Treasury; U.S. Department of Housing and Urban Development Federal Program: Coronavirus State and Local Fiscal Recovery Funds; Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 21.027; 14.228 Pass-Through Agency: NYS Office of the State Comptroller; NYS Office of Community Renewal Criteria: Under the Single Audit Act of 1996 and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), §200.512, Report Submission, the Single audit reporting package is required to be filed within the earlier of 30 calendar days after receipt of the auditors' report, or 9 months after the end of the audit period. Condition: This deadline was not met on a timely basis for the year ended December 31, 2023. Cause: Staffing shortages caused the delays in financial reporting. Effect or Potential Effect: As a result, the entity is not incompliance with §200.512 of the Uniform Guidance. Questioned Costs: None. Context: This year's Single Audit reissued reporting package was filed in mid August, after the required filing date. This compares with the prior year, when the initial Single Audit reporting package was filed timely, but the reissued reporting package was filed after the required filing date. Repeat Finding: This finding is a repeat of finding 2022-008 from the prior year. Recommendation: We recommend the requirements of §200.512 of the Uniform guidance be adhered to by striving to have all information required for the audit available on a timely basis. This will help to ensure timely audit report issuance and compliance with the filing deadline. Views of Responsible Officials of the Auditee: The City is still facing staffing shortages and is working to get the subsequent financial statements completed. It is expected the 2024 reporting package will be filed on time.

Issue: Noncompliance with Uniform Guidance Late Filing of Single Audit Reporting Package Classification: Material Noncompliance Federal Agency: U.S. Department of Treasury; U.S. Department of Housing and Urban Development Federal Program: Coronavirus State and Local Fiscal Recovery Funds; Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 21.027; 14.228 Pass-Through Agency: NYS Office of the State Comptroller; NYS Office of Community Renewal Criteria: Under the Single Audit Act of 1996 and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), §200.512, Report Submission, the Single audit reporting package is required to be filed within the earlier of 30 calendar days after receipt of the auditors' report, or 9 months after the end of the audit period. Condition: This deadline was not met on a timely basis for the year ended December 31, 2023. Cause: Staffing shortages caused the delays in financial reporting. Effect or Potential Effect: As a result, the entity is not incompliance with §200.512 of the Uniform Guidance. Questioned Costs: None. Context: This year's Single Audit reissued reporting package was filed in mid August, after the required filing date. This compares with the prior year, when the initial Single Audit reporting package was filed timely, but the reissued reporting package was filed after the required filing date. Repeat Finding: This finding is a repeat of finding 2022-008 from the prior year. Recommendation: We recommend the requirements of §200.512 of the Uniform guidance be adhered to by striving to have all information required for the audit available on a timely basis. This will help to ensure timely audit report issuance and compliance with the filing deadline. Views of Responsible Officials of the Auditee: The City is still facing staffing shortages and is working to get the subsequent financial statements completed. It is expected the 2024 reporting package will be filed on time.

Issue: Noncompliance with Uniform Guidance Late Filing of Single Audit Reporting Package Classification: Material Noncompliance Federal Agency: U.S. Department of Treasury; U.S. Department of Housing and Urban Development Federal Program: Coronavirus State and Local Fiscal Recovery Funds; Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 21.027; 14.228 Pass-Through Agency: NYS Office of the State Comptroller; NYS Office of Community Renewal Criteria: Under the Single Audit Act of 1996 and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), §200.512, Report Submission, the Single audit reporting package is required to be filed within the earlier of 30 calendar days after receipt of the auditors' report, or 9 months after the end of the audit period. Condition: This deadline was not met on a timely basis for the year ended December 31, 2023. Cause: Staffing shortages caused the delays in financial reporting. Effect or Potential Effect: As a result, the entity is not incompliance with §200.512 of the Uniform Guidance. Questioned Costs: None. Context: This year's Single Audit reissued reporting package was filed in mid August, after the required filing date. This compares with the prior year, when the initial Single Audit reporting package was filed timely, but the reissued reporting package was filed after the required filing date. Repeat Finding: This finding is a repeat of finding 2022-008 from the prior year. Recommendation: We recommend the requirements of §200.512 of the Uniform guidance be adhered to by striving to have all information required for the audit available on a timely basis. This will help to ensure timely audit report issuance and compliance with the filing deadline. Views of Responsible Officials of the Auditee: The City is still facing staffing shortages and is working to get the subsequent financial statements completed. It is expected the 2024 reporting package will be filed on time.

Issue: Noncompliance with Uniform Guidance Late Filing of Single Audit Reporting Package Classification: Material Noncompliance Federal Agency: U.S. Department of Treasury; U.S. Department of Housing and Urban Development Federal Program: Coronavirus State and Local Fiscal Recovery Funds; Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 21.027; 14.228 Pass-Through Agency: NYS Office of the State Comptroller; NYS Office of Community Renewal Criteria: Under the Single Audit Act of 1996 and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), §200.512, Report Submission, the Single audit reporting package is required to be filed within the earlier of 30 calendar days after receipt of the auditors' report, or 9 months after the end of the audit period. Condition: This deadline was not met on a timely basis for the year ended December 31, 2023. Cause: Staffing shortages caused the delays in financial reporting. Effect or Potential Effect: As a result, the entity is not incompliance with §200.512 of the Uniform Guidance. Questioned Costs: None. Context: This year's Single Audit reissued reporting package was filed in mid August, after the required filing date. This compares with the prior year, when the initial Single Audit reporting package was filed timely, but the reissued reporting package was filed after the required filing date. Repeat Finding: This finding is a repeat of finding 2022-008 from the prior year. Recommendation: We recommend the requirements of §200.512 of the Uniform guidance be adhered to by striving to have all information required for the audit available on a timely basis. This will help to ensure timely audit report issuance and compliance with the filing deadline. Views of Responsible Officials of the Auditee: The City is still facing staffing shortages and is working to get the subsequent financial statements completed. It is expected the 2024 reporting package will be filed on time.

Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause: The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs: None. Context: The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding: This finding is a repeat of finding 2022-006 and 2022-007 from the prior year. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee: The City agrees with the finding.

Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause: The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs: None. Context: The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding: This finding is a repeat of finding 2022-006 and 2022-007 from the prior year. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee: The City agrees with the finding.

Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause: The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs: None. Context: The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding: This finding is a repeat of finding 2022-006 and 2022-007 from the prior year. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee: The City agrees with the finding.

Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause: The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs: None. Context: The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding: This finding is a repeat of finding 2022-006 and 2022-007 from the prior year. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee: The City agrees with the finding.

Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause: The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs: None. Context: The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding: This finding is a repeat of finding 2022-006 and 2022-007 from the prior year. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee: The City agrees with the finding.

Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause: The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs: None. Context: The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding: This finding is a repeat of finding 2022-006 and 2022-007 from the prior year. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee: The City agrees with the finding.

Issue: Noncompliance with Uniform Guidance Late Filing of Single Audit Reporting Package Classification: Material Noncompliance Federal Agency: U.S. Department of Treasury; U.S. Department of Housing and Urban Development Federal Program: Coronavirus State and Local Fiscal Recovery Funds; Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 21.027; 14.228 Pass-Through Agency: NYS Office of the State Comptroller; NYS Office of Community Renewal Criteria: Under the Single Audit Act of 1996 and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), §200.512, Report Submission, the Single audit reporting package is required to be filed within the earlier of 30 calendar days after receipt of the auditors' report, or 9 months after the end of the audit period. Condition: This deadline was not met on a timely basis for the year ended December 31, 2023. Cause: Staffing shortages caused the delays in financial reporting. Effect or Potential Effect: As a result, the entity is not incompliance with §200.512 of the Uniform Guidance. Questioned Costs: None. Context: This year's Single Audit reissued reporting package was filed in mid August, after the required filing date. This compares with the prior year, when the initial Single Audit reporting package was filed timely, but the reissued reporting package was filed after the required filing date. Repeat Finding: This finding is a repeat of finding 2022-008 from the prior year. Recommendation: We recommend the requirements of §200.512 of the Uniform guidance be adhered to by striving to have all information required for the audit available on a timely basis. This will help to ensure timely audit report issuance and compliance with the filing deadline. Views of Responsible Officials of the Auditee: The City is still facing staffing shortages and is working to get the subsequent financial statements completed. It is expected the 2024 reporting package will be filed on time.

Issue: Noncompliance with Uniform Guidance Late Filing of Single Audit Reporting Package Classification: Material Noncompliance Federal Agency: U.S. Department of Treasury; U.S. Department of Housing and Urban Development Federal Program: Coronavirus State and Local Fiscal Recovery Funds; Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 21.027; 14.228 Pass-Through Agency: NYS Office of the State Comptroller; NYS Office of Community Renewal Criteria: Under the Single Audit Act of 1996 and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), §200.512, Report Submission, the Single audit reporting package is required to be filed within the earlier of 30 calendar days after receipt of the auditors' report, or 9 months after the end of the audit period. Condition: This deadline was not met on a timely basis for the year ended December 31, 2023. Cause: Staffing shortages caused the delays in financial reporting. Effect or Potential Effect: As a result, the entity is not incompliance with §200.512 of the Uniform Guidance. Questioned Costs: None. Context: This year's Single Audit reissued reporting package was filed in mid August, after the required filing date. This compares with the prior year, when the initial Single Audit reporting package was filed timely, but the reissued reporting package was filed after the required filing date. Repeat Finding: This finding is a repeat of finding 2022-008 from the prior year. Recommendation: We recommend the requirements of §200.512 of the Uniform guidance be adhered to by striving to have all information required for the audit available on a timely basis. This will help to ensure timely audit report issuance and compliance with the filing deadline. Views of Responsible Officials of the Auditee: The City is still facing staffing shortages and is working to get the subsequent financial statements completed. It is expected the 2024 reporting package will be filed on time.

Issue: Noncompliance with Uniform Guidance Late Filing of Single Audit Reporting Package Classification: Material Noncompliance Federal Agency: U.S. Department of Treasury; U.S. Department of Housing and Urban Development Federal Program: Coronavirus State and Local Fiscal Recovery Funds; Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 21.027; 14.228 Pass-Through Agency: NYS Office of the State Comptroller; NYS Office of Community Renewal Criteria: Under the Single Audit Act of 1996 and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), §200.512, Report Submission, the Single audit reporting package is required to be filed within the earlier of 30 calendar days after receipt of the auditors' report, or 9 months after the end of the audit period. Condition: This deadline was not met on a timely basis for the year ended December 31, 2023. Cause: Staffing shortages caused the delays in financial reporting. Effect or Potential Effect: As a result, the entity is not incompliance with §200.512 of the Uniform Guidance. Questioned Costs: None. Context: This year's Single Audit reissued reporting package was filed in mid August, after the required filing date. This compares with the prior year, when the initial Single Audit reporting package was filed timely, but the reissued reporting package was filed after the required filing date. Repeat Finding: This finding is a repeat of finding 2022-008 from the prior year. Recommendation: We recommend the requirements of §200.512 of the Uniform guidance be adhered to by striving to have all information required for the audit available on a timely basis. This will help to ensure timely audit report issuance and compliance with the filing deadline. Views of Responsible Officials of the Auditee: The City is still facing staffing shortages and is working to get the subsequent financial statements completed. It is expected the 2024 reporting package will be filed on time.

Issue: Noncompliance with Uniform Guidance Late Filing of Single Audit Reporting Package Classification: Material Noncompliance Federal Agency: U.S. Department of Treasury; U.S. Department of Housing and Urban Development Federal Program: Coronavirus State and Local Fiscal Recovery Funds; Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 21.027; 14.228 Pass-Through Agency: NYS Office of the State Comptroller; NYS Office of Community Renewal Criteria: Under the Single Audit Act of 1996 and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), §200.512, Report Submission, the Single audit reporting package is required to be filed within the earlier of 30 calendar days after receipt of the auditors' report, or 9 months after the end of the audit period. Condition: This deadline was not met on a timely basis for the year ended December 31, 2023. Cause: Staffing shortages caused the delays in financial reporting. Effect or Potential Effect: As a result, the entity is not incompliance with §200.512 of the Uniform Guidance. Questioned Costs: None. Context: This year's Single Audit reissued reporting package was filed in mid August, after the required filing date. This compares with the prior year, when the initial Single Audit reporting package was filed timely, but the reissued reporting package was filed after the required filing date. Repeat Finding: This finding is a repeat of finding 2022-008 from the prior year. Recommendation: We recommend the requirements of §200.512 of the Uniform guidance be adhered to by striving to have all information required for the audit available on a timely basis. This will help to ensure timely audit report issuance and compliance with the filing deadline. Views of Responsible Officials of the Auditee: The City is still facing staffing shortages and is working to get the subsequent financial statements completed. It is expected the 2024 reporting package will be filed on time.

Issue: Noncompliance with Uniform Guidance Late Filing of Single Audit Reporting Package Classification: Material Noncompliance Federal Agency: U.S. Department of Treasury; U.S. Department of Housing and Urban Development Federal Program: Coronavirus State and Local Fiscal Recovery Funds; Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 21.027; 14.228 Pass-Through Agency: NYS Office of the State Comptroller; NYS Office of Community Renewal Criteria: Under the Single Audit Act of 1996 and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), §200.512, Report Submission, the Single audit reporting package is required to be filed within the earlier of 30 calendar days after receipt of the auditors' report, or 9 months after the end of the audit period. Condition: This deadline was not met on a timely basis for the year ended December 31, 2023. Cause: Staffing shortages caused the delays in financial reporting. Effect or Potential Effect: As a result, the entity is not incompliance with §200.512 of the Uniform Guidance. Questioned Costs: None. Context: This year's Single Audit reissued reporting package was filed in mid August, after the required filing date. This compares with the prior year, when the initial Single Audit reporting package was filed timely, but the reissued reporting package was filed after the required filing date. Repeat Finding: This finding is a repeat of finding 2022-008 from the prior year. Recommendation: We recommend the requirements of §200.512 of the Uniform guidance be adhered to by striving to have all information required for the audit available on a timely basis. This will help to ensure timely audit report issuance and compliance with the filing deadline. Views of Responsible Officials of the Auditee: The City is still facing staffing shortages and is working to get the subsequent financial statements completed. It is expected the 2024 reporting package will be filed on time.

Issue: Noncompliance with Uniform Guidance Late Filing of Single Audit Reporting Package Classification: Material Noncompliance Federal Agency: U.S. Department of Treasury; U.S. Department of Housing and Urban Development Federal Program: Coronavirus State and Local Fiscal Recovery Funds; Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 21.027; 14.228 Pass-Through Agency: NYS Office of the State Comptroller; NYS Office of Community Renewal Criteria: Under the Single Audit Act of 1996 and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), §200.512, Report Submission, the Single audit reporting package is required to be filed within the earlier of 30 calendar days after receipt of the auditors' report, or 9 months after the end of the audit period. Condition: This deadline was not met on a timely basis for the year ended December 31, 2023. Cause: Staffing shortages caused the delays in financial reporting. Effect or Potential Effect: As a result, the entity is not incompliance with §200.512 of the Uniform Guidance. Questioned Costs: None. Context: This year's Single Audit reissued reporting package was filed in mid August, after the required filing date. This compares with the prior year, when the initial Single Audit reporting package was filed timely, but the reissued reporting package was filed after the required filing date. Repeat Finding: This finding is a repeat of finding 2022-008 from the prior year. Recommendation: We recommend the requirements of §200.512 of the Uniform guidance be adhered to by striving to have all information required for the audit available on a timely basis. This will help to ensure timely audit report issuance and compliance with the filing deadline. Views of Responsible Officials of the Auditee: The City is still facing staffing shortages and is working to get the subsequent financial statements completed. It is expected the 2024 reporting package will be filed on time.

Issue: Noncompliance with Uniform Guidance Late Filing of Single Audit Reporting Package Classification: Material Noncompliance Federal Agency: U.S. Department of Treasury; U.S. Department of Housing and Urban Development Federal Program: Coronavirus State and Local Fiscal Recovery Funds; Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 21.027; 14.228 Pass-Through Agency: NYS Office of the State Comptroller; NYS Office of Community Renewal Criteria: Under the Single Audit Act of 1996 and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), §200.512, Report Submission, the Single audit reporting package is required to be filed within the earlier of 30 calendar days after receipt of the auditors' report, or 9 months after the end of the audit period. Condition: This deadline was not met on a timely basis for the year ended December 31, 2023. Cause: Staffing shortages caused the delays in financial reporting. Effect or Potential Effect: As a result, the entity is not incompliance with §200.512 of the Uniform Guidance. Questioned Costs: None. Context: This year's Single Audit reissued reporting package was filed in mid August, after the required filing date. This compares with the prior year, when the initial Single Audit reporting package was filed timely, but the reissued reporting package was filed after the required filing date. Repeat Finding: This finding is a repeat of finding 2022-008 from the prior year. Recommendation: We recommend the requirements of §200.512 of the Uniform guidance be adhered to by striving to have all information required for the audit available on a timely basis. This will help to ensure timely audit report issuance and compliance with the filing deadline. Views of Responsible Officials of the Auditee: The City is still facing staffing shortages and is working to get the subsequent financial statements completed. It is expected the 2024 reporting package will be filed on time.

Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause: The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs: None. Context: The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding: This finding is a repeat of finding 2022-006 and 2022-007 from the prior year. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee: The City agrees with the finding.

Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause: The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs: None. Context: The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding: This finding is a repeat of finding 2022-006 and 2022-007 from the prior year. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee: The City agrees with the finding.

Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause: The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs: None. Context: The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding: This finding is a repeat of finding 2022-006 and 2022-007 from the prior year. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee: The City agrees with the finding.

Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause: The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs: None. Context: The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding: This finding is a repeat of finding 2022-006 and 2022-007 from the prior year. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee: The City agrees with the finding.

Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause: The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs: None. Context: The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding: This finding is a repeat of finding 2022-006 and 2022-007 from the prior year. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee: The City agrees with the finding.

Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause: The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs: None. Context: The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding: This finding is a repeat of finding 2022-006 and 2022-007 from the prior year. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee: The City agrees with the finding.