Convert a bank statement to Excel, free

What the Excel file contains

Copying a statement out of a PDF usually breaks it: columns run together, descriptions wrap onto new rows and amounts paste as text. This converter reads the statement's structure first and then writes the workbook, so each transaction is one row and each column means one thing.

Amounts such as 2,400.00 and -48.20 arrive as numbers with their decimals shown, so totals work straight away. Account numbers keep their leading zeros, because they stay as text. Dates come as they appear in the result, often in the form 2026-09-02, which Excel and Google Sheets both recognise.

How to convert a bank statement PDF to Excel

1. Download the statement from your online banking as a PDF, or scan the paper copy. Remove any password from the PDF first, because a locked file can't be read.
2. Upload it on this page. The first page is read, usually in a few seconds.
3. Check the opening balance and the first and last rows against the statement.
4. Choose Download, then Excel (.xlsx). Open it in Excel, Google Sheets, Numbers or LibreOffice.

Check the conversion with the balance

A statement checks itself. Opening balance plus credits minus debits should equal the closing balance, and each row's running balance should equal the row above plus that row's amount. Add a column with =D3+C4 (or your columns) and compare it with the printed balance: the first row that disagrees shows you exactly where to look.

Statements with separate debit and credit columns

Some banks print money out and money in as two columns, and others print one signed amount. The tool keeps the layout the bank used. If you need a single column, add =Credit-Debit in a new column. Statements with Dr and Cr after the amount are kept as printed, so filter on that column to split them.

Whole statements and many statements

Lenders, accountants and bookkeepers need every page, often for six or twelve months. A free account reads every page of a statement and joins the transactions into one table, up to 100 pages a month, and flags a run when the table comes back shorter than the statement. Results from many statements export to one workbook. See the bank statement field list and lending and mortgage.

curl -X POST "$DOCREFINERY_API/v1/workflows/wf_demo_bank_statement/run" \
  -H "Authorization: Bearer $DOCREFINERY_API_KEY" \
  -F "[email protected]"

# Take trace_id from the answer, then poll until status is "fulfilled"
curl "$DOCREFINERY_API/v1/runway/9f1c0a7e" \
  -H "Authorization: Bearer $DOCREFINERY_API_KEY"

{
  "trace_id": "9f1c0a7e",
  "status": "fulfilled",
  "document_type": "bank_statement",
  "result": {
    "fields": [
      {
        "key": "client_name",
        "alias": "Client Name",
        "text": "Alex Sample",
        "field_confidence": 0.99,
        "location": { "page": 1, "bbox": [0.08, 0.12, 0.46, 0.14] }
      },
      {
        "key": "account_number",
        "alias": "Account Number",
        "text": "0012 3456 7890",
        "field_confidence": 0.98,
        "location": { "page": 1, "bbox": [0.08, 0.17, 0.46, 0.19] }
      },
      {
        "key": "statement_start_date",
        "alias": "Statement Start Date",
        "text": "2026-09-01",
        "field_confidence": 0.97,
        "location": { "page": 1, "bbox": [0.08, 0.22, 0.46, 0.24] }
      },
      {
        "key": "transactions",
        "alias": "Transactions",
        "table": [
          [
            { "key": "date", "alias": "Date", "text": "2026-09-02" },
            { "key": "description", "alias": "Description", "text": "Card payment, Market Hall" },
            { "key": "amount", "alias": "Amount", "text": "-48.20" },
            { "key": "balance", "alias": "Balance", "text": "4,162.35" }
          ]
        ]
      }
    ],
    "extraction_approval": "auto",
    "low_confidence_fields": []
  }
}