Bank statements

One HDFC card, two spenders: getting the PDF into a shared sheet

When two people use one HDFC credit card, turn the statement PDF into a sheet with a Who column so the household can see each person's share of the bill.

Editorial illustration for One HDFC card, two spenders: getting the PDF into a shared sheet

When one card serves a whole household, the statement is a muddle of two people's lives. Get the PDF text into a sheet, add a Who column with your initials, and total by person and by shared category. The conversation about money then starts from numbers, not from memory.

What goes wrong with one card and two people?

Neither of you can say, at a glance, who spent what. One of you remembers the weekend trip, the other remembers the appliance, and the grocery runs belong to both. The bill is paid in one amount, so nobody feels the total until it lands. Turning it into a sheet is a small step towards a calm monthly talk.

How do you convert and tag the statement?

  1. Download the statement and check you can select the text.
  2. Paste the transaction lines into a blank sheet and split them into date, description and amount.
  3. Add a Who column. Use A for one person, B for the other and S for shared.
  4. Add a Category column: Groceries, Fuel, Dining, Home, Travel and so on.
  5. Sit down together for fifteen minutes and fill both columns. The ones you disagree on are the useful ones.

What does the arithmetic look like?

Say the monthly statement is ₹61,400. Tagging gives A ₹14,200, B ₹9,800 and S ₹37,400. Check: 14,200 plus 9,800 plus 37,400 equals 61,400. If the shared amount is paid equally, each person owes ₹18,700 of it, so A's total is 14,200 plus 18,700, which is ₹32,900, and B's total is 9,800 plus 18,700, which is ₹28,500. Together that is again ₹61,400.

WhoOwn spendingHalf of sharedTotal
A₹14,200₹18,700₹32,900
B₹9,800₹18,700₹28,500
Household₹24,000₹37,400₹61,400

The formula for each person's own spending is =SUMIF(E2:E80,"A",C2:C80), and the shared total is =SUMIF(E2:E80,"S",C2:C80). Your own split rule may not be half and half; if one of you earns more, you can agree a proportion and change the 0.5 in the sheet to match.

How can SpendixAI fit in?

SpendixAI imports the card PDF, CSV or Excel file with the card chosen as the account, and shows the parsed rows before saving. It keeps one personal workspace on Pro and is not a bill-splitting app, so it will not work out who owes whom. What it does give you is categorised spending and reports you can filter, which makes the sheet's totals quicker to reach. If you need the split calculation, keep a small sheet for that.

What if you disagree about a row?

Some rows will not be obviously his, hers or shared: a gift bought on the card, an appliance you both use, a medical bill for one parent. Give such rows a fourth tag, Discuss, and leave them out of the split until you have talked. At the end of the sitting, total the Discuss rows separately, say ₹6,300, and settle them in one conversation rather than one at a time over the month.

Keep the disagreement about the row, not about the person. A line that says a hardware shop on a Saturday is easier to talk about than a feeling that one of you spends too much.

Make the review a monthly habit

  • Pick a fixed day after the statement is generated.
  • Fill Who and Category together, with the statement open.
  • Compare this month's shared total against last month's.
  • Choose one thing to change, not five.
  • Keep the finished sheet and the PDF in the same folder.
SPENDIXAI JOURNAL

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

Explore your reports