Finding No.: 2022-045 AL Program: 97.039 - Hazard Mitigation Grant Program Area: Allowable Costs/Cost Principles Questioned Costs: $99,924 Contact Person(s): Patrick Guerrero, Governor’s Authorized Rep., PAO Corrective Action Plan: The Hazard Mitigation Grant Program (HMGP) agrees with this finding....
Finding No.: 2022-045 AL Program: 97.039 - Hazard Mitigation Grant Program Area: Allowable Costs/Cost Principles Questioned Costs: $99,924 Contact Person(s): Patrick Guerrero, Governor’s Authorized Rep., PAO Corrective Action Plan: The Hazard Mitigation Grant Program (HMGP) agrees with this finding. During the audit submission process, HMGP provided the support documents for the journal entries and reversals associated with the $99,923.27 to the auditor, as requested. However, it was only upon receiving this audit finding # 2022-049, that the discrepancy of a duplicate audit drawdown was called into question. HMGP’s ledger for this project as well as the Munis drawdown history does not indicate a remaining balance of $99,923.73 and the project related to this finding has already been closed out. To address this audit finding that HMGP received this last week on September 17th, HMGP reached out to the Department of Finance to provide related documents for the drawdowns. Based on the documents provided by DOF, the questioned cost was not a direct result of the duplicate drawdown but as a result of the reverse journal entries made by Tyler Munis staff in an effort to correct the duplicate drawdown. HMGP accurately completed all required steps to process and provided the necessary justification to process a total of $99,923.73 for professional services and submitted it to DOF. Based on the supporting documents, the $99,923.73 was comprised of: • $53,451.01- under Request for Payment Application #11, letter reference # GAR22-HM-005 received by DOF on 10/18/2021 and requested to be charged to M142352.62060. • $46,472.72- under Request for Payment Application #12, letter reference # GAR22-HM-031 received by DOF on 11/05/2021 and requested to be charged to M142352.62060. Both HMGP payment application requests show the project string was meant to be charged to 62060 which stands for Professional Services and was submitted to DOF for processing. Since the new Munis financial system portal was launch in the CNMI a month prior, HMGP personnel were not able to enter transactions directly, unlike the current process. However, when the transaction was processed on Munis, it was entered in by a Tyler Munis representative, as identified by the staff initials SMD, who was assigned to assist DOF employees with data input during the transition period and, according to the Munis transaction history, accidentally entered the debit for the $99,923.27 under the Construction project string instead of Professional Services on 12/2/2021. On 12/13/2021, SMD credited the $99,923.27 back to Construction and debited $99,923.27 to Professional Services with Journal entry # 2125. The Munis transaction history also shows various entries and reversals made under the project account that serve to correct the same journal error. HMGP personnel would not be able to review the transactions entered prior to posting, and based on the transaction logs, even after the transactions were posted, HMGP would see that those involved in processing the transactions corrected their errors. Additionally, the supporting documents associated with the drawdowns on Munis display a bank statement with a lumpsum total of various project accounts. Furthermore, most of the journal entries during the time in question either contained the same supporting documents or indicated “access denied” when selected by HMGP personnel with Munis access. The document provided to HMGP on 9/24/2025 indicated the final two transactions related to this expense was entered by Tyler Munis staff on August of 2022. In an effort to reverse the duplicate drawdowns that occurred in Professional Services, SMD reversed the $99,923.27 from professional services labeled as "REV JE 2125 DONE IN ERROR". Journal Entry (JE) 2125 refers to the debit they initially made on 12/13/2021. This credit effectively canceled out and corrected one of the two drawdowns that occurred within the Professional Services Project String. However, on the same day, SMD made a second journal entry reversal under the Construction project string with an identical PA journal comment ""REV JE 2125 DONE IN ERROR."" It is unclear as to why this transaction occurred given that original error under construction was made and corrected on December 2021. Since this incorrect journal entry was made as a debit to construction and the correct journal entry was made as a credit to professional services, the net draw would have been $0. Since $0 worth of funds were paid out and no check was cut as a result, this additional debit would not have been conspicuous to HMGP or the DOF staff. HMGP is prepared to provide the additional documentation upon request. Additionally, acknowledging that the second debit to construction in August of 2022 for $99,923.73 was recorded and was not corrected for this project, HMGP will work with DOF to correct the journal entry and return the funds to FEMA. To address the finding, a significant action step already taken is the transition that occurred in 2024 for agencies to initiate their own drawdowns. This drawdown process ensures HMGP’s direct oversight of all expenditures moving forward to reduce the risk of future duplications. HMGP created an internal drawdown tracker upon DOF’s transition to agency-initiated drawdown requests for 2024 expenses to present. HMGP will work with DOF to correct the journal entry on Munis in relation to the questioned cost and process the return of funds to FEMA. HMGP will create a tracker for all requested transactions made to DOF, such as reversals or corrections if needed as that function cannot be completed on Munis by HMGP. HMGP will review the tracker on a bi-weekly basis to ensure that all MUNIS journal entries and transfers related to HMGP to ensure expenditures are completed accurately and on a timely basis to avoid future misclassifications or duplications. HMGP will continue to ensure that all payments are correctly coded and submitted into Munis with the appropriate documentation and supporting details. HMGP will update the financial management portion of the HMGP standard operating procedures to reflect these action items. Proposed Completion Date: September 30, 2026