Audit 174138

FY End
2022-12-31
Total Expended
$2.30M
Findings
6
Programs
11
Organization: YWCA Northeast Indiana, Inc. (IN)
Year: 2022 Accepted: 2023-09-12

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
204814 2022-001 Material Weakness - P
204815 2022-001 Material Weakness - P
204816 2022-001 Material Weakness - P
781256 2022-001 Material Weakness - P
781257 2022-001 Material Weakness - P
781258 2022-001 Material Weakness - P

Contacts

Name Title Type
RYM2JU69ZB34 Greg Johnson Auditee
2604244908 Susan Berghoff Auditor
No contacts on file

Notes to SEFA

Accounting Policies: 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. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

2022-001 Federal Grantor: All Programs Pass-through Grantor: All Programs Federal Assistance Listing Number: All Programs Program Title: All Programs Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Audits (Uniform Guidance) requires auditees to prepare an accurate Schedule of Expenditures of Federal Awards (SEFA) containing awards expended, assistance listing title and number, award number, name of the Federal Agency, name of the pass-through entity, and awards paid to subrecipients. Condition: During our audit we noted the SEFA contained errors. The Organization?s current internal control over the SEFA reporting is not sufficient enough to ensure correct reporting. Assistance As Reported Listing On Original Number SEFA As Corrected $ Difference 14.228 $103,968 $ 103,968 $ - 14.231 1,139,267 934,588 (204,679) 14.267 130,169 101,173 (28,996) 16.017 49,790 50,655 865 16.575 542,247 638,257 96,010 16.588 42,677 42,847 170 21.027 82,619 88,550 5,931 93.497 9,282 42,683 33,401 93.569 82,342 82,594 252 93.667 32,148 32,148 - 93.671 145,691 181,732 36,041 $ 2,360,200 $ 2,299,195 $ (61,005) Cause: Management failed to follow reporting requirements related to the SEFA. Effect: Federal expenditures reported in the SEFA were incorrect. Questioned costs: None Recommendation: We recommend management develop internal controls over reporting and consult with external consultants, if necessary, to ensure an accurate SEFA is prepared. Management?s Response: See corrective action plan on page 41.
2022-001 Federal Grantor: All Programs Pass-through Grantor: All Programs Federal Assistance Listing Number: All Programs Program Title: All Programs Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Audits (Uniform Guidance) requires auditees to prepare an accurate Schedule of Expenditures of Federal Awards (SEFA) containing awards expended, assistance listing title and number, award number, name of the Federal Agency, name of the pass-through entity, and awards paid to subrecipients. Condition: During our audit we noted the SEFA contained errors. The Organization?s current internal control over the SEFA reporting is not sufficient enough to ensure correct reporting. Assistance As Reported Listing On Original Number SEFA As Corrected $ Difference 14.228 $103,968 $ 103,968 $ - 14.231 1,139,267 934,588 (204,679) 14.267 130,169 101,173 (28,996) 16.017 49,790 50,655 865 16.575 542,247 638,257 96,010 16.588 42,677 42,847 170 21.027 82,619 88,550 5,931 93.497 9,282 42,683 33,401 93.569 82,342 82,594 252 93.667 32,148 32,148 - 93.671 145,691 181,732 36,041 $ 2,360,200 $ 2,299,195 $ (61,005) Cause: Management failed to follow reporting requirements related to the SEFA. Effect: Federal expenditures reported in the SEFA were incorrect. Questioned costs: None Recommendation: We recommend management develop internal controls over reporting and consult with external consultants, if necessary, to ensure an accurate SEFA is prepared. Management?s Response: See corrective action plan on page 41.
2022-001 Federal Grantor: All Programs Pass-through Grantor: All Programs Federal Assistance Listing Number: All Programs Program Title: All Programs Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Audits (Uniform Guidance) requires auditees to prepare an accurate Schedule of Expenditures of Federal Awards (SEFA) containing awards expended, assistance listing title and number, award number, name of the Federal Agency, name of the pass-through entity, and awards paid to subrecipients. Condition: During our audit we noted the SEFA contained errors. The Organization?s current internal control over the SEFA reporting is not sufficient enough to ensure correct reporting. Assistance As Reported Listing On Original Number SEFA As Corrected $ Difference 14.228 $103,968 $ 103,968 $ - 14.231 1,139,267 934,588 (204,679) 14.267 130,169 101,173 (28,996) 16.017 49,790 50,655 865 16.575 542,247 638,257 96,010 16.588 42,677 42,847 170 21.027 82,619 88,550 5,931 93.497 9,282 42,683 33,401 93.569 82,342 82,594 252 93.667 32,148 32,148 - 93.671 145,691 181,732 36,041 $ 2,360,200 $ 2,299,195 $ (61,005) Cause: Management failed to follow reporting requirements related to the SEFA. Effect: Federal expenditures reported in the SEFA were incorrect. Questioned costs: None Recommendation: We recommend management develop internal controls over reporting and consult with external consultants, if necessary, to ensure an accurate SEFA is prepared. Management?s Response: See corrective action plan on page 41.
2022-001 Federal Grantor: All Programs Pass-through Grantor: All Programs Federal Assistance Listing Number: All Programs Program Title: All Programs Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Audits (Uniform Guidance) requires auditees to prepare an accurate Schedule of Expenditures of Federal Awards (SEFA) containing awards expended, assistance listing title and number, award number, name of the Federal Agency, name of the pass-through entity, and awards paid to subrecipients. Condition: During our audit we noted the SEFA contained errors. The Organization?s current internal control over the SEFA reporting is not sufficient enough to ensure correct reporting. Assistance As Reported Listing On Original Number SEFA As Corrected $ Difference 14.228 $103,968 $ 103,968 $ - 14.231 1,139,267 934,588 (204,679) 14.267 130,169 101,173 (28,996) 16.017 49,790 50,655 865 16.575 542,247 638,257 96,010 16.588 42,677 42,847 170 21.027 82,619 88,550 5,931 93.497 9,282 42,683 33,401 93.569 82,342 82,594 252 93.667 32,148 32,148 - 93.671 145,691 181,732 36,041 $ 2,360,200 $ 2,299,195 $ (61,005) Cause: Management failed to follow reporting requirements related to the SEFA. Effect: Federal expenditures reported in the SEFA were incorrect. Questioned costs: None Recommendation: We recommend management develop internal controls over reporting and consult with external consultants, if necessary, to ensure an accurate SEFA is prepared. Management?s Response: See corrective action plan on page 41.
2022-001 Federal Grantor: All Programs Pass-through Grantor: All Programs Federal Assistance Listing Number: All Programs Program Title: All Programs Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Audits (Uniform Guidance) requires auditees to prepare an accurate Schedule of Expenditures of Federal Awards (SEFA) containing awards expended, assistance listing title and number, award number, name of the Federal Agency, name of the pass-through entity, and awards paid to subrecipients. Condition: During our audit we noted the SEFA contained errors. The Organization?s current internal control over the SEFA reporting is not sufficient enough to ensure correct reporting. Assistance As Reported Listing On Original Number SEFA As Corrected $ Difference 14.228 $103,968 $ 103,968 $ - 14.231 1,139,267 934,588 (204,679) 14.267 130,169 101,173 (28,996) 16.017 49,790 50,655 865 16.575 542,247 638,257 96,010 16.588 42,677 42,847 170 21.027 82,619 88,550 5,931 93.497 9,282 42,683 33,401 93.569 82,342 82,594 252 93.667 32,148 32,148 - 93.671 145,691 181,732 36,041 $ 2,360,200 $ 2,299,195 $ (61,005) Cause: Management failed to follow reporting requirements related to the SEFA. Effect: Federal expenditures reported in the SEFA were incorrect. Questioned costs: None Recommendation: We recommend management develop internal controls over reporting and consult with external consultants, if necessary, to ensure an accurate SEFA is prepared. Management?s Response: See corrective action plan on page 41.
2022-001 Federal Grantor: All Programs Pass-through Grantor: All Programs Federal Assistance Listing Number: All Programs Program Title: All Programs Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Audits (Uniform Guidance) requires auditees to prepare an accurate Schedule of Expenditures of Federal Awards (SEFA) containing awards expended, assistance listing title and number, award number, name of the Federal Agency, name of the pass-through entity, and awards paid to subrecipients. Condition: During our audit we noted the SEFA contained errors. The Organization?s current internal control over the SEFA reporting is not sufficient enough to ensure correct reporting. Assistance As Reported Listing On Original Number SEFA As Corrected $ Difference 14.228 $103,968 $ 103,968 $ - 14.231 1,139,267 934,588 (204,679) 14.267 130,169 101,173 (28,996) 16.017 49,790 50,655 865 16.575 542,247 638,257 96,010 16.588 42,677 42,847 170 21.027 82,619 88,550 5,931 93.497 9,282 42,683 33,401 93.569 82,342 82,594 252 93.667 32,148 32,148 - 93.671 145,691 181,732 36,041 $ 2,360,200 $ 2,299,195 $ (61,005) Cause: Management failed to follow reporting requirements related to the SEFA. Effect: Federal expenditures reported in the SEFA were incorrect. Questioned costs: None Recommendation: We recommend management develop internal controls over reporting and consult with external consultants, if necessary, to ensure an accurate SEFA is prepared. Management?s Response: See corrective action plan on page 41.