FAC Explorer

Finding 1224430 (2023-029)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2026-07-22
Audit: 407734
Organization: Commonwealth of the Northern Mariana Islands (MP)
Auditor: ERNST & YOUNG (CNMI) INC

AI Summary

  • Core Issue: CNMI failed to submit all required quarterly reports for the Emergency Rental Assistance Program, leading to noncompliance with federal reporting requirements.
  • Impacted Requirements: All eight quarterly SF-425 financial reports and half of the ERA 1 performance reports were not provided, indicating a lack of adequate monitoring and documentation controls.
  • Recommended Follow-Up: CNMI should enhance compliance measures and establish a systematic filing system to ensure timely and accurate reporting in the future.

Finding Text

Finding No. 2023-029 Federal Agency: U.S. Department of the Treasury AL Program: COVID-19 21.023 Emergency Rental Assistance Program Federal Award No.: 20010001/000021, ERAE0528 Area: Reporting Questioned Costs: $-0- Criteria: In accordance with the Emergency Rental Assistance (ERA) program reporting guidance Version 3.4, all ERA 1 and ERA 2 Recipients (State, Local, and Territorial Recipients and all Tribe, TDHE, and the DHHL Recipients) must submit the Federal Financial Report, Standard Form 425 (SF-425) and the ERA 1 and ERA 2 Performance Reports (1505-0266 for ERA 1 and 1505-0270 for ERA 2), on a quarterly basis and a final report. Recipients must provide all required reports on each ERA 1 and ERA 2 award separately. Condition: 1. Of eight quarterly SF-425 federal financial reports for ERA 1 and ERA 2 grant awards that were due for submission during FY2023, all eight (or 100%) quarterly reports for the following reporting periods were not provided. 2. Of eight quarterly performance reports for ERA 1 and ERA 2 grant awards that were due for submission during FY2023, the following were noted: a. For four (or 50%), ERA 1 performance reports for the following reporting periods were not provided: Finding No. 2023-029, continued Federal Agency: U.S. Department of the Treasury AL Program: COVID-19 21.023 Emergency Rental Assistance Program Federal Award No.: 20010001/000021, ERAE0528 Area: Reporting Questioned Costs: $-0- Condition, continued: b. For one (or 13%), the ERA 2 performance report for the quarter ended 09/30/22 reporting period was not provided. c. For three (or 38%), underlying accounting records supporting the narratives reported on ERA 2 performance reports for the following reporting periods, were not provided. Cause: CNMI lacks monitoring controls over adequate documentation and systematic filing of relevant documentation supporting the program’s reporting compliance requirements. Effect or Potential Effect: CNMI is in noncompliance with applicable reporting compliance requirements. No questioned costs are presented as the noncompliance is non-monetary in nature. Identification as a Repeat Finding: Finding No. 2022-025 Recommendation: CNMI should strengthen and enforce compliance with the applicable reporting requirements and implement and establish systematic filing of relevant documentation for easy retrieval. Finding No. 2023-029, continued Federal Agency: U.S. Department of the Treasury AL Program: COVID-19 21.023 Emergency Rental Assistance Program Federal Award No.: 20010001/000021, ERAE0528 Area: Reporting Questioned Costs: $-0- Views of Responsible Officials: Condition 1 - Office of Grants Management (OGM) respectfully disagrees with this finding. The Office believes that it was difficult to submit accurate financial reports because expenses and final totals kept shifting with the transition of the CNMI financial management system from JD Edwards to Tyler-Munis. In addition, checks were being cancelled or returned by landlords because tenants were opting to move to better living conditions, making the financial figures fluctuate each month. OGM mentioned to EY of these movements in expenses and the shifts in the SF-425. It was only months after the closing of the fiscal year whereby the expenses stabilized. As such, OGM should not be penalized for the difference in the SF-425. OGM did provide the narrative report to EY for that reporting period. Furthermore, the Department of Finance had the responsibility in reporting of this program’s activities. OGM did not have access to the U.S. Department of the Treasury portal. This further made it more difficult to catch up with the reporting of items. Subsequently, U.S. Department of the Treasury started requesting for different metrics or evidence to which our office was not prepared because we were operating under a set of understood deliverables, making it again difficult to report succinctly and accurately for the program. OGM was tasked by the former Governor last minute to handle this program because the state housing program did not want to manage this emergency rental assistance program due to the overload in workload brought on by the CDBG-Disaster program. Furthermore, OGM did provide EY with complete listing of expenses that matched the FMIS generated ending fund balance for this business unit. Regarding ERA1, U.S, Department of the Treasury accepted the full report inclusive of SF-425. For ERA2, a final report has been provided and is under full review. Condition 2a - OGM disagrees with this finding. For ERA1 reports, U.S. Department of the Treasury has accepted the final report and has closed all matters pertaining to this grant and this is substantiated by the return of funds amounting to $1,746.41. As noted, reports are very difficult to generate without full access to real-time data and the lack of software. The immense load and pressure to execute welfare assistance can be very overwhelming. OGM asks that this finding be removed as all reports have been accepted by U.S. Department of the Treasury for ERA 1. Condition 2b - OGM disagrees with this finding. For ERA 2, reports are very difficult to generate without full access to real-time data and the lack of software. The immense load and pressure to execute welfare assistance can be very overwhelming. Finding No. 2023-029, continued Federal Agency: U.S. Department of the Treasury AL Program: COVID-19 21.023 Emergency Rental Assistance Program Federal Award No.: 20010001/000021, ERAE0528 Area: Reporting Questioned Costs: $-0- Views of Responsible Officials, continued: Condition 2c - OGM disagrees with this finding. OGM believes this condition is substantially related to the reporting concerns identified under Condition 2b and reflects the same underlying reporting and documentation challenges. Because the supporting accounting records and narrative reporting requirements are interconnected, the Office respectfully requests consideration of consolidating this condition with Condition 2b to avoid duplication of findings addressing the same underlying issue. Refer to CNMI’s Corrective Action Plan for additional information. Auditor Response: Conditions 1, 2a, 2b, and 2c - While OGM provided an explanation of the challenges on the submission of the quarterly SF-425 and performance reports, the quarterly reports and/or underlying accounting records were not provided. Accordingly, we were unable to test the accuracy of any amounts and/or data reported. Further, Conditions 2b and 2c are two separate compliance findings. Findings are retained as amounts and/or data reported, were not supported by adequate documentation.

Corrective Action Plan

Finding No.: 2023-029, continued AL Program: COVID-19 21.023 – Emergency Rental Assistance Program Area: Reporting Questioned Costs: $-0- Contact Person(s): Epiphanio Cabrera, Jr., Grants Administrator, OGM-SC Corrective Action Plan: months after the closing of the fiscal year whereby the expenses stabilized. As such, OGM should not be penalized for the difference in the SF425. OGM did provide the narrative report to EY for that reporting period. Furthermore, the Department of Finance had the responsibility in reporting of this program’s activities; OGM did not have access to the US Treasury portal. This further made it more difficult to catch-up with the reporting of items. Subsequently, US Treasury started requesting for different metrics or evidence to which our office was not prepared because we were operating under a set of understood deliverables, making it again difficult to report succinctly and accurately for the program. OGM was tasked by the former Governor last minute to handle this program because the state housing program did not want to manage this emergency rental assistance program due to the overload in workload brought on by the CDBG-Disaster program. Furthermore, OGM did provide EY with complete listing of expenses that matched the FMIS generated ending fund balance for this business unit. Regarding ERA1, US Treasury accepted the full report inclusive of SF425. For ERA2, a final report has been provided and is under full review. OGM will need to hire more financial analysts to meet the increased demand from programs such as CCERA-type programs. Furthermore, US Treasury has closed and accepted ERA1 reports. CCERA did return $1,746.41, inclusive of 5% interest to US Treasury under invoice # OCAERA0411A under the Collect Delinquent Indebtedness. Proposed Completion Date: Ongoing Condition 2a: The Office of Grants Management (OGM) disagrees with this finding. For ERA1 reports, US Treasury has accepted the final report and has closed all matters pertaining to this grant and this is substantiated by the return of funds amounting to $1,746.41. As noted, reports are very difficult to generate without full access to real-time data and the lack of software. The immense load and pressure to execute welfare assistance can be very overwhelming. I ask that this finding be removed as all reports have been accepted by US Treasury for ERA 1. Proposed Completion Date: Ongoing Finding No.: 2023-029, continued AL Program: COVID-19 21.023 – Emergency Rental Assistance Program Area: Reporting Questioned Costs: $-0- Contact Person(s): Epiphanio Cabrera, Jr., Grants Administrator, OGM-SC Corrective Action Plan: Condition 2b: The Office of Grants Management (OGM) disagrees with this finding. For ERA 2, reports are very difficult to generate without full access to real-time data and the lack of software. The immense load and pressure to execute welfare assistance can be very overwhelming. OGM will need to hire more financial analysts in the future to meet the increased demand from programs such as CCERA-type programs. Additional monitoring controls and systematic filing will need to exist in the future related work to improve reporting requirements. Proposed Completion Date: Ongoing Condition 2c: The Office of Grants Management (OGM) disagrees with this finding. We believe this condition is substantially related to the reporting concerns identified under Condition 2b and reflects the same underlying reporting and documentation challenges. Because the supporting accounting records and narrative reporting requirements are interconnected, the Office respectfully requests consideration of consolidating this condition with Condition 2b to avoid duplication of findings addressing the same underlying issue. Proposed Completion Date: Ongoing

Categories

Reporting

Other Findings in this Audit

  • 1224392 2023-010
    Material Weakness Repeat
  • 1224393 2023-010
    Material Weakness Repeat
  • 1224394 2023-011
    Material Weakness Repeat
  • 1224395 2023-012
    Material Weakness Repeat
  • 1224396 2023-013
    Material Weakness Repeat
  • 1224397 2023-014
    Material Weakness Repeat
  • 1224398 2023-015
    Material Weakness Repeat
  • 1224399 2023-016
    Material Weakness Repeat
  • 1224400 2023-017
    Material Weakness Repeat
  • 1224401 2023-018
    Material Weakness Repeat
  • 1224402 2023-019
    Material Weakness Repeat
  • 1224403 2023-020
    Material Weakness Repeat
  • 1224404 2023-015
    Material Weakness Repeat
  • 1224405 2023-016
    Material Weakness Repeat
  • 1224406 2023-017
    Material Weakness Repeat
  • 1224407 2023-018
    Material Weakness Repeat
  • 1224408 2023-019
    Material Weakness Repeat
  • 1224409 2023-020
    Material Weakness Repeat
  • 1224410 2023-015
    Material Weakness Repeat
  • 1224411 2023-016
    Material Weakness Repeat
  • 1224412 2023-017
    Material Weakness Repeat
  • 1224413 2023-018
    Material Weakness Repeat
  • 1224414 2023-019
    Material Weakness Repeat
  • 1224415 2023-020
    Material Weakness Repeat
  • 1224416 2023-015
    Material Weakness Repeat
  • 1224417 2023-016
    Material Weakness Repeat
  • 1224418 2023-017
    Material Weakness Repeat
  • 1224419 2023-018
    Material Weakness Repeat
  • 1224420 2023-019
    Material Weakness Repeat
  • 1224421 2023-020
    Material Weakness Repeat
  • 1224422 2023-021
    Material Weakness Repeat
  • 1224423 2023-022
    Material Weakness Repeat
  • 1224424 2023-023
    Material Weakness Repeat
  • 1224425 2023-024
    Material Weakness Repeat
  • 1224426 2023-025
    Material Weakness Repeat
  • 1224427 2023-026
    Material Weakness Repeat
  • 1224428 2023-027
    Material Weakness Repeat
  • 1224429 2023-028
    Material Weakness Repeat
  • 1224431 2023-030
    Material Weakness Repeat
  • 1224432 2023-031
    Material Weakness Repeat
  • 1224433 2023-032
    Material Weakness Repeat
  • 1224434 2023-033
    Material Weakness Repeat
  • 1224435 2023-034
    Material Weakness Repeat
  • 1224436 2023-035
    Material Weakness Repeat
  • 1224437 2023-036
    Material Weakness Repeat
  • 1224438 2023-037
    Material Weakness Repeat
  • 1224439 2023-038
    Material Weakness Repeat
  • 1224440 2023-039
    Material Weakness Repeat
  • 1224441 2023-040
    Material Weakness Repeat
  • 1224442 2023-041
    Material Weakness Repeat
  • 1224443 2023-042
    Material Weakness Repeat
  • 1224444 2023-039
    Material Weakness Repeat
  • 1224445 2023-040
    Material Weakness Repeat
  • 1224446 2023-041
    Material Weakness Repeat
  • 1224447 2023-042
    Material Weakness Repeat
  • 1224448 2023-039
    Material Weakness Repeat
  • 1224449 2023-040
    Material Weakness Repeat
  • 1224450 2023-041
    Material Weakness Repeat
  • 1224451 2023-042
    Material Weakness Repeat
  • 1224452 2023-043
    Material Weakness Repeat
  • 1224453 2023-044
    Material Weakness Repeat
  • 1224454 2023-045
    Material Weakness Repeat
  • 1224455 2023-046
    Material Weakness Repeat
  • 1224456 2023-047
    Material Weakness Repeat
  • 1224457 2023-048
    Material Weakness Repeat
  • 1224458 2023-049
    Material Weakness Repeat
  • 1224459 2023-050
    Material Weakness Repeat
  • 1224460 2023-048
    Material Weakness Repeat
  • 1224461 2023-049
    Material Weakness Repeat
  • 1224462 2023-050
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $104.07M
93.778 GRANTS TO STATES FOR MEDICAID $76.95M
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $31.11M
10.539 CNMI NUTRITION ASSISTANCE $16.44M
93.767 CHILDREN'S HEALTH INSURANCE PROGRAM $14.01M
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $10.33M
10.542 PANDEMIC EBT FOOD BENEFITS $9.86M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $7.85M
84.425H Education Stabilization Fund-Governors (Outlying Areas) $6.68M
17.225 UNEMPLOYMENT INSURANCE $5.91M
11.307 ECONOMIC ADJUSTMENT ASSISTANCE $4.56M
21.023 EMERGENCY RENTAL ASSISTANCE PROGRAM $3.57M
93.596 CHILD CARE MANDATORY AND MATCHING FUNDS OF THE CHILD CARE AND DEVELOPMENT FUND $3.54M
20.526 BUSES AND BUS FACILITIES FORMULA, COMPETITIVE, AND LOW OR NO EMISSIONS PROGRAMS $2.85M
66.600 Environmental Protection Consolidated Grants for the Insular Areas - Program Support $2.46M
66.801 HAZARDOUS WASTE MANAGEMENT STATE PROGRAM SUPPORT $2.18M
97.039 HAZARD MITIGATION GRANT $2.05M
93.667 SOCIAL SERVICES BLOCK GRANT $1.52M
15.611 WILDLIFE RESTORATION AND BASIC HUNTER EDUCATION AND SAFETY $1.45M
12.617 ECONOMIC ADJUSTMENT ASSISTANCE FOR STATE GOVERNMENTS $1.43M
15.875 ECONOMIC, SOCIAL, AND POLITICAL DEVELOPMENT OF THE TERRITORIES $1.39M
11.419 COASTAL ZONE MANAGEMENT ADMINISTRATION AWARDS $1.06M
15.605 SPORT FISH RESTORATION $1.03M
20.600 State and Community Highway Safety $1.02M
84.126A Rehabilitation Services Vocational Rehabilitation Grants to States $722,785
17.277 WIOA NATIONAL DISLOCATED WORKER GRANTS / WIA NATIONAL EMERGENCY GRANTS $642,983
97.067 HOMELAND SECURITY GRANT PROGRAM $586,122
11.482 CORAL REEF CONSERVATION PROGRAM $485,806
16.575 CRIME VICTIM ASSISTANCE $480,848
93.045 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART C, NUTRITION SERVICES $465,958
16.588 VIOLENCE AGAINST WOMEN FORMULA GRANTS $463,780
10.649 PANDEMIC EBT ADMINISTRATIVE COSTS $459,938
16.710 Public Safety Partnership and Community Policing Grants $439,489
97.012 BOATING SAFETY FINANCIAL ASSISTANCE $400,545
93.044 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART B, GRANTS FOR SUPPORTIVE SERVICES AND SENIOR CENTERS $392,210
17.278 WIOA DISLOCATED WORKER FORMULA GRANTS $374,455
15.615 COOPERATIVE ENDANGERED SPECIES CONSERVATION FUND $368,265
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $341,575
97.047 BRIC: BUILDING RESILIENT INFRASTRUCTURE AND COMMUNITIES $319,766
17.259 WIOA YOUTH ACTIVITIES $307,211
16.750 Support for Adam Walsh Act Implementation Program $273,641
81.041 STATE ENERGY PROGRAM $265,459
17.504 CONSULTATION AGREEMENTS $264,451
20.218 MOTOR CARRIER SAFETY ASSISTANCE $252,525
45.025 PROMOTION OF THE ARTS PARTNERSHIP AGREEMENTS $239,433
17.258 WIOA ADULT PROGRAM $229,634
17.235 SENIOR COMMUNITY SERVICE EMPLOYMENT PROGRAM $224,606
81.042 WEATHERIZATION ASSISTANCE FOR LOW-INCOME PERSONS $212,348
15.634 STATE WILDLIFE GRANTS $201,740
16.034 CORONAVIRUS EMERGENCY SUPPLEMENTAL FUNDING PROGRAM $197,962
10.766 COMMUNITY FACILITIES LOANS AND GRANTS $195,515
15.904 HISTORIC PRESERVATION FUND GRANTS-IN-AID $186,515
11.472 COOPERATIVE RESEARCH PROGRAM $168,303
93.464 ACL ASSISTIVE TECHNOLOGY $128,419
93.747 ELDER ABUSE PREVENTION INTERVENTIONS PROGRAM $123,018
17.285 REGISTERED APPRENTICESHIP $116,929
11.437 FISHERIES DATA PROGRAM $112,596
11.467 METEOROLOGIC AND HYDROLOGIC MODERNIZATION DEVELOPMENT $104,532
10.664 COOPERATIVE FORESTRY ASSISTANCE $103,272
15.663 NFWF-USFWS CONSERVATION PARTNERSHIP $91,690
11.035 BROADBAND EQUITY, ACCESS, AND DEPLOYMENT PROGRAM $87,681
97.062 SCIENTIFIC LEADERSHIP AWARDS $86,357
93.048 SPECIAL PROGRAMS FOR THE AGING, TITLE IV, AND TITLE II, DISCRETIONARY PROJECTS $85,373
93.127 EMERGENCY MEDICAL SERVICES FOR CHILDREN $84,663
15.957 EMERGENCY SUPPLEMENTAL HISTORIC PRESERVATION FUND $73,515
17.273 TEMPORARY LABOR CERTIFICATION FOR FOREIGN WORKERS $68,059
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $67,796
12.300 Basic and Applied Scientific Research $65,974
20.509 FORMULA GRANTS FOR RURAL AREAS AND TRIBAL TRANSIT PROGRAM $64,714
93.645 STEPHANIE TUBBS JONES CHILD WELFARE SERVICES PROGRAM $61,124
10.680 Forest Health Protection $60,114
10.179 MICRO-GRANTS FOR FOOD SECURITY PROGRAM $58,129
16.017 SEXUAL ASSAULT SERVICES FORMULA PROGRAM $58,045
10.170 Specialty Crop Block Grant Program - Farm Bill $52,296
93.053 NUTRITION SERVICES INCENTIVE PROGRAM $50,933
93.556 MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES PROGRAM $49,361
59.061 STATE TRADE EXPANSION $41,693
93.569 COMMUNITY SERVICES BLOCK GRANT $39,897
11.407 INTERJURISDICTIONAL FISHERIES ACT OF 1986 $36,146
45.310 Grants to States $32,929
12.022 DOD MENTOR-PROTEGE PROGRAM $31,470
93.369 ACL INDEPENDENT LIVING STATE GRANTS $31,188
21.029 CORONAVIRUS CAPITAL PROJECTS FUND $30,034
93.450 Ebola Healthcare Preparedness and Response for Select Cities with Enhanced Airport Entrance Screenings from Affected Countries in West Africa $27,956
12.600 Community Investment $25,881
66.442 WATER INFRASTRUCTURE IMPROVEMENTS FOR THE NATION SMALL AND UNDERSERVED COMMUNITIES EMERGING CONTAMINANTS GRANT PROGRAM $22,460
16.585 TREATMENT COURT DISCRETIONARY GRANT PROGRAM $18,807
93.052 NATIONAL FAMILY CAREGIVER SUPPORT, TITLE III, PART E $16,169
93.590 Community - Based Child Abuse Prevention Grants $15,683
10.698 STATE & PRIVATE FORESTRY COOPERATIVE FIRE ASSISTANCE $14,514
93.043 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART D, DISEASE PREVENTION AND HEALTH PROMOTION SERVICES $14,287
16.540 Juvenile Justice and Delinquency Prevention $13,470
84.177B Rehabilitation Services Independent Living Services for Older Individuals Who are Blind $13,468
17.600 Mine Health and Safety Grants $13,189
15.631 PARTNERS FOR FISH AND WILDLIFE $9,540
20.703 INTERAGENCY HAZARDOUS MATERIALS PUBLIC SECTOR TRAINING AND PLANNING GRANTS $9,151
45.129 PROMOTION OF THE HUMANITIES FEDERAL/STATE PARTNERSHIP $8,543
66.040 Diesel Emissions Reduction Act (DERA) State Grants $8,314
93.671 FAMILY VIOLENCE PREVENTION AND SERVICES/DOMESTIC VIOLENCE SHELTER AND SUPPORTIVE SERVICES $8,215
93.042 SPECIAL PROGRAMS FOR THE AGING, TITLE VII, CHAPTER 2, LONG TERM CARE OMBUDSMAN SERVICES FOR OLDER INDIVIDUALS $5,973
16.753 CONGRESSIONALLY RECOMMENDED AWARDS $5,484
11.032 STATE DIGITAL EQUITY PLANNING AND CAPACITY GRANT $4,673
15.657 ENDANGERED SPECIES RECOVERY IMPLEMENTATION $4,508
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $4,200
11.U01 2010 Census $2,255
93.630 Developmental Disabilities Basic Support and Advocacy Grants $1,917
11.016 STATISTICAL, RESEARCH, AND METHODOLOGY ASSISTANCE $1,265
10.950 Agricultural Statistics Report $1,113
12.113 STATE MEMORANDUM OF AGREEMENT PROGRAM FOR THE REIMBURSEMENT OF TECHNICAL SERVICES $1,029
93.568 LOW-INCOME HOME ENERGY ASSISTANCE $854
20.500 Federal Transit Capital Investment Grants $761
93.041 SPECIAL PROGRAMS FOR THE AGING, TITLE VII, CHAPTER 3, PROGRAMS FOR PREVENTION OF ELDER ABUSE, NEGLECT, AND EXPLOITATION $525
20.513 ENHANCED MOBILITY OF SENIORS AND INDIVIDUALS WITH DISABILITIES $318
11.473 OFFICE FOR COASTAL MANAGEMENT $169