Finding 572276 (2023-046)

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

AI Summary

  • Core Issue: The PRDF lacks adequate internal controls for financial reporting, leading to significant errors in federal expenditure reporting.
  • Impacted Requirements: Compliance with 2 CFR Part 200 and 45 CFR Part 75 is compromised, particularly in financial management, accurate reporting, and record-keeping.
  • Recommended Follow-Up: Implement robust internal controls, establish uniform policies across departments, and conduct regular reconciliations to ensure accurate financial reporting.

Finding Text

FINDING REFERENCE NUMBER 2023-046 (See Finding Reference Number 2023-018) FEDERAL PROGRAM ALL FEDERAL PROGRAMS ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AWARD NUMBER ALL AWARDS COMPLIANCE REQUIREMENT REPORTING – FINANCIAL STATEMENT ACCOUNTING RECORDS TYPE OF FINDING MATERIAL NONCOMPLIANCE AND MATERIAL WEAKNESS CRITERIA 2 CFR Part 200, Section 302 and 45 CFR Part 75, Section 302- Financial management and standards for financial management systems state 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. (b) The recipient's and subrecipient's financial management system must provide for the following: (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. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 200.305. (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 Internal controls for creating financial reports about state and Federal funds received and spent through the Puerto Rico Integrated Financial System (PRIFAS) have not been put in place by the PRDF. The PRDF lacks an adequate system of internal controls to stop, identify, and fix errors. There was no supervision or review procedure in place to identify and allow for the correction of errors before submission and before the financial data was entered into PRIFAS. There was a delay in getting timely and correct financial information for the year under audit, and the PRDF staff had difficulties preparing and presenting the cash receipt and disbursement report, which included the schedule of federal spending for the audit. The following weaknesses were discovered when the PRDF's initial Financial Statement was reviewed: • Transactions that weren't related to the fiscal year being reported were included in the initial financial data. • The Office of the Secretariat and the four Programmatic Administrations lack uniform policies and procedures to guarantee that the amounts and disclosures in the PRDF's financial reports, financial statement notes, and necessary supplemental information are correctly recognized and reported. • Reports for several significant programs were prepared informally and, in some instances, only by one person, which resulted in significant mistakes in some of the programs. As a result, errors in the reports across the programs were not investigated or fixed. Additionally, we saw that for various financial reports, the PRIFAS data was not considered in the reconciliation process. • Several significant transactions were not entered into the PRIFAS by the Administration for Families and Children (ADFAN, by its Spanish Acronym) Finance Department, they were recorded as encumbrances, and not actual expenditures. This led to an understatement of expenditures in the PRDF's general fund of about $52,300,494. Additionally, Federal spending in one of the major programs was understated by $6,886,156. PERSPECTIVE INFORMATION The PRDF failed to properly registered in its accounting system all transactions needed to prepared the financial statement and to produce accurate financial reports for Federal grants that they received and expended during the fiscal year. No reconciliation procedures are performed regularly to identified errors in recording transactions in PRIFAS. This cause that when the PRDF prepared cash received and disbursement financial statement and the SEFA for audit purposes was incomplete and misstated (see Finding Reference Number 2023-017). STATEMENT OF CAUSE To make sure that all the PRDF's transactions had been accurately documented and reported, the PRDF did not thoroughly examine the financial data that was created and submitted in PRIFAS and used to prepare the financial statement and supplementary information. Due to lack of supervision or a review procedure to identify errors prior to submission, the ADFAN Finance Director recorded transactions as encumbrances, instead of actual expenditures. POSSIBLE ASSERTED EFFECT The PRDF is unable to provide accurate, up-to-date, and comprehensive disclosure of state and Federal funds activities in compliance with the agreement's requirements due to inadequate and inconsistent financial accounting reporting methods. IDENTIFICATION OF REPEAT FINDING No reported as prior audit finding. RECOMMENDATIONS To comply with the requirements of state and local agreements and enable the PRDF to monitor trustworthy financial data for use within the agency and for upcoming audits, we recommend the PRDF update its accounting practices and policies to provide for an accurate, comprehensive, and timely financial reporting system. Implementing an accounting and financial management system that enables the creation of financial data and reports needed by the various oversight organizations. The process should involve defining precise procedures for the creation and evaluation of financial reports, with different roles allocated to various people.

Categories

Reporting Subrecipient Monitoring Internal Control / Segregation of Duties

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
  • 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
  • 572324 2023-057
    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