Finding 1150418 (2023-009)

- Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2025-08-20
Audit: 364578
Organization: City of Biddeford (ME)

AI Summary

  • Core Issue: The City of Biddeford's Schedule of Expenditures of Federal Awards (SEFA) initially overstated expenditures by $113,201 due to accounting errors.
  • Impacted Requirements: Compliance with 2 CFR 200.510 was not met, as expenditures were reported in the wrong period and included unrelated credits.
  • Recommended Follow-Up: Implement regular reviews of grant expenditure accounts by a knowledgeable grant manager to ensure accurate year-end cutoff and proper coding.

Finding Text

2023-009 U.S. Department of Treasury, For the Period July 1, 2022 through June 30, 2023, Assistance Listing #21.027 Coronavirus State and Local Fiscal Recovery Funds Criteria: In accordance with 2 CFR 200.510 Financial Statements, grant recipients are required to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the recipient’s financial statements. The City of Biddeford prepares their SEFA on the accrual basis of accounting. Condition: During our testing of grant expenditures, we found one expenditure totaling $140,320 that was reported in the wrong period. We also found a credit of $27,119 that was unrelated to the State and Local Fiscal Recovery Fund (SLFRF) grant and improperly reduced grant expenditures. The initial SEFA overstated expenditures by $113,201 for the SLFRF grant. The client has made adjustments to the SEFA to correct the errors. Cause: Improper accounting cutoff procedures and improper transaction coding caused the initial SEFA to be incorrect. Effect: The SEFA initially overstated program expenditures by $113,201. Recommendation: We recommend regular review of Federal grant expenditure accounts by a grant manager knowledgeable of the program to ensure proper year end cutoff and proper expense and revenue coding. Known Questioned Costs: None Likely Questioned Costs: None

Categories

Reporting Procurement, Suspension & Debarment

Other Findings in this Audit

  • 573969 2023-008
    Material Weakness Repeat
  • 573970 2023-009
    - Repeat
  • 573971 2023-010
    Significant Deficiency Repeat
  • 573972 2023-008
    Material Weakness Repeat
  • 573973 2023-009
    - Repeat
  • 573974 2023-010
    Significant Deficiency Repeat
  • 573975 2023-008
    Material Weakness Repeat
  • 573976 2023-009
    - Repeat
  • 573977 2023-010
    Significant Deficiency Repeat
  • 1150411 2023-008
    Material Weakness Repeat
  • 1150412 2023-009
    - Repeat
  • 1150413 2023-010
    Significant Deficiency Repeat
  • 1150414 2023-008
    Material Weakness Repeat
  • 1150415 2023-009
    - Repeat
  • 1150416 2023-010
    Significant Deficiency Repeat
  • 1150417 2023-008
    Material Weakness Repeat
  • 1150419 2023-010
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 American Rescue Plan Act - Covid $5.02M
84.425 Elementary and Secondary School Emergency Relief #2 - Covid $1.69M
11.300 Grants for Public Works and Economic Development $1.16M
84.010 Title Ia, Disadvantaged $967,516
84.425 Elementary and Secondary School Emergency Relief #3 - Covid $691,457
84.027 Local Entitlement $641,236
10.555 National School Lunch Program $628,909
97.036 Disaster Grants - Public Assistance $432,435
21.027 Arp Career and Technical Education - Covid $404,463
97.044 Assistance to Firefighters Grant - 2020 $265,474
14.218 Community Development Block Grant - Entitlement $264,285
10.553 National School Lunch Program - Breakfast Program $246,762
84.425 Learning Management Systems (lms) (arpa) - Covid $176,803
14.900 Lead Hazard Reduction Grant Program $123,796
10.555 Food Donation Program $121,469
84.425 Governor's Emergency Education Relieve Funding (geer) - Covid $101,920
20.106 Airport Improvement Program $96,858
84.048 Career and Technical Education - Perkins Alignment Grant $85,476
84.002 Adult Basic Education $85,351
10.582 Fresh Fruit and Vegetable Program $85,263
10.559 Summer Food Service Program $80,637
84.425 Elementary and Secondary School Emergency Relief #1 - Covid $73,207
10.560 State Administrative Expenses for Child Nutrition: Supply Chain Assistance $66,712
21.027 Arp Extended Learning Opportunities - Covid $62,573
84.010 Title Ia, Reallocation $51,582
16.738 Byrne Justice Assistance Grant - 2023 $41,228
84.367 Title Iia - Supporting Effective Instruction $40,061
84.365 Title III Esl $28,731
10.555 After School Program $27,764
84.027 Local Entitlement - Arp - Covid $24,771
84.173 Preschool $19,764
16.738 Byrne Justice Assistance Grant - 2021 $18,074
84.267 21st Century $17,343
84.425 Arp Homeless Children and Youth I - Covid $16,669
10.649 Pandemic Ebt Administrative Costs: Snap $3,140
10.558 Child and Adult Care Food Program $1,299
16.034 Corona Virus Emergency Supplement - Covid $1,005