SACS2012ALL Software Release Letter
July 30, 2012
Dear County and District Chief Business Officials and Charter School Administrators:
2011–12 UNAUDITED ACTUAL FINANCIAL REPORTING SOFTWARE
The software for completing the 2012–13 budgets and interim reports and the 2011–12 unaudited actual financial reports, including both the Standardized Account Code Structure (SACS) financial reporting software and the Charter School Unaudited Actuals Financial Report—Alternative Form (Alternative Form), are now available on our Web page at http://www.cde.ca.gov/fg/sf/fr/.
SACS FINANCIAL REPORTING SOFTWARE—SACS2012ALL
This year our efforts were primarily focused on required changes, with some enhancements. There are also some changes to forms, processes, and technical review checks in the software to ensure that the data the California Department of Education (CDE) collects are accurate. The most notable changes are described below. Please see the "What's New" section of the SACS2012ALL Software User Guide for additional information on the changes made to the software.
New Requirements for Reporting Fund Balance in Governmental Funds
The SACS software contains the remaining revisions needed to incorporate, for estimated and unaudited actuals reporting, the new fund balance classifications required by Governmental Accounting Standards Board Statement 54 (GASB 54). Many forms and processes were impacted, including the fund forms, Form CEFB—Components of Ending Fund Balance, Form 01CS—Criteria and Standards, Form MYP—Multiyear Projections, Form JUV—Juvenile Court and County Community Schools Account, and numerous technical review checks. For a detailed description of the changes, please see the “What’s New” section of the SACS2012ALL Software User Guide.
For information on GASB 54, please see our January 7, 2011 letter, available at http://www.cde.ca.gov/fg/ac/co/.
Fund 09—Charter Schools Special Revenue Fund
Effective fiscal year 2012–13, Fund 09 will be invalid for separately reporting charter schools. A separately reporting charter school should report a general fund and not a special revenue fund. This change does not apply to county offices of education or districts that use Fund 09 to report their charter schools within their own financial statements.
Revised Form CASH
Form CASH—Cashflow Worksheet was expanded in response to user requests to allow for more detailed reporting consistent with industry best practices. Section D, Prior Year Transactions, was restructured and renamed Balance Sheet Transactions. New columns were added to allow comparisons to amounts budgeted. An optional second worksheet was added to allow local educational agencies (LEAs) to continue cashflow projections into the subsequent fiscal year.
Discontinued Supplemental Forms 51A, and 53A, and DAY
Effective fiscal year 2011–12, Form 51A—Analysis of Bonded Indebtedness, Form 53A—Analysis of Restricted Levies, and Form DAY—Community Day Schools are discontinued.
California School Accounting Manual (CSAM)
To assist you in using new SACS account codes added since the 2011 edition of the CSAM was released, any new codes added this year have been included in the SACS Software User Guide “What’s New” section, under “Revised Fund Forms.” Descriptions and other relevant information on new resource codes can be obtained from our SACS Query Web page at http://www.cde.ca.gov/fg/ac/ac/.
Prior year ending balances from 2010–11 unaudited actual data (including funds, assets, debt, juvenile court and county community schools designated for economic uncertainties and capital outlay reserves, and lottery), Gann Limit, No Child Left Behind Maintenance of Effort, and first and second prior year indirect cost rate information have been preloaded into the software.
In addition, to the extent possible, general ledger Fund01 and Fund 17, attendance, and revenue limit from 2009–10 and 2010–11 unaudited actuals, as well as the California Basic Educational Data Systems (CBEDS) data, have been preloaded in the software for use in the Criteria and Standards Review form.
Charter School Beginning Balances
As in last year's software, the prior year ending fund balances from the Charter School Alternative Form have been crosswalked to the equivalent SACS fund and object codes and included with the prior year ending fund balances from the SACS submissions, to ensure consistency of the data by ascertaining that current year beginning balances match prior year ending balances. This only affects charter schools that reported 2010–11 unaudited actuals in the Charter School Alternative Form and that are preparing a 2012–13 budget or 2011–12 unaudited actuals report using the SACS software.
Extracting Budget Period Data for Interim Criteria and Standards Review
The interim period Criteria and Standards Review form will extract applicable budget period data (July 1 single or September 8 dual adoption), if such data are available; otherwise, it will require manual input. To enable extraction of budget period data, the officially exported budget file from the SACS2012 software must be imported (official import is recommended) into the SACS2012ALL software. Be sure to save an electronic copy of your officially exported budget data file for import into the SACS2012ALL software (the software official export default directory is C:\SACS2012\Official). Once the budget data have been imported into the SACS2012ALL software, the SACS2012 software is no longer necessary and can be uninstalled.
Software User Guide and Reporting Calendars
Installing the software with the default settings will automatically copy the SACS2012ALL Software User Guide and financial reporting calendars to your C:\SACS2012ALL\Calendars and Manuals subdirectory. The user guide is accessible from the software Help menu and also by pressing F1 from within most of the forms and processes in the software.
Recommended Installation Environment for SACS Software
It is recommended to download and install the software onto a Windows XP machine. Some users have reported problems running the SACS software on a Windows 7 machine. There is a workaround available on the SACS Software Known Problems/Fixes Web page at http://www.cde.ca.gov/fg/sf/fr/sacs2012allprobfix.asp.
Software Bugs and Fixes
As in the past, we will communicate any detected software bugs and their fixes or workarounds to the county office SACS software contacts via e‑mail, and we will also post them to the CDE Internet. We are very interested in hearing from all LEAs regarding the overall software, forms, and instructions. Comments from charter schools regarding using SACS and/or the Charter School Alternative Form would also be helpful. Send your comments and suggestions using the Change Order form (CHG) included in the SACS software or by e-mail to email@example.com. The completed CHG form may either be faxed to 916-324-7141 or mailed to us at the address shown at the top of the form.
Please be sure to let the appropriate people within your agency know where they can access the software on our Web page. For assistance with the SACS software, districts should contact their county office of education, and charter schools should contact their authorizing agency. County offices may contact us by phone at 916-322-1770 or by e-mail at firstname.lastname@example.org.
CHARTER SCHOOL REPORTING
Pursuant to Education Code Section 42100, each charter school must prepare an annual statement of all receipts and expenditures for the preceding fiscal year. For those charter schools not using SACS, a Microsoft Excel file containing the 2011–12 Charter School Unaudited Actuals Financial Report—Alternative Form and the related Charter School Alternative Form User Guide are available on our Web page at http://www.cde.ca.gov/fg/sf/fr/. For information about using the Alternative Form, please refer to the user guide.
Charter School Financial Reporting Status Form
Each county office of education (COE) should complete the "Charter School Financial Reporting Status" form and return the form to the CDE by September 17, 2012. This form (attached for COEs only) lists all of the authorized charter schools within each county. The form is used to identify whether the charter school 2011–12 unaudited actual financial information is being reported: 1) within the authorizing agency's unaudited actual SACS submission; 2) as a separate SACS submission; or 3) in the Charter School Alternative Form. Please be sure that the reporting status form addresses the status of each charter school's 2011–12 unaudited actual data, not 2011–12 budget data. COEs may fax these completed forms to us at 916-324-7141.
SUBMISSION OF FINANCIAL DATA TO THE CDE
Pursuant to Education Code sections 1628 and 42100, unaudited actual data for COEs, school districts, joint powers agencies (JPAs), and charter schools are due to the CDE by October15, 2012. School district and JPA data must be submitted via the COE; charter school data must be submitted via the charter authorizing agency and the COE. The financial data is due to COEs and authorizing agencies (for charter schools) by September 17, 2012.
Electronic Transfer (eTransfer)
COEs must electronically certify and transfer their county's unaudited actual SACS submissions and Charter School Alternative Forms to our office via the Internet using electronic transfer (eTransfer). COEs should complete the "Request for SACS2012 eTransfer Access" form and mail it to the School Fiscal Services Division (with original signatures) by September 17, 2012, at the address on the form. To comply with statute regarding certification of the data, we need original signatures on the form each year. (This form is attached for COEs only.)
Official Unaudited Actual Data Submissions
Only "Official" unaudited actual SACS submissions are accepted by the CDE unless prior approval from our office is granted. If prior approval is granted, please send an e‑mail explaining all fatal exceptions, the reason for not using the "Official" export, and the name of the CDE person who granted the exception, to email@example.com immediately after the unaudited actual submission (created with the "Other" export option) is eTransferred to the CDE.
Please distribute this information to the appropriate staff within your agency. If you have questions, or if we can be of further assistance, please contact us by phone at 916-322-1770 or by e-mail at firstname.lastname@example.org.
Peggy O’Guin, Administrator
Office of Financial Accountability and Information Services