To remove blank pages from a PDF statement before converting, find them in the page thumbnails, delete them in your reader or with a page-range tool, and save under a new name. Then check that the page numbers and the carried-forward balances still run unbroken, so you know no page with real transactions went along with them.
Which blank pages can go from a PDF statement?
Blank pages that carry no transactions, balances or totals can go. In statement files these are mostly empty scanner backs, pages printed only with a line such as "This page intentionally left blank", and padding pages some systems add so a file has an even page count.
Pages of terms, notices or fee schedules are not blank, but they hold nothing a spreadsheet needs, so they can usually be left out of the copy you convert. Keep the original file untouched as your record and remove pages only from a working copy.
The table below sorts the usual page types. The descriptions are examples; check what your own statement does.
| Page type | Example content | Keep or remove for conversion |
|---|---|---|
| Scanner back | Nothing, or faint marks showing through | Remove |
| Intentionally left blank | One sentence in the middle of the page | Remove |
| Terms and conditions | Paragraphs of small print | Remove from the working copy |
| Closing balance only | A balance line, a page number, a footer | Keep |
| Short continuation | One or two transactions carried over | Keep |
"Intentionally left blank" pages in statement PDFs
An "intentionally left blank" page is a page with a single notice and nothing else. Banks and print systems add them so that a new section starts on a fresh sheet, or so a double-sided printout keeps each statement on its own paper. The notice tells you nothing is missing.
These pages cause two small problems. A converter may read the notice as a line of text and put it in a row, which then needs deleting. And a scanner's skip-blank-pages setting will not catch them, because the page is not empty: it holds a sentence. Most skip settings judge a page by how much ink it has, and one centred line is enough to keep it.
They are easy to spot in the thumbnail view, where they look nearly white with a single grey stroke. Delete them by hand in the thumbnail panel, or by page number with a page-range tool.
Deleting blank PDF pages by page range
Delete blank pages by selecting them in the reader's thumbnail panel and pressing Delete, or by listing the pages to keep in a tool that builds a new file. Either way, save the result under a new name so the original stays complete.
A few common routes:
- Desktop PDF editors. Open the page thumbnails, select the blank pages, and choose the delete command in the page tools. Selecting several at once with Ctrl or Command saves time.
- Preview on a Mac. Show the thumbnails in the sidebar, select the blank pages and press Delete, then save.
- qpdf on the command line. The qpdf command-line documentation describes page ranges with commas and dashes, where z stands for the last page. To drop page 4 of a file,
qpdf --empty --pages statement.pdf 1-3,5-z -- trimmed.pdfkeeps everything else in order.
If removing pages leaves the order wrong, for example after a scan of a double-sided stack, fix the order next. Reordering PDF pages so statement months run in order covers the free tools for that. When a page holds real transactions but also a large margin of ads or notes, deleting is the wrong tool; cropping a PDF before converting trims the clutter and keeps the rows.
How do you prove no real statement page was removed?
Prove the file is complete with three checks: page numbers, balances and a transaction count. Deleting is fast, and a nearly blank page with a closing balance can look exactly like an empty one in a small thumbnail. A minute of checking avoids converting a statement that is quietly missing its last page.
- Read the page numbers. Most statements print "Page 2 of 5" or similar. Every number from 1 to the last should still be present, with only the blank pages missing from the sequence.
- Follow the balances. The balance carried forward at the top of each page should equal the balance at the bottom of the page before it. A break means a page with transactions is gone.
- Check the closing balance. The final page you kept should show the closing balance that the statement summary on page 1 reports.
If any check fails, go back to the original file, which you kept, and look at the pages you removed.
Nearly blank statement pages worth keeping
Some statement pages look blank at a glance but carry data a spreadsheet needs. The most common is a last page holding only one transaction, a closing balance or the end of a fee table. Delete it and the conversion is short by exactly that amount, with nothing to show why.
Keep a page if it has any of these:
- a date and an amount anywhere on it, even one row
- a balance line such as "closing balance" or "balance carried forward"
- a totals box for the period, which is what later checks rely on
- a page number that falls inside the statement's own range, unless the page also says it is left blank
Scanner settings deserve a second look for the same reason. An automatic blank-page skip with a high threshold can drop a page holding a single line of print. If you scan statements, set the threshold low, or turn the option off and remove blank pages by hand.
Once the file is trimmed, any good converter should give you one row per transaction and nothing extra. What separates a good PDF to Excel converter from a bad one explains how to check that it did. FastBankConvert is built to warn you before download when the balances do not add up, which is how a page removed by mistake would show itself. It is getting ready to open, and Get started puts you on the list.