Skip to main content
California Department of Education Logo

Spreadsheets of Valid Combinations

These are downloadable spreadsheet files containing the active Standardized Account Code Structure (SACS) valid combinations for use in the SACS financial reporting software.

The spreadsheets of allowable combinations are provided in two formats: Microsoft Excel and Adobe portable document format. The Adobe format, which requires a free "reader" program, will give the best reproduction of page formatting. Please follow the link, "Download Free Readers" at the bottom right corner of this page to download the reader.

The spreadsheets may be used to check the valid SACS combinations as follows:

Valid Account Code Combinations

 

Spreadsheet

Code Combinations Checked

Fund X Resource

All funds and all resources

Fund X Goal

All funds and all goals

Fund X Function

All funds and all functions

Fund X Object

All funds and objects

Function X Object

All functions with expenditure objects 1000–7999

Resource X Object

All resources with revenue and balance sheet account objects 8000–9999

Goal X Function

All goals with expenditure objects 1000–7999 in functions 1000s, 4000s, 5000s, and 7200–7700, except 7210

Each cell in the spreadsheets indicates for which of the three types of local educational agency (LEA) that combination is allowable:

D - allowable for districts

C - allowable for county offices

J - allowable for joint powers agreements/agencies (JPAs)

(blank) - not allowable for any LEA type

The names of the spreadsheets follow this convention:

YYYY Contents of Columns X Contents of Rows

For example, 2014 Fund X Object is the spreadsheet that describes the allowable combinations of fund and object for 2014–15.

Spreadsheet of Valid Combinations Executable (EXE; Revised 21-Dec-2015)
Portable Document Format of Valid Combinations Executable (EXE; Revised 21-Dec-2015)

Questions:   Financial Accountability & Information Services | sacsinfo@cde.ca.gov | 916-322-1770
Last Reviewed: Monday, December 21, 2015

Share this Page

Recently Posted in Accounting

  • Interest Earned on Federal Funds Ltr (01-Feb-2016) (added 01-Feb-2016)
    The California Department of Education (CDE) letter dated February 1, 2016 reminding local educational agency (LEA) fiscal officials of the federal administrative requirements for remitting interest earned on advances of federal program funds.
  • District-Funded Students in COE Programs (added 29-Dec-2015)
    The following is guidance regarding accounting for district payments to county offices of education (COEs) for district-funded students in county-operated programs.
  • Annual Adjustment to Bid Threshold for Contracts (added 23-Dec-2015)
    Letter dated December 18, 2015, detailing the 2016 annual adjustment to bid threshold for contracts awarded by school districts.
  • Liability Limit for Willful Pupil Misconduct (added 23-Dec-2015)
    Letter dated December 18, 2015, to County and District Superintendents, Chief Business Officials, and Charter School Administrators with the Willful Pupil Misconduct Liability Limits.
  • Master List of SACS Resource Codes (PDF) (added 21-Dec-2015)
    Downloadable spreadsheet containing the history of all resource codes.