Finding 2022-002: Reporting and Chart of Accounts Program Name: Elementary and Secondary School Emergency Relief Fund ? Assistance Listing 84.425C, 84.425D Awarding Agency: U.S. Department of Education, passed through Michigan Department of Education, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: Transactions need to be recorded based on the Michigan School Accounting Manual. The manual has the appropriate account classification with regard to account code dimensions (fund, function, major class, and object code). Condition: During our review of revenue and expenditures, we noted transactions are not being recorded to the appropriate revenue and expense accounts based on the Michigan School Accounting Manual for function, major class and object code. Cause / Effect: The School District did not have adequate controls in place to ensure transactions were being recorded to the proper accounts based on function, major class, and object code. The lack of consistency caused unnecessary variations between the accounting records and required reporting for final expenditure reports. Recommendation: We recommend the School District review the Michigan School Accounting Manual, and follow the guidelines for recording transaction with appropriate account classifications. Views of Responsible Officials and Corrective Actions: Management is in agreement with the finding. See accompanying Corrective Action Plan.
Finding 2022-002: Reporting and Chart of Accounts Program Name: Elementary and Secondary School Emergency Relief Fund ? Assistance Listing 84.425C, 84.425D Awarding Agency: U.S. Department of Education, passed through Michigan Department of Education, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: Transactions need to be recorded based on the Michigan School Accounting Manual. The manual has the appropriate account classification with regard to account code dimensions (fund, function, major class, and object code). Condition: During our review of revenue and expenditures, we noted transactions are not being recorded to the appropriate revenue and expense accounts based on the Michigan School Accounting Manual for function, major class and object code. Cause / Effect: The School District did not have adequate controls in place to ensure transactions were being recorded to the proper accounts based on function, major class, and object code. The lack of consistency caused unnecessary variations between the accounting records and required reporting for final expenditure reports. Recommendation: We recommend the School District review the Michigan School Accounting Manual, and follow the guidelines for recording transaction with appropriate account classifications. Views of Responsible Officials and Corrective Actions: Management is in agreement with the finding. See accompanying Corrective Action Plan.
Finding 2022-002: Reporting and Chart of Accounts Program Name: Elementary and Secondary School Emergency Relief Fund ? Assistance Listing 84.425C, 84.425D Awarding Agency: U.S. Department of Education, passed through Michigan Department of Education, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: Transactions need to be recorded based on the Michigan School Accounting Manual. The manual has the appropriate account classification with regard to account code dimensions (fund, function, major class, and object code). Condition: During our review of revenue and expenditures, we noted transactions are not being recorded to the appropriate revenue and expense accounts based on the Michigan School Accounting Manual for function, major class and object code. Cause / Effect: The School District did not have adequate controls in place to ensure transactions were being recorded to the proper accounts based on function, major class, and object code. The lack of consistency caused unnecessary variations between the accounting records and required reporting for final expenditure reports. Recommendation: We recommend the School District review the Michigan School Accounting Manual, and follow the guidelines for recording transaction with appropriate account classifications. Views of Responsible Officials and Corrective Actions: Management is in agreement with the finding. See accompanying Corrective Action Plan.
Finding 2022-002: Reporting and Chart of Accounts Program Name: Elementary and Secondary School Emergency Relief Fund ? Assistance Listing 84.425C, 84.425D Awarding Agency: U.S. Department of Education, passed through Michigan Department of Education, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: Transactions need to be recorded based on the Michigan School Accounting Manual. The manual has the appropriate account classification with regard to account code dimensions (fund, function, major class, and object code). Condition: During our review of revenue and expenditures, we noted transactions are not being recorded to the appropriate revenue and expense accounts based on the Michigan School Accounting Manual for function, major class and object code. Cause / Effect: The School District did not have adequate controls in place to ensure transactions were being recorded to the proper accounts based on function, major class, and object code. The lack of consistency caused unnecessary variations between the accounting records and required reporting for final expenditure reports. Recommendation: We recommend the School District review the Michigan School Accounting Manual, and follow the guidelines for recording transaction with appropriate account classifications. Views of Responsible Officials and Corrective Actions: Management is in agreement with the finding. See accompanying Corrective Action Plan.
Finding 2022-002: Reporting and Chart of Accounts Program Name: Elementary and Secondary School Emergency Relief Fund ? Assistance Listing 84.425C, 84.425D Awarding Agency: U.S. Department of Education, passed through Michigan Department of Education, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: Transactions need to be recorded based on the Michigan School Accounting Manual. The manual has the appropriate account classification with regard to account code dimensions (fund, function, major class, and object code). Condition: During our review of revenue and expenditures, we noted transactions are not being recorded to the appropriate revenue and expense accounts based on the Michigan School Accounting Manual for function, major class and object code. Cause / Effect: The School District did not have adequate controls in place to ensure transactions were being recorded to the proper accounts based on function, major class, and object code. The lack of consistency caused unnecessary variations between the accounting records and required reporting for final expenditure reports. Recommendation: We recommend the School District review the Michigan School Accounting Manual, and follow the guidelines for recording transaction with appropriate account classifications. Views of Responsible Officials and Corrective Actions: Management is in agreement with the finding. See accompanying Corrective Action Plan.
Finding 2022-004: Wage Rate Requirements Program Name: Elementary and Secondary School Emergency Relief Fund ? Assistance Listing 84.425U Awarding Agency: U.S. Department of Education, passed through Michigan Department of Education, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown ? The School District believes prevailing wages were paid; however, the School District did not have controls in place to retain adequate documentation to determine that the compliance requirement was met. Context / Criteria: All construction contracts in excess of $2,000 awarded by non-Federal entities must include a provision for compliance with the Davis-Bacon Act as supplemented by Department of Labor regulations. Condition: The School District did not have controls in place to ensure construction contracts in excess of $2,000 included provisions for compliance with the Davis-Bacon Act. Cause / Effect: The School District entered into a contract with a construction manager for a project not funded by federal funds. Subsequent to the agreement being placed into effect, a change order was added to include a HVAC project that would be funded by federal funds. The original contract and the change order did not include a provision for compliance with the Davis-Bacon Act. As a result, the School District entered into a construction contract that was not in compliance with 2 CFR Part 176 Subpart C. Recommendation: We recommend management implement procedures to ensure construction contracts entered into that utilize federal funding are reviewed for compliance with federal requirements. Views of Responsible Officials and Corrective Actions: Management is in agreement with the finding. See accompanying Corrective Action Plan.
Finding 2022-002: Reporting and Chart of Accounts Program Name: Elementary and Secondary School Emergency Relief Fund ? Assistance Listing 84.425C, 84.425D Awarding Agency: U.S. Department of Education, passed through Michigan Department of Education, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: Transactions need to be recorded based on the Michigan School Accounting Manual. The manual has the appropriate account classification with regard to account code dimensions (fund, function, major class, and object code). Condition: During our review of revenue and expenditures, we noted transactions are not being recorded to the appropriate revenue and expense accounts based on the Michigan School Accounting Manual for function, major class and object code. Cause / Effect: The School District did not have adequate controls in place to ensure transactions were being recorded to the proper accounts based on function, major class, and object code. The lack of consistency caused unnecessary variations between the accounting records and required reporting for final expenditure reports. Recommendation: We recommend the School District review the Michigan School Accounting Manual, and follow the guidelines for recording transaction with appropriate account classifications. Views of Responsible Officials and Corrective Actions: Management is in agreement with the finding. See accompanying Corrective Action Plan.
Finding 2022-002: Reporting and Chart of Accounts Program Name: Elementary and Secondary School Emergency Relief Fund ? Assistance Listing 84.425C, 84.425D Awarding Agency: U.S. Department of Education, passed through Michigan Department of Education, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: Transactions need to be recorded based on the Michigan School Accounting Manual. The manual has the appropriate account classification with regard to account code dimensions (fund, function, major class, and object code). Condition: During our review of revenue and expenditures, we noted transactions are not being recorded to the appropriate revenue and expense accounts based on the Michigan School Accounting Manual for function, major class and object code. Cause / Effect: The School District did not have adequate controls in place to ensure transactions were being recorded to the proper accounts based on function, major class, and object code. The lack of consistency caused unnecessary variations between the accounting records and required reporting for final expenditure reports. Recommendation: We recommend the School District review the Michigan School Accounting Manual, and follow the guidelines for recording transaction with appropriate account classifications. Views of Responsible Officials and Corrective Actions: Management is in agreement with the finding. See accompanying Corrective Action Plan.
Finding 2022-002: Reporting and Chart of Accounts Program Name: Elementary and Secondary School Emergency Relief Fund ? Assistance Listing 84.425C, 84.425D Awarding Agency: U.S. Department of Education, passed through Michigan Department of Education, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: Transactions need to be recorded based on the Michigan School Accounting Manual. The manual has the appropriate account classification with regard to account code dimensions (fund, function, major class, and object code). Condition: During our review of revenue and expenditures, we noted transactions are not being recorded to the appropriate revenue and expense accounts based on the Michigan School Accounting Manual for function, major class and object code. Cause / Effect: The School District did not have adequate controls in place to ensure transactions were being recorded to the proper accounts based on function, major class, and object code. The lack of consistency caused unnecessary variations between the accounting records and required reporting for final expenditure reports. Recommendation: We recommend the School District review the Michigan School Accounting Manual, and follow the guidelines for recording transaction with appropriate account classifications. Views of Responsible Officials and Corrective Actions: Management is in agreement with the finding. See accompanying Corrective Action Plan.
Finding 2022-002: Reporting and Chart of Accounts Program Name: Elementary and Secondary School Emergency Relief Fund ? Assistance Listing 84.425C, 84.425D Awarding Agency: U.S. Department of Education, passed through Michigan Department of Education, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: Transactions need to be recorded based on the Michigan School Accounting Manual. The manual has the appropriate account classification with regard to account code dimensions (fund, function, major class, and object code). Condition: During our review of revenue and expenditures, we noted transactions are not being recorded to the appropriate revenue and expense accounts based on the Michigan School Accounting Manual for function, major class and object code. Cause / Effect: The School District did not have adequate controls in place to ensure transactions were being recorded to the proper accounts based on function, major class, and object code. The lack of consistency caused unnecessary variations between the accounting records and required reporting for final expenditure reports. Recommendation: We recommend the School District review the Michigan School Accounting Manual, and follow the guidelines for recording transaction with appropriate account classifications. Views of Responsible Officials and Corrective Actions: Management is in agreement with the finding. See accompanying Corrective Action Plan.
Finding 2022-002: Reporting and Chart of Accounts Program Name: Elementary and Secondary School Emergency Relief Fund ? Assistance Listing 84.425C, 84.425D Awarding Agency: U.S. Department of Education, passed through Michigan Department of Education, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: Transactions need to be recorded based on the Michigan School Accounting Manual. The manual has the appropriate account classification with regard to account code dimensions (fund, function, major class, and object code). Condition: During our review of revenue and expenditures, we noted transactions are not being recorded to the appropriate revenue and expense accounts based on the Michigan School Accounting Manual for function, major class and object code. Cause / Effect: The School District did not have adequate controls in place to ensure transactions were being recorded to the proper accounts based on function, major class, and object code. The lack of consistency caused unnecessary variations between the accounting records and required reporting for final expenditure reports. Recommendation: We recommend the School District review the Michigan School Accounting Manual, and follow the guidelines for recording transaction with appropriate account classifications. Views of Responsible Officials and Corrective Actions: Management is in agreement with the finding. See accompanying Corrective Action Plan.
Finding 2022-004: Wage Rate Requirements Program Name: Elementary and Secondary School Emergency Relief Fund ? Assistance Listing 84.425U Awarding Agency: U.S. Department of Education, passed through Michigan Department of Education, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown ? The School District believes prevailing wages were paid; however, the School District did not have controls in place to retain adequate documentation to determine that the compliance requirement was met. Context / Criteria: All construction contracts in excess of $2,000 awarded by non-Federal entities must include a provision for compliance with the Davis-Bacon Act as supplemented by Department of Labor regulations. Condition: The School District did not have controls in place to ensure construction contracts in excess of $2,000 included provisions for compliance with the Davis-Bacon Act. Cause / Effect: The School District entered into a contract with a construction manager for a project not funded by federal funds. Subsequent to the agreement being placed into effect, a change order was added to include a HVAC project that would be funded by federal funds. The original contract and the change order did not include a provision for compliance with the Davis-Bacon Act. As a result, the School District entered into a construction contract that was not in compliance with 2 CFR Part 176 Subpart C. Recommendation: We recommend management implement procedures to ensure construction contracts entered into that utilize federal funding are reviewed for compliance with federal requirements. Views of Responsible Officials and Corrective Actions: Management is in agreement with the finding. See accompanying Corrective Action Plan.