Flow of Funds Analysis

#

Overview #

Flow of Funds provides a visual representation of money movement between income sources, accounts, and expense categories using an interactive Sankey diagram. This powerful visualization helps you understand the complete financial picture at a glance.What It Does

• • Visual Money Flow: Shows how money flows from income sources through accounts to expenses

• • Interactive Diagram: Click on nodes and links to filter and explore specific transactions

• • Category Mapping: Requires transaction categorization to function properly

• • Real-time Filtering: Filter transactions by clicking on diagram elements

• • Transaction Details: View underlying transactions for any flow path

How It Works #

The system creates a three-column visualization:

• • Left Column: Income categories (green flows)

• • Middle Column: Account nodes

• • Right Column: Expense categories (red flows)

• • Flow Width: Represents the amount of money moving through each path

How to Use #

1. 1. Prerequisites: Ensure your transactions are categorized first

1. 1. Navigate: Go to Analyze → Flow of Funds tab

1. 1. View Diagram: The Sankey diagram loads automatically

1. 1. Interact with Flows:

• • Click on income nodes to see money coming in

• • Click on account nodes to see account activity

• • Click on expense nodes to see money going out

• • Click on flow lines to see specific transaction pairs

1. 1. Review Transactions: The bottom table shows filtered transactions based on your clicks

1. 1. Clear Filters: Use the “Clear Filters” button to reset the view

Understanding the Visualization #

• • Green Flows: Income flowing into accounts

• • Red Flows: Expenses flowing out of accounts

• • Blue Flows: Transfers between accounts

• • Node Size: Proportional to total money flow through that node

• • Flow Thickness: Proportional to the amount of money in that flow

Interactive Features #

• • Hover Tooltips: Show detailed information about nodes and flows

• • Click Filtering: Filter transactions by clicking diagram elements

• • External Filters: Use additional filters for date, description, amount

• • Export Options: Export filtered transaction data

Common Use Cases #

• • Financial Overview: Get a complete picture of money flow patterns

• • Source Analysis: Understand where money is coming from

• • Spending Analysis: See where money is being spent

• • Account Usage: Identify which accounts are most active

• • Investigation: Track suspicious money movements

• • Client Presentations: Visual way to explain financial patterns

Best Practices #

• • Categorize First: Ensure all transactions have appropriate categories

• • Regular Updates: Refresh after adding new transaction data

• • Use Filters: Combine diagram clicks with external filters for detailed analysis

• • Export Data: Save filtered results for further analysis

• • Document Findings: Keep notes on significant flow patterns discovered

Troubleshooting #

• • Empty Diagram: Check that transactions are properly categorized

• • Missing Flows: Verify account names and categories are correctly assigned

• • Performance Issues: Use date filters to limit data scope for large datasets