For a returned item or a cancelled order, record the refund as a negative expense in the same category, in the month the money comes back. That keeps your real spending on the item at zero. Record it as income only when the money is a reimbursement for a cost that was never really yours, or when you want your category totals to show what you paid before refunds.
What is the difference in the totals?
Say Shopping spending in a month is ₹9,500, including a pair of shoes that cost ₹3,200. You return the shoes and the full ₹3,200 refund arrives in the same month.
| Method | Shopping total | Income total | Net result |
|---|---|---|---|
| Negative expense in Shopping | ₹6,300 | unchanged | Spending reflects what you kept |
| Refund as income | ₹9,500 | up by ₹3,200 | Spending looks higher, income looks higher |
| No entry at all | ₹9,500 | unchanged | You never see the money came back |
Using the first method, 9,500 - 3,200 = ₹6,300. With the second, your income is overstated by money you merely got back, and your savings figure looks better than it is. With the third, you have a gap between your sheet and your bank.
When is a negative expense the right choice?
- A returned or cancelled purchase.
- A partial refund after a price adjustment.
- A failed payment that the bank reversed.
- Cashback credited for a purchase you made in that category.
The rule is that the refund undoes a purchase, so it belongs on the same line. Your SUMIFS formulas need no special handling, because a negative number simply reduces the total: =SUMIFS($D$2:$D$500,$C$2:$C$500,"Shopping").
When is income the better choice?
- A reimbursement from an employer for travel you paid for yourself, if you track it as a separate flow so you can match it against the claim.
- A tax refund or other money that is not tied to a purchase in your sheet.
- Money a friend returns for a bill you paid on their behalf, where you want the full bill still visible.
Tax refunds and employer claims involve rules that change, so confirm treatment with your CA. For your own tracking, the point is that the record matches what happened.
What if the refund comes in a later month?
Record it when the money arrives, with the original category. That month's category total can then come out lower than expected, or even negative. Suppose you bought a ₹12,000 appliance in March and returned it, with the refund arriving in April. March shows ₹12,000 in Household, and April shows -₹12,000. This is accurate cash-wise, but it can look odd. Add a Note such as Refund of March purchase so you remember why. If you prefer to keep each month clean, you can instead record the refund back in the purchase month, as long as you do it consistently and know your bank statement will show it later.
What about splitting a bill with a friend?
Say you pay a restaurant bill of ₹4,800 and a friend sends you ₹2,000 for their share. Record the dinner at ₹4,800 in Eating out, then record the ₹2,000 as a negative Eating out entry. Your real cost is 4,800 - 2,000 = ₹2,800. Leave the label as Reimbursed so the origin is visible.
Whichever approach you pick, use it for every refund. Switching between the two methods from month to month is what makes category totals impossible to compare.
What about importing statements?
A refund on a statement arrives as a credit row. When you import a statement into SpendixAI, you review each row before saving, so you can give the credit the same category as the purchase. After that, check how your reports show the category total before you rely on the netting. Whichever tool you use, decide your rule once, apply it consistently and write it down.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

