Finding 607617 (2022-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-09-24

AI Summary

  • Core Issue: Performance reports for VOCA grants were inaccurately submitted, with discrepancies between source data and reported metrics.
  • Impacted Requirements: Monthly or quarterly reporting of metrics related to program performance is not reliable, affecting compliance with grant objectives.
  • Recommended Follow-Up: Establish robust internal controls and maintain documentation to ensure accurate data collection and reporting for all grant metrics.

Finding Text

2022-002: REPORTING--VOCA Condition and Criteria: Performance reports must be submitted monthly or quarterly detailing the progress of performance based on metrics identified by the Office for Victims of Crime (OVC) (VOCA grants). 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 VOCA grants. 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 a repeat finding from the 2021 audit. Finding number was 2021-001. 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. Recommendations in the prior Corrective Action Plans were adopted and phased in beginning September 2023. Those recommendations were: ? Additional staff have been trained to review data entered into the client database monthly for quality assurance prior to running the reports used to complete program reports for grants. Three staff members complete this review monthly. ? Data is being entered into the client database and monitored regularly. ? Standardized reports from database are used to compile program reports and backup documentation is saved. ? Program reports are reviewed and approved by Chief Program Officer or Chief Executive Officer prior to submission to granting agency. ? Program staff are entering client data into the client database in a timely manner. All client data must be entered before monthly reports are compiled. This data is also compiled in a Google doc which Senior Director compares to output from database. ? Client bed nights are being tracked in the client database rather than on a paper residential log. ? YWCA has requested an additional field be added to the client database to allow more detailed and accurate reporting. ? Senior Director has conducted trainings for all staff related to accurate and timely collection and entry of client data into database. YWCA continues to follow the preceding recommendations and has implemented the following additional internal controls and procedures to ensure data quality: ? Confirm best practice approaches with other victim service providers on data collection process and program reports. ? CEO, CFO and Director are reviewing data collection and program report process to ensure accuracy and compliance. ? Director of DVIPP and Client Services Specialist are building a detailed process manual to provide clear guidance on program report process (including, but not limited to, data collection/entry, how to write the narratives and collect numbers for program reports). The detailed process manual will streamline procedures and clarify roles and responsibilities to all involved in program reports.

Categories

HUD Housing Programs Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 31175 2022-002
    Material Weakness Repeat
  • 31176 2022-002
    Material Weakness Repeat
  • 31177 2022-002
    Material Weakness Repeat
  • 31178 2022-003
    Material Weakness
  • 607618 2022-002
    Material Weakness Repeat
  • 607619 2022-002
    Material Weakness Repeat
  • 607620 2022-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $172,126
14.267 Continuum of Care Program $128,086
93.436 Well-Integrated Screening and Evaluation for Women Across the Nation (wisewoman) $75,946
93.136 Injury Prevention and Control Research and State and Community Based Programs $65,502
97.024 Emergency Food and Shelter National Board Program $33,057
16.588 Violence Against Women Formula Grants $28,686
93.667 Social Services Block Grant $21,800
16.575 Crime Victim Assistance $11,406
14.231 Emergency Solutions Grant Program $7,309
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $6,855
14.218 Community Development Block Grants/entitlement Grants $6,200