Audit 322841

FY End
2023-12-31
Total Expended
$99.71M
Findings
4
Programs
1
Year: 2023 Accepted: 2024-09-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
499912 2023-001 Significant Deficiency Yes ABH
499913 2023-002 Significant Deficiency Yes B
1076354 2023-001 Significant Deficiency Yes ABH
1076355 2023-002 Significant Deficiency Yes B

Programs

ALN Program Spent Major Findings
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $99.71M Yes 2

Contacts

Name Title Type
WEGVDAKJSM91 John Matson Auditee
3342716214 Amy Verberne Auditor
No contacts on file

Notes to SEFA

Title: RECONCILIATION OF FEDERAL GRANT REVENUE TO EXPENDITURES OF FEDERAL AWARDS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards presents the activity of all federal awards of the Foundation. The Foundation did not receive any funds directly from any federal agencies. Instead, all federal awards were passed to the Foundation from the State. The Foundation’s reporting entity is defined in Note 1 to the Foundation’s financial statements. All federal awards that were received directly from federal agencies are included on the Schedule of Expenditures of Federal Awards, as well as federal assistance passed through government agencies. The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of the Foundation and is presented on the accrual basis of accounting. 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 Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the financial statements. De Minimis Rate Used: N Rate Explanation: The Foundation has not elected to use the 10% de minimis indirect rate allowed under the Uniform Guidance. Below is a reconciliation of the schedule of expenditures of federal awards to the federal grant revenue as presented on the statement of activities of the Foundation:
Title: LOANS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards presents the activity of all federal awards of the Foundation. The Foundation did not receive any funds directly from any federal agencies. Instead, all federal awards were passed to the Foundation from the State. The Foundation’s reporting entity is defined in Note 1 to the Foundation’s financial statements. All federal awards that were received directly from federal agencies are included on the Schedule of Expenditures of Federal Awards, as well as federal assistance passed through government agencies. The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of the Foundation and is presented on the accrual basis of accounting. 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 Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the financial statements. De Minimis Rate Used: N Rate Explanation: The Foundation has not elected to use the 10% de minimis indirect rate allowed under the Uniform Guidance. The Foundation did not expend federal awards related to loans or loan guarantees during the year ended December 31, 2023.
Title: FEDERALLY FUNDED INSURANCE Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards presents the activity of all federal awards of the Foundation. The Foundation did not receive any funds directly from any federal agencies. Instead, all federal awards were passed to the Foundation from the State. The Foundation’s reporting entity is defined in Note 1 to the Foundation’s financial statements. All federal awards that were received directly from federal agencies are included on the Schedule of Expenditures of Federal Awards, as well as federal assistance passed through government agencies. The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of the Foundation and is presented on the accrual basis of accounting. 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 Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the financial statements. De Minimis Rate Used: N Rate Explanation: The Foundation has not elected to use the 10% de minimis indirect rate allowed under the Uniform Guidance. The Foundation had no federally funded insurance for the year ended December 31, 2023.
Title: NONCASH ASSISTANCE Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards presents the activity of all federal awards of the Foundation. The Foundation did not receive any funds directly from any federal agencies. Instead, all federal awards were passed to the Foundation from the State. The Foundation’s reporting entity is defined in Note 1 to the Foundation’s financial statements. All federal awards that were received directly from federal agencies are included on the Schedule of Expenditures of Federal Awards, as well as federal assistance passed through government agencies. The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of the Foundation and is presented on the accrual basis of accounting. 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 Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the financial statements. De Minimis Rate Used: N Rate Explanation: The Foundation has not elected to use the 10% de minimis indirect rate allowed under the Uniform Guidance. The Foundation did not receive any federal noncash assistance for the year ended December 31, 2023.

Finding Details

2023-001 – SIGNIFICANT DEFICIENCY – Internal Controls Over Allowable Activities/Costs and Period of Performance (Originated in 2022) U.S. Department of Treasury – Passed through the State of Alabama Department of Treasury – COVID 19 Coronavirus State and Local Fiscal Recovery Fund – ALN #21.027 – Program Year 2023 Criteria – Per 2 CFR Subpart D - 200.203(b)(3), non-federal entities are required to maintain records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. In addition, per CFR 200.303(a), non-federal entities are required to establish and maintain effective internal controls over federal awards. Condition – For all 60 disbursements sampled, the Foundation relied solely on certifications received (with or without supporting documentation submitted) in order to disburse funds under the federal award program. Cause – Based on guidance received from the grantor, the Foundation relied solely on certifications received (with or without supporting documentation submitted) in order to disburse funds under the federal award program. Effect – Potential disbursements of federal awards for un-allowed costs/activities or in an improper period of availability. Questioned costs – Unknown Auditor’s recommendation – Policies and procedures should be designed, implemented, and monitored to ensure that detailed supporting documentation is obtained and reviewed for all disbursements in accordance with federal award requirements. Management response and current status – See management corrective action plan
2023-002 – SIGNIFICANT DEFICIENCY – Claims Payments Made Based on Incorrect Calculations of Amounts to be Reimbursed (Originated in 2022) U.S. Department of Treasury – Passed through the State of Alabama Department of Treasury – COVID 19 Coronavirus State and Local Fiscal Recovery Fund – ALN #21.027 – Program Year 2023 Criteria – Per 2 CFR Subpart E - 200.403(a) and (b), allowable costs under federal award programs must be necessary and reasonable for the performance of the federal award and must conform to any limitations or exclusions set forth in the federal award as to types or amounts of cost items. In addition, per 2 CFR Subpart E – 200.405(a), a cost is allocable to a particular federal award if the goods or services involved are chargeable or assignable to that federal award in accordance with relative benefits received. Finally, per CFR 200.303(a), non-federal entities are required to establish and maintain effective internal controls over federal awards. Condition – For 1 of 60 disbursements sampled, reimbursed claims amounts included un-allowable costs due to the reimbursement calculations being performed incorrectly in the determination of the appropriate reimbursement amount. Cause – As a result of the Foundation’s reliance solely on certifications received, amounts were not appropriately disbursed under the federal award program. Effect – Claims payments included amounts that were not chargeable or assignable to the federal award in accordance with relative benefits received. Questioned Costs – $95,663 known questioned costs (total amounts paid based on incorrect reimbursement calculations), $529,835 likely questioned costs – amount extrapolated to entire population based on % of known questioned costs. Auditor’s Recommendation – Policies and procedures should be designed, implemented, and monitored which ensure that detailed supporting documentation is obtained and reviewed for all disbursements in accordance with federal award requirements. In addition, all calculations of amounts to be reimbursed should be appropriately recalculated to ensure the proper amount is included in the claims payments. Management response and current status – See management corrective action plan
2023-001 – SIGNIFICANT DEFICIENCY – Internal Controls Over Allowable Activities/Costs and Period of Performance (Originated in 2022) U.S. Department of Treasury – Passed through the State of Alabama Department of Treasury – COVID 19 Coronavirus State and Local Fiscal Recovery Fund – ALN #21.027 – Program Year 2023 Criteria – Per 2 CFR Subpart D - 200.203(b)(3), non-federal entities are required to maintain records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. In addition, per CFR 200.303(a), non-federal entities are required to establish and maintain effective internal controls over federal awards. Condition – For all 60 disbursements sampled, the Foundation relied solely on certifications received (with or without supporting documentation submitted) in order to disburse funds under the federal award program. Cause – Based on guidance received from the grantor, the Foundation relied solely on certifications received (with or without supporting documentation submitted) in order to disburse funds under the federal award program. Effect – Potential disbursements of federal awards for un-allowed costs/activities or in an improper period of availability. Questioned costs – Unknown Auditor’s recommendation – Policies and procedures should be designed, implemented, and monitored to ensure that detailed supporting documentation is obtained and reviewed for all disbursements in accordance with federal award requirements. Management response and current status – See management corrective action plan
2023-002 – SIGNIFICANT DEFICIENCY – Claims Payments Made Based on Incorrect Calculations of Amounts to be Reimbursed (Originated in 2022) U.S. Department of Treasury – Passed through the State of Alabama Department of Treasury – COVID 19 Coronavirus State and Local Fiscal Recovery Fund – ALN #21.027 – Program Year 2023 Criteria – Per 2 CFR Subpart E - 200.403(a) and (b), allowable costs under federal award programs must be necessary and reasonable for the performance of the federal award and must conform to any limitations or exclusions set forth in the federal award as to types or amounts of cost items. In addition, per 2 CFR Subpart E – 200.405(a), a cost is allocable to a particular federal award if the goods or services involved are chargeable or assignable to that federal award in accordance with relative benefits received. Finally, per CFR 200.303(a), non-federal entities are required to establish and maintain effective internal controls over federal awards. Condition – For 1 of 60 disbursements sampled, reimbursed claims amounts included un-allowable costs due to the reimbursement calculations being performed incorrectly in the determination of the appropriate reimbursement amount. Cause – As a result of the Foundation’s reliance solely on certifications received, amounts were not appropriately disbursed under the federal award program. Effect – Claims payments included amounts that were not chargeable or assignable to the federal award in accordance with relative benefits received. Questioned Costs – $95,663 known questioned costs (total amounts paid based on incorrect reimbursement calculations), $529,835 likely questioned costs – amount extrapolated to entire population based on % of known questioned costs. Auditor’s Recommendation – Policies and procedures should be designed, implemented, and monitored which ensure that detailed supporting documentation is obtained and reviewed for all disbursements in accordance with federal award requirements. In addition, all calculations of amounts to be reimbursed should be appropriately recalculated to ensure the proper amount is included in the claims payments. Management response and current status – See management corrective action plan