Skip to Content

Top 6 FREE Cash Flow Template Google Sheets of 2024 (+How To Create One)

Posted on Last updated:

Google Sheets is the top spreadsheet program for organizing and analyzing finances in tabular form. It comes with hundreds of functions, graphs, and state-of-the-art formatting tools to create a cash flow template.

Are you finding it challenging to track your business’s income and expenses?

Maintaining a cash flow sheet is very crucial for a business. By tracking your cash flows, you can easily manage your financial transactions and explore new opportunities for your business to grow.

In this article, let us discuss top 6 FREE Cash Flow Template Google Sheets. We will also learn the steps to create a cash flow spreadsheet from scratch, so make sure to read the article till the end.

Why is a Cash Flow Template created using Google Sheets a must-try?

A cash flow template helps any business monitor its financial performance. You can create it using spreadsheet programs like Microsoft Excel and Google Sheets.

In contrast to other programs, Google Sheets can be the best option for the following reasons. 

  • Robust Reporting – Google Sheets offers a range of charts and graphs. Additionally, you can use tools like Pivot Table to summarize massive datasets and gain insights into your cash flows.
  • Real-time Collaboration – You can share your cash flow template with unlimited users. All of the edits made by each user are saved and can be accessed using the Version History tool. Moreover, Google Sheets allows you to assign specific roles to each user. They can view, edit, or comment based on their role.
  • Ease of Use – An intuitive and beginner-friendly user interface is the key selling point of Google Sheets. It has a very short learning curve. All of the essential tools and functions are accessible through the main menu and toolbar section. Simply put, anyone can quickly add and edit the information.
  • Extensive Customization – The cash flow templates in Google Sheets can be easily customized according to user preference. From adding a company logo to changing the text or cell background colors, everything is possible with a click of a button. 
  • Cost-effective – Unlike Cash Flow calculator apps, Google Sheets is totally free to use. It is a cost-effective solution for small businesses. You will get access to nearly all premium tools without any limitations.

The list doesn’t end here.

You can access Google Sheets from anywhere in the world as long as you have an active internet connection.

Top 6 FREE Cash Flow Template Google Sheets

Many cash flow templates are available online for Microsoft Excel and Google Sheets. We understand that it will be time-consuming and less efficient for you to test each template to find the perfect match for your needs.

So, we decided to do the heavy lifting for you. Here is the list of free-to-use cash flow templates in Google Sheets.

#1 – Small Business Cash Flow Template by Software Accountant

Download FREE Cash Flow Template Google Sheets [SoftwareAccountant]

Click Here To Use This Template!

This monthly cash flow template by SoftwareAccountant comes with an attractive design.

You can download and use the template for free without any limitations.

Make sure you enter the income and expenses as per the predefined sections to track your organization’s financial condition. At the bottom, you also have an “Annual Ending” section, which calculates the net cash increase/decrease, providing a comprehensive overview of your financial status.

You can customize the template by adding your company information, like name, logo, address, contact details, etc.

Feel free to add more sections to this template and include your unique finances.

#2 – Financial Worksheet by Template.net

Click Here To Use This Template!

This is a simple template for small business cash flow management. You will hardly take a few minutes to learn and use this template.

It is also a monthly cash flow template. You can download and customize it as per your requirements by adding the logo, company name, address, etc.

The template uses formulas to calculate monthly and yearly expenses. Avoid editing the cells containing formulas; otherwise, the template won’t work as expected.

#3 – Cash Flow Statement by Vertex42

Click Here To Use This Template!

This cash flow template from Vertex42 helps you track whether your business was profitable or experienced losses over the given period.

Enter your income and expenses into the table to calculate the change in cash over time.

You can enter operational costs, sales made over time, dividends, and cash borrowed.

The template is pretty straightforward. But make sure you spend some time learning all the predefined sections. You can add more as per your requirements, but make sure you do not mess up with the cells holding the formulas.

#4 – Cash Flow Analysis

Click Here To Use This Template!

Business owners can use this advanced template to know when there will be a cash shortfall or excess cash. 

This is a standard cash flow template with an optional line of credit. So, this template helps in managing the finances of a company by allowing them to borrow funds as and when needed. 

You can record the accounts receivable and accounts payable data. The hourly period earnings of each employee can also be recorded. 

By comparing money coming in and money going out, this template shows the business owner how the company’s finances are performing over time.

Note that the template is fully automated using built-in functions; avoid editing the cells holding the formulas.

#5 – Quarterly Cash Flow Projections Template

Click Here To Use This Template!

Are you looking for a template to track your cash flow on a quarterly basis? 

The best part of this template is that it can help you with the estimated, actual, and variance of different financial sections, thereby offering valuable insights into planned versus actual outcomes.

It provides detailed cash flow information for each quarter, enabling thorough analysis.

You can download the template and customize it as per your requirements. Make sure to add your company name before sharing it with others.

#6 – 3-Year Cash Flow Statement by SmartSheet

Click Here To Use This Template!

Last but not least, this template helps you compare the financial performance during the previous three years.

You can also maintain your cash flow separately on a monthly basis.

The template is simple to use and comes with clear instructions. You can customize it as per your needs.

Each sheet of this template is divided into sections for operations, investing, and financing activities. You need to enter the income and expenses in each section, and the template will do all the calculations for you.

Similar to other templates on this list, a few cells are holding the formulas, so avoid editing those for the proper working of the template.

How to Create a Cash Flow Google Sheets Template

We have seen some helpful Cash flow templates for Google Sheets in the above section.

However, if you are not pleased with the templates provided, you can create one using the powerful tools in Google Sheets. 

You will find all of the useful tools in the main menu and toolbar section of Google Sheets. We will use a few of them in the following section to create the template from scratch.

Here’s the template for your reference,

Now, without any further ado, let’s begin.

STEP #1 – Creating the Header

A Header is an essential part of any Google Sheets template. A properly named header helps users understand the purpose of the template as soon as they open it.

Here are the steps,

  • Open a new Google Sheet by clicking here
  • Select the entire first row
  • Increase the height as per your preference
  • Change the cell background color to dark blue (Hex Code – #001149)
  • Change the font color to White
  • Click on the cell “A1“
  • Type “Monthly Cash Flow” 
  • Increase the font size to 23
  • Make the font bold

Our header will look like below,

STEP #2 – Add the Tables for various Budgets

We can include several budget categories to track the cash flowing in and out. 

Here, we will include operations, investments, Finance, etc.

Let’s add the Operations section,

  • Select the cell “A4“
  • Now, type “Operations“
  • Make the font bold
  • Increase the font size to 16
  • Change the font color to dark blue (Hex Code – #001149)

Next, we need to create the vertical section of the first table.

Here are the steps:

  • Click on the cell “A7”
  • Type “ + “
    (Make sure to enter the space before and after the “+” symbol)
  • Now, select the cell “A8” and type “Cash Sales”
  • Repeat the above steps and complete the table as shown below,

Since we have to create a Monthly Cash Flow template, we will have to add the months to fulfill the objective. For that,

  • Select the cell “C6“
  • Enter “January“
  • Next, click the cell “D6” and type “February“
  • Repeat the above steps and complete the header as shown below,
  • For the column header, you need to enter the following details

The table header is ready. Let’s apply the formatting.

  • Select all the cells from “A6” to “O6“
  • Change the cell background color to light gray (Hex Code – #f3f3f3)
  • Select the entire header range as shown in the previous image
  • Change the cell background color to light gray (Hex Code – #f3f3f3)
  • Repeat the above steps for the following range “C11:O13“
  • Next, select the range as shown below,

Now, we need to ensure the monthly total and yearly total is automatically calculated using the SUM function.

To calculate the monthly total, we will use the following formula,

Monthly Operations Cost = Total Cash Generated – Total Expenses

Here are the steps,

  • Select the cell “D14“
  • Type “=sum”
  • Choose the first option from the popup or press “Tab” on your keyboard
  • Provide the cell range “C8:C13“
  • Complete the bracket using “)“
  • Type “–“
  • Next, enter “sum“
  • Select the first option from the popup
  • Provide the cell range “C11:C13“
  • Complete the parenthesis using “)“
  • Press the “Enter” key

Our final formula will be as follows,

=SUM(C8:C9)-SUM(C11:C13)

Repeat the same formula for the rest of the months. Refer to the following image,

Similarly, to find the yearly total, here are the steps:

  • Select the cell “O8“
  • Type “=sum”
  • Choose the first option from the popup
  • Replace the “value” argument with the cell reference “C8:N8”
  • Complete the bracket using “)“
  • Press the “Enter” key

Here’s how the final formula looks,

=SUM(C8:N8)

Repeat the above steps for the rest of the cells as shown below,

Next, use the following formula to find the sum of the yearly total.

=SUM(O8:O13)

Finally, let’s make sure that when we enter values in the table, they will automatically be converted to currency, and a dollar ($) symbol will appear at the beginning.

  • Select the table range as shown below
  • Go to the main menu
  • Click on the “Format” tab
  • Choose the “Number” option from the popup
  • Click the “Accounting” formatting option

That’s done. Our table to find the cash flow through operations is ready.

You need to repeat the above steps to create two more tables. Refer to the following image.

STEP #3 – Adding the Annual Summary Section

Adding an “Annual Ending” section is essential because it gives you an idea about the total cash increase/decrease and the closing balance at the year’s end.

To add this section, 

  • Select the cell “A4“
  • Now, type “Operations“
  • Make the font bold
  • Increase the font size to 16
  • Change the font color to dark blue (Hex Code – #001149)
  • Next, complete the horizontal header as shown below
  • Similarly, complete the vertical header as shown below,

Once the table is ready, we need to format it. Let us use the same color code we used for the tables in the previous section.

Note that you also need to change the number formatting to “Accounting” so that the values entered will be represented as the currency. You can refer to the previous section for the steps.

Finally, to find the decrease or increase in the cash flow for the given month, we will use the following formula.

Cash Flow Increase/Decrease = (Operations Total + Investment Total) – Finances Total

For January, cell “C14” includes Operations Total, “C22” includes Investment Total, and “C30” includes Finances Total.

So, our formula for the January month will be,

Cash Flow Increase/Decrease = (C14+C22)-C30

Insert the formula in the Annual Ending table in the cell “C38”.

=(C14+C22)-C30

To apply this formula for the rest of the months, here are the steps:

  • Click on the cell “C38“
  • Hover over the Fill Handle icon as shown below
  • Click on it and drag the formula to the end of the table

STEP #4 – Formatting the Template

This is the final step; here, we will format the template using built-in options.

You can use the toolbar section to change the font color, cell background color, border style, and much more.

Based on our Google Sheets expertise, we have formatted the template as shown below.

To download the template we created, you can click on the following link.

Click Here To Make A Copy!