Finding 581411 (2022-004)

Significant Deficiency
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2023-12-18
Audit: 7220
Organization: City of Medford (MA)

AI Summary

  • Core Issue: An employee was overpaid by $5,688.29 due to a lack of review in manual payroll calculations.
  • Impacted Requirements: Payments must comply with federal regulations, avoiding improper payments and ensuring accuracy.
  • Recommended Follow-Up: Implement a review process for all manual payroll calculations to prevent future errors.

Finding Text

U.S. Department of Education Passed-through the Commonwealth of Massachusetts’ Department of Elementary and Secondary Education COVID-19 – Education Stabilization Fund – CFDA 84.425 Significant Deficiency in Internal Controls Over Compliance Criteria: Per 2 CFR Part 200, charges to federal awards should be free of improper payments, including (1) payments that should not have been made or that were made in incorrect amounts (including overpayments and underpayments) under statutory, contractual, administrative, or other legally applicable requirements; (2) payments that do not account for credit for applicable discounts; (3) duplicate payments; (4) payments that were made to an ineligible party or for an ineligible good or service; and (5) payments for goods or services not received (except for such payments where authorized by law) Condition: An employee charged to the grant was overpaid by $5,688.29. Cause: The employee’s final check was calculated manually and not reviewed and approved before being paid on a payroll warrant. Effect: The City charged an unallowable cost to the federal award. Questioned Costs: $5,688.29 Repeat Finding from Prior Year: No Recommendation: The School should implement procedures to review and approve all manual payroll calculations to ensure that the pay is calculated correctly. Views of Responsible Official: Management agrees with the finding.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 4958 2022-007
    Significant Deficiency Repeat
  • 4959 2022-007
    Significant Deficiency Repeat
  • 4960 2022-007
    Significant Deficiency Repeat
  • 4961 2022-007
    Significant Deficiency Repeat
  • 4962 2022-005
    -
  • 4963 2022-005
    -
  • 4964 2022-003
    -
  • 4965 2022-006
    - Repeat
  • 4966 2022-006
    - Repeat
  • 4967 2022-006
    - Repeat
  • 4968 2022-006
    - Repeat
  • 4969 2022-004
    Significant Deficiency
  • 4970 2022-004
    Significant Deficiency
  • 4971 2022-004
    Significant Deficiency
  • 4972 2022-004
    Significant Deficiency
  • 4973 2022-004
    Significant Deficiency
  • 4974 2022-004
    Significant Deficiency
  • 4975 2022-004
    Significant Deficiency
  • 4976 2022-004
    Significant Deficiency
  • 581400 2022-007
    Significant Deficiency Repeat
  • 581401 2022-007
    Significant Deficiency Repeat
  • 581402 2022-007
    Significant Deficiency Repeat
  • 581403 2022-007
    Significant Deficiency Repeat
  • 581404 2022-005
    -
  • 581405 2022-005
    -
  • 581406 2022-003
    -
  • 581407 2022-006
    - Repeat
  • 581408 2022-006
    - Repeat
  • 581409 2022-006
    - Repeat
  • 581410 2022-006
    - Repeat
  • 581412 2022-004
    Significant Deficiency
  • 581413 2022-004
    Significant Deficiency
  • 581414 2022-004
    Significant Deficiency
  • 581415 2022-004
    Significant Deficiency
  • 581416 2022-004
    Significant Deficiency
  • 581417 2022-004
    Significant Deficiency
  • 581418 2022-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $13.12M
14.218 Community Development Block Grants/entitlement Grants $2.33M
21.019 Coronavirus Relief Fund $675,893
10.553 School Breakfast Program $377,933
10.555 National School Lunch Program $141,524
84.027 Special Education_grants to States $139,822
32.009 Emergency Connectivity Fund Program $136,000
97.044 Assistance to Firefighters Grant $77,341
84.425 Education Stabilization Fund $56,160
93.959 Block Grants for Prevention and Treatment of Substance Abuse $31,417
84.173 Special Education_preschool Grants $30,908
10.558 Child and Adult Care Food Program $24,353
16.922 Equitable Sharing Program $23,099
16.607 Bulletproof Vest Partnership Program $14,360
84.367 Improving Teacher Quality State Grants $12,515
84.424 Student Support and Academic Enrichment Program $9,942
84.048 Career and Technical Education -- Basic Grants to States $7,060
10.649 Pandemic Ebt Administrative Costs $4,912
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $2,188
84.196 Education for Homeless Children and Youth $2,000
84.010 Title I Grants to Local Educational Agencies $1,402
84.365 English Language Acquisition State Grants $767