How to convert a bank statement PDF to Excel or CSV

These steps work for any text-based PDF statement from a US bank or card issuer. The file is read inside your browser and is never uploaded.

Step 1: get the statement PDF

  1. Sign in to your bank's or card issuer's website on a computer and open the statements or documents section for the account. The bank's own help pages are the final word on where it is.
  2. Choose the statement period and download the PDF.
  3. Use the PDF exactly as downloaded. A statement that was printed and scanned back in has no text layer, and this version of StatementLocal cannot read scans.

Step 2: convert it

  1. Open the StatementLocal converter.
  2. Drop the PDF on the page, or choose it.
  3. Read the verdict at the top of the result:
    • Reconciled: the rows add up from the printed opening balance to the printed closing balance.
    • Off by $X, check rows N to M: something does not add up. The likely rows are highlighted.
    • Cannot check: the statement prints no balances to check against.
  4. If a row is wrong, fix it in the grid. The verdict updates when you leave the cell.
  5. Download CSV, Excel (.xlsx) or QuickBooks CSV. You can download 3 statements a day free.

Step 3: check it before you rely on it

The balance check sees amounts, not text. A Reconciled statement can still have a wrong date or description, so look over those before you file or import anything. A Cannot check statement has nothing to check against: compare its rows with the PDF.

Guides for one task each

Guides for one problem each

What has and has not been tested

We tested StatementLocal on 200 synthetic (made-up) statements across 10 common US statement layouts, built by our own generator. Every statement it could not verify was flagged with Off by or Cannot check, never shown as Reconciled. We have not tested it on every bank's real statements, and we quote no accuracy figure for them.

StatementLocal is not affiliated with any bank. Bank names are used only to say whose statements a guide is about.

Need more than 3 statements a day? Buy the 30-day pass for $9 or Buy Lifetime for $39. One-time payments, taken by Stripe. Sold to US customers only.

Use Chrome? The same converter is also a Chrome extension: Add to Chrome from the Chrome Web Store.