Skip to content

Bank statement to Excel

Your statement as a spreadsheet, without uploading it anywhere.

Drop your bank statements here

PDF statements or CSV downloads; several months at once is fine. They're read in this tab and never uploaded.

How to use Bank statement to Excel

  1. Drop statement files. Drag one or more PDF bank statements or bank CSV downloads (up to 15 MB) onto the drop zone, or enter a PDF password if prompted.
  2. Review balance checks. Inspect the preview table, summary totals, and any highlighted rows where the running balance does not match the statement.
  3. Adjust date and sign options. Set Dates in the statement to Day first or Month first if needed, and check Swap money in and out for credit card files.
  4. Choose format and export. Select Excel (.xlsx), CSV, CSV for QuickBooks, CSV for Xero, OFX, or QBO, then click Convert transactions.

Everything you type stays in this browser on your device. Nothing is uploaded, and your saved details are never sent anywhere.

How does local PDF parsing and running-balance verification work?

The converter reads embedded text lines directly from your PDF with pdf.js, detects transaction dates at the start of each line (YYYY-MM-DD, DD/MM/YYYY, MM/DD/YYYY, or month-name formats), and aligns money-out, money-in, and balance columns from headers or coordinate geometry. Every row’s running balance is then checked mathematically against the printed balance on the statement.

If your bank PDF is encrypted with an owner or user password, you can remove a PDF password before batch conversion or enter the password when prompted during loading.

Detecting date prefixes, column alignment, and currency formats

Positioned text lines are parsed in a Web Worker using src/lib/business/bank-statement.ts. The money parser recognizes leading or trailing minus signs, parentheses for debits ((45.00)), and both period and comma decimal separators (1,234.56 or 1.234,56).

Exported spreadsheets conform to IETF RFC 4180 CSV Format Specification quoting rules so merchant descriptions containing commas never shift columns.

Reading scanned statements with on-device OCR and unlocking PDFs

When a PDF page has no selectable text layer, the loader switches automatically to local OCR (piecesOrOcr) and marks affected pages in the status banner. If no text can be extracted even after OCR, the tool prompts you to try a clearer scan or download the native PDF from online banking.

Comparing Excel, CSV, QuickBooks, Xero, and OFX export formats

Selecting the right Save as radio option depends on your workflow: auditing expenses in a spreadsheet or importing a bank feed into accounting software. Each option formats dates, signs, and headers for its target destination as described in the Xero Central Bank Statement Import Specification.

When your goal is specifically QuickBooks Desktop Web Connect (.qbo), you can also start directly in the dedicated QBO Web Connect converter with INTU.BID preselected.

Save as format File extension Signed vs split amounts Best target workflow Key constraint
Excel .xlsx Separate Money out and Money in Financial audits and pivot tables Built locally via xlsx worker
CSV .csv Separate Money out and Money in Universal spreadsheet import UTF-8 comma-delimited
CSV for QuickBooks .csv Accounting-ready columns QuickBooks Online manual upload Strip currency symbols
CSV for Xero .csv Signed amount layout Xero Import a Statement Consistent date order
OFX .ofx Signed <TRNAMT> tags Xero, QBO, Quicken, Sage ASCII charset 1252
QBO .qbo Signed <TRNAMT> + INTU.BID QuickBooks Desktop Web Connect Requires Intuit bank ID

Fixing date ambiguity, credit card signs, and column mismatches

Banks across the US, UK, Canada, Australia, and Europe print numeric dates differently, and credit card PDFs often invert debit and credit signs. Checking the Summary panel and highlighted preview rows catches these layout quirks before importing into your ledger.

Resolving DD/MM vs MM/DD date order across international banks

By default, Dates in the statement is set to Work it out, which inspects all numeric dates across the PDF to infer whether day or month comes first. If every date in a short statement is 12 or below (such as 03/04/2026), switch manually between Day first (25/03) and Month first (03/25).

Swapping money in and out for credit card statements

Credit card statements frequently list purchases as positive numbers and repayments as credits. Ticking Swap money in and out flips those columns live across the preview table and recalculates Money in and Money out totals immediately.

When exporting to OFX or QBO under the Open Financial Exchange 1.0.2 Technical Specification, you can also switch Account to Credit card (CREDITCARD) and select from 10 supported currencies (USD, GBP, EUR, CAD, AUD, NZD, CHF, SEK, NOK, DKK). If you already have a bank CSV file, use turn cleaned bank CSV downloads into OFX files to skip PDF parsing.

Multi-month batches, record retention, and client-side privacy

Bookkeepers preparing quarterly or annual tax filings often need to combine twelve monthly PDFs into a single ledger file. Dropping multiple PDFs or bank CSVs (up to 15 MB each) merges every transaction sequentially into one download.

Combining multiple statement PDFs and 15 MB bank CSVs

The preview table renders up to 300 rows on screen so your browser stays responsive on large batches, while Convert <N> transactions writes the full dataset to disk. Transactions without a readable date are excluded from OFX/QBO exports and reported in the status note.

For European corporate accounts using structured bank files instead of PDFs, try MT940 to CSV & Excel to extract SWIFT :61: and :86: narratives directly.

Tip: Drop twelve monthly PDFs together in one batch to verify opening and closing totals across the year before exporting a single .xlsx workbook for your accountant.

Zero-upload browser processing and accounting retention scope

Because parsing, OCR, and workbook generation run inside your browser tab, account numbers and balances never touch an external server. Store your original PDFs and reconciled exports according to statutory timelines such as the IRS Business Record Retention Guidelines (3 to 7 years depending on filing type).

This converter prepares transaction data for operational bookkeeping convenience and does not replace certified accounting review or audit verification. Always reconcile ending balances against your bank’s official statement before filing tax returns.

Questions

Is it safe to convert a PDF bank statement in a browser without uploading?

Yes. Statement text extraction, OCR on scanned pages, balance checks, and Excel or CSV file creation all execute inside your browser tab and Web Worker. You can disconnect from the internet after loading the page and conversion still works.

Can scanned image bank statements be converted to Excel or CSV?

Yes. When a PDF page contains no embedded text layer, the converter runs on-device OCR automatically and flags scanned pages in a status note. Because OCR can misread digits on low-resolution scans, review any highlighted balance mismatches carefully.

What is the difference between QuickBooks CSV and Xero CSV exports?

QuickBooks CSV formats dates and columns to match QuickBooks Online import rules, while Xero CSV aligns columns with Xero's statement mapper. Both formats remove currency symbols and keep signed amounts clean for accounting imports.

Why do credit card statements sometimes reverse money in and money out?

Many card issuers print charges as positive amounts and payments as negative amounts, which is the opposite of a checking account. Checking Swap money in and out flips those two columns before you export.

How many transactions are shown in the preview table versus the downloaded file?

The on-screen preview table displays up to the first 300 rows to keep scrolling responsive. Every parsed transaction across all uploaded PDFs or CSVs is included in the downloaded Excel, CSV, OFX, or QBO file.

What happens if a bank CSV file is larger than 15 MB?

CSV uploads are capped at 15 MB per file to prevent browser tab memory exhaustion. Split multi-year CSV exports into yearly or quarterly chunks before dropping them into the converter.

Updated