Finding 570739 (2022-003)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
$1
Year
2022
Accepted
2025-07-08

AI Summary

  • Core Issue: Significant internal control weaknesses were identified across multiple federal programs, leading to missing approvals and documentation.
  • Impacted Requirements: Compliance with 2 CFR § 200.303 and cost principles was not met, risking unallowable expenditures and inadequate financial management.
  • Recommended Follow-up: Implement internal controls based on the Green Book and ensure all records are organized for easy access and review.

Finding Text

Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster AL Number Award Number Award Period Grant Name 20.509 A18AV01093/218AV00785 1/1/2018-9/30/2023 Road Maintenance Programs Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) 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. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). The cost principles in 2 CFR part 200, subpart E (Cost Principles), prescribe the cost accounting requirements associated with the administration of federal awards by: a. States, local governments, and Indian tribes. b. Institutions of higher education (IHEs). c. Nonprofit organizations. Except where otherwise authorized by statute, cost must meet the following general criteria in order to be allowable under federal awards; 4. Be accorded consistent treatment. A cost may not be assigned to a federal award as a direct cost if any other cost incurred for the same purpose in like circumstances has been allocated to the federal award as an indirect cost. 7. Be adequately documented. Condition/Context: During transactional testing of the Judicial Services (AL #15.029) program, the following were noted: • 12 of 26 nonpayroll samples did not have proper approvals. • 3 of 34 payroll samples did not have proper Personnel Status Forms provided. • 3 of 34 payroll samples did not have proper Timesheet approvals. • 2 of 34 payroll samples did not have proper pay rate documented. During transactional testing of the Highway Planning and Construction Cluster (AL #20.205), the following were noted: • 8 of 8 Individually Important Items (IIIs) did not have all required approvals. • 11 of 40 non payroll samples did not have all required approvals. • 20 of 20 payroll samples did not have payrate approval provided. • 2 of 20 payroll samples did not have an approved timesheet. • 2 of 40 non payroll samples did not have adequate support provided. During transactional testing of the Road Maintenance Programs (AL #20.509), the following were noted: • 1 of 4 IIIs did not have support provided. • 3 of 4 IIIs did not have proper approvals. • 39 of 39 non payroll samples did not proper approvals. • 4 of 21 payroll samples were missing timesheets. • 2 of 21 payroll samples did not have an accurate Payroll Status Form provided. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Due to turnover in key personnel and lack of internal controls, the entity did not have the ability to provide supporting documentation. Effect: Without an effective internal control system, an entity’s objective: operations, reporting, and compliance cannot be achieved. In addition, program funds could be expended on activities or costs that are deemed unallowable by the funding agency. Questioned Costs: Known – $32,912 AL # 15.029 – Judicial Services. Known – $61,693 AL # 20.205 – Highway Planning and Construction Cluster. Known – $13,275 AL # 20.509 – Road Maintenance Programs. Repeat Finding: Yes – 2021-003. Recommendation: We recommend that Joint Programs use the Green Book to design, implement, and operate internal controls to achieve its objectives related to operations, reporting, and compliance. We also recommend all records be maintained and filed in a way that allows them to be located and reviewed at any point in time. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.

Corrective Action Plan

Individual(s) Responsible: Chelsea BadHawk, Chief Financial Officer Action: Management will prepare and implement an internal control system that provides effective oversight of operations, reporting, and compliance. The systems and controls will be designed based on standards set forth in the Government Accountability Office Green Book. Anticipated Completion Date: 12/31/2025.

Categories

Questioned Costs Allowable Costs / Cost Principles Material Weakness Reporting Significant Deficiency Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 570734 2022-002
    Material Weakness Repeat
  • 570735 2022-002
    Material Weakness Repeat
  • 570736 2022-002
    Material Weakness Repeat
  • 570737 2022-002
    Material Weakness Repeat
  • 570738 2022-002
    Material Weakness Repeat
  • 570740 2022-003
    Material Weakness Repeat
  • 570741 2022-003
    Material Weakness Repeat
  • 570742 2022-003
    Material Weakness Repeat
  • 570743 2022-003
    Material Weakness Repeat
  • 570744 2022-003
    Material Weakness Repeat
  • 570745 2022-003
    Material Weakness Repeat
  • 570746 2022-003
    Material Weakness Repeat
  • 570747 2022-003
    Material Weakness Repeat
  • 570748 2022-003
    Material Weakness Repeat
  • 570749 2022-003
    Material Weakness Repeat
  • 570750 2022-003
    Material Weakness Repeat
  • 570751 2022-004
    Material Weakness Repeat
  • 570752 2022-004
    Material Weakness Repeat
  • 570753 2022-004
    Material Weakness Repeat
  • 570754 2022-004
    Material Weakness Repeat
  • 570755 2022-004
    Material Weakness Repeat
  • 570756 2022-004
    Material Weakness Repeat
  • 570757 2022-004
    Material Weakness Repeat
  • 570758 2022-004
    Material Weakness Repeat
  • 570759 2022-004
    Material Weakness Repeat
  • 570760 2022-004
    Material Weakness Repeat
  • 570761 2022-004
    Material Weakness Repeat
  • 570762 2022-004
    Material Weakness Repeat
  • 570763 2022-005
    Material Weakness Repeat
  • 570764 2022-005
    Material Weakness Repeat
  • 570765 2022-005
    Material Weakness Repeat
  • 570766 2022-005
    Material Weakness Repeat
  • 570767 2022-005
    Material Weakness Repeat
  • 570768 2022-005
    Material Weakness Repeat
  • 570769 2022-005
    Material Weakness Repeat
  • 570770 2022-005
    Material Weakness Repeat
  • 570771 2022-006
    Material Weakness Repeat
  • 570772 2022-006
    Material Weakness Repeat
  • 570773 2022-006
    Material Weakness Repeat
  • 570774 2022-006
    Material Weakness Repeat
  • 570775 2022-006
    Material Weakness Repeat
  • 570776 2022-006
    Material Weakness Repeat
  • 570777 2022-006
    Material Weakness Repeat
  • 570778 2022-007
    Material Weakness Repeat
  • 570779 2022-007
    Material Weakness Repeat
  • 570780 2022-007
    Material Weakness Repeat
  • 570781 2022-007
    Material Weakness Repeat
  • 570782 2022-007
    Material Weakness Repeat
  • 570783 2022-007
    Material Weakness Repeat
  • 570784 2022-007
    Material Weakness Repeat
  • 1147176 2022-002
    Material Weakness Repeat
  • 1147177 2022-002
    Material Weakness Repeat
  • 1147178 2022-002
    Material Weakness Repeat
  • 1147179 2022-002
    Material Weakness Repeat
  • 1147180 2022-002
    Material Weakness Repeat
  • 1147181 2022-003
    Material Weakness Repeat
  • 1147182 2022-003
    Material Weakness Repeat
  • 1147183 2022-003
    Material Weakness Repeat
  • 1147184 2022-003
    Material Weakness Repeat
  • 1147185 2022-003
    Material Weakness Repeat
  • 1147186 2022-003
    Material Weakness Repeat
  • 1147187 2022-003
    Material Weakness Repeat
  • 1147188 2022-003
    Material Weakness Repeat
  • 1147189 2022-003
    Material Weakness Repeat
  • 1147190 2022-003
    Material Weakness Repeat
  • 1147191 2022-003
    Material Weakness Repeat
  • 1147192 2022-003
    Material Weakness Repeat
  • 1147193 2022-004
    Material Weakness Repeat
  • 1147194 2022-004
    Material Weakness Repeat
  • 1147195 2022-004
    Material Weakness Repeat
  • 1147196 2022-004
    Material Weakness Repeat
  • 1147197 2022-004
    Material Weakness Repeat
  • 1147198 2022-004
    Material Weakness Repeat
  • 1147199 2022-004
    Material Weakness Repeat
  • 1147200 2022-004
    Material Weakness Repeat
  • 1147201 2022-004
    Material Weakness Repeat
  • 1147202 2022-004
    Material Weakness Repeat
  • 1147203 2022-004
    Material Weakness Repeat
  • 1147204 2022-004
    Material Weakness Repeat
  • 1147205 2022-005
    Material Weakness Repeat
  • 1147206 2022-005
    Material Weakness Repeat
  • 1147207 2022-005
    Material Weakness Repeat
  • 1147208 2022-005
    Material Weakness Repeat
  • 1147209 2022-005
    Material Weakness Repeat
  • 1147210 2022-005
    Material Weakness Repeat
  • 1147211 2022-005
    Material Weakness Repeat
  • 1147212 2022-005
    Material Weakness Repeat
  • 1147213 2022-006
    Material Weakness Repeat
  • 1147214 2022-006
    Material Weakness Repeat
  • 1147215 2022-006
    Material Weakness Repeat
  • 1147216 2022-006
    Material Weakness Repeat
  • 1147217 2022-006
    Material Weakness Repeat
  • 1147218 2022-006
    Material Weakness Repeat
  • 1147219 2022-006
    Material Weakness Repeat
  • 1147220 2022-007
    Material Weakness Repeat
  • 1147221 2022-007
    Material Weakness Repeat
  • 1147222 2022-007
    Material Weakness Repeat
  • 1147223 2022-007
    Material Weakness Repeat
  • 1147224 2022-007
    Material Weakness Repeat
  • 1147225 2022-007
    Material Weakness Repeat
  • 1147226 2022-007
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
20.509 25% Road Maintenance $2.12M
20.205 Transportation $1.31M
20.205 Construction Management Services $1.23M
15.029 Judicial Services $811,081
15.036 Fish & Game Wildlife Parks $328,020
20.509 Tribal Road Maintenance $274,307
20.205 2% Planning $110,224
15.024 Indian Self-Determination Contract Support $45,000
15.065 Irrigation Rehab $42,277
21.U01 Covid-19 - U.s Treasury Coronavirus $22,387
15.033 Road Maintenance $9,878
15.037 Bia Supplemental Funding $3,608
15.034 American Indian Agriculture Resource Management Plan $460
15.036 Fish & Game Search & Rescue $413
15.037 Water Resource $202
20.509 Road Maintenance $124