Finding 47943 (2022-002)

-
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2023-03-30
Audit: 52314
Organization: City of Haverhill (MA)

AI Summary

  • Core Issue: The City lacks a proper process for charging expenditures to the Education Stabilization Fund, leading to large manual journal entries and delayed documentation.
  • Impacted Requirements: Compliance with allowable costs and cost principles is at risk, as the City cannot promptly substantiate costs charged to the Federal program.
  • Recommended Follow-Up: Management should establish internal controls to ensure timely and accurate recording of expenditures and maintain accessible documentation for any manual adjustments.

Finding Text

Education Stabilization Fund - Federal Assistance Listing Numbers 84.425C, 84.425D, and 84.425W 2022-002: Controls for Charging Expenditures to the Grant Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Compliance and Internal Control over Compliance ? Other Matter Criteria or Specific Requirement: Grantees must provide reasonable assurance that Federal awards are expended only for allowable activities and that the costs of goods and services charged to Federal awards are allowable and in accordance with the applicable cost principles. Condition: The City did not have an adequate process to charge expenditures to the Education Stabilization Fund program, resulting in large adjusting journal entries to record costs to the grant. The City also did not have an adequate process to maintain supporting documentation for the adjusting entries in an efficient manner that could be provided timely upon request. Questioned Costs: None reported. Context: A majority of expenditures were initially charged to the general fund upon disbursement and subsequently reclassified to the Education Stabilization Fund program via three material manual adjusting journal entries. The City was not able to provide documentation to support the manual journal entries upon request, and support was not provided until a significant amount of time after the request was made. Effect: The City is not able to promptly substantiate the allowability of costs charged to the Federal program. The risk that unallowable costs could be charged, or that accounting errors could be made and not detected and correct timely, is heightened. Cause: Lack of appropriate controls over recording expenditures to the grant and maintaining documentation for costs charged. The internal control process should include procedures to ensure that grant activity is recorded appropriately, and that adequate supporting documentation is maintained and readily available. Recommendation: Management should implement internal control procedures to ensure that expenditures are charged appropriately at the time they are initially incurred. Effective internal control procedures would mitigate the need for large manual adjusting journal entries. If adjusting journal entries are required, the City should retain adequate documentation to support the journal entries. The documentation should be filed in a manner that ensures it is easily accessible upon request. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and will implement internal control procedures to ensure that expenditures are recorded appropriately at the time they are incurred. Management will also implement procedures to ensure that, if manual adjusting entries are required, detailed supporting documentation is maintained. Management plans to implement these procedures in 2023.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 47598 2022-001
    Significant Deficiency Repeat
  • 47599 2022-001
    Significant Deficiency Repeat
  • 47921 2022-001
    Significant Deficiency Repeat
  • 47922 2022-001
    Significant Deficiency Repeat
  • 47923 2022-001
    Significant Deficiency Repeat
  • 47924 2022-001
    Significant Deficiency Repeat
  • 47925 2022-001
    Significant Deficiency Repeat
  • 47926 2022-001
    Significant Deficiency Repeat
  • 47927 2022-001
    Significant Deficiency Repeat
  • 47928 2022-001
    Significant Deficiency Repeat
  • 47929 2022-001
    Significant Deficiency Repeat
  • 47930 2022-001
    Significant Deficiency Repeat
  • 47931 2022-001
    Significant Deficiency Repeat
  • 47932 2022-001
    Significant Deficiency Repeat
  • 47933 2022-001
    Significant Deficiency
  • 47934 2022-004
    -
  • 47935 2022-001
    Significant Deficiency
  • 47936 2022-004
    -
  • 47937 2022-001
    Significant Deficiency
  • 47938 2022-004
    -
  • 47939 2022-002
    -
  • 47940 2022-003
    -
  • 47941 2022-002
    -
  • 47942 2022-003
    -
  • 47944 2022-003
    -
  • 47945 2022-002
    -
  • 47946 2022-003
    -
  • 47947 2022-002
    -
  • 47948 2022-003
    -
  • 47949 2022-002
    -
  • 47950 2022-003
    -
  • 47951 2022-002
    -
  • 47952 2022-003
    -
  • 624040 2022-001
    Significant Deficiency Repeat
  • 624041 2022-001
    Significant Deficiency Repeat
  • 624363 2022-001
    Significant Deficiency Repeat
  • 624364 2022-001
    Significant Deficiency Repeat
  • 624365 2022-001
    Significant Deficiency Repeat
  • 624366 2022-001
    Significant Deficiency Repeat
  • 624367 2022-001
    Significant Deficiency Repeat
  • 624368 2022-001
    Significant Deficiency Repeat
  • 624369 2022-001
    Significant Deficiency Repeat
  • 624370 2022-001
    Significant Deficiency Repeat
  • 624371 2022-001
    Significant Deficiency Repeat
  • 624372 2022-001
    Significant Deficiency Repeat
  • 624373 2022-001
    Significant Deficiency Repeat
  • 624374 2022-001
    Significant Deficiency Repeat
  • 624375 2022-001
    Significant Deficiency
  • 624376 2022-004
    -
  • 624377 2022-001
    Significant Deficiency
  • 624378 2022-004
    -
  • 624379 2022-001
    Significant Deficiency
  • 624380 2022-004
    -
  • 624381 2022-002
    -
  • 624382 2022-003
    -
  • 624383 2022-002
    -
  • 624384 2022-003
    -
  • 624385 2022-002
    -
  • 624386 2022-003
    -
  • 624387 2022-002
    -
  • 624388 2022-003
    -
  • 624389 2022-002
    -
  • 624390 2022-003
    -
  • 624391 2022-002
    -
  • 624392 2022-003
    -
  • 624393 2022-002
    -
  • 624394 2022-003
    -

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $4.22M
10.555 National School Lunch Program $3.87M
14.218 Community Development Block Grants/entitlement Grants $1.23M
10.553 School Breakfast Program $1.09M
14.218 Covid-19 - Community Development Block Grants/entitlement Grants $337,550
10.555 Covid-19 - National School Lunch Program $287,068
10.559 Summer Food Service Program for Children $285,072
84.287 Twenty-First Century Community Learning Centers $163,095
84.010 Title I Grants to Local Educational Agencies $142,260
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $116,000
16.034 Covid-19 - Coronavirus Emergency Supplemental Funding Program $102,146
84.367 Supporting Effective Instruction State Grants $94,167
21.019 Covid-19 - Coronavirus Relief Fund $87,062
14.239 Home Investment Partnerships Program $85,028
93.268 Immunization Cooperative Agreements $69,923
20.600 State and Community Highway Safety $67,290
84.027 Covid-19 - Special Education_grants to States $51,133
84.365 English Language Acquisition State Grants $48,573
84.425 Covid-19 - Education Stabilization Fund $40,531
97.042 Emergency Management Performance Grants $32,757
10.558 Child and Adult Care Food Program $29,691
45.310 Covid-19 - Grants to States $25,000
16.738 Edward Byrne Memorial Justice Assistance Grant Program $21,464
97.044 Assistance to Firefighters Grant $19,594
16.710 Public Safety Partnership and Community Policing Grants $15,099
84.424 Student Support and Academic Enrichment Program $14,941
10.649 Covid-19 - Pandemic Ebt Administrative Costs $14,722
84.027 Special Education_grants to States $9,366
16.922 Equitable Sharing Program $7,273
84.196 Education for Homeless Children and Youth $6,813
84.173 Special Education_preschool Grants $6,138
20.616 National Priority Safety Programs $3,951
84.048 Career and Technical Education -- Basic Grants to States $3,532
84.938 Disaster Recovery Assistance for Education $3,077