Finding 392854 (2023-004)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-04-10
Audit: 303154
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 missing programs and incorrect reporting.
  • Impacted Requirements: Compliance with the COSO Framework and U.S. GAAP is lacking, leading to potential disallowance of expenditures and future awards.
  • Recommended Follow-Up: Establish centralized policies and procedures for grant management to ensure accurate and timely reporting of all expenditures.

Finding Text

2023-001 – Material Weakness, Completeness and Accuracy of Schedule of Expenditures of Federal and State Awards (Repeat Finding 2022-001) Criteria: 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. Condition: We identified 15 federal programs and five state programs requiring adjustment to the reported expenditures. We identified two programs included on the SEFA without an assistance listing number, which resulted in the programs being reported as from the incorrect oversight agency. We identified one program was missing from the SEFA. One program was reported as a state program that was a passthrough of a federal program. The SEFA and SESA balance is required to be reconciled to the basic financial statements prepared in accordance with generally accepted accounting principles in the United States (U.S. GAAP). The Town has failed to adequately perform such reconciliation. Cause: Grant management and reporting is not centralized within the Town and are left to the individual departments. 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. 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 2022-001. View of Responsible Official: Due to turnover at the Greenwich Public Schools in key positions in recent years, the Town’s Finance Department has come to realize the grants reporting needs to be centralized. Initially, the Finance Department will assume more responsibility in the SEFA and SESA reconciliations of the reports to the Town’s financial software (MUNIS) until a Town-wide centralized grants reporting unit can be established. See corrective action plan.

Categories

Reporting

Other Findings in this Audit

  • 392817 2023-003
    Significant Deficiency
  • 392818 2023-003
    Significant Deficiency
  • 392819 2023-003
    Significant Deficiency
  • 392820 2023-003
    Significant Deficiency
  • 392821 2023-003
    Significant Deficiency
  • 392822 2023-003
    Significant Deficiency
  • 392823 2023-003
    Significant Deficiency
  • 392824 2023-003
    Significant Deficiency
  • 392825 2023-003
    Significant Deficiency
  • 392826 2023-003
    Significant Deficiency
  • 392827 2023-003
    Significant Deficiency
  • 392828 2023-003
    Significant Deficiency
  • 392829 2023-003
    Significant Deficiency
  • 392830 2023-003
    Significant Deficiency
  • 392831 2023-003
    Significant Deficiency
  • 392832 2023-003
    Significant Deficiency
  • 392833 2023-003
    Significant Deficiency
  • 392834 2023-003
    Significant Deficiency
  • 392835 2023-003
    Significant Deficiency
  • 392836 2023-003
    Significant Deficiency
  • 392837 2023-003
    Significant Deficiency
  • 392838 2023-003
    Significant Deficiency
  • 392839 2023-003
    Significant Deficiency
  • 392840 2023-003
    Significant Deficiency
  • 392841 2023-003
    Significant Deficiency
  • 392842 2023-003
    Significant Deficiency
  • 392843 2023-003
    Significant Deficiency
  • 392844 2023-003
    Significant Deficiency
  • 392845 2023-003
    Significant Deficiency
  • 392846 2023-003
    Significant Deficiency
  • 392847 2023-003
    Significant Deficiency
  • 392848 2023-004
    Material Weakness Repeat
  • 392849 2023-004
    Material Weakness Repeat
  • 392850 2023-004
    Material Weakness Repeat
  • 392851 2023-004
    Material Weakness Repeat
  • 392852 2023-004
    Material Weakness Repeat
  • 392853 2023-004
    Material Weakness Repeat
  • 392855 2023-004
    Material Weakness Repeat
  • 392856 2023-004
    Material Weakness Repeat
  • 392857 2023-004
    Material Weakness Repeat
  • 392858 2023-004
    Material Weakness Repeat
  • 392859 2023-004
    Material Weakness Repeat
  • 392860 2023-004
    Material Weakness Repeat
  • 392861 2023-004
    Material Weakness Repeat
  • 392862 2023-004
    Material Weakness Repeat
  • 969259 2023-003
    Significant Deficiency
  • 969260 2023-003
    Significant Deficiency
  • 969261 2023-003
    Significant Deficiency
  • 969262 2023-003
    Significant Deficiency
  • 969263 2023-003
    Significant Deficiency
  • 969264 2023-003
    Significant Deficiency
  • 969265 2023-003
    Significant Deficiency
  • 969266 2023-003
    Significant Deficiency
  • 969267 2023-003
    Significant Deficiency
  • 969268 2023-003
    Significant Deficiency
  • 969269 2023-003
    Significant Deficiency
  • 969270 2023-003
    Significant Deficiency
  • 969271 2023-003
    Significant Deficiency
  • 969272 2023-003
    Significant Deficiency
  • 969273 2023-003
    Significant Deficiency
  • 969274 2023-003
    Significant Deficiency
  • 969275 2023-003
    Significant Deficiency
  • 969276 2023-003
    Significant Deficiency
  • 969277 2023-003
    Significant Deficiency
  • 969278 2023-003
    Significant Deficiency
  • 969279 2023-003
    Significant Deficiency
  • 969280 2023-003
    Significant Deficiency
  • 969281 2023-003
    Significant Deficiency
  • 969282 2023-003
    Significant Deficiency
  • 969283 2023-003
    Significant Deficiency
  • 969284 2023-003
    Significant Deficiency
  • 969285 2023-003
    Significant Deficiency
  • 969286 2023-003
    Significant Deficiency
  • 969287 2023-003
    Significant Deficiency
  • 969288 2023-003
    Significant Deficiency
  • 969289 2023-003
    Significant Deficiency
  • 969290 2023-004
    Material Weakness Repeat
  • 969291 2023-004
    Material Weakness Repeat
  • 969292 2023-004
    Material Weakness Repeat
  • 969293 2023-004
    Material Weakness Repeat
  • 969294 2023-004
    Material Weakness Repeat
  • 969295 2023-004
    Material Weakness Repeat
  • 969296 2023-004
    Material Weakness Repeat
  • 969297 2023-004
    Material Weakness Repeat
  • 969298 2023-004
    Material Weakness Repeat
  • 969299 2023-004
    Material Weakness Repeat
  • 969300 2023-004
    Material Weakness Repeat
  • 969301 2023-004
    Material Weakness Repeat
  • 969302 2023-004
    Material Weakness Repeat
  • 969303 2023-004
    Material Weakness Repeat
  • 969304 2023-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $2.93M
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.50M
84.010 Title I Grants to Local Educational Agencies $1.35M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $421,324
10.555 National School Lunch Program $350,375
84.027 Special Education_grants to States $230,563
14.218 Community Development Block Grants/entitlement Grants $119,755
84.048 Career and Technical Education -- Basic Grants to States $115,812
97.039 Hazard Mitigation Grant $100,000
84.367 Improving Teacher Quality State Grants $90,160
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $89,274
10.553 School Breakfast Program $87,361
93.498 Provider Relief Fund $73,648
10.559 Summer Food Service Program for Children $48,214
97.056 Port Security Grant Program $43,462
84.173 Special Education_preschool Grants $33,516
84.365 English Language Acquisition State Grants $28,918
20.601 Alcohol Impaired Driving Countermeasures Incentive Grants I $23,433
90.401 Help America Vote Act Requirements Payments $21,634
93.069 Public Health Emergency Preparedness $15,104
16.607 Bulletproof Vest Partnership Program $13,913
10.649 Pandemic Ebt Administrative Costs $11,927
20.616 National Priority Safety Programs $6,076
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $4,282
20.205 Highway Planning and Construction $3,762