Bank-statements
Convert Bank Statement PDF to Excel
Upload a bank statement PDF, review extracted dates, descriptions, debits, credits, and balances, then download a .xlsx file.
Last updated: September 17, 2026 · Review-first conversion workflow
What does the Excel output look like?
The Excel exporter creates a worksheet named Bank Statement, with a frozen header row and columns based on the extracted fields. It formats field names as headings (for example, transaction_date becomes Transaction Date). Recognized date columns are normalized to YYYY-MM-DD where parsing succeeds. Columns can vary by source; missing balances are not invented.
Synthetic example: these three invented transactions illustrate Date, Description, Debit, Credit and Balance fields. They are not customer data or a measured extraction result. Amounts are in one unspecified account currency.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-05-13 | Example supplies | 125.50 | 0.00 | 374.50 |
| 2026-05-14 | Example receipt | 0.00 | 1000.00 | 1374.50 |
| 2026-05-15 | Example fee | 5.00 | 0.00 | 1369.50 |
Reconcile the sample before using formulas
Debits total 130.50 and credits total 1000.00. The check is 500.00 + 1000.00 - 130.50 = 1369.50. In your workbook, confirm amounts are numeric before summing, compare with the PDF's actual opening and closing balances, and investigate any difference. The exporter preserves extracted fields; it does not certify their accuracy or make every cell a numeric value.
For this five-column layout, a review calculation is opening balance + SUM(D2:D4) - SUM(C2:C4). Adapt the columns and row range to your file. Do not include carried-forward balances or statement summary totals as transactions. If your source has one signed Amount column, use money in as positive and money out as negative instead.
Check dates and missing information
A date such as 03/04/2026 needs the source convention: 3 April and March 4 are different transactions. Confirm against an unambiguous date elsewhere in the statement. Missing years and unreadable dates need review; a displayed date is not proof it was interpreted correctly. If balances are absent, compare row count and debit/credit totals with the PDF rather than treating a missing reconciliation check as a pass.
Generic CSV uses Date, Description, Debit, Credit and Balance columns; Xero CSV uses a different four-column mapping. For preparation by bank or country, see N26's native CSV option, India and South Africa.
How to convert a PDF statement to Excel
- 1. Prepare the source. Digital PDFs usually produce cleaner output than scans. Unlock any password-protected file before upload.
- 2. Upload the PDF. The converter identifies transaction rows and structures dates, descriptions, debits, credits, and balances.
- 3. Review the result. Compare opening and closing totals with the PDF and spot-check rows before downloading.
- 4. Download .xlsx. Save the file, then review the destination application's account and column mapping before import.
When should I use Excel?
Use an Excel workbook when you want to review, filter, reconcile, or annotate transaction rows.
Import options differ between software products and versions. Follow the destination application's current instructions and verify the result before reconciling.
Review checklist
Confirm the day and month order matches the source PDF.
Check that debits and credits have the expected signs or columns.
Spot-check wrapped merchant names and transaction references.
Compare running and closing balances with the statement.
Other available exports
The same upload workflow offers Excel, CSV, QBO, OFX, QIF, and JSON exports.