Finding 1201184 (2025-005)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2025
Accepted
2026-03-30
Audit: 395857
Organization: Town of Greenwich, Connecticut (CT)
Auditor: RSM US LLP

AI Summary

  • Core Issue: There are significant deficiencies in the completeness and accuracy of the Schedule of Expenditures of Federal and State Awards (SEFA/SESFA), with multiple errors identified.
  • Impacted Requirements: Compliance with the COSO Framework and Uniform Guidance (2 CFR 200.510) is not being met, leading to potential inaccuracies in financial reporting.
  • Recommended Follow-Up: Town management should develop centralized policies and procedures to ensure all federal and state funds are accurately reported in the SEFA and SESFA.

Finding Text

2025-005—Significant Deficiency and Noncompliance, Completeness and Accuracy of Schedule of Expenditures of Federal and State Awards (Repeat Finding 2024-004. Severity downgraded from material weakness to significant deficiency due to corrective actions implemented) U.S. Department of Agriculture Passed through State of Connecticut Department of Education Assistance Listing Number: 10.185 Program Name: Local Foods for Schools Incentive Program Assistance Listing Number: 10.579 Program Name: Child Nutrition Discretionary Grants Department of Homeland Security Passed through the State of Connecticut Emergency Management and Homeland Security Assistance Listing Number: 97.042 Program Name: Emergency Management Performance Grant U.S. Department of Health and Human Services Passed through the State Department of Public Health Assistance Listing Number: 93.323 Program Name: COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases U.S. Department of Transportation Assistance Listing Number: 20.939 Program Name: Safe Streets and Roads for All Passed through the State Department of Transportation Assistance Listing Number: 20.205 Program Name: Highway Planning and Construction U.S. Department of Treasury Passed through the State of Connecticut Department of Education and the State Office of Early Childhood Assistance Listing Number: 21.027 Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery FundsCriteria: 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 financial assistance (SESFA) includes the accuracy and completeness of the schedules. The SEFA and SESFA balance should be reconciled to the basic financial statements which are prepared in accordance with generally accepted accounting principles in the United States (U.S. GAAP). The Uniform Guidance 2 CFR 200.510 (b) requires the auditee (the Town) to prepare a schedule of expenditures of federal awards for the period covered by the auditee’s financial statements. The schedule must include the total federal and awards expended as determined in accordance with 2 CFR 200.502 and the Office of Policy and Management’s Compliance Supplement. Condition: We identified several required adjustments and corrections to the SEFA and SESFA as listed below: • Six federal programs were missing or had an incorrect assistance listing number. • One program improperly included on the SESFA that was moved to the SEFA. • One program improperly included under the incorrect oversight agency. • One program improperly reported as a direct grant. • One state program requiring adjustment to decrease the reported expenditures by $250,481. • Three programs improperly included as exempt programs. • One program had an incorrect state grant ID. Cause: Grant management and reporting is not centralized within the Town and are left to the individual departments. Grant agreements and the underlying information required to prepare the SEFA and SESFA are not maintained centrally. Effect or potential effect: This can result in an inaccurate amount reported in the SEFA, SESFA, or basic financial statements or the disallowance of expenditures / future awards by the grantor due to lack of proper reporting. Additionally, an inaccurate SEFA/SESFA can result in incorrect identification of major programs leading to further delays and inefficiencies in the audit. Recommendation: We recommend that Town management, in coordination with the departments, establish policy and procedures to help make certain all federal and state expended funds are captured timely and appropriately in the correct fiscal year in the SEFA and SESFA. Questioned costs: None Context: See condition above. Repeat finding: This is a repeat of finding 2024-001. View of responsible official: We agree with the finding. See corrective action plan.

Corrective Action Plan

2025-005 – Significant Deficiency and Noncompliance, Completeness and Accuracy of Schedule of Expenditures of Federal and State Awards (Repeat Finding 2024-001. Severity downgraded from material weakness to significant deficiency due to corrective actions implemented.) Audit Finding: There were several required adjustments and corrections to the Schedule of Expenditures of Federal Awards (SEFA) and the Schedule of Expenditure of State Financial Assistance (SESFA) as follows: (1) Six federal programs were missing or had an incorrect assistance listing number. (2) One program improperly included on the SESFA that was moved to the SEFA. (3) One program improperly included under the incorrect oversight agency. (4) One program improperly reported as a direct grant. (5) One state program requiring adjustment to decrease the reported expenditures by $250,481. (6) Three programs improperly included as exempt programs. (7) One program had an incorrect state grant ID. Corrective Action Taken: The Town Finance Department has placed an emphasis on timely tracking and reporting of grants, as can be seen from the improvement from material weakness to significant deficiency. The SEFA and SESFA will be prepared throughout the year by Town Finance, who will also maintain copies of all grant agreements. All positions in the BOE Finance Department and Town Finance have now been filled, and the Director of Finance at the BOE has implemented monthly reconciliation procedures. From the Town side, the reconciliations between the GAAP financial statements and amounts reported on the SEFA and SESA will be overseen by the Deputy Comptroller. The Deputy Comptroller and BOE Director of Finance meet regularly to discuss updates and issues and will reconcile the June 30, 2026 reports in the first quarter of FY2027. Anticipated Completion Date: In Process as of July 2025 Name and Phone # of Person Responsible for Implementation

Categories

No categories assigned yet.

Other Findings in this Audit

  • 1201176 2025-005
    Material Weakness Repeat
  • 1201177 2025-005
    Material Weakness Repeat
  • 1201178 2025-005
    Material Weakness Repeat
  • 1201179 2025-005
    Material Weakness Repeat
  • 1201180 2025-005
    Material Weakness Repeat
  • 1201181 2025-005
    Material Weakness Repeat
  • 1201182 2025-005
    Material Weakness Repeat
  • 1201183 2025-005
    Material Weakness Repeat
  • 1201185 2025-006
    Material Weakness Repeat
  • 1201186 2025-006
    Material Weakness Repeat
  • 1201187 2025-006
    Material Weakness Repeat
  • 1201188 2025-006
    Material Weakness Repeat
  • 1201189 2025-006
    Material Weakness Repeat
  • 1201190 2025-006
    Material Weakness Repeat
  • 1201191 2025-007
    Material Weakness Repeat
  • 1201192 2025-008
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.027 SPECIAL EDUCATION GRANTS TO STATES $2.96M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $1.07M
10.555 NATIONAL SCHOOL LUNCH PROGRAM $899,624
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $619,244
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $608,970
20.939 SAFE STREETS AND ROADS FOR ALL $196,819
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $176,291
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $136,856
10.553 SCHOOL BREAKFAST PROGRAM $109,136
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES $98,829
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $60,856
20.601 ALCOHOL IMPAIRED DRIVING COUNTERMEASURES INCENTIVE GRANTS I $53,984
97.044 ASSISTANCE TO FIREFIGHTERS GRANT $46,399
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $44,042
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $35,000
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $21,090
84.425 EDUCATION STABILIZATION FUND $19,475
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $18,836
93.967 CENTERS FOR DISEASE CONTROL AND PREVENTION COLLABORATION WITH ACADEMIA TO STRENGTHEN PUBLIC HEALTH $17,614
97.056 PORT SECURITY GRANT PROGRAM $17,063
10.185 LOCAL FOOD FOR SCHOOLS COOPERATIVE AGREEMENT PROGRAM $15,995
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $15,834
10.579 CHILD NUTRITION DISCRETIONARY GRANTS LIMITED AVAILABILITY $14,109
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $13,168
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $7,778
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $5,000