Finding 1155129 (2024-004)

Material Weakness Repeat Finding
Requirement
ABH
Questioned Costs
-
Year
2024
Accepted
2025-09-24
Audit: 367408
Auditor: Bdo USA PC

AI Summary

  • Core Issue: The Village incorrectly charged costs incurred before the funding period to federal programs, violating grant requirements.
  • Impacted Requirements: Costs must be incurred during the specified funding period, and any pre-award costs need prior approval from the federal agency.
  • Recommended Follow-Up: Ensure that only costs from the correct funding period are charged, with proper documentation and review processes in place.

Finding Text

Federal Agencies: Department of Housing and Urban Development and Department of Health and Human Services Federal Assistance Listing Numbers: 14.267, 93.224 & 93.527 Program: Continuum of Care Program, Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: CA0802L9D012214, CA0802L9D012315, CA1348L9D012208, CA1348L9D012309, CA1510L9D012207, CA1510L9D012308, CA1883L9D012203, CA1883L9D012304, HHI-24-09, SIHI-25-07, HHI-24-04, SIHI-25-18, H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: Where a funding period is specified, a recipient may charge to the grant only allowable costs resulting from obligations incurred during the funding period and any pre-award costs authorized by the Federal awarding agency. Unless the Federal awarding agency authorizes an extension, a recipient shall liquidate all obligations incurred under the award no later than 90 calendar days after the funding period or the date of completion as specified in the terms and conditions of the award or in agency implementing instructions. Condition: We noted that the Village allocated expenditures that were incurred prior to the start of the funding to Continuum of Care Program and Health Center Program Cluster during 2024. During our testing, we noted instances of costs that were incurred prior to the start of the applicable funding periods and were not approved in accordance with §200.308. • For Continuum of Care Program: o 1 out of 60 samples selected for testing had costs claimed in the incorrect grant period. • For Health Center Program Cluster: o 5 of the 74 samples selected for testing had costs claimed in the incorrect grant period. Cause: Due to the manual nature of the allocation process, the Village misapplied the prorated days at the end of certain pay periods. Specifically, the portion of payroll costs attributable to the final days of a pay period was assigned to the subsequent grant period, rather than to the correct, preceding period of performance. This resulted in certain payroll costs being reported and claimed in the wrong grant period, leading to inaccuracies in the allocation of expenditures across periods of performance. Additionally, the client charged rental assistance expense to a subsequent grant period. As a result, these costs were claimed in the incorrect grant period, leading to inaccuracies in the allocation of expenditures across periods of performance. Effect or Potential Effect: Without adequate controls in place to ensure costs are reported in the proper period of performance, the Village could incorrectly charge expenditures to the federal programs. Questioned Costs: Continuum of Care Program: None above the $25,000 reporting threshold. Health Center Program Cluster: None above the $25,000 reporting threshold. Context: This is a condition identified per review of the Villages compliance with specified requirements not using a statistically valid sample. Total costs under the Continuum of Care Program were $5,000,960. Total costs under the Health Center Program Cluster were $1,682,732. Repeat Finding: 2023-008 Recommendation: We recommend that only costs incurred during the appropriate funding period be charged, and that this be appropriately documented and reviewed. Views of Responsible Officials:

Categories

Allowable Costs / Cost Principles Period of Performance Subrecipient Monitoring Reporting

Other Findings in this Audit

  • 1155108 2024-003
    Material Weakness Repeat
  • 1155109 2024-003
    Material Weakness Repeat
  • 1155110 2024-003
    Material Weakness Repeat
  • 1155111 2024-003
    Material Weakness Repeat
  • 1155112 2024-003
    Material Weakness Repeat
  • 1155113 2024-003
    Material Weakness Repeat
  • 1155114 2024-003
    Material Weakness Repeat
  • 1155115 2024-003
    Material Weakness Repeat
  • 1155116 2024-003
    Material Weakness Repeat
  • 1155117 2024-003
    Material Weakness Repeat
  • 1155118 2024-003
    Material Weakness Repeat
  • 1155119 2024-003
    Material Weakness Repeat
  • 1155120 2024-003
    Material Weakness Repeat
  • 1155121 2024-003
    Material Weakness Repeat
  • 1155122 2024-003
    Material Weakness Repeat
  • 1155123 2024-003
    Material Weakness Repeat
  • 1155124 2024-003
    Material Weakness Repeat
  • 1155125 2024-003
    Material Weakness Repeat
  • 1155126 2024-003
    Material Weakness Repeat
  • 1155127 2024-003
    Material Weakness Repeat
  • 1155128 2024-004
    Material Weakness Repeat
  • 1155130 2024-004
    Material Weakness Repeat
  • 1155131 2024-004
    Material Weakness Repeat
  • 1155132 2024-004
    Material Weakness Repeat
  • 1155133 2024-004
    Material Weakness Repeat
  • 1155134 2024-004
    Material Weakness Repeat
  • 1155135 2024-004
    Material Weakness Repeat
  • 1155136 2024-004
    Material Weakness Repeat
  • 1155137 2024-004
    Material Weakness Repeat
  • 1155138 2024-004
    Material Weakness Repeat
  • 1155139 2024-004
    Material Weakness Repeat
  • 1155140 2024-004
    Material Weakness Repeat
  • 1155141 2024-004
    Material Weakness Repeat
  • 1155142 2024-004
    Material Weakness Repeat
  • 1155143 2024-004
    Material Weakness Repeat
  • 1155144 2024-004
    Material Weakness Repeat
  • 1155145 2024-004
    Material Weakness Repeat
  • 1155146 2024-004
    Material Weakness Repeat
  • 1155147 2024-005
    Material Weakness Repeat
  • 1155148 2024-005
    Material Weakness Repeat
  • 1155149 2024-005
    Material Weakness Repeat
  • 1155150 2024-005
    Material Weakness Repeat
  • 1155151 2024-005
    Material Weakness Repeat
  • 1155152 2024-005
    Material Weakness Repeat
  • 1155153 2024-005
    Material Weakness Repeat
  • 1155154 2024-006
    Material Weakness Repeat
  • 1155155 2024-006
    Material Weakness Repeat
  • 1155156 2024-006
    Material Weakness Repeat
  • 1155157 2024-006
    Material Weakness Repeat
  • 1155158 2024-006
    Material Weakness Repeat
  • 1155159 2024-006
    Material Weakness Repeat
  • 1155160 2024-006
    Material Weakness Repeat
  • 1155161 2024-006
    Material Weakness Repeat
  • 1155162 2024-006
    Material Weakness Repeat
  • 1155163 2024-006
    Material Weakness Repeat
  • 1155164 2024-006
    Material Weakness Repeat
  • 1155165 2024-006
    Material Weakness Repeat
  • 1155166 2024-007
    Material Weakness Repeat
  • 1155167 2024-008
    Material Weakness Repeat
  • 1155168 2024-008
    Material Weakness Repeat
  • 1155169 2024-008
    Material Weakness Repeat
  • 1155170 2024-008
    Material Weakness Repeat
  • 1155171 2024-008
    Material Weakness Repeat
  • 1155172 2024-008
    Material Weakness Repeat
  • 1155173 2024-008
    Material Weakness Repeat
  • 1155174 2024-008
    Material Weakness Repeat
  • 1155175 2024-008
    Material Weakness Repeat
  • 1155176 2024-008
    Material Weakness Repeat
  • 1155177 2024-008
    Material Weakness Repeat
  • 1155178 2024-008
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
14.241 Housing Opportunities for Persons with Aids $1.74M
14.231 Emergency Solutions Grant Program $614,176
97.024 Emergency Food and Shelter National Board Program $178,640
97.008 Non-Profit Security Program $148,000
14.218 Community Development Block Grants/entitlement Grants $93,711
14.267 Continuum of Care Program $88,198
10.558 Child and Adult Care Food Program $85,773
93.224 Health Center Program (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $71,391
64.033 Va Supportive Services for Veteran Families Program $63,032
93.526 Grants for New and Expanded Services Under the Health Center Program $56,722
93.527 Grants for New and Expanded Services Under the Health Center Program $12,600
45.129 Promotion of the Humanities Federal/state Partnership $10,000