Convert Axis Bank Statement PDF to Excel: BRS Mapping Rules

Axis Bank is a leading private sector bank in India, offering commercial and retail banking services.

Converting Axis statements from PDF to Excel presents formatting challenges like wrapped descriptions and non-standard date formats. This guide details how to clean and convert Axis statements into Tally-ready PDF templates.

1. Typical Axis PDF Statement Columns

An Axis Current Account statement includes these standard columns:

• Tran Date: The date the entry was recorded.
• Value Date: The effective date of the clearing.
• Transaction Description: Details of the transaction.
• Cheque No: Cheque reference number.
• Debit: Payments out of the account.
• Credit: Deposits into the account.
• Balance: The running ledger balance.

2. Standardizing Date Formatting

Date parsing errors are a common cause of bank statement import failures in Tally. Ensure dates are formatted uniformly:

Select the Date column in your Excel worksheet, right-click, and select format custom. Set it to dd-mm-yyyy before exporting to Tally.

3. Axis BRS Mapping Output Schema