Skip to content
fileshape

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.

01

Your file

Stays on your device. Nothing is uploaded.

Drop a file here

CSV, Excel, ODS, JSON, XML, YAML, HTML or Markdown tables. It stays on this device.

No file handy? Try a sample:

Step by step

Export, convert, import

1 · Export from SBI statement

  1. 01In SBI online banking, open the account statement for your account and choose the date range.
  2. 02Download the statement as Excel. The text export also works; PDF does not.

2 · Import into QuickBooks Online bank import (3-column)

  1. 01In QuickBooks Online, go to Bank transactions → Link account → Upload from file.
  2. 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) columnValue
DateCopied from Txn Date; date written as MM/DD/YYYY
DescriptionCopied from Description; extra spaces removed
AmountCredit 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

Updated 2026-11-20