Instructions: Title III EL YTD Expenditure Report
Consolidated Application data entry instructions for the 2021–22 Title III English Learner (EL) Year-to-Date (YTD) Expenditure Report, 12 Months data collection form.Data Collection Purpose
The local educational agency (LEA) must report year-to-date (YTD) expenditures for the period of July 1, 2021, through June 30, 2022, from the Title III English Learner (EL) Student Program Subgrant allocation.
Program Information
Expenditures by the LEA may include direct administrative and indirect costs, and any repayment of funds. An LEA may use no more than 2 percent of EL student subgrant for direct administrative (Title III, Section 3115[b]). LEA can also apply its approved indirect rate to the portion of the subgrant that is not reserved for direct administrative costs. A list of approved indirect cost rates (ICR) are available on the California Department of Education (CDE) Indirect Cost Rates web page.
According to
the California School Accounting Manual, “Legal obligations are commitments made by an LEA to purchase goods or services immediately or in a future period.” To determine whether a financial commitment should be reported as an expenditure, please refer to 34 Code of Federal Regulations (34 CFR), Part 76, Section 707 on the Electronic Code of Federal Regulations 
web page.
Use the Elementary and Secondary Education Act sections 3115(c) and (d) as a guide to determine authorized expenditures.
CDE Program Staff Contact
Geoffrey Ndirangu
Education Programs Consultant
Language Policy and Leadership Office
gndirang@cde.ca.gov
916-323-5831
Displayed Data – Allocation and Transfers
2021–22 Title III EL student program allocation: Source data from the CDE Title III English Learner and Immigrant Programs web page.
Transferred-in amount: Data displays as reported in the same fiscal year Federal Transferability data collection form.
2021–22 Total allocation: The student program allocation amount plus the transferred-in amount.
Procedures
| Step | Action | Program Instructions |
|---|---|---|
1 |
Enter the YTD amount spent on Certificated Personnel Salaries. | Required field. Enter an amount equal to or greater than zero. |
2 |
Enter the YTD amount spent on Classified Personnel Salaries. | Required field. Enter an amount equal to or greater than zero. |
3 |
Enter the YTD amount spent on Employee Benefits. | Required field. Enter an amount equal to or greater than zero. |
4 |
Enter the YTD amount spent on Books and Supplies. | Required field. Enter an amount equal to or greater than zero. |
5 |
Enter the YTD amount spent on Services and Other Operating Expenditures. | Required field. Enter an amount equal to or greater than zero. |
6 |
Enter the YTD amount spent on Direct Administrative Costs. | Required field. Enter an amount equal to or greater than zero. The amount entered cannot exceed 2 percent of the student program allocation amount plus transferred-in amount. |
7 |
Enter the YTD amount spent on Indirect Costs. | Required field. Enter an amount equal to or greater than zero. LEA can apply its restricted ICR to the portion of subgrant that is not reserved for direct administrative costs. |
Displayed Data – Total Expenditures and Unspent Funds
Total year-to-date expenditures: The sum of all expenditure amounts.
2021–22 Unspent funds: The total allocation amount minus the sum of all expenditure amounts.
Error Messages
| Field Name | Error Message | Resolution |
|---|---|---|
| Employee Benefits Amount | The sum of certificated and classified personnel salaries is equal to zero, employee benefits cannot be greater than zero. | If the sum of certificated and classified personnel salaries expenditure amounts is zero, then ensure that employee benefits expenditure amount is also zero. |
| Direct Administrative Costs Amount | The direct administrative costs amount cannot exceed 2% of the English learner student program allocation amount plus transferred-in amount. | Ensure that the direct administrative costs amount is appropriate. |
| Total Year-to-Date Expenditure Amount | The year-to-date expenditure total cannot be greater than the student program allocation plus transferred-in amount. | Ensure the sum of all expenditures is not greater than the student program allocation plus transferred-in amount. |
| Total Year-to-Date Expenditure Amount | The year-to-date expenditure total should be greater than zero. | Warning only. Ensure that the total expended amount is greater than zero, if appropriate. |