Finding 383514 (2019-009)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2019
Accepted
2024-03-21
Audit: 296571
Organization: Akiachak Native Community (AK)

AI Summary

  • Core Issue: There are significant weaknesses in internal controls over payroll calculations, leading to underpayments for partial hours worked.
  • Impacted Requirements: Compliance with 2 CFR part 200.430 is not met, as payroll records lack accurate documentation and approved pay rates.
  • Recommended Follow-Up: Management should establish clear policies to ensure paychecks are based on approved rates and accurately reflect hours worked.

Finding Text

Finding 2019-009 Lack of Internal Controls Over Activities Allowed or Unallowed and Allowable Costs/Costs Principles Federal Agencies: U.S. Department of the Interior and U.S. Department of Health and Human Services Federal Programs: Consolidated Tribal Government (CTG) and Indian Self-Determination (ISD), respectively CFDA Numbers: 15.021 and 93.441, respectively Award Numbers: A16AV00375 and A19AV00503 (CTG), and 243-12-0006 (ISD), respectively Award Years: 2016 and 2019 (CTG), and 2019 and 2020 (ISD) Type of Finding: Material weakness in internal control over compliance and material noncompliance. Criteria: Per 2 CFR part 200.430, personnel expenses recorded into a federal program must be based on records that accurately reflect the work performed. Hourly employees should be paid for hours worked and documented through a system of internal controls which provides reasonable assurance that the charges are accurate, allowable and properly allocated. Internal controls procedures should be in place to ensure that all cash disbursements and payroll transactions are adequately supported by documentation, approved with accurate account coding on the approval form, retained for support either in the vendor, employee, or program file. Condition and Context: During our payroll allowable costs testing we noted that the Community is incorrectly calculating the gross pay from the timesheets. The Community is taking the employee’s hourly rate multiplied by the hours worked with minutes calculated using 100 minutes per hour instead of 60 minutes. This results in an underpayment on any partial hour worked. We tested 13 payroll transactions charged to CTG program and 25 payroll transactions charged to the ISD program and noted that all transactions tested did not have approved pay rates in the employee personnel files. Cause: Lack of internal controls over payroll transactions. Effect: Lack of internal control over payroll transactions poses the risk that the Community will expend federal funds for non-grant purposes. Questioned costs: None noted. In cases where an employee worked a partial hour, the employees were under paid. In reviewing the pay rates for each of the employees, they appeared reasonable and consistent with similar entities across the State. Repeat finding: This is a repeat of Finding 2018-008, therefore, we believe this to be a systemic issue. Recommendation: We recommend that management implement policies and procedures to ensure that all paychecks are supported by an approved pay rate, hours worked agree to the hours paid and are accurately calculated. Management Response: Management agrees with this finding, see Corrective Action Plan

Corrective Action Plan

Finding 2019-009 Lack of Internal Controls Over Activities Allowed or Unallowed and Allowable Costs/Costs Principles Name of Contact Person: Edward George, Tribal Administrator Corrective Action Plan: The finance department was notified of this finding during the audit and immediately corrected the method of converting timecard totals to hours. Personnel files have been reviewed and updated for all current employees. Proposed Completion Date: Complete as of December 2023

Categories

Allowable Costs / Cost Principles Material Weakness Internal Control / Segregation of Duties

Other Findings in this Audit

  • 383508 2019-006
    Material Weakness Repeat
  • 383509 2019-006
    Material Weakness Repeat
  • 383510 2019-007
    Material Weakness Repeat
  • 383511 2019-007
    Material Weakness Repeat
  • 383512 2019-008
    Material Weakness Repeat
  • 383513 2019-008
    Material Weakness Repeat
  • 383515 2019-009
    Material Weakness Repeat
  • 959950 2019-006
    Material Weakness Repeat
  • 959951 2019-006
    Material Weakness Repeat
  • 959952 2019-007
    Material Weakness Repeat
  • 959953 2019-007
    Material Weakness Repeat
  • 959954 2019-008
    Material Weakness Repeat
  • 959955 2019-008
    Material Weakness Repeat
  • 959956 2019-009
    Material Weakness Repeat
  • 959957 2019-009
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.441 Indian Self-Determination $533,216
14.867 Indian Housing Block Grants $437,080
15.021 Consolidated Tribal Government Program $302,962
20.205 Highway Planning and Construction $122,810
66.926 Indian Environmental General Assistance Program (gap) $92,796
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $92,673
15.029 Tribal Courts $84,838
93.575 Child Care and Development Block Grant $63,104
16.710 Public Safety Partnership and Community Policing Grants $61,340
15.033 Road Maintenance_indian Roads $28,241
16.841 Voca Tribal Victim Services Set-Aside Program $26,692
81.087 Renewable Energy Research and Development $17,124