Expense categories

How to build a Swiggy spend report from your own statements

Build a Swiggy spend report from your bank or card statement: find the charges, total them by month, and see what food delivery really costs you.

Editorial illustration for How to build a Swiggy spend report from your own statements

To see what you spend on Swiggy, you do not need the company's help. Search your bank and card statements for the merchant name, list each charge with its date and amount, and add them up month by month. That gives you a spend report built from records you already own. we will not describe the company's screens, prices or policies, so for order details and refunds use its own account page and terms.

How do you find every charge?

Open each statement and search for the merchant name as it appears there. Descriptions are often shortened, in capitals, or carry extra codes. Try a short fragment of the name and note every variant you see, because the same company can appear under more than one description, especially if you pay by card on some days and UPI on others.

What should each row record?

  • Date as printed on the statement.
  • Amount in rupees.
  • Which account or card it went through.
  • The exact description text.
  • Whether it is a charge or a refund, with refunds shown as negative.

Worked example for one month

Say your statements show these food-delivery charges in the month: ₹349 on the 3rd, ₹512 on the 7th, ₹289 on the 12th, ₹640 on the 15th, ₹418 on the 21st, ₹375 on the 26th and one refund of ₹289 on the 14th. The charges add up to 349 + 512 + 289 + 640 + 418 + 375 = ₹2,583. Take off the refund and the month's net is 2,583 - 289 = ₹2,294. With six orders that is about ₹382 per order (2,294 divided by 6, rounded), and the figure is only a made-up example, not a typical one.

DateAmountType
3₹349Charge
7₹512Charge
12₹289Charge
14-₹289Refund
15₹640Charge
21₹418Charge
26₹375Charge

How do you do this in a spreadsheet?

Put the statement rows in a sheet with the date in column A, the description in column B and the amount in column C. Then =SUMIFS($C$2:$C$500, $B$2:$B$500, "*swiggy*") totals every row whose description contains that word. The asterisks are wildcards and the match is not case-sensitive. To limit it to one month, add two more conditions on the date column, such as ">="&$E$1 and "<"&$F$1 where E1 and F1 hold the first day of the month and the first day of the next month.

When does a sheet stop being enough?

A sheet works for one merchant. When you want the same view for ten merchants across several accounts, categorising every row by hand gets tiring. SpendixAI imports statements from PDF, CSV or Excel, lets you review rows, applies your own rules first and then your history, and lets you add a merchant alias so differently worded descriptions land in one place. You can then use a food-delivery category in the reports. Rules are yours, and AI can be turned off if you prefer.

Do UPI payments and card payments need separate handling?

Yes, in the sense that they live in different statements. A charge made through a UPI app appears in the bank account it debited, while a card charge appears on the card statement, and some orders are paid partly from a wallet balance. If you only search one account, your total will be low. Make a short list of every account and card you use for food orders and search each one for the same month. Then compare the number of orders with the order count you remember. A mismatch usually means one account was missed.

What should you do with the number?

  1. Compare this month with the last two, not with a stranger's budget.
  2. Decide a monthly limit you are comfortable with and write it down.
  3. Check the report again after one month to see whether the limit held.
SPENDIXAI JOURNAL

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

Explore your reports