Audit 46061

FY End
2022-06-30
Total Expended
$3.52M
Findings
8
Programs
12
Organization: Madison District Public Schools (MI)
Year: 2022 Accepted: 2023-02-02

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
48645 2022-003 Material Weakness - B
48646 2022-004 Material Weakness - B
48647 2022-003 Material Weakness - B
48648 2022-004 Material Weakness - B
625087 2022-003 Material Weakness - B
625088 2022-004 Material Weakness - B
625089 2022-003 Material Weakness - B
625090 2022-004 Material Weakness - B

Programs

Contacts

Name Title Type
HHTACAZR8XL1 Lawrence Miller Auditee
2489537404 Daniel Clark, CPA Auditor
No contacts on file

Notes to SEFA

Title: RECONCILIATION TO THE BASIC FINANCIAL STATEMENTS Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal grant activity of Madison District Public Schools (the District) under programs of the federal government for the year ended June 30, 2022. 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 District, it is not intended to and does not present the financial position, changes in net position or cash flows of the District. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting, which is described in Note 1 to the District's financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. 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 incurred and all grant requirements have been met. The Schedule has been arranged to provide information on both 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 end of the fiscal year have been reported. Expenditures are in agreement with amounts reported in the financial statements and the financial reports. The amounts reported on the Grant Auditor Report reconcile with this Schedule. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. See the Notes to the SEFA for table.

Finding Details

2022-003 - Allowable Costs/Cost Principles - Disbursements Finding Type. Material Noncompliance; Material Weakness in Internal Control over Compliance Federal program(s) U.S. Department of Education: Education Stabilization Fund (ALN 84.425); Passed through MDE; All project numbers Criteria. The Uniform Guidance requires the District to establish internal controls over disbursements related to the compliance requirements applicable to allowable costs/cost provisions. The District's policies require an independent review of expenditures. Condition. The District was unable to provide evidence of allowable costs/cost principles and internal controls compliance as follows: Evidence of an independent review was not documented for 16 out of 40 disbursements selected for testing. The District could not provide any supporting documentation for costs charged on three out of 40 disbursements selected for testing. Cause. This condition appears to be the result of the District not adhering to established internal control policies and procedures. Effect. As a result of this condition, the District is at increased risk of unallowable costs being charged to federal programs without being detected by its internal controls. Questioned Costs. The total charges included in our sample that were not supported by allowable documentation amounted to $72,393. Recommendation. We recommend the District follow its internal control policies and procedures that require independent review of all disbursement transactions. View of Responsible Officials. Management Concurs Responsible Official. Director of Finance and Business Operations Estimated Completion Date. June 30, 2023
2022-004 - Allowable Costs/Cost Principles - Payroll Documentation Finding Type. Material Noncompliance; Material Weakness in Internal Control over Compliance Federal program(s) U.S. Department of Education: Education Stabilization Fund (ALN 84.425); Passed through MDE; All project numbers Criteria. The Uniform Guidance requires the District to support payroll charged to federal cost objectives with adequate documentation in accordance with the District's payroll policies. Per the District's federal policies, the District is required to support payroll charges to federal cost objectives with adequate documentation including personnel activity reports or timesheets for those who split their time between multiple cost objectives. Condition. The District was unable to provide evidence of allowable costs/cost principles and internal controls compliance as follows: Of the 21 payroll transactions selected for testing, the District was unable to provide documentation for eight of those charges. Of the 21 payroll transactions selected for testing, the District identified that one individual had been charged to the grant in excess of their actual payroll for the year. Cause. This condition appears to be the result of the District charging costs to federal programs that were not properly supported using allowable methods. Effect. As a result of this condition, the District does not have appropriate payroll support for nine of the transactions tested which were charged to the grant. Questioned Costs. The total charges included in our sample that were not supported by allowable documentation amounted to $129,160. Recommendation. We recommend the District limit payroll charged to federal programs to costs that are supported by documentation that is allowable under federal cost principles and its own policies and procedures. View of Responsible Officials. Management concurs Responsible Official. Director of Finance and Business Operations Estimated Completion Date. June 30, 2023
2022-003 - Allowable Costs/Cost Principles - Disbursements Finding Type. Material Noncompliance; Material Weakness in Internal Control over Compliance Federal program(s) U.S. Department of Education: Education Stabilization Fund (ALN 84.425); Passed through MDE; All project numbers Criteria. The Uniform Guidance requires the District to establish internal controls over disbursements related to the compliance requirements applicable to allowable costs/cost provisions. The District's policies require an independent review of expenditures. Condition. The District was unable to provide evidence of allowable costs/cost principles and internal controls compliance as follows: Evidence of an independent review was not documented for 16 out of 40 disbursements selected for testing. The District could not provide any supporting documentation for costs charged on three out of 40 disbursements selected for testing. Cause. This condition appears to be the result of the District not adhering to established internal control policies and procedures. Effect. As a result of this condition, the District is at increased risk of unallowable costs being charged to federal programs without being detected by its internal controls. Questioned Costs. The total charges included in our sample that were not supported by allowable documentation amounted to $72,393. Recommendation. We recommend the District follow its internal control policies and procedures that require independent review of all disbursement transactions. View of Responsible Officials. Management Concurs Responsible Official. Director of Finance and Business Operations Estimated Completion Date. June 30, 2023
2022-004 - Allowable Costs/Cost Principles - Payroll Documentation Finding Type. Material Noncompliance; Material Weakness in Internal Control over Compliance Federal program(s) U.S. Department of Education: Education Stabilization Fund (ALN 84.425); Passed through MDE; All project numbers Criteria. The Uniform Guidance requires the District to support payroll charged to federal cost objectives with adequate documentation in accordance with the District's payroll policies. Per the District's federal policies, the District is required to support payroll charges to federal cost objectives with adequate documentation including personnel activity reports or timesheets for those who split their time between multiple cost objectives. Condition. The District was unable to provide evidence of allowable costs/cost principles and internal controls compliance as follows: Of the 21 payroll transactions selected for testing, the District was unable to provide documentation for eight of those charges. Of the 21 payroll transactions selected for testing, the District identified that one individual had been charged to the grant in excess of their actual payroll for the year. Cause. This condition appears to be the result of the District charging costs to federal programs that were not properly supported using allowable methods. Effect. As a result of this condition, the District does not have appropriate payroll support for nine of the transactions tested which were charged to the grant. Questioned Costs. The total charges included in our sample that were not supported by allowable documentation amounted to $129,160. Recommendation. We recommend the District limit payroll charged to federal programs to costs that are supported by documentation that is allowable under federal cost principles and its own policies and procedures. View of Responsible Officials. Management concurs Responsible Official. Director of Finance and Business Operations Estimated Completion Date. June 30, 2023
2022-003 - Allowable Costs/Cost Principles - Disbursements Finding Type. Material Noncompliance; Material Weakness in Internal Control over Compliance Federal program(s) U.S. Department of Education: Education Stabilization Fund (ALN 84.425); Passed through MDE; All project numbers Criteria. The Uniform Guidance requires the District to establish internal controls over disbursements related to the compliance requirements applicable to allowable costs/cost provisions. The District's policies require an independent review of expenditures. Condition. The District was unable to provide evidence of allowable costs/cost principles and internal controls compliance as follows: Evidence of an independent review was not documented for 16 out of 40 disbursements selected for testing. The District could not provide any supporting documentation for costs charged on three out of 40 disbursements selected for testing. Cause. This condition appears to be the result of the District not adhering to established internal control policies and procedures. Effect. As a result of this condition, the District is at increased risk of unallowable costs being charged to federal programs without being detected by its internal controls. Questioned Costs. The total charges included in our sample that were not supported by allowable documentation amounted to $72,393. Recommendation. We recommend the District follow its internal control policies and procedures that require independent review of all disbursement transactions. View of Responsible Officials. Management Concurs Responsible Official. Director of Finance and Business Operations Estimated Completion Date. June 30, 2023
2022-004 - Allowable Costs/Cost Principles - Payroll Documentation Finding Type. Material Noncompliance; Material Weakness in Internal Control over Compliance Federal program(s) U.S. Department of Education: Education Stabilization Fund (ALN 84.425); Passed through MDE; All project numbers Criteria. The Uniform Guidance requires the District to support payroll charged to federal cost objectives with adequate documentation in accordance with the District's payroll policies. Per the District's federal policies, the District is required to support payroll charges to federal cost objectives with adequate documentation including personnel activity reports or timesheets for those who split their time between multiple cost objectives. Condition. The District was unable to provide evidence of allowable costs/cost principles and internal controls compliance as follows: Of the 21 payroll transactions selected for testing, the District was unable to provide documentation for eight of those charges. Of the 21 payroll transactions selected for testing, the District identified that one individual had been charged to the grant in excess of their actual payroll for the year. Cause. This condition appears to be the result of the District charging costs to federal programs that were not properly supported using allowable methods. Effect. As a result of this condition, the District does not have appropriate payroll support for nine of the transactions tested which were charged to the grant. Questioned Costs. The total charges included in our sample that were not supported by allowable documentation amounted to $129,160. Recommendation. We recommend the District limit payroll charged to federal programs to costs that are supported by documentation that is allowable under federal cost principles and its own policies and procedures. View of Responsible Officials. Management concurs Responsible Official. Director of Finance and Business Operations Estimated Completion Date. June 30, 2023
2022-003 - Allowable Costs/Cost Principles - Disbursements Finding Type. Material Noncompliance; Material Weakness in Internal Control over Compliance Federal program(s) U.S. Department of Education: Education Stabilization Fund (ALN 84.425); Passed through MDE; All project numbers Criteria. The Uniform Guidance requires the District to establish internal controls over disbursements related to the compliance requirements applicable to allowable costs/cost provisions. The District's policies require an independent review of expenditures. Condition. The District was unable to provide evidence of allowable costs/cost principles and internal controls compliance as follows: Evidence of an independent review was not documented for 16 out of 40 disbursements selected for testing. The District could not provide any supporting documentation for costs charged on three out of 40 disbursements selected for testing. Cause. This condition appears to be the result of the District not adhering to established internal control policies and procedures. Effect. As a result of this condition, the District is at increased risk of unallowable costs being charged to federal programs without being detected by its internal controls. Questioned Costs. The total charges included in our sample that were not supported by allowable documentation amounted to $72,393. Recommendation. We recommend the District follow its internal control policies and procedures that require independent review of all disbursement transactions. View of Responsible Officials. Management Concurs Responsible Official. Director of Finance and Business Operations Estimated Completion Date. June 30, 2023
2022-004 - Allowable Costs/Cost Principles - Payroll Documentation Finding Type. Material Noncompliance; Material Weakness in Internal Control over Compliance Federal program(s) U.S. Department of Education: Education Stabilization Fund (ALN 84.425); Passed through MDE; All project numbers Criteria. The Uniform Guidance requires the District to support payroll charged to federal cost objectives with adequate documentation in accordance with the District's payroll policies. Per the District's federal policies, the District is required to support payroll charges to federal cost objectives with adequate documentation including personnel activity reports or timesheets for those who split their time between multiple cost objectives. Condition. The District was unable to provide evidence of allowable costs/cost principles and internal controls compliance as follows: Of the 21 payroll transactions selected for testing, the District was unable to provide documentation for eight of those charges. Of the 21 payroll transactions selected for testing, the District identified that one individual had been charged to the grant in excess of their actual payroll for the year. Cause. This condition appears to be the result of the District charging costs to federal programs that were not properly supported using allowable methods. Effect. As a result of this condition, the District does not have appropriate payroll support for nine of the transactions tested which were charged to the grant. Questioned Costs. The total charges included in our sample that were not supported by allowable documentation amounted to $129,160. Recommendation. We recommend the District limit payroll charged to federal programs to costs that are supported by documentation that is allowable under federal cost principles and its own policies and procedures. View of Responsible Officials. Management concurs Responsible Official. Director of Finance and Business Operations Estimated Completion Date. June 30, 2023