Convert · Statement extraction

Bank statement to Excel,
reconciled.

Drop in any bank statement PDF and pull every transaction — date, description, debit, credit, and running balance — into a clean .xlsx workbook ready to import into Xero, QuickBooks, or Excel-based reconciliations.

Explore More Tools
No signup, ever 100% local · nothing uploaded Multi-currency aware Esc to close
Every txn
Date · debit · credit
Balance
Running column captured
Local
100% in browser
Free
25 MB free tier

01 — What you get back

From PDF reconciled spreadsheet.

Every transaction line — date, description, debit, credit, balance — split into clean columns. No copy-paste, no manual cleanup.

SAMPLE.PDF
3 pages · sample-statement.pdf

Bank

Northwind Banking Corp.

2026-05-01
to 2026-05-31

Account holder
Sonchoy Studio Ltd.
Account number
XXXX-XXXX-4521
Opening balance
12,450.00
Total credits
+ 24,300.00
Total debits
18,077.60
Closing balance
USD 18,672.40
OUTPUT.XLSX
96% confidence
DateDescriptionDebitCreditBalance
2026-05-02Salary deposit — Northwind Books8,400.0020,850.00
2026-05-05Office rent — Old Street Holdings2,200.0018,650.00
2026-05-09Stripe payout — Invoice INV-26-01425,200.0023,850.00
2026-05-12AWS — monthly compute1,480.0022,370.00
2026-05-18Adobe Creative Cloud — team192.0022,178.00
2026-05-22Wire — Implementation, Northwind10,700.0032,878.00

+ 1 more transaction in the .xlsx

Need more power?

When this tool isn't enough, pdfFiller takes over.

Scanned invoices, multi-page batches, multi-currency stacks, and direct push into your accounting system. Free for 30 days, no card required.

Try Premium Free

Free 30 days · no credit card · cancel anytime

02 — How it works

Three steps from PDF to reconciled rows.

No setup, no signup. Drop your statement, wait a few seconds, download the .xlsx — works for one month, a full quarter, or a year-end statement bundle.

01

Drop the PDF

Drag your statement — one month or a full year — onto the upload tile, or browse for a file. PDF up to 25 MB on the free tier.

02

We parse the lines

Every transaction line is detected and split into date, description, debit, credit, and running balance — with totals checked against the closing balance.

03

Download the .xlsx

A clean workbook with Transactions, Summary, and Confidence sheets — ready for QuickBooks, Xero, or any Excel-based reconciliation.

03 — What gets extracted

Every line that a bookkeeper would type.

Account header

Bank name, account holder, account/IBAN number, branch, and statement period.

Every transaction line

Posting date, value date, description, reference — one row per transaction.

Debit / credit columns

Money in and money out automatically split — even when the bank uses CR/DR suffixes or a single signed column.

Running balance

Balance carried after each line, reconciled against the closing balance for integrity checks.

Period totals

Total credits, total debits, opening balance, and closing balance computed automatically.

Currency aware

USD, EUR, GBP, INR, JPY, AUD, CAD and 30+ more — currency captured from the statement header.

PdfFiller · 30-Day Free Trial

When one-off documents aren't enough.

Bulk OCR, batch invoicing, multi-party e-signing, redaction, audit logs — pdfFiller picks up where Sonchoy ends. Free for 30 days, no credit card.

Try Premium FreeNo card · Cancel anytime

Batch & bulk

Run 100+ invoices, statements, or conversions in one go.

OCR scanned PDFs

Turn paper invoices into searchable, exportable data.

E-sign & request

Multi-party signatures with full audit trails.

Redact & approve

Mask sensitive ledger lines before sending to auditors.

04 — Common questions

Everything about extracting statements.

01What kind of statement PDFs work?

Anything text-based: PDFs exported from online banking, mobile banking apps, or downloaded from your bank's portal. Scanned (image-only) statements need OCR — that's available on the pdfFiller premium tier.

02Does it handle my bank's format?

Most major banks worldwide use one of three common transaction layouts (signed amount, CR/DR suffix, or two-column debit/credit), and we detect all three. If the structure is unusual, the Raw Text sheet in the workbook lets you grab anything we missed.

03How accurate is the extraction?

Typically 95–99% on clean, text-based statements. Each transaction's totals are reconciled against the closing balance — and the Confidence sheet flags any mismatch so you can spot-check before importing.

04What about multi-currency statements?

Currency is captured from the statement header and stamped on every monetary cell. For statements with mixed currencies per line, each row carries its own currency code.

05What happens to my file?

Extraction runs entirely in your browser — your file never leaves your device. Nothing is uploaded to our servers, nothing is stored, nothing is shared.

06Output formats?

Default is .xlsx with a Transactions sheet, a Summary sheet (account header, period totals), and a Confidence sheet. .csv export is one click away.

05 — Related tools

Often used together.

Browse all 91 tools