Sheetgo’s cash flow template combines receipts and payments data automatically, enabling you to:
Generate an updated cash flow statement.
Monitor the money flowing in and out of your company.
Save time on data collection, copy-pasting, and email sending.
How does the cash flow template work?
Sheetgo automations keep data flowing between 3 spreadsheets:
Receipts—Cash Flow: This is where everyone records money coming into the company. For example, customer sales, clients, or bank loans.
Payments - Cash Flow: This is where everyone records money leaving the company. For example, operational costs, supplier payments, staff wages, or taxes.
Cash Flow (master sheet): Data flows into this file directly from the payments and receipts spreadsheets.
How to use the template?
Step 1: Install and explore
If you haven't done so already, install the Cash Flow template.
Allow a few minutes as Sheetgo saves a copy of the files to your Google Drive and creates the automations. Sheetgo will open the template in the Workflow view.
To hide the sidebar, click the X button on the top right-hand side of the screen.
Step 2: Enter your data
Double click Cash Flow (master sheet).
In the Inputs tab, input the start date and start balance.
Click the file icon on the right sidebar, then open Payments - Cash Flow.
Change sample data in the Payments tab.
Double-click on the Receipts - Cash Flow document.
Change sample data in the Receipts tab.
Step 3: Update your connections
Go to the Worfklow tab and click "Run all automations" to update the Cash Flow spreadsheet and the Dashboard.
Open the master sheet. Then open the Cash flow analysis, Monthly cash flow chart, Receipts analysis, or Payments analysis, where data from the two input files are processed to give you a visual overview.
Step 4: Share files
To share any file in your workflow, or share the entire workflow to collaborate with another Sheetgo user.
Step 5: automate transfers
Automate your workflow now to always have the most recent data into your master sheet.