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
- 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.
- 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.
- 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.
- 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.
- 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.
- 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
- Statements that print dates such as 03/04/2026 are ambiguous; the converter works out the order from the other dates and says when it had to assume.
- Scanned statements (photos of paper) have no text layer and are not supported.
- The converter is tested on synthetic statements in six common layouts, not on every bank, so read the balance check before you rely on the numbers.