Cards and UPI

Tracking spend per card to hit reward goals

Track spend per credit card by tagging each purchase with its card and totalling monthly; an example shows how to split a household between two cards.

Editorial illustration for Tracking spend per card to hit reward goals

To track spend per credit card, add one column that names the card for every purchase, then total that column by month. With a sheet, SUMIFS does it. With an app, you pick the card as the account when you import. The reason to bother: reward goals, fee waivers and milestones are all measured per card, so a single combined total tells you nothing about any of them.

What does every transaction need?

  • Date of the purchase.
  • Card name or the last four digits, never the full number.
  • Amount in rupees.
  • Category, for example groceries, fuel, dining.
  • Optional: who spent it, if more than one person uses the card.

How do you get monthly totals per card?

With dates in column A, the card name in column B and amounts in column D, this formula returns the total for one card in one month. The month is given by two dates, the first day of the month and the first day of the next:

  • =SUMIFS($D$2:$D$2000, $B$2:$B$2000, "Card A", $A$2:$A$2000, ">="&DATE(2026,11,1), $A$2:$A$2000, "<"&DATE(2026,12,1))

Change the card name and the dates for each cell in a small summary grid. A pivot table, with Card as rows, month as columns and sum of amount as values, gives the same grid without writing a formula for every cell.

What does a household split look like?

Say a household uses two cards. Card A is used for groceries, fuel and utilities. Card B is used for dining, online shopping and travel. For one month the entries are these, all invented.

CardCategoryAmount (₹)
Card AGroceries14,000
Card AFuel5,000
Card AUtilities3,500
Card BDining6,200
Card BOnline shopping9,300
Card BTravel12,000

Card A totals 14,000 + 5,000 + 3,500 = ₹22,500. Card B totals 6,200 + 9,300 + 12,000 = ₹27,500. Together they come to ₹50,000, and card B carries 27,500 ÷ 50,000 = 55% of the month's card spending. If a reward goal needs card A to reach a certain annual spend, you can see at once whether the split is helping.

How do per-card totals connect to reward goals?

Each reward goal has a card and a period. A spend milestone needs the card's total since the period began. A category cap needs that card's total for the category and the month. An annual fee waiver needs the card's total across the year. With the card column in place, each of these is the same SUMIFS with different conditions added, so you build the habit once and reuse it.

Say the household wants card A to reach ₹2,70,000 in the year. At ₹22,500 a month it gets there in 2,70,000 ÷ 22,500 = 12 months exactly, with no room for a slow month. That tells you, in November, whether to shift one more category to card A.

What mistakes spoil the totals?

  • A payment made to the card is not spending. If you record the bill payment as an expense, the swipes get counted twice.
  • Refunds should reduce the card's total in the month the credit appears, not vanish.
  • Cards added later need their own label from day one, or the totals mix up.
  • Add-on cards for family members share the main card's goals, so tag them to the same card but with the user's name in another column.

How does SpendixAI handle several cards?

You pick the account, such as a card, before you import its statement, and each transaction keeps that account. Duplicate-import warnings can flag overlapping uploads. In the Report builder you can filter and group, and a CSV download gives you the rows for a sheet if you want your own monthly grid.

A first-month plan

  1. List every card you swipe and give each a label.
  2. Collect the last month's statements.
  3. Tag or import every row with its card.
  4. Build the monthly totals and compare them with the goals.
SPENDIXAI JOURNAL

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

Explore your reports