The Cashflow Tracker Table allows the user to see specific Cashflows that occur within the Waterfall, during the waterfall steps. The user can stress the Report based on a specific Scenario.
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 the refresh button.
The user can also change the As of Date on the top left, and then clicking the refresh button.
Specific Functionality:
All columns can be filtered for ease of the user.
Note: Steps without cashflows will not be displayed in the Report.
See detailed information of the data displayed in each column below
Period Column:
The Period column displays the period each step is executed.
Date Column:
The Date column displays the specific date the step will be executed.
Step Index Column:
The Step Index column displays the specific step in accordance with the Waterfall, the user can trace the specific action back to the waterfall structure.
Source Column:
The Source column will display the Source account from which the Cash flow will flow on that specific step. It is determined by the Source account defined under the Waterfall.
Limit Column:
The Limit column will display the amount calculated by the limit set in the specific step. Steps without a Limit will be displayed as blank.
Withdrawal & Available Columns:
The Available column will display how much is currently available in the account, while the Withdrawal column shows how much is paid from said account.
Uses Category Column:
The Uses Category column will display the specific category chosen in the Waterfall in this step. It will also specify the Tranche, if relevant.
Uses Account Column:
The Uses Account column displays which specific account is being used in this step, this correlates to the accounts defined under Uses in the Waterfall.
Payment Due Column:
The Payment Due column will display the amount that is due to be paid in this specific step for this particular account (Notes: Steps that pay more than one account will appear multiple times in the tracker).
Payment Paid Column:
The Payment Paid column will show the actual amount that was paid in this specific step for this particular account (Note: Steps that pay more than one account will appear multiple times in the tracker).
It may vary from the Payment Due column due to insufficient funds in the source account or enforced by a Limit.
Shortfall Column:
The Shortfall column will show the shortfall amount in the case of insufficient funds.