Missing transaction rows
Why Is Excel's PDF Import Missing Bank Transactions?
Reviewed 12 September 2026
Short answer
Short answer
Excel can miss bank transactions when Power Query detects each page as a separate table, treats a wrapped transaction as text outside the table, or drops a row at a page boundary. Compare the first and last transaction on every PDF page with the imported table, append all relevant detected tables, and reconcile the net movement against the printed balances. Do not use the result if the figures do not reconcile.
A missing row is dangerous because the spreadsheet can still look complete. Page-by-page checks catch what a quick scroll will not.
Find the exact boundary where rows disappeared
Add the source page or filename while transforming the data. That creates a trail back to the PDF and makes it much easier to find a gap between two imported tables.
The strongest final check is numerical. Where the statement provides running balances, the change between them should match the transaction amount and the full imported movement should reach the printed closing balance.
Step by step
- 01
Count by page
Record the first and last transaction on each statement page and compare them with the import.
- 02
Review Navigator
Make sure every transaction table was selected, not just the first detected table.
- 03
Repair boundary rows
Reconnect transactions or descriptions that were split by headers and page breaks.
- 04
Reconcile the movement
Compare total debits, credits and closing movement with the source statement.
Checks before you rely on the spreadsheet
- Every PDF page is represented.
- The first and last row around each page break is present.
- No header row became a transaction.
- Imported movement reaches the printed closing balance.
Excel documentation used in this guide
Microsoft documentation checked 12 September 2026.
Questions people ask
Can Power Query split one statement into several tables?
Yes. Navigator can expose multiple detected tables, particularly across pages or changing page layouts.
How do I prove that no transactions are missing?
Check page boundaries and reconcile the imported debit and credit movement to the statement balances.
Should I add an adjustment to force the balance?
No. An unexplained adjustment hides the missing or reversed transaction rather than fixing it.