Cash Flow Template

Use this Google Sheets based template to manage the day-to-day finances of your organization.

Click “Use Template” below to start using and scroll down this page for instructions on how to configure.

How it works

Input expenses are in the Accounts Payable sheet and revenue in the Accounts Receivable sheet, then use Sheetgo to automatically combine them in your Cash Flow sheet.

Get your finances under control with this easy to use spreadsheet-based template.

1

 

Open 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.

After logging in, click on “INSTALL”.

2

 

Creating the Template

Click on the install button. Sheetgo will create the system by connecting the 3 spreadsheets called “Payments“, “Receipts” and “Cash Flow“. Read their descriptions to understand their functions in this template.

3

 

Open all Spreadsheets

Click on all three spreadsheet icons to open the spreadsheets that are necessary¬†to create this template and read their instructions. Finish this step by clicking on the button “open spreadsheet”.

4

 

Updating the Template

Click on the red arrows on the right of Payments and Receipts. Doing this will bring data from Payments and Receipts to your Cash Flow!

You can also automate their updates by clicking on connections > edit connection.

Get started today

Copyright © 2016-2018 Sheetgo