Tuesday, February 23, 2016

Annual Financial Data - Financial (CA Dept of Education)

Annual Financial Data - Financial (CA Dept of Education):

Annual Financial Data

Unaudited year-end data in downloadable, self-extracting files (i.e., SACS, J-200).

 Each year, California's kindergarten through grade twelve (K–12) school districts, county offices of education, charter schools, and joint powers agencies, all commonly known as local educational agencies (LEAs), submit annual financial reports to the California Department of Education (CDE). The Financial Accountability and Information Services (FAIS) Office, within the CDE, is responsible for annually collecting, reviewing, and preparing these financial data for dissemination.

The prior year's data are usually available around March of each year. Please be sure to read the readme.txt and/or documentation.doc files associated with the file type and year you are downloading. They contain detailed information about that year's data. Due to the size of the files, these data sets are processed using the Microsoft Access database application.
If you would like to be notified when these data sets are available for a future year, please send a blank message to join-school-district-financial-data@mlist.cde.ca.gov to subscribe to our mailing list.
Also, selected information from these data sets is available at the Ed-Data Web site External link opens in new window or tab..

LEA Revenue and Expenditure Report SACS Data

In 1997–98, some LEAs began reporting their financial data in the new standardized account code structure (SACS) format using CDE's SACS Financial Reporting Software. Each year, more LEAs converted their financial systems to report in SACS. In order to have consistent statewide data during the transition, the CDE converted the SACS data back to a J-200/400/600 (J-200) equivalent format to produce a statewide set of data. In 2003–04, for the first time all LEAs reported in SACS. For comparison purposes, the CDE converted the 2003–04 statewide data to J-200 and posted both sets of data. However, beginning with 2004–05, only the SACS format is available.
SACS Unaudited Actual Data Sets
The following database(s) contains data for county offices of education, school districts, joint powers agencies, and those charter schools that filed year-end unaudited actual (UA) data in the SACS format.

Charter School Alternative Form Data

Beginning with fiscal year 2003–04, charter school financial reporting was required by Education Code sections 1628 External link opens in new window or tab. and42100 External link opens in new window or tab. (as amended by Assembly Bill 1994, Chapter 1058, Statutes of 2002). The following data sets contain data for the charter schools that used the Charter School Alternative Form. The data sets also include information indicating how the remaining charter schools reported their year-end unaudited actual financial data.
Charter School Alternative Form Unaudited Actual Data Sets
2014–15 Charter School Alternative Form Unaudited Actual Data (EXE: 1MB)
For fiscal year 2014–15, out of an anticipated 1,189 charter school unaudited actual reports, 1,175 reports were received. This data set contains data for the 481 charter schools that used the Charter School Alternative Form.
2013–14 Charter School Alternative Form Unaudited Actual Data (EXE: 1MB)
For fiscal year 2013–14, out of an anticipated 1,133 charter school unaudited actual reports, 1,125 reports were received. This data set contains data for the 452 charter schools that used the Charter School Alternative Form.
2012–13 Charter School Alternative Form Unaudited Actual Data (EXE)
For fiscal year 2012–13, out of an anticipated 1,096 charter school unaudited actual reports, 1,070 reports were received. This data set contains data for the 431 charter schools that used the Charter School Alternative Form.
2011–12 Charter School Alternative Form Unaudited Actual Data (EXE)
For fiscal year 2011–12, out of an anticipated 1,001 charter school unaudited actual reports, 991 reports were received. This data set contains data for the 392 charter schools that used the Charter School Alternative Form.
2010–11 Charter School Alternative Form Unaudited Actual Data (EXE)
Note: This database was re-released May 4, 2012 to reflect a minor update to the Charters table.
For fiscal year 2010–11, out of an anticipated 914 charter school unaudited actual reports, 909 reports were received. This data set contains data for the 346 charter schools that used the Charter School Alternative Form.
2009–10 Charter School Alternative Form Unaudited Actual Data (EXE)
For fiscal year 2009–10, out of an anticipated 829 charter school unaudited actual reports, 814 reports were received. This data set contains data for the 318 charter schools that used the Charter School Alternative Form.
2008–09 Charter School Alternative Form Unaudited Actual Data (EXE) 
For fiscal year 2008–09, out of an anticipated 770 charter school unaudited actual reports, 743 reports were received. This data set contains data for the 290 charter schools that used the Charter School Alternative Form.
2007–08 Charter School Alternative Form Unaudited Actual Data (EXE) 
For fiscal year 2007–08, out of an anticipated 738 charter school unaudited actual reports, 688 reports were received. This data set contains data for the 258 charter schools that used the Charter School Alternative Form.
2006–07 Charter School Alternative Form Unaudited Actual Data (EXE) 
For fiscal year 2006–07, out of an anticipated 630 charter school unaudited actual reports, 617 reports were received. This data set contains data for the 232 charter schools that used the Charter School Alternative Form.
2005–06 Charter School Alternative Form Unaudited Actual Data (EXE)
For fiscal year 2005–06, out of an anticipated 598 charter school unaudited actual reports, 569 reports were received. This data set contains data for the 213 charter schools that used the Charter School Alternative Form.

2004–05 Charter School Alternative Form Unaudited Actual Data
 (EXE)
For fiscal year 2004–05, out of an anticipated 591 charter school unaudited actual reports, 509 reports were received. This data set contains data for the 164 charter schools that used the Charter School Alternative Form.
2003–04 Charter School Alternative Form Unaudited Actual Data (MDB; 2MB) 
For fiscal year 2003–04, a total of 447 charter schools reported unaudited actual financial data. This data set contains data for the 148 charter schools that used the Charter School Alternative Form.

LEA Revenue and Expenditure Report J-200 Data

Until fiscal year 2003–04, the J-200 Unaudited Actual Financial Reports were used by some LEAs to report their balance sheet accounts, revenues by sources, and expenditures by types. Gradually, more and more LEAs reported using SACS. In 2003–04, all LEAs reported in SACS for the first time. For fiscal year 2003–04, the CDE converted the SACS data into the old J-200 format for comparison purposes. However, beginning with fiscal year 2004–05 data, only the SACS format is available. The SACS data are no longer converted to the J-200 format as included in the following data sets.
J-200 Unaudited Actual Data Sets

Program Cost Accounting Report (J-380) Data

Beginning with fiscal year 2003–04 data, the Annual Program Cost Data Report (J-380) is no longer collected as a separate report. Please refer to the SACS unaudited actual data sets above for files that include program cost data in the SACS format.
Prior to fiscal year 2003–04, as included in the following data sets, the J-380/580/780 (J-380) Annual Program Cost Data Reports were used by LEAs to report their unaudited actual expenditure information by program. As conversion to SACS progressed, fewer and fewer LEAs submitted J-380 data.
Program Cost Report Data Sets
Questions:   Financial Accountability & Information Services | sacsinfo@cde.ca.gov | 916-322-1770