Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Scenarios: Allows for the creation of a budget scenario via spreadsheets  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.

...

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


Info

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 Spreadsheets within the scenario

  • Select Type (Budget or Revenue)
  • Add or Remove Properties to On the 'Properties' tab, add or remove properties on your spreadsheet.
  • Click on 'Configure Filters' to filter accounts you want included on the spreadsheet (i.e only want high school accounts with OPU = 200)
  • Enter a 'Sheet Name' 
  • Click on Image Removed to on 'Save Sheet' to save your spreadsheet.  A 'Confirmation Sheet Creation' box appears.  Click on Image Removed to create on 'Create' to continue creating the spreadsheet.  An Once complete, an informational box will appear with budget sheet creation is successfulappears stating budgeting sheet created successfully.

Budgeting Sheets Grid

  • Click onto edit an existing spreadsheet in order to enter proposed amounts (must use the 
  • 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.

...