Audit 5522

FY End
2023-06-30
Total Expended
$3.97M
Findings
8
Programs
13
Organization: Marysville Public Schools (MI)
Year: 2023 Accepted: 2023-12-06
Auditor: Uhy LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
3506 2023-004 Material Weakness - P
3507 2023-004 Material Weakness - P
3508 2023-004 Material Weakness - P
3509 2023-004 Material Weakness - P
579948 2023-004 Material Weakness - P
579949 2023-004 Material Weakness - P
579950 2023-004 Material Weakness - P
579951 2023-004 Material Weakness - P

Contacts

Name Title Type
SE2KWRK3L2H7 Jennifer McKay Auditee
8104556012 Scot Hoskins Auditor
No contacts on file

Notes to SEFA

Title: NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES: Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of Marysville Public Schools (the “District”) for the year ended June 30, 2023. Expenditures reported on the Schedule are reported on the same basis of accounting, the modified accrual basis, as the financial statements, although the basis for determining when federal awards are expended 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), wherein certain types of expenditures are not allowable or are limited as to reimbursement. Revenue has been accrued at June 30, 2023 to match allowable expenditures incurred during the year for each program. Grant funds received in advance that are in excess of incurred costs have been reflected as unearned revenue. All year-end accruals are considered to have met the modified accrual basis of accounting revenue recognition criteria of measurability and availability. USDA commodities have been recognized as revenues and expenditures when received by the District. For purposes of charging indirect costs to federal awards, the District has not elected to use the 10% de minimis cost rate. The District administers a number of federal grants, which are paid under reimburse¬ment arrangements in which the District bills the Michigan Department of Education (MDE) or other pass-through grantors for allowable costs incurred. The programs identi¬fied on the Schedule are reported in the General and Special Revenue Funds of the District. 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 or changes in net position of the District. De Minimis Rate Used: N Rate Explanation: The District administers a number of federal grants, which are paid under reimburse¬ment arrangements in which the District bills the Michigan Department of Education (MDE) or other pass-through grantors for allowable costs incurred. The programs identi¬fied on the Schedule are reported in the General and Special Revenue Funds of the District. The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of Marysville Public Schools (the “District”) for the year ended June 30, 2023. Expenditures reported on the Schedule are reported on the same basis of accounting, the modified accrual basis, as the financial statements, although the basis for determining when federal awards are expended 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), wherein certain types of expenditures are not allowable or are limited as to reimbursement. Revenue has been accrued at June 30, 2023 to match allowable expenditures incurred during the year for each program. Grant funds received in advance that are in excess of incurred costs have been reflected as unearned revenue. All year-end accruals are considered to have met the modified accrual basis of accounting revenue recognition criteria of measurability and availability. USDA commodities have been recognized as revenues and expenditures when received by the District. For purposes of charging indirect costs to federal awards, the District has not elected to use the 10% de minimis cost rate. The District administers a number of federal grants, which are paid under reimbursement arrangements in which the District bills the Michigan Department of Education (MDE) or other pass-through grantors for allowable costs incurred. The programs identified on the Schedule are reported in the General and Special Revenue Funds of the District. 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 or changes in net position of the District.
Title: NOTE 2 - NONCASH ASSISTANCE: Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of Marysville Public Schools (the “District”) for the year ended June 30, 2023. Expenditures reported on the Schedule are reported on the same basis of accounting, the modified accrual basis, as the financial statements, although the basis for determining when federal awards are expended 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), wherein certain types of expenditures are not allowable or are limited as to reimbursement. Revenue has been accrued at June 30, 2023 to match allowable expenditures incurred during the year for each program. Grant funds received in advance that are in excess of incurred costs have been reflected as unearned revenue. All year-end accruals are considered to have met the modified accrual basis of accounting revenue recognition criteria of measurability and availability. USDA commodities have been recognized as revenues and expenditures when received by the District. For purposes of charging indirect costs to federal awards, the District has not elected to use the 10% de minimis cost rate. The District administers a number of federal grants, which are paid under reimburse¬ment arrangements in which the District bills the Michigan Department of Education (MDE) or other pass-through grantors for allowable costs incurred. The programs identi¬fied on the Schedule are reported in the General and Special Revenue Funds of the District. 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 or changes in net position of the District. De Minimis Rate Used: N Rate Explanation: The District administers a number of federal grants, which are paid under reimburse¬ment arrangements in which the District bills the Michigan Department of Education (MDE) or other pass-through grantors for allowable costs incurred. The programs identi¬fied on the Schedule are reported in the General and Special Revenue Funds of the District. The value of the noncash assistance (commodities) received was determined in accordance with the provisions of the Uniform Guidance. The Recipient Entitlement Balance Report is utilized to determine the value of commodities distributed to the District.
Title: NOTE 3 - CASH MANAGEMENT SYSTEM AND GRANT AUDITOR REPORT UTILIZATION: Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of Marysville Public Schools (the “District”) for the year ended June 30, 2023. Expenditures reported on the Schedule are reported on the same basis of accounting, the modified accrual basis, as the financial statements, although the basis for determining when federal awards are expended 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), wherein certain types of expenditures are not allowable or are limited as to reimbursement. Revenue has been accrued at June 30, 2023 to match allowable expenditures incurred during the year for each program. Grant funds received in advance that are in excess of incurred costs have been reflected as unearned revenue. All year-end accruals are considered to have met the modified accrual basis of accounting revenue recognition criteria of measurability and availability. USDA commodities have been recognized as revenues and expenditures when received by the District. For purposes of charging indirect costs to federal awards, the District has not elected to use the 10% de minimis cost rate. The District administers a number of federal grants, which are paid under reimburse¬ment arrangements in which the District bills the Michigan Department of Education (MDE) or other pass-through grantors for allowable costs incurred. The programs identi¬fied on the Schedule are reported in the General and Special Revenue Funds of the District. 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 or changes in net position of the District. De Minimis Rate Used: N Rate Explanation: The District administers a number of federal grants, which are paid under reimburse¬ment arrangements in which the District bills the Michigan Department of Education (MDE) or other pass-through grantors for allowable costs incurred. The programs identi¬fied on the Schedule are reported in the General and Special Revenue Funds of the District. The District utilizes the MDE NexSys and Grant Auditor Report (GAR) in preparing the Schedule.
Title: NOTE 4 - RECONCILIATION OF REVENUES WITH EXPENDITURES OF FEDERAL AWARD PROGRAMS: Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of Marysville Public Schools (the “District”) for the year ended June 30, 2023. Expenditures reported on the Schedule are reported on the same basis of accounting, the modified accrual basis, as the financial statements, although the basis for determining when federal awards are expended 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), wherein certain types of expenditures are not allowable or are limited as to reimbursement. Revenue has been accrued at June 30, 2023 to match allowable expenditures incurred during the year for each program. Grant funds received in advance that are in excess of incurred costs have been reflected as unearned revenue. All year-end accruals are considered to have met the modified accrual basis of accounting revenue recognition criteria of measurability and availability. USDA commodities have been recognized as revenues and expenditures when received by the District. For purposes of charging indirect costs to federal awards, the District has not elected to use the 10% de minimis cost rate. The District administers a number of federal grants, which are paid under reimburse¬ment arrangements in which the District bills the Michigan Department of Education (MDE) or other pass-through grantors for allowable costs incurred. The programs identi¬fied on the Schedule are reported in the General and Special Revenue Funds of the District. 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 or changes in net position of the District. De Minimis Rate Used: N Rate Explanation: The District administers a number of federal grants, which are paid under reimburse¬ment arrangements in which the District bills the Michigan Department of Education (MDE) or other pass-through grantors for allowable costs incurred. The programs identi¬fied on the Schedule are reported in the General and Special Revenue Funds of the District. The following schedule reconciles revenue from federal sources reported in the financial statements to the expenditures of federal awards reported on the Schedule: See notes to the SEFA for chart/table

Finding Details

Material Adjusting Entries and Potential Impact on SEFA Accuracy Program Federal awards internal control deficiency that could impact the accuracy and completeness of federal awards reported on the Schedule of Expenditures of Federal Awards and have an impact on determination of major programs. Type: Material Weakness in Internal Control over federal awards. Criteria: The Schedule of Expenditures of Federal Awards is considered a required element of external financial reporting under SAS 115 and supplementary information required by Uniform Guidance. It is used by grantors and pass-through grantors to monitor federal awards and by auditee auditors to select major programs. Condition: The District’s listing of grants to prepare the SEFA was not accurately reported due to exclusion of indirect costs and unrecorded receivables and deferrals for certain federal awards. Context: The federal grants identified on the District’s listing of grants was understated by $1,078,725. Cause: Due in part to turnover in the Director of Business and Finance position and lack of appropriate and timely monthly close process, the reconciliations were not completed in a timely manner. Effect: Material misstatement of the SEFA is more than probable. Recommendation: The District should create a template to reconcile federal grant activity to the general ledger revenue, expenditure and deferral balances. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Material Adjusting Entries and Potential Impact on SEFA Accuracy Program Federal awards internal control deficiency that could impact the accuracy and completeness of federal awards reported on the Schedule of Expenditures of Federal Awards and have an impact on determination of major programs. Type: Material Weakness in Internal Control over federal awards. Criteria: The Schedule of Expenditures of Federal Awards is considered a required element of external financial reporting under SAS 115 and supplementary information required by Uniform Guidance. It is used by grantors and pass-through grantors to monitor federal awards and by auditee auditors to select major programs. Condition: The District’s listing of grants to prepare the SEFA was not accurately reported due to exclusion of indirect costs and unrecorded receivables and deferrals for certain federal awards. Context: The federal grants identified on the District’s listing of grants was understated by $1,078,725. Cause: Due in part to turnover in the Director of Business and Finance position and lack of appropriate and timely monthly close process, the reconciliations were not completed in a timely manner. Effect: Material misstatement of the SEFA is more than probable. Recommendation: The District should create a template to reconcile federal grant activity to the general ledger revenue, expenditure and deferral balances. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Material Adjusting Entries and Potential Impact on SEFA Accuracy Program Federal awards internal control deficiency that could impact the accuracy and completeness of federal awards reported on the Schedule of Expenditures of Federal Awards and have an impact on determination of major programs. Type: Material Weakness in Internal Control over federal awards. Criteria: The Schedule of Expenditures of Federal Awards is considered a required element of external financial reporting under SAS 115 and supplementary information required by Uniform Guidance. It is used by grantors and pass-through grantors to monitor federal awards and by auditee auditors to select major programs. Condition: The District’s listing of grants to prepare the SEFA was not accurately reported due to exclusion of indirect costs and unrecorded receivables and deferrals for certain federal awards. Context: The federal grants identified on the District’s listing of grants was understated by $1,078,725. Cause: Due in part to turnover in the Director of Business and Finance position and lack of appropriate and timely monthly close process, the reconciliations were not completed in a timely manner. Effect: Material misstatement of the SEFA is more than probable. Recommendation: The District should create a template to reconcile federal grant activity to the general ledger revenue, expenditure and deferral balances. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Material Adjusting Entries and Potential Impact on SEFA Accuracy Program Federal awards internal control deficiency that could impact the accuracy and completeness of federal awards reported on the Schedule of Expenditures of Federal Awards and have an impact on determination of major programs. Type: Material Weakness in Internal Control over federal awards. Criteria: The Schedule of Expenditures of Federal Awards is considered a required element of external financial reporting under SAS 115 and supplementary information required by Uniform Guidance. It is used by grantors and pass-through grantors to monitor federal awards and by auditee auditors to select major programs. Condition: The District’s listing of grants to prepare the SEFA was not accurately reported due to exclusion of indirect costs and unrecorded receivables and deferrals for certain federal awards. Context: The federal grants identified on the District’s listing of grants was understated by $1,078,725. Cause: Due in part to turnover in the Director of Business and Finance position and lack of appropriate and timely monthly close process, the reconciliations were not completed in a timely manner. Effect: Material misstatement of the SEFA is more than probable. Recommendation: The District should create a template to reconcile federal grant activity to the general ledger revenue, expenditure and deferral balances. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Material Adjusting Entries and Potential Impact on SEFA Accuracy Program Federal awards internal control deficiency that could impact the accuracy and completeness of federal awards reported on the Schedule of Expenditures of Federal Awards and have an impact on determination of major programs. Type: Material Weakness in Internal Control over federal awards. Criteria: The Schedule of Expenditures of Federal Awards is considered a required element of external financial reporting under SAS 115 and supplementary information required by Uniform Guidance. It is used by grantors and pass-through grantors to monitor federal awards and by auditee auditors to select major programs. Condition: The District’s listing of grants to prepare the SEFA was not accurately reported due to exclusion of indirect costs and unrecorded receivables and deferrals for certain federal awards. Context: The federal grants identified on the District’s listing of grants was understated by $1,078,725. Cause: Due in part to turnover in the Director of Business and Finance position and lack of appropriate and timely monthly close process, the reconciliations were not completed in a timely manner. Effect: Material misstatement of the SEFA is more than probable. Recommendation: The District should create a template to reconcile federal grant activity to the general ledger revenue, expenditure and deferral balances. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Material Adjusting Entries and Potential Impact on SEFA Accuracy Program Federal awards internal control deficiency that could impact the accuracy and completeness of federal awards reported on the Schedule of Expenditures of Federal Awards and have an impact on determination of major programs. Type: Material Weakness in Internal Control over federal awards. Criteria: The Schedule of Expenditures of Federal Awards is considered a required element of external financial reporting under SAS 115 and supplementary information required by Uniform Guidance. It is used by grantors and pass-through grantors to monitor federal awards and by auditee auditors to select major programs. Condition: The District’s listing of grants to prepare the SEFA was not accurately reported due to exclusion of indirect costs and unrecorded receivables and deferrals for certain federal awards. Context: The federal grants identified on the District’s listing of grants was understated by $1,078,725. Cause: Due in part to turnover in the Director of Business and Finance position and lack of appropriate and timely monthly close process, the reconciliations were not completed in a timely manner. Effect: Material misstatement of the SEFA is more than probable. Recommendation: The District should create a template to reconcile federal grant activity to the general ledger revenue, expenditure and deferral balances. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Material Adjusting Entries and Potential Impact on SEFA Accuracy Program Federal awards internal control deficiency that could impact the accuracy and completeness of federal awards reported on the Schedule of Expenditures of Federal Awards and have an impact on determination of major programs. Type: Material Weakness in Internal Control over federal awards. Criteria: The Schedule of Expenditures of Federal Awards is considered a required element of external financial reporting under SAS 115 and supplementary information required by Uniform Guidance. It is used by grantors and pass-through grantors to monitor federal awards and by auditee auditors to select major programs. Condition: The District’s listing of grants to prepare the SEFA was not accurately reported due to exclusion of indirect costs and unrecorded receivables and deferrals for certain federal awards. Context: The federal grants identified on the District’s listing of grants was understated by $1,078,725. Cause: Due in part to turnover in the Director of Business and Finance position and lack of appropriate and timely monthly close process, the reconciliations were not completed in a timely manner. Effect: Material misstatement of the SEFA is more than probable. Recommendation: The District should create a template to reconcile federal grant activity to the general ledger revenue, expenditure and deferral balances. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Material Adjusting Entries and Potential Impact on SEFA Accuracy Program Federal awards internal control deficiency that could impact the accuracy and completeness of federal awards reported on the Schedule of Expenditures of Federal Awards and have an impact on determination of major programs. Type: Material Weakness in Internal Control over federal awards. Criteria: The Schedule of Expenditures of Federal Awards is considered a required element of external financial reporting under SAS 115 and supplementary information required by Uniform Guidance. It is used by grantors and pass-through grantors to monitor federal awards and by auditee auditors to select major programs. Condition: The District’s listing of grants to prepare the SEFA was not accurately reported due to exclusion of indirect costs and unrecorded receivables and deferrals for certain federal awards. Context: The federal grants identified on the District’s listing of grants was understated by $1,078,725. Cause: Due in part to turnover in the Director of Business and Finance position and lack of appropriate and timely monthly close process, the reconciliations were not completed in a timely manner. Effect: Material misstatement of the SEFA is more than probable. Recommendation: The District should create a template to reconcile federal grant activity to the general ledger revenue, expenditure and deferral balances. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding. See corrective action plan.