Searching your bank or card statement for the merchant name shows what you spent on Myntra: list each charge with its date, subtract refunds that came back, and add up by month. Your statement is the record of what left your account, and the shopping site's order page is where you match each charge to an order.
Step by step with your statement
- Download the statement for the period from your bank or card issuer.
- Search for the merchant name and for any variations that appear in your own statement.
- Copy each matching line into a sheet: date, description, amount.
- Add refunds as negative amounts in the same sheet.
- Sum by month.
We cannot describe another company's menus or policies, so for order details, returns and refund timelines, use the seller's own account and help pages and read their terms.
Worked example with made-up numbers
| Date | Line on statement | Amount (₹) |
|---|---|---|
| 04 Oct | Order payment | 2,499 |
| 04 Oct | Order payment | 1,199 |
| 12 Oct | Refund credit | -1,199 |
| 19 Oct | Order payment | 899 |
| 07 Nov | Order payment | 3,150 |
October charges are 2,499 + 1,199 + 899 = ₹4,597. The refund of ₹1,199 brings the net to 4,597 - 1,199 = ₹3,398. November so far is ₹3,150. Across both months, net spend is 3,398 + 3,150 = ₹6,548. If you only counted the charges and ignored refunds, you would overstate October by ₹1,199.
How do I match a refund to the right order?
Refunds often arrive days later, and sometimes through another route than the original payment. Match by amount first, then by date, and keep the order number from the seller's own page next to the line in your sheet. If a refund seems missing, collect the order number, the amount, the date and the statement line, and raise it through the seller's own help route.
Formulas to total it quickly
- Total of all charges and refunds in C2:C50: =SUM(C2:C50)
- Charges only: =SUMIF(C2:C50,">0")
- Refunds only: =SUMIF(C2:C50,"<0")
- One month, with dates in A2:A50: =SUMIFS(C2:C50,A2:A50,">="&DATE(2026,10,1),A2:A50,"<="&DATE(2026,10,31))
When a sheet stops being enough
If you shop across several sites, doing this by hand every month gets tedious. In SpendixAI you upload statements as PDF, CSV or Excel, review rows, put online shopping into a category you name, and use the Report builder to filter and group, with a CSV download. Check that each shop's name is matched correctly, since descriptions on statements vary.
Look at categories as well as totals. Mark each line as clothing, footwear, gifts or other, and total each group. Say a month's net spend of ₹6,548 splits into ₹3,398 on clothing and ₹3,150 on gifts for a wedding; the gift portion was a one-off, so a regular month is closer to ₹3,398. Splitting out one-offs gives you a more honest picture of your usual pattern than a single total.
Watch for charges that arrive through a different route, such as a wallet top-up, a gift card, or a pay-later payment, because they may not carry the merchant name you searched. Search the statement by amount as well as by name when a total looks too low.
Set a rule for yourself about how often to run this report. Once a month, on the day your statement arrives, is enough for most people, and it takes about ten minutes after the first time. Write the net figure in one place, such as a notebook or a Notes page, next to the month, and after three months you will see whether online shopping is steady or spikes around sales and festivals. A pattern is more useful than any single total.
Closing checklist
- Statement downloaded, merchant lines copied.
- Refunds netted off.
- Order numbers noted next to each line.
- Seller's own terms checked for anything about returns.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
