To see where your grocery money really goes, group a month of grocery transactions by the type of shop, add up each group, and divide by the month's total to get shares. Then divide each group's total by the number of payments to get the average basket. The result tells you whether your grocery budget is mostly weekly stock-ups, frequent top-ups or small convenience orders.
How do you sort grocery payments into channels?
Start with the grocery transactions for one month, taken from your statements or tracker. Read the merchant name on each one and put it into one of three groups. The names below are described generally, so use whatever appears on your own statement.
- Kirana: payments by UPI to a local shop or a person's name, usually with a short or unclear description.
- Supermarket: a named store or chain, usually fewer and larger payments.
- Quick-commerce: a delivery app's name, usually many small payments with fees included.
Cash purchases at the kirana or the vegetable seller will not appear on a statement. Add them by hand for the month, even as one rounded entry per week, or your kirana share will look smaller than it is.
What does a worked example look like?
Say a household's grocery total for one month is ₹24,000, made up of these hypothetical figures.
| Channel | Payments | Total | Share of grocery spend | Average basket |
|---|---|---|---|---|
| Kirana | 16 | ₹9,600 | 40% | ₹600 |
| Supermarket | 4 | ₹8,400 | 35% | ₹2,100 |
| Quick-commerce | 12 | ₹6,000 | 25% | ₹500 |
| All grocery | 32 | ₹24,000 | 100% | ₹750 |
The arithmetic: 9,600 plus 8,400 plus 6,000 is 24,000. Kirana is 9,600 divided by 24,000, which is 40%. Supermarket is 35% and quick-commerce 25%. Average basket is each total divided by its number of payments: 9,600 divided by 16 is ₹600, 8,400 divided by 4 is ₹2,100, 6,000 divided by 12 is ₹500, and 24,000 divided by 32 is ₹750 overall.
What does the mix tell you?
Look at the number of payments as much as the rupees. In the example, quick-commerce is a quarter of the spend but 12 of the 32 payments, which means most of the household's top-ups happen in small bursts. Small bursts are where unplanned items creep in. The supermarket trips are fewer and larger, which usually means a planned list.
The kirana average of ₹600 sits between the two. That might be daily milk, vegetables and staples bought as needed. None of these channels is better or worse in itself. What matters is whether the pattern is the one you intended.
Should you budget by channel or by category?
Most people do better with one grocery budget and a rough split between channels as a guide, not three separate limits. Three strict limits create arguments with yourself in the last week of the month, when one channel is exhausted and another is not.
A simple method is to set the monthly grocery budget from the average of three months, then note the channel shares. If the quick-commerce share climbs for three months in a row, that is your cue to look at what is being ordered, not to panic.
What should you check before trusting the shares?
- Is every grocery purchase in the grocery category, including the vegetable seller and the milk vendor?
- Are cash purchases added?
- Are non-grocery items from the same quick-commerce app, such as snacks, household goods or gifts, sitting in the grocery group? If an order is a mix, decide on a rule and stick to it.
- Are festival months being compared with ordinary ones? A month with a big Diwali shop will not look like a typical month.
Where can an expense tracker help with this?
In SpendixAI, you can add several cash expenses at once and use merchant aliases, so the same shop appearing under different UPI names rolls up to one merchant. You can then filter the grocery category by merchant in the report builder and download the result as a CSV to compute shares in a sheet.
Next steps
- Take last month's grocery category and tag each payment with a channel.
- Compute totals, shares and average baskets as in the table.
- Repeat for the previous two months and compare.
- Set one grocery budget and note what share each channel normally takes.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


