Practical guides on converting bank statement PDFs into Excel, CSV and Tally Prime vouchers. Bank-specific walkthroughs and accounting workflow notes.
HDFC e-statements pack a lot into a tight layout: multi-line NEFT/RTGS narration, Indian comma-format amounts, and Value Dt columns that move depending on the account type. Here is how to extract them into Excel without losing rows.
Tally Prime can import vouchers from Excel, but the template is finicky: ledger names must match exactly, the voucher type column has to use Tally's internal names, and dates must be in DD-MMM-YYYY format. Here is the workflow that takes a bank statement PDF straight to imported vouchers.
RBC issues statements in several distinct layouts depending on whether you have a personal chequing account, a business account, a Visa, a Mastercard, or you have set your statement language to French. Each layout parses cleanly, but they need different handling for opening-balance rows and multi-page continuations.
ICICI ships two main statement layouts: the desktop NetBanking PDF and the iMobile-generated PDF. Both parse cleanly, but they need different handling for the cheque-number column and the narration wrap behaviour.
CSV and Excel both work for sending bank statement data downstream, but they fail in different ways: CSV is fragile around dates and Indian comma formats, Excel is fragile around long ID strings and leading zeros. Here is when to pick which.