Payment Worksheets

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.

Categorical Aid Computation and Payments by School Year

Click the appropriate link below for more information.

• 2021-2022
• 2020-2021
• 2019-2020
• 2018-2019
• 2017-2018
• 2016-2017
• 2015-2016
• 2014-2015
• 2013-2014
• 2012-2013
• 2011-2012
• 2010-2011

2021-2022 Categorical Aid Computation and Eligibility

• Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs (2/17/2022)
• Standard format (.xlsx) - LEA selected separately on each worksheet tab (2/17/2022)
• Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually (2/17/2022)

2020-2021 Categorical Aid Computation and Eligibility

• Macro-enabled format (.xlsm) - LEAs update together on worksheet tabs (5/7/2021)
• Standard format (.xlsx) - LEA selected separately on each worksheet tab (5/7/2021)
• Raw data (.xlsx) - No Pivot Tables or other advanced functionality--must be filtered manually (5/7/2021)