Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

Version 1 Next »

The Budgeting Process contains two programs:

  • Scenarios: Allows for the creation of a budget scenario via spreadsheets  which are then promoted to proposed amounts.
  • Proposed Amounts: Once promoted, the amounts are stored in the proposed amounts grid to allow for changes.  Once ready, they will be applied as initial budget and revenue estimates.

Scenarios

  • Click on Budgeting → Scenario → to create a Scenario
  • Enter Name → Description → 
    • to create a spreadsheet within the scenario; or
    • to upload an outside spreadsheet into the Scenario


You may click  to save what has been entered so far in the Scenario.  You may edit your scenario as many times as you need to in order to add additional spreadsheets or make changes to existing spreadsheets.


Create New Budgeting Sheet within the scenario

  • Select Type (Budget or Revenue)
  • Add or Remove Properties to your spreadsheet.
  • Configure Filters (i.e only want high school accounts)
  • Enter a 'Sheet Name' 
  • Click on  to save your spreadsheet.  A 'Confirmation Sheet Creation' box appears.  Click on  to create the spreadsheet.  An informational box will appear with budget sheet creation is successful.

Budgeting Sheets Grid

  • Click onto edit an existing spreadsheet in order to enter proposed amounts
  • If you prefer to enter proposed amounts and/or make changes to your spreadsheet in Excel, click on  to download the spreadsheet into Excel.  When finished, click on  to import the spreadsheet back into the Budgeting sheets grid
  • Click on  to delete an existing spreadsheet you no longer want.

The Budgeting module can store more than one scenario, though generally, a single scenario will be sufficient.  However, special circumstances may require multiple scenarios based on different assumptions.  For example, you may wish to create a scenario for "Assuming Levy Passes" and another "Assuming Levy Fails".   

Please note that once a scenario is promoted, any successive scenario that is promoted will overwrite a prior scenario's amounts. For example, you create a scenario for HS budget amounts and promote it. You then promote another scenario containing Elementary Budget amounts. The HS budget amounts will be removed and the elementary budget amounts will be uploaded. So instead of creating separate scenarios, we recommend creating separate worksheets within the same scenario.

Each scenario consists of one or more budgeting spreadsheets.   A district may choose to use a single spreadsheet containing all accounts, or create a separate sheets for different management areas.  For example, you might create a sheet for the high school, each elementary building and athletics.  Each principal or supervisor could work on their own portion of the budget.  Once the budgets are completed they can be loaded back into the system. 

Once a scenario is completed and approved, a scenario can be "promoted" to the proposed amounts on the budget and revenue accounts.

To schedule a template or custom report to run for a specific day and/or time, the job scheduler icon  can be used in the 'Generate Report' window.   This is a one-time setup which will then generate the report based on the cron expression and automatically email it to a specified recipient. You can use a free online cron expression generator to generate your cron expression.

  • No labels