FAC Explorer

Finding 400596 (2023-004)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-06-12
Audit: 308638
Organization: City of Portsmouth (OH)
Auditor: Cliftonlarsonallen LLP

AI Summary

  • Core Issue: The City of Portsmouth failed to report subawards to the FSRS as required by the Federal Funding Accountability and Transparency Act (FFATA).
  • Impacted Requirements: Compliance with FFATA mandates timely reporting of subawards of $30,000 or more, which was not met during FY 2023.
  • Recommended Follow-Up: Implement stronger procedures and internal controls to ensure all subawards are reported accurately and on time to FSRS.

Finding Text

Reference Number: 2023-004 Prior Year Finding: No Federal Agency: U.S. Department of Housing and Urban Development (HUD) Entity: City of Portsmouth (the City) Federal Program: Community Development Block Grants/Entitlement Grants Assistance Listing: 14.218 Federal Award Identification Number and Year: None, 2018, 2019, 2020 Pass-Through Entity: N/A Award Number and Period: B-18-MC-51-0018 (7/1/18-9/1/26) B-19-MC-51-0018 (7/1/19-9/1/27) B-20-MC-51-0018 (7/1/20-9/1/28) Compliance Requirement: Reporting – Federal Funding Accountability and Transparency Act (FFATA) Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance Criteria or specific requirement: Compliance: Per the Federal Funding Accountability and Transparency Act (FFATA), prime (direct) recipients of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Reports must be filed in FSRS by the end of the month following the month in which the prime recipient awards any sub-grant greater than or equal to $30,000. If the initial award is below $30,000 but subsequent grant modifications result in a total award equal to or over $30,000, the award will be subject to the reporting requirements as of the date the award exceeds $30,000. If the initial award equals or exceeds $30,000 but funding is subsequently de-obligated such that the total award amount falls below $30,000, the award continues to be subject to FFATA reporting requirements. The following key data elements must be reported: Subawardee Name and Data Universal Numbering System (DUNS) number; Amount of Subaward (inclusive of modifications); Subaward Obligation/Action Date; Date of Report Submission; Subaward Number; Project Description; and Names and Compensation of Highly Compensated Officers. (Names and Compensation of Highly Compensated Officers must only be reported when the entity in the preceding fiscal year received 80 percent or more of its annual gross revenues in Federal awards; and $25,000,000 or more in annual gross revenues from Federal awards; and the public does not have access to this information about the compensation of the senior executives of the entity through periodic reports filed under section 13(a) or 15(d) of the Securities Exchange Act of 1934 (15 U.S.C. §§ 78m(a), 78o(d)) or section 6104 of the Internal Revenue Code of 1986.) Section III – Findings and Questioned Costs – Major Federal Programs (Continued) Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The City of Portsmouth did not report subaward information to FSRS during FY 2023. Context: Subawards were not reported to FSRS during FY 2023. Total subawards selected were $153,000, and $0 was reported as required by FFATA requirements. SEE SCHEDULE OF FINDINGS AND QUESTIONED COSTS FOR CHART/TABLE Cause: The City’s procedures and controls were not sufficient to ensure that subawards were reported to FSRS during FY 2023. Effect: Subawards were not reported to FSRS in accordance with FFATA requirements. Questioned costs: None noted. Recommendation: We recommend the City establish procedures and internal controls to ensure that all required subawards are reported timely and accurately to FSRS no later than the end of the month following the month of issuance of each subaward. Views of Responsible Officials: Management agrees with the finding.

Categories

Subrecipient Monitoring Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties HUD Housing Programs Material Weakness Reporting

Other Findings in this Audit

  • 400586 2023-001
    Significant Deficiency
  • 400587 2023-001
    Significant Deficiency
  • 400588 2023-001
    Significant Deficiency
  • 400589 2023-001
    Significant Deficiency
  • 400590 2023-001
    Significant Deficiency
  • 400591 2023-002
    Material Weakness
  • 400592 2023-002
    Material Weakness
  • 400593 2023-003
    Significant Deficiency
  • 400594 2023-003
    Significant Deficiency
  • 400595 2023-004
    Material Weakness
  • 400597 2023-004
    Material Weakness
  • 400598 2023-004
    Material Weakness
  • 400599 2023-004
    Material Weakness
  • 977028 2023-001
    Significant Deficiency
  • 977029 2023-001
    Significant Deficiency
  • 977030 2023-001
    Significant Deficiency
  • 977031 2023-001
    Significant Deficiency
  • 977032 2023-001
    Significant Deficiency
  • 977033 2023-002
    Material Weakness
  • 977034 2023-002
    Material Weakness
  • 977035 2023-003
    Significant Deficiency
  • 977036 2023-003
    Significant Deficiency
  • 977037 2023-004
    Material Weakness
  • 977038 2023-004
    Material Weakness
  • 977039 2023-004
    Material Weakness
  • 977040 2023-004
    Material Weakness
  • 977041 2023-004
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.555 National School Lunch Program $9.50M
84.010 Title 1 Grants to Local Educational Agencies $7.11M
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $4.82M
84.027 Special Education Grants to States $3.89M
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $2.40M
93.558 Temporary Assistance for Needy Families $1.39M
93.778 Medical Assistance Program $1.27M
93.667 Social Services Block Grant $1.13M
93.659 Adoption Assistance $995,193
14.218 Community Development Block Grants/entitlement Grants $981,316
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $810,216
93.658 Foster Care Title IV-E $691,732
84.048 Career and Technical Education -- Basic Grants to States $546,969
16.575 Crime Victim Assistance $514,142
84.424 Student Support and Academic Enrichment Program $508,497
14.267 Continuum of Care Program $385,158
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $330,328
84.041 Impact Aid $294,804
93.568 Low-Income Home Energy Assistance $285,529
12.999 Rotc $285,359
14.239 Home Investment Partnerships Program $283,339
84.047 Trio Upward Bound $282,370
84.002 Adult Education - Basic Grants to States $229,621
10.559 Summer Food Service Program for Children $207,400
93.958 Block Grants for Community Mental Health Services $191,368
84.173 Special Education Preschool Grants $191,262
93.959 Block Grants for Prevention and Treatment of Substance Abuse $160,581
84.287 Twenty-First Century Community Learning Centers $153,222
97.042 Emergency Management Performance Grants $126,944
84.013 Title I State Agency Program for Neglected and Delinquent Children and Youth $121,458
93.556 Marylee Allen Promoting Safe and Stable Families Program $80,313
93.150 Projects for Assistance in Transition From Homelessness (path) $60,431
10.558 Child and Adult Care Food Program $56,235
97.067 Homeland Security Grant Program $45,456
93.788 Opioid Str $40,000
84.425 Covid-19 - Education Stabilization Fund $39,682
84.377 School Improvement Grants $39,649
93.472 Title IV-E Prevention Program $20,510
84.184 School Safely National Activities $17,910
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $17,771
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $17,065
16.607 Bulletproof Vest Partnership Program $16,901
84.365 English Language Acquisition State Grants $16,868
84.196 Education for Homeless Children and Youth $16,214
93.767 Children's Health Insurance Program $11,140
93.747 Covid-19 - Elder Abuse Prevention Interventions Program $9,438
20.600 State and Community Highway Safety $7,866
93.566 Refugee and Entrant Assistance State/replacement Designee Administered Programs $6,285
10.649 Covid-19 - Pandemic Ebt Administrative Costs $5,950
93.603 Adoption and Legal Guardianship Incentive Payments $4,469
20.607 Alcohol Open Container Requirements $2,975
20.205 Highway Planning and Construction $2,553
93.645 Stephanie Tubbs Jones Child Welfare Services Program $2,503
93.575 Child Care and Development Block Grant $1,497
93.599 Chafee Education and Training Vouchers Program (etv) $599
21.019 Coronavirus Relief Fund $571
93.090 Guardianship Assistance $543
16.738 Edward Byrne Memorial Justice Assistance Grant Program $348