Skip to content

INTERIM DATA PROCESSING

  • Prior Period Data—Prior period data will automatically populate into relevant forms where necessary. An applicable submission must already exist in the SACS Web System for the appropriate Reporting Period or Fiscal year. Certain unaudited actual period data (e.g., data from forms ICR and ESMOE) will populate into interim period forms. There is no additional action required by the user. If an appropriate submission is not available in the SACS Web System, then the user may hand-enter the data.

  • Supplemental Forms—Complete, save, and print supplemental forms AI and CASH (if using the SACS format for cashflow analysis).

  • Import/User Data Input—Import general ledger Original Budget, Board Approved Operating Budget, Actuals to Date, and Projected Year Totals data, as applicable, from the LEA accounting system. Manually input, using the User Data Input/Review screen, any general ledger data that is not maintained in the LEA accounting system.

  • TRC Import and TRC General Ledger—Run the TRC Import and TRC General Ledger modules for each of the four types of interim data, to validate SACS codes and combinations of codes on the imported/input general ledger data and to check interfund, intrafund, and various other balances. Fatal exceptions must be corrected; warning exceptions must be corrected or, if the data is correct, must be explained; informational exceptions should be corrected or, if the data is correct, an explanation is optional but encouraged.

  • General Ledger Data Corrections—Make general ledger data corrections, as necessary, in the LEA accounting system, then reimport the applicable fund(s).

EXCEPTION: Imported Projected Year Totals (PYT) data may be modified or deleted, or new PYT data may be added, in the User Data Input/Review screen. No other types of imported data can be added, modified, or deleted.

Re-run TRC-Import and TRC-General Ledger to verify changes. See the Importing Data section for details about automatic recalculations done after the import, reimport, and user data input processes.

  • Components of Ending Fund Balance/Net Position—Within the Components of Ending Fund Balance/Net Position screen, enter or revise applicable components of ending fund balance/net position, by resource. Re-run TRC-Import and TRC-General Ledger to verify changes. See the Importing Data section for details about automatic recalculations done after the import, reimport, and user data input processes.

  • Fund Forms—When the general ledger data is finalized (including the components of ending fund balance/net position), open, review, save, and print the applicable fund forms. Save Form 01I so applicable data will extract appropriately into the Multiyear Projections (Form MYPI) and Criteria and Standards Review (Form 01CSI) forms.

  • Forms ICR and ESMOE, if applicable.

  • Multiyear Projections—Complete, save, and print Form MYPI if using the SACS form for multiyear projections. Form 01I and Form AI must be completed and saved first. Also, complete and save Form MYPIO, if using the SACS MYP format, for each fund other than the general fund with a projected negative ending fund balance.

  • Criteria and Standards Review—Complete, save, and print the Criteria and Standards Review form. Form 01I, Form AI, Form CASH (if using the SACS format for cashflow analysis), and Form MYPI (if using the SACS MYP format), must be completed and saved before completing Form 01CSI.

  • TRC Supplemental—Run the TRC Supplemental module, which checks for required supplemental and/or criteria and standards forms and for conditions within those forms. Fatal exceptions must be corrected; warning exceptions must be corrected or, if the data is correct, must be explained.

  • Supplemental Data Changes—Make supplemental data changes, as necessary, in the applicable supplemental and/or criteria and standards forms. If it is necessary to make changes to, and subsequently reimport, general ledger data, see the next step for General Ledger Data Corrections. Re-run TRC Supplemental to verify changes.

  • General Ledger Data Corrections—Make general ledger data corrections, as necessary, in the LEA accounting system or in the Components of Ending Fund Balance/Net Position screen, and then reimport the applicable fund(s), if necessary. Re-run TRC-Import and TRC-General Ledger to verify changes. See the Importing Data section for details about automatic recalculations done after the import, reimport, and user data input processes.

  • Form CI—Interim Report Certification. Review the Criteria and Standards Review Summary for any areas of potential concern for fiscal solvency.

  • TRC-Export Validation—Run the TRC Export Validation module, which checks for required forms, forms that have unbalanced or incomplete data, and forms that need to be opened and saved due to general ledger and/or supplemental data changes (dependencies). See Attachment E, for information about clearing form dependencies.

  • Technical Review Checklist, All—To verify all Exceptions have been corrected, or explained where applicable.

  • Table of Contents—View or print the Table of Contents to ensure all applicable forms are completed. You may find it helpful to compare the Table of Contents to Attachment A of this user guide. In addition, all fund, supplemental, and criteria and standards review forms can be printed from the Table of Contents window.

  • Export—Export data to disk using the Official option for submission to the reviewing agency, if required.


Back