Finding 453787 (2022-002)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2023-03-26
Audit: 313753
Organization: City of Portsmouth (OH)

AI Summary

  • Core Issue: The City failed to establish effective internal controls over the distribution of gift cards, leading to incomplete reconciliation of records.
  • Impacted Requirements: Compliance with 2 CFR section 200.303(a) regarding internal control standards was not met, risking the allowability of the gift card activities.
  • Recommended Follow-Up: The City should enhance procedures for safeguarding assets, maintaining records, and ensuring timely reconciliations to prevent future deficiencies.

Finding Text

Reference Number: 2022-002Prior Year Finding: NAFederal Agency: U.S. TreasuryFederal Program: Coronavirus State and Local Recovery Funds (CSLRF)Assistance Listing Number: 21.027Federal IdentificationAward Number and Year:None, March 3, 2021- December 31, 2024Compliance Requirement:Allowable ActivitiesAward YearJuly 1, 2021-June 30, 2022Type of FindingSignificant Deficiency in Internal Control Over ComplianceCriteria or specific requirement:Internal 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 theterms and conditions of the Federal award. These internal controls should be in compliance 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 purchased 4,429 $100 gift cards for the Senior and ALICE programs. The gift card distribution records did contain all the required eligibility information but was not reconciled to the total gift card population as of June 30, 2022. The distribution record was completed and reconciled as of March 1, 2023; however, this was not timely for the fiscal year 2022 federal program audit.Context:None, the finding relates to the maintenance of records.Questioned costs:None noted.Cause:The City?s initial response was to provide immediate financial assistance to the City?s residents. As a result, the time to establish adequate internal controls that prevent and/or detect errors and irregularities was decreased.Effect:The City may be unable to support the allowability of activity supported by the gift cards.Recommendation:We recommend that the City review and evaluate procedures to ensure that the procedures over safeguarding assets, maintenance of records, and reconciliation of activity are consistently performed.Views of responsible officials:The City agrees with the finding, see corrective action plan.

Corrective Action Plan

2022-002 Coronavirus State and Local Recovery Funds (CSLRF) ? Assistance Listing No. 21.027Recommendation: We recommend that the city review and evaluate procedures to ensure that the procedures over safeguarding assets, maintenance of records, and reconciliation of activity are consistently performed.Explanation of disagreement with audit finding: There is no disagreement with the audit finding.Action taken in response to finding: Management concurs with the recommendation. The accounts will be reconciled prior to the program ending on a regular cycle during the program to ensure appropriate accounts and the accuracy of the supporting documentation is provided going forward.Described action planned or taken: The Standard Operating Procedures that provide additional detail will be followed to document the process of reconciling the account on a timely basis. Online applications programs are being created by the department of technology to assist in the program documentation gathering in order to ensure applicants can provide all necessary support for the program in a secure environment.Name(s) of the contact person(s) responsible for corrective action: Kyera Pope, Accounting Administrator, Gloria Taylor, Interim Chief Financial OfficerPlanned completion date for corrective action plan: 7/1/2022.If the Auditor of Public Accounts has questions regarding this plan, please call Mimi Terry, Interim City Manager.

Categories

Procurement, Suspension & Debarment Eligibility Reporting Significant Deficiency Equipment & Real Property Management Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 453786 2022-001
    Significant Deficiency
  • 1030228 2022-001
    Significant Deficiency
  • 1030229 2022-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $12.21M
10.555 National School Lunch Program $8.90M
84.010 Title I Grants to Local Educational Agencies $6.38M
84.027 Special Education_grants to States $3.92M
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $2.30M
93.558 Temporary Assistance for Needy Families $1.28M
93.778 Medical Assistance Program $1.21M
93.667 Social Services Block Grant $1.10M
93.659 Adoption Assistance $1.07M
84.367 Improving Teacher Quality State Grants $800,973
93.658 Foster Care_title IV-E $783,407
84.041 Impact Aid $559,235
21.019 Coronavirus Relief Fund $553,823
84.424 Student Support and Academic Enrichment Program $479,894
14.218 Community Development Block Grants/entitlement Grants $470,441
84.048 Career and Technical Education -- Basic Grants to States $463,667
84.287 Twenty-First Century Community Learning Centers $416,264
10.558 Child and Adult Care Food Program $374,762
10.559 Summer Food Service Program for Children $340,073
93.959 Block Grants for Prevention and Treatment of Substance Abuse $333,081
84.047 Trio_upward Bound $307,797
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $287,717
84.002 Adult Education - Basic Grants to States $282,967
93.568 Low-Income Home Energy Assistance $236,270
12.000 Rotc $214,804
84.173 Special Education_preschool Grants $163,185
93.958 Block Grants for Community Mental Health Services $151,066
16.575 Crime Victim Assistance $84,546
93.556 Promoting Safe and Stable Families $72,644
93.150 Projects for Assistance in Transition From Homelessness (path) $55,560
16.922 Equitable Sharing Program $43,132
93.788 Opioid Str $40,000
97.042 Emergency Management Performance Grants $30,424
84.196 Education for Homeless Children and Youth $28,952
16.607 Bulletproof Vest Partnership Program $26,630
14.239 Home Investment Partnerships Program $20,696
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $18,292
84.365 English Language Acquisition State Grants $13,396
93.767 Children's Health Insurance Program $12,263
84.425 Education Stabilization Fund $8,200
93.566 Refugee and Entrant Assistance_state Administered Programs $6,255
20.607 Alcohol Open Container Requirements $3,680
93.645 Stephanie Tubbs Jones Child Welfare Services Program $3,166
20.205 Highway Planning and Construction $1,245
16.738 Edward Byrne Memorial Justice Assistance Grant Program $1,212
84.377 School Improvement Grants $984
97.067 Homeland Security Grant Program $631
93.599 Chafee Education and Training Vouchers Program (etv) $368
14.267 Continuum of Care Program $-797