Go to example tasks

Convert bank statement PDFs to JSON transactions

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.

Try for free
Invoice, Receipt & PDF Table to JSON/Markdown OCR
Invoice, Receipt & PDF Table to JSON/Markdown OCRpanix/invoice-table-json-extractor
Source URL
Table count
Tables (JSON)
Text
Number
Boolean
List
Object

Input

Document URLs(required):https://api.apify.com/v2/key-value-stores/gZUDoFSN6sExqUTEm/records/sample-bank-statement.pdf
Extract tables as structured JSON:true

Output fields

Source URL
Table count
Tables (JSON)

How it works

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 and you'll land in Apify Console with a copy of this exact task.

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 and extract tables as structured json, to match your specific use case.

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).

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.

Image

Integrate "Convert bank statement PDFs to JSON transactions" into your workflow

Connect "Convert bank statement PDFs to JSON transactions" with 100+ integrations, or run it via API or MCP.

Webhook

Webhook

n8n

n8n

Make

Make

Zapier

Zapier

Airbyte

Airbyte

Keboola

Keboola

IFTTT

IFTTT

Hubspot

Hubspot

GDrive

GDrive

Gmail

Gmail

Apify MCP

Apify MCP

GitHub

GitHub

Slack

Slack

LangChain

LangChain

LlamaIndex

LlamaIndex

Flowise

Flowise

Pinecone

Pinecone

OpenAI

OpenAI

Mastra

Mastra

Clay

Clay

Frequently asked questions

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.

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.

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.

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.