If a shop adds an extra charge for paying by card, record the item at its real price and the surcharge as a separate line, so the two figures never blur together. Say a ₹10,000 purchase carries ₹150 extra: your card statement will show ₹10,150, but your own records should show ₹10,000 for the item and ₹150 for the surcharge. That keeps price comparisons honest and shows what card payments cost you over a year.
Why not just record ₹10,150 as the price?
Because the surcharge is not part of the item. If you later compare what you paid for the same item at another shop, or check whether a sale really saved money, a price inflated by a payment fee gives a wrong answer. The surcharge is the price of a payment method, not of the product.
There is a second reason. If you add up surcharges over a year, you learn what card payments at that kind of shop actually cost, which is useful when you choose between card, UPI and cash for your next big purchase.
What does the made-up example look like?
Say you buy a pressure cooker for ₹10,000 and, at the counter, the shop says paying by card adds ₹150. The surcharge works out to ₹150 ÷ ₹10,000 = 1.5% of the bill. You pay by card, and the statement debit is ₹10,150.
| Line | Amount | Category | Note |
|---|---|---|---|
| Pressure cooker | ₹10,000 | Home and kitchen | Bill number saved |
| Card surcharge | ₹150 | Fees and charges | Shop added on card payment |
| Statement debit | ₹10,150 | Check only | Equals the two lines above |
The third row is a check, not a third expense. ₹10,000 + ₹150 = ₹10,150, and if the two lines do not add up to the debit, something is missing.
How do you record it in a sheet?
- Add a row for the item, with its category and the price printed on the bill.
- Add a second row for the surcharge, with a category such as Fees and charges and a note that names the shop.
- Give both rows the same date and the same payment-method label, for example Credit card.
- Use =SUMIFS($C$2:$C$500, $B$2:$B$500, "Fees and charges") to total all such fees over a period.
If the shop gives a separate line on the bill for the surcharge, copy the figure from the bill. If the extra appears only on the card machine slip, keep the slip or photograph it.
How does this work with an imported statement?
When a statement is imported into a tracker, the card shows one debit of ₹10,150. In SpendixAI, you can review the row before saving it, and add a note such as includes ₹150 surcharge, so the explanation stays with the transaction. If you want the split visible in reports, keep a separate list in your sheet for surcharges, or enter the fee as its own hand-added expense and take care not to double-count the debit. Pick one method and stay with it.
Should you pay by card at all in that case?
Compare the extra ₹150 with what the card gives you back. If the card earns reward points or cashback on the purchase, check the card's own terms to see what that is worth in rupees. If the reward is smaller than ₹150, another payment method saves money. If you are using the card for its purchase protection or the chance to pay later, that has a value too, but be honest about it.
A habit to keep
- Keep the bill and the machine slip together.
- Record the item price and the fee as separate lines.
- Check that the lines add up to the statement debit.
- Review all fee lines once a quarter.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

