Bank statements

Getting an HDFC card statement from PDF into Excel while living abroad

An NRI using an HDFC credit card for family in India can convert the statement PDF to Excel and tag each row by who it was for, in rupees.

Editorial illustration for Getting an HDFC card statement from PDF into Excel while living abroad

Living abroad with an HDFC credit card used for your family's expenses in India, the statement PDF is your only window into those purchases. Convert it into a sheet, add a column for who each purchase was for, and total in rupees. That gives you a monthly figure for what supporting your household in India costs.

Why the card statement matters when you are far away

A parent swipes the card at a grocer, a hospital or a pharmacy, and you learn about it when the statement is issued. Without a sheet you see a long list of merchants and nothing about what they were for. Time zones make a quick call harder; a written record you can read at your own hour is kinder to everyone.

What is the simplest conversion route?

  1. Download the statement PDF yourself, using your own login. Do not ask a relative to read out codes or share credentials to fetch it.
  2. Open it on a computer and try to select text. If it selects, copy the transactions.
  3. Paste into Excel or Google Sheets and split the text into date, description and amount.
  4. Convert the amounts to numbers and the dates to real dates.
  5. Add a column called For: Parents, Spouse, Home, Medical, Travel, Self.

If your version of Excel has Get Data from PDF on the Data tab, try it first and check that every row arrived. If the statement was scanned, ask for a fresh download instead of retyping.

How do you total it in rupees?

The statement will be in rupees, so the totals need no conversion. The conversion only matters when you want to compare with what you earn abroad. Say the statement total is ₹73,800 and you earn in a currency where you converted at ₹82 a unit on the day you topped up the account. Then ₹73,800 divided by 82 is 900 units, so the month cost you 900 units of your home currency. Use the rate you actually got, not a rate you read later, and describe the figure as approximate.

ForAmountShare
Parents' medical and pharmacy₹21,300about 29 percent
Household bills and groceries₹33,500about 45 percent
Travel and visits₹12,000about 16 percent
Own purchases₹7,000about 10 percent

The rows add to ₹73,800: 21,300 plus 33,500 is 54,800, plus 12,000 is 66,800, plus 7,000 is 73,800.

What should you watch for on the PDF?

  • Charges in a foreign currency, which may show both the original amount and the rupee amount.
  • A payment you made to the card, which reduces what is owed and is not spending.
  • A late payment charge or interest line. Do not guess the amount; read it in the statement and check your card terms.
  • A purchase nobody recognises. Ask the family before anything else.

Where does SpendixAI help?

SpendixAI works in rupees and is built for India. You upload the card PDF, CSV or Excel file with the card selected as the account, review the parsed rows and save. Categories can match your own For list, such as Parents and Medical, and reports can then be filtered by them. It does not read SMS or sync with the bank, so each statement is an upload.

A monthly check from far away

  • Download the statement on the same date each month.
  • Tag each row and total by person.
  • Send your family one short summary rather than the whole list.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports