A cash flow statement answers a question the profit and loss statement cannot: where did the cash actually go? A business can show a profit on paper and still run out of money, because profit counts income when it is earned and cash counts it when it arrives. A big invoice paid late, a supplier paid early, a tax bill landing in a slow month — any of these can leave a profitable business short of cash. The cash-flow statement tracks the money itself, month by month, and it is the document that tells you whether the business can pay its bills next week.
The good news is that you already own the source data. Every cash movement in and out of the business passes through the bank account, and the bank statements record all of it. Building the statement is mostly a sorting job: take the year's transactions, put each one in the right bucket, and total the buckets. Year-end is the natural time to do it, when the full year is in hand and the numbers feed straight into tax planning and next year's budget. This guide builds it from your bank data, step by step.
Cash Flow Statement Basics: The Three Sections
Every cash-flow statement has three sections, and they never change. Operating activities are the day-to-day business: cash received from customers, cash paid to suppliers, wages, rent, utilities, and taxes. This is the section that matters most — a business that cannot generate positive operating cash flow is funding itself from somewhere else, and that somewhere else eventually runs out. Investing activities are the long-term moves: buying equipment, selling an old vehicle, or purchasing another business. Financing activities are the money moves with lenders and owners: loan proceeds, loan repayments, and owner contributions or draws.
The three sections add up to the net change in cash for the period, and that number must tie exactly to the change in the bank balance between the start and the end of the period. If it does not tie, something is miscategorized or missing, and the tie-out is the check that catches it. Keep the sections separate and do not net them against each other: a loan that covers an operating shortfall should be visible as exactly that, not hidden inside a single net number. For the record-keeping behind all three sections, our guide to bank reconciliation shows how to keep the underlying bank data clean.
How to Build a Cash Flow Statement From Bank Data
Start by converting the year's bank statements from PDF to Excel, so every transaction is a sortable row with a date, a description, and an amount. Then add a category column and label each row: customer receipts, supplier payments, payroll, rent, loan payments, owner draws, equipment, and so on. The labels should match the three sections — operating, investing, financing — so the totals fall out naturally. A transaction that does not fit any label is a flag, not a problem: look at it, decide what it was, and add a label for it.
Build the statement with one column per month and a year total at the right. Each section lists its inflows and outflows as separate lines, with a subtotal, and the three subtotals feed the net change in cash at the bottom. Then run the tie-out: opening bank balance plus net change in cash must equal the closing bank balance, to the cent. If it does not, the usual causes are a transfer between two business accounts counted twice, a credit card payment recorded as an expense instead of a financing outflow, or a month of statements missing from the file. Fix the category, not the total — a plug figure that forces the tie-out hides the error and guarantees it reappears. Our bank statement template guide shows how to lay the converted data out for this kind of work, and the step-by-step for matching the file to your books is in our guide on how to reconcile a bank statement.
Reading What the Numbers Say
The first thing to read is the operating section. Positive operating cash flow means the core business pays for itself; negative operating flow means it does not, and the business is living on loans, savings, or owner money. One bad month is usually timing — a big customer paying late — but six bad months is a business problem, not a timing problem. Look at the pattern across the year, not a single month: seasonal businesses will show strong and weak quarters, and that is normal as long as the year totals work.
The second thing to read is the gap between profit and cash. If the profit and loss statement shows a healthy profit but operating cash flow is weak, the money is stuck somewhere: unpaid customer invoices, inventory piling up, or bills paid before they were due. Each cause has a different fix — chase receivables, slow down inventory orders, or negotiate payment terms — and the cash-flow statement is what points at the right one. The third thing is the financing section: a business that borrows every year to cover operations is not growing, it is treading water. A business that repays loans from operating cash is the opposite. Compare this year's statement with last year's, side by side, and the direction of travel is usually obvious.
Cash Flow Statement vs Profit and Loss
The two statements answer different questions, and a business needs both. The profit and loss statement shows whether the business model works: revenue minus expenses, over a period, on an accrual basis. The cash-flow statement shows whether the business can survive: cash in minus cash out, over the same period, on a cash basis. A business can be profitable and cash-poor, or cash-rich and unprofitable — the first runs out of money, the second runs out of time.
Use them together at year-end. Build the profit and loss first, from the same categorized transactions, then build the cash-flow statement from the same data — the two should tell a consistent story, and any contradiction between them is worth investigating. Our profit and loss statement template Excel guide builds the other half of the pair from the same bank data, so the two statements share one source and one set of categories. Together they give you, your accountant, and any lender the full picture: what the business earned, and what it actually banked.