Categories
You’ll agree it’s important for banking & payments professionals to understand the flow of funds (FoF).
Why?
The flow of funds (FOF) diagram is critical in explaining your transaction and transaction flows. It shows the origination point, from where the money started its journey, and the route it took along the way to reach its destination, the termination point.
To visualize the flow of funds, you need a visualization design primarily designed for the task.
This is where a Funds Flow Diagram (Sankey) comes into play.
The visualization diagram can help you distill the flow of funds data into meaningful insights. And this can save you tons of hours, which you can use to relax or execute other tasks.
We recommend charts that clearly communicate insights, especially when creating data stories for the top management.
Google Sheets is one of the go-to popular data visualization tools among professionals and business owners worldwide. The spreadsheet app does not natively support Sankey Diagram. Yes, you read that right.
We’re not implying you do away with Google Sheets. You can download and install a specific add-on in your spreadsheet to access a ready-to-use Funds Flow Diagram for your data stories.
In this blog post, you’ll learn the following:
Before diving right into the how-to guide, we’ll address the following question: What is a Funds Flow Diagram?
Definition: Fund flow basically highlights or shows the cash flow movement in a financial system. It usually focuses on examination of inflows and outflows of cash in a defined time period.
The metric doesn’t measure the performance of any asset. Let’s take the example of mutual funds in which fund flow considers the cash used in share purchases, or inflows, and the cash generated from share redemptions, or outflows.
The funds flow diagram doesn’t talk anything about how good or bad a fund is performing.
Net inflow occurs if a business gets more inflow into the mutual fund as compared to outflow. A net inflow produces extra cash for managers to invest.
To create compelling funds flow data story, you require a specific chart. Yes, a chart that can visualize flow without obscuring key insights.
This is where a Sankey Diagram comes in.
A Sankey Diagram or a Fund flow diagram is a type of flow chart which shows path and quantity of data at different stages in a cycle. In Sankey Chart the width of the streams is directly relative to the quantity of flow. And where the flows can combine, split, and be traced through a series of events or stages.
Funds Flow Diagram can display insights into the flow of money from the source to the intended destination. This chart draws the reader’s attention to the enormous flows, the largest consumer, the major losses, and other insights. This diagram use nodes and links to find relationship between important metrics.
The bigger the quantity of data under observation, bigger the size of a node.
So, how can you analyze data using Funds Flow Diagram?
A Funds Flow Diagram visualizes the funds inflow and outflow of a business to get the attention of stakeholders to most important flows, losses etc.
The funds Flow chart uses links and nodes to visualize data for understanding insights better. In this chart, the width of a flow from one node to another is proportional to its quantity.
The key to reading and interpreting a Funds Flow Diagram is remembering that the width of the lines and arrows is proportional to the quantity represented, in this case, volume of funds.
In the ensuing section, we’ll address how to create a funds flow diagram in Google Sheets to analyze the cash flow.
Google Sheets is a trusted data visualization tool because it’s familiar and has been there for years. But the spreadsheet application lacks a ready-made Fund Flow Diagram, such as Sankey Diagram.
We understand switching tools is not an easy task.
Therefore, we’re not advocating you ditch Google Sheets in favor of other expensive data visualization tools.
There’s an easy-to-use and amazingly affordable visualization tool that comes as an add-on you can easily install in your Google Sheets to access a ready-made Fund Flow Diagram, such as Sankey. The tool is called ChartExpo.
So, what is ChartExpo?
ChartExpo is an incredibly intuitive add-on you can easily install in your Google Sheets without watching hours of YouTube tutorials.
With a large number of ready-to-go charts in Google Sheets, the Funds Flow Diagram maker turns your complex, raw data into compelling, easy-to-digest, charts that tell data stories in real-time.
In the coming section, we’ll take you through how to create a Sankey Diagram in Google Sheets to present and analyze funds flow.
You don’t want to miss this!
This section will use a Funds Flow Diagram (Sankey Diagram) to display insights into the table below.
| Income Sources | Income | Spending Sources | Taxes | Taxes Breakage | Spending |
| Distributions | Income | Taxes | Federal | 977,421 | |
| Distributions | Income | Taxes | State | 231,394 | |
| Distributions | Income | Savings | Stock | VTSAX | 1,225,775 |
| Distributions | Income | Savings | Bonds | VXIUX | 122,577 |
| Distributions | Income | Savings | Bonds | VUSXX | 87,555 |
| Distributions | Income | Savings | Bonds | VBTLX | 52,533 |
| Distributions | Income | Savings | Cash | 262,500 | |
| Salaries | Income | Food & Dining | 16,740 | ||
| Salaries | Income | Office | 8,000 | ||
| Salaries | Income | Travel | 7,960 | ||
| SEP IRA | Income | Fitness | 3,600 | ||
| Dividends | Income | Health Insurance | 3,387 | ||
| Dividends | Income | Shopping | 4,848 | ||
| Interest | Income | Bills & Utilities | 3,850 | ||
| Interest | Income | Other Expenses | 7,000 |
To install the ChartExpo, add-on for Google Sheets, click this link.
The above steps show how easily one can create a Sankey Diagram in Google Sheets to present the fund’s flow. You can also use the ChartExpo Excel add-in to create Sankey Charts in Excel for visualizing the fund’s flow.
In the following video, you will learn how to create a funds flow diagram also known as Cash Flow Diagram.
In the coming section, we’ll address the importance of a Funds Flow Diagram.
You will surely agree when we say that extracting actionable insights from tables is so time-consuming and mentally exhausting.
You need intuitive tools to be fully data-driven. Yes, you read that right. You need tools that distill big data sets for you and create insightful visualization that are easy to interpret and analyze.
A Funds Flow Diagram which is an example of a Sankey Diagram provides you with a 360-degree view of the cash flowing in and out, irrespective of volume by providing you actionable insights from data.
Use this chart to identify the areas where you’re losing money before it reaches the intended recipient.
Also, investors can leverage the chart to establish the direction of the cash flows for insights into the health of specific stocks and sectors or the overall market.
Fund flow basically highlights or shows the cash flow movement in a financial system. It usually focuses on the examination of inflows and outflows of cash in a defined time period.
A Funds Flow Diagram displays insights into the flow of money from the source to the intended destination. This chart draws the reader’s attention to the enormous flows, the largest consumer, the major losses, and other insights.
Besides, it uses links and nodes to uncover hidden insights into relationships between critical metrics.
You’ll agree it’s important for banking & payments professionals to understand the flow of funds (FoF).
The flow of funds (FOF) diagram is critical in explaining your transaction and transaction flows. It shows the origination point, from where the money started its journey, and the route it took along the way to reach its destination, the termination point.
This is where a Funds Flow Diagram (Sankey Diagram) comes into play.
The visualization diagram can help you distill the flow of funds data into meaningful insights. And this can save tons of hours, which you can use to relax or execute other tasks.
How much did you enjoy this article?
Learn the importance of quantitative research design and discover different methods and tools to analyze and interpret your data.
Outperform your competitors. Learn what a competitive analysis is, what to include, and how to do it on Google Sheets with this competitive analysis sample.
What is a Likert scale rating? Click here to learn how to create a Likert scale survey using Google Forms and analyze survey data in Google Sheets.
