Audit 322414

FY End
2023-12-31
Total Expended
$952,411
Findings
2
Programs
5
Year: 2023 Accepted: 2024-09-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
499558 2023-002 Material Weakness - B
1076000 2023-002 Material Weakness - B

Contacts

Name Title Type
MLA5YSUM4FK3 Angie Sullivan Auditee
4253278609 Nathan Kalepp Auditor
No contacts on file

Notes to SEFA

Title: Note 1 Basis of Presentation Accounting Policies: See Note 1 De Minimis Rate Used: N Rate Explanation: Cost rate used was approved by pass-through entity for benefits for the major program tested. The accompanying schedule of expenditures of federal awards (“Schedule”) includes the federal grant activity of the under programs of the federal government for the year ended December 31, 2023. 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). Because the Schedule presents only a selected portion of the operations of the Organization, it is not intended to and does not present the statements of financial position, changes in fund balances/net position, or cash flows of the Organization.
Title: Note 2 Summary of Significant Accounting Policies Accounting Policies: See Note 1 De Minimis Rate Used: N Rate Explanation: Cost rate used was approved by pass-through entity for benefits for the major program tested. 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: Note 3 10 Percent De Minimis Indirect Cost Rate Accounting Policies: See Note 1 De Minimis Rate Used: N Rate Explanation: Cost rate used was approved by pass-through entity for benefits for the major program tested. The Organization has not elected to use the 10 percent de minimis indirect cost rate.

Finding Details

Criteria: Title 2, Subpart E – Cost Principles Section 200.430 contains the rules for compensation- personal services relative to the allowable cost requirement of the Organization’s major grant. The standards for documentation of personnel expenses require a process for reviewing after-the-fact interim charges made to a federal award based on budget estimates. Condition: The Organization claimed approximately $150,000 in payroll charges for reimbursement under its major program using an estimate of grant time developed when the grant was applied for. The Organization has deemed this budget estimate to be reasonable with how the employees working on the grant spent their time, however there is no formal documentation of the actual time and effort of these employees. The Organization does review this and no employee charges more than 100% of their time to any federal grant. Cause: The Organization does not prepare personnel activity reports or any other form of time and effort documentation; it uses budget estimates considered by those within the Organization who write the grants. Effect: The Organization is using budget estimates to charge time for employees to its federal grants. If the Organization were to track actual time or conduct a time study, the actual amount charged may be different than the amounts currently charged. Since actual time is not tracked, it is not possible to quantify this amount. The Organization believes that the allocation percentages in the budget approximate actual time spent, and the allocations are reviewed and updated by management periodically. Recommendation: The Organization should track actual time spent on grants and consider preparing personnel activity reports for all employees that charge time to federal grants. This documentation serves as evidence of actual time spent by employees on federally funded grant projects. Management response: The Organization will conduct quarterly time studies by position and make adjustments to allocations as time spent deviates from the most recent time study or original budget.
Criteria: Title 2, Subpart E – Cost Principles Section 200.430 contains the rules for compensation- personal services relative to the allowable cost requirement of the Organization’s major grant. The standards for documentation of personnel expenses require a process for reviewing after-the-fact interim charges made to a federal award based on budget estimates. Condition: The Organization claimed approximately $150,000 in payroll charges for reimbursement under its major program using an estimate of grant time developed when the grant was applied for. The Organization has deemed this budget estimate to be reasonable with how the employees working on the grant spent their time, however there is no formal documentation of the actual time and effort of these employees. The Organization does review this and no employee charges more than 100% of their time to any federal grant. Cause: The Organization does not prepare personnel activity reports or any other form of time and effort documentation; it uses budget estimates considered by those within the Organization who write the grants. Effect: The Organization is using budget estimates to charge time for employees to its federal grants. If the Organization were to track actual time or conduct a time study, the actual amount charged may be different than the amounts currently charged. Since actual time is not tracked, it is not possible to quantify this amount. The Organization believes that the allocation percentages in the budget approximate actual time spent, and the allocations are reviewed and updated by management periodically. Recommendation: The Organization should track actual time spent on grants and consider preparing personnel activity reports for all employees that charge time to federal grants. This documentation serves as evidence of actual time spent by employees on federally funded grant projects. Management response: The Organization will conduct quarterly time studies by position and make adjustments to allocations as time spent deviates from the most recent time study or original budget.