fileforge

Bank statement to Excel › Guides

Combine 12 months of bank statement PDFs into one spreadsheet

Your bank gives you one PDF a month. A tax return, an accountant or a budget wants one list. Here is how to stack a whole year of statements into a single date-sorted sheet without sending any of them to a converter site.

Verified sample The sample below was produced by running this site's converter on two synthetic statements from different banks. It is not real data.

Steps

  1. Download all twelve PDFs from your bank. Use the statements section of online banking. Keep them in one folder so you can select them together.
  2. Open the bank statement converter and drop all the PDFs on it at once. The free allowance is a few pages a day, so a full year may need a pack; the page tells you before it stops.
  3. Leave "Combine files into one list" and "Sort by date" ticked. Every transaction goes into one list in date order, with a column naming the statement it came from.
  4. Check each statement's balance check. Each file shows how many rows reconcile against its running balance. If one file shows a mismatch, look at that file's preview before trusting the total.
  5. Keep "Drop repeated rows" ticked if your statements overlap. A row is dropped only when date, text, amount and balance all match, so two real purchases of the same amount on the same day are kept.
  6. Download Excel or CSV. Money out is negative, money in is positive, so a SUM of the Amount column is your net movement for the year.

Sample: two statements, one list

Date	Description	Amount	Balance	Source file
2026-02-01	TRANSFER TO SAVINGS	-300.00	2820.40	february.pdf
2026-02-02	TRANSFER FROM SAVINGS	36.50	2856.90	february.pdf
2026-02-03	INTEREST PAID	1830.25	4687.15	february.pdf
2026-02-04	RENT PAYMENT LANDLORD LLC	-4.75	4682.40	february.pdf
2026-02-06	COFFEE HOUSE 0098	-62.18	4620.22	february.pdf
2026-02-07	ELECTRIC UTILITY AUTOPAY	-54.32	4565.90	february.pdf

71 transactions from 2 statements in different layouts, sorted by date. 0 repeated rows dropped.

What to check

Open the bank statement converter