A scenario is a single version of an organization’s budget for a given fiscal year. For example, you can create multiple scenarios of your original budget to track revisions for that budget.
The scenario record stores all the information you need to track and manage the scenario, such as associated accounts, projects, or grants. It also stores the total budget, period amounts, and status.
The summary panel displays important information for the scenario such as fiscal year and create date. It also displays total revenue and total expense amounts.
Note: The total expense amount displays the total for all expenses associated with the account. The amount does not update specifically for the scenario, and it also does not update when you apply filters in the action bar.
To quickly view totals and distributions for an account, project, or grant (or a combination that uses two of them) you can apply groups in the scenario list.
One group — To group the list based on account, project, or grant, access and open the scenario from the Budgets list. On the action bar, select Group by. Under Grouping, select Add a group and select how to group the list in the drop down field.
After you save, the list displays one row for each group based on your selection. For example, when you group by account, one row appears for each account in the list and scenario totals calculate automatically for your review. You can also select the drop down in the row to view distributions for the account.
Two groups — To add a secondary group, select Add another grouping. After you save, the list displays one row for each primary group that is associated with the same secondary group. For example, one row appears for account 01-1000-05 that uses project 0310 for distributions. A second row appears for account 01-1000-05 that uses project 0330 for other distributions. Each row calculates totals automatically and includes a drop down to view the applicable distributions.
To export the list to an Excel .XLSX file, select Export to Excel on the action bar. To create a custom export, use the column chooser and filter options to specify the exact data you need. The export will include data from every page that appears in the list.
To copy a scenario, you can export the data to Excel and use the Budget Creator Excel add-in to update data for the new scenario. When you do this, we recommend including the Account description and Project description columns to decrease time spent selecting this data in Excel for the new scenario. After you submit the scenario, you can open it in the web view. You can also do this to replace an existing scenario with a new one.
Tip: To avoid duplication, make sure you delete the original scenario in the web view.
Warning: You cannot export data to the add-in to update an existing scenario. The add-in always creates a new scenario in the web view. For more information, see Budget Creator Excel Add-In.
You can select additional view options to display list data that is most valuable to you and your daily workflow.
Spacing — By default, the data in a scenario list uses the same standard font size and row spacing as other lists in Financial Edge NXT. To reduce font size and minimize row space, select Compact. After you save the options, the compact view displays additional data in the list to help reduce the need to scroll.
Display — These options default column dates, decimals for amounts, and column totals in the list. To view more scenario data and reduce the need to scroll, clear the checkbox for Dates in column header, Decimals, or Column totals in footer
Note: If you do not display decimals, be aware totals may skew slightly due to values that round up or down.
As you review scenario list details, make sure to remember this information for clarification purposes.
To minimize the data you view in the list, select Filters on the action bar. For more information, see Scenario Filters.
If a transaction code is assigned to a grant in the database view, the grant is linked in the list and opens in the web view.
When an account view total is greater than the budget total in the database view, a row appears in the list to display the undistributed amount for the account. After the amount is distributed evenly in the database view, the row no longer appears in the list.
The Total revenue and Total expense rows appear in the footer to calculate scenario amounts for each column.
Tip: If the Total expense row does not appear, make sure it's selected to display from View options, Column totals in footer. Also, if revenue or expenses do not exist for the scenario, its corresponding row does not appear.