| Table of Contents |
|---|
...
- Click Upload
- Enter a 'Sheet Name' and optional 'Description'
- Click on 'Choose File' and select the outside spreadsheet you want to upload
- NOTE: The outside spreadsheet must contain account code dimensions in separate columns with the proper column headers. You may also include the proposed amounts. The following rpd-json files may be downloaded and imported into the Redesign. They are similar to the SSDT Budget Expense and Revenue Expense template report definitions but have been formatted to include the proper columns headers in a spreadsheet format.
- NOTE: When entering proposed amounts, you must change the 'Next Year Proposed' column to 'PA-XXXX' (XXXX=desired fiscal year) in order for the spreadsheet to upload properly into the the budget scenario.
- Click on 'Start Upload' to upload the spreadsheet. Once complete, an informational box appears stating budgeting sheet was uploaded successfully.
Promote a Scenario
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. 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 as well as from 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:
...