PDFCellsConvert a bank statement PDF to Excel
Open the statement in PDFCells, check the transaction table against the page, and download an .xlsx file. Amounts become real Excel numbers, and when PDFCells recognises a running balance column, each printed balance is checked against the rows before it.
Steps
- Go to pdfcells.com and choose the PDF, or drop it on the page. Drop several files to open them as a batch. A password-protected PDF asks for its password.
- Every page is pre-checked and gets a read method: PDF text for pages with a text layer, OCR for scans, or AI for pages you choose.
- Each table opens in an editable grid next to the page. Totals that don't add up, balances that don't tie, text in a number column and cells OCR was unsure of are flagged. Fix any cell, merge or split columns, or undo. A statement whose balances all tie needs no fixing.
- Choose Excel (.xlsx) in the export bar and download. Tables that continue onto the next page are joined into one sheet.
What you get in the workbook
| Part | What it holds |
|---|---|
| Transaction table | An Excel Table with the statement columns as printed. Amounts in parentheses, with a trailing minus or with a currency symbol become signed numbers. Header rows are frozen. |
| Line | Added when the table has a running balance, so rows can be found after sorting. |
| Balance check | When the running-balance check applies, a live formula per row: previous balance plus this row’s amount minus the printed balance. It reads 0 when the row ties. It uses SUMIFS on the Line column, so it stays right after you sort. |
| Payee and Category | Optional. Payee is the description cleaned up (card digits, store numbers and processor prefixes such as SQ * removed). Category comes from your own rules, then a built-in keyword list. |
| By month, By description, By category | Optional summary sheets of live SUMIFS/COUNTIFS formulas over the table. |
| Audit | How each page was read, which checks passed, what is still open and which cells you edited. |
How the checks work on a statement
- Balance ties: each printed balance must equal the previous balance plus that row’s money in minus its money out. A row with an amount but no balance (some banks print one balance per day) carries into the next printed balance. When one cell breaks the pattern, PDFCells names that cell. The check switches on once at least three balances in a row tie and most of the table agrees, so a very short statement may get no balance check, and the first transaction is only checked when an opening balance is printed.
- Opening and closing balances tie: the summary’s opening balance plus credits minus debits must equal the closing balance.
- Footed: a row labelled Total must equal the rows above it. A table whose totals all add up is marked Footed.
Dates and signs
Dates are read month-first or day-first per column: a day above 12 anywhere in the column decides. In the Excel sheet amounts stay as printed in their own columns; the statement formats (CSV, OFX, QBO, Xero) sign every amount so money in is positive and money out is negative.
Many statements print dates as month and day only (01/15), with the year only in the statement period. For the statement formats (OFX, QBO, Xero CSV and the bank CSV), PDFCells takes each date's year from the printed period, so December dates on a January statement get the earlier year. When the page prints no period, the export panel's Statement year picker asks for the year, and those formats stay off until you pick one rather than guess. In the Excel export these dates stay as printed text.
Limits and cost
One file can have up to 300 pages. A batch holds up to 200 files and 2,000 pages in all.
Reading the PDF text and OCR are free, need no account and run in your browser. AI reading is optional: signed-in users get 25 free AI pages a day on the Fast model, then prepaid credits at Anthropic's token cost plus 15% (packs of $10, $25, $50), or no markup with your own Anthropic API key.
If your bank already offers a download
Most banks let you download recent activity as CSV or a Quicken/QuickBooks file from online banking, usually covering a limited window such as the last 90 days to 2 years (see bank-by-bank notes). For that window the bank’s own file is the simplest source. A PDF converter is for everything else: older statements, closed accounts, statements a client emailed you, and scans.
Questions
Is it free to convert a bank statement to Excel?
Yes. Statements with a text layer (the usual download from online banking) are read from the PDF text in your browser, free and without an account. Scanned statements use free in-browser OCR. Only the optional AI reading costs credits, after 25 free pages a day for signed-in users.
Does my bank statement get uploaded?
No. The PDF is opened and converted in your browser. Nothing is sent unless you choose an AI feature for a page.
Will the numbers be real numbers in Excel?
Yes. Amounts, negatives in parentheses or with a trailing minus, currency symbols and decimal-comma formats become numbers you can sum. Full dates become Excel dates.
Can I convert many statements at once?
Yes. Drop up to 200 files (2,000 pages in all) to open them as a batch. A batch exports one workbook with a Source file column, or one statement file per format.
What if a balance doesn’t tie?
The review names the page and row, for example "Balance doesn’t tie on page 1, row 11: Credit should be 397.86". Correct the cell in the grid and the check passes.