/
Financial Forecast

Financial Forecast

The Financial Forecast option allows you to extract forecast data for the current fiscal year. The grid contains the accounts included in the forecast along with their associated forecast line number and description, as well as the three prior year's actual values and current year FYTD expendable or receivable values.

From the Periodic menu,

  1. Click on 'Financial Forecast'.

  2. Select CSV or Excel under Format Type.

  3. Click image-20250903-135922.png  to save it in CSV or Excel format on your computer. 

    image-20250903-135952.png

 

Format Types

  • The CSV option generates a comma-separated formatted file of the forecast data containing the forecast line numbers, prior year actual values, and current year estimates.

The Ending Cash Balance 7.020 and Estimated June 30th Encumbrance 8.010 amounts will be based on actual values for the current period the extract is generated in the CSV and data tab version. This may not be consistent with the estimated values of the other lines when generated for periods throughout the fiscal year.

  • The Excel option will generate a spreadsheet containing prior and current year figures from USAS in the SSDT's Financial Forecast format. This spreadsheet contains a tab “Forecast” where future year figures can be manually input to the sheet. Please see the Instructions tab within the Excel Spreadsheet for more details.

    • Forecast contains the Financial Forecast

    • Parameters contains global parameters (District Name, IRN, Fiscal Year)

    • Data contains source data from USAS at the time the Excel extract was generated

    • Output contains a compilation of data from the Data and Forecast tab in the proper format to save as CSV for the data collection

image-20250903-140525.png

More Information

SSDT Forecast Standard Template

Please ensure the correct fiscal year is entered in the parameters worksheet in order for the forecast years to display correctly in the forecast worksheet.

  • Includes several optional sheets, including "Percentage" and "Summary" presentations of the Forecast, similar to ones provided by AOS.  Also included is a "Charts" sheet, which contains several sample Excel charts showing graphical presentations of the forecast data.  These additional views and charts work without any additional effort and update automatically as the Forecast data is updated.

    • SSDT Financial Forecast Template (macros disabled v97-2003)