Finding 1163358 (2024-007)

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

AI Summary

  • Core Issue: Pembina County inaccurately reported expenditures and obligations, understating them by $17,797.40 in the March 31, 2024, report for the Coronavirus State and Local Fiscal Recovery Funds.
  • Impacted Requirements: The county failed to comply with federal reporting criteria, specifically regarding the inclusion of all incurred expenditures and obligations as outlined in the Project and Expenditure Report User Guide.
  • Recommended Follow-Up: Pembina County should review and ensure compliance with all reporting requirements, accurately reflecting all expenditures and obligations in future Project and Expenditure Reports.

Finding Text

2024-007 – CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS – IMPROPER REPORTING OF EXPENDITURES – ALN 21.027 – SIGNIFICANT DEFICIENCY & OTHER NONCOMPLIANCE FINDING TYPE: OTHER NONCOMPLIANCE Finding 2024-007 Federal Program: FAIN: CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS SLFRP5522 ALN: 21.027 Year(s): 2024 Federal Agency: U.S. Department of Treasury Questioned Cost: $0 Condition Pembina County did not properly report expenditures and obligations on the March 31, 2024, Project and Expenditure Report for the Coronavirus State and Local Fiscal Recovery Funds program. The total cumulative and current expenditures and cumulative and current obligations reported were understated by $17,797.40. Effect The amounts reported as cumulative and current expenditures and current obligations on the March 31, 2024, Project and Expenditure Report were inaccurate. Cause Pembina County did not ensure that all expenditures and obligations were included when completing reporting for the March 31, 2024 Project and Expenditure Report. Criteria Page 19 of the Coronavirus State and Local Fiscal Recovery Funds: Project and Expenditure Report User Guide Version 12 (September 30, 2024) states: • An expenditure is the amount that has been incurred as a liability of the entity (the service has been rendered or the good has been delivered to the entity). • An obligation is an order placed for property and services, contracts and subawards made, and similar transactions that require payment. An obligation also means a requirement under federal law or regulation or provision of the award terms and conditions to which a recipient becomes subject as a result of receiving or expending funds. • 2 CFR 200.303 states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Context As stated in the SLFRF Compliance and Reporting Guidance for counties allocated less than $10 million with a population below 250,000 residents such as Pembina, "the initial Project and Expenditure Report covered the period from March 3, 2021 to March 31, 2022 and was required to be submitted to Treasury by April 30, 2022. The subsequent annual reports will cover one calendar year and must be submitted to Treasury by April 30 each year." Therefore, each year after March 31, 2022, the Pembina County must then submit an annual P&E report for the period covering April 1 202X - March 31, 202Y. Pembina County did submit the 2024 (period covering April 1, 2023-March 31, 2024) report by April 30, 2024, but did not properly include 3 expenses/obligations that were incurred between January 2024 - March 2024, totaling $17,797.40 on the 2024 P&E report. Repeat Finding No. Recommendation We recommend Pembina County review and comply with all reporting requirements of the Coronavirus State and Local Fiscal Recovery Funds program by properly reporting all expenditures and obligations in the Project and Expenditure Reports. Pembina County’s Response See Corrective Action Plan.

Corrective Action Plan

2024-007 – CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS – IMPROPER REPORTING OF EXPENDITURES – ALN 21.027 – SIGNIFICANT DEFICIENCY & OTHER NONCOMPLIANCE Condition Pembina County did not properly report expenditures and obligations on the March 31, 2024, Project and Expenditure Report for the Coronavirus State and Local Fiscal Recovery Funds program. The total cumulative and current expenditures and cumulative and current obligations reported were understated by $17,797.40. Corrective Action Plan: We agree, Pembina County will ensure obligations and expenditures for the SLFR grant are properly stated in future periods. Anticipated Completion Date: FY 2025

Categories

Subrecipient Monitoring Reporting Significant Deficiency Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1163357 2024-006
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $947,000
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $705,805
10.916 WATERSHED REHABILITATION PROGRAM $278,966
10.904 WATERSHED PROTECTION AND FLOOD PREVENTION $184,740
97.067 HOMELAND SECURITY GRANT PROGRAM $101,573
21.032 LOCAL ASSISTANCE AND TRIBAL CONSISTENCY FUND $54,686
16.575 CRIME VICTIM ASSISTANCE $15,948
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $12,865
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $6,450
15.904 HISTORIC PRESERVATION FUND GRANTS-IN-AID $2,186