Audit 36821

FY End
2022-06-30
Total Expended
$22.20M
Findings
12
Programs
25
Year: 2022 Accepted: 2023-03-13
Auditor: Dwc CPAS LLC

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
39698 2022-006 Material Weakness - L
39699 2022-006 Material Weakness - L
39700 2022-006 Material Weakness - L
39701 2022-006 Material Weakness - L
39702 2022-006 Material Weakness - L
39703 2022-006 Material Weakness - L
616140 2022-006 Material Weakness - L
616141 2022-006 Material Weakness - L
616142 2022-006 Material Weakness - L
616143 2022-006 Material Weakness - L
616144 2022-006 Material Weakness - L
616145 2022-006 Material Weakness - L

Programs

ALN Program Spent Major Findings
21.023 Covid-19 Emergency Rental Assistance Program $1.63M Yes 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $1.54M Yes 0
93.568 Covid-19 Low-Income Home Energy Assistance $1.10M Yes 1
93.569 Community Services Block Grant $833,504 - 0
93.667 Social Services Block Grant $728,264 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $670,261 Yes 0
93.569 Covid-19 Community Services Block Grant $630,949 - 0
93.778 Medical Assistance Program $514,678 Yes 0
14.231 Covid-19 Emergency Solutions Grant Program $472,395 - 0
93.053 Nutrition Services Incentive Program $337,107 Yes 0
93.778 Covid-19 Medical Assistance Program $308,708 Yes 0
81.042 Weatherization Assistance for Low-Income Persons $244,881 - 0
94.011 Foster Grandparent Program $139,289 - 0
93.568 Low-Income Home Energy Assistance $91,497 Yes 1
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $89,379 - 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $40,267 - 0
93.044 Covid-19 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $38,595 Yes 0
93.048 Covid-19 Special Programs for the Aging_title Iv_and Title Ii_discretionary Projects $35,000 - 0
14.218 Community Development Block Grants/entitlement Grants $28,898 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $26,296 - 0
93.470 Alzheimer's Disease Program Initiative (adpi) $23,009 - 0
93.042 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $15,474 - 0
97.024 Emergency Food and Shelter National Board Program $14,000 - 0
93.041 Special Programs for the Aging_title Vii, Chapter 3_programs for Prevention of Elder Abuse, Neglect, and Exploitation $8,965 - 0
93.048 Special Programs for the Aging_title Iv_and Title Ii_discretionary Projects $1,795 - 0

Contacts

Name Title Type
GUULBJ28J683 Karla Ann Fales Auditee
5742847101 Richard J. Cullar Auditor
No contacts on file

Notes to SEFA

Title: FAIR MARKET VALUE OF DONATED PERSONAL PROTECTIVE EQUIPMENT (UNAUDITED) Accounting Policies: The accompanying consolidated schedule of expenditures of federal and nonfederal awards (the Schedule) includes the federal and nonfederal award activities of Real Services, Inc. and Affiliates under programs of the federal and nonfederal governments for the year ended June 30, 2022. The information in the 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 Real Services, Inc. and Affiliates, it is not intended to and does not present the consolidated financial position, changes in net assets, or cash flows of Real Services, Inc. and Affiliates.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.The Indiana Housing and Community Development Authority (IHCDA) makes energy assistance payments for participants in the Low-Income Home Energy Assistance Program, Federal Assistance Listing Number #93.568, directly to the energy providers on behalf of entities administering the program. Because the Organization performs all intake functions and is liable for errors made in determining participant eligibility, such payments made by IHCDA to the providers, totaling $11,648,647 (including $5,939,058 for COVID-19 assistance), are included in federal expenditures in the accompanying Schedule. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. During the year ended June 30, 2022, REAL Services, Inc. did not receive donated personal protective equipment from federal sources.

Finding Details

Criteria: The Uniform Guidance requires the auditee to prepare a complete and accurate Schedule of Expenditures of Federal Awards. In addition, Title 2 U.S. Code of Federal Regulations Part 200, Appendix XI 2022 Compliance Supplement Appendix VII Other Audit Advisories requires recipients and subrecipients to separately identify COVID-19 Emergency Acts expenditures on the Schedule. Condition: The Schedule of Expenditures of Federal and Nonfederal Awards (the Schedule) prepared by the Organization did not separately identify American Rescue Plan COVID-19 funding for Assistance Listing No. 93.568 awards. In addition, the Schedule prepared by the Organization contained many pass-through award identification numbers that were not updated from the prior year, mis-identified certain awards as being COVID-19 funded when they weren?t, and contained various classification errors. Cause: Management was unable to accurately identify the source of funding and other information included on the Schedule. Effect or Potential Effect: The Organization did not comply with Federal regulations regarding federal award reporting. The late identification of certain funding delayed completion of the audit. Context: Prior to audit adjustments, the Schedule contained material errors. Repeat Finding: No. Recommendations: We recommend that management provide adequate resources to the Finance and Administration department to properly manage, track, and report grant awards.
Criteria: The Uniform Guidance requires the auditee to prepare a complete and accurate Schedule of Expenditures of Federal Awards. In addition, Title 2 U.S. Code of Federal Regulations Part 200, Appendix XI 2022 Compliance Supplement Appendix VII Other Audit Advisories requires recipients and subrecipients to separately identify COVID-19 Emergency Acts expenditures on the Schedule. Condition: The Schedule of Expenditures of Federal and Nonfederal Awards (the Schedule) prepared by the Organization did not separately identify American Rescue Plan COVID-19 funding for Assistance Listing No. 93.568 awards. In addition, the Schedule prepared by the Organization contained many pass-through award identification numbers that were not updated from the prior year, mis-identified certain awards as being COVID-19 funded when they weren?t, and contained various classification errors. Cause: Management was unable to accurately identify the source of funding and other information included on the Schedule. Effect or Potential Effect: The Organization did not comply with Federal regulations regarding federal award reporting. The late identification of certain funding delayed completion of the audit. Context: Prior to audit adjustments, the Schedule contained material errors. Repeat Finding: No. Recommendations: We recommend that management provide adequate resources to the Finance and Administration department to properly manage, track, and report grant awards.
Criteria: The Uniform Guidance requires the auditee to prepare a complete and accurate Schedule of Expenditures of Federal Awards. In addition, Title 2 U.S. Code of Federal Regulations Part 200, Appendix XI 2022 Compliance Supplement Appendix VII Other Audit Advisories requires recipients and subrecipients to separately identify COVID-19 Emergency Acts expenditures on the Schedule. Condition: The Schedule of Expenditures of Federal and Nonfederal Awards (the Schedule) prepared by the Organization did not separately identify American Rescue Plan COVID-19 funding for Assistance Listing No. 93.568 awards. In addition, the Schedule prepared by the Organization contained many pass-through award identification numbers that were not updated from the prior year, mis-identified certain awards as being COVID-19 funded when they weren?t, and contained various classification errors. Cause: Management was unable to accurately identify the source of funding and other information included on the Schedule. Effect or Potential Effect: The Organization did not comply with Federal regulations regarding federal award reporting. The late identification of certain funding delayed completion of the audit. Context: Prior to audit adjustments, the Schedule contained material errors. Repeat Finding: No. Recommendations: We recommend that management provide adequate resources to the Finance and Administration department to properly manage, track, and report grant awards.
Criteria: The Uniform Guidance requires the auditee to prepare a complete and accurate Schedule of Expenditures of Federal Awards. In addition, Title 2 U.S. Code of Federal Regulations Part 200, Appendix XI 2022 Compliance Supplement Appendix VII Other Audit Advisories requires recipients and subrecipients to separately identify COVID-19 Emergency Acts expenditures on the Schedule. Condition: The Schedule of Expenditures of Federal and Nonfederal Awards (the Schedule) prepared by the Organization did not separately identify American Rescue Plan COVID-19 funding for Assistance Listing No. 93.568 awards. In addition, the Schedule prepared by the Organization contained many pass-through award identification numbers that were not updated from the prior year, mis-identified certain awards as being COVID-19 funded when they weren?t, and contained various classification errors. Cause: Management was unable to accurately identify the source of funding and other information included on the Schedule. Effect or Potential Effect: The Organization did not comply with Federal regulations regarding federal award reporting. The late identification of certain funding delayed completion of the audit. Context: Prior to audit adjustments, the Schedule contained material errors. Repeat Finding: No. Recommendations: We recommend that management provide adequate resources to the Finance and Administration department to properly manage, track, and report grant awards.
Criteria: The Uniform Guidance requires the auditee to prepare a complete and accurate Schedule of Expenditures of Federal Awards. In addition, Title 2 U.S. Code of Federal Regulations Part 200, Appendix XI 2022 Compliance Supplement Appendix VII Other Audit Advisories requires recipients and subrecipients to separately identify COVID-19 Emergency Acts expenditures on the Schedule. Condition: The Schedule of Expenditures of Federal and Nonfederal Awards (the Schedule) prepared by the Organization did not separately identify American Rescue Plan COVID-19 funding for Assistance Listing No. 93.568 awards. In addition, the Schedule prepared by the Organization contained many pass-through award identification numbers that were not updated from the prior year, mis-identified certain awards as being COVID-19 funded when they weren?t, and contained various classification errors. Cause: Management was unable to accurately identify the source of funding and other information included on the Schedule. Effect or Potential Effect: The Organization did not comply with Federal regulations regarding federal award reporting. The late identification of certain funding delayed completion of the audit. Context: Prior to audit adjustments, the Schedule contained material errors. Repeat Finding: No. Recommendations: We recommend that management provide adequate resources to the Finance and Administration department to properly manage, track, and report grant awards.
Criteria: The Uniform Guidance requires the auditee to prepare a complete and accurate Schedule of Expenditures of Federal Awards. In addition, Title 2 U.S. Code of Federal Regulations Part 200, Appendix XI 2022 Compliance Supplement Appendix VII Other Audit Advisories requires recipients and subrecipients to separately identify COVID-19 Emergency Acts expenditures on the Schedule. Condition: The Schedule of Expenditures of Federal and Nonfederal Awards (the Schedule) prepared by the Organization did not separately identify American Rescue Plan COVID-19 funding for Assistance Listing No. 93.568 awards. In addition, the Schedule prepared by the Organization contained many pass-through award identification numbers that were not updated from the prior year, mis-identified certain awards as being COVID-19 funded when they weren?t, and contained various classification errors. Cause: Management was unable to accurately identify the source of funding and other information included on the Schedule. Effect or Potential Effect: The Organization did not comply with Federal regulations regarding federal award reporting. The late identification of certain funding delayed completion of the audit. Context: Prior to audit adjustments, the Schedule contained material errors. Repeat Finding: No. Recommendations: We recommend that management provide adequate resources to the Finance and Administration department to properly manage, track, and report grant awards.
Criteria: The Uniform Guidance requires the auditee to prepare a complete and accurate Schedule of Expenditures of Federal Awards. In addition, Title 2 U.S. Code of Federal Regulations Part 200, Appendix XI 2022 Compliance Supplement Appendix VII Other Audit Advisories requires recipients and subrecipients to separately identify COVID-19 Emergency Acts expenditures on the Schedule. Condition: The Schedule of Expenditures of Federal and Nonfederal Awards (the Schedule) prepared by the Organization did not separately identify American Rescue Plan COVID-19 funding for Assistance Listing No. 93.568 awards. In addition, the Schedule prepared by the Organization contained many pass-through award identification numbers that were not updated from the prior year, mis-identified certain awards as being COVID-19 funded when they weren?t, and contained various classification errors. Cause: Management was unable to accurately identify the source of funding and other information included on the Schedule. Effect or Potential Effect: The Organization did not comply with Federal regulations regarding federal award reporting. The late identification of certain funding delayed completion of the audit. Context: Prior to audit adjustments, the Schedule contained material errors. Repeat Finding: No. Recommendations: We recommend that management provide adequate resources to the Finance and Administration department to properly manage, track, and report grant awards.
Criteria: The Uniform Guidance requires the auditee to prepare a complete and accurate Schedule of Expenditures of Federal Awards. In addition, Title 2 U.S. Code of Federal Regulations Part 200, Appendix XI 2022 Compliance Supplement Appendix VII Other Audit Advisories requires recipients and subrecipients to separately identify COVID-19 Emergency Acts expenditures on the Schedule. Condition: The Schedule of Expenditures of Federal and Nonfederal Awards (the Schedule) prepared by the Organization did not separately identify American Rescue Plan COVID-19 funding for Assistance Listing No. 93.568 awards. In addition, the Schedule prepared by the Organization contained many pass-through award identification numbers that were not updated from the prior year, mis-identified certain awards as being COVID-19 funded when they weren?t, and contained various classification errors. Cause: Management was unable to accurately identify the source of funding and other information included on the Schedule. Effect or Potential Effect: The Organization did not comply with Federal regulations regarding federal award reporting. The late identification of certain funding delayed completion of the audit. Context: Prior to audit adjustments, the Schedule contained material errors. Repeat Finding: No. Recommendations: We recommend that management provide adequate resources to the Finance and Administration department to properly manage, track, and report grant awards.
Criteria: The Uniform Guidance requires the auditee to prepare a complete and accurate Schedule of Expenditures of Federal Awards. In addition, Title 2 U.S. Code of Federal Regulations Part 200, Appendix XI 2022 Compliance Supplement Appendix VII Other Audit Advisories requires recipients and subrecipients to separately identify COVID-19 Emergency Acts expenditures on the Schedule. Condition: The Schedule of Expenditures of Federal and Nonfederal Awards (the Schedule) prepared by the Organization did not separately identify American Rescue Plan COVID-19 funding for Assistance Listing No. 93.568 awards. In addition, the Schedule prepared by the Organization contained many pass-through award identification numbers that were not updated from the prior year, mis-identified certain awards as being COVID-19 funded when they weren?t, and contained various classification errors. Cause: Management was unable to accurately identify the source of funding and other information included on the Schedule. Effect or Potential Effect: The Organization did not comply with Federal regulations regarding federal award reporting. The late identification of certain funding delayed completion of the audit. Context: Prior to audit adjustments, the Schedule contained material errors. Repeat Finding: No. Recommendations: We recommend that management provide adequate resources to the Finance and Administration department to properly manage, track, and report grant awards.
Criteria: The Uniform Guidance requires the auditee to prepare a complete and accurate Schedule of Expenditures of Federal Awards. In addition, Title 2 U.S. Code of Federal Regulations Part 200, Appendix XI 2022 Compliance Supplement Appendix VII Other Audit Advisories requires recipients and subrecipients to separately identify COVID-19 Emergency Acts expenditures on the Schedule. Condition: The Schedule of Expenditures of Federal and Nonfederal Awards (the Schedule) prepared by the Organization did not separately identify American Rescue Plan COVID-19 funding for Assistance Listing No. 93.568 awards. In addition, the Schedule prepared by the Organization contained many pass-through award identification numbers that were not updated from the prior year, mis-identified certain awards as being COVID-19 funded when they weren?t, and contained various classification errors. Cause: Management was unable to accurately identify the source of funding and other information included on the Schedule. Effect or Potential Effect: The Organization did not comply with Federal regulations regarding federal award reporting. The late identification of certain funding delayed completion of the audit. Context: Prior to audit adjustments, the Schedule contained material errors. Repeat Finding: No. Recommendations: We recommend that management provide adequate resources to the Finance and Administration department to properly manage, track, and report grant awards.
Criteria: The Uniform Guidance requires the auditee to prepare a complete and accurate Schedule of Expenditures of Federal Awards. In addition, Title 2 U.S. Code of Federal Regulations Part 200, Appendix XI 2022 Compliance Supplement Appendix VII Other Audit Advisories requires recipients and subrecipients to separately identify COVID-19 Emergency Acts expenditures on the Schedule. Condition: The Schedule of Expenditures of Federal and Nonfederal Awards (the Schedule) prepared by the Organization did not separately identify American Rescue Plan COVID-19 funding for Assistance Listing No. 93.568 awards. In addition, the Schedule prepared by the Organization contained many pass-through award identification numbers that were not updated from the prior year, mis-identified certain awards as being COVID-19 funded when they weren?t, and contained various classification errors. Cause: Management was unable to accurately identify the source of funding and other information included on the Schedule. Effect or Potential Effect: The Organization did not comply with Federal regulations regarding federal award reporting. The late identification of certain funding delayed completion of the audit. Context: Prior to audit adjustments, the Schedule contained material errors. Repeat Finding: No. Recommendations: We recommend that management provide adequate resources to the Finance and Administration department to properly manage, track, and report grant awards.
Criteria: The Uniform Guidance requires the auditee to prepare a complete and accurate Schedule of Expenditures of Federal Awards. In addition, Title 2 U.S. Code of Federal Regulations Part 200, Appendix XI 2022 Compliance Supplement Appendix VII Other Audit Advisories requires recipients and subrecipients to separately identify COVID-19 Emergency Acts expenditures on the Schedule. Condition: The Schedule of Expenditures of Federal and Nonfederal Awards (the Schedule) prepared by the Organization did not separately identify American Rescue Plan COVID-19 funding for Assistance Listing No. 93.568 awards. In addition, the Schedule prepared by the Organization contained many pass-through award identification numbers that were not updated from the prior year, mis-identified certain awards as being COVID-19 funded when they weren?t, and contained various classification errors. Cause: Management was unable to accurately identify the source of funding and other information included on the Schedule. Effect or Potential Effect: The Organization did not comply with Federal regulations regarding federal award reporting. The late identification of certain funding delayed completion of the audit. Context: Prior to audit adjustments, the Schedule contained material errors. Repeat Finding: No. Recommendations: We recommend that management provide adequate resources to the Finance and Administration department to properly manage, track, and report grant awards.