Convert bank statement to Excel

Extract transaction tables from bank statements directly into Excel.

Other Doclium tools

All-in-one document tools.
Simple. Fast. Free.

Scan, chat with, and transform your documents. Convert, compress, merge, split and more — free to use.

Drag & drop your PDF here or PDF up to 50MB · or scan with your camera
Try instant demo:

Three workflows a generic PDF converter does not cover.

Popular document tools

Compress, convert, edit and organise files in the formats people use most.

Smart document tools

Extraction, checking and question-answering for when converting a file is not enough.

A bank statement is a picture of a table, not a table. Doclium reads the rows back out of it — date, description, debit, credit and running balance — and writes them into a real Excel workbook where the numbers are numbers, so SUM and filters work on the result. What makes it trustworthy is that every row is checked against the statement's own arithmetic. If the previous balance plus or minus the amount does not equal the new balance, that row is flagged for review instead of being exported as though it were certain. That check is also what decides whether an amount was money in or money out on a single-column statement, where no amount of column-guessing can tell you. It reads US month/day and UK, European and Indian day/month dates, and works out which convention a statement uses from the statement itself rather than assuming — a date part above 12 settles it, and otherwise the reading that puts the statement in a shorter period wins. The workbook records which way it read them, so you can check.

🔒 Never used for AI training: delete a document and it is gone from the server.
⚡ No watermarks: on any tool, including the free tier.
↩ Undo: step back through your last 10 edits.

How to convert bank statement to Excel

  1. 1Upload the statement PDF. A scan or a photo is read with OCR first, automatically.
  2. 2Doclium finds the transaction rows and reads date, description, amounts and balance.
  3. 3Every row is checked against the running balance; anything that does not reconcile is flagged.
  4. 4Download the .xlsx: transactions, a summary, the rows needing review, and how it was extracted.

Questions people ask

Will debits and credits end up in separate columns?

Yes, and on a statement with a single amount column the direction is worked out from the running balance rather than guessed: if the balance went down, it was money out.

Does it work on scanned statements?

Yes. If the PDF has no text layer, OCR runs automatically as part of the export — you do not have to run it yourself first. Accuracy then depends on the scan; a clean 300dpi scan reads well, a faint fax-grade one is noisier.

What happens when a figure is wrong or unreadable?

It is flagged rather than quietly exported. The workbook has a Review Required sheet listing those rows with the reason, for example “balance continuity suggests 1,200.00, extracted 8,500.00”. A wrong number that looks as confident as a right one is the failure mode this is built to avoid.

Can it tell if a transaction is missing entirely?

Often, yes. Opening balance plus credits minus debits should reach the closing balance; when it does not, the summary says so, because a dropped row leaves every remaining row internally consistent and per-row checks cannot see it.

Are the amounts real numbers in Excel?

Yes. Amounts are written as numeric cells with two decimal places, so SUM, AVERAGE and filters work immediately. Account numbers and reference codes stay as text so leading zeros are not lost.

Is my financial data private?

Your statement is uploaded to Doclium's servers and stored so the export can run on it. It is never used to train AI models, and deleting the document removes the file from the server.

Related tools

Explore all tools

NEWCheck a document before you send itFind what is wrong before someone else does.NEWExtract data from a PDFPull totals, dates and references into a table you can use.AIChat with a PDFAsk anything about your document and get answers with verifiable page citations.AISummarize a PDFGet the key points of a long document, each one cited back to its page.AITranslate a PDFRead a document in another language, side by side with the original.AIConvert PDF to MarkdownTurn a PDF into clean Markdown you can paste into docs, wikis or a repo.NEWCompare two documentsSee exactly what changed between two versions.NEWCheck a document before sendingCatch unfilled placeholders, wrong totals, and exposed sensitive data.NEWCheck contract before signingAudit contract clauses, deadlines, signature fields, and hidden liabilities.NEWPrepare documents for applicationVerify document requirements, page limits, and file constraints before submission.NEWCheck PDF for sensitive informationScan documents for exposed credit cards, personal data, and confidential text.NEWCompare contracts for changesHighlight alterations, deleted clauses, and modified wording between two contracts.NEWCheck NDA before signingAudit NDA clauses, term limits, exclusions, and required signature lines.AIAI PDF summarizerGenerate instant executive summaries and bullet points from any PDF document.AIFree ChatGPT for PDF alternativeAsk questions about your documents with exact page citations and zero cloud training.Convert PDF to WordTurn a PDF into a visually exact .docx with one Word page per PDF page.Convert Word to PDFTurn a Word document into a PDF that looks the same everywhere.Convert Excel to PDFTurn a spreadsheet into a PDF anyone can open and print.Convert PDF to ExcelPull tables out of a PDF into a real spreadsheet.Convert bank statement to ExcelExtract transaction tables from bank statements directly into Excel.Extract invoice data from PDFPull totals, line items, dates and references from invoices into a table.Convert image table to ExcelTurn photos and scans of tables into editable Excel spreadsheets with OCR.Convert receipt to CSVExtract totals, tax, and itemized rows from receipts into CSV or Excel.Extract invoice line itemsExtract itemized invoice rows, quantities, and totals into structured tables.Convert PNG to ExcelConvert PNG table screenshots and images directly into Excel (.xlsx).Password protect a PDFAdd a password so the file can't be opened without it.PDF converterConvert to and from PDF — Word, Excel, PowerPoint, images and more.Convert PDF to JPGRender each page as an image you can use anywhere.Convert JPG to PDFTurn photos and images into a single PDF, in the order you choose.Convert HEIC to PDFConvert iPhone HEIC photos into clean, universally shareable PDF pages.Rotate PDF pagesTurn sideways or upside-down pages the right way up.Delete PDF pagesDrop the pages you don't need and keep the rest.Add page numbers to a PDFNumber the pages of any PDF in one step.OCR a scanned PDFRecover the text from a scanned document so it becomes searchable.Redact a PDFRemove sensitive words for good — the text is deleted, not just hidden.Add a watermark to a PDFStamp text across every page — CONFIDENTIAL, DRAFT, or anything you choose.Add a header or footer to a PDFPut a running header or footer on every page, with page numbers and dates filled in.Resize a PDF to A4 or another paper sizeMake every page one consistent paper size, scaled to fit rather than stretched.Highlight text in a PDFMark up every occurrence of a word or phrase in the colour you choose.Sign a PDFDraw or upload your signature and place it exactly where it belongs.Whiteout a PDFCover marks, stamps or stray text with a clean box.Crop a PDFTrim margins and scan edges, on one page or every page.Add an image to a PDFDrop a logo, photo or stamp onto any page.Convert images to PDFCombine photos, screenshots and scans into a single searchable PDF.Convert PowerPoint to PDFTurn a deck into a PDF, one slide per page.Convert HTML to PDFTurn an HTML file into a PDF that prints and shares cleanly.Organize a PDFReorder, rotate and remove pages until the document reads properly.Convert PDF to PowerPointTurn a PDF back into a deck, one page per slide.Repair a damaged PDFRebuild a broken file so it opens again.Fill a PDF formComplete a form and lock the answers before sending.Flatten a PDFFreeze a document so nothing in it can be edited.Remove PDF metadataStrip author names and hidden data that survive redaction.Convert PDF to textGet the words out of a PDF as plain text.Compress PDF to 100KBReduce PDF file size to under 100KB for application and government portals.Compress PDF to 200KBShrink PDF documents to under 200KB while preserving text clarity.Compress PDF to 500KBResize large PDF files to under 500KB for email and web uploads.Remove metadata before sharingStrip author names, software tags, and hidden revision metadata from PDFs.Merge bank statementsCombine multiple monthly bank statements into a single chronological PDF.Redact PDF for court filingPermanently remove sensitive text so it cannot be selected, copied or searched.Flatten PDF form for submissionLock filled form fields into permanent, read-only document pages.Combine tax documents into one PDFMerge tax forms, W-2s, 1099s, and expense receipts into one clean file.Convert scanned handwriting to textExtract readable digital text from scanned handwritten notes and forms.Compress PDF to 50KBReduce PDF size to under 50KB without losing critical document readability.Compress PDF to 300KBTarget exact 300KB file size while keeping text and graphics clear.Compress PDF to 1MBShrink high-resolution PDF documents to under 1MB quickly.Convert CSV to PDFTurn raw comma-separated data into a readable PDF.Convert TXT to PDFTurn a plain text file into a shareable PDF.Convert RTF to PDFConvert rich text to a PDF that looks the same everywhere.Convert ODT to PDFConvert an OpenDocument file to PDF, layout intact.Convert ODS to PDFConvert an OpenDocument spreadsheet to a shareable PDF.Free PDF editor with no watermarkEdit text, annotate, sign, and crop PDFs with clean output and no watermark.Private PDF editorYour documents are never used to train models, and deleting one removes it from the server.Edit text in a PDFFind and replace words throughout a PDF, keeping the original styling.Edit a PDFDouble-click any line to change the text — it keeps the document's own font. Highlight, sign, cover mistakes and crop too.Merge PDF filesCombine several PDFs into a single document, in the order you choose.Split a PDFPull out a page range as its own document. The original stays as it is.Compress a PDFShrink large PDFs by re-encoding images, and see exactly how much you saved.
Free to use No account, no signup, no payment.
Encrypted in transit Your library is private to your device. Privacy policy.
Answers you can check Every AI answer cites the page it came from.
Works everywhere Install it as an app on phone or desktop.
Doclium makes documents simple.

Get in touch

Questions, problems, or a document Doclium handled badly — tell us and a person will read it.

You're Offline
Please check your internet connection and try again.
No document open
Workspace
Open a document to read it here. Ask a question and the cited pages are highlighted.
Ask Doclium
Open a document from Library, then ask it something.
Most used
Document Actions33

Review

Edit

Pages

Convert

Optimize

Protect

Search
Encrypted in transit. Never used to train models.

Doclium

Scan, chat with, and transform your documents.

Popular document tasks

Recent Documents

No document open

AI Actions

Edit & Convert

Organize

Tools

Everything you can do to a document, in one place.

Most used

Doclium Ready

AI

Extract

Convert from PDF

Convert to PDF

Organize

Optimize

Edit

Security

Sign

Profile

Account, storage, and appearance.

?
Not signed in
Free plan
— of —
Help & Support › Privacy policy ›

Upload Document

Drag & drop your file here or Supports: PDF, PNG, JPG, JPEG · Max file size: 50MB

Recent Files

Capture page 1

Drag corners to the page edges
Enhance
Review pages