Cards and UPI

Add-on card spending: seeing who spent what on one account

See who spent what on a card with add-on cards by using the last four digits in the narration or a tag to split one statement into per-person spending.

Editorial illustration for Add-on card spending: seeing who spent what on one account

To see who spent what on one account with add-on cards, find out how your statement identifies each card, usually by the last four digits or a cardholder name next to each transaction, and tag every row with the person. Then group the spending by person. If your statement does not mark the cardholder, use the issuer's app or the card-wise breakup that many issuers provide.

Why track per person at all?

The primary cardholder pays the whole bill, but the household's spending belongs to several people. Without a split, a parent cannot tell what a student's add-on card used, or a spouse's online shopping looks like the primary's. Tracking per person is about clarity and conversation, and the numbers make it easier to talk about money calmly.

Where does the person show up on a statement?

  • Some statements list transactions under a separate heading for each card, with the cardholder's name or the last four digits.
  • Some show the last four digits in each line.
  • Some do not distinguish at all, and the issuer's app or a separate card-wise statement is the only way to see it.

Look at your own statements, since layouts differ. If you cannot tell, ask the issuer if it provides a card-wise breakup. Do not guess from the merchant names.

How do I tag each row?

  1. Add a Person column to your sheet or tracker.
  2. For each transaction, read the last four digits or cardholder name and enter the person's name.
  3. If there are many rows, filter on the digits that appear in the narration, then fill the Person column for the filtered rows in one go.
  4. Check that the total of all persons equals the statement total.

An example with invented figures: a statement total of ₹42,000 shows card ending 1111 (primary) with ₹26,500, card ending 2222 (spouse) with ₹9,800 and card ending 3333 (child) with ₹5,700. Adding them, 26,500 + 9,800 + 5,700, gives ₹42,000, so the split matches the bill.

How do I total by person in a spreadsheet?

PersonCard endingFormulaExample result (₹)
Primary1111=SUMIFS($E$2:$E$300,$D$2:$D$300,"Primary")26,500
Spouse2222=SUMIFS($E$2:$E$300,$D$2:$D$300,"Spouse")9,800
Child3333=SUMIFS($E$2:$E$300,$D$2:$D$300,"Child")5,700

Here column D holds the Person tag and column E the amount. The same formula works in Excel and Google Sheets. If the last four digits sit inside the narration text, a helper column with =IF(ISNUMBER(SEARCH("2222",B2)),"Spouse","") can fill the tag for that card.

What about shared spending, like groceries?

Decide in advance whether you track by who held the card or by who the spending was for. A parent may hold the child's card for groceries that feed the whole house. Pick one rule, state it at the top of the sheet and use it every month. Keeping to the rule matters more than which one you pick.

Can a tracker do the split?

In SpendixAI, you can import the statement into an account and add a tag or a note for the person on each transaction, then filter in the Report builder to see one person's spending. It does not identify the cardholder by itself unless your statement text carries it, so the tagging step is yours.

What if the statement lists only one total?

Then ask the issuer for the card-wise statement, which many issuers can provide in their app or on request, or compare each transaction with the alerts you received. A card alert usually names the card that was used. Keep those alerts for the month, so you have something to match against when the statement arrives. Until the split is clear, leave the rows untagged rather than guessing, and mention the gap in your note.

Monthly routine

  • Tag each new row with the person the day the statement arrives.
  • Reconcile the per-person totals against the bill total.
  • Share the summary with the family and ask if anything looks wrong.
SPENDIXAI JOURNAL

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

Explore your reports