What is cash flow management?
Simply put, cash flow is the money going in and out of a business.
Use spreadsheets to manage cash flow
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
After logging in, click on the ‘Use template‘ button to configure the Cash flow template.
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”.
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.
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:
- Cash Flow Analysis
- Monthly Cash Flow Chart
- Receivables Analysis
- Payables Analysis
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.