Finding 1223529 (2025-003)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2025
Accepted
2026-07-10
Audit: 406895
Auditor: GRANT THORNTON

AI Summary

  • Core Issue: Employee salary charges to federal awards were based on budgeted amounts instead of actual time worked, leading to potential disallowance of costs.
  • Impacted Requirements: Compliance with Uniform Guidance 200.430(i) for accurate documentation of personnel expenses was not met, as there were no supporting timesheets.
  • Recommended Follow-Up: Implement policies for documented timekeeping and ensure salary allocations reflect actual work performed to comply with federal requirements.

Finding Text

Finding 2025-003: Allowable Costs/Cost Principles (Material Weakness and Noncompliance) Federal Agency: U.S. Department of Housing and Urban Development Assistance Listing Number and Title: 14.218 – CDBG Entitlement Grants Cluster Funding Year: 2024 Criteria: Per the Uniform Guidance 200.430(i) – Compensation – personal services, Standards for Documentation of Personnel Expenses, charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. Among other requirements, these records must: • Be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; • Reasonably reflect the total activity for which the employee is compensated by the non-federal entity, not exceeding 100% of compensated activities; • Encompass both federally assisted and all other activities compensated by the non-federal entity on an integrated basis; and • 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. 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 the award recipient’s system of internal controls includes processes to review after-the-fact interim charges made to a federal awards based on budget estimates, and that all necessary adjustments be made such that the final amount charged to the federal award is accurate, allowable, and properly allocated. Condition: For individuals charged to this program who also have time charged to other programs there were no timesheets or other evidence to support the allocation to the program was based on actual time incurred to the program but was instead based on the budgeted amounts for those individuals. Questioned Costs: $5,770 which includes employee salaries of $4,743 and benefits of $1,027. Context: Of the 40 payroll selections tested, five were related to individuals who were allocated to different programs and the allocation was based on the budgeted allocation rather than time records supporting that level of effort related to the federal award charged. The total payroll costs associated with these five individuals was $4,743, which represented 9.12% of the total sample tested of $52,000. Total payroll and fringe benefit costs associated with ALN 14.218 was $1,568,674. Cause: Current policies and procedures do not require documented timekeeping by employees working on the grant program, which is appropriately reviewed, approved and used as a basis for charges to the grant program. Effect: Personnel costs charged to federal awards without appropriate documentation may be subject to disallowance. Repeat Finding: Yes, 2024-002. Recommendation: Policies and procedures should be implemented to ensure that employee timekeeping and the salary and wage allocations to the federal award are appropriately documented and accurately reflect the level of effort of work performed. Views of Responsible Officials: Management agrees with the details of this finding and will implement the procedures outlined in our Corrective Action Plan.

Corrective Action Plan

Finding 2024‐002: Allowable Costs/Cost Principles (Material Weakness and Noncompliance) Condition: For individuals charged to this program who also have time charged to other programs there were no timesheets or other evidence to support the allocation to the program was based on actual time incurred to the program but was instead based on the budgeted amounts for those individuals. Corrective Action Planned: Recommendation: Policies and procedures should be implemented to ensure that employee timekeeping and the salary and wage allocations to the federal award are appropriately documented and accurately reflect the level of effort of work performed. Objective: To establish an environment of internal controls and accountability within the Chicago Area Command Finance and Social Services teams specific to the following: Required Action: Ensure appropriate policies and procedures are created and implemented and that accurate documentation is in place to assume responsibility and accountability to meet or exceed expectations. Social Services - Implement and document a process for all individuals assigned to multiple contracts to keep time logs of hours worked on each, with a monthly review that the hours align with the budgeted amounts. In the event hours diverge, workload will be adjusted or a budget adjustment will be requested. Finance - Implement and document a process to conduct an internal spot check at least quarterly by selecting a sample of time sheets from various contracts to ensure that proper procedures and documentation have been implemented and tracked appropriately. Meet with Social Services at least quarterly to confirm time log status for all programs administered by Chicago City Fund. Anticipated Completion Date: August 31, 2026 Name of Contact Person Responsible for the Plan: Shari Koehler, Divisional Chief Finance and Technology Director

Categories

Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 1223522 2025-003
    Material Weakness Repeat
  • 1223523 2025-003
    Material Weakness Repeat
  • 1223524 2025-003
    Material Weakness Repeat
  • 1223525 2025-003
    Material Weakness Repeat
  • 1223526 2025-003
    Material Weakness Repeat
  • 1223527 2025-003
    Material Weakness Repeat
  • 1223528 2025-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.600 HEAD START $619,821
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $275,569
93.596 CHILD CARE MANDATORY AND MATCHING FUNDS OF THE CHILD CARE AND DEVELOPMENT FUND $256,237
16.320 SERVICES FOR TRAFFICKING VICTIMS $244,720
93.959 BLOCK GRANTS FOR PREVENTION AND TREATMENT OF SUBSTANCE ABUSE $228,643
10.569 EMERGENCY FOOD ASSISTANCE PROGRAM (FOOD COMMODITIES) $145,372
93.052 NATIONAL FAMILY CAREGIVER SUPPORT, TITLE III, PART E $134,989
10.558 CHILD AND ADULT CARE FOOD PROGRAM $85,383
14.267 CONTINUUM OF CARE PROGRAM $65,132
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $45,894
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $24,098
97.024 EMERGENCY FOOD AND SHELTER NATIONAL BOARD PROGRAM $14,942
93.667 SOCIAL SERVICES BLOCK GRANT $812
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $44