IN
An SBI PDF statement converts to Excel in about a minute, but the part that protects you happens before you download anything. Export Bank Statement reads every transaction off your State Bank of India statement and then checks each one against the running Balance column SBI already prints on the right. Opening balance, plus every credit, minus every debit, has to land on the closing balance shown on the last page. When those tie out, the statement reconciles and you get a green confirmation. When a debit is dropped or a figure is misread, the statement gets flagged straight away. On a long SBI statement, that check earns its keep.
Why the reconciliation check matters on an SBI statement
A converter that only lifts text off the page stops there. It grabs the Txn Date, the description and the Debit or Credit figure, drops it into a grid, and assumes what came out matches what went in. Usually it does. The trouble is the one time it doesn't, because a spreadsheet missing a single ₹4,500 UPI debit looks exactly as neat as a correct one. You notice three weeks later, when Zoho Books won't reconcile and you're chasing a difference across two hundred lines.
Here's the thing SBI hands you for free: a Balance column on every row. That column is a checksum. Take any line's balance, apply the next line's debit or credit, and you should land on the next line's printed balance exactly. The converter walks the entire statement that way, row to row and page to page, instead of trusting the closing figure at the bottom. If the chain breaks anywhere, that's a misread or a dropped transaction, and you're told before you build anything on top of those numbers.
Picture a scanned SBI savings statement where a ₹18,000 salary credit comes through OCR as ₹13,000, the 8 read as a 3 on a faint photocopy. A reader-only tool would leave a ₹5,000 hole in a tidy-looking sheet. Here the next row's printed balance no longer agrees, so the line is flagged; you check that one figure against the PDF, correct it in the results table, and carry on with numbers you can trust. That's the check a careful accountant does by hand, except it doesn't lose concentration on page eleven.
How an SBI statement is laid out
Knowing SBI's format is half of reading it correctly. State Bank of India statements, whether you pull them from net banking (onlinesbi) or the YONO app, use one consistent table for savings and current accounts:
Column | What it holds |
|---|---|
Txn Date | Date the transaction posted (DD/MM/YYYY) |
Value Date | Date the bank values it for interest |
Description | UPI/IMPS/NEFT narration, cheque deposits, charges |
Ref No./Cheque No. | Reference or cheque number |
Debit | Amount withdrawn |
Credit | Amount received |
Balance | Running balance after that line |
The header carries the account holder, the account number and the branch IFSC code — SBI uses an IFSC plus account number, not a UK sort code or an Australian BSB. Amounts follow the Indian numbering system, so a large figure may print as ₹1,50,000 or run into lakhs and crores, with the rupee symbol or "INR" alongside. The running Balance sits in its own right-hand column on every row, which is exactly what makes the reconciliation check possible.
Two SBI quirks are worth flagging before you convert. First, these statements get long — current accounts especially can run twenty or thirty pages across a quarter, and the header repeats on each page rather than the table flowing cleanly. Second, the PDF SBI emails you is almost always password-protected, with a password built from your own details. You don't need to remove it: upload the locked PDF, type the password when asked, and it's unlocked in your browser. The password never leaves your device. The SBI statement password page sets out the exact format and what to try if it's rejected.
How to convert an SBI statement to Excel
- Go to [/convert](/convert) and upload the SBI PDF, locked or not. If it's password-protected you'll be asked for the password, and it's unlocked in your browser.
- Scans are fine too. OCR reads scanned or photographed copies, which are common for older or branch-printed statements.
- Let it read and reconcile. Every transaction is extracted, then checked against the printed Balance column from opening to closing.
- Check the result. A reconciled statement shows a confirmation; a flagged one shows how far out it is, so you know to look for a misread or missing line.
- Download. Take the clean .xlsx for analysis, or the CSV in QuickBooks, Zoho Books or Xero native bank-import format. The Zoho Books CSV is free; the QuickBooks and Xero files come with the paid plans.
What the Excel output looks like
The download is one date-ordered ledger. Debit and Credit stay in their own columns, the Balance column is rebuilt and verified, and the long multi-page statement becomes a single continuous sheet with the repeated page headers stripped out. From there you can sort, total, or filter — or hand the CSV straight to your accounting software.
Getting the data into QuickBooks, Zoho Books or Xero
Be clear on what this is: a convert-then-import path, not a live bank feed. Export Bank Statement doesn't push transactions into your accounting software through an API. It produces a CSV in the native bank-import format each one expects, and you upload that file.
For Zoho Books — widely used across India — go to Banking, pick the SBI account, and use Import Statement, mapping Date, Description, Debit/Credit (or a single Amount) and Reference. For QuickBooks, use Bank transactions → Upload from file and map the same columns. Xero users take the Xero-format CSV under the account's Import Statement. The lines come in as reconcilable entries, ready to match against your books. Full steps live in the QuickBooks import guide and the Zoho Books import guide.
Frequently asked questions
How do I convert a password-protected SBI statement?
Upload it as it is. You'll be asked for the password, and the PDF is unlocked in your browser; the password is never sent to our servers. If you're not sure of the password, the SBI statement password page explains the format.
Can it read a scanned or photographed SBI statement?
Yes. OCR handles scanned and photographed copies, which is common for older SBI statements or ones printed at a branch. Because scans are where misreads happen most, the reconciliation check against the Balance column is exactly what catches a digit that OCR got wrong.
Does it work for both savings and current accounts?
Yes. SBI savings and current accounts share the same Txn Date | Value Date | Description | Ref No./Cheque No. | Debit | Credit | Balance layout, so both convert the same way. Long current-account statements running many pages are handled as one continuous ledger.
Will it import straight into Zoho Books or QuickBooks?
It produces a CSV in the native bank-import format Zoho Books, QuickBooks and Xero expect, and you upload that file. It isn't a live bank-feed API — the path is convert, then import — but the lines arrive ready to reconcile.
What happens if my SBI statement doesn't reconcile?
You're told, and you're shown the size of the gap. A flagged statement means the running balance didn't tie out somewhere — usually a misread digit or a transaction the page layout split awkwardly. You check the likely lines against the PDF, correct a misread figure in the results table, and the check runs again, rather than discovering the gap later in your books.
