Skip to content
fileshape

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.

01

Your file

Stays on your device. Nothing is uploaded.

Drop a file here

CSV, Excel, ODS, JSON, XML, YAML, HTML or Markdown tables. It stays on this device.

No file handy? Try a sample:

Step by step

Export, convert, import

1 · Export from HDFC Bank statement

  1. 01In HDFC NetBanking, download the account statement for the period as Excel (XLS) or delimited text.

2 · Import into Xero bank statement import

  1. 01In Xero, open Accounting → Bank accounts, choose the HDFC account and select Import a statement.
  2. 02Upload the Fileshape CSV. On Xero's column assignment screen, map Date, Amount, Payee, Description and Reference to the fields of the same name.
  3. 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 columnValue
DateCopied from Date; date written as DD/MM/YYYY
AmountDeposit Amt. minus Withdrawal Amt., rounded to 2 decimals
PayeeCopied from Narration; extra spaces removed, cut to 255 characters
DescriptionCopied from Narration; extra spaces removed
ReferenceCopied 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

Updated 2026-11-20