As a hub operator wishing to serve connected DFSPs by giving them visibility of their liquidity balances", because it's the hub operator doing it, at least until the Participant Portal is implemented.
Acceptance Criteria
[x] Access to Business Portal:
[x] The authorized users should be able to access the business portal with valid credentials.
[x] Report Navigation Overview:
[x] Upon logging in, the DFSP should see an option to view the Reports>>settlement statement report section on the portal.
[x] Balance Categories:
[x] The portal should display balance changes categorized into fund deposit, withdrawal, and settlement,reference column in fund withdraw/deposit activities during the selected date range.
[x] Updated Balance:
[x] The portal should display the updated balance after each transaction for easy tracking of the liquidity account status.
[x] Excel Report Format:
[x] The generated report should adhere to the format specified in the provided Excel file.
[x] Export Option:
[x] The DFSP should have the option to export the balance changes and transaction records in a downloadable format that is in excel.
[x] Filter Options:
[x] The report should offer four available filters: DFSP name (selected from onboarded DFSP list), start date, end date, and currency selection (options include All, Currency 1, Currency 2).
[x] Initial Balance Calculation:
[x] The report should calculate the initial balance of each DFSP at the beginning of the selected date range, considering transactions prior to any activities conducted during the selected period.
Error Message for Empty Filtered Range :
If there is no data available within the filtered range, the report should display a clear and informative message under the header names,: "There is no available data in the selected date range and filter criteria. Please adjust your filters or select a different date range."
Visibility of Export Button:
If there is no data to display in the report, the export button should be hidden to prevent users from downloading an empty report.
Capture of Activity Types:
The report should capture fund in, fund out activity, and settlement activity for each DFSP within the selected date range and filter criteria, ensuring comprehensive coverage of financial transactions.
edited >> The specification file was updated/revised on APR 24 due to the changes of the field from header to column (Account Number), the reason behind the changes is when the currency parameter was selected for "ALL", the account number in the header cannot show for all currency so we moved it to column.
User Story
As a hub operator wishing to serve connected DFSPs by giving them visibility of their liquidity balances", because it's the hub operator doing it, at least until the Participant Portal is implemented.
Acceptance Criteria
[x] Access to Business Portal:
[x] Report Navigation Overview:
[x] Balance Categories:
[x] Updated Balance:
[x] Excel Report Format:
[x] Export Option:
[x] Filter Options:
[x] Initial Balance Calculation:
Error Message for Empty Filtered Range :
Visibility of Export Button:
Capture of Activity Types:
Detail Specification
[Spec- DFSP Settlement Statement Report]
Spec- DFSP Settlement Statement Report-2024Apr24.xlsx
edited >> The specification file was updated/revised on APR 24 due to the changes of the field from header to column (Account Number), the reason behind the changes is when the currency parameter was selected for "ALL", the account number in the header cannot show for all currency so we moved it to column.