← All tools | 🏦 Bank Statement → Excel

Bank Statement to Excel Converter

Upload a bank statement PDF and get a clean Excel sheet with every transaction, plus an automatic balance check. The tool detects your bank's format, extracts Date, Description, Reference, Debit, Credit and Balance, and verifies the totals against the printed closing balance.

Step 1 — Upload your bank statement
🏦
Drop your bank statement PDF here or click to browse

SBI · HDFC · ICICI · Axis · Kotak · and most Indian banks

🔒
Your bank statement never leaves your browser. No upload, no server, no storage — every transaction is parsed locally on your device.

Works with SBI, HDFC, ICICI, Axis, Kotak, and most Indian bank statement formats. Unrecognised banks are parsed in generic bank-statement mode.

Working… 0%
How to use▾
  1. Upload your bank statement PDF (downloaded from net banking)
  2. The tool detects the bank format from the statement's text and column headers
  3. It extracts every transaction into Date, Description, Reference No, Debit, Credit and Balance
  4. It checks Opening + Credits − Debits against the printed Closing Balance
  5. Download the .xlsx — a Statement sheet plus a Summary sheet with reconciliation status

Supported banks: SBI, HDFC, ICICI, Axis, Kotak Mahindra, PNB, Bank of Baroda, Canara, Yes Bank, IndusInd — and generic bank-statement mode for the rest.

Frequently asked questions▾
Does this work on scanned statements?

No. The parser needs selectable text. For scanned statements, run OCR first, then convert the OCR'd PDF.

Which banks are supported?

SBI, HDFC, ICICI, Axis, Kotak, PNB, Bank of Baroda, Canara, Yes Bank and IndusInd are detected by name and column layout. Other banks are parsed in generic bank-statement mode.

Is my statement uploaded anywhere?

No. PDF.js reads your file locally and the .xlsx is generated client-side using SheetJS. Your statement never leaves your device.

Converting a bank statement? See our full guide: Bank statement PDF to Excel — HDFC, SBI, ICICI →

How to Convert a Bank Statement to Excel

  1. Upload your bank statement PDF — the tool detects the bank from the statement text and column headers (for example, "Detected: HDFC Bank format").
  2. The converter extracts each transaction into a standard schema: Date, Description, Reference No, Debit, Credit and Balance, continuing the same table across every page.
  3. It reads the printed Opening and Closing balances and checks that Opening + Credits − Debits equals the Closing balance, so you can trust the extraction before you use it.
  4. Download the .xlsx — a Statement sheet with your account details and transactions, plus a Summary sheet with totals and reconciliation status. Compatible with Excel, Google Sheets, LibreOffice and Tally.

Why use LovelyPDF

Your bank statement is parsed entirely in your browser — it is never uploaded to any server. Unlike services such as DocuClipper, Parseur or ConvertBankStatement, there is no account to create and no file to upload. The PDF is read locally by JavaScript and the spreadsheet is built on your device.

No account is required and there is no page cap. Convert a one-page statement or a 12-month export with the same tool, with no registration, no subscription tier, and no watermark on the output spreadsheet.

The converter works on any device with a modern browser. The .xlsx output is universally compatible across all spreadsheet applications and imports cleanly into Tally for bank reconciliation.

Frequently Asked Questions

Does the tool work on scanned bank statements? +

The tool requires a digital text layer to extract data. Scanned statements contain images of text rather than selectable characters. Use the OCR PDF tool to add a text layer to the scanned statement first, then re-upload here.

What is the reconciliation check? +

After extracting all transactions, the tool sums every credit and every debit, then reads the statement's printed opening and closing balances. It verifies that Opening Balance + Total Credits − Total Debits equals the Closing Balance. A match means the extraction captured every transaction; a mismatch flags that some rows may need manual review.

Which banks are automatically detected? +

SBI, HDFC, ICICI, Axis, Kotak, PNB, Bank of Baroda, Canara, Yes Bank and IndusInd are detected by their name in the statement and by their column header layout. Statements from other banks are processed in generic bank-statement mode, which maps the most common Date / Description / Debit / Credit / Balance layouts.

Can I import the output directly into Tally? +

Yes — the Statement sheet uses standard column headers (Date, Description, Reference No, Debit, Credit, Balance) compatible with Tally's Excel import templates. Minor column renaming may be required to match your specific Tally configuration.