Audit 11457

FY End
2022-12-31
Total Expended
$1.69M
Findings
12
Programs
14
Year: 2022 Accepted: 2024-01-15

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
8497 2022-003 Significant Deficiency Yes ABCEGHLN
8498 2022-004 Material Weakness - ABCEGHLN
8499 2022-005 Material Weakness - ABCEGHLN
8500 2022-003 Significant Deficiency Yes ABCEGHLN
8501 2022-004 Material Weakness - ABCEGHLN
8502 2022-005 Material Weakness - ABCEGHLN
584939 2022-003 Significant Deficiency Yes ABCEGHLN
584940 2022-004 Material Weakness - ABCEGHLN
584941 2022-005 Material Weakness - ABCEGHLN
584942 2022-003 Significant Deficiency Yes ABCEGHLN
584943 2022-004 Material Weakness - ABCEGHLN
584944 2022-005 Material Weakness - ABCEGHLN

Contacts

Name Title Type
RPLELMBR4WJ9 Danielle Brown Auditee
8162324481 Amy Hanway Auditor
No contacts on file

Notes to SEFA

Title: BASIS OF PRESENTATION Accounting Policies: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES Expenditures reported on the accompanying schedule of expenditures of federal awards (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. The YWCA has elected to not use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. Pass-through entity identifYing numbers are presented where available. De Minimis Rate Used: N Rate Explanation: THE AUDITEE DID NOT USE THE DE MINIMIS RATE OF 10% OF MODIFIED TOTAL DIRECT COSTS, THE RATES USED WERE BASED ON USAGE OF THE BUILDING OR OTHER APPLICABLE CRITERIA TO RESEMBLE ACTUAL USE OF THE COSTS. The Schedule includes the federal grant activity of the Young Women's Christian Association of St. Joseph, Missouri 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 Requirement for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Young Women's Christian Association of St. Joseph, Missouri, it is not intended to and does not present the financial position, statement of activities and change in net assets, or cash flows of the Young Women's Christian Association of St. Joseph, Missouri.

Finding Details

Condition: The duties of preparing deposits, investigating discrepancies, maintaining master files, maintaining the general ledger, making deposits, reconciling the bank accounts, investigating problems with payables and resolving inquiries and editing the payroll master file are concentrated iIi one person's duties. The duties of opening the mail, authorizing write-offs, authorizing and signing checks and authorizing payroll are concentrated in another person's duties. The duties of recording receipts, updating accounts and pledges receivable, initiating checks for expenditure, updating accounts payable and preparing checks are concentrated in another person's duties. The duties of recording receipts, updating accounts and pledge receivable, initiating checks and updating accounts payable are concentrated in another person's duties. The duties of preparing payroll and resolving inquiries and editing payroll master file are concentrated in another person's duties. Criteria: Internal controls should be in place that provide an adequate segregation of duties that separates initiating, processing, recording and reconciling a transaction. Cause: The size of the Organization's accounting staff precludes certain internal controls that would be preferred if staff were large enough to provide optimum segregation of duties. Effect: Without a separation of duties, errors or irregularities can occur and not be discovered in the nonnal course of business. Recommendation: This deficiency is the result of the limited accounting staff of the Organization. We recommend that the Board and CEO continue active involvement by reviewing operating statements, comparisons to budget, receivables, receipts and disbursements, to add to existing internal controls in the Organization. Response: This will be reviewed and assessed to find where duties can be separated and independently perfonned within staff.
Condition: Many of the Organizations' general ledger accounts were not in balance with supporting details and were not reconciled throughout the year on a monthly basis. Criteria: Financial Statement accounts should be reconciled on a monthly basis to ensure proper financial reports. Cause: Employee turnover throughout the year made it difficult for the financial statements to be kept up every month. Effect: The financial statements looked at every month are not accurate and this could be misleading. Recommendation: We recommend that all financial statement accounts be reconciled on a timely basis so that all financial reports being reviewed are accurate. Response: Financial statements will be reconciled on a monthly basis and reviewed by the board. Adjustments that need to be made will be made in a timely manner to ensure the continued integrity of the financial statements.
Condition: A SEF A was prepared by the Organization but there was changes that were made during the audit to get to a complete and accurate SEF A. Criteria: The SEF A should include all expenditures of federal awards. Cause: Employee turnover throughout the year caused the financials to not be accurate and balanced. Effect: The SEF A prepared by the Organization did not include all federal expenses. Recommendation: We recommend that all federal awards be balanced on a monthly basis to ensure the preparation of the SEF A is accurate. Response: In addition to the above, project codes will be implemented in GL for all funds so that all fund sources and expenses can be identified and reconciled monthly.
Condition: The duties of preparing deposits, investigating discrepancies, maintaining master files, maintaining the general ledger, making deposits, reconciling the bank accounts, investigating problems with payables and resolving inquiries and editing the payroll master file are concentrated iIi one person's duties. The duties of opening the mail, authorizing write-offs, authorizing and signing checks and authorizing payroll are concentrated in another person's duties. The duties of recording receipts, updating accounts and pledges receivable, initiating checks for expenditure, updating accounts payable and preparing checks are concentrated in another person's duties. The duties of recording receipts, updating accounts and pledge receivable, initiating checks and updating accounts payable are concentrated in another person's duties. The duties of preparing payroll and resolving inquiries and editing payroll master file are concentrated in another person's duties. Criteria: Internal controls should be in place that provide an adequate segregation of duties that separates initiating, processing, recording and reconciling a transaction. Cause: The size of the Organization's accounting staff precludes certain internal controls that would be preferred if staff were large enough to provide optimum segregation of duties. Effect: Without a separation of duties, errors or irregularities can occur and not be discovered in the nonnal course of business. Recommendation: This deficiency is the result of the limited accounting staff of the Organization. We recommend that the Board and CEO continue active involvement by reviewing operating statements, comparisons to budget, receivables, receipts and disbursements, to add to existing internal controls in the Organization. Response: This will be reviewed and assessed to find where duties can be separated and independently perfonned within staff.
Condition: Many of the Organizations' general ledger accounts were not in balance with supporting details and were not reconciled throughout the year on a monthly basis. Criteria: Financial Statement accounts should be reconciled on a monthly basis to ensure proper financial reports. Cause: Employee turnover throughout the year made it difficult for the financial statements to be kept up every month. Effect: The financial statements looked at every month are not accurate and this could be misleading. Recommendation: We recommend that all financial statement accounts be reconciled on a timely basis so that all financial reports being reviewed are accurate. Response: Financial statements will be reconciled on a monthly basis and reviewed by the board. Adjustments that need to be made will be made in a timely manner to ensure the continued integrity of the financial statements.
Condition: A SEF A was prepared by the Organization but there was changes that were made during the audit to get to a complete and accurate SEF A. Criteria: The SEF A should include all expenditures of federal awards. Cause: Employee turnover throughout the year caused the financials to not be accurate and balanced. Effect: The SEF A prepared by the Organization did not include all federal expenses. Recommendation: We recommend that all federal awards be balanced on a monthly basis to ensure the preparation of the SEF A is accurate. Response: In addition to the above, project codes will be implemented in GL for all funds so that all fund sources and expenses can be identified and reconciled monthly.
Condition: The duties of preparing deposits, investigating discrepancies, maintaining master files, maintaining the general ledger, making deposits, reconciling the bank accounts, investigating problems with payables and resolving inquiries and editing the payroll master file are concentrated iIi one person's duties. The duties of opening the mail, authorizing write-offs, authorizing and signing checks and authorizing payroll are concentrated in another person's duties. The duties of recording receipts, updating accounts and pledges receivable, initiating checks for expenditure, updating accounts payable and preparing checks are concentrated in another person's duties. The duties of recording receipts, updating accounts and pledge receivable, initiating checks and updating accounts payable are concentrated in another person's duties. The duties of preparing payroll and resolving inquiries and editing payroll master file are concentrated in another person's duties. Criteria: Internal controls should be in place that provide an adequate segregation of duties that separates initiating, processing, recording and reconciling a transaction. Cause: The size of the Organization's accounting staff precludes certain internal controls that would be preferred if staff were large enough to provide optimum segregation of duties. Effect: Without a separation of duties, errors or irregularities can occur and not be discovered in the nonnal course of business. Recommendation: This deficiency is the result of the limited accounting staff of the Organization. We recommend that the Board and CEO continue active involvement by reviewing operating statements, comparisons to budget, receivables, receipts and disbursements, to add to existing internal controls in the Organization. Response: This will be reviewed and assessed to find where duties can be separated and independently perfonned within staff.
Condition: Many of the Organizations' general ledger accounts were not in balance with supporting details and were not reconciled throughout the year on a monthly basis. Criteria: Financial Statement accounts should be reconciled on a monthly basis to ensure proper financial reports. Cause: Employee turnover throughout the year made it difficult for the financial statements to be kept up every month. Effect: The financial statements looked at every month are not accurate and this could be misleading. Recommendation: We recommend that all financial statement accounts be reconciled on a timely basis so that all financial reports being reviewed are accurate. Response: Financial statements will be reconciled on a monthly basis and reviewed by the board. Adjustments that need to be made will be made in a timely manner to ensure the continued integrity of the financial statements.
Condition: A SEF A was prepared by the Organization but there was changes that were made during the audit to get to a complete and accurate SEF A. Criteria: The SEF A should include all expenditures of federal awards. Cause: Employee turnover throughout the year caused the financials to not be accurate and balanced. Effect: The SEF A prepared by the Organization did not include all federal expenses. Recommendation: We recommend that all federal awards be balanced on a monthly basis to ensure the preparation of the SEF A is accurate. Response: In addition to the above, project codes will be implemented in GL for all funds so that all fund sources and expenses can be identified and reconciled monthly.
Condition: The duties of preparing deposits, investigating discrepancies, maintaining master files, maintaining the general ledger, making deposits, reconciling the bank accounts, investigating problems with payables and resolving inquiries and editing the payroll master file are concentrated iIi one person's duties. The duties of opening the mail, authorizing write-offs, authorizing and signing checks and authorizing payroll are concentrated in another person's duties. The duties of recording receipts, updating accounts and pledges receivable, initiating checks for expenditure, updating accounts payable and preparing checks are concentrated in another person's duties. The duties of recording receipts, updating accounts and pledge receivable, initiating checks and updating accounts payable are concentrated in another person's duties. The duties of preparing payroll and resolving inquiries and editing payroll master file are concentrated in another person's duties. Criteria: Internal controls should be in place that provide an adequate segregation of duties that separates initiating, processing, recording and reconciling a transaction. Cause: The size of the Organization's accounting staff precludes certain internal controls that would be preferred if staff were large enough to provide optimum segregation of duties. Effect: Without a separation of duties, errors or irregularities can occur and not be discovered in the nonnal course of business. Recommendation: This deficiency is the result of the limited accounting staff of the Organization. We recommend that the Board and CEO continue active involvement by reviewing operating statements, comparisons to budget, receivables, receipts and disbursements, to add to existing internal controls in the Organization. Response: This will be reviewed and assessed to find where duties can be separated and independently perfonned within staff.
Condition: Many of the Organizations' general ledger accounts were not in balance with supporting details and were not reconciled throughout the year on a monthly basis. Criteria: Financial Statement accounts should be reconciled on a monthly basis to ensure proper financial reports. Cause: Employee turnover throughout the year made it difficult for the financial statements to be kept up every month. Effect: The financial statements looked at every month are not accurate and this could be misleading. Recommendation: We recommend that all financial statement accounts be reconciled on a timely basis so that all financial reports being reviewed are accurate. Response: Financial statements will be reconciled on a monthly basis and reviewed by the board. Adjustments that need to be made will be made in a timely manner to ensure the continued integrity of the financial statements.
Condition: A SEF A was prepared by the Organization but there was changes that were made during the audit to get to a complete and accurate SEF A. Criteria: The SEF A should include all expenditures of federal awards. Cause: Employee turnover throughout the year caused the financials to not be accurate and balanced. Effect: The SEF A prepared by the Organization did not include all federal expenses. Recommendation: We recommend that all federal awards be balanced on a monthly basis to ensure the preparation of the SEF A is accurate. Response: In addition to the above, project codes will be implemented in GL for all funds so that all fund sources and expenses can be identified and reconciled monthly.