Finding 501742 (2020-012)

Significant Deficiency Repeat Finding
Requirement
L
Questioned Costs
-
Year
2020
Accepted
2024-10-03

AI Summary

  • Core Issue: There is a significant deficiency in internal controls, leading to inaccurate quarterly financial reports for the Fort Peck Reservation Rural Water System.
  • Impacted Requirements: Annual financial reports must accurately reflect the period covered, which was not met due to poor accrual accounting.
  • Recommended Follow-Up: Implement more thorough accounting practices and review processes for financial reports to prevent future inaccuracies.

Finding Text

2020-012 Reporting Federal Agency: U.S. Department of Reclamation Federal Program Title: Fort Peck Reservation Rural Water System ALN Number: 15.516 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: R03AV60749 March 31, 2019 R18AV00011 September 30, 2022 Statistically Valid Sample: No, and not intended to be a Statistically Valid Sample Type of Finding: Significant Deficiency in Internal Control Over Compliance and Other Noncompliance Criteria or Specific Requirement: Annual financial reports should accurately reflect the period covered. Condition/Context: During our audit testing, we noted that 1 of the quarterly reports SF-425 reports tested were inaccurate. Questioned Costs: Unable to determine likely questioned costs. Cause: Proper accrual accounting and records were not maintained. Effect: Inaccurate reports. Repeat Finding: This finding was issued as prior year reference number 2019-009. Recommendation: CLA recommend more thorough accounting and review over financial reports. Views of Responsible Officials: There is no disagreement with the audit finding. Corrective Action Plan: See corrective action plan.

Corrective Action Plan

U.S. Department of Interior Fort Peck Reservation Rural Water System – CFDA No. 15.516 2020-012 Reporting Recommendation: CLA recommend more thorough accounting and review over financial reports. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Condition: During our audit testing, we noted that 1 of the quarterly reports SF-425 reports tested were inaccurate. Action taken in response to finding: In FY 2019, accounting services were provided by a company contracted for financial functions. In FY 2020 new positions were created and staff hired to perform all financial accounting in-house. Significant work has been done to provide accurate reports. Although not required, a spreadsheet was created to track cumulative revenue and expenditures with checks and balances to document the calculation of report amounts for each quarterly report. The SF-425 financial report is submitted the spreadsheet, financial records and reports from the accounting software such as the income statement, trial balance, cash report and monthly reconciliation reports. Strengthened internal controls include proper monthly reconciliation process that are reviewed and approved by the general manager, quarterly payroll liability review and adjustments, monthly review and approval of Finance reports by the Board of Directors, monthly and end-of-year adjustments by the Finance Officer and review for accuracy and approval by the General Manager will ensure accurate and timely reports. The knowledge and improved understanding of the new accounting software by the current finance staff and General Manager ensures proper accrual accounting and records are maintained. Name(s) of the contact person(s) responsible for corrective action: Ashleigh Weeks, General Manager, and Jodi Miller, Finance Officer Planned completion date for corrective action plan: Complete

Categories

Reporting Significant Deficiency

Other Findings in this Audit

  • 501732 2020-002
    Significant Deficiency Repeat
  • 501733 2020-003
    Material Weakness Repeat
  • 501734 2020-004
    Significant Deficiency Repeat
  • 501735 2020-005
    Material Weakness
  • 501736 2020-006
    Material Weakness Repeat
  • 501737 2020-007
    Material Weakness
  • 501738 2020-008
    Significant Deficiency
  • 501739 2020-009
    Significant Deficiency
  • 501740 2020-010
    Significant Deficiency Repeat
  • 501741 2020-011
    Significant Deficiency
  • 501743 2020-013
    Significant Deficiency Repeat
  • 1078174 2020-002
    Significant Deficiency Repeat
  • 1078175 2020-003
    Material Weakness Repeat
  • 1078176 2020-004
    Significant Deficiency Repeat
  • 1078177 2020-005
    Material Weakness
  • 1078178 2020-006
    Material Weakness Repeat
  • 1078179 2020-007
    Material Weakness
  • 1078180 2020-008
    Significant Deficiency
  • 1078181 2020-009
    Significant Deficiency
  • 1078182 2020-010
    Significant Deficiency Repeat
  • 1078183 2020-011
    Significant Deficiency
  • 1078184 2020-012
    Significant Deficiency Repeat
  • 1078185 2020-013
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
15.516 Fort Peck Reservation Rural Water System $12.18M
15.048 Bureau of Indian Affairs Facilities Operations and Maintenance $3.15M