Finding 1221603 (2024-046)

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

AI Summary

  • Core Issue: There are significant inaccuracies and lack of support in financial reporting for TANF and PTTA programs, affecting compliance with federal requirements.
  • Impacted Requirements: The financial management system must accurately track and report expenditures, maintain supporting documentation, and ensure timely submissions as per 2 CFR 200 guidelines.
  • Recommended Follow-Up: Implement stronger internal controls and procedures to segregate duties, reconcile financial records, and ensure timely and accurate reporting to prevent future discrepancies.

Finding Text

FINDING REFERENCE NUMBER 2024-046 (See Finding Reference Number 2024-018) FEDERAL PROGRAMS (ALN – 93.558) TEMPORARY ASSISTANCE FOR NEEDY FAMILIES (TANF) (ALN – 93.560) PAYMENT TO TERRITORIES – ADULT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 2022G996117 (Federal Award Year: 10/1/2021 – 9/30/2022) 2023G996117 (Federal Award Year: 10/1/2022 – 9/30/2023) 2022G9922PT (Federal Award Years: 10/1/2022 through 9/30/2025) 2301PRTABD (Federal Award Years: 10/1/2023 through 9/30/2026) ADMINISTRATION ADMINISTRATION FOR SOCIOECONOMIC DEVELOPMENT OF THE FAMILY (ADSEF, BY ITS SPANISH ACRONYM) COMPLIANCE REQUIREMENT REPORTING – FINANCIAL REPORTING TYPE OF FINDING INTERNAL CONTROL AND COMPLIANCE – MATERIAL WEAKNESS AND MATERIAL NONCOMPLIANCE CRITERIA The 2 CFR 200 §200.302, Financial Management, establishes that: “(a) Each State must expend and account for the Federal award in accordance with State laws and procedures for expending and accounting for the State's funds. All recipient and subrecipient financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by the terms and conditions; and tracking expenditures to establish that funds have been used in accordance with Federal statutes, regulations, and the terms and conditions of the Federal award. See § 200.450. (b) The recipient's and subrecipient's financial management system must provide for the following (see §§ 200.334, 200.335, 200.336, and 200.337): (1) Identification of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number, year the Federal award was issued, and name of the Federal agency or pass-through entity. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements in §§ 200.328 and 200.329. When a Federal agency or pass-through entity requires reporting on an accrual basis from a recipient or subrecipient that maintains its records other than on an accrual basis, the recipient or subrecipient must not be required to establish an accrual accounting system. This recipient or subrecipient may develop accrual data for its reports based on an analysis of the documentation on hand. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. (4) Effective control over and accountability for all funds, property, and assets. The recipient or subrecipient must safeguard all assets and ensure they are used solely for authorized purposes. See § 200.303. … (6) Written procedures to implement the requirements of § 200.305 and (7) Written procedures for determining the allowability of costs in accordance with subpart E and the terms and conditions of the Federal award. STATEMENT OF CONDITION As part of our audit procedures over the reporting requirements for the Temporary Assistance for Needy Families (TANF) and Payment to Territories – Adult (PTTA) programs, we reviewed two ACF-196TR reports submitted during the fiscal year under audit. Our review disclosed deficiencies related to the accuracy, support, reconciliation, and timeliness of reported expenditures. Specifically, we noted the following: • Administrative expenditures for both TANF and PTTA are recorded under the same accounting account number and Assistance Listing Number associated with TANF. As a result, the PRIFA accounting system does not segregate administrative expenditures by federal award or Assistance Listing Number, limiting the ability to identify and track expenditures attributable to each program. • Amounts reported in the ACF-196TR reports could not be reconciled to the PRIFA accounting records, particularly for administrative expenditures. Upon request, management was unable to provide supporting schedules, reconciliations, or documentation demonstrating how the reported amounts were derived. Supporting information was prepared only after it was requested during the audit. • For grant award 2023G996117, reported expenditures in the quarterly report of September 30, 2023, that did not agree with the underlying accounting records. We identified differences of $7,266.40 in Line 6A (Work-Related Activities and Expenses), $1,745,668.00 in Line 5A (Basic Assistance), $1,645,366.55 in Line 6J (Administration), $2,007,611.62 in Line 3 (Transfer to SSBG), and $103,052.41 in Line 10 (Total Expenditures). In addition, the report was submitted after the applicable due date. • For grant award 2401PRTANF, reported expenditures in the June 30, 2024 quarterly report that also differed from the accounting records. We identified differences of $12,312.07 in Line 6A (Work-Related Activities and Expenses), $1,898,639.95 in Line 6J (Administration), $3,786,696.14 in Line 3 (Transfer to SSBG), and $1,902,297.08 in Line 10 (Total Expenditures). Furthermore, the report maintained by ADSEF did not contain evidence of the submission date; therefore, we were unable to determine whether the report was submitted within the required timeframe. QUESTIONED COSTS None. PERSPECTIVE INFORMATION This is a systematic deficiency. Procedures and internal controls manuals should provide for and ensure the segregation of duties, and the reconciliation of financial information reported to Federal agencies against the accounting records used to prepare financial statements and SEFA. In addition, the financial management system should provide to account separately the administrative expenditures incurred among all Federal programs administered. ADSEF failure to support reported amounts with verifiable documentation and the absence of independent review increases the risk of inaccurate or misstated financial data being reported to the Federal awarding agency. STATEMENT OF CAUSE During our interviews and understanding of the internal controls over financial reporting, we noted that only one person prepares, submits and certifies the ACF-196TR reports. No proper segregation of duties exists, that allows for validation of all accounting data before submitting the reports. In addition, the procedures manual for preparing reports does not establish a clear process for obtaining information, validating it, recording it, preparing it, and reporting it, as well as the responsibilities and segregation of duties to ensure that the reported information is consistent with ADSEF's accounting records. PRIFAS accounting data base as configured, does not provide for the administrative expenditures incurred from the TANF and Payment to Territories – Adult programs to be segregated. ADSEF lacks internal controls that allow for the timely validation and reconciliation of financial information. Furthermore, they lack a written procedures manual detailing the processes to follow in obtaining accounting data and reporting it to the Federal government, ensuring that the responsibility does not fall on a single individual. POSSIBLE ASSERTED EFFECT ADSEF does not ensure that the reports are accurate and traceable to the accounting database used to prepare their financial reports to the Federal Agencies and their financial statement. IDENTIFICATION OF REPEAT FINDING This is a repeat of a finding reported in the prior audit as Finding Numbers is 2023-025/2023-056. RECOMMENDATIONS We recommend ADSEF to establish written procedures and internal controls manuals to provide and document the segregation of duties related to the reporting compliance requirement. Additionally, work with the Puerto Rico Department of the Treasury to provide accounting records to segregate the administrative expenditures of both programs.

Corrective Action Plan

VIEWS OF RESPONSIBLE OFFICIALS We are resolving these deficiencies by leveraging the new Government ERP system, scheduled for launch in July 2026. This platform will provide the essential functionality to properly configure our Chart of Accounts, ensuring that all TANF and PTTA administrative expenditures are automatically segregated by federal award and Assistance Listing Number (ALN). This system will be the foundation for accurate, traceable, and reconcilable financial reporting, supported by robust internal controls and multi-level supervisory oversight. Action Steps: 1. ERP Chart of Accounts Configuration – Configure the ERP system with a granular Chart of Accounts that strictly segregates TANF and PTTA administrative expenditures, ensuring every transaction is coded to the correct federal grant and ALN. 2. Automated Reporting Workflow – Utilize the ERP's financial reporting modules to generate ACF-196TR reports directly from the General Ledger, ensuring reported expenditures are 100% traceable to source transactions. 3. Digital Reconciliation Workpaper – Require the ERP to generate an automated "Reconciliation Package" for every ACF-196TR submission, which links reported line items directly to General Ledger accounts, eliminating discrepancies. 4. Staff Training & ERP Stabilization – Execute comprehensive training for all finance staff on the new ERP accounting structure, reconciliation modules, and federal reporting requirements, ensuring the system is utilized for full audit compliance. IMPLEMENTATION DATE During Fiscal Year 2026-2027 RESPONSIBLE PERSON Eddie J. Burgos Auxiliary Administrator for Finance and Budget Carlos Martinez Colón Finance Director Vanessa Ayala Gerena Director of Budget

Categories

Subrecipient Monitoring Reporting Internal Control / Segregation of Duties Material Weakness

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
  • 1221575 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
  • 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