Cash flow statement template
A cash flow statement shows where your cash came from and where it went over a period, split into operations, investing and financing. This free template starts from net profit, adjusts for items that aren't cash, and ends with the cash you should see in the bank, so you can check it against your statements.
Updated November 2026
What does the template look like?
Type your numbers in the white cells. Totals and results add themselves in Excel. Here it is with sample figures, so you can see how it fills in.
| Line | This year | Last year |
|---|---|---|
| Cash from operations | ||
| Net profit | $61,600.00 | $49,500.00 |
| Add back depreciation | $5,500.00 | $5,000.00 |
| Less increase in accounts receivable (negative if up) | -$4,700.00 | -$2,100.00 |
| Less increase in inventory (negative if up) | -$2,600.00 | -$1,500.00 |
| Plus increase in accounts payable (negative if down) | $600.00 | $900.00 |
| Plus increase in taxes payable (negative if down) | $900.00 | $300.00 |
| Net cash from operations | $61,300.00 | $52,100.00 |
| Cash from investing | ||
| Equipment and vehicles bought (negative) | -$8,000.00 | -$42,000.00 |
| Assets sold | $0.00 | $6,000.00 |
| Net cash from investing | -$8,000.00 | -$36,000.00 |
| Cash from financing | ||
| Loans received | $15,000.00 | $0.00 |
| Loan principal repaid (negative) | -$9,600.00 | $0.00 |
| Owner contributions | $0.00 | $5,000.00 |
| Owner draws or distributions (negative) | -$42,000.00 | -$36,000.00 |
| Net cash from financing | -$36,600.00 | -$31,000.00 |
| Net change in cash | $16,700.00 | -$14,900.00 |
| Check | ||
| Cash at the start of the period | $31,500.00 | $46,400.00 |
| Start cash | $31,500.00 | $46,400.00 |
| Cash at the end of the period | $48,200.00 | $31,500.00 |
Why does profit differ from cash?
Because the P&L counts things when they're earned or incurred, and cash counts them when money moves. A big sale on 60-day terms is profit now but cash later. A new truck is cash out today but shows up on the P&L slowly, as depreciation. Loan payments and owner draws cost cash but aren't expenses at all. The cash flow statement lines all of that up.
How do I fill it in?
Start with net profit from the profit and loss statement. Add back depreciation, then adjust for changes in receivables, inventory and payables by comparing two balance sheets. Then list equipment bought or sold, loans in and out, and owner money in and out. The ending cash should match your reconciled bank balance.
Do I need one for taxes?
No IRS form asks for it. Lenders often do, and it's the clearest way to answer "we made money, so where did it go?" For the months ahead rather than the past, use the 13-week cash flow forecast.
General information, not tax advice for your situation.
Want a plan for this year?
We run your numbers and show you the options.
See our tax planning and CFO serviceWhat are the three sections of a cash flow statement?
Operations (the day-to-day business), investing (buying and selling equipment and other assets) and financing (loans and owner money in and out).
Why is my ending cash different from my bank balance?
Usually an unrecorded transaction, an account left out, or a balance sheet that isn't reconciled. Reconcile the bank first, then rebuild the changes.
Is a cash flow statement the same as a forecast?
No. This statement looks back at what happened. A forecast looks forward week by week.
Tell us what's messy. We'll tell you what it takes.
Tell us what you need and get a fixed price before any work starts. No pressure and no contract.