Convert SBI bank statement PDF to Excel — the complete guide

State Bank of India is the most commonly encountered bank in any Indian CA's practice — it's the country's largest bank with 500+ million customers. Unfortunately, SBI also produces some of the most inconsistently formatted bank statement PDFs across its various systems (YONO, branch-printed, e-statement portal).

This guide covers every SBI statement variant and how to get each one into clean Excel.

How to download your SBI bank statement PDF

SBI offers statements through multiple channels:

From YONO (mobile/web)

• Login to YONO → Accounts → select account → Statement
• Choose date range (max 1 year at a time)
• Download as PDF — this gives you a digital, text-layer PDF

From internet banking (onlinesbi.sbi)

• Login → My Accounts → Account Statement
• Choose format: select "PDF" (not "XLS" — the XLS is often broken or truncated)
• Select date range and download

From branch (on request)

Branch-generated statements come as printed PDFs (sometimes scanned photocopies). These need OCR — more on that below.

Understanding SBI's statement formats

SBI uses different PDF generators across its systems, producing at least three distinct layouts:

Format 1: YONO digital statement

Clean, modern layout. Columns: Date, Description, Ref No./Cheque No., Debit, Credit, Balance. Text layer is reliable. This is the easiest to convert.

Format 2: Internet banking statement

Slightly older layout. Same columns but narrower spacing, with multi-line narrations that wrap unpredictably. The "Value Date" column sometimes appears, sometimes doesn't.

Format 3: Branch/passbook statement

Often generated from the CBS (Core Banking System). Fixed-width courier font, tight spacing, truncated narrations. Sometimes the debit/credit columns share space and are distinguished only by alignment — an amount on the left is a debit, on the right is a credit, with no column header.

BankXL's parser handles all three formats automatically — it detects which SBI variant you've uploaded and applies the appropriate extraction rules.

Converting SBI statement to Excel (step by step)

Common issues with SBI statement conversion

Multi-line narrations merging with the next row

SBI's NEFT/RTGS narrations often span 2-3 lines ("NEFT CR-0123456789-JOHN DOE-STATE BANK OF INDIA..."). Generic converters treat these continuation lines as separate transactions. BankXL groups them correctly using row-height detection and alignment rules.

Opening balance row appearing as a transaction

SBI prints "B/F" (Brought Forward) with the opening balance in the balance column. This isn't a transaction — BankXL detects and excludes these automatically.

Page totals appearing as transactions

Some SBI formats print page-total rows ("Total for this page: Dr ₹X Cr ₹Y"). These are metadata, not transactions. BankXL's junk-row detection removes them.

Date format inconsistency

SBI uses DD-MM-YYYY in some systems and DD MMM YYYY in others. Both are handled; the Excel output normalises all dates to a consistent format.

Converting SBI passbook scans

Old-style SBI passbooks that have been scanned (or photographed) don't have a text layer — they're effectively images. For these:

• BankXL runs OCR automatically when it detects an image-based PDF
• Accuracy depends on scan quality — a flat, well-lit scan gives 95%+ accuracy
• Skewed or blurry photos drop accuracy significantly; re-scan if possible
• The dot-matrix printed passbook format (courier font, tight spacing) is the hardest — allow extra review time for these

Bulk SBI conversion for CA firms

If you handle multiple SBI accounts — which most Indian CAs do — BankXL's Firm plan supports bulk upload. Drop 10-20 SBI statements at once, all process in parallel, and you download the Excel files together. Combined with Tally XML export, a full month-end reconciliation for an SBI-heavy client base takes minutes instead of hours.

Have an SBI statement format we haven't seen before? Email it to support@banlxlai.com and we'll add support within 24 hours.