A merchant you pay in 8 of the last 12 weeks is part of your routine, whether you chose it or drifted into it. The review takes three questions: has the price crept up, is there a substitute, and is the visit needed this often.
How do you find the weekly merchants?
Take the last 12 weeks of transactions and count, for each merchant, the number of distinct weeks in which you paid at least once. Paying a vendor four times in one week counts as one week. A merchant at 8 or more of 12 is a weekly regular; 4 to 7 is regular but irregular; under 4 is occasional.
In Excel or Google Sheets, put the first day of your 12-week window in H1 and add a helper column D with the week number of each payment: =INT((A2-$H$1)/7)+1, where A is the date. Build a grid with merchants down column J and week numbers 1 to 12 across K1 to V1. In K2 enter =COUNTIFS($B$2:$B$1000,$J2,$D$2:$D$1000,K$1) and copy across and down. Then in W2, =COUNTIF(K2:V2,">0") gives the number of weeks with a payment.
A sample result
| Merchant | Weeks paid (of 12) | Payments | Total | Average |
|---|---|---|---|---|
| Vegetable vendor | 11 | 22 | ₹8,800 | ₹400 |
| Milk and bread shop | 12 | 34 | ₹5,100 | ₹150 |
| Tea stall | 9 | 27 | ₹2,700 | ₹100 |
| Food delivery app | 8 | 13 | ₹7,800 | ₹600 |
| Pharmacy | 3 | 3 | ₹1,500 | ₹500 |
The first four are weekly. The pharmacy is occasional and would not make the review list. These numbers are made up; yours will show a different picture.
Does the price drift upward?
Compare the average payment in the first four weeks with the last four. Say the vegetable vendor averaged ₹380 in weeks 1 to 4 and ₹440 in weeks 9 to 12. The gap is ₹60, which is 60 ÷ 380, or about 16%. That might be seasonal vegetable prices, a larger basket or a change in what you buy. Look at the individual payments before you decide it is price.
Is there a substitute?
This is not an instruction to switch. It is a prompt to check once. The same vegetables from a weekly market, a different stall on your route, or a monthly bulk purchase might cost less, or might not. A shop you pay twelve weeks out of twelve is often also the one you have never compared. Choose one comparison per quarter, so it does not become a chore.
Do you need the visit this often?
A food delivery app paid in 8 weeks out of 12 for ₹7,800 is 13 orders at ₹600. If you removed the three that happened on days when cooking was possible, you would save 3 × 600 = ₹1,800 over the quarter. That is a choice, not a verdict. The question is whether the visit is solving a real problem or filling a habit slot.
What to do with the list
- List merchants paid in 8 or more of 12 weeks.
- Beside each, write the first-four-week and last-four-week averages.
- Mark any with more than a small drift and look at the payments.
- Pick one substitute to compare this quarter.
- For each, write keep, review or cut, and a date.
Where an app helps
A spreadsheet grid works but needs rebuilding each quarter. If you track in SpendixAI, you can filter transactions by merchant and date range to see how many weeks a merchant appears in, and group by merchant in the Report builder. The judgement is still yours.
A fair review rhythm
Once a quarter is enough. Weekly spending changes slowly, and a review every month turns into a chore you quietly stop doing. Put the date in your calendar when you finish.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


