Audit 22471

Title: RECONCILIATION OF FEDERAL AWARDS TO EXPENDITURE OF FEDERAL AWARDS Accounting Policies: All federal grant operations of Rio Rancho Public School District No. 94 (the District) are included in the scope of the Office ofManagement and Budget (OMB) Uniform Grant Guidance audit (the Single Audit). The Single Audit was performed in accordancewith the provisions of the OMB Circular Compliance Supplement (Revised April 2022 the Compliance Supplement). Compliance testingof all requirements are described in the Compliance Supplement, was performed for the grant programs noted below. These programsrepresent all federal award programs and other grants with fiscal year 2022 cash and non-cash expenditures to ensure coverage of at least40% (HIGH risk auditee) of federally granted funds. Actual coverage is approximately 48% of total cash and non-cash federal awardprogram expenditures. Total cash expenditures were in the amount of $18,934,437 and all non-cash expenditures amounted to $498,673. MAJOR FEDERAL ASSISTANCE LISTING TITLE ASSISTANCE NO. EXPENDITURECOVID-19: CARES Act, CRRSA, & ARP 84.425 D, U, & W $ 5 ,568,681Special Education (IDEA) Cluster 84.027 & 84.173 3 ,331,813Improving Teacher Quality State Grants 84.367 5 1 3 , 7 1 5Total $ 9,414,209 The District had two federal programs considered to be High-Risk Type A programs for the year ended June 30, 2022.The U.S. Department of Education is the Districts oversight agency for single audit.Basis of presentationThe accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal grant activity of the District underprograms of the federal government for the year ended June 30, 2022. The information in this schedule is presented in accordance with therequirements of the Office of Management and Budget (OMB) Uniform Grant Guidance. Because the Schedule presents only a selectedportion of the operations of the District, it is not intended to and does not present the financial position and changes in net position of theDistrict. All federal programs considered active during the year ended June 30, 2022, are reflected on the Schedule. An active federal programis defined as a federal program for which there were receipts or disbursements of funds or accrued (deferred) grant revenue adjustmentsduring the fiscal year or a federal program considered as not completed or closed out at the beginning of the fiscal year. The Schedule isprepared using the accrual basis of accounting. Grant revenues are recorded for financial reporting purposes when the District has met thequalifications for the respective grant. Grant revenues for the Food Donation Program are based upon commodities received, at amountsper standard price listing, published quarterly by the United States Department of Agriculture (the USDA). In addition, there is no federalinsurance in effect during the year and loan or loan guarantee outstanding at year end.Accrued and deferred reimbursementsVarious reimbursement procedures are used for Federal awards received by the District. Consequently, timing differences betweenexpenditures and program reimbursements can exist at the beginning and end of the year. Accrued balances at year end represent an excessof reimbursable expenditures over receipts to date. Deferred balance at year-end represent an excess of cash receipts over reimbursableexpenditure to date. Generally, accrued or deferred balances covered by differences in the timing of cash receipts and expenditures will bereversed in the remaining grant period. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The Districts indirect cost rate allowed by New Mexico PublicEducation Department during the year ended June 30, 2022 was 5.71% The differences between the federal awards received (Intergovernmental sources federal) during the year ended June 30, 2022 and thefederal awards expended during the year are as follows: BALANCEFederal Sources $ 26,312,422Indirect costs from federal programs (840,903)Unexpended federal sources from current year ( 2,728,091)Unavailable sources 9 10,676Revenues received as vendor (4,220,994)Total Expenditures of Federal Awards $ 19,433,110