Historical transaction records
What Is the Quickest Way to Turn Years of Bank Statements into Excel?
Reviewed 12 September 2026
Short answer
Short answer
First inventory every account and statement period so missing months are visible. Keep each account separate, convert statements in batches into the same transaction columns, retain a Source File value, remove overlapping dates, sort the rows and reconcile each statement boundary. For supported Australian banks, a dedicated batch converter is usually faster than maintaining a Power Query process across years of layout changes.
The main risk in a multi-year job is not the row count. It is quietly missing a month, combining two accounts or duplicating an overlapping period.
Treat the job as a records reconstruction
Build an inventory before extracting anything: entity, account, first date, last date and each available PDF. Closed accounts need their own history rather than being mixed into a current account file.
Statement formats can change over several years. Test each layout period separately and retain filenames so an accountant can trace any transaction back to the original document.
Step by step
- 01
List every account
Include closed accounts, cards and any personal account used for business transactions.
- 02
Mark statement coverage
Create a month-by-month inventory and resolve gaps before conversion.
- 03
Convert in consistent batches
Use the same transaction columns and keep each account in its own output.
- 04
Remove overlaps and reconcile
Check statement boundaries, duplicate periods and the movement within every source file.
Checks before you rely on the spreadsheet
- Every required month is present or disclosed as missing.
- Different accounts remain separate.
- Every row retains a source filename.
- Each statement period reconciles before the files are handed over.
Questions people ask
Can I combine 36 PDF bank statements into one spreadsheet?
Yes, but combine one account at a time and keep the source filename on every row. Use batches, then reconcile each source period before joining the final table.
What if the bank changed its PDF layout?
Test each layout period separately. A query or parser that works for recent statements should not be assumed to fit older versions.
Should closed bank accounts be included?
Yes, if they fall inside the period requested. Keep each closed account in a clearly labelled file.