Skip to content

Free tool · No account needed

Convert Bank Statement to Excel or CSV

Stop re-typing statements into spreadsheets. Upload a PDF bank or credit card statement and download categorized, balance-checked transactions as Excel, CSV, QuickBooks or Xero files — in seconds.

Your statement is processed in memory — the file and extracted transactions are never stored or logged on our servers. Scanned statements are supported via OCR.

PDF bank statement to CSV

Banks hand you a PDF; your spreadsheet, your accountant and your accounting software all want rows. This converter closes that gap: it reads the statement's text layer, extracts every transaction with its date, description, amount, direction and running balance, and gives you a clean CSV you can open anywhere. Amounts come out signed and numeric — no currency symbols glued to numbers, no columns shifted by long descriptions.

Unlike copy-pasting from a PDF viewer, the output is validated: the running balance is recomputed across every row, so a missed or duplicated transaction shows up as a flag instead of a silent error you find at reconciliation time.

Credit card statement to Excel

Credit card statements convert the same way. Purchases are recorded as debits, payments and refunds as credits, and each merchant line is categorized — software subscriptions, meals, travel, fuel and 20+ other bookkeeping categories. The Excel export includes the category plus the matching default QuickBooks and Xero account names, so month-end coding starts 90% done.

Bank statement to QuickBooks or Xero

When your bank feed is missing months — or the account can't be connected at all — the fastest fix is a manual import. The converter produces QuickBooks bank-feed CSVs in both accepted layouts (3-column Date/Description/Amount and 4-column Date/Description/Credit/Debit, MM/DD/YYYY dates) and a Xero-formatted CSV (Date, Amount, Payee, Description, Reference) ready for Xero's statement import. It doesn't push into either product directly — you stay in control of the import.

Bank statement OCR for scanned PDFs

Not every statement PDF has selectable text — older statements, faxed copies and phone scans are just pictures of a table. The converter detects when a PDF has no usable text layer and routes it through a vision model that reads the table straight from the page images. The same balance check applies, so OCR misreads surface as flagged rows rather than quiet errors in your books.

How it works

  1. 1

    Upload your statement PDF

    Drop any bank or credit card statement up to 10 MB and 20 pages. The PDF is read in your browser — scanned statements are detected automatically and routed through OCR.

  2. 2

    AI extracts and categorizes every row

    Each transaction comes out with date, description, amount, direction and running balance, and is assigned one of 26 bookkeeping categories mapped to default QuickBooks and Xero accounts.

  3. 3

    Review the balance-checked preview

    The running balance is recomputed row by row. Any row that breaks the arithmetic is flagged at the top of the table, and every cell is editable before export.

  4. 4

    Download in the format you need

    Enter your email and download CSV, Excel (.xlsx), QuickBooks 3- or 4-column CSV, or a Xero-formatted CSV. Edits you made in the preview are reflected in the file.

Works with statements from

There are no per-bank templates — any statement that prints one transaction per row converts, including:

  • RBC
  • TD
  • BMO
  • CIBC
  • Scotiabank
  • Desjardins
  • National Bank
  • Chase
  • Bank of America
  • Wells Fargo
  • Citi
  • American Express
  • Capital One
  • HSBC
  • Barclays
  • and most others

Frequently asked questions

How do I convert a bank statement PDF to Excel?
Upload the PDF above. The converter reads every transaction row — date, description, amount, direction and running balance — categorizes each one, and lets you review and edit the table before downloading it as an Excel (.xlsx) or CSV file. Text-based statements under 10 MB and 20 pages typically finish in under 30 seconds.
Can it convert a bank statement to CSV for free?
Yes. The tool is free and works without an account. You get CSV alongside Excel, QuickBooks and Xero formats — we only ask for an email address before the download.
Does it work on scanned bank statements (OCR)?
Yes. When the PDF has no selectable text layer, the converter runs bank statement OCR: a vision model reads the pages directly, so photographed or scanned statements still come out as structured rows. Clearer scans give better results, and any row that breaks the running balance is flagged for review.
Can I import the result into QuickBooks or Xero?
Yes. The converter offers QuickBooks bank-feed CSVs in both the 3-column (Date, Description, Amount) and 4-column (Date, Description, Credit, Debit) layouts, and a Xero-formatted CSV (Date, Amount, Payee, Description, Reference). Each transaction is also categorized against default QuickBooks and Xero account names. It does not push directly into either product — you import the file yourself.
Does it handle credit card statements too?
Yes. Credit card statements convert the same way as chequing and savings statements: purchases come out as debits, payments and refunds as credits, and you can export to CSV or Excel in one step.
Which banks does it work with?
It isn't built around per-bank templates, so it works with statements from most banks — including RBC, TD, BMO, CIBC, Scotiabank, Desjardins, Chase, American Express and others — in any layout that prints one transaction per row. Unusual layouts still return a best-effort parse with problem rows flagged at the top.
How accurate is the extraction?
Every parse is cross-checked deterministically: the running balance is recomputed row by row, and any row where the arithmetic breaks is flagged at the top of the preview so you can fix it before exporting. Dates are checked for order and duplicate rows are removed. You should still review flagged rows — that's what the editable preview is for.
Is my bank statement stored anywhere?
No. Your statement is processed in memory to extract the rows and is not persisted or logged server-side. The only retention is a one-hour cache keyed by the file's fingerprint so re-uploading the same file doesn't cost a second parse.
What are the limits?
PDFs up to 10 MB and 20 pages, five uploads per hour. There are no user accounts, no currency conversion, and no direct push into QuickBooks or Xero — exports are files you import yourself.

Privacy: your statement is processed in memory to extract transactions, and neither the file nor the extracted data is stored or logged on our servers. A one-hour cache keyed by the file's SHA-256 fingerprint is the only retention, so re-uploading the same statement doesn't trigger a second parse. Five uploads per hour.

Ready to monetize your audience?

Get a personalized demo and see how Pelcro can replace the patchwork of tools running your subscription business today.

By submitting your email, you agree to opt in to marketing emails.