Festive sales make the cart look smaller than it is. A phone on no-cost EMI shows a monthly figure. A card offer promises instant discount. A cashback is "credited within 90 days". By the time the last instalment and the last refund arrive, the sale has spread across six months of statements and nobody remembers what the original purchase cost. If you want to know whether the sale actually saved money, the trick is to record the purchase once, at its real price, and connect everything that follows back to it.
Kharch Log already stores the bank and card SMS in your Google Sheet. This post shows how to label those rows so EMI, cashback, and returns tell one story instead of five.
Record the real price on the order day
When you place a big sale order, write a short note on that row in your Sheet: the item and the full price, for example "TV, ₹42,999, 6 month EMI". If the card was charged the full amount, the SMS row already shows it. If the bank converted it to EMI, you may see a large debit followed by a credit, or only the monthly instalments. Either way, the note on the order day is your anchor. Months later, it tells you what the purchase was and what it cost.
Use one category for sale purchases, such as Shopping or Electronics, and add the order name to the note. A clear note on one row beats a perfect category tree. When you look back, you can filter the note text and see every row connected to that order.
- Note the item and full price on the order day
- One category for sale purchases, with the order name in the note
- Do not wait for the EMI schedule to start labelling
No-cost EMI is still the full price
No-cost EMI means the interest is covered by a discount, not that the item is cheaper. You still pay the full price, just spread out. Banks often add a processing fee and GST on the interest component, and those show up as separate small debits. Label them with the same order name. They are part of the purchase cost and are easy to miss because they look like random bank charges.
Each monthly instalment is a repayment of something you already counted. If you recorded the full price on the order day, label the instalments as "EMI, TV" and keep them out of your spending total, the same way you would treat a card bill payment. If you prefer to count spending only as you pay, skip the order-day amount and count each instalment instead. Pick one method per purchase and write it in the note. Counting both doubles the TV.
Cashback and card offers
An instant discount simply lowers the amount debited, so the SMS row already shows the right figure. A cashback is different. It arrives later as a credit, sometimes weeks later, often as a vague SMS from the bank or the app. When it lands, label it with the order name and treat it as a reduction of that purchase, not as income. That way the TV row and its cashback sit together, and the true cost is the debit minus the credit.
Some cashback never arrives, or arrives as points or vouchers instead of money. That is worth knowing. If the note on the order day says "₹2,000 cashback expected", you can check in the following months whether it came. Unclaimed cashback is one of the easiest ways for a good deal to quietly become an average one.
- Instant discount: already reflected in the debit
- Cashback credit: label with the order name, treat it as a reduction
- Write the expected cashback in the order note and check it later
- Points and vouchers are not money until you use them
Returns and refunds in December
Sale returns are common, and refunds take time. A shirt returned in November may be refunded in December. The refund SMS is a credit, and if you label it as income your November looks expensive and December looks rich. Link the refund to the original order instead. Our post on refunds and reversals in the expense sheet covers the method in detail. If a refund is overdue, the order note tells you exactly what to chase.
Check the sale with one filter
At the end of the sale season, filter your Sheet by the sale category or by the order notes and add the debits, minus refunds and cashback. That is what the sale cost. Compare it with what you planned. Most people find one or two orders explain most of the total. That is useful for next year: you will know which kind of deal you actually use and which ones end up in a cupboard.
Questions people actually ask
The bank split my order into EMI. Do I see one SMS or many? It depends on the bank. Some send the full debit and then an EMI conversion message, others only send the monthly amounts. Kharch Log saves each SMS as it arrives. Use the order note to connect them, and pick one counting method per purchase.
Is the processing fee part of the purchase? Yes. Label it with the order name. It is a real cost of choosing EMI, even when the EMI is called no-cost.
What if a refund never arrives? The order note gives you the item, the date, and the amount to quote to the seller or the bank. Without the note, a missing refund is easy to forget.
Sales are fun when you know what they cost. Record the real price once, connect EMI, cashback, and refunds to that row, and check the total at the end of the season. Kharch Log stores the bank and card SMS for you, so the only work is a short note on the order day. Start with the Kharch Log features.