# Convert bank statement PDFs to JSON transactions

**Use case:** 

Extract the transaction table of a PDF bank statement as JSON rows with date, description, reference, debit, credit and balance, plus the summary and the whole statement as Markdown. Use it for bookkeeping, reconciliation and cash-flow analysis. The example parses a sample one-page business statement with 17 transactions.

## Input

```json
{
  "documentUrls": [
    "https://api.apify.com/v2/key-value-stores/gZUDoFSN6sExqUTEm/records/sample-bank-statement.pdf"
  ],
  "ocrMode": "auto",
  "extractTablesAsJson": true,
  "maxPages": 100,
  "maxFileSizeMb": 50,
  "maxDocuments": 100,
  "documentTimeoutSecs": 300
}
```

## Output

```json
{
  "source_url": {
    "label": "Source URL",
    "format": "string"
  },
  "table_count": {
    "label": "Table count",
    "format": "integer"
  },
  "tables_json": {
    "label": "Tables (JSON)",
    "format": "array"
  }
}
```

## How it works

### 1. Sign up on Apify or log in

The Invoice, Receipt & PDF Table to JSON/Markdown OCR Actor is ready to run with the inputs already set for "Convert bank statement PDFs to JSON transactions". [Sign up or log in](https://console.apify.com/create-task-from-example/xlVrIbH5aRRvBBPZe) and you'll land in Apify Console with a copy of this exact task.

### 2. Start the "Convert bank statement PDFs to JSON transactions" task

The Invoice, Receipt & PDF Table to JSON/Markdown OCR Actor will start running based on the input automatically. You can also change all the input fields, like document urls, OCR mode, and more, to match your specific use case.

### 3. Receive the "Convert bank statement PDFs to JSON transactions" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as source url, table count, and tables (json).

### 4. Integrate into your workflow

The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow. You can also [run the "Convert bank statement PDFs to JSON transactions" task via API](https://apify.com/panix/invoice-table-json-extractor.md).

## FAQ

### Which banks does the bank statement task support?

The bank statement to JSON task does not depend on the bank: it finds the tables on each page, so statements from any bank work when the transactions are laid out as a table. Scanned statements are read with OCR.

### How do I get the transactions into a spreadsheet?

Each transaction is a JSON row under tables_json with the statement's own column headers. Map those rows into Google Sheets or your accounting tool with Make, Zapier or n8n, or turn them into CSV with a few lines of code.

### Is my statement sent to an AI service?

The bank statement to JSON task runs its models inside your own Apify run, and nothing is sent to an outside AI service. The results stay in your account under your data retention settings.

### How much does the bank statement to JSON task cost?

The bank statement to JSON task costs $0.005 per digital page on the Apify Free plan and $0.0045 on Starter, less on bigger plans, plus $0.004 per run. Scanned pages cost $0.02 on Free and $0.018 on Starter.

## About this Actor

This example demonstrates how to use [Invoice, Receipt & PDF Table to JSON/Markdown OCR](https://apify.com/panix/invoice-table-json-extractor.md) with a specific input configuration. Visit the [Actor detail page](https://apify.com/panix/invoice-table-json-extractor.md) to learn more, explore other use cases, and run it yourself.


## How to integrate an Actor?

This Task's input is already configured above. Use it as-is rather than inventing a new one.

Do not guess an integration path. Every one of them is in the agent quickstart at https://apify.com/agents.md: the Apify MCP server, Agent Skills with the Apify CLI, the JavaScript and Python clients, the REST API, and the account-free path for an agent with no human to sign in. It also carries the rule on stating cost before the first paid run.

For full API examples (JavaScript, Python, CLI, MCP, OpenAPI), see this Task's Actor page: https://apify.com/panix/invoice-table-json-extractor.md

Each client library has reference documentation the quickstart does not restate: [JavaScript/TypeScript](https://docs.apify.com/api/client/js/docs.md) (`npm install apify-client`) and [Python](https://docs.apify.com/api/client/python/docs.md) (`pip install apify-client`).
