Audit 1901

FY End
2023-06-30
Total Expended
$44.33M
Findings
8
Programs
18
Organization: School District, City of Flint (MI)
Year: 2023 Accepted: 2023-10-31

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
998 2023-001 - - L
999 2023-001 - - L
1000 2023-001 - - L
1001 2023-002 - - L
577440 2023-001 - - L
577441 2023-001 - - L
577442 2023-001 - - L
577443 2023-002 - - L

Programs

Contacts

Name Title Type
MNNJZH49BK96 Terese Knag Auditee
8107607778 Cynthia R. Scott Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the schedule of federal expenditures are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, where in certain types of expenditures are not allowable or are limited as a reimbursement. Cash received is recorded on the cash basis. Revenues are recognized when qualifying expenditures have been incurred and all grant requirements have been met. Expenditures on this schedule reconcile with amounts reported in the financial statements and the financial reports submitted to the Michigan Department of Education. Management has utilized the MDE NexSys Grant Auditor Report (GAR) in preparing the Schedule of Expenditures of Federal Awards. The amounts reported on the Recipient Entitlement Balance Report, or PAL Report, agree with this schedule for USDA donated food commodities and are reported in the Cash Receipts column. Expenditures include spoilage or pilferage. De Minimis Rate Used: N Rate Explanation: Flint Community Schools did not elect to use a flat de minimis rate of 10% of modified total direct costs for their indirect cost rate. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Flint Community Schools 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 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 Flint Community Schools, it is not intended to and does not present the financial position, changes in net assets, or cash flows of Flint Community Schools.
Title: Reconciliation to the Michigan Department of Education (MDE) NexSys Grant Section Auditors Report (GAR): Accounting Policies: Expenditures reported on the schedule of federal expenditures are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, where in certain types of expenditures are not allowable or are limited as a reimbursement. Cash received is recorded on the cash basis. Revenues are recognized when qualifying expenditures have been incurred and all grant requirements have been met. Expenditures on this schedule reconcile with amounts reported in the financial statements and the financial reports submitted to the Michigan Department of Education. Management has utilized the MDE NexSys Grant Auditor Report (GAR) in preparing the Schedule of Expenditures of Federal Awards. The amounts reported on the Recipient Entitlement Balance Report, or PAL Report, agree with this schedule for USDA donated food commodities and are reported in the Cash Receipts column. Expenditures include spoilage or pilferage. De Minimis Rate Used: N Rate Explanation: Flint Community Schools did not elect to use a flat de minimis rate of 10% of modified total direct costs for their indirect cost rate. District total current payments per MDE NexSys GAR $60,418,610 Addition of receipts not passed through the Michigan Department of Education and not included in the NexSys System: 55030 Entitlement Commodities 124,335 55030 Bonus Commodities 19,437 Special Education Cluster 1,579,849 Title I Technical Assistance Grant 8,022 Title III Part A Immigrant Students 14,109 Medicaid Outreach AOP 2021-2022 10,384 Medicaid Outreach AOP 2022-2023 Plus payments out of NexSys in the prior year, but not received by the District until after June 30, 2022: Seamless Summer Option (SSO) - Breakfast 221971 2021-2022 76,699 Seamless Summer Option (SSO) - Lunch 221961 2021-2022 184,206 CACEF Child Care Food Program 221920 2021-2022 25,397 CACEF Cash-in-Lieu of Commodities 222010 2021-2022 1,071 Less payments out of NexSys prior to year end, but not received by the District until after June 30, 2023: School Breakfast Expansion (10,000) Total Current Year Receipts per the Schedule of Expenditures of Federal Awards $62,452,119
Title: Reconciliation to Financial Statements: Accounting Policies: Expenditures reported on the schedule of federal expenditures are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, where in certain types of expenditures are not allowable or are limited as a reimbursement. Cash received is recorded on the cash basis. Revenues are recognized when qualifying expenditures have been incurred and all grant requirements have been met. Expenditures on this schedule reconcile with amounts reported in the financial statements and the financial reports submitted to the Michigan Department of Education. Management has utilized the MDE NexSys Grant Auditor Report (GAR) in preparing the Schedule of Expenditures of Federal Awards. The amounts reported on the Recipient Entitlement Balance Report, or PAL Report, agree with this schedule for USDA donated food commodities and are reported in the Cash Receipts column. Expenditures include spoilage or pilferage. De Minimis Rate Used: N Rate Explanation: Flint Community Schools did not elect to use a flat de minimis rate of 10% of modified total direct costs for their indirect cost rate. General Fund $42,644,156 Special Revenue Fund: Lunch Fund 2,775,487 Federal Revenue Presented in the Financial Statements 45,419,643 Federal revenue for which the School District is considered a vendor or beneficiary rather than a subrecipient: NJROTC Program Grant JROTC221S (64,241) Accounts receivable for the year ended June 30, 2022 received more than 60 days after year-end and recognized as federal revenue in fiscal year June 30, 2023 financial statements: Title I - Part A Imp Basic Pro 221530 2122 (104,700) IDEA Preschool 2021-2022 (56,306) MiCLSD 210210 21 (175,885) Less a prior period adjustment recorded in the current year for accounts receivable for the year ended June 30, 2022 received more than 60 days after year-end and to be recognized as federal revenue in fiscal year June 30, 2023 financial statements that were not shown as unavailable revenue in the prior year financial statements: Title I - Part A Imp Basic Pro 221530 2122 (538,227) Title IIA - Improving Teacher Quality 220520 2122 (151,647) MiCLSD 210210 21 (1,626) Federal Revenue on the Schedule of Expenditures of Federal Awards $44,327,011

Finding Details

Condition and Criteria: The Federal Compliance Supplement requires that accurate records be maintained justifying all meals claimed and documenting that all program funds were spent only on allowable Child Nutrition Program costs. Each month the outsourced management company compares total meals served to total meals claimed, making an adjustment to actual for any missed meals. However, the appropriate documentation supporting the adjustment is not maintained and was not able to be recreated by the management company. In addition, it was found that at one school building, that at times, tally sheets were recreated and unintentionally duplicated, increasing the meals claimed. Effect: This creates potential questioned costs for those unsupported meals being claimed as well as known questioned costs for the duplicated tally sheets claimed. Cause: The management company claims that their weekly closeout occurs on Thursdays, making it likely for meals served on Fridays to be missed in initial counts. In addition, if students are on a field trip, there are times that their daily tally sheets are not turned in on time. However, proper documentation of missed meals is not maintained to support the additional meals being claimed. The duplicated tally sheets occurred by an employee trying to combine the tally sheets into one, and subsequently submitting both the combined tally sheet with the original tally sheets to the management company for reimbursement. Context: The unsupported meals being claimed is a systematic problem occurring due to the process being followed by the management company. The duplicated tally sheets is isolated to one building. Questioned Costs: $295,380. This is the estimated total federal reimbursement for all unsupported meal claims plus the anticipated overcharged claims for duplicated tally sheets. This was determined by taking the known overages and estimating the remaining overages for the months in which the related reports were not available. Auditors' Recommendation: We recommend that in situations where missed meals are identified, that proper documentation (including original tally sheets) be maintained and kept on hand to support the additional meals being claimed. In addition, we recommend that staff be properly trained to not recreate tally sheets, but to properly document on the original copies, to ensure that meal counts are not duplicated. Views of Responsible Officials and Planned Corrective Actions: The District understands the issue and will work with their management company on correcting this issue moving forward. Please see the attached Corrective Action Plan prepared by the District.
Condition and Criteria: The Federal Compliance Supplement requires that accurate records be maintained justifying all meals claimed and documenting that all program funds were spent only on allowable Child Nutrition Program costs. Each month the outsourced management company compares total meals served to total meals claimed, making an adjustment to actual for any missed meals. However, the appropriate documentation supporting the adjustment is not maintained and was not able to be recreated by the management company. In addition, it was found that at one school building, that at times, tally sheets were recreated and unintentionally duplicated, increasing the meals claimed. Effect: This creates potential questioned costs for those unsupported meals being claimed as well as known questioned costs for the duplicated tally sheets claimed. Cause: The management company claims that their weekly closeout occurs on Thursdays, making it likely for meals served on Fridays to be missed in initial counts. In addition, if students are on a field trip, there are times that their daily tally sheets are not turned in on time. However, proper documentation of missed meals is not maintained to support the additional meals being claimed. The duplicated tally sheets occurred by an employee trying to combine the tally sheets into one, and subsequently submitting both the combined tally sheet with the original tally sheets to the management company for reimbursement. Context: The unsupported meals being claimed is a systematic problem occurring due to the process being followed by the management company. The duplicated tally sheets is isolated to one building. Questioned Costs: $295,380. This is the estimated total federal reimbursement for all unsupported meal claims plus the anticipated overcharged claims for duplicated tally sheets. This was determined by taking the known overages and estimating the remaining overages for the months in which the related reports were not available. Auditors' Recommendation: We recommend that in situations where missed meals are identified, that proper documentation (including original tally sheets) be maintained and kept on hand to support the additional meals being claimed. In addition, we recommend that staff be properly trained to not recreate tally sheets, but to properly document on the original copies, to ensure that meal counts are not duplicated. Views of Responsible Officials and Planned Corrective Actions: The District understands the issue and will work with their management company on correcting this issue moving forward. Please see the attached Corrective Action Plan prepared by the District.
Condition and Criteria: The Federal Compliance Supplement requires that accurate records be maintained justifying all meals claimed and documenting that all program funds were spent only on allowable Child Nutrition Program costs. Each month the outsourced management company compares total meals served to total meals claimed, making an adjustment to actual for any missed meals. However, the appropriate documentation supporting the adjustment is not maintained and was not able to be recreated by the management company. In addition, it was found that at one school building, that at times, tally sheets were recreated and unintentionally duplicated, increasing the meals claimed. Effect: This creates potential questioned costs for those unsupported meals being claimed as well as known questioned costs for the duplicated tally sheets claimed. Cause: The management company claims that their weekly closeout occurs on Thursdays, making it likely for meals served on Fridays to be missed in initial counts. In addition, if students are on a field trip, there are times that their daily tally sheets are not turned in on time. However, proper documentation of missed meals is not maintained to support the additional meals being claimed. The duplicated tally sheets occurred by an employee trying to combine the tally sheets into one, and subsequently submitting both the combined tally sheet with the original tally sheets to the management company for reimbursement. Context: The unsupported meals being claimed is a systematic problem occurring due to the process being followed by the management company. The duplicated tally sheets is isolated to one building. Questioned Costs: $295,380. This is the estimated total federal reimbursement for all unsupported meal claims plus the anticipated overcharged claims for duplicated tally sheets. This was determined by taking the known overages and estimating the remaining overages for the months in which the related reports were not available. Auditors' Recommendation: We recommend that in situations where missed meals are identified, that proper documentation (including original tally sheets) be maintained and kept on hand to support the additional meals being claimed. In addition, we recommend that staff be properly trained to not recreate tally sheets, but to properly document on the original copies, to ensure that meal counts are not duplicated. Views of Responsible Officials and Planned Corrective Actions: The District understands the issue and will work with their management company on correcting this issue moving forward. Please see the attached Corrective Action Plan prepared by the District.
Condition and Criteria: The Michigan Department of Education (MDE) requires that Local Education Agency's (LEA’s) report their final expenditures upon completion of a grant, and that those records agree with the LEA's detailed records and that the allocation of costs within the report are appropriate. MDE further requires that any expenditures that are over an approved amount by more than 10% obtain an approved budget amendment. When the ESSER I Final Expenditure Report (FER) was filed, various amounts by function and object code exceeded the final approved budget by more than 10%. Effect: The District has questioned costs for the portions of their FER exceeding 10% of the approved budget. Cause: Some misclassifications were found throughout the audit testing which could imply that these excess costs are in fact included in the approved budget but simply misclassified. However, we are unable to verify that, and must consider these excess costs as unallowable. Context: The FER and all final trial balances for the fiscal years included in the grant were reviewed and evaluated in total. Only the ESSER I FER included overages over 10%. Questioned Costs: $345,536 Auditors' Recommendation: We recommend that the business office closely compare all FERs with not only their final trial balances, but also with their final approved budgets to ensure that all amounts agree and do not exceed more than 10% of the budget, prior to finalizing the FER in the NexSys System. Views of Responsible Officials and Planned Corrective Actions: The District understands the situation and will ensure this happens moving forward. Please see the attached Corrective Action Plan prepared by the District.
Condition and Criteria: The Federal Compliance Supplement requires that accurate records be maintained justifying all meals claimed and documenting that all program funds were spent only on allowable Child Nutrition Program costs. Each month the outsourced management company compares total meals served to total meals claimed, making an adjustment to actual for any missed meals. However, the appropriate documentation supporting the adjustment is not maintained and was not able to be recreated by the management company. In addition, it was found that at one school building, that at times, tally sheets were recreated and unintentionally duplicated, increasing the meals claimed. Effect: This creates potential questioned costs for those unsupported meals being claimed as well as known questioned costs for the duplicated tally sheets claimed. Cause: The management company claims that their weekly closeout occurs on Thursdays, making it likely for meals served on Fridays to be missed in initial counts. In addition, if students are on a field trip, there are times that their daily tally sheets are not turned in on time. However, proper documentation of missed meals is not maintained to support the additional meals being claimed. The duplicated tally sheets occurred by an employee trying to combine the tally sheets into one, and subsequently submitting both the combined tally sheet with the original tally sheets to the management company for reimbursement. Context: The unsupported meals being claimed is a systematic problem occurring due to the process being followed by the management company. The duplicated tally sheets is isolated to one building. Questioned Costs: $295,380. This is the estimated total federal reimbursement for all unsupported meal claims plus the anticipated overcharged claims for duplicated tally sheets. This was determined by taking the known overages and estimating the remaining overages for the months in which the related reports were not available. Auditors' Recommendation: We recommend that in situations where missed meals are identified, that proper documentation (including original tally sheets) be maintained and kept on hand to support the additional meals being claimed. In addition, we recommend that staff be properly trained to not recreate tally sheets, but to properly document on the original copies, to ensure that meal counts are not duplicated. Views of Responsible Officials and Planned Corrective Actions: The District understands the issue and will work with their management company on correcting this issue moving forward. Please see the attached Corrective Action Plan prepared by the District.
Condition and Criteria: The Federal Compliance Supplement requires that accurate records be maintained justifying all meals claimed and documenting that all program funds were spent only on allowable Child Nutrition Program costs. Each month the outsourced management company compares total meals served to total meals claimed, making an adjustment to actual for any missed meals. However, the appropriate documentation supporting the adjustment is not maintained and was not able to be recreated by the management company. In addition, it was found that at one school building, that at times, tally sheets were recreated and unintentionally duplicated, increasing the meals claimed. Effect: This creates potential questioned costs for those unsupported meals being claimed as well as known questioned costs for the duplicated tally sheets claimed. Cause: The management company claims that their weekly closeout occurs on Thursdays, making it likely for meals served on Fridays to be missed in initial counts. In addition, if students are on a field trip, there are times that their daily tally sheets are not turned in on time. However, proper documentation of missed meals is not maintained to support the additional meals being claimed. The duplicated tally sheets occurred by an employee trying to combine the tally sheets into one, and subsequently submitting both the combined tally sheet with the original tally sheets to the management company for reimbursement. Context: The unsupported meals being claimed is a systematic problem occurring due to the process being followed by the management company. The duplicated tally sheets is isolated to one building. Questioned Costs: $295,380. This is the estimated total federal reimbursement for all unsupported meal claims plus the anticipated overcharged claims for duplicated tally sheets. This was determined by taking the known overages and estimating the remaining overages for the months in which the related reports were not available. Auditors' Recommendation: We recommend that in situations where missed meals are identified, that proper documentation (including original tally sheets) be maintained and kept on hand to support the additional meals being claimed. In addition, we recommend that staff be properly trained to not recreate tally sheets, but to properly document on the original copies, to ensure that meal counts are not duplicated. Views of Responsible Officials and Planned Corrective Actions: The District understands the issue and will work with their management company on correcting this issue moving forward. Please see the attached Corrective Action Plan prepared by the District.
Condition and Criteria: The Federal Compliance Supplement requires that accurate records be maintained justifying all meals claimed and documenting that all program funds were spent only on allowable Child Nutrition Program costs. Each month the outsourced management company compares total meals served to total meals claimed, making an adjustment to actual for any missed meals. However, the appropriate documentation supporting the adjustment is not maintained and was not able to be recreated by the management company. In addition, it was found that at one school building, that at times, tally sheets were recreated and unintentionally duplicated, increasing the meals claimed. Effect: This creates potential questioned costs for those unsupported meals being claimed as well as known questioned costs for the duplicated tally sheets claimed. Cause: The management company claims that their weekly closeout occurs on Thursdays, making it likely for meals served on Fridays to be missed in initial counts. In addition, if students are on a field trip, there are times that their daily tally sheets are not turned in on time. However, proper documentation of missed meals is not maintained to support the additional meals being claimed. The duplicated tally sheets occurred by an employee trying to combine the tally sheets into one, and subsequently submitting both the combined tally sheet with the original tally sheets to the management company for reimbursement. Context: The unsupported meals being claimed is a systematic problem occurring due to the process being followed by the management company. The duplicated tally sheets is isolated to one building. Questioned Costs: $295,380. This is the estimated total federal reimbursement for all unsupported meal claims plus the anticipated overcharged claims for duplicated tally sheets. This was determined by taking the known overages and estimating the remaining overages for the months in which the related reports were not available. Auditors' Recommendation: We recommend that in situations where missed meals are identified, that proper documentation (including original tally sheets) be maintained and kept on hand to support the additional meals being claimed. In addition, we recommend that staff be properly trained to not recreate tally sheets, but to properly document on the original copies, to ensure that meal counts are not duplicated. Views of Responsible Officials and Planned Corrective Actions: The District understands the issue and will work with their management company on correcting this issue moving forward. Please see the attached Corrective Action Plan prepared by the District.
Condition and Criteria: The Michigan Department of Education (MDE) requires that Local Education Agency's (LEA’s) report their final expenditures upon completion of a grant, and that those records agree with the LEA's detailed records and that the allocation of costs within the report are appropriate. MDE further requires that any expenditures that are over an approved amount by more than 10% obtain an approved budget amendment. When the ESSER I Final Expenditure Report (FER) was filed, various amounts by function and object code exceeded the final approved budget by more than 10%. Effect: The District has questioned costs for the portions of their FER exceeding 10% of the approved budget. Cause: Some misclassifications were found throughout the audit testing which could imply that these excess costs are in fact included in the approved budget but simply misclassified. However, we are unable to verify that, and must consider these excess costs as unallowable. Context: The FER and all final trial balances for the fiscal years included in the grant were reviewed and evaluated in total. Only the ESSER I FER included overages over 10%. Questioned Costs: $345,536 Auditors' Recommendation: We recommend that the business office closely compare all FERs with not only their final trial balances, but also with their final approved budgets to ensure that all amounts agree and do not exceed more than 10% of the budget, prior to finalizing the FER in the NexSys System. Views of Responsible Officials and Planned Corrective Actions: The District understands the situation and will ensure this happens moving forward. Please see the attached Corrective Action Plan prepared by the District.