Finding 1147202 (2022-004)

Material Weakness Repeat Finding
Requirement
F
Questioned Costs
-
Year
2022
Accepted
2025-07-08

AI Summary

  • Core Issue: Management lacks an effective internal control system, leading to unaddressed compliance and property record issues.
  • Impacted Requirements: Failure to reconcile physical inventories and maintain proper documentation for equipment additions violates 2 CFR § 200.303 and § 200.313.
  • Recommended Follow-Up: Implement internal controls using the Green Book and ensure physical inventories are reconciled with property records every two years.

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). Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR section 200.313(d)(1)). A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated (2 CFR section 200.313(d)(3)). Condition/Context: Management has not implemented an effective internal control system. • A physical inventory was taken in 2021 but was not reconciled to the general ledger. 15.029 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. 20.205 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. • 3 of 3 Individually Important Items (IIIs) equipment additions did not have all required approvals. • 1 of 2 equipment addition samples had no support provided. • 1 of 2 equipment addition samples did not have all required approvals. 20.509 • A physical inventory was conducted in 2021; however, there were no documented controls over the Inventory, and it was not reconciled to the property records. • 6 of 6 equipment samples including prior year equipment did not have support provided. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Due to turnover in key personnel, Joint Programs had a breakdown in internal controls during 2022. Effect: Without an effective internal control system, an entity’s objective: operations, reporting, and compliance cannot be achieved. In addition, property records can be incorrect, and property can be damaged or lost without the knowledge of management. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-004. 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. In addition, we recommend that the physical inventory taken is reconciled with the property records at least once every two years. 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.

Categories

Equipment & Real Property Management

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
  • 570739 2022-003
    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
  • 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