Expense categories

DMart spend report: see what you spend there by month and category

Build a DMart spend report from your bank and card statements, in a sheet or an expense app, with a worked monthly example and tips for messy merchant names.

Editorial illustration for DMart spend report: see what you spend there by month and category

A DMart spend report is a list of every payment to that store across your statements, added up by month. You can build one in a spreadsheet by filtering the narration column for the store name, or in an expense app by filtering on the merchant. The result tells you how much of your household budget goes to one shop, and whether it is growing.

This article does not describe the store's prices, offers or policies. It covers how to read your own statements, which is the only source of truth for what you spent.

Why is a store's name hard to search for?

Statements print merchant names in many forms: the full name, a shortened version, a terminal code, a city, or a payment gateway name. UPI payments might show a different payee label than a card swipe. So search for several fragments rather than one spelling, and check a handful of lines by eye.

  • Try the main word, a short version and the first few letters
  • Search both debit card and UPI lines
  • Look at the amounts, since grocery bills have a recognisable pattern
  • Include refunds, which show as credits

How do I do it in Google Sheets or Excel?

Paste your transactions with the date in A, narration in B and debit amount in C, rows 2 to 500. To add up all lines whose narration contains the store name in the cell E1, use:

=SUMIF($B$2:$B$500, "*"&$E$1&"*", $C$2:$C$500)

The asterisks are wildcards that match any text before and after the name. For one month, add dates in a second condition with SUMIFS:

=SUMIFS($C$2:$C$500, $B$2:$B$500, "*"&$E$1&"*", $A$2:$A$500, ">="&$G$1, $A$2:$A$500, "<="&EOMONTH($G$1,0))

Here G1 holds the first day of the month. Both formulas are not case sensitive, which helps.

A worked monthly example

MonthVisitsTotal spentAverage per visit
August4₹6,400₹1,600
September5₹8,250₹1,650
October6₹10,800₹1,800

The three months add up to ₹25,450 across 15 visits. That works out to ₹1,697 per visit on average, and the monthly total climbed from ₹6,400 to ₹10,800. Is the extra from more visits or bigger baskets? Visits rose from 4 to 6 and the average per visit rose from ₹1,600 to ₹1,800, so both.

What about doing it in an expense app?

In SpendixAI, import your statements, then add a merchant alias so different spellings of the same store roll into one name. The Report builder lets you filter by that merchant and group by month, and you can download the result as CSV. Categorisation uses your own rules first, so you can set groceries for that merchant once and later imports follow it. Check each imported row before saving, because narration text varies.

How do I handle refunds, wallets and gift cards?

A returned item shows as a credit, so subtract it from the month. Money loaded to a wallet or a card for the store is spending at the time of loading, not when you use it, so decide one rule and apply it every month. Say you load ₹2,000 into a wallet in October and spend ₹1,500 from it in November. Count the ₹2,000 in October and nothing in November, or your totals will double count.

What to do with the report

  • Set a monthly grocery budget and compare against this report
  • Split bulk buying from daily top-ups
  • Look for small frequent visits that add up more than one big trip
  • Keep receipts for big household items, in case of returns

Remember to include online orders and gift cards if you pay through other routes, since they will not match the same narration text.

SPENDIXAI JOURNAL

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

Explore your reports