Bank statement converter
Upload a PDF bank statement and download an Excel workbook with one row per transaction: date, description, debit, credit, and balance. A free account with no credit card includes 100 AI credits a month, and a text-based statement uses 1 credit with Table Extract. Scanned statements work too with AI Extract.
Updated
This is a synthetic illustration, not a result produced by the converter. It shows sample statement entries and the corresponding columns to verify in an exported spreadsheet.
| Date | Description | Amount | Balance |
|---|---|---|---|
| Jul 2 | Market Grocer | -$42.50 | $957.50 |
| Jul 3 | Payroll Deposit | +$1,250.00 | $2,207.50 |
| Jul 5 | Electric Bill | -$125.00 | $2,082.50 |
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| Jul 2 | Market Grocer | $42.50 | — | $957.50 |
| Jul 3 | Payroll Deposit | — | $1,250.00 | $2,207.50 |
| Jul 5 | Electric Bill | $125.00 | — | $2,082.50 |
Reconciliation checks for this example
Opening balance: $1,000.00 · 3 transactions · Deposits: $1,250.00 · Withdrawals: $167.50 · Ending balance: $2,082.50.
Compare transaction count, dates, debit/credit signs, and beginning and ending balances with the source PDF. A matching total does not guarantee every row is correct.
Before uploading financial documents, review the privacy policy and its data-retention terms. Do not upload information you are not comfortable processing through the service.
Copying a statement into Excel by hand means retyping every date and amount, and one slipped digit stops the balance from matching. The converter does the retyping; you do the checking.
Sign up with no credit card, then open the PDF converter. Uploading here on this page takes you there after sign-in.
Add the statement you downloaded from online banking, or a scan of a paper statement. The converter shows the file-size limit and the credits the job needs before you start.
Use Table Extract for a text-based statement with a clear transaction table; it uses 1 AI credit per file. Use AI Extract for scans, photos, or unusual layouts; name the columns you want and pick the pages to convert, so summary pages stay out. It uses 10 AI credits per page. A quick test: if you can highlight a single word in the PDF, it has real text.
Download the Excel file, then compare the transaction count and the opening and closing balances with the PDF, as in the example above. You can also choose Analyze in chat to ask questions about the converted transactions.
For invoices, reports, and other PDFs that aren't bank statements, use the general AI PDF to Excel converter; it's the same tool with the same two modes.
Table Extract keeps the columns of the statement's own transaction table. With AI Extract you list the fields you want and the converter fills them for each transaction. Most statements map to these columns:
| Column | What it holds | What to check |
|---|---|---|
| Date | Posting or transaction date | Day and month order (07/05 can be July 5 or May 7) and the year on statements that show none |
| Description | Payee, memo, or transfer details | Descriptions that wrap onto two lines in the PDF |
| Debit / Withdrawal | Money out | Signs: some banks print one Amount column with negatives instead |
| Credit / Deposit | Money in | Deposits landing in the debit column |
| Balance | Running balance after each row | The last balance matches the closing balance on the statement |
| Reference or check number | Check numbers or bank reference codes, where printed | Numbers stored as text if you plan to match on them |
The layout of the PDF matters more than the bank. A statement downloaded from online banking, whether from a national bank or a local credit union, is usually a text-based PDF with a transaction table, the easiest case for Table Extract. We don't publish a list of supported banks, because layouts change between account types and statement periods; try one statement and check it.
The converter downloads an Excel (.xlsx) workbook. If you need CSV, open the workbook in Excel and use Save As with a CSV format, or open it in Google Sheets and download it as CSV. QuickBooks Online and Xero can import bank transactions from a CSV file; arrange the columns to match what they ask for (usually date, description, and amount, or separate debit and credit columns) before importing. The converter does not create QBO, OFX, or QIF files.
No converter is right every time on every layout, so treat the spreadsheet as a draft until it reconciles. Four checks catch most problems:
With AI Extract you can also turn on Review rows for accuracy, a second pass that marks rows that may need a closer look on a separate QA sheet, at no extra AI credits.
A matching total does not prove every row is right, since two errors can cancel out, but a total that doesn't match always means something to fix. The guide to reconciling bank transactions in Excel walks through matching rows against your own records.
Bank statements hold account numbers and spending history, so it's worth knowing where the file goes before you upload it:
The security page has the full details. If you don't need account numbers in the spreadsheet, redact them in the PDF before uploading.
Check extracted dates, descriptions, debit and credit amounts, fees, transfers, and balances against the source PDF.
A spreadsheet can make rows easier to sort and inspect. Formatting and extraction quality can vary by statement.
After checking the output, you can sort transactions, categorize expenses, create pivot tables, or prepare data for another accounting workflow.
Compare the transaction count and beginning and ending balances with the statement before using the data in your records.
The real value comes after the conversion. Once your bank data is in Excel, you can:
Step-by-step guides for the most common next jobs: categorize bank transactions in Excel, combine monthly bank statements into one table, and analyze bank statements in Excel. To present the results, start from the personal financial statement template or the expense report template.
The goal isn't to replace your judgment about the numbers. It's to skip the retyping so you can spend the time on what the numbers mean.
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.
Create a free account with no credit card, upload a statement, and download it as an Excel workbook. Check the balances before you use it for bookkeeping.