2024-002 Compensation for Personal Services Coronavirus State & Local Fiscal Recovery Funds – Assistance Listing No. 21.027 – COVID-19 Funding Award Number: 24-IHFA 186302 – Award Period: October 1, 2023 through September 30, 2024 Award Number: Aurora ARPA – Award Period: April 1, 2024 through December 31, 2024 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Condition: Hours spent working on different funding sources/cost objectives from payroll timesheets did not agree to hours entered into the payroll allocation spreadsheets for five pay periods for sampled employees #1 and #2. Additionally, total hours worked and logged on timesheets did not agree to hours paid for two pay periods for sampled employees #1 and #3. These errors were not detected and corrected after-the-fact. Criteria: According to 2 CFR 200.303(a), non-Federal entities must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Per 2 CFR 200.430(i)(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 Questioned Costs: Not determinable. Cause: The Organization’s established internal controls over salary and wage cost allocation did not operate as intended. Effect: Allowable costs could potentially be overpaid or underpaid or disallowed and required to be paid back to the Federal awarding agency (and/or pass-through entity). Recommendation: The Organization should strengthen their policies and procedures to support a system of internal control able to prevent and/or detect and correct errors timely ensuring costs are accurate, allowable, and properly allocated. Views of Responsible Officials and Planned Corrective Actions: Gateway Domestic Violence Services acknowledges there were errors made but can attest that the charges to funders were correct. See separately issued corrective action plan.
Finding # 2024-001 Type: Material weakness Type: Material noncompliance Assistance Listing Number: Department of Health and Human Services 93.658 Requirement: Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. Such records must meet the standards as specified in 2 CFR 200 Subpart E Cost Principles §200.430. Condition: Payroll allocations were done based on management’s estimate through departmental meetings and work assignments rather than actual time records maintained by staff. Context: Payroll allocation during the months of January through April 2024 were based on estimates. Total payroll charged during this time was approximately $218,000 of the $815,000 total federal expenditures for the year. Cause: Management became aware of the need for a time tracking system after the activities funded by the Federal awards began. Effect: Payroll costs charged to the grant may not be accurate. Questioned Costs: Approximately $218,000 Recommendation: We recommend that management continue to reinforce utilization of the time tracking system that was implemented in 2024. In addition, management should ensure that the timecards submitted by staff are reviewed and approved timely. Management’s Response: Management agrees and as noted, a new time tracking system was implemented in May 2024 and no exceptions were identified after implementation.
Significant Deficiency in Internal Control Over Compliance and Noncompliance – Inadequate Payroll Review and Documentation B. Allowable Costs/Cost Principles Criteria: Per 2 CFR § 200.430(g), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed and are supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. As part of ELI’s internal controls, time and effort documentation, such as employee salary and wage allocations, should be reviewed and approved by ELI to confirm accuracy and consistency with policies or approvals. Condition and Context: We haphazardly selected three months of payroll allocations which included 23 individuals. Our sample was not statistically valid. During our testing of payroll expenses charged to the federal program, we noted controls in place were not sufficient to ensure the amounts charged to the award were properly reviewed and approved to ensure amounts charged agreed to those approved to be charged. This resulted in three errors identified in our testing: January payroll allocations were based on the approved budget, but the amounts charged differed from the budgeted amounts resulting in known questioned costs of $1,014. This impacted 18 of the 23 individuals selected for testing. Two individuals charged to the award had time which was not approved to be charged to the award resulting in known questioned costs of $8,395 and likely questioned costs of $31,717. Likely questioned costs were calculated by quantifying the total amount of payroll for these individuals which were charged to the federal award. Paid time off and holiday pay were not allocated to the awards at the approved allocation rate throughout 2024. This resulted in the cost being under-allocated by $1,924 which did not result in any known question costs. Cause and Effect: Management was working to establish improved controls for reviewing and approving payroll expenses charged to federal awards. This ultimately resulted in establishing a monthly review of all payroll charges to federal awards starting in July 2024. However, management did not include any detective controls to review that approved payroll allocations were being implemented as intended. This resulted in the errors noted above. Recommendation: We recommend that management establish detective controls to ensure payroll expenses are being charged consistently with established policies and approved allocations. Views of Responsible Officials and Planned Corrective Action: We agree with the recommendation and portions of the plan were implemented in February 2024, while the remainder was implemented in July 2025. In January 2024, the ELI team reviewed team members and their respective salary allocations, specifically for the Early Head Start program. Allocations were documented and updated in Axiom, ELI’s payroll system of record. Those allocations were then updated in early February 2024 and regular meetings to review, document and update allocations as needed, have since been held on a consistent basis. The secondary piece, corrected in July 2025, was a system correction for allocation of PTO and Holiday pay, those were not being allocated to EHS consistent with the agreed upon allocations and not going to EHS as they should have been. This has been corrected in Axiom and the ELI accounting team will now perform regular reviews to confirm allocation in agreement with the agreed upon amounts. In addition, correcting entries for 2024 and 2025 will be made by August 31, 2025.
Significant Deficiency in Internal Control Over Compliance and Noncompliance – Inadequate Payroll Review and Documentation B. Allowable Costs/Cost Principles Criteria: Per 2 CFR § 200.430(g), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed and are supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. As part of ELI’s internal controls, time and effort documentation, such as employee salary and wage allocations, should be reviewed and approved by ELI to confirm accuracy and consistency with policies or approvals. Condition and Context: We haphazardly selected three months of payroll allocations which included 23 individuals. Our sample was not statistically valid. During our testing of payroll expenses charged to the federal program, we noted controls in place were not sufficient to ensure the amounts charged to the award were properly reviewed and approved to ensure amounts charged agreed to those approved to be charged. This resulted in three errors identified in our testing: January payroll allocations were based on the approved budget, but the amounts charged differed from the budgeted amounts resulting in known questioned costs of $1,014. This impacted 18 of the 23 individuals selected for testing. Two individuals charged to the award had time which was not approved to be charged to the award resulting in known questioned costs of $8,395 and likely questioned costs of $31,717. Likely questioned costs were calculated by quantifying the total amount of payroll for these individuals which were charged to the federal award. Paid time off and holiday pay were not allocated to the awards at the approved allocation rate throughout 2024. This resulted in the cost being under-allocated by $1,924 which did not result in any known question costs. Cause and Effect: Management was working to establish improved controls for reviewing and approving payroll expenses charged to federal awards. This ultimately resulted in establishing a monthly review of all payroll charges to federal awards starting in July 2024. However, management did not include any detective controls to review that approved payroll allocations were being implemented as intended. This resulted in the errors noted above. Recommendation: We recommend that management establish detective controls to ensure payroll expenses are being charged consistently with established policies and approved allocations. Views of Responsible Officials and Planned Corrective Action: We agree with the recommendation and portions of the plan were implemented in February 2024, while the remainder was implemented in July 2025. In January 2024, the ELI team reviewed team members and their respective salary allocations, specifically for the Early Head Start program. Allocations were documented and updated in Axiom, ELI’s payroll system of record. Those allocations were then updated in early February 2024 and regular meetings to review, document and update allocations as needed, have since been held on a consistent basis. The secondary piece, corrected in July 2025, was a system correction for allocation of PTO and Holiday pay, those were not being allocated to EHS consistent with the agreed upon allocations and not going to EHS as they should have been. This has been corrected in Axiom and the ELI accounting team will now perform regular reviews to confirm allocation in agreement with the agreed upon amounts. In addition, correcting entries for 2024 and 2025 will be made by August 31, 2025.
Significant Deficiency in Internal Control Over Compliance and Noncompliance – Inadequate Payroll Review and Documentation B. Allowable Costs/Cost Principles Criteria: Per 2 CFR § 200.430(g), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed and are supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. As part of ELI’s internal controls, time and effort documentation, such as employee salary and wage allocations, should be reviewed and approved by ELI to confirm accuracy and consistency with policies or approvals. Condition and Context: We haphazardly selected three months of payroll allocations which included 23 individuals. Our sample was not statistically valid. During our testing of payroll expenses charged to the federal program, we noted controls in place were not sufficient to ensure the amounts charged to the award were properly reviewed and approved to ensure amounts charged agreed to those approved to be charged. This resulted in three errors identified in our testing: January payroll allocations were based on the approved budget, but the amounts charged differed from the budgeted amounts resulting in known questioned costs of $1,014. This impacted 18 of the 23 individuals selected for testing. Two individuals charged to the award had time which was not approved to be charged to the award resulting in known questioned costs of $8,395 and likely questioned costs of $31,717. Likely questioned costs were calculated by quantifying the total amount of payroll for these individuals which were charged to the federal award. Paid time off and holiday pay were not allocated to the awards at the approved allocation rate throughout 2024. This resulted in the cost being under-allocated by $1,924 which did not result in any known question costs. Cause and Effect: Management was working to establish improved controls for reviewing and approving payroll expenses charged to federal awards. This ultimately resulted in establishing a monthly review of all payroll charges to federal awards starting in July 2024. However, management did not include any detective controls to review that approved payroll allocations were being implemented as intended. This resulted in the errors noted above. Recommendation: We recommend that management establish detective controls to ensure payroll expenses are being charged consistently with established policies and approved allocations. Views of Responsible Officials and Planned Corrective Action: We agree with the recommendation and portions of the plan were implemented in February 2024, while the remainder was implemented in July 2025. In January 2024, the ELI team reviewed team members and their respective salary allocations, specifically for the Early Head Start program. Allocations were documented and updated in Axiom, ELI’s payroll system of record. Those allocations were then updated in early February 2024 and regular meetings to review, document and update allocations as needed, have since been held on a consistent basis. The secondary piece, corrected in July 2025, was a system correction for allocation of PTO and Holiday pay, those were not being allocated to EHS consistent with the agreed upon allocations and not going to EHS as they should have been. This has been corrected in Axiom and the ELI accounting team will now perform regular reviews to confirm allocation in agreement with the agreed upon amounts. In addition, correcting entries for 2024 and 2025 will be made by August 31, 2025.
Finding 2024-002 Insufficient Documentation of Personnel Expenses Type of Finding: Noncompliance and Material Weakness in Internal Control over Compliance Condition: The Organization charges a material amount of payroll-related costs to its major federal program. However, it does not maintain sufficient documentation to support the level of effort charged to the award, as required by federal regulations. While staff members are required to complete timesheets, the current format does not capture the level of detail needed to substantiate payroll allocations to federal programs. Additionally, there is no formal process for supervisory review and approval of these timesheets. Although no overcharges or double-dipping were identified, the lack of adequate documentation results in known and likely questioned costs due to noncompliance with documentation requirements. Criteria: According to Uniform Guidance 2 CFR §200.430(g), the Organization's charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable, and properly allocated. The records also must reasonably reflect the total activity for which the employee is compensated. The records also must 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. Cause: This issue appears to stem from two primary causes: (1) the timesheet system in use was not designed to capture the information needed to support federal payroll charges, and (2) there is a lack of formal internal controls around timekeeping, including supervisory review and approval of reported time. Possible of Known Effect: As a result, a material amount of salary and payroll taxes charged to the federal program is not adequately supported in accordance with 2 CFR 200.430. This leads to both known and likely questioned costs. The absence of proper documentation increases the risk of misallocated expenses and undermines the Organization’s ability to demonstrate compliance with federal cost principles. Questioned Costs: Known questioned costs of $36,262 were identified. Repeat Finding: This is not a repeat finding. Recommendation: We recommend that the Organization revise its timekeeping system to ensure that staff members record time in a manner that clearly supports the allocation of payroll costs to federal programs. Timesheets should include sufficient detail and be reviewed and approved by supervisors, with documentation of this review retained for audit purposes. For senior leadership, including the CEO, the Organization should implement appropriate methods such as time studies or activity logs to document effort charged to federal awards. Additionally, we recommend the development and documentation of internal controls to oversee the time reporting process and ensure compliance with federal requirements. Views of Responsible Officials: The Organization will develop and implement a standardized timesheet template (Gusto) that captures employee name, pay period, hours worked by funding source, and supervisory approval. Provide mandatory training for all staff whose salaries are charged in whole or in part to grants on documentation and time allocation requirements. Require monthly reconciliation of time sheets to payroll records before submission to grants. The Organization will conduct quarterly internal reviews to ensure compliance and adjust as needed.
2 CFR § 300 codified in 45 CFR part 75 and gives regulatory effect to the Department of Health and Human Services 2 CFR § 200; while 2 CFR § 400 gives regulatory effect to the Department of Agriculture for 2 CFR § 200. 2 CFR § 200.302(b)(6) states the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR § 200.305 for Payment. 2 CFR 200.302(b)(7) requires written procedures for determining the allowability of costs in accordance with Subpart E-Cost Principles of this part and the terms and conditions of the Federal award. 2 CFR 200.430 states that costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity's laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable. 2 CFR 200.431 requires established written leave policies if the entity intends to pay fringe benefits. 2 CFR 200.464(a)(2) requires reimbursement of relocation costs to employees be in accordance with an established written policy must be consistently followed by the employer. 2 CFR 200.475 requires reimbursement and/or charges to be consistent with those normally allowed in like circumstances in the non-Federal entity's non-federally-funded activities and in accordance with non-Federal entity's written travel reimbursement policies. Additionally, for Federal awards, the Uniform Guidance requires a written policy for the procurement requirements outlined in 2 CFR § 200.318(c)(1), 2 CFR § 200.318(c)(2), and 2 CFR § 200.320(B). The Board of Health did not have written policies as required by the Uniform Guidance as they were not aware of the requirements. The failure to implement written policies as required by the Uniform Guidance could result in noncompliance with the District’s federal programs. The Board of Health should adopt written policies in accordance with the Uniform Guidance to help improve internal controls over federal compliance.
2 CFR § 300 codified in 45 CFR part 75 and gives regulatory effect to the Department of Health and Human Services 2 CFR § 200; while 2 CFR § 400 gives regulatory effect to the Department of Agriculture for 2 CFR § 200. 2 CFR § 200.302(b)(6) states the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR § 200.305 for Payment. 2 CFR 200.302(b)(7) requires written procedures for determining the allowability of costs in accordance with Subpart E-Cost Principles of this part and the terms and conditions of the Federal award. 2 CFR 200.430 states that costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity's laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable. 2 CFR 200.431 requires established written leave policies if the entity intends to pay fringe benefits. 2 CFR 200.464(a)(2) requires reimbursement of relocation costs to employees be in accordance with an established written policy must be consistently followed by the employer. 2 CFR 200.475 requires reimbursement and/or charges to be consistent with those normally allowed in like circumstances in the non-Federal entity's non-federally-funded activities and in accordance with non-Federal entity's written travel reimbursement policies. Additionally, for Federal awards, the Uniform Guidance requires a written policy for the procurement requirements outlined in 2 CFR § 200.318(c)(1), 2 CFR § 200.318(c)(2), and 2 CFR § 200.320(B). The Board of Health did not have written policies as required by the Uniform Guidance as they were not aware of the requirements. The failure to implement written policies as required by the Uniform Guidance could result in noncompliance with the District’s federal programs. The Board of Health should adopt written policies in accordance with the Uniform Guidance to help improve internal controls over federal compliance.
2 CFR § 300 codified in 45 CFR part 75 and gives regulatory effect to the Department of Health and Human Services 2 CFR § 200; while 2 CFR § 400 gives regulatory effect to the Department of Agriculture for 2 CFR § 200. 2 CFR § 200.302(b)(6) states the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR § 200.305 for Payment. 2 CFR 200.302(b)(7) requires written procedures for determining the allowability of costs in accordance with Subpart E-Cost Principles of this part and the terms and conditions of the Federal award. 2 CFR 200.430 states that costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity's laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable. 2 CFR 200.431 requires established written leave policies if the entity intends to pay fringe benefits. 2 CFR 200.464(a)(2) requires reimbursement of relocation costs to employees be in accordance with an established written policy must be consistently followed by the employer. 2 CFR 200.475 requires reimbursement and/or charges to be consistent with those normally allowed in like circumstances in the non-Federal entity's non-federally-funded activities and in accordance with non-Federal entity's written travel reimbursement policies. Additionally, for Federal awards, the Uniform Guidance requires a written policy for the procurement requirements outlined in 2 CFR § 200.318(c)(1), 2 CFR § 200.318(c)(2), and 2 CFR § 200.320(B). The Board of Health did not have written policies as required by the Uniform Guidance as they were not aware of the requirements. The failure to implement written policies as required by the Uniform Guidance could result in noncompliance with the District’s federal programs. The Board of Health should adopt written policies in accordance with the Uniform Guidance to help improve internal controls over federal compliance.
2 CFR § 300 codified in 45 CFR part 75 and gives regulatory effect to the Department of Health and Human Services 2 CFR § 200; while 2 CFR § 400 gives regulatory effect to the Department of Agriculture for 2 CFR § 200. 2 CFR § 200.302(b)(6) states the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR § 200.305 for Payment. 2 CFR 200.302(b)(7) requires written procedures for determining the allowability of costs in accordance with Subpart E-Cost Principles of this part and the terms and conditions of the Federal award. 2 CFR 200.430 states that costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity's laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable. 2 CFR 200.431 requires established written leave policies if the entity intends to pay fringe benefits. 2 CFR 200.464(a)(2) requires reimbursement of relocation costs to employees be in accordance with an established written policy must be consistently followed by the employer. 2 CFR 200.475 requires reimbursement and/or charges to be consistent with those normally allowed in like circumstances in the non-Federal entity's non-federally-funded activities and in accordance with non-Federal entity's written travel reimbursement policies. Additionally, for Federal awards, the Uniform Guidance requires a written policy for the procurement requirements outlined in 2 CFR § 200.318(c)(1), 2 CFR § 200.318(c)(2), and 2 CFR § 200.320(B). The Board of Health did not have written policies as required by the Uniform Guidance as they were not aware of the requirements. The failure to implement written policies as required by the Uniform Guidance could result in noncompliance with the District’s federal programs. The Board of Health should adopt written policies in accordance with the Uniform Guidance to help improve internal controls over federal compliance.
2 CFR § 300 codified in 45 CFR part 75 and gives regulatory effect to the Department of Health and Human Services 2 CFR § 200; while 2 CFR § 400 gives regulatory effect to the Department of Agriculture for 2 CFR § 200. 2 CFR § 200.302(b)(6) states the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR § 200.305 for Payment. 2 CFR 200.302(b)(7) requires written procedures for determining the allowability of costs in accordance with Subpart E-Cost Principles of this part and the terms and conditions of the Federal award. 2 CFR 200.430 states that costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity's laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable. 2 CFR 200.431 requires established written leave policies if the entity intends to pay fringe benefits. 2 CFR 200.464(a)(2) requires reimbursement of relocation costs to employees be in accordance with an established written policy must be consistently followed by the employer. 2 CFR 200.475 requires reimbursement and/or charges to be consistent with those normally allowed in like circumstances in the non-Federal entity's non-federally-funded activities and in accordance with non-Federal entity's written travel reimbursement policies. Additionally, for Federal awards, the Uniform Guidance requires a written policy for the procurement requirements outlined in 2 CFR § 200.318(c)(1), 2 CFR § 200.318(c)(2), and 2 CFR § 200.320(B). The Board of Health did not have written policies as required by the Uniform Guidance as they were not aware of the requirements. The failure to implement written policies as required by the Uniform Guidance could result in noncompliance with the District’s federal programs. The Board of Health should adopt written policies in accordance with the Uniform Guidance to help improve internal controls over federal compliance.
2024-003 Time and Effort Documentation (Internal Control) Federal Program: Housing Voucher Cluster; CFDA #14.871 Federal Agency: U.S. Department of Housing and Urban Development Award Period: 2024 Finding resolution status Unresolved Information on universe and population size The universe and population consisted of 26 payroll periods. Sample size information A non‑statistical sample of 3 payroll periods were selected for testing. Identification as a repeat finding This is a repeat finding. Criteria 2 CFR §200.430(i) requires charges to Federal awards for salaries and wages to be based on records that accurately reflect the work performed and that are supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. HUD guidance reiterates the requirement for after the fact time and activity documentation to support payroll allocations to grants. Statement of condition Payroll allocations for four employees were established prospectively at the beginning of the year and were not adjusted to reflect actual time and effort during the year. These employees do not complete detailed timesheets; therefore, there is no after‑the‑fact documentation to support the accuracy of payroll costs charged to Federal programs. Cause Management believed that, because the employees work consistent hours on the same programs each week and supervisory knowledge of attendance exists, maintaining detailed time and effort records was unnecessary. Effect Without contemporaneous, after the fact documentation of actual time spent on each Federal program, the organization cannot demonstrate that salary costs are accurately allocated, increasing the risk of unallowable costs being charged to the grants. Auditor non-compliance code S – Internal Control Deficiencies Questioned costs None Views of responsible officials Management concurs with the finding and has performed a time-study to support program allocations. The allocations have been implemented in 2025. Context The exception was isolated to four administrative employees. The maintenance employee maintained acceptable property specific timesheets and was not included in the exception population. Recommendation We recommend that the organization establish an after the fact time and activity reporting system that meets Uniform Guidance requirements and adjust payroll allocations at least quarterly to reflect actual effort expended. Information on universe and population size The universe and population consisted of 26 payroll periods. Sample size information A non‑statistical sample of 3 payroll periods were selected for testing. Identification as a repeat finding This is a repeat finding. Criteria 2 CFR §200.430(i) requires charges to Federal awards for salaries and wages to be based on records that accurately reflect the work performed and that are supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. HUD guidance reiterates the requirement for after the fact time and activity documentation to support payroll allocations to grants. Statement of condition Payroll allocations for four employees were established prospectively at the beginning of the year and were not adjusted to reflect actual time and effort during the year. These employees do not complete detailed timesheets; therefore, there is no after‑the‑fact documentation to support the accuracy of payroll costs charged to Federal programs. Cause Management believed that, because the employees work consistent hours on the same programs each week and supervisory knowledge of attendance exists, maintaining detailed time and effort records was unnecessary. Effect Without contemporaneous, after the fact documentation of actual time spent on each Federal program, the organization cannot demonstrate that salary costs are accurately allocated, increasing the risk of unallowable costs being charged to the grants. Auditor non-compliance code S – Internal Control Deficiencies Questioned costs None Views of responsible officials Management concurs with the finding and has performed a time-study to support program allocations. The allocations have been implemented in 2025. Context The exception was isolated to four administrative employees. The maintenance employee maintained acceptable property specific timesheets and was not included in the exception population. Recommendation We recommend that the organization establish an after the fact time and activity reporting system that meets Uniform Guidance requirements and adjust payroll allocations at least quarterly to reflect actual effort expended.
Federal agency: U.S. Department of Agriculture, Natural Resources Conservation Service Federal program Name: Partnerships for Climate-Smart Commodities Assistance Listing Number: 10.937 Federal Award Identification No.: NR243A750004G023 Award Period: 12/9/2023 – 12/31/2028 Compliance Requirement: Activities Allowed or Unallowed, Allowable Cost/Cost Principles Type of Finding: • Significant Deficiency in Internal Control over Compliance • Compliance Finding 2024-001: Partnerships for Climate-Smart Commodities- Allowable Cost/Cost Principles Criteria: 2 CFR Section 200.430 (8)(i) Standards for Documentation of Personnel Expenses states that 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 both 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 non-Federal entity; (vii) 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 which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Additionally, per 2 CFR section 200.303(a), a non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: During our review of the payroll allocation for August 2024, we noted that one employee’s payroll costs were incorrectly charged to the grant, resulting in an overstatement of grant expenditures for that period.Context: The total federal expenditures under the Partnerships for Climate-Smart Commodities program were approximately $3,074,267 for the year ended December 31, 2024. The payroll charges tested during our procedures were approximately $95,770, which represented approximately 3% of total expenditures charged to the grant during the year. The misallocation noted was isolated to a single employee’s payroll costs for one month and did not represent a systemic issue across all payroll transactions. Cause: The misallocation occurred due to insufficient review of payroll allocations. Existing internal controls did not include a detailed verification process to ensure that employee time charges were accurately aligned with actual grant-related activities. Effect: As a result, grant expenditures were overstated for the period. If not corrected, this misallocation could impact the accuracy of financial reporting and result in potential noncompliance with grant cost allowability requirements. Identification as a Repeat Finding, if Applicable: No. Questioned Costs: None identified. Recommendation: We recommend that management strengthen internal controls over payroll allocation by implementing a documented review and approval process to verify the accuracy and allowability of personnel expenses charged to Federal awards. This process should ensure compliance with 2 CFR §200.430 and be incorporated into official records, consistent with the entity’s established accounting policies. Responsible Official: President Views of Responsible Official and Planned Corrective Action: Management concurs with the audit finding. See the accompanying management’s corrective action plan for planned corrective action.
Assistance Listing Numbers 93.658 Foster Care Title IV-E 93.667 Social Services Block Grant Federal Agency U.S. Department of Health and Human Services Pass-Through Agency Wisconsin Department of Children and Families Award Numbers / Years Various Criteria: Per 2 CFR §200.430 - Compensation—personal services, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed, are properly supported, and are consistent with the entity’s accounting records. Additionally, 2 CFR §200.303 - Internal Controls requires non-Federal entities to establish and maintain effective internal controls that provide reasonable assurance of compliance with Federal statutes, regulations, and terms and conditions of Federal awards. Condition/Context: As part of our testing procedures over payroll, we reconciled amounts recorded on the Payroll Ledger to the General Ledger for each payroll sample that we tested. From a sample of 40, we noted two instances where the amounts recorded in the General Ledger did not agree with the corresponding amounts recorded in the Payroll Ledger. Our sample was not statistically valid. Effect: Inaccurate or unsupported recording of payroll costs increases the risk that unallowable or misstated payroll expenses may be charged to Federal awards. If not corrected, this could result in inaccurate financial reporting and potential questioned costs. Questioned Costs: None noted. Cause: Payroll Ledger records are generated from programmatic reports based on timesheet entries in the county’s Dayforce system. While manual adjustments or allocations of programmatic reports to the Payroll Ledger are sometimes made before these records are ultimately posted to the General Ledger, no formal reconciliations are performed to account for these changes. As a result, discrepancies between the programmatic reports and the General Ledger are likely whenever there are adjustments or allocations in the programmatic reports which are not posted on the General Ledger. Recommendation: We recommend that management strengthen internal controls over payroll reconciliations by: • Implementing a system review process to ensure Payroll Ledger amounts reconcile to the General Ledger. • Conducting periodic reconciliations between the programmatic reports, Payroll Ledger and General Ledger and promptly investigating any discrepancies. • Providing training to accounting personnel on proper reconciliation procedures. Views of Responsible Officials: Dayforce is configured to allocate salary expenses to an employee’s home agency and department, regardless of where the employee assigns their hours in the timekeeping system. While the timesheet programmatic reflects the agency and department where hours and dollars are functionally charged, the payroll register aligns with the General Ledger based on home agency coding. As a result, the Payroll Register and General Ledger will reconcile with each other but may not align with programmatic reports, which are based on timesheet-level allocations. This system behavior is consistent with current configuration and financial reporting practices.
Assistance Listing Numbers 93.658 Foster Care Title IV-E 93.667 Social Services Block Grant Federal Agency U.S. Department of Health and Human Services Pass-Through Agency Wisconsin Department of Children and Families Award Numbers / Years Various Criteria: Per 2 CFR §200.430 - Compensation—personal services, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed, are properly supported, and are consistent with the entity’s accounting records. Additionally, 2 CFR §200.303 - Internal Controls requires non-Federal entities to establish and maintain effective internal controls that provide reasonable assurance of compliance with Federal statutes, regulations, and terms and conditions of Federal awards. Condition/Context: As part of our testing procedures over payroll, we reconciled amounts recorded on the Payroll Ledger to the General Ledger for each payroll sample that we tested. From a sample of 40, we noted two instances where the amounts recorded in the General Ledger did not agree with the corresponding amounts recorded in the Payroll Ledger. Our sample was not statistically valid. Effect: Inaccurate or unsupported recording of payroll costs increases the risk that unallowable or misstated payroll expenses may be charged to Federal awards. If not corrected, this could result in inaccurate financial reporting and potential questioned costs. Questioned Costs: None noted. Cause: Payroll Ledger records are generated from programmatic reports based on timesheet entries in the county’s Dayforce system. While manual adjustments or allocations of programmatic reports to the Payroll Ledger are sometimes made before these records are ultimately posted to the General Ledger, no formal reconciliations are performed to account for these changes. As a result, discrepancies between the programmatic reports and the General Ledger are likely whenever there are adjustments or allocations in the programmatic reports which are not posted on the General Ledger. Recommendation: We recommend that management strengthen internal controls over payroll reconciliations by: • Implementing a system review process to ensure Payroll Ledger amounts reconcile to the General Ledger. • Conducting periodic reconciliations between the programmatic reports, Payroll Ledger and General Ledger and promptly investigating any discrepancies. • Providing training to accounting personnel on proper reconciliation procedures. Views of Responsible Officials: Dayforce is configured to allocate salary expenses to an employee’s home agency and department, regardless of where the employee assigns their hours in the timekeeping system. While the timesheet programmatic reflects the agency and department where hours and dollars are functionally charged, the payroll register aligns with the General Ledger based on home agency coding. As a result, the Payroll Register and General Ledger will reconcile with each other but may not align with programmatic reports, which are based on timesheet-level allocations. This system behavior is consistent with current configuration and financial reporting practices.
Assistance Listing Numbers 93.658 Foster Care Title IV-E 93.667 Social Services Block Grant Federal Agency U.S. Department of Health and Human Services Pass-Through Agency Wisconsin Department of Children and Families Award Numbers / Years Various Criteria: Per 2 CFR §200.430 - Compensation—personal services, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed, are properly supported, and are consistent with the entity’s accounting records. Additionally, 2 CFR §200.303 - Internal Controls requires non-Federal entities to establish and maintain effective internal controls that provide reasonable assurance of compliance with Federal statutes, regulations, and terms and conditions of Federal awards. Condition/Context: As part of our testing procedures over payroll, we reconciled amounts recorded on the Payroll Ledger to the General Ledger for each payroll sample that we tested. From a sample of 40, we noted two instances where the amounts recorded in the General Ledger did not agree with the corresponding amounts recorded in the Payroll Ledger. Our sample was not statistically valid. Effect: Inaccurate or unsupported recording of payroll costs increases the risk that unallowable or misstated payroll expenses may be charged to Federal awards. If not corrected, this could result in inaccurate financial reporting and potential questioned costs. Questioned Costs: None noted. Cause: Payroll Ledger records are generated from programmatic reports based on timesheet entries in the county’s Dayforce system. While manual adjustments or allocations of programmatic reports to the Payroll Ledger are sometimes made before these records are ultimately posted to the General Ledger, no formal reconciliations are performed to account for these changes. As a result, discrepancies between the programmatic reports and the General Ledger are likely whenever there are adjustments or allocations in the programmatic reports which are not posted on the General Ledger. Recommendation: We recommend that management strengthen internal controls over payroll reconciliations by: • Implementing a system review process to ensure Payroll Ledger amounts reconcile to the General Ledger. • Conducting periodic reconciliations between the programmatic reports, Payroll Ledger and General Ledger and promptly investigating any discrepancies. • Providing training to accounting personnel on proper reconciliation procedures. Views of Responsible Officials: Dayforce is configured to allocate salary expenses to an employee’s home agency and department, regardless of where the employee assigns their hours in the timekeeping system. While the timesheet programmatic reflects the agency and department where hours and dollars are functionally charged, the payroll register aligns with the General Ledger based on home agency coding. As a result, the Payroll Register and General Ledger will reconcile with each other but may not align with programmatic reports, which are based on timesheet-level allocations. This system behavior is consistent with current configuration and financial reporting practices.
Finding No. UG-2024-001 – Lack of Timesheets for Employees Federal Agencies, Programs, and Assistance Listing Numbers: • U.S. Department of Agriculture: Agricultural Marketing Service: • Regional Food Business Centers (Assistance Listing No. 10.186) Criteria – Per Title 2 CFR 200.430(i), charges to federal awards for labor costs must be based on records that accurately reflect the work performed. These records must: • Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. • Be incorporated into the official records of the non-Federal entity. • Reasonably reflect the total activity for which the employee is compensated. • Support the distribution of employees’ labor costs among specific activities or cost objectives. • Include budget estimates only as interim accounting devices, provided that actual work performed is subsequently verified. Condition – The Organization does not maintain timesheets or other records to document hours worked or labor cost allocations. Labor charges are recorded monthly based on budgeted amounts. Cause – The Organization has not implemented a timekeeping system or alternative time documentation for its employees. Payroll costs are charged based on budgeted amounts, which are not subsequently adjusted to reflect actual activities performed. Effect – The Organization cannot substantiate labor costs or demonstrate accurate allocation of labor costs charged to the program. Questioned Costs – Unknown. Recommendation – We recommend that the Organization implement a system for tracking time and effort that meets the requirements of Title 2 CFR 200.430. This system should include: • Detailed timesheets or activity reports for employees whose labor costs are charged to federal awards. • Supervisory review and approval of time records. • Procedures for reconciling budgeted labor charges to actual time worked. Views of Responsible Official(s) and Planned Corrective Action – See Corrective Action Plan on page 36.
Block Grants for Substance Use Prevention, Treatment, and Recovery Services 93.959 Criteria: 2 CFR Section 200.430 states that Recovery Café of Clark County’s must have a formal approval process for employee pay increases or pay changes. Condition: The Organization does not have a formal approval process for employee pay rate changes. Cause: The Organization does not have a proper internal control structure in place to complete its approval process of pay increases and pay rate changes. Effect: No formal approval process of pay increases can create noncompliance with allowable personnel costs related to federal programs.Questioned Costs: None. Recommendation: Management should develop a formal approval process for all pay increases or pay changes to ensure that the financial information is recorded appropriately in accordance with generally accepted accounting principles, is properly reconciled and recorded at year-end in a timely manner, and audits are completed in a timely manner in accordance with 2 CFR Section 200.512. Views of Responsible Officials: Management will work to develop the proper procedures to ensure proper approvals and that balances are appropriately reconciled at year-end and recorded in accordance with generally accepted accounting principles, so the reporting requirements in 2 CFR Section 200.430 are met.
Criteria: Under 2 CFR 200.430(g), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: [1] be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated, [2] reflect the total activity for which the employee is compensated, [3] encompass both federally assisted, and all other activities compensated by the non-Federal entity on an integrated basis, and [4] be incorporated into the official records of the entity. Condition: During testing of payroll and compensation expenses charged to the federal award for the period January 1, 2024 through March 31, 2024, we identified two employees who charged a portion of their time to the federal program but did not maintain timesheets or other documentation reflecting total hours worked. Timesheets maintained only showed hours worked on the federal program. As a result, we were unable to recalculate or verify the accuracy of the amounts charged to the award for these individuals during this period. Cause: The Organization had not yet implemented formal time and effort documentation procedures for employees working part-time on federal programs during the first quarter of 2024. Policies and internal controls requiring complete timesheet documentation were developed and implemented beginning in April 2024. Effect: Due to the lack of contemporaneous time and effort documentation, there is an increased risk that personnel costs charged to the federal award during the affected period may not accurately reflect the time actually devoted to the program. This may result in noncompliance with federal requirements and unallowable costs being charged to the award. Questioned Cost: We identified $14,071 in payroll charges made between January 1 and March 31, 2024 by two employees who were not working 100% on the federal program and for whom incomplete time and effort documentation was maintained. Specifically, the timesheets only reflected hours worked on the federal program and did not include total hours worked across all activities. As a result, we were unable to verify the accuracy of the charges allocated to the federal award. Repeat Finding: This is not a repeat finding. Recommendation: We recommend that the Organization continue to enforce the policies implemented in April 2024 requiring all employees who work less than full-time on federal programs to maintain detailed timesheets or equivalent documentation. These records should be reviewed and approved in accordance with the organization's internal control procedures and retained to support all payroll charges to federal awards. Views of Responsible Officials and Planned Corrective Action (unaudited): See 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:
Reference Number: 2024-002 Prior Year Finding: No Federal Agency: U.S. Department of Health and Human Services Federal Program: Child Support Services Assistance Listing Number: 93.563 Pass-Through Entity: New York State Office of Temporary and Disability Assistance Identifying Number and Period: 18000 (2024) Compliance Requirement: Allowable Costs/Cost Principles – Time and Effort Reporting Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: 2 CFR Section 200.430 (8)(i) Standards for Documentation of Personnel Expenses states that: 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 that provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the recipient or subrecipient; (iii) Reasonably reflect the total activity for which the employee is compensated by the recipient or subrecipient, not exceeding 100 percent of compensated activities (for IHEs, this is the IBS); (iv) Encompass federally-assisted and all other activities compensated by the recipient or subrecipient on an integrated basis but may include the use of subsidiary records as defined in the recipient's or subrecipient's written policy; (v) Comply with the established accounting policies and procedures of the recipient or subrecipient (See paragraph (i)(1)(ii) of this section for treatment of incidental work for IHEs.); 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. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Employee time and effort charged to the program did not agree with supporting documentation. Context: For two of thirty-three employee timesheets selected for testing, the amount claimed for employee time and effort did not agree with supporting documentation. Employee payroll data was entered incorrectly when the claim was compiled, resulting in an underclaim of the amount charged to the program. Cause: The County’s internal controls were not sufficient to ensure that employee time and effort charged to the program was accurate and tied to supporting documentation. Effect: The County underclaimed employee time and effort expended on the program. Questioned costs: None. The error resulted in an underclaim. Recommendation: The County should enhance its procedures and internal controls to ensure that employee time and effort charged to the program is accurate and agrees with supporting documentation. Views of Responsible Officials: There is no disagreement with the audit finding.
Allowable Costs - Payroll Federal Agency: U.S. Department of Housing and Urban Development Federal Program Name / Assistance Listing Number / Pass-Through Agency(ies) / Pass-Through Number(s): • Block Grants for Prevention and Treatment of Substance Abuse, 93.959 o Passed through the State of Connecticut, Department of Mental Health and Addiction Services, 24MHA1009 o Passed through the Commonwealth of Pennsylvania, Department of Drug and Alcohol Programs, 4100089071 o Passed through the State of Louisiana, Department of Health, 2000758195 o Passed through the State of Oklahoma, Department of Mental Health and Substance Abuse Services, B08TI083962 & B08TI084602 • COVID-19 - Substance Abuse and Mental Health Services Projects of Regional and National Significance, 93.243 o Passed through the State of California, Department of Health Care Services, 21-10299 Type of Finding: • Significant Deficiency in Internal Control over Compliance • Other Matters Criteria or specific requirement: 2 CFR Part 200.430 (g) Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award, Compensation – Personal Services requires compliance with standards for documentation of personnel expenses which include the following: “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 that provides reasonable assurance that the charges are accurate, allowable, and properly allocated;” Shatterproof should have internal controls designed and effectively operating to ensure compliance with those provisions. Condition: Monthly certifications of time allocations for employees terminated during 2024 were not performed. One instance was noted where the pay rate utilized did not agree to the HRIS system but in all other instances these rates agreed. Evidence supporting the approval of the pay rates in the HRIS system could not be provided. Questioned costs: Total questioned costs are $37,125 and are shown by program below: • 93.959 $7,168 State of Connecticut, Department of Mental Health and Addiction Services $11,001 Commonwealth of Pennsylvania, Department of Drug and Alcohol Programs $3,532 State of Louisiana, Department of Health $903 State of Oklahoma, Department of Mental Health and Substance Abuse Services • 93.243 $14,521 State of California, Department of Health Care Services Context: During our testing we identified 6 terminated employees whose time allocations were not documented through monthly certifications. We were able to substantiate through position descriptions and acceptance letters that two of these employees were fully chargeable to the grant and were not included in the questioned costs. Additionally we identified one employee in our testing whose pay rate utilized did not agree to the HRIS system, however, the difference was trivial and not included in the accumulation of questioned costs. Cause: Internal controls to certify time allocations by employees and their supervisors were put into place during 2024. Monthly certifications were prepared retroactive to January 2024, however certifications could not be completed for employees who were no longer employed by Shatterproof. Additionally, pay rates from the HRIS system were noted to be used in all but one instance, however, documentation of their approval was not retained. Effect: The lack of internal controls over these compliance requirements provides an opportunity for noncompliance and questioned costs. Repeat Finding: The finding is a modified repeat of findings in the immediately prior year. Prior year finding numbers were 2023-004 and 2023-005. Recommendation: We recommend Shatterproof ensure monthly certifications of time allocations by employees and their supervisors are performed and documented on a consistent basis. In addition, we recommend Shatterproof retain approval of the payrates entered into the HRIS and used to pay employees and ensure controls exist to ensure the proper rates are used. Views of responsible officials: There is no disagreement with the audit finding.
Allowable Costs - Payroll Federal Agency: U.S. Department of Housing and Urban Development Federal Program Name / Assistance Listing Number / Pass-Through Agency(ies) / Pass-Through Number(s): • Block Grants for Prevention and Treatment of Substance Abuse, 93.959 o Passed through the State of Connecticut, Department of Mental Health and Addiction Services, 24MHA1009 o Passed through the Commonwealth of Pennsylvania, Department of Drug and Alcohol Programs, 4100089071 o Passed through the State of Louisiana, Department of Health, 2000758195 o Passed through the State of Oklahoma, Department of Mental Health and Substance Abuse Services, B08TI083962 & B08TI084602 • COVID-19 - Substance Abuse and Mental Health Services Projects of Regional and National Significance, 93.243 o Passed through the State of California, Department of Health Care Services, 21-10299 Type of Finding: • Significant Deficiency in Internal Control over Compliance • Other Matters Criteria or specific requirement: 2 CFR Part 200.430 (g) Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award, Compensation – Personal Services requires compliance with standards for documentation of personnel expenses which include the following: “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 that provides reasonable assurance that the charges are accurate, allowable, and properly allocated;” Shatterproof should have internal controls designed and effectively operating to ensure compliance with those provisions. Condition: Monthly certifications of time allocations for employees terminated during 2024 were not performed. One instance was noted where the pay rate utilized did not agree to the HRIS system but in all other instances these rates agreed. Evidence supporting the approval of the pay rates in the HRIS system could not be provided. Questioned costs: Total questioned costs are $37,125 and are shown by program below: • 93.959 $7,168 State of Connecticut, Department of Mental Health and Addiction Services $11,001 Commonwealth of Pennsylvania, Department of Drug and Alcohol Programs $3,532 State of Louisiana, Department of Health $903 State of Oklahoma, Department of Mental Health and Substance Abuse Services • 93.243 $14,521 State of California, Department of Health Care Services Context: During our testing we identified 6 terminated employees whose time allocations were not documented through monthly certifications. We were able to substantiate through position descriptions and acceptance letters that two of these employees were fully chargeable to the grant and were not included in the questioned costs. Additionally we identified one employee in our testing whose pay rate utilized did not agree to the HRIS system, however, the difference was trivial and not included in the accumulation of questioned costs. Cause: Internal controls to certify time allocations by employees and their supervisors were put into place during 2024. Monthly certifications were prepared retroactive to January 2024, however certifications could not be completed for employees who were no longer employed by Shatterproof. Additionally, pay rates from the HRIS system were noted to be used in all but one instance, however, documentation of their approval was not retained. Effect: The lack of internal controls over these compliance requirements provides an opportunity for noncompliance and questioned costs. Repeat Finding: The finding is a modified repeat of findings in the immediately prior year. Prior year finding numbers were 2023-004 and 2023-005. Recommendation: We recommend Shatterproof ensure monthly certifications of time allocations by employees and their supervisors are performed and documented on a consistent basis. In addition, we recommend Shatterproof retain approval of the payrates entered into the HRIS and used to pay employees and ensure controls exist to ensure the proper rates are used. Views of responsible officials: There is no disagreement with the audit finding.
Allowable Costs - Payroll Federal Agency: U.S. Department of Housing and Urban Development Federal Program Name / Assistance Listing Number / Pass-Through Agency(ies) / Pass-Through Number(s): • Block Grants for Prevention and Treatment of Substance Abuse, 93.959 o Passed through the State of Connecticut, Department of Mental Health and Addiction Services, 24MHA1009 o Passed through the Commonwealth of Pennsylvania, Department of Drug and Alcohol Programs, 4100089071 o Passed through the State of Louisiana, Department of Health, 2000758195 o Passed through the State of Oklahoma, Department of Mental Health and Substance Abuse Services, B08TI083962 & B08TI084602 • COVID-19 - Substance Abuse and Mental Health Services Projects of Regional and National Significance, 93.243 o Passed through the State of California, Department of Health Care Services, 21-10299 Type of Finding: • Significant Deficiency in Internal Control over Compliance • Other Matters Criteria or specific requirement: 2 CFR Part 200.430 (g) Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award, Compensation – Personal Services requires compliance with standards for documentation of personnel expenses which include the following: “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 that provides reasonable assurance that the charges are accurate, allowable, and properly allocated;” Shatterproof should have internal controls designed and effectively operating to ensure compliance with those provisions. Condition: Monthly certifications of time allocations for employees terminated during 2024 were not performed. One instance was noted where the pay rate utilized did not agree to the HRIS system but in all other instances these rates agreed. Evidence supporting the approval of the pay rates in the HRIS system could not be provided. Questioned costs: Total questioned costs are $37,125 and are shown by program below: • 93.959 $7,168 State of Connecticut, Department of Mental Health and Addiction Services $11,001 Commonwealth of Pennsylvania, Department of Drug and Alcohol Programs $3,532 State of Louisiana, Department of Health $903 State of Oklahoma, Department of Mental Health and Substance Abuse Services • 93.243 $14,521 State of California, Department of Health Care Services Context: During our testing we identified 6 terminated employees whose time allocations were not documented through monthly certifications. We were able to substantiate through position descriptions and acceptance letters that two of these employees were fully chargeable to the grant and were not included in the questioned costs. Additionally we identified one employee in our testing whose pay rate utilized did not agree to the HRIS system, however, the difference was trivial and not included in the accumulation of questioned costs. Cause: Internal controls to certify time allocations by employees and their supervisors were put into place during 2024. Monthly certifications were prepared retroactive to January 2024, however certifications could not be completed for employees who were no longer employed by Shatterproof. Additionally, pay rates from the HRIS system were noted to be used in all but one instance, however, documentation of their approval was not retained. Effect: The lack of internal controls over these compliance requirements provides an opportunity for noncompliance and questioned costs. Repeat Finding: The finding is a modified repeat of findings in the immediately prior year. Prior year finding numbers were 2023-004 and 2023-005. Recommendation: We recommend Shatterproof ensure monthly certifications of time allocations by employees and their supervisors are performed and documented on a consistent basis. In addition, we recommend Shatterproof retain approval of the payrates entered into the HRIS and used to pay employees and ensure controls exist to ensure the proper rates are used. Views of responsible officials: There is no disagreement with the audit finding.
Allowable Costs - Payroll Federal Agency: U.S. Department of Housing and Urban Development Federal Program Name / Assistance Listing Number / Pass-Through Agency(ies) / Pass-Through Number(s): • Block Grants for Prevention and Treatment of Substance Abuse, 93.959 o Passed through the State of Connecticut, Department of Mental Health and Addiction Services, 24MHA1009 o Passed through the Commonwealth of Pennsylvania, Department of Drug and Alcohol Programs, 4100089071 o Passed through the State of Louisiana, Department of Health, 2000758195 o Passed through the State of Oklahoma, Department of Mental Health and Substance Abuse Services, B08TI083962 & B08TI084602 • COVID-19 - Substance Abuse and Mental Health Services Projects of Regional and National Significance, 93.243 o Passed through the State of California, Department of Health Care Services, 21-10299 Type of Finding: • Significant Deficiency in Internal Control over Compliance • Other Matters Criteria or specific requirement: 2 CFR Part 200.430 (g) Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award, Compensation – Personal Services requires compliance with standards for documentation of personnel expenses which include the following: “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 that provides reasonable assurance that the charges are accurate, allowable, and properly allocated;” Shatterproof should have internal controls designed and effectively operating to ensure compliance with those provisions. Condition: Monthly certifications of time allocations for employees terminated during 2024 were not performed. One instance was noted where the pay rate utilized did not agree to the HRIS system but in all other instances these rates agreed. Evidence supporting the approval of the pay rates in the HRIS system could not be provided. Questioned costs: Total questioned costs are $37,125 and are shown by program below: • 93.959 $7,168 State of Connecticut, Department of Mental Health and Addiction Services $11,001 Commonwealth of Pennsylvania, Department of Drug and Alcohol Programs $3,532 State of Louisiana, Department of Health $903 State of Oklahoma, Department of Mental Health and Substance Abuse Services • 93.243 $14,521 State of California, Department of Health Care Services Context: During our testing we identified 6 terminated employees whose time allocations were not documented through monthly certifications. We were able to substantiate through position descriptions and acceptance letters that two of these employees were fully chargeable to the grant and were not included in the questioned costs. Additionally we identified one employee in our testing whose pay rate utilized did not agree to the HRIS system, however, the difference was trivial and not included in the accumulation of questioned costs. Cause: Internal controls to certify time allocations by employees and their supervisors were put into place during 2024. Monthly certifications were prepared retroactive to January 2024, however certifications could not be completed for employees who were no longer employed by Shatterproof. Additionally, pay rates from the HRIS system were noted to be used in all but one instance, however, documentation of their approval was not retained. Effect: The lack of internal controls over these compliance requirements provides an opportunity for noncompliance and questioned costs. Repeat Finding: The finding is a modified repeat of findings in the immediately prior year. Prior year finding numbers were 2023-004 and 2023-005. Recommendation: We recommend Shatterproof ensure monthly certifications of time allocations by employees and their supervisors are performed and documented on a consistent basis. In addition, we recommend Shatterproof retain approval of the payrates entered into the HRIS and used to pay employees and ensure controls exist to ensure the proper rates are used. Views of responsible officials: There is no disagreement with the audit finding.
Allowable Costs - Payroll Federal Agency: U.S. Department of Housing and Urban Development Federal Program Name / Assistance Listing Number / Pass-Through Agency(ies) / Pass-Through Number(s): • Block Grants for Prevention and Treatment of Substance Abuse, 93.959 o Passed through the State of Connecticut, Department of Mental Health and Addiction Services, 24MHA1009 o Passed through the Commonwealth of Pennsylvania, Department of Drug and Alcohol Programs, 4100089071 o Passed through the State of Louisiana, Department of Health, 2000758195 o Passed through the State of Oklahoma, Department of Mental Health and Substance Abuse Services, B08TI083962 & B08TI084602 • COVID-19 - Substance Abuse and Mental Health Services Projects of Regional and National Significance, 93.243 o Passed through the State of California, Department of Health Care Services, 21-10299 Type of Finding: • Significant Deficiency in Internal Control over Compliance • Other Matters Criteria or specific requirement: 2 CFR Part 200.430 (g) Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award, Compensation – Personal Services requires compliance with standards for documentation of personnel expenses which include the following: “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 that provides reasonable assurance that the charges are accurate, allowable, and properly allocated;” Shatterproof should have internal controls designed and effectively operating to ensure compliance with those provisions. Condition: Monthly certifications of time allocations for employees terminated during 2024 were not performed. One instance was noted where the pay rate utilized did not agree to the HRIS system but in all other instances these rates agreed. Evidence supporting the approval of the pay rates in the HRIS system could not be provided. Questioned costs: Total questioned costs are $37,125 and are shown by program below: • 93.959 $7,168 State of Connecticut, Department of Mental Health and Addiction Services $11,001 Commonwealth of Pennsylvania, Department of Drug and Alcohol Programs $3,532 State of Louisiana, Department of Health $903 State of Oklahoma, Department of Mental Health and Substance Abuse Services • 93.243 $14,521 State of California, Department of Health Care Services Context: During our testing we identified 6 terminated employees whose time allocations were not documented through monthly certifications. We were able to substantiate through position descriptions and acceptance letters that two of these employees were fully chargeable to the grant and were not included in the questioned costs. Additionally we identified one employee in our testing whose pay rate utilized did not agree to the HRIS system, however, the difference was trivial and not included in the accumulation of questioned costs. Cause: Internal controls to certify time allocations by employees and their supervisors were put into place during 2024. Monthly certifications were prepared retroactive to January 2024, however certifications could not be completed for employees who were no longer employed by Shatterproof. Additionally, pay rates from the HRIS system were noted to be used in all but one instance, however, documentation of their approval was not retained. Effect: The lack of internal controls over these compliance requirements provides an opportunity for noncompliance and questioned costs. Repeat Finding: The finding is a modified repeat of findings in the immediately prior year. Prior year finding numbers were 2023-004 and 2023-005. Recommendation: We recommend Shatterproof ensure monthly certifications of time allocations by employees and their supervisors are performed and documented on a consistent basis. In addition, we recommend Shatterproof retain approval of the payrates entered into the HRIS and used to pay employees and ensure controls exist to ensure the proper rates are used. Views of responsible officials: There is no disagreement with the audit finding.
COCONDITION: Employee time and effort reports were not consistently completed, certified, and maintained in accordance with the grant requirements. The auditor's review of a sample of employee timesheets found discrepancies in how time was allocated and reported for federal projects versus the PALM’s internal records. CRITERIA: The PALM is required by federal grant guidelines, specifically 2 CFR 200.430, to maintain internal controls over all aspects of their federal awards. This includes accurate and consistent documentation of personnel activity reports, timesheets, and payroll distribution records to support the direct labor costs charged to federal awards. CAUSE: The PALM lacked a formal, documented policy and procedure for tracking, certifying, and approving employee time spent on grant-related activities. Insufficient training was provided to employees and supervisors regarding the specific documentation requirements for federal grants. This resulted in personnel recording their time using inconsistent methods, including estimations at the end of a pay period, which increased the risk of inaccurate billing. EFFECT: Inaccurate time allocation led to the questioning of $65,664 in costs charged to the federal award. Since the timekeeping records did not provide reliable assurance that employee compensation was accurately charged, a portion of the labor costs was unsupported. This finding exposes the PALM to the risk of having to repay the federal agency for unallowable costs and could impact future grant funding. RECOMMENDATION: We recommend that the PALM utilize a time management software which integrates with their payroll processing, to easily identify direct labor costs related to the federal program. VIEWS OF RESPONSIBLE OFFICIALS AND PLANNED CORRECTIVE ACTION: The PALM agrees with the finding, and started utilizing a new time management software in 2025 to prevent overbilling of direct labor costs. QUESTIONED COSTS: A total of $54,211 in salaries and $11,453 in benefits were calculated as questioned costs, based on annualized differences from testing.
Federal Agency U.S Department of Health and Human Services Assistance Listing Numbers 93.884 Primary Care Training and Enhancement and 93.732 Integrated Substance Use Disorder Training Program Award Numbers D58HP39725, T34HP42128, T62HP45934, T62HP49309 Criteria In accordance with the Uniform Guidance’s compensation requirements (2 CFR 200.430 Compensation – personal services), payroll expenses must be based on records that accurately reflect the work performed and supported by a system of internal controls that provides reasonable assurances that charges are accurate; allowable and reasonable; and properly allocated. The Uniform Guidance allows for use of budget estimates on an interim basis. When using budget estimates on an interim basis, grantees must reconcile estimates against actual time or effort on a regular basis to ensure that estimates conform to actual staff activity. Grantees must make adjustments in the payroll distribution to align with actual time. [X] Compliance Finding [X ] Significant Deficiency [ ] Material Weakness Condition During fiscal year 2024, the Organization charged payroll costs to Federal programs based on predetermined budgeted percentages rather than actual time and effort of employees working across multiple programs. Cause The Organization did not have a process or controls in place to track and document the time and effort employees spent toward each federal award. Effect Noncompliance with documentation of personnel expense standards; improper allocation of salary and fringe benefits. Questioned Costs Indeterminable. Recommendation We recommend the Organization enhance its timekeeping processes to ensure payroll charges accurately reflect actual work performed on Federal awards. If budget estimates continue to be used, they should be reconciled regularly against actual effort. Alternatively, the Organization could implement an after-the-fact certification system to document that salaries charged to Federal programs are reasonable and consistent with actual work performed. Views of responsible officials and planned corrective action Cahaba Medical Care will implement a formal process to document time and effort for personnel, subject to the level of effort requirements. This process will require time and effort for personnel to attest to the amount of time spent on a grant monthly. These personnel have been informed of the proposed process and trained to promote consistent and accurate reporting relative to federal standards.
Federal Agency U.S Department of Health and Human Services Assistance Listing Numbers 93.884 Primary Care Training and Enhancement and 93.732 Integrated Substance Use Disorder Training Program Award Numbers D58HP39725, T34HP42128, T62HP45934, T62HP49309 Criteria In accordance with the Uniform Guidance’s compensation requirements (2 CFR 200.430 Compensation – personal services), payroll expenses must be based on records that accurately reflect the work performed and supported by a system of internal controls that provides reasonable assurances that charges are accurate; allowable and reasonable; and properly allocated. The Uniform Guidance allows for use of budget estimates on an interim basis. When using budget estimates on an interim basis, grantees must reconcile estimates against actual time or effort on a regular basis to ensure that estimates conform to actual staff activity. Grantees must make adjustments in the payroll distribution to align with actual time. [X] Compliance Finding [X ] Significant Deficiency [ ] Material Weakness Condition During fiscal year 2024, the Organization charged payroll costs to Federal programs based on predetermined budgeted percentages rather than actual time and effort of employees working across multiple programs. Cause The Organization did not have a process or controls in place to track and document the time and effort employees spent toward each federal award. Effect Noncompliance with documentation of personnel expense standards; improper allocation of salary and fringe benefits. Questioned Costs Indeterminable. Recommendation We recommend the Organization enhance its timekeeping processes to ensure payroll charges accurately reflect actual work performed on Federal awards. If budget estimates continue to be used, they should be reconciled regularly against actual effort. Alternatively, the Organization could implement an after-the-fact certification system to document that salaries charged to Federal programs are reasonable and consistent with actual work performed. Views of responsible officials and planned corrective action Cahaba Medical Care will implement a formal process to document time and effort for personnel, subject to the level of effort requirements. This process will require time and effort for personnel to attest to the amount of time spent on a grant monthly. These personnel have been informed of the proposed process and trained to promote consistent and accurate reporting relative to federal standards.
Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Special Programs for the Aging, Title IV, and Title II, Discretionary Projects Grants for New and Expanded Services under the Health Center Program and Senior Companion Program Assistance Listing Number: 93.048 Pass-Through: N/A Federal Award Identification Number and Year: All Award #s under ALN 93.048 Award Period: Project period multiple; Budget period: All Projects #s under ALN 93.048 Questioned Costs: None We note over/under-billing by pay period. Type of Finding (F) Significant Deficiency in Internal Control Over Compliance of Federal Awards (G) Instances of Noncompliance related to Federal Awards Statement of Condition During our audit, we noted instances in which timesheets were not approved, and it appears that allocations are based mainly on budget rather than actual direct and indirect time spent on the grant. In July 2024, the timesheets were improved, however the general ledger amount is consistent indicating that the amount in general ledger is based on budget rather than the percentage of hours worked under the grant. Management implemented a true-up process to be able to verify the payroll charged over one year budget period. Note: the timesheet issue is related only to staff paid from multiple sources (5 out of 11 employees). Management progress: The Institute implemented a new timesheet and an annual reconciliation to verify if the allocations are truing up over one year Budget period and to adjust the Budget in the allowed threshold, if needed. Context 60 transactions were tested. Out of 60, 22 were payroll and payroll taxes related. 14 payroll transactions out of 22 tested, including wages and payroll taxes, seem to be allocated based on budget (per each pay period rather than direct time spent on grant. In some instances (paydays), some grants were underbilled and in some instances were overbilled and the net effect of questioned costs summed up close to $0 (if the overall reconciliation was taken in consideration). The Institute implemented one year reconciliation to make sure that the variations net to zero over the budget period. Criteria Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed (e.g., 2 CFR 200.430; for HHS awards, 45 CFR 75.430(i)). Records must be supported by internal controls, reflect total compensated activities, and support allocation among cost objectives. According to §75.430 (i) select standards for documentation of personal expenses are as follows: (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 both 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 non-Federal entity and (vii) 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 which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Effect The organization does not appear to have sufficient internal controls in place and does not appear to be in compliance with grant requirements as set forth in 45 CFR Part 75. A potential effect of noncompliance of the federal award could result in disallowance of costs, suspension or termination of the award, or reduction of future allocations. Cause Internal controls over compliance do not appear to have been adequately implemented due to a lack of confirmation that the timesheet expenses match the general ledger. Recommendation We recommend the organization prevent recurrence of noncompliance through conducting regular reviews and reconciliations, providing timesheet training and guidance to staff and monitoring compliance. We also recommend a re-design of the timesheets, so grant allocations and calculations for direct and indirect cost are more easily performed and traceable to the grant general ledger. View of Responsible Official: The timesheet implemented in July 2024 properly reflects the actual vs budgeted hours for employees with multiple funding sources. We will continue to analyze discrepancies to determine if budget revisions are necessary. Finding resolved timeline: October 2025 Designated of employee position responsible for meeting this deadline: Bruce Young-Candelaria, President; Ricardo Colon Padilla, financial officer.
Finding 2024-001 Material Weakness: Allowable Costs/Costs Principles - Compliance and Control Finding ALN 84.287 - Twenty-First Century Community Learning Centers Federal Agency: U.S. Department of Education Pass-Through Entity: Missouri Department of Education Fiscal Year: For the year ended December 31, 2024 Criteria or Specific Requirement: 2 CFR section 200.430(i)(1) requires charges to federal awards for salaries and wages be based on records that accurately reflect the work performed. Condition: We noted through procedures performed that allocated salaries and wages as well as related employee benefits and payroll taxes were based on an estimated percentage of time to be devoted to the grant-funded programs as opposed to actual hours worked, resulting in a potential over-allocation or under-allocation of expenditures. Cause: Internal controls over compliance put in place by management were not designed effectively to ensure a review of allocated versus actual hours work by the federal grant was performed and that proof of such reviews was documented and retained. Effect: The possibility exists that noncompliance with federal requirements related to allowable costs and allowable activities could go undetected as there is no review or true up process for actual hours worked related to the program. Questioned Costs: In a sample of 40 expenditures, total known question costs found totaled $12,504. Likely questioned costs exceed $25,000. Context: Of the sample of 40 individual costs charged to the grant, 8 were allocated salary costs and related employee benefits and payroll taxes of full-time, salaried employees. For these 8 payroll related items, allocated costs were based on the estimated percentage of time expected to be devoted by each employee to the grant-funded program. Unleashing Potential did not maintain documentation to support the actual time and effort of each employee charged to the grant. Identification as a Repeat Finding: 2023-001 Recommendation: For employees working on grant-funded programs, management should develop a time-keeping process to track and verify that the amount of time charged to the grant is accurate and based on the employee’s time spent working on the grant. Documented review and approval of this time allocation by the employee’s supervisor should be maintained. Views of Responsible Officials: Management will implement procedures to assure that all costs charged to the 21st Century program are reviewed by a competent individual, and those reviews will be documented.