How to Create a Funds Flow Diagram to Analyze Fund Flow? (2024)

You’ll agree it’s important for banking & payment 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:

Table of Content:

1. What is a Funds Flow Diagram?
2. How to Analyze Data using Funds Flow Diagram?
3. How to Create a Funds Flow Diagram in Google Sheets?
4. Video Tutorial: How to Create a Funds Flow Diagram in Google Sheets?
5. Importance of a Funds Flow Diagram
6. Wrap Up

Before diving right into the how-to guide, we’ll address the following question: What is a Funds Flow Diagram?

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 a 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 that shows the 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 uses nodes and links to find relationships between important metrics.

The bigger the quantity of data under observation, the bigger the size of a node.

So, how can you analyze data using Funds Flow Diagram?

How to Analyze Data Using Funds Flow Diagram?

A Funds Flow Diagram visualizes the fund’s inflow and outflow of a business to get the attention of stakeholders to the most important flows, losses, etc.

The fund’s 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, the 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.

How to Create a Funds Flow Diagram in Google Sheets?

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.

• ChartExpo is cloud-hosted, which makes it extremely light. You have a 100% guarantee that your browser won’t be slowed down.
• You can export your insightful, easy-to-read, and intuitive charts in JPEG, PDF, SVG, and PNG format.
• ChartExpo add-on is only $10 a month after the end of the trial period.
• The easy-to-use app has an in-built library with many easy-to-customize and ready-made charts for your data stories.

In the coming section, we’ll take you through how to create a funds flow diagram using the Sankey Diagram in Google Sheets to present and analyze funds flow.

You don’t want to miss this!

Example

This section will use a Funds Flow Diagram (Sankey Diagram) to display insights into the table below.

To install the ChartExpo, add-on for Google Sheets, clickthis link.

• Open your Google Sheets application.
• Open the worksheet and click theExtensions menu.
• Then go to Charts, Graphs, & Visualizations by ChartExpo.
• Click the Open button in the dropdown.

• Click theAdd New Chartbutton to access your fully stocked library of charts.

• Once ChartExpo is loaded, you will see a list of charts. Look for “Sankey Chart.”

• Select the sheet holding your data and select the Metrics Fill in the numerical numbers (in our case, we’ll use spendings).
• Select the Dimensions button and fill in the dimensional data (in our example, we’ll use tax breakage, taxes, spending sources, income, and income sources), as shown below.

• Finish the simple process by clicking the Create Chart button.

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.

Video Tutorial: How to Create a Funds Flow Diagram in Google Sheets?

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.

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.

FAQs:

What is a fund flow?

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.

What is a flow of funds diagram?

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.

Wrap Up

You’ll agree it’simportant 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.