Finding 528649 (2024-001)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-03-18
Audit: 346615
Organization: Isabella County (MI)

AI Summary

  • Core Issue: There was a discrepancy between reported expenditures in quarterly P&E reports and the general ledger, indicating a lack of detailed tracking.
  • Impacted Requirements: The County did not fully comply with CSLFRF grant requirements and Uniform Guidance due to inaccurate reporting.
  • Recommended Follow-Up: The County should reconcile quarterly P&E reports with the general ledger to ensure accurate classification and reporting of expenditures.

Finding Text

Variance in Quarterly Reporting. Finding Type. Immaterial Noncompliance (Reporting)/Significant Deficiency in Internal Control over Compliance. Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027. 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 quarters one and four of the 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. 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. View of Responsible Officials. Management will conduct cross-checks between the general ledger entries and amounts reported on the quarterly ARPA P&E reports to ensure accuracy in amounts reported for the period. Management will also review classification of project categories on quarterly P&E reports to ensure accuracy.

Corrective Action Plan

Pursuant to federal regulations, Uniform Administrative Requirements Section 200.511, the following is the finding as noted in Isabella County’s Single Audit report for the year ended September 30, 2024, and corrective action to be completed. 2024-001 – Variance in Quarterly Reporting. Auditor Description of Condition and Effect: During the audit, we noted a variance between amounts reported in quarters one and four of the 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. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Auditor 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. Corrective Action: Management will conduct cross-checks between the general ledger entries and amounts reported on the quarterly ARPA P&E reports to ensure accuracy in amounts reported for the period. Management will also review classification of project categories on quarterly P&E reports to ensure accuracy. Responsible Person: Chris Witmer, Director of Finance. Anticipated Completion Date: 09/30/2025

Categories

Reporting

Other Findings in this Audit

  • 1105091 2024-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
10.766 Community Facilities Loans and Grants $20.30M
21.027 Coronavirus State and Local Fiscal Recovery Funds $3.05M
93.563 Child Support Services $67,290
93.045 Special Programs for the Aging, Title Iii, Part C, Nutrition Services $35,549
93.044 Special Programs for the Aging, Title Iii, Part B, Grants for Supportive Services and Senior Centers $34,555
97.067 Homeland Security Grant Program $31,092
97.047 Bric: Building Resilient Infrastructure and Communities $27,682
93.053 Nutrition Services Incentive Program $26,861
93.052 National Family Caregiver Support, Title Iii, Part E $12,511
97.042 Emergency Management Performance Grants $12,455
93.778 Medical Assistance Program $9,844
97.012 Boating Safety Financial Assistance $6,001
16.034 Coronavirus Emergency Supplemental Funding Program $4,247