| Table of Contents |
|---|
...
Click on Budgeting → Scenario → Create to create a Scenario
Enter Name → Description →
...
Click Save to save the Scenario or continue on to create or upload sheets. Remember to ‘Save’ the scenario when finished
...
From the Scenario Grid, query an existing Scenario you want to Clone
Click on
to view the ScenarioClick on
. All accounts associated from the existing scenario will be copied to the new scenario.
...
Once a spreadsheet is created in the scenario, it is displayed on the Budgeting Sheets grid. You can then access the spreadsheet using one or more of the following options in order to add proposed amounts:
...
Click on
to edit an existing spreadsheet (must use the existing PA-XXXX column to enter your proposed amounts)
you can add (insert) or delete rows in your spreadsheet
You can use formulas to enter your proposed amounts
Click on
to regenerate the sheet. This option is helpful if you made changes to the existing sheet (add/remove properties, change account filters, etc). Regenerate will update the sheet with the new changes, thus overriding the previous sheets settings. Existing proposed amounts will be removed.If you prefer to enter proposed amounts and/or make changes to your spreadsheet via Excel, click on
to download the spreadsheet into Excel. Once the spreadsheet is completed and saved, click on 
to import the spreadsheet back into the scenarioClick on
to delete an existing spreadsheet you no longer want.
...
Once a scenario is completed, it can be "promoted" to the proposed amounts field on the budget and revenue accounts. Promote includes all spreadsheets in the scenario. Once promoted, the accounts with associated amounts will appear in Budgeting/Proposed Amounts Grid as well as the Next Year Proposed Amount field under the accounts UI. The proposed amount grid is the working area where you can add/remove/edit the NY proposed amounts. When you do, it directly affects the NY proposed amount on the expenditure/revenue account.
| Warning |
|---|
Please note that once a scenario is promoted, any successive scenario that is promoted for the same year will remove a prior scenario's proposed amounts from the grid. For example, you create a scenario for HS NY proposed amounts and promote it. You then promote another scenario containing elementary NY proposed amounts. The HS NY proposed amounts will be removed from the grid (and from the proposed amounts fields on the expenditure/revenue accounts) and the elementary NY proposed amounts will be loaded. To prevent removal of a prior scenario's proposed amounts, we recommend creating separate worksheets (i.e. HS and Elementary) within the same scenario instead of creating separate scenarios. |
Proposed Amounts
...
Contains separate tabs for existing 'Proposed Budgets' and 'Proposed Anticipated Revenues' amounts in a grid format based on the fiscal year selected. Users can:
...