Finding 524332 (2024-001)

Material Weakness
Requirement
B
Questioned Costs
$1
Year
2024
Accepted
2025-02-24
Audit: 343523
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

  • 524321 2024-002
    Significant Deficiency
  • 524322 2024-002
    Significant Deficiency
  • 524323 2024-002
    Significant Deficiency
  • 524324 2024-003
    Significant Deficiency
  • 524325 2024-003
    Significant Deficiency
  • 524326 2024-003
    Significant Deficiency
  • 524327 2024-004
    -
  • 524328 2024-004
    -
  • 524329 2024-004
    -
  • 524330 2024-001
    Material Weakness
  • 524331 2024-001
    Material Weakness
  • 1100763 2024-002
    Significant Deficiency
  • 1100764 2024-002
    Significant Deficiency
  • 1100765 2024-002
    Significant Deficiency
  • 1100766 2024-003
    Significant Deficiency
  • 1100767 2024-003
    Significant Deficiency
  • 1100768 2024-003
    Significant Deficiency
  • 1100769 2024-004
    -
  • 1100770 2024-004
    -
  • 1100771 2024-004
    -
  • 1100772 2024-001
    Material Weakness
  • 1100773 2024-001
    Material Weakness
  • 1100774 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