Finding 1148398 (2024-001)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-07-25
Audit: 363050
Organization: Bay County (MI)

AI Summary

  • Core Issue: There is a significant discrepancy of $320,511 between the quarterly P&E reports and the general ledger for CSLFRF funds.
  • Impacted Requirements: The County failed to comply with grant reporting requirements due to inadequate tracking of project expenditures.
  • Recommended Follow-Up: The County should reconcile P&E reports with the general ledger and conduct an independent review for accuracy.

Finding Text

Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.

Categories

Reporting

Other Findings in this Audit

  • 571953 2024-001
    Significant Deficiency
  • 571954 2024-001
    Significant Deficiency
  • 571955 2024-001
    Significant Deficiency
  • 571956 2024-001
    Significant Deficiency
  • 571957 2024-001
    Significant Deficiency
  • 571958 2024-001
    Significant Deficiency
  • 571959 2024-001
    Significant Deficiency
  • 571960 2024-001
    Significant Deficiency
  • 571961 2024-001
    Significant Deficiency
  • 1148395 2024-001
    Significant Deficiency
  • 1148396 2024-001
    Significant Deficiency
  • 1148397 2024-001
    Significant Deficiency
  • 1148399 2024-001
    Significant Deficiency
  • 1148400 2024-001
    Significant Deficiency
  • 1148401 2024-001
    Significant Deficiency
  • 1148402 2024-001
    Significant Deficiency
  • 1148403 2024-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.205 Highway Planning and Construction $38,873
93.217 Family Planning Services $31,995
93.069 Public Health Emergency Preparedness $30,741
93.493 Congressional Directives $30,225
93.563 Child Support Services $29,557
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $27,500
93.044 Special Programs for the Aging, Title Iii, Part B, Grants for Supportive Services and Senior Centers $27,306
16.753 Congressionally Recommended Awards $16,195
16.738 Edward Byrne Memorial Justice Assistance Grant Program $16,189
93.994 Maternal and Child Health Services Block Grant to the States $15,228
66.802 Superfund State, Political Subdivision, and Indian Tribe Site-Specific Cooperative Agreements $14,427
93.778 Medical Assistance Program $13,364
93.658 Foster Care Title IV-E $10,859
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $10,110
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $9,483
21.027 Coronavirus State and Local Fiscal Recovery Funds $8,990
20.600 State and Community Highway Safety $7,843
10.553 School Breakfast Program $7,642
93.045 Special Programs for the Aging, Title Iii, Part C, Nutrition Services $7,176
10.555 National School Lunch Program $5,047
20.616 National Priority Safety Programs $4,747
93.052 National Family Caregiver Support, Title Iii, Part E $2,789
97.042 Emergency Management Performance Grants $2,407
93.268 Immunization Cooperative Agreements $1,200
93.597 Grants to States for Access and Visitation Programs $660
97.067 Homeland Security Grant Program $400
93.053 Nutrition Services Incentive Program $98