Finding 614304 (2022-002)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2023-09-27
Audit: 28722
Organization: Duckwater Shoshone Tribe (NV)
Auditor: Sjt Group LLC

AI Summary

  • Core Issue: The Tribe is not following federal requirements for allowable costs, leading to duplicate payments and payroll discrepancies.
  • Impacted Requirements: Costs must be necessary, reasonable, and properly documented; personnel action forms must match actual pay rates.
  • Recommended Follow-Up: Implement strict policies for voiding checks and ensure payroll changes are documented and approved before processing.

Finding Text

2022-002 ? Allowable Costs Federal program information: Funding Agency: U.S. Department of the Treasury Title: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Award Period: March 3, 2021 ? December 31, 2024 Criteria: To be allowable under Federal awards, costs must be necessary and reasonable for the performance and administration of the federal award. Costs must meet the following criteria: 1) necessary and reasonable; 2) consistent with policies and procedures; 3) accorded consistent treatment; and 4) are adequately documented. Condition: We noted the following in our review of expenditures: ? Two assistance checks were sent to a tribal member who was deceased. Once this was discovered, the Tribe issued another two checks to the individual?s beneficiary, resulting in the expense being charged to the program twice as the initial checks were not reversed or properly voided. An audit adjustment was needed to correct this error. ? For the payroll periods February 26, 2022 through March 11, 2022, we identified two instances where two employees? pay rates did not agree to their approved personnel action form effective for that payroll period. This was due to changes in pay not being properly reflected and dated on the personnel action form. Context: Three of forty-four expenditures. Questioned Costs: None. Cause: Internal controls are not in place to ensure expenditures are properly voided in the correct period. In addition, internal controls are not in place to ensure personnel action forms agree with the employee?s actual pay rate. Effect: The Tribe is not in compliance with federal allowable cost requirements. Auditors? Recommendation: Established policies and procedures should be enforced to ensure compliance with federal requirements. Ensure expenses are recorded only once to the federal program. Ensure personnel action forms are completed and approved before an employee?s pay rate is changed in the payroll system. Management Response: Management agrees with auditor?s recommendation, the Finance Manager will submit requests to void checks in the accounting system to the Accounts Payable Clerk. The Accounts Payable Clerk will process the void, and will submit an unposted transaction report of the voided check to the Finance Manager. The Finance Manager will verify that the check is being voided in the correct period, and then post the void to the general ledger. This process should ensure that all checks are voided accurately and timely. When the Council approves a pay increase for an individual(s), the Tribal Manager shall notify Human Resources in writing of the increase and the effective date of the increase for that employee. Human Resources will prepare a Personnel Action Form (PAF) using the information provided. The date of completion of the form will also be indicated on the PAF. One copy of the PAF will be placed in the employee?s Personnel File, and one copy of the PAF will be forwarded to the Payroll Clerk for entry into the accounting system. Employee rates will not be changed in the payroll system without a corresponding PAF.

Categories

Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 37862 2022-002
    Significant Deficiency
  • 37863 2022-003
    Significant Deficiency
  • 37864 2022-003
    Significant Deficiency
  • 614305 2022-003
    Significant Deficiency
  • 614306 2022-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.210 Tribal Self-Governance Program: Ihs Compacts/funding Agreements $3.01M
15.022 Tribal Self-Governance $1.95M
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $847,318
14.867 Indian Housing Block Grants $553,545
15.042 Indian School Equalization Program $237,855
15.046 Administrative Cost Grants for Indian Schools $165,151
93.237 Special Diabetes Program for Indians_diabetes Prevention and Treatment Projects $159,950
15.047 Indian Education Facilities, Operations, and Maintenance $137,167
66.926 Indian Environmental General Assistance Program (gap) $106,630
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $89,813
15.042 Covid-19 Indian School Equalization Program $80,231
84.010 Title I Grants to Local Educational Agencies $38,848
66.419 Water Pollution Control State, Interstate, and Tribal Program Support $38,372
84.377 School Improvement Grants $29,789
84.027 Special Education_grants to States $27,502
15.044 Indian Schools_student Transportation $27,258
21.032 Covid-19 Local Assistance and Tribal Consistency Fund $21,030
15.151 Education Program Enhancements $18,804
10.555 National School Lunch Program $17,468
66.460 Nonpoint Source Implementation Grants $9,621
84.425 Covid-19 Education Stabilization Fund $8,456
97.042 Emergency Management Performance Grants $6,900
15.904 Historic Preservation Fund Grants-in-Aid $5,037
14.862 Covid-19 Indian Community Development Block Grant Program $1,041