Bank Statement to Excel Converter — PDF to CSV
Convert bank statement PDFs to Excel or CSV in your browser. Dates and amounts become real numbers, every row is checked against the running balance, and the file never leaves your device.
Loading only the code needed for this tool…
Year-end summary for a self-employed tax return
The year-end summary adds up one tax year of the rows in this tool per tax-form line: Schedule C (Form 1040) in the United States, SA103S or SA103F in the United Kingdom, T2125 in Canada. For other countries it gives totals by category. You can move any category to another line before you download the XLSX workbook (sheets Summary by line, Detail and Sources) or the one-page PDF, both made in your browser.
Worked example: 12 lines of a freelance designer's bank statement in US dollars, sorted for the 2026 Schedule C.
| Line | What went there | Amount | For the form |
|---|---|---|---|
| 1 Gross receipts or sales | Income | $10,225.50 | $10,225.50 |
| 24a Travel | Travel | $389.00 | $389.00 |
| 24b Deductible meals | Eating out | $48.20 | $24.10 |
| 25 Utilities | Phone, internet and utilities | $85.40 | $85.40 |
| 27b Other expenses (from line 48) | Subscriptions and Bank fees | $131.98 | $131.98 |
Income $10,225.50, expenses $630.48, income minus expenses $9,595.02.
The café bill counts at 50 % ($24.10 of $48.20), as the Schedule C instructions say for most business meals. Left off the form: groceries ($132.40, usually personal) and a $1,000.00 transfer to savings. A subscription paid on December 30, 2025 falls in the year before, so it is left out and mentioned in the notes.
Which forms and lines
United States: Schedule C (Form 1040) lines from the 2026 form, and the 50 % meals rule from the IRS instructions. United Kingdom: SA103S boxes 9 to 19 or SA103F boxes 15 to 30 of the 2025–26 forms, for the tax year that runs from 6 April to 5 April. Canada: T2125 lines from CRA guide T4002 (2025 edition), with meals and entertainment at 50 % and vehicle costs as actual costs, not a per-kilometre rate. The Sources sheet names the page each line was read from and the date we read it; we read them again when the next year's forms come out.
What it does not do
- It is a worksheet of your own records, not tax advice and not a tax return. It does not work out income tax, self-employment tax or National Insurance, capital allowances, depreciation or the cost of goods sold.
- An account used for both business and personal money mixes the two: money in can include wages or interest, and rows flagged for a check, such as eating out, phone bills and subscriptions, count only for their business part.
- Each tool adds up only its own rows. If you pay by card and also keep the receipt, take that expense from one tool's summary, not both, or it is counted twice.
- One currency is added up at a time. Rows in other currencies are counted in the notes and never converted.
- A mileage log at a standard rate and fuel receipts for the same car are usually two ways of claiming the same costs. Fuel is flagged so that you keep only one.
The summary is made on this device. Statements, receipts and amounts are not uploaded; analytics record only which download was used and which form was picked.
Tool quality check
Use the output as a verified working copy
Keep the original source when it may be needed again. Open the generated XLSX in the application that will receive it, and check that its content and formatting meet your needs.
Input
Output
XLSX
Batch
Up to 12 files per run
Up to 12 files per run. Only use one run when files share the same operation.
Move into a related operation instead of re-finding the tool.
Download a destination-ready result and verify it before sharing.
Configured runtime limit applies.
XLSX
Check the upload limit below
Review the result before sharing
Smart workflows
Finish the job, not just the file
Use the existing tool graph to continue into useful next steps. Bulk and output-packaging capabilities are surfaced automatically where the underlying tool supports them.
Continue with Pdf To Excel
Bulk-readyFinish the job after Bank Statement To Excel with a relevant MAXScanner tool, without creating a duplicate converter page.
- Bank Statement To Excel
- Pdf To ExcelBulk processing · Page selection · Workflow-ready
Best when Bank Statement To Excel is only the first step in your workflow.
Continue with Image To Excel
Bulk-readyFinish the job after Bank Statement To Excel with a relevant MAXScanner tool, without creating a duplicate converter page.
- Bank Statement To Excel
- Image To ExcelBulk processing · ZIP-ready output · Quality controls
Best when Bank Statement To Excel is only the first step in your workflow.
About This Tool
To convert a bank statement PDF to Excel, add the statement, check the preview and download an .xlsx or .csv file. Each transaction becomes one row with its date, description, money out, money in and balance. Dates are real dates and amounts are real numbers, so Excel can sort and add them up at once. Every printed balance is checked against the one before it, and a row that does not add up is highlighted before you download. The statement is read by your browser on this device: it is not uploaded anywhere.
What the spreadsheet contains
| Column | What is in it |
|---|---|
| Date | The transaction (booking) date, stored as an Excel date |
| Value date | Only when the statement prints one, as German and Indian statements often do |
| Description | The payee or reference text, with lines that wrapped on the PDF joined into one cell |
| Debit / Credit | Money out and money in, both as positive numbers |
| Amount | Credit minus debit: negative for money out, ready for a SUM or a pivot table |
| Balance and Check | The printed running balance, and OK or "Does not add up" from the balance check |
Five test statements, measured
We made five sample statements for invented banks, in the layouts we see most often, and ran each one through this converter in Chrome on a laptop. Every transaction was found, with the right date and amount:
| Layout | Pages | Rows found | Balance check | Time: laptop / CPU slowed 4× |
|---|---|---|---|---|
| US checking: Withdrawals, Deposits and Balance columns, MM/DD/YYYY | 2 | 34 of 34 | 34 balances add up | 21 / 48 ms |
| UK current account: date and balance printed once per day | 1 | 22 of 22 | 9 daily balances add up | 6 / 20 ms |
| German Girokonto: one signed Betrag column in 1.234,56, no balance column | 1 | 16 of 16 | opening + transactions = closing | 4 / 13 ms |
| Indian savings account: lakh grouping (1,84,250.50), cheque/reference and value date columns | 2 | 30 of 30 | 30 balances add up | 13 / 36 ms |
| No column headings, signed amounts, newest transaction first | 1 | 14 of 14 | 13 balances add up | 3 / 24 ms |
Real statements vary more than five samples can show, which is why the preview and the balance check are there: they tell you which rows to look at instead of asking you to trust the result.
How the balance check works
Each printed balance should equal the balance before it, plus money in, minus money out. In our US sample the statement opens at 2,418.36, the first row is a 78.19 cash withdrawal and the balance printed next to it is 2,340.17: 2,418.36 − 78.19 = 2,340.17, so that row passes. If a figure was misread, or a line was dropped, the next balance will not match, and that row is flagged with the difference. Banks that print the balance only once a day are checked day by day. When a statement prints no running balance at all, the opening balance plus every transaction must equal the closing balance.
Dates and number formats
Banks write 1,234.56 in the US, UK and India, 1.234,56 in Germany, Spain, Italy and Brazil, and 1 234,56 in France. The converter works out which mark is the decimal from the whole statement, not from one number, and reads Indian lakh grouping, full-width Japanese digits, Arabic-Indic digits, CR/DR suffixes, minus signs written after the number and amounts in brackets. A date such as 05/06/2026 can be 5 June or 6 May; if any date on the statement has a day above 12, that settles it, otherwise the order that keeps the rows in sequence wins. The detected format is shown above the preview, and you can change it if days and months look swapped.
Password-protected and scanned statements
Many banks send statements protected with a password, often your date of birth or part of your customer number. Type it when the converter asks: it is used by your browser to open the file and is not stored or sent anywhere. To keep an unlocked copy, use Unlock PDF. A scanned or photographed statement has no text to read, so the converter says so instead of guessing. Run it through OCR PDF first, then add the searchable PDF here, and check the amounts: OCR can misread digits, and the balance check will show you where.
What happens to your file
The PDF is opened by PDF.js, the same reader Firefox uses, inside this page. Text positions go to the converter, also inside the page, and the spreadsheet is built in memory and saved by your browser. You can check it yourself: load the page, switch off Wi-Fi or mobile data, then convert a statement; it still works. Our analytics only records that a conversion finished, the file type and whether the balance check passed; never names, amounts or descriptions.
When this is not the right tool
- If your online banking offers a CSV, Excel or OFX download, use it: it comes straight from the bank's records.
- For other tables in a PDF, such as invoices, price lists or reports, use PDF to Excel, which keeps every cell as it is.
- Statements laid out as cards or blocks instead of columns (some mobile-bank exports) may not be recognised. Set the column roles under Columns we found, or use PDF to Excel.
- Before you send a statement to a landlord or lender, hide account numbers with Find and Redact, and use Merge PDF and Compress PDF if an upload form wants one small file.
How to Use
Add your statements
Choose one or more bank statement PDFs. If a statement asks for a password, type it in the box that appears; the file is opened in your browser.
Check the preview
Look at the balance check above the table. Tap any cell to correct it, merge or split rows from the row menu, and change the date or number format if the converter guessed wrong.
Download Excel or CSV
Select Download Excel (.xlsx) for real dates and numbers, or Download CSV and pick the separator, decimal mark, date format and encoding your software expects.
Use Cases
Bookkeeping and tax
Bring a year of statements into one sheet for your accountant, or import the CSV into bookkeeping software that accepts bank CSV files.
Budgeting
Sort spending by payee, total each month with a pivot table, and find subscriptions you forgot about.
Loan, rent and visa paperwork
Check salary credits and the average balance over several months before you submit statements to a lender, landlord or embassy.
Frequently Asked Questions
How do I convert a bank statement PDF to Excel?+
Add the PDF on this page, check the preview and the balance check, then select Download Excel (.xlsx). Each transaction becomes a row with date, description, debit, credit, amount and balance, with dates and amounts stored as real values.
Is it safe to convert a bank statement online?+
With this converter the statement is not uploaded: it is read by your browser on your device and the spreadsheet is made there too. You can confirm it by going offline after the page loads and converting a statement. Many other online converters upload the file to their server, so read their privacy terms before you use them.
Can I convert a scanned bank statement?+
Not directly. A scan has no text layer, so the converter tells you so. Make it searchable with OCR PDF first, then add the new PDF here and check the amounts, because OCR can misread digits. The balance check points to the rows that do not add up.
How do I convert a password-protected bank statement?+
Add it as usual and type the password when asked. The password only opens the file in your browser; it is not saved or sent. If you need an unlocked copy of the PDF itself, use Unlock PDF.
Why are the dates or amounts wrong in Excel?+
Usually because the statement uses a different date order (DD/MM or MM/DD) or decimal mark (1.234,56 or 1,234.56) from the one assumed. The converter detects both from the whole statement and shows what it used; change Dates or Numbers above the preview if it guessed wrong. The .xlsx file stores real dates and numbers, so Excel does not reinterpret them.
Can I combine several months into one spreadsheet?+
Yes. Add up to 12 statements at once and choose One sheet, in date order, or One sheet per statement. In one sheet a File column shows where each row came from, and a transaction repeated at the edge of two statements is kept once.
Should I download Excel or CSV?+
Excel (.xlsx) keeps dates and numbers as typed values and is best for working in Excel, Numbers or Google Sheets. CSV is plain text for importing into accounting or budgeting software; pick the separator and decimal mark that software expects, for example a semicolon and a decimal comma for many European programs.