Bank Statement PDF to CSV/JSON Converter

Turn bank statement PDFs into clean, reconciled transaction data — dates, descriptions, signed amounts, and running balances — ready for QuickBooks, Xero, Excel, or your data pipeline.

Why this one

Balance-validated extraction. Most PDF extractors hand you rows and hope. This Actor recomputes the running balance across every transaction and checks it against the statement's own opening and closing balances:

• RECONCILED — opening + all transactions = closing. The extraction is provably complete and correct.
• EXTRACTED_WITH_MISMATCHES — rows extracted, but the math doesn't close; mismatchRows tells you exactly which rows to review.
• EXTRACTED_UNVERIFIED — the statement doesn't print balances, so no check was possible.

You only pay the reconciliation fee when the check passes.

Your files are never stored. Statements are processed in memory and discarded. The only output is the transaction dataset in your own account. No file retention, no third-party calls.

Input

Field	Description
pdfUrls	Direct links to one or more statement PDFs (signed S3/Drive/Dropbox links work)
pdfBase64	Alternative: a single PDF inline as base64 — convenient from agents/API
outputFormat	csv-ready (one row per transaction, default) or json (nested per statement)
dateFormat	iso, us, or eu
strictReconciliation	Mark non-reconciling statements as failed instead of returning best-effort rows

Output (csv-ready)

{
  "source": "https://.../statement-jan.pdf",
  "status": "RECONCILED",
  "date": "2026-01-14",
  "description": "ACH DEPOSIT PAYROLL ACME LLC",
  "amount": 2450.00,
  "balance": 5121.37,
  "page": 2
}

Export to CSV/Excel directly from the dataset tab, or pull via API.

Who this is for

• Bookkeepers & accountants — client statement backlogs into your ledger without retyping
• Lenders & underwriters — cash-flow analysis from applicant statements
• AI agents (via MCP) — a callable tool that returns structured, verified transactions
• Anyone migrating banks or reconstructing records for taxes

Notes & limits

• Works on text-based PDFs (the kind your bank generates). Scanned/photographed statements need OCR — not yet supported; on the roadmap.
• Layouts vary by bank. The parser handles the common single-column transaction formats (date … description … amount [balance]). If your bank's layout fails, open an issue with the layout shape (never send a real statement) and it gets fixed fast.
• Output is provided as-is, without warranty, and is not accounting, tax, or financial advice. Verify reconciliation status before relying on extracted data.

Pricing

Event	Price
Run start	$0.02
Per page processed	$0.04
Per statement reconciled	$0.10 (only when the balance check passes)

A typical 5-page statement: $0.32 — versus a $30+/month converter subscription or 30 minutes of retyping.

FAQ

Is my bank statement stored anywhere? No. Files are fetched into memory, parsed, and discarded. The only output is the transaction dataset in your own Apify account, which only you control.

How do I know the extraction is correct? Every statement is reconciled: opening balance + all transactions must equal the closing balance printed on the statement itself. status: "RECONCILED" means the math closes — the extraction is provably complete. You only pay the reconciliation fee when this check passes.

What if my bank's layout isn't supported? Open an issue describing the layout shape (columns, date format — never a real statement). Common-layout gaps are usually fixed within days.

Does it handle scanned statements? Not yet — text-based PDFs only (the kind your bank's website generates). OCR is on the roadmap.

Can I use this from an AI agent? Yes — the Actor is callable via MCP (see the API tab), and the pdfBase64 input means agents can pass files without a hosting step.

What does a typical statement cost? A 5-page statement: $0.02 (run) + $0.20 (pages) + $0.10 (reconciliation) = $0.32. No subscription.

Changelog

• 2026-08-22 — Demo mode: run with empty input to see the output shape on a bundled synthetic statement.
• 2026-08-20 — Launch: balance-reconciled extraction, EU/US formats, accounting negatives, multi-page statements.

---

More tools by Businessquik

Verified data tools built on official and public-mandate sources — no logins, no gray areas, no fragile scrapers:

• Hospital Price File Normalizer — comparable hospital prices from CMS MRFs
• FDA Recall Monitor — new-recalls-only alerts for drugs, devices & food
• Patent Signals — filing velocity, new entrants & expiry intel
• US Location Profile — economy, labor & weather in one call

Support: open an issue on this Actor's Issues tab — layout/format reports are usually fixed within days. Describe the shape of your file or query; never post real bank statements or sensitive data.