Skip to content
Cash Flow Statement cover: a sample sheet with cash at the start, from operations and from investing and a column chart, beside the Dashboard and Opening tabs

Cash Flow Statement

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

This cash flow statement is for owners and managers who need to know where the money went, not just what profit was booked. The Opening tab holds the bank balance at the start of the period. The Cash movements tab logs each payment with its date, description, section and an amount that is positive for money in and negative for money out.

The Dashboard shows the opening balance, net cash from operations, investing and financing, and the cash at the end. A column chart compares money in and money out for each section. The sample period covers the first two weeks of November 2026 for a small food business, so overwrite them with your actual bank activity.

Useful for

  • Checking whether the bank balance can cover payroll
  • Explaining a fall in cash to the owner
  • Planning a loan repayment against operating cash

What's included

  • 4 tabs: Dashboard, Opening, Cash movements, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Opening: a table
  • Cash movements: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Opening tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How is cash flow different from profit?

Profit counts sales and costs when they are recorded, while cash flow counts money when it moves. A customer who owes you money adds to profit but not yet to cash. A loan received adds cash but is not profit. This sheet tracks the cash side.

Where do loan repayments belong?

The principal part of a repayment is financing, and the interest is usually operating. Splitting them takes a little care, so use the figures from your loan statement. Keeping them on separate rows makes the split easy to see.

Should the cash at the end match my bank balance?

It should, if every payment that cleared the bank is logged and the opening balance is correct. Compare the two figures at the end of each period. Any gap usually means a payment is missing or was logged on the wrong date.

  • #profit-and-loss
  • #cash-flow-statement
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More profit and loss templates

See all 12

Also in Finance

All finance templates
Get this template

Preparing your template…