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

HDFC Bank is a leading private sector bank in India. Many companies use HDFC current accounts to process payments, resulting in thousands of transactions monthly.

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

1. Typical HDFC PDF Statement Columns

An HDFC current account statement includes these standard columns:

• Date: The date the entry was recorded.
• Narration: Details of the transaction.
• Chq/Ref No: Transaction reference number.
• Value Date: The effective date of the clearing.
• Withdrawal: Payments out of the account.
• Deposit: Deposits into the account.
• Closing Balance: The running ledger balance.

2. Reconciling Credit Card Statements

HDFC business credit card statement PDFs use a single-column layout for transaction amounts, with credit/debit indicators:

To import these entries, separate purchases and payments into separate columns before importing the file into TallyPrime.

3. HDFC BRS Mapping Output Schema