Supported bank statement formats
Tuned and tested readers for India's largest banks, plus a generic table reader for the rest.
State Bank of India
Columns: Txn Date · Value Date · Description · Ref No./Cheque No. · Debit · Credit · Balance
Dates: "1 Apr 2024", often split over two lines in the date column
State Bank of India to ExcelHDFC Bank
Columns: Date · Narration · Chq./Ref.No. · Value Dt · Withdrawal Amt. · Deposit Amt. · Closing Balance
Dates: dd/mm/yy, for example 05/04/24
HDFC Bank to ExcelICICI Bank
Columns: S No. · Value Date · Transaction Date · Cheque Number · Transaction Remarks · Withdrawal Amount (INR) · Deposit Amount (INR) · Balance (INR)
Dates: dd/mm/yyyy
ICICI Bank to ExcelAxis Bank
Columns: Tran Date · Chq No · Particulars · Debit · Credit · Balance · Init. Br
Dates: dd-mm-yyyy
Axis Bank to ExcelKotak Mahindra Bank
Columns: # · Date · Description · Chq/Ref No. · Amount · Balance
Dates: "01 Apr 2024" or dd-mm-yyyy
Kotak Mahindra Bank to ExcelAlso recognised
Punjab National Bank, Bank of Baroda, Canara Bank, Union Bank of India, IDFC FIRST, Yes Bank, IndusInd, Indian Bank, Indian Overseas Bank, Bank of India, Central Bank of India, UCO, Federal, IDBI, AU Small Finance Bank and co-operative bank passbook prints. These are read by the general table reader, which handles amounts printed before the narration, amounts on the last line of a wrapped narration, vertically centred rows, separate Dr/Cr columns, "Cr"/"Dr" balances, B/F and C/F rows and watermarks. Please check the balance summary after converting.
Any other bank
Choose "Other bank (generic)". KhataSheet looks for a header row with a date, a narration, debit/credit (or amount + Dr/Cr) and a balance, then reads the columns underneath. The balance check tells you immediately whether it worked.