Finding 1130531 (2024-001)

Material Weakness
Requirement
B
Questioned Costs
$1
Year
2024
Accepted
2025-04-04
Audit: 352733
Organization: Town of Brunswick Maine (ME)

AI Summary

  • Core Issue: Payroll records for employees working on multiple grants lack actual time documentation, relying instead on budget estimates.
  • Impacted Requirements: This violates Uniform Guidance 2 CFR 200.430(g), which mandates proper documentation for personnel expenses.
  • Recommended Follow-Up: Implement a timesheet system to accurately track actual hours worked by employees across different funding sources.

Finding Text

2024-001 U.S. Department of Treasury, Assistance Listing #21.027 Coronavirus State and Local Fiscal Recovery Funds Program for the period of July 1, 2023 through June 30, 2024 Criteria: Uniform Guidance section 2 CFR 200.430(g) Standards for Documentation of Personnel Expenses requires records to support the distribution of employee salaries or wages when they are allocated amongst more than one Federal award or a Federal award and a non-Federal award. Budget estimates alone do not qualify as support for charges to Federal awards. Condition: During our testing of payroll expenditures at the School Department over the Coronavirus State and Local Fiscal Recovery Funds Program, we were unable to obtain actual time worked for employees split between multiple grants or Federal and non-Federal activities. Employee time was allocated based on budget estimates throughout the year. Cause: There is currently no system in place to require staff split between multiple grants or Federal and non-Federal activities to maintain weekly timesheets reflecting actual time worked. Effect: Actual time worked could differ from budgeted estimates. Without adequate support, payroll charges could be deemed unallowable. Known Questioned Costs: $4,422 Likely Questioned Costs: $31,105 Recommendation: We recommend a timesheet system be implemented to ensure that employees split between multiple grants or Federal and non-Federal activities are charging actual time worked to the applicable Federal grant.

Categories

Questioned Costs Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 554080 2024-002
    Significant Deficiency
  • 554081 2024-002
    Significant Deficiency
  • 554082 2024-002
    Significant Deficiency
  • 554083 2024-003
    Significant Deficiency
  • 554084 2024-003
    Significant Deficiency
  • 554085 2024-003
    Significant Deficiency
  • 554086 2024-004
    -
  • 554087 2024-004
    -
  • 554088 2024-004
    -
  • 554089 2024-001
    Material Weakness
  • 554090 2024-001
    Material Weakness
  • 554091 2024-001
    Material Weakness
  • 1130522 2024-002
    Significant Deficiency
  • 1130523 2024-002
    Significant Deficiency
  • 1130524 2024-002
    Significant Deficiency
  • 1130525 2024-003
    Significant Deficiency
  • 1130526 2024-003
    Significant Deficiency
  • 1130527 2024-003
    Significant Deficiency
  • 1130528 2024-004
    -
  • 1130529 2024-004
    -
  • 1130530 2024-004
    -
  • 1130532 2024-001
    Material Weakness
  • 1130533 2024-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.027 Special Education State Grants $838,966
21.027 State and Local Fiscal Recovery Funds - Covid-19 $812,019
15.916 Land and Water Conservation Fund Grant $627,768
84.425 Elementary and Secondary School Emergency Relief 3 - Covid-19 $601,837
84.010 Title Ia $492,824
10.555 National School Lunch Program - Subsidized Hot Lunch $384,803
10.553 Breakfast Program $133,425
21.027 State and Local Fiscal Recovery Funds Extended Learning Opportunities - Covid-19 $130,687
14.228 Community Development Block Grants $100,000
84.027 Arp Local Entitlement - Covid-19 $88,450
21.027 State and Local Fiscal Recovery Funds Prek - Covid-19 $83,524
10.555 Food Distribution/food Donation Program $80,069
10.555 State Administrative Expenses for Child Nutrition: Supply Chain Assistance $55,569
84.425 Arp Elementary and Secondary School Emergency Relief - Covid-19 $49,060
84.367 Title Iia - Supporting Effective Instruction $46,561
20.325 Consolidated Rail Infrastructure and Safety Improvements $46,043
16.710 Public Safety Partnership and Community Policing Program $45,000
20.205 Highway Planning and Construction $38,789
66.460 Nonpoint Source Implementation Grants $35,522
97.067 Homeland Security Grant $26,606
84.424 Title Iva - Student Support and Academic Enrichment $24,784
84.425 Arp Elementary and Secondary School Emergency Relief - Learning Loss - Covid-19 $15,641
84.425 Arp Homeless Children & Youth I - Covid-19 $13,736
84.173 Preschool 619 $11,882
20.600 High Visibility Enforcement $10,538
20.600 Dre - Forensic Phlebotomy $9,280
16.738 Edward Byrne Memorial Justice Assistance Grant $8,680
84.365 English Language Acquisition $8,600
15.605 Sport Fish Restoration Program $7,499
20.600 Distracted Driving $5,213
84.425 Elementary and Secondary School Emergency Relief 2 - Covid-19 $3,209
10.649 Pandemic Ebt Administrative Costs: Snap - Covid-19 $2,612
16.607 Bulletproof Vest Partnership Program $1,399
16.015 Missing Alzheimer's Disease Patient Assistance Program $1,072