Finding 44526 (2022-003)

Material Weakness
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2023-03-19
Audit: 43791
Organization: City of Portland Maine (ME)
Auditor: Melanson CPAS

AI Summary

  • Core Issue: Inadequate documentation and controls over the payroll process led to uncertainty about the allowability of payroll costs charged to federal grants.
  • Impacted Requirements: Compliance with federal regulations (CFR Section 200.403(g)) regarding allowable costs and sufficient documentation.
  • Recommended Follow-Up: Redesign payroll processing controls to ensure accuracy, completeness, and compliance with federal cost principles.

Finding Text

2022-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: 2022 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: 2022 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 2022, 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. 21 Questioned Costs Due to the condition noted, we were unable to determine if the costs charged to the applicable grants are allowable. AL Known or Likely Number(s) Name of Federal Program or Cluster Questioned Costs 84.027/84.173 Special Education Cluster $1,900,742 84.425D/84.425U Education Stabilization Fund Cluster $8,334,464 Cause Weaknesses in the design and operation of controls over payroll processing. 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

  • 44518 2022-004
    Material Weakness
  • 44519 2022-004
    Material Weakness
  • 44520 2022-003
    Material Weakness
  • 44521 2022-003
    Material Weakness
  • 44522 2022-003
    Material Weakness
  • 44523 2022-003
    Material Weakness
  • 44524 2022-003
    Material Weakness
  • 44525 2022-003
    Material Weakness
  • 620960 2022-004
    Material Weakness
  • 620961 2022-004
    Material Weakness
  • 620962 2022-003
    Material Weakness
  • 620963 2022-003
    Material Weakness
  • 620964 2022-003
    Material Weakness
  • 620965 2022-003
    Material Weakness
  • 620966 2022-003
    Material Weakness
  • 620967 2022-003
    Material Weakness
  • 620968 2022-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.010 Title I Grants to Local Educational Agencies $1.90M
20.106 Airport Improvement Program $1.17M
10.553 School Breakfast Program $1.14M
14.239 Home Investment Partnerships Program $1.02M
21.019 Coronavirus Relief Fund $529,712
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $462,317
93.788 Opioid Str $417,970
59.075 Shuttered Venue Operators Grant Program $406,997
84.424 Student Support and Academic Enrichment Program $384,429
84.367 Improving Teacher Quality State Grants $351,842
14.218 Community Development Block Grants/entitlement Grants $345,885
14.900 Lead-Based Paint Hazard Control in Privately-Owned Housing $318,360
20.205 Highway Planning and Construction $254,992
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $220,582
10.565 Commodity Supplemental Food Program $217,959
97.067 Homeland Security Grant Program $202,805
84.048 Career and Technical Education -- Basic Grants to States $192,387
10.558 Child and Adult Care Food Program $147,933
10.559 Summer Food Service Program for Children $144,335
84.365 English Language Acquisition State Grants $140,927
16.034 Coronavirus Emergency Supplemental Funding Program $118,000
10.582 Fresh Fruit and Vegetable Program $81,090
84.002 Adult Education - Basic Grants to States $72,622
93.959 Block Grants for Prevention and Treatment of Substance Abuse $71,812
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $70,103
93.069 Public Health Emergency Preparedness $64,343
97.072 Tsa Bomb Dogs $60,326
93.576 Refugee and Entrant Assistance_discretionary Grants $52,248
93.940 Hiv Prevention Activities_health Department Based $50,683
84.196 Education for Homeless Children and Youth $47,972
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $44,667
93.575 Child Care and Development Block Grant $44,431
93.136 Injury Prevention and Control Research and State and Community Based Programs $43,080
16.575 Crime Victim Assistance $41,831
16.609 Project Safe Neighborhoods $37,149
84.027 Special Education_grants to States $36,623
84.173 Special Education_preschool Grants $29,206
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $27,622
97.044 Assistance to Firefighters Grant $26,000
97.032 Crisis Counseling $25,629
14.231 Emergency Solutions Grant Program $16,295
15.904 Historic Preservation Fund Grants-in-Aid $12,500
84.425 Education Stabilization Fund $8,872
21.027 Coronavirus State and Local Fiscal Recovery Funds $6,257
16.738 Edward Byrne Memorial Justice Assistance Grant Program $5,540
10.555 National School Lunch Program $3,688
97.024 Emergency Food and Shelter National Board Program $2,011
93.817 Hospital Preparedness Program (hpp) Ebola Preparedness and Response Activities $163
97.039 Hazard Mitigation Grant $147