Audit 305464

FY End
2023-09-30
Total Expended
$15.60M
Findings
2
Programs
4
Year: 2023 Accepted: 2024-05-03
Auditor: Marcum LLP

Organization Exclusion Status:

Checking exclusion status...

Contacts

Name Title Type
GDAKQ7A8MG55 Bruce Pelleu Auditee
2026847457 Kimberly Robertson Auditor
No contacts on file

Notes to SEFA

Title: 1. Basis of Presentation Accounting Policies: Expenditures reported on the SEFA 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 Council has elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (SEFA) includes the federal award activity of the National Council for Behavioral Health and Subsidiary (the Council) under programs of the federal government for the year ended September 30, 2023. The information on the SEFA 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 SEFA presents only a selected portion of the operations of the Council, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the Council.
Title: 2. Summary of Significant Accounting Policies Accounting Policies: Expenditures reported on the SEFA 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 Council has elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. Expenditures reported on the SEFA 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.
Title: 3. Indirect Cost Rate Accounting Policies: Expenditures reported on the SEFA 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 Council has elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. The Council has elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance.
Title: 4. Reconciliation of Schedule of Expenditures of Federal Awards to the Consolidated Financial Statements Accounting Policies: Expenditures reported on the SEFA 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 Council has elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. Government grants in the accompanying consolidated statement of activities are divided between the following categories: Expenditures per the schedule of expenditures of federal awards $ 15,602,788 Plus: Nonfederal grants 9,838,699 Grants Revenue Reported in the Consolidated Statement of Activities $ 25,441,487

Finding Details

Effect The total effect on federal awards was an overstatement of expenditures of $264,628, which was made up of $225,316 of expenditures that related to Assisted Listing Numbers (ALN) that closed prior to fiscal year 2023 and $39,312 of expenditures related to ALNs that were ongoing during fiscal year 2023. For the $39,312 of overstatement of expenditures that related to ongoing programs, the Council reduced fiscal year 2023 expenditures by the $39,312, thereby having no net effect on the programs for the year ended September 30, 2023. For the $225,316 of overstatement of expenditures that related to programs that closed prior to the year ended September 30, 2023, the Council recorded a liability as of September 30, 2023, representing the funds to be repaid to the federal government. Questioned Costs: Amounts overcharged to federal awards that closed in prior years were as follows: ALN 93.638 ALN 93.283 ALN 93.788 Total Fiscal Year: 2015 $ - $ 512 $ - $ 512 2016 5,200 3,932 - 9,132 2019 215,007 - - 215,007 2020 - - 665 665 Total $ 220,207 $ 4,444 $ 665 $ 225,316 Recommendation We recommend that the Council enhance its internal control over reconciliation and review to ensure that its subsidiary ledgers only include proper and valid transactions. Views of Responsible Officials See corrective action plan.
Effect The total effect on federal awards was an overstatement of expenditures of $264,628, which was made up of $225,316 of expenditures that related to Assisted Listing Numbers (ALN) that closed prior to fiscal year 2023 and $39,312 of expenditures related to ALNs that were ongoing during fiscal year 2023. For the $39,312 of overstatement of expenditures that related to ongoing programs, the Council reduced fiscal year 2023 expenditures by the $39,312, thereby having no net effect on the programs for the year ended September 30, 2023. For the $225,316 of overstatement of expenditures that related to programs that closed prior to the year ended September 30, 2023, the Council recorded a liability as of September 30, 2023, representing the funds to be repaid to the federal government. Questioned Costs: Amounts overcharged to federal awards that closed in prior years were as follows: ALN 93.638 ALN 93.283 ALN 93.788 Total Fiscal Year: 2015 $ - $ 512 $ - $ 512 2016 5,200 3,932 - 9,132 2019 215,007 - - 215,007 2020 - - 665 665 Total $ 220,207 $ 4,444 $ 665 $ 225,316 Recommendation We recommend that the Council enhance its internal control over reconciliation and review to ensure that its subsidiary ledgers only include proper and valid transactions. Views of Responsible Officials See corrective action plan.