India
Convert bank statements in India
Statement formats, date and amount conventions and accounting imports for banks in India.
Quick answer
StatementPilot converts statements from any bank in India into Excel, CSV, QBO, OFX or QIF. Dates default to DD/MM/YYYY, amounts are read in rupees (INR), and exports are ready for Tally, Zoho Books, QuickBooks.
Banks in India
How statements in India are laid out
Indian statements list Txn Date, Value Date, Narration/Description, Cheque/Ref No., Withdrawal, Deposit and Balance columns.
Amounts and dates
Amounts use Indian digit grouping (1,00,000.00) and are labelled Dr / Cr. Narrations for UPI and NEFT transfers are long and include reference numbers.
The usual date format is DD/MM/YYYY. When a statement is ambiguous we use the statement period and other rows to decide the order.
Account identifiers
Branches are identified by an 11-character IFSC code.
Accounting software
The most common destinations in India are Tally, Zoho Books, QuickBooks, Excel. Every export format is included on every plan.
Why statements still matter
Password-protected PDF statements are common (the password is often based on your name and date of birth); remove the password before uploading.
Frequently asked questions
Does the converter support INR statements?
Yes. Amounts in rupees are read with the local number format and the currency is carried into Excel, OFX and QBO exports.
What if my bank in India isn't listed?
Upload it anyway — there are no bank templates. The reconciliation check confirms whether every transaction was captured.
Which date format will my export use?
Excel and OFX use real dates. For CSV and QIF you can choose MM/DD/YYYY or DD/MM/YYYY at export time; DD/MM/YYYY is typical in India.
Convert your first statement in under a minute
20 free pages every month. No credit card. Every export format included.