Finding 397964 (2020-009)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2020
Accepted
2024-05-20
Audit: 306672
Organization: Akiachak Native Community (AK)

AI Summary

  • Core Issue: There are significant weaknesses in internal controls over payroll calculations, leading to underpayments for employees.
  • 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 payroll accuracy, including verifying approved pay rates and proper calculation of hours worked.

Finding Text

Finding 2020-009 Lack of Internal Controls Over Activities Allowed or Unallowed and Allowable Costs/Costs Principles Federal Agencies: U.S. Department of the Treasury Federal Programs: Coronavirus Relief Fund CFDA Numbers: 21.019 Award Number: SLT0591/0845/1405 Award Year: 2020 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 testing of payroll transactions charged to the program, 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. Additionally, we noted that nearly all employees tested did not have approved pay rates in their 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 all cases noted, the employees were under paid. Repeat finding: This is a repeat of Finding 2019-009, 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.

Categories

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

Other Findings in this Audit

  • 397957 2020-006
    Material Weakness Repeat
  • 397958 2020-006
    Material Weakness Repeat
  • 397959 2020-007
    Material Weakness Repeat
  • 397960 2020-007
    Material Weakness Repeat
  • 397961 2020-008
    Material Weakness Repeat
  • 397962 2020-008
    Material Weakness Repeat
  • 397963 2020-009
    Material Weakness Repeat
  • 397965 2020-010
    Significant Deficiency
  • 397966 2020-010
    Significant Deficiency
  • 974399 2020-006
    Material Weakness Repeat
  • 974400 2020-006
    Material Weakness Repeat
  • 974401 2020-007
    Material Weakness Repeat
  • 974402 2020-007
    Material Weakness Repeat
  • 974403 2020-008
    Material Weakness Repeat
  • 974404 2020-008
    Material Weakness Repeat
  • 974405 2020-009
    Material Weakness Repeat
  • 974406 2020-009
    Material Weakness Repeat
  • 974407 2020-010
    Significant Deficiency
  • 974408 2020-010
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
15.022 Tribal Self-Governance $345,183
14.867 Indian Housing Block Grants $300,746
66.926 Indian Environmental General Assistance Program (gap) $107,755
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $107,014
16.710 Public Safety Partnership and Community Policing Grants $96,037
16.841 Voca Tribal Victim Services Set-Aside Program $92,932
93.575 Child Care and Development Block Grant $52,939
93.441 Indian Self-Determination $50,499
15.029 Tribal Courts $38,332
20.205 Highway Planning and Construction $24,196
21.019 Coronavirus Relief Fund $8,455
15.033 Road Maintenance_indian Roads $6,100