Expense categories

Tracking online shopping sales, EMIs and returns without losing track

Track Flipkart and other online shopping, including sale-day buys, card EMI conversions and returns, and see what a shopping event really cost you.

Editorial illustration for Tracking online shopping sales, EMIs and returns without losing track

To track Flipkart spending, record what left your account for each order, not what the sale banner said. Sale-day purchases often come with card EMIs, split shipments and returns, which scatter across statements. Matching each order to its debit and its refund gives you the true cost of a shopping event.

What makes sale-day spending hard to track?

  • Several orders in one day, each with a separate debit.
  • Some paid in full, some converted to monthly instalments on a card.
  • Items cancelled or returned after the sale, with refunds weeks later.
  • Gift items bought for others that you do not think of as your spend.
  • Pay-on-delivery orders that never touch the card.

Before the sale: set a number

Decide a total for the event before you open the app. Write it down with a list of what you actually need. If you are tempted by an item not on the list, give it a day. Many sale items are bought because the price has a strike-through, not because the need was real.

Worked example: a sale week

Say, with made-up figures, you planned ₹12,000. You buy earphones for ₹1,799, a shirt for ₹899, a kitchen mixer for ₹3,499 on card EMI, a backpack for ₹1,299 and a gift for ₹1,150. The total value is 1,799 + 899 + 3,499 + 1,299 + 1,150 = ₹8,646. Then you return the shirt for a ₹899 refund, so the net is ₹7,747. The mixer's instalments show on the card over several months, so list them as a commitment, not as a cost spread across other categories.

OrderPaidAmount (₹)
EarphonesCard, full1,799
ShirtCard, full899
Kitchen mixerCard EMI3,499
BackpackUPI1,299
GiftUPI1,150
Shirt refundCredit-899
Net for the eventAll7,747

How should I record a card EMI?

Record the full purchase value once on the day you bought it, and record the instalments in your EMI list, not as new spending each month. Otherwise you count the mixer many times. Check your card statement or the lender's page for any interest or fee shown on the conversion, and note the amounts you actually see.

How do I follow a return?

  1. Note the return request date and the amount expected.
  2. Check the card or bank statement for the credit.
  3. If it has not arrived by the date promised on the seller's own page, raise it there with your order number.
  4. Mark the line closed in your notes once the credit appears.

What do I check at the end of the event?

Compare three numbers: what you planned, what you ordered, and what you kept after returns. In the example above that is ₹12,000, ₹8,646 and ₹7,747. Then look at the list of items again and mark each as needed, wanted or impulse. If the impulse column has more than one or two items, lower next event's number. Also check that every refund promised has reached the account, and note the ones still pending with their expected dates, so they are not forgotten once the sale is over.

Should I trust the savings shown on the page?

Treat the percentage off as the seller's own presentation, not as your saving. The only saving that counts is against what you would have paid for the same item on an ordinary day, and you can only judge that from your own earlier bills or a price you noted. If you did not need the item, nothing was saved, because the full price left your account.

Using SpendixAI

Upload the statement as PDF, CSV or Excel, review the rows, and let a rule file the seller under Shopping. Add pay-on-delivery orders by hand. The Possible duplicate charges report can help you spot the same amount debited twice within two days.

SPENDIXAI JOURNAL

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

Explore your reports