FAC Explorer

Finding 1224432 (2023-031)

Material Weakness Repeat Finding
Requirement
G
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 calculate its revenue loss for the 09/30/23 deadline, impacting compliance with federal requirements.
  • Impacted Requirements: Earmarking compliance for Rota Municipality is unclear due to missing documentation and lack of internal controls.
  • Recommended Follow-Up: CNMI needs to establish processes for data extraction and clarify responsibilities for earmarking compliance with Rota Municipality.

Finding Text

Finding No. 2023-031 Federal Agency: U.S. Department of the Treasury AL Program: COVID-19 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award No.: COVID-19 Area: Matching, Level of Effort, Earmarking Questioned Costs: Undeterminable Criteria: In accordance with the U.S. Treasury 2022 Final Rule and the Frequently Asked Questions (FAQ 3.1), the Final Rule offers a standard allowance for revenue loss of up to $10 million, not to exceed a recipient’s State and Local Fiscal Recovery Funds (SLFRF) award amount, allowing recipients to select between a standard amount of revenue loss or complete a full revenue loss calculation. Recipients that select the standard allowance may use that amount for government services. Recipients were able to indicate this choice in their Project and Expenditure Reports due April 30, 2022, and recipients may update their revenue loss election, as appropriate, in future reporting cycles through the April 2023 reporting period. Upon update, any prior revenue loss election will be superseded. For recipients not electing the $10 million standard allowance, recipients calculate revenue loss at four distinct points in time, either at the end of each calendar year (e.g., December 31 for years 2020, 2021, 2022, and 2023) or the end of each fiscal year of the recipient. Under the flexibility provided in the 2022 Final Rule, recipients can choose whether to use calendar or fiscal year dates but must be consistent throughout the period of performance. The CNMI Central Government elected to complete a full revenue loss calculation at the end of each of its September 30 fiscal years and also elected not to adjust actual revenue totals for the effect of tax cuts and tax increases, while the Saipan and Tinian Municipalities elected the standard allowance for revenue loss of up to $10 million, not to exceed their SLFRF award amounts. Condition: 1. CNMI did not calculate its revenue loss for the 09/30/23 calculation date. 2. Earmarking requirements for the Rota Municipality are undeterminable as documentation of the option elected was not provided. Cause: 1. Management lacked new processes to extract the necessary data to perform the earmarking revenue loss calculation after its transition from its legacy JD Edwards financial system to the Tyler Munis Financial Management Information System (FMIS) effective October 1, 2021. Finding No. 2023-031, continued Federal Agency: U.S. Department of the Treasury AL Program: COVID-19 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award No.: COVID-19 Area: Matching, Level of Effort, Earmarking Questioned Costs: Undeterminable Cause, continued: 2. There are no internal control processes in place over the Rota Municipality’s earmarking compliance requirements. This is due to confusion as to who is responsible for overseeing the Municipality’s SLFRF funding, as while the Municipality separately received its own funding, such is being maintained by the CNMI Central Government and many of the processes were guided by the CNMI Department of Finance. Effect or Potential Effect: CNMI is unable to substantiate amount drawn under the revenue loss category. Questioned costs is undeterminable as the Program’s FY2023 project expenditures detail schedule did not specify which of the expenditures pertain to the revenue loss eligible use category. Identification as a Repeat Finding: This is not a repeat finding. Recommendation: 1. CNMI should develop and have processes in place to extract the necessary data to be able to perform its earmarking revenue loss calculation. 2. CNMI and the Rota Municipality should verify their records on file and determine as to which option it elected for earmarking requirements. 3. CNMI should assist and provide necessary further guidance to the Rota Municipality, including determining as to who is responsible in overseeing the Municipality’s earmarking compliance requirements. Views of Responsible Officials: Conditions 1 and 2 - CNMI Department of Finance agrees with this finding. The issues stemmed from staff turnover and reorganization following a change in administration, which exposed gaps in internal capacity to perform required earmarking and revenue loss analyses. Refer to CNMI’s Corrective Action Plan for additional information.

Corrective Action Plan

Finding No.: 2023-031 AL Program: COVID-19 21.027 - Coronavirus State and Local Fiscal Recovery Funds Area: Matching, Level of Effort, Earmarking Questioned Costs: Undeterminable Contact Person(s): Tracy B. Norita, Secretary of Finance Corrective Action Plan: Condition 1-2: The CNMI Department of Finance agrees with this finding. The issues stemmed from staff turnover and reorganization following a change in administration, which exposed gaps in internal capacity to perform required earmarking and revenue loss analyses. This occurred alongside conditions documented in the finding, including: • Lack of processes to extract needed data after CNMI transitioned from JD Edwards to Tyler Munis FMIS. • Absence of internal controls over the Rota Municipality’s earmarking compliance due to unclear oversight responsibilities. The proposed corrective actions are described below: a. Cross Training of Personnel (Implemented) CNMI DOF has cross trained multiple staff to ensure continuity and eliminate dependency on any single employee for revenue loss analysis, earmarking determinations, and documentation retention. This improves data accuracy and prevents operational disruptions. b. Strengthening Data Extraction & Documentation Processes (In Progress) DOF is developing processes to reliably extract revenue related data from Tyler Munis to support timely revenue loss calculations, as recommended by auditors. c. Municipal Training and Oversight Clarification (In Progress) CNMI will work closely with municipalities—particularly Rota, which is less familiar with federal grant requirements—to: • Clarify who is responsible for SLFRF earmarking oversight • Verify the municipality’s elected option under the Final Rule • Provide training and technical assistance to ensure full compliance d. Development of an Earmarking & Revenue Loss SOP (Planned) DOF will formalize a written SOP establishing: • Required calculation timelines • Documentation standards • Review procedures • Data retention requirements Proposed Completion Date: October 31, 2026 (Some measures are already in place; additional controls and SOP finalization are underway)

Categories

Matching / Level of Effort / Earmarking

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
  • 1224430 2023-029
    Material Weakness Repeat
  • 1224431 2023-030
    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