Finding 960834 (2022-006)

Material Weakness
Requirement
A
Questioned Costs
-
Year
2022
Accepted
2024-03-26
Audit: 297513
Organization: City of West Fargo (ND)
Auditor: Eide Bailly

AI Summary

  • Core Issue: The City lacks a formal review process for payroll cost allocations to federal awards, leading to potential misstatements.
  • Impacted Requirements: This deficiency violates internal control standards, risking noncompliance with federal funding regulations.
  • Recommended Follow-Up: Implement a thorough review and reconciliation of payroll allocations before the audit, involving both accounting staff and supervisors.

Finding Text

Department of the Treasury, Passed through North Dakota Office of Management and Budget Federal Financial Assistance Listing 21.027 COVID‐19 – Coronavirus State and Local Fiscal Recovery Funds Activities Allowed or Unallowed Material Weakness in Internal Control over Compliance Criteria – A good system of internal accounting control contemplates an adequate system for review of the allocation of payroll expenditures to federal awards. Condition – During the course of our engagement, we noted that the City has no formal review process for the allocation of payroll costs to federal awards, which could result in a material misstatement of the City’s schedule of expenditures of federal awards. Cause – The City does not have an internal control system designed to review the allocation of payroll costs to federal awards. Effect – This deficiency could result in a misstatement to the financial statements and noncompliance with federal awards that would not be prevented or detected. Questioned Costs – None reported. Context/Sampling – A non‐statistical sample of 60 transactions out of a population over 250 total transactions were selected for testing, which accounted for $2,217,102 of $2,774,746 of federal program expenditures. Repeat Finding from Prior Year(s) – No. Recommendation – A thorough review and reconciliation of the allocation of payroll costs to federal awards should take place prior to the beginning of the audit. This review should be done at both the accounting staff and accounting supervisor levels. Views of Responsible Officials – There is no disagreement with the audit finding.

Categories

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

Other Findings in this Audit

  • 384392 2022-006
    Material Weakness
  • 384393 2022-007
    Material Weakness Repeat
  • 384394 2022-008
    Material Weakness
  • 960835 2022-007
    Material Weakness Repeat
  • 960836 2022-008
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $2.77M
15.507 Watersmart (sustaining and Manage America's Resources for Tomorrow) $183,000
10.675 Urban and Community Forestry Program $19,120
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $3,725