CleanStatement

Convert a State Bank of India statement to Excel

SBI is the most-searched bank statement in India and the least consistent: a YONO download, an OnlineSBI download and a branch print of the same account do not produce the same file. Detection therefore leans on the printed bank name rather than the header row, which is shared with most other public-sector banks. CleanStatement takes your State Bank of India export — whether from YONO, OnlineSBI NetBanking or the branch print — and turns it into a continuous, verified Excel ledger. Junk rows are stripped, wrapped narrations are re-joined, every date and amount is normalized. The file is processed entirely inside your browser: it is never uploaded to a server.

What makes a State Bank of India statement hard to use in Excel

Opening a SBI export in a spreadsheet rarely gives you something you can work with. The specific problems with this bank's format are:

  • The public-sector header (Txn Date · Description · Debit · Credit · Balance) is shared with several other banks, so the printed bank name is what identifies it.
  • Long NEFT and UPI narrations wrap and need re-joining.
  • Statement exports vary between YONO, NetBanking and the branch print.

The SBI column layout

When you download a statement from YONO, OnlineSBI NetBanking or the branch print, it typically contains these columns in order:

  • **Txn Date**
  • **Value Date**
  • **Description**
  • **Ref No./Cheque No.**
  • **Debit**
  • **Credit**
  • **Balance**

How CleanStatement extracts your data

CleanStatement identifies this as a SBI statement by finding the bank's name printed on the document, since it shares a standard column layout with several other public-sector banks. It then maps standard columns like "Txn Date" and "Balance" accurately.

While this specific layout hasn't been manually verified against a real statement yet, the generic extraction pipeline will still process it safely.

From there, the same pipeline runs for every bank: repeated page headers, logos, and footers are dropped; continuation rows are folded back into the transaction above them; dates are normalized; amounts with lakh/crore grouping become real numbers; and newest-first statements are re-ordered so the running balance reconciles.

Steps to convert your SBI statement

You can download your statement from YONO, OnlineSBI NetBanking or the branch print in PDF, Excel and CSV from YONO or OnlineSBI. Any of these formats works — they all normalize to the same internal table.

  1. Open CleanStatement and drop the file onto the upload area. Nothing is transmitted; the file is read by your own browser.
  2. If the PDF is password-protected, enter the password when prompted — it is used locally to decrypt the file and never sent anywhere.
  3. Review the status card: the detected bank, the transaction count, the statement period and a pass/fail balance-verified badge.
  4. Check the issues panel for duplicates, balance gaps, round-figure anomalies and returned or bounced transactions.
  5. Optionally click Classify to tag every row to an accounting ledger head.
  6. Download the cleaned .xlsx.

Frequently asked questions

Is my SBI statement uploaded anywhere?

No. The entire conversion happens inside your browser tab. Your State Bank of India statement is never uploaded to a server, and there is no third-party API involved. This is why the tool keeps working even if you go offline after the page has loaded.

Can I convert a password-protected SBI PDF statement?

Yes. SBI statements downloaded from NetBanking are often encrypted with your date of birth, customer ID or a similar key. CleanStatement prompts for the password and decrypts the file locally in the browser.

Will the running balance in the converted file be correct?

The tool recomputes the running balance row by row and compares each figure against the balance printed on your SBI statement. If every row reconciles you get a Balance verified badge; if any row does not, it is flagged for review rather than silently corrected.

Can I import the converted SBI statement into Tally?

Yes. After classification, the downloaded workbook includes a voucher-import sheet for Tally, Zoho Books, QuickBooks or Vyapar, using a proper double-entry mapping — money out as a Payment voucher, money in as a Receipt.

Related guides