Understand what a bank statement PDF looks like, what every section means, and how to convert your real statement to a clean Excel file in seconds — free.
Every bank statement PDF follows the same basic structure, regardless of which bank issued it. Here are all the sections you'll find:
| Section | What It Shows | Where to Find It |
|---|---|---|
| Bank Header | Bank name, logo, branch address, customer care number | Top of page 1 |
| Account Details | Account holder name, account number (masked), account type, branch | Top of page 1 |
| Statement Period | From date and to date this statement covers | Top section |
| Opening Balance | Account balance at start of statement period | Account summary or first transaction row |
| Transaction Table | Date | Description/Narration | Debit | Credit | Balance | Main body of statement |
| Closing Balance | Account balance at end of statement period | Last row of transaction table or summary |
| Totals Row | Sum of all debits and sum of all credits | Bottom of transaction table |
Date: 01 Jun 2026 | Description: NEFT-SALARY/ACME CORP/REF123456 | Debit: — | Credit: 85,000.00 | Balance: 1,23,450.00
| Country | Date Format | Currency | Amount Format |
|---|---|---|---|
| India | DD/MM/YYYY or DD-MMM-YYYY | ₹ INR | 1,23,456.00 (Indian comma system) |
| UK | DD/MM/YYYY | £ GBP | 1,234.56 |
| USA | MM/DD/YYYY | $ USD | 1,234.56 |
| Australia | DD/MM/YYYY | $ AUD | 1,234.56 |
| Canada | MM/DD/YYYY or DD/MM/YYYY | $ CAD | 1,234.56 |
Whether you bank with HDFC, SBI, ICICI or any regional bank, upload your PDF and get a clean Excel file in seconds — no bank-specific software needed.
Password-protected PDFs unlocked automatically. Enter your DOB (DDMMYYYY) when prompted. Net banking and mobile app statements both work.
Custom fonts and scanned pages handled via built-in OCR. YONO, e-passbook, and branch-issued statements all supported.
Private sector formats auto-detected. UPI reference IDs and NEFT/IMPS narrations fully extracted. ₹ INR as plain numbers.
India use cases: ITR filing & income proof • Tally Prime / ERP 9 bank reconciliation • GST return verification • CA bookkeeping (20–50 statements/month) • Home loan & personal loan applications
→ Dedicated Indian Bank Statement Converter
Every major UK high-street and digital bank is supported. DD/MM/YYYY dates auto-converted, £ GBP as plain numbers, and Faster Payments references preserved.
Barclays, NatWest, HSBC UK, Lloyds, Halifax, Santander, Nationwide, TSB, First Direct, Metro Bank, RBS, Bank of Scotland — all formats auto-detected.
Monzo, Starling, Revolut, Wise, Chase UK — digital bank PDF and CSV exports fully supported. Sort codes and account numbers preserved in narrations.
UK use cases: HMRC Self-Assessment expense tracking • Xero / FreeAgent import • Mortgage broker submissions • UKVI visa bank evidence • Companies House audit preparation
→ Dedicated UK Bank Statement Converter
All major US bank statement formats are supported. MM/DD/YYYY dates converted, $ USD as plain numbers, and single signed-amount columns split into Debit/Credit automatically.
Chase, Wells Fargo, Bank of America, Citibank, PNC, US Bank, Capital One, TD Bank, Truist, Regions, KeyBank — all layouts covered including redesigned 2024/2025 formats.
Chime, Cash App, Ally, SoFi, Varo, Navy Federal, USAA, Schwab — neobank CSV and PDF exports both handled. No manual column mapping needed.
US use cases: QuickBooks Online bank feed import • Schedule C / 1040 expense categorisation • Mortgage underwriting cash-flow review • SBA loan application • CPA bookkeeping
