Finding 386268 (2022-005)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2022
Accepted
2024-03-27
Audit: 298678
Auditor: Eide Bailly

AI Summary

  • Core Issue: The Organization lacks adequate internal controls to ensure payroll costs and invoice allocations are accurately calculated.
  • Impacted Requirements: Compliance with internal control criteria for financial assistance programs, specifically regarding payroll and expense calculations.
  • Recommended Follow-Up: Management should establish and implement stronger internal controls to ensure accurate cost allocation calculations.

Finding Text

Department of Treasury Federal Financial Assistance Listing/ALN 21.027 COVID‐19 Coronavirus State and Local Fiscal Recovery Funds Allowable Costs and Allowable Activities Material Weakness in Internal Control over Compliance Criteria ‐ A good system of internal controls includes a process to ensure that all payroll costs and invoice allocations are properly calculated. Condition ‐ We noted that the Organization’s internal controls did not have adequate internal controls to ensure payroll costs and invoice allocations are properly calculated. Cause ‐ During the course of our engagement, we noted that 11 of the expenses selected for testing, stemming primarily from a change in payroll systems, for the program were not correctly calculated. Effect ‐ The Organization’s internal controls failed to ensure costs to the program are properly calculated. Questioned Costs ‐ None Reported. Context/Sampling ‐ A nonstatistical sample of 60 costs were selected for expense testing. 11 out of the 60 costs tested lacked proper calculation of costs. These transactions totaled $13,955 of $293,562 costs tested. Repeat Finding from Prior Year(s) ‐ Yes. Recommendation ‐ Management should implement internal controls to ensure proper cost allocation calculations. Views of Responsible Officials ‐ There is no disagreement with the finding.

Corrective Action Plan

Department of Treasury Federal Financial Assistance Listing/ALN 21.027 COVID‐19 Coronavirus State and Local Fiscal Recovery Funds Allowable Costs and Allowable Activities Material Weakness in Internal Control over Compliance Finding Summary: The Organization’s internal controls did not have adequate internal controls to ensure payroll costs and invoice allocations are properly calculated. Responsible Individuals: Robben Luhning and Susan Koesterman. Corrective Action Plan: During 2022, a new payroll system was implemented that should rectify the issue. Anticipated Completion: December 31, 2023.

Categories

Allowable Costs / Cost Principles Material Weakness

Other Findings in this Audit

  • 386269 2022-006
    Significant Deficiency
  • 386270 2022-007
    Significant Deficiency Repeat
  • 386271 2022-008
    Material Weakness
  • 386272 2022-005
    Material Weakness Repeat
  • 386273 2022-006
    Significant Deficiency
  • 386274 2022-007
    Significant Deficiency Repeat
  • 386275 2022-008
    Material Weakness
  • 386276 2022-005
    Material Weakness Repeat
  • 386277 2022-006
    Significant Deficiency
  • 386278 2022-007
    Significant Deficiency Repeat
  • 386279 2022-008
    Material Weakness
  • 386280 2022-005
    Material Weakness Repeat
  • 386281 2022-006
    Significant Deficiency
  • 386282 2022-007
    Significant Deficiency Repeat
  • 386283 2022-008
    Material Weakness
  • 962710 2022-005
    Material Weakness Repeat
  • 962711 2022-006
    Significant Deficiency
  • 962712 2022-007
    Significant Deficiency Repeat
  • 962713 2022-008
    Material Weakness
  • 962714 2022-005
    Material Weakness Repeat
  • 962715 2022-006
    Significant Deficiency
  • 962716 2022-007
    Significant Deficiency Repeat
  • 962717 2022-008
    Material Weakness
  • 962718 2022-005
    Material Weakness Repeat
  • 962719 2022-006
    Significant Deficiency
  • 962720 2022-007
    Significant Deficiency Repeat
  • 962721 2022-008
    Material Weakness
  • 962722 2022-005
    Material Weakness Repeat
  • 962723 2022-006
    Significant Deficiency
  • 962724 2022-007
    Significant Deficiency Repeat
  • 962725 2022-008
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
14.231 Emergency Solutions Grant Program $220,246
97.024 Emergency Food and Shelter National Board Program $22,130
21.027 Coronavirus State and Local Fiscal Recovery Funds $19,931
14.218 Community Development Block Grants/entitlement Grants $6,295