| Table of Contents |
|---|
...
| Info |
|---|
For further information on the Budgeting process, please refer to the Scenarios and Proposed Amounts sections of the Budgeting chapter in the USAS-R manual. |
...
| Note | ||
|---|---|---|
| ||
When entering Adjustments the amount entered should be what the user would like the new Expendable amount to be on the account. The system will calculate the difference between the initial amount and the entered amount and then create an adjustment for the difference. For Example, if the Initial Budget was 500.00 but the new Expendable amount should be 0.00, then the Adjustment entered in the Proposed Amounts grid should be 0.00. When applied, the Adjustment on the account will be -500.00. |
Upload Budgeting Spreadsheets into the scenario
Use the Upload option to upload outside spreadsheets into your scenario. These spreadsheet may contain proposed amounts.
- From the Scenario's Grid, click on Edit.
- Click on 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 adjusted amounts. column headers that match the standard Budgeting Sheet headers as well as the Proposed Amounts header PA-YYYY (where YYYY is the fiscal year).
- 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 adjusted 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.
- For examples of the proper headers see the Upload spreadsheet for a Scenario section.
- Click on 'Start Upload' to upload the spreadsheet. Once complete, an informational box appears stating budgeting sheet was uploaded successfully.
...
Please note that once a scenario is promoted for a specified fiscal year, any successive scenario related to the same fiscal year that is promoted will remove the prior scenario's proposed amounts on from the grid. For example, you create a scenario for HS adjusted amounts for FY2019 and promote it. The HS amounts are now stored in the proposed amounts grid. You then promote another scenario containing Elementary adjusted amounts for FY2019. The HS adjusted amounts will be removed from the grid and replaced with the elementary amounts will be uploaded. Instead, we recommend once the HS amounts adjusted amounts are complete, to apply for both revenue and expenditure accounts. In order to not lose the HS amounts that were stored on the grid, we recommend applying those amounts. The user can then proceed with promoting the Elementary amounts to the proposed amounts grid, which will then clear out the HS amounts (which are no longer needed since they have been applied).
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:
- Create an adjusted amount in order to add it to the existing grid
- Enter or search for an account
- Enter a fiscal year (enter the full year CCYY).
- Enter the new expendable or receivable amount
- Click on 'Save'
- View an adjusted amount
- From the grid, search the desired account and click on
to view the details of the adjusted amount.
- From the grid, search the desired account and click on
- Edit an adjusted amount
- From the grid, search the desired account and click on
to edit the fiscal year or adjusted amount.
- From the grid, search the desired account and click on
- Delete an adjusted amount
- Per account: From the grid, search the desired account and click on
to delete the adjusted amount for that account. Click on 'delete' to confirm deletion. - Mass Delete: From the grid, click on the checkbox for the adjusted amounts you want to delete and click on the
button to mass delete all checked accounts.
- Per account: From the grid, search the desired account and click on
...
Choose 'Adjustment' which will adjust the existing expendable amounts via additions/deductions for the fiscal year selected. The initial figures are not touched. The 'Update the GAAP Original Estimate' amounts box defaults to being unchecked but you have the option to check it if a GAAP adjustment should also be created.is not checked by default but is available to check if the adjustments should apply to the GAAP Original Estimated amounts.
- Effective Date: When selecting Adjustment transactions type, it will default to 7/1/18. You will need to change the effective date to the posting period you want the adjustments to be reflected in. For example, if you are posting adjustments that you want reflected in the June posting period, you need to enter a June datedate must be manually entered. Adjustments will be included in the MTD Expendable and Receivable amounts based on the date entered.
Click on 'Apply' to proceed with applying the adjusted figures. These will now become the new expendable or receivable figures and the differences between the 'old' and 'new' amounts will appear in the FYTD adjustments as positive or negative figures.