Finding 1158051 (2024-002)

Material Weakness Repeat Finding
Requirement
ABL
Questioned Costs
$1
Year
2024
Accepted
2025-09-30
Audit: 369998
Organization: Semo Electric Cooperative (MO)
Auditor: Uhy LLP

AI Summary

  • Core Issue: Materials were charged to project work orders prematurely, leading to potential inaccuracies in reported expenses.
  • Impacted Requirements: Effective controls for timely reconciliation between work order charges and contractor invoices were lacking, risking compliance with grant reporting standards.
  • Recommended Follow-Up: Implement procedures for timely reconciliations and maintain comprehensive documentation to support material installation and project expenses.

Finding Text

2024-002 U.S. Department Treasury: Coronavirus Capital Projects Fund, AL No.21.029 ACTIVITIES ALLOWED/UNALLOWED; ALLOWABLE COST / COST PRINCIPLES; REPORTING Condition: Materials were charged to project work orders when removed from inventory and not when installed. Reconciliations to contractor invoices, were not performed timely and differences were not identified in subsequent reconciliations tracking project activity for grant reporting. Criteria: Effective controls are required to ensure reported project materials and related expenses are installed, completed and adequately documented for approved project area. Controls should include timely reconciliation between work order charges and related contractor invoices supporting installation and materials used in order to support proper disbursement and reporting. Cause: Errors existed in the total materials charged to project work orders which were not identified timely by the Cooperative’s current monitoring and control activity procedures. Effect: Controls did not exist to adequately reconcile and report the material charges on project work orders used for grant reporting in a timely manner. As a result, errors may exist in reported project expenses. Questioned Cost and Context: Due to timing and volume of activity incurred on the grant project, material charges were evaluated in total for selected work orders as of December 31, 2024 and reconciled to contractor invoices over the same period. A statistically valid, random sample of 60 work order charges for the period of January 1, 2024, through December 31, 2024, revealed 4 work order charges for monthly materials that were not adequately supported. Testing identified errors of $29,962 in material charges of the $729,642 of material tested. Total material reimbursed by this grant was $1,063,778. Recommendation: Procedures should be implemented to ensure more timely reconciliation of material charges to work orders and reporting project grant expenses. Comprehensive documentation should be maintained to validate controls implemented for installation of materials. Procedures should include additional oversight and timely reconciliations of project expenses completed and reported. Grantee’s Response: Management concurs. There were large fiber installation projects still in process at year-end. Subsequent reconciliations have been completed. Controls and other project processes have been improved to ensure more timely reconciliation of material charge-outs to the timing of the installation of material.

Corrective Action Plan

2024-002 Noncompliance: Activities Allowed/Unallowed; Allowable Costs/Activities; Reporting A. Comments on Findings and Recommendations: We concur with the auditor’s findings and recommendations regarding reporting of project expenses and unidentified errors in project reconciliations completed by staff. B. Actions Taken or Planned: Management concurs. Large fiber installation project still in process at year-end. Subsequent reconciliations have been completed. Controls and other project processes have been improved to ensure more timely reconciliation of material charge-outs to the timing of the installation of material. Anticipated completion date: Completed Contact information for this finding: Amanda Burnett, Chief Financial Officer, 573-471-5821

Categories

Questioned Costs Allowable Costs / Cost Principles Subrecipient Monitoring Reporting Equipment & Real Property Management

Other Findings in this Audit

  • 1158046 2024-001
    Material Weakness Repeat
  • 1158047 2024-001
    Material Weakness Repeat
  • 1158048 2024-001
    Material Weakness Repeat
  • 1158049 2024-002
    Material Weakness Repeat
  • 1158050 2024-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.029 Coronavirus Capital Projects Fund Program $2.78M
21.027 Coronavirus State and Local Fiscal Recovery Funds $996,835
10.854 Rural Economic Development Loans and Grants $300,000
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $21,650