Bank Statement PDF to Excel Converter (India)
Convert digital Indian bank statement PDFs into formula-ready Excel (XLSX) spreadsheets. Extract transaction tables with separate date, narration, debit, credit, and running balance columns. Built for Indian CAs, bookkeepers, and tax professionals handling statements from SBI, HDFC, ICICI, Axis, and 19 other major Indian banks.
10 free pages on signup1 credit per pageDigital (text-based) PDFs onlyFiles deleted in 24h
What columns you get in the Excel (XLSX) export
The converter parses text elements from digital statements and extracts every transaction line into clean, standardized tabular fields. Each row corresponds to an individual bank credit or debit event:
| Column / Field | Sample Value | Description |
|---|---|---|
| Txn Date / Value Date | 15/11/2026 | Transaction booking and value dates normalized to standard DD/MM/YYYY formatting for Excel date filters and sorting. |
| Narration / Description | UPI/532014981240/Payment to Vendor/Axis Bank/UPI | Full transaction narrative combining multi-line remarks, UPI transaction IDs, beneficiary names, NEFT/RTGS codes, and cheque details without split rows. |
| Cheque / Reference No | 000542189 | Extracted cheque numbers, IMPS reference numbers, or transaction IDs when reported in the bank statement layout. |
| Withdrawal (Debit) | 14500.00 | Outgoing transactions, vendor payments, and bank charges formatted as positive numeric values ready for SUM and SUMIFS formulas. |
| Deposit (Credit) | 52000.00 | Incoming customer receipts, interest credits, and salary deposits formatted as clean numeric figures. |
| Running Balance | 187450.50 | Closing account balance after each transaction, verified through automated reconciliation formulas across the sheet. |
In addition to standard transaction columns, the generated Excel workbook contains automated balance verification formulas. These compare opening balance, total debits, total credits, and closing balance to highlight discrepancies immediately.
Four steps to convert a bank statement PDF to Excel (XLSX)
- Download the original digital PDF: Save your official digital e-statement directly from your bank's net banking portal or official mobile app. Toolzy processes digital text-based PDFs downloaded from 23 supported Indian banks. Scanned paper copies and photos of physical passbooks are not supported.
- Upload and unlock password: Drop your PDF into the converter. If your bank generated a password-protected statement (using PAN, date of birth, or mobile number), enter your password to unlock the document in temporary server memory. The password is never stored or logged.
- Preview the first page free: Inspect the extracted transaction table and column mappings on page 1 without signing in or entering payment details. Verify date formatting, narration merging, and debit/credit columns.
- Download Excel (.xlsx) spreadsheet: Sign in to convert the complete multi-page statement and download your Excel workbook. New accounts receive 10 free pages on signup, followed by 1 credit per page. Uploaded files and converted outputs are permanently deleted within 24 hours.
How Excel (XLSX) is used in Indian accounting & finance
Bank reconciliation against books
Match converted statement lines against your accounting ledgers in Tally or ERP software using Excel VLOOKUP or XLOOKUP formulas. Identify unposted debits, uncleared cheques, and bank fee discrepancies quickly.
Pivot tables and category summaries
Aggregate high-volume UPI transactions, monthly vendor payouts, utility costs, and client collections using native Excel PivotTables. Generate month-by-month cash flow summaries without manual retyping.
Audit working papers and GST review
Use the converted Excel spreadsheet as supporting working papers for GSTR-1 outward turnover verification, GSTR-2B purchase reconciliation, and annual tax audits. Keep an immutable record tied to original PDF transactions.
Data filtering and narration search
Apply Excel auto-filters to search for specific narration keywords, identify statutory tax payments (advance tax, TDS, GST), and flag suspicious or unclassified cash withdrawals across large multi-page statements.
Supported Indian banks for Excel (XLSX) conversion
Convert digital statement PDFs from any of the following 23 Indian banks into Excel (XLSX). Each bank has a dedicated conversion guide with statement layout specifics and password rules:
Frequently asked questions
Can I convert password-protected bank statement PDFs to Excel?
Yes. If your statement is encrypted with a password (such as your PAN, date of birth, or account number), enter the password when prompted in the converter. The document is unlocked in server memory for extraction and the password is never stored or logged.
Can I upload scanned statements or passbook photos?
No. Toolzy processes digital text-based PDFs downloaded directly from internet banking or official mobile banking apps. Scanned documents and physical photos of passbooks are not supported because the parser reads native vector text elements to ensure table accuracy.
How are multi-line UPI narrations handled in the Excel file?
Indian bank statements frequently split UPI transaction references, merchant IDs, and remarks across multiple lines within a single cell. The converter joins these multi-line descriptions into one clean Excel cell per row, preventing broken lines and misaligned columns.
Does Toolzy provide automated balance reconciliation in Excel?
Yes. The extracted Excel workbook includes mathematical balance verification checks comparing the opening balance, sum of debits, sum of credits, and the final closing balance to confirm that all rows reconcile correctly.
How many statement pages can I convert for free?
You can preview the first page of any supported bank statement without creating an account or signing in. New accounts receive 10 free pages on signup. Additional conversions cost 1 credit per page.
How long are uploaded statement files kept on the server?
All uploaded bank statement PDFs and generated Excel spreadsheets are permanently deleted from server storage within 24 hours. You can also configure tighter retention settings of 1 hour or 6 hours in your account preferences.
Convert your bank statement PDF to Excel (XLSX)
Upload your digital PDF statement and download clean Excel (XLSX). Preview page 1 without signing in. New accounts receive 10 free pages, then 1 credit per page. Uploaded files and extracted outputs are permanently deleted within 24 hours.
10 free pages on signup1 credit per pageDigital (text-based) PDFs onlyFiles deleted in 24h