Cash Flow Statement from Bank Statements: Convert PDF Statements to Excel

What is the difference between a cash flow statement and a bank statement?

A bank statement is a record produced by your bank listing every transaction in one account over a period, in date order, with a running balance. A cash flow statement is a financial statement produced by the business that groups all cash movement across the whole company into three categories: operating, investing, and financing. The bank statement is raw evidence of a single account. The cash flow statement is the classified, entity-wide summary built on top of that evidence. One is an input, the other is the output.

That distinction explains most of the work. Converting the statement gets you the transactions. Turning those transactions into a cash flow statement means excluding movements that are not cash flows of the business at all, such as a transfer from checking into savings, and grouping the rest so a reader can see whether the company funded itself from operations, from selling assets, or from borrowing.

What are the three sections of a cash flow statement?

Under US GAAP the statement of cash flows, governed by ASC 230, splits every cash movement into three activities. The table below shows how ordinary lines on a bank statement map onto them.

Two classifications trip people up. A loan payment is usually one debit on the bank statement but two lines on the cash flow statement, because under US GAAP the interest portion is operating and the principal portion is financing. And an owner draw is financing, not an operating expense, even though it looks like every other withdrawal in the register.

How do you prepare a cash flow statement from a bank statement?

Work in the order below. Each step depends on the one before it, and skipping the transfer step is the single most common reason a first attempt does not tie out.

1. Convert every account for the period

Download each monthly PDF statement for every bank account and card the business used, then convert them to spreadsheet rows. A cash flow statement covers cash and cash equivalents for the entire entity, so a single checking account is rarely the whole story. Converting the statements rather than retyping them keeps the amounts exact, which matters because the statement has to reconcile to the penny at the end.

2. Strip out transfers between your own accounts

If you moved $10,000 from checking to savings, one statement shows a $10,000 withdrawal and the other shows a $10,000 deposit. Neither is a cash flow of the business. Match the pairs and remove both. Leave them in and your operating or financing totals will be overstated by the transfer amount while the net change in cash still appears correct, which is a genuinely hard error to spot later.

3. Classify what remains

Tag every remaining row as operating, investing, or financing. The fastest way is to sort by description or payee and classify each recurring payee once, then apply that tag to all of its rows. The transaction categorization page covers doing this in bulk. Split loan payments into their interest and principal components using the lender amortization schedule.

4. Total each section and reconcile to the bank

Sum operating, investing, and financing. Add the three subtotals to get net change in cash for the period. That figure must equal the combined closing balance of every account minus their combined opening balance. Because each converted row carries the running balance from the statement, you can prove the tie-out directly against the source document rather than asserting it. If the numbers disagree, an account is missing or a transfer was only removed from one side.

Direct method or indirect method?

The direct method lists actual cash receipts and cash payments, which is exactly the shape of a bank statement, so it is the natural fit when you are working from statements. The indirect method starts from net income and adjusts for non-cash items such as depreciation and for changes in receivables, inventory, and payables. It needs an income statement and comparative balance sheets, so bank statements alone will not produce it.

Worth knowing before you choose: under ASC 230 a business entity must present a reconciliation of net income to net cash flow from operating activities regardless of which method it uses, so choosing the direct method does not remove the reconciliation. Most US companies report using the indirect method for that reason. Our guide to the direct and indirect methods walks through both formats side by side, and the cash flow statement template gives you the layout to drop your classified totals into.

Where this tool stops

To be precise about scope: BankXLSX converts statements and preserves the numbers. It does not decide that a payment is investing rather than operating, split your loan payment between interest and principal, or sign off on the finished statement. Those judgments belong to you or your accountant. What it removes is the part with no judgment in it at all, which is getting thousands of accurate transaction rows out of PDFs and into a spreadsheet you can work in.

Once the cash side is clean, the same converted data supports the rest of the close. Use the bank statement to profit and loss page for the accrual view, bank reconciliation to confirm each account agrees with the ledger, and the month end close checklist to sequence the work. Businesses rebuilding a year of history first should start with catch up bookkeeping.