Finding 390810 (2023-003)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2024-04-01
Audit: 301530
Organization: City of Portland Maine (ME)
Auditor: Marcum LLP

AI Summary

  • Core Issue: Payroll processing lacks adequate documentation, leading to uncertainty about the validity and allowability of costs charged to federal awards.
  • Impacted Requirements: Compliance with Allowable Costs/Cost Principles as outlined in federal regulations (CFR Section 200.403(g)).
  • Recommended Follow-Up: The School Department should redesign internal controls over payroll to ensure accuracy and compliance, addressing this as a repeat finding.

Finding Text

2023-003 Improve Controls and Documentation over Payroll Process Federal Agency: U.S. Department of Education Cluster/Program: Special Education Cluster Award Name: Special Education Local Entitlement AL Number(s): 84.027/84.173 Award Year: 2023 Compliance Requirement: Allowable Costs/Cost Principles Federal Agency: U.S. Department of Education Cluster/Program: Education Stabilization Fund Cluster Award Name: Elementary and Secondary Emergency Relief Funds AL Number(s): 84.425D/84.425U Award Year: 2023 Compliance Requirement: Allowable Costs/Cost Principles Federal Agency: U.S. Department of Treasury Cluster/Program: State and Local Fiscal Recovery Funds Award Name: State and Local Fiscal Recovery Funds AL Number(s): 21.027 Award Year: 2023 Compliance Requirement: Allowable Costs/Cost Principles Type of Finding Compliance Internal Control over Compliance - Material Weakness Criteria or Specific Requirement The Code of Federal Regulations Section 200.403(g) states that for costs to be allowable under Federal awards, they must be adequately documented and there must be sufficient documentation. Condition and Context In fiscal year 2023, our sample testing disclosed that amounts paid to employees could not be recalculated and documentation to ensure amounts paid were complete and accurate was not available. Effect or Potential Effect We were unable to conclude on the allowability, validity, or completeness of payroll charged to the grants, and as a result there is a risk that amounts charged to federal awards may not be allowable in accordance with applicable cost principles.Questioned Costs Due to the condition noted, we were unable to determine if the costs charged to the applicable grants are allowable. AL Questioned Number(s) Name of Federal Program or Cluster Costs 84.027/84.173 Special Education Cluster $2,105,321 84.425D/84.425U Education Stabilization Fund Cluster $5,695,516 21.027 State and Local Fiscal Recovery Funds $442,467 Cause Weaknesses in the design and operation of controls over payroll processing in the School Department. Identification as Repeat Finding As identified in Section IV, the Schedule of Prior Year Findings, this is a repeat of finding 2022- 003. Recommendation The School Department must re-design the internal controls surrounding how payroll is processed to provide assurance that processing is complete, accurate and valid. Views of Responsible Official and Planned Corrective Action Management’s views and corrective action plan is included at the end of this report after the summary schedule of prior year audit findings and status.

Categories

Questioned Costs Allowable Costs / Cost Principles Material Weakness

Other Findings in this Audit

  • 390807 2023-003
    Material Weakness Repeat
  • 390808 2023-004
    Material Weakness Repeat
  • 390809 2023-005
    Significant Deficiency
  • 390811 2023-003
    Material Weakness Repeat
  • 967249 2023-003
    Material Weakness Repeat
  • 967250 2023-004
    Material Weakness Repeat
  • 967251 2023-005
    Significant Deficiency
  • 967252 2023-003
    Material Weakness Repeat
  • 967253 2023-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $4.47M
20.106 Airport Improvement Program $3.51M
84.010 Title I Grants to Local Educational Agencies $1.94M
14.218 Community Development Block Grants/entitlement Grants $1.69M
14.239 Home Investment Partnerships Program $1.07M
10.553 School Breakfast Program $854,574
97.024 Emergency Food and Shelter National Board Program $836,501
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $781,615
20.205 Highway Planning and Construction $702,784
84.367 Improving Teacher Quality State Grants $521,656
14.231 Emergency Solutions Grant Program $518,520
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $429,213
93.940 Hiv Prevention Activities_health Department Based $390,533
11.454 Unallied Management Projects $389,981
84.027 Special Education_grants to States $341,613
16.753 Congressionally Recommended Awards $266,833
10.565 Commodity Supplemental Food Program $248,403
84.365 English Language Acquisition State Grants $238,717
84.424 Student Support and Academic Enrichment Program $232,205
10.559 Summer Food Service Program for Children $226,711
84.048 Career and Technical Education -- Basic Grants to States $218,490
21.027 Coronavirus State and Local Fiscal Recovery Funds $193,914
10.558 Child and Adult Care Food Program $187,049
16.922 Equitable Sharing Program $173,572
16.738 Edward Byrne Memorial Justice Assistance Grant Program $159,330
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $142,810
93.069 Public Health Emergency Preparedness $132,011
14.900 Lead-Based Paint Hazard Control in Privately-Owned Housing $121,256
21.019 Coronavirus Relief Fund $108,305
16.575 Crime Victim Assistance $102,328
93.566 Refugee and Entrant Assistance_state Administered Programs $100,755
97.044 Assistance to Firefighters Grant $99,480
97.072 Explosives Detection Canine Team Program $88,357
10.582 Fresh Fruit and Vegetable Program $81,441
15.904 Historic Preservation Fund Grants-in-Aid $67,742
16.710 Public Safety Partnership and Community Policing Grants $67,726
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $65,201
84.002 Adult Education - Basic Grants to States $49,863
93.959 Block Grants for Prevention and Treatment of Substance Abuse $43,763
93.575 Child Care and Development Block Grant $40,817
59.075 Shuttered Venue Operators Grant Program $23,479
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health $19,713
93.788 Opioid Str $15,098
10.649 Pandemic Ebt Administrative Costs $9,420
84.173 Special Education_preschool Grants $8,730
97.056 Port Security Grant Program $8,242
97.032 Crisis Counseling $7,178
16.609 Project Safe Neighborhoods $6,230
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $5,450
84.196 Education for Homeless Children and Youth $4,457
16.034 Coronavirus Emergency Supplemental Funding Program $3,174
84.425 Education Stabilization Fund $978
10.555 National School Lunch Program $782
93.136 Injury Prevention and Control Research and State and Community Based Programs $-410
97.067 Homeland Security Grant Program $-17,312