Bank Statement PDF to CSV for Bookkeeping
Turn bank statement PDFs into CSV rows for your bookkeeping. Runs in your browser and your file is never uploaded. Scanned PDFs aren't supported.
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).
- Drop the PDF on the converter box above (or tap the box to pick it).
- Tick each row against the statement as you go and fix anything that looks off.
- Set Export layout to Standard columns (the QuickBooks, Xero and YNAB layouts are free too), choose Download CSV, then file it with that month's PDF.
What the file looks like
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-09-02 | Client payment INV-1042 | 1250.00 | |
| 2026-09-05 | Office supplies | -86.40 | |
| 2026-09-09 | Software subscription | -29.00 |
Sample rows, Standard columns setting.
CSV notes
- The Standard columns layout gives four columns: Date, Description, Amount and Balance. Dates are written as YYYY-MM-DD, which sorts correctly as text and can't be misread as day-first or month-first.
Why it fits bookkeeping
When the bank only gives you PDFs, catching up a set of books means retyping every line. Convert each statement to a CSV instead and you get one row per transaction, ready to load into whatever ledger or spreadsheet you keep.
A practical monthly routine: on the first business day, pull last month's PDF for each account, convert it, and save the CSV next to the PDF. Then match deposits to invoices you issued and withdrawals to bills you paid. Anything left over is either a missing receipt or a fee to record.
Tip: Keep one CSV per account per month and name it by account and period (for example checking-2026-09.csv). It makes the reconcile step easy to retrace.
Questions
Can I load the CSV into my bookkeeping software?
Most bookkeeping tools accept a bank CSV with date, description and amount columns. If yours is QuickBooks, Xero or YNAB, choose that layout in the Export layout menu so the columns already match.
What should I check before posting the rows?
Compare the row count and the in and out totals shown above the table with the statement's own summary. Fix or delete any row that doesn't match before you download.
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.