Note to Users of Office for Mac
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.
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: Starting in 2015-2016, the three worksheets have been combined into 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.
2022-2023 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs (3/9/2023)
- Standard format (.xlsx) - LEA selected separately on each worksheet tab (3/9/2023)
- Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually (3/9/2023)
- Previous Month Missed Payments - This file indicates districts who were eligible for payments but had un-submitted reports. These payments will post in February AIDS Register. (2/7/2023)
- November Adjustment raw data file (12/8/2022)
2021-2022 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs (6/2/2022)
- Standard format (.xlsx) - LEA selected separately on each worksheet tab (6/2/2022)
- Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually (6/2/2022)
2020-2021 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs
- Standard format (.xlsx) - LEA selected separately on each worksheet tab
- Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually
2019-2020 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs
- Standard format (.xlsx) - LEA selected separately on each worksheet tab
- Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually
2018-2019 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs
- Standard format (.xlsx) - LEA selected separately on each worksheet tab
- Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually
2017-2018 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs
- Standard format (.xlsx) - LEA selected separately on each worksheet tab
- Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually
2016-2017 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs
- Standard format (.xlsx) - LEA selected separately on each worksheet tab
- Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually
2015-2016 Categorical Aid Computation and Eligibility
- Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs
- Standard format (.xlsx) - LEA selected separately on each worksheet tab