Finding 570636 (2024-004)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2024
Accepted
2025-07-08
Audit: 361664
Organization: The Mirror, Inc. (KS)

AI Summary

  • Core Issue: Federal awards were missing from the schedule of expenditures due to inadequate tracking and communication between departments.
  • Impacted Requirements: Internal controls for completeness and accuracy of federal awards schedules were not followed, risking unauthorized or incorrect financial reporting.
  • Recommended Follow-Up: Develop written policies for centralized grant record maintenance and establish a review process to ensure all federal awards are accurately tracked.

Finding Text

Criteria: Internal controls should be in place to ensure the schedule of federal awards is complete and accurate. In addition, a review of the schedule should be performed by an individual other than the individual performing the reconciliation. Condition and Context: Throughout the performance of audit procedures, the auditor identified federal awards that were not included on the schedule of expenditures of federal awards. Grant documents were not received by the accounting department to be able to track and identify the federal awards throughout the year. Cause: The Organization has limited written procedures for the acceptance and tracking of federal awards. The limited procedures lack requiring the timely communication between departments to summarize the federal award information accurately. Effect: The lack of identification of federal awards may result in the occurrence of unauthorized or inaccurate activity recorded within the Organization’s records and reflected on the interim financial statements. Recommendation: We recommend the Organization develop written policies establishing a centralized process to maintain grant records and a process to review the documents for federal funding, and track the federal grants in the aggregate to monitor the applicability of whether a Single Audit under Uniform Guidance is necessary. Management Response: Policies are being implemented to ensure appropriate identification, review process, and tracking of federal awards, see corrective action plan.

Corrective Action Plan

Plan: • Implementing new work flows around grants being awarded. Ensuring all grants are tracked in a single location with identifications within the spreadsheet to track federal awards. Implementation Date: Beginning of Fiscal Year 26- July 1, 2025 Responsible Party: Shelby Turner CFO will review staffs entries on the spreadsheet to ensure necessary data/information for each grant is being kept, in order to have a SEFA prepared for each audit.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 570633 2024-001
    Material Weakness
  • 570634 2024-002
    Material Weakness
  • 570635 2024-003
    Material Weakness
  • 570637 2024-005
    Material Weakness
  • 570638 2024-006
    Material Weakness
  • 1147075 2024-001
    Material Weakness
  • 1147076 2024-002
    Material Weakness
  • 1147077 2024-003
    Material Weakness
  • 1147078 2024-004
    Material Weakness
  • 1147079 2024-005
    Material Weakness
  • 1147080 2024-006
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.558 Temporary Assistance for Needy Families $585,586
93.276 Drug-Free Communities Support Program Grants $143,053
21.027 Coronavirus State and Local Fiscal Recovery Funds $138,904
93.959 Block Grants for Prevention and Treatment of Substance Abuse $48,745
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $37,425