Bank statement PDF to a table you can analyse

Bank and credit card statements arrive as PDFs. They are easy to read and hard to work with: you can't sort them, total them by category or compare months without retyping. Many online "PDF to Excel" tools will do it, but they need you to upload one of the most sensitive documents you own.

This guide shows a private way to get your transactions into a table, check it, and analyse it in Excel or with an AI assistant.

Step 1: Download the right statement

Most banks offer statements in more than one format. Before converting a PDF, check your net banking for:

• CSV or Excel downloads of your transactions. If they exist, use them: they are already a table, and you can skip straight to step 4.
• A "text" PDF rather than a scan. Statements downloaded from net banking almost always contain real text. Statements that were printed and scanned, or photographed, need OCR, which is slower and needs more checking.

Password-protected statements (common for emailed ones) need to be opened with the password and saved again without it. In most PDF viewers, printing to a new PDF does this. Docuflat never asks for the password.

Step 2: Convert the statement to Markdown

Drop the PDF onto the converter. It runs in your browser, so the statement is not uploaded anywhere.

You'll get one section per page. Each transaction appears as a line of text, with the date, description, amounts and balance in the order they are printed:

## Page 2

03/10/2026 UPI/RAMESH KIRANA/123456 1,250.00 48,310.50
04/10/2026 NEFT-SALARY OCT 85,000.00 1,33,310.50
05/10/2026 ATM WDL KOLKATA 5,000.00 1,28,310.50

The text is all there, but a statement's columns (debit, credit, balance) are only implied by their position on the page.

Step 3: Rebuild the table

You have two options.

With an AI assistant. Before pasting, replace your account number, name and address with placeholders, and delete anything the task doesn't need (see redacting text). Then ask:

Turn these bank statement lines into a Markdown table with the columns Date, Description, Debit, Credit, Balance. Use the balance column to decide whether each amount is a debit or a credit. Don't change any numbers, and don't skip any lines.

The balance trick matters: on most statements, a line has either a debit or a credit, and you can tell which by whether the balance went down or up.

In Excel or Google Sheets. Paste the lines into column A, then use Data → Text to Columns with "space" as the separator, and fix the description column, which will be split into several cells. This is slower but keeps everything on your computer.

Step 4: Check it before you trust it

This is the step people skip, and it's the one that matters. Three quick checks catch almost every problem:

1. Count the rows. The number of transactions in your table should match the statement. Most statements print a count, or you can count the lines per page.
2. Check the totals. Add up the debits and credits and compare them with the totals in the statement summary.
3. Check the running balance. Opening balance, plus credits, minus debits, should equal the closing balance. If it doesn't, find the first row where your running balance and the statement's balance differ: that's the mistake.

If you used OCR on a scanned statement, also check every amount against the original. A 3 read as 8 changes the totals and the balance check will find it.

Step 5: Analyse

With a checked table, you can ask useful questions, in Excel or an AI assistant:

• "Group these transactions into categories (groceries, fuel, bills, EMIs, transfers) and total each one."
• "List every recurring payment and how often it occurs."
• "Which UPI payees did I pay most often this quarter?"
• "Compare spending by category between September and October."

Ask the assistant to show its working, or list the rows in each category, so you can see how it decided.

Related

• Tables in other PDFs: How to extract a table from a PDF.
• If you already have the spreadsheet, Excel to Markdown turns it into a table an AI assistant can read, and the guide on feeding spreadsheets to ChatGPT and Claude explains how to shape it.

Keep it private

• Convert in the browser rather than uploading the statement to a free online converter.
• Remove account numbers and personal details before pasting into an AI tool, and check your AI plan's data settings.
• Delete working copies you no longer need. A Markdown file of your transactions is as sensitive as the statement itself.