Convert ICICI Bank Statement PDF to Excel: BRS Mapping Rules

ICICI Bank is a major commercial bank in India. Most medium and large businesses maintain corporate current accounts with ICICI.

Converting ICICI corporate statement PDFs to Excel presents formatting challenges like wrapped descriptions and single-column amounts. This guide details how to clean and convert ICICI statements into Tally-ready PDF templates.

1. Typical ICICI PDF Statement Columns

An ICICI Current Account statement includes these standard columns:

• Value Date: The effective date of the clearing.
• Transaction Date: The date the entry was recorded.
• Cheque No.: Cheque reference number.
• Description: Details of the transaction.
• Amount (INR): Transaction amount values.
• Cr/Dr: Transaction type indicator flag.
• Balance (INR): The running ledger balance.

2. Reconciling Single-Column Amount Formats

ICICI statements use a single amount column with Cr/Dr flags to identify transaction direction:

To import these entries, separate purchases and payments into separate columns based on the Cr/Dr indicator before importing the file into Tally.

3. ICICI BRS Mapping Output Schema