Cards and UPI

Food delivery and online shopping spend from card statements

Find your food delivery and online shopping spend on a card statement by searching merchant text. Includes sheet formulas, refunds and a two-app example.

Editorial illustration for Food delivery and online shopping spend from card statements

To total your food delivery and online shopping spend, search the card statement for the merchant text each app prints, add up the matching debits, and subtract any refunds. A search term such as the app's name in the narration is usually enough, but bank narrations vary, so check a few lines on your own statement before you trust the total. Below is a worked month and a sheet formula that does the sum.

How do I find these lines on a statement?

Open the statement and scan for the names of your regular delivery apps and shopping sites. Narrations are often shortened, in capitals, or followed by a city or reference number, so search for the distinctive part only. Do three things before you start adding.

  • Read five or six lines for each merchant so you know what text to search for
  • Note variants: the same merchant can appear under two spellings or a payment-gateway name
  • Look for credits with the same merchant text, which are usually refunds or cancelled orders

Your own statement is the authority on what the text looks like. Do not assume another person's narrations match yours.

What does a month look like in numbers?

Say these are the matching lines from one cycle, all invented for the example.

MerchantOrdersAmountsTotal
Delivery app A4₹420, ₹380, ₹560, ₹640₹2,000
Delivery app B3₹310, ₹450, ₹540₹1,300
Marketplace X3₹1,899, ₹749, ₹2,350₹4,998
Marketplace Y2₹1,250, ₹899₹2,149
Refund from Marketplace X1₹749 credited-₹749

Food delivery is 2,000 plus 1,300, which is ₹3,300. Online shopping is 4,998 plus 2,149 minus the 749 refund, so ₹6,398 net. Together that is ₹9,698. If you ignore the refund you would report ₹10,447 and overstate shopping by the very order you sent back.

Can a spreadsheet add this up for me?

Yes. Put the narration in column B and the debit amount in column C, rows 2 to 500, in Excel or Google Sheets. The wildcard star matches any text around your search word.

  • =SUMIF($B$2:$B$500, "*delivery app a*", $C$2:$C$500) adds every amount whose narration contains that text; SUMIF ignores upper or lower case
  • =SUMIF($B$2:$B$500, "*delivery app a*", $C$2:$C$500) + SUMIF($B$2:$B$500, "*delivery app b*", $C$2:$C$500) gives both apps together
  • =SUMIFS($C$2:$C$500, $B$2:$B$500, "*marketplace x*", $A$2:$A$500, ">="&$F$1, $A$2:$A$500, "<="&$G$1) limits it to dates between the cycle start in F1 and end in G1

Keep refunds in a separate column or as negative amounts so the totals net off correctly. If a merchant text is too short, it may match unrelated lines, so scan the matching rows once.

When does a sheet stop being enough?

A sheet works while you do the search yourself each month. It gets tiring when the lines multiply, when you also want a category for them, or when you have two cards. SpendixAI lets you upload a card statement as PDF, CSV or Excel, review the rows, and set your own rules so a merchant is filed in the same category every time, with merchant aliases if one shop shows up under different names. You can then filter and group in the Report builder or download a CSV. It does not read your SMS or connect to your bank, so the statement upload is the route in.

What should I do with the total?

  1. Compare delivery and shopping against the same two lines last month
  2. Count orders as well as rupees; ten small orders at ₹330 can matter as much as one big one
  3. Note any month that had a sale or festival, since it will not repeat every month
  4. Decide your own ceiling for each line and write it down
  5. Revisit it after two months, not two days

The aim is not to scold yourself but to know the figure. Most people are surprised only because they have never added it up. Once you see the monthly number, you can decide on your own terms whether it is the amount you meant to spend.

SPENDIXAI JOURNAL

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

Explore your reports