Finding 572324 (2023-057)

Material Weakness
Requirement
N
Questioned Costs
-
Year
2023
Accepted
2025-07-30

AI Summary

  • Core Issue: ADSEF lacks updated written reconciliation procedures for EBT transactions, leading to material noncompliance and weaknesses in internal controls.
  • Impacted Requirements: Failure to reconcile EBT benefits with Federal drawdowns and inadequate documentation violate compliance standards set by 2 CFR §200.303.
  • Recommended Follow-Up: ADSEF should create clear, updated reconciliation procedures and provide staff training on internal controls to enhance compliance and oversight.

Finding Text

FINDING REFERENCE NUMBER 2023-057 (See Finding Reference Number 2023-026) FEDERAL PROGRAM (ALN – 10.566) NUTRITION ASSISTANCE FOR PUERTO RICO U.S. DEPARTMENT OF AGRICULTURE AWARD NUMBERS 221PR426S7003/4; 231PR426S7003/4 (Federal Award Years: 2021 through 2023) 211PR476V1003/4 – ARPA (Federal Award Years: March 11, 2021 through September 30, 2025) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT SPECIAL TESTS & PROVISIONS – EBT RECONCILIATION TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA In accordance with Compliance Supplement and the State Plan, the EBT services provider makes payments to authorized retailers, network, third party providers, and financial institutions on behalf of the Government of Puerto Rico for benefits accessed and distributed to recipients daily. The EBT services provider is reimbursed as authorized by the Popular Bank of Puerto Rico (PBPR). Payments are recorded and compared to the Daily Activity File and Daily Payments Summary File prepared by the EBT services provider for the Department of the Family. EBT system reports provide these and other standardized computer reports as well as ad hoc access to EBT system data to perform the following key reconciliation: 1 Benefits authorized = benefits posted. 2 Benefits accessed by recipients (net EBT account debits/credits) = benefit amount transactions approved by the EBT services provider. 3 Net EBT account debits/credits = amount paid to merchants and financial institutions, “+/-” authorized adjustments. 4 Amount paid to merchants and financial institutions = funds requested by the EBT services provider, “+/-” authorized adjustments. 2 CFR §200.303 (a) establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should align with the 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). STATEMENT OF CONDITION As part of our audit of compliance with the EBT reconciliation requirements for the fiscal year ended June 30, 2023, we identified the following deficiencies: • ADSEF was unable to provide updated written reconciliation procedures or manuals. • No evidence was provided to show that EBT benefits were reconciled or matched to Federal drawdowns (SF-425 or PMS). • When asked about the assessment of SOC reports or vendor reviews, staff were unaware that such reports were required. The report was requested to EBT processor when we asked for it. Additionally, written procedure manuals were requested; however, management indicated that no such manuals were in place at the time. A procedure manual was subsequently created for January 2025, but it lacks clarity regarding specific employee roles and responsibilities. After multiple interviews, we were able to identify the area in charge of the reconciliation process, they provided with a manual from 2012, which was not updated with the data currently used. QUESTIONED COSTS No questioned costs identified. PERSPECTIVE INFORMATION This deficiency is a systemic problem, the evidence provided to support the EBT reconciliation consisted solely of the receipt of the FIN-052 report and the manual entry of its data into Excel spreadsheets, and the SOC report from EBT provider. After multiple attempts to gain a comprehensive understanding of the reconciliation process, we were able to identify the people involved in the reconciliation process and the documents used. They finally provided with a written manual procedure, but was from 2012, which does not comply with Uniform Guidance requirements and documentation actually used. STATEMENT OF CAUSE ADSEF deficiencies stem from the absence of formal updated written reconciliation procedures, inadequate internal controls over EBT operations, lack of staff training, and unclear assignment of responsibilities related to reconciliation and oversight. POSSIBLE ASSERTED EFFECT ADSEF lack of updated written reconciliation process increases the risk of undetected errors or irregularities in EBT transactions, potential misstatements in Federal financial reports, and unaccounted variances between Federal funding and benefit disbursements. It also limits the agency’s ability to monitor program performance and meet audit and compliance obligations. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS We recommend ADSEF develop and implement updated formal, written reconciliation procedures, clearly outlining roles, responsibilities, and the frequency of reconciliations. Additionally, we advise providing staff with comprehensive training on reconciliation protocols and internal control requirements to ensure consistency and compliance.

Corrective Action Plan

VIEWS OF RESPONSIBLE OFFICIALS According to the audit recommendation, it is requested that a written process for reconciling EBT Reconciliation Reports be implemented and developed. Additionally, it is recommended that staff be trained in this matter. The Finance Division will be preparing a task force to assign roles, provide training, and develop a protocol to improve processes and ensure that EBT Reports are reconciled. Manuals will be amended to establish a clearer written procedure. IMPLEMENTATION DATE During Fiscal Year 2025-2026. RESPONSIBLE PERSON Administration for Socioeconomic Development of the Family (ADSEF, by its Spanish Acronym)

Categories

Reporting Internal Control / Segregation of Duties Special Tests & Provisions Subrecipient Monitoring Cash Management Material Weakness

Other Findings in this Audit

  • 572232 2023-029
    Material Weakness
  • 572233 2023-030
    Material Weakness
  • 572234 2023-030
    Material Weakness
  • 572235 2023-030
    Material Weakness
  • 572236 2023-031
    Material Weakness
  • 572237 2023-032
    Material Weakness
  • 572238 2023-032
    Material Weakness
  • 572239 2023-032
    Material Weakness
  • 572240 2023-032
    Material Weakness
  • 572241 2023-033
    Material Weakness
  • 572242 2023-033
    Material Weakness
  • 572243 2023-034
    Material Weakness
  • 572244 2023-034
    Material Weakness
  • 572245 2023-034
    Material Weakness
  • 572246 2023-035
    Material Weakness
  • 572247 2023-035
    Material Weakness
  • 572248 2023-036
    Material Weakness Repeat
  • 572249 2023-037
    Material Weakness
  • 572250 2023-037
    Material Weakness
  • 572251 2023-037
    Material Weakness
  • 572252 2023-037
    Material Weakness
  • 572253 2023-038
    Material Weakness Repeat
  • 572254 2023-038
    Material Weakness Repeat
  • 572255 2023-039
    Material Weakness
  • 572256 2023-040
    Material Weakness
  • 572257 2023-040
    Material Weakness
  • 572258 2023-041
    Material Weakness
  • 572259 2023-042
    Material Weakness
  • 572260 2023-043
    Material Weakness
  • 572261 2023-044
    Material Weakness
  • 572262 2023-045
    Material Weakness
  • 572263 2023-046
    Material Weakness
  • 572264 2023-046
    Material Weakness
  • 572265 2023-046
    Material Weakness
  • 572266 2023-046
    Material Weakness
  • 572267 2023-046
    Material Weakness
  • 572268 2023-046
    Material Weakness
  • 572269 2023-046
    Material Weakness
  • 572270 2023-046
    Material Weakness
  • 572271 2023-046
    Material Weakness
  • 572272 2023-046
    Material Weakness
  • 572273 2023-046
    Material Weakness
  • 572274 2023-046
    Material Weakness
  • 572275 2023-046
    Material Weakness
  • 572276 2023-046
    Material Weakness
  • 572277 2023-046
    Material Weakness
  • 572278 2023-046
    Material Weakness
  • 572279 2023-047
    Material Weakness
  • 572280 2023-047
    Material Weakness
  • 572281 2023-047
    Material Weakness
  • 572282 2023-047
    Material Weakness
  • 572283 2023-047
    Material Weakness
  • 572284 2023-047
    Material Weakness
  • 572285 2023-047
    Material Weakness
  • 572286 2023-047
    Material Weakness
  • 572287 2023-047
    Material Weakness
  • 572288 2023-047
    Material Weakness
  • 572289 2023-047
    Material Weakness
  • 572290 2023-047
    Material Weakness
  • 572291 2023-047
    Material Weakness
  • 572292 2023-047
    Material Weakness
  • 572293 2023-047
    Material Weakness
  • 572294 2023-047
    Material Weakness
  • 572295 2023-048
    Material Weakness Repeat
  • 572296 2023-048
    Material Weakness Repeat
  • 572297 2023-048
    Material Weakness Repeat
  • 572298 2023-048
    Material Weakness Repeat
  • 572299 2023-048
    Material Weakness Repeat
  • 572300 2023-048
    Material Weakness Repeat
  • 572301 2023-048
    Material Weakness Repeat
  • 572302 2023-048
    Material Weakness Repeat
  • 572303 2023-048
    Material Weakness Repeat
  • 572304 2023-048
    Material Weakness Repeat
  • 572305 2023-048
    Material Weakness Repeat
  • 572306 2023-048
    Material Weakness Repeat
  • 572307 2023-048
    Material Weakness Repeat
  • 572308 2023-048
    Material Weakness Repeat
  • 572309 2023-048
    Material Weakness Repeat
  • 572310 2023-048
    Material Weakness Repeat
  • 572311 2023-049
    Material Weakness
  • 572312 2023-050
    Significant Deficiency
  • 572313 2023-050
    Significant Deficiency
  • 572314 2023-050
    Significant Deficiency
  • 572315 2023-050
    Significant Deficiency
  • 572316 2023-051
    Material Weakness
  • 572317 2023-052
    Material Weakness
  • 572318 2023-053
    Material Weakness
  • 572319 2023-054
    Material Weakness
  • 572320 2023-054
    Material Weakness
  • 572321 2023-055
    Material Weakness
  • 572322 2023-056
    Material Weakness
  • 572323 2023-056
    Material Weakness
  • 572325 2023-058
    Material Weakness Repeat
  • 572326 2023-059
    Material Weakness
  • 572327 2023-060
    Material Weakness
  • 572328 2023-061
    Material Weakness
  • 1148674 2023-029
    Material Weakness
  • 1148675 2023-030
    Material Weakness
  • 1148676 2023-030
    Material Weakness
  • 1148677 2023-030
    Material Weakness
  • 1148678 2023-031
    Material Weakness
  • 1148679 2023-032
    Material Weakness
  • 1148680 2023-032
    Material Weakness
  • 1148681 2023-032
    Material Weakness
  • 1148682 2023-032
    Material Weakness
  • 1148683 2023-033
    Material Weakness
  • 1148684 2023-033
    Material Weakness
  • 1148685 2023-034
    Material Weakness
  • 1148686 2023-034
    Material Weakness
  • 1148687 2023-034
    Material Weakness
  • 1148688 2023-035
    Material Weakness
  • 1148689 2023-035
    Material Weakness
  • 1148690 2023-036
    Material Weakness Repeat
  • 1148691 2023-037
    Material Weakness
  • 1148692 2023-037
    Material Weakness
  • 1148693 2023-037
    Material Weakness
  • 1148694 2023-037
    Material Weakness
  • 1148695 2023-038
    Material Weakness Repeat
  • 1148696 2023-038
    Material Weakness Repeat
  • 1148697 2023-039
    Material Weakness
  • 1148698 2023-040
    Material Weakness
  • 1148699 2023-040
    Material Weakness
  • 1148700 2023-041
    Material Weakness
  • 1148701 2023-042
    Material Weakness
  • 1148702 2023-043
    Material Weakness
  • 1148703 2023-044
    Material Weakness
  • 1148704 2023-045
    Material Weakness
  • 1148705 2023-046
    Material Weakness
  • 1148706 2023-046
    Material Weakness
  • 1148707 2023-046
    Material Weakness
  • 1148708 2023-046
    Material Weakness
  • 1148709 2023-046
    Material Weakness
  • 1148710 2023-046
    Material Weakness
  • 1148711 2023-046
    Material Weakness
  • 1148712 2023-046
    Material Weakness
  • 1148713 2023-046
    Material Weakness
  • 1148714 2023-046
    Material Weakness
  • 1148715 2023-046
    Material Weakness
  • 1148716 2023-046
    Material Weakness
  • 1148717 2023-046
    Material Weakness
  • 1148718 2023-046
    Material Weakness
  • 1148719 2023-046
    Material Weakness
  • 1148720 2023-046
    Material Weakness
  • 1148721 2023-047
    Material Weakness
  • 1148722 2023-047
    Material Weakness
  • 1148723 2023-047
    Material Weakness
  • 1148724 2023-047
    Material Weakness
  • 1148725 2023-047
    Material Weakness
  • 1148726 2023-047
    Material Weakness
  • 1148727 2023-047
    Material Weakness
  • 1148728 2023-047
    Material Weakness
  • 1148729 2023-047
    Material Weakness
  • 1148730 2023-047
    Material Weakness
  • 1148731 2023-047
    Material Weakness
  • 1148732 2023-047
    Material Weakness
  • 1148733 2023-047
    Material Weakness
  • 1148734 2023-047
    Material Weakness
  • 1148735 2023-047
    Material Weakness
  • 1148736 2023-047
    Material Weakness
  • 1148737 2023-048
    Material Weakness Repeat
  • 1148738 2023-048
    Material Weakness Repeat
  • 1148739 2023-048
    Material Weakness Repeat
  • 1148740 2023-048
    Material Weakness Repeat
  • 1148741 2023-048
    Material Weakness Repeat
  • 1148742 2023-048
    Material Weakness Repeat
  • 1148743 2023-048
    Material Weakness Repeat
  • 1148744 2023-048
    Material Weakness Repeat
  • 1148745 2023-048
    Material Weakness Repeat
  • 1148746 2023-048
    Material Weakness Repeat
  • 1148747 2023-048
    Material Weakness Repeat
  • 1148748 2023-048
    Material Weakness Repeat
  • 1148749 2023-048
    Material Weakness Repeat
  • 1148750 2023-048
    Material Weakness Repeat
  • 1148751 2023-048
    Material Weakness Repeat
  • 1148752 2023-048
    Material Weakness Repeat
  • 1148753 2023-049
    Material Weakness
  • 1148754 2023-050
    Significant Deficiency
  • 1148755 2023-050
    Significant Deficiency
  • 1148756 2023-050
    Significant Deficiency
  • 1148757 2023-050
    Significant Deficiency
  • 1148758 2023-051
    Material Weakness
  • 1148759 2023-052
    Material Weakness
  • 1148760 2023-053
    Material Weakness
  • 1148761 2023-054
    Material Weakness
  • 1148762 2023-054
    Material Weakness
  • 1148763 2023-055
    Material Weakness
  • 1148764 2023-056
    Material Weakness
  • 1148765 2023-056
    Material Weakness
  • 1148766 2023-057
    Material Weakness
  • 1148767 2023-058
    Material Weakness Repeat
  • 1148768 2023-059
    Material Weakness
  • 1148769 2023-060
    Material Weakness
  • 1148770 2023-061
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.542 Pandemic Ebt Food Benefits $229.88M
93.575 Child Care and Development Block Grant $198.90M
93.658 Foster Care Title IV-E $37.24M
93.560 Payments to Territories – Adults $27.38M
93.563 Child Support Services $23.08M
93.568 Low-Income Home Energy Assistance $20.27M
93.558 Temporary Assistance for Needy Families $17.71M
93.667 Social Services Block Grant $15.76M
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $13.14M
96.001 Social Security Disability Insurance $12.81M
10.566 Nutrition Assistance for Puerto Rico $8.55M
21.027 Coronavirus State and Local Fiscal Recovery Funds $7.13M
14.231 Emergency Solutions Grant Program $6.98M
93.499 Low Income Household Water Assistance Program $4.59M
10.568 Emergency Food Assistance Program (administrative Costs) $3.89M
93.356 Head Start Disaster Recovery $2.44M
93.645 Stephanie Tubbs Jones Child Welfare Services Program $2.41M
93.600 Head Start $2.15M
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $1.67M
93.434 Every Student Succeeds Act/preschool Development Grants $1.26M
93.659 Adoption Assistance $1.15M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $774,933
14.267 Continuum of Care Program $566,427
10.558 Child and Adult Care Food Program $419,729
93.590 Community-Based Child Abuse Prevention Grants $415,166
93.556 Marylee Allen Promoting Safe and Stable Families Program $376,479
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $323,306
10.569 Emergency Food Assistance Program (food Commodities) $322,542
93.747 Elder Abuse Prevention Interventions Program $263,825
10.649 Pandemic Ebt Administrative Costs $260,043
93.669 Child Abuse and Neglect State Grants $164,700
10.565 Commodity Supplemental Food Program $149,909
93.643 Children's Justice Grants to States $81,355
93.489 Child Care Disaster Relief $80,392
93.597 Grants to States for Access and Visitation Programs $58,162
93.599 Chafee Education and Training Vouchers Program (etv) $18,375