Convert SBI Bank Statement PDF to Excel for Tally: Mapping Rules

State Bank of India (SBI) is the largest commercial bank in India. Most businesses maintain their primary current accounts with SBI, generating hundreds of transaction rows monthly.

However, SBI's statement PDF layouts present unique formatting challenges. Split descriptions and non-standard date formats block direct imports. This guide details how to clean and convert SBI statements into Tally-ready PDF templates.

1. Typical SBI PDF Statement Columns

An SBI current account statement includes these standard columns:

• Txn Date: The date the entry was recorded.
• Value Date: The effective date of the clearing.
• Description: Details of the transaction (e.g. transfer references, UPI IDs).
• Ref No. / Cheque No.: Transaction reference number.
• Debit: Payments out of the account.
• Credit: Deposits into the account.
• Balance: The running ledger balance.

2. Solving Multi-Line Narration Splits

SBI statements wrap long transaction details (like detailed UPI strings or international wire details) across multiple lines. This can create blank rows when converted to Excel:

To clean these rows, merge split descriptions into a single text block, aligning the date and amount values on a single row index.

3. SBI BRS Mapping Output Schema