Convert an HDFC bank statement for QuickBooks Online
Download the statement from HDFC NetBanking as Excel or delimited text, not PDF, and drop it into the converter below. Fileshape skips HDFC's account header block, merges the Withdrawal Amt. and Deposit Amt. columns into one signed Amount, rewrites dates as MM/DD/YYYY and gives you a CSV that QuickBooks Online's bank upload accepts.
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
- 01Log in to HDFC NetBanking and open the account statement for the account you reconcile in QuickBooks.
- 02Pick the period you want to import. Shorter periods (one month) are easier to check against QuickBooks afterwards.
- 03Download it in Excel (XLS) or delimited format. Avoid PDF: it has to be OCR'd and loses column structure.
2 · Import into QuickBooks Online bank import (3-column)
- 01In QuickBooks Online, go to Bank transactions, open the Link account dropdown and choose Upload from file (or Upload transactions manually if the account isn't connected to a bank feed).
- 02Select the CSV from Fileshape and pick the QuickBooks bank account it belongs to.
- 03Match the columns (they're already named Date, Description and Amount), tell QuickBooks the dates are MM/DD/YYYY, select the transactions and finish the import.
What changes between the HDFC file and the QuickBooks file
An HDFC NetBanking export is designed to be read by people: it starts with the bank's name, your account number, branch details and the statement period, and only then the transaction table. The table itself has seven columns: Date, Narration, Chq./Ref.No., Value Dt, Withdrawal Amt., Deposit Amt. and Closing Balance. QuickBooks Online's bank upload wants something much plainer, a single table with just a date, a description and an amount.
Fileshape detects the row where the real header starts, so you don't have to delete the title rows by hand. Footer lines such as the statement summary are dropped too. The two money columns are combined with the rule Amount = Deposit Amt. − Withdrawal Amt., rounded to two decimals, which is exactly the sign convention QuickBooks uses: a salary credit of 85,000.00 becomes 85000 and a UPI payment of 486.00 becomes -486.
Dates and Indian number formats
HDFC writes dates as DD/MM/YY, so 01/02/26 means 1 February 2026. Read the wrong way round, it becomes 2 January, which silently scrambles a month of entries. The recipe reads the HDFC date day-first and writes it as 02/01/2026 (MM/DD/YYYY), and you tell QuickBooks that format during the upload. Intuit's own guidance is simply to use one date format for the whole file; if you'd rather give QuickBooks DD/MM/YYYY, change the Date transform in step 3 before downloading.
Amounts in Indian grouping (1,32,450.00) are parsed correctly; the commas are removed rather than treated as decimal separators. Closing Balance and Chq./Ref.No. are not needed by QuickBooks and are left out of the output, but you can add the reference back with Add column if you want it in the description.
Checking the result before you import
Before you download, look at the preview: the number of output rows should match the number of transactions in the statement, and the first and last dates should match the period you exported. A quick sanity check is to add up the Amount column and compare it with the change between the opening and closing balance on the statement. If they match, the file is complete and the signs are right.
Column mapping
How each QuickBooks Online bank import (3-column) 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.
| QuickBooks Online bank import (3-column) column | Value |
|---|---|
| Date | Copied from Date; date written as MM/DD/YYYY |
| Description | Copied from Narration; extra spaces removed |
| Amount | Deposit Amt. minus Withdrawal Amt., rounded to 2 decimals |
FAQ
Questions
Does my bank statement get uploaded to Fileshape?
No. The file is read and converted in your browser; nothing is sent to a server. You can disconnect from the internet after the page loads and it still works.
Can I use the 4-column QuickBooks format instead?
Yes. Pick “QuickBooks Online bank import (4-column)” as the output layout and you get separate Credit and Debit columns instead of a signed Amount. Check the signs in QuickBooks' preview; if money in and money out are the wrong way round, use its option to reverse the values.
Will it work for an HDFC credit card statement?
Not with this recipe. Card statements use different columns. Use Custom headers with Date, Description, Amount and map the columns yourself, or send us a sample layout (with fake data) so we can add a preset.
Related
Other conversions
- 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.
- Import an HDFC bank statement into XeroConvert an HDFC NetBanking statement into Xero's bank statement CSV: Date, Amount, Payee, Description and Reference, ready for reconciliation.
Updated 2026-11-20