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.

• 2018-2019
• 2017-2018
• 2016-2017
• 2015-2016
• 2014-2015
• 2013-2014
• 2012-2013
• 2011-2012
• 2010-2011
• 2009-2010

2019- 2020 Categorical Aid Computation and Eligibility

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

2018- 2019 Categorical Aid Computation and Eligibility

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

2017- 2018 Categorical Aid Computation and Eligibility

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

2016- 2017 Categorical Aid Computation and Eligibility

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

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

2014-2015

• Categorical Aid Payments
• Aid Computation Worksheets (June 8, 2015)
• Adjustment Worksheets (June 8, 2015)

2013-2014

• Categorical Aid Payments
• Aid Computation Worksheets (June 9, 2014)
• Adjustment Worksheets (June 9, 2014)

2012-2013

• Categorical Aid Payments
• Aid Computation Worksheets (June 10, 2013)
• Adjustment Worksheets (June 10, 2013)

2011-2012

• Categorical Aid Payments
• Aid Computation Worksheets (June 11, 2012)
• Adjustment Worksheets (June 11, 2012)

2010-2011

• Categorical Aid Payments
• Aid Computation Worksheets (June 13, 2011)
• Adjustment Worksheets (June 13, 2011)

2009-2010

• Categorical Aid Payments
• Aid Computation Worksheets (June 14, 2010)
• Adjustment Worksheets (June 14, 2010)