Home›Templates›Accounting & Small Business Spreadsheets›Cash Flow Statement
Preview of the Cash Flow Statement template

Sample text in [brackets], replace with yours · Accounting & Small Business Spreadsheets

Free template

Cash Flow Statement Format (Excel & PDF)

Indirect method: net profit adjusted for non-cash items and working capital, then investing and financing, with a check against the balance sheet.

✓ A4✓ Indirect method✓ Current + previous year✓ Excel & PDF

Opens in your browser. No Excel needed, no signup.

Free for personal and commercial use · No watermark · Updated November 2026

Guide

About this cash flow statement template

A cash flow statement shows where a business's cash came from and where it went during a period, in three groups: operating activities (the day-to-day business), investing activities (buying and selling assets and investments) and financing activities (capital, loans, interest and dividends or drawings). This template uses the indirect method, which most companies use: it starts from net profit before tax, adds back non-cash items such as depreciation, adjusts for changes in receivables, inventory and payables, and deducts tax paid. The three totals give the net change in cash, and a check line confirms that closing cash matches your balance sheet.

How to prepare a cash flow statement

  1. 1

    Click "Edit online", or download the Excel file.

  2. 2

    Enter net profit before tax and the non-cash adjustments (depreciation, interest expense, gains or losses on asset sales).

  3. 3

    Enter the change in each working capital item; increases in receivables or inventory are negative.

  4. 4

    Fill in investing and financing cash flows, with cash going out as negatives.

  5. 5

    Enter opening cash, then check that closing cash matches the cash and bank figure on your balance sheet.

Tips for an accurate cash flow statement

Use two balance sheets

Working capital changes come from comparing this year's and last year's balance sheets.

Watch the signs

An increase in an asset uses cash (negative); an increase in a liability provides cash (positive).

Interest placement

Under IAS 7, interest paid may be operating or financing; whichever you pick, use it every year.

Cash is not profit

A profitable business can still run short of cash if customers pay slowly or stock builds up.

Frequently Asked Questions

Yes. Download the Excel or PDF version, or edit it online for free, with no signup and no watermark.

The direct method lists actual cash received from customers and paid to suppliers and staff. The indirect method starts from net profit and adjusts it. Both give the same net cash from operating activities; this template uses the indirect method.

The layout follows the usual IAS 7 / Ind AS 7 / AS 3 structure of operating, investing and financing activities. Check with your accountant for the exact presentation your company must use.

A difference usually means a missing item, a sign error, or an opening cash figure that does not match last year's balance sheet.

Tools that help

📗

Excel to PDF

Convert Excel spreadsheets to PDF with all sheets preserved

Use Tool→
📊

PDF to Excel

Extract tables from PDF into editable Excel spreadsheets

Use Tool→
%

Percentage Calculator

Calculate percentages, increase, decrease, and ratios

Use Tool→
🏦

Loan Calculator

Calculate EMI, total interest, and loan amortization

Use Tool→

More accounting & small business spreadsheets

Expense Report template preview

Expense Report

Claim business expenses with category totals and advances.

ExcelPDF
Inventory / Stock Sheet template preview

Inventory / Stock Sheet

Stock in, stock out, closing stock and reorder alerts.

ExcelPDF
Monthly Business Budget template preview

Monthly Business Budget

Budget vs actual for income and expenses, with profit.

ExcelPDF
Cash Book template preview

Cash Book

Daily cash in and out with a running balance.

ExcelPDF
Price List template preview

Price List

Products and services by category, with discounts.

ExcelPDF
Daily Sales Report template preview

Daily Sales Report

Bills, payment methods and end-of-day cash check.

ExcelPDF
Salary Sheet (Payroll) template preview

Salary Sheet (Payroll)

Monthly payroll for all staff: gross, deductions, net pay.

ExcelPDF
Project Plan (Gantt Chart) template preview

Project Plan (Gantt Chart)

Tasks, owners, dates and a 12-week Gantt chart.

ExcelPDF
Income & Expense Tracker template preview

Income & Expense Tracker

Small business money in and out, running balance, profit by category.

ExcelPDF
Profit and Loss Statement template preview

Profit and Loss Statement

Income statement with gross, operating and net profit.

ExcelPDF
Balance Sheet template preview

Balance Sheet

Assets, liabilities and equity with a balance check.

ExcelPDF
Trial Balance template preview

Trial Balance

Every ledger balance in debit and credit, with totals that must agree.

ExcelPDF
Trading Account template preview

Trading Account

Dr/Cr trading account that works out gross profit or gross loss.

ExcelPDF
Cost Sheet template preview

Cost Sheet

Prime cost to sales, with cost per unit at every level.

ExcelPDF
Bank Reconciliation Statement template preview

Bank Reconciliation Statement

Match the cash book to the bank statement, with an automatic check.

ExcelPDF
Ledger template preview

Ledger

Ledger account with running Dr/Cr balance, plus a T-format sheet.

ExcelPDF