Convert an SBI account statement for QuickBooks
Download your SBI account statement as Excel from online banking, drop it here and pick QuickBooks Online. The converter skips SBI's account details at the top, keeps Txn Date and Description, and replaces the separate Debit and Credit columns with one signed Amount column, the layout QuickBooks' bank upload expects.
Your file
Stays on your device. Nothing is uploaded.
Drop a file hereChoose a file to convert
CSV, Excel, ODS, JSON, XML, YAML, HTML or Markdown tables. It stays on this device.
Step by step
Export, convert, import
1 · Export from SBI statement
- 01In SBI online banking, open the account statement for your account and choose the date range.
- 02Download the statement as Excel. The text export also works; PDF does not.
2 · Import into QuickBooks Online bank import (3-column)
- 01In QuickBooks Online, go to Bank transactions → Link account → Upload from file.
- 02Select the converted CSV, pick the bank account, and match the Date, Description and Amount columns.
Why SBI files need converting
SBI statements list Txn Date, Value Date, Description, Ref No./Cheque No., Debit, Credit and Balance. Amounts are always positive: whether a row is money in or out depends on which column it sits in. QuickBooks' simplest import, the 3-column CSV, uses a single Amount where the sign carries that meaning. Fileshape computes it as Credit − Debit, so a ₹2,000 ATM withdrawal becomes -2000 and a ₹15,000 transfer in becomes 15000.
SBI descriptions often start with a transaction type such as BY TRANSFER, TO TRANSFER, ATM WDL or a UPI string. They're kept as they are, which QuickBooks bank rules can match on, for example a rule for anything containing “ATM WDL”.
Dates, blank cells and odd rows
SBI's export writes the transaction date in a day-first format. The recipe reads it day-first and writes MM/DD/YYYY, so 05/03/2026 (5 March) becomes 03/05/2026. Empty Debit or Credit cells count as zero, so the subtraction never fails on a blank.
Some SBI exports include a line or two under the table such as a closing balance or a computer-generated statement note. Single-cell rows like that are dropped automatically. If an unusual line still slips through, the preview shows it and you can delete it in your spreadsheet or tighten the header row setting.
Column mapping
How each QuickBooks Online bank import (3-column) column is filled
These are the exact rules the converter applies to your SBI statement file. You can change any of them in step 3 before downloading.
| QuickBooks Online bank import (3-column) column | Value |
|---|---|
| Date | Copied from Txn Date; date written as MM/DD/YYYY |
| Description | Copied from Description; extra spaces removed |
| Amount | Credit minus Debit, rounded to 2 decimals |
FAQ
Questions
Do I need an account to convert SBI statements?
No. Conversion is free, needs no sign-up and runs in your browser.
Can I keep the Balance column?
QuickBooks' 3-column upload ignores it, so it isn't included. If you want it for your own checking, add it back with “Add unmapped columns” before downloading.
Does this work for Tally?
Not yet. Tally needs voucher XML rather than a bank CSV. Tally export is on our roadmap.
Related
Other conversions
- Convert an HDFC bank statement for QuickBooks OnlineTurn an HDFC NetBanking statement (XLS or delimited) into the 3-column CSV QuickBooks Online imports: Date, Description and a signed Amount.
- Import an ICICI Bank statement into QuickBooks OnlineConvert an ICICI detailed statement (XLS) into a QuickBooks Online bank upload: transaction dates, remarks and one signed amount column.
- Import an HDFC bank statement into XeroConvert an HDFC NetBanking statement into Xero's bank statement CSV: Date, Amount, Payee, Description and Reference, ready for reconciliation.
Updated 2026-11-20