Convert a Long Multi-Page Statement PDF to CSV
Busy accounts produce statements that run for many pages, with the transaction table split across page breaks and repeated headers. Here is how to make sure nothing is lost in between.
Your file is never uploaded. RowSmith reads text-based PDF statements in your browser. Scanned PDFs aren't supported yet. Always review the rows before you use them.
Open the free statement converter
Steps
- Drop the full PDF on the converter; do not split it into pages first.
- Count rows: compare the number of rows in the preview with a rough count from the PDF, or check the running balance.
- Look at the rows around each page break in the PDF and find them in the preview.
- Download the CSV once the totals agree.
Good to know
Repeated headers
Each page may repeat the column headings and a "continued" line. Those are not transactions; delete them if they show up.
Subtotals per page
Some statements print a subtotal at the bottom of each page. Remove those rows before totalling, or you will count amounts twice.
Running balance as a guard
If the statement has a balance column, each row's balance should equal the previous balance plus the amount. A break in that chain points to a missing row.
Questions
Is there a page limit?
No fixed limit. Very long files take longer because they are read in your browser.
Should I split the PDF?
No. Keeping it whole keeps the rows in order.
Doing this every month? RowSmith Pro
Converting statements, including many at once into one table, stays free with no limit. Pro adds:
- A suggested Schedule C category on every transaction (a suggestion only; confirm with your own records or a tax professional).
- Saved cleanup rules to rename messy merchant text and set your own category every time, with an editor plus import and export.
- One CSV or Excel file per statement, plus a Source file column in the combined file.
- Monthly category totals as CSV or Excel.
- Extra Payee, Category and Category source columns in the accounting and Excel downloads.
$9/month or $59/year. Email us within 14 days of your first payment for a full refund, no questions asked.
This guide was written with AI assistance and reviewed against the converter's behaviour. Always review your output before using it.
RowSmith is an independent tool and is not affiliated with any bank or software company.
Converting is free. RowSmith Pro ($9/month or $59/year) adds suggested Schedule C categories, saved cleanup rules and monthly category totals.