A cash flow template is designed to be the main tool that you will use to manage your finances day to day. The Sheetgo Cash Flow Template for Google Sheets is more than just a static spreadsheet. It’s a cashflow management system based on Google Sheets. This system includes an Accounts Payable spreadsheet, and an Accounts Receivable spreadsheet which are combined to create a Cash Flow. These three spreadsheets are connected using the Sheetgo add-on to update the data between them automatically. Take a look at the diagram below to understand how this system works:
Example: Sheetgo Cash Flow Template Sctructure
Once configured you will 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.
Example: Simple graphic that summarized your cash flow balance
Configuring your template
1. Install Sheetgo to be able to connect Google Sheets
Sheetgo is a add-on for Google Sheets, once installed you will be able to connect any spreadsheet in your Google Drive that is required to set up this template. Click on the button “Integrated with Google” below to start the installation:
2. Install the Cash flow template from the Sheetgo template gallery
From any Google Sheet (however we recommend that you create a new sreadsheet) open Sheetgo by clicking ‘Add-ons -> Sheetgo -> Start‘. Mouse over the green ‘+‘ icon then select the gold Sheetgo logo to ‘Use Template‘.
From the template gallery locate the Cash flow template and click the link to Install.
This will create three new sheets in your Spreadsheet: Instructions, AR Import, AP Import, and Cashflow. The Instructions sheet provides you with a step-by-step guide to configure your casfhlow template. AP Import and AR Import are linked to external spreadsheets that you will configure with your own accounts payable and receivable. Finally, the Cashflow combines Accounts Payable and Accounts receivable to create a dynamic cashflow, updated daily based on your own imports.
3. Configure the Cash Flow Template
Each template spreadsheet has an instructions tab that will explain step by step the process to fill in and configure the template. You’ll need to have your finances handy to fill out the accounts payable and accounts receivable templates with your revenue and expenses from the past few months. Once filled out you will then connect to the cash flow spreadsheet using Sheetgo.
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, and visit our blog to know more about Google Sheets. If you have had difficulty making this template work, please contact us through the help center and we will be happy to assist you with.