Audit 39087

FY End
2022-06-30
Total Expended
$75.65M
Findings
6
Programs
26
Year: 2022 Accepted: 2023-03-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
41866 2022-102 Significant Deficiency Yes L
41867 2022-102 Significant Deficiency Yes L
41868 2022-101 Significant Deficiency - AB
618308 2022-102 Significant Deficiency Yes L
618309 2022-102 Significant Deficiency Yes L
618310 2022-101 Significant Deficiency - AB

Programs

ALN Program Spent Major Findings
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $10.57M Yes 0
10.555 National School Lunch Program $9.17M - 0
84.010 Title I Grants to Local Educational Agencies $6.92M - 0
84.027 Special Education_grants to States $6.76M Yes 0
10.553 School Breakfast Program $2.09M - 0
84.367 Improving Teacher Quality State Grants $992,798 - 0
84.063 Federal Pell Grant Program $933,111 - 0
84.938 Disaster Recovery Assistance for Education $874,685 - 0
84.424 Student Support and Academic Enrichment Program $551,351 - 0
10.558 Child and Adult Care Food Program $444,648 - 0
84.048 Career and Technical Education -- Basic Grants to States $428,693 - 0
84.425 Covid-19 Education Stabilization Fund $254,770 Yes 0
84.173 Special Education_preschool Grants $225,861 Yes 0
10.559 Summer Food Service Program for Children $183,399 - 0
84.002 Adult Education - Basic Grants to States $175,247 - 0
84.365 English Language Acquisition State Grants $166,088 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $150,000 - 0
84.041 Impact Aid $138,029 - 0
84.196 Education for Homeless Children and Youth $131,157 - 0
12.U04 Air Force Junior Reserve Officers Training Corps $110,461 - 0
12.U01 Army Junior Reserve Officers Training Corps $71,003 - 0
12.U02 Marine Corps Junior Reserve Officers Training Corps $69,209 - 0
12.U03 Navy Junior Reserve Officers Training Corps $57,738 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $41,315 - 0
10.582 Fresh Fruit and Vegetable Program $31,164 - 0
93.498 Covid-19 Provider Relief Fund $1,824 - 0

Contacts

Name Title Type
PK2AFBG47QV3 Jim Loyed Auditee
8507674210 Richard McKinney Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The accompanying schedule of expenditures of federal awards (SEFA) includes the federal award activity of the Bay County District School Board 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 financial position, or cash flows of the District.
Title: Noncash Assistance Accounting Policies: Expenditures are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The schedule includes $658,305 of donated food received during the fiscal year under the National School Lunch Program. Donated food is valued at fair value at the time of donation. The District has no other types of federal assistance to be reported that includes, endowments, insurance, noncash assistance, personal protective equipment, other donated property, or free rent.
Title: Disaster Grants Accounting Policies: Expenditures are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The District incurred expenditures for Disaster Grants Public Assistance (Presidentially Declared Disasters) in prior fiscal years.
Title: Loan/Loan Guarantee Outstanding Balances Accounting Policies: Expenditures are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The District did not expend any federal awards in the form of loans or loan guarantees during the fiscal year.

Finding Details

Condition: The District did not have procedures in place to review the reporting required by the grant for accuracy nor for verification of completion of the reporting requirements in a timely manner. Errors were noted in the June 30, 2022 institutional portion report identified as being the final report with all amounts expended at year-end while there was approximately $82,000 remaining to be spent. In addition, it was noted that one of two quarterly reports sampled were uploaded late by three days. Criteria: The U.S. Department of Education requires institutions that received Higher Education Emergency Relief Funds (HEERF) to publicly post certain information accurately on their website related to the student aid and institutional portions of the funds within 10 days of the end of each quarter. 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Effect: By not having a review process in place to verify the reports were accurate and uploaded timely, the reports were not available to the public within the allowed time after quarter-end. Cause: The District had limited employees involved in the disbursement of the HEERF funds resulting in only one person being able to prepare and review the reports. It is unclear why the quarter reviewed was uploaded late. Recommendation: We recommend implementing a process for a secondary review of the reports being prepared as well as a process for verifying reports are uploaded to the website accurately and timely. Views of Responsible Officials and Planned Corrective Action: The District will implement new procedures to verify reports are accurate and uploaded timely in the future.
Condition: The District did not have procedures in place to review the reporting required by the grant for accuracy nor for verification of completion of the reporting requirements in a timely manner. Errors were noted in the June 30, 2022 institutional portion report identified as being the final report with all amounts expended at year-end while there was approximately $82,000 remaining to be spent. In addition, it was noted that one of two quarterly reports sampled were uploaded late by three days. Criteria: The U.S. Department of Education requires institutions that received Higher Education Emergency Relief Funds (HEERF) to publicly post certain information accurately on their website related to the student aid and institutional portions of the funds within 10 days of the end of each quarter. 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Effect: By not having a review process in place to verify the reports were accurate and uploaded timely, the reports were not available to the public within the allowed time after quarter-end. Cause: The District had limited employees involved in the disbursement of the HEERF funds resulting in only one person being able to prepare and review the reports. It is unclear why the quarter reviewed was uploaded late. Recommendation: We recommend implementing a process for a secondary review of the reports being prepared as well as a process for verifying reports are uploaded to the website accurately and timely. Views of Responsible Officials and Planned Corrective Action: The District will implement new procedures to verify reports are accurate and uploaded timely in the future.
Condition: While testing controls, a group of employees were identified that the District missed when completing their triannual procedures related to obtaining time and effort or personnel activity reports from employees paid from grants. Criteria: 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Effect: In this instance, the District performed time and effort and personnel activity reports as a control procedure not specifically required by the grant, due to the type of payroll. This could have been a much more significant issue if it had been associated with certain other grants. Cause: The grant administrator indicated the employees were likely missed due to timing of posting payroll to the project and the reclassification of costs between projects during the year due to changes from the state level associated with accounting for the Education Stabilization Funds. Recommendation: The District should implement and document standardized processes and procedures to identify employees throughout the District who are required to keep time and effort or personnel activity reports during the year. We also recommend general training be completed for all staff regarding this requirement. Views of Responsible Officials and Planned Corrective Action: The District will consider implementation of more standardized requirements associated with time and effort and personnel activity reporting requirements. The District will also consider additional training associated with these requirements for all grant related staff.
Condition: The District did not have procedures in place to review the reporting required by the grant for accuracy nor for verification of completion of the reporting requirements in a timely manner. Errors were noted in the June 30, 2022 institutional portion report identified as being the final report with all amounts expended at year-end while there was approximately $82,000 remaining to be spent. In addition, it was noted that one of two quarterly reports sampled were uploaded late by three days. Criteria: The U.S. Department of Education requires institutions that received Higher Education Emergency Relief Funds (HEERF) to publicly post certain information accurately on their website related to the student aid and institutional portions of the funds within 10 days of the end of each quarter. 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Effect: By not having a review process in place to verify the reports were accurate and uploaded timely, the reports were not available to the public within the allowed time after quarter-end. Cause: The District had limited employees involved in the disbursement of the HEERF funds resulting in only one person being able to prepare and review the reports. It is unclear why the quarter reviewed was uploaded late. Recommendation: We recommend implementing a process for a secondary review of the reports being prepared as well as a process for verifying reports are uploaded to the website accurately and timely. Views of Responsible Officials and Planned Corrective Action: The District will implement new procedures to verify reports are accurate and uploaded timely in the future.
Condition: The District did not have procedures in place to review the reporting required by the grant for accuracy nor for verification of completion of the reporting requirements in a timely manner. Errors were noted in the June 30, 2022 institutional portion report identified as being the final report with all amounts expended at year-end while there was approximately $82,000 remaining to be spent. In addition, it was noted that one of two quarterly reports sampled were uploaded late by three days. Criteria: The U.S. Department of Education requires institutions that received Higher Education Emergency Relief Funds (HEERF) to publicly post certain information accurately on their website related to the student aid and institutional portions of the funds within 10 days of the end of each quarter. 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Effect: By not having a review process in place to verify the reports were accurate and uploaded timely, the reports were not available to the public within the allowed time after quarter-end. Cause: The District had limited employees involved in the disbursement of the HEERF funds resulting in only one person being able to prepare and review the reports. It is unclear why the quarter reviewed was uploaded late. Recommendation: We recommend implementing a process for a secondary review of the reports being prepared as well as a process for verifying reports are uploaded to the website accurately and timely. Views of Responsible Officials and Planned Corrective Action: The District will implement new procedures to verify reports are accurate and uploaded timely in the future.
Condition: While testing controls, a group of employees were identified that the District missed when completing their triannual procedures related to obtaining time and effort or personnel activity reports from employees paid from grants. Criteria: 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Effect: In this instance, the District performed time and effort and personnel activity reports as a control procedure not specifically required by the grant, due to the type of payroll. This could have been a much more significant issue if it had been associated with certain other grants. Cause: The grant administrator indicated the employees were likely missed due to timing of posting payroll to the project and the reclassification of costs between projects during the year due to changes from the state level associated with accounting for the Education Stabilization Funds. Recommendation: The District should implement and document standardized processes and procedures to identify employees throughout the District who are required to keep time and effort or personnel activity reports during the year. We also recommend general training be completed for all staff regarding this requirement. Views of Responsible Officials and Planned Corrective Action: The District will consider implementation of more standardized requirements associated with time and effort and personnel activity reporting requirements. The District will also consider additional training associated with these requirements for all grant related staff.