You are here

Payment Worksheets

Historical Data for Special Education Aid through FY2024

Aid Payment Worksheets for School Districts, CESAs, CCDEBs and Independent Charter Schools

To view information for a specific Local Education Agency (LEA), select it from the pulldown list on a worksheet page.

Note: Data is available in a single Excel workbook file. It can be downloaded in one of two versions: a macro-enabled (.xlsm) file that updates the other worksheets when a specific LEA is selected on one and a standard (.xlsx) file where each worksheet must be updated individually. If your IT system will not permit download of macro-enabled files, use the standard file.

Categorical Aid Computation and Payments by School Year

Click the appropriate link below for more information.

2023-2024 Categorical Aid Computation and Eligibility

  • Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs   "Elig. This Pmt." is the total annual aid eligibility based on the proration rate used for this payment. This amount in the November through March payments will be slightly lower than the June payment, which will use the full and final proration rate. Any other differences are the result of audit changes and adjustments.(updated 2/7/2024)
  • Standard format (.xlsx) - LEA selected separately on each worksheet tab (updated 2/7/2024)
  • Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually (updated 2/7/2024)

2022-2023 Categorical Aid Computation and Eligibility

  • FY23 Summary Of SPED-SAP Payments (6/12/2023)
  • Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs (6/12/2023)  "Elig. This Pmt." is the total annual aid eligibility based on the proration rate used for this payment. This amount in the November through March payments will be slightly lower than the June payment, which will use the full and final proration rate. Any other differences are the result of audit changes and adjustments.
  • Standard format (.xlsx) - LEA selected separately on each worksheet tab (6/12/2023)
  • Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually (6/12/2023)

2021-2022 Categorical Aid Computation and Eligibility

2020-2021 Categorical Aid Computation and Eligibility

2019-2020 Categorical Aid Computation and Eligibility

2018-2019 Categorical Aid Computation and Eligibility

2017-2018 Categorical Aid Computation and Eligibility

2016-2017 Categorical Aid Computation and Eligibility

2015-2016 Categorical Aid Computation and Eligibility

There are numerous compatibility problems with Excel 2011/2016 for Mac reading certain types of data executable files created with Windows versions of Excel. Until an alternative workbook format can be developed, we will provide raw data files for Mac users to access their aid computation information.