Filter your transactions by that merchant and the date range, group the result by account, and read the totals: that answers how much you spent on one thing, such as a merchant over six months. A CSV download lets you keep the answer or check it in a spreadsheet. The walkthrough below uses made-up numbers so you can see each step.
What question are we answering?
Say you suspect food delivery has crept up. The question is: how much did I spend on one food delivery merchant in the last six months, and from which accounts? Notice the three parts. A merchant, a time window and a split by account. Every filter question has the same three parts: what, when, and how to slice it.
Step by step in the Report builder
SpendixAI has a library of 25 ready-made reports grouped by question, plus a Report builder where you filter and group yourself. Pro includes custom reports and advanced filters. The exact buttons depend on the version you see, so follow the idea rather than the labels:
- Set the date range to the last six months, for example 1 May to 31 October.
- Filter by the merchant. Use the cleaned merchant name rather than the raw statement text.
- Group by account. If you can also group by month, do that too and look for a rising line.
- Run the report and read the totals.
- Download the CSV if you want to keep the result or open it in a sheet.
What do the results look like?
Here is a hypothetical result for six months.
| Account | Orders | Total spent |
|---|---|---|
| HDFC Credit 7733 | 14 | ₹6,230 |
| SBI Salary 4821 (UPI) | 9 | ₹3,410 |
| All accounts | 23 | ₹9,640 |
Check the arithmetic: 14 + 9 = 23 orders and 6,230 + 3,410 = ₹9,640. Divide by six months and you get about ₹1,607 a month, since 9,640 divided by 6 is 1,606.67. Divide by 23 orders and the average order is about ₹419. Without the split by account you would probably have remembered only the card, and underestimated by more than a third.
Why are my totals lower than I expected?
A few common reasons are worth ruling out before you trust the number.
- The merchant appears under more than one name, for example a short UPI label and a longer card label. Add a merchant alias so they merge, then rerun.
- A statement is missing. Open the import history and check that every month, for every account, shows a successful status.
- Cash orders are not on any statement. Add them by hand if they matter.
- Refunds are netted against the spend. Look at them separately if you want the gross figure.
Can I check the number another way?
Yes, and you should do it at least once. Download the CSV, open it in a spreadsheet and use a filter on the merchant column. If the sum in the sheet matches the report, you can trust the report for similar questions. For a quick spreadsheet check with a date window, the formula =SUMIFS($C$2:$C$500,$B$2:$B$500,"Merchant name",$A$2:$A$500,">="&DATE(2026,5,1),$A$2:$A$500,"<="&DATE(2026,10,31)) adds the amounts in C for one merchant name in column B between two dates in column A.
What to do with the answer
The point of the question is a decision, not a number. If delivery spending is ₹1,607 a month and you would prefer it were ₹1,000, you could set a monthly budget, which is a Pro feature, or simply put the merchant on a list of things to look at each month. If the figure is lower than you feared, that is useful too.
Other questions the same method answers
- How much did I spend on petrol this year, split by card and by UPI?
- What did one family member's medical visits cost across all accounts?
- How much went to one subscription since I signed up?
- What did I spend in one category in each of the last twelve months?
Each one is a merchant or category, a time window and a split. Once the first report works, the rest take a minute.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


