Finding 624283 (2022-005)

Significant Deficiency Repeat Finding
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-03-30
Audit: 49287
Organization: City of Dayton, Tennessee (TN)

AI Summary

  • Core Issue: The City lacks systematic controls for managing grant files, leading to improper identification and reporting of grants.
  • Impacted Requirements: Compliance with Uniform Guidance is at risk due to inadequate documentation and reconciliation of grant activities.
  • Recommended Follow-Up: Establish robust controls for documenting and reconciling grant information to ensure accurate preparation of the Schedule of Expenditures of Federal and State Awards.

Finding Text

2022-005: Improper Controls over Grant Transactions Condition: The City does not maintain grant files in a systematic manner to identify grant activity within the City?s General Fund, Water and Sewer Fund, Electric Fund, or Sanitation funds. Grant files did not include a reconciliation of grant revenue, expenses, or related deposit and retainage accounts to the general ledger or to the Schedule of Expenditures of Federal and State Awards. This weakness in the current system resulted in grants not identified initially, necessitating numerous revisions and corrections to the Schedule of Expenditures of Federal and State Awards regarding specific identification and names of grants with the associated Catalog of Federal Domestic Assistance (CFDA) number, pass-through number and placement of the grant as a Federal or State grant. Ultimately, City personnel responsible for preparation did not adequately prepare the Schedule of Expenditures of Federal and State Awards. Criteria: Uniform Guidance requires that systematic proper supporting documentation be maintained for grant activity. The Uniform Guidance also dictates that the City is responsible for preparing the Schedule of Expenditures of Federal and State Awards. Cause: Controls do not exist which require all grant information to be documented, reconciled and maintained in an orderly fashion to support grant activity. Effect: Grants could be improperly reported without proper controls. In addition, compliance issues could arise due to lack of controls. Recommendation: We recommend proper controls be established for gathering, naming, identifying, reconciling and maintaining grant documentation. This documentation should be the basis for preparation of the Schedule of Expenditures of Federal and State Awards and support all aspects of grant reconciliation, administration and compliance. Management Response: The current process for grant controls is being re-evalutated to develop stronger controls for gathering, naming, identifying, reconciling and maintaining all grant documents.

Categories

Reporting

Other Findings in this Audit

  • 47836 2022-001
    Material Weakness Repeat
  • 47837 2022-005
    Significant Deficiency Repeat
  • 47838 2022-001
    Material Weakness Repeat
  • 47839 2022-005
    Significant Deficiency Repeat
  • 47840 2022-001
    Material Weakness Repeat
  • 47841 2022-005
    Significant Deficiency Repeat
  • 624278 2022-001
    Material Weakness Repeat
  • 624279 2022-005
    Significant Deficiency Repeat
  • 624280 2022-001
    Material Weakness Repeat
  • 624281 2022-005
    Significant Deficiency Repeat
  • 624282 2022-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.019 Coronavirus Relief Fund $854,721
15.252 Abandoned Mine Land Reclamation (amlr) Program $806,213
84.010 Title I Grants to Local Educational Agencies $373,091
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $169,260
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $165,305
10.553 School Breakfast Program $164,887
84.425 Education Stabilization Fund $110,114
23.002 Appalachian Area Development $88,575
84.371 Striving Readers $79,617
14.239 Home Investment Partnerships Program $70,011
10.555 National School Lunch Program $47,615
84.027 Special Education_grants to States $41,154
45.310 Grants to States $21,096
84.358 Rural Education $18,270
10.559 Summer Food Service Program for Children $9,958
20.607 Alcohol Open Container Requirements $7,314
84.365 English Language Acquisition State Grants $6,925
20.205 Highway Planning and Construction $841
84.173 Special Education_preschool Grants $316
11.300 Investments for Public Works and Economic Development Facilities $0
20.106 Airport Improvement Program $0