@@ -8,32 +8,32 @@ Prioritize the requirements as must-have, should-have, could-have, or won't-have
**GENERAL**
**1.Store data in a database**
**1.Store data in a database (must-have)**
- Who: As a user
- What: I need my transactions to be stored in a database
- Why: So I they can be quickly retrieved and used for vizualization.
**2.Visualize Accounts, Companies, or Groups as Nodes**
**2.Visualize Accounts, Companies, or Groups as Nodes (must-have)**
- Who: As a user
- What: I want accounts, companies, and groups to be visualized as nodes within a graph.
- Why: So that I can easily identify and analyze the relationships and interactions between different participants, gaining a clearer and more organized overview of financial connections.
**3.Visualize Outgoing Cash Flows with Outgoing Edges**
**3.Visualize Outgoing Cash Flows with Outgoing Edges (must-have)**
- Who: As a Financial Manager
- What: I want outgoing edges in the visualization to represent outgoing cash flows.
- Why: So I can clearly track where the company’s money is being spent and manage outflows effectively.
**4.Visualize Incoming Cash Flows with Incoming Edges**
**4.Visualize Incoming Cash Flows with Incoming Edges (must-have)**
- Who: As a Financial Manager
- What: I want incoming edges in the visualization to represent incoming cash flows.
- Why: So I can easily see where the company is receiving money from and monitor cash inflows for effective financial management.
**5. Visualize Net Cash Flows as one edge**
**5. Visualize Net Cash Flows as one edge (must-have)**
- Who: As a Financial Manager
- What: I want an option to visualize the net cash flows (incoming minus outgoing)
- Why: So that I can quickly see the overall net cash position simplifying financial analysis and helping me make more informed decisions about financial management and resource allocation.
**6. Visualize Cash Flows with Edge Thickness Based on Flow Size**
**6. Visualize Cash Flows with Edge Thickness Based on Flow Size (could-have)**
- Who: As a Financial Manager
- What: I want the thickness of edges in the visualization to represent the size of the cash flows.
- Why: So I can quickly identify and focus on the largest cash flows, enabling more effective financial analysis and decision-making.
...
...
@@ -41,43 +41,43 @@ Prioritize the requirements as must-have, should-have, could-have, or won't-have
---
**AGGREGARED AND DETAILED VIEWS**
**7.Visualize my company as a seprate node**
**7.Visualize my company as a seprate node (must-have)**
- Who: As a Financial Manager
- What: I want my company involved in the transactions with different companies to be represented as separete node in the graph
- Why: So I can view cash flows as an aggregate of my company's accounts to providing a general overview of the financial performance of the company.
**8.Visualize Small and Medium-Sized Businesses (SME) as an Aggregate Node**
**8.Visualize Small and Medium-Sized Businesses (SME) as an Aggregate Node (must-have)**
- Who: As a Financial Manager
- What: I want to visualize all Small and Medium-sized businesses (SMEs) as a single aggregate node.
- Why: So that I can simplify the visualization and analyze cash flows to or from SMEs collectively, rather than viewing each business separately.
**9. Visualize Corporations as an Aggregate Node**
**9. Visualize Corporations as an Aggregate Node (must-have)**
- Who: As a Financial Manager
- What: I want to visualize all corporations as a single aggregate node.
- Why: So that I can simplify the visualization and analyze cash flows to or from corporations as a group, rather than individually, making it easier to manage and understand the financial interactions with this segment.
**10. Visualize All Private Persons as an Aggregate Node**
**10. Visualize All Private Persons as an Aggregate Node (must-have)**
- Who: As a Financial Manager
- What: I want to visualize all private persons involved in transactions as a single aggregate node (labeled "Private.")
- Why: So that I can simplify the visualization, reduce complexity, and analyze cash flows to or from private individuals as a group, instead of viewing each person separately.
**11. View Aggregated Incoming and Outgoing Flows Between my ompany's Node and SME, Corp, and Person Nodes**
**11. View Aggregated Incoming and Outgoing Flows Between my ompany's Node and SME, Corp, and Person Nodes (must-have)**
- Who: As a Financial Manager
- What: I want a default view where all incoming and outgoing cash flows between my company SME, Corp, and Person nodes are aggregated.
- Why: So that I can easily monitor and analyze high-level cash flows between my company and these key segments, allowing for more streamlined financial management and decision-making.
View Cash Flows at the Account Level to SMEs, Private Persons, and Corporations
**12. View Cash Flows at the Account Level to SMEs, Private Persons, and Corporations**
**12. View Cash Flows at the Account Level to SMEs, Private Persons, and Corporations (must-have)**
- Who: As a Financial Manager**
- What: I want an option to view cash flows at the account level, showing flows from my company's individual accounts to SMEs, Private persons, and Corporations.
- Why: So that I can track specific financial interactions between my company’s accounts and these key segments, providing deeper insight into how each account is performing in relation to different customer types.
**13. Visualize Coppany's Internal Cash Flows (accounts with same participant_name)**
**13. Visualize Coppany's Internal Cash Flows (accounts with same participant_name) (must-have)**
- Who: As a Financial Manager
- What: I want to visualize cash flows only between our company's internal accounts.
- Why: So that I can track internal financial movements, optimize resource allocation, and ensure efficient liquidity management within the company.
**14. Visualize Internal Transfers within One Bank**
**14. Visualize Internal Transfers within One Bank (shold-have)**
- Who: As a Financial Manager
- What: I want to visualize only the movements of funds within accounts owned by the company in the same bank.
- Why: So that I can track and manage internal transfers within a single bank, ensuring efficient use of internal resources and liquidity management.
...
...
@@ -88,27 +88,31 @@ Prioritize the requirements as must-have, should-have, could-have, or won't-have
**CURRENCIES**
**15. Visualize Cash Flows in Payment Currencies**
**15. Visualize Cash Flows in Payment Currencies (must-have)**
- Who: As a Financial Manager
- What: I want every incoming and outgoing edge to show the currency in which the payment was made.
- Why: So I can easily identify which currencies are being used for both incoming and outgoing payments, helping me manage foreign exchange risk and track multi-currency flows accurately.
**16. Visualize Cash Flows in specific Currency**
**16. Visualize Cash Flows in specific Currency (must-have)**
- Who: As a Financial Manager
- What: I want to filter and visualize cash flows where transactions are made in a specific currency
- Why: So that I can easily monitor balances, track cash movements in that currency, and manage foreign exchange exposure and currency-specific liquidity effectively.
**17. Convert All Other Currencies to Euros (won't have)**
- Who: As an accountant
- What: I want an option to convert all other currencies in the transactions to euros.
- Why: So that I can standardize and simplify financial reporting, enabling easier comparison and analysis of cash flows across different currencies by using a single, consistent currency.
---
**FILTERING BASED ON TIME**
**17. Set Custom Date Ranges**
**18. Set Custom Date Ranges (must-have)**
- Who: As an Accountant
- What: I want to set custom start and end dates filter.
- Why: So that I can focus on specific financial periods that are important to me, helping to analyze relevant financial events more accurately.
**18. Use Preset Date Ranges**
**19. Use Preset Date Ranges(should-have)**
- Who: As an Accountant
- What: I want to apply common preset date ranges (e.g., last week, last month, last quarter, last year, last year).
- Why: So that I can quickly apply filters for commonly used time frames, speeding up routine analyses and saving time.
...
...
@@ -117,17 +121,17 @@ Prioritize the requirements as must-have, should-have, could-have, or won't-have
**FILTERING LOCATION**
**19. Filter Cash Flows by Country to SMEs, Corporations and Persons**
**20. Filter Cash Flows by Country to SMEs, Corporations and Persons (must-have)**
- Who: As a Financial Manager
- What: I want to filter cash flows to SMEs, Corporations and Persons by the country of destination.
- Why: So that I can analyze how cash flows are distributed across different countries for each group, monitor regional financial activities, and manage risks or opportunities related to specific geographic markets.
**20. Filter Cash Flows from SMEs, Corporations, and Private Persons by Country**
**21. Filter Cash Flows from SMEs, Corporations, and Private Persons by Country (must-have)**
- Who: As a Financial Manager
- What: I want to filter cash flows from SMEs, Corporations, and Private Persons to my company based on the country of origin.
- Why: So that I can analyze where incoming cash flows are originating from geographically, monitor international financial activities, and manage risks or opportunities associated with specific countries.
**21. Filter Cash Flows by Postal Codes (Only in Estonia?)**
**22. Filter Cash Flows by Postal Codes (Only in Estonia?) (could-have)**
- Who: As a Financial Manager of a restaurant chain
- What: I want to filter cash flows by postal indexes within my country.
- Why: So that I can see which areas my restaurants are performing better or worse, allowing me to make
...
...
@@ -137,8 +141,7 @@ data-driven decisions to improve financial performance in specific locations.
**FILTERING BY PAYMENT CHANNEL TYPE**
**22. Filter Cash Flows by Payment Channel Type**
**23. Filter Cash Flows by Payment Channel Type (should-have)**
- Who: As a Financial Manager
- What: I want to filter cash flows based on payment channel types (e.g., online banking, mobile payments, in-store POS, etc.).
- Why: So that I can analyze cash flows by different payment channels, helping me understand which channels are being used most frequently and optimize financial operations based on channel performance.
...
...
@@ -147,65 +150,65 @@ data-driven decisions to improve financial performance in specific locations.
**LISTS BASED ON TOP AMOUNT**
**23.List Companies in the SME or Corporate Category Sorted by Total Cash Flows to me**
**24.List Companies in the SME or Corporate Category Sorted by Total Cash Flows to me (must-have)**
- Who: As a Financial Manager
- What: I want an option to list companies within the SME or Corporate category, sorted by the total amount of cash flows to my company.
- Why: So that I can easily see which SMEs or Cporporations are contributing the highest cash flows, helping me prioritize financial strategies and key partnerships.
**24. Select a Company in SME or Corporations list and list Its Transactions Based on Amount**
**25. Select an SME or Corporation and list Its Transactions to My Company Based on Amount (must-have)**
- Who: As a Financial Manager
- What: I want an option to select a company from the list of those with the biggest cash flows to me and list its transactions based on the amount.
- Why: So that I can analyze individual transactions from high-volume companies, prioritize key relationships, and focus on significant financial interactions for better decision-making.
- What: I want an option to select any company and list its transactions to my company, sorted by the amount.
- Why: So that I can analyze individual transactions from key companies, helping me focus on significant financial interactions for better decision-making.
**25.List SMEs or Corporations Based on Cash Flows to Them**
**26.List SMEs or Corporations Based on Cash Flows to Them (must-have)**
- Who: As a Financial Manager
- What: I want an option to open a list of names of SMEs or Corporations where my cash flows to them are sorted by the total amount.
- Why: So that I can track and analyze which companies are receiving the most cash from my company, helping me manage outgoing payments more effectively and prioritize financial relationships.
**26. Select an SME or Corporation and List Transactions from My Company by Amount**
**27. Select an SME or Corporation and List Transactions from My Company by Amount (must-have)**
- Who: As a Financial Manager
- What: I want an option to select an SME or Corporation and get a list of transactions from my company to - that entity, sorted by the amount.
- What: I want an option to select any SME or Corporation and get a list of transactions from my company to that entity, sorted by amount.
- Why: So that I can analyze the largest transactions to specific companies, helping me manage significant outflows and focus on key financial relationships.
---
**LISTS BASED ON TOP FREQUENCY**
**27. List Companies in the SME or Corporate Category Sorted by Frequency of Transactions to My Company**
**28. List Companies in the SME or Corporate Category Sorted by Frequency of Transactions to My Company (must-have)**
- Who: As a Financial Manager
- What: I want an option to list companies within the SME or Corporate category, sorted by the number of transactions to my company.
- Why: So that I can easily see which SMEs or Corporations are sending the most frequent transactions to my company, helping me prioritize relationships with high-frequency transaction partners and optimize incoming financial operations.
**28. View Average Frequency of Transactions When Listing SMEs or Corporations**
**29. Select a Company and Display a List of Transactions to My Company (must-have)**
- Who: As a Financial Manager
- What: I want to see the average frequency of transactions for the same period when listing SMEs or Corporations based on transaction frequency.
- Why: So that I can better understand transaction patterns within the selected time frame, allowing me to evaluate customer payment behaviors and optimize financial planning accordingly.
- What: I want to select any SME or Corporation and display a list of transactions to my company, sorted by amount.
- Why: So that I can analyze specific transactions from key partners, helping me manage relationships and optimize incoming cash flows.
**29. Select a Company and Display a List of Transactions to My Company**
- Who: As a Financial Manager
- What: I want to select a company from the list of SMEs or Corporations sorted by transaction frequency and display the list of transactions sorted by amount to my company.
- Why: So that I can analyze specific transactions from high-frequency partners, helping me manage key relationships and optimize incoming cash flows.
**30. List Companies in the SME or Corporate Category Sorted by Number of Transactions from My Company**
**30. List Companies in the SME or Corporate Category Sorted by Number of Transactions from My Company (must-have)**
- Who: As a Financial Manager
- What: I want an option to list companies within the SME or Corporate category, sorted by the number of transactions from my company to them.
- Why: So that I can identify which SMEs or Corporations are receiving the most frequent transactions from my company, helping me manage outgoing cash flows more effectively and prioritize relationships with high-transaction partners.
**31. View Average Amount of Transactions When Listing Transactions to SMEs or Corporations**
- Who: As a Financial Manager
- What: I want to see the average amount of transactions for the same period when listing my transactions based on frequency to SMEs and Corporations.
- Why: So that I can better analyze the financial impact of frequent transactions and optimize resource allocation by understanding the average value of transactions within the selected time frame.
**32. Select a Company and Display Transactions from My Company Sorted by Amount**
**31. Select a Company and Display Transactions from My Company Sorted by Amount (must-have)*
- Who: As a Financial Manager
- What: I want to select a company from the list of SMEs or Corporations sorted by the number of transactions from my company and display the transactions sorted by amount.
- Why: So that I can analyze the largest transactions to high-frequency partners, helping me manage significant outflows and prioritize key financial relationships.
- What: I want to select any SME or Corporation and display the transactions from my company to that entity, sorted by amount.
- Why: So that I can analyze the largest transactions to key partners, helping me manage significant outflows and prioritize financial relationships.
---
**STATISTICS**
**32. View Average Frequency of Transactions to my company (should-have)**
- Who: As a Financial Manager
- What: I want to see the average frequency of transactions to my company within a selected period.
- Why: So that I can analyze the overall transaction patterns and gain insights into customer behavior over time, allowing me to optimize financial planning and improve decision-making.
- Normal distribution of payments
**33. View Average Amount of Transactions from my company to SMEs or Corporations (should-have)**
- Who: As a Financial Manager
- What: I want to see the average amount of transactions from my company to SMEs and Corporations within a certain period.
- Why: So that I can better analyze the financial impact of frequent transactions and optimize resource allocation by understanding the average value of transactions within the selected time frame.
