Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceFinancial Statements & ReportingStatement of Cash Flows

SpreadsheetFinancial Statements & ReportingFree

Statement of Cash Flows

An indirect-method cash flow statement built from two balance sheets and a few income figures, with checks that it ties to the change in cash.

Shown with sample data

Colour

Statement of Cash Flows

An indirect-method cash flow statement built from two balance sheets and a few income figures, with checks that it ties to the change in cash.

Net cash from operating
$86,550
Net cash from investing
-$45,800
Net cash from financing
-$27,000
Free cash flow
$38,550
Operating cash minus capex
Difference to balance-sheet cash
$0
Must be zero
Debt roll-forward check
$0
Must be zero
Retained earnings check
$0
Must be zero
Balance check, opening
$0
Must be zero
Net cash by activity
  • Operating$86,550
  • Financing-$27,000
  • Investing-$45,800

How to use it

  1. 1On Balance sheets, enter opening and closing balances for each line as positive numbers.
  2. 2On Other figures, enter net income, depreciation, any gain on asset sales, capital expenditure, sale proceeds, borrowing, repayments and dividends or owner draws.
  3. 3Read the Statement: operating, investing and financing sections and the net change in cash.
  4. 4Check Difference to balance-sheet cash is zero, then check the debt and retained-earnings roll-forward checks.
  5. 5If a check is not zero, look for a missing movement: a disposal, a new loan or an equity injection.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Profit is not cash. This statement starts from net income, adds back non-cash items, adjusts for changes in receivables, inventory, prepaid expenses, payables and accruals, then adds investing and financing flows. Every working-capital line is calculated from your opening and closing balance sheets, and built-in checks prove the statement ties to the change in cash and that debt and retained earnings roll forward.

Who it’s for

  • Year-end and quarterly financial statements
  • Explaining to owners why profit and cash differ
  • Loan applications and covenant reporting

What’s included

  • Statement sheet: Cash flows from operating, investing and financing activities.
  • Balance sheets sheet: Opening and closing balance sheets.
  • Other figures sheet: Figures from the income statement and the year’s records.
  • By activity sheet: Net cash and the number of entries for each activity.

How to use it

  1. 1On Balance sheets, enter opening and closing balances for each line as positive numbers.
  2. 2On Other figures, enter net income, depreciation, any gain on asset sales, capital expenditure, sale proceeds, borrowing, repayments and dividends or owner draws.
  3. 3Read the Statement: operating, investing and financing sections and the net change in cash.
  4. 4Check Difference to balance-sheet cash is zero, then check the debt and retained-earnings roll-forward checks.
  5. 5If a check is not zero, look for a missing movement: a disposal, a new loan or an equity injection.

Tips

  • An increase in an asset (receivables, inventory) uses cash; an increase in a liability (payables) provides cash.
  • Gains on asset sales are deducted in operating activities because the full proceeds appear in investing.
  • Free cash flow (operating cash flow minus capital expenditure) is the number owners and lenders watch most.

Questions

What is the indirect method?

It starts with net income and adjusts for non-cash items and working-capital changes to arrive at cash from operations. Most companies use it because it reconciles profit to cash.

What goes in investing and financing activities?

Investing: buying and selling long-term assets and investments. Financing: borrowing and repaying debt, issuing shares or owner contributions, and paying dividends or owner draws.

Why does my cash flow statement not balance?

Usually a balance-sheet movement is missing: a new loan, an asset disposal, an equity injection or a reclassification. The roll-forward checks point to which area to look at.

Related searchesstatement of cash flowscash flow statement templateindirect method cash flowoperating investing financing activitiesfree cash flowcash flow statement excel

Details

Format
Spreadsheet
Category
Financial Statements & Reporting
Sheets
4
Setup
10 min
Level
Advanced
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetFinancial Statements & ReportingFree

Statement of Cash Flows

An indirect-method cash flow statement built from two balance sheets and a few income figures, with checks that it ties to the change in cash.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Financial Statements & Reporting
Sheets
4
Setup
10 min
Level
Advanced
Price
Free

Your copy is private to you.

More financial statements & reporting templates

View all
Small Business Profit and Loss Statement3 sheets

Revenue

$54,650

Gross margin

64%

Net profit

$7,460

Net profit by month
$7,460
$6,365
$3,620
$3,080
$1,650
Nov 2026Oct 2026Sep 2026Jul 2026Jun 2026
SpreadsheetFinancial Statements & Reporting

Small Business Profit and Loss Statement

Monthly P&L against budget and last month, with gross and net margin and a six-month trend.

10 min setupPreview
Monthly Financial Dashboard2 sheets

Revenue this month

$655,000

Revenue, last 12 months

$7,013,000

EBITDA margin this month

16%

EBITDA by month
$57k
$38k
$62k
$79k
$78k
Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026
SpreadsheetFinancial Statements & Reporting

Monthly Financial Dashboard

One page that answers how the business did this month: revenue, margins, EBITDA, cash, DSO and customers against target, with 12-month trends.

10 min setupPreview
Trial Balance2 sheets

Adjusted debits

$57,150

Adjusted credits

$57,150

Difference

$0

ABCD
1AccountTypeDebitCredit
2BankAsset$18,400$0.00
3Accounts receivableAsset$6,200$0.00
4Prepaid insuranceAsset$1,200$0.00
5EquipmentAsset$9,000$0.00
Trial balance
SpreadsheetGeneral Ledger & Trial Balance

Trial Balance

Closing balances by account in debit and credit columns with a balance check and totals by statement section.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ