Convert PDF Bank Statement to Categorised Excel

Choose Categorised Excel in More formats after conversion. The workbook adds rule-based category labels and a By Category sheet with totals for the entire statement. Review the labels and rebuild totals after editing them.

Drop your PDF here or

browse to upload

See How It Works

2 free pages a day 1,000+ banks supported Files deleted in 24h

How to convert a PDF bank statement to Categorised Excel

Download your bank statement as a PDF from your online banking portal.
Drop the PDF into the upload box above (or click to browse). Files up to 25 MB are supported.
Wait while the converter extracts the statement. Processing time depends on the document.
Open More formats and select Categorised Excel. Your first 2 pages each day are free.

Why Categorised Excel?

Categories help group transactions for review. This export assigns labels using ordered description keywords, then creates a summary snapshot. Your review supplies the context a merchant name alone cannot provide.

Summary, Transactions, and By Category worksheets
Date, Description, Category, Debit, Credit, and Balance columns
Ordered keyword rules with Uncategorised for unmatched descriptions
Transaction counts, debit totals, credit totals, and net per category
Categorised CSV also available for a flat transaction table

What gets extracted from your statement

Transaction date (normalised to YYYY-MM-DD)
Transaction description; available details depend on the source PDF
Debit and credit amounts; Excel and CSV use separate columns, while QBO uses signed transaction amounts
Running balance, where the statement shows one
Statement period, opening balance, and closing balance
Account holder name and account number (header only)

Convert Categorised Excel for any bank

Our parser is bank-agnostic — it reads the layout of your statement directly rather than relying on a hand-written template per bank. That's how we support 1,000+ banks worldwide. Common ones below:

Chase Bank of America Wells Fargo Citibank Capital One U.S. Bank PNC Bank Truist American Express Discover HSBC Barclays View all 1,000+ →

Categorised Excel conversion FAQ

How are categories assigned?

The first matching description keyword rule wins. Income, refund, and transfer rules precede merchant rules. Labels need review and do not automatically match your accounting chart of accounts.

Will editing a category update the summary?

No. By Category is a static snapshot. Build and refresh a PivotTable or recalculate totals after edits. Editing Excel does not change the stored extraction.

Does the summary split spending by month?

No. It groups the full uploaded statement by category. Add your own date grouping in a spreadsheet for monthly reporting.

Need a different format?

Try a free conversion