Audit 325665

FY End
2024-06-30
Total Expended
$5.19M
Findings
2
Programs
11
Organization: Coldwater Community Schools (MI)
Year: 2024 Accepted: 2024-10-23
Auditor: Hungerford

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
503538 2024-001 Material Weakness - B
1079980 2024-001 Material Weakness - B

Contacts

Name Title Type
CUVCQRCD7AA3 Rachelle Roby Auditee
2692132052 Marc Sawyers Auditor
No contacts on file

Notes to SEFA

Title: Note A - Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the same basis of accounting as the basic financial statements. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Indirect cost rates are only applied for some grants and are based solely on allowable rates established with the grantor; communicated to the District in the associated grant agreement. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal grant activity of Coldwater Community Schools 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 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 Coldwater Community Schools, it is not intended to and does not present the financial position, changes in net position, or cash flows, as applicable, of Coldwater Community Schools.
Title: Note D - Grant Section Auditor Report Accounting Policies: Expenditures reported on the Schedule are reported on the same basis of accounting as the basic financial statements. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Indirect cost rates are only applied for some grants and are based solely on allowable rates established with the grantor; communicated to the District in the associated grant agreement. Management has utilized the MDE NexSys Grant, Application and Cash Management System Grant Auditor Report (GAR) in preparing the Schedule of Expenditures of Federal Awards.
Title: Note E - Non-Cash Assitance Accounting Policies: Expenditures reported on the Schedule are reported on the same basis of accounting as the basic financial statements. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Indirect cost rates are only applied for some grants and are based solely on allowable rates established with the grantor; communicated to the District in the associated grant agreement. The amounts reported on the Recipient Entitlement Balance Report, or PAL Report, agree with the SEFA for USDA donated food commodities.
Title: Note F - Federal Income Reconciliation Accounting Policies: Expenditures reported on the Schedule are reported on the same basis of accounting as the basic financial statements. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Indirect cost rates are only applied for some grants and are based solely on allowable rates established with the grantor; communicated to the District in the associated grant agreement. “See the Notes to the SEFA for chart/table”

Finding Details

Material Weakness in Internal Controls over Compliance (Allowable Costs/Cost Principles), and Noncompliance with Laws and Regulations. Program Impacted: 84.010 – Title I, Part A. Criteria: 2 CFR 200.430(i) requires that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. Among other requirements identified in this section, these records must (i) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated, and (v) comply with the established accounting policies and practices of the District. Condition: The District did not maintain adequate controls over time and effort reporting to substantiate salaries and wages charged to the Title I, Part A grant. Cause: The District’s oversight of salaries and wages charged to the Title I, Part A grant was insufficient. Effect: The District was unable to support the accuracy of salaries and wages charged to the Title I, Part A grant. Questioned Costs: The District adjusted unsupported charges from the grant via the final request for reimbursement for the fiscal year expenditures. No questioned costs after adjustments. Context: The District utilized Personnel Activity Reports (PARs) for split-funded personnel as the control over salaries and wages charged to the Title I, Part A grant. The PARs identify the employee and total hours spent on grant-funded activities, supporting the rate at which they are to be charged during the specified period. During our review of salaries and wages charged to the grant during the audit period, we noted instances of one individual being charged at rates in excess of those specified on the associated PAR. Recommendation: We recommend that the District adhere to documented time and effort reporting procedures and maintain effective internal controls that ensure salaries and wages are allocated based on records that accurately reflect the work performed. View of Responsible Officials: The District agrees with the finding and will adhere to documented time and effort reporting procedures to ensure that salaries and wages allocated to federal awards are accurate and adequately supported.
Material Weakness in Internal Controls over Compliance (Allowable Costs/Cost Principles), and Noncompliance with Laws and Regulations. Program Impacted: 84.010 – Title I, Part A. Criteria: 2 CFR 200.430(i) requires that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. Among other requirements identified in this section, these records must (i) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated, and (v) comply with the established accounting policies and practices of the District. Condition: The District did not maintain adequate controls over time and effort reporting to substantiate salaries and wages charged to the Title I, Part A grant. Cause: The District’s oversight of salaries and wages charged to the Title I, Part A grant was insufficient. Effect: The District was unable to support the accuracy of salaries and wages charged to the Title I, Part A grant. Questioned Costs: The District adjusted unsupported charges from the grant via the final request for reimbursement for the fiscal year expenditures. No questioned costs after adjustments. Context: The District utilized Personnel Activity Reports (PARs) for split-funded personnel as the control over salaries and wages charged to the Title I, Part A grant. The PARs identify the employee and total hours spent on grant-funded activities, supporting the rate at which they are to be charged during the specified period. During our review of salaries and wages charged to the grant during the audit period, we noted instances of one individual being charged at rates in excess of those specified on the associated PAR. Recommendation: We recommend that the District adhere to documented time and effort reporting procedures and maintain effective internal controls that ensure salaries and wages are allocated based on records that accurately reflect the work performed. View of Responsible Officials: The District agrees with the finding and will adhere to documented time and effort reporting procedures to ensure that salaries and wages allocated to federal awards are accurate and adequately supported.