Bank Statement Converter to Excel, CSV, QBO/OFX

Short answer: Use PDF2XLS to turn a bank or card statement PDF (including scans) into a real .xlsx in one upload. Free: 3 files/day, 10 MB each, no signup. You can also download QBO, OFX, QuickBooks Online CSV, or Xero CSV when the table has Date and Amount/Debit‑Credit columns.

• Free: 3 files/day, no signup or email
• Size cap: 10 MB per file, one file at a time
• Outputs: .xlsx, .csv, .docx, .pptx, plus QBO/OFX/QuickBooks Online CSV/Xero CSV when Date and Amount exist
• Scans/photos: Handled automatically by GPT‑5 vision
• Privacy: Processed on our server in Germany; scanned page images go to OpenAI API; files deleted after processing
• Pro plan: $9/month, unlimited conversions, same 10 MB/file, cancel anytime (free tier stays)

How do I convert a bank statement PDF to Excel or QBO/OFX?

Upload the statement above and pick your download. That’s it.

1. Click Upload and add your PDF (or a photo/scan).
2. Wait a moment while the table is read into rows and columns.
3. Open Download and choose .xlsx or .csv. For accounting, choose QBO, OFX, Xero CSV, or the QuickBooks Online 3‑column CSV. Accounting options appear only when the table has Date and Amount (or separate Debit/Credit).
4. Open the .xlsx in Excel/Sheets, or import the accounting file into your bookkeeping software.

Why do bank statements trip up generic PDF converters?

Statements mix quirks that break simple extractors: multi‑line payee/descriptions; negatives in parentheses; separate Debit/Credit columns versus signed Amount; running balance columns; page headers/footers and stamps overlapping the grid; and two mini‑tables on the same page (e.g., summary + transactions). PDF2XLS focuses on the transaction table and returns numbers as numbers.

Will it work with scanned statements and phone photos?

Yes. There’s no OCR toggle to find — image pages go through GPT‑5 vision automatically. For blurry photos, crop to the table and re‑upload; higher contrast and straight pages improve recognition. If your document is a scan, see OCR for scanned PDFs for quick checks before trusting totals.

What exactly do the accounting downloads contain, and how do I import them?

When the extracted table includes a Date column and an Amount (or Debit/Credit), the Download menu adds QBO, OFX, a QuickBooks Online 3‑column CSV (Date, Description, Amount), and a Xero CSV. You download the file and import it yourself — there’s no direct bank connection.

• QuickBooks Online import: Transactions → Bank transactions → Upload from file.
• Xero import: Accounting → Bank accounts → Import a statement.

If your statement lacks the needed columns, you’ll get Excel/CSV instead. To shape a clean QuickBooks import from .xlsx, see Convert PDF to CSV for QuickBooks.

What should I verify before you use this data?

Do a 2‑minute sanity check specific to statements:

• Opening and closing balances reconcile to the PDF (if present).
• Debit/Credit signs: refunds and payments have the expected sign.
• Parentheses for negatives became negative numbers, not text.
• Date format matches your region (MM/DD vs DD/MM) and imported correctly.
• Thousand/decimal separators are right (1,234.56 vs 1.234,56).
• “Balance brought forward” and “Subtotal” lines aren’t mixed with transactions you plan to import.
• No duplicate lines across page breaks.

For month‑end work, a reconciled sheet helps; grab the layout on Bank reconciliation format in Excel.

What if the output looks wrong?

Here are common causes and quick fixes:

• All rows shifted into one column: The PDF likely uses tabbed text or a photo that’s skewed. Re‑upload a straighter image, or use the .xlsx to split with Excel’s Text to Columns if needed.
• Totals or running balance included as transactions: Delete “Total”/“Balance” lines before import. Keep only dated line items.
• Debit/Credit columns but you need one Amount: In Excel, set Amount = Credit − Debit and delete the originals before exporting CSV.
• Watermarks or stamps over the grid: If possible, re‑export the statement without overlays and re‑upload.
• Very low‑resolution scans: Rescan at a higher resolution or photograph closer with good lighting.

Working through many months? Convert one file at a time here, then consolidate quickly using the guide in Extract data from multiple PDFs to Excel (Free).

Is my bank data safe?

Files are processed on our server in Germany and deleted right after processing. PDFs with a real text layer are parsed on our server and are not sent to any AI provider. For scans/photos, page images go to the OpenAI API for table recognition and aren’t used for training.

Ready to go? Upload above or convert your PDF now.