Audit 53564

FY End
2022-06-30
Total Expended
$6.70M
Findings
0
Programs
15
Organization: Alpena Public Schools (MI)
Year: 2022 Accepted: 2022-10-30

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
84.010 Title I Grants to Local Educational Agencies $794,692 Yes 0
10.553 School Breakfast Program $518,447 - 0
84.425 Education Stabilization Fund $458,586 Yes 0
84.048 Career and Technical Education -- Basic Grants to States $188,465 - 0
84.367 Improving Teacher Quality State Grants $138,296 - 0
21.019 Coronavirus Relief Fund $44,196 - 0
10.555 National School Lunch Program $26,591 - 0
10.582 Fresh Fruit and Vegetable Program $18,468 - 0
93.778 Medical Assistance Program $15,798 - 0
81.041 State Energy Program $15,000 - 0
84.196 Education for Homeless Children and Youth $6,402 - 0
84.424 Student Support and Academic Enrichment Program $5,841 - 0
10.559 Summer Food Service Program for Children $4,092 - 0
10.649 Pandemic Ebt Administrative Costs $3,063 - 0
84.358 Rural Education $112 - 0

Contacts

Name Title Type
Q435QVKS6VS3 Mary Lyon Auditee
9893585009 Chelsea McConnell Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principals contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available.Cash received is recorded on the cash basis; expenditures are recorded on the modified accrual basis of accounting. Revenues are recognized when the qualifying expenditures have been incurred and all grant requirements have been met.The Alpena Public Schools has formatted the Schedule to conform to the recommendations of the Michigan Department of Education. The Schedule has been arranged to provide information on both actual cash received and the revenue recognized. Accordingly, the effects of accruals of accounts receivable, unearned revenue and accounts payable items at both the beginning and end of the fiscal year have been reported. 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 (the Schedule) includes the federal award activity of the Alpena Public Schools 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 Principals, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Alpena Public Schools it is not intended to and does not present the financial position, changes in net assets, or cash flows of the Alpena Public Schools.
Title: Adjustments and Transfers Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principals contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available.Cash received is recorded on the cash basis; expenditures are recorded on the modified accrual basis of accounting. Revenues are recognized when the qualifying expenditures have been incurred and all grant requirements have been met.The Alpena Public Schools has formatted the Schedule to conform to the recommendations of the Michigan Department of Education. The Schedule has been arranged to provide information on both actual cash received and the revenue recognized. Accordingly, the effects of accruals of accounts receivable, unearned revenue and accounts payable items at both the beginning and end of the fiscal year have been reported. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Adjustments and transfers were made to recognize the result of questionable costs that were discovered upon an MDE audit. The amount of $112 was credited back to the Title V grant fund from fiscal year 2020.
Title: Relationship to Governmental Fund Financial Statements Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principals contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available.Cash received is recorded on the cash basis; expenditures are recorded on the modified accrual basis of accounting. Revenues are recognized when the qualifying expenditures have been incurred and all grant requirements have been met.The Alpena Public Schools has formatted the Schedule to conform to the recommendations of the Michigan Department of Education. The Schedule has been arranged to provide information on both actual cash received and the revenue recognized. Accordingly, the effects of accruals of accounts receivable, unearned revenue and accounts payable items at both the beginning and end of the fiscal year have been reported. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Revenues from federal sources are reported in the School District's financial statements as follows:FederalRevenuesGeneral Fund $4,253,378 Special Revenue Fund:Food Service Fund 2,448,727 Total federal revenues per financial statements $6,702,105 Federal grant returned to Michigan Department of EducationTitle V 112 Rounding 2 Total expenditures per the Schedule of Expenditures ofFederal Awards (SEFA) $6,702,219
Title: Michigan Department of Education Disclosures Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principals contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available.Cash received is recorded on the cash basis; expenditures are recorded on the modified accrual basis of accounting. Revenues are recognized when the qualifying expenditures have been incurred and all grant requirements have been met.The Alpena Public Schools has formatted the Schedule to conform to the recommendations of the Michigan Department of Education. The Schedule has been arranged to provide information on both actual cash received and the revenue recognized. Accordingly, the effects of accruals of accounts receivable, unearned revenue and accounts payable items at both the beginning and end of the fiscal year have been reported. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Management has utilized the Michigan Department of Educations NexSys Grant Auditor Report in preparing the schedule of expenditures of federal awards.The amounts reported on the recipient entitlement balance report agree with the schedule of expenditures of federal awards for U.S.D.A. donated food commodities.Expenditures include spoilage or pilferage.
Title: Reconciliation to Michigan Department of Educations NexSys Grant Section A Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principals contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available.Cash received is recorded on the cash basis; expenditures are recorded on the modified accrual basis of accounting. Revenues are recognized when the qualifying expenditures have been incurred and all grant requirements have been met.The Alpena Public Schools has formatted the Schedule to conform to the recommendations of the Michigan Department of Education. The Schedule has been arranged to provide information on both actual cash received and the revenue recognized. Accordingly, the effects of accruals of accounts receivable, unearned revenue and accounts payable items at both the beginning and end of the fiscal year have been reported. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The following shows a reconciliation of current year receipts per the schedule of expenditures of federal awards to current payments per Michigan Department of Education NexSys Grant Auditor Report:School Districts total current payments perMichigan Department of EducationGrant Auditor Report - (GAR) NexSys $5,925,118 Add items not on Nexsys report:Non-cash assistance USDA Commodities 108,008 Medicaid outreach 15,798 Total current year receipts (cash basis) per the Schedule of Expenditures of Federal Awards (SEFA) $6,048,924