How to Convert a Bank Statement PDF to Excel With AI (2026)

To convert a bank statement PDF to Excel with AI, upload the PDF to an assistant that can run code, ask it to extract every transaction into one table (date, description, money in, money out, balance), and have it check that the opening balance plus the transactions equals the closing balance before it hands you an .xlsx file. That last check is the step most guides skip, and it's the one that catches dropped or doubled rows. Scanned statements work too, but they need OCR, so expect more fixing by hand.

First, check whether you need AI at all. Most banks let you download transactions as CSV or Excel from online banking, and that file is exact. AI conversion is for the cases where the PDF is all you have: old statements, a closed account, a client who sends PDFs, or a lender or accountant who asked for a year of history in a spreadsheet.

The four steps in short

1. Upload the PDF to an assistant that runs code on files (it should write a real .xlsx, not just show a table in the chat).
2. Paste the prompt below, which sets the columns, the sign convention and the checks.
3. Read the check results: opening balance + money in − money out = closing balance, and the row count per page.
4. Download the .xlsx and spot-check five rows against the PDF before you use it.

A prompt you can copy for any AI assistant

This works in any chat assistant that can read PDFs and run code. Change the column names if your accounting software wants different ones.

I've attached a bank statement PDF. Convert it to an Excel file.

1. Extract every transaction from every page into one sheet called
   "Transactions" with these columns: Date (YYYY-MM-DD), Description,
   Money in, Money out, Balance. Use numbers, not text, for amounts.
   Leave the empty side blank rather than writing 0.
2. Keep transactions in the order they appear. Don't merge, skip or
   summarize rows. Multi-line descriptions belong to one transaction.
3. Ignore page headers, footers, adverts and "balance brought forward"
   lines, but note the opening and closing balance printed on the
   statement.
4. Add a second sheet called "Checks" with: opening balance, total
   money in, total money out, calculated closing balance (as Excel
   formulas), the closing balance printed on the statement, and the
   difference. Also list the number of transactions found on each page.
5. If the difference isn't zero, tell me which page or date range is
   likely wrong before giving me the file.
6. If any page is a scanned image, run OCR and flag every row where
   you weren't sure of a digit.

Why each line is there:

• Separate money in and money out columns stop the most common error, where a debit loses its minus sign and turns into income.
• "Don't merge or summarize" matters because chat models like to tidy up. A statement with 140 transactions should give you 140 rows.
• The Checks sheet with formulas means you can see the reconciliation yourself instead of trusting a sentence that says "all done". If the calculated closing balance matches the printed one to the cent, it's very unlikely that a transaction is missing or doubled.
• Rows per page finds the page where something went wrong when the totals don't match.

How to check the spreadsheet before you use it

The balance check does most of the work, but it can't catch everything. Two wrong rows can cancel each other out, and a correct amount can sit next to the wrong date. Before you import the file into QuickBooks, Xero or a tax spreadsheet, do these quick checks:

• Compare the row count with the number of transactions on the statement. Some statements print a count; otherwise count one busy page by hand.
• Spot-check five rows: the first, the last, the largest amount, one refund and one transaction that wraps onto two lines.
• Check dates around the year boundary. Statements that print "03 Jan" without a year are where a December-to-January statement goes wrong.
• Sort by amount and look at the top and bottom. A misread decimal point shows up as one absurd number.
• Check the running Balance column if your bank prints one. Each row's balance should equal the previous balance plus money in minus money out. Ask the assistant to add a formula column that flags any row where it doesn't.

If the totals are off, don't ask the AI to "fix it". Ask it which page has the gap, open that page in the PDF, and tell it the exact rows it missed. That's faster and you'll know what changed.

Can ChatGPT convert bank statements to Excel?

Yes. ChatGPT, Claude (Anthropic) and Gemini (Google) can all read an uploaded PDF and, with their code tools, write an .xlsx file. The prompt above works in any of them. The differences that matter for this job are whether the assistant runs real code on the file (rather than retyping the numbers from what it "sees"), whether it gives you a downloadable spreadsheet, and whether it can handle a scanned page.

Watch out for answers that print a neat table in the chat with no file and no checks. That table was typed by the model, not extracted by code, and on long statements that's where rows go missing. Reviewers of these tools have made the same point: language models can invent or drop details, so treat every conversion as a draft until the numbers reconcile.

Doing it in Zemith

Zemith runs this in a cloud sandbox with Python and the usual PDF and spreadsheet libraries (pdfplumber for tables, Tesseract for OCR on scanned pages, openpyxl and pandas for the Excel file). The model writes and runs the extraction code on your actual file, builds the workbook with real formulas, recalculates it, and puts the .xlsx in the chat's Files panel. Files and the sandbox are on the paid plans: Zemith Plus is $15.99 a month (or $179.88 a year), and the free plan is chat only.

A concrete workflow for a freelancer pulling together a year of business transactions:

1. Open a new chat at zemith.com/app, pick a model that supports tools, and choose Add photos or file to attach the statement PDFs.
2. Paste the prompt from above. Add "Combine all months into one Transactions sheet, oldest first" if you attached several.
3. Read the Checks sheet result in the reply. If a month doesn't reconcile, ask which page is off.
4. Ask for a follow-up in the same chat: "Add a Category column using these categories: software, travel, client income, bank fees, other. Then add a summary sheet with totals by category and month as formulas." The sandbox edits the same workbook.
5. Open Files in chat, preview the workbook and choose Download. If you've connected the Microsoft Excel plugin, you can ask Zemith to save it to OneDrive instead; saving a new workbook asks for your approval first.

If you do this every month, put the statements in a Library Project so the same instructions and files are there next time. Projects hold up to 50 sources on paid plans, and chats inside a project can use the same sandbox.

Zemith works for this because the same chat can then analyze the data, chart it or turn it into a Word summary for your accountant. If you mostly want analysis of spreadsheets you already have, our Julius AI alternative guide covers that side, and chat with PDF explains how Zemith reads documents in general.

What about scanned or photographed statements?

A scanned statement is a picture of text, so there's nothing to extract until OCR turns the image back into characters. Expect it to be slower and less exact than a statement downloaded from online banking:

• Ask for OCR explicitly (line 6 of the prompt) and for a list of low-confidence rows, so you know where to look.
• Check digits that OCR confuses: 1 and 7, 5 and 6, 0 and 8, and commas versus decimal points.
• Re-scan at higher quality if a page fails badly. A straight, well-lit scan at 300 dpi does far better than a phone photo at an angle.
• Rely on the balance check even more. On scanned statements it's the only thing standing between you and a typo in your books.

If every page is a poor phone photo, the honest answer is that typing the 30 transactions yourself may be quicker than correcting the OCR.

Is it safe to upload a bank statement to an AI tool?

It depends on the tool's data policy and on how sensitive the statement is. A statement contains your name, address, account number and a list of everyone you paid. Before uploading:

• Read the privacy policy of the tool you use and check whether it trains on your files and how long it keeps them.
• Prefer your bank's own CSV export whenever it exists. Nothing leaves your bank and the numbers are exact.
• Delete the chat and files when you're done if the tool lets you. In Zemith, the workspace setting Auto-delete inactive history also removes chats, their attachments and generated files after a year of inactivity.
• Follow your firm's rules if the statement belongs to a client. Accountants and bookkeepers often have to use approved software for client data.

Other ways to do it, and when they're better

• Your bank's export. Free and exact. Always try it first.
• Excel's own PDF import. In Excel for Microsoft 365 and Excel 2024 on Windows, go to Data, Get Data, From File, From PDF, and pick the tables to load (Office Watch guide, January 2026). It works well on clean, text-based statements with simple tables. It isn't available on Mac, it doesn't read password-protected PDFs, and statements whose transactions wrap across lines often come out messy.
• Dedicated statement converters. Tools like DocuClipper are built for bookkeepers who convert statements in bulk and send them to accounting software. As of October 2026, DocuClipper's pricing page lists a Starter plan at $20.30 a month billed yearly for 60 pages a month, with a 14-day trial of up to 120 pages. If you convert hundreds of pages a month for clients, a dedicated tool is the better choice.
• A general AI assistant (the method above) makes sense when you convert occasionally, your statements vary in layout, or you want to categorize, analyze or summarize the data in the same place. That's the case for most small business owners and freelancers doing their own books.

The bottom line

Download a CSV from your bank if you can. If all you have is the PDF, upload it to an AI assistant that runs code, use a prompt that forces one row per transaction and a balance check written as formulas, and don't trust the file until the calculated closing balance matches the statement. Zemith Plus does all of this in one chat for $15.99 a month and keeps going when you want the data categorized, charted or written up.