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. This tab summarizes monthly revenue and costs, which are then summed to your monthly cash movement and bank balance. A simple graphic shows this information and therefore allows you to see these variables on a daily basis. On top of that, you can include that data on a Google Site portal or report for management and investors.
Let’s get you started
Step 1. Install the template
Use the button below and install the Cash flow template. Login using your Google account and simultaneously make sure your Google Sheets are available. At the same time, we create your Sheetgo account. You need to have
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 find two different tabs. One with instructions and one with sample data we provided for your payments and receipts. Overwrite this sample data with your own information.
Step 4. Configure the Cash flow template
Once you filled out your payments and receipts, go back to the Sheetgo Web Application to update the connections in place. This automatically brings the data inside your “Cash Flow” master file. Let’s break down the components of this spreadsheet, with which you can easily monitor your cash balance:
- Cash Flow Analysis
- Monthly Cash Flow Chart
- Receivables Analysis
- Payables Analysis
You 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.