Skip to content
fileshape

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

ColumnRequiredExampleNotes
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.

Guides