Finding 512851 (2020-001)

Material Weakness
Requirement
ABHLN
Questioned Costs
-
Year
2020
Accepted
2024-12-03
Audit: 330601
Organization: Dairyland Power Cooperative (WI)

AI Summary

  • Core Issue: There are significant weaknesses in internal controls over compliance for federal disaster grants, particularly regarding documentation of controls for non-payroll expenses and reporting.
  • Impacted Requirements: The lack of maintained evidence for control design and operation raises risks of noncompliance with federal award terms, potentially jeopardizing funding.
  • Recommended Follow-Up: Management should establish processes to ensure proper documentation of control design, implementation, and operation to meet compliance requirements.

Finding Text

2020 ‐ 001: Material Weaknesses in Internal Controls over Compliance— Activities Allowed and Allowable Costs for Non-payroll expenses, Period of Performance, Reporting, and Special Test and Provisions. Federal Program - Disaster Grants - Public Assistance (Presidentially Declared Disasters) – ALN 97.036 Year: 2020 Federal Agency: US Department of Homeland Security Pass-Through Entity: The Minnesota Division of Homeland Security Criteria — Recipients receiving Federal awards must establish and maintain effective internal controls over the Federal awards that provide reasonable assurance the recipient is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal awards. A structured review process is a key element of any effective internal control framework designed to prevent or detect noncompliance. Condition — When performing procedures to obtain an understanding of internal controls over the program, there was no evidence maintained of designed, implemented, and operating controls for fiscal year 2020. Cause — The entity had turnover of program staff and a change in its IT systems subsequent to the grant expenses being incurred and the audit being performed. These changes resulted in a lack of evidence maintained from the period of the related expenses to support the design, implementation, and operations of the entity’s controls over compliance with federal awards terms and conditions. Effect — The failure to maintain adequate evidence of the design, implementation and operation of controls over compliance could lead to noncompliance with the terms and conditions of federal awards and potential loss of funding. Questioned Cost — N/A Context —The understanding of the internal controls yielded the following results: Compliance requirement Control Finding Activities Allowed and Allowable Costs (Non-Payroll) & Period of Performance There was no evidence maintained to support the design, implementation or operation of the control in place to ensure that vendor invoices were accurately reviewed for allowability and that it was incurred in the period stipulated in the grant agreement prior to the submission for reimbursement. Reporting & Special Test There was no evidence maintained to support the design, implementation or operation of the control in place to ensure a proper review was performed prior to the deadline to verify if the report was accurate and complete. Recommendation — Management should design processes to ensure that evidence of their controls design, implementation and operation are maintained to support the compliance with the terms and conditions of their grant awards. View of Responsible Officials — See Corrective Action Plan

Corrective Action Plan

2020 ‐ 001: Material Weaknesses in Internal Controls over Compliance— Activities Allowed and Allowable Costs for Non-payroll expenses, Period of Performance, Reporting, and Special Test and Provisions. Compliance requirement Corrective Action Activities Allowed/Allowable Costs and Period of Performance Microsoft D365 was implemented in 2022 as the ERP system for Dairyland Power. Microsoft D365 will allow for project tracking ensuring appropriate approval workflows specific to federal assistance programs. Workflows will be set to ensure costs are routed to personnel who have authority to approve and also have knowledge of cost allowability as stipulated by the federal award. The system also supports historical data requirements by allowing retention of documents withing the system at the transaction level. The use of the Microsoft D365 ERP will ensure the evidence of approval for non-payroll expenses would be appropriately logged and retained within the system. This corrective action is currently in place. Reporting and Special Test and Provision Dairyland Power has recently established Grant Policies to ensure that internal processes are managed in compliance with federal awards. An Allowable Cost Policy was created to clearly define roles and responsibilities for the management of federal awards and also identifies the review and approval process of reimbursement requests/reports. A multi-layer approval process for the approval of reimbursement exists. The Project manager, in coordination with the Grant Specialist and the Compliance Team, will review federal project costs and prepare reimbursement reports per the instructions. The reimbursement request/report will then be submitted to the Grant Manager, who will review the reimbursement request/report for cost allowability and completeness. Upon approval from the Grant Manager, the reimbursement request will be forwarded to the Treasury Manager who will review, approve, and submit the request through the proper submission channel by the deadline. Evidence of review will be saved for documentation purposes. Dairyland Management will conduct an annual review of the established Grant Policies or reassess them when necessary. Employees at Dairyland who participate in the federal award process will be provided with training on the Grant Policies. This corrective action is currently in place. In addition to the above corrective action, Dairyland Power has also engaged an external audit service to conduct a review of the design and operating effectiveness of Dairyland’s grant process internal controls. The purpose is to provide Dairyland with a comprehensive assessment of the existing Dairyland internal control processes and policies related to federal awards. Expected completion of this audit is January 2025. Anticipated Completion Date — January 2025 Responsible Party — Tim Lightfoot, Controller

Categories

Subrecipient Monitoring Allowable Costs / Cost Principles Cash Management Material Weakness Period of Performance Reporting Internal Control / Segregation of Duties Special Tests & Provisions

Other Findings in this Audit

  • 1089293 2020-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $874,351