Finding 1057363 (2023-009)

- Repeat Finding
Requirement
ABFGLM
Questioned Costs
-
Year
2023
Accepted
2024-08-12
Audit: 317016
Organization: City of Derby, Connecticut (CT)

AI Summary

  • Core Issue: The Finance Department failed to prepare required schedules for federal and state expenditures for the fiscal year ending June 30, 2023.
  • Impacted Requirements: These schedules are necessary for compliance with laws and regulations regarding federal and state financial assistance.
  • Recommended Follow-Up: The Finance Department and Board of Education should prepare these schedules annually to ensure proper compliance and internal controls.

Finding Text

*23-09 Federal and State Single Audit Schedules Finding: The Finance Department did not prepare a schedule of expenditures of federal awards and state financial assistance for the year ended June 30, 2023. These schedules are derived from federal and state grant awards received by the General Government and the Board of Education of the City. The Board of Education grant awards primarily are passed through the State Department of Education, while the City receives their grants primarily through the State Department of Housing and Urban Development, the State Department of Health and Human Resources, the State Department of Agriculture and the Office of Policy and Management. The preparation of these schedules of expenditures has, in the past, been made by the auditors, including decision making concerning the federal CFDA number, the pass-through entity number and the amount of federal and state expenditures incurred by the City for the fiscal year. The auditor then reports on the Schedules of Expenditures of Federal and State Financial Assistance and renders his opinion with respect to the compliance with laws, regulations, contracts and grants and with the City’s internal control over compliance with requirements of the laws, regulations, contracts and grants. Criteria: The schedules of federal awards and state financial assistance are required to be prepared by the City. Cause: Lack of a staff member assigned to identify and obtain grant revenue and prepare the appropriate federal and state financial schedules. Effect: The auditor is preparing these schedules and auditing them. Recommendation: We recommend that the Finance Department and/or the Board of Education annually prepare the Schedule of Expenditures of Federal Awards and State Financial Assistance to be presented to the auditor for audit. The auditor can then render an opinion with respect to compliance with and internal control over compliance with laws, regulations, contracts and grants. This will provide the proper segregation of responsibilities over the preparation of the schedules and the rendering of an opinion of these schedules. Management’s Response: The City and BOE will prepare the Schedules of Expenditures of Federal and State Financial Assistance going forward.

Categories

Subrecipient Monitoring Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $601,328
10.553 School Breakfast Program $298,553
84.010 Title I Grants - Opportunity District Essa Sig - Cohort 2 $178,729
93.575 Child Care and Development Block Grant $75,000
10.555 National School Lunch Program $40,762
84.424 Student Support and Academic Enrichment Program $31,134
84.048 Career and Technical Education -- Basic Grants to States $29,422
84.367 Improving Teacher Quality State Grants $11,735
84.010 Title I Grants to Local Educational Agencies $11,423
83.027 Special Education_grants to States $10,000
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $6,515
84.173 Special Education_preschool Grants $6,307
84.365 English Language Acquisition State Grants $5,529
84.027 Special Education_grants to States $5,000
10.559 Summer Food Service Program for Children $4,933
90.401 Help America Vote Act Requirements Payments $2,576
10.649 Pandemic Ebt Administrative Costs $2,512
84.425 Education Stabilization Fund $1,300