Statement of Cash Flows (Direct Method) Template
The formal statement of cash flows is one of the three core financial statements, alongside the P&L and balance sheet — and lenders, investors, and auditors often expect it in a specific format. This template uses the direct method, listing actual cash receipts and payments by activity, organized exactly the way it’s meant to be presented.
Included in the $7/mo Tools Club · Works in Excel or Google Sheets · Includes a built-in AI prompt
Who this is for
- Business owners preparing formal financials for a lender or investor
- Anyone whose accountant has asked for a statement of cash flows specifically
- Growing businesses moving beyond a simple cash flow tracker
- Students learning the direct method as taught in accounting courses
What's included
- Operating activities section listing actual cash receipts and payments
- Investing activities section for equipment and asset purchases/sales
- Financing activities section for loans, owner contributions, and distributions
- Automatic net change in cash and ending cash balance, tying to your balance sheet
Why use a template instead of starting from scratch?
The direct method requires organizing cash movement into three specific categories in a specific order — getting the structure wrong is one of the most common reasons a lender or accountant sends financials back for revision. This template already has the correct structure built in, so you fill in numbers instead of guessing at format.
How to Use This Template
Download and open in Excel or Google Sheets
Requires a Tools Club membership — log in first to access the file.
List cash received from customers and cash paid to suppliers and employees under Operating
This is actual cash movement, not revenue or expenses recognized on the P&L.
List equipment or asset purchases and sales under Investing
Anything involving buying or selling long-term assets belongs here.
List loan proceeds, repayments, and owner contributions or distributions under Financing
This captures how the business is funded, separate from its operations.
Confirm the ending cash balance matches your balance sheet
This is the built-in check that your statement of cash flows is internally consistent with your other financials.
Built-in AI prompt
Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on whether your operating cash flow is healthy relative to your reported profit, and what the financing and investing sections suggest about how the business is being funded, no accounting background required.
Common Mistakes to Avoid
Mixing this up with the cash flow tracker
A simple cash flow tracker is for ongoing monitoring; this formal statement follows a specific structure expected by lenders, investors, and GAAP-based reporting.
Recording revenue instead of cash received
The direct method specifically wants actual cash collected from customers, not revenue recognized — the two can differ significantly if customers pay slowly.
Misclassifying a transaction’s category
Loan proceeds go under Financing, not Operating; equipment purchases go under Investing, not Operating — misclassifying these is the most common formatting error.
Not reconciling to the balance sheet cash balance
Your statement’s ending cash balance must exactly match the cash line on your balance sheet as of that date — if it doesn’t, something was missed or double-counted.
Frequently Asked Questions
Related Templates
Related Resources
Want the Full Template Library?
70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.
Join the Tools Club