Finding 1208386 (2024-018)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2024
Accepted
2026-04-22
Audit: 399363
Organization: City of Danbury (CT)
Auditor: RSM US LLP

AI Summary

  • Core Issue: There are significant errors in the SEFA, with incorrect fiscal year expenditures reported for both CDBG and ESSERS programs.
  • Impacted Requirements: The City must adhere to the COSO Framework for accurate and complete reporting of federal and state awards.
  • Recommended Follow-Up: City management should enhance review processes and policies to ensure all expenditures are correctly reported in the appropriate fiscal year.

Finding Text

Finding 2024-018: Significant Deficiency in Internal Control – Completeness and Accuracy of the SEFA Assistance Listing Program Title and Number: Education Stabilization Fund- Elementary and Secondary School Emergency Relief (84.425D), American Rescue Plan Elementary and Secondary School Emergency Relief (84.425U) (collectively ESSERS) and Community Development Block Grants (CDBG) Entitlement/Special Purpose Grants Cluster (14.218) Federal Agency: U.S. Department of Education and U.S. Department of Housing Pass-through Entity: State of Connecticut Department of Education Award year: 2023 – 2024 Criteria or specific requirement: Committee of Sponsoring Organizations (COSO) Framework – control activities: Proper review of the schedule of expenditures of federal awards (SEFA) and schedule of expenditure of state awards (SESA) should ensure the accuracy and completeness of the schedules. Condition: We identified errors in the SEFA as originally provided by the City including fiscal year 2023 expenditures being included in the fiscal year 2024 SEFA expenditures reported for the Community Development Block Grants CDBG Entitlement/Special Purpose Grants Cluster (CDBG) ($178,900) and Education Stabilization Fund- Elementary and Secondary School Emergency Relief, American Rescue Plan Elementary and Secondary School Emergency Relief (ESSERS) ($37,382). The City needs improved centralized review of the completed SEFA. Cause: Turnover in the City and DPS finance departments along with grant management and reporting not being centralized within the City, with responsibility left to the individual departments. Effect: This can result in inaccurate amounts reported in the SEFA and the disallowance of expenditures/future awards by the grantor due to lack of proper reporting. Context: For CDBG from a population of 88 nonpayroll expenditure transactions we sampled 9 expenditures totaling $266,738 for testing. For one out of the 9 expenditures tested in the amount of $178,900, we noted the expenditure pertained to fiscal year 2023. For ESSERS out of a population of 302 nonpayroll transactions, we sampled 40 transactions totaling $727,290 for testing. Five out of 40 samples tested, totaling $37,382, pertained to fiscal year 2023. The samples were not statistically valid samples. Questioned Cost: None Repeat Finding: 2023-004 Recommendation: We recommend that City management, in coordination with the departments; improve established policies and procedures , including a more thorough review of the complete schedule, to help to make certain all federal and state expended funds are complete and accurate and included in the correct fiscal year in the SEFA and SESA. Views of Responsible Officials: Management agrees with the finding.

Corrective Action Plan

Finding 2024-018: Significant Deficiency in Internal Control – Completeness and Accuracy of the SEFA Condition: For the Education Stabilization Fund- Elementary and Secondary School Emergency Relief (84.425D), American Rescue Plan Elementary and Secondary School Emergency Relief (84.425U) (collectively ESSERS) and Community Development Block Grants (CDBG) Entitlement/Special Purpose Grants Cluster (14.218) resulted in 2023 expenditures reported in our 2024 fiscal year expenditures. Per the Committee of Sponsoring Organizations (COSO) Framework – control activities: Proper review of the schedule of expenditures of federal awards (SEFA) and schedule of expenditure of state awards (SESA) should ensure the accuracy and completeness of the schedules. Contact Person: Joanne Sterk, Assistant Director of Finance – Operations, City of Danbury Contact Person: Michael Weaver, CFO, Danbury Public Schools Corrective Actions Completed: We agree with the finding. The City and Danbury Public Schools are monitoring the timing of purchase orders and vendor invoices to encumber for late invoicing.

Categories

Reporting

Other Findings in this Audit

  • 1208313 2024-010
    Material Weakness Repeat
  • 1208314 2024-010
    Material Weakness Repeat
  • 1208315 2024-010
    Material Weakness Repeat
  • 1208316 2024-010
    Material Weakness Repeat
  • 1208317 2024-010
    Material Weakness Repeat
  • 1208318 2024-010
    Material Weakness Repeat
  • 1208319 2024-010
    Material Weakness Repeat
  • 1208320 2024-013
    Material Weakness Repeat
  • 1208321 2024-013
    Material Weakness Repeat
  • 1208322 2024-014
    Material Weakness Repeat
  • 1208323 2024-014
    Material Weakness Repeat
  • 1208324 2024-010
    Material Weakness Repeat
  • 1208325 2024-010
    Material Weakness Repeat
  • 1208326 2024-010
    Material Weakness Repeat
  • 1208327 2024-010
    Material Weakness Repeat
  • 1208328 2024-010
    Material Weakness Repeat
  • 1208329 2024-010
    Material Weakness Repeat
  • 1208330 2024-010
    Material Weakness Repeat
  • 1208331 2024-011
    Material Weakness Repeat
  • 1208332 2024-011
    Material Weakness Repeat
  • 1208333 2024-011
    Material Weakness Repeat
  • 1208334 2024-011
    Material Weakness Repeat
  • 1208335 2024-011
    Material Weakness Repeat
  • 1208336 2024-011
    Material Weakness Repeat
  • 1208337 2024-011
    Material Weakness Repeat
  • 1208338 2024-016
    Material Weakness Repeat
  • 1208339 2024-016
    Material Weakness Repeat
  • 1208340 2024-016
    Material Weakness Repeat
  • 1208341 2024-016
    Material Weakness Repeat
  • 1208342 2024-016
    Material Weakness Repeat
  • 1208343 2024-016
    Material Weakness Repeat
  • 1208344 2024-016
    Material Weakness Repeat
  • 1208345 2024-017
    Material Weakness Repeat
  • 1208346 2024-017
    Material Weakness Repeat
  • 1208347 2024-017
    Material Weakness Repeat
  • 1208348 2024-017
    Material Weakness Repeat
  • 1208349 2024-017
    Material Weakness Repeat
  • 1208350 2024-017
    Material Weakness Repeat
  • 1208351 2024-017
    Material Weakness Repeat
  • 1208352 2024-016
    Material Weakness Repeat
  • 1208353 2024-016
    Material Weakness Repeat
  • 1208354 2024-016
    Material Weakness Repeat
  • 1208355 2024-016
    Material Weakness Repeat
  • 1208356 2024-016
    Material Weakness Repeat
  • 1208357 2024-016
    Material Weakness Repeat
  • 1208358 2024-010
    Material Weakness Repeat
  • 1208359 2024-010
    Material Weakness Repeat
  • 1208360 2024-010
    Material Weakness Repeat
  • 1208361 2024-010
    Material Weakness Repeat
  • 1208362 2024-010
    Material Weakness Repeat
  • 1208363 2024-010
    Material Weakness Repeat
  • 1208364 2024-010
    Material Weakness Repeat
  • 1208365 2024-010
    Material Weakness Repeat
  • 1208366 2024-010
    Material Weakness Repeat
  • 1208367 2024-010
    Material Weakness Repeat
  • 1208368 2024-010
    Material Weakness Repeat
  • 1208369 2024-010
    Material Weakness Repeat
  • 1208370 2024-010
    Material Weakness Repeat
  • 1208371 2024-015
    Material Weakness Repeat
  • 1208372 2024-015
    Material Weakness Repeat
  • 1208373 2024-015
    Material Weakness Repeat
  • 1208374 2024-015
    Material Weakness Repeat
  • 1208375 2024-015
    Material Weakness Repeat
  • 1208376 2024-015
    Material Weakness Repeat
  • 1208377 2024-015
    Material Weakness Repeat
  • 1208378 2024-018
    Material Weakness Repeat
  • 1208379 2024-018
    Material Weakness Repeat
  • 1208380 2024-018
    Material Weakness Repeat
  • 1208381 2024-018
    Material Weakness Repeat
  • 1208382 2024-018
    Material Weakness Repeat
  • 1208383 2024-018
    Material Weakness Repeat
  • 1208384 2024-018
    Material Weakness Repeat
  • 1208385 2024-018
    Material Weakness Repeat
  • 1208387 2024-012
    Material Weakness Repeat
  • 1208388 2024-010
    Material Weakness Repeat
  • 1208389 2024-013
    Material Weakness Repeat
  • 1208390 2024-010
    Material Weakness Repeat
  • 1208391 2024-010
    Material Weakness Repeat
  • 1208392 2024-010
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
10.555 NATIONAL SCHOOL LUNCH PROGRAM $4.61M
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $3.33M
10.553 SCHOOL BREAKFAST PROGRAM $1.16M
20.106 AIRPORT IMPROVEMENT PROGRAM, INFRASTRUCTURE INVESTMENT AND JOBS ACT PROGRAMS, AND COVID-19 AIRPORTS PROGRAMS $1.15M
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $659,703
84.287 TWENTY-FIRST CENTURY COMMUNITY LEARNING CENTERS $424,825
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $373,250
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $342,067
10.560 STATE ADMINISTRATIVE EXPENSES FOR CHILD NUTRITION $295,515
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES $293,841
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $243,209
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $128,400
84.002 ADULT EDUCATION - BASIC GRANTS TO STATES $127,700
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $107,367
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $88,994
21.016 EQUITABLE SHARING $81,261
97.044 ASSISTANCE TO FIREFIGHTERS GRANT $62,992
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $57,313
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $52,978
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $50,039
84.027 SPECIAL EDUCATION GRANTS TO STATES $31,500
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $29,923
93.354 PUBLIC HEALTH EMERGENCY RESPONSE: COOPERATIVE AGREEMENT FOR EMERGENCY RESPONSE: PUBLIC HEALTH CRISIS RESPONSE $23,117
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $20,651
93.758 PREVENTIVE HEALTH AND HEALTH SERVICES BLOCK GRANT FUNDED SOLELY WITH PREVENTION AND PUBLIC HEALTH FUNDS (PPHF) $12,334
10.558 CHILD AND ADULT CARE FOOD PROGRAM $10,809
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $9,063
10.185 LOCAL FOOD FOR SCHOOLS COOPERATIVE AGREEMENT PROGRAM $7,506
84.425 EDUCATION STABILIZATION FUND $5,056
10.649 PANDEMIC EBT ADMINISTRATIVE COSTS $3,956
45.310 GRANTS TO STATES $2,000
97.073 STATE HOMELAND SECURITY PROGRAM (SHSP) $1,000