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.

Example figures
LineThis yearLast 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 service
Questions

Still wondering?

Ask anything else on a free 30-minute call.

Book a call
What 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.

Get started

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.

Get a free quote

Your name, plus an email or a phone number, whichever you prefer.

A sentence or two is plenty. Please don't include Social Security numbers, bank or card numbers, or tax documents here.

Thanks. This is a design preview, so nothing was sent.