Finding 1163192 (2024-001)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2024
Accepted
2025-12-01
Audit: 372690
Organization: City of Clarksville Gas & Water (TN)
Auditor: CROSSLIN PLLC

AI Summary

  • Core Issue: $867,515 in federal expenditures were not reported in the SEFA, violating federal guidelines.
  • Impacted Requirements: Compliance with 2 CFR §200.510(b) and 2 CFR §200.502 for accurate reporting of federal awards.
  • Recommended Follow-Up: Improve year-end grant reconciliation and review processes to ensure all federal expenditures are recorded accurately.

Finding Text

Federal Expenditures Not Reported in the Schedule of Federal Expenditures of Federal Awards and State Financial Assistance (“SEFA”) Federal Program: Coronavirus State and Local Fiscal Recovery Funds CFDA / Assistance Listing Number: 21.027 Federal Agency: U. S. Department of Treasury Pass-Through Entity: Tennessee Department of Environment and Conservation Fiscal Year Ended June 30, 2024 Criteria Per 2 CFR §200.510(b) and 2 CFR §200.502, entities expending federal awards must accurately identify all federal awards expended during the period and prepare a complete and accurate SEFA that is consistent with amounts recorded in the financial statements. Condition and Context During a subsequent audit, it was identified that federal expenditures totaling $867,515 were not recorded as federal grant revenue or accounts receivable in the financial statements and were also omitted from the SEFA. The amounts were material to total federal expenditures reported under the Uniform Guidance. Cause The omission occurred due to oversight in year-end closing and grant reconciliation procedures, which did not capture the unrecorded federal expenditures at fiscal year-end. Effect The SEFA originally issued was incomplete and understated total federal expenditures by $867,515. As a result, the fiscal year 2024 financial statements were reissued to include the omitted federal expenditures and to present an accurate SEFA in accordance with the Uniform Guidance. Questioned Costs None. Recommendation Management should strengthen year-end grant reconciliation and review procedures to ensure that all federal expenditures are properly recorded and included in the SEFA prior to issuance. Views of Responsible Officials and Planned Corrective Actions See management’s corrective action plan.

Corrective Action Plan

Management concurs with the finding. Procedures have been implemented to enhance year-end review of grant activity, including reconciliation of grant expenditures and receivables to the SEFA and general ledger prior to issuance. The Departments’ will continue to monitor these processes to ensure compliance with the Uniform Guidance reporting requirements. Anticipated Completion Date: October 31, 2025

Categories

Subrecipient Monitoring Reporting Internal Control / Segregation of Duties

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $11.85M