Federal Agency: Department of Housing and Urban Development Federal Program Name: Continuum of Care Assistance Listing Number: 14.267 Federal Award Identification Number and Year: SC-110351 - 2024 SC-111132 - 2024 SC-110353 - 2024 SC-111134 - 2024 SC-110355 - 2024 SC-110349 - 2024 SC-111130 - 2024 Pass-Through Agency: Pierce County Pass-Through Number(s): LP9XHDGASCJ3 Award Period: SC-110351: 7/1/23-6/30/24 SC-111132: 7/1/24-6/30/25 SC-110353: 12/1/23-11/30/24 SC-111134: 12/1/24-11/30/25 SC-110355: 6/1/23-8/31/24 SC-110349: 5/1/23-4/30/24 SC-111130: 5/1/24-4/30/25 Type of finding: Material Weakness in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR 200.303(a), recipients of federal funds must "establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award." Non-federal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred (2 CFR sections 200.212 and 200.318(h); 2 CFR section 1800.30; 48 CFR section 52.209-6). Additionally, an entity is required to have policies and procedures in place for verifying the above requirements. Condition: During our suspension and debarment testing, CLA noted no suspension and debarment policy in place and no suspension and debarment check was performed over a covered transaction. Questioned costs: $7,442 of known questioned costs. Context: There was only one covered transaction subject to suspension and debarment check that had a contract amount exceeding $25,000 but only $7,442 was paid with federal program. However, no suspension and debarment check was performed. CLA elected to perform a SAM.gov check and noted that vendor (Locke System) is not debarred as of the date of the audit procedure. Cause: Share & Care House and Subsidiary lacks sufficient understanding of the compliance requirements surrounding covered transactions and suspension and debarment check requirements. Effect: Contracts could be entered into with suspended or debarred vendors leading to noncompliance. Improper understanding caused Share & Care House and Subsidiary to be noncompliant with program requirements over suspension and debarment. Repeat finding: No. Recommendation: CLA recommends Share & Care House and Subsidiary to develop and implement a suspension and debarment policy that meets the requirements outlined in Uniform Guidance. CLA also recommends increased training for those individuals involved in procurement and contract approval process to ensure suspension and debarment checks are performed on all covered transactions. Views of responsible officials: Management agrees with the finding and has provided its corrective action plan.
Federal Agency: Department of Housing and Urban Development Federal Program Name: Continuum of Care Assistance Listing Number: 14.267 Federal Award Identification Number and Year: SC-110351 - 2024 SC-111132 - 2024 SC-110353 - 2024 SC-111134 - 2024 SC-110355 - 2024 SC-110349 - 2024 SC-111130 - 2024 Pass-Through Agency: Pierce County Pass-Through Number(s): LP9XHDGASCJ3 Award Period: SC-110351: 7/1/23-6/30/24 SC-111132: 7/1/24-6/30/25 SC-110353: 12/1/23-11/30/24 SC-111134: 12/1/24-11/30/25 SC-110355: 6/1/23-8/31/24 SC-110349: 5/1/23-4/30/24 SC-111130: 5/1/24-4/30/25 Type of finding: Material Weakness in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR 200.303(a), recipients of federal funds must "establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award." Non-federal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred (2 CFR sections 200.212 and 200.318(h); 2 CFR section 1800.30; 48 CFR section 52.209-6). Additionally, an entity is required to have policies and procedures in place for verifying the above requirements. Condition: During our suspension and debarment testing, CLA noted no suspension and debarment policy in place and no suspension and debarment check was performed over a covered transaction. Questioned costs: $7,442 of known questioned costs. Context: There was only one covered transaction subject to suspension and debarment check that had a contract amount exceeding $25,000 but only $7,442 was paid with federal program. However, no suspension and debarment check was performed. CLA elected to perform a SAM.gov check and noted that vendor (Locke System) is not debarred as of the date of the audit procedure. Cause: Share & Care House and Subsidiary lacks sufficient understanding of the compliance requirements surrounding covered transactions and suspension and debarment check requirements. Effect: Contracts could be entered into with suspended or debarred vendors leading to noncompliance. Improper understanding caused Share & Care House and Subsidiary to be noncompliant with program requirements over suspension and debarment. Repeat finding: No. Recommendation: CLA recommends Share & Care House and Subsidiary to develop and implement a suspension and debarment policy that meets the requirements outlined in Uniform Guidance. CLA also recommends increased training for those individuals involved in procurement and contract approval process to ensure suspension and debarment checks are performed on all covered transactions. Views of responsible officials: Management agrees with the finding and has provided its corrective action plan.
Federal Agency: Department of Housing and Urban Development Federal Program Name: Continuum of Care Assistance Listing Number: 14.267 Federal Award Identification Number and Year: SC-110351 - 2024 SC-111132 - 2024 SC-110353 - 2024 SC-111134 - 2024 SC-110355 - 2024 SC-110349 - 2024 SC-111130 - 2024 Pass-Through Agency: Pierce County Pass-Through Number(s): LP9XHDGASCJ3 Award Period: SC-110351: 7/1/23-6/30/24 SC-111132: 7/1/24-6/30/25 SC-110353: 12/1/23-11/30/24 SC-111134: 12/1/24-11/30/25 SC-110355: 6/1/23-8/31/24 SC-110349: 5/1/23-4/30/24 SC-111130: 5/1/24-4/30/25 Type of finding: Material Weakness in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR 200.303(a), recipients of federal funds must "establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award." Non-federal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred (2 CFR sections 200.212 and 200.318(h); 2 CFR section 1800.30; 48 CFR section 52.209-6). Additionally, an entity is required to have policies and procedures in place for verifying the above requirements. Condition: During our suspension and debarment testing, CLA noted no suspension and debarment policy in place and no suspension and debarment check was performed over a covered transaction. Questioned costs: $7,442 of known questioned costs. Context: There was only one covered transaction subject to suspension and debarment check that had a contract amount exceeding $25,000 but only $7,442 was paid with federal program. However, no suspension and debarment check was performed. CLA elected to perform a SAM.gov check and noted that vendor (Locke System) is not debarred as of the date of the audit procedure. Cause: Share & Care House and Subsidiary lacks sufficient understanding of the compliance requirements surrounding covered transactions and suspension and debarment check requirements. Effect: Contracts could be entered into with suspended or debarred vendors leading to noncompliance. Improper understanding caused Share & Care House and Subsidiary to be noncompliant with program requirements over suspension and debarment. Repeat finding: No. Recommendation: CLA recommends Share & Care House and Subsidiary to develop and implement a suspension and debarment policy that meets the requirements outlined in Uniform Guidance. CLA also recommends increased training for those individuals involved in procurement and contract approval process to ensure suspension and debarment checks are performed on all covered transactions. Views of responsible officials: Management agrees with the finding and has provided its corrective action plan.
Federal Agency: Department of Housing and Urban Development Federal Program Name: Continuum of Care Assistance Listing Number: 14.267 Federal Award Identification Number and Year: SC-110351 - 2024 SC-111132 - 2024 SC-110353 - 2024 SC-111134 - 2024 SC-110355 - 2024 SC-110349 - 2024 SC-111130 - 2024 Pass-Through Agency: Pierce County Pass-Through Number(s): LP9XHDGASCJ3 Award Period: SC-110351: 7/1/23-6/30/24 SC-111132: 7/1/24-6/30/25 SC-110353: 12/1/23-11/30/24 SC-111134: 12/1/24-11/30/25 SC-110355: 6/1/23-8/31/24 SC-110349: 5/1/23-4/30/24 SC-111130: 5/1/24-4/30/25 Type of finding: Material Weakness in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR 200.303(a), recipients of federal funds must "establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award." Non-federal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred (2 CFR sections 200.212 and 200.318(h); 2 CFR section 1800.30; 48 CFR section 52.209-6). Additionally, an entity is required to have policies and procedures in place for verifying the above requirements. Condition: During our suspension and debarment testing, CLA noted no suspension and debarment policy in place and no suspension and debarment check was performed over a covered transaction. Questioned costs: $7,442 of known questioned costs. Context: There was only one covered transaction subject to suspension and debarment check that had a contract amount exceeding $25,000 but only $7,442 was paid with federal program. However, no suspension and debarment check was performed. CLA elected to perform a SAM.gov check and noted that vendor (Locke System) is not debarred as of the date of the audit procedure. Cause: Share & Care House and Subsidiary lacks sufficient understanding of the compliance requirements surrounding covered transactions and suspension and debarment check requirements. Effect: Contracts could be entered into with suspended or debarred vendors leading to noncompliance. Improper understanding caused Share & Care House and Subsidiary to be noncompliant with program requirements over suspension and debarment. Repeat finding: No. Recommendation: CLA recommends Share & Care House and Subsidiary to develop and implement a suspension and debarment policy that meets the requirements outlined in Uniform Guidance. CLA also recommends increased training for those individuals involved in procurement and contract approval process to ensure suspension and debarment checks are performed on all covered transactions. Views of responsible officials: Management agrees with the finding and has provided its corrective action plan.
Federal Agency: Department of Housing and Urban Development Federal Program Name: Continuum of Care Assistance Listing Number: 14.267 Federal Award Identification Number and Year: SC-110351 - 2024 SC-111132 - 2024 SC-110353 - 2024 SC-111134 - 2024 SC-110355 - 2024 SC-110349 - 2024 SC-111130 - 2024 Pass-Through Agency: Pierce County Pass-Through Number(s): LP9XHDGASCJ3 Award Period: SC-110351: 7/1/23-6/30/24 SC-111132: 7/1/24-6/30/25 SC-110353: 12/1/23-11/30/24 SC-111134: 12/1/24-11/30/25 SC-110355: 6/1/23-8/31/24 SC-110349: 5/1/23-4/30/24 SC-111130: 5/1/24-4/30/25 Type of finding: Material Weakness in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR 200.303(a), recipients of federal funds must "establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award." Non-federal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred (2 CFR sections 200.212 and 200.318(h); 2 CFR section 1800.30; 48 CFR section 52.209-6). Additionally, an entity is required to have policies and procedures in place for verifying the above requirements. Condition: During our suspension and debarment testing, CLA noted no suspension and debarment policy in place and no suspension and debarment check was performed over a covered transaction. Questioned costs: $7,442 of known questioned costs. Context: There was only one covered transaction subject to suspension and debarment check that had a contract amount exceeding $25,000 but only $7,442 was paid with federal program. However, no suspension and debarment check was performed. CLA elected to perform a SAM.gov check and noted that vendor (Locke System) is not debarred as of the date of the audit procedure. Cause: Share & Care House and Subsidiary lacks sufficient understanding of the compliance requirements surrounding covered transactions and suspension and debarment check requirements. Effect: Contracts could be entered into with suspended or debarred vendors leading to noncompliance. Improper understanding caused Share & Care House and Subsidiary to be noncompliant with program requirements over suspension and debarment. Repeat finding: No. Recommendation: CLA recommends Share & Care House and Subsidiary to develop and implement a suspension and debarment policy that meets the requirements outlined in Uniform Guidance. CLA also recommends increased training for those individuals involved in procurement and contract approval process to ensure suspension and debarment checks are performed on all covered transactions. Views of responsible officials: Management agrees with the finding and has provided its corrective action plan.
Federal Agency: Department of Housing and Urban Development Federal Program Name: Continuum of Care Assistance Listing Number: 14.267 Federal Award Identification Number and Year: SC-110351 - 2024 SC-111132 - 2024 SC-110353 - 2024 SC-111134 - 2024 SC-110355 - 2024 SC-110349 - 2024 SC-111130 - 2024 Pass-Through Agency: Pierce County Pass-Through Number(s): LP9XHDGASCJ3 Award Period: SC-110351: 7/1/23-6/30/24 SC-111132: 7/1/24-6/30/25 SC-110353: 12/1/23-11/30/24 SC-111134: 12/1/24-11/30/25 SC-110355: 6/1/23-8/31/24 SC-110349: 5/1/23-4/30/24 SC-111130: 5/1/24-4/30/25 Type of finding: Material Weakness in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR 200.303(a), recipients of federal funds must "establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award." Non-federal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred (2 CFR sections 200.212 and 200.318(h); 2 CFR section 1800.30; 48 CFR section 52.209-6). Additionally, an entity is required to have policies and procedures in place for verifying the above requirements. Condition: During our suspension and debarment testing, CLA noted no suspension and debarment policy in place and no suspension and debarment check was performed over a covered transaction. Questioned costs: $7,442 of known questioned costs. Context: There was only one covered transaction subject to suspension and debarment check that had a contract amount exceeding $25,000 but only $7,442 was paid with federal program. However, no suspension and debarment check was performed. CLA elected to perform a SAM.gov check and noted that vendor (Locke System) is not debarred as of the date of the audit procedure. Cause: Share & Care House and Subsidiary lacks sufficient understanding of the compliance requirements surrounding covered transactions and suspension and debarment check requirements. Effect: Contracts could be entered into with suspended or debarred vendors leading to noncompliance. Improper understanding caused Share & Care House and Subsidiary to be noncompliant with program requirements over suspension and debarment. Repeat finding: No. Recommendation: CLA recommends Share & Care House and Subsidiary to develop and implement a suspension and debarment policy that meets the requirements outlined in Uniform Guidance. CLA also recommends increased training for those individuals involved in procurement and contract approval process to ensure suspension and debarment checks are performed on all covered transactions. Views of responsible officials: Management agrees with the finding and has provided its corrective action plan.
Federal Agency: Department of Housing and Urban Development Federal Program Name: Continuum of Care Assistance Listing Number: 14.267 Federal Award Identification Number and Year: SC-110351 - 2024 SC-111132 - 2024 SC-110353 - 2024 SC-111134 - 2024 SC-110355 - 2024 SC-110349 - 2024 SC-111130 - 2024 Pass-Through Agency: Pierce County Pass-Through Number(s): LP9XHDGASCJ3 Award Period: SC-110351: 7/1/23-6/30/24 SC-111132: 7/1/24-6/30/25 SC-110353: 12/1/23-11/30/24 SC-111134: 12/1/24-11/30/25 SC-110355: 6/1/23-8/31/24 SC-110349: 5/1/23-4/30/24 SC-111130: 5/1/24-4/30/25 Type of finding: Material Weakness in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR 200.303(a), recipients of federal funds must "establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award." Non-federal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred (2 CFR sections 200.212 and 200.318(h); 2 CFR section 1800.30; 48 CFR section 52.209-6). Additionally, an entity is required to have policies and procedures in place for verifying the above requirements. Condition: During our suspension and debarment testing, CLA noted no suspension and debarment policy in place and no suspension and debarment check was performed over a covered transaction. Questioned costs: $7,442 of known questioned costs. Context: There was only one covered transaction subject to suspension and debarment check that had a contract amount exceeding $25,000 but only $7,442 was paid with federal program. However, no suspension and debarment check was performed. CLA elected to perform a SAM.gov check and noted that vendor (Locke System) is not debarred as of the date of the audit procedure. Cause: Share & Care House and Subsidiary lacks sufficient understanding of the compliance requirements surrounding covered transactions and suspension and debarment check requirements. Effect: Contracts could be entered into with suspended or debarred vendors leading to noncompliance. Improper understanding caused Share & Care House and Subsidiary to be noncompliant with program requirements over suspension and debarment. Repeat finding: No. Recommendation: CLA recommends Share & Care House and Subsidiary to develop and implement a suspension and debarment policy that meets the requirements outlined in Uniform Guidance. CLA also recommends increased training for those individuals involved in procurement and contract approval process to ensure suspension and debarment checks are performed on all covered transactions. Views of responsible officials: Management agrees with the finding and has provided its corrective action plan.
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.231, 14.267, 93.224 & 93.527 Program: Emergency Solutions Grant Program, Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: HH-21-03.4, CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in Subpart E 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, matching funds must also be allowable under Subpart E – Cost Principles. Per 2 CFR §200.430 Compensation – Personal Services: “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non Federal entity, not exceeding 100% of compensated activities; (iv) Encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the recipient or subrecipient; and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (vii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient’s or subrecipient’s written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient’s or subrecipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We noted that the Village allocated payroll expenditures to Emergency Solutions Grants Program, Continuum of Care Program, and Health Center Cluster during 2024 that lacked adequate or timely documentation. During our testing we noted instances where supervisor did not approve timesheets, instances where the incorrect allocation rate was utilized, and instances where attestations were not completed timely to support employee’s time allocated to the grant for reimbursement. • For Emergency Solutions Grants Program: o 41 out of 60 selections did not have timely completion of attestations • For Continuum of Care Program: o 2 out of 100 selections utilized the incorrect allocation rate to the grant. • For Continuum of Care Program in our testing of Matching Costs: o 2 out of 60 selections did not have approved timesheets. o 2 out of 60 selections did not have timely completion of attestations. o 1 out of 60 selections utilized the incorrect allocation rate. • For Health Center Program Cluster: o 1 out of 60 selections utilized the incorrect allocation rate to the grant. o 14 out of 60 selections did not have timely completion of attestations. Cause: The Village did not have adequate policies/procedures in place to timely prepare and complete timesheet attestations and approvals and reconcile to actual expenditures charged. Additionally, the Village relied heavily on manual processes that are more prone to error and did not have an adequate review process to identify and correct calculation errors. Effect or Potential Effect: Without adequate controls in place to detect calculation errors and ensure attestations and timesheets were reviewed in a timely manner, the Village could incorrectly charge expenditures to the Federal program, or not request appropriate reimbursement the Village is entitled to under the terms of the grant. Questioned Costs: Emergency Solutions Grants Program: None Continuum of Care Program Known Questioned Costs: $1,575 Continuum of Care Program Likely Questioned Costs: $172,053 Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Emergency Solutions Grants Program in 2024 were $377,797. Payroll costs including fringe benefits for the Continuum of Care Program in 2024 were $1,217,865. Matching costs for the Continuum of Care Program in 2024 were $1,896,728. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Any costs not adequately supported by approved timesheet allocations or in excess of supported allocations are considered questioned costs. Repeat Finding: 2023-003, 2023-004, 2023-005 Recommendation: We recommend that the Village implement policies and procedures to ensure attestations are completed timely (i.e. quarterly) and to ensure timely review for any necessary budget to actual adjustments. Additionally, we recommend implementing system improvements to reduce manual entry and establishing policies to review reimbursement calculations before submission. Views of Responsible Officials:
Federal Agencies: Department of Health and Human Services Federal Assistance Listing Numbers: 93.224 & 93.527 Program: Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 2 CFR §200.403(e), costs must be in accordance with Generally Accepted Accounting Procedures (GAAP) to be allowable under Federal awards. Condition: During our testing of 2024 costs, we noted that 3 of the 60 payroll transactions selected for testing within the Health Center Program Cluster were incurred in 2023. This practice is not in accordance with GAAP, which require that costs be recorded in the period in which they are incurred. Cause: The Village did not have adequate policies and procedures in place to ensure that federal expenditures are properly accrued and recorded in the fiscal year in which the costs are actually incurred. Effect or Potential Effect: Failure to accrue costs in accordance with GAAP may result in expenditures being materially misstated on the SEFA that could lead to inaccurate reporting to the federal agencies. Questioned Costs: Health Center Program Cluster Known Questioned Costs: $473 Health Center Program Cluster Likely Questioned Costs: $26,444 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Repeat Finding: 2023-001 Recommendation: We recommend Village implement policies and procedures to accrue for federal expenditures in the period the costs were incurred to ensure costs are being recorded in accordance with GAAP and the SEFA is representative of all federal expenditures incurred in the reporting year. Views of Responsible Officials:
Federal Agencies: Department of Health and Human Services Federal Assistance Listing Numbers: 93.224 & 93.527 Program: Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 2 CFR §200.403(e), costs must be in accordance with Generally Accepted Accounting Procedures (GAAP) to be allowable under Federal awards. Condition: During our testing of 2024 costs, we noted that 3 of the 60 payroll transactions selected for testing within the Health Center Program Cluster were incurred in 2023. This practice is not in accordance with GAAP, which require that costs be recorded in the period in which they are incurred. Cause: The Village did not have adequate policies and procedures in place to ensure that federal expenditures are properly accrued and recorded in the fiscal year in which the costs are actually incurred. Effect or Potential Effect: Failure to accrue costs in accordance with GAAP may result in expenditures being materially misstated on the SEFA that could lead to inaccurate reporting to the federal agencies. Questioned Costs: Health Center Program Cluster Known Questioned Costs: $473 Health Center Program Cluster Likely Questioned Costs: $26,444 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Repeat Finding: 2023-001 Recommendation: We recommend Village implement policies and procedures to accrue for federal expenditures in the period the costs were incurred to ensure costs are being recorded in accordance with GAAP and the SEFA is representative of all federal expenditures incurred in the reporting year. Views of Responsible Officials:
Federal Agencies: Department of Health and Human Services Federal Assistance Listing Numbers: 93.224 & 93.527 Program: Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 2 CFR §200.403(e), costs must be in accordance with Generally Accepted Accounting Procedures (GAAP) to be allowable under Federal awards. Condition: During our testing of 2024 costs, we noted that 3 of the 60 payroll transactions selected for testing within the Health Center Program Cluster were incurred in 2023. This practice is not in accordance with GAAP, which require that costs be recorded in the period in which they are incurred. Cause: The Village did not have adequate policies and procedures in place to ensure that federal expenditures are properly accrued and recorded in the fiscal year in which the costs are actually incurred. Effect or Potential Effect: Failure to accrue costs in accordance with GAAP may result in expenditures being materially misstated on the SEFA that could lead to inaccurate reporting to the federal agencies. Questioned Costs: Health Center Program Cluster Known Questioned Costs: $473 Health Center Program Cluster Likely Questioned Costs: $26,444 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Repeat Finding: 2023-001 Recommendation: We recommend Village implement policies and procedures to accrue for federal expenditures in the period the costs were incurred to ensure costs are being recorded in accordance with GAAP and the SEFA is representative of all federal expenditures incurred in the reporting year. Views of Responsible Officials:
Federal Agencies: Department of Health and Human Services Federal Assistance Listing Numbers: 93.224 & 93.527 Program: Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 2 CFR §200.403(e), costs must be in accordance with Generally Accepted Accounting Procedures (GAAP) to be allowable under Federal awards. Condition: During our testing of 2024 costs, we noted that 3 of the 60 payroll transactions selected for testing within the Health Center Program Cluster were incurred in 2023. This practice is not in accordance with GAAP, which require that costs be recorded in the period in which they are incurred. Cause: The Village did not have adequate policies and procedures in place to ensure that federal expenditures are properly accrued and recorded in the fiscal year in which the costs are actually incurred. Effect or Potential Effect: Failure to accrue costs in accordance with GAAP may result in expenditures being materially misstated on the SEFA that could lead to inaccurate reporting to the federal agencies. Questioned Costs: Health Center Program Cluster Known Questioned Costs: $473 Health Center Program Cluster Likely Questioned Costs: $26,444 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Repeat Finding: 2023-001 Recommendation: We recommend Village implement policies and procedures to accrue for federal expenditures in the period the costs were incurred to ensure costs are being recorded in accordance with GAAP and the SEFA is representative of all federal expenditures incurred in the reporting year. Views of Responsible Officials:
Federal Agencies: Department of Health and Human Services Federal Assistance Listing Numbers: 93.224 & 93.527 Program: Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 2 CFR §200.403(e), costs must be in accordance with Generally Accepted Accounting Procedures (GAAP) to be allowable under Federal awards. Condition: During our testing of 2024 costs, we noted that 3 of the 60 payroll transactions selected for testing within the Health Center Program Cluster were incurred in 2023. This practice is not in accordance with GAAP, which require that costs be recorded in the period in which they are incurred. Cause: The Village did not have adequate policies and procedures in place to ensure that federal expenditures are properly accrued and recorded in the fiscal year in which the costs are actually incurred. Effect or Potential Effect: Failure to accrue costs in accordance with GAAP may result in expenditures being materially misstated on the SEFA that could lead to inaccurate reporting to the federal agencies. Questioned Costs: Health Center Program Cluster Known Questioned Costs: $473 Health Center Program Cluster Likely Questioned Costs: $26,444 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Repeat Finding: 2023-001 Recommendation: We recommend Village implement policies and procedures to accrue for federal expenditures in the period the costs were incurred to ensure costs are being recorded in accordance with GAAP and the SEFA is representative of all federal expenditures incurred in the reporting year. Views of Responsible Officials:
Federal Agencies: Department of Health and Human Services Federal Assistance Listing Numbers: 93.224 & 93.527 Program: Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 2 CFR §200.403(e), costs must be in accordance with Generally Accepted Accounting Procedures (GAAP) to be allowable under Federal awards. Condition: During our testing of 2024 costs, we noted that 3 of the 60 payroll transactions selected for testing within the Health Center Program Cluster were incurred in 2023. This practice is not in accordance with GAAP, which require that costs be recorded in the period in which they are incurred. Cause: The Village did not have adequate policies and procedures in place to ensure that federal expenditures are properly accrued and recorded in the fiscal year in which the costs are actually incurred. Effect or Potential Effect: Failure to accrue costs in accordance with GAAP may result in expenditures being materially misstated on the SEFA that could lead to inaccurate reporting to the federal agencies. Questioned Costs: Health Center Program Cluster Known Questioned Costs: $473 Health Center Program Cluster Likely Questioned Costs: $26,444 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Repeat Finding: 2023-001 Recommendation: We recommend Village implement policies and procedures to accrue for federal expenditures in the period the costs were incurred to ensure costs are being recorded in accordance with GAAP and the SEFA is representative of all federal expenditures incurred in the reporting year. Views of Responsible Officials:
Federal Agencies: Department of Health and Human Services Federal Assistance Listing Numbers: 93.224 & 93.527 Program: Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 2 CFR §200.403(e), costs must be in accordance with Generally Accepted Accounting Procedures (GAAP) to be allowable under Federal awards. Condition: During our testing of 2024 costs, we noted that 3 of the 60 payroll transactions selected for testing within the Health Center Program Cluster were incurred in 2023. This practice is not in accordance with GAAP, which require that costs be recorded in the period in which they are incurred. Cause: The Village did not have adequate policies and procedures in place to ensure that federal expenditures are properly accrued and recorded in the fiscal year in which the costs are actually incurred. Effect or Potential Effect: Failure to accrue costs in accordance with GAAP may result in expenditures being materially misstated on the SEFA that could lead to inaccurate reporting to the federal agencies. Questioned Costs: Health Center Program Cluster Known Questioned Costs: $473 Health Center Program Cluster Likely Questioned Costs: $26,444 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Repeat Finding: 2023-001 Recommendation: We recommend Village implement policies and procedures to accrue for federal expenditures in the period the costs were incurred to ensure costs are being recorded in accordance with GAAP and the SEFA is representative of all federal expenditures incurred in the reporting year. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.51(g), “HUD will only provide rental assistance for a unit if the rent is reasonable. The recipient or subrecipient must determine whether the rent charged for the unit receiving rental assistance is reasonable in relation to rents being charged for comparable unassisted units, taking into account the location, size, type, quality, amenities, facilities, and management and maintenance of each unit. Reasonable rent must not exceed rents currently being charged by the same owner for comparable unassisted units.” Condition: In accordance with 24 CFR §578.51(g), we noted that: • 5 out of 60 rental payments tested did not have a comparable unit analysis conducted. • 23 out of 60 rental payments did not have a comparable unit analysis completed in a timely manner prior to the tenant’s move-in or prior to increases in rent. • 1 out of 60 rental payments tested did not have documentation for amounts charged (such as lease agreements, rent increase letters, or invoices). • 6 out of 60 rental payments tested had errors in the rent reasonableness forms. • 3 of the 55 rental payments that did have rent reasonableness performed did not have rent reasonableness analyzed in the past 12-months of the rent payment. Cause: The Village did not appropriately retain or produce documentation verifying that rent reasonableness was assessed prior to move-in or during changes to lease terms, as required by its policies. Furthermore, not all supporting documentation for initial or changes to lease terms was obtained or retained. Effect or Potential Effect: The insufficient retention or creation of rent reasonableness forms and supporting documentation has led to ineffective operation of rent reasonableness controls, thereby not appropriately identifying rental amounts for the Village’s clients in need of rental assistance. Consequently, this deficiency could result in incorrect charges being applied to the Federal program. Questioned Costs: Known Questioned Costs: $6,678 Likely Questioned Costs: $170,185 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Questioned costs were determined as the amounts paid without supporting rent reasonableness documentation. The total costs subject to rent reasonableness amounted to $2,429,908. Repeat Finding: 2023-006 Recommendation: We recommend that the Village enhance existing policies to ensure rent reasonableness is performed on all rental assistance. In addition, we recommend management ensures determinations are performed prior to move-in or rent changes being charged, and documentation is maintained for both the rent amount and reasonableness of the rent. We further recommend a policy be enacted for reviewing rent reasonableness on a periodic basis (i.e. annually) for those tenants that have not had a change in rent during the period. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.51(g), “HUD will only provide rental assistance for a unit if the rent is reasonable. The recipient or subrecipient must determine whether the rent charged for the unit receiving rental assistance is reasonable in relation to rents being charged for comparable unassisted units, taking into account the location, size, type, quality, amenities, facilities, and management and maintenance of each unit. Reasonable rent must not exceed rents currently being charged by the same owner for comparable unassisted units.” Condition: In accordance with 24 CFR §578.51(g), we noted that: • 5 out of 60 rental payments tested did not have a comparable unit analysis conducted. • 23 out of 60 rental payments did not have a comparable unit analysis completed in a timely manner prior to the tenant’s move-in or prior to increases in rent. • 1 out of 60 rental payments tested did not have documentation for amounts charged (such as lease agreements, rent increase letters, or invoices). • 6 out of 60 rental payments tested had errors in the rent reasonableness forms. • 3 of the 55 rental payments that did have rent reasonableness performed did not have rent reasonableness analyzed in the past 12-months of the rent payment. Cause: The Village did not appropriately retain or produce documentation verifying that rent reasonableness was assessed prior to move-in or during changes to lease terms, as required by its policies. Furthermore, not all supporting documentation for initial or changes to lease terms was obtained or retained. Effect or Potential Effect: The insufficient retention or creation of rent reasonableness forms and supporting documentation has led to ineffective operation of rent reasonableness controls, thereby not appropriately identifying rental amounts for the Village’s clients in need of rental assistance. Consequently, this deficiency could result in incorrect charges being applied to the Federal program. Questioned Costs: Known Questioned Costs: $6,678 Likely Questioned Costs: $170,185 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Questioned costs were determined as the amounts paid without supporting rent reasonableness documentation. The total costs subject to rent reasonableness amounted to $2,429,908. Repeat Finding: 2023-006 Recommendation: We recommend that the Village enhance existing policies to ensure rent reasonableness is performed on all rental assistance. In addition, we recommend management ensures determinations are performed prior to move-in or rent changes being charged, and documentation is maintained for both the rent amount and reasonableness of the rent. We further recommend a policy be enacted for reviewing rent reasonableness on a periodic basis (i.e. annually) for those tenants that have not had a change in rent during the period. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.51(g), “HUD will only provide rental assistance for a unit if the rent is reasonable. The recipient or subrecipient must determine whether the rent charged for the unit receiving rental assistance is reasonable in relation to rents being charged for comparable unassisted units, taking into account the location, size, type, quality, amenities, facilities, and management and maintenance of each unit. Reasonable rent must not exceed rents currently being charged by the same owner for comparable unassisted units.” Condition: In accordance with 24 CFR §578.51(g), we noted that: • 5 out of 60 rental payments tested did not have a comparable unit analysis conducted. • 23 out of 60 rental payments did not have a comparable unit analysis completed in a timely manner prior to the tenant’s move-in or prior to increases in rent. • 1 out of 60 rental payments tested did not have documentation for amounts charged (such as lease agreements, rent increase letters, or invoices). • 6 out of 60 rental payments tested had errors in the rent reasonableness forms. • 3 of the 55 rental payments that did have rent reasonableness performed did not have rent reasonableness analyzed in the past 12-months of the rent payment. Cause: The Village did not appropriately retain or produce documentation verifying that rent reasonableness was assessed prior to move-in or during changes to lease terms, as required by its policies. Furthermore, not all supporting documentation for initial or changes to lease terms was obtained or retained. Effect or Potential Effect: The insufficient retention or creation of rent reasonableness forms and supporting documentation has led to ineffective operation of rent reasonableness controls, thereby not appropriately identifying rental amounts for the Village’s clients in need of rental assistance. Consequently, this deficiency could result in incorrect charges being applied to the Federal program. Questioned Costs: Known Questioned Costs: $6,678 Likely Questioned Costs: $170,185 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Questioned costs were determined as the amounts paid without supporting rent reasonableness documentation. The total costs subject to rent reasonableness amounted to $2,429,908. Repeat Finding: 2023-006 Recommendation: We recommend that the Village enhance existing policies to ensure rent reasonableness is performed on all rental assistance. In addition, we recommend management ensures determinations are performed prior to move-in or rent changes being charged, and documentation is maintained for both the rent amount and reasonableness of the rent. We further recommend a policy be enacted for reviewing rent reasonableness on a periodic basis (i.e. annually) for those tenants that have not had a change in rent during the period. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.51(g), “HUD will only provide rental assistance for a unit if the rent is reasonable. The recipient or subrecipient must determine whether the rent charged for the unit receiving rental assistance is reasonable in relation to rents being charged for comparable unassisted units, taking into account the location, size, type, quality, amenities, facilities, and management and maintenance of each unit. Reasonable rent must not exceed rents currently being charged by the same owner for comparable unassisted units.” Condition: In accordance with 24 CFR §578.51(g), we noted that: • 5 out of 60 rental payments tested did not have a comparable unit analysis conducted. • 23 out of 60 rental payments did not have a comparable unit analysis completed in a timely manner prior to the tenant’s move-in or prior to increases in rent. • 1 out of 60 rental payments tested did not have documentation for amounts charged (such as lease agreements, rent increase letters, or invoices). • 6 out of 60 rental payments tested had errors in the rent reasonableness forms. • 3 of the 55 rental payments that did have rent reasonableness performed did not have rent reasonableness analyzed in the past 12-months of the rent payment. Cause: The Village did not appropriately retain or produce documentation verifying that rent reasonableness was assessed prior to move-in or during changes to lease terms, as required by its policies. Furthermore, not all supporting documentation for initial or changes to lease terms was obtained or retained. Effect or Potential Effect: The insufficient retention or creation of rent reasonableness forms and supporting documentation has led to ineffective operation of rent reasonableness controls, thereby not appropriately identifying rental amounts for the Village’s clients in need of rental assistance. Consequently, this deficiency could result in incorrect charges being applied to the Federal program. Questioned Costs: Known Questioned Costs: $6,678 Likely Questioned Costs: $170,185 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Questioned costs were determined as the amounts paid without supporting rent reasonableness documentation. The total costs subject to rent reasonableness amounted to $2,429,908. Repeat Finding: 2023-006 Recommendation: We recommend that the Village enhance existing policies to ensure rent reasonableness is performed on all rental assistance. In addition, we recommend management ensures determinations are performed prior to move-in or rent changes being charged, and documentation is maintained for both the rent amount and reasonableness of the rent. We further recommend a policy be enacted for reviewing rent reasonableness on a periodic basis (i.e. annually) for those tenants that have not had a change in rent during the period. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.51(g), “HUD will only provide rental assistance for a unit if the rent is reasonable. The recipient or subrecipient must determine whether the rent charged for the unit receiving rental assistance is reasonable in relation to rents being charged for comparable unassisted units, taking into account the location, size, type, quality, amenities, facilities, and management and maintenance of each unit. Reasonable rent must not exceed rents currently being charged by the same owner for comparable unassisted units.” Condition: In accordance with 24 CFR §578.51(g), we noted that: • 5 out of 60 rental payments tested did not have a comparable unit analysis conducted. • 23 out of 60 rental payments did not have a comparable unit analysis completed in a timely manner prior to the tenant’s move-in or prior to increases in rent. • 1 out of 60 rental payments tested did not have documentation for amounts charged (such as lease agreements, rent increase letters, or invoices). • 6 out of 60 rental payments tested had errors in the rent reasonableness forms. • 3 of the 55 rental payments that did have rent reasonableness performed did not have rent reasonableness analyzed in the past 12-months of the rent payment. Cause: The Village did not appropriately retain or produce documentation verifying that rent reasonableness was assessed prior to move-in or during changes to lease terms, as required by its policies. Furthermore, not all supporting documentation for initial or changes to lease terms was obtained or retained. Effect or Potential Effect: The insufficient retention or creation of rent reasonableness forms and supporting documentation has led to ineffective operation of rent reasonableness controls, thereby not appropriately identifying rental amounts for the Village’s clients in need of rental assistance. Consequently, this deficiency could result in incorrect charges being applied to the Federal program. Questioned Costs: Known Questioned Costs: $6,678 Likely Questioned Costs: $170,185 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Questioned costs were determined as the amounts paid without supporting rent reasonableness documentation. The total costs subject to rent reasonableness amounted to $2,429,908. Repeat Finding: 2023-006 Recommendation: We recommend that the Village enhance existing policies to ensure rent reasonableness is performed on all rental assistance. In addition, we recommend management ensures determinations are performed prior to move-in or rent changes being charged, and documentation is maintained for both the rent amount and reasonableness of the rent. We further recommend a policy be enacted for reviewing rent reasonableness on a periodic basis (i.e. annually) for those tenants that have not had a change in rent during the period. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.51(g), “HUD will only provide rental assistance for a unit if the rent is reasonable. The recipient or subrecipient must determine whether the rent charged for the unit receiving rental assistance is reasonable in relation to rents being charged for comparable unassisted units, taking into account the location, size, type, quality, amenities, facilities, and management and maintenance of each unit. Reasonable rent must not exceed rents currently being charged by the same owner for comparable unassisted units.” Condition: In accordance with 24 CFR §578.51(g), we noted that: • 5 out of 60 rental payments tested did not have a comparable unit analysis conducted. • 23 out of 60 rental payments did not have a comparable unit analysis completed in a timely manner prior to the tenant’s move-in or prior to increases in rent. • 1 out of 60 rental payments tested did not have documentation for amounts charged (such as lease agreements, rent increase letters, or invoices). • 6 out of 60 rental payments tested had errors in the rent reasonableness forms. • 3 of the 55 rental payments that did have rent reasonableness performed did not have rent reasonableness analyzed in the past 12-months of the rent payment. Cause: The Village did not appropriately retain or produce documentation verifying that rent reasonableness was assessed prior to move-in or during changes to lease terms, as required by its policies. Furthermore, not all supporting documentation for initial or changes to lease terms was obtained or retained. Effect or Potential Effect: The insufficient retention or creation of rent reasonableness forms and supporting documentation has led to ineffective operation of rent reasonableness controls, thereby not appropriately identifying rental amounts for the Village’s clients in need of rental assistance. Consequently, this deficiency could result in incorrect charges being applied to the Federal program. Questioned Costs: Known Questioned Costs: $6,678 Likely Questioned Costs: $170,185 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Questioned costs were determined as the amounts paid without supporting rent reasonableness documentation. The total costs subject to rent reasonableness amounted to $2,429,908. Repeat Finding: 2023-006 Recommendation: We recommend that the Village enhance existing policies to ensure rent reasonableness is performed on all rental assistance. In addition, we recommend management ensures determinations are performed prior to move-in or rent changes being charged, and documentation is maintained for both the rent amount and reasonableness of the rent. We further recommend a policy be enacted for reviewing rent reasonableness on a periodic basis (i.e. annually) for those tenants that have not had a change in rent during the period. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.51(g), “HUD will only provide rental assistance for a unit if the rent is reasonable. The recipient or subrecipient must determine whether the rent charged for the unit receiving rental assistance is reasonable in relation to rents being charged for comparable unassisted units, taking into account the location, size, type, quality, amenities, facilities, and management and maintenance of each unit. Reasonable rent must not exceed rents currently being charged by the same owner for comparable unassisted units.” Condition: In accordance with 24 CFR §578.51(g), we noted that: • 5 out of 60 rental payments tested did not have a comparable unit analysis conducted. • 23 out of 60 rental payments did not have a comparable unit analysis completed in a timely manner prior to the tenant’s move-in or prior to increases in rent. • 1 out of 60 rental payments tested did not have documentation for amounts charged (such as lease agreements, rent increase letters, or invoices). • 6 out of 60 rental payments tested had errors in the rent reasonableness forms. • 3 of the 55 rental payments that did have rent reasonableness performed did not have rent reasonableness analyzed in the past 12-months of the rent payment. Cause: The Village did not appropriately retain or produce documentation verifying that rent reasonableness was assessed prior to move-in or during changes to lease terms, as required by its policies. Furthermore, not all supporting documentation for initial or changes to lease terms was obtained or retained. Effect or Potential Effect: The insufficient retention or creation of rent reasonableness forms and supporting documentation has led to ineffective operation of rent reasonableness controls, thereby not appropriately identifying rental amounts for the Village’s clients in need of rental assistance. Consequently, this deficiency could result in incorrect charges being applied to the Federal program. Questioned Costs: Known Questioned Costs: $6,678 Likely Questioned Costs: $170,185 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Questioned costs were determined as the amounts paid without supporting rent reasonableness documentation. The total costs subject to rent reasonableness amounted to $2,429,908. Repeat Finding: 2023-006 Recommendation: We recommend that the Village enhance existing policies to ensure rent reasonableness is performed on all rental assistance. In addition, we recommend management ensures determinations are performed prior to move-in or rent changes being charged, and documentation is maintained for both the rent amount and reasonableness of the rent. We further recommend a policy be enacted for reviewing rent reasonableness on a periodic basis (i.e. annually) for those tenants that have not had a change in rent during the period. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.51(g), “HUD will only provide rental assistance for a unit if the rent is reasonable. The recipient or subrecipient must determine whether the rent charged for the unit receiving rental assistance is reasonable in relation to rents being charged for comparable unassisted units, taking into account the location, size, type, quality, amenities, facilities, and management and maintenance of each unit. Reasonable rent must not exceed rents currently being charged by the same owner for comparable unassisted units.” Condition: In accordance with 24 CFR §578.51(g), we noted that: • 5 out of 60 rental payments tested did not have a comparable unit analysis conducted. • 23 out of 60 rental payments did not have a comparable unit analysis completed in a timely manner prior to the tenant’s move-in or prior to increases in rent. • 1 out of 60 rental payments tested did not have documentation for amounts charged (such as lease agreements, rent increase letters, or invoices). • 6 out of 60 rental payments tested had errors in the rent reasonableness forms. • 3 of the 55 rental payments that did have rent reasonableness performed did not have rent reasonableness analyzed in the past 12-months of the rent payment. Cause: The Village did not appropriately retain or produce documentation verifying that rent reasonableness was assessed prior to move-in or during changes to lease terms, as required by its policies. Furthermore, not all supporting documentation for initial or changes to lease terms was obtained or retained. Effect or Potential Effect: The insufficient retention or creation of rent reasonableness forms and supporting documentation has led to ineffective operation of rent reasonableness controls, thereby not appropriately identifying rental amounts for the Village’s clients in need of rental assistance. Consequently, this deficiency could result in incorrect charges being applied to the Federal program. Questioned Costs: Known Questioned Costs: $6,678 Likely Questioned Costs: $170,185 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Questioned costs were determined as the amounts paid without supporting rent reasonableness documentation. The total costs subject to rent reasonableness amounted to $2,429,908. Repeat Finding: 2023-006 Recommendation: We recommend that the Village enhance existing policies to ensure rent reasonableness is performed on all rental assistance. In addition, we recommend management ensures determinations are performed prior to move-in or rent changes being charged, and documentation is maintained for both the rent amount and reasonableness of the rent. We further recommend a policy be enacted for reviewing rent reasonableness on a periodic basis (i.e. annually) for those tenants that have not had a change in rent during the period. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.51(g), “HUD will only provide rental assistance for a unit if the rent is reasonable. The recipient or subrecipient must determine whether the rent charged for the unit receiving rental assistance is reasonable in relation to rents being charged for comparable unassisted units, taking into account the location, size, type, quality, amenities, facilities, and management and maintenance of each unit. Reasonable rent must not exceed rents currently being charged by the same owner for comparable unassisted units.” Condition: In accordance with 24 CFR §578.51(g), we noted that: • 5 out of 60 rental payments tested did not have a comparable unit analysis conducted. • 23 out of 60 rental payments did not have a comparable unit analysis completed in a timely manner prior to the tenant’s move-in or prior to increases in rent. • 1 out of 60 rental payments tested did not have documentation for amounts charged (such as lease agreements, rent increase letters, or invoices). • 6 out of 60 rental payments tested had errors in the rent reasonableness forms. • 3 of the 55 rental payments that did have rent reasonableness performed did not have rent reasonableness analyzed in the past 12-months of the rent payment. Cause: The Village did not appropriately retain or produce documentation verifying that rent reasonableness was assessed prior to move-in or during changes to lease terms, as required by its policies. Furthermore, not all supporting documentation for initial or changes to lease terms was obtained or retained. Effect or Potential Effect: The insufficient retention or creation of rent reasonableness forms and supporting documentation has led to ineffective operation of rent reasonableness controls, thereby not appropriately identifying rental amounts for the Village’s clients in need of rental assistance. Consequently, this deficiency could result in incorrect charges being applied to the Federal program. Questioned Costs: Known Questioned Costs: $6,678 Likely Questioned Costs: $170,185 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Questioned costs were determined as the amounts paid without supporting rent reasonableness documentation. The total costs subject to rent reasonableness amounted to $2,429,908. Repeat Finding: 2023-006 Recommendation: We recommend that the Village enhance existing policies to ensure rent reasonableness is performed on all rental assistance. In addition, we recommend management ensures determinations are performed prior to move-in or rent changes being charged, and documentation is maintained for both the rent amount and reasonableness of the rent. We further recommend a policy be enacted for reviewing rent reasonableness on a periodic basis (i.e. annually) for those tenants that have not had a change in rent during the period. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.51(g), “HUD will only provide rental assistance for a unit if the rent is reasonable. The recipient or subrecipient must determine whether the rent charged for the unit receiving rental assistance is reasonable in relation to rents being charged for comparable unassisted units, taking into account the location, size, type, quality, amenities, facilities, and management and maintenance of each unit. Reasonable rent must not exceed rents currently being charged by the same owner for comparable unassisted units.” Condition: In accordance with 24 CFR §578.51(g), we noted that: • 5 out of 60 rental payments tested did not have a comparable unit analysis conducted. • 23 out of 60 rental payments did not have a comparable unit analysis completed in a timely manner prior to the tenant’s move-in or prior to increases in rent. • 1 out of 60 rental payments tested did not have documentation for amounts charged (such as lease agreements, rent increase letters, or invoices). • 6 out of 60 rental payments tested had errors in the rent reasonableness forms. • 3 of the 55 rental payments that did have rent reasonableness performed did not have rent reasonableness analyzed in the past 12-months of the rent payment. Cause: The Village did not appropriately retain or produce documentation verifying that rent reasonableness was assessed prior to move-in or during changes to lease terms, as required by its policies. Furthermore, not all supporting documentation for initial or changes to lease terms was obtained or retained. Effect or Potential Effect: The insufficient retention or creation of rent reasonableness forms and supporting documentation has led to ineffective operation of rent reasonableness controls, thereby not appropriately identifying rental amounts for the Village’s clients in need of rental assistance. Consequently, this deficiency could result in incorrect charges being applied to the Federal program. Questioned Costs: Known Questioned Costs: $6,678 Likely Questioned Costs: $170,185 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Questioned costs were determined as the amounts paid without supporting rent reasonableness documentation. The total costs subject to rent reasonableness amounted to $2,429,908. Repeat Finding: 2023-006 Recommendation: We recommend that the Village enhance existing policies to ensure rent reasonableness is performed on all rental assistance. In addition, we recommend management ensures determinations are performed prior to move-in or rent changes being charged, and documentation is maintained for both the rent amount and reasonableness of the rent. We further recommend a policy be enacted for reviewing rent reasonableness on a periodic basis (i.e. annually) for those tenants that have not had a change in rent during the period. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.51(g), “HUD will only provide rental assistance for a unit if the rent is reasonable. The recipient or subrecipient must determine whether the rent charged for the unit receiving rental assistance is reasonable in relation to rents being charged for comparable unassisted units, taking into account the location, size, type, quality, amenities, facilities, and management and maintenance of each unit. Reasonable rent must not exceed rents currently being charged by the same owner for comparable unassisted units.” Condition: In accordance with 24 CFR §578.51(g), we noted that: • 5 out of 60 rental payments tested did not have a comparable unit analysis conducted. • 23 out of 60 rental payments did not have a comparable unit analysis completed in a timely manner prior to the tenant’s move-in or prior to increases in rent. • 1 out of 60 rental payments tested did not have documentation for amounts charged (such as lease agreements, rent increase letters, or invoices). • 6 out of 60 rental payments tested had errors in the rent reasonableness forms. • 3 of the 55 rental payments that did have rent reasonableness performed did not have rent reasonableness analyzed in the past 12-months of the rent payment. Cause: The Village did not appropriately retain or produce documentation verifying that rent reasonableness was assessed prior to move-in or during changes to lease terms, as required by its policies. Furthermore, not all supporting documentation for initial or changes to lease terms was obtained or retained. Effect or Potential Effect: The insufficient retention or creation of rent reasonableness forms and supporting documentation has led to ineffective operation of rent reasonableness controls, thereby not appropriately identifying rental amounts for the Village’s clients in need of rental assistance. Consequently, this deficiency could result in incorrect charges being applied to the Federal program. Questioned Costs: Known Questioned Costs: $6,678 Likely Questioned Costs: $170,185 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Questioned costs were determined as the amounts paid without supporting rent reasonableness documentation. The total costs subject to rent reasonableness amounted to $2,429,908. Repeat Finding: 2023-006 Recommendation: We recommend that the Village enhance existing policies to ensure rent reasonableness is performed on all rental assistance. In addition, we recommend management ensures determinations are performed prior to move-in or rent changes being charged, and documentation is maintained for both the rent amount and reasonableness of the rent. We further recommend a policy be enacted for reviewing rent reasonableness on a periodic basis (i.e. annually) for those tenants that have not had a change in rent during the period. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.51(g), “HUD will only provide rental assistance for a unit if the rent is reasonable. The recipient or subrecipient must determine whether the rent charged for the unit receiving rental assistance is reasonable in relation to rents being charged for comparable unassisted units, taking into account the location, size, type, quality, amenities, facilities, and management and maintenance of each unit. Reasonable rent must not exceed rents currently being charged by the same owner for comparable unassisted units.” Condition: In accordance with 24 CFR §578.51(g), we noted that: • 5 out of 60 rental payments tested did not have a comparable unit analysis conducted. • 23 out of 60 rental payments did not have a comparable unit analysis completed in a timely manner prior to the tenant’s move-in or prior to increases in rent. • 1 out of 60 rental payments tested did not have documentation for amounts charged (such as lease agreements, rent increase letters, or invoices). • 6 out of 60 rental payments tested had errors in the rent reasonableness forms. • 3 of the 55 rental payments that did have rent reasonableness performed did not have rent reasonableness analyzed in the past 12-months of the rent payment. Cause: The Village did not appropriately retain or produce documentation verifying that rent reasonableness was assessed prior to move-in or during changes to lease terms, as required by its policies. Furthermore, not all supporting documentation for initial or changes to lease terms was obtained or retained. Effect or Potential Effect: The insufficient retention or creation of rent reasonableness forms and supporting documentation has led to ineffective operation of rent reasonableness controls, thereby not appropriately identifying rental amounts for the Village’s clients in need of rental assistance. Consequently, this deficiency could result in incorrect charges being applied to the Federal program. Questioned Costs: Known Questioned Costs: $6,678 Likely Questioned Costs: $170,185 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Questioned costs were determined as the amounts paid without supporting rent reasonableness documentation. The total costs subject to rent reasonableness amounted to $2,429,908. Repeat Finding: 2023-006 Recommendation: We recommend that the Village enhance existing policies to ensure rent reasonableness is performed on all rental assistance. In addition, we recommend management ensures determinations are performed prior to move-in or rent changes being charged, and documentation is maintained for both the rent amount and reasonableness of the rent. We further recommend a policy be enacted for reviewing rent reasonableness on a periodic basis (i.e. annually) for those tenants that have not had a change in rent during the period. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.73(b): “Notwithstanding 2 CFR 200.306(b)(5), a recipient or subrecipient may use funds from any source, including any other federal sources (excluding Continuum of Care program funds), as well as State, local, and private sources, provided that funds from the source are not statutorily prohibited to be used as a match. The recipient must ensure that any funds used to satisfy the matching requirements of this section are eligible under the laws governing the funds in order to be used as matching funds for a grant awarded under this program.” Condition: We noted that the Village’s controls did not identify certain costs within the matching pool that were unallowable under the matching cost principles. However, the matching pool exceeded the required match, and management was able to fulfil the match without the unallowable costs in the pool. Cause: The Village did not have adequate policies and procedures in place to ensure that only allowable costs were included in the matching pool used to satisfy matching requirements. Potential Effect: Without adequate controls in place, the Village could utilize costs for matching requirements that are not in compliance with §578.73. This may impact the Village’s ability to meet the required matching threshold, result in repayment of funds, and could affect future funding. Questioned Costs: None. Context: The Village incurred total costs that exceeded the required match. As a result, they were able to offset any unallowable costs, while still meeting the required match and remaining in compliance at year end. Repeat Finding: Not a repeat finding. Recommendation: We recommend Village enhance their policies and procedures to ensure that only allowable costs are utilized to satisfy matching requirements. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.73(b): “Notwithstanding 2 CFR 200.306(b)(5), a recipient or subrecipient may use funds from any source, including any other federal sources (excluding Continuum of Care program funds), as well as State, local, and private sources, provided that funds from the source are not statutorily prohibited to be used as a match. The recipient must ensure that any funds used to satisfy the matching requirements of this section are eligible under the laws governing the funds in order to be used as matching funds for a grant awarded under this program.” Condition: We noted that the Village’s controls did not identify certain costs within the matching pool that were unallowable under the matching cost principles. However, the matching pool exceeded the required match, and management was able to fulfil the match without the unallowable costs in the pool. Cause: The Village did not have adequate policies and procedures in place to ensure that only allowable costs were included in the matching pool used to satisfy matching requirements. Potential Effect: Without adequate controls in place, the Village could utilize costs for matching requirements that are not in compliance with §578.73. This may impact the Village’s ability to meet the required matching threshold, result in repayment of funds, and could affect future funding. Questioned Costs: None. Context: The Village incurred total costs that exceeded the required match. As a result, they were able to offset any unallowable costs, while still meeting the required match and remaining in compliance at year end. Repeat Finding: Not a repeat finding. Recommendation: We recommend Village enhance their policies and procedures to ensure that only allowable costs are utilized to satisfy matching requirements. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.73(b): “Notwithstanding 2 CFR 200.306(b)(5), a recipient or subrecipient may use funds from any source, including any other federal sources (excluding Continuum of Care program funds), as well as State, local, and private sources, provided that funds from the source are not statutorily prohibited to be used as a match. The recipient must ensure that any funds used to satisfy the matching requirements of this section are eligible under the laws governing the funds in order to be used as matching funds for a grant awarded under this program.” Condition: We noted that the Village’s controls did not identify certain costs within the matching pool that were unallowable under the matching cost principles. However, the matching pool exceeded the required match, and management was able to fulfil the match without the unallowable costs in the pool. Cause: The Village did not have adequate policies and procedures in place to ensure that only allowable costs were included in the matching pool used to satisfy matching requirements. Potential Effect: Without adequate controls in place, the Village could utilize costs for matching requirements that are not in compliance with §578.73. This may impact the Village’s ability to meet the required matching threshold, result in repayment of funds, and could affect future funding. Questioned Costs: None. Context: The Village incurred total costs that exceeded the required match. As a result, they were able to offset any unallowable costs, while still meeting the required match and remaining in compliance at year end. Repeat Finding: Not a repeat finding. Recommendation: We recommend Village enhance their policies and procedures to ensure that only allowable costs are utilized to satisfy matching requirements. Views of Responsible Officials:
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.267 Program: Continuum of Care Program Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 24 CFR §578.73(b): “Notwithstanding 2 CFR 200.306(b)(5), a recipient or subrecipient may use funds from any source, including any other federal sources (excluding Continuum of Care program funds), as well as State, local, and private sources, provided that funds from the source are not statutorily prohibited to be used as a match. The recipient must ensure that any funds used to satisfy the matching requirements of this section are eligible under the laws governing the funds in order to be used as matching funds for a grant awarded under this program.” Condition: We noted that the Village’s controls did not identify certain costs within the matching pool that were unallowable under the matching cost principles. However, the matching pool exceeded the required match, and management was able to fulfil the match without the unallowable costs in the pool. Cause: The Village did not have adequate policies and procedures in place to ensure that only allowable costs were included in the matching pool used to satisfy matching requirements. Potential Effect: Without adequate controls in place, the Village could utilize costs for matching requirements that are not in compliance with §578.73. This may impact the Village’s ability to meet the required matching threshold, result in repayment of funds, and could affect future funding. Questioned Costs: None. Context: The Village incurred total costs that exceeded the required match. As a result, they were able to offset any unallowable costs, while still meeting the required match and remaining in compliance at year end. Repeat Finding: Not a repeat finding. Recommendation: We recommend Village enhance their policies and procedures to ensure that only allowable costs are utilized to satisfy matching requirements. Views of Responsible Officials: