Every bank statement in Excel, no file limit.
Chat apps stop at 10 or 20 files. Here, every transaction on every statement becomes an Excel row, with its date, description, counterparty and signed amount.
Your own API key, the AI at cost. Or BatchAI Cloud, with no key.
- One payment, lifetime license
- Free 3-day trial, no card
- 7-day money-back guarantee
- Windows and macOS
Files per batch
200 statements to Excel: chat app or BatchAI Local?
A chat app reads your statements a few at a time: 10 per message on Gemini, 20 per chat on Claude, 80 every 3 hours on ChatGPT Plus. BatchAI Local reads them all in one batch.
-
10 files per message
10 / 200
20 separate messages
-
20 files per chat
20 / 200
10 separate chats
-
80 files every 3 hours
80 / 200
3 rounds, 6 h of waiting
-
BatchAI Local
No file limit
∞
in a single batch
Limits published in the Gemini, Claude and ChatGPT help centers, checked on October 31, 2026. Every limit, AI by AI →
Getting the Excel table
With Claude: 10 chats
- 1. Open a new chat
- 2. Attach the next 20 statements
- 3. Ask for the same columns again
- 4. Copy the table from the reply into Excel
- 5. Check that the columns haven't changed
Repeat 10 times · 50 steps, then merge 10 tables
With BatchAI Local: one batch
- The whole folder at once, no file limit
- Every transaction on its own row
- Debits negative, credits positive, as real numbers
- Opening and closing balance for each statement
One Excel file · statements on one sheet, transactions on the next
Try it on five sample statements.
The columns and instruction below, on made-up statements. Download the Excel file: its second sheet lists every transaction.
Instruction: Each file is a bank statement, provided on purpose by the account holder to be turned into a table: you may read and copy all of its data. List every transaction in statement order, across all pages, one row per transaction. Debits are negative, credits positive. Balance, carried-forward and total lines are not transactions.
Batch complete
5 files · Claude Haiku 5.5 · ≈ $0.003 of AI
| File | BankText | AccountText | Period startDate | Period endDate | Opening balanceNumber | Closing balanceNumber | CurrencyText | TransactionsNumber |
|---|---|---|---|---|---|---|---|---|
| northgate_statement_2026-09.pdf | Northgate Sample Bank | GB00NSBK00000012345678 | 2026-09-01 | 2026-09-30 | 3,214.77 | 6,940.76 | GBP | 22 |
| harbor-federal_estatement_sep26.pdf | Harbor Federal Bank | 000123456789 | 2026-09-01 | 2026-09-30 | 18,402.15 | 15,696.53 | USD | 31 |
| ridgeline-cu-2026-09.pdf | Ridgeline Credit Union | 000987654321 | 2026-09-01 | 2026-09-30 | 2,210.00 | 6,884.20 | USD | 14 |
| bluewater_business_sep26.pdf | Bluewater Business Bank | GB00BWBB00000087654321 | 2026-09-01 | 2026-09-30 | 50,210.88 | 49,509.52 | GBP | 9 |
| lakeside_7731_sep26.pdf | Lakeside Commercial Bank | Not found | 2026-09-01 | 2026-09-30 | 9,120.50 | 12,097.50 | USD | 26 |
Fictional statements. Cost estimated at public prices. A value missing from a statement stays empty: the AI doesn't guess.
From PDF statements to a spreadsheet, in three steps.
-
1 Download your statements
Save the PDF statements from your online banking: they carry the text, which gives the most reliable results.
-
2 Drop the folder
Name your columns once: one row per statement, plus line items for the transactions.
-
3 Export to Excel
Statements on the first sheet, every transaction on the second, ready to filter and total.
What's in your spreadsheet.
Two sheets, exactly like the app's Excel export.
| Results sheet | One row per statement: bank, account, period, opening and closing balance, currency and number of transactions. |
|---|---|
| Line items sheet | One row per transaction: date, description, counterparty and amount, with its statement's details alongside. |
| Amount | A number, negative for a debit and positive for a credit, ready to total. |
| Date | The same format on every row, whatever the bank prints: YYYY-MM-DD, or the one you pick. |
| Counterparty | Who paid or got paid, when the statement shows it. |
| Your own columns | Add a category, a reference or anything else the statements show. |
Balance, carried-forward and total lines aren't counted as transactions.
Good to know before you start.
-
AI at cost
With your API key, about $0.33 per 1,000 pages (Claude Haiku 5.5), billed by your provider; or BatchAI Cloud, no key needed. Get an API key
-
Nothing is made up
A missing or unreadable value stays empty and flagged, never guessed.
-
PDFs from online banking work best
They carry the statement's text. Check your first batch: the transaction count per statement is right there in the Results sheet.
-
Your statements are never stored
With your key, they go straight to the AI you choose; with BatchAI Cloud, our server in Frankfurt passes them on to Anthropic and only holds them in memory.
What else BatchAI Local does.
- Resumes to Excel Every resume becomes an Excel row: name, current role, experience, skills and email.
- Contracts and resumes: a text per file Points to check, summary, translation or letter: a text for each document, following your instruction.
- One synthesis report for the folder One report that brings all the files together: analysis, comparison, anomalies. On its own, or next to the spreadsheet.
- Accounting exports and automations Accounting files for DATEV, FEC, Xero or QuickBooks (Pro), files renamed from their values (Essential), Zapier, Make or n8n (Team).
Your questions about bank statements.
Why not just upload my statements to ChatGPT or Claude?
Chat apps cap uploads: Gemini takes 10 files per message, Claude 20 per chat, ChatGPT Plus 80 every 3 hours (official help centers, checked October 31, 2026). Past that, you split the folder and stitch the replies together by hand. BatchAI Local sends each statement on its own, with no file limit per batch. Every limit, with its source.
Is it safe to send bank statements to an AI?
With your own API key, there's no BatchAI server in between: each statement goes from your computer to the provider you pick (Anthropic, OpenAI or Google), under that provider's API terms. With BatchAI Cloud, statements pass through our server in Frankfurt on their way to Anthropic, in memory only, and are never stored.
Will the AI refuse to read bank data?
Not in our test of November 2026, run with Claude Haiku 5.5 through BatchAI Cloud. The instruction shown in the sample above says the statements are shared on purpose by their holder; with it, every PDF statement was read in full, with every amount and the right opening and closing balances.
Do I need an API key to try it?
Not to see the app in action: the sample batch runs without a key. For your own statements, connect your key in the app in a minute, or try BatchAI Cloud with no key (100 pages). How to get an API key.
How many statements can I convert at once?
There's no file limit per batch: a folder of 12 statements or 1,200 is handled the same way, one file per request.
Does it work with my bank?
There's no list of supported banks: the AI reads each statement's layout. Our test covered English, French and German layouts, with carried-forward lines and two-line descriptions. Check your first batch against one of your statements.
How much does it cost?
The trial is free for 3 days from your first batch, with no card and no account. After that, a lifetime license from $79, paid once, plus tax, with a 7-day money-back guarantee. With your API key, your provider bills the AI separately at its public prices: about $0.33 per 1,000 pages with Claude Haiku 5.5. See pricing.
Can I get the transactions into my accounting software?
The spreadsheet exports to Excel or CSV, so you can import it like any other spreadsheet.
Next month's folder, done in minutes.
Free 3-day trial with everything in Essential and no file limit. Then a lifetime license from $79 with your own API key, or BatchAI Cloud from $29/month with the AI included.