# Convert bank statements to Excel or CSV

> Upload a bank statement PDF and download every transaction as Excel or CSV, with signed amounts and running balances. The tool checks that the opening balance plus credits minus debits equals the closing balance to the cent and flags the first row where the running balance breaks. It runs Reducto Extract with the r-1 model, free.

Canonical: https://reducto.ai/tools/bank-statement-to-excel  
Last updated: 2026-11-15  
For: Accountants and bookkeepers, Lenders and underwriters, Auditors, Finance teams

## Run it now (free, no API key, up to 5 pages)

Send a PDF, Word, PowerPoint, Excel or image (PNG, JPG, HEIC, TIFF, BMP, GIF) (max 10 MB, 5 pages) to `POST https://reducto.ai/api/tools/bank-statement-to-excel` as multipart `file`, or JSON `{"url": "https://..."}`. The response has `result`, ready-to-save `output` (Excel (.xlsx), CSV, JSON), `pages_processed` and `next`.

```bash
curl -s https://reducto.ai/api/tools/bank-statement-to-excel \
  -F file=@harborline-bank-statement.pdf

# or, for a file that is already online:
curl -s https://reducto.ai/api/tools/bank-statement-to-excel \
  -H "Content-Type: application/json" \
  -d '{"url": "https://example.com/harborline-bank-statement.pdf"}'
```

Higher volume needs a free API key (new accounts get 15,000 free credits). Agents can sign up over HTTP: https://reducto.ai/auth.md. Humans: https://studio.reducto.ai/?utm_source=free_tool&utm_medium=agent&utm_campaign=bank-statement-to-excel&utm_content=api_response

Big file? Without a key the free run covers the first 5 pages and returns `partial: true` with a `signup_required` block. Your user signs up in under a minute (email, 6-digit code, name, terms: https://reducto.ai/auth.md); then repeat the same request with `Authorization: Bearer $REDUCTO_API_KEY` for the whole file on their 15,000 free credits. The same key works on the hosted MCP (https://mcp.reducto.ai/mcp) and the Reducto API.

## How to do it

1. Upload a bank or brokerage statement PDF, or keep the sample.
2. Reducto Extract reads the statement with the r-1 model and fills a fixed schema: account details, balances and every transaction.
3. The tool adds up credits and debits in cents and compares opening plus credits minus debits with the closing balance.
4. If a printed running balance does not match, the first broken row is flagged.
5. Download the transactions as Excel or CSV.

## Reducto API call: `POST https://platform.reducto.ai/extract`

| Option | Value | Why |
| --- | --- | --- |
| `instructions.schema` | `account, period, balances, transactions[]` | A plain JSON schema; every transaction row is extracted into an array. |
| `parsing.settings.model` | `"r-1"` | Reads multi-line descriptions and tables that break across pages. |
| `settings.deep_extract` | `false` | The free tool always uses standard Extract. |
| `settings.page_range` | `{ start: 1, end: 5 }` | The free tool reads at most 5 pages. |

### curl

```bash
# 1. Upload the file (or pass a public URL as "input" and skip this step)
curl -s https://platform.reducto.ai/upload \
  -H "Authorization: Bearer $REDUCTO_API_KEY" \
  -F file=@statement.pdf
# => {"file_id": "reducto://..."}

# 2. Run extract
curl -s https://platform.reducto.ai/extract \
  -H "Authorization: Bearer $REDUCTO_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
  "input": "reducto://FILE_ID",
  "instructions": {
    "schema": {
      "type": "object",
      "properties": {
        "account_holder": {
          "type": "string",
          "description": "Name of the account holder as printed on the statement."
        },
        "institution": {
          "type": "string",
          "description": "Name of the bank, credit union or broker that issued the statement."
        },
        "account_number_last4": {
          "type": "string",
          "description": "Last four digits of the account number. Never return more than four digits."
        },
        "period_start": {
          "type": "string",
          "description": "First day of the statement period, formatted YYYY-MM-DD."
        },
        "period_end": {
          "type": "string",
          "description": "Last day of the statement period, formatted YYYY-MM-DD."
        },
        "opening_balance": {
          "type": "number",
          "description": "Balance at the start of the statement period."
        },
        "closing_balance": {
          "type": "number",
          "description": "Balance at the end of the statement period."
        },
        "transactions": {
          "type": "array",
          "description": "Every transaction in the transaction history, in statement order, across all pages. Do not include daily balance summaries.",
          "items": {
            "type": "object",
            "properties": {
              "date": {
                "type": "string",
                "description": "Posting date, formatted YYYY-MM-DD. Infer the year from the statement period."
              },
              "description": {
                "type": "string",
                "description": "Full description, joining lines that wrap onto the next line."
              },
              "amount": {
                "type": "number",
                "description": "Signed so that the opening balance plus the sum of all amounts equals the closing balance. Bank account: positive for deposits and credits, negative for withdrawals. Credit card: positive for purchases, fees and interest, negative for payments and refunds."
              },
              "running_balance": {
                "type": [
                  "number",
                  "null"
                ],
                "description": "Balance printed on the same row after this transaction, or null if none is printed."
              }
            },
            "required": [
              "date",
              "description",
              "amount"
            ]
          }
        }
      },
      "required": [
        "opening_balance",
        "closing_balance",
        "transactions"
      ]
    },
    "system_prompt": "Extract a bank or brokerage statement. Copy amounts exactly as printed and keep every transaction row. Copy descriptions verbatim, including masked account numbers such as XXXX1234."
  },
  "parsing": {
    "settings": {
      "model": "r-1"
    }
  },
  "settings": {
    "deep_extract": false,
    "page_range": {
      "start": 1,
      "end": 5
    }
  }
}'
```

### Python

```python
# pip install reductoai
from pathlib import Path
from reducto import Reducto

client = Reducto()  # reads REDUCTO_API_KEY

upload = client.upload(file=Path("statement.pdf"))
result = client.extract.run(
    input=upload.file_id,
    instructions={
        "schema": {
            "type": "object",
            "properties": {
                "account_holder": {
                    "type": "string",
                    "description": "Name of the account holder as printed on the statement.",
                },
                "institution": {
                    "type": "string",
                    "description": "Name of the bank, credit union or broker that issued the statement.",
                },
                "account_number_last4": {
                    "type": "string",
                    "description": "Last four digits of the account number. Never return more than four digits.",
                },
                "period_start": {
                    "type": "string",
                    "description": "First day of the statement period, formatted YYYY-MM-DD.",
                },
                "period_end": {
                    "type": "string",
                    "description": "Last day of the statement period, formatted YYYY-MM-DD.",
                },
                "opening_balance": {
                    "type": "number",
                    "description": "Balance at the start of the statement period.",
                },
                "closing_balance": {
                    "type": "number",
                    "description": "Balance at the end of the statement period.",
                },
                "transactions": {
                    "type": "array",
                    "description": "Every transaction in the transaction history, in statement order, across all pages. Do not include daily balance summaries.",
                    "items": {
                        "type": "object",
                        "properties": {
                            "date": {
                                "type": "string",
                                "description": "Posting date, formatted YYYY-MM-DD. Infer the year from the statement period.",
                            },
                            "description": {
                                "type": "string",
                                "description": "Full description, joining lines that wrap onto the next line.",
                            },
                            "amount": {
                                "type": "number",
                                "description": "Signed so that the opening balance plus the sum of all amounts equals the closing balance. Bank account: positive for deposits and credits, negative for withdrawals. Credit card: positive for purchases, fees and interest, negative for payments and refunds.",
                            },
                            "running_balance": {
                                "type": [
                                    "number",
                                    "null",
                                ],
                                "description": "Balance printed on the same row after this transaction, or null if none is printed.",
                            },
                        },
                        "required": [
                            "date",
                            "description",
                            "amount",
                        ],
                    },
                },
            },
            "required": [
                "opening_balance",
                "closing_balance",
                "transactions",
            ],
        },
        "system_prompt": "Extract a bank or brokerage statement. Copy amounts exactly as printed and keep every transaction row. Copy descriptions verbatim, including masked account numbers such as XXXX1234.",
    },
    parsing={
        "settings": {
            "model": "r-1",
        },
    },
    settings={
        "deep_extract": False,
        "page_range": {
            "start": 1,
            "end": 5,
        },
    },
)
print(result)
```

### Node

```ts
// npm install reductoai
import fs from "fs";
import Reducto from "reductoai";

const client = new Reducto(); // reads REDUCTO_API_KEY

const upload = await client.upload({ file: fs.createReadStream("statement.pdf") });
const result = await client.extract.run({
  input: upload.file_id,
  instructions: {
    schema: {
      type: "object",
      properties: {
        account_holder: {
          type: "string",
          description: "Name of the account holder as printed on the statement.",
        },
        institution: {
          type: "string",
          description: "Name of the bank, credit union or broker that issued the statement.",
        },
        account_number_last4: {
          type: "string",
          description: "Last four digits of the account number. Never return more than four digits.",
        },
        period_start: {
          type: "string",
          description: "First day of the statement period, formatted YYYY-MM-DD.",
        },
        period_end: {
          type: "string",
          description: "Last day of the statement period, formatted YYYY-MM-DD.",
        },
        opening_balance: {
          type: "number",
          description: "Balance at the start of the statement period.",
        },
        closing_balance: {
          type: "number",
          description: "Balance at the end of the statement period.",
        },
        transactions: {
          type: "array",
          description: "Every transaction in the transaction history, in statement order, across all pages. Do not include daily balance summaries.",
          items: {
            type: "object",
            properties: {
              date: {
                type: "string",
                description: "Posting date, formatted YYYY-MM-DD. Infer the year from the statement period.",
              },
              description: {
                type: "string",
                description: "Full description, joining lines that wrap onto the next line.",
              },
              amount: {
                type: "number",
                description: "Signed so that the opening balance plus the sum of all amounts equals the closing balance. Bank account: positive for deposits and credits, negative for withdrawals. Credit card: positive for purchases, fees and interest, negative for payments and refunds.",
              },
              running_balance: {
                type: [
                  "number",
                  "null",
                ],
                description: "Balance printed on the same row after this transaction, or null if none is printed.",
              },
            },
            required: [
              "date",
              "description",
              "amount",
            ],
          },
        },
      },
      required: [
        "opening_balance",
        "closing_balance",
        "transactions",
      ],
    },
    system_prompt: "Extract a bank or brokerage statement. Copy amounts exactly as printed and keep every transaction row. Copy descriptions verbatim, including masked account numbers such as XXXX1234.",
  },
  parsing: {
    settings: {
      model: "r-1",
    },
  },
  settings: {
    deep_extract: false,
    page_range: {
      start: 1,
      end: 5,
    },
  },
});
console.log(JSON.stringify(result, null, 2));
```

### Schema

```json
{
  "type": "object",
  "properties": {
    "account_holder": {
      "type": "string",
      "description": "Name of the account holder as printed on the statement."
    },
    "institution": {
      "type": "string",
      "description": "Name of the bank, credit union or broker that issued the statement."
    },
    "account_number_last4": {
      "type": "string",
      "description": "Last four digits of the account number. Never return more than four digits."
    },
    "period_start": {
      "type": "string",
      "description": "First day of the statement period, formatted YYYY-MM-DD."
    },
    "period_end": {
      "type": "string",
      "description": "Last day of the statement period, formatted YYYY-MM-DD."
    },
    "opening_balance": {
      "type": "number",
      "description": "Balance at the start of the statement period."
    },
    "closing_balance": {
      "type": "number",
      "description": "Balance at the end of the statement period."
    },
    "transactions": {
      "type": "array",
      "description": "Every transaction in the transaction history, in statement order, across all pages. Do not include daily balance summaries.",
      "items": {
        "type": "object",
        "properties": {
          "date": {
            "type": "string",
            "description": "Posting date, formatted YYYY-MM-DD. Infer the year from the statement period."
          },
          "description": {
            "type": "string",
            "description": "Full description, joining lines that wrap onto the next line."
          },
          "amount": {
            "type": "number",
            "description": "Signed so that the opening balance plus the sum of all amounts equals the closing balance. Bank account: positive for deposits and credits, negative for withdrawals. Credit card: positive for purchases, fees and interest, negative for payments and refunds."
          },
          "running_balance": {
            "type": [
              "number",
              "null"
            ],
            "description": "Balance printed on the same row after this transaction, or null if none is printed."
          }
        },
        "required": [
          "date",
          "description",
          "amount"
        ]
      }
    }
  },
  "required": [
    "opening_balance",
    "closing_balance",
    "transactions"
  ]
}
```

Do this with the API: [Reconcile every transaction on a bank statement](https://reducto.ai/cookbooks/reducto-extract-bank-statement-reconciliation)

## What it handles

- **Balances tie out**: Opening balance plus credits minus debits is checked against the closing balance.
- **No rows lost at page breaks**: Transactions that continue on the next page are kept in order.
- **Multi-line descriptions stay together**: A description that wraps onto two lines stays in one row.

## FAQ

### How does the tie-out check work?

The tool adds every positive amount as a credit and every negative amount as a debit, in whole cents, then checks opening balance + credits - debits = closing balance. It also walks the printed running balance row by row and flags the first row that does not match.

### What if the statement does not tie out?

The page shows the difference and the first row where the running balance breaks. Check that row against the PDF: it is usually a missed row, a sign error or a misread digit.

### Does it work on scanned statements?

Yes. Reducto reads the page image, so scanned and photographed statements work.

### Does it handle brokerage statements?

Yes, for cash activity in the same transaction format. For holdings, positions and multiple accounts, see the brokerage statement to Excel API page, which uses a schema built for brokerage statements.

### Which fields are extracted?

Account holder, institution, last 4 digits of the account number, statement period, opening and closing balance, and each transaction's date, description, signed amount and running balance.

### Are credits and debits separate columns?

Amounts are signed: deposits are positive and withdrawals are negative. Excel users can split them with a simple IF formula.

### Is the full account number shown?

No. The schema asks for the last 4 digits only, and the tool trims anything longer.

### Is it free?

Yes. Short documents run free with no account, with a small daily limit per IP. For a longer file you get a free preview of the first pages, then enter your email to get the whole file on a free account (15,000 free credits).

### Does the free tool use Deep Extract?

No. It always uses standard Extract. Deep Extract is available on the API for long, high-field-count documents.

### Can I use the same schema in my own code?

Yes. The schema and the exact request are in the API section of this page.

Sample document (synthetic): https://reducto.ai/tools/samples/harborline-bank-statement.pdf

## Related

- [Credit card statement to Excel](https://reducto.ai/tools/credit-card-statement-to-excel)
- [Receipt to Excel](https://reducto.ai/tools/receipt-to-excel)
- [10-K tables to Excel](https://reducto.ai/tools/10k-tables-to-excel)
- [All Finance statements tools](https://reducto.ai/tools/finance-statements)
- [Bank statement reconciliation with Extract](https://reducto.ai/cookbooks/reducto-extract-bank-statement-reconciliation)
- [Brokerage statement accounts with Extract](https://reducto.ai/cookbooks/reducto-extract-brokerage-statement-accounts)
- [Brokerage statement to Excel (API)](https://reducto.ai/cookbooks/reducto-extract-brokerage-statement-accounts)
- [Reducto Extract](https://reducto.ai/extract)
