Audit 299140

FY End
2023-06-30
Total Expended
$1.64M
Findings
8
Programs
13
Organization: Delton Kellogg Schools (MI)
Year: 2023 Accepted: 2024-03-28

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
386826 2023-001 Significant Deficiency - A
386827 2023-002 Significant Deficiency - A
386828 2023-001 Significant Deficiency - A
386829 2023-002 Significant Deficiency - A
963268 2023-001 Significant Deficiency - A
963269 2023-002 Significant Deficiency - A
963270 2023-001 Significant Deficiency - A
963271 2023-002 Significant Deficiency - A

Contacts

Name Title Type
K4KFC9GNKCS4 Andy Nurenberg Auditee
2696231501 Joe Verlin Auditor
No contacts on file

Notes to SEFA

Title: Note 1 - Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting, which is described in Note 1 to the School District's financial statements. 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. Pass-through entity identifying numbers are presented where applicable and have been identified in the Schedule. Cash received is recorded on the cash basis; expenditures are recorded on the modified accrual basis of accounting. Revenues are recognized when the qualifying expenditures have been included and all grant requirements have been met. The Schedule has been arranged to provide information on both the actual cash received and the revenue recognized. Accordingly, the effects of accruals of accounts receivable, unearned revenue, and accounts payable items at both the beginning and the end of the fiscal year have been reported. Expenditures are in agreement with amounts reported in the financial statements and the grant financial reports. The amounts on the Grant Auditor Report reconcile with this Schedule. The School District has elected not to use the 10-percent de minimus indirect cost rate to recover indirect costs as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: N/A The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of Delton Kellogg Schools (the “School District”) 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 Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Because the schedule presents only a selected portion of the operations of the District, it is not intended to and does not present the financial position, changes in net position, or cash flows of the School District.
Title: Note 2 - Summary of Significant Accounting Policies Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting, which is described in Note 1 to the School District's financial statements. 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. Pass-through entity identifying numbers are presented where applicable and have been identified in the Schedule. Cash received is recorded on the cash basis; expenditures are recorded on the modified accrual basis of accounting. Revenues are recognized when the qualifying expenditures have been included and all grant requirements have been met. The Schedule has been arranged to provide information on both the actual cash received and the revenue recognized. Accordingly, the effects of accruals of accounts receivable, unearned revenue, and accounts payable items at both the beginning and the end of the fiscal year have been reported. Expenditures are in agreement with amounts reported in the financial statements and the grant financial reports. The amounts on the Grant Auditor Report reconcile with this Schedule. The School District has elected not to use the 10-percent de minimus indirect cost rate to recover indirect costs as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: N/A Expenditures reported on the Schedule are reported on the accrual basis of accounting, which is described in Note 1 to the School District's financial statements. 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. Pass-through entity identifying numbers are presented where applicable and have been identified in the Schedule. Cash received is recorded on the cash basis; expenditures are recorded on the modified accrual basis of accounting. Revenues are recognized when the qualifying expenditures have been included and all grant requirements have been met. The Schedule has been arranged to provide information on both the actual cash received and the revenue recognized. Accordingly, the effects of accruals of accounts receivable, unearned revenue, and accounts payable items at both the beginning and the end of the fiscal year have been reported. Expenditures are in agreement with amounts reported in the financial statements and the grant financial reports. The amounts on the Grant Auditor Report reconcile with this Schedule. The School District has elected not to use the 10-percent de minimus indirect cost rate to recover indirect costs as allowed under the Uniform Guidance.
Title: Note 3 - Noncash Assistance Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting, which is described in Note 1 to the School District's financial statements. 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. Pass-through entity identifying numbers are presented where applicable and have been identified in the Schedule. Cash received is recorded on the cash basis; expenditures are recorded on the modified accrual basis of accounting. Revenues are recognized when the qualifying expenditures have been included and all grant requirements have been met. The Schedule has been arranged to provide information on both the actual cash received and the revenue recognized. Accordingly, the effects of accruals of accounts receivable, unearned revenue, and accounts payable items at both the beginning and the end of the fiscal year have been reported. Expenditures are in agreement with amounts reported in the financial statements and the grant financial reports. The amounts on the Grant Auditor Report reconcile with this Schedule. The School District has elected not to use the 10-percent de minimus indirect cost rate to recover indirect costs as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: N/A The value of the noncash assistance received was determined in accordance with the provisions of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. The grantee received no noncash assistance during the year ended June 30, 2023 that is not included on the schedule of expenditures of federal awards.
Title: Note 4 - Adjustments to the Schedule of Expenditures of Federal Awards Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting, which is described in Note 1 to the School District's financial statements. 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. Pass-through entity identifying numbers are presented where applicable and have been identified in the Schedule. Cash received is recorded on the cash basis; expenditures are recorded on the modified accrual basis of accounting. Revenues are recognized when the qualifying expenditures have been included and all grant requirements have been met. The Schedule has been arranged to provide information on both the actual cash received and the revenue recognized. Accordingly, the effects of accruals of accounts receivable, unearned revenue, and accounts payable items at both the beginning and the end of the fiscal year have been reported. Expenditures are in agreement with amounts reported in the financial statements and the grant financial reports. The amounts on the Grant Auditor Report reconcile with this Schedule. The School District has elected not to use the 10-percent de minimus indirect cost rate to recover indirect costs as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: N/A Page 64 of the .pdf provides a reconciliation of the federal revenues reported on the fund financial statemements to the federal expenditures reported in the Schedule.

Finding Details

Activities/Costs Allowed - Budget Finding Type: Significant Deficiency in Internal Controls over Compliance Criteria: The School is responsible for ensuring that the activities/costs of its federal grants are properly budgeted and approved by MDE. Condition/Finding: During our audit procedures performed to verify that activities/costs were allowable, it was discovered that the Elementary School Assessments were not properly budgeted on the ESSER III budget approved by MDE. Cause: This condition is the result of lack of controls in place by management to appropriately review and amend the budget as necessary throughout the grant term. Effect: As a result of this condition, the School incurred expenses during the year that are not allowable to be reimbursed based on the current budget approved. Recommendation: We recommend that the School establish procedures to ensure that budgets for all federal grants are reviewed at an on-going basis to ensure all expenditures are properly budgeted.
Activities/Costs Allowed Finding Type: Significant Deficiency in Internal Controls over Compliance Criteria: The School is responsible for ensuring that employee wages reimbursed under federal grants have signed semi-annual certifications or activity reports to certify time spent under each grant. Condition/Finding: During our audit procedures ,it was discovered that employees reimbursed under ESSER II and ESSER III did not have signed semi-annual certifications or activity reports on file. Cause: This condition is the result of lack of controls in place by management. Effect: As a result of this condition, the School may not have properly allocated wages to the ESSER II and ESSER III grants. Recommendation: We recommend that the School have employees reimbursed under federal grants sign semi-annual certifications or activity reports to verify allocation of wages.
Activities/Costs Allowed - Budget Finding Type: Significant Deficiency in Internal Controls over Compliance Criteria: The School is responsible for ensuring that the activities/costs of its federal grants are properly budgeted and approved by MDE. Condition/Finding: During our audit procedures performed to verify that activities/costs were allowable, it was discovered that the Elementary School Assessments were not properly budgeted on the ESSER III budget approved by MDE. Cause: This condition is the result of lack of controls in place by management to appropriately review and amend the budget as necessary throughout the grant term. Effect: As a result of this condition, the School incurred expenses during the year that are not allowable to be reimbursed based on the current budget approved. Recommendation: We recommend that the School establish procedures to ensure that budgets for all federal grants are reviewed at an on-going basis to ensure all expenditures are properly budgeted.
Activities/Costs Allowed Finding Type: Significant Deficiency in Internal Controls over Compliance Criteria: The School is responsible for ensuring that employee wages reimbursed under federal grants have signed semi-annual certifications or activity reports to certify time spent under each grant. Condition/Finding: During our audit procedures ,it was discovered that employees reimbursed under ESSER II and ESSER III did not have signed semi-annual certifications or activity reports on file. Cause: This condition is the result of lack of controls in place by management. Effect: As a result of this condition, the School may not have properly allocated wages to the ESSER II and ESSER III grants. Recommendation: We recommend that the School have employees reimbursed under federal grants sign semi-annual certifications or activity reports to verify allocation of wages.
Activities/Costs Allowed - Budget Finding Type: Significant Deficiency in Internal Controls over Compliance Criteria: The School is responsible for ensuring that the activities/costs of its federal grants are properly budgeted and approved by MDE. Condition/Finding: During our audit procedures performed to verify that activities/costs were allowable, it was discovered that the Elementary School Assessments were not properly budgeted on the ESSER III budget approved by MDE. Cause: This condition is the result of lack of controls in place by management to appropriately review and amend the budget as necessary throughout the grant term. Effect: As a result of this condition, the School incurred expenses during the year that are not allowable to be reimbursed based on the current budget approved. Recommendation: We recommend that the School establish procedures to ensure that budgets for all federal grants are reviewed at an on-going basis to ensure all expenditures are properly budgeted.
Activities/Costs Allowed Finding Type: Significant Deficiency in Internal Controls over Compliance Criteria: The School is responsible for ensuring that employee wages reimbursed under federal grants have signed semi-annual certifications or activity reports to certify time spent under each grant. Condition/Finding: During our audit procedures ,it was discovered that employees reimbursed under ESSER II and ESSER III did not have signed semi-annual certifications or activity reports on file. Cause: This condition is the result of lack of controls in place by management. Effect: As a result of this condition, the School may not have properly allocated wages to the ESSER II and ESSER III grants. Recommendation: We recommend that the School have employees reimbursed under federal grants sign semi-annual certifications or activity reports to verify allocation of wages.
Activities/Costs Allowed - Budget Finding Type: Significant Deficiency in Internal Controls over Compliance Criteria: The School is responsible for ensuring that the activities/costs of its federal grants are properly budgeted and approved by MDE. Condition/Finding: During our audit procedures performed to verify that activities/costs were allowable, it was discovered that the Elementary School Assessments were not properly budgeted on the ESSER III budget approved by MDE. Cause: This condition is the result of lack of controls in place by management to appropriately review and amend the budget as necessary throughout the grant term. Effect: As a result of this condition, the School incurred expenses during the year that are not allowable to be reimbursed based on the current budget approved. Recommendation: We recommend that the School establish procedures to ensure that budgets for all federal grants are reviewed at an on-going basis to ensure all expenditures are properly budgeted.
Activities/Costs Allowed Finding Type: Significant Deficiency in Internal Controls over Compliance Criteria: The School is responsible for ensuring that employee wages reimbursed under federal grants have signed semi-annual certifications or activity reports to certify time spent under each grant. Condition/Finding: During our audit procedures ,it was discovered that employees reimbursed under ESSER II and ESSER III did not have signed semi-annual certifications or activity reports on file. Cause: This condition is the result of lack of controls in place by management. Effect: As a result of this condition, the School may not have properly allocated wages to the ESSER II and ESSER III grants. Recommendation: We recommend that the School have employees reimbursed under federal grants sign semi-annual certifications or activity reports to verify allocation of wages.