The Custom Cashflow Report allows users to see only the fields they are interested in. Users can filter any field from the collateral, bond, or waterfall steps-related field.
When creating a New Deal Cashflow Report, the user can customize the report by choosing which sections to include, which scenario to execute, from which date this report will be generated, and whether to display either Historical data, Projections data, or both.
Report Sections:
To customize the reports’ sections, click on the Report Sections.
Note: In deals with different collateral, the sections will be updated accordingly.
The user can also configure the specific fields that will be shown in the report by clicking on the report field configuration. The field search can be manually searched or narrowed down by the category drop-down list (which will also be updated by the collateral type).
By clicking on a field, the user can see the description of the field below.
Scenarios:
The user can choose which Scenario will be executed on this report. All scenarios defined under the Scenarios tab will appear in the drop-down.
As of Date:
The user can choose which date will the Report will be displayed from. This allows the user the ability to examine the deal from various points in time.
The earliest date available is the Cut-Off Date - for reports that include collateral, and First Interest Payment Date in reports that include Bonds. The user has the option to choose whether to show Historical data, Projected data or both.
Historical Data is only available in deals where they were provided. Historical data is not manipulated, and simply displayed as given, and will be taken into account in future projections.
The Report:
Once clicking generate, the Report will be displayed.
Once the Report is generated, the user can use the buttons located at the top right, which are shown in the visual below. These six icons allow the user to save the table, export to Excel, Refresh the table in case there are changes in other sections, Edit the table, minimize the table or Delete it.
The user can also change the scenario by clicking on the scenario name on the top left, then clicking refresh.
The user can also change the As of Date on the top left next to the Scenario name and then refresh.
By default, the report shows all the fields that was selected when creating the widget. The user can add/remove columns to the report by selecting them on the Column Tool Panel on the right side of the screen:
Column Menu Option:
Users can open the column menu options by clicking on the
icon that appears upon hovering over each of columns in the table:
This panel provides variety of actions:
- Pin column
- Auto-size this column
- Auto-size all columns
- Group by the column
- Reset Columns
Pin Column:
To use the pin column option users must select the right or left by clicking on the Pin Column and then selecting Left / Right / No Pin. The columns within the table will reorder the columns so that left pinned columns come first and right pinned columns come last, depending on which selection is made.
Below is an example of 2 columns that are pinned to the left (Vehicle Model Name & Beginning Balance) and one to the right (Counter).
Example:
Two columns pinned to the left and one for the right.
Auto-Size a Column / All columns:
Users can auto size the columns in the table by clicking the auto-size option. The system will work out the best width to fit the contents of the cells in the column(s).
Group by Column:
Users can group by the column that is selected. If the column is already group, then the option that will be shown is to un-group the column.
Reset Columns: Reset the default column setup after generating the widget.
Expand All: Expand all groups. It is only shown if the table has grouping by at least one column.
Collapse All: Contract all groups. Only shown if the table has grouping by at least one column.
Column Filtering: You can filter your data at the column level. Many column filters can be active at once (e.g. filters set on different columns) and the grid will display rows that pass every column's filter.
How to use filters:
• Users can open the Filters Tool Panel by clicking on the
icon.
• Columns that are filtered will have the filter icon appear beside the column name
.
The filtering option contains a variety of conditions to filter by based on the format of the field:
Options
- Character type field filtering options
- Numeric type field filtering options
Date type field filtering options
- The ability to filter on 2 conditions at a time with an “And” or “Or” operators. The user can also search list of values with autocomplete.
- The summary line at the bottom of the table will update dynamically the remaining number of rows based filtered rows:
- The ability to filter on 2 conditions at a time with an “And” or “Or” operators. The user can also search list of values with autocomplete.
Column Selection:
The column selection allows users to decide which columns to display in the table. Users can search for a column name where autocomplete will bring the top the matches results to select. By default the order of the columns is kept in sync with the order they are shown in the table.
Column Sorting:
Users can sort their data at the column level on multiple columns. The default action for multiple column sorting is to hold down the Shift key while clicking the column header after sorting the first column. A small number will appear on each column to show the order of the sorting.
Sorting a Row Group :
By default, the groups are presented randomly and are not sorted in any order. However, the user can sort the grouping column.
Moving a Column:
The columns can be moved in the table by dragging the column headers with the mouse to move the column to the new location
Column Tool Panel:
The columns tool panel to the right of the table, provides functions for managing the grid's columns:
Pivot Mode Section:
Check the 'Pivot Mode' checkbox to turn the grid into Pivot Mode. Uncheck to take the grid out of pivot mode.
Columns Section:
Users can decide which columns to display in the table. The user can search for column name where autocomplete will bring to the top the matches results to select. By default the order of the columns is kept in sync with the order they are shown in the table.
Select / Un-select All:
Toggle to select or un-select all columns in the columns section.
Drag Handle:
Each column can be dragged to one of the following:
- Row Group
Users can group a column by dragging it to the Row Group section of the Column Tool Panel. For example you can: Drag a column(s) (e.g. Vehicle Manufactured Name & Vehicle Model Name) to Row Groups to group rows or Drag a columns(s) (e.g. Beginning Balance) to Values to aggregate
The group column groups the Vehicle Name and in parenthesis provides a count of rows in each group. The second column displays the sum of the beginning balance by vehicle name.
- Sorting a Row Group
By default, the groups are presented randomly and are not sorted in any order. However, the user can sort the grouping column.
Summary Status Bar:
The status bar appears below the grid and displays information about the data in the grid. Users can see that information by highlighting the relevant rows.
Pivot Mode
Users can pivot the data by turning on the Pivot Mode, turning this on is required to be turned on for pivoting to work. When the grid is in pivot mode, the following will happen:
- Only columns with Group, Pivot or Value active will be included in the table .
- Only aggregated rows will be shown, the lowest level row Data will not be displayed. If pivot mode is off, then adding or removing pivot columns will have no effect.
Export to Excel:
Users can export the table to Excel by clicking the “Export to Excel” icon
located on the top right side of the screen.
Autosave:
The table will autosave every time a change occurs.