Converting Multi-Page PDF Bank Statements

Bank statements often split a transaction across two pages - the date and description appear at the bottom of one page, and the amount appears at the top of the next. pdftoxlsx detects these split rows automatically and merges them into a single complete transaction. It also recognizes and removes repeated column headers (Date, Description, Amount) that banks print at the top of every page, so your output contains only one header row followed by all transactions.

Most bank statements include page numbers, account information, bank logos, and disclaimer text repeated on every page. pdftoxlsx identifies these repeating elements and strips them from the output. Only actual transaction data makes it into the final spreadsheet. This includes removing: page numbers and page counts, repeated account holder names and addresses, bank branch information, running balance headers that appear on each page, and legal disclaimer footers.

You can upload multiple monthly statements at once and pdftoxlsx will convert them in batch. Each statement produces its own sheet in the Excel output, or you can choose to merge all months into a single consolidated spreadsheet. This is useful for year-end reconciliation or catching up on several months of bookkeeping. pdftoxlsx processes up to 12 PDF files per batch. Transactions are kept in chronological order within each statement and across merged outputs.

pdftoxlsx preserves the page order as it appears in the PDF. If your bank statement lists transactions from newest to oldest, the output will maintain that order. You can re-sort by date in Excel after conversion. If pages within a PDF are out of order (which can happen with some bank portals that generate pages asynchronously), pdftoxlsx still extracts all transactions correctly - they just appear in the page order of the source PDF. Sort by the Date column in Excel to fix any ordering issues.