To find out how much you spend on Swiggy, Zomato and Amazon each month, search your statements for each name, add up the matching rows and net off any refunds. Use every account and card you pay from, because the same app can appear under different payment methods. Then compare the total with your monthly spending.
Where will the payments show up?
- Card statements, where the merchant name usually appears in the description.
- Bank statements, for UPI and net transfers; the narration can show a payment gateway or the app name, so check your own statement.
- Wallet or app balance payments, which may not appear on a bank statement at all.
- Cash on delivery, which does not appear until you enter it by hand.
Statement descriptions are not standardised. If a search for the app name finds nothing, look at a recent order you remember and see how that line reads, then search for that text.
How do you add them up in a sheet?
Export or copy statement rows into a sheet, with the description in column B and the amount in column C, rows 2 to 500. The wildcard form of SUMIFS finds any description that contains the name.
- Swiggy: =SUMIFS($C$2:$C$500, $B$2:$B$500, "*swiggy*")
- Zomato: =SUMIFS($C$2:$C$500, $B$2:$B$500, "*zomato*")
- Amazon: =SUMIFS($C$2:$C$500, $B$2:$B$500, "*amazon*")
- Number of Swiggy orders: =COUNTIFS($B$2:$B$500, "*swiggy*")
SUMIFS matching is not case-sensitive. Keep debits as positive numbers and refunds as negative, or total refunds in a separate formula, so you do not double count. Amazon descriptions can also catch unrelated lines that include the same text, so scan the matches once.
What does a month look like?
Say the three sums come to ₹4,260 for Swiggy, ₹2,890 for Zomato and ₹9,135 for Amazon. Together that is 4,260 + 2,890 + 9,135 = ₹16,285. If total spending that month was ₹70,000, these three took 16,285 ÷ 70,000 = 23.3 per cent. If a ₹1,200 Amazon refund also arrived, the net Amazon figure is 9,135 − 1,200 = ₹7,935, and the three-app total is ₹15,085.
| App | Gross | Refunds | Net |
|---|---|---|---|
| Swiggy | ₹4,260 | ₹0 | ₹4,260 |
| Zomato | ₹2,890 | ₹0 | ₹2,890 |
| Amazon | ₹9,135 | ₹1,200 | ₹7,935 |
| Total | ₹16,285 | ₹1,200 | ₹15,085 |
What does a total like that tell you?
Food delivery and online shopping have different meanings. Splitting your result into delivery and shopping usually shows more than a combined figure. A useful second look is the count of orders: ₹4,260 across, say, 14 orders is about ₹304 an order, which is a clearer prompt to cook or order differently than a bare monthly total.
Can this be automatic?
If you do this every month, a tracker does it for you. SpendixAI takes your statements as PDF, CSV or Excel, normalises merchant names so the same shop looks the same, and lets you add merchant aliases when a description is messy. After you correct a category once, it becomes history for next time. Use the report builder to filter by merchant and group by month. You still need to add cash orders yourself, and you review each imported row before saving.
What about shared accounts and gifts?
If several people order on one account, the total is a household figure, not a personal one. If you ordered something as a gift, you may want to tag it separately so it does not distort your own habits. Do the same for work lunches you are reimbursed for: note the reimbursement as a credit so your net spending is true. Small bookkeeping habits like these change the story the total tells.
What to do with the number
- Set a monthly limit for food delivery and another for shopping.
- Check the limit weekly, not at month end.
- Note the festival months and sale periods separately, since they are not typical.
- Look at the smallest orders; those often add up.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
