Town of GuilderlandLocal Government

Compliance with Reporting Under the Uniform Guidance Information on Federal Program: U.S. Department of Housing and Urban Development Assistance Listing No. 14.871 and Coronavirus State and Local Fiscal Recovery Funds Assistance Listing No. 21.027. Criteria: According to the code of federal regulations section § 200.520 (a), single audits must be performed on an annual basis, including submitting the data collection form and the reporting package to the FAC within the timeframe specified in §200.512 which is the earlier of 30 calendar days after receipt of the auditor’s report or nine months after the end of the audit period. Statement of Condition: The data collection forms for the years 2019 through 2021 have not been submitted timely. Statement of Cause: Due to significant turnover in key positions within the Town’s fiscal office, the financial audits are currently behind. The results of the financial audits are required as part of the submission with the data collection form to the FAC, therefore, the data collection forms cannot be completed and submitted until the completion of the financial audits. Statement of Effect: The Town was not in compliance with federal guidelines. Questioned Cost: None. Repeat Finding: Yes. Perspective Information: As part of testing the compliance with the Uniform Guidance, the dates of the submissions to the FAC are reviewed. Recommendation: The Town should follow federal guidelines by submitting the data collection form to the FAC in a timely manner. Views of responsible officials and Planned Corrective Actions: The Town of Guilderland Comptroller’s Office suffered significant turnover in key positions during the fiscal years of 2019 and 2021 including the retirement of the Town Comptroller and Fiscal Officer. In addition, the COVID-19 pandemic had significant impact to the Town, particularly during 2020 when remote work was encouraged. This combination and sequence of events made it impossible to meet the required external audit reporting deadlines. Since these events, the Town has filled the vacant positions and has scheduled all remaining audits. The auditors are working as expeditiously as possible to complete the remaining audits. The required reporting noted in the guidelines above cannot be completed until each prior year audit is finished, therefore causing a delay in each fiscal year’s reporting.

Compliance with Reporting to Housing and Urban Development Information on Federal Program: U.S. Department of Housing and Urban Development Assistance Listing No. 14.871 and Coronavirus State and Local Fiscal Recovery Funds Assistance Listing No. 21.027. Criteria: According to 24 CFR § 5.801, audited financial statements must be submitted to HUD annually, no later than nine months after the end of the fiscal year or the reporting period. Statement of Condition: The financial information submission was not submitted timely. Statement of Cause: Due to significant turnover in key positions within the Town’s fiscal office, the financial audits are currently behind. The results of the financial audits are required as part of the submission with the REAC, therefore, the REAC cannot be completed and submitted until the completion of the financial audits. Statement of Effect: The Town was not in compliance with federal guidelines. Questioned Cost: None. Repeat Finding: Yes. Perspective Information: As part of testing the compliance with the reporting requirements of the program, the submission of the REAC form is reviewed and additional procedures performed related to the information contained in the REAC submission related to the audited financial statements. As the financial statements have not yet been audited, this review could not be completed. Recommendation: The Town should follow federal guidelines by submitting the audited financial statement to HUD through the REAC submission in a timely manner. Views of responsible officials and Planned Corrective Actions: The Town of Guilderland Comptroller’s Office suffered significant turnover in key positions during the fiscal years of 2019 and 2021 including the retirement of the Town Comptroller and Fiscal Officer. In addition, the COVID-19 pandemic had significant impact to the Town, particularly during 2020 when remote work was encouraged. This combination and sequence of events made it impossible to meet the required external audit reporting deadlines. Since these events, the Town has filled the vacant positions and has scheduled all remaining audits. The auditors are working as expeditiously as possible to complete the remaining audits. The required reporting noted in the guidelines above cannot be completed until each prior year audit is finished, therefore causing a delay in each fiscal year’s reporting.

Coronavirus State and Local Fiscal Recovery Funds Information on Federal Program: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing No. 21.027. Criteria: CFR Section 200.318 stipulates that a non-Federal entity must use its own documented procurement procedures which reflect applicable state, local, and tribal laws, and regulations, provided that the procurements conform to applicable Federal law and the standards identified in Part 200 Subpart D. additionally, 2 CFR Section 200.213 stipulates that no awards, subawards, or contracts be awarded to parties that are debarred, suspended, or otherwise excluded from or ineligible for participation in Federal assistance programs or activities. Statement of Condition: During our discussions with management and testing of the major program, we noted that the Town is not verifying the eligibility of vendors to participate in Federal assistance programs. Statement of Cause: The Town did not review compliance requirements related to procurement outlined in 2 CFR Section 200.318 and Section 200.213. Statement of Effect: The Town is not in compliance with 2 CFR Section 200.213. The Town is not performing required procedures, as a result, vendors that are not eligible for participation in Federal assistance programs or activities could be selected. Questioned Cost: None. Repeat Finding: No. Perspective Information: As part of testing of compliance over procurement, a selection of vendors charged to the major program was selected for testing of compliance. Of the Town’s vendors charged to the program, none were suspended or debarred from participation in Federal assistance programs or activities. Recommendation: we recommend that the Town review the requirements of 2 CFR Section 200.213 and ensure that a review of the eligibility of potential vendors to participate in Federal assistance programs or activities is performed prior to disbursing funds to the vendor. Views of responsible officials and Planned Corrective Actions: Moving forward, the Town of Guilderland will ensure that vendors are not included on the suspended or debarred list to ensure compliance with the requirements noted above.

Compliance with Reporting Under the Uniform Guidance Information on Federal Program: U.S. Department of Housing and Urban Development Assistance Listing No. 14.871. Criteria: According to the code of federal regulations section § 200.520 (a), single audits must be performed on an annual basis, including submitting the data collection form and the reporting package to the FAC within the timeframe specified in §200.512 which is the earlier of 30 calendar days after receipt of the auditor’s report or nine months after the end of the audit period. Statement of Condition: The data collection forms for the years 2019 through 2021 have not been submitted timely. Statement of Cause: Due to significant turnover in key positions within the Town’s fiscal office, the financial audits are currently behind. The results of the financial audits are required as part of the submission with the data collection form to the FAC, therefore, the data collection forms cannot be completed and submitted until the completion of the financial audits. Statement of Effect: The Town was not in compliance with federal guidelines. Questioned Cost: None. Repeat Finding: Yes. Perspective Information: As part of testing the compliance with the Uniform Guidance, the dates of the submissions to the FAC are reviewed. Recommendation: The Town should follow federal guidelines by submitting the data collection form to the FAC in a timely manner. Views of responsible officials and Planned Corrective Actions: The Town of Guilderland Comptroller’s Office suffered significant turnover in key positions during the fiscal years of 2019 and 2021 including the retirement of the Town Comptroller and Fiscal Officer. In addition, the COVID-19 pandemic had significant impact to the Town, particularly during 2020 when remote work was encouraged. This combination and sequence of events made it impossible to meet the required external audit reporting deadlines. Since these events, the Town has filled the vacant positions and has scheduled all remaining audits. The auditors are working as expeditiously as possible to complete the remaining audits. The required reporting noted in the guidelines above cannot be completed until each prior year audit is finished, therefore causing a delay in each fiscal year’s reporting.

Compliance with Reporting to Housing and Urban Development Information on Federal Program: U.S. Department of Housing and Urban Development Assistance Listing No. 14.871. Criteria: According to 24 CFR § 5.801, audited financial statements must be submitted to HUD annually, no later than nine months after the end of the fiscal year or the reporting period. Statement of Condition: The financial information submission was not submitted timely. Statement of Cause: Due to significant turnover in key positions within the Town’s fiscal office, the financial audits are currently behind. The results of the financial audits are required as part of the submission with the REAC, therefore, the REAC cannot be completed and submitted until the completion of the financial audits. Statement of Effect: The Town was not in compliance with federal guidelines. Questioned Cost: None. Repeat Finding: Yes. Perspective Information: As part of testing the compliance with the reporting requirements of the program, the submission of the REAC form is reviewed and additional procedures performed related to the information contained in the REAC submission related to the audited financial statements. As the financial statements have not yet been audited, this review could not be completed. Recommendation: The Town should follow federal guidelines by submitting the audited financial statement to HUD through the REAC submission in a timely manner. Views of responsible officials and Planned Corrective Actions: The Town of Guilderland Comptroller’s Office suffered significant turnover in key positions during the fiscal years of 2019 and 2021 including the retirement of the Town Comptroller and Fiscal Officer. In addition, the COVID-19 pandemic had significant impact to the Town, particularly during 2020 when remote work was encouraged. This combination and sequence of events made it impossible to meet the required external audit reporting deadlines. Since these events, the Town has filled the vacant positions and has scheduled all remaining audits. The auditors are working as expeditiously as possible to complete the remaining audits. The required reporting noted in the guidelines above cannot be completed until each prior year audit is finished, therefore causing a delay in each fiscal year’s reporting.

Compliance with Reporting Under the Uniform Guidance. Information on Federal Program: U.S Department of Housing and Urban Development Assistance Listing No. 14.871. Criteria: According to the code of federal regulations section § 200.520 (a), single audits must be performed on an annual basis, including submitting the data collection form and the reporting package to the FAC within the timeframe specified in §200.512 which is the earlier of 30 calendar days after receipt of the auditor’s report or nine months after the end of the audit period. Statement of Condition: The data collection forms for the years 2018 through 2021 have not been submitted timely. Statement of Cause: Due to significant turnover in key positions within the Town’s fiscal office, the financial audits are currently behind. The results of the financial audits are required as part of the submission with the data collection form to the FAC, therefore, the data collection forms cannot be completed and submitted until the completion of the financial audits. Statement of Effect: The Town was not in compliance with federal guidelines. Questioned Cost: None. Repeat Finding: Yes. Perspective Information: As part of testing the compliance with the Uniform Guidance, the dates of the submissions to the FAC are reviewed. Recommendation: The Town should follow federal guidelines by submitting the data collection form to the FAC in a timely manner. Views of responsible officials and Planned Corrective Actions: The Town of Guilderland Comptroller’s Office suffered significant turnover in key positions during the fiscal years of 2019 and 2021 including the retirement of the Town Comptroller and Fiscal Officer. In addition, the COVID-19 pandemic had significant impact to the Town, particularly during 2020 when remote work was encouraged. This combination and sequence of events made it impossible to meet the required external audit reporting deadlines. Since these events, the Town has filled the vacant positions and has scheduled all remaining audits. The auditors are working as expeditiously as possible to complete the remaining audits. The required reporting noted in the guidelines above cannot be completed until each prior year audit is finished, therefore causing a delay in each fiscal year’s reporting.

Compliance with Reporting to Housing and Urban Development. Information on Federal Program: U.S Department of Housing and Urban Development Assistance Listing No. 14.871. Criteria: According to 24 CFR § 5.801, audited financial statements must be submitted to HUD annually, no later than nine months after the end of the fiscal year or the reporting period. Statement of Condition: The financial information submission was not submitted timely. Statement of Cause: Due to significant turnover in key positions within the Town’s fiscal office, the financial audits are currently behind. The results of the financial audits are required as part of the submission with the REAC, therefore, the REAC cannot be completed and submitted until the completion of the financial audits. Statement of Effect: The Town was not in compliance with federal guidelines. Questioned Cost: None. Repeat Finding: Yes. Perspective Information: As part of testing the compliance with the reporting requirements of the program, the submission of the REAC form is reviewed and additional procedures performed related to the information contained in the REAC submission related to the audited financial statements. As the financial statements have not yet been audited, this review could not be completed. Recommendation: The Town should follow federal guidelines by submitting the audited financial statement to HUD through the REAC submission in a timely manner. Views of responsible officials and Planned Corrective Actions: The Town of Guilderland Comptroller’s Office suffered significant turnover in key positions during the fiscal years of 2019 and 2021 including the retirement of the Town Comptroller and Fiscal Officer. In addition, the COVID-19 pandemic had significant impact to the Town, particularly during 2020 when remote work was encouraged. This combination and sequence of events made it impossible to meet the required external audit reporting deadlines. Since these events, the Town has filled the vacant positions and has scheduled all remaining audits. The auditors are working as expeditiously as possible to complete the remaining audits. The required reporting noted in the guidelines above cannot be completed until each prior year audit is finished, therefore causing a delay in each fiscal year’s reporting.

Compliance with Reporting Under the Uniform Guidance Information on Federal Program: U.S Department of Housing and Urban Development Assistance Listing No. 14.871, Section 8 Housing Choice Vouchers. Criteria: According to the code of federal regulations section § 200.520 (a), single audits must be performed on an annual basis, including submitting the data collection form and the reporting package to the FAC within the timeframe specified in §200.512 which is the earlier of 30 calendar days after receipt of the auditor’s report or nine months after the end of the audit period. Statement of Condition: The data collection forms for the years 2020 through 2023 have not been submitted timely. Statement of Cause: Due to significant turnover in key positions within the Town’s fiscal office, the financial audits are currently behind. The results of the financial audits are required as part of the submission with the data collection form to the FAC, therefore, the data collection forms cannot be completed and submitted until the completion of the financial audits. Statement of Effect: The Town was not in compliance with federal guidelines. Questioned Cost: None. Repeat Finding: Yes. Perspective Information/Context: As part of testing the compliance with the Uniform Guidance, the dates of the submissions to the FAC are reviewed. Recommendation: The Town should follow federal guidelines by submitting the data collection form to the FAC in a timely manner. Views of responsible officials and Planned Corrective Actions: The Town of Guilderland Comptroller’s Office suffered significant turnover in key positions during the fiscal years of 2019 and 2021 including the retirement of the Town Comptroller and Fiscal Officer. In addition, the COVID-19 pandemic had significant impact to the Town, particularly during 2020 when remote work was encouraged. This combination and sequence of events made it impossible to meet the required external audit reporting deadlines. Since these events, the Town has filled the vacant positions and has scheduled all remaining audits. The auditors are working as expeditiously as possible to complete the remaining audits. The required reporting noted in the guidelines above cannot be completed until each prior year audit is finished, therefore causing a delay in each fiscal year’s reporting.

Compliance with Reporting to Housing and Urban Development Information on Federal Program: U.S Department of Housing and Urban Development Assistance Listing No. 14.871, Section 8 Housing Choice Vouchers. Criteria: According to 24 CFR § 5.801, audited financial statements must be submitted to HUD annually, no later than nine months after the end of the fiscal year or the reporting period. Statement of Condition: The financial information submission was not submitted timely. Statement of Cause: Due to significant turnover in key positions within the Town’s fiscal office, the financial audits are currently behind. The results of the financial audits are required as part of the submission with the REAC, therefore, the REAC cannot be completed and submitted until the completion of the financial audits. Statement of Effect: The Town was not in compliance with federal guidelines. Questioned Cost: None. Repeat Finding: Yes. Perspective Information/Context: As part of testing the compliance with the reporting requirements of the program, the submission of the REAC form is reviewed and additional procedures performed related to the information contained in the REAC submission related to the audited financial statements. As the financial statements have not yet been audited, this review could not be completed. Recommendation: The Town should follow federal guidelines by submitting the audited financial statement to HUD through the REAC submission in a timely manner. Views of responsible officials and Planned Corrective Actions: The Town of Guilderland Comptroller’s Office suffered significant turnover in key positions during the fiscal years of 2019 and 2021 including the retirement of the Town Comptroller and Fiscal Officer. In addition, the COVID-19 pandemic had significant impact to the Town, particularly during 2020 when remote work was encouraged. This combination and sequence of events made it impossible to meet the required external audit reporting deadlines. Since these events, the Town has filled the vacant positions and has scheduled all remaining audits. The auditors are working as expeditiously as possible to complete the remaining audits. The required reporting noted in the guidelines above cannot be completed until each prior year audit is finished, therefore causing a delay in each fiscal year’s reporting.

Material Weakness; 2019-003 Compliance with Reporting Under the Uniform Guidance; Information on Federal Program: U.S Department of Housing and Urban Development Assistance Listing No. 14.871.; Criteria: According to the code of federal regulations section § 200.520 (a), single audits must be performed on an annual basis, including submitting the data collection form and the reporting package to the FAC within the timeframe specified in §200.512 which is the earlier of 30 calendar days after receipt of the auditor’s report or nine months after the end of the audit period.; Statement of Condition: The data collection forms for the years 2019 through 2022 have not been submitted timely.; Statement of Cause: Due to significant turnover in key positions within the Town’s fiscal office, the financial audits are currently behind. The results of the financial audits are required as part of the submission with the data collection form to the FAC, therefore, the data collection forms cannot be completed and submitted until the completion of the financial audits.; Statement of Effect: The Town was not in compliance with federal guidelines.; Questioned Cost: None.; Repeat Finding: Yes.; Perspective Information: As part of testing the compliance with the Uniform Guidance, the dates of the submissions to the FAC are reviewed.; Recommendation: The Town should follow federal guidelines by submitting the data collection form to the FAC in a timely manner.; Views of responsible officials and Planned Corrective Actions: The Town of Guilderland Comptroller’s Office suffered significant turnover in key positions during the fiscal years of 2019 and 2021 including the retirement of the Town Comptroller and Fiscal Officer. In addition, the COVID-19 pandemic had significant impact to the Town, particularly during 2020 when remote work was encouraged. This combination and sequence of events made it impossible to meet the required external audit reporting deadlines. Since these events, the Town has filled the vacant positions and has scheduled all remaining audits. The auditors are working as expeditiously as possible to complete the remaining audits. The required reporting noted in the guidelines above cannot be completed until each prior year audit is finished, therefore causing a delay in each fiscal year’s reporting.

Material Weakness; 2019-004 Compliance with Reporting to Housing and Urban Development; Information on Federal Program: U.S Department of Housing and Urban Development Assistance Listing No. 14.871.; Criteria: According to 24 CFR § 5.801, audited financial statements must be submitted to HUD annually, no later than nine months after the end of the fiscal year or the reporting period.; Statement of Condition: The financial information submission was not submitted timely.; Statement of Cause: Due to significant turnover in key positions within the Town’s fiscal office, the financial audits are currently behind. The results of the financial audits are required as part of the submission with the REAC, therefore, the REAC cannot be completed and submitted until the completion of the financial audits.; Statement of Effect: The Town was not in compliance with federal guidelines.; Questioned Cost: None.; Repeat Finding: No.; Perspective Information: As part of testing the compliance with the reporting requirements of the program, the submission of the REAC form is reviewed and additional procedures performed related to the information contained in the REAC submission related to the audited financial statements. As the financial statements have not yet been audited, this review could not be completed.; Recommendation: The Town should follow federal guidelines by submitting the audited financial statement to HUD through the REAC submission in a timely manner.; Views of responsible officials and Planned Corrective Actions: The Town of Guilderland Comptroller’s Office suffered significant turnover in key positions during the fiscal years of 2019 and 2021 including the retirement of the Town Comptroller and Fiscal Officer. In addition, the COVID-19 pandemic had significant impact to the Town, particularly during 2020 when remote work was encouraged. This combination and sequence of events made it impossible to meet the required external audit reporting deadlines. Since these events, the Town has filled the vacant positions and has scheduled all remaining audits. The auditors are working as expeditiously as possible to complete the remaining audits. The required reporting noted in the guidelines above cannot be completed until each prior year audit is finished, therefore causing a delay in each fiscal year’s reporting.

Significant Deficiency; 2019-005 Certification Signatures; Information on Federal Program: U.S Department of Housing and Urban Development Assistance Listing No. 14.871.; Criteria: According to 24 CFR § 5.659, any information supplied by the family must be true and complete. The Certification Form is the documentation utilized for the family and program manager to attest that all information that has been provided is true and complete.; Statement of Condition: Three certification forms examined were missing either the family signature or the program manager.; Statement of Cause: Due to the automated signature system not being set up for a particular employee, there were forms that were missing the program manager signature. Signatures of the family missing were an oversight.; Statement of Effect: The HUD program was not in compliance with federal guidelines.; Questioned Cost: None.; Repeat Finding: No.; Perspective Information: As part of testing the compliance requirements of the program, a sample of certification forms is examined to ensure proper signatures are present.; Recommendation: The program administrator should ensure that all signatures are present on all required documentation.; Views of responsible officials and Planned Corrective Actions: The Town contracts with a third-party administrator for our Section 8 housing program. Their document creation system incorporates an automated signature feature that facilitates the placement of scanned signatures on forms during the review and printing process by case-workers. Unfortunately, during the training of a new employee on their system, an oversight occurred in setting up their electronic signature, resulting in missing signatures on a small number of certification forms. To address this issue, they have enhanced their "New User Checklist" to include a specific step for configuring electronic signatures for new employees. Additionally, the employees responsible for these oversights have been replaced, and the incident prompted a thorough review of their procedures. The current department managers have implemented training protocols to ensure that staff verify all signatures on documents. Additionally, third-party audits for various municipalities as well as their SOC audit have been conducted subsequently and did not reveal any additional instances of certification forms missing signatures.

2018-002 Identification of Federal Awards Statement of Condition: The Town did not properly identify their federal awards. Criteria: To accurately present the Schedule of Expenditures of Federal Awards of the Town, all federal awards should be properly identified. The accuracy and completeness of financial data is crucial to the Schedule of Expenditures of Federal Awards. Statement of Cause: The Town did not have the proper tracking procedures in place to track their awards. Statement of Effect: The Schedule of Expenditures of Federal Awards would have been inaccurate and incomplete. Questioned Costs: None Perspective Information: As part of audit procedures, federal awards are assessed and tested. Identification of Repeat Finding: No. Recommendation: Management should implement a tracking system to properly track their awards so that this doesn’t recur in the future. Views of responsible officials and planned corrective actions: The Town has created a tracking system for all federal awards and expenditures.

2018-003 Single Audit Filing Statement of Condition: The Single Audit was not filed within 9 months after year-end as required by the Federal Audit Clearinghouse. Criteria: To be in compliance with the Government Auditing Standards, Single Audits are required to be submitted within 9 months after year-end to the Federal Audit Clearinghouse. Statement of Cause: Single Audit was not filed due to issues mentioned in 2018-002 along with the audit of the Town being significantly delayed due to turnover in the Town Comptroller’s office. Statement of Effect: The Town was not in compliance with federal guidelines. Questioned Costs: None Perspective Information: As part of audit procedures, filing dates are observed and compared to relevant deadlines. Identification of Repeat Finding: No Recommendation: It is recommended that effort be taken to try and get back to being current to be able to submit on time in future years. Views of responsible officials and planned corrective actions: The Town of Guilderland Comptroller’s Office suffered significant turnover in key positions during the fiscal years of 2019 and 2021 including the retirement of the Town Comptroller and Fiscal Officer. The Town also implemented a new accounting software during 2018 that caused significant delays in the monthly and year-end reporting. Lastly, the COVID-19 pandemic had significant impact to the Town, particularly during 2020 when remote work was encouraged. This combination and sequence of events made it impossible to meet the required external audit reporting deadlines. Since these events, the Town has filled the vacant positions and has scheduled all remaining audits. The auditors are working as expeditiously as possible to complete the remaining audits. The required reporting noted in the guidelines above cannot be completed until each prior year audit is finished, therefore causing a delay in each fiscal year’s reporting.