Budgeting

Refunds and returns in category totals: net or gross?

How are refunds shown in an expense report? See how a ₹4,000 return reduces a shopping total, why purchase and refund months differ, and when to look at gross.

Editorial illustration for Refunds and returns in category totals: net or gross?

A refund usually reduces the category total in the month it lands, not the month you bought the item. That is the net view. The gross view ignores refunds and shows only what you paid. Both are useful, but they answer different questions, so know which one your report is showing before you trust a total.

A ₹4,000 return, shown three ways

Say you spent ₹12,000 on shopping in October, including a ₹4,000 pair of shoes you later returned. In November you spent ₹3,000 on other shopping, and the ₹4,000 refund arrived on the 12th.

ViewOctoberNovemberTwo-month total
Gross (refund ignored)₹12,000₹3,000₹15,000
Net in the month the refund lands₹12,000−₹1,000₹11,000
Net matched to the purchase month₹8,000₹3,000₹11,000

All three agree that you kept ₹11,000 worth of shopping over two months only after refunds. The difference is where the ₹4,000 sits. November's −₹1,000 is correct arithmetic, since 3,000 − 4,000, but it looks odd until you remember the refund belongs to an October purchase.

Why do the purchase month and the refund month differ?

Returns take time: the item is collected, checked, and money is returned some days or weeks later, sometimes to a different account or method from the one you paid with. If the purchase was on a card in October and the credit arrives on the card statement in November, each month's report sees only half the story.

Which view should you use?

  • For a monthly budget check, the matched view tells you what shopping really cost in October. It needs you to link the refund to its purchase.
  • For cash flow and for matching your bank balance, use the month-of-refund view, since the money really did come back in November.
  • For understanding buying habits, such as how often you order and return, look at gross as well. Heavy returners will see a big gap between gross and net.

Where do refunds go wrong in reports?

  1. The refund is recorded as income. Spending then looks higher and income higher by the same amount, which distorts your savings rate.
  2. The refund goes into a different category from the original purchase, so shopping stays at ₹12,000 and a mystery credit sits elsewhere.
  3. Only part is returned. If ₹1,500 of ₹4,000 comes back, record ₹1,500, not ₹4,000.
  4. The refund goes to a wallet or store credit. Nothing reaches your bank account, so nothing appears on a statement, yet the purchase is still partly cancelled.

A tidy habit for returns

Note the return date and the order reference in the transaction notes, and attach the return slip or confirmation if your tool lets you. SpendixAI keeps receipts together with their transactions, which suits this. When the credit appears on the statement, assign it to the same category as the original purchase and check that the two-month total matches what you actually kept.

What about exchanges and cashback?

An exchange is a refund and a new purchase together. If you return the ₹4,000 shoes and buy a ₹4,500 pair, the extra spend is ₹500, though the statement may show a ₹4,500 debit and a ₹4,000 credit. Cashback credited later is best treated as a small refund of the original purchase, because it lowers what that purchase really cost you.

When to look at gross

Use gross when you want to know how much you ordered, not how much you kept. A month where gross is ₹20,000 and net is ₹11,000 means you returned nearly half of what you ordered, which may point to buying decisions worth slowing down.

SPENDIXAI JOURNAL

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

Explore your reports