Finding 1221575 (2024-035)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-06-30

AI Summary

  • Core Issue: The PRDF failed to accurately prepare the Schedule of Expenditures of Federal Awards (SEFA), leading to significant reporting errors and delays.
  • Impacted Requirements: Compliance with 2 CFR §200.510, which mandates accurate reporting of federal awards, including detailed program expenditures and proper documentation.
  • Recommended Follow-Up: PRDF should implement procedures for timely collection, organization, and validation of data from all Administrations to ensure accurate SEFA preparation.

Finding Text

FINDING REFERENCE NUMBER 2024-035 (See Finding Reference Number 2024-014) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS TYPE OF FINDING INTERNAL CONTROL AND COMPLIANCE – MATERIAL WEAKNESS AND MATERIAL NONCOMPLIANCE CRITERIA 2 CFR §200.510 Financial Statements, (b) states that the auditee must prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee's financial statements which must include the total Federal awards expended. At a minimum, the schedule must: (1) list individual Federal Programs by Federal agency, (2) for Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included, (3) provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available, (4) Include the total amount provided to subrecipients from each Federal program, (5) for loan or loan guarantee programs identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. STATEMENT OF CONDITION During our audit procedures of the Schedule of Expenditures of Federal Awards (SEFA) prepared by the PRDF, we noted significant deficiencies related to the schedule preparation as follows: • The expenditures for some Federal programs were not accurately reported. To reconcile amounts in the SEFA with the audited financial accounts, the PRDF agree with the suggested auditor adjustments and posted them to the SEFA. • The PRDF Management does not have an adequate internal control system in place to quickly detect and accurately document the expenditures incurred under each Federal programs. This situation led to delays and errors in the preparation of the schedule and the amounts initially submitted for the SEFA. • The initial SEFA submitted for audit procedures contained the following deficiencies because of inadequate internal controls: o There are no safeguards in place to keep an accurate and comprehensive list of Notice of Agreements (NOAs). As a result, the different versions of the SEFA that were received contain incorrect and incomplete information. o Expenditures related to COVID-19 appropriations for different Federal programs were not separately disclosed in the SEFA. For ALN 14.231 the amount of $3,119,131.54 was not separately presented, in addition for ALN 93.671 the distribution between COVID and regular funds was incorrectly presented by $2,075,855.34. o For ALN 93.558 expenditures were included that do not correspond to the program as follows: a total amount of $20,364,480 of programs expenditures correspond to ALN 93.560 and a total amount of $9,140,245.62 corresponds to ALN 93.667. The incorrect presentation of these amounts could affect the correct identification of the programs as Type A and Type B for major program determination. o For ALN 93.671 a total amount of $712,602.44 were included as program expenditure but those expenditures correspond to ALN 93.497. o During the fiscal year, reimbursements of expenses incurred related to ALN 97.036 were received in the amount of $2,828,481.01; however, for the initial SEFA submitted, no validation was performed on the amount of expenses of those reimbursements that should be included in the schedule. After the validation is completed, all the amounts should be included in the schedule as expenditure. PERSPECTIVE INFORMATION This is a systemic deficiency. The PRDF was unable to provide an accurate Schedule of Expenditures of Federal Awards (SEFA), and related supporting documentation in order to apply required audit procedures. The PRDF is composed of five (5) Administrations that manage federal funds. The Office of Secretariat is responsible for coordinating the work of the administrations, but there are no established procedures for coordinating the collection of information when preparing the SEFA for audit purposes. STATEMENT OF CAUSE The PRDF does not have an adequate procedure established to collect, organize, and validate the information necessary for the preparation of the SEFA in accordance with Federal regulations. POSSIBLE ASSERTED EFFECT The PRDF may fail to include all Federal programs and total expenditures in the SEFA causing misstatements in the SEFA submitted to Auditors. It also leads to inaccurate Major Program Determination multiple times made by the auditors because of the different versions of the SEFA submitted, affecting the execution of the Single Audit in a reasonable time. IDENTIFICATION OF REPEAT FINDING This is a repeat of a finding reported in the prior audit as Finding Numbers 2023-019/2023-047. RECOMMENDATIONS We recommend the PRDF establish adequate procedures to coordinate the collection, organization, and validation of the required information to prepare the SEFA from each of the Administrations in a timely manner to ensure that all Federal programs/transactions are properly recorded and included in the schedule.

Corrective Action Plan

VIEWS OF RESPONSIBLE OFFICIALS To resolve this finding, the Government of Puerto Rico is transitioning to a new Enterprise Resource Planning (ERP) system. This new government-wide financial system is scheduled for a live launch in July 2026. This modern platform will provide the PRDF with the capability to produce all required SEFA preparation for Single Audits in a more agile and reliable manner. By streamlining data collection and fiscal reporting, this system will ensure that the Department meets all federal audit requirements on time. IMPLEMENTATION DATE During Fiscal Year 2026-2027 RESPONSIBLE PERSON Yessenia Peña Díaz Assistance Secretary of Administration

Categories

Reporting Subrecipient Monitoring

Other Findings in this Audit

  • 1221540 2024-020
    Material Weakness Repeat
  • 1221541 2024-021
    Material Weakness Repeat
  • 1221542 2024-022
    Material Weakness Repeat
  • 1221543 2024-023
    Material Weakness Repeat
  • 1221544 2024-023
    Material Weakness Repeat
  • 1221545 2024-023
    Material Weakness Repeat
  • 1221546 2024-023
    Material Weakness Repeat
  • 1221547 2024-024
    Material Weakness Repeat
  • 1221548 2024-024
    Material Weakness Repeat
  • 1221549 2024-025
    Material Weakness Repeat
  • 1221550 2024-025
    Material Weakness Repeat
  • 1221551 2024-026
    Material Weakness Repeat
  • 1221552 2024-027
    Material Weakness Repeat
  • 1221553 2024-028
    Material Weakness Repeat
  • 1221554 2024-029
    Material Weakness Repeat
  • 1221555 2024-030
    Material Weakness Repeat
  • 1221556 2024-030
    Material Weakness Repeat
  • 1221557 2024-030
    Material Weakness Repeat
  • 1221558 2024-030
    Material Weakness Repeat
  • 1221559 2024-031
    Material Weakness Repeat
  • 1221560 2024-032
    Material Weakness Repeat
  • 1221561 2024-033
    Material Weakness Repeat
  • 1221562 2024-034
    Material Weakness Repeat
  • 1221563 2024-035
    Material Weakness Repeat
  • 1221564 2024-035
    Material Weakness Repeat
  • 1221565 2024-035
    Material Weakness Repeat
  • 1221566 2024-035
    Material Weakness Repeat
  • 1221567 2024-035
    Material Weakness Repeat
  • 1221568 2024-035
    Material Weakness Repeat
  • 1221569 2024-035
    Material Weakness Repeat
  • 1221570 2024-035
    Material Weakness Repeat
  • 1221571 2024-035
    Material Weakness Repeat
  • 1221572 2024-035
    Material Weakness Repeat
  • 1221573 2024-035
    Material Weakness Repeat
  • 1221574 2024-035
    Material Weakness Repeat
  • 1221576 2024-036
    Material Weakness Repeat
  • 1221577 2024-036
    Material Weakness Repeat
  • 1221578 2024-036
    Material Weakness Repeat
  • 1221579 2024-036
    Material Weakness Repeat
  • 1221580 2024-036
    Material Weakness Repeat
  • 1221581 2024-036
    Material Weakness Repeat
  • 1221582 2024-036
    Material Weakness Repeat
  • 1221583 2024-036
    Material Weakness Repeat
  • 1221584 2024-036
    Material Weakness Repeat
  • 1221585 2024-036
    Material Weakness Repeat
  • 1221586 2024-036
    Material Weakness Repeat
  • 1221587 2024-036
    Material Weakness Repeat
  • 1221588 2024-036
    Material Weakness Repeat
  • 1221589 2024-037
    Material Weakness Repeat
  • 1221590 2024-038
    Material Weakness Repeat
  • 1221591 2024-038
    Material Weakness Repeat
  • 1221592 2024-038
    Material Weakness Repeat
  • 1221593 2024-038
    Material Weakness Repeat
  • 1221594 2024-039
    Material Weakness Repeat
  • 1221595 2024-040
    Material Weakness Repeat
  • 1221596 2024-041
    Material Weakness Repeat
  • 1221597 2024-042
    Material Weakness Repeat
  • 1221598 2024-043
    Material Weakness Repeat
  • 1221599 2024-044
    Material Weakness Repeat
  • 1221600 2024-044
    Material Weakness Repeat
  • 1221601 2024-045
    Material Weakness Repeat
  • 1221602 2024-046
    Material Weakness Repeat
  • 1221603 2024-046
    Material Weakness Repeat
  • 1221604 2024-047
    Material Weakness Repeat
  • 1221605 2024-048
    Material Weakness Repeat
  • 1221606 2024-048
    Material Weakness Repeat
  • 1221607 2024-048
    Material Weakness Repeat
  • 1221608 2024-049
    Material Weakness Repeat
  • 1221609 2024-050
    Material Weakness Repeat
  • 1221610 2024-051
    Material Weakness Repeat
  • 1221611 2024-052
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $92.49M
93.596 CHILD CARE MANDATORY AND MATCHING FUNDS OF THE CHILD CARE AND DEVELOPMENT FUND $56.25M
93.658 FOSTER CARE TITLE IV-E $52.54M
93.568 LOW-INCOME HOME ENERGY ASSISTANCE $30.11M
10.542 PANDEMIC EBT FOOD BENEFITS $29.17M
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $28.11M
93.560 PAYMENTS TO TERRITORIES €“ ADULTS $26.26M
93.563 CHILD SUPPORT SERVICES $25.32M
93.667 SOCIAL SERVICES BLOCK GRANT $17.75M
96.001 SOCIAL SECURITY DISABILITY INSURANCE $13.48M
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $6.43M
93.659 ADOPTION ASSISTANCE $4.37M
10.568 EMERGENCY FOOD ASSISTANCE PROGRAM (ADMINISTRATIVE COSTS) $4.35M
93.556 MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES PROGRAM $3.38M
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $3.12M
93.645 STEPHANIE TUBBS JONES CHILD WELFARE SERVICES PROGRAM $3.02M
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $2.87M
93.671 FAMILY VIOLENCE PREVENTION AND SERVICES/DOMESTIC VIOLENCE SHELTER AND SUPPORTIVE SERVICES $2.36M
93.356 HEAD START DISASTER RECOVERY $1.81M
93.747 ELDER ABUSE PREVENTION INTERVENTIONS PROGRAM $1.30M
93.434 EVERY STUDENT SUCCEEDS ACT/PRESCHOOL DEVELOPMENT GRANTS $1.24M
93.600 HEAD START $941,560
93.590 COMMUNITY-BASED CHILD ABUSE PREVENTION GRANTS $829,081
93.497 FAMILY VIOLENCE PREVENTION AND SERVICES/ SEXUAL ASSAULT/RAPE CRISIS SERVICES AND SUPPORTS $712,602
93.090 GUARDIANSHIP ASSISTANCE $691,532
10.566 NUTRITION ASSISTANCE FOR PUERTO RICO $686,567
93.674 JOHN H. CHAFEE FOSTER CARE PROGRAM FOR SUCCESSFUL TRANSITION TO ADULTHOOD $656,571
10.565 COMMODITY SUPPLEMENTAL FOOD PROGRAM $628,994
93.669 CHILD ABUSE AND NEGLECT STATE GRANTS $492,642
10.558 CHILD AND ADULT CARE FOOD PROGRAM $467,546
10.649 PANDEMIC EBT ADMINISTRATIVE COSTS $364,443
93.643 CHILDREN'S JUSTICE GRANTS TO STATES $300,072
14.267 CONTINUUM OF CARE PROGRAM $299,310
93.499 LOW INCOME HOUSEHOLD WATER ASSISTANCE PROGRAM $295,355
93.599 CHAFEE EDUCATION AND TRAINING VOUCHERS PROGRAM (ETV) $172,527
93.489 CHILD CARE DISASTER RELIEF $102,530
93.597 GRANTS TO STATES FOR ACCESS AND VISITATION PROGRAMS $18,065