Audit 333446

FY End
2024-06-30
Total Expended
$1.06M
Findings
2
Programs
7
Organization: Northland Foundation (MN)
Year: 2024 Accepted: 2024-12-18
Auditor: Rsm US LLP

Organization Exclusion Status:

Checking exclusion status...

Contacts

Name Title Type
FKCXEDHJLJX3 Heather Brouse Auditee
2187234040 Dan Schelske 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 Foundation has not elected to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal grant and loan activity of Northland Foundation (the Foundation) under programs of the federal government for the year ended June 30, 2024. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) 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 Foundation, it is not intended to, and does not present, the financial position, changes in net assets or cash flows of the Foundation.
Title: Summary of Significant Accounting Policies 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 Foundation has not elected to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. 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.
Title: Indirect Cost Rate 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 Foundation has not elected to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The Foundation has not elected to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance.

Finding Details

Finding 2024-004 U.S. Department of Treasury Federal Award Year Ending June 30, 2024 COVID-19: Coronavirus State and Local Fiscal Recovery Funds Lack of internal controls over the preparation of the Schedule of Expenditures of Federal Awards Criteria: In accordance with 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Condition: The Schedule of Expenditures for Federal Awards for the year ended June 30, 2024, was initially overstated by $529,900 due to an improper subrecipient verses beneficiary determination for a grant. Cause: While this original grant agreement specified that the Foundation was a subrecipient, the Foundation did not timely review a 2024 grant amendment or obtain further correspondence from the granter that updated the initial subrecipient determination to now identify the Foundation as a beneficiary, resulting in the removal of $529,900 from the Schedule of Expenditures for Federal Awards. Effect or potential effect: Improper reporting of federal expenditures results in errors on the Schedule of Expenditures for Federal Awards and can lead to inaccurate major program determination. In this instance, the error did result in an update to the major program determination. Questioned costs: None. Context: During the audit, we reviewed a July 2024 grant amendment from the grantor that removed a number of the original grant requirements and reclassified the Foundation as a “grantee.” Upon further inquiry with the grantor, it was discovered that the Foundation is no longer considered a subrecipient. Thus, the Foundation is a beneficiary, which resulted in the removal of incurred costs of $529,900 from the Schedule of Expenditures of Federal Awards. Recommendation: To ensure accuracy of the Schedule of Expenditures of Federal Awards, the Foundation should improve the processes and controls around timely identification of potential federal awards, which includes enhancing the review of any grant amendments and timely contacting passthrough entities to verify potential updates to the subrecipient verses beneficiary determination. Views of responsible officials of the auditee: The Foundation agrees with the above finding, and its response is included in the corrective action plan.
Finding 2024-004 U.S. Department of Treasury Federal Award Year Ending June 30, 2024 COVID-19: Coronavirus State and Local Fiscal Recovery Funds Lack of internal controls over the preparation of the Schedule of Expenditures of Federal Awards Criteria: In accordance with 2 CFR 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Condition: The Schedule of Expenditures for Federal Awards for the year ended June 30, 2024, was initially overstated by $529,900 due to an improper subrecipient verses beneficiary determination for a grant. Cause: While this original grant agreement specified that the Foundation was a subrecipient, the Foundation did not timely review a 2024 grant amendment or obtain further correspondence from the granter that updated the initial subrecipient determination to now identify the Foundation as a beneficiary, resulting in the removal of $529,900 from the Schedule of Expenditures for Federal Awards. Effect or potential effect: Improper reporting of federal expenditures results in errors on the Schedule of Expenditures for Federal Awards and can lead to inaccurate major program determination. In this instance, the error did result in an update to the major program determination. Questioned costs: None. Context: During the audit, we reviewed a July 2024 grant amendment from the grantor that removed a number of the original grant requirements and reclassified the Foundation as a “grantee.” Upon further inquiry with the grantor, it was discovered that the Foundation is no longer considered a subrecipient. Thus, the Foundation is a beneficiary, which resulted in the removal of incurred costs of $529,900 from the Schedule of Expenditures of Federal Awards. Recommendation: To ensure accuracy of the Schedule of Expenditures of Federal Awards, the Foundation should improve the processes and controls around timely identification of potential federal awards, which includes enhancing the review of any grant amendments and timely contacting passthrough entities to verify potential updates to the subrecipient verses beneficiary determination. Views of responsible officials of the auditee: The Foundation agrees with the above finding, and its response is included in the corrective action plan.