Skip to content

Supported bank statement formats

21 Indian bank formats, plus a generic table reader and manual column mapping for everything else.

Tuned and tested

Bank-specific column names and quirks, covered by automated tests on synthetic look-alike statements.

State Bank of India

Columns: Txn Date · Value Date · Description · Ref No./Cheque No. · Debit · Credit · Balance

HDFC Bank

Columns: Date · Narration · Chq./Ref.No. · Value Dt · Withdrawal Amt. · Deposit Amt. · Closing Balance

ICICI Bank

Columns: S No. · Value Date · Transaction Date · Cheque Number · Transaction Remarks · Withdrawal Amount (INR) · Deposit Amount (INR) · Balance (INR)

Axis Bank

Columns: Tran Date · Chq No · Particulars · Debit · Credit · Balance · Init. Br

Kotak Mahindra Bank

Columns: # · Date · Description · Chq/Ref No. · Amount · Balance

Tested look-alike layouts

Read by the general table reader and covered by automated tests on synthetic look-alike statements.

Punjab National Bank

Columns: Txn Date · Withdrawal · Deposit · Balance · Cheque No. · Narration

Bank of Baroda

Columns: DATE · NARRATION · CHQ.NO. · WITHDRAWAL (DR) · DEPOSIT (CR) · BALANCE (INR)

Canara Bank

Columns: Txn Date · Value Date · Cheque No. · Description · Branch Code · Debit · Credit · Balance

Canara to Excel

Union Bank of India

Columns: Date · Particulars · Chq./Ref. No. · Value Date · Withdrawals · Deposits · Balance

IDFC FIRST Bank

Columns: Transaction Date · Value Date · Particulars · Cheque No · Debit · Credit · Balance

IDFC FIRST to Excel

Yes Bank

Columns: Transaction Date · Value Date · Description · Reference No · Amount · Dr / Cr · Balance

Yes Bank to Excel

IndusInd Bank

Columns: Date · Particulars · Chq./Ref. No · Withdrawal · Deposit · Balance

IndusInd to Excel

Co-operative banks

Columns: Sr. No. · Date · Particulars · Chq. No. · Withdrawals · Deposits · Balance

Co-op bank to Excel

Recognised, not yet sample-tested

Detected from the letterhead or IFSC code and read by the general table reader. The balance check tells you whether it worked.

Indian Bank

Typical columns: Date · Particulars / Narration · Cheque / Ref No. · Withdrawals (Debit) · Deposits (Credit) · Balance

Indian Bank to Excel

Indian Overseas Bank

Typical columns: Date · Particulars / Narration · Cheque / Ref No. · Withdrawals (Debit) · Deposits (Credit) · Balance

Bank of India

Typical columns: Date · Particulars / Narration · Cheque / Ref No. · Withdrawals (Debit) · Deposits (Credit) · Balance

Central Bank of India

Typical columns: Date · Particulars / Narration · Cheque / Ref No. · Withdrawals (Debit) · Deposits (Credit) · Balance

Central Bank to Excel

UCO Bank

Typical columns: Date · Particulars / Narration · Cheque / Ref No. · Withdrawals (Debit) · Deposits (Credit) · Balance

Federal Bank

Typical columns: Date · Particulars / Narration · Cheque / Ref No. · Withdrawals (Debit) · Deposits (Credit) · Balance

Federal to Excel

IDBI Bank

Typical columns: Date · Particulars / Narration · Cheque / Ref No. · Withdrawals (Debit) · Deposits (Credit) · Balance

AU Small Finance Bank

Typical columns: Date · Particulars / Narration · Cheque / Ref No. · Withdrawals (Debit) · Deposits (Credit) · Balance

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. If it cannot find one, choose Map columns yourself and point at the columns once. The balance check tells you immediately whether it worked. Bank missing? Tell us.