Convert PDF bank statements to Excel or CSV

Why converting a PDF bank statement is harder than it sounds

Copy-paste from a PDF into a spreadsheet almost never works. Bank statements use multi-column layouts with column headers repeated on every page, wrapped descriptions that spill onto the next line, running-balance columns that shift when the number of digits changes, and subtotal rows that break the flow of real transactions. The output of a naive copy is a mangled block of text where amounts stack in the wrong column, dates land in the description field, and every page footer contaminates the data. Manual cleanup on a twelve-month statement can eat a full afternoon.

A converter that actually works has to understand the shape of a bank statement, not just the text of a PDF. That means detecting where the transaction table starts and ends, identifying which vertical bands hold which fields, merging rows that wrap, and dropping the header, footer, and subtotal noise. Karchu does this automatically for every common statement layout without any per-bank templates or configuration.

How the conversion works

Karchu treats a PDF conversion as a three-step pipeline. First, extract the text. For digitally generated PDFs (the kind your bank produces when you download a statement from its portal), this is a text-extraction pass that preserves positional data - the x and y coordinates of every glyph. For scanned image PDFs, Karchu runs on-device OCR to convert the pixels into positioned text. Both paths converge on the same intermediate representation.

Second, structure detection. Karchu inspects the positional data to find the transaction table: a block of rows that share a consistent column geometry. Header rows, subtotals, and page footers get filtered out. Wrapped descriptions get rejoined by matching a continuation line's x-coordinate to the description column above. Multi-page statements get stitched into a single continuous table by matching the column geometry across pages.

Third, normalization. Dates are parsed into ISO 8601. Amounts are parsed with the right sign (debits negative, credits positive) regardless of whether the source used parentheses, a trailing minus, a leading minus, or paired debit/credit columns. Currency symbols are stripped. Character encoding is normalized so foreign merchant names survive the trip.

How to convert a PDF bank statement to Excel in Karchu, step by step

This is the exact procedure in the app today. It takes about three minutes for a typical monthly statement, most of which is the review step.

1. Sign in and open Upload. Sign in to Karchu and open the Upload tab. Drag the PDF statement onto the drop area or click to pick the file, then give the document a name you will recognise later, for example 'Chase checking, March 2026'.
2. Let Karchu read the pages. Karchu splits the PDF into pages, extracts the text layer, and falls back to OCR on any page that is a scan or an image. A progress grid shows each page as it finishes and an extraction quality card reports how many rows were found and how confident the parser is.
3. Check the preview before importing. The preview lists every detected transaction with date, description, debit, credit, and balance. Fix the date format if a DD/MM statement was read as MM/DD, correct the statement period if it was misdetected, and map any unknown categories from the source file. Nothing is saved until you confirm.
4. Confirm the import. Confirm the import and the transactions move into the Transactions tab, categorized by your rules, deduplicated against statements you already imported, and linked back to the source document.
5. Filter to the rows you want. On the Transactions tab, narrow the set with the date range, category, amount, and account filters, or search by merchant or description. Whatever is on screen is what gets exported, so a single statement, one category, or a full year all work the same way.
6. Export to Excel or CSV. Open the Export menu and choose Excel (multi-sheet) for a workbook with transactions, monthly totals, categories, and top merchants, CSV (transactions) for a flat file, or Export filtered CSV to pick your own columns. The download starts immediately, generated in your browser.

Two details worth knowing. The Excel export is a multi-sheet workbook, so you get monthly totals and category totals alongside the raw transactions without building a single pivot table. And the export always follows the filters on screen, so exporting one statement, one category, or a full tax year is the same three clicks.

Prefer a comparison of every conversion route, including copy and paste and Power Query? Read convert a PDF bank statement to Excel. If your target is accounting software rather than a spreadsheet, use the PDF to QBO converter instead. If you want categories and cash flow rather than just the rows, start from the bank statement analyzer.

What you get in the exported file

The exported Excel or CSV has a stable schema:

• Date in ISO 8601 (YYYY-MM-DD).
• Description as it appeared on the statement, with wrapped lines rejoined.
• Amount as a signed decimal number.
• Category assigned by the rule engine (Groceries, Rent, Subscriptions, Salary, and so on).
• Balance when the source statement includes one, or a computed running balance otherwise.
• Account when the source statement covers multiple accounts.

Columns do not change between exports, which matters when you build a downstream spreadsheet, a Power Query template, or a script that reads Karchu output on a schedule. UTF-8 encoding means merchant names with accents, umlauts, or non-Latin characters round-trip correctly through Excel, Numbers, and Google Sheets.

Scanned statements and OCR

Many banks still produce statements that are effectively images: scanned paper, or a print-to-PDF workflow that rasterizes the page. Text extraction fails on those files. Karchu detects when a PDF is image-based and switches to OCR automatically. The OCR runs in your browser, so scanned statements are processed on your device rather than uploaded to a third-party OCR API. Accuracy on typical statement fonts is well above 99%, and Karchu highlights any row where a numeric field looks ambiguous so you can double-check before exporting.

Common uses for the converted output

• Accounting software import. QuickBooks, Xero, and Wave all accept CSV imports. Karchu output drops in directly.
• Loan and mortgage applications. Lenders often ask for the last three to twelve months of statements in Excel. Karchu produces the combined file with categories in one export.
• Tax preparation. Filter the exported file by category to isolate deductible business expenses, charitable contributions, or medical spending.
• Budgeting. Import the categorized output into a personal budgeting spreadsheet or dashboard.
• Forensic and audit work. Structured data is the starting point for anomaly detection, duplicate-charge investigations, and cash-flow reconstruction.

Batch conversion

One statement is easy. Twelve is where a converter earns its keep. Karchu accepts a batch upload, converts every file, merges the transactions into a single categorized dataset, and exports the combined output. Duplicates that appear across overlapping statements are detected and deduped. Categories stay consistent across the whole batch because the rule engine is shared, so you can build a rule once during month one and it applies retroactively to every prior month.

Frequently asked questions

Convert a statement now

You do not need to commit to a workflow to try this. Sign in, drop in the last PDF statement your bank sent you, and export the Excel. If the file is cleaner than what you get from any other converter you have tried, keep going. If it is not, you have lost two minutes.