Multi-page statement cleanup
How Do I Remove Repeated Bank Statement Headers in Excel?
Reviewed 12 September 2026
Short answer
Short answer
Filter repeated headers using the complete header pattern, not one common word. For example, require the expected combination of Date, Description, Debit, Credit and Balance fields, or remove rows that exactly match the known page heading. Keep an untouched raw query and count the rows removed so you can inspect them before loading the cleaned table.
Multi-page PDFs repeat navigation for human readers. Once imported, that page furniture sits inside the transaction data and can break dates, totals and filters.
Remove page furniture with a narrow rule
A broad filter such as Description does not equal Date can delete a legitimate transaction containing that word. Match the full known header arrangement or a combination of fields that a real transaction cannot satisfy.
Opening balance, closing balance and totals are not ordinary transactions either, but preserve those values separately because they are useful reconciliation controls.
Step by step
- 01
Identify every repeated row
Compare page starts and ends to list headings, footers and carried-forward balance lines.
- 02
Write an exact filter
Match the complete header pattern or a safe combination of column values.
- 03
Keep removed rows for review
Use a separate query or raw sheet so filtered content remains auditable.
- 04
Recount and reconcile
Confirm transaction counts and movement after the filter runs.
Checks before you rely on the spreadsheet
- The filter uses a complete header pattern.
- Opening and closing controls are retained separately.
- Removed rows can still be reviewed.
- No real transaction disappeared.
Questions people ask
Why does Excel treat page headers as data?
A PDF importer sees repeated text in the document. It does not always know that the text is page furniture rather than a table row.
Should I remove balance brought forward rows?
Remove them from the transaction table, but retain their values for checking statement continuity.
Can the cleanup refresh next month?
Yes, if the header pattern and detected table structure remain consistent. Review the query whenever the bank changes its statement layout.