What is cash flow management?

Simply put, cash flow is the money going in and out of a business. Think payments, expenses, invoicing, etc. Cash flow management is the careful tracking and analysis of these transactions. There’s no dispute that finances are best tracked in a spreadsheet. You could track cash flow in a static spreadsheet, but this will require a lot of manual work and manipulation when what you really want is a system that will make visualizing and reporting financial data a breeze.

Use spreadsheets to manage cash flow

At Sheetgo, we are committed to developing applicable solutions for your business. We don’t just provide you with our spreadsheet enhancing add-on, and leave you to it, we provide you with the same real-life solutions that we use ourselves! We created a cash flow template to use as the main tool for managing finances day to day. The Sheetgo cash flow template for Google Sheets is not just a static template with pretty fonts and colors. It’s a dynamic, automated cash flow management system based on Google Sheets. Our system includes a Payments spreadsheet and a Receipts spreadsheet which are connected using Sheetgo to a third Cash Flow spreadsheet. These three spreadsheets are connected using the Sheetgo to automatically update the data that flows between them. Take a look at the diagram below to understand how our system works:

Follow the steps in this simple tutorial to have a single tab in your cash flow sheet that summarizes monthly revenue and costs which are then summed to your monthly cash movement and bank balance. This information is included in a simple graphic that allows you to see these variables daily and can easily be included in a Google Site portal or report for management and investors.

Let’s Get Started

Step 1. Install the template

Use the button below to install the Cash flow template. You will be asked to log in with your Google account to make sure that your Google Sheets are available. At the same time, your Sheetgo account will be created. You will need to have Sheetgo enabled on your Google Sheets account to use this template.

After logging in, click on the ‘Use template‘ button to configure the Cash flow template. Sheetgo will automatically create the system by connecting the 3 spreadsheets called “Payments“, “Receipts” and “Cash Flow“ and install them into your Google Drive.

Example

Step 2. Open all spreadsheets

Once configured, you will see the Network View that exactly shows how the system is designed. To use the template, click on all the spreadsheet icons to open the two input spreadsheets “Payments” and “Receipts”, and the master spreadsheet “Cash Flow”

Example 

Step 3. Fill out the input spreadsheets

In each of these spreadsheets, you will find two different tabs. One with instructions and one with sample data we provided for your payments and receipts. Overwrite this dummy data with your own information.

Example

Step 4. Configure the Cash Flow Template

Once filled out your payments and receipts, go back to the Sheetgo Web Application to update the connections in place. This will automatically bring the data inside your “Cash Flow” master file. Let’s break down the components of this spreadsheet, designed for you to easily monitor your cash balance:

  • Instructions
  • Cash Flow Analysis
  • Monthly Cash Flow Chart
  • Receivables Analysis
  • Payables Analysis
  • Receipts
  • Payments

Example

Congrats! 🙂

You’ve configured your Google Sheets cash flow template. Feel free to adapt it as you see fit to meet the needs of your business. If you have had difficulties making this template work, please chat with us using the bubble on the right below and we will be happy to assist you with setting it up.

Share This