FAC Explorer

Finding 569085 (2024-004)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2024
Accepted
2025-06-30
Audit: 360711
Organization: Town of Greenwich, Connecticut (CT)
Auditor: Rsm US LLP

AI Summary

  • Core Issue: There are significant inaccuracies in the Schedule of Expenditures of Federal and State Awards (SEFA/SESA), including misreported programs and unaccounted costs.
  • Impacted Requirements: Compliance with U.S. GAAP and Uniform Guidance (2 CFR 200.510) is not being met, risking disallowance of expenditures and future awards.
  • Recommended Follow-Up: Town management should implement centralized policies and procedures to ensure accurate and timely reporting of all federal and state funds in the SEFA and SESA.

Finding Text

2024-004 – Material Weakness and Noncompliance, Completeness and Accuracy of Schedule of Expenditures of Federal and State Awards (Repeat Finding 2023-004) U.S. Department of Agriculture Passed through State of Connecticut Department of Education Child Nutrition Cluster Assistance Listing Number: 10.553 Program Name: School Breakfast Program Assistance Listing Number: 10.555 Program Name: National School Lunch Program Assistance Listing Number: 10.560 Program Name: State Administrative Expenses for Child Nutrition Assistance Listing Number: 10.649 Program Name: COVID-19 Pandemic Electronic Benefit (P-EBT) Administrative Costs 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 Education Passed through the State of Connecticut Department of Education Assistance Listing Number: 84.010 Program Name: Title I Grants to Local Education Agencies Special Education Cluster (IDEA) Assistance Listing Number: 84.027 Program Name: Special Education Grants to States Assistance Listing Number: 84.027 Program Name: COVID-19 Special Education Grants to States Assistance Listing Number: 84.173 Program Name: Special Education Preschool Grants Assistance Listing Number: 84.173 Program Name: COVID-19 Special Education Preschool Grants Assistance Listing Number: 84.048 Program Name: Career and Technical Education – Basic Grants to States Assistance Listing Number: 84.365 Program Name: English Language Acquisition to State Grants Assistance Listing Number: 84.367 Program Name: Supporting Effective Instruction State Grants Assistance Listing Number: 84.424 Program Name: Student Support and Academic Enrichment Program Education Stabilization Fund: Assistance Listing Number: 84.425D Program Name: COVID-19 Elementary and Secondary School Relief Fund (ESSER) Assistance Listing Number: 84.425U Program Name: COVID-19 American Rescue Plan - Elementary and Secondary School Emergency Relief Fund (ARP ESSER) U.S. Department of Health and Human Services Passed through the State Department of Public Health Assistance Listing Number: 93.268 Program Name: Immunization Cooperative Agreements Assistance Listing Number: 93.323 Program Name: COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases 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 awards (SESA) includes the accuracy and completeness of the schedules. The SEFA and SESA 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 awards expended as determined in accordance with 2 CFR 200.502. Condition: We identified 16 federal programs and 9 state programs requiring adjustment to the reported expenditures. We identified 4 programs included on the SEFA under the incorrect oversight agency. We also identified 2 programs missing from the SEFA. The Town failed to adequately perform a reconciliation of the SEFA and SESA to the financial statements. In addition, during testing of allowable costs, we discovered $98,252 of costs pertaining to FY2023 transactions that were included in the FY2024 SEFA, with a projected total error of $185,755. Cause: Grant management and reporting is not centralized within the Town and are left to the individual departments. Underlying accounting records are maintained on a budgetary basis until year end-reporting. Additionally, management as well as department heads are unfamiliar with grant accounting in accordance with U.S. GAAP. Effect or potential effect: This can result in an inaccurate amount reported in the SEFA, SESA, or basic financial statements or the disallowance of expenditures / future awards by the grantor due to lack of proper reporting. Additionally, an inaccurate SEFA/SESA 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 to make certain all federal and state expended funds are captured timely and appropriately in the correct fiscal year in the SEFA and SESA. Questioned costs: None Context: See condition above. Repeat finding: This is a repeat of finding 2023-001. View of responsible official: We agree with the finding. See corrective action plan.

Categories

Reporting School Nutrition Programs

Other Findings in this Audit

  • 569051 2024-003
    Significant Deficiency Repeat
  • 569052 2024-003
    Significant Deficiency Repeat
  • 569053 2024-003
    Significant Deficiency Repeat
  • 569054 2024-003
    Significant Deficiency Repeat
  • 569055 2024-003
    Significant Deficiency Repeat
  • 569056 2024-003
    Significant Deficiency Repeat
  • 569057 2024-003
    Significant Deficiency Repeat
  • 569058 2024-003
    Significant Deficiency Repeat
  • 569059 2024-003
    Significant Deficiency Repeat
  • 569060 2024-003
    Significant Deficiency Repeat
  • 569061 2024-003
    Significant Deficiency Repeat
  • 569062 2024-003
    Significant Deficiency Repeat
  • 569063 2024-003
    Significant Deficiency Repeat
  • 569064 2024-003
    Significant Deficiency Repeat
  • 569065 2024-003
    Significant Deficiency Repeat
  • 569066 2024-003
    Significant Deficiency Repeat
  • 569067 2024-003
    Significant Deficiency Repeat
  • 569068 2024-003
    Significant Deficiency Repeat
  • 569069 2024-003
    Significant Deficiency Repeat
  • 569070 2024-003
    Significant Deficiency Repeat
  • 569071 2024-003
    Significant Deficiency Repeat
  • 569072 2024-003
    Significant Deficiency Repeat
  • 569073 2024-003
    Significant Deficiency Repeat
  • 569074 2024-003
    Significant Deficiency Repeat
  • 569075 2024-003
    Significant Deficiency Repeat
  • 569076 2024-003
    Significant Deficiency Repeat
  • 569077 2024-003
    Significant Deficiency Repeat
  • 569078 2024-003
    Significant Deficiency Repeat
  • 569079 2024-003
    Significant Deficiency Repeat
  • 569080 2024-004
    Material Weakness Repeat
  • 569081 2024-004
    Material Weakness Repeat
  • 569082 2024-004
    Material Weakness Repeat
  • 569083 2024-004
    Material Weakness Repeat
  • 569084 2024-004
    Material Weakness Repeat
  • 569086 2024-004
    Material Weakness Repeat
  • 569087 2024-004
    Material Weakness Repeat
  • 569088 2024-004
    Material Weakness Repeat
  • 569089 2024-004
    Material Weakness Repeat
  • 569090 2024-004
    Material Weakness Repeat
  • 569091 2024-004
    Material Weakness Repeat
  • 569092 2024-004
    Material Weakness Repeat
  • 569093 2024-004
    Material Weakness Repeat
  • 569094 2024-004
    Material Weakness Repeat
  • 569095 2024-004
    Material Weakness Repeat
  • 569096 2024-004
    Material Weakness Repeat
  • 569097 2024-004
    Material Weakness Repeat
  • 569098 2024-004
    Material Weakness Repeat
  • 569099 2024-004
    Material Weakness Repeat
  • 569100 2024-004
    Material Weakness Repeat
  • 569101 2024-004
    Material Weakness Repeat
  • 569102 2024-004
    Material Weakness Repeat
  • 569103 2024-005
    Material Weakness
  • 569104 2024-005
    Material Weakness
  • 569105 2024-005
    Material Weakness
  • 569106 2024-005
    Material Weakness
  • 569107 2024-005
    Material Weakness
  • 569108 2024-005
    Material Weakness
  • 569109 2024-005
    Material Weakness
  • 569110 2024-005
    Material Weakness
  • 569111 2024-006
    Material Weakness
  • 569112 2024-006
    Material Weakness
  • 569113 2024-007
    Material Weakness
  • 569114 2024-007
    Material Weakness
  • 569115 2024-008
    Material Weakness
  • 569116 2024-008
    Material Weakness
  • 569117 2024-008
    Material Weakness
  • 569118 2024-008
    Material Weakness
  • 569119 2024-009
    Material Weakness
  • 569120 2024-009
    Material Weakness
  • 1145493 2024-003
    Significant Deficiency Repeat
  • 1145494 2024-003
    Significant Deficiency Repeat
  • 1145495 2024-003
    Significant Deficiency Repeat
  • 1145496 2024-003
    Significant Deficiency Repeat
  • 1145497 2024-003
    Significant Deficiency Repeat
  • 1145498 2024-003
    Significant Deficiency Repeat
  • 1145499 2024-003
    Significant Deficiency Repeat
  • 1145500 2024-003
    Significant Deficiency Repeat
  • 1145501 2024-003
    Significant Deficiency Repeat
  • 1145502 2024-003
    Significant Deficiency Repeat
  • 1145503 2024-003
    Significant Deficiency Repeat
  • 1145504 2024-003
    Significant Deficiency Repeat
  • 1145505 2024-003
    Significant Deficiency Repeat
  • 1145506 2024-003
    Significant Deficiency Repeat
  • 1145507 2024-003
    Significant Deficiency Repeat
  • 1145508 2024-003
    Significant Deficiency Repeat
  • 1145509 2024-003
    Significant Deficiency Repeat
  • 1145510 2024-003
    Significant Deficiency Repeat
  • 1145511 2024-003
    Significant Deficiency Repeat
  • 1145512 2024-003
    Significant Deficiency Repeat
  • 1145513 2024-003
    Significant Deficiency Repeat
  • 1145514 2024-003
    Significant Deficiency Repeat
  • 1145515 2024-003
    Significant Deficiency Repeat
  • 1145516 2024-003
    Significant Deficiency Repeat
  • 1145517 2024-003
    Significant Deficiency Repeat
  • 1145518 2024-003
    Significant Deficiency Repeat
  • 1145519 2024-003
    Significant Deficiency Repeat
  • 1145520 2024-003
    Significant Deficiency Repeat
  • 1145521 2024-003
    Significant Deficiency Repeat
  • 1145522 2024-004
    Material Weakness Repeat
  • 1145523 2024-004
    Material Weakness Repeat
  • 1145524 2024-004
    Material Weakness Repeat
  • 1145525 2024-004
    Material Weakness Repeat
  • 1145526 2024-004
    Material Weakness Repeat
  • 1145527 2024-004
    Material Weakness Repeat
  • 1145528 2024-004
    Material Weakness Repeat
  • 1145529 2024-004
    Material Weakness Repeat
  • 1145530 2024-004
    Material Weakness Repeat
  • 1145531 2024-004
    Material Weakness Repeat
  • 1145532 2024-004
    Material Weakness Repeat
  • 1145533 2024-004
    Material Weakness Repeat
  • 1145534 2024-004
    Material Weakness Repeat
  • 1145535 2024-004
    Material Weakness Repeat
  • 1145536 2024-004
    Material Weakness Repeat
  • 1145537 2024-004
    Material Weakness Repeat
  • 1145538 2024-004
    Material Weakness Repeat
  • 1145539 2024-004
    Material Weakness Repeat
  • 1145540 2024-004
    Material Weakness Repeat
  • 1145541 2024-004
    Material Weakness Repeat
  • 1145542 2024-004
    Material Weakness Repeat
  • 1145543 2024-004
    Material Weakness Repeat
  • 1145544 2024-004
    Material Weakness Repeat
  • 1145545 2024-005
    Material Weakness
  • 1145546 2024-005
    Material Weakness
  • 1145547 2024-005
    Material Weakness
  • 1145548 2024-005
    Material Weakness
  • 1145549 2024-005
    Material Weakness
  • 1145550 2024-005
    Material Weakness
  • 1145551 2024-005
    Material Weakness
  • 1145552 2024-005
    Material Weakness
  • 1145553 2024-006
    Material Weakness
  • 1145554 2024-006
    Material Weakness
  • 1145555 2024-007
    Material Weakness
  • 1145556 2024-007
    Material Weakness
  • 1145557 2024-008
    Material Weakness
  • 1145558 2024-008
    Material Weakness
  • 1145559 2024-008
    Material Weakness
  • 1145560 2024-008
    Material Weakness
  • 1145561 2024-009
    Material Weakness
  • 1145562 2024-009
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $3.25M
84.010 Title I Grants to Local Educational Agencies $1.86M
10.555 National School Lunch Program $943,978
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $389,021
84.027 Special Education Grants to States $327,591
10.560 State Administrative Expenses for Child Nutrition $197,266
21.027 Coronavirus State and Local Fiscal Recovery Funds $173,886
10.553 School Breakfast Program $115,177
84.048 Career and Technical Education -- Basic Grants to States $93,095
97.042 Emergency Management Performance Grants $62,527
84.173 Special Education Preschool Grants $51,537
84.424 Student Support and Academic Enrichment Program $36,869
20.601 Alcohol Impaired Driving Countermeasures Incentive Grants I $35,229
84.365 English Language Acquisition State Grants $34,948
20.205 Highway Planning and Construction $33,334
20.616 National Priority Safety Programs $28,614
14.218 Community Development Block Grants/entitlement Grants $20,399
93.268 Immunization Cooperative Agreements $16,300
10.649 Pandemic Ebt Administrative Costs $9,795
16.738 Edward Byrne Memorial Justice Assistance Grant Program $9,740
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $4,841