Instructions: Title III EL YTD Expenditure Report
Consolidated Application data entry instructions for the 2022–23 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, 2022, through June 30, 2023, 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 Contacts
Annie Abreu Park
Staff Services Analyst
Language Policy and Leadership Office
aabreupark@cde.ca.gov
916-319-9620
Geoffrey Ndirangu
Education Programs Consultant
Language Policy and Leadership Office
gndirang@cde.ca.gov
916-323-5831
Displayed Data – Allocation
2022–23 Title III EL student program allocation: Source data from the CDE Title III English Learner and Immigrant Programs web page.
Procedures – Transferred Funds
| Step | Action | Program Instructions |
|---|---|---|
1 |
Enter the Transferred-in Amount. | Required field. The amount transferred-in from Title II, Part A and/or Title IV, Part A to Title III English Learner must be equal to or greater than zero. |
Displayed Data – Total Allocation
2022–23 Total allocation: The sum of the Title III EL student program allocation amount plus the transferred-in amount.
Procedures – Expenditures
| Step | Action | Program Instructions |
|---|---|---|
2 |
Enter the YTD amount spent on 1000–1999 Certificated Personnel Salaries. | Required field. Enter an amount equal to or greater than zero. |
3 |
Enter the YTD amount spent on 2000–2999 Classified Personnel Salaries. | Required field. Enter an amount equal to or greater than zero. |
4 |
Enter the YTD amount spent on 3000–3999 Employee Benefits. | Required field. Enter an amount equal to or greater than zero. |
5 |
Enter the YTD amount spent on 4000–4999 Books and Supplies. | Required field. Enter an amount equal to or greater than zero. |
6 |
Enter the YTD amount spent on 5000–5999 Services and Other Operating Expenditures. | Required field. Enter an amount equal to or greater than zero. |
7 |
Enter the YTD amount spent on Direct Administrative Costs. | Required field. Enter an amount equal to or greater than zero. The direct administrative costs amount cannot exceed 2% of the EL student program allocation amount plus transferred-in amount. |
8 |
Enter the YTD amount spent on Indirect Costs. | Required field. Enter an amount equal to or greater than zero. LEA can apply its restricted indirect cost rate 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 expenditures.
2022–23 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 expenditure amounts are appropriate. |