Bank statement examples by bank

What a bank statement actually contains

Whatever bank issued it, a statement is built from the same handful of parts. Knowing them makes the converted spreadsheet easier to read and easier to check.

• Account header. The account holder, account number (usually masked), the statement period, and the opening and closing balances. This is summary information, not transaction data.
• The transaction table. The part you actually want in a spreadsheet. Each row is one transaction: the date it posted, a description (merchant, payee, or a transfer reference), the amount, and often a running balance.
• Summaries and totals. Subtotals for deposits, withdrawals, fees, or interest, plus a daily balance summary on many checking statements. These are useful for sanity-checking a conversion but are not transactions themselves.

When ConvertFin converts a statement, it reads that middle section, the transaction rows, and turns them into clean columns: Date, Description, Amount and Balance. Checking and savings statements usually fill all four. Credit card statements, like American Express, have no running balance, so that column simply stays empty while the date, description and amount come through in full.

Why the layout differs from bank to bank

There is no single standard for how a statement is printed, which is why a converter that handles one bank layout can stumble on another. A few of the differences you will see across the examples on this site:

• One amount column versus two. Chase lists deposits and withdrawals together in a single amount column. Wells Fargo and PNC split them into separate deposits and withdrawals sections.
• Where the balance appears. Some statements print a balance on every transaction line. Wells Fargo only shows the daily ending balance on days that had activity, and U.S. Bank keeps a separate daily balance summary after the transaction list.
• Wrapping descriptions. Bank of America and Citi descriptions can run long and wrap onto a second line, which is worth checking in the preview so each transaction stays on one row.
• Transaction date versus posting date. Capital One prints both. The date that matters for reconciliation is usually the transaction date, which is the one the converter keeps.

You do not need to memorize any of this. The per-bank pages describe each layout and give a practical tip, and the converter preview table lets you confirm the result before you export.

Convert your statement, privately, in your browser

ConvertFin is different from most PDF to Excel tools in one important way: your statement never leaves your device. The file is parsed locally in your browser using pdf.js. It is not uploaded to a server, not stored, and not sent anywhere. That matters for a document full of account numbers and spending history. You can read more about how we keep it private.

Getting a spreadsheet takes three moves. First, open the PDF you downloaded from your bank online portal. Next, review the preview, where ConvertFin reads the transaction rows into a Date, Description, Amount and Balance table so you can check them before exporting. Finally, export the result as an Excel file (.xlsx) or a CSV, ready for Excel, Google Sheets, or your accounting tool. You can also convert to CSV if that is what your software imports.

One requirement to know up front: the PDF needs selectable text. Statements downloaded directly from online banking are text-based and work well. A scanned or photographed statement is just an image with no readable text underneath, so it cannot be converted until it has been through OCR. If you would rather follow along, here is the step-by-step guide.