The Sheetgo Cash Flow template helps you manage and analyze business cash flow with ease. It consolidates receipts and payments into a single spreadsheet and provides automated dashboards and reports — giving you real-time visibility of money flowing in and out of your company.

How the Workflow is Structured

The workflow has:

Receipts form – Records money coming into the company, such as sales, clients, or loans.
Payments form – Records money going out, such as supplier payments, wages, or taxes.
Cash Flow spreadsheet – Automatically generated from the Receipts and Payments tabs to show balances, inflows, and outflows.

Steps to use the template

Step 1: Install the Template

Install the template from this link: Cash flow
Once installed, the workflow will open in your Sheetgo workspace at app.sheetgo.com.
You’ll see helpful notes in the right-side panel of your workflow.

👉 Before starting, delete the sample data in the Receipts and Payments tabs of the spreadsheet (but keep the headers).

Step 2: Share your forms

Share the Receipts form with team members who record incoming payments.
Share the Payments form with those responsible for expenses.

👉 Refer to this article to learn how to share forms.

👉 New entries will appear in the tabs of the Cash Flow spreadsheet.

Step 3: Enter your data

Double click Cash Flow (master sheet).
In the Inputs tab, input the start date and start balance.

Step 4: Submit forms for Receipts and Payments

Receipts form fields

Client name – Enter the name of the client receiving the invoice.
Invoice # – Enter the invoice number for this transaction.
Invoice amount ($) – Total billed amount on the invoice.
Amount received ($) – Total payment received from the client.
Date received – Select the date when the payment was received.
Product – Name of the product or service provided.
Product category – Category this product or service belongs to.
Notes – Add any additional comments or transaction details.

The Receipt Form is used whenever you receive an amount.

👉 In short: Fill out the form each time you record incoming payments. All responses are automatically saved in the Receipts tab of the Cash Flow spreadsheet.

Payments form fields

Supplier – Enter the name of the supplier making the invoice payment.
Invoice # – Provide the invoice number associated with this payment.
Invoice amount ($) – Full amount billed on the invoice.
Amount paid ($) – Amount actually paid toward the invoice.
Date paid – Select the date the payment was made to the supplier.
Category – Choose or enter the category that best describes this payment.
Notes – Add any relevant comments or details about this transaction.

👉 In short: Fill out the form each time you record outgoing payments. All responses are automatically saved in the Payments tab of the Cash Flow spreadsheet.

Step 5: View your reports

Cash Flow Analysis: Monthly summary of balances, receivables, and payables.
Monthly Cash Flow Chart: A trend line showing fluctuations in cash flow over time.
Receipts Analysis: Breakdown of income sources by category.
Payments Analysis: Breakdown of spending by category.