Finding 575955 (2024-004)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-09-09
Audit: 365875
Organization: Town of Gorham (ME)

AI Summary

  • Core Issue: The Finance Department struggles to reconcile expenditures regularly due to staff limitations and new software implementation.
  • Impacted Requirements: Some ARPA costs were incorrectly coded to non-ARPA accounts, affecting the accuracy of financial reporting.
  • Recommended Follow-Up: Increase Finance Department staff to three by FY26 to improve monthly review processes and ensure proper coding of invoices.

Finding Text

Management response/corrective action: The Town Council approves the projects for ARPA and the department that the project is related to manages the project and codes the invoices. The Finance Department has two staff and has been implementing new financial software. Due to the volume of work the Finance Department cannot reconcile the Town’s expenditure routinely. Everything posted to ARPA is reviewed to make sure the cost is appropriate during the reporting period ending March 31st. The report is filed as of 4/30/24, based on the snapshot of what was coded to the ARPA expense lines as of March 31st. No costs reported were not considered ARPA expenses. At year end, a thorough review of all the Town’s expenditure is done, and some ARPA costs were found coded to non-ARPA account. These costs were moved to the ARPA account in June as part of year end entries. Some of these costs were paid in the reporting period of March 31st and had they been coded correctly they would have been in that report. These costs were captured in the next annual report that is due 04/30/25. The Finance Department staff will be increasing to three in FY26 so this will give the Finance Director more time to review the monthly expenditure to find any miscoded invoices.

Corrective Action Plan

Management response/corrective action: The Town Council approves the projects for ARPA and the department that the project is related to manages the project and codes the invoices. The Finance Department has two staff and has been implementing new financial software. Due to the volume of work the Finance Department cannot reconcile the Town’s expenditure routinely. Everything posted to ARPA is reviewed to make sure the cost is appropriate during the reporting period ending March 31st. The report is filed as of 4/30/24, based on the snapshot of what was coded to the ARPA expense lines as of March 31st. No costs reported were not considered ARPA expenses. At year end, a thorough review of all the Town’s expenditure is done, and some ARPA costs were found coded to non-ARPA account. These costs were moved to the ARPA account in June as part of year end entries. Some of these costs were paid in the reporting period of March 31st and had they been coded correctly they would have been in that report. These costs were captured in the next annual report that is due 04/30/25. The Finance Department staff will be increasing to three in FY26 so this will give the Finance Director more time to review the monthly expenditure to find any miscoded invoices.

Categories

Reporting

Other Findings in this Audit

  • 575952 2024-001
    Significant Deficiency
  • 575953 2024-002
    Significant Deficiency Repeat
  • 575954 2024-003
    Significant Deficiency
  • 575956 2024-002
    Significant Deficiency Repeat
  • 575957 2024-003
    Significant Deficiency
  • 575958 2024-004
    Significant Deficiency
  • 575959 2024-002
    Significant Deficiency Repeat
  • 575960 2024-003
    Significant Deficiency
  • 575961 2024-004
    Significant Deficiency
  • 1152394 2024-001
    Significant Deficiency
  • 1152395 2024-002
    Significant Deficiency Repeat
  • 1152396 2024-003
    Significant Deficiency
  • 1152397 2024-004
    Significant Deficiency
  • 1152398 2024-002
    Significant Deficiency Repeat
  • 1152399 2024-003
    Significant Deficiency
  • 1152400 2024-004
    Significant Deficiency
  • 1152401 2024-002
    Significant Deficiency Repeat
  • 1152402 2024-003
    Significant Deficiency
  • 1152403 2024-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.251 Economic Development Initiative, Community Project Funding, and Miscellaneous Grants $1.00M
84.027 Special Education State Grants Individuals with Disabilities Act $933,351
21.027 Covid-19 Pre-K Expansion $453,809
10.553 National School Lunch Program $306,452
84.010 Title Ia - Basic Disadvantaged Program $262,427
21.027 Covid-19 American Rescue Plan $245,815
84.425 Covid-19 Esser #3 $177,921
10.555 School Breakfast Program $96,812
10.555 Food Donation Program $94,073
84.367 Supporting Effective Instruction $87,237
10.555 Child Nutrition Supply Chain Assistance $65,842
21.027 Covid-19 Maine Recovery and Jobs Plan $61,017
20.600 2024 High Visibility Enforcement and Education $20,686
84.173 Preschool $19,956
84.425 Covid-19 Multilingual Learners Experiencing Homelessness $18,400
84.425 Covid-19 Esser #2 $11,664
20.600 2023 Impaired Driving Enforcement $11,133
20.600 2024 Dre / Fp Training and Call-Out $5,239
10.558 Snap Year 1 $3,265
20.600 2023 Op Hve Cit & Sustained Enforcement $3,083
16.738 Edward Byrne Justice Assistance Grant $2,850
20.600 2023 Dre / Fp Training and Call-Out $2,378
20.600 2023 Hv Distracted Driving Enforcement $1,479
97.067 Homeland Security Grant $1,346
20.600 2024 Distracted Driving Enforcement $1,344
20.500 2023 Speed Enforcement $735