Finding 1166956 (2024-003)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-12-30

AI Summary

  • Core Issue: The Bureau did not properly record and report $10,017,388 in federal program expenditures on the Schedule of Expenditures of Federal Awards (SEFA), leading to incomplete and misstated financial statements.
  • Impacted Requirements: Compliance with 2 CFR §200.510 was not met, as the SEFA lacked necessary details about federal awards, including expenditures and fund transfers.
  • Recommended Follow-Up: The Bureau should enhance record-keeping and controls for federal programs, ensure timely sharing of award information, and conduct regular fiscal monitoring to accurately reflect all transactions in future SEFAs.

Finding Text

FINDING REFERENCE NUMBER 2024-003 (See FINDING REFERENCE NUMBER 2024-001) FEDERAL PROGRAMS 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 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 Federal programs revenues, we identified significant cash receipts for the Disaster Grants – Public Assistance related to reimbursements of payroll and overtime payments previously paid by Bureau state funds. However, we could not identify any expenditures register under the Federal program on Schedule of Expenditures of Federal Awards (SEFA) during the current fiscal year or any prior fiscal year related to the reimbursements received. To include the expenditures as Federal program expenditures, the Bureau staff must recognize fund transfers from the Federal program accounts to state funds accounts by preparing the related journal entries which effectively records the expenditure amounts on the SEFA. As discussed with management, the fund transfers were not made during the fiscal year 2024-2025 nor have any adjustment been registered to recognize the Federal expenditures incurred. The total amount received and expended was $10,017,388. We requested the fund transfers and related entries information if those were performed after the fiscal year end, but as of the date of our audit, no transfers or adjustments had been made. After the condition was identified and discussed with the Bureau management, the corresponding adjustments to correct record the transfers and related expenditures on the Federal program were performed and provided to us to correct the amounts related to the program reported in the SEFA and financial statement as of June 30, 2024. QUESTIONED COSTS None PERSPECTIVE INFORMATION The Bureau failed to identify properly in its records and/or accounting records Federal grants funds that they received and expended during the fiscal year. This cause that when Bureau prepared the SEFA and financial statement for audit purposes the SEFA was incomplete and misstated. Also, this condition has limited the use of the reimburse funds on other operating activities of the Bureau. STATEMENT OF CAUSE The Bureau budget and finance staff failed to identify the Federal program receipts and performed the fund transfers and related journal entries on a timely manner to be included on the correct fiscal year, causing the preparation of an incomplete and misstated financial statement and SEFA initially submitted for audit purposes. POSSIBLE ASSERTED EFFECT The Bureau fail to include all Federal programs expenditures in the SEFA causing misstatements in the SEFA, which may lead to errors in the determination if a Uniform Guidance audit is required to the Bureau and could provoke an incorrect Major Program Determination by the auditors, resulting in the most likely exclusion of a Major Program for audit purpose. Also, since the original expenditures were paid with state funds and the funds received shall be reimbursed to the Bureau state funds accounts, the funds have been idle for a long period of time, limiting the potential use of the funds by the Bureau on operating needs for more than two years. IDENTIFICATION OF REPEAT FINDING Not applicable. RECOMMENDATIONS We recommend the Bureau budget and finance staff to maintain adequate records and controls related to the Federal programs in order to properly identify the Federal programs/transactions when the SEFA is prepared. Once a Federal award is granted or received, the information must be shared with all personnel involved in the financial statement and the SEFA preparation to provide assurance that all require program activities / expenditures are included on the SEFA. In addition, the Bureau must perform a regular fiscal monitoring over the Federal programs transactions in order to provide reasonable assurance that all Federal programs/transactions are properly recorded and included in the SEFA and if any reimbursements to state funds are applicable, that those reimbursements are made on a timely basis.

Corrective Action Plan

VIEWS OF RESPONSIBLE OFFICIALS As part of the Corrective Action Plan to address the identified findings, the following measures will be implemented: • For the preparation of the SEFA, all accounts related to disaster funds will be included, considering that these accounts were segregated into revenues and expenses by the Department of the Treasury. Both categories will be properly incorporated into the SEFA preparation process. • Federal reimbursements received will be immediately identified, and the corresponding journal entries will be prepared without delay to accurately reflect the associated expenses. • Journal entries related to the reimbursement received will be prepared, and the expenses will be recorded in the appropriate accounting accounts, ensuring proper classification and compliance with federal requirements. • We are currently in the process of drafting the corresponding administrative order, for which a preliminary draft has already been prepared. This document aims to clearly and systematically establish the necessary processes and procedures, including those related to the identified deficiencies, to ensure the implementation of enhanced controls that guarantee regulatory compliance and operational efficiency. • Responsible personnel will be retrained on the processes and requirements applicable to SEFA preparation, in order to strengthen compliance and accuracy in reporting. • A fiscal section within the Office of Federal Affairs will be established to manage the fiscal process of federal funds. This structure will ensure that all transactions, corrections, and journal entries are recorded in a timely and accurate manner in the federal accounting accounts. IMPLEMENTATION DATE Fiscal Year 2025-2026 RESPONSIBLE PERSON Maritza Torres López

Categories

Subrecipient Monitoring Reporting

Other Findings in this Audit

  • 1166955 2024-003
    Material Weakness Repeat
  • 1166957 2024-004
    Material Weakness Repeat
  • 1166958 2024-004
    Material Weakness Repeat
  • 1166959 2024-005
    Material Weakness Repeat
  • 1166960 2024-005
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $11.48M
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $2.12M
21.016 EQUITABLE SHARING $590,318
16.588 VIOLENCE AGAINST WOMEN FORMULA GRANTS $290,968
97.067 HOMELAND SECURITY GRANT PROGRAM $221,783
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $143,532
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $96,710
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $37,555
16.922 EQUITABLE SHARING PROGRAM $4,367
16.575 CRIME VICTIM ASSISTANCE $1,300