Bank Statement PDF to Excel for Bookkeeping
Convert bank statement PDFs to an Excel workbook for bookkeeping and reconciliation. Runs in your browser. Your file is never uploaded.
Converts text-based PDF bank statements to CSV or Excel in your browser. Your file is never uploaded. Always review the output before using it.
Steps for bookkeeping
- Download the statement PDF for the month you're catching up on as a PDF (scanned PDFs aren't supported).
- Add the file to the converter at the top of this page. Several PDFs can go in together.
- Tick each row against the statement as you go and fix anything that looks off.
- Set Export layout to Standard columns (QuickBooks, Xero and YNAB layouts are free as well), choose Download Excel, then file it with that month's PDF.
What the file looks like
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-09-12 | Courier delivery | -18.75 | |
| 2026-09-15 | Card processor payout | 642.10 | |
| 2026-09-20 | Phone bill | -61.00 |
Sample rows, Standard columns setting.
Excel notes
- Download Excel saves a real .xlsx workbook, so there's no import wizard to click through: open the file and the Date, Description, Amount and Balance columns are already split.
Why it fits bookkeeping
Plenty of small businesses keep their books in Excel. Converting a statement gives you an .xlsx with each transaction in its own row, so reconciling is filtering and ticking rather than retyping.
If you keep a simple cash book in Excel, paste each month's converted rows beneath the last, add an Account column and a Category column, and use a pivot table to see income and spending by category. The Balance column from the statement is a handy check that nothing went missing.
Tip: Add a Reconciled column with a simple Y once each row matches an invoice or receipt, then filter to the blanks to see what's left.
Questions
Does the Excel file keep the running balance?
Yes, when the statement prints one. The Balance column comes from the statement, so you can compare it with your own running total to catch a missing row.
Can I convert credit card statements too?
Text-based credit card statements with a similar date, description and amount table may work. Check the signs, since card statements treat payments and charges differently.
RowSmith is an independent tool and is not affiliated with any bank or software company named on this page.
Converting is free. RowSmith Pro ($9/month or $59/year) adds suggested Schedule C categories, saved cleanup rules and monthly category totals.