Bank statements to Excel for taxes and accounting
At tax time you often need a full year of transactions in one place: to total deductible expenses, separate business and personal spending, or hand a clean spreadsheet to your accountant. If all you have is twelve PDF statements, that means a lot of copying and typing.
StatementLocal converts text-based PDF statements into CSV or Excel in your browser. With Pro or the 30-Day Pass you can drop the whole year at once and get a single merged file, with a balance check on every statement so you know nothing was skipped.
Try it on your own statement. Free: 1 file per day, CSV & Excel export, nothing uploaded.
Open the free converterHow to do it
- Download the PDF statement from your online banking (Statements or Documents section). It must be a text-based PDF, not a scan.
- Open the converter and drop the PDF onto it, or click to choose the file. It is read locally in your browser.
- Review the editable preview. Rows that don't reconcile with the running balance are highlighted; click any cell to fix it.
- Export CSV or Excel (.xlsx) and save it to your device.
What columns you get
Every export, CSV or Excel, has the same columns, so your templates and import mappings keep working from month to month:
| Column | What it contains |
|---|---|
| Date | Transaction date (YYYY-MM-DD in CSV, a real date cell in Excel). The year is inferred from the statement period, including December–January rollovers. |
| Description | The transaction text, with multi-line descriptions joined into one cell. |
| Amount | One signed number: money in positive, money out negative. |
| Debit / Credit | The same amount split into money-out and money-in columns. |
| Balance | The running balance, when the statement prints one. |
| Source File | Which PDF the row came from, useful when merging several statements. |
| Check | OK when the row reconciles with the running balance, or a MISMATCH note to review. |
Tips for a clean result
- Add a Category column in Excel next to Description, then use a pivot table on Category and Amount to total each type of expense for the year.
- Filter Description for merchants you deduct (software, office rent, mileage-related fuel) to build a list for your accountant.
- The Source File column records which statement each row came from, which helps when you need to show the original document.
- The 30-Day Pass ($19, no renewal) suits a one-off tax-season catch-up; Pro Yearly suits bookkeepers who convert statements all year.
- Always review the result: StatementLocal checks the math against the printed balances, but it is not tax advice.
Private by design
The PDF is opened by JavaScript inside your browser tab and never uploaded. No AI is involved: parsing is deterministic, so the same PDF always gives the same result. Scanned (image-only) PDFs aren't supported yet. Read more in the privacy guide or the Privacy Policy.
Pricing: the free plan converts 1 file per day. Pro ($9/month or $59/year) and the one-time 30-Day Pass ($19) unlock unlimited files and batch merging. See plans.
Try it on your own statement. Free: 1 file per day, CSV & Excel export, nothing uploaded.
Convert a statement nowFAQ
Can I convert 12 months of statements at once?
Yes, with Pro or the 30-Day Pass. Batch conversion merges many PDFs into one CSV or Excel file. The free plan converts one PDF per day.
Can I give the spreadsheet to my accountant?
Yes. The export is a standard Excel or CSV file. Delete the Check column first if you don't want to share the review notes.
Is it safe to use for sensitive financial records?
Statements are processed only in your browser and never uploaded. No AI or analytics are involved.
Does it categorize expenses automatically?
No. It extracts transactions accurately; categorizing is up to you or your accounting software.