The download button in online banking usually reaches back a few months, sometimes a year or two. Closed accounts often lose online access altogether. So when a tax return, a mortgage application, a divorce disclosure or an executor's accounts need transactions from years ago, what you can get is PDFs or paper — and what you need is a spreadsheet you can trust. Here is how to get from one to the other.
First, get the statements
Start with whatever is already in reach, then ask the bank for the rest.
- Online banking, even for older periods. The CSV download may stop at a few months, but the statements section often keeps PDFs for much longer — several years at many banks. Download every PDF you might need while you can still sign in, especially before closing an account.
- Your own records. Emailed e-statements, paper statements in a drawer, PDFs saved by accounting software, or statements attached to an old loan application.
- The bank itself. Banks keep records long after an account closes; in the US and the UK, anti-money-laundering rules generally require at least five years. Ask customer service or a branch for copies of statements for specific months. Some banks charge a research or copy fee for older statements, so ask about it before ordering a decade.
- In the UK and EU, a subject access request. Data protection law lets you ask any organisation for the personal data it holds about you, which includes your transaction history. It is free in most cases and the bank has one month to respond. Ask for the transactions in an electronic format; some banks will send a spreadsheet, which saves the conversion step entirely.
- For someone who has died. Executors and administrators can request statements from the bank's bereavement team, usually with a death certificate and proof of their authority.
Whatever arrives will be one of three things: a CSV or spreadsheet (use it as it is), a text PDF, or paper and scans. The rest of this guide is about the last two.
Text PDFs: the straightforward case
A PDF you downloaded from online banking almost always contains real text — you can select a word with the cursor. That makes it easy to convert accurately.
For a handful of pages, Excel's own PDF import can do it (Microsoft 365 on Windows: Data → Get Data → From File → From PDF), though each page comes back as a separate table to stitch together. Our step-by-step guide on converting a bank statement PDF to Excel covers that route and its common problems.
For more than a few statements, a converter saves the stitching. The bank statement converter here puts every transaction from every page into one table and checks the result against the statement's own balances. It also writes CSV if the spreadsheet is headed into accounting software.
Paper and scans: where accuracy is at risk
Statements the bank posts to you, and old paper statements from a drawer, have to be turned into images first. A flatbed scanner at 300 dpi is ideal; a phone photo works if the page is flat, evenly lit and fills the frame. Photograph every page, including the ones with only a few transactions — the last page often carries the closing balance you need for the check.
Excel's PDF import cannot read scans at all, because a scan holds a picture of text rather than text. You need something that reads images. The converter here takes scanned statements and phone photos directly — upload the pages of one statement together and they are read as one statement.
Reading an image is where mistakes creep in: a 3 read as an 8, a smudged decimal point, a faint line skipped. That is not a reason to type everything by hand. It is a reason to run the check below on every statement, because the check catches exactly these errors.
The check that makes old statements trustworthy
Every statement carries its own proof: an opening balance, a closing balance, and everything in between. If the transactions you have are complete and correct, then:
opening balance + money in − money out = closing balance
exactly, to the cent. When it does not, the difference tells you what went wrong. A difference equal to one transaction means it was dropped or doubled. A difference like 5.00 or 0.50 on a scan usually means one digit was misread. A difference of twice an amount means something landed in the wrong column.
Most statements also print a running balance on each line, which lets you find the exact row: each balance should equal the one above it plus that line's money in minus its money out. The first row where that fails is where to look.
The converter here runs both checks automatically and says, per statement, whether it reconciles. If you are doing it yourself in Excel, the formulas are in the PDF to Excel guide. Either way, do it for every statement. With twelve months of history, one missed line is the difference between a figure you can put on a form and one you have to explain.
Putting several years into one sheet
Convert one statement at a time and check each one before combining. Then:
- Put every month into one table with the same columns: date, description, money out, money in, balance, and a column for the statement it came from.
- Check continuity between statements: each statement's opening balance should equal the previous statement's closing balance. A gap means a missing statement, not a conversion error.
- Sort by date, and add a signed amount column (money in minus money out) for pivot tables and totals by year or payee.
If the history is headed into budgeting or accounting software rather than a spreadsheet, see the guides for YNAB and GnuCash.
If it is a big job
Several years of statements, from several accounts, in a mix of PDFs and paper, is a day's work even with a good converter. If the deadline is close — a tax filing, a court disclosure, an estate account — the whole batch can be converted for you: every statement reconciled to the cent or delivered with the difference explained, priced before any work starts.
Questions
- How far back can I get bank statements?
- Online banking often keeps PDF statements for several years even when the transaction download covers only recent months. Beyond that, ask the bank: records are generally kept for at least five years after they are made or after an account closes, though older copies may carry a fee.
- Can I get statements for a closed bank account?
- Usually yes. Online access typically ends when the account closes, but the bank still holds the records. Request copies from customer service or a branch; in the UK and EU a subject access request is a free alternative.
- How do I convert paper bank statements to Excel?
- Scan or photograph every page, then use a converter that reads images, and check the result against the statement's opening and closing balances. Excel's built-in PDF import cannot read scans.
- How do I know the converted statements are complete?
- Check that opening balance plus money in minus money out equals the closing balance for every statement, and that each statement opens where the previous one closed. Together those prove no transaction and no statement is missing.
The machines this uses
- 5Bank Statement to ExcelEvery transaction from a PDF or scanned statement in one clean sheet — and a check that the balances add up, so you know nothing was missed.The first 2 pages a day are free, balance checks included. See and copy every row.
- 4Image to ExcelA photo, screenshot or scan of a table comes back as rows and columns. Check it here, then download it as a spreadsheet.3 free pages a day across up to 3 uploads. See and copy every table.