Finding 1100110 (2023-004)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2025-02-19

AI Summary

  • Core Issue: Monthly and quarterly performance reports submitted to the Indiana Department of Health were inaccurate, failing to reflect the correct metrics.
  • Impacted Requirements: The lack of adequate internal controls led to discrepancies between source data and reported metrics, undermining the reliability of performance reports.
  • Recommended Follow-Up: Implement robust internal controls, establish a consistent reporting process, and conduct regular audits to ensure accuracy and compliance.

Finding Text

Condition and Criteria: Performance reports must be submitted monthly or quarterly detailing the progress of performance based on metrics identified by the Indiana Department of Health (IDOH). The metrics are detailed in the individual grant agreement. These metrics relate to the number of people served through the program and other non-financial objectives. Reporting for these metrics were not completed accurately. Cause: There is not an adequate internal control system to compare and maintain source data established to ensure source data mirrors metrics reported. Effect: Performance reports cannot be accurately relied upon to demonstrate the Organization has met the grant objectives. As these reports deal with performance metrics, there are no questioned costs identified. Context: Testing was conducted on three performance reports out of sixteen reports submitted for the calendar year for the above RPE grant. 100% of the reports tested had deviations between the source documents and the submitted report metrics for the reporting period. Metrics were under and over reported as compared to source data. Identification of Repeat Findings: This finding is not a repeat finding as RPE was not tested in 2022. Recommendation: Internal controls and procedures should be established and documentation maintained to support all program metrics surrounding each grant reporting. Views of Responsible Officials and Planned Corrective Actions: YWCA acknowledges discrepancies in data metrics reported. • Utilize & document consistent process and tools (Client Track database) for effective tracking and reporting for all program reports. • Establish a routine for random and planned audits to verify reporting accuracy. • Provide training on proper reporting procedures, best audit practices, and data entry accuracy. Tracking and Documentation: • All program reports will be organized by grant name, month, and year with program report and source document with two signatures to confirm the process (manager and Department Director). • All staff will sign off on training topics, with documentation saved in their personnel folder. • Random internal audits will be conducted bi-weekly throughout the year to ensure compliance.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 523665 2023-001
    Material Weakness
  • 523666 2023-002
    Material Weakness
  • 523667 2023-003
    Material Weakness Repeat
  • 523668 2023-004
    Material Weakness
  • 1100107 2023-001
    Material Weakness
  • 1100108 2023-002
    Material Weakness
  • 1100109 2023-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
16.575 Crime Victim Assistance $326,753
14.267 Domestic Violence Bonus $114,598
93.898 Breast and Cervical Cancer $99,116
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $80,050
93.898 Wisewomen $59,187
93.136 Rape Prevention and Education $58,703
14.218 Community Development Block Grants/entitlement Grants $35,422
16.588 Stop $30,205
93.667 Social Services Block Grant $21,800
14.231 Emergency Solutions Grant Program $14,100
96.898 Wisewomen $2,688