Finding 1155148 (2024-005)

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

AI Summary

  • Core Issue: Payroll transactions were incorrectly recorded, with 3 out of 60 transactions from 2023 included in 2024 costs, violating GAAP.
  • Impacted Requirements: Non-Federal entities must maintain internal controls for compliance with federal regulations and ensure costs are recorded in the correct fiscal period.
  • Recommended Follow-Up: Implement policies to ensure federal expenditures are accrued in the correct period to maintain accurate financial reporting.

Finding Text

Federal Agencies: Department of Health and Human Services Federal Assistance Listing Numbers: 93.224 & 93.527 Program: Health Center Program Cluster, COVID-19 Health Center Program Cluster Award/Pass-Through Entity Identifying Numbers: H80CS10606-16-00, H80CS10606-17-04, H80CS10606-17-05, H8GCS48224, H8L50900-01-00, H8NCS53911-01-04 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 2 CFR §200.403(e), costs must be in accordance with Generally Accepted Accounting Procedures (GAAP) to be allowable under Federal awards. Condition: During our testing of 2024 costs, we noted that 3 of the 60 payroll transactions selected for testing within the Health Center Program Cluster were incurred in 2023. This practice is not in accordance with GAAP, which require that costs be recorded in the period in which they are incurred. Cause: The Village did not have adequate policies and procedures in place to ensure that federal expenditures are properly accrued and recorded in the fiscal year in which the costs are actually incurred. Effect or Potential Effect: Failure to accrue costs in accordance with GAAP may result in expenditures being materially misstated on the SEFA that could lead to inaccurate reporting to the federal agencies. Questioned Costs: Health Center Program Cluster Known Questioned Costs: $473 Health Center Program Cluster Likely Questioned Costs: $26,444 Context: This is a condition identified per review of the Village’s compliance with specified requirements not using a statistically valid sample. Payroll costs including fringe benefits for the Health Center Program Cluster in 2024 were $1,714,998. Repeat Finding: 2023-001 Recommendation: We recommend Village implement policies and procedures to accrue for federal expenditures in the period the costs were incurred to ensure costs are being recorded in accordance with GAAP and the SEFA is representative of all federal expenditures incurred in the reporting year. Views of Responsible Officials:

Categories

Questioned Costs 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
  • 1155129 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
  • 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