FormaliniFormaliniPaper to Data
Try it free

Bank statement converter

Convert bank statements to Excel, CSV or JSON

Upload a PDF or scanned bank statement and get every transaction as clean rows — date, description, amount and running balance — ready for Excel, your accounting tool or your own app.

Convert a statement freeSee plans and prices

Works on scanned statements

Photographed or photocopied statements are read too, not only text-based PDFs.

Balances checked for you

Opening balance plus transactions is compared with the closing balance, so missed rows show up.

Any bank, any layout

No bank-specific templates to set up. Multi-page statements become one transaction list.

What a converted statement looks like

{
  "bank": "Example Bank",
  "account_ending": "4821",
  "period": {
    "from": "2026-08-01",
    "to": "2026-08-31"
  },
  "opening_balance": 2140.55,
  "closing_balance": 1873.2,
  "currency": "EUR",
  "transactions": [
    {
      "date": "2026-08-02",
      "description": "Card payment — Office supplies",
      "amount": -84.3,
      "balance": 2056.25
    },
    {
      "date": "2026-08-05",
      "description": "Transfer in — Client ACME",
      "amount": 1200,
      "balance": 3256.25
    }
  ],
  "checks": {
    "balances_reconcile": true
  }
}

How to convert a bank statement to Excel

  1. 01

    Download the statement PDF from online banking, or photograph the paper copy.

  2. 02

    Upload it to Formalini — the first three pages are free without an account.

  3. 03

    Check the transactions; any value the reader is unsure about is highlighted.

  4. 04

    Export to CSV for Excel or Google Sheets, or JSON for your software.

Bank statement to Excel questions

Is it safe to upload a bank statement?
Files are encrypted in transit and at rest, stored in your private space only, and the free demo keeps nothing after it answers.
Can I convert many statements at once?
Yes. With an account you can upload in bulk or send statements through the API and receive the rows by webhook.
Does it work for credit card statements?
Yes. Card statements are read the same way — date, merchant, amount and any foreign-currency details.
Can I open the result in Excel?
Export as CSV and open it directly in Excel, Numbers or Google Sheets.

Related tools