Export layout
HDFC Bank statement export columns
HDFC Bank NetBanking account statement export (Excel/delimited).
The HDFC Bank statement layout has 7 columns.
HDFC NetBanking can export an account statement as Excel or delimited text in addition to PDF. The spreadsheet versions contain the bank's header block (bank name, account number, branch, statement period) followed by a seven-column transaction table: Date, Narration, Chq./Ref.No., Value Dt, Withdrawal Amt., Deposit Amt. and Closing Balance.
Money in and money out are in separate columns and both are positive, dates are written day-first with a two-digit year, and amounts may use Indian digit grouping. Accounting tools need one signed amount and an unambiguous date, which is what Fileshape's HDFC recipes produce.
Import rules to know
- Header and summary rows surround the table; they're skipped automatically when the header row is set to Auto-detect.
- Narration packs channel, counterparty and reference into one field (for example UPI-…, NEFT CR-…).
- Value Dt can differ from Date for cheques and some transfers.
Columns
| Column | Required | Example | Notes |
|---|---|---|---|
| Date | |||
| Narration | |||
| Chq./Ref.No. | |||
| Value Dt | |||
| Withdrawal Amt. | |||
| Deposit Amt. | |||
| Closing Balance |
Bank exports include header/summary rows above the table — remove them or use 'header row' when importing.