Client Bank Statement PDFs to Excel for Accountants
Accountants: turn client statement PDFs into Excel workpapers without uploading them anywhere. Converted in your browser. Review all output.
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 accountants and bookkeepers
- Download the client's statement PDFs, one account at a time 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.
- Tie out the totals above the table to the statement summary and note it in your workpapers.
- Set Export layout to Standard columns (QuickBooks, Xero and YNAB layouts are free as well), choose Download Excel, then save it in the client folder.
What the file looks like
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-02-10 | Payroll run | -6420.00 | |
| 2026-02-18 | Customer check deposit | 3105.00 | |
| 2026-02-25 | Loan interest | -212.48 |
Sample rows, Standard columns setting.
Excel notes
- Each file you drop adds its rows to the same table, so several statements download as one sheet. Add a column afterwards if you need to tell the accounts apart.
Why it fits accountants and bookkeepers
Excel is still where most workpapers start. Converting the client's statements gives you a working sheet you can tie out to the PDF, annotate and keep in the client file.
For review, keep the converted sheet unaltered on one tab and do your adjustments on a second tab with formulas pointing back. A reviewer can then see the raw conversion, your changes and the tie-out to the statement without reopening the PDF.
Tip: Tie out the in and out totals shown above the preview to the statement summary and note it on the sheet, so a reviewer can see the conversion was checked.
Questions
Can I edit rows before they go into the workbook?
Yes. Click any cell to correct it, or use × to delete a row such as a pending item, before you download.
Does it handle statements from banks outside the US?
Day-first dates, Cr and Dr markers and other number styles are handled in many layouts, but check dates closely on any statement from outside the US.
Can I keep the client's original description text?
Yes. Descriptions come from the statement as printed, including any wrapped second lines, so you can keep them as evidence and add your own cleaned-up column.
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.