IDEA Expenditure Master Spreadsheet
The Fresno County SELPA maintains an expenditure master spreadsheet organized by SACS Resource, and by each Member School District. The spreadsheet contains the following:
- Member LEA Name
- Funding allocation amount
- Expenditure amount for each of the seven reports
- Total of all expenditure reports
- Balance of allocation less expenditure reports
- Cash disbursements transferred to LEA
Example:
| Member | Allocation | Exp Rpt 1 | Exp Rpt 2 | Exp Rpt 3 | Total | Balance | Transfer 1 |
|---|---|---|---|---|---|---|---|
| ABC District | $150,000 | $70,000 | $20,000 | $40,000 | $130,000 | $20,000 | $70,000 |
| XYZ District | $45,000 | $15,000 | $18,000 | $12,000 | $45,000 | $0 | $15,000 |
In this example, ABC has received a cash disbursement of $70,000 to date. This is the reimbursement of Expenditure Report #1. The LEA has not yet received a cash disbursement for Expenditure Reports #2 and #3.
Please note that the Fresno County SELPA will apply any expenditure claim amounts to any prior year carryover balances. The amounts will be deducted from the current year claim, and added to the prior year claim.
