Finding 1173669 (2024-003)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-02-16

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) was incomplete and inaccurate, missing key federal programs and containing discrepancies in reported amounts.
  • Impacted Requirements: Noncompliance with CFR §200.510(b) and §200.302(b)(1) regarding the accurate reporting of federal awards and expenditures.
  • Recommended Follow-Up: Implement formal procedures for SEFA preparation, establish a dual-review process, and maintain a centralized tracking log for federal grants to enhance accuracy and compliance.

Finding Text

Internal Control over Compliance and Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards (SEFA)) ALN: 10.904, Milk River Project ALN: 10.923, Stream Restoration and Bridge Replacement for St. Mary Siphon Failure ALN: 15.U01, Replacement of St. Mary and Hallls Coulee Siphons on St. Mary Canal CRITERIA: The Code of Federal Regulations (CFR) Section §200.510(b) states in part: "The auditee must also 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 as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended." The schedule must provide total Federal awards expended for each individual Federal program. CFR 200.302(b)(1) requires that the nonfederal entity must identify in its accounts and on the schedule of expenditures of federal awards all federal awards received and expended, as well as the federal programs under which they were received. Federal program and award identification must include, as applicable, the Assistance Listing program title and number, the federal award identification number and year, the name of the federal agency, and the name of the pass-through entity, if any. CONDITION: The ALN 10.923, Stream Restoration and Bridge Replacement for St. Mary Siphon Failure, was left off the prepared SEFA. Amounts reported for ALN 10.904 and ALN 15.U01 did not agree to the accounting records. CONTEXT: The SEFA was misstated as follows: • Understated for ALN 10.904 by $196,980; • Understated for ALN 10.923 by $105,977; and • Overstated for ALN 15.U01 by $1,978,224. The net effect was an overstatement of $1,675,267 for total federal expenditures. EFFECT: The SEFA provided was not complete and accurate. QUESTIONED COSTS: None CAUSE: The internal controls for the preparation of the SEFA and review of the SEFA were not present to ensure the SEFA was complete and accurate. RECOMMENDATION: We recommend the MRJBOC prepare written procedures on how to put together the SEFA and strengthen internal controls to ensure all federal awards are included on the SEFA. We also recommend that the SEFA be reviewed by someone other than the preparer for completeness and accuracy prior to providing to the auditor. MRJBOC RESPONSE: MRJBOC acknowledges the deficiencies identified in the preparation and review of the Schedule of Expenditures of Federal Awards (SEFA). During 2024, the organization experienced a significant increase in federal funding activity related to emergency response and infrastructure replacement projects. The rapid expansion of federal programs, addition of funds and reporting requirements exceeded existing internal documentation and review processes. To strengthen compliance controls and ensure SEFA accuracy in future reporting periods, MRJBOC will implement the following corrective actions: • Develop and formalize written SEFA preparation procedures, including grant identification, ALN verification, and reconciliation to general ledger balances. • Establish a dual-review process in which the SEFA is reviewed and approved by a party independent from the preparer prior to submission to auditors. • Maintain a centralized federal grant tracking log that includes award numbers, funding sources, drawdowns, and cumulative expenditures. These measures will improve internal control over federal reporting, enhance accuracy, and ensure compliance with federal audit requirements.

Corrective Action Plan

Finding #2024-003: Internal Control Over Compliance and SEFA Reporting Contact Person Responsible: Jennifer Patrick, Project Manager Milk River Joint Board of Control Corrective Action Planned: 1. Develop SEFA preparation procedures, including grant identification, Assistance Listing Number verification, and reconciliation to the general ledger. 2. Establish a dual review process where the SEFA is reviewed and approved by a party independent of the preparer prior to submission to auditors. 3. Perform an annual reconciliation of SEFA totals to audited financial statements before audit fieldwork. Completion Date: This item was corrected during the 2024 audit process. A tracking spreadsheet has been implemented for 2025 to ensure proper identification, classification, and reporting moving forward. This control will remain in place as an ongoing activity for all federal funding to ensure continued compliance with reporting requirements. Disagreement with Finding: MRJBOC agrees with the finding; however, we would like to clarify that the reporting discrepancy was primarily the result of timing and classification factors. Specifically, certain funding initially received through the State of Montana was not identified as federal pass-through funding until after the SEFA was completed. Once it was determined that the funding required federal reporting under SEFA guidelines rather than state grant reporting, adjustments were necessary to properly reflect the award information. MRJBOC recognizes the importance of accurate grant identification and reporting and will implement the corrective actions outlined to strengthen internal controls, grant tracking procedures, and SEFA preparation processes moving forward. We have also taken steps to ensure a clear understanding of the findings and will continue to monitor and address them in future fiscal years. I certify this Corrective Action Plan has been prepared in accordance with 2 CFR §200.516 and addresses all audit findings for the year ended December 31, 2024.

Categories

Reporting

Other Findings in this Audit

  • 1173667 2024-003
    Material Weakness Repeat
  • 1173668 2024-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
15.U01 US DEPARTMENT OF INTERIOR, BOR REPLACEMENT OF THE ST. MARY AND HALLS COULEE SIPHONS ON THE ST. MARY CANAL $14.40M
10.904 WATERSHED PROTECTION AND FLOOD PREVENTION $662,871
10.923 EMERGENCY WATERSHED PROTECTION PROGRAM $105,977