Convert a PDF Bank Statement to Excel
Drop a digital PDF bank statement and download a reconciled Excel workbook with date, description, debit, credit, and balance columns. Dates and amounts are stored as real spreadsheet types — not text.
Drag & drop your bank statement
PDF only · processed in your browser · nothing is uploaded
Choose a fileDoing this monthly or across clients?
Batch multi-file conversion and direct QuickBooks/Xero sync — join the early-access list. We only collect your email, never your statement.
How to convert a bank statement to Excel
- Drag your digital PDF statement onto the box above (or click to choose it).
- StatementTidy parses and reconciles the transactions in your browser.
- Review the preview — flagged rows are highlighted, never dropped.
- Click “Download Excel” to save a .xlsx file you can open in Excel or Google Sheets.
What you get in the workbook
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-03-02 | CARD PURCHASE OFFICE SUPPLY CO 0228 | 86.40 | 4124.15 | |
| 2026-03-05 | ACH DEPOSIT CLIENT PAYMENT INV-1042 | 1500.00 | 5624.15 | |
| 2026-03-09 | MONTHLY SERVICE FEE | 12.00 | 5612.15 |
Open it in Excel or Google Sheets
- Excel: double-click the downloaded .xlsx — no import wizard, no text-to-columns step.
- Google Sheets: upload the .xlsx to Google Drive and open it with Google Sheets, or use File → Import in an existing sheet.
- Numbers or LibreOffice: open the .xlsx directly, or download the CSV instead.
Three things to do once it's in Excel
- Total by month: add a column with =TEXT(A2,"yyyy-mm") and use SUMIFS on the Debit and Credit columns — it works immediately because the dates are real dates.
- Find recurring charges: sort by Description, or insert a PivotTable with Description as rows and Debit as values to see subscriptions and repeat vendors.
- Check the math: the last Balance should equal the closing balance printed on your statement; StatementTidy has already confirmed this before you download.
Using the spreadsheet to reconcile
Comparing a statement against your books is much faster in a spreadsheet: paste your ledger next to the converted transactions, sort both by date and amount, and anything missing or duplicated stands out. It's the same check bookkeepers run when a bank feed drops transactions.
Fix missing bank feed transactions in QuickBooks
Why typed columns matter
Most PDF-to-Excel tools paste everything as text: dates sort alphabetically, amounts won't sum, and SUM() returns zero until you fix every cell. StatementTidy writes real Excel dates and numbers, so you can filter by month, total a category, or build a pivot table the moment the file opens.
Need CSV instead?
Frequently asked questions
How do I convert a bank statement PDF to Excel?
Drop the digital PDF on the converter at the top of this page, check the reconciled preview, and click Download Excel to get a .xlsx file.
Will the dates and amounts work in formulas?
Yes. Dates are stored as Excel dates and amounts as numbers, so sorting, SUM, and pivot tables work without clean-up.
Does it work with Google Sheets?
Yes — upload the .xlsx to Google Drive and open it with Sheets, or download the CSV and import that.
Is my statement uploaded?
No. The conversion runs entirely in your browser.
Can I convert several months into one Excel file?
The converter handles one statement at a time. Convert each month, then paste the rows into one sheet — the columns are identical, so they line up. Multi-file conversion is in development.
Can I convert a credit card statement to Excel?
Yes. Use the credit card statement converter — charges come out as money out and payments as money in.