Audit 37339

FY End
2022-12-31
Total Expended
$1.08M
Findings
8
Programs
11
Year: 2022 Accepted: 2023-09-24

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
31175 2022-002 Material Weakness Yes L
31176 2022-002 Material Weakness Yes L
31177 2022-002 Material Weakness Yes L
31178 2022-003 Material Weakness - L
607617 2022-002 Material Weakness Yes L
607618 2022-002 Material Weakness Yes L
607619 2022-002 Material Weakness Yes L
607620 2022-003 Material Weakness - L

Contacts

Name Title Type
HKAEMLKLC9N1 Melissa Martin Auditee
7657420075 Kimberley Morisette Auditor
No contacts on file

Notes to SEFA

Title: NOTE D: PASSED THROUGH TO SUBRECIPIENTS Accounting Policies: NOTE A: BASIS OF PRESENTATION The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of the Organization under programs of the federal government for the year ended December 31, 2022. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Organization, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the Organization. NOTE B: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES A) Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. B)Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: NOTE C: INDIRECT COST RATE: The Organization has elected to not use the 10% de minimis indirect cost rate allowed under Uniform Guidance. The Organization had no awards that were passed through to subrecipients.

Finding Details

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.
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.
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.
2022-003: REPORTING--STOP Condition and Criteria: Performance reports must be submitted monthly or quarterly detailing the progress of performance based on metrics identified by the Office for Violence Against Woman (OVAW). 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 two performance reports out of thirteen reports submitted for the calendar year for the above STOP 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 not a repeat finding as STOP was not tested in 2021. 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 Corrective Action Plan were adopted and phased in beginning September 2023. Those recommendations were: ? 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.
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.
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.
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.
2022-003: REPORTING--STOP Condition and Criteria: Performance reports must be submitted monthly or quarterly detailing the progress of performance based on metrics identified by the Office for Violence Against Woman (OVAW). 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 two performance reports out of thirteen reports submitted for the calendar year for the above STOP 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 not a repeat finding as STOP was not tested in 2021. 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 Corrective Action Plan were adopted and phased in beginning September 2023. Those recommendations were: ? 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.