Toolzy
Finance and document tools
ToolsBank statementsAI AgentsPricingInsightsHelp CenterContact Us
Home/Bank statement converter/Excel

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.

Convert a bank statementSee a sample conversion

10 free pages on signup·1 credit per page·Digital (text-based) PDFs only·Files deleted in 24h

Other conversion formats: Bank statement to CSV →·Bank statement to Tally XML →

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 / FieldSample ValueDescription
Txn Date / Value Date15/11/2026Transaction booking and value dates normalized to standard DD/MM/YYYY formatting for Excel date filters and sorting.
Narration / DescriptionUPI/532014981240/Payment to Vendor/Axis Bank/UPIFull transaction narrative combining multi-line remarks, UPI transaction IDs, beneficiary names, NEFT/RTGS codes, and cheque details without split rows.
Cheque / Reference No000542189Extracted cheque numbers, IMPS reference numbers, or transaction IDs when reported in the bank statement layout.
Withdrawal (Debit)14500.00Outgoing transactions, vendor payments, and bank charges formatted as positive numeric values ready for SUM and SUMIFS formulas.
Deposit (Credit)52000.00Incoming customer receipts, interest credits, and salary deposits formatted as clean numeric figures.
Running Balance187450.50Closing 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)

  1. 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.
  2. 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.
  3. 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.
  4. 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:

SBIto Excel (XLSX) →HDFCto Excel (XLSX) →ICICIto Excel (XLSX) →Axisto Excel (XLSX) →Kotakto Excel (XLSX) →Bank of Barodato Excel (XLSX) →PNBto Excel (XLSX) →Canarato Excel (XLSX) →Union Bankto Excel (XLSX) →IDFC FIRSTto Excel (XLSX) →YES Bankto Excel (XLSX) →IndusIndto Excel (XLSX) →Bank of Indiato Excel (XLSX) →Indian Bankto Excel (XLSX) →Central Bank of Indiato Excel (XLSX) →IDBI Bankto Excel (XLSX) →Federal Bankto Excel (XLSX) →Indian Overseas Bankto Excel (XLSX) →UCO Bankto Excel (XLSX) →AU Small Finance Bankto Excel (XLSX) →RBL Bankto Excel (XLSX) →Bandhan Bankto Excel (XLSX) →South Indian Bankto Excel (XLSX) →

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.

Convert a bank statementSee a sample conversion

10 free pages on signup·1 credit per page·Digital (text-based) PDFs only·Files deleted in 24h

For CAs and bookkeepers·Excel (XLSX) converter·CSV converter·ICICI statement converter·For CA firms (multi-client)·Tally XML converter·Password-protected PDFs·ITR & GST working papers·Zoho Books (CSV)·QuickBooks (CSV)·GST reconciliation (Excel)·Loan & visa applications·Toolzy vs generic converters·SBI statement·HDFC statement·ICICI statement·Axis statement·Kotak statement·Bank of Baroda statement·PNB statement·Canara statement·Union Bank statement·IDFC FIRST statement·YES Bank statement·IndusInd statement·Bank of India statement·Indian Bank statement·Central Bank of India statement·IDBI Bank statement·Federal Bank statement·Indian Overseas Bank statement·UCO Bank statement·AU Small Finance Bank statement·RBL Bank statement·Bandhan Bank statement·South Indian Bank statement
Privacy Policy•Terms & Conditions•Contact
Toolzy © 2026 — finance, document, and developer toolsOwned and operated by Toolzy Team