Import an HDFC bank statement into Xero
Export the statement from HDFC NetBanking as Excel or delimited text, drop it below and select Xero bank statement import. You get Xero's columns (Date, Amount, Payee, Description and Reference) with a signed amount, day-first dates and the HDFC cheque or reference number carried into Reference.
Your file
Stays on your device. Nothing is uploaded.
Drop a file hereChoose a file to convert
CSV, Excel, ODS, JSON, XML, YAML, HTML or Markdown tables. It stays on this device.
Step by step
Export, convert, import
1 · Export from HDFC Bank statement
- 01In HDFC NetBanking, download the account statement for the period as Excel (XLS) or delimited text.
2 · Import into Xero bank statement import
- 01In Xero, open Accounting → Bank accounts, choose the HDFC account and select Import a statement.
- 02Upload the Fileshape CSV. On Xero's column assignment screen, map Date, Amount, Payee, Description and Reference to the fields of the same name.
- 03Check the date format Xero shows matches DD/MM/YYYY and complete the import, then reconcile.
How the Xero file differs from the QuickBooks one
Xero's statement import has more room than QuickBooks': besides date and amount it takes a Payee, a Description and a Reference. The recipe fills Payee and Description from HDFC's Narration (Payee is cut to 255 characters to keep it short) and Reference from Chq./Ref.No. This matters for reconciliation: Xero's suggested matches and bank rules look at payee and reference, so carrying the HDFC reference makes cheque payments and NEFT transfers much easier to match.
Dates stay day-first. Xero organisations set up for India, the UK or Australia read DD/MM/YYYY, so the recipe writes dates in that order with a four-digit year. If your organisation uses a US date format, switch the Date transform to MM/DD/YYYY before downloading.
Signed amounts
Xero expects one Amount column where spending is negative and money received is positive. HDFC gives two columns, so the recipe calculates Deposit Amt. − Withdrawal Amt. for every row and rounds to two decimals. Amounts written with Indian digit grouping are handled, so 1,32,450.00 is read as 132450.
A sensible first run is to import a single week, check it reconciles, then import the rest of the month.
Making narrations more useful in Xero
HDFC narrations pack a lot into one line: the channel (UPI, NEFT, IMPS, POS), the counterparty and long reference codes. Xero's bank rules can match on text contained in the payee, so you don't strictly need to clean them. If you'd like tidier payee names, add a Find & replace transform to Payee that removes the leading channel prefix, and keep the full text in Description for your audit trail.
Column mapping
How each Xero bank statement import column is filled
These are the exact rules the converter applies to your HDFC Bank statement file. You can change any of them in step 3 before downloading.
| Xero bank statement import column | Value |
|---|---|
| Date | Copied from Date; date written as DD/MM/YYYY |
| Amount | Deposit Amt. minus Withdrawal Amt., rounded to 2 decimals |
| Payee | Copied from Narration; extra spaces removed, cut to 255 characters |
| Description | Copied from Narration; extra spaces removed |
| Reference | Copied from Chq./Ref.No. |
FAQ
Questions
Is my statement uploaded to a server?
No. Fileshape converts it in your browser.
Can Xero take the HDFC file directly?
Not reliably. The account details at the top and the two amount columns don't fit Xero's statement format, which is why converting first is quicker than editing the sheet by hand.
Can I reuse these settings next month?
Yes. Copy the recipe JSON or the share link from step 4; it contains only the mapping rules, never your data.
Related
Other conversions
- Convert an HDFC bank statement for QuickBooks OnlineTurn an HDFC NetBanking statement (XLS or delimited) into the 3-column CSV QuickBooks Online imports: Date, Description and a signed Amount.
- Import an ICICI Bank statement into QuickBooks OnlineConvert an ICICI detailed statement (XLS) into a QuickBooks Online bank upload: transaction dates, remarks and one signed amount column.
- Convert an SBI account statement for QuickBooksTurn an SBI (onlinesbi) account statement into a QuickBooks Online CSV. Debit and Credit become one signed amount, and dates become MM/DD/YYYY.
Updated 2026-11-20