How to extract a bank statement: download it, then get the transactions out

Menu names differ from bank to bank, but the route is nearly always the same:

1. Sign in to online banking. The website and the app usually both offer statements; the steps below follow the website.
2. Open the account, then look for a section called Statements, Documents, eStatements or Statements and documents. On some sites it sits under a profile or "More" menu rather than on the account page.
3. Choose the year and month. Statements follow the bank's cycle, so a "March" statement may run from mid-February to mid-March.
4. Open the statement and use Download or the save icon to keep the PDF. Save it with a name that sorts, such as 2026-03 current account.pdf.
5. Repeat for each month and each account. A joint account, a savings pot and a credit card each have their own statements.

In a banking app the route is usually the account, then a menu named Statements or Documents, then share or save the PDF to your files. If you cannot find it, the bank's help pages will name the exact menu; search its site for "download statement".

Statements in online banking typically reach back further than the transaction history you can export, often several years, though the limit is the bank's. Download everything you might need while you can still sign in, especially before you close an account. For anything older, or for a closed account, ask the bank for copies; our guide to old bank statements covers how, including subject access requests in the UK and EU.

Some banks email statements as PDFs that need a password to open. The password format comes from the bank, usually in the email that delivered the statement, and it is often built from personal details rather than your online-banking password. If you have the password and still cannot get the file into a converter, the guide to opening a password-protected bank statement PDF walks through the options, including unlocking it in your browser.

If what you need is transaction data, look for an export before you touch the PDF. In the account's transaction list, search for Export, Download transactions or a download icon. Many banks offer:

• CSV, which opens in Excel or Google Sheets;
• OFX or QFX, for personal-finance and accounting software;
• QBO, a QuickBooks Web Connect file;
• sometimes a format named after an app, such as Quicken or QuickBooks.

Choose the date range, choose the format and download. An export comes straight from the bank's records, so there is nothing to misread, and it is free. That makes it the best option whenever it covers the period you need.

Its limits are practical. Many banks restrict exports to recent months, closed accounts often lose access, and a statement someone else sent you has no export attached. If you are not sure which file your software wants, the QBO, QFX, OFX and QIF comparison explains each one.

When the PDF is all you have, there are three realistic ways to turn it into rows:

1. Copy and paste. Select the transactions in a PDF viewer, paste into a spreadsheet, then split them with Data → Text to Columns. Fine for one short page. On longer statements, wrapped descriptions become extra rows and blank money-in cells shift amounts into the wrong column.
2. Excel's Get Data from PDF. In Microsoft 365 Excel on Windows, Data → Get Data → From File → From PDF finds tables in a text PDF. You then join the page tables in Power Query and remove repeated headers. It is free if you already have that Excel, and it reads nothing from scans or photos.
3. A statement converter. It reads every page into one table and handles scans. The one worth using tells you whether its result adds up.

Our step-by-step guide to converting a bank statement PDF to Excel covers methods 2 and 3 in detail, with the common clean-up fixes.

The bank statement converter here reads a PDF, a scan or photos of the pages, then checks the opening balance plus money in minus money out against the closing balance, and every printed running balance against the row before. The first two pages a day are free, and you see every row before paying. A scanned statement is read from the image; for paper, see scanned bank statement to Excel. For a plain data file rather than a workbook, choose bank statement to CSV.

Whichever method you used, run two checks before relying on the result.

The total check. Opening balance + total money in − total money out should equal the closing balance printed on the statement, exactly. If the difference equals one transaction's amount, that line is missing or doubled. A difference like 90.00 or 0.09 usually means a misread digit.

The row check. On statements that print a running balance, each balance should equal the one before plus that row's money in minus its money out. The first row where it does not is where the problem is: that line, or one missing just above it.

Then compare the row count with the statement and look at a few dates and descriptions. Matching balances show that the amounts are consistent; they cannot catch a wrong date, a misread reference number in a description, or two errors that cancel each other out. In our own test on fictional statements, a phone photo lost a digit from two descriptions while every balance check passed.

• The statement section shows nothing older than a year or two. The bank's online archive has a limit. Ask the bank for older copies; some charge a fee.
• The download opens as a blank or broken file. Try the desktop website instead of the app, or another browser, and save the file rather than viewing it inline.
• Dates come out wrong in Excel. 03/04 means 3 April in the UK and March 4 in the US. Set the date format deliberately instead of trusting your computer's region.
• Amounts will not sum. They are stored as text. Remove currency symbols and convert the column to numbers.
• The converter found no transactions. You may have uploaded a cover letter or summary page. Check that the file contains the itemised list.