Budgeting

Drill down from a category total to the transactions behind it

Drill down from a category total to the transactions behind it in three steps: sort by amount, group by merchant and check dates, using a ₹14,000 shopping example.

Editorial illustration for Drill down from a category total to the transactions behind it

To see what makes up a category total, list its transactions and do three things: sort by amount, group by merchant, and check the dates. A ₹14,000 shopping total looks like one big number, but the steps show it is three purchases plus a pile of small ones.

Step 1: sort by amount, largest first

Start with the largest items, because a few of them usually explain most of the total. Imagine your ₹14,000 shopping category sorted from the top.

PurchaseAmountRunning total
Kitchen appliance₹5,200₹5,200
Festive clothes₹3,600₹8,800
Gift for a relative₹1,800₹10,600
17 smaller purchases₹3,400₹14,000

Three purchases make up ₹10,600, or about 76% of the category (10,600 ÷ 14,000). The seventeen small ones average 3,400 ÷ 17 = ₹200 each.

Step 2: group by merchant

Now group everything by who was paid. Say eleven of the seventeen small purchases went to one online marketplace, adding up to ₹2,200, and the other six, adding up to ₹1,200, were spread across local shops.

  • Online marketplace: 11 purchases, ₹2,200, average ₹200.
  • Local shops: 6 purchases, ₹1,200, average ₹200.
  • Check: 2,200 + 1,200 = ₹3,400, which matches the small purchases above.

Eleven separate orders in a month hints at a habit, such as ordering small things one at a time. Combining them into fewer orders might save delivery or platform fees, which is a decision you can only see because you grouped.

Step 3: check the dates

Look at when the money went out. Were the three big items within the same week of a festival? Did the small purchases cluster on weekends or just after payday? Dates show whether spending was planned or reactive. A spike on the 1st to 3rd of a month suggests spending right after salary arrives, whereas a spread across the month suggests regular drift.

What if the total still does not make sense?

  1. Check that every transaction belongs in the category. A ₹1,800 gift may deserve a gifts category.
  2. Look for duplicates, the same amount to the same merchant a day apart.
  3. Look for a refund that has not been linked, which would make the total look larger than it was.
  4. Check the date filter, since a payment on the last day of the month may fall into the next one.

What decision should the drill-down end with?

End with one choice. For this example it might be: give appliances their own line in the yearly plan, because a ₹5,200 purchase is not a monthly shopping habit, and combine small online orders into one weekly basket. A drill-down that produces no decision is just curiosity.

What if the biggest item is a one-off?

Take the ₹5,200 appliance out and look at what is left: 14,000 − 5,200 = ₹8,800. That is a fairer picture of ordinary shopping for the month. Do the same comparison with other months. If ordinary shopping is ₹8,800 here and a typical month is ₹7,000, the difference is the habit to examine, not the appliance.

A three-minute version for any category

  1. Open the transactions for the category and period.
  2. Sort by amount, descending. Note the top three and their share of the total.
  3. Group by merchant. Note any merchant with many payments.
  4. Sort by date. Note clusters.
  5. Write one sentence about what you will do differently.

In SpendixAI, the Report builder lets you filter by category and group by merchant, which does steps one and two quickly. The date check and the decision are yours.

SPENDIXAI JOURNAL

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

Explore your reports