SACS technical review checks, explained one at a time
The SACS Web System runs about ninety technical review checks on an unaudited actuals or budget submission. Each one has a page here: CDE's wording, what it means in the ledger, the usual causes, and the repair. Paste the id from your TRC screen to jump straight to it.
Ledger checks: answered from the Other Export
SACS Pre-Flight runs these 39 on your .dat before the system does.
- AR-AP-POSITIVEF
- BALANCE-FDxRSF
- CEFB-POSITIVEF
- CEFB=FD-EQUITYF
- CHECKFUNCTIONF
- CHECKFUNDF
- CHECKGOALF
- CHECKOBJECTF
- CHK-FUNCTIONxOBJECTF
- CHK-FUNDxFUNCTION-BF
- CHK-FUNDxOBJECTF
- CHK-GOALxFUNCTION-AF
- CHK-GOALxFUNCTION-BF
- CHK-RES6500XOBJ8091F
- CONTRIB-RESTR-REVF
- CONTRIB-UNREST-REVF
- DUE-FROM=DUE-TOF
- EPA-CONTRIBF
- EXCESS-ASSIGN-REUF
- INTERFD-DIR-COSTF
- INTERFD-IN-OUTF
- INTERFD-INDIRECTF
- INTRAFD-DIR-COSTF
- INTRAFD-INDIRECTF
- LCFF-TRANSFERF
- LOTTERY-CONTRIBF
- SPECIAL-ED-GOALF
- UNASSIGNED-NEGATIVEF
- CHECKRESOURCEW
- CHK-FUNDxFUNCTION-AW
- CHK-FUNDxGOALW
- CHK-FUNDxRESOURCEW
- CHK-RESOURCExOBJECTAW
- EFB-POSITIVEW
- EXP-POSITIVEW
- OBJ-POSITIVEW
- PASS-THRU-REV=EXPW
- REV-POSITIVEW
- CHK-RESOURCExOBJECTBO
Form and system checks: answered inside the SACS Web System
53 checks that need a supplemental form, last year's submission, or the system itself.
- FORM01-PROVIDEFForm 01
Form 01 (Form 01I) has not been opened and saved.
- CS-EXPLANATIONSFForm 01CS (budget and interim)
A criterion or standard flagged in Form 01CS is missing its required explanation.
- CS-PROVIDEFForm 01CS (budget and interim)
The criteria and standards review (Form 01CS) has not been provided.
- CS-YES-NOFForm 01CS (budget and interim)
One or more yes/no questions in Form 01CS have not been answered.
- ADA-PROVIDEFForm A
Average daily attendance data (Form A) have not been provided.
- ASSET-ACCUM-DEPR-NEGFForm ASSET
Concerns Form ASSET: an accumulated depreciation figure that has gone negative, which usually means activity was keyed with the wrong sign o...
- ASSET-IMPORTFForm ASSET
Capital asset amounts were imported or keyed (function 8500, or capital outlay objects 6XXX), so the capital assets supplemental data (Form ...
- ASSET-PY-BALFForm ASSET
Concerns Form ASSET: the prior year ending balances preloaded from last year's submission do not agree with what is shown as this year's beg...
- UNAUDIT-CERT-PROVIDEFForm CA
The unaudited actuals certification (Form CA) has not been provided.
- CASHFLOW-PROVIDEWForm CASH (budget)
The cashflow worksheet (Form CASH) has not been provided. Budget period only.
- BUDGET-CERT-PROVIDEFForm CB (budget)
The budget certification (Form CB) has not been provided. Budget period only.
- CB-BALANCE-ABOVE-MINWForm CB (budget)
Concerns Form CB: the reserve for economic uncertainties must meet the minimum for the district's size. Budget period only.
- CB-BUDGET-CERTIFYFForm CB (budget)
Concerns Form CB: the certification selection (positive, qualified, negative) must be made. Budget period only.
- WK-COMP-CERT-PROVIDEFForm CC (budget)
The workers' compensation certification (Form CC) has not been provided. Budget period only.
- CEA-PROVIDEFForm CEA
Current Expense Formula and Minimum Classroom Compensation data (Form CEA) have not been provided.
- CURRENT-CALC-EXPOForm CEA
The percent of current cost of education spent on classroom compensation (Form CEA, Part III, Line 15) is below the allowable percentage.
- DEBT-ACTIVITYOForm DEBT
Long-term debt exists, but no activity appears to have been entered in Form DEBT for one or more debt types.
- DEBT-IMPORTFForm DEBT
Long-term debt amounts were imported, so the long-term debt supplemental data (Form DEBT) must be provided.
- DEBT-POSITIVEFForm DEBT
Concerns Form DEBT: a long-term liability balance that has gone negative.
- DEBT-PY-BALFForm DEBT
The Schedule of Long-Term Liabilities (Form DEBT) has not been provided, and last year's submission carried long-term liability ending balan...
- ESMOE-ADAFForm ESMOE
Concerns Form ESMOE: the ADA figure the maintenance of effort calculation needs is missing or does not agree with Form A.
- ESMOE-IMPORTFForm ESMOE
The Every Student Succeeds Act Maintenance of Effort form (Form ESMOE) has not been provided, and ESSA amounts were imported.
- GANN-PROVIDEFForm GANN
Appropriations limit calculations (Form GANN), including budget year revenue and ADA, have not been provided.
- IC-ADMIN-NOT-ZEROFForm ICR
No Other General Administration costs are reported in Form ICR, Part III, Line A1.
- IC-ADMIN-PLANT-SVCSWForm ICR
The percentage of plant services costs attributable to general administration is either zero or exceeds 25 percent, which usually points at ...
- IC-BD-SUPT-NOT-ZEROWForm ICR
No Board and Superintendent costs are reported in Form ICR, Part III, Line B7.
- IC-BD-SUPT-VS-ADMINWForm ICR
Concerns Form ICR: board and superintendent costs compared with other general administration costs fall outside the range CDE expects.
- IC-EXCEEDS-LEA-RATEWForm ICR
Concerns Form ICR: indirect costs charged to programs exceed what the district's approved indirect cost rate allows.
- IC-PCTWForm ICR
The straight indirect cost percentage (without the carry-forward adjustment) is below 2 percent or above 9 percent, which CDE treats as unus...
- IC-POSITIVEWForm ICR
Concerns Form ICR: an amount on the worksheet that must be positive is negative.
- ICR-PROVIDEFForm ICR
The Indirect Cost Rate Worksheet (Form ICR) has not been provided.
- LOT-CONTRIB-IMPORT-AFForm L
Concerns Form L: lottery amounts reported on the form must agree with the imported ledger for resource 1100 and 6300 activity; this is one o...
- LOT-CONTRIB-IMPORT-BWForm L
Concerns Form L: the second variant of the comparison between lottery amounts on the form and the imported ledger.
- LOT-IMPORTFForm L
The Lottery Report (Form L) has not been provided, and lottery amounts were imported in resources 1100 and/or 6300.
- MYP-PROVIDEWForm MYP (budget and interim)
The multiyear projection (Form MYP) has not been provided.
- PCR-ALLOC-NO-DIRECTWForm PCR
Concerns Form PCR: a program shows allocated costs but no direct costs.
- PCR-GF-EXPENDITURESFForm PCR
Total costs by program in Form PCR, Column 6, do not agree with total expenditures (objects 1000-7999) in funds 01, 09 and 62.
- PCRAF-UNDISTRIBUTEDFForm PCRAF
Concerns Form PCRAF: allocation factors leave undistributed amounts, so costs remain unassigned to programs.
- INTERFD-INDIRECT-FNFLedger, by function
Transfers of indirect costs between funds (Object 7350) must net to zero across funds by function. SACS Pre-Flight runs the all-funds test (...
- INTRAFD-INDIRECT-FNFLedger, by function
Transfers of indirect costs (Object 7310) must net to zero by fund and by function. SACS Pre-Flight runs the by-fund test (INTRAFD-INDIRECT)...
- CHK-FDXRS7690xOB8590FLedger, pending verification
Concerns resource 7690 (STRS on-behalf pension contributions) recorded with object 8590, by fund. CDE's exact wording appears on the TRC scr...
- CONSOLIDATED-ADM-BALFLedger, pending verification
Concerns the consolidated administrative cost pool for federal programs: its activity and balance must reconcile. CDE's exact wording appear...
- SE-PASS-THRU-REVENUEWLedger, pending verification
Concerns special education pass-through revenue: amounts received on behalf of other agencies in special education resources should equal wh...
- NET-INV-CAP-ASSETSWNet position (funds 61-95)
Concerns net position in proprietary and fiduciary funds: net investment in capital assets must be consistent with the capital asset and rel...
- RS-NET-POSITION-ZEROFNet position (funds 61-95)
Concerns restricted net position by resource in proprietary and fiduciary funds. Not yet verified against a CDE log, so SACS Pre-Flight does...
- UNR-NET-POSITION-NEGFNet position (funds 61-95)
Concerns a negative unrestricted net position in a proprietary or fiduciary fund. Not yet verified against a CDE log, so SACS Pre-Flight doe...
- PY-EFB=CY-BFBFPrior year submission
The prior year ending fund balance, preloaded from last year's unaudited actuals submission, does not equal this year's beginning fund balan...
- PY-EFB=CY-BFB-RESFPrior year submission
The prior year ending balance, preloaded from last year's submission, does not equal this year's beginning balance (Object 9791) by fund and...
- VERSION-CHECKWSACS Web System
The SACS Web System version in use is checked against the current release.
- CHK-DEPENDENCYFSACS Web System forms
A form depends on another form that has not been opened and saved first (for example, Form ICR depends on the fund forms, including funds 09...
- CHK-UNBALANCED-AWSACS Web System forms
A supplemental form contains unbalanced or incomplete data; the form's own internal checks raised exceptions, and this TRC reports them.
- CHK-UNBALANCED-BFSACS Web System forms
The second of the two TRCs that report unbalanced or incomplete data in the supplemental forms.
- CHK-RS-LOCAL-DEFINEDFSACS Web System setup
Locally defined resource codes used in the imported data must be set up in the SACS Web System's locally defined resource list.
See every check on your own file before the system runs them. Drop a SACS Other Export (.dat) into SACS Pre-Flight: findings with line numbers, free, entirely in your browser. The file never leaves your computer.
Run SACS Pre-Flight free