Audit 299831

FY End
2023-06-30
Total Expended
$976,205
Findings
8
Programs
6
Organization: Covenant House Missouri (MO)
Year: 2023 Accepted: 2024-03-28

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
387766 2023-001 Material Weakness - P
387767 2023-001 Material Weakness - P
387768 2023-001 Material Weakness - P
387769 2023-001 Material Weakness - P
964208 2023-001 Material Weakness - P
964209 2023-001 Material Weakness - P
964210 2023-001 Material Weakness - P
964211 2023-001 Material Weakness - P

Programs

ALN Program Spent Major Findings
14.267 Continuum of Care Program $206,446 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $164,935 - 0
16.320 Services for Trafficking Victims $85,834 - 0
93.550 Transitional Living for Homeless Youth $37,360 - 0
14.218 Community Development Block Grants/entitlement Grants $19,465 - 0
14.231 Emergency Solutions Grant Program $4,854 Yes 1

Contacts

Name Title Type
XL5DWN7GU5M7 Kellie Roberts Auditee
3144507699 Robert Cordero Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation 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 Organization has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The Organization is reimbursed for programmatic and administrative costs as stated in each contract. The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) includes the federal award activity of Covenant House Missouri (the “Organization”) under programs of the federal government for the year ended June 30, 2023. The information in this Schedule is presented in accordance with the requirements of the 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 consolidated financial position, changes in net assets or cash flows of the Organization.
Title: Non-Cash Awards 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 Organization has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The Organization is reimbursed for programmatic and administrative costs as stated in each contract. For the year ended June 30, 2023, the Organization did not have or receive any non-cash awards, mortgages, or loan funds that should be included in the federal expenditures presented in this Schedule.

Finding Details

Criteria Management is required to prepare the Schedule of Expenditures of Federal Awards (“SEFA”). If the SEFA includes errors or omissions, it will surely result in inefficiencies, additional audit effort by auditors if major programs must be re-selected, the potential for audit restatement, and/or additional audit costs. Condition Not all federal expenditures were included on the client prepared Schedule of Expenditures of Federal Awards. There were differences noted in reconciling expenditures from the original SEFA to the government contract revenue (which is the basis for expenditures), and it was discovered that certain adjustments for grants receivable, unearned revenues and grant revenue had not been made in order to properly report total federal expenditures. These errors were corrected through adjustments proposed as part of the financial statement audit. Questioned Costs None Context One of the grants, containing funding from the federal program assistance listing number 14.231- Emergency Solutions Grant Program incorrectly omitted $301,226 of federal expenditures on the SEFA provided by management. Cause Funding received from one award was incorrectly reported as part of the contribution revenue and omitted from the client prepared SEFA. Effect This delayed the completion of the compliance audit. Recommendations We recommend that the Organization become familiar with the SEFA reporting elements required by the Uniform Guidance and develops and implements a review process to ensure a complete and accurate SEFA is prepared. These processes and controls should include reconciling the SEFA to the current year general ledger expenditures, grant reporting submitted/approved and reviewing other grant related information to ensure accuracy. Additionally, management should consider requiring key Grants Management personnel take advanced Uniform Guidance training and annual updates, as made available.
Criteria Management is required to prepare the Schedule of Expenditures of Federal Awards (“SEFA”). If the SEFA includes errors or omissions, it will surely result in inefficiencies, additional audit effort by auditors if major programs must be re-selected, the potential for audit restatement, and/or additional audit costs. Condition Not all federal expenditures were included on the client prepared Schedule of Expenditures of Federal Awards. There were differences noted in reconciling expenditures from the original SEFA to the government contract revenue (which is the basis for expenditures), and it was discovered that certain adjustments for grants receivable, unearned revenues and grant revenue had not been made in order to properly report total federal expenditures. These errors were corrected through adjustments proposed as part of the financial statement audit. Questioned Costs None Context One of the grants, containing funding from the federal program assistance listing number 14.231- Emergency Solutions Grant Program incorrectly omitted $301,226 of federal expenditures on the SEFA provided by management. Cause Funding received from one award was incorrectly reported as part of the contribution revenue and omitted from the client prepared SEFA. Effect This delayed the completion of the compliance audit. Recommendations We recommend that the Organization become familiar with the SEFA reporting elements required by the Uniform Guidance and develops and implements a review process to ensure a complete and accurate SEFA is prepared. These processes and controls should include reconciling the SEFA to the current year general ledger expenditures, grant reporting submitted/approved and reviewing other grant related information to ensure accuracy. Additionally, management should consider requiring key Grants Management personnel take advanced Uniform Guidance training and annual updates, as made available.
Criteria Management is required to prepare the Schedule of Expenditures of Federal Awards (“SEFA”). If the SEFA includes errors or omissions, it will surely result in inefficiencies, additional audit effort by auditors if major programs must be re-selected, the potential for audit restatement, and/or additional audit costs. Condition Not all federal expenditures were included on the client prepared Schedule of Expenditures of Federal Awards. There were differences noted in reconciling expenditures from the original SEFA to the government contract revenue (which is the basis for expenditures), and it was discovered that certain adjustments for grants receivable, unearned revenues and grant revenue had not been made in order to properly report total federal expenditures. These errors were corrected through adjustments proposed as part of the financial statement audit. Questioned Costs None Context One of the grants, containing funding from the federal program assistance listing number 14.231- Emergency Solutions Grant Program incorrectly omitted $301,226 of federal expenditures on the SEFA provided by management. Cause Funding received from one award was incorrectly reported as part of the contribution revenue and omitted from the client prepared SEFA. Effect This delayed the completion of the compliance audit. Recommendations We recommend that the Organization become familiar with the SEFA reporting elements required by the Uniform Guidance and develops and implements a review process to ensure a complete and accurate SEFA is prepared. These processes and controls should include reconciling the SEFA to the current year general ledger expenditures, grant reporting submitted/approved and reviewing other grant related information to ensure accuracy. Additionally, management should consider requiring key Grants Management personnel take advanced Uniform Guidance training and annual updates, as made available.
Criteria Management is required to prepare the Schedule of Expenditures of Federal Awards (“SEFA”). If the SEFA includes errors or omissions, it will surely result in inefficiencies, additional audit effort by auditors if major programs must be re-selected, the potential for audit restatement, and/or additional audit costs. Condition Not all federal expenditures were included on the client prepared Schedule of Expenditures of Federal Awards. There were differences noted in reconciling expenditures from the original SEFA to the government contract revenue (which is the basis for expenditures), and it was discovered that certain adjustments for grants receivable, unearned revenues and grant revenue had not been made in order to properly report total federal expenditures. These errors were corrected through adjustments proposed as part of the financial statement audit. Questioned Costs None Context One of the grants, containing funding from the federal program assistance listing number 14.231- Emergency Solutions Grant Program incorrectly omitted $301,226 of federal expenditures on the SEFA provided by management. Cause Funding received from one award was incorrectly reported as part of the contribution revenue and omitted from the client prepared SEFA. Effect This delayed the completion of the compliance audit. Recommendations We recommend that the Organization become familiar with the SEFA reporting elements required by the Uniform Guidance and develops and implements a review process to ensure a complete and accurate SEFA is prepared. These processes and controls should include reconciling the SEFA to the current year general ledger expenditures, grant reporting submitted/approved and reviewing other grant related information to ensure accuracy. Additionally, management should consider requiring key Grants Management personnel take advanced Uniform Guidance training and annual updates, as made available.
Criteria Management is required to prepare the Schedule of Expenditures of Federal Awards (“SEFA”). If the SEFA includes errors or omissions, it will surely result in inefficiencies, additional audit effort by auditors if major programs must be re-selected, the potential for audit restatement, and/or additional audit costs. Condition Not all federal expenditures were included on the client prepared Schedule of Expenditures of Federal Awards. There were differences noted in reconciling expenditures from the original SEFA to the government contract revenue (which is the basis for expenditures), and it was discovered that certain adjustments for grants receivable, unearned revenues and grant revenue had not been made in order to properly report total federal expenditures. These errors were corrected through adjustments proposed as part of the financial statement audit. Questioned Costs None Context One of the grants, containing funding from the federal program assistance listing number 14.231- Emergency Solutions Grant Program incorrectly omitted $301,226 of federal expenditures on the SEFA provided by management. Cause Funding received from one award was incorrectly reported as part of the contribution revenue and omitted from the client prepared SEFA. Effect This delayed the completion of the compliance audit. Recommendations We recommend that the Organization become familiar with the SEFA reporting elements required by the Uniform Guidance and develops and implements a review process to ensure a complete and accurate SEFA is prepared. These processes and controls should include reconciling the SEFA to the current year general ledger expenditures, grant reporting submitted/approved and reviewing other grant related information to ensure accuracy. Additionally, management should consider requiring key Grants Management personnel take advanced Uniform Guidance training and annual updates, as made available.
Criteria Management is required to prepare the Schedule of Expenditures of Federal Awards (“SEFA”). If the SEFA includes errors or omissions, it will surely result in inefficiencies, additional audit effort by auditors if major programs must be re-selected, the potential for audit restatement, and/or additional audit costs. Condition Not all federal expenditures were included on the client prepared Schedule of Expenditures of Federal Awards. There were differences noted in reconciling expenditures from the original SEFA to the government contract revenue (which is the basis for expenditures), and it was discovered that certain adjustments for grants receivable, unearned revenues and grant revenue had not been made in order to properly report total federal expenditures. These errors were corrected through adjustments proposed as part of the financial statement audit. Questioned Costs None Context One of the grants, containing funding from the federal program assistance listing number 14.231- Emergency Solutions Grant Program incorrectly omitted $301,226 of federal expenditures on the SEFA provided by management. Cause Funding received from one award was incorrectly reported as part of the contribution revenue and omitted from the client prepared SEFA. Effect This delayed the completion of the compliance audit. Recommendations We recommend that the Organization become familiar with the SEFA reporting elements required by the Uniform Guidance and develops and implements a review process to ensure a complete and accurate SEFA is prepared. These processes and controls should include reconciling the SEFA to the current year general ledger expenditures, grant reporting submitted/approved and reviewing other grant related information to ensure accuracy. Additionally, management should consider requiring key Grants Management personnel take advanced Uniform Guidance training and annual updates, as made available.
Criteria Management is required to prepare the Schedule of Expenditures of Federal Awards (“SEFA”). If the SEFA includes errors or omissions, it will surely result in inefficiencies, additional audit effort by auditors if major programs must be re-selected, the potential for audit restatement, and/or additional audit costs. Condition Not all federal expenditures were included on the client prepared Schedule of Expenditures of Federal Awards. There were differences noted in reconciling expenditures from the original SEFA to the government contract revenue (which is the basis for expenditures), and it was discovered that certain adjustments for grants receivable, unearned revenues and grant revenue had not been made in order to properly report total federal expenditures. These errors were corrected through adjustments proposed as part of the financial statement audit. Questioned Costs None Context One of the grants, containing funding from the federal program assistance listing number 14.231- Emergency Solutions Grant Program incorrectly omitted $301,226 of federal expenditures on the SEFA provided by management. Cause Funding received from one award was incorrectly reported as part of the contribution revenue and omitted from the client prepared SEFA. Effect This delayed the completion of the compliance audit. Recommendations We recommend that the Organization become familiar with the SEFA reporting elements required by the Uniform Guidance and develops and implements a review process to ensure a complete and accurate SEFA is prepared. These processes and controls should include reconciling the SEFA to the current year general ledger expenditures, grant reporting submitted/approved and reviewing other grant related information to ensure accuracy. Additionally, management should consider requiring key Grants Management personnel take advanced Uniform Guidance training and annual updates, as made available.
Criteria Management is required to prepare the Schedule of Expenditures of Federal Awards (“SEFA”). If the SEFA includes errors or omissions, it will surely result in inefficiencies, additional audit effort by auditors if major programs must be re-selected, the potential for audit restatement, and/or additional audit costs. Condition Not all federal expenditures were included on the client prepared Schedule of Expenditures of Federal Awards. There were differences noted in reconciling expenditures from the original SEFA to the government contract revenue (which is the basis for expenditures), and it was discovered that certain adjustments for grants receivable, unearned revenues and grant revenue had not been made in order to properly report total federal expenditures. These errors were corrected through adjustments proposed as part of the financial statement audit. Questioned Costs None Context One of the grants, containing funding from the federal program assistance listing number 14.231- Emergency Solutions Grant Program incorrectly omitted $301,226 of federal expenditures on the SEFA provided by management. Cause Funding received from one award was incorrectly reported as part of the contribution revenue and omitted from the client prepared SEFA. Effect This delayed the completion of the compliance audit. Recommendations We recommend that the Organization become familiar with the SEFA reporting elements required by the Uniform Guidance and develops and implements a review process to ensure a complete and accurate SEFA is prepared. These processes and controls should include reconciling the SEFA to the current year general ledger expenditures, grant reporting submitted/approved and reviewing other grant related information to ensure accuracy. Additionally, management should consider requiring key Grants Management personnel take advanced Uniform Guidance training and annual updates, as made available.