Expense categories

Reliance Smart spend report: build your own from bank statements

Want a spend report for Reliance Smart purchases? Pull the lines from your statements, total them by month and check against receipts. Here is the method.

Editorial illustration for Reliance Smart spend report: build your own from bank statements

To get a spend report for Reliance Smart, you do not need anything from the store: your own bank and card statements already hold every payment. Filter for the store's name, total by month, and match large amounts to receipts. If the store or its app offers a purchase history, check its own help page for how to view it.

Where do the payments show up?

Grocery stores are paid in different ways, so the same shop can appear in different forms: a card swipe with the merchant name, a UPI payment with a store name or a handle, or cash that appears nowhere. Pull statements for all the accounts and cards you use. Then search each for the store name. Spelling on statements is often shortened or capitalised oddly, so also try part of the name.

How do I total it by month in a spreadsheet?

Put your statement rows in a sheet: dates in column A, narration in column B, amount in column C. Say the store name appears somewhere in the narration. These formulas work in Excel and Google Sheets.

  • Total for October 2026: =SUMIFS($C$2:$C$500, $B$2:$B$500, "*SMART*", $A$2:$A$500, ">="&DATE(2026,10,1), $A$2:$A$500, "<"&DATE(2026,11,1)). The asterisks are wildcards that match any text around the word; type whatever part of the name actually appears on your statement.
  • Number of visits in the same month: =COUNTIFS($B$2:$B$500, "*SMART*", $A$2:$A$500, ">="&DATE(2026,10,1), $A$2:$A$500, "<"&DATE(2026,11,1)).
  • Average basket for the month: divide the first result by the second, for example =E2/E3 if those two cells hold them.
  • Dates must be real dates, not text. If the formula returns zero, check that column A is right-aligned.

Say October shows five visits of ₹1,240, ₹860, ₹2,310, ₹745 and ₹1,495. The total is ₹6,650 (1,240 + 860 + 2,310 + 745 + 1,495). Divided by five visits, the average basket is ₹1,330. Those numbers are made up, but the arithmetic is the method.

What if the card statement and the receipt disagree?

Match by date and amount, not by name. Keep the paper or digital receipt for larger shops. If a charge appears that you do not recognise, look at the date, the amount and the last few digits of your card, ask household members, and then contact your bank or the store through their official help pages. Check their own terms for how disputes are handled.

When a sheet stops being enough

Rebuilding the sheet every month gets tiresome. In SpendixAI you can upload the statement as PDF, CSV or Excel, review the rows, and let categorisation put the store under groceries or your own category, with rules you can edit. A report grouped by category or filtered by merchant then gives the monthly picture. You still review rows before saving, because layouts differ and an odd narration may need a manual fix.

Questions worth asking of the report

  • Is the monthly total stable, or does it jump around festivals?
  • Are small top-up trips costing more than one planned weekly trip?
  • Does the same item show as two charges on one day? A duplicate swipe is worth checking.

How do I split the spend into useful pieces?

A single monthly total hides a lot. Add a second look: group visits into weekday and weekend trips, or into small trips under ₹500 and larger ones above. Say October had two small trips of ₹320 and ₹410 and three large ones. The small trips total ₹730, and if they happened because the weekly shop was missing items, one better-planned list could replace them. That is the kind of question a report exists to raise, not to answer for you.

Next step

  1. Gather three months of statements from every account you use.
  2. Filter for the store and total by month.
  3. Match the biggest amounts to receipts.
  4. Set a monthly grocery figure from what you learned.
SPENDIXAI JOURNAL

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

Explore your reports