Cash Flow Statement Format In Excel With Formula ((full)) Free Download (2026)

To build an effective statement, you must understand the three standard sections defined by accounting principles like IAS 7:

Row 17: "Proceeds from Bank Loan" → Positive number. Row 18: "Dividends Paid" → Negative number. Row 19: "Repayment of Debt" → Negative number. Row 20: "Cash Flow from Financing" → Formula: =SUM(B17:B19)

To create a cash flow statement in Excel, you can use the following steps: To build an effective statement, you must understand

Row 22: "Net Increase / (Decrease) in Cash" → Formula: =B11+B15+B20 Row 23: "Opening Cash Balance" → Link from previous period's closing balance. Row 24: "Closing Cash Balance" → Formula: =B22+B23

Most small to medium businesses prefer the direct method because it lists actual cash sources and uses. Here is the layout you should build in Excel. Row 20: "Cash Flow from Financing" → Formula:

Even with a free template, users make errors. Here is how built-in formulas save you:

Stop using static, error-prone paper statements. Download our free template today, plug in your numbers, and watch your financial health come into focus. Even with a free template, users make errors

Tracks how the company is funded, including new loans, debt repayments, and dividend payments. Standard Excel Format (Indirect Method)

A cash flow statement is a financial statement that summarizes the inflows and outflows of cash and cash equivalents over a specific period. It provides a snapshot of a company's liquidity position and helps stakeholders understand its ability to generate cash and meet financial obligations. A cash flow statement typically consists of three main sections: