PDF-only records
My Accountant Needs CSV but I Only Have PDF Bank Statements
Reviewed 12 September 2026
Short answer
Short answer
Keep the original PDFs, then convert each bank account into a separate chronological CSV with Date, Description, Debit, Credit and Balance columns. Check every statement period, reconcile the transaction movement and send both the CSV and PDFs to your accountant. If your bank no longer offers a historical CSV export, a converter built for that bank can recover the transaction rows from the PDFs.
This is a common handover problem. The data still exists, but it is trapped in a document designed for reading rather than importing.
Turn the PDFs into a working file without losing the evidence
Start by asking whether the accountant has a required column order or template. Avoid combining accounts unless requested, and include the source filename so each row can be checked against its statement.
A converted CSV saves data-entry time, but the PDFs remain important. They show the account, period and printed balances used to verify the extracted rows.
Step by step
- 01
Ask for the specification
Confirm the date range, accounts and required CSV columns.
- 02
Collect and label PDFs
Use clear filenames and identify any missing or overlapping periods.
- 03
Convert by account
Create consistent rows and retain the source filename for traceability.
- 04
Reconcile and deliver
Check the balances, then provide CSV plus the original PDFs.
Checks before you rely on the spreadsheet
- CSV columns match the accountant's request.
- Each account has its own history.
- Every statement period is accounted for.
- Converted rows reconcile with the PDFs.
Questions people ask
Can a PDF bank statement be converted to CSV?
Yes. A text-based statement can be parsed into transaction rows, but the method must account for the bank's layout and still be checked against the source balances.
Will Excel open the converted CSV?
Yes. Excel opens CSV directly, and the same file can often be imported into accounting software.
Is it safe to discard the PDFs after conversion?
No. Keep the original statements for verification and record-keeping, subject to your accountant's advice and applicable obligations.