A cash flow statement template is only as good as the numbers you put in it. BankXLSX converts your PDF bank statements into clean Excel rows with running balances, so the operating, investing, and financing totals you drop into the template come from the bank record instead of from memory. Upload a statement, download a spreadsheet, and fill the template in minutes. Start free, no credit card.
Last updated July 2026
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
A cash flow statement template has four blocks: an opening cash balance, then one section each for operating, investing, and financing activities, and finally a net change in cash that carries down to a closing balance. Each section lists its cash inflows as positive numbers and its outflows as negative, with a subtotal. The template only works if the closing balance it calculates matches the closing balance on your bank statements, which is why the fastest way to fill one is to convert the statements first and total the classified rows.
Downloading a template takes a minute. Filling it with numbers that reconcile is the part that stalls.
The template has rows for cash from customers and cash to suppliers, but those totals live scattered across months of PDF statements.
The closing balance the template calculates disagrees with the bank. Usually a transfer was counted twice or an account was left out.
Rows exist for investing and financing, but deciding which withdrawals belong there means reading every transaction description.
Without a repeatable way to get transactions into a spreadsheet, next month means starting the same manual process again.
Convert the statements, classify the rows once, and the template totals follow.
Date, description, amount, and running balance, ready to sum with a SUMIF once each row carries a section tag.
The running balance comes straight from the statement, so the template closing balance can be checked against the source.
Convert next month statement the same way and paste the rows underneath. The template formulas keep working.
Stack checking, savings, and card statements so the template reflects the whole business rather than one account.
No software to install and no credit card to start.
Upload each monthly PDF and download the transactions as an XLSX or CSV with the running balance intact.
Tip: Convert every account, not just checking.
Add a column tagging each row operating, investing, or financing, remove internal transfers, then total each tag.
Tip: A SUMIF on the tag column gives you the three subtotals.
Paste the subtotals into the template, then check that opening balance plus net change equals the closing balance on the bank statement.
Tip: If it is off, look for a transfer counted on one side only.
Every usable template follows the same skeleton, whether you build it yourself or download one. Here is the layout and a worked example.
You need a cash flow statement for a lender, an investor, or your own planning, and the template is the format they expect to see.
Producing a monthly cash flow statement for clients whose accounting software reports are incomplete or not yet reconciled.
Using last twelve months of actual bank activity as the base for a forward cash flow projection.
Cross-checking the cash flow statement generated by the accounting system against what the bank actually shows.
The template below is the direct-method format, which is the one that maps cleanly onto converted bank statement rows. Inflows are positive, outflows are negative, and the three subtotals add to the net change in cash.
| Line | Section | Example |
|---|---|---|
| Opening cash balance | Header | $42,000 |
| Cash received from customers | Operating | $118,500 |
| Cash paid to suppliers | Operating | ($46,200) |
| Cash paid to employees | Operating | ($38,000) |
| Interest and bank fees paid | Operating | ($1,300) |
| Net cash from operating activities | Subtotal | $33,000 |
| Purchase of equipment | Investing | ($15,000) |
| Net cash from investing activities | Subtotal | ($15,000) |
| Loan principal repayments | Financing | ($6,000) |
| Owner draw | Financing | ($4,000) |
| Net cash from financing activities | Subtotal | ($10,000) |
| Net change in cash | Total | $8,000 |
| Closing cash balance | Header | $50,000 |
Read the example from the bottom up and it tells a story a lender cares about. The business generated $33,000 from operations, spent $15,000 on equipment, returned $10,000 to its lender and its owner, and still ended the month $8,000 richer in cash. Operating cash comfortably covered the investment, which is the pattern that gets a loan approved.
Keep the transactions on one sheet and the statement on another. On the transaction sheet, paste the converted rows and add a single column called Section with one of three values in it. On the statement sheet, each subtotal is a SUMIF against that column. This keeps the template alive: next month you paste more rows underneath and the subtotals update on their own.
Net cash from operating activities is =SUMIF(Transactions!$D:$D,"Operating",Transactions!$C:$C), assuming column C holds the signed amount and column D holds the section tag. Repeat for Investing and Financing. Net change in cash is the sum of the three subtotals. The tie-out check is a single formula: opening balance plus net change, compared against the closing balance you pulled from the last statement of the period. If that check does not return zero, stop and find the missing account or the transfer you only removed from one side.
Convert your statement so withdrawals are negative and deposits positive in a single amount column. Templates break when debits and credits sit in two columns and the subtotals silently add outflows to inflows. If your bank exports two columns, combine them into one signed column before you tag anything. The guide on merging debit and credit columns covers exactly this.
A cash flow projection uses the same three sections, but the columns become future months instead of one past period. The most defensible way to build one is to base it on real history: convert the last twelve months of statements, total each section by month, and use those actuals as the baseline you adjust for known changes such as a new hire, a rent increase, or a loan that finishes repaying. A projection built on twelve months of bank data is far harder to argue with than one built on optimism.
Keep the actuals and the forecast in the same workbook, side by side. Each month, replace the forecast column with the converted actuals and you have a rolling forecast plus a variance check for free.
The template is the easy half. Filling it means getting every transaction out of your PDF statements and classified. That is what the converter above is for: upload a statement, download clean rows, tag them, and the subtotals fall out. The full method is on the cash flow statement from bank statements page, and if you are unsure which format to present, read direct versus indirect method first.
For the accrual counterpart, the bank statement to profit and loss page builds a P&L from the same converted data, and bank reconciliation confirms each account agrees before you report anything. Bookkeepers producing these monthly for clients can start from the bookkeeper workflow.
An opening cash balance, then three sections for operating, investing, and financing activities, each with its own subtotal, followed by net change in cash and a closing cash balance. Inflows are positive and outflows negative. The closing balance the template calculates must match the closing balance on your bank statements.
Opening cash, plus net cash from operating activities, plus net cash from investing activities, plus net cash from financing activities, equals net change in cash, which added to opening cash gives closing cash. Both the direct and indirect methods use the same three sections. They differ only in how the operating section is presented.
Put your transactions on one sheet with a signed amount column and a section tag column, then build the statement on a second sheet where each subtotal is a SUMIF against the tag. Net change in cash is the sum of the three subtotals. Check it by confirming opening balance plus net change equals the closing balance from the bank.
Yes. Keep the three sections and turn the single period column into one column per future month. Base the forecast on converted actuals from the last twelve months rather than estimates, then adjust for known changes. Replace each forecast column with actuals as the month closes and you have a rolling forecast.
Almost always a transfer between your own accounts was removed from one side but not the other, or an account was left out entirely. Both errors leave net change in cash disagreeing with the closing balance. Convert every account for the period and match each transfer out to its transfer in before you total anything.
If you are filling it from bank statements, use the direct method, because it lists actual receipts and payments in the same shape as your transaction rows. The indirect method starts from net income and needs an income statement and comparative balance sheets, which bank statements alone will not give you.
Cash leaves the business when you pay the card, not when you swipe it. If you are building the statement from bank statements, the payment to the card issuer is the cash outflow. Convert the card statement separately when you need to see what that payment was actually spent on.
The full method for building it from statements.
The reconciliation template that proves the balances.
The accrual view from the same data.
Where the cash flow statement fits in the close.
Analyze income and balances in Excel.
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
